0% encontró este documento útil (0 votos)
95 vistas38 páginas

Premisas de Ventas y Costos Anuales

El documento presenta las premisas de ventas, costos y presupuestos de equipos de una empresa para 12 meses. Se detallan las ventas mensuales y anuales de 3 productos, así como los costos mensuales y anuales asociados. También incluye fórmulas y costos unitarios de los ingredientes de los productos, y una lista de equipos requeridos con sus precios unitarios y totales.
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLS, PDF, TXT o lee en línea desde Scribd
0% encontró este documento útil (0 votos)
95 vistas38 páginas

Premisas de Ventas y Costos Anuales

El documento presenta las premisas de ventas, costos y presupuestos de equipos de una empresa para 12 meses. Se detallan las ventas mensuales y anuales de 3 productos, así como los costos mensuales y anuales asociados. También incluye fórmulas y costos unitarios de los ingredientes de los productos, y una lista de equipos requeridos con sus precios unitarios y totales.
Derechos de autor
© © All Rights Reserved
Nos tomamos en serio los derechos de los contenidos. Si sospechas que se trata de tu contenido, reclámalo aquí.
Formatos disponibles
Descarga como XLS, PDF, TXT o lee en línea desde Scribd

PREMISAS DE VENTAS

PRECIO DE PRECIO DE PRECIO DE


MES PPRODUCTO 1 TOTAL PPRODUCTO 2 TOTAL PPRODUCTO 3 TOTAL TOTAL
VENTA VENTA VENTA
MES 1 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 2 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 3 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 4 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 5 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 6 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 7 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 8 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 9 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 10 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 11 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
MES 12 14000 8.00 112,000.00 10,000 12.00 120,000.00 232,000.00
TOTAL 168000 1,344,000.00 120,000.00 1,440,000.00 2,784,000.00
VENTAS ANUALES

MES COSTO TOTAL COSTO TOTAL COSTO TOTAL TOTAL


MES 1 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 2 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 3 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 4 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 5 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 6 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 7 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 8 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 9 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 10 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 11 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
MES 12 14000 3.67 51,333.70 10,000 $ 8.59 85,875.06 0 $ - 0.00 137,208.77
TOTAL 168000 616,004.45 120,000.00 1,030,500.75 0.00 0.00 1,646,505.20
NOTA: LAS ESTIMACIONES PRESENTADAS EN LOS PRESENTES ESTADOS FINANCIEROS SON EN BASE A LAS INVESTIGACIONES DE MERCADOS, LOS CALCULOS DE LOS COSTOS SON
CONFORME A LA INVESTIGACION REALIZADA POR LOS EMPRESARIOS EN CUANTO A LOS PROMEDIOS DE LOS PRECIOS DE LAS MATERIAS PRIMAS QUE HABRAN DE NECESITAR PARA LA
ELABORACION DE LOS ALIMENTOS.
PRESUPUESTO DE COSTO

COSTO UNITARIO DE MATERIAS PRIMAS

Unidades Precio cantidad Importe


Producto y presentacion Ingredientes del producto de Medida unitario utilizada/prod. unitario total DIF. UNITARIA PRECIO PUBLICO
Nectar de durazno Durazno Kilo $ 28.50 0.0451 1.2839
y naranja presentacion Naranja Kilo $ 4.00 0.0265 0.1060
de 265 ml Agua Kilo $ 0.25 0.1687 0.0422
Azucar Kilo $ 12.20 0.0265 0.3233
Acido citrico Kilo $ 120.00 0.0007 0.0795
Benzoato de sodio Kilo $ 120.00 0.0003 0.0318
Envase Pieza $ 1.80 1.00000 1.8000
0.0
0.0
0.0
0.0
0.0
0.0
0.0
total $ 3.67 -$ 3.67
850 ml Durazno Kilo $ 28.50 0.1445 4.118
Naranja Kilo $ 4.00 0.085 0.340
Agua Kilo $ 0.25 0.541025 0.135
Azucar Kilo $ 12.20 0.085 1.037
Acido citrico Kilo $ 120.00 0.002125 0.255
Benzoato de sodio Kilo $ 120.00 0.00085 0.102
Envase Pieza $ 2.60 1 2.600
0.0
0.0
0.0
0.0
Total 8.6
3 0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
total 0.0

$ -
$ -
$ -
$ -
$ -
$ -
Total 0 $ -
FORMULACION
17
10
63.65
10
0.25
0.1
1
102
PRESUPUESTOS DE EQUIPOS POR ADQUIRIR

MAQUINARIA Y EQUIPOS UNIDAD CANTIDAD PRECIO U. PRECIO T.


Embotelladora semi automatica Piezas 1 $15,320 15,320.00
Marmita electrica Piezas 1 $255,000.00 255,000.00
Licuadora Industrial Piezas 1 $17,400 17,400.00
Lavadora de frutas Piezas 1 $85,200 85,200.00
Etiquetadora Piezas 1 $47,000 47,000.00
Mesas de acero inoxidable Piezas 2 $7,100 14,200.00
Utensilios Piezas 1 $21,225 21,225.00
Equipo de laboratorio Piezas 1 $26,350 26,350.00
-
-
-
-
-
-
-
- MOBILIARIO Y EQUIPO
-
- PORCENTAJE ANUAL MENSUAL
- 10% 48,169.50 4,014.13
-
- EQUIPO ADMINISTRATIVO
-

