1 answer

Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on...

Question:

Excel Online Structured Activity: Personal taxes Mary Jarvis is a single individual who is working on filing her tax return f
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. • She received $13,000 from the sale of Google stock that was purchased 6 months prior to the sale at a cost of 54.900. Mary receives one exemption ($4.000), and she has allowable itemized deductions of $7.500. These amounts will be deducted from her gross income to determine taxable income. Assume that her tax rates are based on Table 3.3. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required answer the questions below. to X1 Open spreadsheet 3. What is Mary's Federal tax liability Round your answer to the nearest cont. 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.

Answers

$ 18,481.95 $ 6,930 1 $ 25,411.25 * Taxes on Dividends and love Terms Capital Gains. → Dividend Income = $13.000 → LT Capital35,441.26 4,995 1 30,406 • 95 Calculation of moosgirol Tar sale roosginal Vol. Pale 98% © Da © Calculation of overge Tan soleAnswer @ calculation of federal Tax Liability salary = $120,000 Interest Income = $ 4,000 * Short Term Capital Gains $ 13,000* * y Pearsal cuerption $4800 @ Itomike nadeckiong $ 71500 Poloble Income Befosse Dividende anh long terms capital Gains 143,

.

Similar Solved Questions

1 answer
Refer to the following circuit (Q1 is a generic transistor), assuming β = 200 when the...
Refer to the following circuit (Q1 is a generic transistor), assuming β = 200 when the transistor is in the active region. (a) If R1 is open, calculate VB, VE, VC. (b) If R1 is short, calculate IB, IE and VC. (c) If R2 is short, calculate IE and VC. (d) If R3 is short, calculate VB, IC, and IB....
1 answer
Reflect on the analysis of the sin of suicide and, thus, euthanasia from the topic readings....
Reflect on the analysis of the sin of suicide and, thus, euthanasia from the topic readings. Do you agree? Why or why not? Refer to the lecture and topic readings in your response...
1 answer
Learning: The Adjusting Process QUESTION ANSWER Date Credit A piece of equipment purchased cost $10,000 and...
Learning: The Adjusting Process QUESTION ANSWER Date Credit A piece of equipment purchased cost $10,000 and has depreciation expense of $2,000 for this year. Debit 2,000 Accounts Depreciation Expense - Equipment Accumulated Depreciation - Equipment 2,000 What is the journal entry to record the depre...
1 answer
The [#H^+#] in a solution is 0.01 M. What is the pH of the solution?
The [#H^+#] in a solution is 0.01 M. What is the pH of the solution?...
1 answer
Pt) Consider the function f: R (-co, -6) defined by fu) 3 -9 еxp(Зх + 8)...
pt) Consider the function f: R (-co, -6) defined by fu) 3 -9 еxp(Зх + 8) — 6. The inverse of f is given by the formula: f(x)=...
1 answer
Consider how Jones Valley Brook Park Lodge could use capital budgeting to decide whether the $11,500,000...
Consider how Jones Valley Brook Park Lodge could use capital budgeting to decide whether the $11,500,000 Brook Park Lodge expansion would be a good investment. Assume Jones Valley's managers developed the following estimates concerning the expansion: (Click the icon to view the estimates.) Click...
1 answer
Create a problem statement for the Prevention of Fraud. You should refine and thoroughly discuss the...
Create a problem statement for the Prevention of Fraud. You should refine and thoroughly discuss the topic problem. It should be one page long....
1 answer
Unit Goals: To Gain a Working Understanding of these Basic concepts; a-What is health? b-Wellness vs. disease model of h...
Unit Goals: To Gain a Working Understanding of these Basic concepts; a-What is health? b-Wellness vs. disease model of health. c-What is your personal definition of health? d-What cultural definition/s of health are prevalent? e-What is the physical foundation of health? f-What is the psychological ...
1 answer
7. + -/12.5 points ZinPhysLS3 11.P.016. RMy Notes Ask Your Teacher To lift a wire ring...
7. + -/12.5 points ZinPhysLS3 11.P.016. RMy Notes Ask Your Teacher To lift a wire ring of radius 2.65 cm from the surface of a container of blood plasma, a vertical force of 2.20 x 10-2 N greater than the weight of the ring is required. Calculate (in N/m) the surface tension of blood plasma from thi...
1 answer
Need Hongren Accounting 10th edition Problem P12-27A solutionnch On October 1, 2014, Edwards, French, and Gill...
Need Hongren Accounting 10th edition Problem P12-27A solutionnch On October 1, 2014, Edwards, French, and Gill formed the E, F, G partnership. Edwards contributed $21,000; French, $35,000; and Gill, $44,000, Edwards will manage the store; French will work in the store three- quarters of the time and...
1 answer
Prepaid expenses are: incurred and already paid or recorded. O paid and recorded in an asset...
Prepaid expenses are: incurred and already paid or recorded. O paid and recorded in an asset account after they are used or consumed. O incurred but not yet paid or recorded. O paid and recorded in an asset account before they are used or consumed....
1 answer
I apologies because they are 4 questions, but I cannot split them cause they are related....
I apologies because they are 4 questions, but I cannot split them cause they are related. So hope somebody help me with them. Ozone Formation: NO2(g), is formed by chemical reactions involving N2(g) and O2(g) at the high temperatures Inside internal combustion engines in our cars. In the presence o...
1 answer
Write a C++ program and algorithm to create a class of fraction having variables numerator and...
Write a C++ program and algorithm to create a class of fraction having variables numerator and denominator, and member functions setting and getting values of the fractions. Also create a static member variable of the class having fraction value tolerance of 0.1. Instantiate 10 fraction objects and ...
1 answer
9. Physician order reads: Administer 20,000 Units of Heparin subcutaneous injection once a day. The pharmacy...
9. Physician order reads: Administer 20,000 Units of Heparin subcutaneous injection once a day. The pharmacy provides Heparin 8,000 Units in 1 ml solution. How many milliliters with the nurse administer?...
1 answer
(1 point) An aerospace company has submitted bids on two separate federal government defense contracts. The...
(1 point) An aerospace company has submitted bids on two separate federal government defense contracts. The company president believes that there is a 36% probability of winning the first contract. If they win the first contract, the probability of winning the second is 65%. However, if they lose th...
1 answer
What is the derivative of #pi#?
What is the derivative of #pi#?...
1 answer
PA P world Tariff $20 $14 P world Quota . D (Thousands) 20 25 35 40...
PA P world Tariff $20 $14 P world Quota . D (Thousands) 20 25 35 40 Answer the questions below based upon the above diagram. Note that Q is measured in 1,000s. a. With free trade, what is the total value ($) of imports? b. If the government imposes a tariff, derive the change in consumer surplus and...
1 answer
Considering that the majority of operating room managers and directors do not function in a patient...
Considering that the majority of operating room managers and directors do not function in a patient care or clinical role, is it necessary to require such leaders to be registered nurses? In your opinion, what might be the advantage of hiring a surgical technologist with management and organizationa...
1 answer
2. Expand f(x)svā sill o<x<2π in a Fourier series. [15] [15] 2. Expand f(x)svā sill o
2. Expand f(x)svā sill o<x<2π in a Fourier series. [15] [15] 2. Expand f(x)svā sill o...
1 answer
Question 1 (12 points) You are writing a shopping list app that calculates how many groceries...
Question 1 (12 points) You are writing a shopping list app that calculates how many groceries to buy given the size of a family Define a function called totalEggs that takes one input parameter representing the number of people in the family and prints out the total number of eses to buy. Assume eac...