Question

In: Finance

you dont plan on working a majority of your life before retiring, as your parents are...

you dont plan on working a majority of your life before retiring, as your parents are doing instead you believe a 20 year working career is sufficient to accumulate a retirement account value of $2 million. If you start today, how much will you have deposit each month to reach $2 million at retirement assume you will average a 7% annual rate of return and deposits will be made at the end of each month

Solutions

Expert Solution

Ans:- we will use the PMT function of excel to find the monthly deposit.

For PMT, Rate=7%/12, Nper=12*20=240, PV=0, FV=-$2,000,000.

Therefore, the monthly deposit to accumulate $2 million should be approx $3,839.31.


Related Solutions

1.You do not plan on working the majority of your life before retiring, as your parents...
1.You do not plan on working the majority of your life before retiring, as your parents are doing. Instead, you believe a 20 year working career is sufficient to accumulate a retirement account value of $2,000,000. If you start today, how much will you have to deposit each month to reach $2,000,000 at retirement?Assume you will average a 7.00 percent annual rate of return and deposits will be made at the end of the month. Report the final answer as...
You plan on working for the next 35 years before retiring and you would like to...
You plan on working for the next 35 years before retiring and you would like to accumulate $2 million when you stop working. If you start today, how much will you deposit each month to reach $2 million in retirement? Assume you will average a 7% annual rate of return in deposits will be made at the end of each month.
You plan on retiring in 30 years and want to have $3,000,000 saved in your retirement...
You plan on retiring in 30 years and want to have $3,000,000 saved in your retirement account. You will earn an average rate of return of 6% on your investments. How much will you need to invest each month in order to get to your goal.
In creating a plan to buy your life insurance, what factors should you consider before buying?...
In creating a plan to buy your life insurance, what factors should you consider before buying? Also, describe from whom you should buy, including the sources. Pls write atleast 300 words.
In creating a plan to buy your life insurance, what factors should you consider before buying?...
In creating a plan to buy your life insurance, what factors should you consider before buying? Also, describe from whom you should buy, including the sources. ( PLEASE DETAILED ANSWER)!!
You plan on retiring in 20 years. You plan on making an annual payment to yourself...
You plan on retiring in 20 years. You plan on making an annual payment to yourself in retirement and the first payment will occur 20 years from today. You plan on needing to make 25 payments as you plan to live 25 years in retirement. To keep up with inflation, you want your retirement payments to grow 3% ann. As part of your retirement planning, you deposited $75,000 into a savings account 8 years ago. However, life etc. got in...
You plan on retiring in 20 years. You plan on making an annual payment to yourself...
You plan on retiring in 20 years. You plan on making an annual payment to yourself in retirement and the first payment will occur 20 years from today. You plan on needing to make 25 payments as you plan to live 25 years in retirement. To keep up with inflation, you want your retirement payments to grow 3% ann. As part of your retirement planning, you deposited $75,000 into a savings account 8 years ago. However, life etc. got in...
Assume you plan on retiring in 30 years (i.e., in the year 2049). Share your estimate...
Assume you plan on retiring in 30 years (i.e., in the year 2049). Share your estimate of your future financial need, in terms of annual earnings. Share your desired quality of life and living standards. Finally, define both your role and the government’s role, in meeting your future financial requirements.
Your parents plan to give you $200 a month for four years while you are in...
Your parents plan to give you $200 a month for four years while you are in college. At a discount rate of 6 percent, compounded monthly, what are these payments worth to you when you first start college? $8,797.40 $8,409.56 $8,198.79 $8,516.06 $8,279.32
your wonderful parents established a college savings plan for you when you were born. They deposited...
your wonderful parents established a college savings plan for you when you were born. They deposited $50 into the account on the last day of each month. The account has earned 10% compounded monthly. Now you are off to Monash university. What equal amount can they withdraw beginning today (your 18th birthday) and each year for 4 years to spend on your education, assuming that the account now earns 7% annually?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT