home *** CD-ROM | disk | FTP | other *** search
/ CP/M / CPM_CDROM.iso / cpm / programs / spredsht / taxcal11.lbr / SCHEDC.CZL / SCHEDC.CAL (.txt)
SuperCalc Worksheet  |  1987-03-22  |  4KB  |  153 lines
  1. SuperCalc ver.  1.00
  2. Schedule C - 1986
  3. "Schedule C - 1986
  4. "Real Estate Taxes
  5. "Home Owners Insurance
  6. 8+921.2
  7. "Line 1a
  8. "Gross Receipts
  9. urance
  10. "Line 1b
  11. "Returns & Allow
  12. rance
  13. "Line 1c
  14. & All
  15. "Net Receipts
  16. rance
  17. C4-C5
  18. "Line 2
  19. "Cost of Sales
  20. rance
  21. "Line 3
  22.  Sales
  23. "Gross Profit
  24. rance
  25. D6-D7
  26. "Line 4a
  27. "W'dfall Tax Cred
  28. "Line 4b
  29. Tax C
  30. "Other Income
  31. "Line 5
  32. "Total Income
  33. SUM(D8:D10)
  34. "Deductions
  35. "Line 6
  36. "Advertising
  37. "Line 7
  38. "Bad Debts
  39. "Line 8
  40. "Bank Svc Chgs
  41. "Line 9
  42. c Chgs
  43. "Car & Trk Exp
  44. "Line 10
  45. "Commissions
  46. "Line 11
  47. "Depletion
  48. "Line 12
  49. "Depreciation
  50. D(.21*
  51. "Line 13
  52. "Dues & Pubs
  53. "Line 14
  54. "Epl'e Benf't Prog
  55. "Line 15
  56. "Freight
  57. "Line 16
  58. "Insurance
  59. "Detroit
  60. "Consumers
  61. "Michigan
  62. "Line 17
  63. "Laundry & Cl'n'g
  64. "Edison
  65.  & Cl'
  66. "Power
  67.  & Cl'    
  68. "Bell & ATT
  69. "Water
  70. "Line 18
  71. "Legal & Prof Svcs
  72. "January
  73. Prof 
  74. 7.61    
  75. "Line 19
  76. Prof 
  77. "Mortgage Interest
  78. "February
  79. 2.62    
  80. "Line 20
  81. "Office Expense
  82. +4.82
  83. "March
  84.  Expens
  85. "Line 21
  86. "Other Interest
  87. 39.77
  88. "April
  89. Interes
  90. 0.21    
  91. "Line 22
  92. teres
  93. "Pension
  94. teres
  95. "Line 23
  96. "Rent
  97. "June
  98. "Line 24
  99. "Repairs
  100. "July
  101. "Line 25
  102. "Supplies
  103. "August
  104. "Line 26
  105. "Taxes
  106. "September
  107.      P 0
  108. "Line 27
  109. "Travel & Ent'ment
  110. "October
  111.  Ent'
  112. ctob    !P 0
  113. "Line 28
  114.  Ent'
  115. "Util & Tel
  116. ROUND(15%SUM(H37:K37),2)
  117. "November
  118.     "P 0
  119. "Line 29a
  120. "Wages
  121. "December
  122. 1.82    #P 0
  123. "Line 29b
  124. "Job Credit
  125. SUM(H25:H36)
  126. H37:K37
  127. SUM(I25:I36)
  128. H37:K37    $
  129. SUM(J25:J36)
  130. H37:K37
  131. SUM(K25:K36)
  132. H37:K37
  133. "Line 29c
  134. "Difference
  135. C36-C37
  136. "Line 30
  137. "Wnd'fl Prft Tax
  138. "Line 31
  139. rft T
  140. "Other Expenses
  141. "Line 31a
  142. "Line 31b
  143. "Line 31c
  144. "Line 31d
  145. "Line 31e
  146. "Line 31f
  147. "Line 31g
  148. "Line 32
  149. SUM(C13:C35)+C38+SUM(C39:C47)
  150. ______
  151. "Line 33
  152. D11-D49
  153.