please help!

til Harys get for the h00 .000 Sheet She 40th the . Show 16000 the who mil =97813379110 GEMINDTAP e Activity: Personal taxes Pidy JOIVIS 15 d sunyie Huiviuudi WHO IS WUIHY Utier Lax LUETTU epitvius year. Held as She received $131,000 in salary. . She received $10,000 of dividend income. She received $8,400 of interest income on Home Depot bonds. She received $24,500 from the sale of Disney stock that was purchased 2 years prior to the sale a She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale Mary receives one exemption ($4,000), and she has allowable itemized deductions of $7,500. Thes Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Onli questions below. Open spreadsheet a. What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermedia $ 38543.25 b. What is her marginal tax rate? Round your answer to 1 decimal place. 28 % c. What is her average tax rate? Round your answer to 2 decimal places. 23.75 % Check My Work Reset Problem D E sonal taxes ary Tax Table for Single Individuals Taxable income dend Income rest Income Stock Sale Stock Cost Stock Sale Stock Cost sonal Exemption ized Deductions cable Tax Rate on Dividends & LT Capital Gains $10,000.00 $8.400.00 $24.500.00 $5.400.00 $10,000.00 $4 600.00 $4,000.00 $7,500.00 15.00% Percentage Amount Paid on Excess on Base over Base $0.00 50.00 1000 $9 225.00 5922.50 15.00% $37.450.00 $5,156 25 25.00% $90.750 00 $18.48125 28 004 $189.750 00 $-46.075.25 33 00 $411 500.00 $119.40125 35.00% $413 200.00 $119,996 25 390 Calculation of Federal Tax Liability ulation of Thxable income ary rest Incomo Capital Gains come before Exemption and Doductions. Sonal Exemption ozod Doductions axable income before Dividends & LT Capital Gains as on Taxable income Before Dividends & LT Capital Gains Liability on Base of Bracket Liability on Excess over Base Kon Taxable income before Dividends & LI Capital Gains Formulas MNA UNA ANA ANA ANA NA ANA ENA INA Sheet1 + on Mode Automatic Workbook Statistics Type here to sear layo 34 ridiy JAI VIS IS a Single Huiviuudi WHO IS WIKING UIT HET e la ICUT TUY LIVE previous year. One has as She received $131,000 in salary. She received $10,000 of dividend income. She received $8,400 of interest income on Home Depot bonds. She received $24,500 from the sale of Disney stock that was purchased 2 years prior to the sale a She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale Mary receives one exemption ($4,000), and she has allowable itemized deductions of $7,500. The Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Onli questions below. X Open spreadsheet a. What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermedia $ 38543.25 X b. What is her marginal tax rate? Round your answer to 1 decimal place. 28 % c. What is her average tax rate? Round your answer to 2 decimal places. 23.75 % Check My Work Reset Problem D sonal taxes ary Tax Table for Single Individuals Taxable income dend Income rest Income Stock Sale Stock Cost Stock Sale Stock Cost Sonal Exemption 2 ized Deductions cable Tax Rate on Dividends & LT Capital Gains $10,000.00 $8.400.00 $24 500.00 $5 400.00 $10.000.00 $4,800.00 54,000.00 $7,500.00 15.00% Percentage Amount Paid on ESS on Base over Base $0.00 $0.00 10:00 $9 225.00 $922.50 15.00% $37,450.00 $5,156 25 225 00 $90.750 00 $18.481.25 28 00 $189.750 00 $-46 07525 33 009 $611 500.00 $119.40125 35.0096 $413 200.00 $119,996 25 39 80% Calculation of Federal Tax Liability ulation of Taxable income ary Test Incomo Capital Gains come before Exemption and Deductions sonal Exemption zod Doductions axable income before Dividends & LT Capital Gains is on Taxablo Income Before Dividends & LT Capital Gains Liability on Base of Bracket Liability on Excess over Base con Taxable income before Dividends & LT Capital Gains Formules ANA ANA ANA ANA ANA ANA ANA NA ENIA Sheet1 + on Mode: Automatic Workbook Statistics Type here to searc bayo Excel Online Structured Activity: Personales Mary larvis is a single individual who is working on ting her tax return for the previous year. She has assembled the following relevant information . She received $131,000 in salary She received $10,000 of dividend income . She received $8,400 of interest income on Home Depot bonds She received $24,500 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $5,400 She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale at a cost of $4,600 Mary receives one emption (54,000), and she has allowable itemized deductions of $7,500. These amounts will be deducted from her gross income to determine her table incom Assume that her tax rates are based on tablets. The data has been collected in the Merosoft Excel Online Mebelow. Open the spreadsheet and perform the end analysis to answer the Question below De What Hary's federal tax by found your answer to the nearest cent. Do not found intermediate cakulation What is hermal tax rate? Hound your answer to 1 decimal place What is her avere takrate Hound your answer to 2 decimal places til Harys get for the h00 .000 Sheet She 40th the . Show 16000 the who mil =97813379110 GEMINDTAP e Activity: Personal taxes Pidy JOIVIS 15 d sunyie Huiviuudi WHO IS WUIHY Utier Lax LUETTU epitvius year. Held as She received $131,000 in salary. . She received $10,000 of dividend income. She received $8,400 of interest income on Home Depot bonds. She received $24,500 from the sale of Disney stock that was purchased 2 years prior to the sale a She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale Mary receives one exemption ($4,000), and she has allowable itemized deductions of $7,500. Thes Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Onli questions below. Open spreadsheet a. What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermedia $ 38543.25 b. What is her marginal tax rate? Round your answer to 1 decimal place. 28 % c. What is her average tax rate? Round your answer to 2 decimal places. 23.75 % Check My Work Reset Problem D E sonal taxes ary Tax Table for Single Individuals Taxable income dend Income rest Income Stock Sale Stock Cost Stock Sale Stock Cost sonal Exemption ized Deductions cable Tax Rate on Dividends & LT Capital Gains $10,000.00 $8.400.00 $24.500.00 $5.400.00 $10,000.00 $4 600.00 $4,000.00 $7,500.00 15.00% Percentage Amount Paid on Excess on Base over Base $0.00 50.00 1000 $9 225.00 5922.50 15.00% $37.450.00 $5,156 25 25.00% $90.750 00 $18.48125 28 004 $189.750 00 $-46.075.25 33 00 $411 500.00 $119.40125 35.00% $413 200.00 $119,996 25 390 Calculation of Federal Tax Liability ulation of Thxable income ary rest Incomo Capital Gains come before Exemption and Doductions. Sonal Exemption ozod Doductions axable income before Dividends & LT Capital Gains as on Taxable income Before Dividends & LT Capital Gains Liability on Base of Bracket Liability on Excess over Base Kon Taxable income before Dividends & LI Capital Gains Formulas MNA UNA ANA ANA ANA NA ANA ENA INA Sheet1 + on Mode Automatic Workbook Statistics Type here to sear layo 34 ridiy JAI VIS IS a Single Huiviuudi WHO IS WIKING UIT HET e la ICUT TUY LIVE previous year. One has as She received $131,000 in salary. She received $10,000 of dividend income. She received $8,400 of interest income on Home Depot bonds. She received $24,500 from the sale of Disney stock that was purchased 2 years prior to the sale a She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale Mary receives one exemption ($4,000), and she has allowable itemized deductions of $7,500. The Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Onli questions below. X Open spreadsheet a. What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermedia $ 38543.25 X b. What is her marginal tax rate? Round your answer to 1 decimal place. 28 % c. What is her average tax rate? Round your answer to 2 decimal places. 23.75 % Check My Work Reset Problem D sonal taxes ary Tax Table for Single Individuals Taxable income dend Income rest Income Stock Sale Stock Cost Stock Sale Stock Cost Sonal Exemption 2 ized Deductions cable Tax Rate on Dividends & LT Capital Gains $10,000.00 $8.400.00 $24 500.00 $5 400.00 $10.000.00 $4,800.00 54,000.00 $7,500.00 15.00% Percentage Amount Paid on ESS on Base over Base $0.00 $0.00 10:00 $9 225.00 $922.50 15.00% $37,450.00 $5,156 25 225 00 $90.750 00 $18.481.25 28 00 $189.750 00 $-46 07525 33 009 $611 500.00 $119.40125 35.0096 $413 200.00 $119,996 25 39 80% Calculation of Federal Tax Liability ulation of Taxable income ary Test Incomo Capital Gains come before Exemption and Deductions sonal Exemption zod Doductions axable income before Dividends & LT Capital Gains is on Taxablo Income Before Dividends & LT Capital Gains Liability on Base of Bracket Liability on Excess over Base con Taxable income before Dividends & LT Capital Gains Formules ANA ANA ANA ANA ANA ANA ANA NA ENIA Sheet1 + on Mode: Automatic Workbook Statistics Type here to searc bayo Excel Online Structured Activity: Personales Mary larvis is a single individual who is working on ting her tax return for the previous year. She has assembled the following relevant information . She received $131,000 in salary She received $10,000 of dividend income . She received $8,400 of interest income on Home Depot bonds She received $24,500 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $5,400 She received $10,000 from the sale of Google stock that was purchased 6 months prior to the sale at a cost of $4,600 Mary receives one emption (54,000), and she has allowable itemized deductions of $7,500. These amounts will be deducted from her gross income to determine her table incom Assume that her tax rates are based on tablets. The data has been collected in the Merosoft Excel Online Mebelow. Open the spreadsheet and perform the end analysis to answer the Question below De What Hary's federal tax by found your answer to the nearest cent. Do not found intermediate cakulation What is hermal tax rate? Hound your answer to 1 decimal place What is her avere takrate Hound your answer to 2 decimal places