Question

You want to be a millionaire when you retire in 40 years. You can much more will you have to save each month if you wait 10 y Please show formulas, calculations, and steps! Show all work
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Number of periods = 40*12 = 480
Rate per month = 12.5%/12
FV = 1,000,000
Monthly Payment = FV/(1-(1+12.5%/12)-480)/(12.5%/12) =  1,000,000/(1-(1+12.5%/12)-480)/(12.5%/12) = 72.53

New Number of Periods = 30*12 = 360
Monthly Payment = FV/(1-(1+12.5%/12)-360)/(12.5%/12) =  1,000,000/(1-(1+12.5%/12)-360​​​​​​​)/(12.5%/12) = 255.91

More savings per month required = 255.91 - 72.53 = 183.38 (Option e is correct option)

Please Discuss in case of Doubt

Best of Luck. God Bless
Please Rate Well

Add a comment
Know the answer?
Add Answer to:
Please show formulas, calculations, and steps! Show all work You want to be a millionaire when...
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 be a millionaire when you retire in 35 years. a. How much do...

    You want to be a millionaire when you retire in 35 years. a. How much do you have to save each month if you can earn an annual return of 10.7 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. How much do you have to save each month if you wait 10 years before you begin your deposits? (Do not round intermediate calculations and round your answer to 2 decimal places,...

  • You have decided that you want to be a millionaire when you retire in 45 years....

    You have decided that you want to be a millionaire when you retire in 45 years. Requirement 1: If you can earn an annual return of 9 percent, how much do you have to invest today? (Enter rounded answer as directed, but do not use rounded numbers in intermediate calculations. Round your answer to 2 decimal places (e.g., 32.16).)   Investment $    Requirement 2: What if you can earn 4.5 percent? (Enter rounded answer as directed, but do not use rounded...

  • Please show your work with the formulas/calculations written out (for example; without using excel tables). 9....

    Please show your work with the formulas/calculations written out (for example; without using excel tables). 9. If you paid $750 for an investment 25 years ago that is now worth $2000, what was your rate of return? 10. If you save $100 per month, what annual rate of interest must you earn in order to accumulate $10,000 after 10 years? 11. If you borrow $250,000 for 10 years and your monthly payment is $1000, what rate of interest are you...

  • I need help solving part c but you need part b for part c. b. If you are 25 years old and you want to be a millionaire b...

    I need help solving part c but you need part b for part c. b. If you are 25 years old and you want to be a millionaire by age 65, how much must you need to invest monthly, if you can earn 10.5 percent per year return over that period? c. If you also had a lump sum of $20,000 at age 25, how much less must you invest per month if you want to retire at age 65,...

  • please answer all and show all work. 6. You have just started working and would like...

    please answer all and show all work. 6. You have just started working and would like to start saving for your retirement. If you would like to accumulate 53 million dollars when you retire in 40 years, how much do you need to save each month in cual amounts of the interest rate is 6% to reach this goal? Assume you start saving one month from today. Use the table of cash flows given below for problems 7 and 8....

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

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

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

  • Problem 4-25 Calculating Present Values (LO 2] You have decided that you want to be a...

    Problem 4-25 Calculating Present Values (LO 2] You have decided that you want to be a millionaire when you retire in 44 years. a. If you can earn an annual return of 11.34 percent, how much do you have to invest today? (Do not round Intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What if you can earn an annual return of 5.67 percent? (Do not round Intermediate calculations and round your answer to 2...

  • Create an excel solution for this problem and show steps. Assume that you plan to retire...

    Create an excel solution for this problem and show steps. Assume that you plan to retire 40 years from now and that you expect to need $2million to support the lifestyle that you want. a) if the interest rate is 10%, is the following statement approximetly true? "waiting 5 years to start saving doubles what you must deposit each year." b) if the interest rate is 12%, is the required multiplier higher or lower than for the 10% rate in...

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