Could you also show the excel functions used to solve.

(10 points) Solve the following: a. Find the present value of $11,200 nine years from now. The interest rate is 8%. b. Find the present value of $15,500 per year for 10 years with the first payment at the end of the first year at 8% interest. c. How long will it take to repay a 8% loan of $107,200 if $13,000 is paid at the end of each year. d. What would be the annual payment on a $475,600, 20 year loan at 12% interest. e. Find the value of a $1,000 bond paying $75 every six months and maturing 10 years from now if the current rate of interest is 13% compounded semiannually. 11200 -6 D E F C B Problem 4 c. b. d a. e PV FV INT Rate PMT NPER 8% 11200 1 2 3 4 5 6 7 8 9 20 21 2