Question

In: Finance

A man is planning to retire in 20 years. He wishes to deposit a regular amount...

A man is planning to retire in 20 years. He wishes to deposit a regular amount every three months until he retires, so that, beginning one year following his retirement, he will receive annual payments of $60,000 for the next 15 years. How much must he deposits if the annual interest rate is 6% compounded quarterly? (Note that the last deposit is made on the date of the end of 20th year, and first withdrawal is at the end of 21st year.) Draw cash flow diagram.

Solutions

Expert Solution

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.


Related Solutions

A man is planning to retire in 25 years. He wishes to deposit a regular amount...
A man is planning to retire in 25 years. He wishes to deposit a regular amount every three months until he retires, so that, beginning one year following his retirement, he will receive annual payments of $80,000 for the next 15 years. How much must he deposit if the interest rate is 6% compounded quarterly?
Q.3. A man is planning to retire in 20 years. He wishes to deposit a regular...
Q.3. A man is planning to retire in 20 years. He wishes to deposit a regular amount every two months until he retires so that, beginning one year following his retirement, he will receive annual payments of $30,000 for the next 10 years. How much must he deposit if the interest rate is 10% compounded monthly?
A man plans to retire in 25 years and spend 35 years in retirement. He currently...
A man plans to retire in 25 years and spend 35 years in retirement. He currently earns $82,500 before-tax annually, which increases annually with the level of inflation. He has determined that he needs 70% of his pre-retirement income for his retirement years. He currently has $282,000 in his RRSP account and $10,000 in a non-registered account. He will earn 5.50% before retirement and during retirement he will readjust his portfolio to be more conservative earning 3.50%. Inflation is 2%...
A man is planning to retire in 15 years. Money can be deposited at 4% interest...
A man is planning to retire in 15 years. Money can be deposited at 4% interest compounded quarterly, and it is also estimated that the future general inflation rate will be 6% compounded annually. What amount of end-of quarter deposit must be made each quarter until the man retires so that he can make annual withdrawals of $80,000 in terms of today's dollars over the 20 years following his retirement? (Assume that his first withdrawal occurs at the end of...
A man is planning to retire in 15 years. Money can be deposited at 8% interest...
A man is planning to retire in 15 years. Money can be deposited at 8% interest compounded quarterly, and it is also estimated that the future general inflation rate will be 6%. What amount of end-of-quarter deposit must be made each quarter until the man retires so that he can make annual withdrawals of $80,000 in terms of today's dollars over the 20 years following his retirement? (Assume that his first withdrawal occurs at the end of the first year...
Collins wishes to retire in 30 years’ time and has estimated that he will require a...
Collins wishes to retire in 30 years’ time and has estimated that he will require a monthly pension income of K24,000 per month for 20 years subsequent to retirement. Collins will contribute to a retirement fund which will enable her to take out a monthly pension of K24,000 after retirement. The retirement fund is currently earning a return of 9% per annum, interest compounded monthly, and this level is expected to remain unchanged and to be sustainable over the next...
Chad Zutter, a 25 years old university graduate, and he wishes to retire at age of...
Chad Zutter, a 25 years old university graduate, and he wishes to retire at age of 65. To cover his cost of living after retiring, he deposits $2,000 each year into retirement fund. He will earn 10 percent over the fund until he retires. * (a) If Chad makes an annual end of year payment, how much will he has when he retired. (b) If Chad decided to start saving beginning of the year, calculate the amount he will has...
John is currently 25 years old. He has $10,000 saved up and wishes to deposit this...
John is currently 25 years old. He has $10,000 saved up and wishes to deposit this into a savings account which pays him J12 = 6% p.a. He also wishes to deposit $X every month into that account so that when he retires at 55, he can withdraw $2000 every month end to support his retirement. He expects to live up till 70 years. How much should he deposit every month into his account?
You are planning to save for retirement. You would like to retire 20 years from today...
You are planning to save for retirement. You would like to retire 20 years from today and you currently have $190,000 set aside. You anticipate saving $825 per month ($550 out of your pocket and $275 from a company match into your 401(k) plan. You anticipating earning an 8.5% rate of return over the next 10 years. After 10 years, you will up your monthly savings to $X per month (combined contribution from you and your employer into your 401(k)...
1. A regular deposit of $100 is made at the beginning of each year for 20...
1. A regular deposit of $100 is made at the beginning of each year for 20 years. Simple interest is calculated at i%per year for the 20 years. At the end of the 20-year period, the total interest in the account is $840. Suppose that interest of i% compounded annually had been paid instead. How much interest would have been in the account at the end of the 20 years? 2. Herman has agreed to repay a debt by using...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT