Question

In: Accounting

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 from Bryan Jone’s 2017 Form W-2 Wage and Tax Statement:

                                   

Box 1 – Wages, tips, and other compensation

52,000

Box 2 – Federal Withholding

8,750

Box 17 – State Income Tax Withholding

1,000

Interest and Dividends

Bryan has some Certificates of Deposits are Main Street bank which yielded 3,750 in interest in

            2017. In addition, Bryan has interest income from municipal bonds in the amount of 1,250.

Also, Bryan received $2100 in qualified dividends from Plum Electronic Co.

Profit/Loss from Business

Bryan has a part-time accounting services business. In 2017, his income and expenses are as f    follows:

                                                Service Revenue          7,000

                                                Office Expense                  500

                                                Advertising                       750

Capital Gains

Bryan had the following stock transactions in 2017:

He sold 1,000 shares of Apex Co. for $ 12,000 on June 7, 2016, which he purchased on April 1, 2014 for 25,000. In addition, he sold 750 shares of Velocity Inc. for $10,000 on September 1, 2016, which he purchased on December 1, 2015 for $5,000.

Rental Real Estate

Bryan owns a rent house which he purchased on July 1, 2014. The income and expenses of the rental real estate unit for 2017 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. Bryan received a gift of $4,000 from his brother.

2. Bryan paid $3,000 for the year in alimony to his ex-wife, per divorce decree.

3. Bryan had gambling winnings of $1,000.

4. Bryan was the beneficiary of his mother’s life insurance policy.

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

Solutions

Expert Solution

Below are deductions for AGI

Particulars Amount Comment Form 1040
Office expense              500 Schedule C expense Line 12
Advertising              750 Schedule C expense Line 12
Basis of Apex co 1000 shares        25,000 Form 8949 Line 13
Basis of 750 shares of Velocity           5,000 Form 8949 Line 13
Rental real estate- Property taxes           1,500 Schedule E Line 17
Rental real estate- Depreciation           1,000 Schedule E Line 17
Rental real estate- Repairs              750 Schedule E Line 17
Rental real estate- Insurance           2,000 Schedule E Line 17
Alimony           3,000 Form 1040 for AGI deduction Line 31a

Related Solutions

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:...
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...
Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of...
Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of return by hand (i.e. no financial calculator or Excel routine). For this problem assume a 10-year analysis period, double declining depreciation is used, 21% corporate tax rate, an initial cost of $200,000, an annual benefit of $60,000 and no salvage value but instead you must pay a disposal fee of $20,000 that your corporate accountant determined is 100% tax deductible.
Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of...
Complete a spreadsheet (by hand or by Excel) and then determine the after-tax internal rate of return by hand (i.e. no financial calculator or Excel routine). For this problem assume a 7-year property, MACRS depreciation is used, 21% corporate tax rate, an initial cost of $800,000, an annual benefit of $150,000 and a salvage value of $100,000. Do not forget the recaptured depreciation.
Prepare a spreadsheet using Excel or a similar program in which you compute the items listed...
Prepare a spreadsheet using Excel or a similar program in which you compute the items listed in parts a, b, and d. Be sure to compute the Yield-to-Maturity (YTM) and Yield-to-Call (YTC) for each of years 5, 6, 7, 8, and 9. Kaufman Enterprises has bonds outstanding with a $1,000 face value and 10 years left until maturity. They have an 11% annual coupon payment, and their current price is $1,175. The bonds may be called in 5 years at...
Prepare a spreadsheet using Excel or a similar program in which you compute the items listed...
Prepare a spreadsheet using Excel or a similar program in which you compute the items listed in parts a, b, and d. Be sure to compute the Yield-to-Maturity (YTM) and Yield-to-Call (YTC) for each of years 5, 6, 7, 8, and 9. Kaufman Enterprises has bonds outstanding with a $1,000 face value and 10 years left until maturity. They have an 11% annual coupon payment, and their current price is $1,185. The bonds may be called in 5 years at...
7. Check all the items that can possibly be taken as a FOR AGI Adjustment: Casualty...
7. Check all the items that can possibly be taken as a FOR AGI Adjustment: Casualty Educator Expenses Self-employment taxes Medical Expenses Business Expenses Real-Estate Taxes on Residence Tuition paid for your degree at EKU 8. Check all the items that can possibly be taken as a FOR AGI adjustment: Student Loan Interest Paid State Income Taxes Paid Moving Expenses Health Savings Account Contributions Personal Property taxes paid Early Withdraw from Savings Penalty Charitable Contributions 10. Which of the following...
​Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator
Calculate all of the problems in the document below in an Excel spreadsheet or on a financial calculator. Please show your work in order to get credit. For each problem, state the inputs given, what you are being asked to find (the missing input), and then use the Finance function to get the correct answer (if using Excel).13. You are told that if you invest $15,000 per year for10 years (all payments made at the end of each year), you...
How do you display all the formulas in an Excel spreadsheet? There is a toggle switch...
How do you display all the formulas in an Excel spreadsheet? There is a toggle switch and you start by pressing CTRL and then another character. What is the other character to allow you to display all the formulas in your spreadsheet at once?
Create an Excel spreadsheet in which you use capital budgeting tools to determine the quality of...
Create an Excel spreadsheet in which you use capital budgeting tools to determine the quality of 3 proposed investment projects, as well as a 6-8 page report that analyzes your computations and recommends the project that will bring the most value to the company. I have completed the excel portion of this question Scenario You work as a finance manager for Drill Tech, Inc., a mid-sized manufacturing company located in Minnesota. Three capital project requests were identified as potential projects...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT