Program de
guvernare
Documentul original ↗
Proiect editorial 2026-2028Propuneri, date și condiții de implementare, cu stadiul verificării la vedere.

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																															
Download
Coloana 1Coloana 2Coloana 3Coloana 4Coloana 5Coloana 6Coloana 7Coloana 8Coloana 9Coloana 10Coloana 11Coloana 12Coloana 13Coloana 14Coloana 15Coloana 16Coloana 17Coloana 18Coloana 19Coloana 20Coloana 21Coloana 22Coloana 23Coloana 24Coloana 25Coloana 26Coloana 27Coloana 28Coloana 29Coloana 30Coloana 31Coloana 32Coloana 33Coloana 34Coloana 35Coloana 36Coloana 37Coloana 38Coloana 39Coloana 40Coloana 41Coloana 42Coloana 43Coloana 44Coloana 45Coloana 46Coloana 47Coloana 48Coloana 49Coloana 50Coloana 51Coloana 52Coloana 53Coloana 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)																																																				
Download
Coloana 1Coloana 2Coloana 3Coloana 4Coloana 5Coloana 6Coloana 7Coloana 8Coloana 9Coloana 10Coloana 11Coloana 12Coloana 13Coloana 14Coloana 15Coloana 16Coloana 17Coloana 18Coloana 19Coloana 20Coloana 21Coloana 22Coloana 23Coloana 24Coloana 25Coloana 26Coloana 27Coloana 28Coloana 29Coloana 30Coloana 31Coloana 32Coloana 33Coloana 34Coloana 35Coloana 36Coloana 37Coloana 38Coloana 39Coloana 40Coloana 41Coloana 42Coloana 43Coloana 44Coloana 45Coloana 46Coloana 47Coloana 48Coloana 49Coloana 50Coloana 51Coloana 52Coloana 53Coloana 54
Fiscal multiplier='Input data'!C49
Budget balance semi-elasticity='Input data'!C50

Coloanele sunt separate în sursă; anteturile nu sunt confirmate.

Download
Coloana 1Coloana 2Coloana 3Coloana 4Coloana 5Coloana 6Coloana 7Coloana 8Coloana 9Coloana 10Coloana 11Coloana 12Coloana 13Coloana 14Coloana 15Coloana 16Coloana 17Coloana 18Coloana 19Coloana 20Coloana 21Coloana 22Coloana 23Coloana 24Coloana 25Coloana 26Coloana 27Coloana 28Coloana 29Coloana 30Coloana 31Coloana 32Coloana 33Coloana 34Coloana 35Coloana 36Coloana 37Coloana 38Coloana 39Coloana 40Coloana 41Coloana 42Coloana 43Coloana 44Coloana 45Coloana 46Coloana 47Coloana 48Coloana 49Coloana 50Coloana 51Coloana 52Coloana 53Coloana 54
Auxiliary variable to control the closure of the output gap0=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 value0=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																																																				
Download
Coloana 1Coloana 2Coloana 3Coloana 4Coloana 5Coloana 6Coloana 7Coloana 8Coloana 9Coloana 10Coloana 11Coloana 12Coloana 13Coloana 14Coloana 15Coloana 16Coloana 17Coloana 18Coloana 19Coloana 20Coloana 21Coloana 22Coloana 23Coloana 24Coloana 25Coloana 26Coloana 27Coloana 28Coloana 29Coloana 30Coloana 31Coloana 32Coloana 33Coloana 34Coloana 35Coloana 36Coloana 37Coloana 38Coloana 39Coloana 40Coloana 41Coloana 42Coloana 43Coloana 44Coloana 45Coloana 46Coloana 47Coloana 48Coloana 49Coloana 50Coloana 51Coloana 52Coloana 53Coloana 54
202120222023202420252026202720282029203020312032203320342035203620372038203920402041
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)00000000000000000000
(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) Revenues00000000000000000000
(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																																																				
Download
Coloana 1Coloana 2Coloana 3Coloana 4Coloana 5Coloana 6Coloana 7Coloana 8Coloana 9Coloana 10Coloana 11Coloana 12Coloana 13Coloana 14Coloana 15Coloana 16Coloana 17Coloana 18Coloana 19Coloana 20Coloana 21Coloana 22Coloana 23Coloana 24Coloana 25Coloana 26Coloana 27Coloana 28Coloana 29Coloana 30Coloana 31Coloana 32Coloana 33Coloana 34Coloana 35Coloana 36Coloana 37Coloana 38Coloana 39Coloana 40Coloana 41Coloana 42Coloana 43Coloana 44Coloana 45Coloana 46Coloana 47Coloana 48Coloana 49Coloana 50Coloana 51Coloana 52Coloana 53Coloana 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.

Download
Coloana 1Coloana 2Coloana 3Coloana 4Coloana 5Coloana 6Coloana 7Coloana 8Coloana 9Coloana 10Coloana 11Coloana 12Coloana 13Coloana 14Coloana 15Coloana 16Coloana 17Coloana 18Coloana 19Coloana 20Coloana 21Coloana 22Coloana 23Coloana 24Coloana 25Coloana 26Coloana 27Coloana 28Coloana 29Coloana 30Coloana 31Coloana 32Coloana 33Coloana 34Coloana 35Coloana 36Coloana 37Coloana 38Coloana 39Coloana 40Coloana 41Coloana 42Coloana 43Coloana 44Coloana 45Coloana 46Coloana 47Coloana 48Coloana 49Coloana 50Coloana 51Coloana 52Coloana 53Coloana 54
202120222023202420252026202720282029203020312032203320342035203620372038203920402041
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