Solve through excel per year. How much will you have in 10 years? 2. Bernard needs $140,000

Solve through excel
 

Transcribed Image Text:

per year. How much will you have in 10 years? 2. Bernard needs $140,000 in 9 years for his daughter's education. If he can earn 7.5% per year, how much does he need to invest today? 3. You have $38,000 to invest and you need $70,000 for a down payment and closing costs on a house. If you want to buy the house in 8 years, what rate of interest do you need to earn? 4. You have $18,000 to invest right now and you figure you will need $25,000 to buy a new car. If you can earn 7% per year, how long before you can buy the car? 5. Consider the cash flows presented in the table below. What is the value of the cash flows in year 4 if the interest rate is 6 percent compounded annually? Year 1 2 3 Year 1 2 3 4 6. Consider the cash flows presented in the table below. What is the present value if the appropriate interest rate is 7 percent compounded annually? 4 5 Cash Flow 17,000 15,000 19,000 21,000 Cash Flow 21,000 14,000 21,000 13,000 18,000 7. What is the present value of $16,000 per year for 12 years if the interest rate is 7%? 8. You are going to borrow $600,000 to buy a house. What will your monthly payment be if the annual interest rate is 6.2 percent, and you borrow the money for 30 years? 9. You borrow $65, 000 to be repaid in 5 equal payments at the end of each of the next 5 years. The bank charges 6.3 percent compounded annually. Prepare the loan amortization schedule. per year. How much will you have in 10 years? 2. Bernard needs $140,000 in 9 years for his daughter's education. If he can earn 7.5% per year, how much does he need to invest today? 3. You have $38,000 to invest and you need $70,000 for a down payment and closing costs on a house. If you want to buy the house in 8 years, what rate of interest do you need to earn? 4. You have $18,000 to invest right now and you figure you will need $25,000 to buy a new car. If you can earn 7% per year, how long before you can buy the car? 5. Consider the cash flows presented in the table below. What is the value of the cash flows in year 4 if the interest rate is 6 percent compounded annually? Year 1 2 3 Year 1 2 3 4 6. Consider the cash flows presented in the table below. What is the present value if the appropriate interest rate is 7 percent compounded annually? 4 5 Cash Flow 17,000 15,000 19,000 21,000 Cash Flow 21,000 14,000 21,000 13,000 18,000 7. What is the present value of $16,000 per year for 12 years if the interest rate is 7%? 8. You are going to borrow $600,000 to buy a house. What will your monthly payment be if the annual interest rate is 6.2 percent, and you borrow the money for 30 years? 9. You borrow $65, 000 to be repaid in 5 equal payments at the end of each of the next 5 years. The bank charges 6.3 percent compounded annually. Prepare the loan amortization schedule.

Answer rating: 100% (QA)

1 If you invest 2000 per year at 5 interest per year you will have 24000 in 10 years 2 To have 14000... View the full answer