Using the guidelines below, prepare a spreadsheet to determine if you owe the Federal government or the Federal government owes you. Open a spreadsheet and in cell A1 enter Income Tax Return. In cell A3, enter Wages, Salaries, and Tips and in cell B3, enter $16200.89. In cell A4, enter Taxable Interest and in cell B4, enter 111.90. In cell A5, enter Unemployment Compensation and in cell B5, enter 0. In cell A6, enter Adjusted Gross Income and in cell B6, enter a formula to find the total of B3, B4, and B5. In cell A7, enter Single and in cell B7 enter $8750. In cell A8, enter Taxable Income and in cell B8, enter a formula to subtract the amount in cell B7 from the Adjusted Gross Income. In cell A9, enter Federal Income Tax Withheld and in cell B9, enter $1567.94. In cell A10, enter Earned Income Credit and in cell B10, enter 0 In cell A11, enter Total Payments and in cell B11, enter a formula to add Federal Income Tax Withheld and Earned Income Credit. Next you would use the tax table in the tax booklet to look up the corresponding value for your taxable income. The value from the tax table is $758. In cell A12, enter Tax and in cell B12, enter $758. Since the total payments in cell B11 are greater than the tax in cell B12, you will be receiving a refund. In cell A13, enter Refund and in cell B13, enter a formula to subtract the tax from the total payments. Let's check your answer. In cell B13, you should have $809.94.
