Question: Use an excel spreadsheet and the FV, PV, and PMT functions to determine the amount of each. R= the annual interest rate, t= number of
Use an excel spreadsheet and the FV, PV, and PMT functions to determine the amount of each. R= the annual interest rate, t= number of years. When there are multiple cash flows per year, the amount of annuity shown below. Round all the answers to nearest dollar.
a) Present value of a $ 500 annuity, when R= 11% compound annually and t= 18
b) Future value of a $ 2,400 annuity, when R= 5% compound 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 where R= 63/8% compounded annually and t= 3
h) Present value of a $ 1,000 annuity when R= 10% compounded semiannually and t= 11.
i) The semiannual annuity payment that will pay off, over six years a $ 9,860 debt owed if R= 13%
j) Future value of a $ 1 annuity when R= 8% compounded annually and t= 200
Step by Step Solution
3.37 Rating (166 Votes )
There are 3 Steps involved in it
a Present value of a 500 annuity when R 11 compound annually and t 18 Given information Annuity 50... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
68-B-C-F-C-B (1208).xlsx
300 KBs Excel File