481,695.00 20% 5,000.00 416.67

EQUIPO DE REPARTO

PORCENTAJE ANUAL MENSUAL

20% 50,000.00 4,166.67


EQUIPOS ADMINISTRATIVOS UNIDAD CANTIDAD PRECIO U. PRECIO T.
Equipo de oficina Piezas 1 $25,000.00 25,000.00
-
PRECIO UNIRTARIO DE
- OBRA AREA EN m² m² PRECIO TOTAL

Total 25,000.00 0
0
0
0
0
0
0
0
0
0
0
0
0
TOTAL 505200
Construccion de la empresa UNIDAD CANTIDAD PRECIO U. PRECIO T.
Obra civil Metros 120 4,210.00 505,200.00 OBRA CIVIL
PORCENTAJE ANUAL MENSUAL

5% 25,260.00 2,105
EQUIPO DE REPARTO UNIDAD CANTIDAD PRECIO U. PRECIO T.
Camioneta Repartidora Pieza 1 250,000 250,000.00
-
250,000.00
PREMISA DE MANO DE OBRA

Puesto Prima Vacacional


Sueldo base Aguinaldo Impuesto sobre Sueldo mensual
Sueldo diario Dias del mes (25% de 6 IMSS (34%) SAR (2%) Sueldo anual
mensual (15 días) Nóminas (2%) integrado
Días)
Mano de obra directa
Responsable de la empresa 270.00 30 $8,100.00 $4,050.00 $405.00 $2,754.00 $162.00 $162.00 $11,178.00 $138,591.00
Encargado de Produccion y ventas 180.00 30 $5,400.00 $2,700.00 $270.00 $1,836.00 $108.00 $108.00 $7,452.00 $92,394.00
Obrero 120.00 30 $3,600.00 $1,800.00 $180.00 $1,224.00 $72.00 $72.00 $4,968.00 $61,596.00
$17,100.00 $8,550.00 $855.00 $5,814.00 $342.00 $342.00 $23,598.00 $292,581.00

TOTAL MANO DE OBRA $17,100.00 $8,550.00 $855.00 $5,814.00 $342.00 $342.00 $23,598.00 $292,581.00

MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11
Plazas MANO DE OBRA COSTO COSTO COSTO COSTO COSTO COSTO COSTO COSTO COSTO COSTO COSTO
Mano de obra directa
1 Responsable de la empresa 11,178.00 11,178.00 11,178.00 11,178.00 11,178.00 11,178.00 11,178.00 11,178.00 11,178.00 11,178.00 11,178.00
2 Encargado de Produccion y ventas 14,904.00 14,904.00 14,904.00 14,904.00 14,904.00 14,904.00 14,904.00 14,904.00 14,904.00 14,904.00 14,904.00
4 Obrero 19,872.00 19,872.00 19,872.00 19,872.00 19,872.00 19,872.00 19,872.00 19,872.00 19,872.00 19,872.00 19,872.00
Total mano de obra 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00
MES 12 TOTAL
COSTO COSTO

15,633.00 $138,591.00
20,844.00 $184,788.00
27,792.00 $246,384.00
64,269.00 $569,763.00
PROGRAMA DE EGRESOS AÑO # 1

CONCEPTO IMPORTE MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11
Materia prima directa
Producto 1 22.66% $616,004.45 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70
Producto 2 37.91% $1,030,500.75 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06
0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS: 60.57% $1,646,505.20 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77

Insumos
0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Mano de Obra
Responsable de la empresa 5.10% $138,591.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00
Encargado de Produccion 6.80% $184,788.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00
Obrero 9.06% $246,384.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00
SUMAS: 20.96% $569,763.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00
0.00%
Gastos de servicios
Agua potable 0.11% $3,000.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00
Energia electrica 3.31% $90,000.00 $7,500.00 $7,500.00 $7,500.00 $7,500.00 $7,500.00 $7,500.00 $7,500.00 $7,500.00 $7,500.00 $7,500.00 $7,500.00
Gas 0.22% $6,000.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00
Mantenimiento 0.22% $6,000.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00 $500.00
Otros 0.44% $12,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00 $1,000.00
SUMAS: 4.30% $117,000.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00 $9,750.00

Gastos de Venta
Publicidad 1.10% $30,000.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00 $2,500.00
Distribucion 7.50% $204,000.00 $17,000.00 $17,000.00 $17,000.00 $17,000.00 $17,000.00 $17,000.00 $17,000.00 $17,000.00 $17,000.00 $17,000.00 $17,000.00
SUMAS: 8.61% $234,000.00 $19,500.00 $19,500.00 $19,500.00 $19,500.00 $19,500.00 $19,500.00 $19,500.00 $19,500.00 $19,500.00 $19,500.00 $19,500.00

