Clipboard Font Alignment Number B C D F G H pts. Build a model which - for a given taxable income - will provide (1) the marginal tax rate and (2) the TOTAL tax due. Please make sure that the model works for any income, including loss (negative income) and any correct set of tax brackets. Taxable income: $ Marginal Rate Total tax due: 150,000.00 0.24 #SPILLI Must work for any positive (c.6, S100,000.00), negative leg. $1,000.00) or zero (50.00) taxable income The output must be numeric, e.g. 0.00%, 10.00% Strings such as "O" or "NA" are not allowed) The output must be numerice.g. $100.00 $0.00. Strings such as "O" or "WAare not allowed) Brackets: Add a calculated bose tax (flat tox) column using data from income over and This model will be tested on different sets of input date Income over Marginal Rate Base Tax S 10.00% $ $ 10,000.00 12.00% $ 1,000.00 $ 40,000.00 22.00M $ 4,600.00 $ 85,000.00 24.00% 5 14,500.00 S 165,000.00 32.00% $ 33,700.00 $ 210,000.00 35.00% S 48,100.00 $ 520,000.00 37.00% $156,600.00 $ 1,000,000.00 39.00% $ 334,200.00 $ 2,000,000.00 42.0096 $724,200.00 Time Saving Hint: Formulas need to be developed only for the cells, the rest is 3 1 7 29 30 32 33