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.
%
A . Summary of Introduction:-
To determine the federal tax liability.
1)Personal Taxes: The personal taxes refer to those taxes which an individual has to pay on his income. This tax is an important source of revenue and the amount of tax is used for the welfare activities of the society.
Capital Gain or Loss: Whenever security is bought or sold, there is a difference between the buy price and the selling price. If the selling price is greater than the price at which it was bought, there is a capital gain and if the buying price is more than the selling price, there is a capital loss. The capital gains are subject to tax.
Explanation of Solution
Calculation of the federal tax liability: Federal tax liability=(Tax on dividend income+Tax on long-term capital gain+Tax on other income)
Federal tax liability=($1875+$2250+$29500)=$33895
Working note: The calculation of taxable income: : | ||
1. Income from salary is $125000. | 125000 | |
Income from investment includes | ||
2. Dividend received is $12,500 | 12500 | 1875 |
3. Stock purchased is $5200. So, the capital gain is $16800 ($22000−$5200) . | 16800 | 2520 |
DShe received $7,200 of interest income on Home Depot bonds. | 7200 | |
As the stock is held more than one year, as it is a long-term capital gain. | ||
4. Another stock has been purchased six months back at $5600 and it is sold at $15,000. The capital gain is $9400 ($15,000−$5,600) | 9400 | |
5. The total income of the person subject to tax is $163700 ($125000+12500+16800+9400) | 170900 | |
6. As per federal guidelines, $4,000 exemption is available for the taxpayer and also for the dependents. Also, the itemized deduction will be $7,500. | 11500 | |
Total Gross Income | 159400 | |
Other Income (Salary and other) | 130100 | 18481.25 |
Tax | 39350 | 11018 |
33894.25 |
B) To Determine The marginal tax rate.
Personal Taxes: The personal taxes refer to those taxes which an individual has to pay on his income. This tax is an important source of revenue and the amount of tax is used for the welfare activities of the society. Capital Gain or Loss: Whenever security is bought or sold, there is a difference between the buy price and the selling price. If the selling price is greater than the price at which it was bought, there is a capital gain and if the buying price is more than the selling price, there is a capital loss. The capital gains are subject to tax. c. Summary Introduction
C) To determine The average tax rate. Personal Taxes: The personal taxes refer to those taxes which an individual has to pay on his income. This tax is an important source of revenue and the amount of tax is used for the welfare activities of the society. Capital Gain or Loss: Whenever security is bought or sold, there is a difference between the buy price and the selling price. If the selling price is greater than the price at which it was bought, there is a capital gain and if the buying price is more than the selling price, there is a capital loss. The capital gains are subject to tax.
Mary Jarvis is a single individual who is working on filing her tax return for the...
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: Video 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 $96,000 in salary. • She received $18,500 of dividend income. • She received $7,700 of interest income on Home Depot...
Need this ASAP Please! 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 $102,000 in salary. • She received $17,500 of dividend income. • She received $7,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 $6,700. • She received...
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 $106,000 in salary • She received $15,000 of dividend income. • She received $6,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,500. • She received $9,500 from the sale...
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 $76,000 in salary. • She received $10,500 of dividend income. • She received $5,900 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 $5,300. . She received $12,500 from the sale...
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...
help please 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 $125,000 in salary. She received $15,500 of dividend income. She received $8,300 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,500. She received $9,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 $125,000 in salary. She received $15,500 of dividend income. She received $8,300 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,500. She received $9,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 $91,000 in salary. She received $18,500 of dividend income. She received $5,800 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 $6,700. She received $12,500 from the sale of Google stock that was...