Ç&TAX1040 87 z|TAXA 87 |õTAXC 87 3Tâ\wg15 \dg38 >a1:"I.R.S. FORM 1040 >a1:\wc39 >c1:\wc20 >a2:" This Spreadsheet relates to the following files automatically: >a3:" --> taxa.87 >a4:" and --> taxc.87 >a5:" 6e Exemptions (col. b = "Error" if 0) >b5:=c5/c5@ >c5:1.000000000000E+00 >a5:\dl0 >a7:"Income >a8:" 7 Wages, salaries, tips, etc. >c8:0 >a9:" 8 Taxable Interest Income >c9:0 >a10:" 9 Tax-exempt interest income >b10:0 >c10:" --- >a11:" 10 Dividend income >c11:0 >a12:" 11 Tax Refunds >c12:0 >a13:" 12 Alimony received >c13:0 >a14:" 13 Business income (Schedule C) >c14:=taxc[c49]@ >a15:" 14 Capital gain (Schedule D) >c15:0 >a16:" 15 Other gains or (losses) (attach Form 4797) >c16:0 >a17:" 16a Pensions, IRA dist., annuities >b17:0 >c17:" --- >a18:" 16b Taxable amount >c18:0 >a19:" 17 Rents, royalties, ... (attach Sched. E) >c19:0 >a20:" 18 Farm income (Schedule F) >c20:0 >a21:" 19 Unemployment compensation >c21:0 >a22:" 20a Social Security Benefits >b22:0 >c22:" --- >a23:" 20b Taxable Amount from S.S. worksheet >c23:0 >a24:" 21 Other income >c24:0 >a25:" 22 Total income >c25:=sum(c8:c24)@ >a27:"Adjustments to Income >a28:" 23 Employee bus. exp. (form 2106) >b28:0 >c28:" --- >a29:" 24a IRA Deduction from worksheet >b29:0 >c29:" --- >a30:" 24b Spouse's IRA Deduction >b30:0 >c30:" --- >a31:" 25 Self-employed health insurance >b31:0 >c31:" --- >a32:" 26 Keogh payments >b32:0 >c32:" --- >a33:" 27 Penalty on early withdrawal of savings >b33:0 >c33:" --- >a34:" 28 Alimony paid >b34:0 >c34:" --- >a35:" 29 Total Adjustments >c35:=sum(b28:b34)@ >a37:"Adjusted Gross Income >a38:" 30 Adjusted Gross Income >c38:=c25-c35@ >a40:"Tax Computation >a41:" 31 Amount from line 30 >c41:=c38@ >a42:" 32a ......... >a43:" 33a Itemized Deductions (Schedule A) >c43:=taxa[c45]@ >a44:" 33b Standard Deduction >c44:0 >a45:" 34 Subtract line 33a or 33b >c45:=if(c43,c41-c43,c41-c44) @ >a46:" 35 $1,900 per exemption >c46:=1900*c5@ >a47:" 36 Taxable Income >c47:=c45-c46@ >a48:" 37 Tax >c48:0 >a49:" 38 Additional taxes >a50:" 39 Total taxes >c50:=c48+c49@ >a52:"Credits >a53:" 40 Child Care >b53:0 >c53:" --- >a54:" 41 Elderly >b54:0 >c54:" --- >a55:" 42 Line 40 + 41 >c55:=b53+b54@ >a56:" 43 Subtract line 42 from line 39 >c56:=c50-c55@ >a57:" 44 Foreign tax credit >b57:0 >c57:" --- >a58:" 45 General business credit >b58:0 >c58:" --- >a59:" 46 Total business and other Credits >c59:=b57+b58@ >a60:" 47 Subtract line 46 from line 43 >c60:=c56-c59@ >a62:"Other Taxes >a63:" 48 Self-employment >c63:0 >a64:" 49 Alternative minimum >c64:0 >a65:" 50 Recapture of Investment Credit >c65:0 >a66:" 51 Social Security on tips >c66:0 >a67:" 52 Tax on IRA (Form 5329) >c67:0 >a68:" 53 Total Tax >c68:=sum(c60:c67) >a70:"Payments >a71:" 54 Federal income tax withheld >b71:0 >c71:" --- >a72:" 55 1987 estimated tax payments >b72:0 >c72:" --- >a73:" 56 Earned income credit >b73:0 >c73:" --- >a74:" 57 Form 4868 >b74:0 >c74:" --- >a75:" 58 Excess FICA >b75:0 >c75:" --- >a76:" 59 Federal fuels tax >b76:0 >c76:" --- >a77:" 60 Regulated investment co. >b77:0 >c77:" --- >a78:" 61 Total Payments >c78:=sum(b71:b77)@ >a80:"Refund or Balance Due >a81:" 62 Amount OVERPAID >c81:=if(c78>c68,c78-c68,0)@ >a82:" 63 REFUNDED TO YOU >c82:=c81@ >a83:" 64 Applied to 1988 tax >b83:0 >c83:" --- >a84:" 65 BALANCE DUE >c84:=if(c68>c78,c68-c78,0)@ >a1 \aB:TAXA.87 \wg15 \dg38 >a1:" SCHEDULE A - ITEMIZED DEDUCTIONS >a1:\wc39 >a3:" This Spreadsheet is used with the "tax1040.87" spreadsheet file. >a5:"Medical and Dental Expenses >a6:" 1a Medicine and drugs, doctors, dentists >b6:0 >c6:" --- >a7:" 1b Transportation and lodging >b7:0 >c7:" --- >a8:" 1c Other (Eyeglasses, etc.) >b8:0 >c8:" --- >a9:" 2 Total >b9:=sum(b6:b8)@ >c9:" --- >a10:" 3 7.5% of Form 1040, line 31 >b10:=tax1040[c41]*.075@ >c10:" --- >a11:" Line 2 - Line 3 >b11:=b9-b10@ >c11:" --- >a12:" 4 Total (If <0, enter 0) >c12:=if(b11>0,b11,0)@ >a13:"Taxes >a14:" 5 State and local income >b14:0 >c14:" --- >a15:" 6 Real Estate >b15:0 >c15:" --- >a16:" 7 Other taxes >b16:0 >c16:" --- >a17:" 8 Total >c17:=sum(b14:b16)@ >a18:"Interest expense >a19:" 9a Home Mortgage (institutions) >b19:0 >c19:" --- >a20:" 9b Home Mortgage (individuals) >b20:0 >c20:" --- >a21:" 10 Deductible points >b21:0 >c21:" --- >a22:" 11 Deductible investment interest >b22:0 >c22:" --- >a23:" 12a Personal Interest Paid >b23:0 >c23:" --- >a24:" 12b Multiply by 65% >b24:=b23*.65@ >c24:" --- >a25:" 13 Total Interest >c25:=sum(b19:b22)+b24 @ >a26:"Contributions >a27:" 14a Cash contributions >b27:0 >c27:" --- >a28:" 14b Cash Contributions (>$3,000) >b28:0 >c28:" --- >a29:" 15 Other than cash >b29:0 >c29:" --- >a30:" 16 Carryover >b30:0 >c30:" --- >a31:" 17 Total >c31:=sum(b27:b30)@ >a32:"Casualty or Theft Losses >a33:" 18 Total Casualty or Theft Losses >c33:0 >a34:"Moving Expenses >a35:" 19 Total moving expenses >c35:0 >a36:"Miscellaneous Deductions >a37:" 20 Unreimbursed business expenses >b37:0 >c37:" --- >a38:" 21 Other Expenses >b38:0 >c38:" --- >a39:" 22 Total Miscellaneous Deductions >b39:=b37+b38@ >c39:" --- >a40:" 23 Multiply by 2% >b40:=tax1040[c41]*.02@ >c40:" --- >a41:" 24 Subtract line 23 from line 22 >b41:=b39-b40@ >c41:=if(b41>0,b40,0)@ >a42:"Other Miscellaneous Deductions >a43:" 25 Misc. deductions not subject to 2% limit >c43:0 >a44:"Total Itemized Deductions >a45:" 26 Total Itemized Deductions >c45:=c12+c17+c25+c31+c33+c35+c41+c43 >a1 \aB:TAXC.87 >a1:"SCHEDULE C -- PROFIT OR (LOSS) FROM BUSINESS OR PROFESSION >a1:\wc35 >b1:\wc20 >c1:\wc20 >a3:" This spreadsheet relates to "taxa.87" >a5:"Income >a6:" 1a Gross Receipts >c6:0 >a7:" 1b Less: Returns and Allowances >c7:0 >a8:" 1c Line 1a - 1b >c8:=c6-c7@ >a9:" 2 Cost of goods sold and/or operations >c9:0 >a10:" 3 Gross Profit >c10:=c8-c9@ >a11:" 4 Other income >c11:0 >a12:" 5 Gross Income >c12:=c10+c11 >a14:"Deductions >a15:" 6 Advertising >c15:0 >a16:" 7 Bad debts >c16:0 >a17:" 8 Bank Service Charges >c17:0 >a18:" 9 Car and truck expenses >c18:0 >a19:" 10 Commissions >c19:0 >a20:" 11 Depletion >c20:0 >a21:" 12 Depreciation (Form 4562) >c21:0 >a22:" 13 Dues and Publications >c22:0 >a23:" 14 Employee Benefit Programs >c23:0 >a24:" 15 Freight >c24:0 >a25:" 16 Insurance >c25:0 >a26:" 17 Interest >c26:0 >a27:" a Mortgage (financial institutions) >c27:0 >a28:" b Other >c28:0 >a29:" 18 Laundry and cleaning >c29:0 >a30:" 19 Legal and professional services >c30:0 >a31:" 20 Office expense >c31:0 >a32:" 21 Pension and profit-sharing >c32:0 >a33:" 22 Rent >c33:0 >a34:" 23 Repairs >c34:0 >a35:" 24 Supplies >c35:0 >a36:" 25 Taxes >c36:0 >a37:" 26 Travel and entertainment >c37:" --- >a38:" a Travel >b38:0 >c38:" --- >a39:" b Meals and entertainment >b39:0 >c39:" --- >a40:" c Enter 10% of line 26b >b40:=b39*.20@ >c40:" --- >a41:" d Subtract line 26c from 26b >c41:=b39-b40@ >a42:" 27 Utilities and phone >c42:0 >a43:" 28a Wages >b43:0 >c43:" --- >a44:" 28b Jobs Credit >b44:0 >c44:" --- >a45:" 28c Line 28a - 28b >c45:=b43-b44@ >a46:" 29 Other expenses >c46:0 >a47:" 30 Total Deductions >c47:=sum(c15:c46)@ >a49:" 31 Net Profit or (Loss) >c49:=c12-c47@ >a1