ZuoTi.Pro
Question

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 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 = 0, type = 0) = ??

500,000.00   

112,839.09

212,839.09

business   finance   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

Answer #1

No. 212839.09

1 0
Add a comment
Know the answer?
Add Answer to:
Mr. Moore is 35 years old today and is beginning to plan for his retirement. He...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions

  • The next two questions will be based on the following information Mr. Moore is 35 years...

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

  • Bill has decided to begin investing for retirement. He is going to put his tax raturn...

    Bill has decided to begin investing for retirement. He is going to put his tax raturn of $7,328 into the account today and then set up monthly contributions from his paycheck in the amount of $385. The money will go into an account that earns 7.7 percent annual interest (compounded monthly). How much will he have in the account after 20 years? Show using excell cell functions Nper Rate PV FV PMT

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

  • 2. Mike currently 48, has $20,000 saved for retirement. He is currently saving $500 at the...

    2. Mike currently 48, has $20,000 saved for retirement. He is currently saving $500 at the beginning of every month and his employer matches his total savings contribution on a monthly basis. Mike projects that he could earn 9% on his savings. He plans to retire at 65 and expects to live until age 85. His current expenditure on basic needs at the beginning of every month is $2500 every month which is expected to increase with inflation of 3%....

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

  • Rob is thinking about retirement. He is 38 years old and working as a sales associate at Dillard's. His current annual i...

    Rob is thinking about retirement. He is 38 years old and working as a sales associate at Dillard's. His current annual income is $56,000 and this income will increase at a 5% rate annually. Dillard's offers a defined contribution plan and Rob contributes $2240 out of his gross income every year and now his current retirement account balance is $55,000. He wants to retire at his normal retirement age which is 67, and his life expectancy is 90. The interest...

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

  • Your best friend Frank just celebrated his 30th birthday and wants to start saving for his anticipated retirement. Frank plans to retire in 35 years and believes that he will have 20 good years of ret...

    Your best friend Frank just celebrated his 30th birthday and wants to start saving for his anticipated retirement. Frank plans to retire in 35 years and believes that he will have 20 good years of retirement and believes that if he can withdraw $90,000 at the end of each year, he can enjoy his retirement. Assume that a reasonable rate of interest for Frank for all scenarios presented below is 8% per year. This is an annual rate, review each...

  • Mini-Case where he has worked on him. He 2000 in addition his lump sum bonu and...

    Mini-Case where he has worked on him. He 2000 in addition his lump sum bonu and owns mutual fune 60, has just retired from his job at the city council. worked for 38 years. He has a family that is depen- He has received a lump sum retirement bonus of wirion to £1,700 per month as his pension. Besides um bonus, he also has £60,000 in an ISA account autual fund units worth £80,000 as of now. The ISA Barry...

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