Excel One structured Acty onal taxes Mary Jara ng individual who working on higher tax return to She received 116. in any She received $17.000 of dividend income She received 7,100 of income on Home Depot bant, . She received $27.000 from the sale of Disney shock that was purchased 2 years prior to the sale at a cost of $6.00 . She received $11.000 from these of Google stock that was purchased 6 months prior to the sale at a cost of $6.900 Mary receives one exemption (54,000), and she has allowable itemized deductions of $7,500. These amounts will be deducted from her gross income to determine tur table income Assume that her tax rates are based on 5. The data has been collected in the Microsoft Excel Online le below. Open the spreadsheet and perform the requred analysis tower the questi Open readsheet whats a tas Round capace What is herverage rate Round your answer to 2 capaces Personal taxes $116,000.00 Tax Table for Single Individuals Percentage on Excess over Base Taxable income Dividend Income In Income LT Stock Sale 7 LT Stock Cost ST Stock Sale 9 ST Stock Cost Personal bon 11 Home Deductions 12 Aplicable Tax Rate on Dividends & LT Capital Gans $17,000.00 $7,100.00 $2200000 96.70000 $11,000.00 $0.00 $9 225.00 $3745000 $90,750.00 $180,750.00 $411,500.00 $413200.00 Amount Pad on Base $0.00 $922 50 $515625 $16,48125 607525 $11940125 $119 996 25 15.00 25 000 2800 3300% 35009 39 08 34000.00 $7.50000 1 a Calculation of Federal Tax Lability Calculation of taxable income 16 Salary 11 orest Income ST Capital Gains 19 Income before Exercon and Deductions Personal Exmotion themed Deductions Taxable income before Dividends < Captalans Taxes on Taxable income Dafore Dividends & LT Capital Gains 25 Tax Labaty on Base of Bracket 26 Tax Liability on Excess over Base 21 Taxon Taxable income before Dividends & LT Capital Gans Taxes on Dividends & LT Capital Gans 30 Dividend Income 31 LT Capa Gain Income TDI Can in Excel template - Saved H e t Data Review View Help Tell me what you want to do Currency Conditional Format icomat Painter BIUR A Number ST Stock Sale ST Sack Cost Personal Exemption hamed Deductions 13 Aplicable Tax Rate on Dividends & LT Capital Gains $11,000.00 $690000 $4.000.00 $7,500.00 15.00% $90.750.00 $189,750.00 $411,500.00 $413.200.00 $18.481.25 $46075 25 $119.40125 $119.996.25 28.00% 33.00% 35.00% 19180 Formula 14 a. Calculation of Federal Tax Liability Calculation of Taxable income 16 Salary 17 arest Income 1ST C Gains 19 Income before Exemption and Deductions Personal Evembon ad Deductions 22 Table Income before Dividends & LT Capital Gains UNA ANA DINA UNA 24 Tures on Terable income Before Dividends & LT Cape Gains Tax Layon Base of Bracket To y on Ecossover Base 27 xonale Income before Dividends LT Capa Gans 2 Tarson Dividends LT Capital ans Didend income LT C lans Income Total Dund LT Catalans income 3 The on Dividends & LT Capital Gains income NA INA INA NA 5. Calculation of Marginal Tax Rate INA Calculation et Average Tax Rate Sheet Excel One structured Acty onal taxes Mary Jara ng individual who working on higher tax return to She received 116. in any She received $17.000 of dividend income She received 7,100 of income on Home Depot bant, . She received $27.000 from the sale of Disney shock that was purchased 2 years prior to the sale at a cost of $6.00 . She received $11.000 from these of Google stock that was purchased 6 months prior to the sale at a cost of $6.900 Mary receives one exemption (54,000), and she has allowable itemized deductions of $7,500. These amounts will be deducted from her gross income to determine tur table income Assume that her tax rates are based on 5. The data has been collected in the Microsoft Excel Online le below. Open the spreadsheet and perform the requred analysis tower the questi Open readsheet whats a tas Round capace What is herverage rate Round your answer to 2 capaces Personal taxes $116,000.00 Tax Table for Single Individuals Percentage on Excess over Base Taxable income Dividend Income In Income LT Stock Sale 7 LT Stock Cost ST Stock Sale 9 ST Stock Cost Personal bon 11 Home Deductions 12 Aplicable Tax Rate on Dividends & LT Capital Gans $17,000.00 $7,100.00 $2200000 96.70000 $11,000.00 $0.00 $9 225.00 $3745000 $90,750.00 $180,750.00 $411,500.00 $413200.00 Amount Pad on Base $0.00 $922 50 $515625 $16,48125 607525 $11940125 $119 996 25 15.00 25 000 2800 3300% 35009 39 08 34000.00 $7.50000 1 a Calculation of Federal Tax Lability Calculation of taxable income 16 Salary 11 orest Income ST Capital Gains 19 Income before Exercon and Deductions Personal Exmotion themed Deductions Taxable income before Dividends < Captalans Taxes on Taxable income Dafore Dividends & LT Capital Gains 25 Tax Labaty on Base of Bracket 26 Tax Liability on Excess over Base 21 Taxon Taxable income before Dividends & LT Capital Gans Taxes on Dividends & LT Capital Gans 30 Dividend Income 31 LT Capa Gain Income TDI Can in Excel template - Saved H e t Data Review View Help Tell me what you want to do Currency Conditional Format icomat Painter BIUR A Number ST Stock Sale ST Sack Cost Personal Exemption hamed Deductions 13 Aplicable Tax Rate on Dividends & LT Capital Gains $11,000.00 $690000 $4.000.00 $7,500.00 15.00% $90.750.00 $189,750.00 $411,500.00 $413.200.00 $18.481.25 $46075 25 $119.40125 $119.996.25 28.00% 33.00% 35.00% 19180 Formula 14 a. Calculation of Federal Tax Liability Calculation of Taxable income 16 Salary 17 arest Income 1ST C Gains 19 Income before Exemption and Deductions Personal Evembon ad Deductions 22 Table Income before Dividends & LT Capital Gains UNA ANA DINA UNA 24 Tures on Terable income Before Dividends & LT Cape Gains Tax Layon Base of Bracket To y on Ecossover Base 27 xonale Income before Dividends LT Capa Gans 2 Tarson Dividends LT Capital ans Didend income LT C lans Income Total Dund LT Catalans income 3 The on Dividends & LT Capital Gains income NA INA INA NA 5. Calculation of Marginal Tax Rate INA Calculation et Average Tax Rate Sheet