Question

If Leon requires $1,000,000 to retire, how much does he need to save weekly for the...

If Leon requires $1,000,000 to retire, how much does he need to save weekly for the next 15 years to reach his goal if he has already saved $100,000 and his investments can earn 5% per year while compounding monthly?

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

Function Arguments PMT Rate 15%/12 0.004166667 Nper 15 12 180 个 = -100000 个 = 1000000 - number Pv -100000 Fv 100000d Type -2950.475974 Calculates the payment for a loan based on constant payments and a constant interest rate. Fv is the future value, or a cash balance you want to attain after the last payment is made, 0 (zero) if omitted. Formula result = S (2,950.48 Help on this function OK Cancel

Hence, Required weekly payment is $737.62 ($2,950.48/4)

Add a comment
Know the answer?
Add Answer to:
If Leon requires $1,000,000 to retire, how much does he need to save weekly for the...
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
  • Randy Hill wants to retire in 20 years with $1,000,000. If he can earn 10% per...

    Randy Hill wants to retire in 20 years with $1,000,000. If he can earn 10% per year on his investments, how much does he need to deposit each year to reach his goal? Round your answer to the nearest dollar. $25,000 $18,000 $5,727 $17,460 None of these choices are correct.

  • Question 5 1 pts Your clients want help figuring out how much they need to save...

    Question 5 1 pts Your clients want help figuring out how much they need to save each month so that they can reach their retirement goal. If your clients are currently 40 years old and want to retire when they are age 68, how much do they need to save at the end of each month to reach their goal? They currently have $190,000 saved for retirement. Assume the following: • Your clients currently spend $100,000 (in today's dollars), and...

  • Question 4 1 pts Your clients want help figuring out how much they need to save...

    Question 4 1 pts Your clients want help figuring out how much they need to save each month so that they can reach their retirement goal. If your clients are currently 37 years old and want to retire when they are age 62, how much do they need to save at the end of each month to reach their goal? They currently have $180,000 saved for retirement. Assume the following: • Your clients currently spend $70,000 (in today's dollars), and...

  • Your father is 50 years old and will retire in 10 years. He expects to live...

    Your father is 50 years old and will retire in 10 years. He expects to live for 25 years after he retires, until he is 85. He wants a fixed retirement income that has the same purchasing power at the time he retires as $40,000 has today. (The real value of his retirement income will decline annually after he retires.) His retirement income will begin the day he retires, 10 years from today, at which time he will receive 24...

  • Kevin has decided to retire once he has $1,000,000 in his retirement account. At the end...

    Kevin has decided to retire once he has $1,000,000 in his retirement account. At the end of each year, he will contribute $4,500 to the account, which is expected to provide an annual return of 7.4%. How many years will it take until he can retire? a. 36 years b. 42 years c. 40 years d. 39 years e. 41 years Suppose Kevin’s friend, George, has the same retirement plan, saving $4,500 at the end of each year and retiring...

  • Your clients want help figuring out how much they need to save for their child's education....

    Your clients want help figuring out how much they need to save for their child's education. If your clients' child is currently 4 years old and will start college at 18 years of age, how much do they need to save at the end of each month to reach their goal? Assume the following: • You estimate that a year of tuition in line with your clients' goal is $7,000 in today's dollars • College expenses inflate at 4.4% per...

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

  • How much will Jimmy need to save per month to pay for Jane and his retirement

    How much will Jimmy need to save per month to pay for Jane and his retirement income for 25 years assuming that Jimmy can earn 8.0% per year, compounding monthly, on the invested funds. Assume Jimmy and Jane stop saving in 40 years when they reach 65, and funds are then held in a savings account earning zero. Further, assume that the 401k is NOT used for income, as it will be needed for a vacation home transition. (Hint: Use...

  • your uncle will retire in 10 years he will need $25000 per year for 10 years...

    your uncle will retire in 10 years he will need $25000 per year for 10 years after his retirement. how much he have to save at end of each year for next 10 years to support his after retirement need if market interest rate for saving is on average is 8% annually in next 20 years

  • Adam will retire in 10 years. He wants a fixed retirement income that has the same...

    Adam will retire in 10 years. He wants a fixed retirement income that has the same purchasing power at the time he retires as $40,000 has today, and he plan to receive that fixed income for 25 years starts from the day he retires. Inflation rate is expected to be 5% for 10 years (ignore inflation after Adam retires). He currently has $100,000 in the 8% annual compounding rate savings. How much must Adam save during each of next 10...

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