|
1.
|
Earnings
|
earn
|
|
|
|
2.
|
Allowances
|
tax_al
|
B
|
0
|
|
3.
|
Credits in taxable income:
|
|
|
|
|
|
Credits in taxable income of principal
|
taxbl_cr_princ
|
B
|
IF(AND(Children>0,Married=0),Taper(PPS,earn_princ,PPS_lim+PPS_ch_lim*(Children-1),PPS_taper),IF(AND(Children=0,Married=0),taper2(NSAS,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2),IF(Married>0,taper3(NSAP,earn_princ,earn_spouse,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2,NSAP_CES),,0)))
|
|
|
Credits in taxable income of spouse
|
taxbl_cr_spouse
|
B
|
IF(AND(Children>0,Married=0),0,IF(AND(Children=0,Married=0),0,IF(Married>0,taper3(NSAP,earn_spouse,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2,NSAP_CES),0)))
|
|
4.
|
CG taxable income
|
tax_inc
|
B
|
earn+taxbl_cr
|
|
5.
|
CG tax before credits
|
|
|
|
|
|
Medicare Levy
|
med_levy
|
B
|
medicare(tax_inc,sing_lim,m_lim,SAPTO_lim,ch_lim,shade_rate,medic_rate,Married,tax_inc_oth,Children)
|
|
|
Tax liability
|
liab
|
P
|
Tax(tax_inc, tax_sch)
|
|
6.
|
Tax credits :
|
|
|
|
|
|
Low Income Tax Offset
|
low_cr
|
B
|
LITO(Tax_Inc,low_inc_lim,low_inc_cr,low_inc_lim_2,low_inc_redn,low_inc_lim_3,low_inc_redn_2)
|
|
|
Senior Australian and Pensioner Tax Offset
|
sap_cr
|
P
|
IF(AND(taxbl_cr_princ>0,NOT(AND(Children>0,Married=0))),Tax(taxbl_cr_princ,tax_sch),IF(taxbl_cr_princ>0,Taper(SAPTO,tax_inc,SAPTO_thresh,SAPTO_taper),0)
|
|
|
Beneficiary tax offset
|
ben_cr
|
B
|
IF(AND(taxbl_cr>0, NOT(AND(Children>0, Married=0))), Tax(taxbl_cr, tax_sch), 0)
|
|
|
Total
|
tax_cr
|
B
|
low_cr+sap_cr+ben_cr
|
|
7.
|
CG tax
|
CG_tax
|
B
|
Positive(liab-tax_cr) + med_levy
|
|
8.
|
State and local taxes
|
local_tax
|
B
|
0
|
|
9.
|
Employees' soc security
|
SSC
|
B
|
0
|
|
11.
|
Cash transfers:
|
|
|
|
|
|
Family Tax Benefit (Part A)
|
ftbA
|
J
|
IF(PA>0,((FTB_A_max+FTB_A_CES_max+IF(earn_princ+earn_spouse<FTB_A_supp_lim,FTB_A_supp,0))*Children+IF(Children>2,(Children-2)*FTB_A_large,0)),MAX(((FTB_A_max+FTB_A_CES_max+IF(earn_princ+earn_spous<FTB_A_supp_lim,FTB_A_supp,0))*Children-Positive((earn_princ+earn_spous+taxbl_cr_princ+taxbl_cr_spouse)-FTB_A_lim1)*FTB_A_taper1),Positive((FTB_A_base+FTB_A_CES_basic)*Children-Positive((earn_princ+earn_spous+taxbl_cr_princ+taxbl_cr_spouse)-(FTB_A_lim2+(Positive(Children-1))*FTB_A_child))*FTB_A_taper2)))
|
|
|
Family Tax Benefit (Part B)
|
ftbB
|
J
|
IF(earn_princ<FTB_B_lim_p,IF(Children>0,Taper((FTB_B+FTB_B_CES_5),earn_spouse+taxbl_cr_spouse,FTB_B_lim,FTB_B_taper),0),0)
|
|
|
Pharmaceutical Allowance
|
PA
|
J
|
AND(Children>0,Married=0)*IF(Taper(PPS+PA+PPS_CES,earn_princ,PPS_lim+PPS_ch_lim*(Children-1),PPS_taper)>0,PA,0)
|
|
|
Energy Supplement
|
CES
|
J
|
IF(AND(Children>0,Married=0,Taper(PPS+PPS_CES,earn_princ,PPS_lim+PPS_ch_lim*(Children-1),PPS_taper)>0),MAX(0,Taper(PPS+PPS_CES,earn_princ,PPS_lim+PPS_ch_lim*(Children-1),PPS_taper)-Taper(PPS, earn_princ,PPS_lim+PPS_ch_lim*(Children-1),PPS_taper)),IF(AND(Children>0,Married=0,Taper(PPS+PPS_CES,earn_princ,PPS_lim+PPS_ch_lim*(Children-1),PPS_taper)=0),0,IF(AND(Children=0,Married=0,taper2(NSAS+NSAS_CES,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2)>0),taper2(NSAS+NSAS_CES,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2)-taper2(NSAS,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2),IF(AND(Married>0,taper3(NSAP,earn_spouse,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2,NSAP_CES)>0),taper3(NSAP,earn_spouse,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2,NSAP_CES)-taper3(NSAP,earn_spouse,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2,NSAP_CES-NSAP_CES)))))+IF(AND(Married>0,taper2(NSAP+NSAP_CES,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2)>0),max(0, taper2(NSAP+NSAP_CES,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2)- taper2(NSAP,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2)),0)
|
|
|
SchoolKids Bonus
|
SKB
|
J
|
0
|
|
|
Single Income Family Supplement
|
SIFS
|
J
|
sifs(tax_inc_princ,tax_inc_spouse,ftbA+ftbB,SIFS_max,SIFS_in_lim_pr,SIFS_in_taper_pr,SIFS_out_lim_pr,SIFS_out_taper_pr,SIFS_out_lim_sec,SIFS_out_taper_sec)
|
|
|
|
cash_trans
|
J
|
ftbA+ftbB+taxbl_cr_princ+PA+taxbl_cr_spouse+Tele_A +CES+SKB+SIFS
|
|
|
Telephone Allowance
|
TA
|
B
|
IF(Married=0,IF(Children>0,IF(Taper(PPS+PA+PPS_CES,earn_princ,PPS_lim+PPS_ch_lim*(Children-1),PPS_taper)>0,Tele_A,0),0),0)
|
|
|
Employer’s State pay-roll tax
|
tax_empr
|
B
|
(earn+SG_rate*min(earn,SG_ceil))*Pay_roll_rate
|