In: Finance
You estimate that by the time you retire in 35 years, you will have accumulated savings of $2.5 million.
a. If the interest rate is 10.5% and you live 15 years after retirement, what annual level of expenditure will those savings support? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Annual expenditure
b. Unfortunately, inflation will eat into the value of your retirement income. Assume a 6% inflation rate and work out a spending program for your $2.5 million in retirement savings that will allow you to increase your expenditure in line with inflation. What will be your expenditure amount in real terms for each year of your retirement? (Do not round intermediate calculations. Round your answer to 2 decimal places.)
Real annual expenditure
a. Here rate=10.5%, nper=15, PV=$2.5mn
So, annual expenditure is $338120 per year
b.
For first year of retirement, real expenditure= 338120/1.06=$318981.14. Similarly expenditure in real terms during the year retirement is given below:
Year | Nominal Expenditure | Real Expenditure (Nominal Expenditure/(1+inflation rate)^year) |
1 | $338,120.00 | $318,981.14 |
2 | $338,120.00 | $300,925.60 |
3 | $338,120.00 | $283,892.08 |
4 | $338,120.00 | $267,822.71 |
5 | $338,120.00 | $252,662.94 |
6 | $338,120.00 | $238,361.26 |
7 | $338,120.00 | $224,869.11 |
8 | $338,120.00 | $212,140.67 |
9 | $338,120.00 | $200,132.71 |
10 | $338,120.00 | $188,804.44 |
11 | $338,120.00 | $178,117.40 |
12 | $338,120.00 | $168,035.28 |
13 | $338,120.00 | $158,523.85 |
14 | $338,120.00 | $149,550.80 |
15 | $338,120.00 | $141,085.66 |