The following problems are to be completed in Excel.

Consider the following information:

You will work for 30 years and then, retire.

You will live for 34 years after you retire.

You estimate that you will need $14,000 per month through your retirement years.

You expect to earn 10% on your retirement fund during your working years and 4% after you retire.

You estimate that your salary will grow at an average annual rate of 3.6% and inflation will average 3.5% during your retirement years.

1. How much must you save in the first month of your career to meet these goals?