Sgt. Barnes is a veteran police officer filing as Head of Household. Currently, her taxable income is $50,000, but has been asked to sit for the Leutenant's exam. She is excited about the opportunity as the pay raise will give her an additional $15,000 of taxable income. Sgt. Barnes would like to know what the tax implication will be with the promotion and raise. Sgt. Barnes also moonlights as a private security guard for major sporting events and is concerned the promotion and raise will have an adverse impact on her marginal tax rate. Required: 1. Complete the "The tax is:" column for each filing status table using a formula. 2. Prepare the Current Salary and Proposed Salary tax calculations using VLOOKUP formulas to the 2022 tax brackets. 3. Enter a formula to coupute the Marginal Tax Rate (Hint: ATax/ATaxable Income) Schedule Z-Head of Household $ SS $ If taxable income is over: 14,650.00 $ But not over: The tax is: Plus: $ 14,650.00 $ 10% 55,900.00 $ 1,465.00 12% $ sssssss 55,900.00 $ 89,050.00 6,415.00 22% $ 89,050.00 $ 170,050.00 13,708.00 24% $ 170,050.00 $ 215,950.00 33,148.00 32% $ 215,950.00 $ 539,900.00 47,836.00 35% $ 539,900.00 $ $ 161,218.50 37% Taxable Income: If taxable income is over: But not over: The tax is: Plus tax percentage: Plus tax amount: Total Tax: Current Salary Proposed Salary $ 50,000 $ 65,000 14,650 $ 55,900 55,900 $ 89,050 1,465 $ 6,415 12% 22% 4,242 $ 2,002 5,707 $ 8,417 Marginal Tax Rate: 18.07%