1. |
Earnings |
earn |
|
|
2. |
Allowances |
tax_al |
B |
0 |
3. |
Credits in taxable income: |
|
|
|
|
Credits in taxable income of principal |
taxbl_cr_princ |
P |
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 |
S |
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 |
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) |
|
Temporary Budget Repair Levy |
TBRL |
B |
TBRL_rate*Positive(tax_inc-TBRL_lim) |
|
Tax liability |
liab |
P |
Tax(tax_inc, tax_sch) |
6. |
Tax credits : |
|
|
|
|
Low income credit |
low_cr |
B |
Taper(low_inc_cr,tax_inc,low_inc_lim,low_inc_redn) |
|
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 + 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 |
P |
IF(PA>0,((FTB_A_max+FTB_A_CES_max+IF(princ_earn+spouse_earn<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(princ_earn+spouse_earn<FTB_A_supp_lim,FTB_A_supp,0))*Children-Positive((princ_earn+taxbl_cr+spouse_earn+taxbl_ cr_spouse)-FTB_A_lim1)*FTB_A_taper1),Positive((FTB_A_base+FTB_A_CES_ basic)*Children-Positive((princ_earn+taxbl_cr+spouse_earn+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) |
|
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) |
|
Income support bonus |
ISB |
B |
IF(AND(Married=0,(taxbl_cr_princ+earn_princ+PA)>0),ISB_s,IF(AND(Married>0,taper3(NSAP, taxbl_cr_princ, earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_ taper2,NSAP_CES)>0),ISB_p,0))+IF(AND(Married>0,taper2(NSAP+NSAP_CES,earn_princ,NSA_lim1,NSA_lim2,NSA_taper1,NSA_taper2)>0),ISB_p,0) |
|
Telephone Allowance |
TeleA |
P |
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) |
|
|
cash_trans |
J |
ftbA+ftbB+taxbl_cr_princ+PA+taxbl_cr_spouse+Tele_A +CEA=CES+SKB+SIFS+ISB |
13. |
Employer’s State pay-roll tax |
tax_empr |
B |
earn*Pay_roll_rate |