finance excel

finance excel

Project description
Part (a) (40 points)
Design a retirement plan for yourself. Come up with some assumptions regarding the age you
will retire and the withdrawal from savings at the beginning of each month that you will give
yourself during retirement.
Assume you will earn 7% before retirement and 4% during retirement. Use the ;life expectancy
tables used by the Social Security Administration, to determine how long you will likely live in
retirement: http://www.ssa.gov/oact/STATS/table4c6.html.
Determine your retirement savings goal (enough that you can make the monthly withdrawals
required in your assumption).
Then determine how much you would have to save each month prior to retirement in order to
reach the goal.
Part (b) (30 points)
If you assume an inflation rate of 3%, what is the new, inflation-adjusted, retirement savings
goal?
How much do you have to save each month prior to retirement in order to reach the inflationadjusted
goal?
Pact (c) (30 points)
If you already have $50,000 in the account, how does this change the monthly savings
requirement prior to retirement, in the inflation-adjusted retirement plan?