Gastos de Administracion
Limpieza 0.31% $8,400.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00
Papeleria 0.18% $4,800.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00 $400.00
Telefono 0.35% $9,600.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00
DEPRECIACION DE EDIFICIO 0.93% $25,260.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00
DEPRECIACION DE EQUIPO DE
REPARTO 1.84% $50,000.00 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67
DEPRECIACION DE MOBILIARIO
ADMVO 0.18% $5,000.00 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67
DEPRECIACION DE MAQUINARIA Y
EQUIPO 1.77% $48,169.50 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13
SUMAS 5.56% $151,229.50 $12,602.46 $12,602.46 $12,602.46 $12,602.46 $12,602.46 $12,602.46 $12,602.46 $12,602.46 $12,602.46 $12,602.46 $12,602.46

Gastos financieros
INTERESES FONAES 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES CAPITAL SEMILLA 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES FONAY 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
GRAN TOTAL 100.00% $2,718,497.70 $225,015.22 $225,015.22 $225,015.22 $225,015.22 $225,015.22 $225,015.22 $225,015.22 $225,015.22 $225,015.22 $225,015.22 $225,015.22
NOTA: LOS COSTOS Y GASTOS PRESENTES EN ESTE ANALISIS INCLUYEN EL IVA, SON PROPORCIONADOS EN BASE A LA INVESTIGACION REALIZADA POR EL EMPRESARIO SOBRE PRESUPUESTOS DE SUS FUTUROS EGRESOS.

PROGRAMA DE EGRESOS AÑO # 2

CONCEPTO IMPORTE MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11
Materia prima directa
22.66% $616,004.45 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70
37.91% $1,030,500.75 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06
0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS: 60.57% $1,646,505.20 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77

Insumos
Aditivos 0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Mano de obra
5.10% $138,591.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00
6.80% $184,788.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00
Obrero 9.06% $246,384.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00
SUMAS: 20.96% $569,763.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00

Gastos de servicio
Imprevistos 0.00% $0.00
0.00% $0.00
0.00% $0.00
0.00% $0.00
0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gastos de Venta
0.00% $0.00
0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gastos de Administracion
0.31% $8,400.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00
0.00% $0.00
0.35% $9,600.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00
DEPRECIACION DE EDIFICIO 0.93% $25,260.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00
DEPRECIACION DE EQUIPO DE
REPARTO 1.84% $50,000.00 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67
DEPRECIACION DE MOBILIARIO
ADMVO 0.18% $5,000.00 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67
DEPRECIACION DE MOBILIARIO 1.77% $48,169.50 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13
SUMAS 5.39% $146,429.50 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46

Gastos financieros
INTERESES FONAES 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES CAPITAL SEMILLA 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES FONAY 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
GRAN TOTAL 86.91% $2,362,697.70 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22

NOTA: LOS COSTOS Y GASTOS PRESENTES EN ESTE ANALISIS


INCLUYEN EL IVA, SON PROPORCIONADOS EN BASE A LA
INVESTIGACION REALIZADA POR EL EMPRESARIO SOBRE
PRESUPUESTOS DE SUS FUTUROS EGRESOS.

PROGRAMA DE EGRESOS AÑO # 3

CONCEPTO IMPORTE MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11
Materia prima directa
22.66% $616,004.45 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70
37.91% $1,030,500.75 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06
0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS: 60.57% $1,646,505.20 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77

Insumos
Aditivos 0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Mano de Obra Directa


Encargado de la Empresa 5.10% $138,591.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00
Encargado de Produccion 6.80% $184,788.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00
Obrero 9.06% $246,384.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00
SUMAS: 20.96% $569,763.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00
0.00%
Gastos de servicio
0.00% $0.00
0.00% $0.00
0.00% $0.00
0.00% $0.00
0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gastos de Venta
0.00% $0.00
0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gastos de Administracion
0.00% $0.00
0.00% $0.00
0.00% $0.00
DEPRECIACION DE EDIFICIO 0.93% $25,260.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00
DEPRECIACION DE EQUIPO DE
REPARTO 1.84% $50,000.00 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67
DEPRECIACION DE MOBILIARIO
ADMVO 0.18% $5,000.00 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67
DEPRECIACION DE MOBILIARIO 1.77% $48,169.50 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13
SUMAS 4.72% $128,429.50 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46

Gastos financieros
INTERESES FONAES 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES CAPITAL SEMILLA 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES FONAY 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
GRAN TOTAL 86.25% $2,344,697.70 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22

NOTA: LOS COSTOS Y GASTOS PRESENTES EN ESTE ANALISIS


INCLUYEN EL IVA, SON PROPORCIONADOS EN BASE A LA
INVESTIGACION REALIZADA POR EL EMPRESARIO SOBRE
PRESUPUESTOS DE SUS FUTUROS EGRESOS.

PROGRAMA DE EGRESOS AÑO # 4

CONCEPTO IMPORTE MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11
Materia prima directa
Costos de Produccion del chorizo de
camaron 250 grs. 22.66% $616,004.45 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70
37.91% $1,030,500.75 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06
0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS: 60.57% $1,646,505.20 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77

Insumos
Aditivos 0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Mano de Obra Directa


