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 |
BPA_org*0.15 +0.15*Taper(BPA_ins, MINA(earn,BPA_ins_thrsh2),BPA_ins_thrsh1,BPA_ins_redn) + Empl_crd |
|
|
|
S |
IF(AND(Married=1, earn_spouse >0),BPA_org*0.15 +0.15*Taper(BPA_ins, MINA(earn_spouse,BPA_ins_thrsh2),BPA_ins_thrsh1,BPA_ins_redn),0)+IF(AND(Married=0, tax_inc_spouse >0),BPA_org*0.15-Taper(BPA_org*0.15, tax_inc_spouse,Sp_crd_thrsh,Sp_crd_wth) +0.15*Taper(BPA_ins, MINA(earn_spouse,BPA_ins_thrsh2),BPA_ins_thrsh1,BPA_ins_redn),0)+(earn_spouse>0)*Empl_crd |
|
Spouse credit |
spouse_cr |
P |
IF(OR(Married=1,Children>0),Taper(BPA_org*0.15 +0.15*Taper(BPA_ins, MINA(tax_inc_spouse,BPA_ins_thrsh2),BPA_ins_thrsh1,BPA_ins_redn),earn_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 |
MAX(0,MIN((CWB_max+CWB_max_fam*OR(Married=1,Children>0)),(CWB_phzn_rt*MAX(0,F_EARN-CWB_phzin_thrsh)))-MAX(0,CWB_phzout_rt*MAX(0,(F_NETINC)-MIN(CWB_see,S_EARN,S_NETINC)-(CWB_phzout_thrsh+CWB_phzn_thrsh_fam*OR(Married=1,Children>0))))) |
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 – Total with affordability measure |
GST_cr afordability |
P |
Taper(1.5*(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 - Adult with affordability measure |
GST_cr_adult afordability |
P |
Taper(1.5*(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 |
|
GST Credit - Child with affordability measure |
GST_cr_child afordability |
P |
GST_cr affordability - GST_cr_adult afordability |
|
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_child +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 |