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,850