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

Caută în documenteToate materialele sursei Deschide originalul extern ↗
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 51
(1.2) Cumulated budgetary effort (in terms of primary balance)00000000000000000000
(1.3) Cyclical component=-$C$48*D30=-$C$48*E30=-$C$48*F30=-$C$48*G30=-$C$48*H30=-$C$48*I30=-$C$48*J30=-$C$48*K30=-$C$48*L30=-$C$48*M30=-$C$48*N30=-$C$48*O30=-$C$48*P30=-$C$48*Q30=-$C$48*R30=-$C$48*S30=-$C$48*T30=-$C$48*U30=-$C$48*V30=-$C$48*W30
(1.4) One-off and other temporary measures=-D14=-E14=-F14=-G14=-H14=-I14=-J14=-K14=-L14=-M14=-N14=-O14=-P14=-Q14=-R14=-S14=-T14=-U14=-V14=-W14
(1.5) Cost of ageing=IF(D$56<=$C$6,0,HLOOKUP(D$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(E$56<=$C$6,0,HLOOKUP(E$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(F$56<=$C$6,0,HLOOKUP(F$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(G$56<=$C$6,0,HLOOKUP(G$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(H$56<=$C$6,0,HLOOKUP(H$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(I$56<=$C$6,0,HLOOKUP(I$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(J$56<=$C$6,0,HLOOKUP(J$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(K$56<=$C$6,0,HLOOKUP(K$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(L$56<=$C$6,0,HLOOKUP(L$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(M$56<=$C$6,0,HLOOKUP(M$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(N$56<=$C$6,0,HLOOKUP(N$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(O$56<=$C$6,0,HLOOKUP(O$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(P$56<=$C$6,0,HLOOKUP(P$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(Q$56<=$C$6,0,HLOOKUP(Q$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(R$56<=$C$6,0,HLOOKUP(R$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(S$56<=$C$6,0,HLOOKUP(S$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(T$56<=$C$6,0,HLOOKUP(T$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(U$56<=$C$6,0,HLOOKUP(U$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(V$56<=$C$6,0,HLOOKUP(V$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))=IF(W$56<=$C$6,0,HLOOKUP(W$56,'Input data'!$C$9:$BB$26,12,FALSE)-HLOOKUP($C$6,'Input data'!$C$9:$BB$26,12,FALSE))
(1.6) Property incomes=IF(D$56<=$C$5,0,-HLOOKUP(D$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(E$56<=$C$5,0,-HLOOKUP(E$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(F$56<=$C$5,0,-HLOOKUP(F$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(G$56<=$C$6,0,-HLOOKUP(G$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(H$56<=$C$6,0,-HLOOKUP(H$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(I$56<=$C$6,0,-HLOOKUP(I$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(J$56<=$C$6,0,-HLOOKUP(J$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(K$56<=$C$6,0,-HLOOKUP(K$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(L$56<=$C$6,0,-HLOOKUP(L$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(M$56<=$C$6,0,-HLOOKUP(M$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(N$56<=$C$6,0,-HLOOKUP(N$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(O$56<=$C$6,0,-HLOOKUP(O$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(P$56<=$C$6,0,-HLOOKUP(P$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(Q$56<=$C$6,0,-HLOOKUP(Q$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(R$56<=$C$6,0,-HLOOKUP(R$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(S$56<=$C$6,0,-HLOOKUP(S$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(T$56<=$C$6,0,-HLOOKUP(T$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(U$56<=$C$6,0,-HLOOKUP(U$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(V$56<=$C$6,0,-HLOOKUP(V$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))=IF(W$56<=$C$6,0,-HLOOKUP(W$56,'Input data'!$C$9:$BB$26,18,FALSE)+HLOOKUP($C$6,'Input data'!$C$9:$BB$26,18,FALSE))
(1.7) Revenues00000000000000000000
(2) Snowball effect (2.1 + 2.2 + 2.3)=SUM(D68:D71)=SUM(E68:E71)=SUM(F68:F71)=SUM(G68:G71)=SUM(H68:H71)=SUM(I68:I71)=SUM(J68:J71)=SUM(K68:K71)=SUM(L68:L71)=SUM(M68:M71)=SUM(N68:N71)=SUM(O68:O71)=SUM(P68:P71)=SUM(Q68:Q71)=SUM(R68:R71)=SUM(S68:S71)=SUM(T68:T71)=SUM(U68:U71)=SUM(V68:V71)=SUM(W68:W71)
(2.1) Interest expenditure=C57*D36/100*(1/(1+D33/100))=D57*E36/100*(1/(1+E33/100))=E57*F36/100*(1/(1+F33/100))=F57*G36/100*(1/(1+G33/100))=G57*H36/100*(1/(1+H33/100))=H57*I36/100*(1/(1+I33/100))=I57*J36/100*(1/(1+J33/100))=J57*K36/100*(1/(1+K33/100))=K57*L36/100*(1/(1+L33/100))=L57*M36/100*(1/(1+M33/100))=M57*N36/100*(1/(1+N33/100))=N57*O36/100*(1/(1+O33/100))=O57*P36/100*(1/(1+P33/100))=P57*Q36/100*(1/(1+Q33/100))=Q57*R36/100*(1/(1+R33/100))=R57*S36/100*(1/(1+S33/100))=S57*T36/100*(1/(1+T33/100))=T57*U36/100*(1/(1+U33/100))=U57*V36/100*(1/(1+V33/100))=V57*W36/100*(1/(1+W33/100))
(2.2) Growth effect=-C57*(D24/100)*(1/(1+D33/100))=-D57*(E24/100)*(1/(1+E33/100))=-E57*(F24/100)*(1/(1+F33/100))=-F57*(G24/100)*(1/(1+G33/100))=-G57*(H24/100)*(1/(1+H33/100))=-H57*(I24/100)*(1/(1+I33/100))=-I57*(J24/100)*(1/(1+J33/100))=-J57*(K24/100)*(1/(1+K33/100))=-K57*(L24/100)*(1/(1+L33/100))=-L57*(M24/100)*(1/(1+M33/100))=-M57*(N24/100)*(1/(1+N33/100))=-N57*(O24/100)*(1/(1+O33/100))=-O57*(P24/100)*(1/(1+P33/100))=-P57*(Q24/100)*(1/(1+Q33/100))=-Q57*(R24/100)*(1/(1+R33/100))=-R57*(S24/100)*(1/(1+S33/100))=-S57*(T24/100)*(1/(1+T33/100))=-T57*(U24/100)*(1/(1+U33/100))=-U57*(V24/100)*(1/(1+V33/100))=-V57*(W24/100)*(1/(1+W33/100))
(2.3) Inflation effect=-C57*D42/100*(1/(1+D42/100))=-D57*E42/100*(1/(1+E42/100))=-E57*F42/100*(1/(1+F42/100))=-F57*G42/100*(1/(1+G42/100))=-G57*H42/100*(1/(1+H42/100))=-H57*I42/100*(1/(1+I42/100))=-I57*J42/100*(1/(1+J42/100))=-J57*K42/100*(1/(1+K42/100))=-K57*L42/100*(1/(1+L42/100))=-L57*M42/100*(1/(1+M42/100))=-M57*N42/100*(1/(1+N42/100))=-N57*O42/100*(1/(1+O42/100))=-O57*P42/100*(1/(1+P42/100))=-P57*Q42/100*(1/(1+Q42/100))=-Q57*R42/100*(1/(1+R42/100))=-R57*S42/100*(1/(1+S42/100))=-S57*T42/100*(1/(1+T42/100))=-T57*U42/100*(1/(1+U42/100))=-U57*V42/100*(1/(1+V42/100))=-V57*W42/100*(1/(1+W42/100))
(2.4) Exchange rate effect linked to the interest rate='Baseline NFPC'!D70='Baseline NFPC'!E70='Baseline NFPC'!F70='Baseline NFPC'!G700000000000000000
(3 ) Stock flow adjustments (3.1 + 3.2)='Input data'!D16='Input data'!E16='Input data'!F16='Input data'!G16='Input data'!H16='Input data'!I16='Input data'!J16='Input data'!K16='Input data'!L16='Input data'!M16='Input data'!N16='Input data'!O16='Input data'!P16='Input data'!Q16='Input data'!R16='Input data'!S16='Input data'!T16='Input data'!U16='Input data'!V16='Input data'!W16
(3.1) Base=D15=E15=F15=G15=H15=I15=J15=K15=L15=M15=N15=O15=P15=Q15=R15=S15=T15=U15=V15=W15
(3.2) Adjustment due to the exchange rate effect linked to debt value=+D72-D73=+E72-E73=+F72-F73=+G72-G73=+H72-H73=+I72-I73=+J72-J73=+K72-K73=+L72-L73=+M72-M73=+N72-N73=+O72-O73=+P72-P73=+Q72-Q73=+R72-R73=+S72-S73=+T72-T73=+U72-U73=+V72-V73=+W72-W73

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

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 51
Other budgetary variables
Headline balance=D59-D68=E59-E68=F59-F68=G59-G68=H59-H68=I59-I68=J59-J68=K59-K68=L59-L68=M59-M68=N59-N68=O59-O68=P59-P68=Q59-Q68=R59-R68=S59-S68=T59-T68=U59-U68=V59-V68=W59-W68
Structural balance=D60-D68-D64-D65-D66=E60-E68-E64-E65-E66=F60-F68-F64-F65-F66=G60-G68-G64-G65-G66=H60-H68-H64-H65-H66=I60-I68-I64-I65-I66=J60-J68-J64-J65-J66=K60-K68-K64-K65-K66=L60-L68-L64-L65-L66=M60-M68-M64-M65-M66=N60-N68-N64-N65-N66=O60-O68-O64-O65-O66=P60-P68-P64-P65-P66=Q60-Q68-Q64-Q65-Q66=R60-R68-R64-R65-R66=S60-S68-S64-S65-S66=T60-T68-T64-T65-T66=U60-U68-U64-U65-U66=V60-V68-V64-V65-V66=W60-W68-W64-W65-W66
Net expenditure growth='Input data'!D45='Input data'!E45='Input data'!F45='Input data'!G33+G42-(G$12-F$12)/'Input data'!$C$64*100='Input data'!H33+H42-(H$12-G$12)/'Input data'!$C$64*100='Input data'!I33+I42-(I$12-H$12)/'Input data'!$C$64*100='Input data'!J33+J42-(J$12-I$12)/'Input data'!$C$64*100='Input data'!K33+K42-(K$12-J$12)/'Input data'!$C$64*100='Input data'!L33+L42-(L$12-K$12)/'Input data'!$C$64*100='Input data'!M33+M42-(M$12-L$12)/'Input data'!$C$64*100='Input data'!N33+N42-(N$12-M$12)/'Input data'!$C$64*100='Input data'!O33+O42-(O$12-N$12)/'Input data'!$C$64*100='Input data'!P33+P42-(P$12-O$12)/'Input data'!$C$64*100='Input data'!Q33+Q42-(Q$12-P$12)/'Input data'!$C$64*100='Input data'!R33+R42-(R$12-Q$12)/'Input data'!$C$64*100='Input data'!S33+S42-(S$12-R$12)/'Input data'!$C$64*100='Input data'!T33+T42-(T$12-S$12)/'Input data'!$C$64*100='Input data'!U33+U42-(U$12-T$12)/'Input data'!$C$64*100='Input data'!V33+V42-(V$12-U$12)/'Input data'!$C$64*100='Input data'!W33+W42-(W$12-V$12)/'Input data'!$C$64*100

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

	Average net primary expenditure growth		=AVERAGE(OFFSET($G$79,0,0,1,'Criteria results'!F5))																																															
	Debt decreasing? (For criterion 1)									=IF(K57<J57,0,1)	=IF(L57<K57,0,1)	=IF(M57<L57,0,1)	=IF(N57<M57,0,1)	=IF(O57<N57,0,1)	=IF(P57<O57,0,1)	=IF(Q57<P57,0,1)	=IF(R57<Q57,0,1)	=IF(S57<R57,0,1)	=IF(T57<S57,0,1)	=IF(U57<T57,0,1)	=IF(V57<U57,0,1)	=IF(W57<V57,0,1)																												
	Debt decomposition and IIR
Download
Coloana 1Coloana 2Coloana 3Coloana 4Coloana 5Coloana 6Coloana 7Coloana 8Coloana 9Coloana 10Coloana 11Coloana 12Coloana 13Coloana 14Coloana 15Coloana 16Coloana 17Coloana 18Coloana 19Coloana 20Coloana 21Coloana 22Coloana 23Coloana 24Coloana 25Coloana 26Coloana 27Coloana 28Coloana 29Coloana 30Coloana 31Coloana 32Coloana 33Coloana 34Coloana 35Coloana 36Coloana 37Coloana 38Coloana 39Coloana 40Coloana 41Coloana 42Coloana 43Coloana 44Coloana 45Coloana 46Coloana 47Coloana 48Coloana 49Coloana 50Coloana 51
Auxiliary variable identifying whether debt is increasing=IF((D92-C92*D43/((1+D24/100)*(1+D42/100)))>0,1,0)=IF((E92-D92*E43/((1+E24/100)*(1+E42/100)))>0,1,0)=IF((F92-E92*F43/((1+F24/100)*(1+F42/100)))>0,1,0)=IF((G92-F92*G43/((1+G24/100)*(1+G42/100)))>0,1,0)=IF((H92-G92*H43/((1+H24/100)*(1+H42/100)))>0,1,0)=IF((I92-H92*I43/((1+I24/100)*(1+I42/100)))>0,1,0)=IF((J92-I92*J43/((1+J24/100)*(1+J42/100)))>0,1,0)=IF((K92-J92*K43/((1+K24/100)*(1+K42/100)))>0,1,0)=IF((L92-K92*L43/((1+L24/100)*(1+L42/100)))>0,1,0)=IF((M92-L92*M43/((1+M24/100)*(1+M42/100)))>0,1,0)=IF((N92-M92*N43/((1+N24/100)*(1+N42/100)))>0,1,0)=IF((O92-N92*O43/((1+O24/100)*(1+O42/100)))>0,1,0)=IF((P92-O92*P43/((1+P24/100)*(1+P42/100)))>0,1,0)=IF((Q92-P92*Q43/((1+Q24/100)*(1+Q42/100)))>0,1,0)=IF((R92-Q92*R43/((1+R24/100)*(1+R42/100)))>0,1,0)=IF((S92-R92*S43/((1+S24/100)*(1+S42/100)))>0,1,0)=IF((T92-S92*T43/((1+T24/100)*(1+T42/100)))>0,1,0)=IF((U92-T92*U43/((1+U24/100)*(1+U42/100)))>0,1,0)=IF((V92-U92*V43/((1+V24/100)*(1+V42/100)))>0,1,0)=IF((W92-V92*W43/((1+W24/100)*(1+W42/100)))>0,1,0)
Auxiliary variable identifying whether some debt is rolled over even though debt is decreasing=IF(AND(D87=0,ABS(D92-C92*D43/((1+D24/100)*(1+D42/100)))<((C98*C92*D43/((1+D24/100)*(1+D42/100))+(D39*C92*C99*D43/((1+D24/100)*(1+D42/100)))))),1,0)=IF(AND(E87=0,ABS(E92-D92*E43/((1+E24/100)*(1+E42/100)))<((D98*D92*E43/((1+E24/100)*(1+E42/100))+(E39*D92*D99*E43/((1+E24/100)*(1+E42/100)))))),1,0)=IF(AND(F87=0,ABS(F92-E92*F43/((1+F24/100)*(1+F42/100)))<((E98*E92*F43/((1+F24/100)*(1+F42/100))+(F39*E92*E99*F43/((1+F24/100)*(1+F42/100)))))),1,0)=IF(AND(G87=0,ABS(G92-F92*G43/((1+G24/100)*(1+G42/100)))<((F98*F92*G43/((1+G24/100)*(1+G42/100))+(G39*F92*F99*G43/((1+G24/100)*(1+G42/100)))))),1,0)=IF(AND(H87=0,ABS(H92-G92*H43/((1+H24/100)*(1+H42/100)))<((G98*G92*H43/((1+H24/100)*(1+H42/100))+(H39*G92*G99*H43/((1+H24/100)*(1+H42/100)))))),1,0)=IF(AND(I87=0,ABS(I92-H92*I43/((1+I24/100)*(1+I42/100)))<((H98*H92*I43/((1+I24/100)*(1+I42/100))+(I39*H92*H99*I43/((1+I24/100)*(1+I42/100)))))),1,0)=IF(AND(J87=0,ABS(J92-I92*J43/((1+J24/100)*(1+J42/100)))<((I98*I92*J43/((1+J24/100)*(1+J42/100))+(J39*I92*I99*J43/((1+J24/100)*(1+J42/100)))))),1,0)=IF(AND(K87=0,ABS(K92-J92*K43/((1+K24/100)*(1+K42/100)))<((J98*J92*K43/((1+K24/100)*(1+K42/100))+(K39*J92*J99*K43/((1+K24/100)*(1+K42/100)))))),1,0)=IF(AND(L87=0,ABS(L92-K92*L43/((1+L24/100)*(1+L42/100)))<((K98*K92*L43/((1+L24/100)*(1+L42/100))+(L39*K92*K99*L43/((1+L24/100)*(1+L42/100)))))),1,0)=IF(AND(M87=0,ABS(M92-L92*M43/((1+M24/100)*(1+M42/100)))<((L98*L92*M43/((1+M24/100)*(1+M42/100))+(M39*L92*L99*M43/((1+M24/100)*(1+M42/100)))))),1,0)=IF(AND(N87=0,ABS(N92-M92*N43/((1+N24/100)*(1+N42/100)))<((M98*M92*N43/((1+N24/100)*(1+N42/100))+(N39*M92*M99*N43/((1+N24/100)*(1+N42/100)))))),1,0)=IF(AND(O87=0,ABS(O92-N92*O43/((1+O24/100)*(1+O42/100)))<((N98*N92*O43/((1+O24/100)*(1+O42/100))+(O39*N92*N99*O43/((1+O24/100)*(1+O42/100)))))),1,0)=IF(AND(P87=0,ABS(P92-O92*P43/((1+P24/100)*(1+P42/100)))<((O98*O92*P43/((1+P24/100)*(1+P42/100))+(P39*O92*O99*P43/((1+P24/100)*(1+P42/100)))))),1,0)=IF(AND(Q87=0,ABS(Q92-P92*Q43/((1+Q24/100)*(1+Q42/100)))<((P98*P92*Q43/((1+Q24/100)*(1+Q42/100))+(Q39*P92*P99*Q43/((1+Q24/100)*(1+Q42/100)))))),1,0)=IF(AND(R87=0,ABS(R92-Q92*R43/((1+R24/100)*(1+R42/100)))<((Q98*Q92*R43/((1+R24/100)*(1+R42/100))+(R39*Q92*Q99*R43/((1+R24/100)*(1+R42/100)))))),1,0)=IF(AND(S87=0,ABS(S92-R92*S43/((1+S24/100)*(1+S42/100)))<((R98*R92*S43/((1+S24/100)*(1+S42/100))+(S39*R92*R99*S43/((1+S24/100)*(1+S42/100)))))),1,0)=IF(AND(T87=0,ABS(T92-S92*T43/((1+T24/100)*(1+T42/100)))<((S98*S92*T43/((1+T24/100)*(1+T42/100))+(T39*S92*S99*T43/((1+T24/100)*(1+T42/100)))))),1,0)=IF(AND(U87=0,ABS(U92-T92*U43/((1+U24/100)*(1+U42/100)))<((T98*T92*U43/((1+U24/100)*(1+U42/100))+(U39*T92*T99*U43/((1+U24/100)*(1+U42/100)))))),1,0)=IF(AND(V87=0,ABS(V92-U92*V43/((1+V24/100)*(1+V42/100)))<((U98*U92*V43/((1+V24/100)*(1+V42/100))+(V39*U92*U99*V43/((1+V24/100)*(1+V42/100)))))),1,0)=IF(AND(W87=0,ABS(W92-V92*W43/((1+W24/100)*(1+W42/100)))<((V98*V92*W43/((1+W24/100)*(1+W42/100))+(W39*V92*V99*W43/((1+W24/100)*(1+W42/100)))))),1,0)

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

Download
Coloana 1Coloana 2Coloana 3Coloana 4Coloana 5Coloana 6Coloana 7Coloana 8Coloana 9Coloana 10Coloana 11Coloana 12Coloana 13Coloana 14Coloana 15Coloana 16Coloana 17Coloana 18Coloana 19Coloana 20Coloana 21Coloana 22Coloana 23Coloana 24Coloana 25Coloana 26Coloana 27Coloana 28Coloana 29Coloana 30Coloana 31Coloana 32Coloana 33Coloana 34Coloana 35Coloana 36Coloana 37Coloana 38Coloana 39Coloana 40Coloana 41Coloana 42Coloana 43Coloana 44Coloana 45Coloana 46Coloana 47Coloana 48Coloana 49Coloana 50Coloana 51
202120222023202420252026202720282029203020312032203320342035203620372038203920402041
Gross debt=C57=D57=E57=F57=G57=G92*(1+H106/100)*H43-H60-H61+H62+H63+H64+H65+H66+H72=H92*(1+I106/100)*I43-I60-I61+I62+I63+I64+I65+I66+I72=I92*(1+J106/100)*J43-J60-J61+J62+J63+J64+J65+J66+J72=J92*(1+K106/100)*K43-K60-K61+K62+K63+K64+K65+K66+K72=K92*(1+L106/100)*L43-L60-L61+L62+L63+L64+L65+L66+L72=L92*(1+M106/100)*M43-M60-M61+M62+M63+M64+M65+M66+M72=M92*(1+N106/100)*N43-N60-N61+N62+N63+N64+N65+N66+N72=N92*(1+O106/100)*O43-O60-O61+O62+O63+O64+O65+O66+O72=O92*(1+P106/100)*P43-P60-P61+P62+P63+P64+P65+P66+P72=P92*(1+Q106/100)*Q43-Q60-Q61+Q62+Q63+Q64+Q65+Q66+Q72=Q92*(1+R106/100)*R43-R60-R61+R62+R63+R64+R65+R66+R72=R92*(1+S106/100)*S43-S60-S61+S62+S63+S64+S65+S66+S72=S92*(1+T106/100)*T43-T60-T61+T62+T63+T64+T65+T66+T72=T92*(1+U106/100)*U43-U60-U61+U62+U63+U64+U65+U66+U72=U92*(1+V106/100)*V43-V60-V61+V62+V63+V64+V65+V66+V72=V92*(1+W106/100)*W43-W60-W61+W62+W63+W64+W65+W66+W72
Of which Outstanding debt='Input data'!C66*$D$92=IF(E92=0,0,IF(E87=1,D92*E43/((1+E24/100)*(1+E42/100))-E94-E95,IF(AND(E87=0,E88=1),(1-D98-E39*D99)*D92*E43/((1+E24/100)*(1+E42/100)),E92)))=IF(F92=0,0,IF(F87=1,E92*F43/((1+F24/100)*(1+F42/100))-F94-F95,IF(AND(F87=0,F88=1),(1-E98-F39*E99)*E92*F43/((1+F24/100)*(1+F42/100)),F92)))=IF(G92=0,0,IF(G87=1,F92*G43/((1+G24/100)*(1+G42/100))-G94-G95,IF(AND(G87=0,G88=1),(1-F98-G39*F99)*F92*G43/((1+G24/100)*(1+G42/100)),G92)))=IF(H92=0,0,IF(H87=1,G92*H43/((1+H24/100)*(1+H42/100))-H94-H95,IF(AND(H87=0,H88=1),(1-G98-H39*G99)*G92*H43/((1+H24/100)*(1+H42/100)),H92)))=IF(I92=0,0,IF(I87=1,H92*I43/((1+I24/100)*(1+I42/100))-I94-I95,IF(AND(I87=0,I88=1),(1-H98-I39*H99)*H92*I43/((1+I24/100)*(1+I42/100)),I92)))=IF(J92=0,0,IF(J87=1,I92*J43/((1+J24/100)*(1+J42/100))-J94-J95,IF(AND(J87=0,J88=1),(1-I98-J39*I99)*I92*J43/((1+J24/100)*(1+J42/100)),J92)))=IF(K92=0,0,IF(K87=1,J92*K43/((1+K24/100)*(1+K42/100))-K94-K95,IF(AND(K87=0,K88=1),(1-J98-K39*J99)*J92*K43/((1+K24/100)*(1+K42/100)),K92)))=IF(L92=0,0,IF(L87=1,K92*L43/((1+L24/100)*(1+L42/100))-L94-L95,IF(AND(L87=0,L88=1),(1-K98-L39*K99)*K92*L43/((1+L24/100)*(1+L42/100)),L92)))=IF(M92=0,0,IF(M87=1,L92*M43/((1+M24/100)*(1+M42/100))-M94-M95,IF(AND(M87=0,M88=1),(1-L98-M39*L99)*L92*M43/((1+M24/100)*(1+M42/100)),M92)))=IF(N92=0,0,IF(N87=1,M92*N43/((1+N24/100)*(1+N42/100))-N94-N95,IF(AND(N87=0,N88=1),(1-M98-N39*M99)*M92*N43/((1+N24/100)*(1+N42/100)),N92)))=IF(O92=0,0,IF(O87=1,N92*O43/((1+O24/100)*(1+O42/100))-O94-O95,IF(AND(O87=0,O88=1),(1-N98-O39*N99)*N92*O43/((1+O24/100)*(1+O42/100)),O92)))=IF(P92=0,0,IF(P87=1,O92*P43/((1+P24/100)*(1+P42/100))-P94-P95,IF(AND(P87=0,P88=1),(1-O98-P39*O99)*O92*P43/((1+P24/100)*(1+P42/100)),P92)))=IF(Q92=0,0,IF(Q87=1,P92*Q43/((1+Q24/100)*(1+Q42/100))-Q94-Q95,IF(AND(Q87=0,Q88=1),(1-P98-Q39*P99)*P92*Q43/((1+Q24/100)*(1+Q42/100)),Q92)))=IF(R92=0,0,IF(R87=1,Q92*R43/((1+R24/100)*(1+R42/100))-R94-R95,IF(AND(R87=0,R88=1),(1-Q98-R39*Q99)*Q92*R43/((1+R24/100)*(1+R42/100)),R92)))=IF(S92=0,0,IF(S87=1,R92*S43/((1+S24/100)*(1+S42/100))-S94-S95,IF(AND(S87=0,S88=1),(1-R98-S39*R99)*R92*S43/((1+S24/100)*(1+S42/100)),S92)))=IF(T92=0,0,IF(T87=1,S92*T43/((1+T24/100)*(1+T42/100))-T94-T95,IF(AND(T87=0,T88=1),(1-S98-T39*S99)*S92*T43/((1+T24/100)*(1+T42/100)),T92)))=IF(U92=0,0,IF(U87=1,T92*U43/((1+U24/100)*(1+U42/100))-U94-U95,IF(AND(U87=0,U88=1),(1-T98-U39*T99)*T92*U43/((1+U24/100)*(1+U42/100)),U92)))=IF(V92=0,0,IF(V87=1,U92*V43/((1+V24/100)*(1+V42/100))-V94-V95,IF(AND(V87=0,V88=1),(1-U98-V39*U99)*U92*V43/((1+V24/100)*(1+V42/100)),V92)))=IF(W92=0,0,IF(W87=1,V92*W43/((1+W24/100)*(1+W42/100))-W94-W95,IF(AND(W87=0,W88=1),(1-V98-W39*V99)*V92*W43/((1+W24/100)*(1+W42/100)),W92)))
Rolled over long-term debt='Input data'!C67*$D$92=IF(E92=0,0,IF(E87=1,E39*D92*D99*E43/((1+E24/100)*(1+E42/100)),IF(AND(E87=0,E88=1),(E39*D92*D99*E43/((1+E24/100)*(1+E42/100)))*(1-ABS(E92-D92*E43/((1+E24/100)*(1+E42/100)))/((E39*D92*D99*E43/((1+E24/100)*(1+E42/100)))+(D98*D92*E43/((1+E24/100)*(1+E42/100))))),0)))=IF(F92=0,0,IF(F87=1,F39*E92*E99*F43/((1+F24/100)*(1+F42/100)),IF(AND(F87=0,F88=1),(F39*E92*E99*F43/((1+F24/100)*(1+F42/100)))*(1-ABS(F92-E92*F43/((1+F24/100)*(1+F42/100)))/((F39*E92*E99*F43/((1+F24/100)*(1+F42/100)))+(E98*E92*F43/((1+F24/100)*(1+F42/100))))),0)))=IF(G92=0,0,IF(G87=1,G39*F92*F99*G43/((1+G24/100)*(1+G42/100)),IF(AND(G87=0,G88=1),(G39*F92*F99*G43/((1+G24/100)*(1+G42/100)))*(1-ABS(G92-F92*G43/((1+G24/100)*(1+G42/100)))/((G39*F92*F99*G43/((1+G24/100)*(1+G42/100)))+(F98*F92*G43/((1+G24/100)*(1+G42/100))))),0)))=IF(H92=0,0,IF(H87=1,H39*G92*G99*H43/((1+H24/100)*(1+H42/100)),IF(AND(H87=0,H88=1),(H39*G92*G99*H43/((1+H24/100)*(1+H42/100)))*(1-ABS(H92-G92*H43/((1+H24/100)*(1+H42/100)))/((H39*G92*G99*H43/((1+H24/100)*(1+H42/100)))+(G98*G92*H43/((1+H24/100)*(1+H42/100))))),0)))=IF(I92=0,0,IF(I87=1,I39*H92*H99*I43/((1+I24/100)*(1+I42/100)),IF(AND(I87=0,I88=1),(I39*H92*H99*I43/((1+I24/100)*(1+I42/100)))*(1-ABS(I92-H92*I43/((1+I24/100)*(1+I42/100)))/((I39*H92*H99*I43/((1+I24/100)*(1+I42/100)))+(H98*H92*I43/((1+I24/100)*(1+I42/100))))),0)))=IF(J92=0,0,IF(J87=1,J39*I92*I99*J43/((1+J24/100)*(1+J42/100)),IF(AND(J87=0,J88=1),(J39*I92*I99*J43/((1+J24/100)*(1+J42/100)))*(1-ABS(J92-I92*J43/((1+J24/100)*(1+J42/100)))/((J39*I92*I99*J43/((1+J24/100)*(1+J42/100)))+(I98*I92*J43/((1+J24/100)*(1+J42/100))))),0)))=IF(K92=0,0,IF(K87=1,K39*J92*J99*K43/((1+K24/100)*(1+K42/100)),IF(AND(K87=0,K88=1),(K39*J92*J99*K43/((1+K24/100)*(1+K42/100)))*(1-ABS(K92-J92*K43/((1+K24/100)*(1+K42/100)))/((K39*J92*J99*K43/((1+K24/100)*(1+K42/100)))+(J98*J92*K43/((1+K24/100)*(1+K42/100))))),0)))=IF(L92=0,0,IF(L87=1,L39*K92*K99*L43/((1+L24/100)*(1+L42/100)),IF(AND(L87=0,L88=1),(L39*K92*K99*L43/((1+L24/100)*(1+L42/100)))*(1-ABS(L92-K92*L43/((1+L24/100)*(1+L42/100)))/((L39*K92*K99*L43/((1+L24/100)*(1+L42/100)))+(K98*K92*L43/((1+L24/100)*(1+L42/100))))),0)))=IF(M92=0,0,IF(M87=1,M39*L92*L99*M43/((1+M24/100)*(1+M42/100)),IF(AND(M87=0,M88=1),(M39*L92*L99*M43/((1+M24/100)*(1+M42/100)))*(1-ABS(M92-L92*M43/((1+M24/100)*(1+M42/100)))/((M39*L92*L99*M43/((1+M24/100)*(1+M42/100)))+(L98*L92*M43/((1+M24/100)*(1+M42/100))))),0)))=IF(N92=0,0,IF(N87=1,N39*M92*M99*N43/((1+N24/100)*(1+N42/100)),IF(AND(N87=0,N88=1),(N39*M92*M99*N43/((1+N24/100)*(1+N42/100)))*(1-ABS(N92-M92*N43/((1+N24/100)*(1+N42/100)))/((N39*M92*M99*N43/((1+N24/100)*(1+N42/100)))+(M98*M92*N43/((1+N24/100)*(1+N42/100))))),0)))=IF(O92=0,0,IF(O87=1,O39*N92*N99*O43/((1+O24/100)*(1+O42/100)),IF(AND(O87=0,O88=1),(O39*N92*N99*O43/((1+O24/100)*(1+O42/100)))*(1-ABS(O92-N92*O43/((1+O24/100)*(1+O42/100)))/((O39*N92*N99*O43/((1+O24/100)*(1+O42/100)))+(N98*N92*O43/((1+O24/100)*(1+O42/100))))),0)))=IF(P92=0,0,IF(P87=1,P39*O92*O99*P43/((1+P24/100)*(1+P42/100)),IF(AND(P87=0,P88=1),(P39*O92*O99*P43/((1+P24/100)*(1+P42/100)))*(1-ABS(P92-O92*P43/((1+P24/100)*(1+P42/100)))/((P39*O92*O99*P43/((1+P24/100)*(1+P42/100)))+(O98*O92*P43/((1+P24/100)*(1+P42/100))))),0)))=IF(Q92=0,0,IF(Q87=1,Q39*P92*P99*Q43/((1+Q24/100)*(1+Q42/100)),IF(AND(Q87=0,Q88=1),(Q39*P92*P99*Q43/((1+Q24/100)*(1+Q42/100)))*(1-ABS(Q92-P92*Q43/((1+Q24/100)*(1+Q42/100)))/((Q39*P92*P99*Q43/((1+Q24/100)*(1+Q42/100)))+(P98*P92*Q43/((1+Q24/100)*(1+Q42/100))))),0)))=IF(R92=0,0,IF(R87=1,R39*Q92*Q99*R43/((1+R24/100)*(1+R42/100)),IF(AND(R87=0,R88=1),(R39*Q92*Q99*R43/((1+R24/100)*(1+R42/100)))*(1-ABS(R92-Q92*R43/((1+R24/100)*(1+R42/100)))/((R39*Q92*Q99*R43/((1+R24/100)*(1+R42/100)))+(Q98*Q92*R43/((1+R24/100)*(1+R42/100))))),0)))=IF(S92=0,0,IF(S87=1,S39*R92*R99*S43/((1+S24/100)*(1+S42/100)),IF(AND(S87=0,S88=1),(S39*R92*R99*S43/((1+S24/100)*(1+S42/100)))*(1-ABS(S92-R92*S43/((1+S24/100)*(1+S42/100)))/((S39*R92*R99*S43/((1+S24/100)*(1+S42/100)))+(R98*R92*S43/((1+S24/100)*(1+S42/100))))),0)))=IF(T92=0,0,IF(T87=1,T39*S92*S99*T43/((1+T24/100)*(1+T42/100)),IF(AND(T87=0,T88=1),(T39*S92*S99*T43/((1+T24/100)*(1+T42/100)))*(1-ABS(T92-S92*T43/((1+T24/100)*(1+T42/100)))/((T39*S92*S99*T43/((1+T24/100)*(1+T42/100)))+(S98*S92*T43/((1+T24/100)*(1+T42/100))))),0)))=IF(U92=0,0,IF(U87=1,U39*T92*T99*U43/((1+U24/100)*(1+U42/100)),IF(AND(U87=0,U88=1),(U39*T92*T99*U43/((1+U24/100)*(1+U42/100)))*(1-ABS(U92-T92*U43/((1+U24/100)*(1+U42/100)))/((U39*T92*T99*U43/((1+U24/100)*(1+U42/100)))+(T98*T92*U43/((1+U24/100)*(1+U42/100))))),0)))=IF(V92=0,0,IF(V87=1,V39*U92*U99*V43/((1+V24/100)*(1+V42/100)),IF(AND(V87=0,V88=1),(V39*U92*U99*V43/((1+V24/100)*(1+V42/100)))*(1-ABS(V92-U92*V43/((1+V24/100)*(1+V42/100)))/((V39*U92*U99*V43/((1+V24/100)*(1+V42/100)))+(U98*U92*V43/((1+V24/100)*(1+V42/100))))),0)))=IF(W92=0,0,IF(W87=1,W39*V92*V99*W43/((1+W24/100)*(1+W42/100)),IF(AND(W87=0,W88=1),(W39*V92*V99*W43/((1+W24/100)*(1+W42/100)))*(1-ABS(W92-V92*W43/((1+W24/100)*(1+W42/100)))/((W39*V92*V99*W43/((1+W24/100)*(1+W42/100)))+(V98*V92*W43/((1+W24/100)*(1+W42/100))))),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