Question

In: Finance

You plan to retire 35 years from now. You expect that you will live 25 years...

You plan to retire 35 years from now. You expect that you will live 25 years after retiring. You want to have enough money upon reaching retirement age to withdraw $180,000 from the account at the beginning of each year you expect to live, and yet still have $2,500,000 left in the account at the time of your expected death (60 years from now). You plan to accumulate the retirement fund by making equal annual deposits at the end of each year for the next 35 years. You expect that you will be able to earn 12% per year on your deposits. However, you only expect to earn 6% per year on your investment after you retire since you will choose to place the money in less risky investments. What equal annual deposits must you make each year to reach your retirement goal?

Solutions

Expert Solution

Present value of retirement benefits at the age of retirement

Present value of annuity of 180000 at the time of retirement

Using present value function in MS excel

Pv(rate,nper,pmt,fv,type) rate = 6% nper = 25 pmt =180000 fv = 0 type =1

PV(6%,25,180000,0,1)

($2,439,064.35)

present value of 2500000 left in account at the time of retirement

Using present value function in MS excel

Pv(rate,nper,pmt,fv,type) rate = 6% nper = 25 pmt =0 fv = 2500000 type =0

PV(6%,25,0,2500000,1)

($582,496.58)

total funds would be accumulated at the time of retirement

($3,021,560.93)

Yearly amount to be saved to get the funds accumulated

Using PMT function in MS excel

pmt(rate,nper,pv,fv,type) rate = 12% nper =35 pv = 0 fv= 3021560.93 type =0

PMT(12%,35,0,3021560.93,0)

($6,999.81)

You should save 6999.81 or 7000 Approx per year to accumulate a fund

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

You plan to retire 34 years from now. You expect that you will live 26 years...
You plan to retire 34 years from now. You expect that you will live 26 years after retiring. You want to have enough money upon reaching retirement age to withdraw $120,000 from the account at the beginning of each year you expect to live, and yet still have $2,200,000 left in the account at the time of your expected death (60 years from now). You plan to accumulate the retirement fund by making equal annual deposits at the end of...
You are 25 years old and plan to retire 35 year from today. You expect that...
You are 25 years old and plan to retire 35 year from today. You expect that you will live 30 years after retiring. You want to have enough money upon reaching retirement age to withdraw $150,000 from the account at the beginning of each year you expect to live, and yet still have $1,000,000 left in the account at the time of your expected death (65 years from now). You plan to accumulate the retirement fund by making equal annual...
You are 25 years old and plan to retire 35 year from today. You expect that...
You are 25 years old and plan to retire 35 year from today. You expect that you will live 30 years after retiring. You want to have enough money upon reaching retirement age to withdraw $150,000 from the account at the beginning of each year you expect to live, and yet still have $1,000,000 left in the account at the time of your expected death (65 years from now). You plan to accumulate the retirement fund by making equal annual...
Homework 2 When you retire you expect to live for another 25 years. Each month of...
Homework 2 When you retire you expect to live for another 25 years. Each month of your retirement you want to be able to withdraw $8,500 for living expenses. If you can earn 4.5% per year on your investment, how much do you need to have in your retirement account, at the time you retire, to make this happen?
Assume you are now 25 years old. You plan to retire when you are 65 years...
Assume you are now 25 years old. You plan to retire when you are 65 years old. You think you will live until you are 80 years. a.) If the rate of return during your working years (a.k.a. the "savings period") is 8% and you plan to save $2,000 per year, how much will you have saved up by retirement age? b.) If the rate of return during your retirement is 6% on the amount of savings you have accumulated,...
You plan to retire in 30 years. Beginning in 31 years from now you wish to...
You plan to retire in 30 years. Beginning in 31 years from now you wish to have an annual retirement income of $80,000 / year as measured in today’s dollars. The inflation rate is assumed to be 2.5%. Each year in retirement you wish to have your retirement income grow by 3% per year. You plan on living for 35 years in retirement. Starting in one year from now you are going to make annual deposits into a savings account....
19. You are currently 43 years old and expect to retire in 25 years, and then...
19. You are currently 43 years old and expect to retire in 25 years, and then you expect to live for another 20 years after retirement. Your current labor income is about $60,000. Assuming you have no savings, how much do you need to save from this point until retirement in order to replace 75% of your current income during retirement? (Assume no increase in wage and that your rate of interest will exceed inflation by 3%) (4 pts) 20....
Solve using excel (show work) Assume you are now 25 years old. You plan to retire...
Solve using excel (show work) Assume you are now 25 years old. You plan to retire when you are 65 years old. You think you will live until you are 80 years. a.) If the rate of return during your working years (a.k.a. the "savings period") is 8% and you plan to save $2,000 per year, how much will you have saved up by retirement age? b.) If the rate of return during your retirement is 6% on the amount...
Assume that you plan to retire in 35 years and that you estimate you will need...
Assume that you plan to retire in 35 years and that you estimate you will need an income of $100,000 at the beginning of each year for 30 years, following your retirement. You also plan to donate $1,000,000 to the Georgia Southern University College of Business to endow a scholarship in the name of your favorite finance professor. You will make this endowment exactly 5 years after you retire. Assume that you will earn 11.00 percent during your working years...
Assume you are 32 years old and plan to retire in 35 years at age 67....
Assume you are 32 years old and plan to retire in 35 years at age 67. You are currently earning $75,000/year and expect average annual salary increases of 4.0%/year over the next 35 years. You have $0 saved for retirement. You are trying to determine how much money to save (invest) each year in your 401(k) Plan to fund your retirement in order to pay yourself 70% of your final salary each year (that increases with inflation). [Remember this is...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT