Question

When you retire you expect to live for another 30 years. At the time your retire, you want to be able to withdraw $8,250 per
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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

110 A 1 2 PMT 3 4 N 5 6 1/4 Monthly withdraw Years to live in retirement No. of monthly withdrawal Annual interest rate Month

Cell reference -

A в 2 PMT Monthly withdraw 3 Years to live in retirement 4 N No. of monthly withdrawal Annual interest rate 6 1/Y Monthly int

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

Add a comment
Know the answer?
Add Answer to:
When you retire you expect to live for another 30 years. At the time your retire,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You want to retire at age 60 and expert to live another 30 years. On the...

    You want to retire at age 60 and expert to live another 30 years. On the day you retire you will have GHC 400,900 in your retirement savings account. You are conservative and expect to earn 5% on your money during your retirement. How much can you withdraw from your retirement savings account each month if you plan to die on the day you spend your last penny? (3 marks)

  • 10. You retire at age 60 and expect to live another 27 years. On the day...

    10. You retire at age 60 and expect to live another 27 years. On the day you retire, you have $464,900 in your retirement savings account. You are conservative and expect to earn 14.5% on your money during your retirement. How much can you withdraw from your Jretirement savings each month if you plan to die on the day you spend your last penny?

  • You want $6,000 per month in your retirement. You expect to retire 40 years from today....

    You want $6,000 per month in your retirement. You expect to retire 40 years from today. At the time you retire, you want the payments to be at the beginning of the month and want them to last 30 years or 360 months. You expect an annual interest rate of 5% during retirement. You need to save to obtain this retirement. How much per month at the end of each month do you need to save for the next 480...

  • You want to withdraw $11,200 per month for 30 years when you retire, then you expect...

    You want to withdraw $11,200 per month for 30 years when you retire, then you expect to pass on. You plan to retire in 40 years, and expect to earn a return of 11.2 percent until then. You will make monthly deposits to fund your retirement account. Immediately after you make your last deposit, you plan to withdraw $80,000 to take an around the world trip. You also wish to leave your grandchildren $1,200,000 when you pass on. You will...

  • On the day you retire you have $1,000,000 saved. You expect to live another 25 years...

    On the day you retire you have $1,000,000 saved. You expect to live another 25 years during which time you expect to earn 6.19% on your savings while inflation averages 2.5% annually. Assume you want to spend the same amount each year in real terms and die on the day you spend your last dime. What real amount will you be able to spend each year?

  • expect to retire You are 35 years old today and are considering your retirement needs. You...

    expect to retire You are 35 years old today and are considering your retirement needs. You at age 65 and your actuarial tables suggest that you will live to be 100. You want to move to the Bahamas when you retire. You estimate that it will cost you $ 300,000 to make the move (on your 65th birthday) and that your living expenses will be $30,000 a year (starting at the end of year 66 and continuing through the end...

  • Question 18 (3.5 points) You plan to retire 33 years from now. You expect that you...

    Question 18 (3.5 points) You plan to retire 33 years from now. You expect that you will live 29 years after retiring. You want to have enough money upon reaching retirement age to withdraw $150,000 from the account at the beginning of each year you expect to live, and yet still have $2,300,000 left in the account at the time of your expected death (62 years from now). You plan to accumulate the retirement fund by making equal annual deposits...

  • You just turned 23 years old and want to retire when you turn 65. You expect...

    You just turned 23 years old and want to retire when you turn 65. You expect to live for 25 years after retirement and want to withdraw $90,000 per year in retirement, starting on your 65th birthday. You expect to earn a return of 7% on your investments every year. 1. What is the present value (as of your 65th birthday) of the withdrawals you expect to make in retirement? 2. How much money should you save each year if...

  • 1. You want $6,000 per month in your retirement. You expect to retire 40 years from...

    1. You want $6,000 per month in your retirement. You expect to retire 40 years from today. At the time you retire, you want the payments to be at the beginning of the month and want them to last 30 years or 360 months. You expect an annual interest rate of 5% during retirement. You need to save to obtain this retirement. How much per month at the end of each month do you need to save for the next...

  • You hope to retire in 30 years, when you do, you would like to have the...

    You hope to retire in 30 years, when you do, you would like to have the purchasing power of $100,000 today, during each year of retirement. Your cash is needed at the beginning of each year of retirement. Inflation is expected to be 3% per year from now until the end of your retirement. Your retirement will last 25 years, you expect your 401k to earn 5% per year during your retirement years. How much money do you need at...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT