In: Finance

# Tommy plans to retire in 25 years (1st withdrawal in year 26). He is told by...

Tommy plans to retire in 25 years (1st withdrawal in year 26). He is told by Simon that a desirable standard of living in 26 years will require $180,249 per year. Tommy wants to be able to maintain that level of purchasing power forever (Assume inflation = 3% per year). Tommy plans to increase his savings by 2% per year and expects to earn 6% per year on his investments. How much does Tommy have to save the first year to fund his retirement goal? ## Solutions ##### Expert Solution Step 1 : Calculate Retirement Corpus To calculate the corpus reqired at the time of retirement, we need to use the PV function of excel: • Retirement Period = 20 Years (Lets assume he'll live 20 years after retirement, ie, from 60 years to 80 years) • Effective rate of return = 2.91% Retirement Corpur Required =$2,782,790

Step 2 : Calculation of First Year Investment

• Saving period = 25 years
• Goal Required = $2,782,790 • Rate of Return = (1+6%)*(1+2%)-1 = 8.12% This can be solved using the PMT function excel: Hence, the first year investment needs to be$34,594, which will increased by 2% every year to reach the goal.

## Related Solutions

##### Newman plans to retire in 25 years and plans to withdraw end of the year payments...
Newman plans to retire in 25 years and plans to withdraw end of the year payments in the amount of $85,000 from his retirement account to allow him to enjoy the same standard of living he has enjoyed in life thus far. Newman’s financial planner has advised him that he should estimate his retirement will last 30 years and use a conservative 8% annual rate of return in his financial planning. Newman does already have$75,000 already...
##### STATE: Andrew plans to retire in 40 years. He plans to invest part of his retirement...
STATE: Andrew plans to retire in 40 years. He plans to invest part of his retirement funds in stocks, so he seeks out information on past returns. He learns that from 1966 to 2015, the annual returns on S&P 500 had mean 11.0% and standard deviation 17.0% . PLAN: The distribution of annual returns on common stocks is roughly symmetric, so the mean return over even a moderate number of years is close to Normal. We can use the Central...
##### Ms. Smith plans to retire in 25 years (she will be 65). The IRS longevity table...
Ms. Smith plans to retire in 25 years (she will be 65). The IRS longevity table forecasts that Ms. Smith will live to be 85 years old. Ms. Smith is expected to have 20 years in retirement. Ms. Smith needs to be able to withdraw $60,000 annually (end of each year) from her retirement investment account before the balance is fully used. This plus her$35,000 annually in social security benefits will serve her needs (she believes). During her 20...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT