Question

In: Finance

MF has decided to start saving for his retirement. He will start at the end of...

MF has decided to start saving for his retirement. He will start at the end of this year saving $2000 a year for 10 years and $5,000 a year for the next 15 years after that. When he has finished with this period, he will still have 10 years left until he retires. The interest rate before retirement is 9.5% interest per year. After he retires the expected interest rate is 8%. If he wants to withdraw from his account for 25 years, how much will he be able to withdraw each year so nothing is left at the end of the 25 years?

Solutions

Expert Solution

Sol:

Annual deposits (PMT) = $2,000 for 10 years and then $5,000 for next 15 years.

Interest rate = 9.5% per year before retirement and 8% after retirement.

Period (NPER)

To determine how much he will be able to withdraw each year so nothing is left at the end of the 25 years we can use FV and PMT function in excel:

PMT

-2000

NPER

10

Interest rate

9.50%

Future value

$31,120.58

Present value

$31,120.58

PMT

5,000

NPER

15

Interest rate

9.50%

Future value

$274,112.56

Present value

$274,112.56

NPER

10

Interest rate

9.50%

Future value

$679,313.31

Present value

$679,313.31

NPER

25

Interest rate

8%

PMT

$63,637.24

Therefore amount he will be able to withdraw each year so nothing is left at the end of the 25 years will be $63,637.24.

Working


Related Solutions

A is saving for her retirement and contributes $1000 to his account at the end of...
A is saving for her retirement and contributes $1000 to his account at the end of every year for 40 years. B is also saving for his retirement and contributes $950 to his account at the beginning of every year for 40 years. If they have the same amount of money after 40 years, what is the annual effective interest rate?
Richard and his dad decide to start saving for retirement at the same time. Richard is...
Richard and his dad decide to start saving for retirement at the same time. Richard is 20 years old and his dad is 40 years old. Both plan to put money into an IRA until they are 65. Both invest in the same things and earn the same rate of return which is 7%. Finally, in their retirement years, both believe they can score an APR of 4%. If they both want to receive $2,000 per month during retirement then...
Tom decides to get an early start on retirement saving and, beginning at age 22, he...
Tom decides to get an early start on retirement saving and, beginning at age 22, he invests $4,000 per year in a Roth IRA for 10 years in a row. At that point, he stops contributing to the account but leaves the money invested until age 65 (a period of 33 years). Harry doesn’t start investing until he’s 32 but from then on invests $5,000 in a Roth IRA each year for 33 years until retirement at age 65. If...
Bob, who is a close friend, has decided to start his own consulting firm. He has...
Bob, who is a close friend, has decided to start his own consulting firm. He has received conflicting information regarding the best business structure to reduce his tax liability. He will be the only employee; however, he is willing to consider creating an S-Corporation. Compare and contrast the benefits of Corporations, LLCs and S-Corps and make a recommendation regarding which would be the most advantageous for Bob. Defend your position. Please provide me some additional information that is not already...
Sam has a saving of $30,000 to start with and he is looking for private health...
Sam has a saving of $30,000 to start with and he is looking for private health insurance. His chance of getting cancer is 2% and his utility function U =√ Savings (utility is the square root of savings). He has three options: 1) do not buy the insurance and suffer the loss of $30,000 if he gets cancer; 2) buy partial insurance that provides coverage of $15,000 in the event of cancer, at the cost of $300 premium; 3) buy...
Adam plans to save 300,000 for his retirement within next 30 years. He is saving every...
Adam plans to save 300,000 for his retirement within next 30 years. He is saving every month as monthly savings and invest those with 10 percent yield. How much does Adam need to save every month?
Burt is saving up for his retirement. Today is his 36th birthday. Burt first started saving...
Burt is saving up for his retirement. Today is his 36th birthday. Burt first started saving when he was 27 years old. On his 27th birthday, Burt made the first contribution to his retirement account when he deposited $2,000. Each year on his birthday, Burt has contributed another $2,000 to the account. The 10th (and last) of these contributions was made earlier today on his 36th birthday. The account has paid an effective annual rate of return of 5.4%. a)...
You start saving $1,000 at the end of this year and increase your saving by 5%...
You start saving $1,000 at the end of this year and increase your saving by 5% every year for 18 years. Your account earns 13%. How much will you have in your account in 18 years?
You start saving $1,000 at the end of this year and increase your saving by 2%...
You start saving $1,000 at the end of this year and increase your saving by 2% every year for 21 years. Your account earns 15%. How much will you have in your account in 21 years?
You want to start saving for retirement. You currently have $7,000 set aside for retirement in...
You want to start saving for retirement. You currently have $7,000 set aside for retirement in an IRA. You want to contribute an additional $300 per month for the next 5 years (10%). Then, you believe that you can invest $1,000 per month for the next 45 years (10%). How much would you have at retirement if you would do this?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT