Use an Excel spreadsheet and the FV, PV, and PMT functions to determine the amount of each of the following . R = theannual interest rate and t = the number number of years. When the reare multipule cash flows per year, the amount ofannutity shown below is the amount of each individual cash flow (not the total cash flow for the year). Round all answers to thenearest dollar.
a. Present value of a $500annuity when R = 11% compounded annually and t =18
b. Future value of a $2,400annuity when R = 5% compounded annually and t= 25
c. Future value of$950 annuity when R = 12.8% compounded semiannually andt = 15
d. The annual annuitypayment that will $13,400 in eight years when R = 9%compounded annually
e. Present value of a$10,000 annuity when R = 8% compounded quartely andt = 10
f. Future value of a$238 annuity when R = 7% compounded annually andt = 16
g. Present value of a$1,000 annuity when R = 6?% compounded annually andt = 3
h. Present value of $700annuity when R = 10% compounded semiannualy and t= 11
i. Thesemiannually annuity payment that will pay off, over six years, a$9,860 debt owed today if R = 13%
j. Future valueof a $1 annuity when R = 8% compounded annually andt = 200