9. Retire early or not:

Plan A: Retire at age 60 Plan B: Retire at age 65

Assume you are 25 years old now and you expect to live to age 82. Also assume your salary would reach $100,000 when you are 60 and will increase by 5% annually until age 65. You expect to have a pension of 60% of your annual income at the time of your retirement.

(a) Assuming an interest rate of 3.1%, what should you invest monthly to reach your goal with both Plan A and Plan B?

(b) Assuming the 5% annual salary increase happens throughout your career, deter- mine your annual salary and your annual net income after making the contributions to each Plan for each of the next 10 years.

MUST USE EXCEL, PLEASE LEAVE ALL FORMULAS AVAILABLE TO USE FOR FUTURE USE

9. Retire early or not: Plan A: Retire at age 60 Plan B: Retire at age 65 Assume you are 25 years old now and you expect to live to age 82. Also assume your salary would reach $100,000 when you are 60 and will increase by 5% annually until age 65. You expect to have a pension of 60% of your annual income at the time of your retirement. (a) Assuming an interest rate of 3.1%, what should you invest monthly to reach your goal with both Plan A and Plan B? (b) Assuming the 5% annual salary increase happens throughout your career, deter- mine your annual salary and your annual net income after making the contributions to each Plan for each of the next 10 years