Question

Waiting period with an ordinary annuity. Fill in the missing number of payments or years (waiting period) in the following table for an ordinary annuity stream i Data Table (Click on the following icone in order to copy its contents into a spreadsheet.) Annual Interest Rate Future Value Annuity Present Value Number of Payments or Years ? ? 6% 8% 10% 4% 0.00 $5,794.62 0.00 $100,000.00 $250.00 $400.00 $636.48 $80.80 $2,867.48 0.00 $6,000.00 0.00

Answer 1

Using Excel, we enter the below formulas

1.
=NPER(6%,-250,2867.48,0)=20

2.
=NPER(8%,-400,0,5794.62)=10

3.
=NPER(10%,-636.48,6000,0)=30

4.
=NPER(4%,-80.80,0,100000)=100