Solve through excel

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? 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? 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