Encargado de la Empresa 5.10% $138,591.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00
Encargado de Produccion 6.80% $184,788.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00
Obrero 9.06% $246,384.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00
SUMAS: 20.96% $569,763.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00
0.00%
Gastos de servicio
Imprevistos 0.00% $0.00
0.00% $0.00
0.00% $0.00
0.00% $0.00
0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gastos de Venta
0.00% $0.00
0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gastos de Administracion
*Art. De limpieza 0.00% $0.00
Papeleria 0.00% $0.00
Telefono 0.00% $0.00
DEPRECIACION DE EDIFICIO 0.93% $25,260.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00
DEPRECIACION DE EQUIPO DE
REPARTO 1.84% $50,000.00 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67
DEPRECIACION DE MOBILIARIO
ADMVO 0.18% $5,000.00 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67
DEPRECIACION DE MOBILIARIO 1.77% $48,169.50 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13
SUMAS 4.72% $128,429.50 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46 $10,702.46

Gastos financieros
INTERESES FONAES 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES CAPITAL SEMILLA 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES FONAY 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
GRAN TOTAL 86.25% $2,344,697.70 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22 $193,865.22

NOTA: LOS COSTOS Y GASTOS PRESENTES EN ESTE ANALISIS


INCLUYEN EL IVA, SON PROPORCIONADOS EN BASE A LA
INVESTIGACION REALIZADA POR EL EMPRESARIO SOBRE
PRESUPUESTOS DE SUS FUTUROS EGRESOS.

PROGRAMA DE EGRESOS AÑO # 5

CONCEPTO IMPORTE MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11
Materia prima
22.66% $616,004.45 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70 $51,333.70
37.91% $1,030,500.75 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06 $85,875.06
0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS: 60.57% $1,646,505.20 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77 $137,208.77

Insumos
Aditivos 0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Mano de Obra
5.10% $138,591.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00 $11,178.00
6.80% $184,788.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00 $14,904.00
9.06% $246,384.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00 $19,872.00
SUMAS: 20.96% $569,763.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00 $45,954.00
0.00%
Gastos de servicio
Imprevistos 0.00% $0.00
0.00% $0.00
0.00% $0.00
0.00% $0.00
0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gastos de Venta
0.00% $0.00
0.00% $0.00
SUMAS: 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

Gastos de Administracion
0.31% $8,400.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00 $700.00
0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
0.35% $9,600.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00 $800.00
DEPRECIACION DE EDIFICIO 0.93% $25,260.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00 $2,105.00
DEPRECIACION DE EQUIPO DE
REPARTO 1.84% $50,000.00 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67 $4,166.67
DEPRECIACION DE MOBILIARIO
ADMVO 0.18% $5,000.00 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67 $416.67
DEPRECIACION DE MOBILIARIO 1.77% $48,169.50 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13 $4,014.13
SUMAS 5.39% $146,429.50 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46 $12,202.46
Gastos financieros
INTERESES FONAES 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES CAPITAL SEMILLA 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
INTERESES FONAY 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
SUMAS 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
GRAN TOTAL 86.91% $2,362,697.70 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22 $195,365.22

NOTA: LOS COSTOS Y GASTOS PRESENTES EN ESTE ANALISIS


INCLUYEN EL IVA, SON PROPORCIONADOS EN BASE A LA
INVESTIGACION REALIZADA POR EL EMPRESARIO SOBRE
PRESUPUESTOS DE SUS FUTUROS EGRESOS.
MES 12

$51,333.70
$85,875.06
$0.00
$137,208.77

$0.00

$15,633.00
$20,844.00
$27,792.00
$64,269.00

$250.00
$7,500.00
$500.00
$500.00
$1,000.00
$9,750.00

$2,500.00
$17,000.00
$19,500.00

$700.00
$400.00
$800.00
$2,105.00

$4,166.67

$416.67

$4,014.13
$12,602.46

$0.00
$0.00
$0.00
$0.00
$243,330.22

MES 12

$51,333.70
$85,875.06
$0.00
$137,208.77

$0.00

$15,633.00
$20,844.00
$27,792.00
$64,269.00

$0.00

$0.00

$700.00

$800.00
$2,105.00

$4,166.67

$416.67
$4,014.13
$12,202.46

$0.00
$0.00
$0.00
$0.00
$213,680.22

MES 12

$51,333.70
$85,875.06
$0.00
$137,208.77

$0.00

$15,633.00
$20,844.00
$27,792.00
$64,269.00

$0.00

$0.00

$2,105.00

$4,166.67

$416.67
$4,014.13
$10,702.46

$0.00
$0.00
$0.00
$0.00
$212,180.22

MES 12

$51,333.70
$85,875.06
$0.00
$137,208.77

$0.00

$15,633.00
$20,844.00
$27,792.00
$64,269.00

$0.00

$0.00

$2,105.00

$4,166.67

$416.67
$4,014.13
$10,702.46
$0.00
$0.00
$0.00
$0.00
$212,180.22

MES 12

$51,333.70
$85,875.06
$0.00
$137,208.77

$0.00

$15,633.00
$20,844.00
$27,792.00
$64,269.00

$0.00

$0.00

$700.00
$0.00
$800.00
$2,105.00

$4,166.67

$416.67
$4,014.13
$12,202.46
$0.00
$0.00
$0.00
$0.00
$213,680.22
ESTADO DE RESULTADOS PRO-FORMA
DEL 1° DE ENERO AL 31 DE DICIEMBRE DE LOS AÑOS 1 AL 5

CONCEPTO AÑO 1 AÑO 2 AÑO 3 AÑO 4

