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

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
Rolled over long-term debt='Input data'!C67*$D$84=IF(E84=0,0,IF(E80=1,E39*D84*D91*E43/((1+E23/100)*(1+E42/100)),IF(AND(E80=0,E81=1),(E39*D84*D91*E43/((1+E23/100)*(1+E42/100)))*(1-ABS(E84-D84*E43/((1+E23/100)*(1+E42/100)))/((E39*D84*D91*E43/((1+E23/100)*(1+E42/100)))+(D90*D84*E43/((1+E23/100)*(1+E42/100))))),0)))=IF(F84=0,0,IF(F80=1,F39*E84*E91*F43/((1+F23/100)*(1+F42/100)),IF(AND(F80=0,F81=1),(F39*E84*E91*F43/((1+F23/100)*(1+F42/100)))*(1-ABS(F84-E84*F43/((1+F23/100)*(1+F42/100)))/((F39*E84*E91*F43/((1+F23/100)*(1+F42/100)))+(E90*E84*F43/((1+F23/100)*(1+F42/100))))),0)))=IF(G84=0,0,IF(G80=1,G39*F84*F91*G43/((1+G23/100)*(1+G42/100)),IF(AND(G80=0,G81=1),(G39*F84*F91*G43/((1+G23/100)*(1+G42/100)))*(1-ABS(G84-F84*G43/((1+G23/100)*(1+G42/100)))/((G39*F84*F91*G43/((1+G23/100)*(1+G42/100)))+(F90*F84*G43/((1+G23/100)*(1+G42/100))))),0)))=IF(H84=0,0,IF(H80=1,H39*G84*G91*H43/((1+H23/100)*(1+H42/100)),IF(AND(H80=0,H81=1),(H39*G84*G91*H43/((1+H23/100)*(1+H42/100)))*(1-ABS(H84-G84*H43/((1+H23/100)*(1+H42/100)))/((H39*G84*G91*H43/((1+H23/100)*(1+H42/100)))+(G90*G84*H43/((1+H23/100)*(1+H42/100))))),0)))=IF(I84=0,0,IF(I80=1,I39*H84*H91*I43/((1+I23/100)*(1+I42/100)),IF(AND(I80=0,I81=1),(I39*H84*H91*I43/((1+I23/100)*(1+I42/100)))*(1-ABS(I84-H84*I43/((1+I23/100)*(1+I42/100)))/((I39*H84*H91*I43/((1+I23/100)*(1+I42/100)))+(H90*H84*I43/((1+I23/100)*(1+I42/100))))),0)))=IF(J84=0,0,IF(J80=1,J39*I84*I91*J43/((1+J23/100)*(1+J42/100)),IF(AND(J80=0,J81=1),(J39*I84*I91*J43/((1+J23/100)*(1+J42/100)))*(1-ABS(J84-I84*J43/((1+J23/100)*(1+J42/100)))/((J39*I84*I91*J43/((1+J23/100)*(1+J42/100)))+(I90*I84*J43/((1+J23/100)*(1+J42/100))))),0)))=IF(K84=0,0,IF(K80=1,K39*J84*J91*K43/((1+K23/100)*(1+K42/100)),IF(AND(K80=0,K81=1),(K39*J84*J91*K43/((1+K23/100)*(1+K42/100)))*(1-ABS(K84-J84*K43/((1+K23/100)*(1+K42/100)))/((K39*J84*J91*K43/((1+K23/100)*(1+K42/100)))+(J90*J84*K43/((1+K23/100)*(1+K42/100))))),0)))=IF(L84=0,0,IF(L80=1,L39*K84*K91*L43/((1+L23/100)*(1+L42/100)),IF(AND(L80=0,L81=1),(L39*K84*K91*L43/((1+L23/100)*(1+L42/100)))*(1-ABS(L84-K84*L43/((1+L23/100)*(1+L42/100)))/((L39*K84*K91*L43/((1+L23/100)*(1+L42/100)))+(K90*K84*L43/((1+L23/100)*(1+L42/100))))),0)))=IF(M84=0,0,IF(M80=1,M39*L84*L91*M43/((1+M23/100)*(1+M42/100)),IF(AND(M80=0,M81=1),(M39*L84*L91*M43/((1+M23/100)*(1+M42/100)))*(1-ABS(M84-L84*M43/((1+M23/100)*(1+M42/100)))/((M39*L84*L91*M43/((1+M23/100)*(1+M42/100)))+(L90*L84*M43/((1+M23/100)*(1+M42/100))))),0)))=IF(N84=0,0,IF(N80=1,N39*M84*M91*N43/((1+N23/100)*(1+N42/100)),IF(AND(N80=0,N81=1),(N39*M84*M91*N43/((1+N23/100)*(1+N42/100)))*(1-ABS(N84-M84*N43/((1+N23/100)*(1+N42/100)))/((N39*M84*M91*N43/((1+N23/100)*(1+N42/100)))+(M90*M84*N43/((1+N23/100)*(1+N42/100))))),0)))=IF(O84=0,0,IF(O80=1,O39*N84*N91*O43/((1+O23/100)*(1+O42/100)),IF(AND(O80=0,O81=1),(O39*N84*N91*O43/((1+O23/100)*(1+O42/100)))*(1-ABS(O84-N84*O43/((1+O23/100)*(1+O42/100)))/((O39*N84*N91*O43/((1+O23/100)*(1+O42/100)))+(N90*N84*O43/((1+O23/100)*(1+O42/100))))),0)))=IF(P84=0,0,IF(P80=1,P39*O84*O91*P43/((1+P23/100)*(1+P42/100)),IF(AND(P80=0,P81=1),(P39*O84*O91*P43/((1+P23/100)*(1+P42/100)))*(1-ABS(P84-O84*P43/((1+P23/100)*(1+P42/100)))/((P39*O84*O91*P43/((1+P23/100)*(1+P42/100)))+(O90*O84*P43/((1+P23/100)*(1+P42/100))))),0)))=IF(Q84=0,0,IF(Q80=1,Q39*P84*P91*Q43/((1+Q23/100)*(1+Q42/100)),IF(AND(Q80=0,Q81=1),(Q39*P84*P91*Q43/((1+Q23/100)*(1+Q42/100)))*(1-ABS(Q84-P84*Q43/((1+Q23/100)*(1+Q42/100)))/((Q39*P84*P91*Q43/((1+Q23/100)*(1+Q42/100)))+(P90*P84*Q43/((1+Q23/100)*(1+Q42/100))))),0)))=IF(R84=0,0,IF(R80=1,R39*Q84*Q91*R43/((1+R23/100)*(1+R42/100)),IF(AND(R80=0,R81=1),(R39*Q84*Q91*R43/((1+R23/100)*(1+R42/100)))*(1-ABS(R84-Q84*R43/((1+R23/100)*(1+R42/100)))/((R39*Q84*Q91*R43/((1+R23/100)*(1+R42/100)))+(Q90*Q84*R43/((1+R23/100)*(1+R42/100))))),0)))=IF(S84=0,0,IF(S80=1,S39*R84*R91*S43/((1+S23/100)*(1+S42/100)),IF(AND(S80=0,S81=1),(S39*R84*R91*S43/((1+S23/100)*(1+S42/100)))*(1-ABS(S84-R84*S43/((1+S23/100)*(1+S42/100)))/((S39*R84*R91*S43/((1+S23/100)*(1+S42/100)))+(R90*R84*S43/((1+S23/100)*(1+S42/100))))),0)))=IF(T84=0,0,IF(T80=1,T39*S84*S91*T43/((1+T23/100)*(1+T42/100)),IF(AND(T80=0,T81=1),(T39*S84*S91*T43/((1+T23/100)*(1+T42/100)))*(1-ABS(T84-S84*T43/((1+T23/100)*(1+T42/100)))/((T39*S84*S91*T43/((1+T23/100)*(1+T42/100)))+(S90*S84*T43/((1+T23/100)*(1+T42/100))))),0)))=IF(U84=0,0,IF(U80=1,U39*T84*T91*U43/((1+U23/100)*(1+U42/100)),IF(AND(U80=0,U81=1),(U39*T84*T91*U43/((1+U23/100)*(1+U42/100)))*(1-ABS(U84-T84*U43/((1+U23/100)*(1+U42/100)))/((U39*T84*T91*U43/((1+U23/100)*(1+U42/100)))+(T90*T84*U43/((1+U23/100)*(1+U42/100))))),0)))=IF(V84=0,0,IF(V80=1,V39*U84*U91*V43/((1+V23/100)*(1+V42/100)),IF(AND(V80=0,V81=1),(V39*U84*U91*V43/((1+V23/100)*(1+V42/100)))*(1-ABS(V84-U84*V43/((1+V23/100)*(1+V42/100)))/((V39*U84*U91*V43/((1+V23/100)*(1+V42/100)))+(U90*U84*V43/((1+V23/100)*(1+V42/100))))),0)))=IF(W84=0,0,IF(W80=1,W39*V84*V91*W43/((1+W23/100)*(1+W42/100)),IF(AND(W80=0,W81=1),(W39*V84*V91*W43/((1+W23/100)*(1+W42/100)))*(1-ABS(W84-V84*W43/((1+W23/100)*(1+W42/100)))/((W39*V84*V91*W43/((1+W23/100)*(1+W42/100)))+(V90*V84*W43/((1+W23/100)*(1+W42/100))))),0)))
Rolled over short-term debt='Input data'!C68*$D$84=IF(E84=0,0,IF(E80=1,(1-D91)*D84*E43/((1+E23/100)*(1+E42/100)),IF(AND(E80=0,E81=1),(D90*D84*E43/((1+E23/100)*(1+E42/100)))*(1-ABS(E84-D84*E43/((1+E23/100)*(1+E42/100)))/((E39*D84*D91*E43/((1+E23/100)*(1+E42/100)))+(D90*D84*E43/((1+E23/100)*(1+E42/100))))),0)))=IF(F84=0,0,IF(F80=1,(1-E91)*E84*F43/((1+F23/100)*(1+F42/100)),IF(AND(F80=0,F81=1),(E90*E84*F43/((1+F23/100)*(1+F42/100)))*(1-ABS(F84-E84*F43/((1+F23/100)*(1+F42/100)))/((F39*E84*E91*F43/((1+F23/100)*(1+F42/100)))+(E90*E84*F43/((1+F23/100)*(1+F42/100))))),0)))=IF(G84=0,0,IF(G80=1,(1-F91)*F84*G43/((1+G23/100)*(1+G42/100)),IF(AND(G80=0,G81=1),(F90*F84*G43/((1+G23/100)*(1+G42/100)))*(1-ABS(G84-F84*G43/((1+G23/100)*(1+G42/100)))/((G39*F84*F91*G43/((1+G23/100)*(1+G42/100)))+(F90*F84*G43/((1+G23/100)*(1+G42/100))))),0)))=IF(H84=0,0,IF(H80=1,(1-G91)*G84*H43/((1+H23/100)*(1+H42/100)),IF(AND(H80=0,H81=1),(G90*G84*H43/((1+H23/100)*(1+H42/100)))*(1-ABS(H84-G84*H43/((1+H23/100)*(1+H42/100)))/((H39*G84*G91*H43/((1+H23/100)*(1+H42/100)))+(G90*G84*H43/((1+H23/100)*(1+H42/100))))),0)))=IF(I84=0,0,IF(I80=1,(1-H91)*H84*I43/((1+I23/100)*(1+I42/100)),IF(AND(I80=0,I81=1),(H90*H84*I43/((1+I23/100)*(1+I42/100)))*(1-ABS(I84-H84*I43/((1+I23/100)*(1+I42/100)))/((I39*H84*H91*I43/((1+I23/100)*(1+I42/100)))+(H90*H84*I43/((1+I23/100)*(1+I42/100))))),0)))=IF(J84=0,0,IF(J80=1,(1-I91)*I84*J43/((1+J23/100)*(1+J42/100)),IF(AND(J80=0,J81=1),(I90*I84*J43/((1+J23/100)*(1+J42/100)))*(1-ABS(J84-I84*J43/((1+J23/100)*(1+J42/100)))/((J39*I84*I91*J43/((1+J23/100)*(1+J42/100)))+(I90*I84*J43/((1+J23/100)*(1+J42/100))))),0)))=IF(K84=0,0,IF(K80=1,(1-J91)*J84*K43/((1+K23/100)*(1+K42/100)),IF(AND(K80=0,K81=1),(J90*J84*K43/((1+K23/100)*(1+K42/100)))*(1-ABS(K84-J84*K43/((1+K23/100)*(1+K42/100)))/((K39*J84*J91*K43/((1+K23/100)*(1+K42/100)))+(J90*J84*K43/((1+K23/100)*(1+K42/100))))),0)))=IF(L84=0,0,IF(L80=1,(1-K91)*K84*L43/((1+L23/100)*(1+L42/100)),IF(AND(L80=0,L81=1),(K90*K84*L43/((1+L23/100)*(1+L42/100)))*(1-ABS(L84-K84*L43/((1+L23/100)*(1+L42/100)))/((L39*K84*K91*L43/((1+L23/100)*(1+L42/100)))+(K90*K84*L43/((1+L23/100)*(1+L42/100))))),0)))=IF(M84=0,0,IF(M80=1,(1-L91)*L84*M43/((1+M23/100)*(1+M42/100)),IF(AND(M80=0,M81=1),(L90*L84*M43/((1+M23/100)*(1+M42/100)))*(1-ABS(M84-L84*M43/((1+M23/100)*(1+M42/100)))/((M39*L84*L91*M43/((1+M23/100)*(1+M42/100)))+(L90*L84*M43/((1+M23/100)*(1+M42/100))))),0)))=IF(N84=0,0,IF(N80=1,(1-M91)*M84*N43/((1+N23/100)*(1+N42/100)),IF(AND(N80=0,N81=1),(M90*M84*N43/((1+N23/100)*(1+N42/100)))*(1-ABS(N84-M84*N43/((1+N23/100)*(1+N42/100)))/((N39*M84*M91*N43/((1+N23/100)*(1+N42/100)))+(M90*M84*N43/((1+N23/100)*(1+N42/100))))),0)))=IF(O84=0,0,IF(O80=1,(1-N91)*N84*O43/((1+O23/100)*(1+O42/100)),IF(AND(O80=0,O81=1),(N90*N84*O43/((1+O23/100)*(1+O42/100)))*(1-ABS(O84-N84*O43/((1+O23/100)*(1+O42/100)))/((O39*N84*N91*O43/((1+O23/100)*(1+O42/100)))+(N90*N84*O43/((1+O23/100)*(1+O42/100))))),0)))=IF(P84=0,0,IF(P80=1,(1-O91)*O84*P43/((1+P23/100)*(1+P42/100)),IF(AND(P80=0,P81=1),(O90*O84*P43/((1+P23/100)*(1+P42/100)))*(1-ABS(P84-O84*P43/((1+P23/100)*(1+P42/100)))/((P39*O84*O91*P43/((1+P23/100)*(1+P42/100)))+(O90*O84*P43/((1+P23/100)*(1+P42/100))))),0)))=IF(Q84=0,0,IF(Q80=1,(1-P91)*P84*Q43/((1+Q23/100)*(1+Q42/100)),IF(AND(Q80=0,Q81=1),(P90*P84*Q43/((1+Q23/100)*(1+Q42/100)))*(1-ABS(Q84-P84*Q43/((1+Q23/100)*(1+Q42/100)))/((Q39*P84*P91*Q43/((1+Q23/100)*(1+Q42/100)))+(P90*P84*Q43/((1+Q23/100)*(1+Q42/100))))),0)))=IF(R84=0,0,IF(R80=1,(1-Q91)*Q84*R43/((1+R23/100)*(1+R42/100)),IF(AND(R80=0,R81=1),(Q90*Q84*R43/((1+R23/100)*(1+R42/100)))*(1-ABS(R84-Q84*R43/((1+R23/100)*(1+R42/100)))/((R39*Q84*Q91*R43/((1+R23/100)*(1+R42/100)))+(Q90*Q84*R43/((1+R23/100)*(1+R42/100))))),0)))=IF(S84=0,0,IF(S80=1,(1-R91)*R84*S43/((1+S23/100)*(1+S42/100)),IF(AND(S80=0,S81=1),(R90*R84*S43/((1+S23/100)*(1+S42/100)))*(1-ABS(S84-R84*S43/((1+S23/100)*(1+S42/100)))/((S39*R84*R91*S43/((1+S23/100)*(1+S42/100)))+(R90*R84*S43/((1+S23/100)*(1+S42/100))))),0)))=IF(T84=0,0,IF(T80=1,(1-S91)*S84*T43/((1+T23/100)*(1+T42/100)),IF(AND(T80=0,T81=1),(S90*S84*T43/((1+T23/100)*(1+T42/100)))*(1-ABS(T84-S84*T43/((1+T23/100)*(1+T42/100)))/((T39*S84*S91*T43/((1+T23/100)*(1+T42/100)))+(S90*S84*T43/((1+T23/100)*(1+T42/100))))),0)))=IF(U84=0,0,IF(U80=1,(1-T91)*T84*U43/((1+U23/100)*(1+U42/100)),IF(AND(U80=0,U81=1),(T90*T84*U43/((1+U23/100)*(1+U42/100)))*(1-ABS(U84-T84*U43/((1+U23/100)*(1+U42/100)))/((U39*T84*T91*U43/((1+U23/100)*(1+U42/100)))+(T90*T84*U43/((1+U23/100)*(1+U42/100))))),0)))=IF(V84=0,0,IF(V80=1,(1-U91)*U84*V43/((1+V23/100)*(1+V42/100)),IF(AND(V80=0,V81=1),(U90*U84*V43/((1+V23/100)*(1+V42/100)))*(1-ABS(V84-U84*V43/((1+V23/100)*(1+V42/100)))/((V39*U84*U91*V43/((1+V23/100)*(1+V42/100)))+(U90*U84*V43/((1+V23/100)*(1+V42/100))))),0)))=IF(W84=0,0,IF(W80=1,(1-V91)*V84*W43/((1+W23/100)*(1+W42/100)),IF(AND(W80=0,W81=1),(V90*V84*W43/((1+W23/100)*(1+W42/100)))*(1-ABS(W84-V84*W43/((1+W23/100)*(1+W42/100)))/((W39*V84*V91*W43/((1+W23/100)*(1+W42/100)))+(V90*V84*W43/((1+W23/100)*(1+W42/100))))),0)))
New long-term debt='Input data'!C69*$D$84=IF(E84=0,0,IF(E80=1,'Input data'!$C$58*(E84-D84*E43/((1+E23/100)*(1+E42/100))),0))=IF(F84=0,0,IF(F80=1,'Input data'!$C$58*(F84-E84*F43/((1+F23/100)*(1+F42/100))),0))=IF(G84=0,0,IF(G80=1,'Input data'!$C$58*(G84-F84*G43/((1+G23/100)*(1+G42/100))),0))=IF(H84=0,0,IF(H80=1,'Input data'!$C$58*(H84-G84*H43/((1+H23/100)*(1+H42/100))),0))=IF(I84=0,0,IF(I80=1,'Input data'!$C$58*(I84-H84*I43/((1+I23/100)*(1+I42/100))),0))=IF(J84=0,0,IF(J80=1,'Input data'!$C$58*(J84-I84*J43/((1+J23/100)*(1+J42/100))),0))=IF(K84=0,0,IF(K80=1,'Input data'!$C$58*(K84-J84*K43/((1+K23/100)*(1+K42/100))),0))=IF(L84=0,0,IF(L80=1,'Input data'!$C$58*(L84-K84*L43/((1+L23/100)*(1+L42/100))),0))=IF(M84=0,0,IF(M80=1,'Input data'!$C$58*(M84-L84*M43/((1+M23/100)*(1+M42/100))),0))=IF(N84=0,0,IF(N80=1,'Input data'!$C$58*(N84-M84*N43/((1+N23/100)*(1+N42/100))),0))=IF(O84=0,0,IF(O80=1,'Input data'!$C$58*(O84-N84*O43/((1+O23/100)*(1+O42/100))),0))=IF(P84=0,0,IF(P80=1,'Input data'!$C$58*(P84-O84*P43/((1+P23/100)*(1+P42/100))),0))=IF(Q84=0,0,IF(Q80=1,'Input data'!$C$58*(Q84-P84*Q43/((1+Q23/100)*(1+Q42/100))),0))=IF(R84=0,0,IF(R80=1,'Input data'!$C$58*(R84-Q84*R43/((1+R23/100)*(1+R42/100))),0))=IF(S84=0,0,IF(S80=1,'Input data'!$C$58*(S84-R84*S43/((1+S23/100)*(1+S42/100))),0))=IF(T84=0,0,IF(T80=1,'Input data'!$C$58*(T84-S84*T43/((1+T23/100)*(1+T42/100))),0))=IF(U84=0,0,IF(U80=1,'Input data'!$C$58*(U84-T84*U43/((1+U23/100)*(1+U42/100))),0))=IF(V84=0,0,IF(V80=1,'Input data'!$C$58*(V84-U84*V43/((1+V23/100)*(1+V42/100))),0))=IF(W84=0,0,IF(W80=1,'Input data'!$C$58*(W84-V84*W43/((1+W23/100)*(1+W42/100))),0))
New short-term debt='Input data'!C70*$D$84=IF(E84=0,0,IF(E80=1,'Input data'!$C$57*(E84-D84*E43/((1+E23/100)*(1+E42/100))),0))=IF(F84=0,0,IF(F80=1,'Input data'!$C$57*(F84-E84*F43/((1+F23/100)*(1+F42/100))),0))=IF(G84=0,0,IF(G80=1,'Input data'!$C$57*(G84-F84*G43/((1+G23/100)*(1+G42/100))),0))=IF(H84=0,0,IF(H80=1,'Input data'!$C$57*(H84-G84*H43/((1+H23/100)*(1+H42/100))),0))=IF(I84=0,0,IF(I80=1,'Input data'!$C$57*(I84-H84*I43/((1+I23/100)*(1+I42/100))),0))=IF(J84=0,0,IF(J80=1,'Input data'!$C$57*(J84-I84*J43/((1+J23/100)*(1+J42/100))),0))=IF(K84=0,0,IF(K80=1,'Input data'!$C$57*(K84-J84*K43/((1+K23/100)*(1+K42/100))),0))=IF(L84=0,0,IF(L80=1,'Input data'!$C$57*(L84-K84*L43/((1+L23/100)*(1+L42/100))),0))=IF(M84=0,0,IF(M80=1,'Input data'!$C$57*(M84-L84*M43/((1+M23/100)*(1+M42/100))),0))=IF(N84=0,0,IF(N80=1,'Input data'!$C$57*(N84-M84*N43/((1+N23/100)*(1+N42/100))),0))=IF(O84=0,0,IF(O80=1,'Input data'!$C$57*(O84-N84*O43/((1+O23/100)*(1+O42/100))),0))=IF(P84=0,0,IF(P80=1,'Input data'!$C$57*(P84-O84*P43/((1+P23/100)*(1+P42/100))),0))=IF(Q84=0,0,IF(Q80=1,'Input data'!$C$57*(Q84-P84*Q43/((1+Q23/100)*(1+Q42/100))),0))=IF(R84=0,0,IF(R80=1,'Input data'!$C$57*(R84-Q84*R43/((1+R23/100)*(1+R42/100))),0))=IF(S84=0,0,IF(S80=1,'Input data'!$C$57*(S84-R84*S43/((1+S23/100)*(1+S42/100))),0))=IF(T84=0,0,IF(T80=1,'Input data'!$C$57*(T84-S84*T43/((1+T23/100)*(1+T42/100))),0))=IF(U84=0,0,IF(U80=1,'Input data'!$C$57*(U84-T84*U43/((1+U23/100)*(1+U42/100))),0))=IF(V84=0,0,IF(V80=1,'Input data'!$C$57*(V84-U84*V43/((1+V23/100)*(1+V42/100))),0))=IF(W84=0,0,IF(W80=1,'Input data'!$C$57*(W84-V84*W43/((1+W23/100)*(1+W42/100))),0))
Share of short-term debt in total government debt='Baseline NFPC'!$D$93=IF(E84<>0,(E87+E89)/(E85+E86+E87+E88+E89),0)=IF(F84<>0,(F87+F89)/(F85+F86+F87+F88+F89),0)=IF(G84<>0,(G87+G89)/(G85+G86+G87+G88+G89),0)=IF(H84<>0,(H87+H89)/(H85+H86+H87+H88+H89),0)=IF(I84<>0,(I87+I89)/(I85+I86+I87+I88+I89),0)=IF(J84<>0,(J87+J89)/(J85+J86+J87+J88+J89),0)=IF(K84<>0,(K87+K89)/(K85+K86+K87+K88+K89),0)=IF(L84<>0,(L87+L89)/(L85+L86+L87+L88+L89),0)=IF(M84<>0,(M87+M89)/(M85+M86+M87+M88+M89),0)=IF(N84<>0,(N87+N89)/(N85+N86+N87+N88+N89),0)=IF(O84<>0,(O87+O89)/(O85+O86+O87+O88+O89),0)=IF(P84<>0,(P87+P89)/(P85+P86+P87+P88+P89),0)=IF(Q84<>0,(Q87+Q89)/(Q85+Q86+Q87+Q88+Q89),0)=IF(R84<>0,(R87+R89)/(R85+R86+R87+R88+R89),0)=IF(S84<>0,(S87+S89)/(S85+S86+S87+S88+S89),0)=IF(T84<>0,(T87+T89)/(T85+T86+T87+T88+T89),0)=IF(U84<>0,(U87+U89)/(U85+U86+U87+U88+U89),0)=IF(V84<>0,(V87+V89)/(V85+V86+V87+V88+V89),0)=IF(W84<>0,(W87+W89)/(W85+W86+W87+W88+W89),0)
Share of long-term debt in total government debt='Baseline NFPC'!$D$94=IF(E84<>0,(E85+E86+E88)/(E85+E86+E87+E88+E89),1)=IF(F84<>0,(F85+F86+F88)/(F85+F86+F87+F88+F89),1)=IF(G84<>0,(G85+G86+G88)/(G85+G86+G87+G88+G89),1)=IF(H84<>0,(H85+H86+H88)/(H85+H86+H87+H88+H89),1)=IF(I84<>0,(I85+I86+I88)/(I85+I86+I87+I88+I89),1)=IF(J84<>0,(J85+J86+J88)/(J85+J86+J87+J88+J89),1)=IF(K84<>0,(K85+K86+K88)/(K85+K86+K87+K88+K89),1)=IF(L84<>0,(L85+L86+L88)/(L85+L86+L87+L88+L89),1)=IF(M84<>0,(M85+M86+M88)/(M85+M86+M87+M88+M89),1)=IF(N84<>0,(N85+N86+N88)/(N85+N86+N87+N88+N89),1)=IF(O84<>0,(O85+O86+O88)/(O85+O86+O87+O88+O89),1)=IF(P84<>0,(P85+P86+P88)/(P85+P86+P87+P88+P89),1)=IF(Q84<>0,(Q85+Q86+Q88)/(Q85+Q86+Q87+Q88+Q89),1)=IF(R84<>0,(R85+R86+R88)/(R85+R86+R87+R88+R89),1)=IF(S84<>0,(S85+S86+S88)/(S85+S86+S87+S88+S89),1)=IF(T84<>0,(T85+T86+T88)/(T85+T86+T87+T88+T89),1)=IF(U84<>0,(U85+U86+U88)/(U85+U86+U87+U88+U89),1)=IF(V84<>0,(V85+V86+V88)/(V85+V86+V87+V88+V89),1)=IF(W84<>0,(W85+W86+W88)/(W85+W86+W87+W88+W89),1)

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
IIR=C105=D105=E95+E96=F95+F96=G95+G96=H95+H96=I95+I96=J95+J96=K95+K96=L95+L96=M95+M96=N95+N96=O95+O96=P95+P96=Q95+Q96=R95+R96=S95+S96=T95+T96=U95+U96=V95+V96=W95+W96
Long-term implicit interest rate=((E36*D84)-(E38*(D87+D89)))/(D85+D86+D88)=((F36*E84)-(F38*(E87+E89)))/(E85+E86+E88)=((G36*F84)-(G38*(F87+F89)))/(F85+F86+F88)=IF(G84>0,(G94*G85+H37*(G88+G86))/(G85+G86+G88),H37)=IF(H84>0,(H94*H85+I37*(H88+H86))/(H85+H86+H88),I37)=IF(I84>0,(I94*I85+J37*(I88+I86))/(I85+I86+I88),J37)=IF(J84>0,(J94*J85+K37*(J88+J86))/(J85+J86+J88),K37)=IF(K84>0,(K94*K85+L37*(K88+K86))/(K85+K86+K88),L37)=IF(L84>0,(L94*L85+M37*(L88+L86))/(L85+L86+L88),M37)=IF(M84>0,(M94*M85+N37*(M88+M86))/(M85+M86+M88),N37)=IF(N84>0,(N94*N85+O37*(N88+N86))/(N85+N86+N88),O37)=IF(O84>0,(O94*O85+P37*(O88+O86))/(O85+O86+O88),P37)=IF(P84>0,(P94*P85+Q37*(P88+P86))/(P85+P86+P88),Q37)=IF(Q84>0,(Q94*Q85+R37*(Q88+Q86))/(Q85+Q86+Q88),R37)=IF(R84>0,(R94*R85+S37*(R88+R86))/(R85+R86+R88),S37)=IF(S84>0,(S94*S85+T37*(S88+S86))/(S85+S86+S88),T37)=IF(T84>0,(T94*T85+U37*(T88+T86))/(T85+T86+T88),U37)=IF(U84>0,(U94*U85+V37*(U88+U86))/(U85+U86+U88),V37)=IF(V84>0,(V94*V85+W37*(V88+V86))/(V85+V86+V88),W37)
Nominal implicit interest rate on debt (Excel approximation)=(E94*(D85+D86+D88)+E38*(D87+D89))/D84=(F94*(E85+E86+E88)+F38*(E87+E89))/E84=(G94*(F85+F86+F88)+G38*(F87+F89))/F84=(H94*(G85+G86+G88)+H38*(G87+G89))/G84=(I94*(H85+H86+H88)+I38*(H87+H89))/H84=(J94*(I85+I86+I88)+J38*(I87+I89))/I84=(K94*(J85+J86+J88)+K38*(J87+J89))/J84=(L94*(K85+K86+K88)+L38*(K87+K89))/K84=(M94*(L85+L86+L88)+M38*(L87+L89))/L84=(N94*(M85+M86+M88)+N38*(M87+M89))/M84=(O94*(N85+N86+N88)+O38*(N87+N89))/N84=(P94*(O85+O86+O88)+P38*(O87+O89))/O84=(Q94*(P85+P86+P88)+Q38*(P87+P89))/P84=(R94*(Q85+Q86+Q88)+R38*(Q87+Q89))/Q84=(S94*(R85+R86+R88)+S38*(R87+R89))/R84=(T94*(S85+S86+S88)+T38*(S87+S89))/S84=(U94*(T85+T86+T88)+U38*(T87+T89))/T84=(V94*(U85+U86+U88)+V38*(U87+U89))/U84=(W94*(V85+V86+V88)+W38*(V87+V89))/V84
Diff. STATA=IF('Criteria results'!$F$5=4,E106,E111)=IF('Criteria results'!$F$5=4,F106,F111)=IF('Criteria results'!$F$5=4,G106,G111)=IF('Criteria results'!$F$5=4,H106,H111)=IF('Criteria results'!$F$5=4,I106,I111)=IF('Criteria results'!$F$5=4,J106,J111)=IF('Criteria results'!$F$5=4,K106,K111)=IF('Criteria results'!$F$5=4,L106,L111)=IF('Criteria results'!$F$5=4,M106,M111)=IF('Criteria results'!$F$5=4,N106,N111)=IF('Criteria results'!$F$5=4,O106,O111)=IF('Criteria results'!$F$5=4,P106,P111)=IF('Criteria results'!$F$5=4,Q106,Q111)=IF('Criteria results'!$F$5=4,R106,R111)=IF('Criteria results'!$F$5=4,S106,S111)=IF('Criteria results'!$F$5=4,T106,T111)=IF('Criteria results'!$F$5=4,U106,U111)=IF('Criteria results'!$F$5=4,V106,V111)=IF('Criteria results'!$F$5=4,W106,W111)

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

	(i - g)	=((1+C93/100)/((1+C23/100)*(1+C42/100))-1)*100	=((1+D93/100)/((1+D23/100)*(1+D42/100))-1)*100	=((1+E93/100)/((1+E23/100)*(1+E42/100))-1)*100	=((1+F93/100)/((1+F23/100)*(1+F42/100))-1)*100	=((1+G93/100)/((1+G23/100)*(1+G42/100))-1)*100	=((1+H93/100)/((1+H23/100)*(1+H42/100))-1)*100	=((1+I93/100)/((1+I23/100)*(1+I42/100))-1)*100	=((1+J93/100)/((1+J23/100)*(1+J42/100))-1)*100	=((1+K93/100)/((1+K23/100)*(1+K42/100))-1)*100	=((1+L93/100)/((1+L23/100)*(1+L42/100))-1)*100	=((1+M93/100)/((1+M23/100)*(1+M42/100))-1)*100	=((1+N93/100)/((1+N23/100)*(1+N42/100))-1)*100	=((1+O93/100)/((1+O23/100)*(1+O42/100))-1)*100	=((1+P93/100)/((1+P23/100)*(1+P42/100))-1)*100	=((1+Q93/100)/((1+Q23/100)*(1+Q42/100))-1)*100	=((1+R93/100)/((1+R23/100)*(1+R42/100))-1)*100	=((1+S93/100)/((1+S23/100)*(1+S42/100))-1)*100	=((1+T93/100)/((1+T23/100)*(1+T42/100))-1)*100	=((1+U93/100)/((1+U23/100)*(1+U42/100))-1)*100	=((1+V93/100)/((1+V23/100)*(1+V42/100))-1)*100	=((1+W93/100)/((1+W23/100)*(1+W42/100))-1)*100																															
	Per memo - STATA results																																																				
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
No extension (annual adjustment of 1.22)
Debt48.46889877319347.48941802978548.80021286010750.91009140014653.26996231079154.56098937988354.97552108764654.44799804687553.68751907348652.87162780761751.94284439086951.56192016601651.3655967712451.37397384643651.51466369628951.71912002563552.05750656127952.56393432617253.25945281982454.1824913024955.275409698486
IIR3.46999526023863.59000682830814.82607746124274.53761100769044.18066883087164.64905929565435.00180673599245.27034235000615.56742525100715.80180168151866.00278377532966.1740269660956.32462882995616.4407582283026.52355575561526.57656240463266.60363054275516.6087479591376.59503650665286.56511974334726.521152973175
IIR difference STATA - Excel00000000000000000

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
Extension (annual adjustment of 0.74)
Debt48.46889877319347.48941802978548.80021286010750.91009140014653.46532058715855.41451644897556.95612716674858.0312080383358.56506347656258.55329895019557.96347045898457.32458496093856.72304916381856.17171859741256.06938934326256.03917694091856.1510047912656.43965148925856.92388153076257.6410713195858.528293609619
IIR3.46999526023863.59000682830814.82607746124274.53761100769044.18066883087164.66459083557135.04005861282355.33455181121835.56757068634035.75320339202885.9017591476446.11511659622196.27576589584356.39805412292486.48474121093756.54188346862796.57316398620616.58246278762826.57282114028936.54681634902956.5065712928772
IIR difference STATA - Excel00000000000000000

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

