Question: Home Insert Draw Page Layout Formulas Data Review View Acrobat X Arial 10 ' abe General v Paste BI U v v MA $ %
Home Insert Draw Page Layout Formulas Data Review View Acrobat X Arial 10 ' abe General v Paste BI U v v MA $ % ) A1 v fe A B D E G H Income Tax Calculation for 2020 (Single) 1 2 3 4 5 6 7 8 9 10 11 12 Bracket Floor Bracket Ceiling Base Tax Marginal Rate $0 $9,875 $0 10% $9,875 $40,125 $988 12% $40,125 $85,525 $4,618 22% $85,525 $163,300 $14,606 24% $ 163,300 $207,350 $33,272 32% $207,350 $518,400 $47,368 35% $518,400 $999,999,999 ### 37% Taxable income Bracket Floor Base Tax Marginal Rate Margin (Taxable Income- Bracket Floor) Marginal Tax Total Tax (Base Tax (Margin x + Marginal Tax) Marginal Rate) 13 14 15 16 17 Create formulas in the yellow cells to compute Total Tax, given a value for Taxable income in cell B14. 18 19 on
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
