home *** CD-ROM | disk | FTP | other *** search
/ ftp.barnyard.co.uk / 2015.02.ftp.barnyard.co.uk.tar / ftp.barnyard.co.uk / cpm / walnut-creek-CDROM / CPM / PROGRAMS / SPREDSHT / PCALCTAX.LBR / TAX1040.87 next >
Text File  |  2000-06-30  |  4KB  |  169 lines
  1. \wg15
  2. \dg38
  3. >a1:"I.R.S. FORM 1040
  4. >a1:\wc39
  5. >c1:\wc20
  6. >a2:"  This Spreadsheet relates to the following files automatically:
  7. >a3:"     --> taxa.87 
  8. >a4:" and --> taxc.87 
  9. >a5:"  6e Exemptions (col. b = "Error" if 0)
  10. >b5:=c5/c5@
  11. >c5:1.000000000000E+00
  12. >a5:\dl0
  13. >a7:"Income
  14. >a8:"  7  Wages, salaries, tips, etc.
  15. >c8:0
  16. >a9:"  8  Taxable Interest Income
  17. >c9:0
  18. >a10:"  9  Tax-exempt interest income
  19. >b10:0
  20. >c10:"         ---
  21. >a11:"  10 Dividend income
  22. >c11:0
  23. >a12:"  11 Tax Refunds
  24. >c12:0
  25. >a13:"  12 Alimony received
  26. >c13:0
  27. >a14:"  13 Business income (Schedule C)
  28. >c14:=taxc[c49]@
  29. >a15:"  14 Capital gain (Schedule D)
  30. >c15:0
  31. >a16:"  15 Other gains or (losses) (attach Form 4797) 
  32. >c16:0
  33. >a17:"  16a Pensions, IRA dist., annuities    
  34. >b17:0
  35. >c17:"         ---
  36. >a18:"  16b   Taxable amount
  37. >c18:0
  38. >a19:"  17 Rents, royalties, ... (attach Sched. E) 
  39. >c19:0
  40. >a20:"  18 Farm income (Schedule F)
  41. >c20:0
  42. >a21:"  19 Unemployment compensation
  43. >c21:0
  44. >a22:"  20a Social Security Benefits
  45. >b22:0
  46. >c22:"         ---
  47. >a23:"  20b Taxable Amount from S.S. worksheet
  48. >c23:0
  49. >a24:"  21 Other income
  50. >c24:0
  51. >a25:"  22 Total income
  52. >c25:=sum(c8:c24)@
  53. >a27:"Adjustments to Income
  54. >a28:"  23 Employee bus. exp. (form 2106)
  55. >b28:0
  56. >c28:"         ---
  57. >a29:"  24a IRA Deduction from worksheet
  58. >b29:0
  59. >c29:"         ---
  60. >a30:"  24b Spouse's IRA Deduction
  61. >b30:0
  62. >c30:"         ---
  63. >a31:"  25 Self-employed health insurance
  64. >b31:0
  65. >c31:"         ---
  66. >a32:"  26 Keogh payments
  67. >b32:0
  68. >c32:"         ---
  69. >a33:"  27 Penalty on early withdrawal of savings 
  70. >b33:0
  71. >c33:"         ---
  72. >a34:"  28 Alimony paid
  73. >b34:0
  74. >c34:"         ---
  75. >a35:"  29 Total Adjustments
  76. >c35:=sum(b28:b34)@
  77. >a37:"Adjusted Gross Income
  78. >a38:"  30 Adjusted Gross Income
  79. >c38:=c25-c35@
  80. >a40:"Tax Computation
  81. >a41:"  31 Amount from line 30 
  82. >c41:=c38@
  83. >a42:"  32a .........
  84. >a43:"  33a Itemized Deductions (Schedule A)
  85. >c43:=taxa[c45]@
  86. >a44:"  33b Standard Deduction
  87. >c44:0
  88. >a45:"  34 Subtract line 33a or 33b
  89. >c45:=if(c43,c41-c43,c41-c44) @
  90. >a46:"  35 $1,900 per exemption
  91. >c46:=1900*c5@
  92. >a47:"  36 Taxable Income
  93. >c47:=c45-c46@
  94. >a48:"  37 Tax    
  95. >c48:0
  96. >a49:"  38 Additional taxes
  97. >a50:"  39 Total taxes
  98. >c50:=c48+c49@
  99. >a52:"Credits
  100. >a53:"  40 Child Care
  101. >b53:0
  102. >c53:"         ---
  103. >a54:"  41 Elderly
  104. >b54:0
  105. >c54:"         ---
  106. >a55:"  42 Line 40 + 41
  107. >c55:=b53+b54@
  108. >a56:"  43 Subtract line 42 from line 39
  109. >c56:=c50-c55@
  110. >a57:"  44 Foreign tax credit
  111. >b57:0
  112. >c57:"         ---
  113. >a58:"  45 General business credit
  114. >b58:0
  115. >c58:"         ---
  116. >a59:"  46 Total business and other Credits
  117. >c59:=b57+b58@
  118. >a60:"  47 Subtract line 46 from line 43
  119. >c60:=c56-c59@
  120. >a62:"Other Taxes
  121. >a63:"  48 Self-employment
  122. >c63:0
  123. >a64:"  49 Alternative minimum
  124. >c64:0
  125. >a65:"  50 Recapture of Investment Credit
  126. >c65:0
  127. >a66:"  51 Social Security on tips
  128. >c66:0
  129. >a67:"  52 Tax on IRA (Form 5329)
  130. >c67:0
  131. >a68:"  53 Total Tax
  132. >c68:=sum(c60:c67)
  133. >a70:"Payments
  134. >a71:"  54 Federal income tax withheld
  135. >b71:0
  136. >c71:"         ---
  137. >a72:"  55 1987 estimated tax payments
  138. >b72:0
  139. >c72:"         ---
  140. >a73:"  56 Earned income credit
  141. >b73:0
  142. >c73:"         ---
  143. >a74:"  57 Form 4868
  144. >b74:0
  145. >c74:"         ---
  146. >a75:"  58 Excess FICA
  147. >b75:0
  148. >c75:"         ---
  149. >a76:"  59 Federal fuels tax
  150. >b76:0
  151. >c76:"         ---
  152. >a77:"  60 Regulated investment co.
  153. >b77:0
  154. >c77:"         ---
  155. >a78:"  61 Total Payments
  156. >c78:=sum(b71:b77)@
  157. >a80:"Refund or Balance Due
  158. >a81:"  62 Amount OVERPAID
  159. >c81:=if(c78>c68,c78-c68,0)@
  160. >a82:"  63 REFUNDED TO YOU
  161. >c82:=c81@
  162. >a83:"  64 Applied to 1988 tax
  163. >b83:0
  164. >c83:"         ---
  165. >a84:"  65 BALANCE DUE
  166. >c84:=if(c68>c78,c68-c78,0)@
  167. >a1
  168. \aB:TAXA.87
  169.