copy of cashflow

2
CASH FLOW ul Explicatii/Perioada 1 2 3 4 5 6 7 8 9 10 11 12 I Venituri din: 1. Vanzari 200 200 200 200 200 200 200 200 200 200 200 100 2. Ven. Financiare 0.375 0.375 15.375 0 0 0 0 0 0 0 0 0 3. Alte venituri 262.5 150 110 80 50 30 15 5 0 0 0 0 4. Total venituri 462.88 350.38 325.38 280 250 230 215 205 200 200 200 100 II Cheltuieli directe 1.Cheltuieli materiale - pe numerar 64 64 64 64 64 64 64 64 64 64 64 32 - pe credit 0 0 0 0 0 0 0 0 0 0 0 0 2. Ch. cu manopera directa 80 80 80 80 80 80 80 80 80 80 80 80 Total chelt.directe 144 144 144 144 144 144 144 144 144 144 144 140 III. Chelt. indirecte 1.Chirii 0 0 0 0 0 0 0 0 0 0 0 0 2.Utilitati 1.5 1.5 1.5 0.8 0.8 0.8 0.8 0.8 0.8 0.8 1.5 1.5 3.Desfacere-transpo 2 2 2 2 2 2 2 2 2 2 2 2 4.Reparatii-intreti 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 0.3 5.Chelt.administrat 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 0.5 gospodaresti 6.Salarii TESA 28 28 28 28 28 28 28 28 28 28 28 28 7. Reclama 1 1 1 1 1 1 1 1 1 1 1 1 8.Asigurari 46 0 0 0 0 0 0 0 0 0 0 9.Amortizare 2.19 2.19 2.19 2.19 2.19 2.19 2.19 2.19 2.19 2.19 2.19 2.19 10.Chelt cu dobanzi 13.125 13.125 13.125 13.125 13.125 13.125 13.125 13.125 13.125 13.125 13.125 13.125 11.Alte cheltuieli (rabat de ex) 0 0 0 0 0 0 0 0 0 0 0 0 Total chelt.indirec 94.615 48.615 48.615 47.915 47.915 47.915 47.915 47.915 47.915 47.915 48.615 48.615 IV:Total cheltuieli 238.62 192.62 192.62 191.92 191.92 191.92 191.92 191.92 191.92 191.92 192.62 188.62 V: TVA (de plata) 15.485 15.485 15.485 15.35 15.35 15.35 15.35 15.35 15.35 15.35 15.485 7.885 VI:Total general 254.1 208.1 208.1 207.27 207.27 207.27 207.27 207.27 207.27 207.27 208.1 196.5 Cheltuieli

Upload: olaru-lorena

Post on 24-Sep-2015

226 views

Category:

Documents


1 download

DESCRIPTION

dfghjgfd

TRANSCRIPT

Sheet1CASH FLOW ulExplicatii/Perioada123456789101112I Venituri din:1. Vanzari2002002002002002002002002002002001002. Ven. Financiare0.3750.37515.3750000000003. Alte venituri262.515011080503015500004. Total venituri462.875350.375325.375280250230215205200200200100II Cheltuieli directe1.Cheltuieli materiale- pe numerar646464646464646464646432- pe credit0000000000002. Ch. cu manoperadirecta808080808080808080808080Total chelt.directe144144144144144144144144144144144140III. Chelt. indirecte1.Chirii0000000000002.Utilitati1.51.51.50.80.80.80.80.80.80.81.51.53.Desfacere-transport2222222222224.Reparatii-intretinere0.30.30.30.30.30.30.30.30.30.30.30.35.Chelt.administrativ0.50.50.50.50.50.50.50.50.50.50.50.5gospodaresti6.Salarii TESA2828282828282828282828287. Reclama1111111111118.Asigurari4600000000009.Amortizare2.192.192.192.192.192.192.192.192.192.192.192.1910.Chelt cu dobanzile13.12513.12513.12513.12513.12513.12513.12513.12513.12513.12513.12513.12511.Alte cheltuieli(rabat de ex)000000000000Total chelt.indirecte94.61548.61548.61547.91547.91547.91547.91547.91547.91547.91548.61548.615IV:Total cheltuieli238.615192.615192.615191.915191.915191.915191.915191.915191.915191.915192.615188.615V: TVA (de plata)15.48515.48515.48515.3515.3515.3515.3515.3515.3515.3515.4857.885VI:Total general254.1208.1208.1207.265207.265207.265207.265207.265207.265207.265208.1196.5CheltuieliVII:Profit impozabil(I-VI)208.775157.76117.27572.73542.73522.7357.735-2.265-7.265-7.265-8.1-96.5Explicatii/Perioada123456789101112VIII:Impozit pe profit52.1937539.4429.3187518.1837510.683755.683751.9337500000IX: Profit net156.58125118.3287.9562554.5512532.0512517.051255.8012500000X: Dividende, parti000000000000SocialeXI: Profit nerepartizat156.58125118.3287.9562554.5512532.0512517.051255.8012500000XII: Profit nerepartizatcumulat6.581258.327.956254.551252.051252.051250.80125Reinvestire150110805030155

Sheet2

Sheet3