{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Prognoza veniturilor","Prognoza cheltuielilor"," Cpp","Bilant","FN An 1 I","FN An 2 I ","FN An 3 I ","FN An 1-5","Indicatori"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":50,"comments":8,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Prognoza veniturilor","index":0,"n_rows":44,"n_cols":17,"rows_kept":44,"cut":false,"hidden":false,"merged":[[4,0,4,15],[7,0,7,15],[20,0,20,15],[0,0,0,14],[0,15,2,16],[1,0,2,14],[3,0,3,16],[5,16,6,16],[43,0,43,1],[33,0,33,1],[35,0,35,1],[5,15,6,15],[5,13,6,13],[5,4,5,7],[5,8,5,11],[5,12,6,12],[5,14,6,14]]}
["MINISTERUL AGRICULTURII SI DEZVOLTARII RURALE",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Anexa B1"]
["AGENTIA PENTRU FINANTAREA INVESTITIILOR RURALE"]
[]
[]
["  Prognoza veniturilor si evolutia capacitatii de productie-varianta cu proiect"]
[null,null,null,null,"Anul 1",null,null,null,"Anul 2",null,null,null,"Total                             An 1","Total                             An 2","Total                              An 3","Total                              An 4","Total                              An 5"]
["Nr. Crt.","Categoria","Pret in LEI/UM","UM","TRIM I ","TRIM II ","TRIM III ","TRIM IV ","TRIM I ","TRIM II ","TRIM III ","TRIM IV "]
["Vanzari fizice previzionate"]
[1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E9:H9)","v":0},{"$f":"SUM(I9:L9)","v":0}]
[2,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E10:H10)","v":0},{"$f":"SUM(I10:L10)","v":0}]
[3,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:H11)","v":0},0]
[4,null,null,null,null,null,null,null,null,null,null,null,0,0]
[5,null,null,null,null,null,null,null,null,null,null,null,0,0]
[6,null,null,null,null,null,null,null,null,null,null,null,0,0]
[7,null,null,null,null,null,null,null,null,null,null,null,0,0]
[8,null,null,null,null,null,null,null,null,null,null,null,0,0]
[9,null,null,null,null,null,null,null,null,null,null,null,0,0]
[10,null,null,null,null,null,null,null,null,null,null,null,0,0]
[11,null,null,null,null,null,null,null,null,null,null,null,0,0]
[12,null,null,null,null,null,null,null,null,null,null,null,0,0]
["Vanzari valorice previzionate"]
[1,{"$f":"B9","v":0},{"$f":"C9","v":0},"LEI",{"$f":"C9*E9","v":0},{"$f":"C9*F9","v":0},{"$f":"C9*G9","v":0},{"$f":"C9*H9","v":0},{"$f":"C9*I9","v":0},{"$f":"C9*J9","v":0},{"$f":"C9*K9","v":0},{"$f":"C9*L9","v":0},{"$f":"SUM(E22:H22)","v":0},{"$f":"SUM(I22:L22)","v":0},{"$f":"SUM($C$9*O9)","v":0},{"$f":"SUM($C$9*P9)","v":0},{"$f":"SUM($C$9*Q9)","v":0}]
[2,{"$f":"B10","v":0},{"$f":"C10","v":0},"LEI",{"$f":"C10*E10","v":0},{"$f":"C10*F10","v":0},{"$f":"C10*G10","v":0},{"$f":"C10*H10","v":0},{"$f":"C10*I10","v":0},{"$f":"C10*J10","v":0},{"$f":"C10*K10","v":0},{"$f":"C10*L10","v":0},{"$f":"SUM(E23:H23)","v":0},{"$f":"SUM(I23:L23)","v":0},{"$f":"SUM($C$10*O10)","v":0},{"$f":"SUM($C$10*P10)","v":0},{"$f":"SUM($C$10*Q10)","v":0}]
[3,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$11*O11)","v":0},{"$f":"SUM($C$11*P11)","v":0},{"$f":"SUM($C$11*Q11)","v":0}]
[4,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$12*O12)","v":0},{"$f":"SUM($C$12*P12)","v":0},{"$f":"SUM($C$12*Q12)","v":0}]
[5,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$13*O13)","v":0},{"$f":"SUM($C$13*P13)","v":0},{"$f":"SUM($C$13*Q13)","v":0}]
[6,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$14*O14)","v":0},{"$f":"SUM($C$14*P14)","v":0},{"$f":"SUM($C$14*Q14)","v":0}]
[7,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$15*O15)","v":0},{"$f":"SUM($C$15*P15)","v":0},{"$f":"SUM($C$15*Q15)","v":0}]
[8,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$16*O16)","v":0},{"$f":"SUM($C$16*P16)","v":0},{"$f":"SUM($C$16*Q16)","v":0}]
[9,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$17*O17)","v":0},{"$f":"SUM($C$17*P17)","v":0},{"$f":"SUM($C$17*Q17)","v":0}]
[10,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$18*O18)","v":0},{"$f":"SUM($C$18*P18)","v":0},{"$f":"SUM($C$18*Q18)","v":0}]
[11,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$19*O19)","v":0},{"$f":"SUM($C$19*P19)","v":0},{"$f":"SUM($C$19*Q19)","v":0}]
[12,0,0,"LEI",0,0,0,0,0,0,0,0,0,0,{"$f":"SUM($C$20*O20)","v":0},{"$f":"SUM($C$20*P20)","v":0},{"$f":"SUM($C$20*Q20)","v":0}]
["Venituri productie proprie – total",null,null,"LEI",{"$f":"SUM(E22+E23+E24+E25+E26+E27+E28+E29+E30+E31+E32+E33)","v":0},{"$f":"SUM(F22+F23+F24+F25+F26+F27+F28+F29+F30+F31+F32+F33)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(O22+O23+O24+O25+O26+O27+O28+O29+O30+O31+O32+O33)","v":0},0,0]
[13,"Alte venituri",null,"LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E35:H35)","v":0},{"$f":"SUM(I35:L35)","v":0}]
["Total productie vanduta",null,null,"LEI",{"$f":"SUM(E34+E35)","v":0},{"$f":"SUM(F34+F35)","v":0},0,0,0,0,0,0,{"$f":"SUM(M34+M35)","v":0},0,0,0,0]
[14,"Venituri din vanzari marfuri",null,"LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E37:H37)","v":0},{"$f":"SUM(I37:L37)","v":0}]
[15,"Venituri din subventii de exploatare aferente cifrei de afaceri nete",null,"LEI",null,null,null,null,null,null,null,null,0,0]
[16,"Venituri din subventii pentru investitii ",null,"LEI",null,null,null,null,null,null,null,null,0,0]
[17,"Venituri din alte activitati",null,"LEI",null,null,null,null,null,null,null,null,0,0]
[18,"Variatia stocurilor (+ pentru C; - pentru D)",null,"LEI",null,null,null,null,null,null,null,null,0,0]
[19,"Venituri din productia realizata pentru scopuri proprii si capitalizata",null,"LEI",null,null,null,null,null,null,null,null,0,0]
[20,"Alte venituri din exploatare",null,"LEI",null,null,null,null,null,null,null,null,0,0]
["Total venituri din exploatare",null,null,"LEI",{"$f":"SUM(E36:E43)","v":0},{"$f":"SUM(F36:F43)","v":0},0,0,0,0,0,{"$f":"SUM(L36:L43)","v":0},0,{"$f":"SUM(N36:N43)","v":0},0,0,0]

