In: Finance
You wish to purchase a 15-year deferred annuity (payments start now) that will last 20 years and generate $3000 per month for those 20 years while growing in value at 3% during the 20-year payout period. Assuming the discount rate for all cash flows is 7%
What is the price you should pay for this 15-year deferred, 3% growing 20-year annuity? in creating your answer, place a spinner on all key rates (growth and discount)
Present Value (PV)of Cash Flow=(Cash Flow)/((1+i)^N) | ||||||
i=Discount Rate=7%=0.07 | ||||||
N=Year of Cash Flow | ||||||
Cash Flow at end of Year15= | $3,000 | |||||
Cash Flow at end of Year16=3000*1.03 | $3,090 | |||||
Cash Flow at end of Year (N+1)=1.03*(Cash Flow in Year (N) | ||||||
N | CF | PV=CF/(1.07^N) | ||||
Year End | Cash Flow | Present Value | ||||
0 | 0 | |||||
1 | 0 | |||||
2 | 0 | |||||
3 | 0 | |||||
4 | 0 | |||||
5 | 0 | |||||
6 | 0 | |||||
7 | 0 | |||||
8 | 0 | |||||
9 | 0 | |||||
10 | 0 | |||||
11 | 0 | |||||
12 | 0 | |||||
13 | 0 | |||||
14 | 0 | |||||
15 | $3,000 | $1,087 | ||||
16 | $3,090 | $1,047 | ||||
17 | $3,183 | $1,008 | ||||
18 | $3,278 | $970 | ||||
19 | $3,377 | $934 | ||||
20 | $3,478 | $899 | ||||
21 | $3,582 | $865 | ||||
22 | $3,690 | $833 | ||||
23 | $3,800 | $802 | ||||
24 | $3,914 | $772 | ||||
25 | $4,032 | $743 | ||||
26 | $4,153 | $715 | ||||
27 | $4,277 | $688 | ||||
28 | $4,406 | $663 | ||||
29 | $4,538 | $638 | ||||
30 | $4,674 | $614 | ||||
31 | $4,814 | $591 | ||||
32 | $4,959 | $569 | ||||
33 | $5,107 | $548 | ||||
34 | $5,261 | $527 | ||||
SUM | $15,511 | |||||
Price you should pay for this 15-year deferred, 3% growing 20-year annuity | $15,511 | |||||