1. |
Earnings |
earn |
|
|
2. |
Allowances |
tax_al |
B |
CPP_deduc |
|
Enhanced CPP contribution (deductible portion) |
CPP_deduc |
B |
CPP_ratededuc*MINA(Positive(earn-CPP_ex),(CPP_up-CPP_ex)) |
|
Net income |
Net_inc |
B |
Earn - tax_al |
3. |
Credits in taxable income |
taxbl_cr |
|
0 |
4. |
CG taxable income |
tax_inc |
B |
Net_inc - taxbl_cr |
5. |
CG tax before credits |
CG_tax_bc |
B |
Tax(tax_inc, 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) |
|
Social security |
ssc_cr |
B |
ssc_crd_rate*SSC |
|
Total (wastable) tax credits |
tax_cr |
B |
basic_cr+spouse_cr+ssc_cr |
|
Canada Workers Benefit |
CWB |
J |
IF(Married>0,MAX(0,MIN(CWB_max+CWB_max_fam,( CWB_phzn_rt * MAX(0,net_inc_total-CWB_phzin_thrsh)))-MAX(0, CWB_phzout_rt*MAX(0,net_inc_total-(CWB_phzout_thrsh+ CWB_phzn_thrsh_fam)))), IF(Children>0,MAX(0,MIN(CWB_max+CWB_max_fam,( CWB_phzn_rt*MAX(0,net_inc_total-CWB_phzin_thrsh)))-MAX(0, CWB_phzout_rt*MAX(0,net_inc_total-(CWB_phzout_thrsh+CWB_phzn_thrsh_fam)))), MAX(0,MIN(CWB_max,( CWB_phzn_rt*MAX(0,net_inc_total-CWB_phzin_thrsh)))-MAX(0, CWB_phzout_rt* MAX(0,net_inc_total-CWB_phzout_thrsh))))) |
7. |
CG tax |
CG_tax |
B |
Positive(CG_tax_bc-tax_cr)- CWB |
8. |
State and local taxes |
|
|
|
|
Liable provincial tax |
Prov_tax_sch |
B |
Tax(tax_inc, Prov_sch) |
|
Provincial tax credits |
Prov_tax_cred |
P |
P_basic_crd+P_ssc_tc_rt*SSC_princ+IF(AND(Married=0, Children>0), P_spouse_crd, Married*Taper(P_spouse_crd, net_inc_spouse, P_sp_crd_thr, P_sp_crd_wd)) |
|
|
|
S |
(net_inc_spouse>0)*(P_ssc_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) |
|
Low-income Individuals and Families Tax Credit (LIFT) |
Prov_LIFT_crd |
J |
IF(Married=1,MIN(Taper(MIN(P_LIFT_crd,earn*P_LIFT_phzn_rt), net_inc_total, P_LIFT_cp_thr, P_LIFT_phzout_rt), Taper(MIN(P_LIFT_crd,earn*P_LIFT_phzn_rt),net_inc,P_LIFT_sg_thr,P_LIFT_phzout_rt)),Taper(MIN(P_LIFT_crd,net_inc*P_LIFT_phzn_rt),net_inc,P_LIFT_sg_thr,P_LIFT_phzout_rt)) |
|
Liable provincial tax |
Prov_tax |
B |
Positive(Prov_tax_sch - Prov_tax_cred + Prov_surtax -Prov_tax_redn – Prov_LIFT_crd) |
9. |
Employees' soc security: |
|
|
|
|
Canada Pension Plan contribution (creditable portion) |
CPP_cred |
B |
CPP_rate*MINA(Positive(earn-CPP_ex),(CPP_up-CPP_ex)) |
|
Canada Pension Plan (total) |
CPP |
B |
CPP_deduc+CPP_cred |
|
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(net_inc_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))))), net_inc_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, (net_inc_total-GST_sgsp_thrsh)*GST_sgsp_rate))), net_inc_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, (net_inc_total-GST_sgsp_thrsh) *GST_sgsp_rate))), net_inc_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,net_inc_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,net_inc_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 |