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 / TAXC.87 < prev   
Text File  |  2000-06-30  |  2KB  |  96 lines
  1. >a1:"SCHEDULE C -- PROFIT OR (LOSS) FROM BUSINESS OR PROFESSION
  2. >a1:\wc35
  3. >b1:\wc20
  4. >c1:\wc20
  5. >a3:"     This spreadsheet relates to "taxa.87"
  6. >a5:"Income
  7. >a6:"  1a  Gross Receipts
  8. >c6:0
  9. >a7:"  1b  Less: Returns and Allowances
  10. >c7:0
  11. >a8:"  1c  Line 1a - 1b
  12. >c8:=c6-c7@
  13. >a9:"  2   Cost of goods sold and/or operations
  14. >c9:0
  15. >a10:"  3   Gross Profit
  16. >c10:=c8-c9@
  17. >a11:"  4   Other income
  18. >c11:0
  19. >a12:"  5   Gross Income
  20. >c12:=c10+c11
  21. >a14:"Deductions
  22. >a15:"  6   Advertising
  23. >c15:0
  24. >a16:"  7   Bad debts
  25. >c16:0
  26. >a17:"  8   Bank Service Charges
  27. >c17:0
  28. >a18:"  9   Car and truck expenses
  29. >c18:0
  30. >a19:"  10  Commissions
  31. >c19:0
  32. >a20:"  11  Depletion
  33. >c20:0
  34. >a21:"  12  Depreciation (Form 4562)
  35. >c21:0
  36. >a22:"  13  Dues and Publications
  37. >c22:0
  38. >a23:"  14  Employee Benefit Programs
  39. >c23:0
  40. >a24:"  15  Freight
  41. >c24:0
  42. >a25:"  16  Insurance
  43. >c25:0
  44. >a26:"  17  Interest
  45. >c26:0
  46. >a27:"    a Mortgage (financial institutions)
  47. >c27:0
  48. >a28:"    b Other
  49. >c28:0
  50. >a29:"  18  Laundry and cleaning
  51. >c29:0
  52. >a30:"  19  Legal and professional services
  53. >c30:0
  54. >a31:"  20  Office expense
  55. >c31:0
  56. >a32:"  21  Pension and profit-sharing
  57. >c32:0
  58. >a33:"  22  Rent 
  59. >c33:0
  60. >a34:"  23  Repairs
  61. >c34:0
  62. >a35:"  24  Supplies
  63. >c35:0
  64. >a36:"  25  Taxes
  65. >c36:0
  66. >a37:"  26  Travel and entertainment
  67. >c37:"         ---
  68. >a38:"    a Travel
  69. >b38:0
  70. >c38:"         ---
  71. >a39:"    b Meals and entertainment
  72. >b39:0
  73. >c39:"         ---
  74. >a40:"    c Enter 10% of line 26b
  75. >b40:=b39*.20@
  76. >c40:"         ---
  77. >a41:"    d Subtract line 26c from 26b
  78. >c41:=b39-b40@
  79. >a42:"  27  Utilities and phone
  80. >c42:0
  81. >a43:"  28a Wages
  82. >b43:0
  83. >c43:"         ---
  84. >a44:"  28b Jobs Credit
  85. >b44:0
  86. >c44:"         ---
  87. >a45:"  28c  Line 28a - 28b
  88. >c45:=b43-b44@
  89. >a46:"  29  Other expenses
  90. >c46:0
  91. >a47:"  30  Total Deductions
  92. >c47:=sum(c15:c46)@
  93. >a49:"  31  Net Profit or (Loss)
  94. >c49:=c12-c47@
  95. >a1
  96.