{"sheet":"Prognoza cheltuielilor","index":1,"n_rows":18,"n_cols":17,"rows_kept":18,"cut":false,"hidden":false,"merged":[[5,15,6,15],[5,16,6,16],[0,1,0,14],[0,15,2,16],[1,1,2,14],[3,1,3,16],[4,1,4,16],[5,4,5,7],[5,8,5,11],[5,12,6,12],[5,13,6,13],[5,14,6,14]]}
[null,"MINISTERUL AGRICULTURII SI DEZVOLTARII RURALE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anexa B2"]
[null,"AGENTIA PENTRU FINANTAREA INVESTITIILOR RURALE"]
[]
[]
[null,"  Prognoza cheltuielilor si evolutia capacitatii de productie-varianta cu proiect"]
[null,null,null,null,"Anul 1",null,null,null,"Anul 2",null,null,null,"Total                            An 1","Total                                An 2","Total                             An 3","Total                              An 4","Total                             An 5"]
[null,"Nr. Crt.","Categoria","UM","TRIM I ","TRIM II ","TRIM III ","TRIM IV ","TRIM I ","TRIM II ","TRIM III ","TRIM IV "]
[null,1,"Cheltuieli cu materiile prime si cu materialele consumabile","LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E8:H8)","v":0},{"$f":"SUM(I8:L8)","v":0}]
[null,2,"Alte cheltuieli materiale","LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E9:H9)","v":0},{"$f":"SUM(I9:L9)","v":0}]
[null,3,"Alte cheltuieli din afara (cu energia si apa)","LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E10:H10)","v":0},{"$f":"SUM(I10:L10)","v":0}]
[null,4,"Cheltuieli privind marfurile ","LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E11:H11)","v":0},{"$f":"SUM(I11:L11)","v":0}]
[null,5,"Cheltuieli materiale – total","LEI",{"$f":"SUM(E8:E11)","v":0},{"$f":"SUM(F8:F11)","v":0},0,0,0,0,0,0,{"$f":"SUM(M8:M11)","v":0},{"$f":"SUM(N8:N11)","v":0},{"$f":"SUM(O8:O11)","v":0},{"$f":"SUM(P8:P11)","v":0},{"$f":"SUM(Q8:Q11)","v":0}]
[null,6,"Cheltuieli cu personalul angajat","LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E13:H13)","v":0},{"$f":"SUM(I13:L13)","v":0}]
[null,7,"Cheltuieli cu asigurarile si protectia sociala","LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E14:H14)","v":0},{"$f":"SUM(I14:L14)","v":0}]
[null,8,"Cheltuieli cu personalul – total","LEI",{"$f":"SUM(E13:E14)","v":0},{"$f":"SUM(F13:F14)","v":0},0,{"$f":"SUM(H13:H14)","v":0},0,0,0,0,{"$f":"SUM(M13:M14)","v":0},{"$f":"SUM(N13:N14)","v":0},{"$f":"SUM(O13:O14)","v":0},{"$f":"SUM(P13:P14)","v":0},{"$f":"SUM(Q13:Q14)","v":0}]
[null,9,"Cheltuieli cu amortizarile","LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E16:H16)","v":0},{"$f":"SUM(I16:L16)","v":0}]
[null,10,"Alte cheltuieli de exploatare","LEI",null,null,null,null,null,null,null,null,{"$f":"SUM(E17:H17)","v":0},{"$f":"SUM(I17:L17)","v":0}]
[null,11,"Cheltuieli pentru exploatare - total","LEI",{"$f":"SUM(E12+E15+E17+E16)","v":0},{"$f":"SUM(F12+F15+F17+F16)","v":0},0,0,0,0,0,0,{"$f":"SUM(M12+M15+M17+M16)","v":0},{"$f":"SUM(N12+N15+N17+N16)","v":0},{"$f":"SUM(O12+O15+O17+O16)","v":0},{"$f":"SUM(P12+P15+P17+P16)","v":0},{"$f":"SUM(Q12+Q15+Q17+Q16)","v":0}]

