Anancial advisor oers many types of advice to customers; they will invest as much as tax deferred retirement plans. The tax rate is 15% for income and investment is tax exempt. The following formulae can he used to have the desired result: Income before tax = Salary +0utstanding Mortgage - Debt And, Net Income = Income before lax tax Firstly. in cell H2, calculate the income before tax and then drag the cursor to copy the formula for all couples. In this situation. the tax rate is 15% of income. The screenshot is shown below: '_ H2 - .f" :- kmoiez ' a _ A _ I 1 c ' D ' E ' F ' 6 H 1 Couple children Salary Mortgage Debt Invested Ta: salary befote tax 2 1 2 95920 87300 6230 6.0% 26554.5 177030 3 2 3 9\" 105320 15200 9.995 20089.5 189930 0 3 1 819\" 35720 2030 9.0% 17303.5 115630 i a 2 10310 73610 13450 3095 20329.5 135530 L 5 1 17430 sea-o 5230 15.095 1.9110 12m 7 6 4 55090 noon 11200 0.0% 20077.5 173850 3 1 2 39730 99600 11520 4.3% 26671.5 111310 9 8 2 53330 05320 mean 2.9" 19953 133020 10 9 3 50730 102220 11740 0.095 21181.5 141210 11 10 3 65160 113050 19380 9.5% 24063.5 160330 12 11 0 101320 75250 9140 9.7% 25189.5 167930 13 12 2 33310 39030 3260 3.695 12733.5 33390 13 13 2 44690 17m 93m 9.3% 12335.5 32570 15 14 2 76120 35650 9110 M 15300 102000 16 15 3 32120 65550 10500 7.595 13377 31130 17 _ 16 2 110950 120710 16970 15.096 32203.5 210690