Question

The next two questions will be based on the following information Mr. Moore is 35 years old today and is beginning to plan for his retirement. He wants to set aside an equal amount at the end of each of the next 25 years so that he can retire at age 60. He expects to live to the maximum age of 80 and wants to be able to withdraw $25,000 per year from the account on his 61st through 80th birthdays. The account is expected to earn 10 percent per annum for the entire period of time.

Determine the value of pension at the age of 60 for all payments during age 61- 80? Excel hint: PV(rate, nper, pmt, fv O, type 0)?? O 112,839.09 O 212.839.09 O 500,000.00 O 312.839.09

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Value of pension at age of 60 PMT (1-(1/1 An)))/r $212,839.09 25000* (1-(1/(1.10 20)))/0.10

Add a comment
Know the answer?
Add Answer to:
The next two questions will be based on the following information Mr. Moore is 35 years...
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
  • Mr. Moore is 35 years old today and is beginning to plan for his retirement. He...

    Mr. Moore is 35 years old today and is beginning to plan for his retirement. He wants to set aside an equal amount at the end of each of the next 25 years so that he can retire at age 60. He expects to live to the maximum age of 80 and wants to be able to withdraw $25,000 per year from the account on his 61st through 80th birthdays. The account is expected to earn 10 percent per annum...

  • Mark Gandalla, a young engineer at John Deere, plans to retire 35 years from now. He...

    Mark Gandalla, a young engineer at John Deere, plans to retire 35 years from now. He expects that he will live another 25 years after retiring. Mark wants to have enough money upon reaching retirement age to withdraw $120,000 from the account at the end of each year he expects to live, and yet still have $1,000,000 left in the account at the time of his expected death (60 years from now). Mark Gandalla plans to accumulate the retirement fund...

  • Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's...

    Problem 5-36 Suppose that you were to receive a $30,000 gift upon graduation from your master's degree program, when you turn 31 years old. At the end of each working year for 34 years, you put an additional $5,000 into an IRA a. Assuming you earn an annual compounded rate of 7.5 percent on the Rift and the IRA investments, how much would be available when you retire at age 65? b. If you hope to draw money out of...

  • Mr. Nieto has $3,431,712 and wants to retire. He expects to live for another 15 years...

    Mr. Nieto has $3,431,712 and wants to retire. He expects to live for another 15 years and to earn 5.0% on his invested funds. How much could he withdraw at the end of each of the next 15 years and end up with $500,000 in the account? Solve without Excel and show formulas used!

  • Caulfield mogul Monty​ Buxton, age 40​, would like to retire at age 60. Once Mr. Buxton​...

    Caulfield mogul Monty​ Buxton, age 40​, would like to retire at age 60. Once Mr. Buxton​ retires, he wants to withdraw $1.2 billion at the beginning of each year for 10 years from a special offshore account which will pay 27% annually. In order to fund his​ retirement, Mr. Buxton will make 20 equal​ end-of-the-year deposits in this same special account which will pay 27​% annually. How much money will Mr. Buxton need at age​ 60, and how large of...

  • Arnold Atkinson wants to retire in 20 years at age 65. He has determined that he...

    Arnold Atkinson wants to retire in 20 years at age 65. He has determined that he will need a capital sum of $2,784,000 at that time to provide his retirement income. He presently has a retirement plan with a balance of $350,000, to which he will add $25,000 per year. Phil assumes that his preretirement and postretirement rates of return will be 8%, and that inflation will average 3%. He will not consider Social Security benefits in his planning. He...

  • Your client is 30 years old and wishes to retire at age 60. At the time, your client quashes to have saved $2,000,000. Y...

    Your client is 30 years old and wishes to retire at age 60. At the time, your client quashes to have saved $2,000,000. You advise the client to set aside money every year for the next 30 years. This money will be invested in a fund that you believe will average 12% each year for the next 30 years. A) How much will your client need to set aside for each payment into the fund in order to accumulate the...

  • Colin is 40 years old and wants to retire in 27 years. His family has a...

    Colin is 40 years old and wants to retire in 27 years. His family has a history of living well into their 90s. Therefore, he estimates that he will live to age 95. He currently has a salary of $150,000 and expects that he will need about 75% of that amount annually if he were retired. He can earn 8 percent from his portfolio and expects inflation to continue at 3 percent. Some years ago, he worked for the government...

  • Your uncle has $500,000 and wants to retire. He expects to live for another 20 years,...

    Your uncle has $500,000 and wants to retire. He expects to live for another 20 years, and he also expects to earn 5% on his invested funds. How much could he withdraw at the beginning of each of the next 20 years and end up with zero in the account? $40,474.12 $39,617.22 $39,259.89 38,210.76 $37,759.46

  • Huey, Dewey and Louie are triplets.  They are 25 years old and are trying to set up...

    Huey, Dewey and Louie are triplets.  They are 25 years old and are trying to set up savings plans for themselves.  They plan to retire at age 65.  They each have different ideas.  All APR’s are 4%. Huey’s plan:  deposit $100 each month into the account and leave the money in the bank until he retires at age 65.   Dewey’s plan:  Dewey doesn’t want to be bothered with monthly payments like Huey. He wants to hang onto his money throughout the year, and then make just...

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