|
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
|