{"sheet":" Cpp","index":2,"n_rows":44,"n_cols":18,"rows_kept":44,"cut":false,"hidden":false,"merged":[[0,1,0,14],[7,1,7,17],[14,1,14,17],[5,4,6,4],[5,13,6,13],[0,15,2,17],[21,1,21,17],[23,1,23,17],[1,1,2,14],[3,1,3,17],[5,15,6,15],[5,16,6,16],[5,17,6,17],[4,1,4,17],[5,5,5,8],[5,9,5,12],[5,14,6,14]]}
[null,"MINISTERUL AGRICULTURII SI DEZVOLTARII RURALE",null,null,null,null,null,null,null,null,null,null,null,null,null,"Anexa B3"]
[null,"AGENTIA PENTRU FINANTAREA INVESTITIILOR RURALE"]
[]
[]
[null,"  Proiectia contului de profit si pierdere  activitate cu proiect "]
[null,null,null,null,"Anul 0              (anterior depunerii cererii de finantare)","Anul 1",null,null,null,"Anul 2",null,null,null,"Total                         An 1","Total                         An 2","Total                           An 3","Total                        An 4","Total                        An 5"]
[null,"Nr. Crt.","Categoria",null,null,"TRIM I ","TRIM II ","TRIM III ","TRIM IV ","TRIM I ","TRIM II ","TRIM III ","TRIM IV "]
[null,"Venituri din exploatare"]
[null,1,"Cifra de afaceri ","LEI",null,{"$f":"'Prognoza veniturilor'!E36+'Prognoza veniturilor'!E37+'Prognoza veniturilor'!E38+'Prognoza veniturilor'!E40","v":0},{"$f":"'Prognoza veniturilor'!F36+'Prognoza veniturilor'!F37+'Prognoza veniturilor'!F38+'Prognoza veniturilor'!F40","v":0},{"$f":"'Prognoza veniturilor'!G36+'Prognoza veniturilor'!G37+'Prognoza veniturilor'!G38+'Prognoza veniturilor'!G40","v":0},{"$f":"'Prognoza veniturilor'!H36+'Prognoza veniturilor'!H37+'Prognoza veniturilor'!H38+'Prognoza veniturilor'!H40","v":0},{"$f":"'Prognoza veniturilor'!I36+'Prognoza veniturilor'!I37+'Prognoza veniturilor'!I38+'Prognoza veniturilor'!I40","v":0},{"$f":"'Prognoza veniturilor'!J36+'Prognoza veniturilor'!J37+'Prognoza veniturilor'!J38+'Prognoza veniturilor'!J40","v":0},{"$f":"'Prognoza veniturilor'!K36+'Prognoza veniturilor'!K37+'Prognoza veniturilor'!K38+'Prognoza veniturilor'!K40","v":0},{"$f":"'Prognoza veniturilor'!L36+'Prognoza veniturilor'!L37+'Prognoza veniturilor'!L38+'Prognoza veniturilor'!L40","v":0},{"$f":"SUM(F9:I9)","v":0},{"$f":"SUM(J9:M9)","v":0},{"$f":"'Prognoza veniturilor'!O36+'Prognoza veniturilor'!O37+'Prognoza veniturilor'!O38+'Prognoza veniturilor'!O40","v":0},{"$f":"'Prognoza veniturilor'!P36+'Prognoza veniturilor'!P37+'Prognoza veniturilor'!P38+'Prognoza veniturilor'!P40","v":0},{"$f":"'Prognoza veniturilor'!Q36+'Prognoza veniturilor'!Q37+'Prognoza veniturilor'!Q38+'Prognoza veniturilor'!Q40","v":0}]
[null,2,"Venituri din subventii pentru investitii ",null,null,{"$f":"'Prognoza veniturilor'!E39","v":0},{"$f":"'Prognoza veniturilor'!F39","v":0},{"$f":"'Prognoza veniturilor'!G39","v":0},{"$f":"'Prognoza veniturilor'!H39","v":0},{"$f":"'Prognoza veniturilor'!I39","v":0},{"$f":"'Prognoza veniturilor'!J39","v":0},{"$f":"'Prognoza veniturilor'!K39","v":0},{"$f":"'Prognoza veniturilor'!L39","v":0},{"$f":"SUM(F10:I10)","v":0},{"$f":"SUM(J10:M10)","v":0},{"$f":"'Prognoza veniturilor'!O39","v":0},{"$f":"'Prognoza veniturilor'!P39","v":0},{"$f":"'Prognoza veniturilor'!Q39","v":0}]
[null,3,"Variatia stocurilor (+ pentru C; - pentru D)","LEI",null,{"$f":"'Prognoza veniturilor'!E41","v":0},{"$f":"'Prognoza veniturilor'!F41","v":0},{"$f":"'Prognoza veniturilor'!G41","v":0},{"$f":"'Prognoza veniturilor'!H41","v":0},{"$f":"'Prognoza veniturilor'!I41","v":0},{"$f":"'Prognoza veniturilor'!J41","v":0},{"$f":"'Prognoza veniturilor'!K41","v":0},{"$f":"'Prognoza veniturilor'!L41","v":0},{"$f":"SUM(F11:I11)","v":0},{"$f":"SUM(J11:M11)","v":0},{"$f":"'Prognoza veniturilor'!O41","v":0},{"$f":"'Prognoza veniturilor'!P41","v":0},{"$f":"'Prognoza veniturilor'!Q41","v":0}]
[null,4,"Venituri  din productia realizata pentru scopuri proprii si capitalizata","LEI",null,{"$f":"'Prognoza veniturilor'!E42","v":0},{"$f":"'Prognoza veniturilor'!F42","v":0},{"$f":"'Prognoza veniturilor'!G42","v":0},{"$f":"'Prognoza veniturilor'!H42","v":0},{"$f":"'Prognoza veniturilor'!I42","v":0},{"$f":"'Prognoza veniturilor'!J42","v":0},{"$f":"'Prognoza veniturilor'!K42","v":0},{"$f":"'Prognoza veniturilor'!L42","v":0},{"$f":"SUM(F12:I12)","v":0},{"$f":"SUM(J12:M12)","v":0},{"$f":"'Prognoza veniturilor'!O42","v":0},{"$f":"'Prognoza veniturilor'!P42","v":0},{"$f":"'Prognoza veniturilor'!Q42","v":0}]
[null,5,"Alte venituri din exploatare","LEI",null,{"$f":"'Prognoza veniturilor'!E43","v":0},{"$f":"'Prognoza veniturilor'!F43","v":0},{"$f":"'Prognoza veniturilor'!G43","v":0},{"$f":"'Prognoza veniturilor'!H43","v":0},{"$f":"'Prognoza veniturilor'!I43","v":0},{"$f":"'Prognoza veniturilor'!J43","v":0},{"$f":"'Prognoza veniturilor'!K43","v":0},{"$f":"'Prognoza veniturilor'!L43","v":0},{"$f":"SUM(F13:I13)","v":0},{"$f":"SUM(J13:M13)","v":0},{"$f":"'Prognoza veniturilor'!O43","v":0},{"$f":"'Prognoza veniturilor'!P43","v":0},{"$f":"'Prognoza veniturilor'!Q43","v":0}]
[null,6,"Venituri din exploatare – total","LEI",{"$f":"SUM(E9:E13)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Cheltuieli pentru exploatare"]
[null,7,"Cheltuieli materiale – total ","LEI",null,{"$f":"'Prognoza cheltuielilor'!E12","v":0},{"$f":"'Prognoza cheltuielilor'!F12","v":0},{"$f":"'Prognoza cheltuielilor'!G12","v":0},{"$f":"'Prognoza cheltuielilor'!H12","v":0},{"$f":"'Prognoza cheltuielilor'!I12","v":0},{"$f":"'Prognoza cheltuielilor'!J12","v":0},{"$f":"'Prognoza cheltuielilor'!K12","v":0},{"$f":"'Prognoza cheltuielilor'!L12","v":0},{"$f":"'Prognoza cheltuielilor'!M12","v":0},{"$f":"'Prognoza cheltuielilor'!N12","v":0},{"$f":"'Prognoza cheltuielilor'!O12","v":0},{"$f":"'Prognoza cheltuielilor'!P12","v":0},{"$f":"'Prognoza cheltuielilor'!Q12","v":0}]
[null,8,"Cheltuieli cu personalul – total","LEI",null,{"$f":"'Prognoza cheltuielilor'!E15","v":0},{"$f":"'Prognoza cheltuielilor'!F15","v":0},{"$f":"'Prognoza cheltuielilor'!G15","v":0},{"$f":"'Prognoza cheltuielilor'!H15","v":0},{"$f":"'Prognoza cheltuielilor'!I15","v":0},{"$f":"'Prognoza cheltuielilor'!J15","v":0},{"$f":"'Prognoza cheltuielilor'!K15","v":0},{"$f":"'Prognoza cheltuielilor'!L15","v":0},{"$f":"'Prognoza cheltuielilor'!M15","v":0},{"$f":"'Prognoza cheltuielilor'!N15","v":0},{"$f":"'Prognoza cheltuielilor'!O15","v":0},{"$f":"'Prognoza cheltuielilor'!P15","v":0},{"$f":"'Prognoza cheltuielilor'!Q15","v":0}]
[null,9,"Cheltuieli cu amortizarile ","LEI",null,{"$f":"'Prognoza cheltuielilor'!E16","v":0},{"$f":"'Prognoza cheltuielilor'!F16","v":0},{"$f":"'Prognoza cheltuielilor'!G16","v":0},{"$f":"'Prognoza cheltuielilor'!H16","v":0},{"$f":"'Prognoza cheltuielilor'!I16","v":0},{"$f":"'Prognoza cheltuielilor'!J16","v":0},{"$f":"'Prognoza cheltuielilor'!K16","v":0},{"$f":"'Prognoza cheltuielilor'!L16","v":0},{"$f":"'Prognoza cheltuielilor'!M16","v":0},{"$f":"'Prognoza cheltuielilor'!N16","v":0},{"$f":"'Prognoza cheltuielilor'!O16","v":0},{"$f":"'Prognoza cheltuielilor'!P16","v":0},{"$f":"'Prognoza cheltuielilor'!Q16","v":0}]
[null,10,"Alte cheltuieli de exploatare","LEI",null,{"$f":"'Prognoza cheltuielilor'!E17","v":0},{"$f":"'Prognoza cheltuielilor'!F17","v":0},{"$f":"'Prognoza cheltuielilor'!G17","v":0},{"$f":"'Prognoza cheltuielilor'!H17","v":0},{"$f":"'Prognoza cheltuielilor'!I17","v":0},{"$f":"'Prognoza cheltuielilor'!J17","v":0},{"$f":"'Prognoza cheltuielilor'!K17","v":0},{"$f":"'Prognoza cheltuielilor'!L17","v":0},{"$f":"'Prognoza cheltuielilor'!M17","v":0},{"$f":"'Prognoza cheltuielilor'!N17","v":0},{"$f":"'Prognoza cheltuielilor'!O17","v":0},{"$f":"'Prognoza cheltuielilor'!P17","v":0},{"$f":"'Prognoza cheltuielilor'!Q17","v":0}]
[null,11,"Cheltuieli pentru exploatare - total","LEI",{"$f":"SUM(E16:E19)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,12,"Rezultatul din exploatare","LEI",{"$f":"SUM(E14-E20)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Venituri financiare – total"]
[null,13,"Venituri financiare – total","LEI",null,null,null,null,null,null,null,null,null,{"$f":"SUM(F23:I23)","v":0},{"$f":"SUM(J23:M23)","v":0}]
[null,"Cheltuieli financiare, din care"]
[null,14,"Cheltuieli privind dobanzile","LEI",null,null,null,null,null,null,null,null,null,{"$f":"SUM(F25:I25)","v":0},{"$f":"SUM(J25:M25)","v":0}]
[null,15,"Alte cheltuieli financiare","LEI",null,null,null,null,null,null,null,null,null,{"$f":"SUM(F26:I26)","v":0},{"$f":"SUM(J26:M26)","v":0}]
[null,16,"Cheltuieli financiare  - total","LEI",{"$f":"SUM(E25+E26)","v":0},{"$f":"SUM(F25+F26)","v":0},{"$f":"SUM(G25+G26)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,17,"Rezultatul financiar","LEI",{"$f":"SUM(E23-E27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,18,"Rezultatul brut","LEI",{"$f":"SUM(E21+E28)","v":0},{"$f":"SUM(F21+F28)","v":0},{"$f":"SUM(G21+G28)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,19,"Impozitul pe profit / cifra de afaceri","LEI",null,null,null,null,null,null,null,null,null,{"$f":"SUM(F30:I30)","v":0},{"$f":"SUM(J30:M30)","v":0}]
[null,20,"Rezultatul net al exercitiului financiar","LEI",{"$f":"SUM(E29-E30)","v":0},0,{"$f":"SUM(G29-G30)","v":0},0,0,0,0,0,0,{"$f":"SUM(N29-N30)","v":0},0,0,0,0]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[]
[]
[null,null,null,null,{"$f":"IF('Prognoza veniturilor'!D50-'Prognoza cheltuielilor'!D21>0,'Prognoza veniturilor'!D50-'Prognoza cheltuielilor'!D21,0)","v":0},{"$f":"IF('Prognoza veniturilor'!E50-'Prognoza cheltuielilor'!E21>0,'Prognoza veniturilor'!E50-'Prognoza cheltuielilor'!E21,0)","v":0}]
[null,null,null,null,{"$f":"IF('Prognoza veniturilor'!D50-'Prognoza cheltuielilor'!D21<0,-'Prognoza veniturilor'!D50+'Prognoza cheltuielilor'!D21,0)","v":0},{"$f":"IF('Prognoza veniturilor'!E50-'Prognoza cheltuielilor'!E21<0,-'Prognoza veniturilor'!E50+'Prognoza cheltuielilor'!E21,0)","v":0}]

{"sheet":"Bilant","index":3,"n_rows":32,"n_cols":9,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,7,1,8],[0,1,1,6],[3,1,3,8]]}
[null,"                        MINISTERUL AGRICULTURII SI DEZVOLTARII RURALE                                                                       AGENTIA PENTRU FINANTAREA INVESTITIILOR RURALE",null,null,null,null,null,"Anexa B4"]
[]
[]
[null,"BILANT SINTETIC PREVIZIONAT - LEI"]
[null,null,null,"Anul 0             (anterior depunerii cererii de finantare)","Anul 1","Anul 2","Anul 3","Anul 4","Anul 5"]
[null,1,"Active imobilizate - brute"]
[null,2,"Valoarea amortizarii cumulate"]
[null,"I","Active imobilizate - nete (1-2)",{"$f":"D6-D7","v":0},{"$f":"E6-E7","v":0},0,0,0,0]
[null,3,"Stocuri"]
[null,4,"Creante "]
[null,5,"Casa si conturi la banci"]
[null,"II","Total active circulante (3+4+5)",{"$f":"D9+D10+D11","v":0},0,0,0,0,0]
[]
[null,null,"TOTAL ACTIV (I+II)",{"$f":"D8+D12","v":0},0,0,0,0,0]
[null,"III","Datorii ce trebuie platite intr-o perioada de pana la un an",{"$f":"SUM(D16:D18)","v":0},0,0,0,0,0]
[null,6,"Imprumuturi si datorii la institutii de credit"]
[null,7,"Datorii comerciale"]
[null,8,"Alte datorii, inclusiv fiscale si la asigurari sociale"]
[null,"IV","Datorii ce trebuie platite intr-o perioada mai mare de un an",{"$f":"SUM(D20:D22)","v":0},0,0,0,0,0]
[null,9,"Imprumuturi si datorii la institutii de credit"]
[null,10,"Datorii comerciale"]
[null,11,"Alte datorii, inclusiv fiscale si la asigurari sociale"]
[null,"V","Subventii pentru investitii"]
[null,12,"Capital social"]
[null,13,"Rezultatul exercitiului financiar"]
[null,14,"  - repartizare profit la dividende"]
[null,15,"  - repartizare profit la la rezerve"]
[null,16,"Rezerve"]
[null,"VI","Total capitaluri proprii",{"$f":"D24+D25+D28","v":0},0,0,0,0,0]
[null,null,"TOTAL PASIV",{"$f":"D15+D19+D23+D29","v":0},0,0,0,0,0]
[]
[null,null,"Verificare:",{"$f":"D14-D30","v":0},0,0,0,0,0]

{"sheet":"FN An 1 I","index":4,"n_rows":55,"n_cols":22,"rows_kept":55,"cut":false,"hidden":false,"merged":[[25,2,25,16],[4,16,5,16],[1,1,2,12],[1,13,2,16],[3,4,3,15],[5,2,5,15]]}
[]
[null,"           MINISTERUL AGRICULTURII SI DEZVOLTARII RURALE                                                                                                                                                                                                                     AGENTIA PENTRU FINANTAREA INVESTITIILOR RURALE",null,null,null,null,null,null,null,null,null,null,null,"Anexa B5"]
[]
[null,null,"Flux de numerar - previziuni - LEI",null,"Anul 1 al implementarii",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,"OPERATIUNEA/PERIOADA",null,"Luna 1","Luna 2","Luna 3","Luna 4","Luna 5","Luna 6","Luna 7","Luna 8","Luna 9","Luna 10","Luna 11","Luna 12","Anul  1                      al implementarii"]
[null,"I.","ACTIVITATEA DE INVESTITII SI FINANTARE"]
[null,"A.","Total intrari de lichiditati din:   (A1+A2+A3+A4)",null,{"$f":"E8+E9+E10+E13","v":0},{"$f":"F8+F9+F10+F13","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q8:Q10)+Q13","v":0}]
[null,null,"A1. Aport la capitalul societatii  (imprumuturi de la actionari/asociati)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:P8)","v":0}]
[null,null,"A2. Vanzari de active, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E9:P9)","v":0}]
[null,null,"A3. Credite pe termen lung, din care: (A.3.1. + A.3.2.)",null,{"$f":"SUM(E11:E12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"   A.3.1. Imprumut - cofinantare la proiect",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:P11)","v":0}]
[null,null,"   A.3.2. Alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:P12)","v":0}]
[null,null,"A4. Ajutor nerambursabil FEADR  (inclusiv avans)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:P13)","v":0}]
[null,"B.","Total iesiri de lichiditati prin investitii:   (B1+B2+B3)",null,{"$f":"SUM(E15:E17)","v":0},{"$f":"SUM(F15:F17)","v":0},{"$f":"SUM(G15:G17)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(P15:P17)","v":0},{"$f":"SUM(Q15:Q17)","v":0}]
[null,null,"B1. Achizitii de active fixe corporale, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:P15)","v":0}]
[null,null,"B2. Achizitii de active fixe necorporale, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:P16)","v":0}]
[null,null,"B3. Cresterea investitiilor in curs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:P17)","v":0},null,null,null,null,{"$f":"SUM(Q14-Q8-Q10-Q13)","v":0}]
[null,"C.","Total iesiri de lichiditati prin finantare   (C1+C2)",null,{"$f":"E19+E22","v":0},{"$f":"F19+F22","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"C1. Rambursari de Credite pe termen mediu si lung, din care:  (C.1.1.+ C.1.2.)",null,{"$f":"SUM(E20:E21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"   C.1.1. Rate la imprumut - cofinantare la proiect",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:P20)","v":0}]
[null,null,"   C.1.2. Rate la alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:P21)","v":0}]
[null,null,"C2. Plati de dobanzi la Credite pe termen mediu si lung, din care:   (C.2.1.+C.2.2.)",null,{"$f":"SUM(E23:E24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"   C.2.1. La imprumut - cofinantare la proiect",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E23:P23)","v":0}]
[null,null,"   C.2.2. La alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:P24)","v":0}]
[null,"D.","Flux de lichiditati din activitatea de investitii si finantare (A-B-C)",null,{"$f":"E7-E14-E18","v":0},{"$f":"F7-F14-F18","v":0},{"$f":"G7-G14-G18","v":0},{"$f":"H7-H14-H18","v":0},{"$f":"I7-I14-I18","v":0},0,0,0,0,0,0,0,{"$f":"Q7-Q14-Q18","v":0}]
[null,"II.","ACTIVITATEA DE EXPLOATARE"]
[null,"E.","Incasari din activitatea de exploatare, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:P27)","v":0}]
[null,"F.","Incasari din activitatea financiara pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"G.","Credite pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"H.","Total intrari de numerar (E+F+G)",null,{"$f":"SUM(E27:E29)","v":0},{"$f":"SUM(F27:F29)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(P27:P29)","v":0},0]
[null,"I.","Plati pentru activitatea de exploatare, inclusiv TVA (dupa caz), din care:",null,{"$f":"SUM(E32:E40)","v":0},{"$f":"SUM(F32:F40)","v":0},{"$f":"SUM(G32:G40)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(P32:P40)","v":0},0]
[null,"I1.","Materii prime si materiale",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I2.","Alte materiale",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I3.","Energia si apa",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E34:P34)","v":0}]
[null,"I4.","Marfuri",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I5.","Aferente personalului angajat",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I6.","Asigurari si protectie sociala",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I7.","Prestatii externe",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I8.","Impozite, taxe si varsaminte asimilate",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I9.","Alte plati aferente exploatarii",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E40:P40)","v":0}]
[null,"J.","Flux brut inainte de plati pentru impozit pe profit /cifra de afaceri si ajustare TVA (H-I)",null,{"$f":"E30-E31","v":0},{"$f":"F30-F31","v":0},0,0,0,0,0,0,0,0,0,{"$f":"P30-P31","v":0},{"$f":"SUM(E41:P41)","v":0}]
[null,"K.","Plati/incasari pentru impozite si taxe  (K1-K2+K3)",null,{"$f":"E43-E44+E45","v":0},{"$f":"F43-F44+F45","v":0},{"$f":"G43-G44+G45","v":0},{"$f":"H43-H44+H45","v":0},0,0,0,0,0,0,0,{"$f":"P43-P44+P45","v":0},{"$f":"Q43-Q44+Q45","v":0}]
[null,null,"K1.  plati TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E43:P43)","v":0}]
[null,null,"K2.  rambursari TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"K3. impozit pe profit/cifra de afaceri",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"L.","Rambursari de credite pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"M.","Plati de dobanzi la credite pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N.","Dividende",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"O.","Total plati exclusiv cele aferente exploatarii  (K+L+M+N)",null,{"$f":"E42+E46+E47+E48","v":0},{"$f":"F42+F46+F47+F48","v":0},0,0,0,0,0,0,0,0,0,{"$f":"P42+P46+P47+P48","v":0},{"$f":"Q42+Q46+Q47+Q48","v":0}]
[null,"P.","Flux de numerar din activitatea de exploatare (J-O)",null,{"$f":"E41-E49","v":0},{"$f":"F41-F49","v":0},{"$f":"G41-G49","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(E50:P50)","v":0}]
[null,"III.","FLUX DE LICHIDITATI (CASH FLOW)"]
[null,"Q.","Flux de lichiditati net al perioadei (D+P)",null,{"$f":"E25+E50","v":0},{"$f":"F25+F50","v":0},0,0,0,0,0,0,0,0,0,{"$f":"P25+P50","v":0},{"$f":"Q25+Q50","v":0}]
[null,"R.","Disponibil de numerar al lunii precedente",null,{"$f":"D53","v":0},{"$f":"E54","v":0},0,{"$f":"G54","v":0},0,0,0,0,0,0,0,0,{"$f":"D53","v":0}]
[null,"S.","Disponibil de numerar la sfarsitul perioadei (R+Q)",{"$f":"SUM(D53)","v":0},{"$f":"E52+E53","v":0},{"$f":"F52+F53","v":0},{"$f":"G52+G53","v":0},0,0,0,0,0,0,0,0,{"$f":"P52+P53","v":0},{"$f":"Q52+Q53","v":0}]
[null,null," "]

