home *** CD-ROM | disk | FTP | other *** search
/ Oakland CPM Archive / oakcpm.iso / sigm / vol115 / t1-tax82.cal (.txt) < prev    next >
Encoding:
SuperCalc Worksheet  |  1985-02-10  |  16.5 KB  |  337 lines
  1. SuperCalc Ver.  1.05
  2. FEDERAL AND ONTARIO INDIVIDUAL INCOME TAX RETURN - T1 GENERAL
  3. "FEDERAL AND ONTARIO INDIVIDUAL INCOME TAX RETURN - T1 GENERAL
  4. this form.
  5. "T1 general tax form for 1981 by  Bill Wood, Mississauga, Ontario.
  6. "Revised for 1982 by  Gary A Porter CGA , Toronto, Ont
  7. "*****************************************
  8. "IDENTIFICATION
  9. equired schedu
  10. "ACC. #
  11.    Line 3
  12. T1 uses two
  13. "NAME:
  14. ott Carmichael
  15. "Birth Date
  16. "Address:
  17. ions.
  18. "Marital Stat
  19. ***********
  20. "Spouse Name
  21. en McCoy
  22. "Spouse SIN
  23. ith U.I.C. rep
  24. "Postal Code
  25. O INDIVIDUA
  26. "Prov. Dec 31
  27. "Occupation
  28. T1 GENERAL
  29. "Employer
  30. "***********************************************************************
  31. "CALCULATION OF FEDERAL POLITICAL CONTRIBUTION TAX CREDIT
  32. "Total federal political contributions
  33. "Allowable credit
  34. "% of first
  35. IF(E18>E19,(C19*E19)/100,(E18*C19)/100)
  36. "% of next
  37. IF(E18>E19+E20,(C20*E20)/100,IF(E18-E19<0,0,((E18-E19)*C20)/100))
  38. 3>E14+E15,(C15*
  39. "% exceeding
  40. IF(E18<E19+E20,0,((E18-(E19+E20))*C21)/100)
  41. "maximum
  42. IF(SUM(F19:F21)>E22,E22,SUM(F19:F21))
  43. "***********************************************************************
  44. "***********************************************************************
  45. "UNEMPLOYMENT INSURANCE BENEFIT REPAYMENT PAYABLE
  46. "Unemployment ins. benefits
  47. "Benefits repaid in the year
  48. "Net unemployment ins. benefits received
  49. in the year
  50. F27-F28
  51. "Net income
  52. "Base amount
  53. 27300
  54. "Net income in excess of base amount
  55. IF(OR(F27<0,F27=0),0,IF(F31-F32<0,0,F31-F32))
  56. "Benefits repayable
  57. "% A or B whichever less
  58. IF(F29<0,0,(MIN(F29,F33)*C35)/100)
  59. "***********************************************************************
  60. "***********************************************************************
  61. "CANADA PENSION PLAN CONTRIBUTION ON SELF-EMPLOYED EARNINGS
  62. "Contributory self-employed earnings
  63. "Contrib. earnings from employ.(C or I of T4)
  64.  of T4)
  65. "Total contributory earnings
  66. SUM(E40:E41)
  67. "Basic CPP exemption of
  68. "Earnings subject to contr. (max.)
  69. 14900
  70. IF(E42-E43>D44,D44,IF(E42-E43<0,0,E42-E43))
  71. "Contribution ( % earnings )
  72. o con.)
  73. (E44*D45)/100
  74. "Contributions through employment (form T4)
  75. "Times 2 >
  76. E46*2
  77. "CPP contributions payable
  78. IF(F45-F47<0,0,F45-F47)
  79. "***********************************************************************
  80. "CALCULATION OF TOTAL INCOME  ******************
  81. "Total earnings from box C on T4 slips
  82. box C on T4 slips
  83. "Commissions box L on T4 slips
  84. "Other employment income
  85. (guide item 3)
  86. "Total employment earnings
  87. al employm
  88. E52+E54
  89.      B 
  90. "Employment exp. max.=
  91. "3% of emp. earnings =
  92. ngs =
  93. E52*.03
  94.      B 
  95. "Employment expense deduction
  96. MIN(C58:C59)
  97. "Other allowable exp.
  98. "Total employment expenses
  99. D60+D61
  100. "Net employment earnings
  101. rnings
  102. E56-E62
  103. "Old age security pension  (T4A slips)
  104. "Canada or Quebec pension benefits (T4A slips)
  105. "Other pensions or superannuation (T4A slips)
  106. "Taxable family allowance  (TFA1 slips)
  107. "Unemployment insurance benefits (T4U slips)
  108. "Taxable dividends (from schedule 4)
  109. "Interest & investment income (schedule 4)
  110. 16.85
  111. "Rental income   Gross
  112. le 7)      Net
  113. "Taxable capital gains/loss (schedule 2)
  114. 54.99
  115. "Other income  (Guide item 17)
  116. "Business income Gross
  117.         Net
  118. "Profes. income  Gross
  119.          Net
  120. "Commis. income  Gross
  121.          Net
  122. "Farming income  Gross
  123.          Net
  124. "Fishing income  Gross
  125.          Net
  126. "Total income
  127. al income
  128. SUM(E64:E80)
  129.      B 
  130. "CALCULATION of TAXABLE INCOME  *************
  131. "Canada or Quebec pension plan
  132. "contributions through employment
  133. "             (box D of T4)  max. 268.20
  134. "Contributions payable on self-emp. earnings
  135. "U.I.C. premiums (box E on T4) max. 300.30
  136. ax. 294.84
  137. "Registered ret. savings plan
  138. "R.R.S.P. premiums
  139. "R.H.O.S.P. contributions
  140. "Union, professional dues
  141. "Tuition fees   (gride item 25)
  142. "Child care expenses (schedule 5)
  143. "Business investment losses
  144. "Other deductions (not U.I.C. deductions)
  145. "Other deductions (U.I.C. only)
  146. SUM(E87:E98)
  147. "Net income
  148. F82-F99
  149.      B 
  150. "Basic personal exemption
  151. "Age exemption  $2220
  152. "Married exemption  (set spouses income to -1 if no spouse clamed)
  153. "     If spouse income not over
  154. "           Spouse's net income
  155. "Claim
  156. IF(D108<D107,IF(D107-D108>3110,3110,D107-D108),0)
  157. IF(D108<0,0,D109)
  158. "Total claim for wholly dependent children
  159. "Additional personal exemptions (schedule 6)
  160. "Total personal exemptions
  161. al persona
  162. SUM(E103:E112)
  163.    B 
  164. "Net income less Personal exemptions
  165. F101-F114
  166.      B 
  167. "Standard deduction
  168. "Medical expenses
  169. "3% of Net income
  170. .03*F101
  171.      B 
  172. "Allowable medical
  173. IF(D120<D121,0,D120-D121)
  174. "Charitable donations
  175. 111111
  176. "Total
  177. D122+D123
  178.      B 
  179. "Allowable deduction
  180. IF(D124<C119,C119,D124)
  181. "Interest,dividend,capital gains deduction
  182. ction
  183. C70,D75)
  184. "Pension income deduction
  185. "Deduction for blind, confined to bed/weelchair
  186. "Education deduction
  187. "Eligible deduction transferred from spouse
  188. "Gifts to Canada or a province
  189. "Unemployment insurance benefit repayment payable
  190. "Non-capital losses of other years
  191. "Capital losses of other years
  192. SUM(E125:E135)
  193. "Tax rate lookup table for 1981
  194. "Taxable income
  195. F116-F136
  196. 11120
  197. 15568
  198. 20016
  199. 31136
  200. 53376
  201. 10000000000000
  202. 11120
  203. 15568
  204. 20016
  205. F132-M134)+M13
  206. 31136
  207. 53376
  208. 10000000000000
  209. "***********************************************************************
  210. 13233
  211. 10000000000000
  212. "SCHEDULE 1  Detailed tax calculation
  213. (F132-O134)+O13
  214. F132-Q134)+Q13
  215. "(uses lookup table at G132-U135)
  216. "Federal income tax
  217. "Tax income
  218. "On first
  219. LOOKUP(B144,G137:R137)
  220. On first
  221. "   tax is
  222. LOOKUP(B144,G138:R138)
  223. "On remaining
  224. B144-B145
  225. 9,G132:U13
  226. LOOKUP(E145,G139:R139)*100
  227. LOOKUP(E140,G134:U134)*100
  228. (B146*C146)/100
  229. "Total federal income tax on taxable income
  230. E145+E146
  231. 9,G134:U134)
  232. "Tax adjustment
  233. "Total
  234. justmen
  235. F147+F148
  236. "Federal dividend tax credit
  237. 22.67
  238. (D150*E71)/100
  239. "Basic tax
  240. F149-F150
  241. "Federal tax reduction
  242. ax on t
  243. "If basic tax is:
  244. basic tax
  245. "less than
  246. " use basic
  247. "Spouses's unused tax credit
  248. "maximum=
  249. IF(F151<B155,F151,B155)
  250. 57)/100)))
  251. ,IF((F151*D157)/100>C158,C158,(F151*D157)/100)))
  252. "Federal tax
  253. F151-F158-F156
  254. "Federal foreign tax credit
  255. "Foreign income or profits tax paid
  256. eige country
  257. "Net foreign income
  258. 53.79
  259. "    =
  260. (C163/(F101+E127+E135))*(F159+F150)
  261. MIN(E162:E163)
  262. "Feneral tax payable
  263. F159-F164
  264. "Ontario income tax
  265. "Basic Ontario income tax
  266. "% basic federal tax
  267. (F151*C169)/100
  268. "Provincial foreign tax credit (form T2036)
  269. "Ontario tax
  270. F169-F170
  271. "Ontario tax reduction
  272. "taxable income =
  273. "If taxable income is:
  274. " or less reduction is Ontario tax
  275. "Over
  276. " reduction is zero
  277. "Between the two reduction is calculated =
  278. IF(D174<A176,F171,IF(D174>B177,0,(B177-D174)/2))
  279. "Ontario tax payable
  280. F171-F178
  281. "***********************************************************************
  282. "Taxable income
  283. "Federal tax payable
  284. "Federal political contribution
  285. "Federal tax payable before business investment tax credit
  286. F184-F185
  287. "Business investment tax credit
  288. "Federal tax payable before employment tax credit
  289. F186-F187
  290. "Employment tax credit claimed
  291. "Net federal tax payable
  292. F188-F189
  293. "Ontario tax payable
  294. "C.P.P. contribution payable on self-employed earnings
  295. yed earnings
  296. "U.I.C. benefit repayment payable
  297. "Total payable
  298. SUM(F190:F193)
  299. "Tax deducted per information slips
  300. 27.77
  301. information 
  302. "Ontario tax credits (guide 68)
  303. "C.P.P. overpayment (guide 19)
  304. "U.I.C. overpayment (guide 20)
  305. "Amounts paid by instalments
  306. "Child tax credit (from shedule 10)
  307. "Total credits
  308. SUM(E196:E201)
  309. "Difference
  310. F194-F202
  311. "Refund
  312. IF(F203>0,0,F202-F194)
  313. "Balance due
  314. IF(F203>0,F203,0)
  315. "***********************************************************************
  316. "***********************************************************************
  317. "SUMMARY OF TAX
  318. "Total tax of
  319. " is:
  320. IF(C214<.01,0,(C214/F82)*100)
  321. " % of total income
  322. IF(C214<.01,0,(C214/F101)*100)
  323. " % of net income
  324. IF(C214<.01,0,(C214/F137)*100)
  325. " % of taxable income
  326. "The tax on the last $1.00 of income=
  327. ((C146*C169)/100)+C146
  328. "UNUSED FEDERAL TAX REDUCTION IS:
  329. 200-F158
  330. "***********************************************************************
  331. "***********************************************************************
  332. "PAGE 1 - PRINT A1:F14 & A51:F82
  333. "PAGE 2 - PRINT A84:F137
  334. "PAGE 3 - PRINT A16:F49
  335. "PAGE 4 - PRINT A183:F223
  336. "SCHEDULE 1 - PRINT A140:F179
  337.