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:
Assume that her tax rates are based on Table 3.5. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.
Open spreadsheet
What is Mary's federal tax liability? Round your answer to the nearest cent. Do not round intermediate calculations.
$
What is her marginal tax rate? Round your answer to 1 decimal place.
%
What is her average tax rate? Round your answer to 2 decimal places.
%
Mary's federal tax liability | |
Salary | 103000 |
Dividend Income | 0 |
Interest income. | 5200 |
Capital Gain | |
Disney Stock | 14600 |
Google Stock | 8500 |
Taxable Income | 131300 |
Deduction | 11500 |
Net Taxable | 119800 |
Tax Liablity | 27068 |
Her Marginal Tax rate is: | |
Upto 84200 | 22% |
84200-160725 | 24% |
Average Tax Rate | |
Taxable Income | 119800 |
Tax liablity | 27068 |
Avg | 22.59 |
Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on...
EST Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on filing her tax the previous year. She has assembled the following relevant information She received $109,000 in salary. She received $14,500 of dividend income . She received $3,300 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 $6,600. She received $11,500 from the...
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 $131,000 in salary. • She received $12.500 of dividend income. • She received $6.200 of interest income on Home Depot bonds. • She received $21.000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $5.300. •...
INDTAP Search this course . ty Personal taxes 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 th • She received $106,000 in salary. • She received $19,500 of dividend Income. • She received $8,400 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...
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 $126,000 in salary. • She received $14,500 of dividend income. • She received $6,300 of interest income on Home Depot bonds. • She received $21,000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $5,600. •...
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 $94,000 in salary. • She received $17,000 of dividend Income. • She received $4,800 of interest income on Home Depot bonds. • She received $21,000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $5,200. •...
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 $124,000 in salary. • She received $19,000 of dividend income. • She received $4,900 of interest income on Home Depot bonds. • She received $21,000 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $6,300. •...
Excel Online Structured Activity: Personal taxes Mary Jarvis iš a single individual who is working on filing her tax return for the previous year. She has assembled the following relevant information: . She received $73,000 in salary. .She received $16,500 of dividend income. .She received $4,400 of interest income on Home Depot bonds. .She received $23,000 from the sale of Disney stock that was purchased 2 years prior the sale at a cost of $5,300. .She received $14,000 from the...
need help ? 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 $139,000 in salary. • She received $14,000 of dividend income. . She received $3,500 of interest income on Home Depot bonds. . She received $21,500 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $6,900. . She received $12,000 from...
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 $115,000 in salary. She received $14,500 of dividend income. She received $5,800 of interest income on Home Depot bonds. She received $23,500 from the sale of Disney stock that was purchased 2 years prior to the sale at a cost of $6,400. She received $10,500 from the sale of Google stock that was...
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 $90,000 in salary. • She received $11,000 of dividend income. She received $6,200 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,300. She received $10,500 from the sale of Google stock that...