In: Accounting
A 5-year annuity of ten $4500 semiannual payments will begin 9 years from now, with the first payment coming 9.5 years from now. If the discount rate is 12% compounded monthly, what is the value of this annuity five years from now? What is the value three years from now? What is the current value of the annuity?
I have calculate the PVa at t=9 is 73073.68, but I don't know how to do the next steps...
Please explain as clearly as possible
Thanks!!
Effective semi annual discount rate: | ||||||
Monthly discount rate =(12/12)%= | 0.01 | |||||
Effective semi annual discount rate=R: | ||||||
1+R=(1+0.01)^6= | 1.0615 | |||||
Effective semi annual discount rate=R: | 0.0615 | 6.15% | ||||
Present Value (PV) of Cash Flow: | ||||||
(Cash Flow)/((1+i)^N) | ||||||
i=Discount Rate=0.0615 | ||||||
N=Period of Cash Flow | ||||||
Annuity Value 5 year from now | ||||||
N | A | B=A/(1.0615^N) | ||||
Years from today | Semi annual Period from 5 years | Cash flow | Present value at period 0 | |||
5 | 0 | $0 | $0 | |||
5.5 | 1 | $0 | $0 | |||
6 | 2 | $0 | $0 | |||
6.5 | 3 | $0 | $0 | |||
7 | 4 | $0 | $0 | |||
7.5 | 5 | $0 | $0 | |||
8 | 6 | $0 | $0 | |||
8.5 | 7 | $0 | $0 | |||
9 | 8 | $0 | $0 | |||
9.5 | 9 | $4,500 | $2,629.86 | |||
10 | 10 | $4,500 | $2,477.49 | |||
10.5 | 11 | $4,500 | $2,333.96 | |||
11 | 12 | $4,500 | $2,198.73 | |||
11.5 | 13 | $4,500 | $2,071.35 | |||
12 | 14 | $4,500 | $1,951.34 | |||
12.5 | 15 | $4,500 | $1,838.28 | |||
13 | 16 | $4,500 | $1,731.78 | |||
13.5 | 17 | $4,500 | $1,631.45 | |||
14 | 18 | $4,500 | $1,536.92 | |||
SUM | $20,401.16 | |||||
Value of annuity five years from now | $20,401.16 | |||||
Number of periods from 3 years to 5 years | 4 | (2*2) | ||||
Value of annuity Three years from now | $16,068.48 | (20401.16/(1.0615^4) | ||||
Number of periods from today to 3 years | 6 | (3*2) | ||||
Current Value of annuity (Today) | $11,231.94 | (16068.48/(1.0615^6) | ||||