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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| New long-term debt | ='Input data'!C69*$D$83 | =IF(E83=0,0,IF(E79=1,'Input data'!$C$58*(E83-D83*E42/((1+E23/100)*(1+E41/100))),0)) | =IF(F83=0,0,IF(F79=1,'Input data'!$C$58*(F83-E83*F42/((1+F23/100)*(1+F41/100))),0)) | =IF(G83=0,0,IF(G79=1,'Input data'!$C$58*(G83-F83*G42/((1+G23/100)*(1+G41/100))),0)) | =IF(H83=0,0,IF(H79=1,'Input data'!$C$58*(H83-G83*H42/((1+H23/100)*(1+H41/100))),0)) | =IF(I83=0,0,IF(I79=1,'Input data'!$C$58*(I83-H83*I42/((1+I23/100)*(1+I41/100))),0)) | =IF(J83=0,0,IF(J79=1,'Input data'!$C$58*(J83-I83*J42/((1+J23/100)*(1+J41/100))),0)) | =IF(K83=0,0,IF(K79=1,'Input data'!$C$58*(K83-J83*K42/((1+K23/100)*(1+K41/100))),0)) | =IF(L83=0,0,IF(L79=1,'Input data'!$C$58*(L83-K83*L42/((1+L23/100)*(1+L41/100))),0)) | =IF(M83=0,0,IF(M79=1,'Input data'!$C$58*(M83-L83*M42/((1+M23/100)*(1+M41/100))),0)) | =IF(N83=0,0,IF(N79=1,'Input data'!$C$58*(N83-M83*N42/((1+N23/100)*(1+N41/100))),0)) | =IF(O83=0,0,IF(O79=1,'Input data'!$C$58*(O83-N83*O42/((1+O23/100)*(1+O41/100))),0)) | =IF(P83=0,0,IF(P79=1,'Input data'!$C$58*(P83-O83*P42/((1+P23/100)*(1+P41/100))),0)) | =IF(Q83=0,0,IF(Q79=1,'Input data'!$C$58*(Q83-P83*Q42/((1+Q23/100)*(1+Q41/100))),0)) | =IF(R83=0,0,IF(R79=1,'Input data'!$C$58*(R83-Q83*R42/((1+R23/100)*(1+R41/100))),0)) | =IF(S83=0,0,IF(S79=1,'Input data'!$C$58*(S83-R83*S42/((1+S23/100)*(1+S41/100))),0)) | =IF(T83=0,0,IF(T79=1,'Input data'!$C$58*(T83-S83*T42/((1+T23/100)*(1+T41/100))),0)) | =IF(U83=0,0,IF(U79=1,'Input data'!$C$58*(U83-T83*U42/((1+U23/100)*(1+U41/100))),0)) | =IF(V83=0,0,IF(V79=1,'Input data'!$C$58*(V83-U83*V42/((1+V23/100)*(1+V41/100))),0)) | =IF(W83=0,0,IF(W79=1,'Input data'!$C$58*(W83-V83*W42/((1+W23/100)*(1+W41/100))),0)) | |||||||||||||||||||||||||||||||||
| New short-term debt | ='Input data'!C70*$D$83 | =IF(E83=0,0,IF(E79=1,'Input data'!$C$57*(E83-D83*E42/((1+E23/100)*(1+E41/100))),0)) | =IF(F83=0,0,IF(F79=1,'Input data'!$C$57*(F83-E83*F42/((1+F23/100)*(1+F41/100))),0)) | =IF(G83=0,0,IF(G79=1,'Input data'!$C$57*(G83-F83*G42/((1+G23/100)*(1+G41/100))),0)) | =IF(H83=0,0,IF(H79=1,'Input data'!$C$57*(H83-G83*H42/((1+H23/100)*(1+H41/100))),0)) | =IF(I83=0,0,IF(I79=1,'Input data'!$C$57*(I83-H83*I42/((1+I23/100)*(1+I41/100))),0)) | =IF(J83=0,0,IF(J79=1,'Input data'!$C$57*(J83-I83*J42/((1+J23/100)*(1+J41/100))),0)) | =IF(K83=0,0,IF(K79=1,'Input data'!$C$57*(K83-J83*K42/((1+K23/100)*(1+K41/100))),0)) | =IF(L83=0,0,IF(L79=1,'Input data'!$C$57*(L83-K83*L42/((1+L23/100)*(1+L41/100))),0)) | =IF(M83=0,0,IF(M79=1,'Input data'!$C$57*(M83-L83*M42/((1+M23/100)*(1+M41/100))),0)) | =IF(N83=0,0,IF(N79=1,'Input data'!$C$57*(N83-M83*N42/((1+N23/100)*(1+N41/100))),0)) | =IF(O83=0,0,IF(O79=1,'Input data'!$C$57*(O83-N83*O42/((1+O23/100)*(1+O41/100))),0)) | =IF(P83=0,0,IF(P79=1,'Input data'!$C$57*(P83-O83*P42/((1+P23/100)*(1+P41/100))),0)) | =IF(Q83=0,0,IF(Q79=1,'Input data'!$C$57*(Q83-P83*Q42/((1+Q23/100)*(1+Q41/100))),0)) | =IF(R83=0,0,IF(R79=1,'Input data'!$C$57*(R83-Q83*R42/((1+R23/100)*(1+R41/100))),0)) | =IF(S83=0,0,IF(S79=1,'Input data'!$C$57*(S83-R83*S42/((1+S23/100)*(1+S41/100))),0)) | =IF(T83=0,0,IF(T79=1,'Input data'!$C$57*(T83-S83*T42/((1+T23/100)*(1+T41/100))),0)) | =IF(U83=0,0,IF(U79=1,'Input data'!$C$57*(U83-T83*U42/((1+U23/100)*(1+U41/100))),0)) | =IF(V83=0,0,IF(V79=1,'Input data'!$C$57*(V83-U83*V42/((1+V23/100)*(1+V41/100))),0)) | =IF(W83=0,0,IF(W79=1,'Input data'!$C$57*(W83-V83*W42/((1+W23/100)*(1+W41/100))),0)) | |||||||||||||||||||||||||||||||||
| Share of short-term debt in total government debt | ='Baseline NFPC'!$D$93 | =IF(E83<>0,(E86+E88)/(E84+E85+E86+E87+E88),0) | =IF(F83<>0,(F86+F88)/(F84+F85+F86+F87+F88),0) | =IF(G83<>0,(G86+G88)/(G84+G85+G86+G87+G88),0) | =IF(H83<>0,(H86+H88)/(H84+H85+H86+H87+H88),0) | =IF(I83<>0,(I86+I88)/(I84+I85+I86+I87+I88),0) | =IF(J83<>0,(J86+J88)/(J84+J85+J86+J87+J88),0) | =IF(K83<>0,(K86+K88)/(K84+K85+K86+K87+K88),0) | =IF(L83<>0,(L86+L88)/(L84+L85+L86+L87+L88),0) | =IF(M83<>0,(M86+M88)/(M84+M85+M86+M87+M88),0) | =IF(N83<>0,(N86+N88)/(N84+N85+N86+N87+N88),0) | =IF(O83<>0,(O86+O88)/(O84+O85+O86+O87+O88),0) | =IF(P83<>0,(P86+P88)/(P84+P85+P86+P87+P88),0) | =IF(Q83<>0,(Q86+Q88)/(Q84+Q85+Q86+Q87+Q88),0) | =IF(R83<>0,(R86+R88)/(R84+R85+R86+R87+R88),0) | =IF(S83<>0,(S86+S88)/(S84+S85+S86+S87+S88),0) | =IF(T83<>0,(T86+T88)/(T84+T85+T86+T87+T88),0) | =IF(U83<>0,(U86+U88)/(U84+U85+U86+U87+U88),0) | =IF(V83<>0,(V86+V88)/(V84+V85+V86+V87+V88),0) | =IF(W83<>0,(W86+W88)/(W84+W85+W86+W87+W88),0) | |||||||||||||||||||||||||||||||||
| Share of long-term debt in total government debt | ='Baseline NFPC'!$D$94 | =IF(E83<>0,(E84+E85+E87)/(E84+E85+E86+E87+E88),1) | =IF(F83<>0,(F84+F85+F87)/(F84+F85+F86+F87+F88),1) | =IF(G83<>0,(G84+G85+G87)/(G84+G85+G86+G87+G88),1) | =IF(H83<>0,(H84+H85+H87)/(H84+H85+H86+H87+H88),1) | =IF(I83<>0,(I84+I85+I87)/(I84+I85+I86+I87+I88),1) | =IF(J83<>0,(J84+J85+J87)/(J84+J85+J86+J87+J88),1) | =IF(K83<>0,(K84+K85+K87)/(K84+K85+K86+K87+K88),1) | =IF(L83<>0,(L84+L85+L87)/(L84+L85+L86+L87+L88),1) | =IF(M83<>0,(M84+M85+M87)/(M84+M85+M86+M87+M88),1) | =IF(N83<>0,(N84+N85+N87)/(N84+N85+N86+N87+N88),1) | =IF(O83<>0,(O84+O85+O87)/(O84+O85+O86+O87+O88),1) | =IF(P83<>0,(P84+P85+P87)/(P84+P85+P86+P87+P88),1) | =IF(Q83<>0,(Q84+Q85+Q87)/(Q84+Q85+Q86+Q87+Q88),1) | =IF(R83<>0,(R84+R85+R87)/(R84+R85+R86+R87+R88),1) | =IF(S83<>0,(S84+S85+S87)/(S84+S85+S86+S87+S88),1) | =IF(T83<>0,(T84+T85+T87)/(T84+T85+T86+T87+T88),1) | =IF(U83<>0,(U84+U85+U87)/(U84+U85+U86+U87+U88),1) | =IF(V83<>0,(V84+V85+V87)/(V84+V85+V86+V87+V88),1) | =IF(W83<>0,(W84+W85+W87)/(W84+W85+W86+W87+W88),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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IIR | =E94+E95 | =F94+F95 | =G94+G95 | =H94+H95 | =I94+I95 | =J94+J95 | =K94+K95 | =L94+L95 | =M94+M95 | =N94+N95 | =O94+O95 | =P94+P95 | =Q94+Q95 | =R94+R95 | =S94+S95 | =T94+T95 | =U94+U95 | =V94+V95 | =W94+W95 | ||||||||||||||||||||||||||||||||||
| Long-term implicit interest rate | =((E35*D83)-(E37*(D86+D88)))/(D84+D85+D87) | =((F35*E83)-(F37*(E86+E88)))/(E84+E85+E87) | =((G35*F83)-(G37*(F86+F88)))/(F84+F85+F87) | =IF(G83>0,(G93*G84+H36*(G87+G85))/(G84+G85+G87),H36) | =IF(H83>0,(H93*H84+I36*(H87+H85))/(H84+H85+H87),I36) | =IF(I83>0,(I93*I84+J36*(I87+I85))/(I84+I85+I87),J36) | =IF(J83>0,(J93*J84+K36*(J87+J85))/(J84+J85+J87),K36) | =IF(K83>0,(K93*K84+L36*(K87+K85))/(K84+K85+K87),L36) | =IF(L83>0,(L93*L84+M36*(L87+L85))/(L84+L85+L87),M36) | =IF(M83>0,(M93*M84+N36*(M87+M85))/(M84+M85+M87),N36) | =IF(N83>0,(N93*N84+O36*(N87+N85))/(N84+N85+N87),O36) | =IF(O83>0,(O93*O84+P36*(O87+O85))/(O84+O85+O87),P36) | =IF(P83>0,(P93*P84+Q36*(P87+P85))/(P84+P85+P87),Q36) | =IF(Q83>0,(Q93*Q84+R36*(Q87+Q85))/(Q84+Q85+Q87),R36) | =IF(R83>0,(R93*R84+S36*(R87+R85))/(R84+R85+R87),S36) | =IF(S83>0,(S93*S84+T36*(S87+S85))/(S84+S85+S87),T36) | =IF(T83>0,(T93*T84+U36*(T87+T85))/(T84+T85+T87),U36) | =IF(U83>0,(U93*U84+V36*(U87+U85))/(U84+U85+U87),V36) | =IF(V83>0,(V93*V84+W36*(V87+V85))/(V84+V85+V87),W36) | ||||||||||||||||||||||||||||||||||
| Nominal implicit interest rate on debt (Excel approximation) | =(E93*(D84+D85+D87)+E37*(D86+D88))/D83 | =(F93*(E84+E85+E87)+F37*(E86+E88))/E83 | =(G93*(F84+F85+F87)+G37*(F86+F88))/F83 | =(H93*(G84+G85+G87)+H37*(G86+G88))/G83 | =(I93*(H84+H85+H87)+I37*(H86+H88))/H83 | =(J93*(I84+I85+I87)+J37*(I86+I88))/I83 | =(K93*(J84+J85+J87)+K37*(J86+J88))/J83 | =(L93*(K84+K85+K87)+L37*(K86+K88))/K83 | =(M93*(L84+L85+L87)+M37*(L86+L88))/L83 | =(N93*(M84+M85+M87)+N37*(M86+M88))/M83 | =(O93*(N84+N85+N87)+O37*(N86+N88))/N83 | =(P93*(O84+O85+O87)+P37*(O86+O88))/O83 | =(Q93*(P84+P85+P87)+Q37*(P86+P88))/P83 | =(R93*(Q84+Q85+Q87)+R37*(Q86+Q88))/Q83 | =(S93*(R84+R85+R87)+S37*(R86+R88))/R83 | =(T93*(S84+S85+S87)+T37*(S86+S88))/S83 | =(U93*(T84+T85+T87)+U37*(T86+T88))/T83 | =(V93*(U84+U85+U87)+V37*(U86+U88))/U83 | =(W93*(V84+V85+V87)+W37*(V86+V88))/V83 | ||||||||||||||||||||||||||||||||||
| Diff. STATA | =IF('Criteria results'!$F$5=4,E105,E110) | =IF('Criteria results'!$F$5=4,F105,F110) | =IF('Criteria results'!$F$5=4,G105,G110) | =IF('Criteria results'!$F$5=4,H105,H110) | =IF('Criteria results'!$F$5=4,I105,I110) | =IF('Criteria results'!$F$5=4,J105,J110) | =IF('Criteria results'!$F$5=4,K105,K110) | =IF('Criteria results'!$F$5=4,L105,L110) | =IF('Criteria results'!$F$5=4,M105,M110) | =IF('Criteria results'!$F$5=4,N105,N110) | =IF('Criteria results'!$F$5=4,O105,O110) | =IF('Criteria results'!$F$5=4,P105,P110) | =IF('Criteria results'!$F$5=4,Q105,Q110) | =IF('Criteria results'!$F$5=4,R105,R110) | =IF('Criteria results'!$F$5=4,S105,S110) | =IF('Criteria results'!$F$5=4,T105,T110) | =IF('Criteria results'!$F$5=4,U105,U110) | =IF('Criteria results'!$F$5=4,V105,V110) | =IF('Criteria results'!$F$5=4,W105,W110) |
Coloanele sunt separate în sursă; anteturile nu sunt confirmate.
(i - g) =((1+C92/100)/((1+C23/100)*(1+C41/100))-1)*100 =((1+D92/100)/((1+D23/100)*(1+D41/100))-1)*100 =((1+E92/100)/((1+E23/100)*(1+E41/100))-1)*100 =((1+F92/100)/((1+F23/100)*(1+F41/100))-1)*100 =((1+G92/100)/((1+G23/100)*(1+G41/100))-1)*100 =((1+H92/100)/((1+H23/100)*(1+H41/100))-1)*100 =((1+I92/100)/((1+I23/100)*(1+I41/100))-1)*100 =((1+J92/100)/((1+J23/100)*(1+J41/100))-1)*100 =((1+K92/100)/((1+K23/100)*(1+K41/100))-1)*100 =((1+L92/100)/((1+L23/100)*(1+L41/100))-1)*100 =((1+M92/100)/((1+M23/100)*(1+M41/100))-1)*100 =((1+N92/100)/((1+N23/100)*(1+N41/100))-1)*100 =((1+O92/100)/((1+O23/100)*(1+O41/100))-1)*100 =((1+P92/100)/((1+P23/100)*(1+P41/100))-1)*100 =((1+Q92/100)/((1+Q23/100)*(1+Q41/100))-1)*100 =((1+R92/100)/((1+R23/100)*(1+R41/100))-1)*100 =((1+S92/100)/((1+S23/100)*(1+S41/100))-1)*100 =((1+T92/100)/((1+T23/100)*(1+T41/100))-1)*100 =((1+U92/100)/((1+U23/100)*(1+U41/100))-1)*100 =((1+V92/100)/((1+V23/100)*(1+V41/100))-1)*100 =((1+W92/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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| No extension (annual adjustment of 1.22) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Debt | 48.468898773193 | 47.489418029785 | 48.800212860107 | 50.910091400146 | 53.269962310791 | 54.560989379883 | 54.975521087646 | 54.447998046875 | 53.473892211914 | 52.902797698975 | 52.588047027588 | 52.286823272705 | 52.072639465332 | 52.188446044922 | 52.422847747803 | 52.707885742188 | 53.114803314209 | 53.678020477295 | 54.418151855469 | 55.372833251953 | 56.482482910156 | ||||||||||||||||||||||||||||||||
| IIR | 3.4699952602386 | 3.5900068283081 | 4.8260774612427 | 4.5376110076904 | 4.1806688308716 | 4.6490592956543 | 5.0018067359924 | 5.2703423500061 | 5.4756722450256 | 5.6564836502075 | 5.8158164024353 | 5.952787399292 | 6.0700769424438 | 6.1536874771118 | 6.2069072723389 | 6.2334866523743 | 6.2372779846191 | 6.221869468689 | 6.1901512145996 | 6.1444892883301 | 6.0868148803711 | ||||||||||||||||||||||||||||||||
| IIR difference STATA - Excel | 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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Extension (annual adjustment of 0.74) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Debt | 48.468898773193 | 47.489418029785 | 48.800212860107 | 50.910091400146 | 53.465320587158 | 55.414516448975 | 56.956127166748 | 58.03120803833 | 58.565063476562 | 58.553298950195 | 57.963470458984 | 57.077693939209 | 56.610191345215 | 56.490924835205 | 56.449512481689 | 56.416687011719 | 56.587268829346 | 56.918434143066 | 57.429359436035 | 58.157150268555 | 59.038257598877 | ||||||||||||||||||||||||||||||||
| IIR | 3.4699952602386 | 3.5900068283081 | 4.8260774612427 | 4.5376110076904 | 4.1806688308716 | 4.6645908355713 | 5.0400586128235 | 5.3345518112183 | 5.5675706863403 | 5.7532033920288 | 5.901759147644 | 6.0209083557129 | 6.1247215270996 | 6.199061870575 | 6.2443900108337 | 6.2645630836487 | 6.2633962631226 | 6.2442584037781 | 6.2097873687744 | 6.1621389389038 | 6.1030683517456 | ||||||||||||||||||||||||||||||||
| IIR difference STATA - Excel | 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.
Adverse (r-g)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Country | ='Input data'!C3 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| Key years | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| ='Input data'!B5 | =+'Input data'!C5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| Last year of adjustment | =+C5+'Criteria results'!F5 | ||||||||||||||||||||||||||||||||||||||||||||||||||||
| Last year of no-fiscal-policy-change projections | =C5+'Criteria results'!F5+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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Structural primary balance ('+' means 'surplus') | ='Input data'!C13 | ='Input data'!D13 | ='Input data'!E13 | ='Input data'!F13 | ='Adjust. no safeguard'!G12 | ='Adjust. no safeguard'!H12 | ='Adjust. no safeguard'!I12 | ='Adjust. no safeguard'!J12 | ='Adjust. no safeguard'!K12 | ='Adjust. no safeguard'!L12 | ='Adjust. no safeguard'!M12 | =IF(N10<=$C$6,M12+'Criteria results'!$F$6,M12) | =IF(O10<=$C$6,N12+'Criteria results'!$F$6,N12) | =IF(P10<=$C$6,O12+'Criteria results'!$F$6,O12) | =IF(Q10<=$C$6,P12+'Criteria results'!$F$6,P12) | =IF(R10<=$C$6,Q12+'Criteria results'!$F$6,Q12) | =IF(S10<=$C$6,R12+'Criteria results'!$F$6,R12) | =IF(T10<=$C$6,S12+'Criteria results'!$F$6,S12) | =IF(U10<=$C$6,T12+'Criteria results'!$F$6,T12) | =IF(V10<=$C$6,U12+'Criteria results'!$F$6,U12) | =IF(W10<=$C$6,V12+'Criteria results'!$F$6,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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ='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 | Coloana 52 | Coloana 53 | Coloana 54 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| GDP growth assumptions | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Actual GDP (real) | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Level | ='Input data'!C31 | =IF(AND(D50>1,C50>1),IF(AND(D50>0,C50>0),D27*(D51/100+1),0)+IF(D50>0,C22*(1+D52/100),0)-C22*(1+'Input data'!D30/100),IF(D50=1,D27,C22*(1+D52/100))) | =IF(AND(E50>1,D50>1),IF(AND(E50>0,D50>0),E27*(E51/100+1),0)+IF(E50>0,D22*(1+E52/100),0)-D22*(1+'Input data'!E30/100),IF(E50=1,E27,D22*(1+E52/100))) | =IF(AND(F50>1,E50>1),IF(AND(F50>0,E50>0),F27*(F51/100+1),0)+IF(F50>0,E22*(1+F52/100),0)-E22*(1+'Input data'!F30/100),IF(F50=1,F27,E22*(1+F52/100))) | =IF(AND(G50>1,F50>1),IF(AND(G50>0,F50>0),G27*(G51/100+1),0)+IF(G50>0,F22*(1+G52/100),0)-F22*(1+'Input data'!G30/100),IF(G50=1,G27,F22*(1+G52/100))) | =IF(AND(H50>1,G50>1),IF(AND(H50>0,G50>0),H27*(H51/100+1),0)+IF(H50>0,G22*(1+H52/100),0)-G22*(1+'Input data'!H30/100),IF(H50=1,H27,G22*(1+H52/100))) | =IF(AND(I50>1,H50>1),IF(AND(I50>0,H50>0),I27*(I51/100+1),0)+IF(I50>0,H22*(1+I52/100),0)-H22*(1+'Input data'!I30/100),IF(I50=1,I27,H22*(1+I52/100))) | =IF(AND(J50>1,I50>1),IF(AND(J50>0,I50>0),J27*(J51/100+1),0)+IF(J50>0,I22*(1+J52/100),0)-I22*(1+'Input data'!J30/100),IF(J50=1,J27,I22*(1+J52/100))) | =IF(AND(K50>1,J50>1),IF(AND(K50>0,J50>0),K27*(K51/100+1),0)+IF(K50>0,J22*(1+K52/100),0)-J22*(1+'Adverse (r-g)'!K24/100),IF(K50=1,K27,J22*(1+K52/100))) | =IF(AND(L50>1,K50>1),IF(AND(L50>0,K50>0),L27*(L51/100+1),0)+IF(L50>0,K22*(1+L52/100),0)-K22*(1+'Adverse (r-g)'!L24/100),IF(L50=1,L27,K22*(1+L52/100))) | =IF(AND(M50>1,L50>1),IF(AND(M50>0,L50>0),M27*(M51/100+1),0)+IF(M50>0,L22*(1+M52/100),0)-L22*(1+'Adverse (r-g)'!M24/100),IF(M50=1,M27,L22*(1+M52/100))) | =IF(AND(N50>1,M50>1),IF(AND(N50>0,M50>0),N27*(N51/100+1),0)+IF(N50>0,M22*(1+N52/100),0)-M22*(1+'Adverse (r-g)'!N24/100),IF(N50=1,N27,M22*(1+N52/100))) | =IF(AND(O50>1,N50>1),IF(AND(O50>0,N50>0),O27*(O51/100+1),0)+IF(O50>0,N22*(1+O52/100),0)-N22*(1+'Adverse (r-g)'!O24/100),IF(O50=1,O27,N22*(1+O52/100))) | =IF(AND(P50>1,O50>1),IF(AND(P50>0,O50>0),P27*(P51/100+1),0)+IF(P50>0,O22*(1+P52/100),0)-O22*(1+'Adverse (r-g)'!P24/100),IF(P50=1,P27,O22*(1+P52/100))) | =IF(AND(Q50>1,P50>1),IF(AND(Q50>0,P50>0),Q27*(Q51/100+1),0)+IF(Q50>0,P22*(1+Q52/100),0)-P22*(1+'Adverse (r-g)'!Q24/100),IF(Q50=1,Q27,P22*(1+Q52/100))) | =IF(AND(R50>1,Q50>1),IF(AND(R50>0,Q50>0),R27*(R51/100+1),0)+IF(R50>0,Q22*(1+R52/100),0)-Q22*(1+'Adverse (r-g)'!R24/100),IF(R50=1,R27,Q22*(1+R52/100))) | =IF(AND(S50>1,R50>1),IF(AND(S50>0,R50>0),S27*(S51/100+1),0)+IF(S50>0,R22*(1+S52/100),0)-R22*(1+'Adverse (r-g)'!S24/100),IF(S50=1,S27,R22*(1+S52/100))) | =IF(AND(T50>1,S50>1),IF(AND(T50>0,S50>0),T27*(T51/100+1),0)+IF(T50>0,S22*(1+T52/100),0)-S22*(1+'Adverse (r-g)'!T24/100),IF(T50=1,T27,S22*(1+T52/100))) | =IF(AND(U50>1,T50>1),IF(AND(U50>0,T50>0),U27*(U51/100+1),0)+IF(U50>0,T22*(1+U52/100),0)-T22*(1+'Adverse (r-g)'!U24/100),IF(U50=1,U27,T22*(1+U52/100))) | =IF(AND(V50>1,U50>1),IF(AND(V50>0,U50>0),V27*(V51/100+1),0)+IF(V50>0,U22*(1+V52/100),0)-U22*(1+'Adverse (r-g)'!V24/100),IF(V50=1,V27,U22*(1+V52/100))) | =IF(AND(W50>1,V50>1),IF(AND(W50>0,V50>0),W27*(W51/100+1),0)+IF(W50>0,V22*(1+W52/100),0)-V22*(1+'Adverse (r-g)'!W24/100),IF(W50=1,W27,V22*(1+W52/100))) | ||||||||||||||||||||||||||||||||
| Growth rate (including feedback and output-gap closure effect) | =+'Input data'!C30 | =100*(D22/C22-1) | =100*(E22/D22-1) | =100*(F22/E22-1) | =100*(G22/F22-1) | =100*(H22/G22-1) | =100*(I22/H22-1) | =100*(J22/I22-1) | =100*(K22/J22-1) | =100*(L22/K22-1) | =100*(M22/L22-1) | =100*(N22/M22-1) | =100*(O22/N22-1) | =100*(P22/O22-1) | =100*(Q22/P22-1) | =100*(R22/Q22-1) | =100*(S22/R22-1) | =100*(T22/S22-1) | =100*(U22/T22-1) | =100*(V22/U22-1) | =100*(W22/V22-1) | ||||||||||||||||||||||||||||||||
| per memo: initial shock (GDP growth rate in baseline scenario - 0.5) | =IF('Criteria results'!$F$5=4,'Input data'!K30-0.5,'Input data'!K30) | =IF('Criteria results'!$F$5=4,'Input data'!L30-0.5,'Input data'!L30) | =IF('Criteria results'!$F$5=4,'Input data'!M30-0.5,'Input data'!M30) | ='Input data'!N30-0.5 | ='Input data'!O30-0.5 | ='Input data'!P30-0.5 | ='Input data'!Q30-0.5 | ='Input data'!R30-0.5 | ='Input data'!S30-0.5 | ='Input data'!T30-0.5 | ='Input data'!U30-0.5 | ='Input data'!V30-0.5 | ='Input data'!W30-0.5 |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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) | =IF('Criteria results'!$F$5=4,J27*(1+'Input data'!K33/100-0.005),J27*(1+'Input data'!K33/100)) | =IF('Criteria results'!$F$5=4,K27*(1+'Input data'!L33/100-0.005),K27*(1+'Input data'!L33/100)) | =IF('Criteria results'!$F$5=4,L27*(1+'Input data'!M33/100-0.005),L27*(1+'Input data'!M33/100)) | =+M27*(1+'Input data'!N33/100-0.005) | =+N27*(1+'Input data'!O33/100-0.005) | =+O27*(1+'Input data'!P33/100-0.005) | =+P27*(1+'Input data'!Q33/100-0.005) | =+Q27*(1+'Input data'!R33/100-0.005) | =+R27*(1+'Input data'!S33/100-0.005) | =+S27*(1+'Input data'!T33/100-0.005) | =+T27*(1+'Input data'!U33/100-0.005) | =+U27*(1+'Input data'!V33/100-0.005) | =+V27*(1+'Input data'!W33/100-0.005) |
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Output gap | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Output gap | =100*(C22/C27-1) | =100*(D22/D27-1) | =100*(E22/E27-1) | =100*(F22/F27-1) | =100*(G22/G27-1) | =100*(H22/H27-1) | =100*(I22/I27-1) | =100*(J22/J27-1) | =100*(K22/K27-1) | =100*(L22/L27-1) | =100*(M22/M27-1) | =100*(N22/N27-1) | =100*(O22/O27-1) | =100*(P22/P27-1) | =100*(Q22/Q27-1) | =100*(R22/R27-1) | =100*(S22/S27-1) | =100*(T22/T27-1) | =100*(U22/U27-1) | =100*(V22/V27-1) | =100*(W22/W27-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+C42/100)-1) | =100*((1+D23/100)*(1+D42/100)-1) | =100*((1+E23/100)*(1+E42/100)-1) | =100*((1+F23/100)*(1+F42/100)-1) | =100*((1+G23/100)*(1+G42/100)-1) | =100*((1+H23/100)*(1+H42/100)-1) | =100*((1+I23/100)*(1+I42/100)-1) | =100*((1+J23/100)*(1+J42/100)-1) | =100*((1+K23/100)*(1+K42/100)-1) | =100*((1+L23/100)*(1+L42/100)-1) | =100*((1+M23/100)*(1+M42/100)-1) | =100*((1+N23/100)*(1+N42/100)-1) | =100*((1+O23/100)*(1+O42/100)-1) | =100*((1+P23/100)*(1+P42/100)-1) | =100*((1+Q23/100)*(1+Q42/100)-1) | =100*((1+R23/100)*(1+R42/100)-1) | =100*((1+S23/100)*(1+S42/100)-1) | =100*((1+T23/100)*(1+T42/100)-1) | =100*((1+U23/100)*(1+U42/100)-1) | =100*((1+V23/100)*(1+V42/100)-1) | =100*((1+W23/100)*(1+W42/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 and inflation | |||||||||||||||||||||||||||||||||||||||||||||||||||||
| Nominal implicit interest rate on debt | ='Input data'!C37 | ='Input data'!D37 | ='Input data'!E37 | ='Input data'!F37 | ='Input data'!G37 | =H93 | =I93 | =J93 | =K93 | =L93 | =M93 | =N93 | =O93 | =P93 | =Q93 | =R93 | =S93 | =T93 | =U93 | =V93 | =W93 | ||||||||||||||||||||||||||||||||
| Long-term interest rate | ='Input data'!D$39 | ='Input data'!E$39 | ='Input data'!F$39 | ='Input data'!G$39 | =$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(H10-$G$10) | =$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(I10-$G$10) | =$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(J10-$G$10) | =IF('Criteria results'!$F$5=4,$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(K10-$G$10)+0.5,$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(K10-$G$10)) | =IF('Criteria results'!$F$5=4,$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(L10-$G$10)+0.5,$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(L10-$G$10)) | =IF('Criteria results'!$F$5=4,$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(M10-$G$10)+0.5,$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(M10-$G$10)) | =IF('Criteria results'!$F$5=4,$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(N10-$G$10)+0.5,$G$37+('Input data'!$C$52-$G$37)/($O$10-$G$10)*(N10-$G$10)+0.5) | ='Input data'!$C$52+0.5 | ='Baseline NFPC'!P36+0.5 | ='Baseline NFPC'!Q36+0.5 | ='Baseline NFPC'!R36+0.5 | ='Baseline NFPC'!S36+0.5 | ='Baseline NFPC'!T36+0.5 | ='Baseline NFPC'!U36+0.5 | ='Baseline NFPC'!V36+0.5 | ='Baseline NFPC'!W36+0.5 | |||||||||||||||||||||||||||||||||
| Short-term interest rate | ='Input data'!D$38 | ='Input data'!E$38 | ='Input data'!F$38 | ='Input data'!G$38 | =$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(H10-$G$10) | =$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(I10-$G$10) | =$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(J10-$G$10) | =IF('Criteria results'!$F$5=4,$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(K10-$G$10)+0.5,$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(K10-$G$10)) | =IF('Criteria results'!$F$5=4,$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(L10-$G$10)+0.5,$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(L10-$G$10)) | =IF('Criteria results'!$F$5=4,$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(M10-$G$10)+0.5,$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(M10-$G$10)) | =IF('Criteria results'!$F$5=4,$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(N10-$G$10)+0.5,$G$38+('Input data'!$C$53-$G$38)/($O$10-$G$10)*(N10-$G$10)+0.5) | ='Input data'!$C$53+0.5 | ='Baseline NFPC'!P37+0.5 | ='Baseline NFPC'!Q37+0.5 | ='Baseline NFPC'!R37+0.5 | ='Baseline NFPC'!S37+0.5 | ='Baseline NFPC'!T37+0.5 | ='Baseline NFPC'!U37+0.5 | ='Baseline NFPC'!V37+0.5 | ='Baseline NFPC'!W37+0.5 |
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