insert Data Review Tell me what you want to do A xan Arial - 10 - AA Currency 13 Autatum Paste 29 Copy c. 9 .29 Conditional Format Formatting was able Insert Delete Format de Sert & Fin Format Painter Clipboard ang Personal taxes Salary $84,000.00 Tax Table for Single Individuals: Taxable income Dividend Income Interest Income ILT Stock Sale ILT Stock Cont ST Stock Sale ST Stock Cost Personal Exemption termined Deductions Aplicable Tax Rate on Dividends & LT Capital Gains $13,000.00 $8,700.00 $21.500.00 $5.500.00 $14.000.00 $5.200.00 $4.000.00 $7 500 00 15.00% $0.00 $9,225.00 $37 450.00 $90.750.00 $189.750.00 S411,500.00 $413.200.00 Amount Paid on Base 3000 $022.50 $5,156.25 $18.481 25 46 07525 $11940125 $119.000 25 Percentage on Excess Over Base 10.00% 1500 25.00 28.00 30.00% 35.00% 39.60 Formins MNA 1. Calculation of Federal Tax Liability Calculation of Taxable income: Salary Interest Income ST Capital Gains Income before Exemption and Deductions Data Review View Help Tell me what you want to do Arial Home Insert X Out CE Copy Format Painter Clipboard 10 BIUR ab - A A A. Currency - $ % 868 Conditional Format Formatting -as Table Insert Delete Formato Personal Exemption Iternized Deductions Taxable income before Dividends & LT Capital Gains INTA WNA ENA NA Taxes on Taxable income Before Dividends & LT Capital Gains: Tax Liability on Base of Bracket Tax Liability on Excess over Base Tax on Taxable income before Dividends & LT Capital Gains NA NA Taxes on Dividends & LT Capital Gains: Dividend Income LT Capital Gains Income Total Dividend & LT Capital Gains Income Tax on Dividends & LT Capital Gains Income #N/A NIA WNIA NIA Total Federal Tax Liability b. Calculation of Marginal Tax Rate Marginal Tax Rate c. Calculation of Average Tax Rate Average Tax Rate Sheet1 Maps insert Data Review Tell me what you want to do A xan Arial - 10 - AA Currency 13 Autatum Paste 29 Copy c. 9 .29 Conditional Format Formatting was able Insert Delete Format de Sert & Fin Format Painter Clipboard ang Personal taxes Salary $84,000.00 Tax Table for Single Individuals: Taxable income Dividend Income Interest Income ILT Stock Sale ILT Stock Cont ST Stock Sale ST Stock Cost Personal Exemption termined Deductions Aplicable Tax Rate on Dividends & LT Capital Gains $13,000.00 $8,700.00 $21.500.00 $5.500.00 $14.000.00 $5.200.00 $4.000.00 $7 500 00 15.00% $0.00 $9,225.00 $37 450.00 $90.750.00 $189.750.00 S411,500.00 $413.200.00 Amount Paid on Base 3000 $022.50 $5,156.25 $18.481 25 46 07525 $11940125 $119.000 25 Percentage on Excess Over Base 10.00% 1500 25.00 28.00 30.00% 35.00% 39.60 Formins MNA 1. Calculation of Federal Tax Liability Calculation of Taxable income: Salary Interest Income ST Capital Gains Income before Exemption and Deductions Data Review View Help Tell me what you want to do Arial Home Insert X Out CE Copy Format Painter Clipboard 10 BIUR ab - A A A. Currency - $ % 868 Conditional Format Formatting -as Table Insert Delete Formato Personal Exemption Iternized Deductions Taxable income before Dividends & LT Capital Gains INTA WNA ENA NA Taxes on Taxable income Before Dividends & LT Capital Gains: Tax Liability on Base of Bracket Tax Liability on Excess over Base Tax on Taxable income before Dividends & LT Capital Gains NA NA Taxes on Dividends & LT Capital Gains: Dividend Income LT Capital Gains Income Total Dividend & LT Capital Gains Income Tax on Dividends & LT Capital Gains Income #N/A NIA WNIA NIA Total Federal Tax Liability b. Calculation of Marginal Tax Rate Marginal Tax Rate c. Calculation of Average Tax Rate Average Tax Rate Sheet1 Maps