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
Share of long-term debt that matures every year ='Baseline NFPC'!C38 ='Baseline NFPC'!D38 ='Baseline NFPC'!E38 ='Baseline NFPC'!F38 ='Baseline NFPC'!G38 ='Baseline NFPC'!H38 ='Baseline NFPC'!I38 ='Baseline NFPC'!J38 ='Baseline NFPC'!K38 ='Baseline NFPC'!L38 ='Baseline NFPC'!M38 ='Baseline NFPC'!N38 ='Baseline NFPC'!O38 ='Baseline NFPC'!P38 ='Baseline NFPC'!Q38 ='Baseline NFPC'!R38 ='Baseline NFPC'!S38 ='Baseline NFPC'!T38 ='Baseline NFPC'!U38 ='Baseline NFPC'!V38 ='Baseline NFPC'!W38
| 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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Inflation and exchange rate | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| GDP deflator (National currency) | ='Input data'!C42 | ='Input data'!D42 | ='Input data'!E42 | ='Input data'!F42 | ='Input data'!G42 | ='Baseline NFPC'!H41 | ='Baseline NFPC'!I41 | ='Baseline NFPC'!J41 | ='Baseline NFPC'!K41 | ='Baseline NFPC'!L41 | ='Baseline NFPC'!M41 | ='Baseline NFPC'!N41 | ='Baseline NFPC'!O41 | ='Baseline NFPC'!P41 | ='Baseline NFPC'!Q41 | ='Baseline NFPC'!R41 | ='Baseline NFPC'!S41 | ='Baseline NFPC'!T41 | ='Baseline NFPC'!U41 | ='Baseline NFPC'!V41 | ='Baseline NFPC'!W41 | ||||||||||||||||||||||||||||||||
| Exchange rate composite change (weighted by share of debt in each currency) | ='Baseline NFPC'!C42 | ='Baseline NFPC'!D42 | ='Baseline NFPC'!E42 | ='Baseline NFPC'!F42 | ='Baseline NFPC'!G42 | ='Baseline NFPC'!H42 | ='Baseline NFPC'!I42 | ='Baseline NFPC'!J42 | ='Baseline NFPC'!K42 | ='Baseline NFPC'!L42 | ='Baseline NFPC'!M42 | ='Baseline NFPC'!N42 | ='Baseline NFPC'!O42 | ='Baseline NFPC'!P42 | ='Baseline NFPC'!Q42 | ='Baseline NFPC'!R42 | ='Baseline NFPC'!S42 | ='Baseline NFPC'!T42 | ='Baseline NFPC'!U42 | ='Baseline NFPC'!V42 | ='Baseline NFPC'!W42 |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
Intermediate calculations (growth rate equation)
| 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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Fiscal multiplier | ='Input data'!C49 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| Budget balance semi-elasticity | ='Input data'!C50 |
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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Auxiliary variable to control the closure of the output gap | 0 | =IF(AND(ABS((D12-C12)-('Input data'!D13-'Input data'!C13))>0.0001,ABS(D12-C12)>0.0001,D$10>$C$5),4,IF(C50=4,3,IF(C50=3,2,IF(C50=2,1,0)))) | =IF(AND(ABS((E12-D12)-('Input data'!E13-'Input data'!D13))>0.0001,ABS(E12-D12)>0.0001,E$10>$C$5),4,IF(D50=4,3,IF(D50=3,2,IF(D50=2,1,0)))) | =IF(AND(ABS((F12-E12)-('Input data'!F13-'Input data'!E13))>0.0001,ABS(F12-E12)>0.0001,F$10>$C$5),4,IF(E50=4,3,IF(E50=3,2,IF(E50=2,1,0)))) | =IF(AND(ABS((G12-F12)-('Input data'!G13-'Input data'!F13))>0.0001,ABS(G12-F12)>0.0001,G$10>$C$5),4,IF(F50=4,3,IF(F50=3,2,IF(F50=2,1,0)))) | =IF(AND(ABS((H12-G12)-('Input data'!H13-'Input data'!G13))>0.0001,ABS(H12-G12)>0.0001,H$10>$C$5),4,IF(G50=4,3,IF(G50=3,2,IF(G50=2,1,0)))) | =IF(AND(ABS((I12-H12)-('Input data'!I13-'Input data'!H13))>0.0001,ABS(I12-H12)>0.0001,I$10>$C$5),4,IF(H50=4,3,IF(H50=3,2,IF(H50=2,1,0)))) | =IF(AND(ABS((J12-I12)-('Input data'!J13-'Input data'!I13))>0.0001,ABS(J12-I12)>0.0001,J$10>$C$5),4,IF(I50=4,3,IF(I50=3,2,IF(I50=2,1,0)))) | =IF(AND(ABS((K12-J12)-('Input data'!K13-'Input data'!J13))>0.0001,ABS(K12-J12)>0.0001,K$10>$C$5),4,IF(J50=4,3,IF(J50=3,2,IF(J50=2,1,0)))) | =IF(AND(ABS((L12-K12)-('Input data'!L13-'Input data'!K13))>0.0001,ABS(L12-K12)>0.0001,L$10>$C$5),4,IF(K50=4,3,IF(K50=3,2,IF(K50=2,1,0)))) | =IF(AND(ABS((M12-L12)-('Input data'!M13-'Input data'!L13))>0.0001,ABS(M12-L12)>0.0001,M$10>$C$5),4,IF(L50=4,3,IF(L50=3,2,IF(L50=2,1,0)))) | =IF(AND(ABS((N12-M12)-('Input data'!N13-'Input data'!M13))>0.0001,ABS(N12-M12)>0.0001,N$10>$C$5),4,IF(M50=4,3,IF(M50=3,2,IF(M50=2,1,0)))) | =IF(AND(ABS((O12-N12)-('Input data'!O13-'Input data'!N13))>0.0001,ABS(O12-N12)>0.0001,O$10>$C$5),4,IF(N50=4,3,IF(N50=3,2,IF(N50=2,1,0)))) | =IF(AND(ABS((P12-O12)-('Input data'!P13-'Input data'!O13))>0.0001,ABS(P12-O12)>0.0001,P$10>$C$5),4,IF(O50=4,3,IF(O50=3,2,IF(O50=2,1,0)))) | =IF(AND(ABS((Q12-P12)-('Input data'!Q13-'Input data'!P13))>0.0001,ABS(Q12-P12)>0.0001,Q$10>$C$5),4,IF(P50=4,3,IF(P50=3,2,IF(P50=2,1,0)))) | =IF(AND(ABS((R12-Q12)-('Input data'!R13-'Input data'!Q13))>0.0001,ABS(R12-Q12)>0.0001,R$10>$C$5),4,IF(Q50=4,3,IF(Q50=3,2,IF(Q50=2,1,0)))) | =IF(AND(ABS((S12-R12)-('Input data'!S13-'Input data'!R13))>0.0001,ABS(S12-R12)>0.0001,S$10>$C$5),4,IF(R50=4,3,IF(R50=3,2,IF(R50=2,1,0)))) | =IF(AND(ABS((T12-S12)-('Input data'!T13-'Input data'!S13))>0.0001,ABS(T12-S12)>0.0001,T$10>$C$5),4,IF(S50=4,3,IF(S50=3,2,IF(S50=2,1,0)))) | =IF(AND(ABS((U12-T12)-('Input data'!U13-'Input data'!T13))>0.0001,ABS(U12-T12)>0.0001,U$10>$C$5),4,IF(T50=4,3,IF(T50=3,2,IF(T50=2,1,0)))) | =IF(AND(ABS((V12-U12)-('Input data'!V13-'Input data'!U13))>0.0001,ABS(V12-U12)>0.0001,V$10>$C$5),4,IF(U50=4,3,IF(U50=3,2,IF(U50=2,1,0)))) | =IF(AND(ABS((W12-V12)-('Input data'!W13-'Input data'!V13))>0.0001,ABS(W12-V12)>0.0001,W$10>$C$5),4,IF(V50=4,3,IF(V50=3,2,IF(V50=2,1,0)))) | ||||||||||||||||||||||||||||||||
| OG intermediate auxiliary value | 0 | =IF(C50=4,2/3*C30,IF(C50=3,1/3*B30,0)) | =IF(D50=4,2/3*D30,IF(D50=3,1/3*C30,0)) | =IF(E50=4,2/3*E30,IF(E50=3,1/3*D30,0)) | =IF(F50=4,2/3*F30,IF(F50=3,1/3*E30,0)) | =IF(G50=4,2/3*G30,IF(G50=3,1/3*F30,0)) | =IF(H50=4,2/3*H30,IF(H50=3,1/3*G30,0)) | =IF(I50=4,2/3*I30,IF(I50=3,1/3*H30,0)) | =IF(J50=4,2/3*J30,IF(J50=3,1/3*I30,0)) | =IF(K50=4,2/3*K30,IF(K50=3,1/3*J30,0)) | =IF(L50=4,2/3*L30,IF(L50=3,1/3*K30,0)) | =IF(M50=4,2/3*M30,IF(M50=3,1/3*L30,0)) | =IF(N50=4,2/3*N30,IF(N50=3,1/3*M30,0)) | =IF(O50=4,2/3*O30,IF(O50=3,1/3*N30,0)) | =IF(P50=4,2/3*P30,IF(P50=3,1/3*O30,0)) | =IF(Q50=4,2/3*Q30,IF(Q50=3,1/3*P30,0)) | =IF(R50=4,2/3*R30,IF(R50=3,1/3*Q30,0)) | =IF(S50=4,2/3*S30,IF(S50=3,1/3*R30,0)) | =IF(T50=4,2/3*T30,IF(T50=3,1/3*S30,0)) | =IF(U50=4,2/3*U30,IF(U50=3,1/3*T30,0)) | =IF(V50=4,2/3*V30,IF(V50=3,1/3*U30,0)) | ||||||||||||||||||||||||||||||||
| GDP intermediate growth rate - only feedback effect and no closure of the OG | ='Input data'!D30-$C$47*((D12-C12)-('Input data'!D13-'Input data'!C13)) | ='Input data'!E30-$C$47*((E12-D12)-('Input data'!E13-'Input data'!D13)) | ='Input data'!F30-$C$47*((F12-E12)-('Input data'!F13-'Input data'!E13)) | ='Input data'!G30-$C$47*((G12-F12)) | ='Input data'!H30-$C$47*((H12-G12)) | ='Input data'!I30-$C$47*((I12-H12)) | ='Input data'!J30-$C$47*((J12-I12)) | ='Adverse (r-g)'!K24-$C$47*(K12-J12) | ='Adverse (r-g)'!L24-$C$47*(L12-K12) | ='Adverse (r-g)'!M24-$C$47*(M12-L12) | ='Adverse (r-g)'!N24-$C$47*((N12-M12)) | ='Adverse (r-g)'!O24-$C$47*((O12-N12)) | ='Adverse (r-g)'!P24-$C$47*((P12-O12)) | ='Adverse (r-g)'!Q24-$C$47*((Q12-P12)) | ='Adverse (r-g)'!R24-$C$47*((R12-Q12)) | ='Adverse (r-g)'!S24-$C$47*((S12-R12)) | ='Adverse (r-g)'!T24-$C$47*((T12-S12)) | ='Adverse (r-g)'!U24-$C$47*((U12-T12)) | ='Adverse (r-g)'!V24-$C$47*((V12-U12)) | ='Adverse (r-g)'!W24-$C$47*((W12-V12)) |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
Debt projections
| 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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | |||||||||||||||||||||||||||||||||
| Gross debt | =+'Input data'!C12 | =+C57+D58 | =+D57+E58 | =+E57+F58 | =+F57+G58 | =+G57+H58 | =+H57+I58 | =+I57+J58 | =+J57+K58 | =+K57+L58 | =+L57+M58 | =+M57+N58 | =+N57+O58 | =+O57+P58 | =+P57+Q58 | =+Q57+R58 | =+R57+S58 | =+S57+T58 | =+T57+U58 | =+U57+V58 | =+V57+W58 | ||||||||||||||||||||||||||||||||
| Change in debt (-1+2+3) | =-D59+D67+D72 | =-E59+E67+E72 | =-F59+F67+F72 | =-G59+G67+G72 | =-H59+H67+H72 | =-I59+I67+I72 | =-J59+J67+J72 | =-K59+K67+K72 | =-L59+L67+L72 | =-M59+M67+M72 | =-N59+N67+N72 | =-O59+O67+O72 | =-P59+P67+P72 | =-Q59+Q67+Q72 | =-R59+R67+R72 | =-S59+S67+S72 | =-T59+T67+T72 | =-U59+U67+U72 | =-V59+V67+V72 | =-W59+W67+W72 | |||||||||||||||||||||||||||||||||
| (1) Primary balance (1.1 + 1.2 - 1.3 -1.4 -1.5 - 1.6 -1.7) | =D60+D61-D62-D63-D64-D65-D66 | =E60+E61-E62-E63-E64-E65-E66 | =F60+F61-F62-F63-F64-F65-F66 | =G60+G61-G62-G63-G64-G65-G66 | =H60+H61-H62-H63-H64-H65-H66 | =I60+I61-I62-I63-I64-I65-I66 | =J60+J61-J62-J63-J64-J65-J66 | =K60+K61-K62-K63-K64-K65-K66 | =L60+L61-L62-L63-L64-L65-L66 | =M60+M61-M62-M63-M64-M65-M66 | =N60+N61-N62-N63-N64-N65-N66 | =O60+O61-O62-O63-O64-O65-O66 | =P60+P61-P62-P63-P64-P65-P66 | =Q60+Q61-Q62-Q63-Q64-Q65-Q66 | =R60+R61-R62-R63-R64-R65-R66 | =S60+S61-S62-S63-S64-S65-S66 | =T60+T61-T62-T63-T64-T65-T66 | =U60+U61-U62-U63-U64-U65-U66 | =V60+V61-V62-V63-V64-V65-V66 | =W60+W61-W62-W63-W64-W65-W66 | |||||||||||||||||||||||||||||||||
| (1.1) Structural primary balance (before ageing cost) | =D12 | =E12 | =F12 | =IF(G12="",F60,G12) | =IF(H12="",G60,H12) | =IF(I12="",H60,I12) | =IF(J12="",I60,J12) | =IF(K12="",J60,K12) | =IF(L12="",K60,L12) | =IF(M12="",L60,M12) | =IF(N12="",M60,N12) | =IF(O12="",N60,O12) | =IF(P12="",O60,P12) | =IF(Q12="",P60,Q12) | =IF(R12="",Q60,R12) | =IF(S12="",R60,S12) | =IF(T12="",S60,T12) | =IF(U12="",T60,U12) | =IF(V12="",U60,V12) | =IF(W12="",V60,W12) | |||||||||||||||||||||||||||||||||
| (1.2) Cumulated budgetary effort (in terms of primary balance) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
| (1.3) Cyclical component | =-$C$48*D30 | =-$C$48*E30 | =-$C$48*F30 | =-$C$48*G30 | =-$C$48*H30 | =-$C$48*I30 | =-$C$48*J30 | =-$C$48*K30 | =-$C$48*L30 | =-$C$48*M30 | =-$C$48*N30 | =-$C$48*O30 | =-$C$48*P30 | =-$C$48*Q30 | =-$C$48*R30 | =-$C$48*S30 | =-$C$48*T30 | =-$C$48*U30 | =-$C$48*V30 | =-$C$48*W30 | |||||||||||||||||||||||||||||||||
| (1.4) One-off and other temporary measures | =-D13 | =-E13 | =-F13 | =-G13 | =-H13 | =-I13 | =-J13 | =-K13 | =-L13 | =-M13 | =-N13 | =-O13 | =-P13 | =-Q13 | =-R13 | =-S13 | =-T13 | =-U13 | =-V13 | =-W13 | |||||||||||||||||||||||||||||||||
| (1.5) Cost of ageing | =IF(D$56<=$C$6,0,HLOOKUP(D$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(E$56<=$C$6,0,HLOOKUP(E$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(F$56<=$C$6,0,HLOOKUP(F$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(G$56<=$C$6,0,HLOOKUP(G$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(H$56<=$C$6,0,HLOOKUP(H$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(I$56<=$C$6,0,HLOOKUP(I$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(J$56<=$C$6,0,HLOOKUP(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*(D23/100)*(1/(1+D33/100)) | =-D57*(E23/100)*(1/(1+E33/100)) | =-E57*(F23/100)*(1/(1+F33/100)) | =-F57*(G23/100)*(1/(1+G33/100)) | =-G57*(H23/100)*(1/(1+H33/100)) | =-H57*(I23/100)*(1/(1+I33/100)) | =-I57*(J23/100)*(1/(1+J33/100)) | =-J57*(K23/100)*(1/(1+K33/100)) | =-K57*(L23/100)*(1/(1+L33/100)) | =-L57*(M23/100)*(1/(1+M33/100)) | =-M57*(N23/100)*(1/(1+N33/100)) | =-N57*(O23/100)*(1/(1+O33/100)) | =-O57*(P23/100)*(1/(1+P33/100)) | =-P57*(Q23/100)*(1/(1+Q33/100)) | =-Q57*(R23/100)*(1/(1+R33/100)) | =-R57*(S23/100)*(1/(1+S33/100)) | =-S57*(T23/100)*(1/(1+T33/100)) | =-T57*(U23/100)*(1/(1+U33/100)) | =-U57*(V23/100)*(1/(1+V33/100)) | =-V57*(W23/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 | ='Baseline NFPC'!H70 | ='Baseline NFPC'!I70 | ='Baseline NFPC'!J70 | ='Baseline NFPC'!K70 | ='Baseline NFPC'!L70 | ='Baseline NFPC'!M70 | ='Baseline NFPC'!N70 | ='Baseline NFPC'!O70 | ='Baseline NFPC'!P70 | ='Baseline NFPC'!Q70 | ='Baseline NFPC'!R70 | ='Baseline NFPC'!S70 | ='Baseline NFPC'!T70 | ='Baseline NFPC'!U70 | ='Baseline NFPC'!V70 | ='Baseline NFPC'!W70 | |||||||||||||||||||||||||||||||||
| (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 | =D14 | =E14 | =F14 | =G14 | =H14 | =I14 | =J14 | =K14 | =L14 | =M14 | =N14 | =O14 | =P14 | =Q14 | =R14 | =S14 | =T14 | =U14 | =V14 | =W14 | |||||||||||||||||||||||||||||||||
| (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 |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
Debt increasing? (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
| 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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Auxiliary variable identifying whether debt is increasing | =IF((E84-D84*E43/((1+E23/100)*(1+E42/100)))>0,1,0) | =IF((F84-E84*F43/((1+F23/100)*(1+F42/100)))>0,1,0) | =IF((G84-F84*G43/((1+G23/100)*(1+G42/100)))>0,1,0) | =IF((H84-G84*H43/((1+H23/100)*(1+H42/100)))>0,1,0) | =IF((I84-H84*I43/((1+I23/100)*(1+I42/100)))>0,1,0) | =IF((J84-I84*J43/((1+J23/100)*(1+J42/100)))>0,1,0) | =IF((K84-J84*K43/((1+K23/100)*(1+K42/100)))>0,1,0) | =IF((L84-K84*L43/((1+L23/100)*(1+L42/100)))>0,1,0) | =IF((M84-L84*M43/((1+M23/100)*(1+M42/100)))>0,1,0) | =IF((N84-M84*N43/((1+N23/100)*(1+N42/100)))>0,1,0) | =IF((O84-N84*O43/((1+O23/100)*(1+O42/100)))>0,1,0) | =IF((P84-O84*P43/((1+P23/100)*(1+P42/100)))>0,1,0) | =IF((Q84-P84*Q43/((1+Q23/100)*(1+Q42/100)))>0,1,0) | =IF((R84-Q84*R43/((1+R23/100)*(1+R42/100)))>0,1,0) | =IF((S84-R84*S43/((1+S23/100)*(1+S42/100)))>0,1,0) | =IF((T84-S84*T43/((1+T23/100)*(1+T42/100)))>0,1,0) | =IF((U84-T84*U43/((1+U23/100)*(1+U42/100)))>0,1,0) | =IF((V84-U84*V43/((1+V23/100)*(1+V42/100)))>0,1,0) | =IF((W84-V84*W43/((1+W23/100)*(1+W42/100)))>0,1,0) | ||||||||||||||||||||||||||||||||||
| Auxiliary variable identifying whether some debt is rolled over even though debt is decreasing | =IF(AND(E80=0,ABS(E84-D84*E43/((1+E23/100)*(1+E42/100)))<((D90*D84*E43/((1+E23/100)*(1+E42/100))+(E39*D84*D91*E43/((1+E23/100)*(1+E42/100)))))),1,0) | =IF(AND(F80=0,ABS(F84-E84*F43/((1+F23/100)*(1+F42/100)))<((E90*E84*F43/((1+F23/100)*(1+F42/100))+(F39*E84*E91*F43/((1+F23/100)*(1+F42/100)))))),1,0) | =IF(AND(G80=0,ABS(G84-F84*G43/((1+G23/100)*(1+G42/100)))<((F90*F84*G43/((1+G23/100)*(1+G42/100))+(G39*F84*F91*G43/((1+G23/100)*(1+G42/100)))))),1,0) | =IF(AND(H80=0,ABS(H84-G84*H43/((1+H23/100)*(1+H42/100)))<((G90*G84*H43/((1+H23/100)*(1+H42/100))+(H39*G84*G91*H43/((1+H23/100)*(1+H42/100)))))),1,0) | =IF(AND(I80=0,ABS(I84-H84*I43/((1+I23/100)*(1+I42/100)))<((H90*H84*I43/((1+I23/100)*(1+I42/100))+(I39*H84*H91*I43/((1+I23/100)*(1+I42/100)))))),1,0) | =IF(AND(J80=0,ABS(J84-I84*J43/((1+J23/100)*(1+J42/100)))<((I90*I84*J43/((1+J23/100)*(1+J42/100))+(J39*I84*I91*J43/((1+J23/100)*(1+J42/100)))))),1,0) | =IF(AND(K80=0,ABS(K84-J84*K43/((1+K23/100)*(1+K42/100)))<((J90*J84*K43/((1+K23/100)*(1+K42/100))+(K39*J84*J91*K43/((1+K23/100)*(1+K42/100)))))),1,0) | =IF(AND(L80=0,ABS(L84-K84*L43/((1+L23/100)*(1+L42/100)))<((K90*K84*L43/((1+L23/100)*(1+L42/100))+(L39*K84*K91*L43/((1+L23/100)*(1+L42/100)))))),1,0) | =IF(AND(M80=0,ABS(M84-L84*M43/((1+M23/100)*(1+M42/100)))<((L90*L84*M43/((1+M23/100)*(1+M42/100))+(M39*L84*L91*M43/((1+M23/100)*(1+M42/100)))))),1,0) | =IF(AND(N80=0,ABS(N84-M84*N43/((1+N23/100)*(1+N42/100)))<((M90*M84*N43/((1+N23/100)*(1+N42/100))+(N39*M84*M91*N43/((1+N23/100)*(1+N42/100)))))),1,0) | =IF(AND(O80=0,ABS(O84-N84*O43/((1+O23/100)*(1+O42/100)))<((N90*N84*O43/((1+O23/100)*(1+O42/100))+(O39*N84*N91*O43/((1+O23/100)*(1+O42/100)))))),1,0) | =IF(AND(P80=0,ABS(P84-O84*P43/((1+P23/100)*(1+P42/100)))<((O90*O84*P43/((1+P23/100)*(1+P42/100))+(P39*O84*O91*P43/((1+P23/100)*(1+P42/100)))))),1,0) | =IF(AND(Q80=0,ABS(Q84-P84*Q43/((1+Q23/100)*(1+Q42/100)))<((P90*P84*Q43/((1+Q23/100)*(1+Q42/100))+(Q39*P84*P91*Q43/((1+Q23/100)*(1+Q42/100)))))),1,0) | =IF(AND(R80=0,ABS(R84-Q84*R43/((1+R23/100)*(1+R42/100)))<((Q90*Q84*R43/((1+R23/100)*(1+R42/100))+(R39*Q84*Q91*R43/((1+R23/100)*(1+R42/100)))))),1,0) | =IF(AND(S80=0,ABS(S84-R84*S43/((1+S23/100)*(1+S42/100)))<((R90*R84*S43/((1+S23/100)*(1+S42/100))+(S39*R84*R91*S43/((1+S23/100)*(1+S42/100)))))),1,0) | =IF(AND(T80=0,ABS(T84-S84*T43/((1+T23/100)*(1+T42/100)))<((S90*S84*T43/((1+T23/100)*(1+T42/100))+(T39*S84*S91*T43/((1+T23/100)*(1+T42/100)))))),1,0) | =IF(AND(U80=0,ABS(U84-T84*U43/((1+U23/100)*(1+U42/100)))<((T90*T84*U43/((1+U23/100)*(1+U42/100))+(U39*T84*T91*U43/((1+U23/100)*(1+U42/100)))))),1,0) | =IF(AND(V80=0,ABS(V84-U84*V43/((1+V23/100)*(1+V42/100)))<((U90*U84*V43/((1+V23/100)*(1+V42/100))+(V39*U84*U91*V43/((1+V23/100)*(1+V42/100)))))),1,0) | =IF(AND(W80=0,ABS(W84-V84*W43/((1+W23/100)*(1+W42/100)))<((V90*V84*W43/((1+W23/100)*(1+W42/100))+(W39*V84*V91*W43/((1+W23/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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | =G84*(1+H98/100)*H43-H60-H61+H62+H63+H64+H65+H66+H72 | =H84*(1+I98/100)*I43-I60-I61+I62+I63+I64+I65+I66+I72 | =I84*(1+J98/100)*J43-J60-J61+J62+J63+J64+J65+J66+J72 | =J84*(1+K98/100)*K43-K60-K61+K62+K63+K64+K65+K66+K72 | =K84*(1+L98/100)*L43-L60-L61+L62+L63+L64+L65+L66+L72 | =L84*(1+M98/100)*M43-M60-M61+M62+M63+M64+M65+M66+M72 | =M84*(1+N98/100)*N43-N60-N61+N62+N63+N64+N65+N66+N72 | =N84*(1+O98/100)*O43-O60-O61+O62+O63+O64+O65+O66+O72 | =O84*(1+P98/100)*P43-P60-P61+P62+P63+P64+P65+P66+P72 | =P84*(1+Q98/100)*Q43-Q60-Q61+Q62+Q63+Q64+Q65+Q66+Q72 | =Q84*(1+R98/100)*R43-R60-R61+R62+R63+R64+R65+R66+R72 | =R84*(1+S98/100)*S43-S60-S61+S62+S63+S64+S65+S66+S72 | =S84*(1+T98/100)*T43-T60-T61+T62+T63+T64+T65+T66+T72 | =T84*(1+U98/100)*U43-U60-U61+U62+U63+U64+U65+U66+U72 | =U84*(1+V98/100)*V43-V60-V61+V62+V63+V64+V65+V66+V72 | =V84*(1+W98/100)*W43-W60-W61+W62+W63+W64+W65+W66+W72 | ||||||||||||||||||||||||||||||||
| Of which Outstanding debt | ='Input data'!C66*$D$84 | =IF(E84=0,0,IF(E80=1,D84*E43/((1+E23/100)*(1+E42/100))-E86-E87,IF(AND(E80=0,E81=1),(1-D90-E39*D91)*D84*E43/((1+E23/100)*(1+E42/100)),E84))) | =IF(F84=0,0,IF(F80=1,E84*F43/((1+F23/100)*(1+F42/100))-F86-F87,IF(AND(F80=0,F81=1),(1-E90-F39*E91)*E84*F43/((1+F23/100)*(1+F42/100)),F84))) | =IF(G84=0,0,IF(G80=1,F84*G43/((1+G23/100)*(1+G42/100))-G86-G87,IF(AND(G80=0,G81=1),(1-F90-G39*F91)*F84*G43/((1+G23/100)*(1+G42/100)),G84))) | =IF(H84=0,0,IF(H80=1,G84*H43/((1+H23/100)*(1+H42/100))-H86-H87,IF(AND(H80=0,H81=1),(1-G90-H39*G91)*G84*H43/((1+H23/100)*(1+H42/100)),H84))) | =IF(I84=0,0,IF(I80=1,H84*I43/((1+I23/100)*(1+I42/100))-I86-I87,IF(AND(I80=0,I81=1),(1-H90-I39*H91)*H84*I43/((1+I23/100)*(1+I42/100)),I84))) | =IF(J84=0,0,IF(J80=1,I84*J43/((1+J23/100)*(1+J42/100))-J86-J87,IF(AND(J80=0,J81=1),(1-I90-J39*I91)*I84*J43/((1+J23/100)*(1+J42/100)),J84))) | =IF(K84=0,0,IF(K80=1,J84*K43/((1+K23/100)*(1+K42/100))-K86-K87,IF(AND(K80=0,K81=1),(1-J90-K39*J91)*J84*K43/((1+K23/100)*(1+K42/100)),K84))) | =IF(L84=0,0,IF(L80=1,K84*L43/((1+L23/100)*(1+L42/100))-L86-L87,IF(AND(L80=0,L81=1),(1-K90-L39*K91)*K84*L43/((1+L23/100)*(1+L42/100)),L84))) | =IF(M84=0,0,IF(M80=1,L84*M43/((1+M23/100)*(1+M42/100))-M86-M87,IF(AND(M80=0,M81=1),(1-L90-M39*L91)*L84*M43/((1+M23/100)*(1+M42/100)),M84))) | =IF(N84=0,0,IF(N80=1,M84*N43/((1+N23/100)*(1+N42/100))-N86-N87,IF(AND(N80=0,N81=1),(1-M90-N39*M91)*M84*N43/((1+N23/100)*(1+N42/100)),N84))) | =IF(O84=0,0,IF(O80=1,N84*O43/((1+O23/100)*(1+O42/100))-O86-O87,IF(AND(O80=0,O81=1),(1-N90-O39*N91)*N84*O43/((1+O23/100)*(1+O42/100)),O84))) | =IF(P84=0,0,IF(P80=1,O84*P43/((1+P23/100)*(1+P42/100))-P86-P87,IF(AND(P80=0,P81=1),(1-O90-P39*O91)*O84*P43/((1+P23/100)*(1+P42/100)),P84))) | =IF(Q84=0,0,IF(Q80=1,P84*Q43/((1+Q23/100)*(1+Q42/100))-Q86-Q87,IF(AND(Q80=0,Q81=1),(1-P90-Q39*P91)*P84*Q43/((1+Q23/100)*(1+Q42/100)),Q84))) | =IF(R84=0,0,IF(R80=1,Q84*R43/((1+R23/100)*(1+R42/100))-R86-R87,IF(AND(R80=0,R81=1),(1-Q90-R39*Q91)*Q84*R43/((1+R23/100)*(1+R42/100)),R84))) | =IF(S84=0,0,IF(S80=1,R84*S43/((1+S23/100)*(1+S42/100))-S86-S87,IF(AND(S80=0,S81=1),(1-R90-S39*R91)*R84*S43/((1+S23/100)*(1+S42/100)),S84))) | =IF(T84=0,0,IF(T80=1,S84*T43/((1+T23/100)*(1+T42/100))-T86-T87,IF(AND(T80=0,T81=1),(1-S90-T39*S91)*S84*T43/((1+T23/100)*(1+T42/100)),T84))) | =IF(U84=0,0,IF(U80=1,T84*U43/((1+U23/100)*(1+U42/100))-U86-U87,IF(AND(U80=0,U81=1),(1-T90-U39*T91)*T84*U43/((1+U23/100)*(1+U42/100)),U84))) | =IF(V84=0,0,IF(V80=1,U84*V43/((1+V23/100)*(1+V42/100))-V86-V87,IF(AND(V80=0,V81=1),(1-U90-V39*U91)*U84*V43/((1+V23/100)*(1+V42/100)),V84))) | =IF(W84=0,0,IF(W80=1,V84*W43/((1+W23/100)*(1+W42/100))-W86-W87,IF(AND(W80=0,W81=1),(1-V90-W39*V91)*V84*W43/((1+W23/100)*(1+W42/100)),W84))) |
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