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,0),,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,0),0))) |
4. |
CG taxable income |
tax_inc |
B |
earn+taxbl_cr+Coronavirus Supplement |
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 : |
|
|
|
|
Spouse credit |
spouse_cr |
P |
Taper(IF(Children>0,0,spouse_cr*Married),earn_spouse+taxbl_cr_spouse,sp_lim,sp_redn) |
|
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) |
|
Low and Middle Income Tax Offset |
lmito_cr |
B |
MAX(0,IF(Tax_Inc<LMITO_Thr1,LMITO_Base,MAX(IF(Tax_Inc<LMITO_Thr2,MIN(LMITO_Max,LMITO_Base+(Tax_Inc-LMITO_Thr1)*LMITO_Taper1),LMITO_Max-(Tax_Inc-LMITO_Thr2)*LMITO_Taper2)))) |
|
Total |
tax_cr |
B |
spouse_cr+low_cr+sap_cr+ben_cr |
7. |
CG tax |
CG_tax |
B |
Positive(liab-tax_cr) + med_levy + TBRL |
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) |
|
Clean Energy Advance |
CEA |
J |
IF(AND(Children>0,Married=0,Taper(PPS+PPS_CES,earn_princ,PPS_lim+PPS_ch_lim*(Children-1),PPS_taper)>0),PPS_CEA,IF(AND(Children=0,Married=0,taper2(NSAS+NSAS_CES,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2)>0),NSAS_CEA,IF(AND(Married>0,taper3(NSAP,earn_spouse,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2,NSAP_CES)>0),NSAP_CEA)))+IF(AND(taxbl_cr_princ>0,Married>0,taper2(NSAP+NSAP_CES,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2)>0),NSAP_CEA,0)+IF(AND(ftbA>0,ftbA>FTB_A_base*Children+IF(Children>2,(Children-2)*FTB_A_large,0)),FTB_A_CEA_max*Children,0)+ IF(AND(ftbA>0,ftbA<=FTB_A_base*Children+IF(Children>2,(Children-2)*FTB_A_large,0)),FTB_A_CEA_basic*Children,0)+IF(ftbB>0,FTB_B_CEA_5,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+CEA=CES+SKB+SIFS |
|
COVID-19 Economic Support Payment |
Eco_supp_1 and Eco_supp_2 |
B |
IF(OR(ftbA>0,ftbB>0),Eco_supp_1+2*Eco_supp_2,0) |
|
Coronavirus Supplement (Principal) |
Weighted_avg_CVS |
B |
IF(taxbl_cr_princ>0,Weighted_avg_CVS*26,0) |
|
Coronavirus Supplement (Spouse) |
Weighted_avg_CVS |
B |
IF(taxbl_cr_spouse>0,Weighted_avg_CVS*26,0) |
|
|
|
|
|
|
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*Pay_roll_rate |