|
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_avg,wr_allow_max-wr_rate1*((earn-SSC)-(wr_lim_avg))+oth_ded_exp,
IF(earn-SSC<=wr_lim_max,wr_allow_avg-wr_rate2*((earn-SSC)-(wr_lim_avg))+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)))
|