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
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Output gap | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Output gap | =100*(C22/C26-1) | =100*(D22/D26-1) | =100*(E22/E26-1) | =100*(F22/F26-1) | =100*(G22/G26-1) | =100*(H22/H26-1) | =100*(I22/I26-1) | =100*(J22/J26-1) | =100*(K22/K26-1) | =100*(L22/L26-1) | =100*(M22/M26-1) | =100*(N22/N26-1) | =100*(O22/O26-1) | =100*(P22/P26-1) | =100*(Q22/Q26-1) | =100*(R22/R26-1) | =100*(S22/S26-1) | =100*(T22/T26-1) | =100*(U22/U26-1) | =100*(V22/V26-1) | =100*(W22/W26-1) |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Actual GDP (nominal, national currency) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Growth rate | =100*((1+C23/100)*(1+C41/100)-1) | =100*((1+D23/100)*(1+D41/100)-1) | =100*((1+E23/100)*(1+E41/100)-1) | =100*((1+F23/100)*(1+F41/100)-1) | =100*((1+G23/100)*(1+G41/100)-1) | =100*((1+H23/100)*(1+H41/100)-1) | =100*((1+I23/100)*(1+I41/100)-1) | =100*((1+J23/100)*(1+J41/100)-1) | =100*((1+K23/100)*(1+K41/100)-1) | =100*((1+L23/100)*(1+L41/100)-1) | =100*((1+M23/100)*(1+M41/100)-1) | =100*((1+N23/100)*(1+N41/100)-1) | =100*((1+O23/100)*(1+O41/100)-1) | =100*((1+P23/100)*(1+P41/100)-1) | =100*((1+Q23/100)*(1+Q41/100)-1) | =100*((1+R23/100)*(1+R41/100)-1) | =100*((1+S23/100)*(1+S41/100)-1) | =100*((1+T23/100)*(1+T41/100)-1) | =100*((1+U23/100)*(1+U41/100)-1) | =100*((1+V23/100)*(1+V41/100)-1) | =100*((1+W23/100)*(1+W41/100)-1) |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Interest rates | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Nominal implicit interest rate on debt | ='Input data'!C37 | ='Input data'!D37 | ='Input data'!E37 | ='Input data'!F37 | ='Input data'!G37 | =H92 | =I92 | =J92 | =K92 | =L92 | =M92 | =N92 | =O92 | =P92 | =Q92 | =R92 | =S92 | =T92 | =U92 | =V92 | =W92 | ||||||||||||||||||||||||||||||||
| Long-term interest rate | ='Input data'!D$39 | ='Input data'!E$39 | ='Input data'!F$39 | ='Input data'!G$39 | =G36+($O$36-$G$36)/($O$10-$G$10) | =H36+($O$36-$G$36)/($O$10-$G$10) | =I36+($O$36-$G$36)/($O$10-$G$10) | =IF('Criteria results'!$F$5=4,IF(J56>90,G36+('Input data'!$C$52-$G$36)/($O$10-$G$10)*(K10-$G$10)+1+0.06*(J56-90),G36+('Input data'!$C$52-$G$36)/($O$10-$G$10)*(K10-$G$10)+1),G36+('Input data'!$C$52-$G$36)/($O$10-$G$10)*(K10-$G$10)) | =$G$36+('Input data'!$C$52-$G$36)/($O$10-$G$10)*(L10-$G$10) | =$G$36+('Input data'!$C$52-$G$36)/($O$10-$G$10)*(M10-$G$10) | =IF('Criteria results'!$F$5=7,IF(M56>90,G36+('Input data'!$C$52-$G$36)/($O$10-$G$10)*(N10-$G$10)+1+0.06*(M56-90),G36+('Input data'!$C$52-$G$36)/($O$10-$G$10)*(N10-$G$10)+1),G36+('Input data'!$C$52-$G$36)/($O$10-$G$10)*(N10-$G$10)) | ='Baseline NFPC'!O36 | ='Baseline NFPC'!P36 | ='Baseline NFPC'!Q36 | ='Baseline NFPC'!R36 | ='Baseline NFPC'!S36 | ='Baseline NFPC'!T36 | ='Baseline NFPC'!U36 | ='Baseline NFPC'!V36 | ='Baseline NFPC'!W36 | |||||||||||||||||||||||||||||||||
| Short-term interest rate | ='Input data'!D$38 | ='Input data'!E$38 | ='Input data'!F$38 | ='Input data'!G$38 | =G37+($O$37-$G$37)/($O$10-$G$10) | =H37+($O$37-$G$37)/($O$10-$G$10) | =I37+($O$37-$G$37)/($O$10-$G$10) | =IF('Criteria results'!$F$5=4,IF(J56>90,G37+('Input data'!$C$53-$G$37)/($O$10-$G$10)*(K10-$G$10)+1+0.06*(J56-90),G37+('Input data'!$C$53-$G$37)/($O$10-$G$10)*(K10-$G$10)+1),G37+('Input data'!$C$53-$G$37)/($O$10-$G$10)*(K10-$G$10)) | =$G$37+('Input data'!$C$53-$G$37)/($O$10-$G$10)*(L10-$G$10) | =$G$37+('Input data'!$C$53-$G$37)/($O$10-$G$10)*(M10-$G$10) | =IF('Criteria results'!$F$5=7,IF(M56>90,G37+('Input data'!$C$53-$G$37)/($O$10-$G$10)*(N10-$G$10)+1+0.06*(M56-90),G37+('Input data'!$C$53-$G$37)/($O$10-$G$10)*(N10-$G$10)+1),G37+('Input data'!$C$53-$G$37)/($O$10-$G$10)*(N10-$G$10)) | ='Baseline NFPC'!O37 | ='Baseline NFPC'!P37 | ='Baseline NFPC'!Q37 | ='Baseline NFPC'!R37 | ='Baseline NFPC'!S37 | ='Baseline NFPC'!T37 | ='Baseline NFPC'!U37 | ='Baseline NFPC'!V37 | ='Baseline NFPC'!W37 | |||||||||||||||||||||||||||||||||
| 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 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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(C49=4,3,IF(C49=3,2,IF(C49=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(D49=4,3,IF(D49=3,2,IF(D49=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(E49=4,3,IF(E49=3,2,IF(E49=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(F49=4,3,IF(F49=3,2,IF(F49=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(G49=4,3,IF(G49=3,2,IF(G49=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(H49=4,3,IF(H49=3,2,IF(H49=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(I49=4,3,IF(I49=3,2,IF(I49=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(J49=4,3,IF(J49=3,2,IF(J49=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(K49=4,3,IF(K49=3,2,IF(K49=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(L49=4,3,IF(L49=3,2,IF(L49=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(M49=4,3,IF(M49=3,2,IF(M49=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(N49=4,3,IF(N49=3,2,IF(N49=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(O49=4,3,IF(O49=3,2,IF(O49=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(P49=4,3,IF(P49=3,2,IF(P49=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(Q49=4,3,IF(Q49=3,2,IF(Q49=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(R49=4,3,IF(R49=3,2,IF(R49=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(S49=4,3,IF(S49=3,2,IF(S49=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(T49=4,3,IF(T49=3,2,IF(T49=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(U49=4,3,IF(U49=3,2,IF(U49=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(V49=4,3,IF(V49=3,2,IF(V49=2,1,0)))) | ||||||||||||||||||||||||||||||||
| OG intermediate auxiliary value | 0 | =IF(C49=4,2/3*C29,IF(C49=3,1/3*B29,0)) | =IF(D49=4,2/3*D29,IF(D49=3,1/3*C29,0)) | =IF(E49=4,2/3*E29,IF(E49=3,1/3*D29,0)) | =IF(F49=4,2/3*F29,IF(F49=3,1/3*E29,0)) | =IF(G49=4,2/3*G29,IF(G49=3,1/3*F29,0)) | =IF(H49=4,2/3*H29,IF(H49=3,1/3*G29,0)) | =IF(I49=4,2/3*I29,IF(I49=3,1/3*H29,0)) | =IF(J49=4,2/3*J29,IF(J49=3,1/3*I29,0)) | =IF(K49=4,2/3*K29,IF(K49=3,1/3*J29,0)) | =IF(L49=4,2/3*L29,IF(L49=3,1/3*K29,0)) | =IF(M49=4,2/3*M29,IF(M49=3,1/3*L29,0)) | =IF(N49=4,2/3*N29,IF(N49=3,1/3*M29,0)) | =IF(O49=4,2/3*O29,IF(O49=3,1/3*N29,0)) | =IF(P49=4,2/3*P29,IF(P49=3,1/3*O29,0)) | =IF(Q49=4,2/3*Q29,IF(Q49=3,1/3*P29,0)) | =IF(R49=4,2/3*R29,IF(R49=3,1/3*Q29,0)) | =IF(S49=4,2/3*S29,IF(S49=3,1/3*R29,0)) | =IF(T49=4,2/3*T29,IF(T49=3,1/3*S29,0)) | =IF(U49=4,2/3*U29,IF(U49=3,1/3*T29,0)) | =IF(V49=4,2/3*V29,IF(V49=3,1/3*U29,0)) | ||||||||||||||||||||||||||||||||
| GDP intermediate growth rate - only feedback effect and no closure of the OG | ='Input data'!D30-$C$46*((D12-C12)-('Input data'!D13-'Input data'!C13)) | ='Input data'!E30-$C$46*((E12-D12)-('Input data'!E13-'Input data'!D13)) | ='Input data'!F30-$C$46*((F12-E12)-('Input data'!F13-'Input data'!E13)) | ='Input data'!G30-$C$46*((G12-F12)) | ='Input data'!H30-$C$46*((H12-G12)) | ='Input data'!I30-$C$46*((I12-H12)) | ='Input data'!J30-$C$46*((J12-I12)) | ='Input data'!K30-$C$46*((K12-J12)) | ='Input data'!L30-$C$46*((L12-K12)) | ='Input data'!M30-$C$46*((M12-L12)) | ='Input data'!N30-$C$46*((N12-M12)) | ='Input data'!O30-$C$46*((O12-N12)) | ='Input data'!P30-$C$46*((P12-O12)) | ='Input data'!Q30-$C$46*((Q12-P12)) | ='Input data'!R30-$C$46*((R12-Q12)) | ='Input data'!S30-$C$46*((S12-R12)) | ='Input data'!T30-$C$46*((T12-S12)) | ='Input data'!U30-$C$46*((U12-T12)) | ='Input data'!V30-$C$46*((V12-U12)) | ='Input data'!W30-$C$46*((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 | =+C56+D57 | =+D56+E57 | =+E56+F57 | =+F56+G57 | =+G56+H57 | =+H56+I57 | =+I56+J57 | =+J56+K57 | =+K56+L57 | =+L56+M57 | =+M56+N57 | =+N56+O57 | =+O56+P57 | =+P56+Q57 | =+Q56+R57 | =+R56+S57 | =+S56+T57 | =+T56+U57 | =+U56+V57 | =+V56+W57 | ||||||||||||||||||||||||||||||||
| Change in debt (-1+2+3) | =-D58+D66+D71 | =-E58+E66+E71 | =-F58+F66+F71 | =-G58+G66+G71 | =-H58+H66+H71 | =-I58+I66+I71 | =-J58+J66+J71 | =-K58+K66+K71 | =-L58+L66+L71 | =-M58+M66+M71 | =-N58+N66+N71 | =-O58+O66+O71 | =-P58+P66+P71 | =-Q58+Q66+Q71 | =-R58+R66+R71 | =-S58+S66+S71 | =-T58+T66+T71 | =-U58+U66+U71 | =-V58+V66+V71 | =-W58+W66+W71 | |||||||||||||||||||||||||||||||||
| (1) Primary balance (1.1 + 1.2 - 1.3 -1.4 -1.5 - 1.6 -1.7) | =D59+D60-D61-D62-D63-D64-D65 | =E59+E60-E61-E62-E63-E64-E65 | =F59+F60-F61-F62-F63-F64-F65 | =G59+G60-G61-G62-G63-G64-G65 | =H59+H60-H61-H62-H63-H64-H65 | =I59+I60-I61-I62-I63-I64-I65 | =J59+J60-J61-J62-J63-J64-J65 | =K59+K60-K61-K62-K63-K64-K65 | =L59+L60-L61-L62-L63-L64-L65 | =M59+M60-M61-M62-M63-M64-M65 | =N59+N60-N61-N62-N63-N64-N65 | =O59+O60-O61-O62-O63-O64-O65 | =P59+P60-P61-P62-P63-P64-P65 | =Q59+Q60-Q61-Q62-Q63-Q64-Q65 | =R59+R60-R61-R62-R63-R64-R65 | =S59+S60-S61-S62-S63-S64-S65 | =T59+T60-T61-T62-T63-T64-T65 | =U59+U60-U61-U62-U63-U64-U65 | =V59+V60-V61-V62-V63-V64-V65 | =W59+W60-W61-W62-W63-W64-W65 | |||||||||||||||||||||||||||||||||
| (1.1) Structural primary balance (before ageing cost) | =D12 | =E12 | =F12 | =IF(G12="",F59,G12) | =IF(H12="",G59,H12) | =IF(I12="",H59,I12) | =IF(J12="",I59,J12) | =IF(K12="",J59,K12) | =IF(L12="",K59,L12) | =IF(M12="",L59,M12) | =IF(N12="",M59,N12) | =IF(O12="",N59,O12) | =IF(P12="",O59,P12) | =IF(Q12="",P59,Q12) | =IF(R12="",Q59,R12) | =IF(S12="",R59,S12) | =IF(T12="",S59,T12) | =IF(U12="",T59,U12) | =IF(V12="",U59,V12) | =IF(W12="",V59,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$47*D29 | =-$C$47*E29 | =-$C$47*F29 | =-$C$47*G29 | =-$C$47*H29 | =-$C$47*I29 | =-$C$47*J29 | =-$C$47*K29 | =-$C$47*L29 | =-$C$47*M29 | =-$C$47*N29 | =-$C$47*O29 | =-$C$47*P29 | =-$C$47*Q29 | =-$C$47*R29 | =-$C$47*S29 | =-$C$47*T29 | =-$C$47*U29 | =-$C$47*V29 | =-$C$47*W29 | |||||||||||||||||||||||||||||||||
| (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$55<=$C$6,0,HLOOKUP(D$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(E$55<=$C$6,0,HLOOKUP(E$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(F$55<=$C$6,0,HLOOKUP(F$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(G$55<=$C$6,0,HLOOKUP(G$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(H$55<=$C$6,0,HLOOKUP(H$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(I$55<=$C$6,0,HLOOKUP(I$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(J$55<=$C$6,0,HLOOKUP(J$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(K$55<=$C$6,0,HLOOKUP(K$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(L$55<=$C$6,0,HLOOKUP(L$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(M$55<=$C$6,0,HLOOKUP(M$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(N$55<=$C$6,0,HLOOKUP(N$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(O$55<=$C$6,0,HLOOKUP(O$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(P$55<=$C$6,0,HLOOKUP(P$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(Q$55<=$C$6,0,HLOOKUP(Q$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(R$55<=$C$6,0,HLOOKUP(R$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(S$55<=$C$6,0,HLOOKUP(S$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(T$55<=$C$6,0,HLOOKUP(T$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(U$55<=$C$6,0,HLOOKUP(U$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(V$55<=$C$6,0,HLOOKUP(V$55,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE)) | =IF(W$55<=$C$6,0,HLOOKUP(W$55,'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$55<=$C$5,0,-HLOOKUP(D$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(E$55<=$C$5,0,-HLOOKUP(E$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(F$55<=$C$5,0,-HLOOKUP(F$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(G$55<=$C$6,0,-HLOOKUP(G$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(H$55<=$C$6,0,-HLOOKUP(H$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(I$55<=$C$6,0,-HLOOKUP(I$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(J$55<=$C$6,0,-HLOOKUP(J$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(K$55<=$C$6,0,-HLOOKUP(K$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(L$55<=$C$6,0,-HLOOKUP(L$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(M$55<=$C$6,0,-HLOOKUP(M$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(N$55<=$C$6,0,-HLOOKUP(N$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(O$55<=$C$6,0,-HLOOKUP(O$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(P$55<=$C$6,0,-HLOOKUP(P$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(Q$55<=$C$6,0,-HLOOKUP(Q$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(R$55<=$C$6,0,-HLOOKUP(R$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(S$55<=$C$6,0,-HLOOKUP(S$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(T$55<=$C$6,0,-HLOOKUP(T$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(U$55<=$C$6,0,-HLOOKUP(U$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(V$55<=$C$6,0,-HLOOKUP(V$55,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE)) | =IF(W$55<=$C$6,0,-HLOOKUP(W$55,'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(D67:D70) | =SUM(E67:E70) | =SUM(F67:F70) | =SUM(G67:G70) | =SUM(H67:H70) | =SUM(I67:I70) | =SUM(J67:J70) | =SUM(K67:K70) | =SUM(L67:L70) | =SUM(M67:M70) | =SUM(N67:N70) | =SUM(O67:O70) | =SUM(P67:P70) | =SUM(Q67:Q70) | =SUM(R67:R70) | =SUM(S67:S70) | =SUM(T67:T70) | =SUM(U67:U70) | =SUM(V67:V70) | =SUM(W67:W70) | |||||||||||||||||||||||||||||||||
| (2.1) Interest expenditure | =C56*D35/100*(1/(1+D32/100)) | =D56*E35/100*(1/(1+E32/100)) | =E56*F35/100*(1/(1+F32/100)) | =F56*G35/100*(1/(1+G32/100)) | =G56*H35/100*(1/(1+H32/100)) | =H56*I35/100*(1/(1+I32/100)) | =I56*J35/100*(1/(1+J32/100)) | =J56*K35/100*(1/(1+K32/100)) | =K56*L35/100*(1/(1+L32/100)) | =L56*M35/100*(1/(1+M32/100)) | =M56*N35/100*(1/(1+N32/100)) | =N56*O35/100*(1/(1+O32/100)) | =O56*P35/100*(1/(1+P32/100)) | =P56*Q35/100*(1/(1+Q32/100)) | =Q56*R35/100*(1/(1+R32/100)) | =R56*S35/100*(1/(1+S32/100)) | =S56*T35/100*(1/(1+T32/100)) | =T56*U35/100*(1/(1+U32/100)) | =U56*V35/100*(1/(1+V32/100)) | =V56*W35/100*(1/(1+W32/100)) | |||||||||||||||||||||||||||||||||
| (2.2) Growth effect | =-C56*(D23/100)*(1/(1+D32/100)) | =-D56*(E23/100)*(1/(1+E32/100)) | =-E56*(F23/100)*(1/(1+F32/100)) | =-F56*(G23/100)*(1/(1+G32/100)) | =-G56*(H23/100)*(1/(1+H32/100)) | =-H56*(I23/100)*(1/(1+I32/100)) | =-I56*(J23/100)*(1/(1+J32/100)) | =-J56*(K23/100)*(1/(1+K32/100)) | =-K56*(L23/100)*(1/(1+L32/100)) | =-L56*(M23/100)*(1/(1+M32/100)) | =-M56*(N23/100)*(1/(1+N32/100)) | =-N56*(O23/100)*(1/(1+O32/100)) | =-O56*(P23/100)*(1/(1+P32/100)) | =-P56*(Q23/100)*(1/(1+Q32/100)) | =-Q56*(R23/100)*(1/(1+R32/100)) | =-R56*(S23/100)*(1/(1+S32/100)) | =-S56*(T23/100)*(1/(1+T32/100)) | =-T56*(U23/100)*(1/(1+U32/100)) | =-U56*(V23/100)*(1/(1+V32/100)) | =-V56*(W23/100)*(1/(1+W32/100)) | |||||||||||||||||||||||||||||||||
| (2.3) Inflation effect | =-C56*D41/100*(1/(1+D41/100)) | =-D56*E41/100*(1/(1+E41/100)) | =-E56*F41/100*(1/(1+F41/100)) | =-F56*G41/100*(1/(1+G41/100)) | =-G56*H41/100*(1/(1+H41/100)) | =-H56*I41/100*(1/(1+I41/100)) | =-I56*J41/100*(1/(1+J41/100)) | =-J56*K41/100*(1/(1+K41/100)) | =-K56*L41/100*(1/(1+L41/100)) | =-L56*M41/100*(1/(1+M41/100)) | =-M56*N41/100*(1/(1+N41/100)) | =-N56*O41/100*(1/(1+O41/100)) | =-O56*P41/100*(1/(1+P41/100)) | =-P56*Q41/100*(1/(1+Q41/100)) | =-Q56*R41/100*(1/(1+R41/100)) | =-R56*S41/100*(1/(1+S41/100)) | =-S56*T41/100*(1/(1+T41/100)) | =-T56*U41/100*(1/(1+U41/100)) | =-U56*V41/100*(1/(1+V41/100)) | =-V56*W41/100*(1/(1+W41/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 | =+D71-D72 | =+E71-E72 | =+F71-F72 | =+G71-G72 | =+H71-H72 | =+I71-I72 | =+J71-J72 | =+K71-K72 | =+L71-L72 | =+M71-M72 | =+N71-N72 | =+O71-O72 | =+P71-P72 | =+Q71-Q72 | =+R71-R72 | =+S71-S72 | =+T71-T72 | =+U71-U72 | =+V71-V72 | =+W71-W72 |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
Debt increasing? (For criterion 1) =IF(K56<J56,0,1) =IF(L56<K56,0,1) =IF(M56<L56,0,1) =IF(N56<M56,0,1) =IF(O56<N56,0,1) =IF(P56<O56,0,1) =IF(Q56<P56,0,1) =IF(R56<Q56,0,1) =IF(S56<R56,0,1) =IF(T56<S56,0,1) =IF(U56<T56,0,1) =IF(V56<U56,0,1) =IF(W56<V56,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((E83-D83*E42/((1+E23/100)*(1+E41/100)))>0,1,0) | =IF((F83-E83*F42/((1+F23/100)*(1+F41/100)))>0,1,0) | =IF((G83-F83*G42/((1+G23/100)*(1+G41/100)))>0,1,0) | =IF((H83-G83*H42/((1+H23/100)*(1+H41/100)))>0,1,0) | =IF((I83-H83*I42/((1+I23/100)*(1+I41/100)))>0,1,0) | =IF((J83-I83*J42/((1+J23/100)*(1+J41/100)))>0,1,0) | =IF((K83-J83*K42/((1+K23/100)*(1+K41/100)))>0,1,0) | =IF((L83-K83*L42/((1+L23/100)*(1+L41/100)))>0,1,0) | =IF((M83-L83*M42/((1+M23/100)*(1+M41/100)))>0,1,0) | =IF((N83-M83*N42/((1+N23/100)*(1+N41/100)))>0,1,0) | =IF((O83-N83*O42/((1+O23/100)*(1+O41/100)))>0,1,0) | =IF((P83-O83*P42/((1+P23/100)*(1+P41/100)))>0,1,0) | =IF((Q83-P83*Q42/((1+Q23/100)*(1+Q41/100)))>0,1,0) | =IF((R83-Q83*R42/((1+R23/100)*(1+R41/100)))>0,1,0) | =IF((S83-R83*S42/((1+S23/100)*(1+S41/100)))>0,1,0) | =IF((T83-S83*T42/((1+T23/100)*(1+T41/100)))>0,1,0) | =IF((U83-T83*U42/((1+U23/100)*(1+U41/100)))>0,1,0) | =IF((V83-U83*V42/((1+V23/100)*(1+V41/100)))>0,1,0) | =IF((W83-V83*W42/((1+W23/100)*(1+W41/100)))>0,1,0) | ||||||||||||||||||||||||||||||||||
| Auxiliary variable identifying whether some debt is rolled over even though debt is decreasing | =IF(AND(E79=0,ABS(E83-D83*E42/((1+E23/100)*(1+E41/100)))<((D89*D83*E42/((1+E23/100)*(1+E41/100))+(E38*D83*D90*E42/((1+E23/100)*(1+E41/100)))))),1,0) | =IF(AND(F79=0,ABS(F83-E83*F42/((1+F23/100)*(1+F41/100)))<((E89*E83*F42/((1+F23/100)*(1+F41/100))+(F38*E83*E90*F42/((1+F23/100)*(1+F41/100)))))),1,0) | =IF(AND(G79=0,ABS(G83-F83*G42/((1+G23/100)*(1+G41/100)))<((F89*F83*G42/((1+G23/100)*(1+G41/100))+(G38*F83*F90*G42/((1+G23/100)*(1+G41/100)))))),1,0) | =IF(AND(H79=0,ABS(H83-G83*H42/((1+H23/100)*(1+H41/100)))<((G89*G83*H42/((1+H23/100)*(1+H41/100))+(H38*G83*G90*H42/((1+H23/100)*(1+H41/100)))))),1,0) | =IF(AND(I79=0,ABS(I83-H83*I42/((1+I23/100)*(1+I41/100)))<((H89*H83*I42/((1+I23/100)*(1+I41/100))+(I38*H83*H90*I42/((1+I23/100)*(1+I41/100)))))),1,0) | =IF(AND(J79=0,ABS(J83-I83*J42/((1+J23/100)*(1+J41/100)))<((I89*I83*J42/((1+J23/100)*(1+J41/100))+(J38*I83*I90*J42/((1+J23/100)*(1+J41/100)))))),1,0) | =IF(AND(K79=0,ABS(K83-J83*K42/((1+K23/100)*(1+K41/100)))<((J89*J83*K42/((1+K23/100)*(1+K41/100))+(K38*J83*J90*K42/((1+K23/100)*(1+K41/100)))))),1,0) | =IF(AND(L79=0,ABS(L83-K83*L42/((1+L23/100)*(1+L41/100)))<((K89*K83*L42/((1+L23/100)*(1+L41/100))+(L38*K83*K90*L42/((1+L23/100)*(1+L41/100)))))),1,0) | =IF(AND(M79=0,ABS(M83-L83*M42/((1+M23/100)*(1+M41/100)))<((L89*L83*M42/((1+M23/100)*(1+M41/100))+(M38*L83*L90*M42/((1+M23/100)*(1+M41/100)))))),1,0) | =IF(AND(N79=0,ABS(N83-M83*N42/((1+N23/100)*(1+N41/100)))<((M89*M83*N42/((1+N23/100)*(1+N41/100))+(N38*M83*M90*N42/((1+N23/100)*(1+N41/100)))))),1,0) | =IF(AND(O79=0,ABS(O83-N83*O42/((1+O23/100)*(1+O41/100)))<((N89*N83*O42/((1+O23/100)*(1+O41/100))+(O38*N83*N90*O42/((1+O23/100)*(1+O41/100)))))),1,0) | =IF(AND(P79=0,ABS(P83-O83*P42/((1+P23/100)*(1+P41/100)))<((O89*O83*P42/((1+P23/100)*(1+P41/100))+(P38*O83*O90*P42/((1+P23/100)*(1+P41/100)))))),1,0) | =IF(AND(Q79=0,ABS(Q83-P83*Q42/((1+Q23/100)*(1+Q41/100)))<((P89*P83*Q42/((1+Q23/100)*(1+Q41/100))+(Q38*P83*P90*Q42/((1+Q23/100)*(1+Q41/100)))))),1,0) | =IF(AND(R79=0,ABS(R83-Q83*R42/((1+R23/100)*(1+R41/100)))<((Q89*Q83*R42/((1+R23/100)*(1+R41/100))+(R38*Q83*Q90*R42/((1+R23/100)*(1+R41/100)))))),1,0) | =IF(AND(S79=0,ABS(S83-R83*S42/((1+S23/100)*(1+S41/100)))<((R89*R83*S42/((1+S23/100)*(1+S41/100))+(S38*R83*R90*S42/((1+S23/100)*(1+S41/100)))))),1,0) | =IF(AND(T79=0,ABS(T83-S83*T42/((1+T23/100)*(1+T41/100)))<((S89*S83*T42/((1+T23/100)*(1+T41/100))+(T38*S83*S90*T42/((1+T23/100)*(1+T41/100)))))),1,0) | =IF(AND(U79=0,ABS(U83-T83*U42/((1+U23/100)*(1+U41/100)))<((T89*T83*U42/((1+U23/100)*(1+U41/100))+(U38*T83*T90*U42/((1+U23/100)*(1+U41/100)))))),1,0) | =IF(AND(V79=0,ABS(V83-U83*V42/((1+V23/100)*(1+V41/100)))<((U89*U83*V42/((1+V23/100)*(1+V41/100))+(V38*U83*U90*V42/((1+V23/100)*(1+V41/100)))))),1,0) | =IF(AND(W79=0,ABS(W83-V83*W42/((1+W23/100)*(1+W41/100)))<((V89*V83*W42/((1+W23/100)*(1+W41/100))+(W38*V83*V90*W42/((1+W23/100)*(1+W41/100)))))),1,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