Use an Excel spreadsheet and the FV, PV, PMT functions todetermine the amount of
ID: 2433270 • Letter: U
Question
Use an Excel spreadsheet and the FV, PV, PMT functions todetermine the amount of each of the following, R=the annualinterest rate and T=number of years,. When there are multiplecash flows per year, the amount of the annuity shown below is theamount 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% compoundedannually and T=25 c. Future value of a 950 annuity when R=12.8% compoundedsemiannually and T=15 d. The annual annuity payment that will provide 13,400in 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% compoundedannually 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% compoundedsemiannually 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% compoundedannually and T=200 Use an Excel spreadsheet and the FV, PV, PMT functions todetermine the amount of each of the following, R=the annualinterest rate and T=number of years,. When there are multiplecash flows per year, the amount of the annuity shown below is theamount 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% compoundedannually and T=25 c. Future value of a 950 annuity when R=12.8% compoundedsemiannually and T=15 d. The annual annuity payment that will provide 13,400in 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% compoundedannually 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% compoundedsemiannually 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% compoundedannually and T=200Explanation / Answer
0.128 / 2
15*2
0.08/4
10*4
-$10,000
Interest Rate (Rate)
7%
16
0.10/2
11*2
13%/2
6*2
(a) Calculating PresentValue of Annuity: Interest Rate (Rate) 11% Number of Periods (Nper) 18 Annual Payment Amount (PMT) -$500 Present Value of Annuity (PV) $3,850.81 (b) Calculating Future Value ofAnnuity: Interest Rate (Rate) 5% Number of Periods (Nper) 25 Annuity Payment (PMT) -$2,400 Future Value of Annuity Amount(FV) $114,545.04 (c ) Calculating Future Value ofAnnuity: Interest Rate (Rate)0.128 / 2
Number of Periods (Nper)15*2
Annuity Payment (PMT) -$950 Future Value of Annuity Amount(FV) $80,609.88 (d) Calculating AnnuityPayment: Interest Rate (Rate) 9% Number of Periods (Nper) 8 Future Value of Annuity Amount (FV) -$13,400 Annuity Payment (PMT) $1,215.04 (e) Calculating Present Value ofAnnuity: Interest Rate (Rate)0.08/4
Number of Periods (Nper)10*4
Annual Payment Amount (PMT)-$10,000
Present Value of Annuity Amount(PV) $273,554.79 (f) Calculating Future Value ofAnnuity:Interest Rate (Rate)
7%
Number of Periods (Nper)16
Annuity Payment (PMT) -$238 Future Value of Annuity (FV) $6,637.36 (h) Calculating Present Value ofAnnuity: Interest Rate (Rate)0.10/2
Number of Periods (Nper)11*2
Annuity Payment Amount (PMT) -$700 Present Value of Annuity (PV) $26,953.65 (i) Calculating Semi-Annual Payment: Interest Rate (Rate)13%/2
Number of Periods (Nper)6*2
Present Value of Debt Amount (PV) -$9,860 Semi-Annual Annuity Payment(PMT) $1,208.52 (j) Calcualting Future Value ofDollar (FV): Interest Rate (Rate) 8% Number of Periods (Npet) 200 Present Value of Dollar Amount (PV) -$1 Future value of Dollar Amount(FV) $4,838,949.58Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.