Consider the following information:

You will work for (maybe) 45 years and, then, retire.

You will live for an additional 25 years (more or less) after you retire.

You estimate that you will need $12,000 per month through your retirement years. (You are not absolutely sure about the amount or if you need it at the beginning or end of each month.)

You want to leave (about) $1,000,000 to your heirs upon your demise.

You expect to earn (around) 12% on your retirement fund during your working years and (at least) 2% after you retire.

You want to take an around-the-world cruise 1 year before you retire. Based on current prices and estimated inflation, the cruise for you and your travelling companion will cost (at least) $40,000.

In the worksheet labeled Retirement, construct a dynamic spreadsheet that incorporates the items listed above and allows for easy modifications of the inputs. Your output (clearly identified and labeled) should be the monthly savings required to meet your goals.

For this project, consider only the information and conditions provided. When constructing your worksheets, remember to consider economy and aesthetics. Your worksheets should be labeled so that an informed reader could open any worksheet and understand its purpose, inputs and outputs.