Scribd Logo
Upload

Welcome to Scribd!

  • 29 views

    Explicatii/Perioada L1 L2: Total Cheltuieli Directe (1+2)

    Uploaded by

    Camelia Beket
    1. The document summarizes cash flow information for a company over multiple periods (L1-L12). 2. It shows beginning cash balances, cash inflows from sales and other sources, and cash outflows for direct costs, indirect costs, and other expenses. 3. The net cash flow or surplus/deficit is calculated for each period by subtracting total cash outflows from total cash inflows.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd

    Explicatii/Perioada L1 L2: Total Cheltuieli Directe (1+2)

    Uploaded by

    Camelia Beket
    29 views18 pages
    1. The document summarizes cash flow information for a company over multiple periods (L1-L12). 2. It shows beginning cash balances, cash inflows from sales and other sources, and cash outflows for direct costs, indirect costs, and other expenses. 3. The net cash flow or surplus/deficit is calculated for each period by subtracting total cash outflows from total cash inflows.

    Original Description:

    hgkgffklikjh

    Original Title

    model cashflow

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. The document summarizes cash flow information for a company over multiple periods (L1-L12). 2. It shows beginning cash balances, cash inflows from sales and other sources, and cash outflows for direct costs, indirect costs, and other expenses. 3. The net cash flow or surplus/deficit is calculated for each period by subtracting total cash outflows from total cash inflows.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    29 views18 pages

    Explicatii/Perioada L1 L2: Total Cheltuieli Directe (1+2)

    Uploaded by

    Camelia Beket
    1. The document summarizes cash flow information for a company over multiple periods (L1-L12). 2. It shows beginning cash balances, cash inflows from sales and other sources, and cash outflows for direct costs, indirect costs, and other expenses. 3. The net cash flow or surplus/deficit is calculated for each period by subtracting total cash outflows from total cash inflows.

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 18

    MII EURO

    Explicatii/Perioada L1 L2
    1.Numerar la inceputul perioadei 500 1083.949
    2.Intrari de numerar:
    -din vanzari:
    -pe numerar 898.56 898.56
    -pe credit
    -din credite: 3000
    -alte intrari de numerar:
    -intrari TVA 19% 80.8704 80.8704
    -alte intrari
    A.TOTAL NUMERAR DISPONIBIL(1+2) 1398.56 1982.509
    Iesiri de numerar:
    CHELTUIELI DIRECTE
    1.Cheltuieli materiale:
    -pe numerar 134.784 134.784
    -pe credit
    2.Cheltuieli cu manopera directa 15 15
    TOTAL CHELTUIELI DIRECTE(1+2) 149.784 149.784
    CHELTUIELI INDIRECTE:
    1.Chirii
    2.Utilitati 89.856 89.856
    3.Desfacere/transport
    4.Reparatii/intretinere 17.9712 17.9712
    5.Cheltuieli adm-gosp 5 5
    6.Salarii TESA 40 40
    7.Reclama 2 2
    8.Asigurari 10
    9.Rate rambursare credite
    10.Cheltuieli cu dobanzile 15
    11.Alte cheltuieli:
    -iesiri TVA 19% 31.317168 29.41717
    -comisioane/rabat com
    TOTAL CHELTUIELI INDIRECTE(1+2) 164.8272 169.8272
    I.TOTAL CHELTUIELI(directe+indirecte) 314.6112 319.6112
    II.CHELTUIELI INVESTITIONALE
    III.INVESTITII DE CAPITAL(15-30%)
    IV.DIFERENTA TVA(TVA intrari-TVA iesiri) 49.55323
    V.IMPOZIT PE PROFIT
    B.TOTAL IESIRI NUMERAR(I+II+III+IV+V) 314.6112 319.6112
    SURPLUS/DEFICIT DE NUMERAR(A-B) 1083.9488 1662.898
    Factor de actualizare pentru rata de 8% 0.9933
    Cash flow actualizat 1076.68634

    Met Depr:

    Met Kap:
    L3 L4 L5 L6 L7 L8 L9
    1662.898 2241.8464 2820.795 3399.744 3978.69 2948.32 3425.441

    898.56 898.56 898.56 898.56 748.8 748.8 898.56

    80.8704 80.8704 80.8704 80.8704 67.392 67.392 80.8704

    2561.458 3140.4064 3719.355 4298.304 4727.49 3697.12 4324

    134.784 134.784 134.784 134.784 112.32 112.32 134.784

    15 15 15 15 15 15 15
    149.784 149.784 149.784 149.784 127.32 127.32 149.784

    89.856 89.856 89.856 89.856 74.88 74.88 89.856

    17.9712 17.9712 17.9712 17.9712 14.976 14.976 17.9712


    5 5 5 5 5 5 5
    40 40 40 40 40 40 40
    2 2 2 2 2 2 2

    1500
    15 15 15 15 15 7.5 7.5

    29.41717 29.417168 29.41717 29.41717 26.0026 26.0026 29.41717

    169.8272 169.8272 169.8272 169.8272 1651.86 144.356 162.3272


    319.6112 319.6112 319.6112 319.6112 1779.18 271.676 312.1112
    1500

    51.45323 51.453232 51.45323 51.45323 51.4532 41.3894 41.38936


    319.6112 319.6112 319.6112 319.6112 1779.18 271.676 312.1112
    2241.846 2820.7952 3399.744 3978.693 2948.32 3425.44 4011.89

    0.324675 40519.481
    0.036
    0.034839
    0.035419 57595.628
    L10 L11 L12 An1-total An2 An3 An4
    4011.89 4598.338 5184.787 35856.6976

    898.56 898.56 898.56 10483.2

    80.8704 80.8704 80.8704 943.488

    4910.45 5496.898 6083.347 46339.8976

    134.784 134.784 134.784 1572.48

    15 15 15 180
    149.784 149.784 149.784 1752.48

    89.856 89.856 89.856 1048.32

    17.9712 17.9712 17.9712 209.664


    5 5 5 60
    40 40 40 480
    2 2 2 24
    10
    1500
    7.5 7.5 7.5

    29.41717 29.41717 29.41717 348.07696

    162.3272 162.3272 1662.327 1831.984


    312.1112 312.1112 1812.111 6711.964
    1500

    51.45323 51.45323 51.45323 543.957808


    312.1112 312.1112 1812.111 6711.964
    4598.338 5184.787 4271.236
    MII EURO
    Explicatii/Perioada L1 L2 L3
    1.Numerar la inceputul perioadei 1000 5700 6252
    2.Intrari de numerar:
    -din vanzari:
    -pe numerar 5625 5625 5625
    -pe credit contributia marcii 10 % 562.5 562.5 562.5
    -din credite: 4000
    -alte intrari de numerar:
    - TVA 19% colectat 1176 1176 1176
    -alte intrari
    A.TOTAL NUMERAR DISPONIBIL(1+2) 11188 11325 11877
    Iesiri de numerar:
    CHELTUIELI DIRECTE
    1.Cheltuieli materiale:
    -pe numerar 1687.5 1687.5 1687.5
    -pe credit
    2.Cheltuieli cu manopera directa 700 700 700
    TOTAL CHELTUIELI DIRECTE(1+2) 2387.5 2387.5 2387.5
    CHELTUIELI INDIRECTE:
    1.Chirii 700 700 700
    2.Utilitati 250 250 250
    3.Desfacere/transport 200 200 200
    4.Reparatii/intretinere 112.5 112.5 112.5
    5.Cheltuieli adm-gosp 200 200 200
    6.Salarii TESA 300 300 300
    7.Reclama
    8.Asigurari 1350
    9.Rate rambursare credite
    10.Cheltuieli cu dobanzile
    11.Alte cheltuieli:
    -iesiri TVA 19% 239.88 239.88 239.88
    -comisioane/rabat com 187.5 187.5 187.5
    TOTAL CHELTUIELI INDIRECTE(1+2) 3100 1750 1750
    I.TOTAL CHELTUIELI(directe+indirecte) 5487.5 4137.5 4137.5
    II.CHELTUIELI INVESTITIONALE
    III.INVESTITII DE CAPITAL(15-30%)
    IV.DIFERENTA TVA(TVA intrari-TVA iesiri) 935.75 935.75
    V.IMPOZIT PE PROFIT
    B.TOTAL IESIRI NUMERAR(I+II+III+IV+V) 5487.5 5073 5073
    SURPLUS/DEFICIT DE NUMERAR(A-B) 5700 6252 6803.5
    Factor de actualizare pentru rata de 8% 0.993
    CF actualizat 10222
    valoarea marcii 1022.215

    260
    70
    260
    L4 L5 L6 L7 L8 L9 L10 L11 L12
    6803.5 6242 6793 7345 7896.94 7160 7712 8264 8815

    5625 5625 5625 5625 5625 5625 5625 5625 5625


    562.5 562.5 562.5 562.5 562.5 562.5 562.5 562.5 562.5

    1175.63 1176 1176 1176 1175.625 1176 1176 1176 1176

    12428.5 11867 12418 12970 13521.94 12785 13337 13889 14440

    1687.5 1687.5 1687.5 1687.5 1687.5 1687.5 1687.5 1687.5 1687.5

    700 700 700 700 700 700 700 700 700


    2387.5 2387.5 2387.5 2387.5 2387.5 2387.5 2387.5 2387.5

    700 700 700 700 700 700 700 700 700


    250 250 250 250 250 250 250 250 250
    200 200 200 200 200 200 200 200 200
    112.5 112.5 112.5 112.5 112.5 112.5 112.5 112.5 112.5
    200 200 200 200 200 200 200 200 200
    300 300 300 300 300 300 300 300 300

    40
    0

    239.875 239.88 239.88 239.88 239.875 239.88 239.88 239.88 239.88


    187.5 187.5 187.5 187.5 187.5 187.5 187.5 187.5 187.5
    1750 1750 1750 1750 1750 1750 1750 1750 1750
    4137.5 4137.5 4137.5 4137.5 4137.5 4137.5 4137.5 4137.5 1750
    25 25 50

    935.75 935.75 935.75 935.75 935.75 935.75 935.75 935.75 935.75


    1088.56 1263.5104 1410
    6186.81 5073 5073 5073 6361.7604 5073 5073 5073 4146
    6241.69 6793 7345 7897 7160.1796 7712 8264 8815 10294
    An1-total An2 An3

    67500
    6750

    14108

    67500

    10125

    6750

    1350
    2400
    1

    1350

    1539
    6750 0
    16201
    48613

    10293
    MII EURO
    Explicatii/Perioada L1 L2 L3
    1.Numerar la inceputul perioadei
    2.Intrari de numerar:
    -din vanzari:
    -pe numerar
    -pe credit
    -din credite:
    -alte intrari de numerar:
    -intrari TVA 19%
    -alte intrari
    A.TOTAL NUMERAR DISPONIBIL(1+2)
    Iesiri de numerar:
    CHELTUIELI DIRECTE
    1.Cheltuieli materiale:
    -pe numerar
    -pe credit
    2.Cheltuieli cu manopera directa
    TOTAL CHELTUIELI DIRECTE(1+2)
    CHELTUIELI INDIRECTE:
    1.Chirii
    2.Utilitati
    3.Desfacere/transport
    4.Reparatii/intretinere
    5.Cheltuieli adm-gosp
    6.Salarii TESA
    7.Reclama
    8.Asigurari
    9.Rate rambursare credite
    10.Cheltuieli cu dobanzile
    11.Alte cheltuieli:
    -iesiri TVA 19%
    -comisioane/rabat com
    TOTAL CHELTUIELI INDIRECTE(1+2)
    I.TOTAL CHELTUIELI(directe+indirecte)
    II.CHELTUIELI INVESTITIONALE
    III.INVESTITII DE CAPITAL(15-30%)
    IV.DIFERENTA TVA(TVA intrari-TVA iesiri)
    V.IMPOZIT PE PROFIT
    B.TOTAL IESIRI NUMERAR(I+II+III+IV+V)
    SURPLUS/DEFICIT DE NUMERAR(A-B)
    L4 L5 L6 L7 L8 L9 L10 L11 L12
    An1-total An2 An3

    You might also like