AÑO 1 AÑO 2 AÑO 3 AÑO 4


VENTAS 2,784,000.00 100.00% 2,784,000.00 100.00% 2,784,000.00 100.00% 2,784,000.00

COSTO DE LO VENDIDO 2,333,268.20 83.81% 2,216,268.20 79.61% 2,216,268.20 79.61% 2,216,268.20

UTILIDAD BRUTA 450,731.81 16.19% 567,731.81 20.39% 567,731.81 20.39% 567,731.81

GASTOS OPERATIVOS

GASTOS DE ADMINISTRACIÓN 151,229.50 5.43% 146,429.50 5.26% 128,429.50 4.61% 128,429.50

GASTOS DE VENTA 234,000.00 8.41% 0.00 0.00% 0.00 0.00% 0.00

UTILIDAD DE OPERACIÓN 65,502.31 2.35% 421,302.31 15.13% 439,302.31 15.78% 439,302.31

GASTOS FINANCIEROS 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00

UTILIDAD ANTES DE IMPUESTOS 65,502.31 2.35% 421,302.31 15.13% 439,302.31 15.78% 439,302.31

ISR 18,340.65 0.66% 117,964.65 4.24% 123,004.65 4.42% 123,004.65

0.00% 0.00%

RESULTADO NETO 47,161.66 1.69% 303,337.66 10.90% 316,297.66 11.36% 316,297.66

CPT 2,718,497.70
COSTO VARIABLE 2,333,268.20
COSTO FIJO 385,229.50

P. 1 C Variable 616004.45 398,322.54 1,014,326.99


C Fijo 223,433.11
C Prod. Total
Unitario
RESULTADOS PRO-FORMA
ERO AL 31 DE DICIEMBRE DE LOS AÑOS 1 AL 5

AÑO 5

AÑO 5
100.00% 2,784,000.00 100.00%

79.61% 2,216,268.20 79.61%

20.39% 567,731.81 20.39%

4.61% 146,429.50 5.26%

0.00% 0.00 0.00%

15.78% 421,302.31 15.13%

0.00% 0.00 0.00%

15.78% 421,302.31 15.13%

4.42% 117,964.65 4.24%

0.00% 0.00%

11.36% 303,337.66 10.90%


SALSA DE PIÑA CON CHILE HABANERO
PLAN DE INVERSION
UNIDADES CANTIDAD PRECIO TOTAL A VALOR
UNITARIO PAGAR
MATERIA PRIMA
Costo de materias primas 137,208.77
TOTAL MATERIA PRIMA 137,208.77
INSUMOS
0.00
TOTAL 0.00

SUELDOS Y SALARIOS
Encargado de la Empresa 11,178.00
Encargado de Produccion 14,904.00
Obrero 19,872.00
TOTAL SUELDOS Y SALARIOS 45,954.00 45,954.00

GASTOS AL SERVICIO
Agua potable 250.00
Energia electrica 7,500.00
Gas 500.00
Mantenimiento 500.00
Otros 1,000.00
total gastos al servicio 9,750.00
GASTO ADMINISTRATIVO
*Art. De limpieza 700.00
Papeleria 400.00
Telefono 800.00
TOTAL GASTO ADMINISTRATIVO 1,900.00

GASTOS DE VENTAS
2,500.00
17,000.00
TOTAL GASTOS DE VENTAS 19,500.00

TOTAL CAPITAL DE TRABAJO 214,312.77

EQ. DE TRABAJO
EQUIPO DE PRODUCCION
MAQUINARIA Y EQUIPO 481,695.00
EQUIPO DE REPARTO 250,000.00
OBRA CIVIL 505,200.00

EQ. ADMINISTRATIVO
MOBILIARIO DE OFICINA - 25,000.00

TOTAL ACTIVO FIJO 1,261,895.00


ACTIVO DIFERIDO
0.00
0.00
0.00
0.00
0.00
0.00
TOTAL ACTIVO DIFERIDO 0.00
TOTAL ACTIVOS 1,476,207.77
IVA 0.00
TOTAL ACTIVOS 1,476,207.77

NOTA: LAS PRESENTES LISTA DE PRECIOS, DE LOS COSTOS DE EQUIPOS ASI COMO PAGOS DE SERVICIOS, SON BASADOS
EN COTIZACIONES E INVESTIGACIONES .

**EL CAPITAL DE TRABAJO ESTA PROYECTADO PARA UN MES.


PRESUPUESTO DE VENTAS
PRESUPUESTO DE VENTAS
DEL 1 DE ENERO AL 31 DE DICIEMBRE DEL AÑO 1

MODALIDADES MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12 TOTAL

112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 1,344,000.00
120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 1,440,000.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

TOTAL 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 2,784,000.00
Nota: Los calculos no incluyen IVA.

PRESUPUESTO DE VENTAS
DEL 1 DE ENERO AL 31 DE DICIEMBRE DEL AÑO 2

MODALIDADES MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12 TOTAL

112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 1,344,000.00
120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 1,440,000.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

TOTAL 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 2,784,000.00
Nota: Los calculos no incluyen IVA.

PRESUPUESTO DE VENTAS
DEL 1 DE ENERO AL 31 DE DICIEMBRE DEL AÑO 3

