Please help with formulas

4) Row 17 needs an IF statement, if your parents retire (a "R" in Row 10) the tax rate is: .15 otherwise if they continue working the tax rate is .30

5) Row 18 needs an IF statement, if your parents retire the cost of living is: Row 6 - 15000 otherwise it is Row 6

6) Row 20 needs an IF statement, if your parents stay in their home (Cell C11 = "Y") they must pay the home association fees shown in Row 7, otherwise 0.

7) Row 23 (beginning of year cash) equals the end of the year cash for the prior year.

8) Row 32 (income tax), if your parents have a positive income before taxes (i.e. > 0), multiply their income before taxes times the tax rate in Row 17, otherwise no taxes are due if your income is negative.

Your parents decision to retire 2 CONSTANTS 2007 2008 2009 2010 3 SALARY INCREASE FACTOR NA 0.03 0.03 0.02 4 PART TIME WAGES EXPECTED NA 10000 10200 10500 5 BUY OUT AMOUNT NA 30000 25000 20000 6 COST OF LIVING (NOT RETIRED) 41000 42000 43000 7 HOME ASSOCIATION DUES NA 12000 13000 14000 2013 0.01 12000 2011 0.02 10800 15000 44000 15000 2012 0.01 11400 5000 45000 16000 NA 46000 17000 2009 2011 2012 2013 9 INPUTS 10 RETIRED [R] or WORKING [W] 11 STAY IN HOME? [Y] OR [N] 2007 NA NA 2008 W Y w 2010 W NA . NA NA NA 12 2007 2008 2009 2010 2011 2012 2013 13 SUMMARY OF KEY RESULTS END-OF-THE-YEAR 14 CASH ON HAND NA 82400 84872 86569 25800 16400 12000 2007 2008 2009 2010 2011 2012 2013 NA 16 CALCULATIONS 17 TAX RATE 18 COST OF LIVING 19 YEARLY SALARY OR WAGES 20 HOME ASSOCIATION DUES NA 80000 NA 8240084872 86569 10800 11400 12000 21 2007 2008 2009 2010 2011 2012 2013 INCOME STATEMENT AND 22 CASH FLOW STATEMENT BEGINNING-OF-THE-YEAR 23 CASH ON HAND NA 82400 84872 86569 12000 10800 15000 25800 11400 5000 16400 82400 84872 86569 12000 0 0 0 25 SALARY OR WAGES NA 26 BUY OUT INCOME NA 27 TOTAL CASH INFLOW NA 28 HOME ASSOCIATION DUES NA 29 COST OF LIVING NA 30 TOTAL COSTS NA 31 INCOME BEFORE TAXES NA 32 INCOME TAX EXPENSE NA Instructions Sheet1 Sheet2 0 82400 84872 86569 25800 16400 12000 + Solart dortination and press ENTER or chance Daste