Mary Jarvis is a single individual who is working on fling her tax return for the previous year. She has assembled the following relevant information: . She received $77,000 in salary She received $13,500 of dividend income. . She received $4,200 of interest income on Home Depot bonds She received $25,000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $5,300 She received 39,000 from the sale of Google stock that was purchased 6 months prior to the sale at a cost of $6,200. Mary receives one exemption ($4,000), and she has allowable itemized deduction of $7,500. These amounts will be deducted from her gross income to determine her taxable income Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Online ple below Open the spreadsheet und perform the required analysis answer the questions below Open spreadsheet 2. What is Mary's federal tax liability Round your answer to the nearest cont. Do not round Intermediate calculations 103,050 b. What is her marginal tax rate? Round your answer to 1 decimal place 25 What is her average tax rate Round your answer to 2 decimal places c Taxable income E Amount Pas on Excess on Bas Over Bato $0.00 30.00 10.00% 19.225.00 592250 15.00% $37.450.00 55,156.25 25.00% 590,750.00 518, 481.25 20.00 $189,750.00 $46,075 25 33.00 3411 00.00 $ 119,601.25 25.00 5413,200.00 $ 119,996.25 29.805 Fomulas YA ANTA NA NA NA 4 Dlyan income 513,500.00 5 Interestingu 34,200.00 5 LT Stock Sale $25,000.00 LT Stock Cost $5,300.00 3 ST Stock Sale 99.000.00 9 ST Stock Cout 50.200.00 10 Pomonal Examen 34.000.00 11 tamaad Deductions 37.500.00 12 Aplicatii Tax Rate on Oldende ALT Captain 15.00 13 14 Canon of Federal Terbiy 15 Calculation of Taxable incom! 16 Say 12 interest income 18 ST Capital 19 Income before Enamon and Deductions 20 Personal Exampion 21 amd Deductions Taxable income before Odondo LT Captal Gaina 23 24 Taas on ahle menneet LT Cancer Gant 25 Thuyn an of art Ht 26 Tax Ubon Wovere 27 Tax on Turabia income before donds LT Capital Oaha 20 22 Tame an Dividers & LT Capital Care 30 Dividend income 31 LT Capital Gains income 32 Total Didend & LT Capi Gane income 3 Taxon Dividends & Capital gains income 34 35 Total Federal Tux Lilly 30 37 Calculation of Murpinal Tax Plata 3 Marginal Tax Rule 39 40. Calculation of Average Tax Rate wage Tax Rate 42 NA NA WA NA INA NA NA NA NA MA 44 45 46 40 39 50 51