Question

In: Accounting

Determine all items that will be excluded from gross income. In a MS Excel spreadsheet, list...

Determine all items that will be excluded from gross income. In a MS Excel spreadsheet, list all excluded items in column A. In column B, explain why the item is excluded.

Taxpayer Information

                Name:   John Washington

                Address:   3450 Green St.

                                    Miami, FL 54321

                DOB:   5/5/1960

                Filing Status: Married

                SSN: 434-20-2020

                Occupation: Engineer

                Name: Debra Washington

                Address: 3450 Green St.

                                   Miami, FL 54321

                DOB: 7/7/1962

                Filing Status: Married

                SSN: 411-21-4568

                Occupation: Teacher

INCOME INFORMATION:

                Wages and Compensation

The following information is taken from John Washington’s 2017 Form W-2 Wage and Tax Statement:

                                               

Box 1 – Wages, tips, and other compensation

80,000

Box 2 – Federal Withholding

12,500

Box 17 – State Income Tax Withholding

2,000

                               

The following information is taken from Debra Washington’s 2017 Form W-2 Wage and Tax Statement:

                                               

Box 1 – Wages, tips, and other compensation

42,000

Box 2 – Federal Withholding

3,500

Box 17 – State Income Tax Withholding

750

                Interest and Dividends

                John had interest income from a savings account from Everest Bank of $500.00

                Debra had dividend income of $550 from Blue Co. stock.

                Capital Gains

                John had the following stock transactions in 2017:

He sold 1,000 shares of Apex Co. for $ 12,000 on June 7, 2017, which he purchased on April 1, 2017 for 25,000

                Rental Real Estate

The couple owns a rent house which he purchased on July 1, 2014. The income and expenses of the rental real estate unit are as follows:

                                Rental income                                   $12,000

                                Property taxes                                $1,500

                                Depreciation                                    $1,000

                                Repairs and Maintenance             $750

                                Insurance                                            $2,000

Other Transactions in 2017

1. Debra had educator expenses in 2017 of $450.00

2. John had gambling winnings of $1,000.

3. John was the beneficiary of his mother’s life insurance policy.

His mother died in 2017 and he received $50,000 under this policy.

                4. Debra paid $700 in student loan interest.

Solutions

Expert Solution

ANSWER:-

33 Student loan Amount Amount
Actual interest                  700
1 Min actual or 2,500                  700
2 Total income       1,43,800
3 Deductions to AGI               450
4 Modified AGI       1,43,350
5 Phase out       1,35,000
6            8,350
7 Divide by 15000                    0
8 Amount of phase out                  195
Deduction                  505

Related Solutions

1) List 5 items excluded from Gross Income. 2) List 5 items included in Gross Income....
1) List 5 items excluded from Gross Income. 2) List 5 items included in Gross Income. 3) List the five filing statuses taxpayers may use when filing a return. 4) List the requirements to meet the Head-of-Household filing status. 5) List the components of the Individual Tax Formula (Hint: Starts with Income and ends with Tax Due (or refund)
Determine all items that will be deducted before the AGI calculation. In a MS Excel spreadsheet,...
Determine all items that will be deducted before the AGI calculation. In a MS Excel spreadsheet, list all deductible items in column A. In column B, determine where that deduction should appear on Form 1040 (for tax year 2017). Taxpayer Information             Name:   Bryan Jones             Address:   1200 Main St.                             Green Bay, Wisconsin 12345             DOB:   5/6/1976             Filing Status: Single             SSN: 500-10-2000             Occupation: Staff Accountant INCOME INFORMATION: Wages and Compensation The following information is taken...
Which of the following items of income are generally excluded from gross income: start up expenses...
Which of the following items of income are generally excluded from gross income: start up expenses paid cost recovery death benefit paid on life insurance policy charitable contributions made both c and d
Determine if the following are included or excluded from gross income: Mary’s father gives her $10,000...
Determine if the following are included or excluded from gross income: Mary’s father gives her $10,000 so that she can purchase a car. The Lang family receives $3,000 from a friend after their house was destroyed by fire. Martha gives her attorney an extra $500 because he did an excellent job preparing her will. Justin’s employer gave him an iPad because he has not been absent from work for three weeks. Juan’s wife died three weeks ago, and her employer...
Which of the following can be excluded from Ellen's gross income? 1. The value of a...
Which of the following can be excluded from Ellen's gross income? 1. The value of a diamond ring that Ellen received as a gift from David. 2. The value of a mansion that Ellen inherited from her parents. 3. The value of concert tickets that Ellen won in a radio contest. 4. The value of a scholarship for room and board that Ellen received to her state university. Group of answer choices c. 1, 2, and 3 a. 1 only...
1. Which of the following items would be excluded from the calculation of taxable income by...
1. Which of the following items would be excluded from the calculation of taxable income by an auditor employing the bank-deposit audit method? A.. Existing funds from wages in the taxpayer's bank account. B.. A deposit of $125 in proceeds from the taxpayer's garage sale. C.. A deposit of a $25 birthday gift from the taxpayer's grandmother. D.. A deposit of $20 from the taxpayer's lottery winnings 2. Which of the following is typical of a field audit, but not...
List four items that are considered deductions for AGI(Adjusted Gross Income) - when listing these items...
List four items that are considered deductions for AGI(Adjusted Gross Income) - when listing these items - state whether they are deducted on the Form 1040 or on a supporting form or schedule. What are considered Educational Related Expenses as they relate to deductions for AGI(Adjusted Gross Income)
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of...
Please show formulas using excel Build a spreadsheet: Construct an Excel spreadsheet to solve all of the preceding requirements. Show how the solution will change if the following data change: the April 1 work-in-process costs were $66,000 for direct material and $18,000 for conversion. Work in process, April 1—10,000 units: Direct material: 100% complete, cost of .........................................................................................................$ 22,000 Conversion: 20% complete, cost of ................................................................................................................. 4,500 Balance in work in process, April 1 ..................................................................................................................$  26,500 Units started during April ......................................................................................................................................100,000 Units...
List and describe 9 employee fringe benefits that are excluded from income. Give an example of...
List and describe 9 employee fringe benefits that are excluded from income. Give an example of the each benefit and any rules and limitations on the income tax exclusion.
List some of the items that are deducted from gross pay to arrive at net pay...
List some of the items that are deducted from gross pay to arrive at net pay on an employee's paycheck. Discuss the different types of taxes. Which taxes are deducted from an employee's paycheck and which taxes are the employer responsible for paying?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT