|
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, NSAP_CES),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) |