cash flow.xls
2
Denumirea societatii: Perioada Pana la: Previzionare Cash Flow A. INCASARI Nov-14 Dec-14 Ianuarie Februarie Martie Aprilie Mai Iunie Iulie August Septembrie Octombrie Noiembrie Decembrie Total AN 1 AN 2 AN 3 AN 4 20,078 29,485 7,247 6,810 10,000 20,000 20,000 20,000 10,000 10,000 20,000 20,000 20,000 30,000 194,057 197,938 201,897 205,935 Debitori 1,171,194 ### 479,189 600,059 550,000 700,000 700,000 800,000 800,000 900,000 ### ### ### ### ### ### ### ### Credite 3,308 62,193 258,550 917 300,000 - - - - - - - - - 559,467 - - - Subventii - - - - - - - - - - - - - - - - - - Aport de capital - - - - - - - - - - - - - - - - - - Alte surse 113,702 147,068 66,535 50,093 - - - - - 27,000 - 16,000 - - 159,628 162,821 166,077 169,399 TOTAL 1,308,282 ### 811,521 657,879 860,000 720,000 720,000 820,000 810,000 937,000 ### ### ### ### ### ### ### ### B. PLATI Actual Actual Ianuarie Februarie Martie Aprilie Mai Iunie Iulie August Septembrie Octombrie Noiembrie Decembrie Total AN 1 AN 2 AN 3 AN 4 Achizitii marfa 87,430 75,366 1,867 1,400 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 103,267 105,332 107,439 109,588 Datorii furnizori 590,869 370,626 280,426 238,439 672,000 472,000 500,000 550,000 570,000 600,000 800,000 800,000 800,000 800,000 ### ### ### ### Salarii (net) 54,720 54,212 50,508 45,132 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 545,640 556,553 567,684 579,038 Chirii, impozite, asigurari 700 2,356 3,896 - 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 2,000 23,896 24,374 24,861 25,359 Energie, apa 2,100 3,700 3,317 2,311 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 2,500 30,628 31,241 31,865 32,503 Telefon, taxe postale, consum 5,121 4,647 4,000 4,370 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 4,000 48,370 49,337 50,324 51,331 Transport 3,738 2,221 549 - - - - - - - - - - - 549 560 571 583 Publicitate - - - - - - - - - - - - - - - - - - Rambursari de credite princip 89,849 286,206 28,573 77,660 27,656 52,656 52,656 52,656 52,656 52,656 52,656 52,656 52,656 52,656 607,793 296,248 - - Plati servicii bancare dob ba 13,575 14,299 11,637 11,422 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 10,000 123,059 65,000 - - TVA si alte taxe 166,175 248,411 44,639 66,023 35,000 75,000 70,000 100,000 70,000 70,000 100,000 100,000 100,000 100,000 930,662 949,275 968,261 987,626 Achizitii mijloace fixe - lea 25,000 28,000 21,500 21,500 21,500 21,500 17,000 12,300 12,300 12,300 10,000 10,000 7,500 7,500 174,900 41,200 37,200 36,200 Alte cheltuieli 243,379 144,852 341,803 166,087 - - - - - - - - - - 507,890 518,048 528,409 538,977 TOTAL 1,282,656 ### 792,715 634,344 829,656 694,656 713,156 788,456 778,456 808,456 ### ### ### ### ### ### ### ### C. NET CASH (A - B) 25,626 13,586 18,806 23,535 30,344 25,344 6,844 31,544 31,544 128,544 83,844 99,844 86,344 96,344 662,881 626,901 ### ### D. SOLD INITIAL 25,617 51,243 64,829 83,635 107,170 137,514 162,858 169,702 201,246 232,790 361,334 445,178 545,022 631,366 727,710 ### ### ### E. SOLD FINAL (C + D) 51,243 64,829 83,635 107,170 137,514 162,858 169,702 201,246 232,790 361,334 445,178 545,022 631,366 727,710 ### ### ### ### SEMNATURA SI STAMPILA Vanzari de marfuri (plata cash)
-
Upload
elena-mirica -
Category
Documents
-
view
8 -
download
5
Transcript of cash flow.xls
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
