I have never worked in microsoft excel before. can you please check my answers and format it into excel format for my finance class

5-1 FutureValue Compute the future value in year 9 of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 using a 10 percent interest rate. 7 FV = $ 2,000 x (1+0.10) 5 + $ 1,500 x (1+0.10) = $3,897.42 + $2,415.77 = $6,313.19 5-3 Future Value of an Annuity What is the future value of a $900 annuity payment over five years if interest rates are 8 percent? 900 x [ (1+.08)^5 -1/.08] 900 x [1.5868/.08] 469.44 = 4224.96 FV of annuity = PMT*FVIFA(i,n) = 900*FVIFA(8%,5) = 900* 5.8666 = $5,279.94 5-5 Present Value Compute the present value of a $2,000 deposit in year 1 and another $1,500 deposit at the end of year 3 if interest rates are 10 percent. Present value = 2000/(1+10%)^1 + 1500/(1+10%)^3 = $2,945.15 5-7 Present Value of an Annuity What's the present value of a $900 annuity payment over five years if interest rates are 8 percent? PV of annuity = PMT*PVIFA(i,n) = 900*PVIFA(8%,5) = 900* 3.9927 = $3,593.43 5-12 Present Value of an Annuity Due If the present value of an ordinary, 6-year annuity is $8,500 and interest rates are 9.5 percent, what's the present value of the same annuity due? PVA6 due = $8,500 (1 + 0.095) = $9,307.50 5-15 Effective Annual Rate A loan is offered with monthly payments and a 10 percent APR. What's the loan's effective annual rate (EAR)? EAR = ( 0.10 12 12 1+ - 1 = 0.1047 = 10.47% 5-39 Loan Payments You wish to buy a $25,000 car. The dealer offers you a 4-year loan with a 9 percent APR. What are the monthly payments? How would the payment differ if you paid interest only? What would the consequences of such a decision be? Monthly Payment PMT = PMT(rate, nper,pv) = PMT(9%/12, 4*12,-25000) = $622.13 Monthly Interest = 25000*9%/12 = $187.50