Part 5: Supplementing Prof. Business Retirement Savings. Prof. Business realizes she is entering the last quarter of her career and is considering retirement in 7 years. She is in a self-managed defined contribution pension plan and through automatic payroll deduction and University matching both based on mandated percentages of her salary $1600/month is currently deposited into her pension plan. Due to the lack of recent raises at her public university, she doesnt plan on these monthly contributions increasing much if any over the next 7 years. Prof. Business currently has $720,000 in her pension plan account and is somewhat concerned if this along with her mandated future $1600 monthly deposits will adequately fund her retirement in 7 years. She is considering supplementing her pension plan by having automatic additional monthly deposits deducted into a 403c retirement plan which is like a 401k plan for employees of non-profit organizations like public universities. She is comfortable that this 403c plan since it has the same investment management companies and investment options as her current pension plan and it also has a Roth option where she wont get a tax break for her deposits, but her retirement withdrawals will be tax free. Prof. Business has a monthly deposit amount in mind but wants your help in trying to figure out if this amount will be adequate. Given her current pension plan portfolio investment mix, she estimates a nominal annual expected return of 6.96% which translates to a 0.58% monthly expected return. answer in an excel sheet

1. Prof. Business is considering having $1100/month, which is 10-15% of her monthly gross (pre-tax) salary deducted and deposited into the 403c for the next 7 years. This is addition to the $720,000 already in her pension plan today and the estimated $1600 monthly deposits into her current pension plan. What is the expected total value of Prof. Business retirement accounts after making end of the month deposits of $2700 for 7 years on top of her current retirement savings of $720,000 at her expected monthly return?

2. Prof. Business estimates she will live for 25 years after her planned retirement in 7 years and wants a monthly retirement annuity with the withdrawals at the end of each month once she retires. What is her expected monthly retirement income using your answer from #1 and assuming she will continue to earn her expected monthly return after retirement?