1.
Earnings
earn
2.
Allowances:
tax_al
P
IF(earn_princ<basic_al_lim1,basic_al*basic_al_rate1,IF(earn_princ<basic_al_lim2,basic_al* basic_al_rate2,IF(earn_princ<basic_al_lim3,basic_al* basic_al_rate3,basic_al* basic_al_rate4)))+ ROUNDUP(Married*(earn_spouse- MIN(emp_inc_max,MAX(emp_inc_min,Tax(earn_spouse,emp_inc_sch)))<=spouse_al_ceil)*spouse_al*VLOOKUP(positive(earn_princ- MIN(emp_inc_max,MAX(emp_inc_min,Tax(earn_princ,emp_inc_sch)))),taxpayer_lim,2,TRUE),-4)) + ROUNDUP(Married*VLOOKUP(Positive(earn_spouse- MIN(emp_inc_max,MAX(emp_inc_min,Tax(earn_spouse,emp_inc_sch)))),spouse_al_sp,2,TRUE)*VLOOKUP(positive(earn_princ- MIN(emp_inc_max,MAX(emp_inc_min,Tax(earn_princ,emp_inc_sch)))),taxpayer_lim,2,TRUE),-4)+ Children*child_al +MAX((earn_princ*VLOOKUP(earn_princ,emp_inc_sch,2,TRUE)+VLOOKUP(earn_princ,emp_inc_sch,3,TRUE)),emp_inc_min) + SSC_princ
S
MIN(earn_spouse, IF(earn_spouse<basic_al_lim1,basic_al*basic_al_rate1,IF(earn_spouse<basic_al_lim2,basic_al* basic_al_rate2,IF(earn_spouse<basic_al_lim3,basic_al* basic_al_rate3,basic_al* basic_al_rate4)))+ MAX((earn_spouse*VLOOKUP(earn_spouse,emp_inc_sch,2,TRUE)+VLOOKUP(earn_spouse,emp_inc_sch,3,TRUE)),emp_inc_min) + SSC_spouse)
3.
Credits in taxable income
taxbl_cr
B
4.
CG taxable income
tax_inc
B
Positive(earn-tax_al)
5.
CG tax before credits
CG_tax_excl
B
Positive(Tax(tax_inc, tax_sch))
6.
Tax credits :
tax_cr
B
7.
CG tax
CG_tax
B
CG_tax_excl*surtax
8.
State and local taxes
Local taxable income
local_tax_inc
P
Positive(earn_princ- (s_basic_al+ ROUNDUP(VLOOKUP(positive(earn_princ- MIN(emp_inc_max,MAX(emp_inc_min,Tax(earn_princ,emp_inc_sch)))),taxpayer_lim,2,TRUE)*Married*((earn_spouse-(earn_spouse>0)*MAX(emp_inc_min,Tax(earn_spouse,emp_inc_sch))<=s_spouse_al_ceil)*s_spouse_al+VLOOKUP(Positive(earn_spouse-(earn_spouse>0)*MAX(emp_inc_min,Tax(earn_spouse,emp_inc_sch))),s_spouse_al_sp,2,TRUE))+Children*s_child_al+ MAX((earn_princ*VLOOKUP(earn_princ,emp_inc_sch,2,TRUE)+VLOOKUP(earn_princ,emp_inc_sch,3,TRUE)),emp_inc_min) +SSC_princ))
S
Positive(earn_spouse-(s_basic_al+(earn_spouse>0)* MAX((earn_spouse*VLOOKUP(earn_spouse,emp_inc_sch,2,TRUE)+VLOOKUP(earn_spouse,emp_inc_sch,3,TRUE)),emp_inc_min) +SSC_spouse))
Local tax
local_tax
P
(earn_princ-MAX(emp_inc_min,Tax(earn_princ,emp_inc_sch))>350000+(Married*(earn_princ - (earn_princ>0)*MAX(emp_inc_min,Tax(earn_princ, emp_inc_sch))<='s_spouse_al_ceil)+Children>0)*((Married*(earn_princ' - (earn_princ>0)*MAX(emp_inc_min,Tax(earn_princ, emp_inc_sch))<='s_spouse_al_ceil)+Children)*350000+100000+210000))*(pref_per_cap+mun_per_cap)+(earn_princ-MAX(emp_inc_min,Tax(earn_princ,emp_inc_sch))>350000+(Married*(earn_princ' - (earn_princ>0)*MAX(emp_inc_min,Tax(earn_princ, emp_inc_sch))<='s_spouse_al_ceil)+Children>0)*((Married*(earn_princ' - (earn_princ>0)*MAX(emp_inc_min,Tax(earn_princ, emp_inc_sch))<=s_spouse_al_ceil)+Children)*350000+100000+320000))*Positive(Tax(Positive(earn_spouse-tax_al_spouse),local_sch)-IF(Positive(earn_spouse-tax_al_spouse)>2000000,MAXA(2500,((Positive(earn_spouse-tax_al_spouse)-MAX(emp_inc_min,Tax(earn_princ,emp_inc_sch)))-(Positive(earn_spouse-tax_al_spouse)-2000000))*5%),MINA((Positive(earn_spouse-tax_al_spouse)-MAX(emp_inc_min,Tax(earn_princ,emp_inc_sch))),Positive(earn_spouse-tax_al_spouse))*5%))
S
(earn_spouse - (earn_spouse>0)*MAX(emp_inc_min,Tax(earn_spouse, emp_inc_sch))>350000)*(pref_per_cap+mun_per_cap+Positive(Tax(local_tax_inc_spouse,local_sch)-IF(local_tax_inc_spouse>2000000,MAXA(2500,((local_tax_inc_spouse-tax_inc_spouse)-(local_tax_inc_spouse-2000000))*5%),MINA((local_tax_inc_spouse-tax_inc_spouse),local_tax_inc_spouse)*5%)))
9.
Employees' soc security
SSC
B
SSC_pens*MIN(earn, pens_ceil)+SSC_sick*MIN(earn, sick_ceil)+SSC_unemp*earn
11.
Cash transfers
cash_trans
B
IF(Children>0,IF(Positive(princ_inc - princ_empl_inc)<Child_transfer_lim+(Child_transfer_lim_incr*Children), Child_transfer,Child_transfer2)*Children,0) +Child_rear(Married, princ_inc - princ_empl_inc -Child_rear_c,Children,child_rear_sch)
13.
Employer's social security
SSC_empr
B
SSC_pens*MIN(earn, pens_ceil)+SSC_sick*MIN(earn, sick_ceil)+(SSC_empr_unemp+SSC_empr_oth)*earn
