Use an Excel spreadsheet and the FV, PV, and PMT functions to determine the amount of each

Question:

Use an Excel spreadsheet and the FV, PV, and 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 shown below is the amount of each individual cash flow (not the total cash flow for the year). Round all answers to the nearest dollar.
a. Present value of a $500 when R = 11% compounded annually and t = 18
b. of a $2,400 when R = 5% compounded annually and t = 25
c. of a $950 when R = 12.8% compounded semiannually and t = 15
d. The annual payment that will provide $13,400 in eight years when R = 9% compounded annually
e. Present value of a $10,000 when R = 8% compounded quarterly and t = 10
f. of a $238 when R = 7% compounded annually and t = 16
g. Present value of a $1,000 when R = 63/8% compounded annually and t = 3
h. Present value of a $700 when R = 10% compounded semiannually and t = 11
i. The semiannual payment that will pay off, over six years, a $9,860 debt owed today if R = 13%
j. of a $1 when R = 8% compounded annually and t = 200

Annuity
An annuity is a series of equal payment made at equal intervals during a period of time. In other words annuity is a contract between insurer and insurance company in which insurer make a lump-sum payment or a series of payment and, in return,... Future Value
Future value (FV) is the value of a current asset at a future date based on an assumed rate of growth. The future value (FV) is important to investors and financial planners as they use it to estimate how much an investment made today will be worth...