# 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 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.

#### Similar Solved Questions

##### 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....
##### 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...
##### 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....
##### 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...
##### 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 ...
##### 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 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...
##### What is the derivative of pi?
What is the derivative of pi?...
##### 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...