Question

20 Time Value of Money Exercise: Question 1: Assume you deposit $700 every three months at a 6 percent annual rate, compounded quarterly. How much will you have at the end of 20 years? Question 2 You borrow a five-year $13,000 loan with monthly payments of $250. What is the annual percentage rate (APR) on the loan? Question 3: How much would you have to invest today to receive $50,000 in 10 years at 9.5 percent per year? Question 4: Ms. Nelson will receive $12,000 a year for the next 20 years from her retirement fund. If a 6 percent interest rate is applied, what is the current value of her retirement fund? Question 5 Assume you deposit $2,000 every six months at 10 percent compounded semi-annually. How much will you have at the end of 10 years? Question 6: If you need $40,000 for your son's education in 10 years, how much must you deposit at the beginning of each year in the bank earning 6 percent in order to have the college money ready? Question 7: If you have $30,000 in a savings account earning 10 percent, how large an annuity can you draw out each year if you want nothing left at the end of 8 years? Question 8: You borrow $6,000 at a 10 percent annual rate to be repaid in 3 equal payments at the end of each of the next 3 years. How large is the total interest payment over the three years? Question 9: I invested $600.000 in a cattle ranch and I sold that ranch for $1.800.000 ten years later. What was my annual percentage rate return? Question 10: How much can I borrow for the purchase of my first home if I can afford to make monthly payments of $1,000, and the annual interest rate is 4.8 percent on a 30-year mortgage?

I need help on question 9.

Answer 1

Answer is 11.61%

Formula for Excel is: =RATE(B3,,-B1,B2)

ДА 1 PV 2 EV 3 NPER 4 Rate $600,000 $1,800,000 10 11.61% 5

B 1 PV 2 FV 3 NPER 4 Rate 5 600000 1800000 10 =RATE(B3,,-B1,B2)