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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031 | 2032 | 2033 | 2034 | 2035 | 2036 | 2037 | 2038 | 2039 | 2040 | 2041 | |||||||||||||||||||||||||||||||||
| Gross debt | =C56 | =D56 | =E56 | =F56 | =G56 | =G83*(1+H97/100)*H42-H59-H60+H61+H62+H63+H64+H65+H71 | =H83*(1+I97/100)*I42-I59-I60+I61+I62+I63+I64+I65+I71 | =I83*(1+J97/100)*J42-J59-J60+J61+J62+J63+J64+J65+J71 | =J83*(1+K97/100)*K42-K59-K60+K61+K62+K63+K64+K65+K71 | =K83*(1+L97/100)*L42-L59-L60+L61+L62+L63+L64+L65+L71 | =L83*(1+M97/100)*M42-M59-M60+M61+M62+M63+M64+M65+M71 | =M83*(1+N97/100)*N42-N59-N60+N61+N62+N63+N64+N65+N71 | =N83*(1+O97/100)*O42-O59-O60+O61+O62+O63+O64+O65+O71 | =O83*(1+P97/100)*P42-P59-P60+P61+P62+P63+P64+P65+P71 | =P83*(1+Q97/100)*Q42-Q59-Q60+Q61+Q62+Q63+Q64+Q65+Q71 | =Q83*(1+R97/100)*R42-R59-R60+R61+R62+R63+R64+R65+R71 | =R83*(1+S97/100)*S42-S59-S60+S61+S62+S63+S64+S65+S71 | =S83*(1+T97/100)*T42-T59-T60+T61+T62+T63+T64+T65+T71 | =T83*(1+U97/100)*U42-U59-U60+U61+U62+U63+U64+U65+U71 | =U83*(1+V97/100)*V42-V59-V60+V61+V62+V63+V64+V65+V71 | =V83*(1+W97/100)*W42-W59-W60+W61+W62+W63+W64+W65+W71 | ||||||||||||||||||||||||||||||||
| Of which Outstanding debt | ='Input data'!C66*$D$83 | =IF(E83=0,0,IF(E79=1,D83*E42/((1+E23/100)*(1+E41/100))-E85-E86,IF(AND(E79=0,E80=1),(1-D89-E38*D90)*D83*E42/((1+E23/100)*(1+E41/100)),E83))) | =IF(F83=0,0,IF(F79=1,E83*F42/((1+F23/100)*(1+F41/100))-F85-F86,IF(AND(F79=0,F80=1),(1-E89-F38*E90)*E83*F42/((1+F23/100)*(1+F41/100)),F83))) | =IF(G83=0,0,IF(G79=1,F83*G42/((1+G23/100)*(1+G41/100))-G85-G86,IF(AND(G79=0,G80=1),(1-F89-G38*F90)*F83*G42/((1+G23/100)*(1+G41/100)),G83))) | =IF(H83=0,0,IF(H79=1,G83*H42/((1+H23/100)*(1+H41/100))-H85-H86,IF(AND(H79=0,H80=1),(1-G89-H38*G90)*G83*H42/((1+H23/100)*(1+H41/100)),H83))) | =IF(I83=0,0,IF(I79=1,H83*I42/((1+I23/100)*(1+I41/100))-I85-I86,IF(AND(I79=0,I80=1),(1-H89-I38*H90)*H83*I42/((1+I23/100)*(1+I41/100)),I83))) | =IF(J83=0,0,IF(J79=1,I83*J42/((1+J23/100)*(1+J41/100))-J85-J86,IF(AND(J79=0,J80=1),(1-I89-J38*I90)*I83*J42/((1+J23/100)*(1+J41/100)),J83))) | =IF(K83=0,0,IF(K79=1,J83*K42/((1+K23/100)*(1+K41/100))-K85-K86,IF(AND(K79=0,K80=1),(1-J89-K38*J90)*J83*K42/((1+K23/100)*(1+K41/100)),K83))) | =IF(L83=0,0,IF(L79=1,K83*L42/((1+L23/100)*(1+L41/100))-L85-L86,IF(AND(L79=0,L80=1),(1-K89-L38*K90)*K83*L42/((1+L23/100)*(1+L41/100)),L83))) | =IF(M83=0,0,IF(M79=1,L83*M42/((1+M23/100)*(1+M41/100))-M85-M86,IF(AND(M79=0,M80=1),(1-L89-M38*L90)*L83*M42/((1+M23/100)*(1+M41/100)),M83))) | =IF(N83=0,0,IF(N79=1,M83*N42/((1+N23/100)*(1+N41/100))-N85-N86,IF(AND(N79=0,N80=1),(1-M89-N38*M90)*M83*N42/((1+N23/100)*(1+N41/100)),N83))) | =IF(O83=0,0,IF(O79=1,N83*O42/((1+O23/100)*(1+O41/100))-O85-O86,IF(AND(O79=0,O80=1),(1-N89-O38*N90)*N83*O42/((1+O23/100)*(1+O41/100)),O83))) | =IF(P83=0,0,IF(P79=1,O83*P42/((1+P23/100)*(1+P41/100))-P85-P86,IF(AND(P79=0,P80=1),(1-O89-P38*O90)*O83*P42/((1+P23/100)*(1+P41/100)),P83))) | =IF(Q83=0,0,IF(Q79=1,P83*Q42/((1+Q23/100)*(1+Q41/100))-Q85-Q86,IF(AND(Q79=0,Q80=1),(1-P89-Q38*P90)*P83*Q42/((1+Q23/100)*(1+Q41/100)),Q83))) | =IF(R83=0,0,IF(R79=1,Q83*R42/((1+R23/100)*(1+R41/100))-R85-R86,IF(AND(R79=0,R80=1),(1-Q89-R38*Q90)*Q83*R42/((1+R23/100)*(1+R41/100)),R83))) | =IF(S83=0,0,IF(S79=1,R83*S42/((1+S23/100)*(1+S41/100))-S85-S86,IF(AND(S79=0,S80=1),(1-R89-S38*R90)*R83*S42/((1+S23/100)*(1+S41/100)),S83))) | =IF(T83=0,0,IF(T79=1,S83*T42/((1+T23/100)*(1+T41/100))-T85-T86,IF(AND(T79=0,T80=1),(1-S89-T38*S90)*S83*T42/((1+T23/100)*(1+T41/100)),T83))) | =IF(U83=0,0,IF(U79=1,T83*U42/((1+U23/100)*(1+U41/100))-U85-U86,IF(AND(U79=0,U80=1),(1-T89-U38*T90)*T83*U42/((1+U23/100)*(1+U41/100)),U83))) | =IF(V83=0,0,IF(V79=1,U83*V42/((1+V23/100)*(1+V41/100))-V85-V86,IF(AND(V79=0,V80=1),(1-U89-V38*U90)*U83*V42/((1+V23/100)*(1+V41/100)),V83))) | =IF(W83=0,0,IF(W79=1,V83*W42/((1+W23/100)*(1+W41/100))-W85-W86,IF(AND(W79=0,W80=1),(1-V89-W38*V90)*V83*W42/((1+W23/100)*(1+W41/100)),W83))) | |||||||||||||||||||||||||||||||||
| Rolled over long-term debt | ='Input data'!C67*$D$83 | =IF(E83=0,0,IF(E79=1,E38*D83*D90*E42/((1+E23/100)*(1+E41/100)),IF(AND(E79=0,E80=1),(E38*D83*D90*E42/((1+E23/100)*(1+E41/100)))*(1-ABS(E83-D83*E42/((1+E23/100)*(1+E41/100)))/((E38*D83*D90*E42/((1+E23/100)*(1+E41/100)))+(D89*D83*E42/((1+E23/100)*(1+E41/100))))),0))) | =IF(F83=0,0,IF(F79=1,F38*E83*E90*F42/((1+F23/100)*(1+F41/100)),IF(AND(F79=0,F80=1),(F38*E83*E90*F42/((1+F23/100)*(1+F41/100)))*(1-ABS(F83-E83*F42/((1+F23/100)*(1+F41/100)))/((F38*E83*E90*F42/((1+F23/100)*(1+F41/100)))+(E89*E83*F42/((1+F23/100)*(1+F41/100))))),0))) | =IF(G83=0,0,IF(G79=1,G38*F83*F90*G42/((1+G23/100)*(1+G41/100)),IF(AND(G79=0,G80=1),(G38*F83*F90*G42/((1+G23/100)*(1+G41/100)))*(1-ABS(G83-F83*G42/((1+G23/100)*(1+G41/100)))/((G38*F83*F90*G42/((1+G23/100)*(1+G41/100)))+(F89*F83*G42/((1+G23/100)*(1+G41/100))))),0))) | =IF(H83=0,0,IF(H79=1,H38*G83*G90*H42/((1+H23/100)*(1+H41/100)),IF(AND(H79=0,H80=1),(H38*G83*G90*H42/((1+H23/100)*(1+H41/100)))*(1-ABS(H83-G83*H42/((1+H23/100)*(1+H41/100)))/((H38*G83*G90*H42/((1+H23/100)*(1+H41/100)))+(G89*G83*H42/((1+H23/100)*(1+H41/100))))),0))) | =IF(I83=0,0,IF(I79=1,I38*H83*H90*I42/((1+I23/100)*(1+I41/100)),IF(AND(I79=0,I80=1),(I38*H83*H90*I42/((1+I23/100)*(1+I41/100)))*(1-ABS(I83-H83*I42/((1+I23/100)*(1+I41/100)))/((I38*H83*H90*I42/((1+I23/100)*(1+I41/100)))+(H89*H83*I42/((1+I23/100)*(1+I41/100))))),0))) | =IF(J83=0,0,IF(J79=1,J38*I83*I90*J42/((1+J23/100)*(1+J41/100)),IF(AND(J79=0,J80=1),(J38*I83*I90*J42/((1+J23/100)*(1+J41/100)))*(1-ABS(J83-I83*J42/((1+J23/100)*(1+J41/100)))/((J38*I83*I90*J42/((1+J23/100)*(1+J41/100)))+(I89*I83*J42/((1+J23/100)*(1+J41/100))))),0))) | =IF(K83=0,0,IF(K79=1,K38*J83*J90*K42/((1+K23/100)*(1+K41/100)),IF(AND(K79=0,K80=1),(K38*J83*J90*K42/((1+K23/100)*(1+K41/100)))*(1-ABS(K83-J83*K42/((1+K23/100)*(1+K41/100)))/((K38*J83*J90*K42/((1+K23/100)*(1+K41/100)))+(J89*J83*K42/((1+K23/100)*(1+K41/100))))),0))) | =IF(L83=0,0,IF(L79=1,L38*K83*K90*L42/((1+L23/100)*(1+L41/100)),IF(AND(L79=0,L80=1),(L38*K83*K90*L42/((1+L23/100)*(1+L41/100)))*(1-ABS(L83-K83*L42/((1+L23/100)*(1+L41/100)))/((L38*K83*K90*L42/((1+L23/100)*(1+L41/100)))+(K89*K83*L42/((1+L23/100)*(1+L41/100))))),0))) | =IF(M83=0,0,IF(M79=1,M38*L83*L90*M42/((1+M23/100)*(1+M41/100)),IF(AND(M79=0,M80=1),(M38*L83*L90*M42/((1+M23/100)*(1+M41/100)))*(1-ABS(M83-L83*M42/((1+M23/100)*(1+M41/100)))/((M38*L83*L90*M42/((1+M23/100)*(1+M41/100)))+(L89*L83*M42/((1+M23/100)*(1+M41/100))))),0))) | =IF(N83=0,0,IF(N79=1,N38*M83*M90*N42/((1+N23/100)*(1+N41/100)),IF(AND(N79=0,N80=1),(N38*M83*M90*N42/((1+N23/100)*(1+N41/100)))*(1-ABS(N83-M83*N42/((1+N23/100)*(1+N41/100)))/((N38*M83*M90*N42/((1+N23/100)*(1+N41/100)))+(M89*M83*N42/((1+N23/100)*(1+N41/100))))),0))) | =IF(O83=0,0,IF(O79=1,O38*N83*N90*O42/((1+O23/100)*(1+O41/100)),IF(AND(O79=0,O80=1),(O38*N83*N90*O42/((1+O23/100)*(1+O41/100)))*(1-ABS(O83-N83*O42/((1+O23/100)*(1+O41/100)))/((O38*N83*N90*O42/((1+O23/100)*(1+O41/100)))+(N89*N83*O42/((1+O23/100)*(1+O41/100))))),0))) | =IF(P83=0,0,IF(P79=1,P38*O83*O90*P42/((1+P23/100)*(1+P41/100)),IF(AND(P79=0,P80=1),(P38*O83*O90*P42/((1+P23/100)*(1+P41/100)))*(1-ABS(P83-O83*P42/((1+P23/100)*(1+P41/100)))/((P38*O83*O90*P42/((1+P23/100)*(1+P41/100)))+(O89*O83*P42/((1+P23/100)*(1+P41/100))))),0))) | =IF(Q83=0,0,IF(Q79=1,Q38*P83*P90*Q42/((1+Q23/100)*(1+Q41/100)),IF(AND(Q79=0,Q80=1),(Q38*P83*P90*Q42/((1+Q23/100)*(1+Q41/100)))*(1-ABS(Q83-P83*Q42/((1+Q23/100)*(1+Q41/100)))/((Q38*P83*P90*Q42/((1+Q23/100)*(1+Q41/100)))+(P89*P83*Q42/((1+Q23/100)*(1+Q41/100))))),0))) | =IF(R83=0,0,IF(R79=1,R38*Q83*Q90*R42/((1+R23/100)*(1+R41/100)),IF(AND(R79=0,R80=1),(R38*Q83*Q90*R42/((1+R23/100)*(1+R41/100)))*(1-ABS(R83-Q83*R42/((1+R23/100)*(1+R41/100)))/((R38*Q83*Q90*R42/((1+R23/100)*(1+R41/100)))+(Q89*Q83*R42/((1+R23/100)*(1+R41/100))))),0))) | =IF(S83=0,0,IF(S79=1,S38*R83*R90*S42/((1+S23/100)*(1+S41/100)),IF(AND(S79=0,S80=1),(S38*R83*R90*S42/((1+S23/100)*(1+S41/100)))*(1-ABS(S83-R83*S42/((1+S23/100)*(1+S41/100)))/((S38*R83*R90*S42/((1+S23/100)*(1+S41/100)))+(R89*R83*S42/((1+S23/100)*(1+S41/100))))),0))) | =IF(T83=0,0,IF(T79=1,T38*S83*S90*T42/((1+T23/100)*(1+T41/100)),IF(AND(T79=0,T80=1),(T38*S83*S90*T42/((1+T23/100)*(1+T41/100)))*(1-ABS(T83-S83*T42/((1+T23/100)*(1+T41/100)))/((T38*S83*S90*T42/((1+T23/100)*(1+T41/100)))+(S89*S83*T42/((1+T23/100)*(1+T41/100))))),0))) | =IF(U83=0,0,IF(U79=1,U38*T83*T90*U42/((1+U23/100)*(1+U41/100)),IF(AND(U79=0,U80=1),(U38*T83*T90*U42/((1+U23/100)*(1+U41/100)))*(1-ABS(U83-T83*U42/((1+U23/100)*(1+U41/100)))/((U38*T83*T90*U42/((1+U23/100)*(1+U41/100)))+(T89*T83*U42/((1+U23/100)*(1+U41/100))))),0))) | =IF(V83=0,0,IF(V79=1,V38*U83*U90*V42/((1+V23/100)*(1+V41/100)),IF(AND(V79=0,V80=1),(V38*U83*U90*V42/((1+V23/100)*(1+V41/100)))*(1-ABS(V83-U83*V42/((1+V23/100)*(1+V41/100)))/((V38*U83*U90*V42/((1+V23/100)*(1+V41/100)))+(U89*U83*V42/((1+V23/100)*(1+V41/100))))),0))) | =IF(W83=0,0,IF(W79=1,W38*V83*V90*W42/((1+W23/100)*(1+W41/100)),IF(AND(W79=0,W80=1),(W38*V83*V90*W42/((1+W23/100)*(1+W41/100)))*(1-ABS(W83-V83*W42/((1+W23/100)*(1+W41/100)))/((W38*V83*V90*W42/((1+W23/100)*(1+W41/100)))+(V89*V83*W42/((1+W23/100)*(1+W41/100))))),0))) | |||||||||||||||||||||||||||||||||
| Rolled over short-term debt | ='Input data'!C68*$D$83 | =IF(E83=0,0,IF(E79=1,(1-D90)*D83*E42/((1+E23/100)*(1+E41/100)),IF(AND(E79=0,E80=1),(D89*D83*E42/((1+E23/100)*(1+E41/100)))*(1-ABS(E83-D83*E42/((1+E23/100)*(1+E41/100)))/((E38*D83*D90*E42/((1+E23/100)*(1+E41/100)))+(D89*D83*E42/((1+E23/100)*(1+E41/100))))),0))) | =IF(F83=0,0,IF(F79=1,(1-E90)*E83*F42/((1+F23/100)*(1+F41/100)),IF(AND(F79=0,F80=1),(E89*E83*F42/((1+F23/100)*(1+F41/100)))*(1-ABS(F83-E83*F42/((1+F23/100)*(1+F41/100)))/((F38*E83*E90*F42/((1+F23/100)*(1+F41/100)))+(E89*E83*F42/((1+F23/100)*(1+F41/100))))),0))) | =IF(G83=0,0,IF(G79=1,(1-F90)*F83*G42/((1+G23/100)*(1+G41/100)),IF(AND(G79=0,G80=1),(F89*F83*G42/((1+G23/100)*(1+G41/100)))*(1-ABS(G83-F83*G42/((1+G23/100)*(1+G41/100)))/((G38*F83*F90*G42/((1+G23/100)*(1+G41/100)))+(F89*F83*G42/((1+G23/100)*(1+G41/100))))),0))) | =IF(H83=0,0,IF(H79=1,(1-G90)*G83*H42/((1+H23/100)*(1+H41/100)),IF(AND(H79=0,H80=1),(G89*G83*H42/((1+H23/100)*(1+H41/100)))*(1-ABS(H83-G83*H42/((1+H23/100)*(1+H41/100)))/((H38*G83*G90*H42/((1+H23/100)*(1+H41/100)))+(G89*G83*H42/((1+H23/100)*(1+H41/100))))),0))) | =IF(I83=0,0,IF(I79=1,(1-H90)*H83*I42/((1+I23/100)*(1+I41/100)),IF(AND(I79=0,I80=1),(H89*H83*I42/((1+I23/100)*(1+I41/100)))*(1-ABS(I83-H83*I42/((1+I23/100)*(1+I41/100)))/((I38*H83*H90*I42/((1+I23/100)*(1+I41/100)))+(H89*H83*I42/((1+I23/100)*(1+I41/100))))),0))) | =IF(J83=0,0,IF(J79=1,(1-I90)*I83*J42/((1+J23/100)*(1+J41/100)),IF(AND(J79=0,J80=1),(I89*I83*J42/((1+J23/100)*(1+J41/100)))*(1-ABS(J83-I83*J42/((1+J23/100)*(1+J41/100)))/((J38*I83*I90*J42/((1+J23/100)*(1+J41/100)))+(I89*I83*J42/((1+J23/100)*(1+J41/100))))),0))) | =IF(K83=0,0,IF(K79=1,(1-J90)*J83*K42/((1+K23/100)*(1+K41/100)),IF(AND(K79=0,K80=1),(J89*J83*K42/((1+K23/100)*(1+K41/100)))*(1-ABS(K83-J83*K42/((1+K23/100)*(1+K41/100)))/((K38*J83*J90*K42/((1+K23/100)*(1+K41/100)))+(J89*J83*K42/((1+K23/100)*(1+K41/100))))),0))) | =IF(L83=0,0,IF(L79=1,(1-K90)*K83*L42/((1+L23/100)*(1+L41/100)),IF(AND(L79=0,L80=1),(K89*K83*L42/((1+L23/100)*(1+L41/100)))*(1-ABS(L83-K83*L42/((1+L23/100)*(1+L41/100)))/((L38*K83*K90*L42/((1+L23/100)*(1+L41/100)))+(K89*K83*L42/((1+L23/100)*(1+L41/100))))),0))) | =IF(M83=0,0,IF(M79=1,(1-L90)*L83*M42/((1+M23/100)*(1+M41/100)),IF(AND(M79=0,M80=1),(L89*L83*M42/((1+M23/100)*(1+M41/100)))*(1-ABS(M83-L83*M42/((1+M23/100)*(1+M41/100)))/((M38*L83*L90*M42/((1+M23/100)*(1+M41/100)))+(L89*L83*M42/((1+M23/100)*(1+M41/100))))),0))) | =IF(N83=0,0,IF(N79=1,(1-M90)*M83*N42/((1+N23/100)*(1+N41/100)),IF(AND(N79=0,N80=1),(M89*M83*N42/((1+N23/100)*(1+N41/100)))*(1-ABS(N83-M83*N42/((1+N23/100)*(1+N41/100)))/((N38*M83*M90*N42/((1+N23/100)*(1+N41/100)))+(M89*M83*N42/((1+N23/100)*(1+N41/100))))),0))) | =IF(O83=0,0,IF(O79=1,(1-N90)*N83*O42/((1+O23/100)*(1+O41/100)),IF(AND(O79=0,O80=1),(N89*N83*O42/((1+O23/100)*(1+O41/100)))*(1-ABS(O83-N83*O42/((1+O23/100)*(1+O41/100)))/((O38*N83*N90*O42/((1+O23/100)*(1+O41/100)))+(N89*N83*O42/((1+O23/100)*(1+O41/100))))),0))) | =IF(P83=0,0,IF(P79=1,(1-O90)*O83*P42/((1+P23/100)*(1+P41/100)),IF(AND(P79=0,P80=1),(O89*O83*P42/((1+P23/100)*(1+P41/100)))*(1-ABS(P83-O83*P42/((1+P23/100)*(1+P41/100)))/((P38*O83*O90*P42/((1+P23/100)*(1+P41/100)))+(O89*O83*P42/((1+P23/100)*(1+P41/100))))),0))) | =IF(Q83=0,0,IF(Q79=1,(1-P90)*P83*Q42/((1+Q23/100)*(1+Q41/100)),IF(AND(Q79=0,Q80=1),(P89*P83*Q42/((1+Q23/100)*(1+Q41/100)))*(1-ABS(Q83-P83*Q42/((1+Q23/100)*(1+Q41/100)))/((Q38*P83*P90*Q42/((1+Q23/100)*(1+Q41/100)))+(P89*P83*Q42/((1+Q23/100)*(1+Q41/100))))),0))) | =IF(R83=0,0,IF(R79=1,(1-Q90)*Q83*R42/((1+R23/100)*(1+R41/100)),IF(AND(R79=0,R80=1),(Q89*Q83*R42/((1+R23/100)*(1+R41/100)))*(1-ABS(R83-Q83*R42/((1+R23/100)*(1+R41/100)))/((R38*Q83*Q90*R42/((1+R23/100)*(1+R41/100)))+(Q89*Q83*R42/((1+R23/100)*(1+R41/100))))),0))) | =IF(S83=0,0,IF(S79=1,(1-R90)*R83*S42/((1+S23/100)*(1+S41/100)),IF(AND(S79=0,S80=1),(R89*R83*S42/((1+S23/100)*(1+S41/100)))*(1-ABS(S83-R83*S42/((1+S23/100)*(1+S41/100)))/((S38*R83*R90*S42/((1+S23/100)*(1+S41/100)))+(R89*R83*S42/((1+S23/100)*(1+S41/100))))),0))) | =IF(T83=0,0,IF(T79=1,(1-S90)*S83*T42/((1+T23/100)*(1+T41/100)),IF(AND(T79=0,T80=1),(S89*S83*T42/((1+T23/100)*(1+T41/100)))*(1-ABS(T83-S83*T42/((1+T23/100)*(1+T41/100)))/((T38*S83*S90*T42/((1+T23/100)*(1+T41/100)))+(S89*S83*T42/((1+T23/100)*(1+T41/100))))),0))) | =IF(U83=0,0,IF(U79=1,(1-T90)*T83*U42/((1+U23/100)*(1+U41/100)),IF(AND(U79=0,U80=1),(T89*T83*U42/((1+U23/100)*(1+U41/100)))*(1-ABS(U83-T83*U42/((1+U23/100)*(1+U41/100)))/((U38*T83*T90*U42/((1+U23/100)*(1+U41/100)))+(T89*T83*U42/((1+U23/100)*(1+U41/100))))),0))) | =IF(V83=0,0,IF(V79=1,(1-U90)*U83*V42/((1+V23/100)*(1+V41/100)),IF(AND(V79=0,V80=1),(U89*U83*V42/((1+V23/100)*(1+V41/100)))*(1-ABS(V83-U83*V42/((1+V23/100)*(1+V41/100)))/((V38*U83*U90*V42/((1+V23/100)*(1+V41/100)))+(U89*U83*V42/((1+V23/100)*(1+V41/100))))),0))) | =IF(W83=0,0,IF(W79=1,(1-V90)*V83*W42/((1+W23/100)*(1+W41/100)),IF(AND(W79=0,W80=1),(V89*V83*W42/((1+W23/100)*(1+W41/100)))*(1-ABS(W83-V83*W42/((1+W23/100)*(1+W41/100)))/((W38*V83*V90*W42/((1+W23/100)*(1+W41/100)))+(V89*V83*W42/((1+W23/100)*(1+W41/100))))),0))) | |||||||||||||||||||||||||||||||||
| 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,E104,E109) | =IF('Criteria results'!$F$5=4,F104,F109) | =IF('Criteria results'!$F$5=4,G104,G109) | =IF('Criteria results'!$F$5=4,H104,H109) | =IF('Criteria results'!$F$5=4,I104,I109) | =IF('Criteria results'!$F$5=4,J104,J109) | =IF('Criteria results'!$F$5=4,K104,K109) | =IF('Criteria results'!$F$5=4,L104,L109) | =IF('Criteria results'!$F$5=4,M104,M109) | =IF('Criteria results'!$F$5=4,N104,N109) | =IF('Criteria results'!$F$5=4,O104,O109) | =IF('Criteria results'!$F$5=4,P104,P109) | =IF('Criteria results'!$F$5=4,Q104,Q109) | =IF('Criteria results'!$F$5=4,R104,R109) | =IF('Criteria results'!$F$5=4,S104,S109) | =IF('Criteria results'!$F$5=4,T104,T109) | =IF('Criteria results'!$F$5=4,U104,U109) | =IF('Criteria results'!$F$5=4,V104,V109) | =IF('Criteria results'!$F$5=4,W104,W109) |
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.471134185791 | 52.380870819092 | 51.152339935303 | 50.442733764648 | 49.893573760986 | 49.525650024414 | 49.267127990723 | 49.050266265869 | 48.945083618164 | 48.983253479004 | 49.185031890869 | 49.586513519287 | 50.133483886719 | ||||||||||||||||||||||||||||||||
| IIR | 3.4699952602386 | 3.5900068283081 | 4.8260774612427 | 4.5376110076904 | 4.1806688308716 | 4.6490592956543 | 5.0018067359924 | 5.2703423500061 | 5.6591782569885 | 5.7662477493286 | 5.9023404121399 | 6.0174207687378 | 6.1180448532104 | 6.1900534629822 | 6.2349033355713 | 6.2557210922241 | 6.2558107376099 | 6.2382664680481 | 6.2055768966675 | 6.1597561836243 | 6.1024270057678 | ||||||||||||||||||||||||||||||||
| 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.
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