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 |