Excel Online Tutorial $$

Excel Online Structured Activity: Personal taxes

Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information:

She received $$97,000$ in salary.

She received $$17,000$ of dividend income.

She received $$8,500$ of interest income on Home Depot bonds.

She received $$22,500$ from the sale of Disney stock that was purchased $2$ years prior to the sale at a cost of $$5,800.$

She received $$9,500$ from the sale of Google stock that was purchased $6$ months prior to the sale at a cost of $$5,300.$ a$.$ What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermediate calculations.

$

b$.$ What is her marginal tax rate? Round your answer to $1$ decimal place.

$\%$

c$.$ What is her average tax rate? Round your answer to $2$ decimal places.

$\%$