Anexa 9 - Formular Cash flow

Cash flowDenumirea societatii:Perioada De la:Pana la:Previzionare Cash FlowA. INCASARINov-14Dec-14IanuarieFebruarieMartieAprilieMaiIunieIulieAugustSeptembrieOctombrieNoiembrieDecembrieTotal AN 1AN 2AN 3AN 4AN 5Vanzari de marfuri (plata cash)20,07829,4857,2476,81010,00020,00020,00020,00010,00010,00020,00020,00020,00030,000194,057197,938201,897205,935210,054Debitori1,171,1941,009,736479,189600,059550,000700,000700,000800,000800,000900,0001,100,0001,100,0001,100,0001,100,0009,929,24810,127,83310,330,39010,536,99710,747,737Credite3,30862,193258,550917300,0000.00.00.00.00.00.00.00.00.0559,4670.00.00.00.0Subventii0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Aport de capital0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Alte surse113,702147,06866,53550,0930.00.00.00.00.027,0000.016,0000.00.0159,628162,821166,077169,399172,786TOTAL1,308,2821,248,482811,521657,879860,000720,000720,000820,000810,000937,0001,120,0001,136,0001,120,0001,130,00010,842,40010,488,59210,698,36310,912,33111,130,577B. PLATIActualActualIanuarieFebruarieMartieAprilieMaiIunieIulieAugustSeptembrieOctombrieNoiembrieDecembrieTotal AN 1AN 2AN 3AN 4AN 5Achizitii marfa87,43075,3661,8671,40010,00010,00010,00010,00010,00010,00010,00010,00010,00010,000103,267105,332107,439109,588111,780Datorii furnizori590,869370,626280,426238,439672,000472,000500,000550,000570,000600,000800,000800,000800,000800,0007,082,8657,224,5227,369,0137,516,3937,666,721Salarii (net)54,72054,21250,50845,13245,00045,00045,00045,00045,00045,00045,00045,00045,00045,000545,640556,553567,684579,038590,618Chirii, impozite, asigurari7002,3563,8960.02,0002,0002,0002,0002,0002,0002,0002,0002,0002,00023,89624,37424,86125,35925,866Energie, apa2,1003,7003,3172,3112,5002,5002,5002,5002,5002,5002,5002,5002,5002,50030,62831,24131,86532,50333,153Telefon, taxe postale, consumabile5,1214,6474,0004,3704,0004,0004,0004,0004,0004,0004,0004,0004,0004,00048,37049,33750,32451,33152,357Transport3,7382,2215490.00.00.00.00.00.00.00.00.00.00.0549560571583594Publicitate0.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0Rambursari de credite principal cred banca89,849286,20628,57377,66027,65652,65652,65652,65652,65652,65652,65652,65652,65652,656607,793296,2480.00.00.0Plati servicii bancare dob banci+comm13,57514,29911,63711,42210,00010,00010,00010,00010,00010,00010,00010,00010,00010,000123,05965,0000.00.00.0TVA si alte taxe166,175248,41144,63966,02335,00075,00070,000100,00070,00070,000100,000100,000100,000100,000930,662949,275968,261987,6261,007,378Achizitii mijloace fixe - leasing+dob+comm25,00028,00021,50021,50021,50021,50017,00012,30012,30012,30010,00010,0007,5007,500174,90041,20037,20036,20024,200Alte cheltuieli243,379144,852341,803166,0870.00.00.00.00.00.00.00.00.00.0507,890518,048528,409538,977549,756TOTAL1,282,6561,234,896792,715634,344829,656694,656713,156788,456778,456808,4561,036,1561,036,1561,033,6561,033,65610,179,5199,861,6909,685,6279,877,59610,062,424C. NET CASH (A - B)25,62613,58618,80623,53530,34425,3446,84431,54431,544128,54483,84499,84486,34496,344662,881626,9011,012,7361,034,7351,068,154D. SOLD INITIAL25,61751,24364,82983,635107,170137,514162,858169,702201,246232,790361,334445,178545,022631,366727,7101,390,5912,017,4923,030,2294,064,964E. SOLD FINAL (C + D)51,24364,82983,635107,170137,514162,858169,702201,246232,790361,334445,178545,022631,366727,7101,390,5912,017,4923,030,2294,064,9645,133,117SEMNATURA SI STAMPILA

Luna curentaIncasari din vanzari de marfuri unde plata este facuta imediatIncasari din vanzari precedente pe credit comercial: CEC, BO, OPUn credit acordat va avea in corespondenta o plata de valoare cel putin egala (achizitie active fixe, marfuri, etc.)Agentii guvernamentale locale, centrale sau europeneInvestitia proprietarilor in firmaVanzari de active, avansuri trezorerie, rambursari de TVALuna curentaAchizitii de materii prime unde plata se face imediatPlati pe credit pentru marfaSalarii neteDobanzi bancare, chelt de dobandire etcPlati pt active fixe, echipamente, masini etc.STERGE TABELLuna curentaLuna curenta