{"sheet":"FN An 2 I ","index":5,"n_rows":55,"n_cols":22,"rows_kept":55,"cut":false,"hidden":false,"merged":[[25,2,25,16],[1,1,2,12],[1,13,2,16],[3,4,3,15],[4,16,5,16],[5,2,5,15]]}
[]
[null,"           MINISTERUL AGRICULTURII SI DEZVOLTARII RURALE                                                                                                                                                                                                                     AGENTIA PENTRU FINANTAREA INVESTITIILOR RURALE",null,null,null,null,null,null,null,null,null,null,null,"Anexa B6"]
[]
[null,null,"Flux de numerar - previziuni - LEI",null,"Anul 2 al implementarii",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,"OPERATIUNEA/PERIOADA",null,"Luna 1","Luna 2","Luna 3","Luna 4","Luna 5","Luna 6","Luna 7","Luna 8","Luna 9","Luna 10","Luna 11","Luna 12","Anul  2  al implementarii"]
[null,"I.","ACTIVITATEA DE INVESTITII SI FINANTARE"]
[null,"A.","Total intrari de lichiditati din:   (A1+A2+A3+A4)",null,{"$f":"E8+E9+E10+E13","v":0},{"$f":"F8+F9+F10+F13","v":0},0,{"$f":"H8+H9+H10+H13","v":0},{"$f":"I8+I9+I10+I13","v":0},{"$f":"J8+J9+J10+J13","v":0},0,0,0,0,0,0,{"$f":"SUM(Q8:Q10)+Q13","v":0}]
[null,null,"A1. Aport la capitalul societatii  (imprumuturi de la actionari/asociati)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:P8)","v":0}]
[null,null,"A2. Vanzari de active, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E9:P9)","v":0}]
[null,null,"A3. Credite pe termen lung, din care: (A.3.1. + A.3.2.)",null,{"$f":"SUM(E11:E12)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"   A.3.1. Imprumut - cofinantare la proiect",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:P11)","v":0}]
[null,null,"   A.3.2. Alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:P12)","v":0}]
[null,null,"A4. Ajutor nerambursabil FEADR  (inclusiv avans)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:P13)","v":0}]
[null,"B.","Total iesiri de lichiditati prin investitii:   (B1+B2+B3)",null,{"$f":"SUM(E15:E17)","v":0},{"$f":"SUM(F15:F17)","v":0},{"$f":"SUM(G15:G17)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(P15:P17)","v":0},{"$f":"SUM(Q15:Q17)","v":0}]
[null,null,"B1. Achizitii de active fixe corporale, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:P15)","v":0}]
[null,null,"B2. Achizitii de active fixe necorporale, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:P16)","v":0}]
[null,null,"B3. Cresterea investitiilor in curs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:P17)","v":0},null,null,null,null,{"$f":"SUM(Q14-Q8-Q10-Q13)","v":0}]
[null,"C.","Total iesiri de lichiditati prin finantare   (C1+C2)",null,{"$f":"E19+E22","v":0},{"$f":"F19+F22","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"C1. Rambursari de Credite pe termen mediu si lung, din care:  (C.1.1.+ C.1.2.)",null,{"$f":"SUM(E20:E21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"   C.1.1. Rate la imprumut - cofinantare la proiect",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:P20)","v":0}]
[null,null,"   C.1.2. Rate la alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:P21)","v":0}]
[null,null,"C2. Plati de dobanzi la Credite pe termen mediu si lung, din care:   (C.2.1.+C.2.2.)",null,{"$f":"SUM(E23:E24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"   C.2.1. La imprumut - cofinantare la proiect",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E23:P23)","v":0}]
[null,null,"   C.2.2. La alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:P24)","v":0}]
[null,"D.","Flux de lichiditati din activitatea de investitii si finantare (A-B-C)",null,{"$f":"E7-E14-E18","v":0},{"$f":"F7-F14-F18","v":0},{"$f":"G7-G14-G18","v":0},{"$f":"H7-H14-H18","v":0},{"$f":"I7-I14-I18","v":0},0,0,0,0,0,0,0,{"$f":"Q7-Q14-Q18","v":0}]
[null,"II.","ACTIVITATEA DE EXPLOATARE"]
[null,"E.","Incasari din activitatea de exploatare, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:P27)","v":0}]
[null,"F.","Incasari din activitatea financiara pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"G.","Credite pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"H.","Total intrari de numerar (E+F+G)",null,{"$f":"SUM(E27:E29)","v":0},{"$f":"SUM(F27:F29)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(P27:P29)","v":0},0]
[null,"I.","Plati pentru activitatea de exploatare, inclusiv TVA (dupa caz), din care:",null,{"$f":"SUM(E32:E40)","v":0},{"$f":"SUM(F32:F40)","v":0},{"$f":"SUM(G32:G40)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(P32:P40)","v":0},0]
[null,"I1.","Materii prime si materiale",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I2.","Alte materiale",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I3.","Energia si apa",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I4.","Marfuri",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I5.","Aferente personalului angajat",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I6.","Asigurari si protectie sociala",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I7.","Prestatii externe",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I8.","Impozite, taxe si varsaminte asimilate",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I9.","Alte plati aferente exploatarii",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E40:P40)","v":0}]
[null,"J.","Flux brut inainte de plati pentru impozit pe profit /cifra de afaceri si ajustare TVA (H-I)",null,{"$f":"E30-E31","v":0},{"$f":"F30-F31","v":0},0,0,0,0,0,0,0,0,0,{"$f":"P30-P31","v":0},{"$f":"SUM(E41:P41)","v":0}]
[null,"K.","Plati/incasari pentru impozite si taxe  (K1-K2+K3)",null,{"$f":"E43-E44+E45","v":0},{"$f":"F43-F44+F45","v":0},{"$f":"G43-G44+G45","v":0},{"$f":"H43-H44+H45","v":0},0,0,0,0,0,0,0,{"$f":"P43-P44+P45","v":0},{"$f":"Q43-Q44+Q45","v":0}]
[null,null,"K1.  plati TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E43:P43)","v":0}]
[null,null,"K2.  rambursari TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"K3. impozit pe profit/cifra de afaceri",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"L.","Rambursari de credite pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"M.","Plati de dobanzi la credite pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N.","Dividende",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"O.","Total plati exclusiv cele aferente exploatarii  (K+L+M+N)",null,{"$f":"E42+E46+E47+E48","v":0},{"$f":"F42+F46+F47+F48","v":0},0,0,0,0,0,0,0,0,0,{"$f":"P42+P46+P47+P48","v":0},{"$f":"Q42+Q46+Q47+Q48","v":0}]
[null,"P.","Flux de numerar din activitatea de exploatare (J-O)",null,{"$f":"E41-E49","v":0},{"$f":"F41-F49","v":0},{"$f":"G41-G49","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(E50:P50)","v":0}]
[null,"III.","FLUX DE LICHIDITATI (CASH FLOW)"]
[null,"Q.","Flux de lichiditati net al perioadei (D+P)",null,{"$f":"E25+E50","v":0},{"$f":"F25+F50","v":0},0,0,0,0,0,0,0,0,0,{"$f":"P25+P50","v":0},{"$f":"Q25+Q50","v":0}]
[null,"R.","Disponibil de numerar al lunii precedente",{"$f":"'FN An 1 I'!Q54","v":0},{"$f":"D53","v":0},{"$f":"E54","v":0},0,{"$f":"G54","v":0},0,0,0,0,0,0,0,0,{"$f":"D53","v":0}]
[null,"S.","Disponibil de numerar la sfarsitul perioadei (R+Q)",{"$f":"SUM(D53)","v":0},{"$f":"E52+E53","v":0},{"$f":"F52+F53","v":0},{"$f":"G52+G53","v":0},0,0,0,0,0,0,0,0,{"$f":"P52+P53","v":0},{"$f":"Q52+Q53","v":0}]
[null,null," "]

