Scribd Logo
Upload

Welcome to Scribd!

  • 11 views

    PROYECTOEC

    Uploaded by

    Andrea Segura
    The document analyzes the costs and revenues of a business over a 10 year period on a monthly basis. It provides detailed income statements showing revenues, expenses, cash flow and other financial metrics to evaluate the profitability and returns of the business.

    Copyright:

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

    PROYECTOEC

    Uploaded by

    Andrea Segura
    11 views2 pages
    The document analyzes the costs and revenues of a business over a 10 year period on a monthly basis. It provides detailed income statements showing revenues, expenses, cash flow and other financial metrics to evaluate the profitability and returns of the business.

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document analyzes the costs and revenues of a business over a 10 year period on a monthly basis. It provides detailed income statements showing revenues, expenses, cash flow and other financial metrics to evaluate the profitability and returns of the business.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    11 views2 pages

    PROYECTOEC

    Uploaded by

    Andrea Segura
    The document analyzes the costs and revenues of a business over a 10 year period on a monthly basis. It provides detailed income statements showing revenues, expenses, cash flow and other financial metrics to evaluate the profitability and returns of the business.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 2

    Ingresos/mes 0 1 2 3 4

    Venta - $89,920.80 $89,920.80 $89,920.80 $89,920.80


    Total ingresos - $89,920.80 $89,920.80 $89,920.80 $89,920.80
    Inversiòn -$100,000.00
    Costos/ año
    Agua potable -$230.00 -$230.00 -$230.00 -$230.00
    Electricidad -$1,500.00 -$1,542.45 -$1,586.10 -$1,630.99
    Telefono -$450.00 -$450.00 -$450.00 -$450.00
    Renta del local -$1,423.00 -$1,423.00 -$1,423.00 -$1,423.00
    Agua purificada -$220.00 -$226.23 -$232.63 -$239.21
    Gasolina -$600.00 -$616.98 -$634.44 -$652.40
    Sueldo de empacador -$4,000.00 -$4,000.00 -$4,000.00 -$4,000.00
    Sueldo de operador -$4,800.00 -$4,800.00 -$4,800.00 -$4,800.00
    Sueldo de rolador -$6,000.00 -$6,000.00 -$6,000.00 -$6,000.00
    sueldo de repartidor -$5,200.00 -$5,200.00 -$5,200.00 -$5,200.00
    Sueldo de gerente -$10,000.00 -$10,000.00 -$10,000.00 -$10,000.00
    general

    Sueldo de administrativo -$4,000.00 -$4,000.00 -$4,000.00 -$4,000.00


    Cartucho de impresora -$70.00 -$70.00 -$70.00 -$70.00
    Hojas blancas tamaño -$36.80 -$36.80 -$36.80 -$36.80
    carta
    Costo de seguro -$1,000.00 - - -
    Aceite -$112.00 -$112.00 -$112.00 -$112.00
    Alambre pulido cal-12 -$3,125.00 -$3,125.00 -$3,125.00 -$3,125.00
    Alambre pulido cal-14 -$3,850.00 -$3,850.00 -$3,850.00 -$3,850.00
    Alambre pulido cal-15 -$4,120.00 -$4,120.00 -$4,120.00 -$4,120.00
    Alambre pulido cal-16 -$1,560.00 -$1,560.00 -$1,560.00 -$1,560.00
    Alambre pulido cal-17 -$4,480.00 -$4,480.00 -$4,480.00 -$4,480.00
    Alambre pulido cal-18 -$3,300.00 -$3,300.00 -$3,300.00 -$3,300.00
    Alambre pulido cal-19 -$3,460.00 -$3,460.00 -$3,460.00 -$3,460.00
    Alambre welt -$212.50 -$212.50 -$212.50 -$212.50
    Aserrin -$56.00 -$56.00 -$56.00 -$56.00
    Bolsa -$500.00 -$500.00 -$500.00 -$500.00
    Caja -$792.00 -$792.00 -$792.00 -$792.00
    Total costos -$100,000.00 -$65,097.30 -$64,162.96 -$64,230.47 -$64,299.89
    Flujo de caja -$100,000.00 $24,823.50 $25,757.84 $25,690.33 $25,620.91

    VA $508,072.57
    INVERSIÓN -$100,000.00
    VPN $608,072.57
    TIR 22%
    B/L 5.0807257489
    5 6 7 8 9 10
    $89,920.80 $89,920.80 $89,920.80 $89,920.80 $89,920.80 $89,920.80
    $89,920.80 $89,920.80 $89,920.80 $89,920.80 $89,920.80 $89,920.80

    -$230.00 -$230.00 -$230.00 -$230.00 -$230.00 -$230.00


    -$1,677.14 -$1,724.61 -$1,773.41 -$1,823.60 -$1,875.21 -$1,928.28
    -$450.00 -$450.00 -$450.00 -$450.00 -$450.00 -$450.00
    -$1,423.00 -$1,423.00 -$1,423.00 -$1,423.00 -$1,423.00 -$1,423.00
    -$245.98 -$252.94 -$260.10 -$267.46 -$275.03 -$282.81
    -$670.86 -$689.84 -$709.37 -$729.44 -$750.08 -$771.31
    -$4,000.00 -$4,000.00 -$4,000.00 -$4,000.00 -$4,000.00 -$4,000.00
    -$4,800.00 -$4,800.00 -$4,800.00 -$4,800.00 -$4,800.00 -$4,800.00
    -$6,000.00 -$6,000.00 -$6,000.00 -$6,000.00 -$6,000.00 -$6,000.00
    -$5,200.00 -$5,200.00 -$5,200.00 -$5,200.00 -$5,200.00 -$5,200.00

    -$10,000.00 -$10,000.00 -$10,000.00 -$10,000.00 -$10,000.00 -$10,000.00

    -$4,000.00 -$4,000.00 -$4,000.00 -$4,000.00 -$4,000.00 -$4,000.00


    -$70.00 -$70.00 -$70.00 -$70.00 -$70.00 -$70.00
    -$36.80 -$36.80 -$36.80 -$36.80 -$36.80 -$36.80

    - - - - - -
    -$112.00 -$112.00 -$112.00 -$112.00 -$112.00 -$112.00
    -$3,125.00 -$3,125.00 -$3,125.00 -$3,125.00 -$3,125.00 -$3,125.00
    -$3,850.00 -$3,850.00 -$3,850.00 -$3,850.00 -$3,850.00 -$3,850.00
    -$4,120.00 -$4,120.00 -$4,120.00 -$4,120.00 -$4,120.00 -$4,120.00
    -$1,560.00 -$1,560.00 -$1,560.00 -$1,560.00 -$1,560.00 -$1,560.00
    -$4,480.00 -$4,480.00 -$4,480.00 -$4,480.00 -$4,480.00 -$4,480.00
    -$3,300.00 -$3,300.00 -$3,300.00 -$3,300.00 -$3,300.00 -$3,300.00
    -$3,460.00 -$3,460.00 -$3,460.00 -$3,460.00 -$3,460.00 -$3,460.00
    -$212.50 -$212.50 -$212.50 -$212.50 -$212.50 -$212.50
    -$56.00 -$56.00 -$56.00 -$56.00 -$56.00 -$56.00
    -$500.00 -$500.00 -$500.00 -$500.00 -$500.00 -$500.00
    -$792.00 -$792.00 -$792.00 -$792.00 -$792.00 -$792.00
    -$64,371.28 -$64,444.69 -$64,520.18 -$64,597.80 -$64,677.63 -$64,759.70
    $25,549.52 $25,476.11 $25,400.62 $25,323.00 $25,243.17 $25,161.10

    You might also like