Question

In: Finance

Assume that you contribute $250 per month to a retirement plan for 25 years. Then you...

Assume that you contribute $250 per month to a retirement plan for 25 years. Then you are able to increase the contribution to $500 per month for another 25 years. Given a 9.0 percent interest rate, what is the value of your retirement plan after the 50 years?

Solutions

Expert Solution

The retirement plan sees contributions of $ 250 per month for 25 years, followed by monthly contributions of $ 500 for another 25 years (300 months). Annual Interest Rate = 9 %

Monthly Interest Rate = (9/12) = 0.75 % per month

Assuming that contributions are made at the beginning of each month, the total future value of these monthly deposits would be equal to the retirement plan value after 25 years.

Deposit 1 Future Value = D1 = {250 x (1.0075)^(300) + 250 x (1.0075)^(299) + ....+ 250 x (1.0075)^(1)} x (1.0075)^(300) = $ 2656772.44 ~ $ 2656772

Deposit 2 Future Value = D2 = 500 x (1.0075)^(300) + 500 x (1.0075)^(299) + 500 x (1.0075)^(298) + ....+ 500 x (1.0075) = $ 564765.18 ~ $ 564765

Total Value of Retirement Plan = D1 + D2 = 2656772 + 564765 = $ 3221538

NOTE: If Deposits are assumed to be made at the end of each month then

- D1 = {250 x (1.0075)^(299) + 250 x (1.0075)^(298) + ............+ 250} x (1.0075)^(300) = $ 2636995

- D2 = 500 x (1.0075)^(299) + 250 x (1.0075)^(298) + ....+ 500 = $ 560561

Total Retirement Plan Value = 2636995 + 560561 = $ 3197556


Related Solutions

Assume that you contribute $260 per month to a retirement plan for 20 years. Then you...
Assume that you contribute $260 per month to a retirement plan for 20 years. Then you are able to increase the contribution to $460 per month for the next 30 years. Given a 6.0 percent interest rate, what is the value of your retirement plan after the 50 years? (Do not round intermediate calculations and round your final answer to 2 decimal places.)
Assume that you contribute $260 per month to a retirement plan for 20 years. Then you...
Assume that you contribute $260 per month to a retirement plan for 20 years. Then you are able to increase the contribution to $520 per month for another 30 years. Given a 7.2 percent interest rate, what is the value of your retirement plan after the 50 years?  
11. Assume you contribute $500 per month to a retirement plan for 30 years. Then, you...
11. Assume you contribute $500 per month to a retirement plan for 30 years. Then, you are able to increase the contribution to $600 per month for another 15 years. Given a nine (9) percent interest rate (as APR), what is the value of your retirement plan after the 45 years? Group of answer choices A. $3,740,279.81 B. $915,371.74 C. $3,190,385.51 D. $4,008,230.74 E. $4,655,6541.55
Assume you put $500 per month into a retirement account for 13 years, and the account...
Assume you put $500 per month into a retirement account for 13 years, and the account has an APR of 3.06% compounded monthly. What is the account balance at the end of the 13 years? Round your answer to the nearest cent. How much of the money in the account at the end of the 13 years is your personal investment, meaning that the money came directly from you? How much of the money in the account at the end...
Suppose that you are 25 years old, and making retirement plans. You are starting to contribute...
Suppose that you are 25 years old, and making retirement plans. You are starting to contribute $600 per month to your retirement account at the beginning of each month. You intend to do so until the age of sixty seven and then stop the contributions. You will retire at age 70. You receive a 7% APR compounded monthly on your account. What could you withdraw in terms of a monthly perpetuity?                                          Group of answer choices < $12800                                                         > $13400 $12800-$13000...
You are completing a retirement plan and you expect to work for an additional 25 years...
You are completing a retirement plan and you expect to work for an additional 25 years until retirement. You plan for a retirement horizon of 20 years. During retirement, you would like to withdraw an annual income equal that affords purchasing power equal to $150,000 today (so your withdrawals must adjust for inflation). Assume you will make 20 annual withdrawals during retirement with the first occurring one year following your retirement date. You would like to also have $1,000,000 in...
You are completing a retirement plan and you expect to work for an additional 25 years...
You are completing a retirement plan and you expect to work for an additional 25 years until retirement. You plan for a retirement horizon of 20 years. During retirement, you would like to withdraw an annual income equal that affords purchasing power equal to $150,000 today (so your withdrawals must adjust for inflation). Assume you will make 20 annual withdrawals during retirement with the first occurring one year following your retirement date. You would like to also have $1,000,000 in...
You are completing a retirement plan and you expect to work for an additional 25 years...
You are completing a retirement plan and you expect to work for an additional 25 years until retirement. You plan for a retirement horizon of 20 years. During retirement, you would like to withdraw an annual income equal that affords purchasing power equal to $150,000 today (so your withdrawals must adjust for inflation). Assume you will make 20 annual withdrawals during retirement with the first occurring one year following your retirement date. You would like to also have $1,000,000 in...
You set up a savings plan for retirement in 35 years. You will deposit $250 each...
You set up a savings plan for retirement in 35 years. You will deposit $250 each month for 35 years. The account will earn an average of 6.5% compounded monthly. a. How much will you have in your retirement plan in 35 years? b. How much interest did you earn. c. What percent of the balance is interest? Could you show the formula in Excel? I think it is PV.
If you currently have$200’000 in your retirement account , and plan to contribute $10,000 per year...
If you currently have$200’000 in your retirement account , and plan to contribute $10,000 per year and can earn 8%(annually) , how long will it take you to reach your goal of $1,000,000?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT