Question

In: Finance

Your best friend Steve just celebrated his 30th birthday and wants to start saving for his...

Your best friend Steve just celebrated his 30th birthday and wants to start saving for his anticipated retirement. Steve plans to retire in 30 years and believes that he will have 25 good years of retirement (he has looked at the life expectancy tables and is playing the odds here) and believes that if he can withdraw $120,000 at the end of each year, he can enjoy his retirement. In this problem, assume that the full 25 years of retirement payments are made, and the account has a zero balance at the end. Assume that a reasonable rate of interest for Steve for all scenarios presented below is 7% per year. This is an annual rate, review each individual question for more specifics on compounding periods per year. Because Steve is planning ahead, the first withdrawal will not take place until one year after he retires. he wants to make equal annual deposits into his account for his retirement fund.

A. If he starts making these deposits in one year and makes his last deposit on the day he retires, what amount must he deposit annually to be able to make the desired withdrawals at retirement?

A1) First: Amount Steve needs to have saved as of his retirement:

A2) The amount Steve must save each year (beginning at the end of the first year) to fund his retirement is:

A3) If Steve decides to make monthly deposits for 35 years to reach his same retirement goal, how much must Steve start depositing one month from today?

Solutions

Expert Solution

A1]

Amount Steve needs to have saved as of his retirement is calculated using PV function in Excel :

rate = 7% (annual rate of interest earned)

nper = 25 (25 yearly withdrawals during retirement)

pmt = 120,000 (yearly withdrawal amount desired)

PV is calculated to be $1,398,430

A2]

Amount Steve must save each year is calculated using PMT function in Excel :

rate = 7% (annual interest rate)

nper = 30 (30 annual deposits until retirement)

pv =0 (current value of retirement account is zero)

fv = 1,398,430 (required value of retirement fund at the end of 30 years from now)

PMT is calculated to be $14,804

A3]

If Steve makes monthly deposits for 35 years to reach his same retirement goal, the monthly deposit is calculated using PMT function in Excel :

rate = 7% / 12 (converting annual rate into monthly rate)

nper = 35 * 12 (35 years with 12 monthly deposits each year)

pv =0 (current value of retirement account is zero)

fv = 1,398,430 (required value of retirement fund at the end of 30 years from now)

PMT is calculated to be $776.45


Related Solutions

Your best friend Steve just celebrated his 30th birthday and wants to start saving for his...
Your best friend Steve just celebrated his 30th birthday and wants to start saving for his anticipated retirement. Steve plans to retire in 30 years and believes that he will have 25 good years of retirement (he has looked at the life expectancy tables and is playing the odds here) and believes that if he can withdraw $120,000 at the end of each year, he can enjoy his retirement. In this problem, assume that the full 25 years of retirement...
Your best friend Frank just celebrated his 30th birthday and wants to start saving for his...
Your best friend Frank just celebrated his 30th birthday and wants to start saving for his anticipated retirement. Frank plans to retire in 35 years and believes that he will have 20 good years of retirement and believes that if he can withdraw $90,000 at the end of each year, he can enjoy his retirement. Assume that a reasonable rate of interest for Frank for all scenarios presented below is 8% per year. This is an annual rate, review each...
Your friend is celebrating her 30th birthday today and wants to start saving for her anticipated...
Your friend is celebrating her 30th birthday today and wants to start saving for her anticipated retirement at age 65. She wants to be able to withdraw $80,000 from her savings account on each birthday for 25 years following her retirement; the first withdrawal will be on her 66th birthday. Your friend intends to invest her money in the local credit union, which offers 4.5 percent interest per year. She wants to make equal annual payments on each birthday into...
Your friend is celebrating her 30th birthday today and wants to start saving for her anticipated...
Your friend is celebrating her 30th birthday today and wants to start saving for her anticipated retirement at age 65. She wants to be able to withdraw $80,000 from her savings account on each birthday for 25 years following her retirement; the first withdrawal will be on her 66th birthday. Your friend intends to invest her money in the local credit union, which offers 4.5 percent interest per year. She wants to make equal annual payments on each birthday into...
Your friend is celebrating her 25th birthday today and wants to start saving for her anticipated...
Your friend is celebrating her 25th birthday today and wants to start saving for her anticipated retirement at age 65. She wants to be able to withdraw $200,000 from her saving account on each birthday for 15 years following her retirement; the first withdrawal will be on her 66th birthday. Your friend intends to invest her money in a retirement account, which earns 8 percent return per year. She wants to make an equal annual deposit on each birthday into...
Your friend is celebrating her 25th birthday today and wants to start saving for her anticipated...
Your friend is celebrating her 25th birthday today and wants to start saving for her anticipated early retirement at age 55. She wants to be able to withdraw $10,000 from her savings account on each birthday for 10 years following her retirement, the first withdrawal will be in her 56th birthday. She wants to make equal, annual payments on each birthday in a new savings account she will establish for her retirement fund. The account pays 8 per cent interest...
Your uncle Abdallah is celebrating his 33th birthday today and wants to start saving for his...
Your uncle Abdallah is celebrating his 33th birthday today and wants to start saving for his retirement at the age of 63. He wants to be able to withdraw AED 100,000 from his saving account on each birthday for 20 years following his retirement. The first withdraw will be on his 64th birthday. Your uncle intends to invest his money in a local bank in Abu Dhabi that offers 7% interest rate per year. He wants to make equal payments...
2) Today, you celebrated your 30th birthday. Also, you just landed a new job, thanks to...
2) Today, you celebrated your 30th birthday. Also, you just landed a new job, thanks to your excellent education at BW. The new firm provides you a 401-k plan, and you decide to deposit $400 every month for first 20 years. After that (since your kids are out in college and your living expenses are lower) you increase your contribution by $200/month, that results in a total contribution of $600/month. The firm matches it at 100% and deposits the money...
Your friend tells you that she wants to start saving for retirement by investing in the...
Your friend tells you that she wants to start saving for retirement by investing in the stock market. Given that you have taken this finance class, she asks you for advice about what stocks she should buy. What would you tell her?
This is a classic retirement problem. A friend is celebrating her birthday and wants to start...
This is a classic retirement problem. A friend is celebrating her birthday and wants to start saving for her anticipates retirement. She has the following years to retirement and retirement spending goals: Years until retirement: 30 Amount to withdraw each year: 90,000 Years to withdraw in retirement: 20 Interest Rate: 8% Because your friend is planning ahead, the first withdraw will not take place until one year after she retires. She wants to make an equal annual deposit into her...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT