Question

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.

1.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.                  

2.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.

Business   Accounting   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Use rate formuale in excel - rate(nper,pmt,pv,fv,type)

For value at retirement (saving) =FV(B6,B1,-B5,-B4,0)

For value at retirement (stock) =FV(B12,B1,-B11,-B10,0)

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Andrew wishes to retire in 12 years and currently he has RM50,000 in savings account yielding...
Andrew wishes to retire in 12 years and currently he has RM50,000 in savings account yielding 5 percent annually and RM100,000 in stocks yielding 10 percent per annum. If he expects to add RM10,000 to his savings account and RM20,000 to his stock portfolio at the end of each year, how much is his retirement funds when he retires?
You wish to save money to provide for retirement. Beginning one year from now, you will...
You wish to save money to provide for retirement. Beginning one year from now, you will begin depositing a annual fixed amount into a retirement savings account that will earn 8% annually. You will make 30 such deposits. Then, one year after making the final deposit, you will withdraw $100,000 annually for 20 years (no more deposits). You wish to have $50,000 left in the account after the 20-year retirement period ends (note that this final cash flow has the...
You just turned 28 and are now seriously planning for your retirement. You wish to retire...
You just turned 28 and are now seriously planning for your retirement. You wish to retire two years earlier than the mandatory retirement age of 65. You hope to be able to make end-of-month withdrawals from your retirement account of P25,000 per month for a 30-year period after that. Your plan is to fund your retirement by making monthly deposits between now and when you retire. The initial monthly deposit will be made at the end of the coming month....
You plan to retire in 28 years. At the point of retirement, you want to be...
You plan to retire in 28 years. At the point of retirement, you want to be able to withdraw 25,682 at the end of each year forever. Assume that you earn a 7.1% rate of return prior to retirement and an 5.69% rate of return after retirement. If you do not want to make any further contributions to your retirement fund, how much do you need today? Round answer to the nearest dollar.
you are planning your retirement in 10 years you currently have 169000$ in a bond account...
you are planning your retirement in 10 years you currently have 169000$ in a bond account and 609000 in a stock account. you plan to add 7100$ per year at the end of each of the next 10 years to your bond the stock account will earn a return of 10.75% and the bond account will earn a return of 7.25%.when you retire you plan to withdraw an equal amount of each of the next 21 years at the end...
Duke plans to retire in 20 years and has just established a personal retirement account where...
Duke plans to retire in 20 years and has just established a personal retirement account where the annual return rate is 8%. If at the end of every month in the coming 20 years, Duke will deposit $500 in the retirement account, what’s the monthly amount (at the end of each month) he can withdraw from this retirement account in the 10 years after retirement (Duke will have a zero balance after the last withdrawal)?
A week from now, you plan to begin saving for your retirement by depositing $200 into...
A week from now, you plan to begin saving for your retirement by depositing $200 into a new savings account that has an expected return of 7.75% compounded monthly. You plan to continue depositing the same amount each week until you retire in 40 years. You expect to make withdrawals from your savings account every year for 35 years after you retire. Assume you were asked to find the amount you will be able to withdraw each year from your...
A year from now, you plan to begin saving for your retirement by depositing $20,000 into...
A year from now, you plan to begin saving for your retirement by depositing $20,000 into a new savings account that has an expected return of 5.75% compounded monthly. You plan to continue depositing the same amount each year until you retire in 35 years. You expect to make withdrawals from your savings account every month for 40 years after you retire. Assume you were asked to find the amount you will be able to withdraw each month from your...
You want to withdraw $8,500 per month in real terms for 25 years when you retire....
You want to withdraw $8,500 per month in real terms for 25 years when you retire. You plan to retire in 35 years, and expect to earn an 11 percent nominal effective annual return before you retire. You will make monthly deposits to fund your retirement account. Immediately after you make your last deposit, you plan to withdraw $35,000 in real terms to take an around the world trip. You also wish to leave your grandchildren $750,000 in real terms...
You have finished your time at Kelley and need to start thinking about retirement. You plan...
You have finished your time at Kelley and need to start thinking about retirement. You plan on working for 20 more years and then retire. Upon your retirement 20 years from today, you plan to have enough money to withdraw $10,000 per month, with the first payment coming exactly one month after your retirement day. You expect your retirement account to earn a return of 8% APR (stated rate), compounded monthly, on all funds in the retirement account. Assuming you...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT