Question

You have just turned 30 years​ old, have just received your​ MBA, and have accepted your first job. Now you must decide how much money to put into your retirement plan. You are required to specify a fixed percentage of your salary that you want to contribute. Assume that your starting salary is $ 70 comma 000 per year and it will grow 1.8 % per year until you retire. Every dollar in the plan earns 6.5 % per year. You cannot make withdrawals until you retire on your​ sixty-fifth birthday. After that​ point, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn 65. You estimate that to live comfortably in​ retirement, you will need $ 97 comma 000 per year starting at the end of the first year of retirement and ending on your 100th birthday. What percentage of your income do you need to contribute to the plan every year to fund your retirement​ income?

Answer 1

Answer:

Find attached

Explanation:

The present value of $97,000 per year after retirement for 35 years is computed thus:

=-pv(rate,nper,pmt,fv)

rate is the plan rate of return of 6.5%

nper is 35 years(years after retirement)

pmt is the amount required per year

fv is not applicable is taken as zero

=-pv(6.5%,35,97000,0)=$1,327,634.80  

The amount needed in the account at retirement is the future value of the plan.

Regular yearly payment into the plan is =pmt

=pmt(rate,nper,-pv,fv)

=-pmt(6.5%,35,0,1327634.80)=$ 10,703.74

The percentage of income that must be contributed is found in the attached

Download xlsx