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 / TAXA.87 < prev    next >
Text File  |  2000-06-30  |  3KB  |  105 lines
  1. \wg15
  2. \dg38
  3. >a1:" SCHEDULE A - ITEMIZED DEDUCTIONS
  4. >a1:\wc39
  5. >a3:"  This Spreadsheet is used with the "tax1040.87" spreadsheet file.
  6. >a5:"Medical and Dental Expenses
  7. >a6:"  1a Medicine and drugs, doctors, dentists
  8. >b6:0
  9. >c6:"         ---
  10. >a7:"  1b Transportation and lodging
  11. >b7:0
  12. >c7:"         ---
  13. >a8:"  1c  Other (Eyeglasses, etc.)
  14. >b8:0
  15. >c8:"         ---
  16. >a9:"  2  Total
  17. >b9:=sum(b6:b8)@
  18. >c9:"         ---
  19. >a10:"  3  7.5% of Form 1040, line 31
  20. >b10:=tax1040[c41]*.075@
  21. >c10:"         ---
  22. >a11:"     Line 2 - Line 3 
  23. >b11:=b9-b10@
  24. >c11:"         ---
  25. >a12:"  4  Total (If <0, enter 0)
  26. >c12:=if(b11>0,b11,0)@
  27. >a13:"Taxes
  28. >a14:"  5  State and local income
  29. >b14:0
  30. >c14:"         ---
  31. >a15:"  6  Real Estate
  32. >b15:0
  33. >c15:"         ---
  34. >a16:"  7  Other taxes
  35. >b16:0
  36. >c16:"         ---
  37. >a17:"  8  Total
  38. >c17:=sum(b14:b16)@
  39. >a18:"Interest expense
  40. >a19:"  9a Home Mortgage (institutions)
  41. >b19:0
  42. >c19:"         ---
  43. >a20:"  9b Home Mortgage (individuals)
  44. >b20:0
  45. >c20:"         ---
  46. >a21:"  10 Deductible points
  47. >b21:0
  48. >c21:"         ---
  49. >a22:"  11 Deductible investment interest
  50. >b22:0
  51. >c22:"         ---
  52. >a23:"  12a Personal Interest Paid 
  53. >b23:0
  54. >c23:"         ---
  55. >a24:"  12b Multiply by 65%
  56. >b24:=b23*.65@
  57. >c24:"         ---
  58. >a25:"  13  Total Interest 
  59. >c25:=sum(b19:b22)+b24 @
  60. >a26:"Contributions
  61. >a27:"  14a Cash contributions
  62. >b27:0
  63. >c27:"         ---
  64. >a28:"  14b Cash Contributions (>$3,000)
  65. >b28:0
  66. >c28:"         ---
  67. >a29:"  15 Other than cash
  68. >b29:0
  69. >c29:"         ---
  70. >a30:"  16 Carryover
  71. >b30:0
  72. >c30:"         ---
  73. >a31:"  17 Total
  74. >c31:=sum(b27:b30)@
  75. >a32:"Casualty or Theft Losses
  76. >a33:"  18 Total Casualty or Theft Losses 
  77. >c33:0
  78. >a34:"Moving Expenses
  79. >a35:"  19 Total moving expenses
  80. >c35:0
  81. >a36:"Miscellaneous Deductions
  82. >a37:"  20 Unreimbursed business expenses
  83. >b37:0
  84. >c37:"         ---
  85. >a38:"  21 Other Expenses
  86. >b38:0
  87. >c38:"         ---
  88. >a39:"  22 Total Miscellaneous Deductions
  89. >b39:=b37+b38@
  90. >c39:"         ---
  91. >a40:"  23 Multiply by 2%
  92. >b40:=tax1040[c41]*.02@
  93. >c40:"         ---
  94. >a41:"  24 Subtract line 23 from line 22
  95. >b41:=b39-b40@
  96. >c41:=if(b41>0,b40,0)@
  97. >a42:"Other Miscellaneous Deductions
  98. >a43:"  25 Misc. deductions not subject to 2% limit
  99. >c43:0
  100. >a44:"Total Itemized Deductions
  101. >a45:"  26 Total Itemized Deductions
  102. >c45:=c12+c17+c25+c31+c33+c35+c41+c43 
  103. >a1
  104. \aB:TAXC.87
  105.