Document colectat · Supraveghere fiscală și plan bugetar România
Download
- Instituția sau publicația sursă
- Supraveghere fiscală și plan bugetar România
- Data preluării
- 26.09.2026 17:53
- Dimensiunea materialului
- 345,7 KB
Conținutul documentului colectat
Secțiuni și tabele
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)
| Coloana 1 | Coloana 2 | Coloana 3 | Coloana 4 | Coloana 5 | Coloana 6 | Coloana 7 | Coloana 8 | Coloana 9 | Coloana 10 | Coloana 11 | Coloana 12 | Coloana 13 | Coloana 14 | Coloana 15 | Coloana 16 | Coloana 17 | Coloana 18 | Coloana 19 | Coloana 20 | Coloana 21 | Coloana 22 | Coloana 23 | Coloana 24 | Coloana 25 | Coloana 26 | Coloana 27 | Coloana 28 | Coloana 29 | Coloana 30 | Coloana 31 | Coloana 32 | Coloana 33 | Coloana 34 | Coloana 35 | Coloana 36 | Coloana 37 | Coloana 38 | Coloana 39 | Coloana 40 | Coloana 41 | Coloana 42 | Coloana 43 | Coloana 44 | Coloana 45 | Coloana 46 | Coloana 47 | Coloana 48 | Coloana 49 | Coloana 50 | Coloana 51 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
Debt decomposition and IIR
| Coloana 1 | Coloana 2 | Coloana 3 | Coloana 4 | Coloana 5 | Coloana 6 | Coloana 7 | Coloana 8 | Coloana 9 | Coloana 10 | Coloana 11 | Coloana 12 | Coloana 13 | Coloana 14 | Coloana 15 | Coloana 16 | Coloana 17 | Coloana 18 | Coloana 19 | Coloana 20 | Coloana 21 | Coloana 22 | Coloana 23 | Coloana 24 | Coloana 25 | Coloana 26 | Coloana 27 | Coloana 28 | Coloana 29 | Coloana 30 | Coloana 31 | Coloana 32 | Coloana 33 | Coloana 34 | Coloana 35 | Coloana 36 | Coloana 37 | Coloana 38 | Coloana 39 | Coloana 40 | Coloana 41 | Coloana 42 | Coloana 43 | Coloana 44 | Coloana 45 | Coloana 46 | Coloana 47 | Coloana 48 | Coloana 49 | Coloana 50 | Coloana 51 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
| Coloana 1 | Coloana 2 | Coloana 3 | Coloana 4 | Coloana 5 | Coloana 6 | Coloana 7 | Coloana 8 | Coloana 9 | Coloana 10 | Coloana 11 | Coloana 12 | Coloana 13 | Coloana 14 | Coloana 15 | Coloana 16 | Coloana 17 | Coloana 18 | Coloana 19 | Coloana 20 | Coloana 21 | Coloana 22 | Coloana 23 | Coloana 24 | Coloana 25 | Coloana 26 | Coloana 27 | Coloana 28 | Coloana 29 | Coloana 30 | Coloana 31 | Coloana 32 | Coloana 33 | Coloana 34 | Coloana 35 | Coloana 36 | Coloana 37 | Coloana 38 | Coloana 39 | Coloana 40 | Coloana 41 | Coloana 42 | Coloana 43 | Coloana 44 | Coloana 45 | Coloana 46 | Coloana 47 | Coloana 48 | Coloana 49 | Coloana 50 | Coloana 51 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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))) | ||||||||||||||||||||||||||||||
| Rolled over short-term debt | ='Input data'!C68*$D$100 | =IF(E100=0,0,IF(E95=1,(1-D107)*D100*E43/((1+E24/100)*(1+E42/100)),IF(AND(E95=0,E96=1),(D106*D100*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,(1-E107)*E100*F43/((1+F24/100)*(1+F42/100)),IF(AND(F95=0,F96=1),(E106*E100*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,(1-F107)*F100*G43/((1+G24/100)*(1+G42/100)),IF(AND(G95=0,G96=1),(F106*F100*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,(1-G107)*G100*H43/((1+H24/100)*(1+H42/100)),IF(AND(H95=0,H96=1),(G106*G100*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,(1-H107)*H100*I43/((1+I24/100)*(1+I42/100)),IF(AND(I95=0,I96=1),(H106*H100*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,(1-I107)*I100*J43/((1+J24/100)*(1+J42/100)),IF(AND(J95=0,J96=1),(I106*I100*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,(1-J107)*J100*K43/((1+K24/100)*(1+K42/100)),IF(AND(K95=0,K96=1),(J106*J100*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,(1-K107)*K100*L43/((1+L24/100)*(1+L42/100)),IF(AND(L95=0,L96=1),(K106*K100*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,(1-L107)*L100*M43/((1+M24/100)*(1+M42/100)),IF(AND(M95=0,M96=1),(L106*L100*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,(1-M107)*M100*N43/((1+N24/100)*(1+N42/100)),IF(AND(N95=0,N96=1),(M106*M100*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,(1-N107)*N100*O43/((1+O24/100)*(1+O42/100)),IF(AND(O95=0,O96=1),(N106*N100*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,(1-O107)*O100*P43/((1+P24/100)*(1+P42/100)),IF(AND(P95=0,P96=1),(O106*O100*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,(1-P107)*P100*Q43/((1+Q24/100)*(1+Q42/100)),IF(AND(Q95=0,Q96=1),(P106*P100*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,(1-Q107)*Q100*R43/((1+R24/100)*(1+R42/100)),IF(AND(R95=0,R96=1),(Q106*Q100*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,(1-R107)*R100*S43/((1+S24/100)*(1+S42/100)),IF(AND(S95=0,S96=1),(R106*R100*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,(1-S107)*S100*T43/((1+T24/100)*(1+T42/100)),IF(AND(T95=0,T96=1),(S106*S100*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,(1-T107)*T100*U43/((1+U24/100)*(1+U42/100)),IF(AND(U95=0,U96=1),(T106*T100*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,(1-U107)*U100*V43/((1+V24/100)*(1+V42/100)),IF(AND(V95=0,V96=1),(U106*U100*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,(1-V107)*V100*W43/((1+W24/100)*(1+W42/100)),IF(AND(W95=0,W96=1),(V106*V100*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))) | ||||||||||||||||||||||||||||||
| New long-term debt | ='Input data'!C69*$D$100 | =IF(E100=0,0,IF(E95=1,'Input data'!$C$58*(E100-D100*E43/((1+E24/100)*(1+E42/100))),0)) | =IF(F100=0,0,IF(F95=1,'Input data'!$C$58*(F100-E100*F43/((1+F24/100)*(1+F42/100))),0)) | =IF(G100=0,0,IF(G95=1,'Input data'!$C$58*(G100-F100*G43/((1+G24/100)*(1+G42/100))),0)) | =IF(H100=0,0,IF(H95=1,'Input data'!$C$58*(H100-G100*H43/((1+H24/100)*(1+H42/100))),0)) | =IF(I100=0,0,IF(I95=1,'Input data'!$C$58*(I100-H100*I43/((1+I24/100)*(1+I42/100))),0)) | =IF(J100=0,0,IF(J95=1,'Input data'!$C$58*(J100-I100*J43/((1+J24/100)*(1+J42/100))),0)) | =IF(K100=0,0,IF(K95=1,'Input data'!$C$58*(K100-J100*K43/((1+K24/100)*(1+K42/100))),0)) | =IF(L100=0,0,IF(L95=1,'Input data'!$C$58*(L100-K100*L43/((1+L24/100)*(1+L42/100))),0)) | =IF(M100=0,0,IF(M95=1,'Input data'!$C$58*(M100-L100*M43/((1+M24/100)*(1+M42/100))),0)) | =IF(N100=0,0,IF(N95=1,'Input data'!$C$58*(N100-M100*N43/((1+N24/100)*(1+N42/100))),0)) | =IF(O100=0,0,IF(O95=1,'Input data'!$C$58*(O100-N100*O43/((1+O24/100)*(1+O42/100))),0)) | =IF(P100=0,0,IF(P95=1,'Input data'!$C$58*(P100-O100*P43/((1+P24/100)*(1+P42/100))),0)) | =IF(Q100=0,0,IF(Q95=1,'Input data'!$C$58*(Q100-P100*Q43/((1+Q24/100)*(1+Q42/100))),0)) | =IF(R100=0,0,IF(R95=1,'Input data'!$C$58*(R100-Q100*R43/((1+R24/100)*(1+R42/100))),0)) | =IF(S100=0,0,IF(S95=1,'Input data'!$C$58*(S100-R100*S43/((1+S24/100)*(1+S42/100))),0)) | =IF(T100=0,0,IF(T95=1,'Input data'!$C$58*(T100-S100*T43/((1+T24/100)*(1+T42/100))),0)) | =IF(U100=0,0,IF(U95=1,'Input data'!$C$58*(U100-T100*U43/((1+U24/100)*(1+U42/100))),0)) | =IF(V100=0,0,IF(V95=1,'Input data'!$C$58*(V100-U100*V43/((1+V24/100)*(1+V42/100))),0)) | =IF(W100=0,0,IF(W95=1,'Input data'!$C$58*(W100-V100*W43/((1+W24/100)*(1+W42/100))),0)) | ||||||||||||||||||||||||||||||
| New short-term debt | ='Input data'!C70*$D$100 | =IF(E100=0,0,IF(E95=1,'Input data'!$C$57*(E100-D100*E43/((1+E24/100)*(1+E42/100))),0)) | =IF(F100=0,0,IF(F95=1,'Input data'!$C$57*(F100-E100*F43/((1+F24/100)*(1+F42/100))),0)) | =IF(G100=0,0,IF(G95=1,'Input data'!$C$57*(G100-F100*G43/((1+G24/100)*(1+G42/100))),0)) | =IF(H100=0,0,IF(H95=1,'Input data'!$C$57*(H100-G100*H43/((1+H24/100)*(1+H42/100))),0)) | =IF(I100=0,0,IF(I95=1,'Input data'!$C$57*(I100-H100*I43/((1+I24/100)*(1+I42/100))),0)) | =IF(J100=0,0,IF(J95=1,'Input data'!$C$57*(J100-I100*J43/((1+J24/100)*(1+J42/100))),0)) | =IF(K100=0,0,IF(K95=1,'Input data'!$C$57*(K100-J100*K43/((1+K24/100)*(1+K42/100))),0)) | =IF(L100=0,0,IF(L95=1,'Input data'!$C$57*(L100-K100*L43/((1+L24/100)*(1+L42/100))),0)) | =IF(M100=0,0,IF(M95=1,'Input data'!$C$57*(M100-L100*M43/((1+M24/100)*(1+M42/100))),0)) | =IF(N100=0,0,IF(N95=1,'Input data'!$C$57*(N100-M100*N43/((1+N24/100)*(1+N42/100))),0)) | =IF(O100=0,0,IF(O95=1,'Input data'!$C$57*(O100-N100*O43/((1+O24/100)*(1+O42/100))),0)) | =IF(P100=0,0,IF(P95=1,'Input data'!$C$57*(P100-O100*P43/((1+P24/100)*(1+P42/100))),0)) | =IF(Q100=0,0,IF(Q95=1,'Input data'!$C$57*(Q100-P100*Q43/((1+Q24/100)*(1+Q42/100))),0)) | =IF(R100=0,0,IF(R95=1,'Input data'!$C$57*(R100-Q100*R43/((1+R24/100)*(1+R42/100))),0)) | =IF(S100=0,0,IF(S95=1,'Input data'!$C$57*(S100-R100*S43/((1+S24/100)*(1+S42/100))),0)) | =IF(T100=0,0,IF(T95=1,'Input data'!$C$57*(T100-S100*T43/((1+T24/100)*(1+T42/100))),0)) | =IF(U100=0,0,IF(U95=1,'Input data'!$C$57*(U100-T100*U43/((1+U24/100)*(1+U42/100))),0)) | =IF(V100=0,0,IF(V95=1,'Input data'!$C$57*(V100-U100*V43/((1+V24/100)*(1+V42/100))),0)) | =IF(W100=0,0,IF(W95=1,'Input data'!$C$57*(W100-V100*W43/((1+W24/100)*(1+W42/100))),0)) | ||||||||||||||||||||||||||||||
| Share of short-term debt in total government debt | ='Baseline NFPC'!$D$93 | =IF(E100<>0,(E103+E105)/(E101+E102+E103+E104+E105),0) | =IF(F100<>0,(F103+F105)/(F101+F102+F103+F104+F105),0) | =IF(G100<>0,(G103+G105)/(G101+G102+G103+G104+G105),0) | =IF(H100<>0,(H103+H105)/(H101+H102+H103+H104+H105),0) | =IF(I100<>0,(I103+I105)/(I101+I102+I103+I104+I105),0) | =IF(J100<>0,(J103+J105)/(J101+J102+J103+J104+J105),0) | =IF(K100<>0,(K103+K105)/(K101+K102+K103+K104+K105),0) | =IF(L100<>0,(L103+L105)/(L101+L102+L103+L104+L105),0) | =IF(M100<>0,(M103+M105)/(M101+M102+M103+M104+M105),0) | =IF(N100<>0,(N103+N105)/(N101+N102+N103+N104+N105),0) | =IF(O100<>0,(O103+O105)/(O101+O102+O103+O104+O105),0) | =IF(P100<>0,(P103+P105)/(P101+P102+P103+P104+P105),0) | =IF(Q100<>0,(Q103+Q105)/(Q101+Q102+Q103+Q104+Q105),0) | =IF(R100<>0,(R103+R105)/(R101+R102+R103+R104+R105),0) | =IF(S100<>0,(S103+S105)/(S101+S102+S103+S104+S105),0) | =IF(T100<>0,(T103+T105)/(T101+T102+T103+T104+T105),0) | =IF(U100<>0,(U103+U105)/(U101+U102+U103+U104+U105),0) | =IF(V100<>0,(V103+V105)/(V101+V102+V103+V104+V105),0) | =IF(W100<>0,(W103+W105)/(W101+W102+W103+W104+W105),0) |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
Valorile și formulările aparțin documentului citat. Data preluării nu reprezintă perioada datelor sau data publicării de către instituție.
Identificarea exactă a documentului colectat
Amprenta SHA-256 permite identificarea versiunii preluate.
fd31788b7e6a576eb7e55af6f002c6c6d39ebc4d975283a44dd5aad4edf34051