Question
Video Excel Online Structured Activity: Personal taxas Mary Jarvis is a single individual who is working on filing her tax return for the previous
Video Excel Online Structured Activity: Personal taxas Mary Jarvis is a single individual who is working on filing her tax return for the previous year. She has abled the folowing relevant information She received $94,000 in salary She received $12,000 of dividend income. She received $6,200 of interest income on Home Depot bonds of $7,000 of $0,200, She received $21,000 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 por to the Mary receives one exemption ($4,000), and she has allowable nemized deductions of $7,300. These a units will be deducted from her gross income to determine her taxabis incone Assume that her tax rates are based on Table 3.3. The data has been collected in the Microsoft Excel Online fe below. Open the spreadsheet and perform the required the Doen sorsadsbeel a: What is Mary's federal tax liability? Round your answer to the nearest cunt. Do not round intermediate calculations b. What is her marginal tax rate? Round your answer to 1 decimals " e. What is her average tax rata? Round your answer to 2 decimal places
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started