Question

Please do the question manually and show all of your work! The correct answer is not helpful without the steps. Please and many thanks!

Question 6 20 points You want to start saving for your retirement, which you expect 33 years from now. To do this, you will invest $1,000 every month until then. You decide to allocate your savings as follows: • $700 per month in a stock fund with an expected APR return of 5.5% • $300 per month in a bond fund with an expected APR return of 2.5% At your retirement, you will redeem all of your investments and put them into a single account with a 4% return. But you will also make monthly withdrawals over the 25 years of your expected life following retirement. How much will you be able to withdraw from your account each month during your 25-year retirement? (Hint: First calculate the total future value of what you have invested at your retirement date; and then calculate a monthly annuity payment using that future value as your base amount.) O O O O A B. c. D. $1,425 $3,219 $5,097 $9,432 $9,923

Answer 1

Calculate the monthly payment as follows:

А 14 Particulars Amount 15 Stock fund $781,301.36 16 Bond fund $184,308.96 17 Future value $965,610.32 18 Monthly payment $5,097

Answer: Option C.

Formulas:

A 14 Particulars 15 Stock fund 16 Bond fund 17 Future value 18 Monthly payment Amount =FV(5.5%/12,33*12,-700) =FV(2.5%/12,33*12,-300) =B15+B16 =PMT(4%/12,25*12,-B17)