Question

Please show your work with the formulas/calculations written out (for example; without using excel tables). 9....

Please show your work with the formulas/calculations written out (for example; without using excel tables).

9. If you paid $750 for an investment 25 years ago that is now worth $2000, what was your rate of return?

10. If you save $100 per month, what annual rate of interest must you earn in order to accumulate $10,000 after 10 years?

11. If you borrow $250,000 for 10 years and your monthly payment is $1000, what rate of interest are you paying?

12. If you bought a bond five years ago for $900 which paid annual interest of $250 and sold it today for $950, what was your rate of return?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Using financial calculator
1.
PV=-750
N=25
PMT=0
FV=2000
CPT I/Y=4.001%

2.
N=10*12
PMT=-100
FV=10000
PV=0
CPT I/Y=-0.316%
Annual rate=-0.316%*12=-3.792%

3.
N=10*12
PMT=-1000
PV=250000
FV=0
CPT I/Y=-1.090%
Annual rate=-1.090%*12=-13.077%

4.
N=5
PMT=250
FV=950
PV=-900
CPT I/Y=28.411%

Add a comment
Know the answer?
Add Answer to:
Please show your work with the formulas/calculations written out (for example; without using excel tables). 9....
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Please show your work with the formulas written out. Please answer as if you can only...

    Please show your work with the formulas written out. Please answer as if you can only use a four function calculator (because that is how I have to learn it). Do not just put down the calculator keystrokes I need to see every step and number to learn how to do it. 9. If you paid $750 for an investment 25 years ago that is now worth $2000, what was your rate of return? 10. If you save $100 per...

  • Please show your work with the formulas written out. Please answer as if you can only use a four function calculator (be...

    Please show your work with the formulas written out. Please answer as if you can only use a four function calculator (because that is how I have to learn it). Do not just put down the calculator keystrokes I need to see every step and number to learn how to do it. 13. If you want to accumulate $250 after 30 years and your bank pays 2%, how much will you have to deposit monthly? 14. If you borrow $250...

  • without using financial formulas just basic math formulas are eligible. Please provide all formula used and...

    without using financial formulas just basic math formulas are eligible. Please provide all formula used and variables with clear steps. Please use Goal Seek Tool in excel. EXCEL Question 1 (Home Loan) (3marks] Construct an EXCEL spreadsheet, which projects cash flows of a home loan with yearly loan repayments, ie. the loan is paid by payments at the end of each year for n years, until the loan is completely paid off. Please use your spreadsheet to answer the following...

  • Please show your work with the formulas written out. Please answer as if you can not...

    Please show your work with the formulas written out. Please answer as if you can not use a calculator, or only use a four function calculator (because that is how I have to learn it). Do not just put down the calculator keystrokes I need to see every step and number to learn how to do it. 17. If you borrow $25000 and repay $800 monthly at a rate of 6%, how many months will it take to repay the...

  • Please show formulas and work. No excel formulas please. Problem 1 You take out an amortized...

    Please show formulas and work. No excel formulas please. Problem 1 You take out an amortized loan for $10,000. The loan is to be paid in equal installments at the end of each of the next 5 years. The interest rate is 8%. Construct an amortization schedule. Problem 2: A. Calculate the PV of $100 due in 5 years compounded daily at 12%. B. Calculate the FV of $1000 due in 3 years at 6% compounded quarterly. C. Calculate the...

  • Bond and Stock Value and Evaluation. PLEASE SHOW ALL FORMULAS/EQUATIONS AND SHOW ALL OF YOUR WORK. Do not use Excel....

    Bond and Stock Value and Evaluation. PLEASE SHOW ALL FORMULAS/EQUATIONS AND SHOW ALL OF YOUR WORK. Do not use Excel. 4. The company yesterday paid their annual dividend of $2.00 and the expected price in 2 years is $100. The dividend payment is expected to grow at 7 %. i) What is the stock's required return? ii) what is the price today? Use annual compounding

  • Please post with mathematical formulas please, no an excel sheet 2. The lender of a loan...

    Please post with mathematical formulas please, no an excel sheet 2. The lender of a loan of 175000 receives interest payments at the end of each year for 25 years at an effective annual interest rate of i, and in addi tion, will receive a lump-sum repayment of the principal along with the 25th interest payment. The borrower will pay the annual interest to the lender and accumulate the 175000 by making 25 level annual deposits at the end of...

  • Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs...

    Solve the following questions using a financial calculator. Submit your answers in Excel. Show calculator inputs (ie. N, PV, etc.) to get partial credit. 1. How much would you pay for the right to receive $12,000 at the end of 15 years if you can earn a 15% return on a real estate investment with similar risk? 2. What constant amount invested at the end of each year at a 10% annual interest rate will be worth $20,000 at the...

  • Can the work be shown in excel using formulas? You deposit $10,000 in an account that...

    Can the work be shown in excel using formulas? You deposit $10,000 in an account that earns 5.5% compounded continuously and your friend deposits $10,000 in an account that earns 5.5% annually. a. How much more will you have in the account in 10 years? b. How much more interest did you earn in the 10 years?

  • PLEASE SHOW EXCEL FORMULAS USED TO SOLVE Suppose a stock had an initial price of $79...

    PLEASE SHOW EXCEL FORMULAS USED TO SOLVE Suppose a stock had an initial price of $79 per share, paid a dividend of $1.45 per share during the year, and had an ending share price of $88. What was the dividend yield? The capital gains yield? nitial price Dividend paid Ending share prices Complete the following analysis. Do not hard code values in your calculations. Dividend yield Capital gains yield Suppose a stock had an initial price of $79 per share,...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT