Download

OKUP(J$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(K$56<=$C$6,0,HLOOKUP(K$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(L$56<=$C$6,0,HLOOKUP(L$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(M$56<=$C$6,0,HLOOKUP(M$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(N$56<=$C$6,0,HLOOKUP(N$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(O$56<=$C$6,0,HLOOKUP(O$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(P$56<=$C$6,0,HLOOKUP(P$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(Q$56<=$C$6,0,HLOOKUP(Q$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(R$56<=$C$6,0,HLOOKUP(R$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(S$56<=$C$6,0,HLOOKUP(S$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(T$56<=$C$6,0,HLOOKUP(T$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(U$56<=$C$6,0,HLOOKUP(U$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(V$56<=$C$6,0,HLOOKUP(V$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) =IF(W$56<=$C$6,0,HLOOKUP(W$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) (1.6) Property incomes =IF(D$56<=$C$5,0,-HLOOKUP(D$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(E$56<=$C$5,0,-HLOOKUP(E$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(F$56<=$C$5,0,-HLOOKUP(F$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(G$56<=$C$6,0,-HLOOKUP(G$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(H$56<=$C$6,0,-HLOOKUP(H$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(I$56<=$C$6,0,-HLOOKUP(I$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(J$56<=$C$6,0,-HLOOKUP(J$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(K$56<=$C$6,0,-HLOOKUP(K$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(L$56<=$C$6,0,-HLOOKUP(L$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(M$56<=$C$6,0,-HLOOKUP(M$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(N$56<=$C$6,0,-HLOOKUP(N$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(O$56<=$C$6,0,-HLOOKUP(O$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(P$56<=$C$6,0,-HLOOKUP(P$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(Q$56<=$C$6,0,-HLOOKUP(Q$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(R$56<=$C$6,0,-HLOOKUP(R$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(S$56<=$C$6,0,-HLOOKUP(S$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(T$56<=$C$6,0,-HLOOKUP(T$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(U$56<=$C$6,0,-HLOOKUP(U$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(V$56<=$C$6,0,-HLOOKUP(V$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) =IF(W$56<=$C$6,0,-HLOOKUP(W$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) (1.7) Revenues 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (2) Snowball effect (2.1 + 2.2 + 2.3) =SUM(D68:D71) =SUM(E68:E71) =SUM(F68:F71) =SUM(G68:G71) =SUM(H68:H71) =SUM(I68:I71) =SUM(J68:J71) =SUM(K68:K71) =SUM(L68:L71) =SUM(M68:M71) =SUM(N68:N71) =SUM(O68:O71) =SUM(P68:P71) =SUM(Q68:Q71) =SUM(R68:R71) =SUM(S68:S71) =SUM(T68:T71) =SUM(U68:U71) =SUM(V68:V71) =SUM(W68:W71) (2.1) Interest expenditure =C57*D36/100*(1/(1+D33/100)) =D57*E36/100*(1/(1+E33/100)) =E57*F36/100*(1/(1+F33/100)) =F57*G36/100*(1/(1+G33/100)) =G57*H36/100*(1/(1+H33/100)) =H57*I36/100*(1/(1+I33/100)) =I57*J36/100*(1/(1+J33/100)) =J57*K36/100*(1/(1+K33/100)) =K57*L36/100*(1/(1+L33/100)) =L57*M36/100*(1/(1+M33/100)) =M57*N36/100*(1/(1+N33/100)) =N57*O36/100*(1/(1+O33/100)) =O57*P36/100*(1/(1+P33/100)) =P57*Q36/100*(1/(1+Q33/100)) =Q57*R36/100*(1/(1+R33/100)) =R57*S36/100*(1/(1+S33/100)) =S57*T36/100*(1/(1+T33/100)) =T57*U36/100*(1/(1+U33/100)) =U57*V36/100*(1/(1+V33/100)) =V57*W36/100*(1/(1+W33/100)) (2.2) Growth effect =-C57*(D24/100)*(1/(1+D33/100)) =-D57*(E24/100)*(1/(1+E33/100)) =-E57*(F24/100)*(1/(1+F33/100)) =-F57*(G24/100)*(1/(1+G33/100)) =-G57*(H24/100)*(1/(1+H33/100)) =-H57*(I24/100)*(1/(1+I33/100)) =-I57*(J24/100)*(1/(1+J33/100)) =-J57*(K24/100)*(1/(1+K33/100)) =-K57*(L24/100)*(1/(1+L33/100)) =-L57*(M24/100)*(1/(1+M33/100)) =-M57*(N24/100)*(1/(1+N33/100)) =-N57*(O24/100)*(1/(1+O33/100)) =-O57*(P24/100)*(1/(1+P33/100)) =-P57*(Q24/100)*(1/(1+Q33/100)) =-Q57*(R24/100)*(1/(1+R33/100)) =-R57*(S24/100)*(1/(1+S33/100)) =-S57*(T24/100)*(1/(1+T33/100)) =-T57*(U24/100)*(1/(1+U33/100)) =-U57*(V24/100)*(1/(1+V33/100)) =-V57*(W24/100)*(1/(1+W33/100)) (2.3) Inflation effect =-C57*D42/100*(1/(1+D42/100)) =-D57*E42/100*(1/(1+E42/100)) =-E57*F42/100*(1/(1+F42/100)) =-F57*G42/100*(1/(1+G42/100)) =-G57*H42/100*(1/(1+H42/100)) =-H57*I42/100*(1/(1+I42/100)) =-I57*J42/100*(1/(1+J42/100)) =-J57*K42/100*(1/(1+K42/100)) =-K57*L42/100*(1/(1+L42/100)) =-L57*M42/100*(1/(1+M42/100)) =-M57*N42/100*(1/(1+N42/100)) =-N57*O42/100*(1/(1+O42/100)) =-O57*P42/100*(1/(1+P42/100)) =-P57*Q42/100*(1/(1+Q42/100)) =-Q57*R42/100*(1/(1+R42/100)) =-R57*S42/100*(1/(1+S42/100)) =-S57*T42/100*(1/(1+T42/100)) =-T57*U42/100*(1/(1+U42/100)) =-U57*V42/100*(1/(1+V42/100)) =-V57*W42/100*(1/(1+W42/100)) (2.4) Exchange rate effect linked to the interest rate ='Baseline NFPC'!D70 ='Baseline NFPC'!E70 ='Baseline NFPC'!F70 ='Baseline NFPC'!G70 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 (3 ) Stock flow adjustments (3.1 + 3.2) ='Input data'!D16 ='Input data'!E16 ='Input data'!F16 ='Input data'!G16 ='Input data'!H16 ='Input data'!I16 ='Input data'!J16 ='Input data'!K16 ='Input data'!L16 ='Input data'!M16 ='Input data'!N16 ='Input data'!O16 ='Input data'!P16 ='Input data'!Q16 ='Input data'!R16 ='Input data'!S16 ='Input data'!T16 ='Input data'!U16 ='Input data'!V16 ='Input data'!W16 (3.1) Base =D15 =E15 =F15 =G15 =H15 =I15 =J15 =K15 =L15 =M15 =N15 =O15 =P15 =Q15 =R15 =S15 =T15 =U15 =V15 =W15 (3.2) Adjustment due to the exchange rate effect linked to debt value =+D72-D73 =+E72-E73 =+F72-F73 =+G72-G73 =+H72-H73 =+I72-I73 =+J72-J73 =+K72-K73 =+L72-L73 =+M72-M73 =+N72-N73 =+O72-O73 =+P72-P73 =+Q72-Q73 =+R72-R73 =+S72-S73 =+T72-T73 =+U72-U73 =+V72-V73 =+W72-W73 Other budgetary variables Headline balance =D59-D68 =E59-E68 =F59-F68 =G59-G68 =H59-H68 =I59-I68 =J59-J68 =K59-K68 =L59-L68 =M59-M68 =N59-N68 =O59-O68 =P59-P68 =Q59-Q68 =R59-R68 =S59-S68 =T59-T68 =U59-U68 =V59-V68 =W59-W68 Structural balance =D60-D68-D64-D65-D66 =E60-E68-E64-E65-E66 =F60-F68-F64-F65-F66 =G60-G68-G64-G65-G66 =H60-H68-H64-H65-H66 =I60-I68-I64-I65-I66 =J60-J68-J64-J65-J66 =K60-K68-K64-K65-K66 =L60-L68-L64-L65-L66 =M60-M68-M64-M65-M66 =N60-N68-N64-N65-N66 =O60-O68-O64-O65-O66 =P60-P68-P64-P65-P66 =Q60-Q68-Q64-Q65-Q66 =R60-R68-R64-R65-R66 =S60-S68-S64-S65-S66 =T60-T68-T64-T65-T66 =U60-U68-U64-U65-U66 =V60-V68-V64-V65-V66 =W60-W68-W64-W65-W66 Net expenditure growth ='Input data'!D45 ='Input data'!E45 ='Input data'!F45 ='Input data'!G33+G42-(G$12-F$12)/'Input data'!$C$64*100 ='Input data'!H33+H42-(H$12-G$12)/'Input data'!$C$64*100 ='Input data'!I33+I42-(I$12-H$12)/'Input data'!$C$64*100 ='Input data'!J33+J42-(J$12-I$12)/'Input data'!$C$64*100 ='Input data'!K33+K42-(K$12-J$12)/'Input data'!$C$64*100 ='Input data'!L33+L42-(L$12-K$12)/'Input data'!$C$64*100 ='Input data'!M33+M42-(M$12-L$12)/'Input data'!$C$64*100 ='Input data'!N33+N42-(N$12-M$12)/'Input data'!$C$64*100 ='Input data'!O33+O42-(O$12-N$12)/'Input data'!$C$64*100 ='Input data'!P33+P42-(P$12-O$12)/'Input data'!$C$64*100 ='Input data'!Q33+Q42-(Q$12-P$12)/'Input data'!$C$64*100 ='Input data'!R33+R42-(R$12-Q$12)/'Input data'!$C$64*100 ='Input data'!S33+S42-(S$12-R$12)/'Input data'!$C$64*100 ='Input data'!T33+T42-(T$12-S$12)/'Input data'!$C$64*100 ='Input data'!U33+U42-(U$12-T$12)/'Input data'!$C$64*100 ='Input data'!V33+V42-(V$12-U$12)/'Input data'!$C$64*100 ='Input data'!W33+W42-(W$12-V$12)/'Input data'!$C$64*100 Average net primary expenditure growth =AVERAGE(OFFSET($G$79,0,0,1,'Criteria results'!F5)) Debt decreasing? (For criterion 1) =IF(K57<J57,0,1) =IF(L57<K57,0,1) =IF(M57<L57,0,1) =IF(N57<M57,0,1) =IF(O57<N57,0,1) =IF(P57<O57,0,1) =IF(Q57<P57,0,1) =IF(R57<Q57,0,1) =IF(S57<R57,0,1) =IF(T57<S57,0,1) =IF(U57<T57,0,1) =IF(V57<U57,0,1) =IF(W57<V57,0,1) Debt decomposition and IIR Auxiliary variable identifying whether debt is increasing =IF((D92-C92*D43/((1+D24/100)*(1+D42/100)))>0,1,0) =IF((E92-D92*E43/((1+E24/100)*(1+E42/100)))>0,1,0) =IF((F92-E92*F43/((1+F24/100)*(1+F42/100)))>0,1,0) =IF((G92-F92*G43/((1+G24/100)*(1+G42/100)))>0,1,0) =IF((H92-G92*H43/((1+H24/100)*(1+H42/100)))>0,1,0) =IF((I92-H92*I43/((1+I24/100)*(1+I42/100)))>0,1,0) =IF((J92-I92*J43/((1+J24/100)*(1+J42/100)))>0,1,0) =IF((K92-J92*K43/((1+K24/100)*(1+K42/100)))>0,1,0) =IF((L92-K92*L43/((1+L24/100)*(1+L42/100)))>0,1,0) =IF((M92-L92*M43/((1+M24/100)*(1+M42/100)))>0,1,0) =IF((N92-M92*N43/((1+N24/100)*(1+N42/100)))>0,1,0) =IF((O92-N92*O43/((1+O24/100)*(1+O42/100)))>0,1,0) =IF((P92-O92*P43/((1+P24/100)*(1+P42/100)))>0,1,0) =IF((Q92-P92*Q43/((1+Q24/100)*(1+Q42/100)))>0,1,0) =IF((R92-Q92*R43/((1+R24/100)*(1+R42/100)))>0,1,0) =IF((S92-R92*S43/((1+S24/100)*(1+S42/100)))>0,1,0) =IF((T92-S92*T43/((1+T24/100)*(1+T42/100)))>0,1,0) =IF((U92-T92*U43/((1+U24/100)*(1+U42/100)))>0,1,0) =IF((V92-U92*V43/((1+V24/100)*(1+V42/100)))>0,1,0) =IF((W92-V92*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(D87=0,ABS(D92-C92*D43/((1+D24/100)*(1+D42/100)))<((C98*C92*D43/((1+D24/100)*(1+D42/100))+(D39*C92*C99*D43/((1+D24/100)*(1+D42/100)))))),1,0) =IF(AND(E87=0,ABS(E92-D92*E43/((1+E24/100)*(1+E42/100)))<((D98*D92*E43/((1+E24/100)*(1+E42/100))+(E39*D92*D99*E43/((1+E24/100)*(1+E42/100)))))),1,0) =IF(AND(F87=0,ABS(F92-E92*F43/((1+F24/100)*(1+F42/100)))<((E98*E92*F43/((1+F24/100)*(1+F42/100))+(F39*E92*E99*F43/((1+F24/100)*(1+F42/100)))))),1,0) =IF(AND(G87=0,ABS(G92-F92*G43/((1+G24/100)*(1+G42/100)))<((F98*F92*G43/((1+G24/100)*(1+G42/100))+(G39*F92*F99*G43/((1+G24/100)*(1+G42/100)))))),1,0) =IF(AND(H87=0,ABS(H92-G92*H43/((1+H24/100)*(1+H42/100)))<((G98*G92*H43/((1+H24/100)*(1+H42/100))+(H39*G92*G99*H43/((1+H24/100)*(1+H42/100)))))),1,0) =IF(AND(I87=0,ABS(I92-H92*I43/((1+I24/100)*(1+I42/100)))<((H98*H92*I43/((1+I24/100)*(1+I42/100))+(I39*H92*H99*I43/((1+I24/100)*(1+I42/100)))))),1,0) =IF(AND(J87=0,ABS(J92-I92*J43/((1+J24/100)*(1+J42/100)))<((I98*I92*J43/((1+J24/100)*(1+J42/100))+(J39*I92*I99*J43/((1+J24/100)*(1+J42/100)))))),1,0) =IF(AND(K87=0,ABS(K92-J92*K43/((1+K24/100)*(1+K42/100)))<((J98*J92*K43/((1+K24/100)*(1+K42/100))+(K39*J92*J99*K43/((1+K24/100)*(1+K42/100)))))),1,0) =IF(AND(L87=0,ABS(L92-K92*L43/((1+L24/100)*(1+L42/100)))<((K98*K92*L43/((1+L24/100)*(1+L42/100))+(L39*K92*K99*L43/((1+L24/100)*(1+L42/100)))))),1,0) =IF(AND(M87=0,ABS(M92-L92*M43/((1+M24/100)*(1+M42/100)))<((L98*L92*M43/((1+M24/100)*(1+M42/100))+(M39*L92*L99*M43/((1+M24/100)*(1+M42/100)))))),1,0) =IF(AND(N87=0,ABS(N92-M92*N43/((1+N24/100)*(1+N42/100)))<((M98*M92*N43/((1+N24/100)*(1+N42/100))+(N39*M92*M99*N43/((1+N24/100)*(1+N42/100)))))),1,0) =IF(AND(O87=0,ABS(O92-N92*O43/((1+O24/100)*(1+O42/100)))<((N98*N92*O43/((1+O24/100)*(1+O42/100))+(O39*N92*N99*O43/((1+O24/100)*(1+O42/100)))))),1,0) =IF(AND(P87=0,ABS(P92-O92*P43/((1+P24/100)*(1+P42/100)))<((O98*O92*P43/((1+P24/100)*(1+P42/100))+(P39*O92*O99*P43/((1+P24/100)*(1+P42/100)))))),1,0) =IF(AND(Q87=0,ABS(Q92-P92*Q43/((1+Q24/100)*(1+Q42/100)))<((P98*P92*Q43/((1+Q24/100)*(1+Q42/100))+(Q39*P92*P99*Q43/((1+Q24/100)*(1+Q42/100)))))),1,0) =IF(AND(R87=0,ABS(R92-Q92*R43/((1+R24/100)*(1+R42/100)))<((Q98*Q92*R43/((1+R24/100)*(1+R42/100))+(R39*Q92*Q99*R43/((1+R24/100)*(1+R42/100)))))),1,0) =IF(AND(S87=0,ABS(S92-R92*S43/((1+S24/100)*(1+S42/100)))<((R98*R92*S43/((1+S24/100)*(1+S42/100))+(S39*R92*R99*S43/((1+S24/100)*(1+S42/100)))))),1,0) =IF(AND(T87=0,ABS(T92-S92*T43/((1+T24/100)*(1+T42/100)))<((S98*S92*T43/((1+T24/100)*(1+T42/100))+(T39*S92*S99*T43/((1+T24/100)*(1+T42/100)))))),1,0) =IF(AND(U87=0,ABS(U92-T92*U43/((1+U24/100)*(1+U42/100)))<((T98*T92*U43/((1+U24/100)*(1+U42/100))+(U39*T92*T99*U43/((1+U24/100)*(1+U42/100)))))),1,0) =IF(AND(V87=0,ABS(V92-U92*V43/((1+V24/100)*(1+V42/100)))<((U98*U92*V43/((1+V24/100)*(1+V42/100))+(V39*U92*U99*V43/((1+V24/100)*(1+V42/100)))))),1,0) =IF(AND(W87=0,ABS(W92-V92*W43/((1+W24/100)*(1+W42/100)))<((V98*V92*W43/((1+W24/100)*(1+W42/100))+(W39*V92*V99*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 =G92*(1+H106/100)*H43-H60-H61+H62+H63+H64+H65+H66+H72 =H92*(1+I106/100)*I43-I60-I61+I62+I63+I64+I65+I66+I72 =I92*(1+J106/100)*J43-J60-J61+J62+J63+J64+J65+J66+J72 =J92*(1+K106/100)*K43-K60-K61+K62+K63+K64+K65+K66+K72 =K92*(1+L106/100)*L43-L60-L61+L62+L63+L64+L65+L66+L72 =L92*(1+M106/100)*M43-M60-M61+M62+M63+M64+M65+M66+M72 =M92*(1+N106/100)*N43-N60-N61+N62+N63+N64+N65+N66+N72 =N92*(1+O106/100)*O43-O60-O61+O62+O63+O64+O65+O66+O72 =O92*(1+P106/100)*P43-P60-P61+P62+P63+P64+P65+P66+P72 =P92*(1+Q106/100)*Q43-Q60-Q61+Q62+Q63+Q64+Q65+Q66+Q72 =Q92*(1+R106/100)*R43-R60-R61+R62+R63+R64+R65+R66+R72 =R92*(1+S106/100)*S43-S60-S61+S62+S63+S64+S65+S66+S72 =S92*(1+T106/100)*T43-T60-T61+T62+T63+T64+T65+T66+T72 =T92*(1+U106/100)*U43-U60-U61+U62+U63+U64+U65+U66+U72 =U92*(1+V106/100)*V43-V60-V61+V62+V63+V64+V65+V66+V72 =V92*(1+W106/100)*W43-W60-W61+W62+W63+W64+W65+W66+W72 Of which Outstanding debt ='Input data'!C66*$D$92 =IF(E92=0,0,IF(E87=1,D92*E43/((1+E24/100)*(1+E42/100))-E94-E95,IF(AND(E87=0,E88=1),(1-D98-E39*D99)*D92*E43/((1+E24/100)*(1+E42/100)),E92))) =IF(F92=0,0,IF(F87=1,E92*F43/((1+F24/100)*(1+F42/100))-F94-F95,IF(AND(F87=0,F88=1),(1-E98-F39*E99)*E92*F43/((1+F24/100)*(1+F42/100)),F92))) =IF(G92=0,0,IF(G87=1,F92*G43/((1+G24/100)*(1+G42/100))-G94-G95,IF(AND(G87=0,G88=1),(1-F98-G39*F99)*F92*G43/((1+G24/100)*(1+G42/100)),G92))) =IF(H92=0,0,IF(H87=1,G92*H43/((1+H24/100)*(1+H42/100))-H94-H95,IF(AND(H87=0,H88=1),(1-G98-H39*G99)*G92*H43/((1+H24/100)*(1+H42/100)),H92))) =IF(I92=0,0,IF(I87=1,H92*I43/((1+I24/100)*(1+I42/100))-I94-I95,IF(AND(I87=0,I88=1),(1-H98-I39*H99)*H92*I43/((1+I24/100)*(1+I42/100)),I92))) =IF(J92=0,0,IF(J87=1,I92*J43/((1+J24/100)*(1+J42/100))-J94-J95,IF(AND(J87=0,J88=1),(1-I98-J39*I99)*I92*J43/((1+J24/100)*(1+J42/100)),J92))) =IF(K92=0,0,IF(K87=1,J92*K43/((1+K24/100)*(1+K42/100))-K94-K95,IF(AND(K87=0,K88=1),(1-J98-K39*J99)*J92*K43/((1+K24/100)*(1+K42/100)),K92))) =IF(L92=0,0,IF(L87=1,K92*L43/((1+L24/100)*(1+L42/100))-L94-L95,IF(AND(L87=0,L88=1),(1-K98-L39*K99)*K92*L43/((1+L24/100)*(1+L42/100)),L92))) =IF(M92=0,0,IF(M87=1,L92*M43/((1+M24/100)*(1+M42/100))-M94-M95,IF(AND(M87=0,M88=1),(1-L98-M39*L99)*L92*M43/((1+M24/100)*(1+M42/100)),M92))) =IF(N92=0,0,IF(N87=1,M92*N43/((1+N24/100)*(1+N42/100))-N94-N95,IF(AND(N87=0,N88=1),(1-M98-N39*M99)*M92*N43/((1+N24/100)*(1+N42/100)),N92))) =IF(O92=0,0,IF(O87=1,N92*O43/((1+O24/100)*(1+O42/100))-O94-O95,IF(AND(O87=0,O88=1),(1-N98-O39*N99)*N92*O43/((1+O24/100)*(1+O42/100)),O92))) =IF(P92=0,0,IF(P87=1,O92*P43/((1+P24/100)*(1+P42/100))-P94-P95,IF(AND(P87=0,P88=1),(1-O98-P39*O99)*O92*P43/((1+P24/100)*(1+P42/100)),P92))) =IF(Q92=0,0,IF(Q87=1,P92*Q43/((1+Q24/100)*(1+Q42/100))-Q94-Q95,IF(AND(Q87=0,Q88=1),(1-P98-Q39*P99)*P92*Q43/((1+Q24/100)*(1+Q42/100)),Q92))) =IF(R92=0,0,IF(R87=1,Q92*R43/((1+R24/100)*(1+R42/100))-R94-R95,IF(AND(R87=0,R88=1),(1-Q98-R39*Q99)*Q92*R43/((1+R24/100)*(1+R42/100)),R92))) =IF(S92=0,0,IF(S87=1,R92*S43/((1+S24/100)*(1+S42/100))-S94-S95,IF(AND(S87=0,S88=1),(1-R98-S39*R99)*R92*S43/((1+S24/100)*(1+S42/100)),S92))) =IF(T92=0,0,IF(T87=1,S92*T43/((1+T24/100)*(1+T42/100))-T94-T95,IF(AND(T87=0,T88=1),(1-S98-T39*S99)*S92*T43/((1+T24/100)*(1+T42/100)),T92))) =IF(U92=0,0,IF(U87=1,T92*U43/((1+U24/100)*(1+U42/100))-U94-U95,IF(AND(U87=0,U88=1),(1-T98-U39*T99)*T92*U43/((1+U24/100)*(1+U42/100)),U92))) =IF(V92=0,0,IF(V87=1,U92*V43/((1+V24/100)*(1+V42/100))-V94-V95,IF(AND(V87=0,V88=1),(1-U98-V39*U99)*U92*V43/((1+V24/100)*(1+V42/100)),