1. |
Earnings |
earn |
B |
for individual taxation: earn=earn_princ, or earn=’earn_sp’ for joint (family) taxation: earn=earn_princ+earn_sp |
2. |
Allowances: |
|
|
|
|
Work related, individual |
work_ind |
B |
IF(earn-SSC<=wr_lim_min,wr_allow_max+oth_ded_exp,IF(earn-SSC<=wr_lim_ max,wr_allow_max-wr_rate*((earn-SSC)-(wr_lim_min))+oth_ded_exp,oth_ded_ exp)) |
|
Work related, family |
work_fam |
J |
IF(AND(earn_sp=0,married=0,children=0),0,IF(earn_total-SSC_fam<=wr_lim_min, wr_allow_max+oth_ded_exp,IF(earn_total-SSC_fam=wr_lim_max,wr_allow_max-wr_rate*((earn_total-SSC_fam)-(wr_lim_min))+oth_ded_exp,oth_ded_exp))) |
|
Joint taxation allowance |
joint_allow_fam |
J |
IF(AND(Married=0,Children=0),0,IF(AND(Married=0,Children>0),joint_tax_allow_ fam2,joint_tax_allow_fam1)) |
|
Personal and family exempt income, individual |
ex_inc_ind |
B |
per_fam_exempt_inc |
|
Personal and family exempt income, family |
ex_inc_fam |
J |
IF(AND(Married=0,Children=0),0,per_fam_exempt_inc) |
|
Children exempt income, individual |
child_ex_inc_ind |
P |
IF(earn_sp=’0,’ (children>0)*(dep_child+(children>1)*dep_child2+(children>2)* dep_child3+(children>3)*(children-3)*dep_child4), (children>0)*(dep_child+ (children>1)*dep_child2+(children>2)*dep_child3+(children>3)*(children-3)* dep_child4)/2) |
|
|
|
S |
IF(earn_sp=’0,’ 0, (children>0)*(dep_child+(children>1)*dep_child2+(children> 2)*dep_child3+(children>3)*(children-3)*dep_child4)/2) |
|
Children exempt income, family |
child_ex_inc_fam |
J |
(children>0)*(dep_child+(children>1)*dep_child2+(children>2)*dep_child3+(children>3)*(children-3)*dep_child4) |
3. |
Credits in taxable income |
taxbl_cr |
B, J |
0 |
4. |
CG taxable income |
tax_inc |
B, J |
IF(AND(Married=’0,’ Children=’0),’ tax_inc_princ, MINA(tax_inc_princ+tax_inc_sp, tax_inc_fam)) |
|
|
tax_inc_ind |
B |
Positive(earn-(work_ind+SSC)) |
|
|
tax_inc_fam |
J |
IF(AND(Married=’0,’ Children), 0, Positive(earn-(work_fam+joint_allow_fam+SSC_ princ+SSC_sp))) |
5. |
CG tax before credits |
CG_tax_ind_excl |
B |
MAXA(0, VLOOKUP(tax_inc_ind, tax_sch_sg, 2)+(tax_inc_ind-VLOOKUP(tax_inc_ ind, tax_sch_sg, 1))*VLOOKUP(tax_inc_ind, tax_sch_sg, 3)) |
|
|
CG_tax_fam_excl |
J |
MAXA(0, VLOOKUP(tax_inc_fam, tax_sch_sg, 2)+(tax_inc_fam-VLOOKUP(tax_ inc_fam, tax_sch_sg, 1))*VLOOKUP(tax_inc_fam, tax_sch_sg, 3)) |
6. |
CG tax credits : |
CG_tax_cr_ind |
B |
MAXA(0,VLOOKUP(ex_inc_ind+child_ex_inc_ind,tax_sch_sg,2)+ ((ex_inc_ind+ child_ex_inc_ind)-VLOOKUP(ex_inc_ind+child_ex_inc_ind,tax_sch_sg,1))* VLOOKUP(ex_inc_ind+child_ex_inc_ind,tax_sch_sg,3)+IF(AND(earn>0,married=0,children>=2),MIN(SP_tax_credit,(SSC+SSC_empr)),0) |
|
|
CG_tax_cr_fam |
J |
MAXA(0,VLOOKUP(ex_inc_fam+child_ex_inc_fam,tax_sch_sg,2)+ ((ex_inc_fam+ child_ex_inc_fam)-VLOOKUP(ex_inc_fam+child_ex_inc_fam,tax_sch_sg,1))* VLOOKUP(ex_inc_fam+child_ex_inc_fam,tax_sch_sg,3)+IF(AND(earn_total>0,married=0,children>=2),MIN(SP_tax_credit,(SSC_fam+SSC_empr_fam)),0) |
7. |
CG tax |
CG_tax_ind |
B |
CG_tax_ind_excl-CG_tax_cr_ind |
|
|
CG_tax_fam |
J |
CG_tax_fam_excl-CG_tax_cr_fam |
8. |
State and local tax before credits |
local_tax_ind_excl |
B |
MAXA(0, VLOOKUP(tax_inc_ind, tax_sch_sa, 2)+(tax_inc_ind-VLOOKUP(tax_ inc_ind, tax_sch_sa, 1))*VLOOKUP(tax_inc_ind, tax_sch_sa, 3)) |
|
|
local_tax_fam_excl |
J |
MAXA(0, VLOOKUP(tax_inc_fam, tax_sch_sa, 2)+(tax_inc_fam-VLOOKUP(tax_ inc_fam, tax_sch_sa, 1))*VLOOKUP(tax_inc_fam, tax_sch_sa, 3)) |
|
local tax credits |
local_tax_cr_ind |
B |
MAXA(0,VLOOKUP(ex_inc_ind+child_ex_inc_ind,tax_sch_sa,2)+ ((ex_inc_ind+ child_ex_inc_ind)-VLOOKUP(ex_inc_ind+child_ex_inc_ind,tax_sch_sa,1))* VLOOKUP(ex_inc_ind+child_ex_inc_ind,tax_sch_sa,3)) |
|
|
local_tax_cr_fam |
J |
MAXA(0,VLOOKUP(ex_inc_fam+child_ex_inc_fam,tax_sch_sa,2)+ ((ex_inc_fam+ child_ex_inc_fam)-VLOOKUP(ex_inc_fam+child_ex_inc_fam,tax_sch_sa,1))* VLOOKUP(ex_inc_fam+child_ex_inc_fam,tax_sch_sa,3)) |
|
State and local tax |
local_tax_ind |
B |
Positive(local_tax_ind_excl-local_tax_cr_ind) |
|
|
local_tax_fam |
J |
Positive(local_tax_fam_excl-local_tax_cr_fam) |
9. |
Employees’ soc security |
SSC |
B |
IF(AND(earn>0, earn<=’min_lim),’ min_lim*(pension_rate+unemp_rate+oth_rate), IF(earn>=’top_lim,’ top_lim*(pension_rate+unemp_rate+oth_rate), earn* (pension_rate+unemp_rate+oth_rate))) |
|
|
SSC_fam |
J |
SSC_princ+SSC_sp |
11. |
Cash transfers |
Child_transf |
|
IF(Children=0,0,IF(earn<=’VLOOKUP(Children,’ SS_child_table,2),SS_child_ benefit*Children, IF(earn<=’VLOOKUP(Children,’ SS_child_table, 3), VLOOKUP (Children, SS_child_table, 3)-earn, 0))) |
13. |
Employer’s SSC |
SSC_empr |
|
IF(AND(earn>0, earn<=’min_lim),’ min_lim*(pension_empr+unemp_empr+ oth_ umpr), IF(earn>=’top_lim,’ top_lim*(pension_empr+unemp_empr+oth_empr), earn*(pension_empr+unemp_empr+oth_empr))) |