Download

,1,0) =IF(H57>90,1,0) =IF(I57>90,1,0) =IF(J57>90,1,0) =IF(K57>90,1,0) =IF(L57>90,1,0) =IF(M57>90,1,0) =IF(N57>90,1,0) =IF(O57>90,1,0) =IF(P57>90,1,0) =IF(Q57>90,1,0) =IF(R57>90,1,0) =IF(S57>90,1,0) =IF(T57>90,1,0) =IF(U57>90,1,0) =IF(V57>90,1,0) =IF(W57>90,1,0) Debt between 60% and 90% (for debt sustainability safeguard) =IF(AND(F57>60,F57<=90),1,0) =IF(AND(G57>60,G57<=90),1,0) =IF(AND(H57>60,H57<=90),1,0) =IF(AND(I57>60,I57<=90),1,0) =IF(AND(J57>60,J57<=90),1,0) =IF(AND(K57>60,K57<=90),1,0) =IF(AND(L57>60,L57<=90),1,0) =IF(AND(M57>60,M57<=90),1,0) =IF(AND(N57>60,N57<=90),1,0) =IF(AND(O57>60,O57<=90),1,0) =IF(AND(P57>60,P57<=90),1,0) =IF(AND(Q57>60,Q57<=90),1,0) =IF(AND(R57>60,R57<=90),1,0) =IF(AND(S57>60,S57<=90),1,0) =IF(AND(T57>60,T57<=90),1,0) =IF(AND(U57>60,U57<=90),1,0) =IF(AND(V57>60,V57<=90),1,0) =IF(AND(W57>60,W57<=90),1,0) Debt above 60% (for debt sustainability safeguard) =IF(F57>60,1,0) =IF(G57>60,1,0) =IF(H57>60,1,0) =IF(I57>60,1,0) =IF(J57>60,1,0) =IF(K57>60,1,0) =IF(L57>60,1,0) =IF(M57>60,1,0) =IF(N57>60,1,0) =IF(O57>60,1,0) =IF(P57>60,1,0) =IF(Q57>60,1,0) =IF(R57>60,1,0) =IF(S57>60,1,0) =IF(T57>60,1,0) =IF(U57>60,1,0) =IF(V57>60,1,0) =IF(W57>60,1,0) Deficit exceeding 3% / under EDP (for deficit benchmark and debt sustainability safeguard) ='Input data'!F17 =IF(F87=0,0,IF(AND(E77>-3.05,F77>-3.05),0,1)) =IF(G87=0,0,IF(AND(F77>-3.05,G77>-3.05),0,1)) =IF(H87=0,0,IF(AND(G77>-3.05,H77>-3.05),0,1)) =IF(I87=0,0,IF(AND(H77>-3.05,I77>-3.05),0,1)) =IF(J87=0,0,IF(AND(I77>-3.05,J77>-3.05),0,1)) =IF(K87=0,0,IF(AND(J77>-3.05,K77>-3.05),0,1)) =IF(L87=0,0,IF(AND(K77>-3.05,L77>-3.05),0,1)) =IF(M87=0,0,IF(AND(L77>-3.05,M77>-3.05),0,1)) =IF(N87=0,0,IF(AND(M77>-3.05,N77>-3.05),0,1)) =IF(O87=0,0,IF(AND(N77>-3.05,O77>-3.05),0,1)) =IF(P87=0,0,IF(AND(O77>-3.05,P77>-3.05),0,1)) =IF(Q87=0,0,IF(AND(P77>-3.05,Q77>-3.05),0,1)) =IF(R87=0,0,IF(AND(Q77>-3.05,R77>-3.05),0,1)) =IF(S87=0,0,IF(AND(R77>-3.05,S77>-3.05),0,1)) =IF(T87=0,0,IF(AND(S77>-3.05,T77>-3.05),0,1)) =IF(U87=0,0,IF(AND(T77>-3.05,U77>-3.05),0,1)) =IF(V87=0,0,IF(AND(U77>-3.05,V77>-3.05),0,1)) Structural balance ensuring safety margin (for deficit resilience safeguard) =IF(F78>=-1.55,1,0) =IF(G78>=-1.55,1,0) =IF(H78>=-1.55,1,0) =IF(I78>=-1.55,1,0) =IF(J78>=-1.55,1,0) =IF(K78>=-1.55,1,0) =IF(L78>=-1.55,1,0) =IF(M78>=-1.55,1,0) =IF(N78>=-1.55,1,0) =IF(O78>=-1.55,1,0) =IF(P78>=-1.55,1,0) =IF(Q78>=-1.55,1,0) =IF(R78>=-1.55,1,0) =IF(S78>=-1.55,1,0) =IF(T78>=-1.55,1,0) =IF(U78>=-1.55,1,0) =IF(V78>=-1.55,1,0) =IF(W78>=-1.55,1,0) Approximation of interest payments in % GDP =E57*F36/100*(1/((1+'Input data'!F30/100)*(1+F42/100))) =F57*G36/100*(1/((1+'Input data'!G30/100)*(1+G42/100))) =G57*H36/100*(1/((1+'Input data'!H30/100)*(1+H42/100))) =H57*I36/100*(1/((1+'Input data'!I30/100)*(1+I42/100))) =I57*J36/100*(1/((1+'Input data'!J30/100)*(1+J42/100))) =J57*K36/100*(1/((1+'Input data'!K30/100)*(1+K42/100))) =K57*L36/100*(1/((1+'Input data'!L30/100)*(1+L42/100))) =L57*M36/100*(1/((1+'Input data'!M30/100)*(1+M42/100))) =M57*N36/100*(1/((1+'Input data'!N30/100)*(1+N42/100))) =N57*O36/100*(1/((1+'Input data'!O30/100)*(1+O42/100))) =O57*P36/100*(1/((1+'Input data'!P30/100)*(1+P42/100))) =P57*Q36/100*(1/((1+'Input data'!Q30/100)*(1+Q42/100))) =Q57*R36/100*(1/((1+'Input data'!R30/100)*(1+R42/100))) =R57*S36/100*(1/((1+'Input data'!S30/100)*(1+S42/100))) =S57*T36/100*(1/((1+'Input data'!T30/100)*(1+T42/100))) =T57*U36/100*(1/((1+'Input data'!U30/100)*(1+U42/100))) =U57*V36/100*(1/((1+'Input data'!V30/100)*(1+V42/100))) =V57*W36/100*(1/((1+'Input data'!W30/100)*(1+W42/100))) Change in interest payments (for deficit benchmark in SB terms from 2028 onwards) =G90-F90 =H90-G90 =I90-H90 =J90-I90 =K90-J90 =L90-K90 =M90-L90 =N90-M90 =O90-N90 =P90-O90 =Q90-P90 =R90-Q90 =S90-R90 =T90-S90 =U90-T90 =V90-U90 =W90-V90 Debt decomposition and IIR Auxiliary variable identifying whether debt is increasing =IF((D100-C100*D43/((1+D24/100)*(1+D42/100)))>0,1,0) =IF((E100-D100*E43/((1+E24/100)*(1+E42/100)))>0,1,0) =IF((F100-E100*F43/((1+F24/100)*(1+F42/100)))>0,1,0) =IF((G100-F100*G43/((1+G24/100)*(1+G42/100)))>0,1,0) =IF((H100-G100*H43/((1+H24/100)*(1+H42/100)))>0,1,0) =IF((I100-H100*I43/((1+I24/100)*(1+I42/100)))>0,1,0) =IF((J100-I100*J43/((1+J24/100)*(1+J42/100)))>0,1,0) =IF((K100-J100*K43/((1+K24/100)*(1+K42/100)))>0,1,0) =IF((L100-K100*L43/((1+L24/100)*(1+L42/100)))>0,1,0) =IF((M100-L100*M43/((1+M24/100)*(1+M42/100)))>0,1,0) =IF((N100-M100*N43/((1+N24/100)*(1+N42/100)))>0,1,0) =IF((O100-N100*O43/((1+O24/100)*(1+O42/100)))>0,1,0) =IF((P100-O100*P43/((1+P24/100)*(1+P42/100)))>0,1,0) =IF((Q100-P100*Q43/((1+Q24/100)*(1+Q42/100)))>0,1,0) =IF((R100-Q100*R43/((1+R24/100)*(1+R42/100)))>0,1,0) =IF((S100-R100*S43/((1+S24/100)*(1+S42/100)))>0,1,0) =IF((T100-S100*T43/((1+T24/100)*(1+T42/100)))>0,1,0) =IF((U100-T100*U43/((1+U24/100)*(1+U42/100)))>0,1,0) =IF((V100-U100*V43/((1+V24/100)*(1+V42/100)))>0,1,0) =IF((W100-V100*W43/((1+W24/100)*(1+W42/100)))>0,1,0) Auxiliary variable identifying whether some debt is rolled over even though debt is decreasing =IF(AND(D95=0,ABS(D100-C100*D43/((1+D24/100)*(1+D42/100)))<((C106*C100*D43/((1+D24/100)*(1+D42/100))+(D39*C100*C107*D43/((1+D24/100)*(1+D42/100)))))),1,0) =IF(AND(E95=0,ABS(E100-D100*E43/((1+E24/100)*(1+E42/100)))<((D106*D100*E43/((1+E24/100)*(1+E42/100))+(E39*D100*D107*E43/((1+E24/100)*(1+E42/100)))))),1,0) =IF(AND(F95=0,ABS(F100-E100*F43/((1+F24/100)*(1+F42/100)))<((E106*E100*F43/((1+F24/100)*(1+F42/100))+(F39*E100*E107*F43/((1+F24/100)*(1+F42/100)))))),1,0) =IF(AND(G95=0,ABS(G100-F100*G43/((1+G24/100)*(1+G42/100)))<((F106*F100*G43/((1+G24/100)*(1+G42/100))+(G39*F100*F107*G43/((1+G24/100)*(1+G42/100)))))),1,0) =IF(AND(H95=0,ABS(H100-G100*H43/((1+H24/100)*(1+H42/100)))<((G106*G100*H43/((1+H24/100)*(1+H42/100))+(H39*G100*G107*H43/((1+H24/100)*(1+H42/100)))))),1,0) =IF(AND(I95=0,ABS(I100-H100*I43/((1+I24/100)*(1+I42/100)))<((H106*H100*I43/((1+I24/100)*(1+I42/100))+(I39*H100*H107*I43/((1+I24/100)*(1+I42/100)))))),1,0) =IF(AND(J95=0,ABS(J100-I100*J43/((1+J24/100)*(1+J42/100)))<((I106*I100*J43/((1+J24/100)*(1+J42/100))+(J39*I100*I107*J43/((1+J24/100)*(1+J42/100)))))),1,0) =IF(AND(K95=0,ABS(K100-J100*K43/((1+K24/100)*(1+K42/100)))<((J106*J100*K43/((1+K24/100)*(1+K42/100))+(K39*J100*J107*K43/((1+K24/100)*(1+K42/100)))))),1,0) =IF(AND(L95=0,ABS(L100-K100*L43/((1+L24/100)*(1+L42/100)))<((K106*K100*L43/((1+L24/100)*(1+L42/100))+(L39*K100*K107*L43/((1+L24/100)*(1+L42/100)))))),1,0) =IF(AND(M95=0,ABS(M100-L100*M43/((1+M24/100)*(1+M42/100)))<((L106*L100*M43/((1+M24/100)*(1+M42/100))+(M39*L100*L107*M43/((1+M24/100)*(1+M42/100)))))),1,0) =IF(AND(N95=0,ABS(N100-M100*N43/((1+N24/100)*(1+N42/100)))<((M106*M100*N43/((1+N24/100)*(1+N42/100))+(N39*M100*M107*N43/((1+N24/100)*(1+N42/100)))))),1,0) =IF(AND(O95=0,ABS(O100-N100*O43/((1+O24/100)*(1+O42/100)))<((N106*N100*O43/((1+O24/100)*(1+O42/100))+(O39*N100*N107*O43/((1+O24/100)*(1+O42/100)))))),1,0) =IF(AND(P95=0,ABS(P100-O100*P43/((1+P24/100)*(1+P42/100)))<((O106*O100*P43/((1+P24/100)*(1+P42/100))+(P39*O100*O107*P43/((1+P24/100)*(1+P42/100)))))),1,0) =IF(AND(Q95=0,ABS(Q100-P100*Q43/((1+Q24/100)*(1+Q42/100)))<((P106*P100*Q43/((1+Q24/100)*(1+Q42/100))+(Q39*P100*P107*Q43/((1+Q24/100)*(1+Q42/100)))))),1,0) =IF(AND(R95=0,ABS(R100-Q100*R43/((1+R24/100)*(1+R42/100)))<((Q106*Q100*R43/((1+R24/100)*(1+R42/100))+(R39*Q100*Q107*R43/((1+R24/100)*(1+R42/100)))))),1,0) =IF(AND(S95=0,ABS(S100-R100*S43/((1+S24/100)*(1+S42/100)))<((R106*R100*S43/((1+S24/100)*(1+S42/100))+(S39*R100*R107*S43/((1+S24/100)*(1+S42/100)))))),1,0) =IF(AND(T95=0,ABS(T100-S100*T43/((1+T24/100)*(1+T42/100)))<((S106*S100*T43/((1+T24/100)*(1+T42/100))+(T39*S100*S107*T43/((1+T24/100)*(1+T42/100)))))),1,0) =IF(AND(U95=0,ABS(U100-T100*U43/((1+U24/100)*(1+U42/100)))<((T106*T100*U43/((1+U24/100)*(1+U42/100))+(U39*T100*T107*U43/((1+U24/100)*(1+U42/100)))))),1,0) =IF(AND(V95=0,ABS(V100-U100*V43/((1+V24/100)*(1+V42/100)))<((U106*U100*V43/((1+V24/100)*(1+V42/100))+(V39*U100*U107*V43/((1+V24/100)*(1+V42/100)))))),1,0) =IF(AND(W95=0,ABS(W100-V100*W43/((1+W24/100)*(1+W42/100)))<((V106*V100*W43/((1+W24/100)*(1+W42/100))+(W39*V100*V107*W43/((1+W24/100)*(1+W42/100)))))),1,0) 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 Gross debt =C57 =D57 =E57 =F57 =G57 =G100*(1+H113/100)*H43-H60-H61+H62+H63+H64+H65+H66+H72 =H100*(1+I113/100)*I43-I60-I61+I62+I63+I64+I65+I66+I72 =I100*(1+J113/100)*J43-J60-J61+J62+J63+J64+J65+J66+J72 =J100*(1+K113/100)*K43-K60-K61+K62+K63+K64+K65+K66+K72 =K100*(1+L113/100)*L43-L60-L61+L62+L63+L64+L65+L66+L72 =L100*(1+M113/100)*M43-M60-M61+M62+M63+M64+M65+M66+M72 =M100*(1+N113/100)*N43-N60-N61+N62+N63+N64+N65+N66+N72 =N100*(1+O113/100)*O43-O60-O61+O62+O63+O64+O65+O66+O72 =O100*(1+P113/100)*P43-P60-P61+P62+P63+P64+P65+P66+P72 =P100*(1+Q113/100)*Q43-Q60-Q61+Q62+Q63+Q64+Q65+Q66+Q72 =Q100*(1+R113/100)*R43-R60-R61+R62+R63+R64+R65+R66+R72 =R100*(1+S113/100)*S43-S60-S61+S62+S63+S64+S65+S66+S72 =S100*(1+T113/100)*T43-T60-T61+T62+T63+T64+T65+T66+T72 =T100*(1+U113/100)*U43-U60-U61+U62+U63+U64+U65+U66+U72 =U100*(1+V113/100)*V43-V60-V61+V62+V63+V64+V65+V66+V72 =V100*(1+W113/100)*W43-W60-W61+W62+W63+W64+W65+W66+W72 Of which Outstanding debt ='Input data'!C66*$D$100 =IF(E100=0,0,IF(E95=1,D100*E43/((1+E24/100)*(1+E42/100))-E102-E103,IF(AND(E95=0,E96=1),(1-D106-E39*D107)*D100*E43/((1+E24/100)*(1+E42/100)),E100))) =IF(F100=0,0,IF(F95=1,E100*F43/((1+F24/100)*(1+F42/100))-F102-F103,IF(AND(F95=0,F96=1),(1-E106-F39*E107)*E100*F43/((1+F24/100)*(1+F42/100)),F100))) =IF(G100=0,0,IF(G95=1,F100*G43/((1+G24/100)*(1+G42/100))-G102-G103,IF(AND(G95=0,G96=1),(1-F106-G39*F107)*F100*G43/((1+G24/100)*(1+G42/100)),G100))) =IF(H100=0,0,IF(H95=1,G100*H43/((1+H24/100)*(1+H42/100))-H102-H103,IF(AND(H95=0,H96=1),(1-G106-H39*G107)*G100*H43/((1+H24/100)*(1+H42/100)),H100))) =IF(I100=0,0,IF(I95=1,H100*I43/((1+I24/100)*(1+I42/100))-I102-I103,IF(AND(I95=0,I96=1),(1-H106-I39*H107)*H100*I43/((1+I24/100)*(1+I42/100)),I100))) =IF(J100=0,0,IF(J95=1,I100*J43/((1+J24/100)*(1+J42/100))-J102-J103,IF(AND(J95=0,J96=1),(1-I106-J39*I107)*I100*J43/((1+J24/100)*(1+J42/100)),J100))) =IF(K100=0,0,IF(K95=1,J100*K43/((1+K24/100)*(1+K42/100))-K102-K103,IF(AND(K95=0,K96=1),(1-J106-K39*J107)*J100*K43/((1+K24/100)*(1+K42/100)),K100))) =IF(L100=0,0,IF(L95=1,K100*L43/((1+L24/100)*(1+L42/100))-L102-L103,IF(AND(L95=0,L96=1),(1-K106-L39*K107)*K100*L43/((1+L24/100)*(1+L42/100)),L100))) =IF(M100=0,0,IF(M95=1,L100*M43/((1+M24/100)*(1+M42/100))-M102-M103,IF(AND(M95=0,M96=1),(1-L106-M39*L107)*L100*M43/((1+M24/100)*(1+M42/100)),M100))) =IF(N100=0,0,IF(N95=1,M100*N43/((1+N24/100)*(1+N42/100))-N102-N103,IF(AND(N95=0,N96=1),(1-M106-N39*M107)*M100*N43/((1+N24/100)*(1+N42/100)),N100))) =IF(O100=0,0,IF(O95=1,N100*O43/((1+O24/100)*(1+O42/100))-O102-O103,IF(AND(O95=0,O96=1),(1-N106-O39*N107)*N100*O43/((1+O24/100)*(1+O42/100)),O100))) =IF(P100=0,0,IF(P95=1,O100*P43/((1+P24/100)*(1+P42/100))-P102-P103,IF(AND(P95=0,P96=1),(1-O106-P39*O107)*O100*P43/((1+P24/100)*(1+P42/100)),P100))) =IF(Q100=0,0,IF(Q95=1,P100*Q43/((1+Q24/100)*(1+Q42/100))-Q102-Q103,IF(AND(Q95=0,Q96=1),(1-P106-Q39*P107)*P100*Q43/((1+Q24/100)*(1+Q42/100)),Q100))) =IF(R100=0,0,IF(R95=1,Q100*R43/((1+R24/100)*(1+R42/100))-R102-R103,IF(AND(R95=0,R96=1),(1-Q106-R39*Q107)*Q100*R43/((1+R24/100)*(1+R42/100)),R100))) =IF(S100=0,0,IF(S95=1,R100*S43/((1+S24/100)*(1+S42/100))-S102-S103,IF(AND(S95=0,S96=1),(1-R106-S39*R107)*R100*S43/((1+S24/100)*(1+S42/100)),S100))) =IF(T100=0,0,IF(T95=1,S100*T43/((1+T24/100)*(1+T42/100))-T102-T103,IF(AND(T95=0,T96=1),(1-S106-T39*S107)*S100*T43/((1+T24/100)*(1+T42/100)),T100))) =IF(U100=0,0,IF(U95=1,T100*U43/((1+U24/100)*(1+U42/100))-U102-U103,IF(AND(U95=0,U96=1),(1-T106-U39*T107)*T100*U43/((1+U24/100)*(1+U42/100)),U100))) =IF(V100=0,0,IF(V95=1,U100*V43/((1+V24/100)*(1+V42/100))-V102-V103,IF(AND(V95=0,V96=1),(1-U106-V39*U107)*U100*V43/((1+V24/100)*(1+V42/100)),V100))) =IF(W100=0,0,IF(W95=1,V100*W43/((1+W24/100)*(1+W42/100))-W102-W103,IF(AND(W95=0,W96=1),(1-V106-W39*V107)*V100*W43/((1+W24/100)*(1+W42/100)),W100))) Rolled over long-term debt ='Input data'!C67*$D$100 =IF(E100=0,0,IF(E95=1,E39*D100*D107*E43/((1+E24/100)*(1+E42/100)),IF(AND(E95=0,E96=1),(E39*D100*D107*E43/((1+E24/100)*(1+E42/100)))*(1-ABS(E100-D100*E43/((1+E24/100)*(1+E42/100)))/((E39*D100*D107*E43/((1+E24/100)*(1+E42/100)))+(D106*D100*E43/((1+E24/100)*(1+E42/100))))),0))) =IF(F100=0,0,IF(F95=1,F39*E100*E107*F43/((1+F24/100)*(1+F42/100)),IF(AND(F95=0,F96=1),(F39*E100*E107*F43/((1+F24/100)*(1+F42/100)))*(1-ABS(F100-E100*F43/((1+F24/100)*(1+F42/100)))/((F39*E100*E107*F43/((1+F24/100)*(1+F42/100)))+(E106*E100*F43/((1+F24/100)*(1+F42/100))))),0))) =IF(G100=0,0,IF(G95=1,G39*F100*F107*G43/((1+G24/100)*(1+G42/100)),IF(AND(G95=0,G96=1),(G39*F100*F107*G43/((1+G24/100)*(1+G42/100)))*(1-ABS(G100-F100*G43/((1+G24/100)*(1+G42/100)))/((G39*F100*F107*G43/((1+G24/100)*(1+G42/100)))+(F106*F100*G43/((1+G24/100)*(1+G42/100))))),0))) =IF(H100=0,0,IF(H95=1,H39*G100*G107*H43/((1+H24/100)*(1+H42/100)),IF(AND(H95=0,H96=1),(H39*G100*G107*H43/((1+H24/100)*(1+H42/100)))*(1-ABS(H100-G100*H43/((1+H24/100)*(1+H42/100)))/((H39*G100*G107*H43/((1+H24/100)*(1+H42/100)))+(G106*G100*H43/((1+H24/100)*(1+H42/100))))),0))) =IF(I100=0,0,IF(I95=1,I39*H100*H107*I43/((1+I24/100)*(1+I42/100)),IF(AND(I95=0,I96=1),(I39*H100*H107*I43/((1+I24/100)*(1+I42/100)))*(1-ABS(I100-H100*I43/((1+I24/100)*(1+I42/100)))/((I39*H100*H107*I43/((1+I24/100)*(1+I42/100)))+(H106*H100*I43/((1+I24/100)*(1+I42/100))))),0))) =IF(J100=0,0,IF(J95=1,J39*I100*I107*J43/((1+J24/100)*(1+J42/100)),IF(AND(J95=0,J96=1),(J39*I100*I107*J43/((1+J24/100)*(1+J42/100)))*(1-ABS(J100-I100*J43/((1+J24/100)*(1+J42/100)))/((J39*I100*I107*J43/((1+J24/100)*(1+J42/100)))+(I106*I100*J43/((1+J24/100)*(1+J42/100))))),0))) =IF(K100=0,0,IF(K95=1,K39*J100*J107*K43/((1+K24/100)*(1+K42/100)),IF(AND(K95=0,K96=1),(K39*J100*J107*K43/((1+K24/100)*(1+K42/100)))*(1-ABS(K100-J100*K43/((1+K24/100)*(1+K42/100)))/((K39*J100*J107*K43/((1+K24/100)*(1+K42/100)))+(J106*J100*K43/((1+K24/100)*(1+K42/100))))),0))) =IF(L100=0,0,IF(L95=1,L39*K100*K107*L43/((1+L24/100)*(1+L42/100)),IF(AND(L95=0,L96=1),(L39*K100*K107*L43/((1+L24/100)*(1+L42/100)))*(1-ABS(L100-K100*L43/((1+L24/100)*(1+L42/100)))/((L39*K100*K107*L43/((1+L24/100)*(1+L42/100)))+(K106*K100*L43/((1+L24/100)*(1+L42/100))))),0))) =IF(M100=0,0,IF(M95=1,M39*L100*L107*M43/((1+M24/100)*(1+M42/100)),IF(AND(M95=0,M96=1),(M39*L100*L107*M43/((1+M24/100)*(1+M42/100)))*(1-ABS(M100-L100*M43/((1+M24/100)*(1+M42/100)))/((M39*L100*L107*M43/((1+M24/100)*(1+M42/100)))+(L106*L100*M43/((1+M24/100)*(1+M42/100))))),0))) =IF(N100=0,0,IF(N95=1,N39*M100*M107*N43/((1+N24/100)*(1+N42/100)),IF(AND(N95=0,N96=1),(N39*M100*M107*N43/((1+N24/100)*(1+N42/100)))*(1-ABS(N100-M100*N43/((1+N24/100)*(1+N42/100)))/((N39*M100*M107*N43/((1+N24/100)*(1+N42/100)))+(M106*M100*N43/((1+N24/100)*(1+N42/100))))),0))) =IF(O100=0,0,IF(O95=1,O39*N100*N107*O43/((1+O24/100)*(1+O42/100)),IF(AND(O95=0,O96=1),(O39*N100*N107*O43/((1+O24/100)*(1+O42/100)))*(1-ABS(O100-N100*O43/((1+O24/100)*(1+O42/100)))/((O39*N100*N107*O43/((1+O24/100)*(1+O42/100)))+(N106*N100*O43/((1+O24/100)*(1+O42/100))))),0))) =IF(P100=0,0,IF(P95=1,P39*O100*O107*P43/((1+P24/100)*(1+P42/100)),IF(AND(P95=0,P96=1),(P39*O100*O107*P43/((1+P24/100)*(1+P42/100)))*(1-ABS(P100-O100*P43/((1+P24/100)*(1+P42/100)))/((P39*O100*O107*P43/((1+P24/100)*(1+P42/100)))+(O106*O100*P43/((1+P24/100)*(1+P42/100))))),0))) =IF(Q100=0,0,IF(Q95=1,Q39*P100*P107*Q43/((1+Q24/100)*(1+Q42/100)),IF(AND(Q95=0,Q96=1),(Q39*P100*P107*Q43/((1+Q24/100)*(1+Q42/100)))*(1-ABS(Q100-P100*Q43/((1+Q24/100)*(1+Q42/100)))/((Q39*P100*P107*Q43/((1+Q24/100)*(1+Q42/100)))+(P106*P100*Q43/((1+Q24/100)*(1+Q42/100))))),0))) =IF(R100=0,0,IF(R95=1,R39*Q100*Q107*R43/((1+R24/100)*(1+R42/100)),IF(AND(R95=0,R96=1),(R39*Q100*Q107*R43/((1+R24/100)*(1+R42/100)))*(1-ABS(R100-Q100*R43/((1+R24/100)*(1+R42/100)))/((R39*Q100*Q107*R43/((1+R24/100)*(1+R42/100)))+(Q106*Q100*R43/((1+R24/100)*(1+R42/100))))),0))) =IF(S100=0,0,IF(S95=1,S39*R100*R107*S43/((1+S24/100)*(1+S42/100)),IF(AND(S95=0,S96=1),(S39*R100*R107*S43/((1+S24/100)*(1+S42/100)))*(1-ABS(S100-R100*S43/((1+S24/100)*(1+S42/100)))/((S39*R100*R107*S43/((1+S24/100)*(1+S42/100)))+(R106*R100*S43/((1+S24/100)*(1+S42/100))))),0))) =IF(T100=0,0,IF(T95=1,T39*S100*S107*T43/((1+T24/100)*(1+T42/100)),IF(AND(T95=0,T96=1),(T39*S100*S107*T43/((1+T24/100)*(1+T42/100)))*(1-ABS(T100-S100*T43/((1+T24/100)*(1+T42/100)))/((T39*S100*S107*T43/((1+T24/100)*(1+T42/100)))+(S106*S100*T43/((1+T24/100)*(1+T42/100))))),0))) =IF(U100=0,0,IF(U95=1,U39*T100*T107*U43/((1+U24/100)*(1+U42/100)),IF(AND(U95=0,U96=1),(U39*T100*T107*U43/((1+U24/100)*(1+U42/100)))*(1-ABS(U100-T100*U43/((1+U24/100)*(1+U42/100)))/((U39*T100*T107*U43/((1+U24/100)*(1+U42/100)))+(T106*T100*U43/((1+U24/100)*(1+U42/100))))),0))) =IF(V100=0,0,IF(V95=1,V39*U100*U107*V43/((1+V24/100)*(1+V42/100)),IF(AND(V95=0,V96=1),(V39*U100*U107*V43/((1+V24/100)*(1+V42/100)))*(1-ABS(V100-U100*V43/((1+V24/100)*(1+V42/100)))/((V39*U100*U107*V43/((1+V24/100)*(1+V42/100)))+(U106*U100*V43/((1+V24/100)*(1+V42/100))))),0))) =IF(W100=0,0,IF(W95=1,W39*V100*V107*W43/((1+W24/100)*(1+W42/100)),IF(AND(W95=0,W96=1),(W39*V100*V107*W43/((1+W24/100)*(1+W42/100)))*(1-ABS(W100-V100*W43/((1+W24/100)*(1+W42/100)))/((W39*V100*V107*W43/((1+W24/100)*(1+W42/100)))+(V106*V100*W43/((1+W24/100)*(1+W42/100))))),0)))