{"sheet":"FN An 3 I ","index":6,"n_rows":55,"n_cols":22,"rows_kept":55,"cut":false,"hidden":false,"merged":[[25,2,25,16],[1,1,2,12],[1,13,2,16],[3,4,3,15],[4,16,5,16],[5,2,5,15]]}
[]
[null,"           MINISTERUL AGRICULTURII SI DEZVOLTARII RURALE                                                                                                                                                                                                                     AGENTIA PENTRU FINANTAREA INVESTITIILOR RURALE",null,null,null,null,null,null,null,null,null,null,null,"Anexa B7"]
[]
[null,null,"Flux de numerar - previziuni - LEI",null,"Anul 3 al implementarii",null,null,null,null,null,null,null,null,null,null,null,"Total"]
[null,null,"OPERATIUNEA/PERIOADA",null,"Luna 1","Luna 2","Luna 3","Luna 4","Luna 5","Luna 6","Luna 7","Luna 8","Luna 9","Luna 10","Luna 11","Luna 12","Anul  3  al implementarii"]
[null,"I.","ACTIVITATEA DE INVESTITII SI FINANTARE"]
[null,"A.","Total intrari de lichiditati din:   (A1+A2+A3+A4)",null,{"$f":"E8+E9+E10+E13","v":0},{"$f":"F8+F9+F10+F13","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q8:Q10)+Q13","v":0}]
[null,null,"A1. Aport la capitalul societatii  (imprumuturi de la actionari/asociati)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E8:P8)","v":0}]
[null,null,"A2. Vanzari de active, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E9:P9)","v":0}]
[null,null,"A3. Credite pe termen lung, din care: (A.3.1. + A.3.2.)",null,{"$f":"SUM(E11:E12)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Q11:Q12)","v":0}]
[null,null,"   A.3.1. Imprumut - cofinantare la proiect",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E11:P11)","v":0}]
[null,null,"   A.3.2. Alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E12:P12)","v":0}]
[null,null,"A4. Ajutor nerambursabil FEADR  (inclusiv avans)",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:P13)","v":0}]
[null,"B.","Total iesiri de lichiditati prin investitii:   (B1+B2+B3)",null,{"$f":"SUM(E15:E17)","v":0},{"$f":"SUM(F15:F17)","v":0},{"$f":"SUM(G15:G17)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(P15:P17)","v":0},{"$f":"SUM(Q15:Q17)","v":0}]
[null,null,"B1. Achizitii de active fixe corporale, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E15:P15)","v":0}]
[null,null,"B2. Achizitii de active fixe necorporale, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E16:P16)","v":0}]
[null,null,"B3. Cresterea investitiilor in curs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:P17)","v":0},null,null,null,null,{"$f":"SUM(Q14-Q8-Q10-Q13)","v":0}]
[null,"C.","Total iesiri de lichiditati prin finantare   (C1+C2)",null,{"$f":"E19+E22","v":0},{"$f":"F19+F22","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,"C1. Rambursari de Credite pe termen mediu si lung, din care:  (C.1.1.+ C.1.2.)",null,{"$f":"SUM(E20:E21)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"   C.1.1. Rate la imprumut - cofinantare la proiect",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:P20)","v":0}]
[null,null,"   C.1.2. Rate la alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:P21)","v":0}]
[null,null,"C2. Plati de dobanzi la Credite pe termen mediu si lung, din care:   (C.2.1.+C.2.2.)",null,{"$f":"SUM(E23:E24)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,"   C.2.1. La imprumut - cofinantare la proiect",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E23:P23)","v":0}]
[null,null,"   C.2.2. La alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:P24)","v":0}]
[null,"D.","Flux de lichiditati din activitatea de investitii si finantare (A-B-C)",null,{"$f":"E7-E14-E18","v":0},{"$f":"F7-F14-F18","v":0},{"$f":"G7-G14-G18","v":0},{"$f":"H7-H14-H18","v":0},{"$f":"I7-I14-I18","v":0},0,0,0,0,0,0,0,{"$f":"Q7-Q14-Q18","v":0}]
[null,"II.","ACTIVITATEA DE EXPLOATARE"]
[null,"E.","Incasari din activitatea de exploatare, inclusiv TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E27:P27)","v":0}]
[null,"F.","Incasari din activitatea financiara pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"G.","Credite pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"H.","Total intrari de numerar (E+F+G)",null,{"$f":"SUM(E27:E29)","v":0},{"$f":"SUM(F27:F29)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(P27:P29)","v":0},0]
[null,"I.","Plati pentru activitatea de exploatare, inclusiv TVA (dupa caz), din care:",null,{"$f":"SUM(E32:E40)","v":0},{"$f":"SUM(F32:F40)","v":0},{"$f":"SUM(G32:G40)","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(P32:P40)","v":0},0]
[null,"I1.","Materii prime si materiale",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I2.","Alte materiale",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I3.","Energia si apa",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I4.","Marfuri",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I5.","Aferente personalului angajat",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I6.","Asigurari si protectie sociala",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I7.","Prestatii externe",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I8.","Impozite, taxe si varsaminte asimilate",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"I9.","Alte plati aferente exploatarii",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E40:P40)","v":0}]
[null,"J.","Flux brut inainte de plati pentru impozit pe profit /cifra de afaceri si ajustare TVA (H-I)",null,{"$f":"E30-E31","v":0},{"$f":"F30-F31","v":0},0,0,0,0,0,0,0,0,0,{"$f":"P30-P31","v":0},{"$f":"SUM(E41:P41)","v":0}]
[null,"K.","Plati/incasari pentru impozite si taxe  (K1-K2+K3)",null,{"$f":"E43-E44+E45","v":0},{"$f":"F43-F44+F45","v":0},{"$f":"G43-G44+G45","v":0},{"$f":"H43-H44+H45","v":0},0,0,0,0,0,0,0,{"$f":"P43-P44+P45","v":0},{"$f":"Q43-Q44+Q45","v":0}]
[null,null,"K1.  plati TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E43:P43)","v":0}]
[null,null,"K2.  rambursari TVA",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,"K3. impozit pe profit/cifra de afaceri",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"L.","Rambursari de credite pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"M.","Plati de dobanzi la credite pe termen scurt",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"N.","Dividende",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"O.","Total plati exclusiv cele aferente exploatarii  (K+L+M+N)",null,{"$f":"E42+E46+E47+E48","v":0},{"$f":"F42+F46+F47+F48","v":0},0,0,0,0,0,0,0,0,0,{"$f":"P42+P46+P47+P48","v":0},{"$f":"Q42+Q46+Q47+Q48","v":0}]
[null,"P.","Flux de numerar din activitatea de exploatare (J-O)",null,{"$f":"E41-E49","v":0},{"$f":"F41-F49","v":0},{"$f":"G41-G49","v":0},0,0,0,0,0,0,0,0,0,{"$f":"SUM(E50:P50)","v":0}]
[null,"III.","FLUX DE LICHIDITATI (CASH FLOW)"]
[null,"Q.","Flux de lichiditati net al perioadei (D+P)",null,{"$f":"E25+E50","v":0},{"$f":"F25+F50","v":0},0,0,0,0,0,0,0,0,0,{"$f":"P25+P50","v":0},{"$f":"Q25+Q50","v":0}]
[null,"R.","Disponibil de numerar al lunii precedente",{"$f":"'FN An 2 I '!Q54","v":0},{"$f":"D53","v":0},{"$f":"E54","v":0},0,{"$f":"G54","v":0},0,0,0,0,0,0,0,0,{"$f":"D53","v":0}]
[null,"S.","Disponibil de numerar la sfarsitul perioadei (R+Q)",{"$f":"SUM(D53)","v":0},{"$f":"E52+E53","v":0},{"$f":"F52+F53","v":0},{"$f":"G52+G53","v":0},0,0,0,0,0,0,0,0,{"$f":"P52+P53","v":0},{"$f":"Q52+Q53","v":0}]
[null,null," "]

{"sheet":"FN An 1-5","index":7,"n_rows":55,"n_cols":14,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,6,2,8],[1,1,2,5],[25,2,25,8],[3,4,3,8],[5,2,5,8]]}
[]
[null,"                MINISTERUL AGRICULTURII SI DEZVOLTARII RURALE                                                                                                            AGENTIA PENTRU FINANTAREA INVESTITIILOR RURALE",null,null,null,null,"Anexa B8"]
[]
[null,null,"Flux de numerar - previziuni - LEI"]
[null,null,"OPERATIUNEA/PERIOADA",null,"Anul 1","Anul 2","Anul 3","Anul 4","Anul 5"]
[null,"I.","ACTIVITATEA DE INVESTITII SI FINANTARE"]
[null,"A.","Total intrari de lichiditati din:   (A1+A2+A3+A4)",null,{"$f":"SUM(E8:E10)+E13","v":0},{"$f":"SUM(F8:F10)+F13","v":0},{"$f":"SUM(G8:G10)+G13","v":0},{"$f":"SUM(H8:H10)+H13","v":0},{"$f":"SUM(I8:I10)+I13","v":0}]
[null,null,"A1. Aport la capitalul societatii (imprumuturi de la actionari/asociati)"]
[null,null,"A2. Vanzari de active, inclusiv TVA"]
[null,null,"A3. Credite pe termen lung, din care: (A.3.1. + A.3.2.)",null,{"$f":"SUM(E11:E12)","v":0},{"$f":"SUM(F11:F12)","v":0},{"$f":"SUM(G11:G12)","v":0},{"$f":"SUM(H11:H12)","v":0},{"$f":"SUM(I11:I12)","v":0}]
[null,null,"   A.3.1. Imprumut - cofinantare la proiect"]
[null,null,"   A.3.2. Alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare"]
[null,null,"A4. Ajutor nerambursabil FEADR  (inclusiv avans)"]
[null,"B.","Total iesiri de lichiditati prin investitii:   (B1+B2+B3)",null,{"$f":"SUM(E15:E17)","v":0},{"$f":"SUM(F15:F17)","v":0},{"$f":"SUM(G15:G17)","v":0},{"$f":"SUM(H15:H17)","v":0},{"$f":"SUM(I15:I17)","v":0}]
[null,null,"B1. Achizitii de active fixe corporale, inclusiv TVA"]
[null,null,"B2. Achizitii de active fixe necorporale, inclusiv TVA"]
[null,null,"B3. Cresterea investitiilor in curs",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(#REF!-#REF!-#REF!-#REF!)","v":{"$error":"#REF!"}}]
[null,"C.","Total iesiri de lichiditati prin finantare   (C1+C2)",null,{"$f":"E19+E22","v":0},{"$f":"F19+F22","v":0},{"$f":"G19+G22","v":0},{"$f":"H19+H22","v":0},{"$f":"I19+I22","v":0}]
[null,null,"C1. Rambursari de Credite pe termen mediu si lung, din care:  (C.1.1.+ C.1.2.)",null,{"$f":"SUM(E20:E21)","v":0},{"$f":"SUM(F20:F21)","v":0},{"$f":"SUM(G20:G21)","v":0},{"$f":"SUM(H20:H21)","v":0},{"$f":"SUM(I20:I21)","v":0}]
[null,null,"   C.1.1. Rate la imprumut - cofinantare la proiect"]
[null,null,"   C.1.2. Rate la alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare"]
[null,null,"C2. Plati de dobanzi la Credite pe termen mediu si lung, din care:   (C.2.1.+C.2.2.)",null,{"$f":"SUM(E23:E24)","v":0},{"$f":"SUM(F23:F24)","v":0},{"$f":"SUM(G23:G24)","v":0},{"$f":"SUM(H23:H24)","v":0},{"$f":"SUM(I23:I24)","v":0}]
[null,null,"   C.2.1. La imprumut - cofinantare la proiect"]
[null,null,"   C.2.2. La alte Credite pe termen mediu si lung, leasinguri, alte datorii financiare"]
[null,"D.","Flux de lichiditati din activitatea de investitii si finantare (A-B-C)",null,{"$f":"E7-E14-E18","v":0},{"$f":"F7-F14-F18","v":0},{"$f":"G7-G14-G18","v":0},{"$f":"H7-H14-H18","v":0},{"$f":"I7-I14-I18","v":0}]
[null,"II.","ACTIVITATEA DE EXPLOATARE"]
[null,"E.","Incasari din activitatea de exploatare, inclusiv TVA"]
[null,"F.","Incasari din activitatea financiara pe termen scurt"]
[null,"G.","Credite pe termen scurt"]
[null,"H.","Total intrari de numerar (E+F+G)",null,{"$f":"SUM(E27:E29)","v":0},{"$f":"SUM(F27:F29)","v":0},{"$f":"SUM(G27:G29)","v":0},{"$f":"SUM(H27:H29)","v":0},{"$f":"SUM(I27:I29)","v":0}]
[null,"I.","Plati pentru activitatea de exploatare, inclusiv TVA (dupa caz), din care:",null,{"$f":"SUM(E32:E40)","v":0},{"$f":"SUM(F32:F40)","v":0},{"$f":"SUM(G32:G40)","v":0},{"$f":"SUM(H32:H40)","v":0},{"$f":"SUM(I32:I40)","v":0}]
[null,"I1.","Materii prime si materiale"]
[null,"I2.","Alte materiale"]
[null,"I3.","Energie si apa"]
[null,"I4.","Marfuri"]
[null,"I5.","Aferente personalului angajat"]
[null,"I6.","Asigurari si protectie sociala"]
[null,"I7.","Prestatii externe"]
[null,"I8.","Impozite, taxe si varsaminte asimilate"]
[null,"I9.","Alte plati aferente exploatarii"]
[null,"J.","Flux brut inainte de plati pentru impozit pe profit /cifra de afaceri si ajustare TVA (H-I)",null,{"$f":"E30-E31","v":0},{"$f":"F30-F31","v":0},{"$f":"G30-G31","v":0},{"$f":"H30-H31","v":0},{"$f":"I30-I31","v":0}]
[null,"K.","Plati/incasari pentru impozite si taxe                  (K1-K2+K3)",null,{"$f":"E43-E44+E45","v":0},{"$f":"F43-F44+F45","v":0},{"$f":"G43-G44+G45","v":0},{"$f":"H43-H44+H45","v":0},{"$f":"I43-I44+I45","v":0}]
[null,null,"K1.  plati TVA"]
[null,null,"K2.  rambursari TVA"]
[null,null,"K3.  impozit pe profit/cifra de afaceri"]
[null,"L.","Rambursari de credite pe termen scurt"]
[null,"M.","Plati de dobanzi la credite pe termen scurt"]
[null,"N.","Dividende"]
[null,"O.","Total plati, exclusiv cele aferente exploatarii (K+L+M+N)",null,{"$f":"E42+E46+E47+E48","v":0},{"$f":"F42+F46+F47+F48","v":0},{"$f":"G42+G46+G47+G48","v":0},{"$f":"H42+H46+H47+H48","v":0},{"$f":"I42+I46+I47+I48","v":0}]
[null,"P.","Flux de numerar din activitatea de exploatare (J-O)",null,{"$f":"E41-E49","v":0},{"$f":"F41-F49","v":0},{"$f":"G41-G49","v":0},{"$f":"H41-H49","v":0},{"$f":"I41-I49","v":0}]
[null,"III.","FLUX DE LICHIDITATI (CASH FLOW)"]
[null,"Q.","Flux de lichiditati net al perioadei (D+P)",null,{"$f":"E25+E50","v":0},{"$f":"F25+F50","v":0},{"$f":"G25+G50","v":0},{"$f":"H25+H50","v":0},{"$f":"I25+I50","v":0}]
[null,"R.","Disponibil de numerar al perioadei precedente",{"$f":"'FN An 3 I '!Q54","v":0},{"$f":"D53","v":0},{"$f":"E54","v":0},{"$f":"F54","v":0},{"$f":"G54","v":0},{"$f":"H54","v":0}]
[null,"S.","Disponibil de numerar la sfarsitul perioadei (Q+R)",{"$f":"SUM(D53)","v":0},{"$f":"E52+E53","v":0},{"$f":"F52+F53","v":0},{"$f":"G52+G53","v":0},{"$f":"H52+H53","v":0},{"$f":"I52+I53","v":0}]
[null,null," "]

{"sheet":"Indicatori","index":8,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,18,0],[0,1,1,6],[0,7,3,8],[2,1,3,6],[4,1,4,8],[16,4,16,8],[6,3,7,3],[5,1,5,8],[6,1,6,2],[7,4,7,8],[19,1,20,6],[12,4,12,8],[8,4,8,8],[17,4,17,8]]}
[null,"MINISTERUL AGRICULTURII SI DEZVOLTARII RURALE",null,null,null,null,null,"Anexa B9"]
[]
[null,"AGENTIA PENTRU FINANTAREA INVESTITIILOR RURALE"]
[]
[]
[null,"INDICATORI FINANCIARI"]
[null,"Anul",null,"UM","Total an 1","Total an 2","Total an 3","Total an 4","Total an 5"]
[null,"Nr.crt.","Specificatie",null,"Valoare"]
[null,1,"Valoare investitie(Vi)= valoarea totala a proiectului fara TVA","LEI"]
[null,2,"Veniturile din exploatare (Ve) = veniturile realizate din activitatea curenta, conform obiectului de activitate al solicitantului. ","LEI",{"$f":"'Prognoza veniturilor'!M44","v":0},{"$f":"'Prognoza veniturilor'!N44","v":0},{"$f":"'Prognoza veniturilor'!O44","v":0},{"$f":"'Prognoza veniturilor'!P44","v":0},{"$f":"'Prognoza veniturilor'!Q44","v":0}]
[null,3,"Cheltuieli de exploatare (Ce)= cheltuielile generate de derularea activitatii curente\n","LEI",{"$f":"'Prognoza cheltuielilor'!M18","v":0},{"$f":"'Prognoza cheltuielilor'!N18","v":0},{"$f":"'Prognoza cheltuielilor'!O18","v":0},{"$f":"'Prognoza cheltuielilor'!P18","v":0},{"$f":"'Prognoza cheltuielilor'!Q18","v":0}]
[null,4,"Rata rezultatului din exploatare (rRe) -  trebuie sa fie minim 10%","%",{"$f":"IF(E10=0,\"Eroare\",ROUND((E10-E11)/E10,4))","v":"Eroare"},{"$f":"IF(F10=0,\"Eroare\",ROUND((F10-F11)/F10,4))","v":"Eroare"},{"$f":"IF(G10=0,\"Eroare\",ROUND((G10-G11)/G10,4))","v":"Eroare"},{"$f":"IF(H10=0,\"Eroare\",ROUND((H10-H11)/H10,4))","v":"Eroare"},{"$f":"IF(I10=0,\"Eroare\",ROUND((I10-I11)/I10,4))","v":"Eroare"}]
[null,5,"Durata de recuperare a investitiei (Dr) - maxim 12 ani","ANI",{"$f":"ROUND(E9/(('FN An 1-5'!E52/(1+E17)+'FN An 1-5'!F52/(1+E17)^2+'FN An 1-5'!G52/(1+E17)^3+'FN An 1-5'!H52/(1+E17)^4+'FN An 1-5'!I52/(1+E17)^5+'FN An 1-5'!I52+'FN An 1-5'!I52+'FN An 1-5'!I52+'FN An 1-5'!I52+'FN An 1-5'!I52+'FN An 1-5'!I52+'FN An 1-5'!I52)/12), 4)","v":{"$error":"#DIV/0!"}}]
[null,6,"Rata rentabilitatii capitalului investit (rRc) - trebuie sa fie minim 5%","%",{"$f":"IF($E$9=0,\"Eroare\",ROUND('FN An 1-5'!E50/$E$9, 4))","v":"Eroare"},{"$f":"IF($E$9=0,\"Eroare\",ROUND('FN An 1-5'!F50/$E$9, 4))","v":"Eroare"},{"$f":"IF($E$9=0,\"Eroare\",ROUND('FN An 1-5'!G50/$E$9, 4))","v":"Eroare"},{"$f":"IF($E$9=0,\"Eroare\",ROUND('FN An 1-5'!H50/$E$9, 4))","v":"Eroare"},{"$f":"IF($E$9=0,\"Eroare\",ROUND('FN An 1-5'!I50/$E$9, 4))","v":"Eroare"}]
[null,7,"Rata acoperirii prin fluxul de numerar (RAFN) - trebuie sa fie mai mare sau egal cu 1.2","Numeric",{"$f":"IF('FN An 1-5'!E18=0,\"Nu este cazul !\", ROUND(('FN An 1-5'!E50)/'FN An 1-5'!E18, 4))","v":"Nu este cazul !"},{"$f":"IF('FN An 1-5'!F18=0,\"Nu este cazul !\", ROUND(('FN An 1-5'!F50)/'FN An 1-5'!F18, 4))","v":"Nu este cazul !"},{"$f":"IF('FN An 1-5'!G18=0,\"Nu este cazul !\", ROUND(('FN An 1-5'!G50)/'FN An 1-5'!G18, 4))","v":"Nu este cazul !"},{"$f":"IF('FN An 1-5'!H18=0,\"Nu este cazul !\", ROUND(('FN An 1-5'!H50)/'FN An 1-5'!H18, 4))","v":"Nu este cazul !"},{"$f":"IF('FN An 1-5'!I18=0,\"Nu este cazul !\", ROUND(('FN An 1-5'!I50)/'FN An 1-5'!I18, 4))","v":"Nu este cazul !"}]
[null,8,"Rata indatorarii pe termen mediu si lung (rI) - maxim 60%","%",{"$f":"IF(Bilant!E14=0,\"Eroare\", ROUND(Bilant!E19/Bilant!E14, 4))","v":"Eroare"},{"$f":"IF(Bilant!F14=0,\"Eroare\", ROUND(Bilant!F19/Bilant!F14, 4))","v":"Eroare"},{"$f":"IF(Bilant!G14=0,\"Eroare\", ROUND(Bilant!G19/Bilant!G14, 4))","v":"Eroare"},{"$f":"IF(Bilant!H14=0,\"Eroare\", ROUND(Bilant!H19/Bilant!H14, 4))","v":"Eroare"},{"$f":"IF(Bilant!I14=0,\"Eroare\", ROUND(Bilant!I19/Bilant!I14, 4))","v":"Eroare"}]
[null,9,"Rata de actualizare",null,0.08]
[null,10,"Valoare actualizata neta (VAN) - trebuie sa fie pozitiva","LEI",{"$f":"ROUND('FN An 1-5'!E52/(1+E17)+'FN An 1-5'!F52/(1+E17)^2+'FN An 1-5'!G52/(1+E17)^3+'FN An 1-5'!H52/(1+E17)^4+'FN An 1-5'!I52/(1+E17)^5+'FN An 1-5'!I50/(1+E17)^6+'FN An 1-5'!I50/(1+E17)^7+'FN An 1-5'!I50/(1+E17)^8+'FN An 1-5'!I50/(1+E17)^9+'FN An 1-5'!I50/(1+E17)^10+'FN An 1-5'!I50/(1+E17)^11+'FN An 1-5'!I50/(1+E17)^12-Indicatori!E9, 0)","v":0}]
[null,11,"Disponibil de numerar la sfarsitul perioadei - trebuie sa fie pozitiv","LEI",{"$f":"'FN An 1-5'!E54","v":0},{"$f":"'FN An 1-5'!F54","v":0},{"$f":"'FN An 1-5'!G54","v":0},{"$f":"'FN An 1-5'!H54","v":0},{"$f":"'FN An 1-5'!I54","v":0}]