5. [-/1 Points] DETAILS MY NOTES CAMMBA4 3.E.007. ASK YOUR TEACHER PRACTICE ANOTHER Datafile: TaxData. The file TaxData contains information from federal tax returns filed in 2007 for all counties in the United States (3,142 counties in total). Create a PivotTable in Excel to answer the questions below. The PivotTable should have State Abbreviation as Row Labels. The Values in the PivotTable should be the sum of adjusted gross income for each state. (a) Sort the PivotTable data to display the states with the smallest sum of adjusted gross income on top and the largest on the bottom. Which state had the smallest sum of adjusted gross income? What is the total adjusted gross income for federal tax returns filed in this state with the smallest total adjusted gross income (in dollars)? (Hint: To sort data in a PivotTable in Excel, right-click any cell in the PivotTable that contains the data you want to sort, and select Sort.) ? ☑ has the smallest sum of adjust gross income with $ (b) Add the County Name to the Row Labels in the PivotTable. Sort the County Names by Sum of Adjusted Gross Income with the lowest values on the top and the highest values on the bottom. Filter the Row Labels so that only the state of Texas is displayed. Which county had the smallest sum of adjusted gross income in the state of Texas? The county that had the smallest sum of adjusted gross income in the state of Texas is ? Which county had the largest sum of adjusted gross income in the state of Texas? The county that had the largest sum of adjusted gross income in the state of Texas ? (c) Click on Sum of Adjusted Gross Income in the Values area of the PivotTable in Excel. Click Value Field Settings.... Click the tab for Show Values As. In the Show values as box, select % of Parent Row Total. Click OK. This displays the adjusted gross income reported by each county as a percentage of the total state adjusted gross income. Which county has the highest percentage adjusted gross income in the state of Texas? What is this percentage? (Round your answer to two decimal places.) ? ☑ has the highest percentage of adjusted gross income in Texas at %. (d) Remove the filter on the Row Labels to display data for all states. What percentage of total adjusted gross income in the United States was provided by the state of California? (Round your answer to two decimal places.) % Need Help? Submit Answer Read It Watch It Home My Assignments + Request Extension

As a newly hired IRS trainee, you have been asked to calculate the amount of tax refund or tax owed for the taxpayer (in $). (Enter a positive value for the amount.) Other Refund/Owe (Select one) Tax Таx Name Payments Amount Liability Credits Taxes Trent $6,898 $1,331 $775 $7,700 ---Select---

Title Record these transactions in the General Journal, complete with suitable explanations. Ask your... Description   Record these transactions in the General Journal, complete with suitable explanations. Ask your instructor which of the following tax rates to use: i. Add 5% GST only ii. Add 13% HST iii. Add 5% GST 1 7% PST 1. Rita Jackson, owner of a grocery store, withdrew merchandise for her own use, $55 plus tax(es). 2. Issued cheque to the Provincial Telephone Co. to pay the following: company telephone bill, $45.50 plus tax(es), and owner’s home telephone bill, $41.10. 3. Owner has given you the receipt for a bouquet of flowers sent to her husband. The amount was paid by company cheque, $25.  4. Owner took used printer, valued at $225 plus tax(es), from the business for personal use at home. 5. Issued cheque for $500 to Ms. Jackson for personal use. 6. Owner took office supplies for own use, $15 plus tax(es). 7. Paid owner’s personal dry-cleaning bill, $15.50, with a…

Can someone help me with this question please?

11.A taxpayer is claiming tax preparation expense as a legal and professional fee.  They paid $430 at your office last year.  The forms breakdown by cost is as follows:  Form 1040- $100 Form Sch. C- $125 Form SE- $55 Form 8867- $75 Form 8863- $75  What is the correct amount that can be deducted on their Schedule C for the current year?  Choose one answer.   a. $280     b. $180     c. $355     d. $430

Assume the following information to complete this question.  Total Gross Sales $100,000 Total Full Deduction $60,000 Total Sales Tax rate of 9% Calculate the amount of District Tax that would be reported. Knowledge of the statewide base rate is needed to figure out ONLY the district tax amount. It may be helpful to use the sales tax return as your guide.

I received the answer for exercise 12-19. How do I find out an additional medicare tax rate 3.8% instead of 0.9%? I see 2.9% on the Web. Please advise,   Exercise 12-19 (LO. 7) Compute the additional Medicare tax for the following taxpayers. If required, round your answers to the nearest dollar. c.  Simon has net investment income of $38,000 and MAGI of $223,000 and files as a single taxpayer.Simon's additional Medicare tax is $fill in the blank 3. --------------------------------------------------------------- Step 2 Computation of Additional Medicare tax of Simon Net Investment income = $38,000 MAGI = $223,000 Additional Medicare tax rate = 3.8% on net investment after the settled threshold limit Threshold limit of additional Medicare tax = $200,000 of  MAGI Particular Amount ($) MAGI 223,000 Less: Net investment income (38,000) Net MAGI 185,000 Therefore the Net MAGI is below the threshold limit by = $15,000 ($200,000 - $185,000) Net investment income =…

Please help with total tax bill. and plz   typing solution sent me   Thank you I  Solution sent me very fast type. I give u thum