1) Name your first scenario "Retire Early/Stay" with these values: R, R, R, R, R, R, Y2) Name your 2nd scenario "Retire Early/Move" with these values R, R, R, R, R, R, N3) Name your 3rd scenario "Delay/Stay" with these values W, W, W, R, R, R, Y4) Name your 4th scenario "Delay/Move" with these values W, W, W, R, R, R, N5) Format the spreadsheet to look like the following figures (make sure the change the labels to match the new column A heading (i.e. Retire or Work, 2008?). Delete the current values column, blank column and blank row like you did for projects 8 and 9.

Your parents decision to retire CONSTANTS SALARY INCREASE FACTOR PART TIME WAGES EXPECTED BUY OUT AMOUNT COST OF LIVING (NOT RETIRED) HOME OWNERS DUES INPUTS RETIRED [R] or WORKING [W] STAY IN HOME? [Y] OR [N] SUMMARY OF KEY RESULTS END-OF-THE-YEAR CASH ON HAND CALCULATIONS TAX RATE COST OF LIVING YEARLY SALARY OR WAGES HOME OWNERS DUES PAID INCOME STATEMENT AND CASH FLOW STATEMENT BEGINNING-OF-THE-YEAR CASH ON HAND SALARY OR WAGES BUY OUT INCOME TOTAL CASH INFLOW HOME OWNERS DUES PAID COST OF LIVING TOTAL COSTS INCOME BEFORE TAXES INCOME TAX EXPENSE NET INCOME AFTER TAXES END-OF-THE-YEAR CASH ON HAND (BEGINNING-OF-THE- YEAR CASH, PLUS NET INCOME AFTER TAXES) 2007 2007 NA 2007 2007 80000 2007 NA NA 30000 2008 0.03 10000 30000 0.03 0.02 10200 10500 25000 20000 41000 42000 43000 12000 13000 14000 2008 W Y 2008 50580 2008 2009 2008 2009 W NA 2009 50580 71490 0.3 0.3 41000 42000 82400 84872 12000 13000 2009 2009 30000 50580 2010 71490 2010 W 2010 92189 2010 0.3 43000 86569 14000 2010 71490 82400 84872 86569 0 0 0 82400 84872 86569 12000 14000 13000 41000 42000 43000 53000 55000 29400 29872 8962 20580 20910 8820 2011 92189 0.02 10800 15000 44000 15000 2011 R 2011 73989 2011 2011 2012 0.01 11400 5000 45000 16000 10800 15000 25800 2012 R 73989 2012 0.15 29000 10800 15000 16000 44389 2012 0.15 30000 11400 11400 5000 16400 15000 16000 29000 30000 57000 44000 46000 -29600 29569 -18200 8871 0 20699 -18200 -29600 0 92189 73989 2012 44389 2013 0.01 12000 0 46000 17000 2013 R 2013 8389 2013 0.15 31000 12000 17000 2013 44389 12000 0 12000 17000- 31000 48000 -36000 0 -36000 8389