### Create an Account

Home / Questions / Use an Excel spread sheet and the FV PV PMT functions to determine the amount

# Use an Excel spread sheet and the FV PV PMT functions to determine the amount

Use an Excel spread sheet and the FV, PV, PMT functions to determine the amount of each of the following, R = the annual interest rate and T=number of years,. When there are multiple cash flows per year, the amount of the annuity shown below is the amount of each individual cash flow (not the total sach flow forthe year). Round to the nearest dollar.

a. Present the value of a 500 annuity when R= 11% compounded annually and T=18

b. Future value of a 2,400 annuity when R=5% compounded annually and T=25

c. Future value of a 950 annuity when R=12.8% compounded semiannually and T=15

d. The annual annuity payment that will provide 13,400 in eight years when R=9% compounded annually.

e. Present value of a 10,000 annuity when R= 8% compounded quarterly and T=10

f. Future value of a 238 annuity when R=7% compounded annually and T=16

g. Present value of a 1,000 annuity when R=6 3/8% compounded annually and T=3

h. Present value of a 700 annuity when R=10% compounded semiannually and T=11

i. The semiannual annuity payment what will pay off,over six years, a 9,860 debt owned today if R=13%

j. Future value of a dollar when R=8% compounded annually and T=200

May 01 2018 View more View Less Subscribe To Get Solution