Stochastic

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 50
Country='Input data'!C3
Key years
='Input data'!B5=+'Input data'!C5
First year of stochastic projections=C5+'Criteria results'!F5+1
Last year of stochastic projections=C6+4

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 50
Baseline assumptions
202120222023202420252026202720282029203020312032203320342035203620372038203920402041
Gross debt ratio in the Adjust. no safeguard='Adjust. no safeguard'!C57='Adjust. no safeguard'!D57='Adjust. no safeguard'!E57='Adjust. no safeguard'!F57='Adjust. no safeguard'!G57='Adjust. no safeguard'!H57='Adjust. no safeguard'!I57='Adjust. no safeguard'!J57='Adjust. no safeguard'!K57='Adjust. no safeguard'!L57='Adjust. no safeguard'!M57='Adjust. no safeguard'!N57='Adjust. no safeguard'!O57='Adjust. no safeguard'!P57='Adjust. no safeguard'!Q57='Adjust. no safeguard'!R57='Adjust. no safeguard'!S57='Adjust. no safeguard'!T57='Adjust. no safeguard'!U57='Adjust. no safeguard'!V57='Adjust. no safeguard'!W57

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 50
Distribution of debt paths
p10=C$11=D$11=E$11=F$11=G$11=H$11=I$11=J$11=IF('Criteria results'!$F$5=4,K$11+'Input data'!C74,K$11)=IF('Criteria results'!$F$5=4,L$11+'Input data'!D74,L$11)=IF('Criteria results'!$F$5=4,M$11+'Input data'!E74,M$11)=IF('Criteria results'!$F$5=4,N$11+'Input data'!F74,N$11+'Input data'!C74)=IF('Criteria results'!$F$5=4,O$11+'Input data'!G74,O$11+'Input data'!D74)=IF('Criteria results'!$F$5=4,"",Stochastic!P$11+'Input data'!E74)=IF('Criteria results'!$F$5=4,"",Stochastic!Q$11+'Input data'!F74)=IF('Criteria results'!$F$5=4,"",Stochastic!R$11+'Input data'!G74)

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