In: Finance
An investor plans the following investments for the next 20
years: 12.00 years of $10,075.00 per year, and 8.00 years of
$13,775.00 per year.
She thinks his investments will earn 4.00% a year for the first
12.00 years, and then earn 11.00% per year for the last 8.00 years.
How much would the investor have to set aside today if she wants to
fund the entire account?
Year | Cashflows | PVF | Present values | ||||||
0 | 0 | 1 | 0 | ||||||
1 | 10075 | 0.961538 | 9687.5 | ||||||
2 | 10075 | 0.924556 | 9314.904 | ||||||
3 | 10075 | 0.888996 | 8956.638 | ||||||
4 | 10075 | 0.854804 | 8612.152 | ||||||
5 | 10075 | 0.821927 | 8280.916 | ||||||
6 | 10075 | 0.790315 | 7962.419 | ||||||
7 | 10075 | 0.759918 | 7656.172 | ||||||
8 | 10075 | 0.73069 | 7361.704 | ||||||
9 | 10075 | 0.702587 | 7078.561 | ||||||
10 | 10075 | 0.675564 | 6806.309 | ||||||
11 | 10075 | 0.649581 | 6544.528 | ||||||
12 | 10075 | 0.624597 | 6292.815 | ||||||
13 | 13775 | 0.5627 | 7751.193 | ||||||
14 | 13775 | 0.506937 | 6983.057 | ||||||
15 | 13775 | 0.4567 | 6291.042 | ||||||
16 | 13775 | 0.411441 | 5667.606 | ||||||
17 | 13775 | 0.370668 | 5105.951 | ||||||
18 | 13775 | 0.333935 | 4599.956 | ||||||
19 | 13775 | 0.300842 | 4144.104 | ||||||
20 | 13775 | 0.271029 | 3733.427 | ||||||
Present value of cash outflows | 138831 | ||||||||
Amount to be kept aside today: 138831 | |||||||||
Note: Here PVF is computed by applying 4% for first 12yrs and then 11% afterwards on PVf of 12th year | |||||||||