Your aunt Maria is planning for retirement in 12 years. She currently has a portfolio made up of $50,000 in a money market savings account and $125,000 in a mutual fund. She receives an annual bonus from her current employer that she plans to deposit in the savings account at the end of each year for the next 12 years. The annual rates of return for the savings account and mutual fund, and the annual amount deposited in the savings account appear in the following table.

1. Compute the total amount of money in Aunt Marias portfolio when she retires at the end of 12 years. To accomplish this, you must show the following values: 1. The future value of the initial savings balance. 2. The future value of the initial mutual fund balance. 3. The future value of the annual deposits to the savings account over the 12-year horizon. 4. The total future value of the portfolio.
2. When she retires, suppose your aunt deposits the total amount of money determined in part (A) in a new account earning 5.00 percent annually. If she expects to live another 20 years once she retires, how much can she withdraw each month to end up with a zero balance in the account upon her death? Assume she receives the withdrawal at the end of each month.

The annual rate of return on savings account 4.00 percent The annual rate of return on mutual fund 7.50 percent The end-of-year savings deposit for $2,500 years 1-6 The end-of-year savings deposit for years 7 - 12 $5,000