MODALIDADES MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12 TOTAL

112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 1,344,000.00
120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 1,440,000.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
TOTAL 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 2,784,000.00
Nota: Los calculos no incluyen IVA.

PRESUPUESTO DE VENTAS
DEL 1 DE ENERO AL 31 DE DICIEMBRE DEL AÑO 4

MODALIDADES MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12 TOTAL

salsa de piña cole


habaneron chi 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 1,344,000.00
120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 1,440,000.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

TOTAL 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 2,784,000.00
Nota: Los calculos no incluyen IVA.

PRESUPUESTO DE VENTAS
DEL 1 DE ENERO AL 31 DE DICIEMBRE DEL AÑO 5

MODALIDADES MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12 TOTAL

salsa de piña con


chile habanero 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 112,000.00 1,344,000.00
120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 120,000.00 1,440,000.00
0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00

TOTAL 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 2,784,000.00
Nota: Los calculos no incluyen IVA.
ESTADO DE COSTO DE PRODUCCIÓN Y VENTA PRO-FORMA
DEL 1° DE ENERO AL 31 DE DICIEMBRE DE LOS AÑOS 1 AL 5

CONCEPTO AÑO 1 AÑO 2 AÑO 3 AÑO 4 AÑO 5


AÑO 1 AÑO 2 AÑO 3 AÑO 4 AÑO 5
Materias primas Utilizadas 1,646,505.20 70.57% 1,646,505.20 74.29% 1,646,505.20 74.29% 1,646,505.20 74.29% 1,646,505.20 74.29%
Mano de Obra Directa 569,763.00 24.42% 569,763.00 25.71% 569,763.00 25.71% 569,763.00 25.71% 569,763.00 25.71%
Costo primo 2,216,268.20 94.99% 2,216,268.20 100.00% 2,216,268.20 100.00% 2,216,268.20 100.00% 2,216,268.20 100.00%
Gastos indirectos de fabricación 117,000.00 5.01% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%
Costo de Producción y venta 2,333,268.20 100.00% 2,216,268.20 100.00% 2,216,268.20 100.00% 2,216,268.20 100.00% 2,216,268.20 100.00%
FLUJO DE EFECTIVO PRO-FORMA
PROYECCIONES DEL PRIMER AL QUINTO AÑO

AÑO 1 AÑO 2 AÑO 3 AÑO 4 AÑO 5


INGRESOS:
SALDO INICIAL 214,312.77 389,903.93 821,671.09 1,266,398.25 1,711,125.40
VENTAS 2,784,000.00 2,784,000.00 2,784,000.00 2,784,000.00 2,784,000.00
TOTAL INGRESO 2,998,312.77 3,173,903.93 3,605,671.09 4,050,398.25 4,495,125.40

EGRESOS:
MATERIAS PRIMAS 1,646,505.20 1,646,505.20 1,646,505.20 1,646,505.20 1,646,505.20
MANO DE OBRA 569,763.00 569,763.00 569,763.00 569,763.00 569,763.00
GASTOS INDIRECTOS DE FAB 117,000.00 0.00 0.00 0.00 0.00
GASTOS DE ADMINISTRACIÓN 151,229.50 146,429.50 128,429.50 128,429.50 146,429.50
GASTOS DE VENTA 234,000.00 0.00 0.00 0.00 0.00
GASTOS FINANCIEROS 0.00 0.00 0.00 0.00 0.00
PAGO DE DEUDA 0.00 0.00 0.00 0.00 0.00
PAGO DE IMPUESTOS 18,340.65 117,964.65 123,004.65 123,004.65 117,964.65
TOTAL EGRESOS 2,736,838.34 2,480,662.34 2,467,702.34 2,467,702.34 2,480,662.34

SALDO PRELIMINAR 261,474.43 693,241.59 1,137,968.75 1,582,695.90 2,014,463.06


MAS DEPRECIACIONES 128,429.50 128,429.50 128,429.50 128,429.50 128,429.50
IVA ACREDITABLE 0.00 0.00 0.00 0.00 0.00
AMORTIZACIONES 0.00 0 0 0 0
SALDO FINAL 389,903.93 821,671.09 1,266,398.25 1,711,125.40 2,142,892.56

FLUJOS DE EFECTIVO PRO-FORMA


PROYECCIONES DEL PRIMER AÑO

MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
INGRESOS:
SALDO INICIAL 214,312.77 230,471.61 246,630.46 262,789.31 278,948.15 295,107.00 311,265.85 327,424.69 343,583.54 359,742.39 375,901.23 392,060.08
VENTAS 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00 232,000.00
TOTAL INGRESO 446,312.77 462,471.61 478,630.46 494,789.31 510,948.15 527,107.00 543,265.85 559,424.69 575,583.54 591,742.39 607,901.23 624,060.08

