I just need these formulas for Excel.

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.

9) Save your work!

`

10) Create the scenario as described below.

11) Your changing cells for all scenarios are: C10 to H10 and C11, the result cell is H14

12) Name your first scenario "Retire Early/Stay" with these values: R, R, R, R, R, R, Y

13) Name your 2nd scenario "Retire Early/Move" with these values R, R, R, R, R, R, N

14) Name your 3rd scenario "Delay/Stay" with these values W, W, W, R, R, R, Y

15) Name your 4th scenario "Delay/Move" with these values W, W, W, R, R, R, N