Question
I have a project to do a 1040 form on an excel spreadsheet since the 2018 version is not out yet. Can someone help me
I have a project to do a 1040 form on an excel spreadsheet since the 2018 version is not out yet. Can someone help me with the process. I have completed most of the items. What items should I add or remove in all the following sections.
Thank you
Based on the information provided, you are to complete the 2018 Form 1040 and any supporting schedules/forms for Bob and Melissa Grant. You do not need to prepare a state tax return. You should complete this tax return by hand using the forms available from the IRS website, www.irs.gov. You may find the form instructions helpful in completing this assignment. Please provide a list of assumptions you make, if any. I will grade your return subject to any reasonable assumptions listed. You do not need to calculate AMT. The 1040 and all supporting documents are to be typed.
Attach a cover letter summarizing the return, such as refund, tax owed, average and effective tax rates.
Bob and Melissa Grant are married and live in Lexington, Kentucky. The Grants have two children Jared age 15 and Alana age 12. The Grants would like to file a joint tax return for the year.
The following information relates to the Grants tax year:
Bobs Social Security number is 987-45-1234
Melissas Social Security number is 494-37-4883
Jareds Social Security number is 412-32-5690
Alanas Social Security number is 412-32-6940
The Grants mailing address is 95 Hickory Road, Lexington, Kentucky 40502.
Jared and Alana are tax dependents for federal tax purposes
Bob Grant received the following during the year:
Employer | Gross Wages | Federal Income Tax Withholding | State Income Tax Withholding |
National Storage | $56,200 | $10,000 | $3,750 |
Lexington Little League | $3,710 | 0 | 0 |
Melissa Grant received the following during the year:
Employer | Gross Wages | Federal Income Tax Withholding | State Income Tax Withholding |
Jensen Photography | $29,400 | $2,850 | $1,525 |
All applicable and appropriate payroll taxes were withheld by Grants respective employers.
The Grants also received the following during this year:
Interest Income from First Kentucky Bank $830
Interest Income from City of Lexington, KY Bond $1,450
Interest Income from U.S. Treasury Bond $675
Interest Income from Nevada State School Board Bond $150
Workers Compensation payments to Bob $8,350
Disability payments received by Bob on account of injury $5,500
National Storage paid 100% of premiums the premiums on the policy and included the premium payments in Bobs taxable wages
Receipt of payment by Melissa as a result of a lawsuit for damages sustained in a car
accident:
Medical Expenses $ 2,500
Emotional Distress $18,000
Punitive Damages $14,000
Total $34,500
Bob received an inheritance from his favorite uncle, James Robert, in the amount of $25,000 in cash, on November 30.
Eight years ago, Melissa purchased an annuity contract for $70,000. This year, she received her first payment on the annuity. The payment amount was $10,000. The annuity started to pay on January 1, and she received a full first years payment. It will pay her $10,000 per year for ten years (beginning with this year). The $10,000 payment was reported to Melissa on form 1099-R for the current year (box 7 contained an entry of 7 on the form).
The Grants did not own, control or manage any foreign bank accounts nor were they a grantor or beneficiary of a foreign trust during the tax year.
The Grants paid or incurred the following expenses during the year:
Dentist/Orthodontist (unreimbursed by insurance) $8,500
Doctors (unreimbursed by insurance) $ 625
Prescriptions (unreimbursed by insurance) $ 380
Real property taxes on residence $2,800
Vehicle property tax based upon age of vehicle $ 450
Mortgage interest on principal residence $8,560
Interest paid on borrowed money to purchase the City of
Lexington, KY municipal bonds $ 400
Interest paid on borrowed money to purchase
U.S. Treasury bonds $ 240
Contribution to the Red Cross $3,000
Contribution to Senator Rick Hartleys Re-election Campaign $2,500
Contribution to First Baptist Church of Kentucky $9,000
Fees paid to Jones & Company, CPAs for tax preparation $ 300
In addition, Bob drove 7,750 miles commuting to work and Melissa drove 6,230 miles commuting to work. Both the Grants have represented to you that they maintained careful logs to support their respective mileage.
The Grants drove 465 miles in total to receive medical treatment at a hospital in April.
During the year, the Grants personal residence was burglarized on October 1 of the current year. The theft occurred during the day while both the Grants were at work and their children were at school. The Grants had the following personal property stolen:
Item | Purchase Date | Fair Value on Date of Theft | Tax Basis of Item | Insurance Reimbursement Received |
Laptop computer and Printer | 09/01/2012 | 3,000 | 4,000 | 300 |
Musical Instrument | 03/01/2010 | 2,000 | 4,500 | 500 |
Home Theater | 03/01/2010 | 5,000 | 11,000 | 1,000 |
2011 Honda Pilot | 07/01/2011 | 3,000 | 5,500 | 1,500 |
The Grants would like to receive a refund (if any) of any tax they may have overpaid for the year. Their preferred method of receiving the refund is by check.
Income: National Storage- Gross Wages Lexington Little League Gross Wages Jensen Photography- Gross Wages Interest Income- First Kentucky Bank Interest Income City Of Lexington, KY Bond Interest Income Nevada State School Board Bond Punitive Damages Annuity Total Income $56,200 $3,710 $29,400 $830 $1,450 $150 $14,000 $3,000 For AGI: Total For AGI AGI From AGI: Standardized Deduction: ltemized Deductions Medical Expenses Emotional Distress Dentist/ Orthodontist Doctors Prescriptions Real Property Taxes on Residence Vehicle Poperty Tax Mortage interest on Principal Residence Contribution to the Red Cross Contribution to Senator Rick Hartly's Contribution to First Baptist Church Fees for CPA tax preperation Travel - Medical treatment Total Itemized Deductions Taxable Income Income Tax Liabil Child Tax Credit Tax Withholding: Federal Tax Withholding - Bob Federal Tax Withholding - Melissa Total Tax Withholding Tax Refund $24,000 $2,500 $18,000 $8,500 $625 $380 $2,800 $450 $8,560 $3,000 $2,500 $9,000 $300 ($4,000) $10,000 $2,850 $12,850 Income: National Storage- Gross Wages Lexington Little League Gross Wages Jensen Photography- Gross Wages Interest Income- First Kentucky Bank Interest Income City Of Lexington, KY Bond Interest Income Nevada State School Board Bond Punitive Damages Annuity Total Income $56,200 $3,710 $29,400 $830 $1,450 $150 $14,000 $3,000 For AGI: Total For AGI AGI From AGI: Standardized Deduction: ltemized Deductions Medical Expenses Emotional Distress Dentist/ Orthodontist Doctors Prescriptions Real Property Taxes on Residence Vehicle Poperty Tax Mortage interest on Principal Residence Contribution to the Red Cross Contribution to Senator Rick Hartly's Contribution to First Baptist Church Fees for CPA tax preperation Travel - Medical treatment Total Itemized Deductions Taxable Income Income Tax Liabil Child Tax Credit Tax Withholding: Federal Tax Withholding - Bob Federal Tax Withholding - Melissa Total Tax Withholding Tax Refund $24,000 $2,500 $18,000 $8,500 $625 $380 $2,800 $450 $8,560 $3,000 $2,500 $9,000 $300 ($4,000) $10,000 $2,850 $12,850Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started