EGRESOS:
MATERIAS PRIMAS 137,208.77 137,208.77 137,208.77 137,208.77 137,208.77 137,208.77 137,208.77 137,208.77 137,208.77 137,208.77 137,208.77 137,208.77
INSUMOS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
MANO DE OBRA 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 45,954.00 64,269.00
GASTOS INDIRECTOS DE FAB 9,750.00 9,750.00 9,750.00 9,750.00 9,750.00 9,750.00 9,750.00 9,750.00 9,750.00 9,750.00 9,750.00 9,750.00
GASTOS DE ADMINISTRACIÓN 12,602.46 12,602.46 12,602.46 12,602.46 12,602.46 12,602.46 12,602.46 12,602.46 12,602.46 12,602.46 12,602.46 12,602.46
GASTOS DE VENTA 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00 19,500.00
GASTOS FINANCIEROS 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
PAGO DE DEUDA 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
PAGO DE IMPUESTOS 1,528.39 1,528.39 1,528.39 1,528.39 1,528.39 1,528.39 1,528.39 1,528.39 1,528.39 1,528.39 1,528.39 1,528.39
TOTAL EGRESOS 226,543.61 226,543.61 226,543.61 226,543.61 226,543.61 226,543.61 226,543.61 226,543.61 226,543.61 226,543.61 226,543.61 244,858.61

SALDO PRELIMINAR 219,769.15 235,928.00 252,086.85 268,245.69 284,404.54 300,563.39 316,722.23 332,881.08 349,039.93 365,198.77 381,357.62 379,201.47
MAS DEPRECIACIONES 10,702.46 10,702.46 10,702.46 10,702.46 10,702.46 10,702.46 10,702.46 10,702.46 10,702.46 10,702.46 10,702.46 10,702.46
IVA ACREDITABLE 0.00
AMORTIZACIONES 0.00 0 0 0 0 0 0 0 0 0 0 0
SALDO FINAL 230,471.61 246,630.46 262,789.31 278,948.15 295,107.00 311,265.85 327,424.69 343,583.54 359,742.39 375,901.23 392,060.08 389,903.93
LUJOS DE EFECTIVO PRO-FORMA
PROYECCIONES DEL PRIMER AÑO

TOTAL

0.00
2,784,000.00
2,784,000.00

1,646,505.20
0.00
569,763.00
117,000.00
151,229.50
234,000.00
0.00
0.00
18,340.65
2,736,838.34

0.00
128,429.50
0.00
0.00
128,429.50
BALANCE GENERAL PRO-FORMA
DEL 1 AL 31 DE DICIEMBRE DE LOS AÑOS 1 AL 5

CONCEPTO AÑO 1 AÑO 2 AÑO 3 AÑO 4 AÑO 5

AÑO 0 AÑO 1 AÑO 2 AÑO 3 AÑO 4 AÑO 5


CIRCULANTE
CAJA Y BANCOS 214,312.77 22.07% 389,903.93 37.20% 821,671.09 59.69% 1,266,398.25 73.71% 1,711,125.40 83.08% 2,142,892.56 89.72%
IVA ACREDITABLE 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%
TOTAL ACTIVO CIRCULANTE 214,312.77 22.07% 389,903.93 37.20% 821,671.09 59.69% 1,266,398.25 73.71% 1,711,125.40 83.08% 2,142,892.56 89.72%
FIJO
EQ. DE TRABAJO 481,695.00 49.61% 433,525.50 41.37% 385,356.00 27.99% 337,186.50 19.62% 289,017.00 14.03% 240,847.50 10.08%
DEPRECIACIÓN 48,169.50 4.96% 48,169.50 4.60% 48,169.50 3.50% 48,169.50 2.80% 48,169.50 2.34% 48,169.50 2.02%
EQ. DE REPARTO 250,000.00 25.75% 200,000.00 19.08% 150,000.00 10.90% 100,000.00 5.82% 50,000.00 2.43% 0.00 0.00%
DEPRECIACIÓN 50,000.00 5.15% 50,000.00 4.77% 50,000.00 3.63% 50,000.00 2.91% 50,000.00 2.43% 50,000.00 2.09%
EQ. ADMINISTRATIVO 25,000.00 2.57% 24,583.33 2.35% 19,583.33 1.42% 14,583.33 0.85% 9,583.33 0.47% 4,583.33 0.19%
DEPRECIACIÓN 416.67 0.04% 5,000.00 0.48% 5,000.00 0.36% 5,000.00 0.29% 5,000.00 0.24% 5,000.00 0.21%
TOTAL ACTIVO FIJO 756,695.00 77.93% 658,108.83 62.80% 554,939.33 40.31% 451,769.83 26.29% 348,600.33 16.92% 245,430.83 10.28%
DIFERIDO
C ONTRATOS DE SERVICIOS 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%
TOTAL ACTIVO DIFERIO 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%
TOTAL ACTIVOS 971,007.77 100.00% 1,048,012.76 100.00% 1,376,610.42 100.00% 1,718,168.08 100.00% 2,059,725.74 100.00% 2,388,323.40 100.00%

PASIVOS
PASIVO CIRCULANTE 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%
IVA POR VENTA 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%
DEUDA A CORTO PLAZO 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%
TOTAL CIRCULANTE 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%
PASIVO L/PLAZO
DEUDA A LARGO PLAZO 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%
TOTAL DE PASIVO 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00% 0.00 0.00%

