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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Rolled over short-term debt | ='Input data'!C68*$D$87 | =IF(E87=0,0,IF(E83=1,(1-D94)*D87*E42/((1+E23/100)*(1+E41/100)),IF(AND(E83=0,E84=1),(D93*D87*E42/((1+E23/100)*(1+E41/100)))*(1-ABS(E87-D87*E42/((1+E23/100)*(1+E41/100)))/((E38*D87*D94*E42/((1+E23/100)*(1+E41/100)))+(D93*D87*E42/((1+E23/100)*(1+E41/100))))),0))) | =IF(F87=0,0,IF(F83=1,(1-E94)*E87*F42/((1+F23/100)*(1+F41/100)),IF(AND(F83=0,F84=1),(E93*E87*F42/((1+F23/100)*(1+F41/100)))*(1-ABS(F87-E87*F42/((1+F23/100)*(1+F41/100)))/((F38*E87*E94*F42/((1+F23/100)*(1+F41/100)))+(E93*E87*F42/((1+F23/100)*(1+F41/100))))),0))) | =IF(G87=0,0,IF(G83=1,(1-F94)*F87*G42/((1+G23/100)*(1+G41/100)),IF(AND(G83=0,G84=1),(F93*F87*G42/((1+G23/100)*(1+G41/100)))*(1-ABS(G87-F87*G42/((1+G23/100)*(1+G41/100)))/((G38*F87*F94*G42/((1+G23/100)*(1+G41/100)))+(F93*F87*G42/((1+G23/100)*(1+G41/100))))),0))) | =IF(H87=0,0,IF(H83=1,(1-G94)*G87*H42/((1+H23/100)*(1+H41/100)),IF(AND(H83=0,H84=1),(G93*G87*H42/((1+H23/100)*(1+H41/100)))*(1-ABS(H87-G87*H42/((1+H23/100)*(1+H41/100)))/((H38*G87*G94*H42/((1+H23/100)*(1+H41/100)))+(G93*G87*H42/((1+H23/100)*(1+H41/100))))),0))) | =IF(I87=0,0,IF(I83=1,(1-H94)*H87*I42/((1+I23/100)*(1+I41/100)),IF(AND(I83=0,I84=1),(H93*H87*I42/((1+I23/100)*(1+I41/100)))*(1-ABS(I87-H87*I42/((1+I23/100)*(1+I41/100)))/((I38*H87*H94*I42/((1+I23/100)*(1+I41/100)))+(H93*H87*I42/((1+I23/100)*(1+I41/100))))),0))) | =IF(J87=0,0,IF(J83=1,(1-I94)*I87*J42/((1+J23/100)*(1+J41/100)),IF(AND(J83=0,J84=1),(I93*I87*J42/((1+J23/100)*(1+J41/100)))*(1-ABS(J87-I87*J42/((1+J23/100)*(1+J41/100)))/((J38*I87*I94*J42/((1+J23/100)*(1+J41/100)))+(I93*I87*J42/((1+J23/100)*(1+J41/100))))),0))) | =IF(K87=0,0,IF(K83=1,(1-J94)*J87*K42/((1+K23/100)*(1+K41/100)),IF(AND(K83=0,K84=1),(J93*J87*K42/((1+K23/100)*(1+K41/100)))*(1-ABS(K87-J87*K42/((1+K23/100)*(1+K41/100)))/((K38*J87*J94*K42/((1+K23/100)*(1+K41/100)))+(J93*J87*K42/((1+K23/100)*(1+K41/100))))),0))) | =IF(L87=0,0,IF(L83=1,(1-K94)*K87*L42/((1+L23/100)*(1+L41/100)),IF(AND(L83=0,L84=1),(K93*K87*L42/((1+L23/100)*(1+L41/100)))*(1-ABS(L87-K87*L42/((1+L23/100)*(1+L41/100)))/((L38*K87*K94*L42/((1+L23/100)*(1+L41/100)))+(K93*K87*L42/((1+L23/100)*(1+L41/100))))),0))) | =IF(M87=0,0,IF(M83=1,(1-L94)*L87*M42/((1+M23/100)*(1+M41/100)),IF(AND(M83=0,M84=1),(L93*L87*M42/((1+M23/100)*(1+M41/100)))*(1-ABS(M87-L87*M42/((1+M23/100)*(1+M41/100)))/((M38*L87*L94*M42/((1+M23/100)*(1+M41/100)))+(L93*L87*M42/((1+M23/100)*(1+M41/100))))),0))) | =IF(N87=0,0,IF(N83=1,(1-M94)*M87*N42/((1+N23/100)*(1+N41/100)),IF(AND(N83=0,N84=1),(M93*M87*N42/((1+N23/100)*(1+N41/100)))*(1-ABS(N87-M87*N42/((1+N23/100)*(1+N41/100)))/((N38*M87*M94*N42/((1+N23/100)*(1+N41/100)))+(M93*M87*N42/((1+N23/100)*(1+N41/100))))),0))) | =IF(O87=0,0,IF(O83=1,(1-N94)*N87*O42/((1+O23/100)*(1+O41/100)),IF(AND(O83=0,O84=1),(N93*N87*O42/((1+O23/100)*(1+O41/100)))*(1-ABS(O87-N87*O42/((1+O23/100)*(1+O41/100)))/((O38*N87*N94*O42/((1+O23/100)*(1+O41/100)))+(N93*N87*O42/((1+O23/100)*(1+O41/100))))),0))) | =IF(P87=0,0,IF(P83=1,(1-O94)*O87*P42/((1+P23/100)*(1+P41/100)),IF(AND(P83=0,P84=1),(O93*O87*P42/((1+P23/100)*(1+P41/100)))*(1-ABS(P87-O87*P42/((1+P23/100)*(1+P41/100)))/((P38*O87*O94*P42/((1+P23/100)*(1+P41/100)))+(O93*O87*P42/((1+P23/100)*(1+P41/100))))),0))) | =IF(Q87=0,0,IF(Q83=1,(1-P94)*P87*Q42/((1+Q23/100)*(1+Q41/100)),IF(AND(Q83=0,Q84=1),(P93*P87*Q42/((1+Q23/100)*(1+Q41/100)))*(1-ABS(Q87-P87*Q42/((1+Q23/100)*(1+Q41/100)))/((Q38*P87*P94*Q42/((1+Q23/100)*(1+Q41/100)))+(P93*P87*Q42/((1+Q23/100)*(1+Q41/100))))),0))) | =IF(R87=0,0,IF(R83=1,(1-Q94)*Q87*R42/((1+R23/100)*(1+R41/100)),IF(AND(R83=0,R84=1),(Q93*Q87*R42/((1+R23/100)*(1+R41/100)))*(1-ABS(R87-Q87*R42/((1+R23/100)*(1+R41/100)))/((R38*Q87*Q94*R42/((1+R23/100)*(1+R41/100)))+(Q93*Q87*R42/((1+R23/100)*(1+R41/100))))),0))) | =IF(S87=0,0,IF(S83=1,(1-R94)*R87*S42/((1+S23/100)*(1+S41/100)),IF(AND(S83=0,S84=1),(R93*R87*S42/((1+S23/100)*(1+S41/100)))*(1-ABS(S87-R87*S42/((1+S23/100)*(1+S41/100)))/((S38*R87*R94*S42/((1+S23/100)*(1+S41/100)))+(R93*R87*S42/((1+S23/100)*(1+S41/100))))),0))) | =IF(T87=0,0,IF(T83=1,(1-S94)*S87*T42/((1+T23/100)*(1+T41/100)),IF(AND(T83=0,T84=1),(S93*S87*T42/((1+T23/100)*(1+T41/100)))*(1-ABS(T87-S87*T42/((1+T23/100)*(1+T41/100)))/((T38*S87*S94*T42/((1+T23/100)*(1+T41/100)))+(S93*S87*T42/((1+T23/100)*(1+T41/100))))),0))) | =IF(U87=0,0,IF(U83=1,(1-T94)*T87*U42/((1+U23/100)*(1+U41/100)),IF(AND(U83=0,U84=1),(T93*T87*U42/((1+U23/100)*(1+U41/100)))*(1-ABS(U87-T87*U42/((1+U23/100)*(1+U41/100)))/((U38*T87*T94*U42/((1+U23/100)*(1+U41/100)))+(T93*T87*U42/((1+U23/100)*(1+U41/100))))),0))) | =IF(V87=0,0,IF(V83=1,(1-U94)*U87*V42/((1+V23/100)*(1+V41/100)),IF(AND(V83=0,V84=1),(U93*U87*V42/((1+V23/100)*(1+V41/100)))*(1-ABS(V87-U87*V42/((1+V23/100)*(1+V41/100)))/((V38*U87*U94*V42/((1+V23/100)*(1+V41/100)))+(U93*U87*V42/((1+V23/100)*(1+V41/100))))),0))) | =IF(W87=0,0,IF(W83=1,(1-V94)*V87*W42/((1+W23/100)*(1+W41/100)),IF(AND(W83=0,W84=1),(V93*V87*W42/((1+W23/100)*(1+W41/100)))*(1-ABS(W87-V87*W42/((1+W23/100)*(1+W41/100)))/((W38*V87*V94*W42/((1+W23/100)*(1+W41/100)))+(V93*V87*W42/((1+W23/100)*(1+W41/100))))),0))) | ||||||||||||||||||||||||||||||
| New long-term debt | ='Input data'!C69*$D$87 | =IF(E87=0,0,IF(E83=1,'Input data'!$C$58*(E87-D87*E42/((1+E23/100)*(1+E41/100))),0)) | =IF(F87=0,0,IF(F83=1,'Input data'!$C$58*(F87-E87*F42/((1+F23/100)*(1+F41/100))),0)) | =IF(G87=0,0,IF(G83=1,'Input data'!$C$58*(G87-F87*G42/((1+G23/100)*(1+G41/100))),0)) | =IF(H87=0,0,IF(H83=1,'Input data'!$C$58*(H87-G87*H42/((1+H23/100)*(1+H41/100))),0)) | =IF(I87=0,0,IF(I83=1,'Input data'!$C$58*(I87-H87*I42/((1+I23/100)*(1+I41/100))),0)) | =IF(J87=0,0,IF(J83=1,'Input data'!$C$58*(J87-I87*J42/((1+J23/100)*(1+J41/100))),0)) | =IF(K87=0,0,IF(K83=1,'Input data'!$C$58*(K87-J87*K42/((1+K23/100)*(1+K41/100))),0)) | =IF(L87=0,0,IF(L83=1,'Input data'!$C$58*(L87-K87*L42/((1+L23/100)*(1+L41/100))),0)) | =IF(M87=0,0,IF(M83=1,'Input data'!$C$58*(M87-L87*M42/((1+M23/100)*(1+M41/100))),0)) | =IF(N87=0,0,IF(N83=1,'Input data'!$C$58*(N87-M87*N42/((1+N23/100)*(1+N41/100))),0)) | =IF(O87=0,0,IF(O83=1,'Input data'!$C$58*(O87-N87*O42/((1+O23/100)*(1+O41/100))),0)) | =IF(P87=0,0,IF(P83=1,'Input data'!$C$58*(P87-O87*P42/((1+P23/100)*(1+P41/100))),0)) | =IF(Q87=0,0,IF(Q83=1,'Input data'!$C$58*(Q87-P87*Q42/((1+Q23/100)*(1+Q41/100))),0)) | =IF(R87=0,0,IF(R83=1,'Input data'!$C$58*(R87-Q87*R42/((1+R23/100)*(1+R41/100))),0)) | =IF(S87=0,0,IF(S83=1,'Input data'!$C$58*(S87-R87*S42/((1+S23/100)*(1+S41/100))),0)) | =IF(T87=0,0,IF(T83=1,'Input data'!$C$58*(T87-S87*T42/((1+T23/100)*(1+T41/100))),0)) | =IF(U87=0,0,IF(U83=1,'Input data'!$C$58*(U87-T87*U42/((1+U23/100)*(1+U41/100))),0)) | =IF(V87=0,0,IF(V83=1,'Input data'!$C$58*(V87-U87*V42/((1+V23/100)*(1+V41/100))),0)) | =IF(W87=0,0,IF(W83=1,'Input data'!$C$58*(W87-V87*W42/((1+W23/100)*(1+W41/100))),0)) | ||||||||||||||||||||||||||||||
| New short-term debt | ='Input data'!C70*$D$87 | =IF(E87=0,0,IF(E83=1,'Input data'!$C$57*(E87-D87*E42/((1+E23/100)*(1+E41/100))),0)) | =IF(F87=0,0,IF(F83=1,'Input data'!$C$57*(F87-E87*F42/((1+F23/100)*(1+F41/100))),0)) | =IF(G87=0,0,IF(G83=1,'Input data'!$C$57*(G87-F87*G42/((1+G23/100)*(1+G41/100))),0)) | =IF(H87=0,0,IF(H83=1,'Input data'!$C$57*(H87-G87*H42/((1+H23/100)*(1+H41/100))),0)) | =IF(I87=0,0,IF(I83=1,'Input data'!$C$57*(I87-H87*I42/((1+I23/100)*(1+I41/100))),0)) | =IF(J87=0,0,IF(J83=1,'Input data'!$C$57*(J87-I87*J42/((1+J23/100)*(1+J41/100))),0)) | =IF(K87=0,0,IF(K83=1,'Input data'!$C$57*(K87-J87*K42/((1+K23/100)*(1+K41/100))),0)) | =IF(L87=0,0,IF(L83=1,'Input data'!$C$57*(L87-K87*L42/((1+L23/100)*(1+L41/100))),0)) | =IF(M87=0,0,IF(M83=1,'Input data'!$C$57*(M87-L87*M42/((1+M23/100)*(1+M41/100))),0)) | =IF(N87=0,0,IF(N83=1,'Input data'!$C$57*(N87-M87*N42/((1+N23/100)*(1+N41/100))),0)) | =IF(O87=0,0,IF(O83=1,'Input data'!$C$57*(O87-N87*O42/((1+O23/100)*(1+O41/100))),0)) | =IF(P87=0,0,IF(P83=1,'Input data'!$C$57*(P87-O87*P42/((1+P23/100)*(1+P41/100))),0)) | =IF(Q87=0,0,IF(Q83=1,'Input data'!$C$57*(Q87-P87*Q42/((1+Q23/100)*(1+Q41/100))),0)) | =IF(R87=0,0,IF(R83=1,'Input data'!$C$57*(R87-Q87*R42/((1+R23/100)*(1+R41/100))),0)) | =IF(S87=0,0,IF(S83=1,'Input data'!$C$57*(S87-R87*S42/((1+S23/100)*(1+S41/100))),0)) | =IF(T87=0,0,IF(T83=1,'Input data'!$C$57*(T87-S87*T42/((1+T23/100)*(1+T41/100))),0)) | =IF(U87=0,0,IF(U83=1,'Input data'!$C$57*(U87-T87*U42/((1+U23/100)*(1+U41/100))),0)) | =IF(V87=0,0,IF(V83=1,'Input data'!$C$57*(V87-U87*V42/((1+V23/100)*(1+V41/100))),0)) | =IF(W87=0,0,IF(W83=1,'Input data'!$C$57*(W87-V87*W42/((1+W23/100)*(1+W41/100))),0)) | ||||||||||||||||||||||||||||||
| Share of short-term debt in total government debt | =1-D94 | =IF(E87<>0,(E90+E92)/(E88+E89+E90+E91+E92),0) | =IF(F87<>0,(F90+F92)/(F88+F89+F90+F91+F92),0) | =IF(G87<>0,(G90+G92)/(G88+G89+G90+G91+G92),0) | =IF(H87<>0,(H90+H92)/(H88+H89+H90+H91+H92),0) | =IF(I87<>0,(I90+I92)/(I88+I89+I90+I91+I92),0) | =IF(J87<>0,(J90+J92)/(J88+J89+J90+J91+J92),0) | =IF(K87<>0,(K90+K92)/(K88+K89+K90+K91+K92),0) | =IF(L87<>0,(L90+L92)/(L88+L89+L90+L91+L92),0) | =IF(M87<>0,(M90+M92)/(M88+M89+M90+M91+M92),0) | =IF(N87<>0,(N90+N92)/(N88+N89+N90+N91+N92),0) | =IF(O87<>0,(O90+O92)/(O88+O89+O90+O91+O92),0) | =IF(P87<>0,(P90+P92)/(P88+P89+P90+P91+P92),0) | =IF(Q87<>0,(Q90+Q92)/(Q88+Q89+Q90+Q91+Q92),0) | =IF(R87<>0,(R90+R92)/(R88+R89+R90+R91+R92),0) | =IF(S87<>0,(S90+S92)/(S88+S89+S90+S91+S92),0) | =IF(T87<>0,(T90+T92)/(T88+T89+T90+T91+T92),0) | =IF(U87<>0,(U90+U92)/(U88+U89+U90+U91+U92),0) | =IF(V87<>0,(V90+V92)/(V88+V89+V90+V91+V92),0) | =IF(W87<>0,(W90+W92)/(W88+W89+W90+W91+W92),0) | ||||||||||||||||||||||||||||||
| Share of long-term debt in total government debt | =(D88+D89+D91)/D87 | =IF(E87<>0,(E88+E89+E91)/(E88+E89+E90+E91+E92),1) | =IF(F87<>0,(F88+F89+F91)/(F88+F89+F90+F91+F92),1) | =IF(G87<>0,(G88+G89+G91)/(G88+G89+G90+G91+G92),1) | =IF(H87<>0,(H88+H89+H91)/(H88+H89+H90+H91+H92),1) | =IF(I87<>0,(I88+I89+I91)/(I88+I89+I90+I91+I92),1) | =IF(J87<>0,(J88+J89+J91)/(J88+J89+J90+J91+J92),1) | =IF(K87<>0,(K88+K89+K91)/(K88+K89+K90+K91+K92),1) | =IF(L87<>0,(L88+L89+L91)/(L88+L89+L90+L91+L92),1) | =IF(M87<>0,(M88+M89+M91)/(M88+M89+M90+M91+M92),1) | =IF(N87<>0,(N88+N89+N91)/(N88+N89+N90+N91+N92),1) | =IF(O87<>0,(O88+O89+O91)/(O88+O89+O90+O91+O92),1) | =IF(P87<>0,(P88+P89+P91)/(P88+P89+P90+P91+P92),1) | =IF(Q87<>0,(Q88+Q89+Q91)/(Q88+Q89+Q90+Q91+Q92),1) | =IF(R87<>0,(R88+R89+R91)/(R88+R89+R90+R91+R92),1) | =IF(S87<>0,(S88+S89+S91)/(S88+S89+S90+S91+S92),1) | =IF(T87<>0,(T88+T89+T91)/(T88+T89+T90+T91+T92),1) | =IF(U87<>0,(U88+U89+U91)/(U88+U89+U90+U91+U92),1) | =IF(V87<>0,(V88+V89+V91)/(V88+V89+V90+V91+V92),1) | =IF(W87<>0,(W88+W89+W91)/(W88+W89+W90+W91+W92),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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IIR | =C35 | =D35 | =E98+E99 | =F98+F99 | =G98+G99 | =H98+H99 | =I98+I99 | =J98+J99 | =K98+K99 | =L98+L99 | =M98+M99 | =N98+N99 | =O98+O99 | =P98+P99 | =Q98+Q99 | =R98+R99 | =S98+S99 | =T98+T99 | =U98+U99 | =V98+V99 | =W98+W99 | |||||||||||||||||||||||||||||
| Long-term implicit interest rate | =((E35*D87)-(E37*D90+D92))/(D88+D89+D91) | =((F35*E87)-(F37*E90+E92))/(E88+E89+E91) | =((G35*F87)-(G37*F90+F92))/(F88+F89+F91) | =IF(G87>0,(G97*G88+H36*(G91+G89))/(G88+G89+G91),H36) | =IF(H87>0,(H97*H88+I36*(H91+H89))/(H88+H89+H91),I36) | =IF(I87>0,(I97*I88+J36*(I91+I89))/(I88+I89+I91),J36) | =IF(J87>0,(J97*J88+K36*(J91+J89))/(J88+J89+J91),K36) | =IF(K87>0,(K97*K88+L36*(K91+K89))/(K88+K89+K91),L36) | =IF(L87>0,(L97*L88+M36*(L91+L89))/(L88+L89+L91),M36) | =IF(M87>0,(M97*M88+N36*(M91+M89))/(M88+M89+M91),N36) | =IF(N87>0,(N97*N88+O36*(N91+N89))/(N88+N89+N91),O36) | =IF(O87>0,(O97*O88+P36*(O91+O89))/(O88+O89+O91),P36) | =IF(P87>0,(P97*P88+Q36*(P91+P89))/(P88+P89+P91),Q36) | =IF(Q87>0,(Q97*Q88+R36*(Q91+Q89))/(Q88+Q89+Q91),R36) | =IF(R87>0,(R97*R88+S36*(R91+R89))/(R88+R89+R91),S36) | =IF(S87>0,(S97*S88+T36*(S91+S89))/(S88+S89+S91),T36) | =IF(T87>0,(T97*T88+U36*(T91+T89))/(T88+T89+T91),U36) | =IF(U87>0,(U97*U88+V36*(U91+U89))/(U88+U89+U91),V36) | =IF(V87>0,(V97*V88+W36*(V91+V89))/(V88+V89+V91),W36) | |||||||||||||||||||||||||||||||
| Nominal implicit interest rate on debt (Excel approximation) | =E35 | =F35 | =G35 | =(H97*(G88+G89+G91)+H37*(G90+G92))/G87 | =(I97*(H88+H89+H91)+I37*(H90+H92))/H87 | =(J97*(I88+I89+I91)+J37*(I90+I92))/I87 | =(K97*(J88+J89+J91)+K37*(J90+J92))/J87 | =(L97*(K88+K89+K91)+L37*(K90+K92))/K87 | =(M97*(L88+L89+L91)+M37*(L90+L92))/L87 | =(N97*(M88+M89+M91)+N37*(M90+M92))/M87 | =(O97*(N88+N89+N91)+O37*(N90+N92))/N87 | =(P97*(O88+O89+O91)+P37*(O90+O92))/O87 | =(Q97*(P88+P89+P91)+Q37*(P90+P92))/P87 | =(R97*(Q88+Q89+Q91)+R37*(Q90+Q92))/Q87 | =(S97*(R88+R89+R91)+S37*(R90+R92))/R87 | =(T97*(S88+S89+S91)+T37*(S90+S92))/S87 | =(U97*(T88+T89+T91)+U37*(T90+T92))/T87 | =(V97*(U88+U89+U91)+V37*(U90+U92))/U87 | =(W97*(V88+V89+V91)+W37*(V90+V92))/V87 | |||||||||||||||||||||||||||||||
| Diff. STATA | =E108 | =F108 | =G108 | =H108 | =I108 | =J108 | =K108 | =L108 | =M108 | =N108 | =O108 | =P108 | =Q108 | =R108 | =S108 | =T108 | =U108 | =V108 | =W108 |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
(i - g) =((1+C96/100)/((1+C23/100)*(1+C41/100))-1)*100 =((1+D96/100)/((1+D23/100)*(1+D41/100))-1)*100 =((1+E96/100)/((1+E23/100)*(1+E41/100))-1)*100 =((1+F96/100)/((1+F23/100)*(1+F41/100))-1)*100 =((1+G96/100)/((1+G23/100)*(1+G41/100))-1)*100 =((1+H96/100)/((1+H23/100)*(1+H41/100))-1)*100 =((1+I96/100)/((1+I23/100)*(1+I41/100))-1)*100 =((1+J96/100)/((1+J23/100)*(1+J41/100))-1)*100 =((1+K96/100)/((1+K23/100)*(1+K41/100))-1)*100 =((1+L96/100)/((1+L23/100)*(1+L41/100))-1)*100 =((1+M96/100)/((1+M23/100)*(1+M41/100))-1)*100 =((1+N96/100)/((1+N23/100)*(1+N41/100))-1)*100 =((1+O96/100)/((1+O23/100)*(1+O41/100))-1)*100 =((1+P96/100)/((1+P23/100)*(1+P41/100))-1)*100 =((1+Q96/100)/((1+Q23/100)*(1+Q41/100))-1)*100 =((1+R96/100)/((1+R23/100)*(1+R41/100))-1)*100 =((1+S96/100)/((1+S23/100)*(1+S41/100))-1)*100 =((1+T96/100)/((1+T23/100)*(1+T41/100))-1)*100 =((1+U96/100)/((1+U23/100)*(1+U41/100))-1)*100 =((1+V96/100)/((1+V23/100)*(1+V41/100))-1)*100 =((1+W96/100)/((1+W23/100)*(1+W41/100))-1)*100
Per memo - STATA results
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Debt | 48.4689 | 47.48942 | 48.80021 | 50.91009 | 55.08279 | 59.39212 | 63.85165 | 68.7166 | 73.98103 | 79.44759 | 85.07632 | 90.84272 | 96.85401 | 103.131 | 109.6054 | 116.2131 | 123.0527 | 130.2083 | 137.7062 | 145.6082 | 153.7701 | |||||||||||||||||||||||||||||
| IIR | 3.469995 | 3.590007 | 4.826077 | 4.537611 | 4.180669 | 4.739128 | 5.173497 | 5.511672 | 5.775837 | 5.982463 | 6.143624 | 6.269081 | 6.366651 | 6.419635 | 6.436716 | 6.425914 | 6.393559 | 6.344418 | 6.282157 | 6.209555 | 6.128747 | |||||||||||||||||||||||||||||
| IIR difference STATA - Excel | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Share of long-term debt that matures every year | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | |||||||||||||||||||||||||||||
| CY | 0.03801916 | 0.07859744 | 0.05947547 | 0.09687696 | 0.11684023 | 0.13811532 | 0.13659083 | 0.14219136 | 0.1389396 | 0.12512538 | 0.1284918 | 0.07208514 | 0.06868139 | 0.0680495 | 0.06808078 | 0.06766632 | 0.06922052 | 0.06662979 | 0.06643431 | 0.06639338 | 0.06621254 | |||||||||||||||||||||||||||||
| EL | 0.03033705 | 0.03594311 | 0.04116618 | 0.01594102 | 0.01585014 | 0.03752878 | 0.03405028 | 0.04734439 | 0.04407593 | 0.0508599 | 0.06623794 | 0.06025377 | 0.09003059 | 0.07295239 | 0.07736666 | 0.09083936 | 0.0996211 | 0.10965455 | 0.09865441 | 0.10313576 | 0.11073873 | |||||||||||||||||||||||||||||
| IE | 0.001 | 0.07537306 | 0.04688205 | 0.05421672 | 0.06734311 | 0.07328111 | 0.06373561 | 0.07199902 | 0.07792014 | 0.07366593 | 0.09283323 | 0.09749916 | 0.10431984 | 0.07769295 | 0.08189674 | 0.07226059 | 0.07247516 | 0.07270425 | 0.07292216 | 0.07311259 | 0.07343585 | |||||||||||||||||||||||||||||
| PT | 0.08381841 | 0.06939163 | 0.04649241 | 0.04919325 | 0.05671274 | 0.06401188 | 0.0649313 | 0.06391246 | 0.06169361 | 0.05442604 | 0.08556656 | 0.08165381 | 0.07587859 | 0.06135627 | 0.08179735 | 0.08444232 | 0.06027019 | 0.07297076 | 0.05731596 | 0.06079668 | 0.05729366 |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
Adjustment scenario
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Country | ='Input data'!C3 | |||||||||||||||||||||||||||||||||||||||||||||||||
| Key years | ||||||||||||||||||||||||||||||||||||||||||||||||||
| ='Input data'!B5 | =+'Input data'!C5 | |||||||||||||||||||||||||||||||||||||||||||||||||
| Last year of adjustment | =+C5+'Criteria results'!$F$5 | |||||||||||||||||||||||||||||||||||||||||||||||||
| Last year of no-fiscal-policy-change projections | =C5+'Criteria results'!$F$5+10 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key assumptions | ||||||||||||||||||||||||||||||||||||||||||||||||||
| 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | ||||||||||||||||||||||||||||||
| Fiscal assumptions (% of GDP) |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
Structural primary balance ('+' means 'surplus') ='Input data'!C13 ='Input data'!D13 ='Input data'!E13 ='Input data'!F13 =IF(G10<=$C$6,
IF(AND(F87=1,F77<=-3.05,'Criteria results'!$F$6<0.5),F12+0.5, IF(AND(F78<=-1.55,'Criteria results'!$F$5=4,'Criteria results'!$F$6<0.4),F12+0.4, IF(AND(F78<=-1.55,'Criteria results'!$F$5=7,'Criteria results'!$F$6<0.25),F12+0.25,
F12+'Criteria results'!$F$6))),F12) =IF(H10<=$C$6,
IF(AND(G87=1,G77<=-3.05,'Criteria results'!$F$6<0.5),G12+0.5, IF(AND(G78<=-1.55,'Criteria results'!$F$5=4,'Criteria results'!$F$6<0.4),G12+0.4, IF(AND(G78<=-1.55,'Criteria results'!$F$5=7,'Criteria results'!$F$6<0.25),G12+0.25,
G12+'Criteria results'!$F$6))),G12) =IF(I10<=$C$6,
IF(AND(H87=1,H77<=-3.05,'Criteria results'!$F$6<0.5),H12+0.5, IF(AND(H78<=-1.55,'Criteria results'!$F$5=4,'Criteria results'!$F$6<0.4),H12+0.4, IF(AND(H78<=-1.55,'Criteria results'!$F$5=7,'Criteria results'!$F$6<0.25),H12+0.25,
H12+'Criteria results'!$F$6))),H12) =IF(J10<=$C$6,
IF(AND(I87=1,I77<=-3.05,'Criteria results'!$F$6<0.5+J91),I12+0.5+J91, IF(AND(I78<=-1.55,'Criteria results'!$F$5=4,'Criteria results'!$F$6<0.4),I12+0.4, IF(AND(I78<=-1.55,'Criteria results'!$F$5=7,'Criteria results'!$F$6<0.25),I12+0.25,
I12+'Criteria results'!$F$6))),I12) =IF(K10<=$C$6,
IF(AND(J87=1,J77<=-3.05,'Criteria results'!$F$6<0.5+K91),J12+0.5+K91, IF(AND(J78<=-1.55,'Criteria results'!$F$5=4,'Criteria results'!$F$6<0.4),J12+0.4, IF(AND(J78<=-1.55,'Criteria results'!$F$5=7,'Criteria results'!$F$6<0.25),J12+0.25,
J12+'Criteria results'!$F$6))),J12) =IF(L10<=$C$6,
IF(AND(K87=1,K77<=-3.05,'Criteria results'!$F$6<0.5+L91),K12+0.5+L91, IF(AND(K78<=-1.55,'Criteria results'!$F$5=4,'Criteria results'!$F$6<0.4),K12+0.4, IF(AND(K78<=-1.55,'Criteria results'!$F$5=7,'Criteria results'!$F$6<0.25),K12+0.25,
K12+'Criteria results'!$F$6))),K12) =IF(M10<=$C$6,
IF(AND(L87=1,L77<=-3.05,'Criteria results'!$F$6<0.5+M91),L12+0.5+M91, IF(AND(L78<=-1.55,'Criteria results'!$F$5=4,'Criteria results'!$F$6<0.4),L12+0.4, IF(AND(L78<=-1.55,'Criteria results'!$F$5=7,'Criteria results'!$F$6<0.25),L12+0.25,
L12+'Criteria results'!$F$6))),L12) =M12 =N12 =O12 =P12 =Q12 =R12 =S12 =T12 =U12 =V12
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Annual change in SPB | =G12-F12 | =H12-G12 | =I12-H12 | =J12-I12 | =K12-J12 | =L12-K12 | =M12-L12 | =N12-M12 | =O12-N12 | =P12-O12 | =Q12-P12 | =R12-Q12 | =S12-R12 | =T12-S12 | =U12-T12 | =V12-U12 | =W12-V12 | |||||||||||||||||||||||||||||||||
| One-off and other temporary measures | ='Input data'!C14 | ='Input data'!D14 | ='Input data'!E14 | ='Input data'!F14 | ='Input data'!G14 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | =0 | |||||||||||||||||||||||||||||
| Stock flow adjustments (without exchange rate effect) | ='Input data'!C15 | ='Input data'!D15 | ='Input data'!E15 | ='Input data'!F15 | ='Input data'!G15 | ='Input data'!H15 | ='Input data'!I15 | ='Input data'!J15 | ='Input data'!K15 | ='Input data'!L15 | ='Input data'!M15 | ='Input data'!N15 | ='Input data'!O15 | ='Input data'!P15 | ='Input data'!Q15 | ='Input data'!R15 | ='Input data'!S15 | ='Input data'!T15 | ='Input data'!U15 | ='Input data'!V15 | ='Input data'!W15 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ='Input data'!B19 | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Total ageing cost (net of taxes on pensions) | ='Input data'!C20 | ='Input data'!D20 | ='Input data'!E20 | ='Input data'!F20 | ='Input data'!G20 | ='Input data'!H20 | ='Input data'!I20 | ='Input data'!J20 | ='Input data'!K20 | ='Input data'!L20 | ='Input data'!M20 | ='Input data'!N20 | ='Input data'!O20 | ='Input data'!P20 | ='Input data'!Q20 | ='Input data'!R20 | ='Input data'!S20 | ='Input data'!T20 | ='Input data'!U20 | ='Input data'!V20 | ='Input data'!W20 | |||||||||||||||||||||||||||||
| Property income | ='Input data'!C26 | ='Input data'!D26 | ='Input data'!E26 | ='Input data'!F26 | ='Input data'!G26 | ='Input data'!H26 | ='Input data'!I26 | ='Input data'!J26 | ='Input data'!K26 | ='Input data'!L26 | ='Input data'!M26 | ='Input data'!N26 | ='Input data'!O26 | ='Input data'!P26 | ='Input data'!Q26 | ='Input data'!R26 | ='Input data'!S26 | ='Input data'!T26 | ='Input data'!U26 | ='Input data'!V26 | ='Input data'!W26 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GDP growth assumptions | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Actual GDP (real) | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Level | ='Input data'!C31 | ='Baseline NFPC'!D22 | ='Baseline NFPC'!E22 | ='Baseline NFPC'!F22 | =IF(AND(G50>1,F50>1),IF(AND(G50>0,F50>0),G27*(G51/100+1),0)+IF(G50>0,F23*(1+G52/100),0)-F23*(1+'Input data'!G30/100),IF(G50=1,G27,F23*(1+G52/100))) | =IF(AND(H50>1,G50>1),IF(AND(H50>0,G50>0),H27*(H51/100+1),0)+IF(H50>0,G23*(1+H52/100),0)-G23*(1+'Input data'!H30/100),IF(H50=1,H27,G23*(1+H52/100))) | =IF(AND(I50>1,H50>1),IF(AND(I50>0,H50>0),I27*(I51/100+1),0)+IF(I50>0,H23*(1+I52/100),0)-H23*(1+'Input data'!I30/100),IF(I50=1,I27,H23*(1+I52/100))) | =IF(AND(J50>1,I50>1),IF(AND(J50>0,I50>0),J27*(J51/100+1),0)+IF(J50>0,I23*(1+J52/100),0)-I23*(1+'Input data'!J30/100),IF(J50=1,J27,I23*(1+J52/100))) | =IF(AND(K50>1,J50>1),IF(AND(K50>0,J50>0),K27*(K51/100+1),0)+IF(K50>0,J23*(1+K52/100),0)-J23*(1+'Input data'!K30/100),IF(K50=1,K27,J23*(1+K52/100))) | =IF(AND(L50>1,K50>1),IF(AND(L50>0,K50>0),L27*(L51/100+1),0)+IF(L50>0,K23*(1+L52/100),0)-K23*(1+'Input data'!L30/100),IF(L50=1,L27,K23*(1+L52/100))) | =IF(AND(M50>1,L50>1),IF(AND(M50>0,L50>0),M27*(M51/100+1),0)+IF(M50>0,L23*(1+M52/100),0)-L23*(1+'Input data'!M30/100),IF(M50=1,M27,L23*(1+M52/100))) | =IF(AND(N50>1,M50>1),IF(AND(N50>0,M50>0),N27*(N51/100+1),0)+IF(N50>0,M23*(1+N52/100),0)-M23*(1+'Input data'!N30/100),IF(N50=1,N27,M23*(1+N52/100))) | =IF(AND(O50>1,N50>1),IF(AND(O50>0,N50>0),O27*(O51/100+1),0)+IF(O50>0,N23*(1+O52/100),0)-N23*(1+'Input data'!O30/100),IF(O50=1,O27,N23*(1+O52/100))) | =IF(AND(P50>1,O50>1),IF(AND(P50>0,O50>0),P27*(P51/100+1),0)+IF(P50>0,O23*(1+P52/100),0)-O23*(1+'Input data'!P30/100),IF(P50=1,P27,O23*(1+P52/100))) | =IF(AND(Q50>1,P50>1),IF(AND(Q50>0,P50>0),Q27*(Q51/100+1),0)+IF(Q50>0,P23*(1+Q52/100),0)-P23*(1+'Input data'!Q30/100),IF(Q50=1,Q27,P23*(1+Q52/100))) | =IF(AND(R50>1,Q50>1),IF(AND(R50>0,Q50>0),R27*(R51/100+1),0)+IF(R50>0,Q23*(1+R52/100),0)-Q23*(1+'Input data'!R30/100),IF(R50=1,R27,Q23*(1+R52/100))) | =IF(AND(S50>1,R50>1),IF(AND(S50>0,R50>0),S27*(S51/100+1),0)+IF(S50>0,R23*(1+S52/100),0)-R23*(1+'Input data'!S30/100),IF(S50=1,S27,R23*(1+S52/100))) | =IF(AND(T50>1,S50>1),IF(AND(T50>0,S50>0),T27*(T51/100+1),0)+IF(T50>0,S23*(1+T52/100),0)-S23*(1+'Input data'!T30/100),IF(T50=1,T27,S23*(1+T52/100))) | =IF(AND(U50>1,T50>1),IF(AND(U50>0,T50>0),U27*(U51/100+1),0)+IF(U50>0,T23*(1+U52/100),0)-T23*(1+'Input data'!U30/100),IF(U50=1,U27,T23*(1+U52/100))) | =IF(AND(V50>1,U50>1),IF(AND(V50>0,U50>0),V27*(V51/100+1),0)+IF(V50>0,U23*(1+V52/100),0)-U23*(1+'Input data'!V30/100),IF(V50=1,V27,U23*(1+V52/100))) | =IF(AND(W50>1,V50>1),IF(AND(W50>0,V50>0),W27*(W51/100+1),0)+IF(W50>0,V23*(1+W52/100),0)-V23*(1+'Input data'!W30/100),IF(W50=1,W27,V23*(1+W52/100))) | |||||||||||||||||||||||||||||
| Growth rate | =+'Input data'!C30 | ='Baseline NFPC'!D23 | ='Baseline NFPC'!E23 | ='Baseline NFPC'!F23 | =100*(G23/F23-1) | =100*(H23/G23-1) | =100*(I23/H23-1) | =100*(J23/I23-1) | =100*(K23/J23-1) | =100*(L23/K23-1) | =100*(M23/L23-1) | =100*(N23/M23-1) | =100*(O23/N23-1) | =100*(P23/O23-1) | =100*(Q23/P23-1) | =100*(R23/Q23-1) | =100*(S23/R23-1) | =100*(T23/S23-1) | =100*(U23/T23-1) | =100*(V23/U23-1) | =100*(W23/V23-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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Potential GDP (real) | ||||||||||||||||||||||||||||||||||||||||||||||||||
| Level | ='Input data'!C34 | =+C27*(1+'Input data'!D33/100) | =+D27*(1+'Input data'!E33/100) | =+E27*(1+'Input data'!F33/100) | =+F27*(1+'Input data'!G33/100) | =+G27*(1+'Input data'!H33/100) | =+H27*(1+'Input data'!I33/100) | =+I27*(1+'Input data'!J33/100) | =+J27*(1+'Input data'!K33/100) | =+K27*(1+'Input data'!L33/100) | =+L27*(1+'Input data'!M33/100) | =+M27*(1+'Input data'!N33/100) | =+N27*(1+'Input data'!O33/100) | =+O27*(1+'Input data'!P33/100) | =+P27*(1+'Input data'!Q33/100) | =+Q27*(1+'Input data'!R33/100) | =+R27*(1+'Input data'!S33/100) | =+S27*(1+'Input data'!T33/100) | =+T27*(1+'Input data'!U33/100) | =+U27*(1+'Input data'!V33/100) | =+V27*(1+'Input data'!W33/100) |
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