|
1.
|
Earnings
|
earn
|
|
|
|
2.
|
Allowances
|
tax_al
|
B
|
0
|
|
3.
|
Credits in taxable income
|
taxbl_cr
|
|
|
|
4.
|
CG taxable income
|
tax_inc
|
B
|
Earn
|
|
5.
|
CG tax before credits:
|
Basic_Fed_tax
|
B
|
Tax(earn, Fed_sch)
|
|
|
Basic Federal tax
|
Basic_Fed_tax
|
B
|
Tax(earn, Fed_sch)
|
|
6.
|
Tax credits :
|
|
|
|
|
|
Basic credit
|
basic_cr
|
P
|
Basic_cred + Empl_crd
|
|
|
|
|
S
|
(earn_spouse>0)*Empl_crd+IF(AND(Married=1,earn_spouse>0),Basic_cred,0)+IF(AND(Married=0,tax_inc_spouse>0),Basic_cred-Taper(Spouse_cred,tax_inc_ spouse,Sp_crd_thrsh,Sp_crd_wth),0)
|
|
|
Spouse credit
|
spouse_cr
|
P
|
IF(OR(Married=’1,Children>0),Taper(Spouse_cred,’ tax_inc_spouse, Sp_crd_ thrsh,Sp_crd_wth), 0)
|
|
|
Unemployment insurance
|
unemp_cr
|
B
|
Unemp_crd_rate*SSC
|
|
|
Total (wastable) tax credits
|
tax_cr
|
B
|
basic_cr+spouse_cr+unemp_cr
|
|
|
Working Income Tax Benefit
|
WITB
|
P
|
IF(Married>0,MAX(0,MIN(WITB_max+WITB_max_fam,(WITB_phzn_rt* MAX(0, earn_total-WITB_phzin_thrsh)))-MAX(0,WITB_phzout_rt*MAX(0,earn_total-(WITB_phzout_thrsh+WITB_phzn_thrsh_fam)))), IF(Children>0,MAX(0,MIN (WITB_max+WITB_max_fam,(WITB_phzn_rt*MAX(0,earn_total-WITB_phzin_ thrsh)))-MAX(0,WITB_phzout_rt*MAX(0,earn_total-(WITB_phzout_thrsh+WITB_ phzn_thrsh_fam)))), MAX(0,MIN(WITB_max,(WITB_phzn_rt*MAX(0,earn_total-WITB_phzin_thrsh)))-MAX(0,WITB_phzout_rt*MAX(0,earn_total-WITB_phzout_ thrsh)))))
|
|
7.
|
CG tax
|
CG_tax
|
B
|
Positive(Basic_Fed_tax-tax_cr)-WITB
|
|
8.
|
State and local taxes
|
|
|
|
|
|
Liable provincial tax
|
Prov_tax_sch
|
B
|
Tax(earn, Prov_sch)
|
|
|
Provincial tax credits
|
Prov_tax_cred
|
P
|
P_basic_crd+P_unem_tc_rt*SSC_princ+IF(AND(Married=’0,’ Children>0), P_spouse_crd, Married*Taper(P_spouse_crd, earn_spouse, P_sp_crd_thr, P_sp_ crd_wd))
|
|
|
|
|
S
|
=(earn_spouse>0)*(P_unem_tc_rt*SSC_spouse)+OR(Married=1,Children>0)*P_basic_crd
|
|
|
Provincial surtax
|
Prov_surtax
|
B
|
P_sur_rt1*Positive(Prov_tax_sch-Prov_tax_cred-P_sur_thr1)+P_sur_rt2*Positive(Prov_tax_sch-Prov_tax_cred-P_sur_thr2)
|
|
|
Provincial tax reduction
|
Prov_tax_redn
|
B
|
MAX(2*(P_tax_red+Children*P_tr_chld)-(Prov_tax_sch-Prov_tax_cred+Prov_ surtax), 0)
|
|
|
Provincial sales tax credit
|
Prov_tax_stcred
|
P
|
Taper(IF(Married=’1,’ 2, 1)*P_sales_cred+Children*P_salcr_chd, earn_total, IF(Married+Children=’0,’ P_ps_thresh,P_ps_thr_sen),P_ps_red_rt)
|
|
|
Liable provincial tax
|
Prov_tax
|
B
|
Positive(Prov_tax_sch-Prov_tax_cred+Prov_surtax-Prov_tax_redn)
|
|
9.
|
Employees’ soc security:
|
|
|
|
|
|
Canada Pension Plan
|
CPP
|
B
|
MIN(CPP_rate*Positive((earn-CPP_ex), CPP_max)
|
|
|
Unemployment insurance
|
Unemp
|
B
|
MIN(Unemp_rate*earn, Unemp_max)
|
|
|
State health premium
|
Prov_health
|
B
|
MIN(Hstep(tax_inc, P_hlth_sch), P_hlth_max)
|
|
|
Total Employees’soc security
|
SSC
|
B
|
CPP+Unemp+Prov_health
|
|
11.
|
Cash transfers (nonwastable)
|
|
|
|
|
|
Canada Child Benefit
|
CCB
|
P
|
Taper(Taper(Children*ccb_credit2,MINA(earn_total, ccb_crd_thrsh2), ccb_crd_ thrsh1, IF(children=’1,’ ccb_1st _redn1, IF(children=’2,’ ccb_1st _redn2, IF(children=’3,’ ccb_1st _redn3, IF(children>3, ccb_1st _redn4, 0))))), earn_total, ccb_crd_thrsh2, IF(children=’1,’ ccb_2nd _redn1, IF(children=’2,’ ccb_2nd _redn2, IF(children=’3,’ ccb_2nd _redn3, IF(children>3, ccb_2nd _redn4, 0)))))
|
|
|
GST Credit Total
|
GST_cr
|
P
|
Taper((GST_crd_ad+(Married=1)*(GST_crd_ad+Children*GST_crd_ch)+(Married=0)*(Children>0)*(GST_crd_ad+GST_crd_sgsp+Positive(Children-1)*GST_crd_ ch)+(Married=0)*(Children=’0)*Positive(MIN(GST_crd_sgsp,’ (earn_total-GST_ sgsp_thrsh)*GST_sgsp_rate))), earn_total, GST_crd_thrsh, GST_crd_redn)
|
|
|
GST Credit Adult
|
GST_cr_adult
|
P
|
Taper((GST_crd_ad+(Married=1)*(GST_crd_ad)+(Married=’0)*Positive(MIN(GST_crd_sgsp,’ (earn_total-GST_sgsp_thrsh)*GST_sgsp_rate))), earn_total, GST_ crd_thrsh, GST_crd_redn)
|
|
|
GST Credit Child
|
GST_cr_child
|
P
|
GST_cr-GST_cr_adult
|
|
|
Ontario child benefit
|
Prov_child_ben
|
P
|
Taper(Children*P_ch_amt,earn_total,P_ch_thresh,P_ch_redn_rate)
|
|
|
Ontario sales tax credit
|
Prov_sales_cr
|
P
|
Taper(IF(Married=1,2,1)*P_sales_cred+Children*P_salcr_chd,earn_total,IF(Married+Children=’0,’ P_ps_thresh,P_ps_thr_sen),P_ps_red_rt)
|
|
|
Total Cash Transfers
|
Cash_tran
|
P
|
CCB+GST_cr+Prov_child_ben+ Prov_sales_cr
|
|
13.
|
Employer’s soc security
|
|
|
|
|
|
Canada Pension Plan
|
CPP_empr
|
B
|
CPP
|
|
|
Unemployment insurance
|
Unemp_empr
|
B
|
Unemp*Unemp_emplr
|
|
|
Ontario Employers Health Tax
|
Health_empr
|
B
|
earn*emp_healthtax
|
|
|
Ontario Workers Compensation
|
Comp_empr
|
B
|
MIN(earn, emp_workcomp_ceil)*emp_workcomp
|
|
|
Total Employer’s soc security
|
SSC_empr
|
B
|
CPP_empr+Unemp_empr+Health_empr+Comp_empr
|