CAPITAL SOCIAL 971,007.77 100.00% 971,007.77 95.37% 971,007.77 73.48% 971,007.77 59.29% 971,007.77 49.69% 971,007.77 43.01%
RESERVA LEGAL 0.00 2,358.08 17,524.97 33,339.85 49,154.73 64,321.61
RESULTADO DELEJERCIO ANTE
0.00% 0.00 0.00% 44,803.58 3.39% 332,974.35 20.33% 633,457.13 32.42% 933,939.91 41.37%
UTILIDAD POR APLICAR DEL 0.00 0.00% 44,803.58 4.40% 288,170.78 21.81% 300,482.78 18.35% 300,482.78 15.38% 288,170.78 12.77%
EJERCICIO
TOTAL DEL CAPITAL 971,007.77 100.00% 1,018,169.43 100.00% 1,321,507.09 100.00% 1,637,804.75 100.00% 1,954,102.40 100.00% 2,257,440.06 100.00%

PASIVO Y CAPITAL 971,007.77 100.00% 1,018,169.43 100.00% 1,321,507.09 100.00% 1,637,804.75 100.00% 1,954,102.40 100.00% 2,257,440.06 100.00%
0.00 29,843.33 55,103.33 80,363.33 105,623.33 130,883.33
PROYECCIONES DE LAS POSIBLES FUENTES DE FINANCIAMIENTO

SAGARPA

MONTO DE INVERSION $1,476,207.77


$1,476,207.77
PORCENTAJE DE APOYO $0.00

TASA DE INTERES ANUAL 0.00%

ANOS DE AMORTIZACION 1.00

AMORTIZACION DE CAPITAL ANUAL MENSUAL


A 5 ANOS $0.00 $0.00 0.00

MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Interés $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Capital $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Interés $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Capital $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

PAGO TOTAL $0.00


CAPITAL $0.00
INTERESES $0.00
INT. PROM $0.00
PAGO MENSUAL $0.00
SUMA $0.00
PAGO DIARIO $0.00
PROYECCIONES DE LAS POSIBLES FUENTES DE FINANCIAMIENTO

CAPITAL SEMILLA

MONTO DE INVERSION $1,476,207.77


$1,476,207.77
APOYO $0.00

TASA DE INTERES ANUAL 10%

ANOS DE AMORTIZACION 4.00

AMORTIZACION DE CAPITAL ANUAL MENSUAL


A 5 ANOS $0.00 $0.00 0.00

MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Interés $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Capital $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

PAGO TOTAL $0.00


CAPITAL $0.00
INTERESES $0.00
INT. PROM $0.00
PAGO MENSUAL $0.00
SUMA $0.00
PAGO DIARIO $0.00
PROYECCIONES DE LAS POSIBLES FUENTES DE FINANCIAMIENTO

FONAY

MONTO DE INVERSION $1,476,207.77


$1,476,207.77
PORCENTAJE DE APOYO $0.00

TASA DE INTERES ANUAL 14%

ANOS DE AMORTIZACION 1.00

AMORTIZACION DE CAPITAL ANUAL MENSUAL


A 5 ANOS $0.00 $0.00 0.00

MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Interés $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Capital $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Interés $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Capital $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Total $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
ENERO FEBRERO MARZO ABRIL MAYO JUNIO JULIO AGOSTO SEPTIEMBRE OCTUBRE NOVIEMBRE DICIEMBRE
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
MES 1 MES 2 MES 3 MES 4 MES 5 MES 6 MES 7 MES 8 MES 9 MES 10 MES 11 MES 12
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

PAGO TOTAL $0.00


CAPITAL $0.00
INTERESES $0.00
INT. PROM $0.00
PAGO MENSUAL $0.00
SUMA $0.00
PAGO DIARIO $0.00
EVALUACION FINANCIERA
RAZONES RESULTADOS POR AÑO
FORMULA
FINANCIERAS: 1 2 3 4 5

Punto de equilibrio Costos fijos


PEF = ### 718,049.83 629,782.80 629,782.80 718,049.83
operativo 1- (Costos variables / Ingresos)

Punto de equilibrio (Costos fijos + amortizaciones)


PEF = ### 718,049.83 629,782.80 629,782.80 718,049.83
financiero 1- (Costos variables / Ingresos)
EVALUACION FINANCIERA

TMAR=interes +
PORCENTAJE DE
COSTO DE CAPITAL Inflacion + (interes PONDERACION
CAPITAL TOTAL
*Inflacion)

INVERSIONIST 1,476,207.77 50.00% 18.80% 9.400%


0.00% 0.00% 0.000%
0.00% 10.00% 0.000%
FINANCIAMIEN 0.00% 50.00% 14.00% 7.000%

TOTAL DE INVE 1,476,207.77 100.00% 16.400%


1,476,207.77
INFLACION 10%
PREMIO AL
RIESGO 8%

PRI
FUJOS AL FLUJOS

INV. INICIAL AÑO PRESENTE ACTUALES

0 -1,476,207.77 -1,476,207.77

1 389,903.93 334,969.01 -1,141,238.76

2 821,671.09 606,445.87 -534,792.89


FLUJOS
3 1,266,398.25 802,992.26 268,199.37

4 1,711,125.40 932,115.90 1,200,315.28

5 2,142,892.56 1,002,848.89 2,203,164.16

SUMATORIA 4,855,783.46 2,203,164.16

K= 16% C

VAN RBC PRI TIR

4,855,783.46 2.93 3 55%


% AÑOS %

También podría gustarte