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

1 Expert Approved Answer
Step: 1 Unlock

a Present value of a 500 annuity when R 11 compound annually and t 18 Given information Annuity 50... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

68-B-C-F-C-B (1208).xlsx

300 KBs Excel File

Students Have Also Explored These Related Corporate Finance Questions!