Question

In: Finance

You wish to retire in 20 years. Currently, your pre-retirement fund has RM50,000 in a savings...

You wish to retire in 20 years. Currently, your pre-retirement fund has RM50,000 in a savings account yielding 3.0% annually and RM300,000 quality stocks yielding 11.0% annually. Furthermore, you expect to add RM8,000 to the savings account and RM15,000 to your stock portfolios at the end of each year in the next 20 year. You will keep this fund until the retirement date.

Calculate the overall rate of return per year that you must earn on your post-retirement fund if you wish to withdraw RM240,000 at the end of each year in the following 25 years after retirement.


How much would your remaining fund be after three year-end withdrawals of RM 300,000 each post the retirement? Assume your fund earns a return of 5% per year.

Solutions

Expert Solution

Year Savings Account Addition In Savings Account   Total Saving Accounts   Savings with Interest @ 3% Quality Stock   Addition In Savings Account   Total Portfolio Portfolio with Interest @ 11%
0                                                                          50,000                                                               -                                                        50,000                 3,00,000                                                          -                       3,00,000
1                                                                          50,000                                                        8,000                                                      58,000                                                      59,740                 3,00,000                                                 15,000                     3,15,000 349650
2                                                                          59,740                                                        8,000                                                      67,740                                                      69,772                 3,15,000                                                 15,000                     3,30,000 366300
3                                                                          67,740                                                        8,000                                                      75,740                                                      78,012                 3,30,000                                                 15,000                     3,45,000 382950
4                                                                          75,740                                                        8,000                                                      83,740                                                      86,252                 3,45,000                                                 15,000                     3,60,000 399600
5                                                                          83,740                                                        8,000                                                      91,740                                                      94,492                 3,60,000                                                 15,000                     3,75,000 416250
6                                                                          91,740                                                        8,000                                                      99,740                                                  1,02,732                 3,75,000                                                 15,000                     3,90,000 432900
7                                                                          99,740                                                        8,000                                                  1,07,740                                                  1,10,972                 3,90,000                                                 15,000                     4,05,000 449550
8                                                                      1,07,740                                                        8,000                                                  1,15,740                                                  1,19,212                 4,05,000                                                 15,000                     4,20,000 466200
9                                                                      1,15,740                                                        8,000                                                  1,23,740                                                  1,27,452                 4,20,000                                                 15,000                     4,35,000 482850
10                                                                      1,23,740                                                        8,000                                                  1,31,740                                                  1,35,692                 4,35,000                                                 15,000                     4,50,000 499500
11                                                                      1,31,740                                                        8,000                                                  1,39,740                                                  1,43,932                 4,50,000                                                 15,000                     4,65,000 516150
12                                                                      1,39,740                                                        8,000                                                  1,47,740                                                  1,52,172                 4,65,000                                                 15,000                     4,80,000 532800
13                                                                      1,47,740                                                        8,000                                                  1,55,740                                                  1,60,412                 4,80,000                                                 15,000                     4,95,000 549450
14                                                                      1,55,740                                                        8,000                                                  1,63,740                                                  1,68,652                 4,95,000                                                 15,000                     5,10,000 566100
15                                                                      1,63,740                                                        8,000                                                  1,71,740                                                  1,76,892                 5,10,000                                                 15,000                     5,25,000 582750
16                                                                      1,71,740                                                        8,000                                                  1,79,740                                                  1,85,132                 5,25,000                                                 15,000                     5,40,000 599400
17                                                                      1,79,740                                                        8,000                                                  1,87,740                                                  1,93,372                 5,40,000                                                 15,000                     5,55,000 616050
18                                                                      1,87,740                                                        8,000                                                  1,95,740                                                  2,01,612                 5,55,000

Related Solutions

You wish to retire in 30 years with retirement savings equal to $750,000. How much should...
You wish to retire in 30 years with retirement savings equal to $750,000. How much should you put away each month if the annual interest rate is 9.75%? Round to the nearest 0.01.
You plan to retire in exactly 20 years. Your goal is to create a fund that...
You plan to retire in exactly 20 years. Your goal is to create a fund that will allow you to receive $20,000 at the end of each year for the next 30 years between retirement and death (a psychic told you that you’d die exactly 30 years after you retire). You know that you will be able to earn 11% per year during the 30-year retirement period. Required: d. Now assume that you will earn 10% from now through the...
You plan to retire in year 20 Your retirement will last 25 years starting in year...
You plan to retire in year 20 Your retirement will last 25 years starting in year 21 You want to have $50,000 each year of your retirement. How much would you have to invest each year, starting in one year, for 15 years , to exactly pay for your retirement ,if your investments earn 6.00% APR (compounded annually)?
You plan to retire in year 20 Your retirement will last 25 years starting in year...
You plan to retire in year 20 Your retirement will last 25 years starting in year 21 You want to have $50,000 each year of your retirement. How much would you have to invest each year, starting in one year, for 15 years , to exactly pay for your retirement ,if your investments earn 6.00% APR (compounded annually)? Answers: $21,349 $21,546 $20,930 $20,520
You plan to retire in year 20 Your retirement will last 25 years starting in year...
You plan to retire in year 20 Your retirement will last 25 years starting in year 21 You want to have $50,000 each year of your retirement. How much would you have to invest each year, starting in one year, for 15 years , to exactly pay for your retirement ,if your investments earn 6.00% APR (compounded annually)? a. 21.,349 b. 21, 546 c. 20,520 d. 20,930
1. On the day you retire, you will have $389,900 in your retirement savings. You expect...
1. On the day you retire, you will have $389,900 in your retirement savings. You expect to earn 4.5 percent, compounded monthly, and live 24 more years. How much can you withdraw from your savings each month during your retirement? A. $754.16 B. $751.35 C. $2,208.01 D. $2,072.00 E. $2,216.28 2. You are retired, have $264,500 in your savings, withdraw $2,000 each month, and earn 4.5 percent, compounded monthly. How long will it be until you run out of money?...
Suppose you are just starting your retirement savings at age 25, and plan to retire at...
Suppose you are just starting your retirement savings at age 25, and plan to retire at age 70. Your goal is to save a million dollars in your IRA and you believe you can earn a 7% rate of return on your investment. How much must you contribute to your IRA each year to meet your goal? Select one: a. $22,222 b. $3,500 c. $619 d. $21,881
Your retirement is 20 years away and you are interested in saving for your retirement. You...
Your retirement is 20 years away and you are interested in saving for your retirement. You expect another fifteen years to live after retirement. You think you will need 60,000 dollars every year to live post retirement. You have to estimate how much you should save annually if You expect a rate of return of 8% for the next 35 years, and You expect to earn 9% for the next 20 years. At retirement you put your money in an...
Your parents will retire in 20 years. They currently have $300,000 saved, and they think they...
Your parents will retire in 20 years. They currently have $300,000 saved, and they think they will need $950,000 at retirement. What annual interest rate must they earn to reach their goal, assuming they don't save any additional funds? Round your answer to two decimal places.
Suppose you plan to retire in 33 years. Today, your retirement has a balance of 500,000....
Suppose you plan to retire in 33 years. Today, your retirement has a balance of 500,000. If you can earn 3% per year in your retirement account, how much more do you need to deposit now so that you can have 2.9 million when you retire? 1. 694,761.60 2. 1,593,376.12 3. 1,093,376.12 4. 593,376.12
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT