A2 7a May I please have the answer in formula form and not excel. thx:) 7. You are making plans for your retirement. You have just turned 30 and want to retire on your 65 th birthday. Once retired,...

A2 7a

May I please have the answer in formula form and not excel. thx:)

7. You are making plans for your retirement. You have just turned 30 and want to retire on your 65^th
birthday. Once retired, you plan to move to a tax-free Caribbean state, where you believe you can live comfortably on your retirement savings. You plan to make your first withdrawal from your retirement savings when you retire at age 65 and your last withdrawal one month before your 85^th
birthday. Based on family history, you expect to live until exactly age 85.

Your plan is to have a total of $1 million when you retire. Your current salary is $36,000 per year, or $3,000 per month. Your personal tax rate is approximately 30%. You estimate that you can earn an average return of 12% APR compounded annually on any money you invest over the next 60 years. You want to start putting aside a fixed amount of money at the end of every month until your retirement at age 65. You will make your first deposit one month from now and your last deposit on your 65^th
birthday.

a. To ensure that you are able to achieve your retirement objective, what is the maximum percentage of your after-tax monthly income that you can spend?