Costos Tesis Trapiche 2p3i57
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 2z6p3t
Overview 5o1f4z
& View Costos Tesis Trapiche as PDF for free.
More details 6z3438
- Words: 1,791
- Pages: 33
TABLA DE AMORTIZACION MENSUAL DEL P
PRESTAMO BANCARIO Monto del Préstamo 80,000,000.00 Tipo de interés 24.00% Tipo de interés efectivo 1.809% Duración (en años) 2.00 Frecuencia de pago Mensual Sistema de pago elegido Cuotas constantes Número de pagos 24 Totales Suma de las cuotas Suma de los intereses
98,087,582.48 18,087,582.48
Período
Cuota Mensual
Intereses
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
4,780,339.93 4,720,047.99 4,659,756.05 4,599,464.11 4,539,172.17 4,478,880.22 4,418,588.28 4,358,296.34 4,298,004.40 4,237,712.46 4,177,420.52 4,117,128.57 4,056,836.63 3,996,544.69 3,936,252.75 3,875,960.81 3,815,668.87 3,755,376.92 3,695,084.98 3,634,793.04 3,574,501.10 3,514,209.16 3,453,917.22 3,393,625.27
1,447,006.60 1,386,714.66 1,326,422.72 1,266,130.77 1,205,838.83 1,145,546.89 1,085,254.95 1,024,963.01 964,671.07 904,379.12 844,087.18 783,795.24 723,503.30 663,211.36 602,919.42 542,627.47 482,335.53 422,043.59 361,751.65 301,459.71 241,167.77 180,875.82 120,583.88 60,291.94
MORTIZACION MENSUAL DEL PRESTAMO Cuota Amortización 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33
Capital por Amortizar
Capital Amortizado
80,000,000.00 76,666,666.67 73,333,333.33 70,000,000.00 66,666,666.67 63,333,333.33 60,000,000.00 56,666,666.67 53,333,333.33 50,000,000.00 46,666,666.67 43,333,333.33 40,000,000.00 36,666,666.67 33,333,333.33 30,000,000.00 26,666,666.67 23,333,333.33 20,000,000.00 16,666,666.67 13,333,333.33 10,000,000.00 6,666,666.67 3,333,333.33 0.00
3,333,333.33 6,666,666.67 10,000,000.00 13,333,333.33 16,666,666.67 20,000,000.00 23,333,333.33 26,666,666.67 30,000,000.00 33,333,333.33 36,666,666.67 40,000,000.00 43,333,333.33 46,666,666.67 50,000,000.00 53,333,333.33 56,666,666.67 60,000,000.00 63,333,333.33 66,666,666.67 70,000,000.00 73,333,333.33 76,666,666.67 80,000,000.00
TABLA DE AMORTIZACION DE CREDITO ANUALIZADA MONTO DEL CREDITO TASA ANUALIZADA CUOTAS
80,000,000.00 24% 24
TABLA DE AMORTIZACION ANUAL DEL PRESTAMO Período 0 1 2 3 4 5
Cuota ANUAL
Intereses
Cuota Amortización
Capital por Amortizar
0.00 0.00 0.00 80,000,000.00 0.00 53,384,811.04 13,384,811.04 40,000,000.00 40,000,000.00 40,000,000.00 44,702,771.45 4,702,771.45 40,000,000.00 0.00 80,000,000.00 0.00 0.00 0.00 0.00 80,000,000.00 0.00 0.00 0.00 0.00 80,000,000.00 0.00 0.00 0.00 0.00 80,000,000.00 98,087,582.48 18,087,582.48
PRESTAMOS ANUALIZADO amortizacion vs. intereses
44,702,771.45
53,384,811.04
60,000,000.00
50,000,000.00
40,000,000.00
13,384,811.04 10,000,000.00
40,000,000.00
40,000,000.00
30,000,000.00
20,000,000.00
Capital Amortizado
40,000,000.
40,000,000.
20,000,000.00
13,384,811.04 10,000,000.00
2 Interes es
0.003
Cuota Amortiza ci ón
0.004
Cuota ANUAL
0.00 0.00
1
0.00 0.00
0.00
0.00 0.00
4,702,771.45
0.005
PERSONAL
cantidad
SUELDO
TOTAL SUELDO
Gerente General
1
12,000.00
12,000.00
Encargado de Produccion
1
10,000.00
10,000.00
Engargado de Ventas
1
10,000.00
10,000.00
Operarios
9
4,500.00
40,500.00 0.00 0.00 0.00 0.00
12 BONO DE ALIMENTACION MENSUAL:
72,500.00 450.00
VARIABLES DE LA NOMINA VALOR NOMINA AÑO 1 VAR. INTER ANUAL SUELDO
870,000.00 5000%
VALOR CESTATICKETS AÑO 1
64,800.00
VALOR UNIDAD TRIBUTARIA (U.T.)
0.0012
DIAS VAC.+BONO VAC.
28
VARIACION U.T. INTERANUAL
200%
DIAS UTILIDADES
60
VALOR CESTATICKETS
450.00
NUMERO DE EMPLEADOS
2
SUELDO MENSUAL PROM. AÑO 1
11,000.00
NUMERO DE OBREROS
10
SALARIO MENSUAL PROM. AÑO 1
1,450.00
PRESUPUESTO DE NOMINA
AÑO
NOMINA
CESTATICKETS
VACACIONES
1
870,000.00
64,800.00
67,666.67
2
44,370,000.00
194,400.00
3,451,000.00
3
2,262,870,000.00
583,200.00
176,001,000.00
4
115,406,370,000.00
1,749,600.00
8,976,051,000.00
5
5,885,724,870,000.00
5,248,800.00
457,778,601,000.00
PORCENTAJE AÑO
TOTAL NOMINA
8%
83%
ISTRACION
PRODUCCION
1
1,303,266.67
108,605.56
1,086,055.56
2
62,837,800.00
5,236,483.33
52,364,833.33
3
3,193,841,400.00
266,153,450.00
2,661,534,500.00
4
162,853,252,200.00
13,571,104,350.00
135,711,043,500.00
5
8,305,417,884,600.00
692,118,157,050.00
6,921,181,570,500.00
PRESUPUESTO DE NOMINA 1,200,000,000,000.00 1,000,000,000,000.00 800,000,000,000.00 600,000,000,000.00 400,000,000,000.00
1,000,000,000,000.00 800,000,000,000.00 600,000,000,000.00 400,000,000,000.00 200,000,000,000.00 0.00
1
2 CESTATICKETS
VACACIONES
3 UTILIDADES
4 ANTIGÜEDAD
5
BONO DE ALIMENTACION
TOTAL MENSUAL
AREA
450.00
12,450.00
ISTRACION
450.00
10,450.00
PRODUCCION
450.00
10,450.00
VENTAS
4,050.00
44,550.00
PRODUCCION
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
5,400.00
DISTRIBUCION DE LA N
Opera ri os
Engargado de Ventas
77,900.00
Encargado de Producci on
Gerente Genera l
0.00
OMINA
10,000.00
TOTAL SUELDO
UTILIDADES
ANTIGÜEDAD
TOTAL
145,000.00
155,800.00
1,303,266.67
7,395,000.00
7,427,400.00
62,837,800.00
377,145,000.00
377,242,200.00
3,193,841,400.00
19,234,395,000.00
19,234,686,600.00
162,853,252,200.00
980,954,145,000.00
980,955,019,800.00
8,305,417,884,600.00
20,000.00
BONO DE ALIM
EVOLUCION DE LA NO 8,000,000,000,000.00 7,000,000,000,000.00 6,000,000,000,000.00 5,000,000,000,000.00 4,000,000,000,000.00
8%
3,000,000,000,000.00
VENTAS 108,605.56
2,000,000,000,000.00
5,236,483.33 266,153,450.00 13,571,104,350.00 692,118,157,050.00
1,000,000,000,000.00 0.00
1
2
3
ISTRACION
PRODUCCIO
AD
4
5
STRIBUCION DE LA NOMINA
10,000.00
OTAL SUELDO
20,000.00
30,000.00
40,000.00
50,000.00
BONO DE ALIMENTACION
VOLUCION DE LA NOMINA
2
MINISTRACION
3 PRODUCCION
4 VENTAS
5
PRESUPUESTO DE MATERIA PRIMA DE ACUERDO A PRODUCTO AÑO 1
PRODUCTO
PROPORCION POR PORCION (KG)
1.00
CAÑA DE AZUCAR
KG/AÑO
Costo Unitario
500,000.00
60.00
Produccion Anual (PORCIONES)
500,000.00
PESO DE LA PORCION
1.00
totales anuales C.U. AÑO 1
500,000.00
60
Se asume que la produccion sera constante por los años en estudio, de manera que solo la inflacion sea la variable independiente
E 20,000,000,000,000.00 AÑO
Inflacion Anual
1
BOLIVARES 30,000,000.00
2
20000%
6,030,000,000.00
3
6000%
367,830,000,000.00
4
1500% 5,885,280,000,000.00
5
200% 17,655,840,000,000.00
18,000,000,000,000.00 16,000,000,000,000.00 14,000,000,000,000.00 12,000,000,000,000.00 10,000,000,000,000.00 8,000,000,000,000.00 6,000,000,000,000.00 4,000,000,000,000.00 2,000,000,000,000.00
0.00 30,00 1
AÑO 1
Costo Anual
30,000,000.00
30,000,000.00
60.00 independiente
EVOLUCION COSTO MATERIA PRIMA 20,000,000,000,000.00 18,000,000,000,000.00
17,655,840,000,000.00
16,000,000,000,000.00 14,000,000,000,000.00 12,000,000,000,000.00 10,000,000,000,000.00 8,000,000,000,000.00 6,000,000,000,000.00
5,885,280,000,000.00
4,000,000,000,000.00 2,000,000,000,000.00 0.00 30,000,000.00 1
2
6,030,000,000.00
BOLIVARES
367,830,000,000.00
3
4
5
PRESUPUESTO DE COSTOS INDIRECTOS VARIABLES:
EV
GASTO ANUAL AÑO 1 BASE PARA REPARACIONES
15,000.00
INSUMOS DE PRODUCCION
50,000.00
BASE PARA ALQUILERES:
45,000,000,000.00 40,000,000,000.00
-
BASE PARA SERVICIOS PUBLICOS
480.00
aumento 20% interanual
35,000,000,000.00 30,000,000,000.00
AÑO
INFLACION 1
REPARACIONES
INSUMOS
SERVICIOS PUBLICOS
TOTAL COSTOS INDIRECTOS
15,000.00
50,000.00
480.00
65,480.00
2
20000%
3,015,000.00
10,050,000.00
576.00
13,065,576.00
3
6000%
183,915,000.00
613,050,000.00
691.20
796,965,691.20
4
1500%
2,942,640,000.00
9,808,800,000.00
829.44 12,751,440,829.44
5
200%
8,827,920,000.00 29,426,400,000.00
995.33 38,254,320,995.33
25,000,000,000.00 20,000,000,000.00 15,000,000,000.00 10,000,000,000.00 5,000,000,000.00 0.00
RE SE
EVOLUCION COSTOS INDIRECTOS 45,000,000,000.00 40,000,000,000.00
38,254,320,995.33
35,000,000,000.00 30,000,000,000.00 25,000,000,000.00 20,000,000,000.00 15,000,000,000.00 12,751,440,829.44
10,000,000,000.00 5,000,000,000.00 0.00
1
65,480.00
2
13,065,576.00
REPARACIONES SERVICIOS PUBLICOS
796,965,691.20
3
4
INSUMOS TOTAL COSTOS INDIRECTOS
5
PRESUPUESTO GASTOS ISTRATIVOS Y VENTAS VARIABLES: PAPELERIA Y ART OFICINA:
0.01% DE LAS VENTAS
IMPUESTOS MUNICIPALES
0.10% DE LAS VENTAS
AGUA POTABLE
16,200.00 ANUAL BASE AÑO 1
MANTENIMIENTO OFICINAS
10,000.00 ANUAL BASE AÑO 1
HONORARIOS CONTADOR
25,000.00 ANUAL BASE AÑO 1
INSUMOS DE ASEO
12,000.00 ANUAL BASE AÑO 1
PUBLICIDAD
0.05% DE LAS VENTAS
AÑO
INFLACION 1
GASTOS ISTRATIVOS DEPENDIENTE DE VENTAS
GASTOS ISTRATIVOS GASTOS DE VENTAS DEPENDIENTES INFLACION
TOTAL
198,000.00
63,200.00
90,000.00
351,200.00
2
20000%
39,798,000.00
12,703,200.00
18,090,000.00
70,591,200.00
3
6000%
2,427,678,000.00
774,895,200.00
1,103,490,000.00
4,306,063,200.00
4
1500%
38,842,848,000.00
12,398,323,200.00
17,655,840,000.00
68,897,011,200.00
5
200%
116,528,544,000.00
37,194,969,600.00
52,967,520,000.00 206,691,033,600.00
EVOLUCION DE LOS GASTOS 140,000,000,000.00 120,000,000,000.00 100,000,000,000.00 80,000,000,000.00 60,000,000,000.00 40,000,000,000.00 20,000,000,000.00 0.00
1
2
3
4
GASTOS ISTRATIVOS DEPENDIENTE DE VENTAS GASTOS ISTRATIVOS DEPENDIENTES INFLACION GASTOS DE VENTAS
5
DEPRECIACION DE ACTIVO FIJO PRODUCCION
MOBILIARIO Y EQUIPOS NOMBRE
C.U.
CANTIDAD
COSTO
HORNO INDUSTRIAL
600,000.00
2
1,200,000.00
COCINA BALANZA
72,000.00 230,000.00 10,000.00
1 1 1
72,000.00 230,000.00 10,000.00
UTENCILIOS COCINA
6,000.00
3
18,000.00
CONGELADOR REFRIGERADOR
200,000.00 200,000.00
1 1
200,000.00 200,000.00
MOSTRADOR FRIO
480,000.00
1
480,000.00
BATIDORA
DEPRECIACION ACTIVO F
METODO DE LA LINEA RECTA
10 9 8 7 6 5
VALOR DE ADQUISICION
2,410,000.00
FECHA ADQUISICION: Año
1
VIDA UTIL:
4
10 AÑOS
VALOR DE RESCATE:
0.00
AÑO
DEPRECIACION
VALOR NETO
3 DEPRECIACION ACUMULADA
0
0
2,410,000.00
0
1
241,000.00
2,169,000.00
241,000.00
2
241,000.00
1,928,000.00
482,000.00
3
241,000.00
1,687,000.00
723,000.00
4
241,000.00
1,446,000.00
964,000.00
5
241,000.00
1,205,000.00
1,205,000.00
6
241,000.00
964,000.00
1,446,000.00
7
241,000.00
723,000.00
1,687,000.00
8
241,000.00
482,000.00
1,928,000.00
9
241,000.00
241,000.00
2,169,000.00
10
241,000.00
0.00
2,410,000.00
2 1 0 0
500000
1000000
DEPRECIACION
1500000 VALOR NETO
DEPRECIACION ACTIVO FIJO PRODUCCION
500000
1000000
DEPRECIACION
1500000 VALOR NETO
2000000
2500000
DEPRECIACION ACUMULADA
3000000
DEPRECIACION DE ACTIVO FIJO ISTRACION
DEPRECIACION ACTIVO FIJO AD MOBILIARIO Y EQUIPOS
METODO DE LA LINEA RECTA
NOMBRE
C.U.
CANTIDAD
COSTO
Computador
156,000.00
3
468,000.00
Estanteria
32,000.00
4
128,000.00
Mesas y Sillas
8,000.00
21
168,000.00
Aire Acondicionado
130,000.00
2
260,000.00
Escritorios
30,000.00
1
30,000.00
5
4
3 VALOR DE ADQUISICION
1,054,000.00
FECHA ADQUISICION: Año
1
VIDA UTIL:
5 AÑOS
VALOR DE RESCATE: AÑO
2
0.00 DEPRECIACION
VALOR NETO
DEPRECIACION ACUMULADA
0
0
1,054,000.00
0
1
210,800.00
843,200.00
210,800.00
2
210,800.00
632,400.00
421,600.00
3
210,800.00
421,600.00
632,400.00
4
210,800.00
210,800.00
843,200.00
5
210,800.00
0.00
1,054,000.00
1
0 0
200000
400000
DEPRECIACION
600000 VALOR NETO
8
DEPREC
ON ACTIVO FIJO ISTRACION
0000
N
600000 VALOR NETO
800000
1000000
DEPRECIACION ACUMULADA
1200000
PRESUPUESTO DE VENTAS BERENJENAS ACHOCOLATADAS UTILIDAD BRUTA ESPERADA POSTRE
500%
PRODUCTO
NATURALEZA
PORCION BERENJENA ACHOCOLATADA
Produccion
cantidad/año
PRECIO VENTA
500000
360.00
TOTAL INGRESOS VENTAS
AÑO
INFLACION
INGRESO ANUALES
1
Bs VENTAS
180,000,000.00
180,000,000.00
2
20000%
36,180,000,000.00
36,180,000,000.00
3
6000%
2,206,980,000,000.00
2,206,980,000,000.00
4
1500%
35,311,680,000,000.00
35,311,680,000,000.00
200% 105,935,040,000,000.00
105,935,040,000,000.00
5
AS
Bs/Año
EVOLUCION DE LAS VENTAS
180,000,000.00
180,000,000.00
120,000,000,000,000.00 105,935,040,000,000.00 100,000,000,000,000.00
80,000,000,000,000.00
60,000,000,000,000.00
40,000,000,000,000.00
35,311,680,000,000.00
20,000,000,000,000.00
0.00
2,206,980,000,000.00 180,000,000.0036,180,000,000.00 1
2 INGRESO ANUALES
3
4
5
TAS 105,935,040,000,000.00
35,311,680,000,000.00
000.00 4
5
FLUJO DE CAJA PROYECTADO 1 SALDO INICIAL INGRESOS CAPITAL PRESTAMO BANCARIO VENTAS TOTAL INGRESOS
2 -
2,000,000.00 80,000,000.00 180,000,000.00 262,000,000.00
EGRESOS PRODUCCION EQUIPOS PARA PRODUCCION MATERIA PRIMA MANO DE OBRA COSTOS INDIRECTOS EGRESOS PRODUCCION
2,410,000.00 30,000,000.00 1,086,055.56 65,480.00 33,561,535.56
ISTRACION MOBILIARIO SUELDOS ISTRACION GASTOS ISTRATIVOS EGRESOS ISTRACION
1,054,000.00 108,605.56 261,200.00 1,423,805.56
VENTAS NOMINA DE VENTAS PUBLICIDAD EGRESOS VENTAS FINANCIEROS E IMPUESTOS I.S.L.R PRESTAMO BANCARIO EGRESOS FINANCIEROS TOTAL EGRESOS
AÑOS 3
108,605.56 90,000.00 198,605.56
32,147,696.27 53,384,811.04 85,532,507.31 120,716,453.97
141,283,546.03
-
19,877,815,712.38
-
36,180,000,000.00
2,206,980,000,000.00
36,180,000,000.00
2,206,980,000,000.00
6,030,000,000.00 52,364,833.33 13,065,576.00 6,095,430,409.33
5,236,483.33 52,501,200.00 57,737,683.33
5,236,483.33 70,591,200.00 75,827,683.33
10,169,769,286.20 44,702,771.45 10,214,472,057.65 16,443,467,833.65
367,830,000,000.00 2,661,534,500.00 796,965,691.20 371,288,500,191.20
266,153,450.00 3,202,573,200.00 3,468,726,650.00
266,153,450.00 4,306,063,200.00 4,572,216,650.00
621,491,527,773.99 621,491,527,773.99 1,000,820,971,265.19
INGRESOS - EGRESOS
141,283,546.03
19,736,532,166.35
1,206,159,028,734.81
SALDO DE CAJA PROYECTADO
141,283,546.03
19,877,815,712.38
1,226,036,844,447.19
TADO
AÑOS 4
5
1,226,036,844,447.19
20,447,656,524,796.80
-
-
35,311,680,000,000.00
105,935,040,000,000.00
35,311,680,000,000.00
105,935,040,000,000.00
5,885,280,000,000.00 135,711,043,500.00 12,751,440,829.44 6,033,742,484,329.44
13,571,104,350.00 51,241,171,200.00 64,812,275,550.00
13,571,104,350.00 68,897,011,200.00 82,468,115,550.00
9,909,037,444,220.99 9,909,037,444,220.99 16,090,060,319,650.40
17,655,840,000,000.00 6,921,181,570,500.00 38,254,320,995.33 24,615,275,891,495.30
6,921,181,570,500.00 153,723,513,600.00 7,074,905,084,100.00
692,118,157,050.00 206,691,033,600.00 898,809,190,650.00
25,172,976,963,261.60 25,172,976,963,261.60 57,761,967,129,506.90
19,221,619,680,349.60
48,173,072,870,493.10
20,447,656,524,796.80
68,620,729,395,289.80
ESTADO DE COSTOS DE PRODUCCION PROYECTADO AÑOS 1
2
INVENTARIO INICIAL MATERIA PRIMA COMPRAS MATERIA PRIMA INVENTARIO FINAL MATERIA PRIMA
0.00 30,000,000.00 0.00
0.00 6,030,000,000.00 0.00
CONSUMO
30,000,000.00
6,030,000,000.00
1,086,055.56 65,480.00 241,000.00
52,364,833.33 13,065,576.00 241,000.00
31,392,535.56
6,095,671,409.33
MANO DE OBRA COSTOS INDIRECTOS DEPRECIACION ACTIVOS PRODUCCION COSTO DE PRODUCCION
ODUCCION PROYECTADO AÑOS 3
4
5
0.00 0.00 367,830,000,000.00 5,885,280,000,000.00 0.00 0.00
0.00 17,655,840,000,000.00 0.00
367,830,000,000.00 5,885,280,000,000.00
17,655,840,000,000.00
2,661,534,500.00 796,965,691.20 241,000.00
135,711,043,500.00 12,751,440,829.44 241,000.00
6,921,181,570,500.00 38,254,320,995.33 241,000.00
371,288,741,191.20 6,033,742,725,329.44
24,615,276,132,495.30
ESTADO DE GANANCIAS Y PERDIDAS PROYECTADO 1 INGRESOS VENTAS TOTAL INGRESOS
2
AÑOS 3
180,000,000.00 180,000,000.00
36,180,000,000.00 36,180,000,000.00
2,206,980,000,000.00 2,206,980,000,000.00
31,392,535.56
6,095,671,409.33
371,288,741,191.20
UTILIDAD BRUTA EN VENTAS
148,607,464.44
30,084,328,590.67
1,835,691,258,808.80
NOMINA ISTRACION GASTOS ISTRATIVOS DEPRECIACION MOBILIARIO GASTOS DE VENTAS GASTOS FINANCIEROS
108,605.56 261,200.00 210,800.00 90,000.00 53,384,811.04
5,236,483.33 52,501,200.00 210,800.00 70,591,200.00 44,702,771.45
266,153,450.00 3,202,573,200.00 210,800.00 4,306,063,200.00 -
TOTAL GASTOS
54,055,416.59
173,242,454.78
7,775,000,650.00
UTILIDAD NETA
94,552,047.85
29,911,086,135.89
1,827,916,258,158.80
I.S.L.R.
32,147,696.27
10,169,769,286.20
621,491,527,773.99
UTILIDAD DESPUES DE I.S.L.R.
62,404,351.58
19,741,316,849.69
1,206,424,730,384.81
COSTO DE PRODUCCION
AS PROYECTADO
AÑOS 4
5
35,311,680,000,000.00 35,311,680,000,000.00
105,935,040,000,000.00 105,935,040,000,000.00
6,033,742,725,329.44
24,615,276,132,495.30
29,277,937,274,670.60
81,319,763,867,504.70
13,571,104,350.00 51,241,171,200.00 210,800.00 68,897,011,200.00 -
6,921,181,570,500.00 153,723,513,600.00 210,800.00 206,691,033,600.00 -
133,709,497,550.00
7,281,596,328,500.00
29,144,227,777,120.60
74,038,167,539,004.70
9,909,037,444,220.99
25,172,976,963,261.60
19,235,190,332,899.60
48,865,190,575,743.10
TASA INTERNA DE RETORNO
19,235,190,332,899.60 1,206,424,730,384.81 19,741,316,849.69 62,404,351.58 0
1
2
3
82,000,000.00
=−50.073.510,00+ (−12.087.272,45)/((1+𝑇𝐼𝑅) )+1.108.347.188,15/(1+𝑇𝐼𝑅)^2 +68.466.614.697,45/(1+𝑇𝐼𝑅)^3 +1.071.361.369.523,15/(1+𝑇𝐼𝑅)^4 +915.
Haciendo (1+TIR)= t
la ecuacion queda:
0=−50.073.510,00∗𝑡^5−12.087.272,45∗𝑡^4+1.108.347.188,15∗𝑡^3+68,.466.6914.697,45∗𝑡^2+1.071.361.369.523,15∗𝑡+915
Calculando valor de t por aproximacion t
valor de la ecuacion 31
102685174241522
32
-139374042962768
31.4
11168139237301.3
31.5
-12797052568350.2
31.45
-759285083833.422
31.44
1635008433204.58
31.446
198961706197.203
31.447
-40533801959.6719
31.4468 31.4469
puntos extremos
aproximaciones 7368829369.32813 buscando valor cero de la ecuacion -16582265681.9219
31.44684
-2211555704.42188
31.44683
183547182.703125
31.446831
-55962907.921875
31.4468307
15890124.203125
31.4468308
-8060886.671875
31.4468307663
t= (1+ TIR) TIR= t-1 TIR:
18.078125 VALOR APROXIMADO
3044.68%
48,865,190,575,743.10
4
5
𝑅)^3 +1.071.361.369.523,15/(1+𝑇𝐼𝑅)^4 +915.846.116.322,60/(1+𝑇𝐼𝑅)^5
914.697,45∗𝑡^2+1.071.361.369.523,15∗𝑡+915.846.116.322,60
^
PRESTAMO BANCARIO Monto del Préstamo 80,000,000.00 Tipo de interés 24.00% Tipo de interés efectivo 1.809% Duración (en años) 2.00 Frecuencia de pago Mensual Sistema de pago elegido Cuotas constantes Número de pagos 24 Totales Suma de las cuotas Suma de los intereses
98,087,582.48 18,087,582.48
Período
Cuota Mensual
Intereses
0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
4,780,339.93 4,720,047.99 4,659,756.05 4,599,464.11 4,539,172.17 4,478,880.22 4,418,588.28 4,358,296.34 4,298,004.40 4,237,712.46 4,177,420.52 4,117,128.57 4,056,836.63 3,996,544.69 3,936,252.75 3,875,960.81 3,815,668.87 3,755,376.92 3,695,084.98 3,634,793.04 3,574,501.10 3,514,209.16 3,453,917.22 3,393,625.27
1,447,006.60 1,386,714.66 1,326,422.72 1,266,130.77 1,205,838.83 1,145,546.89 1,085,254.95 1,024,963.01 964,671.07 904,379.12 844,087.18 783,795.24 723,503.30 663,211.36 602,919.42 542,627.47 482,335.53 422,043.59 361,751.65 301,459.71 241,167.77 180,875.82 120,583.88 60,291.94
MORTIZACION MENSUAL DEL PRESTAMO Cuota Amortización 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33 3,333,333.33
Capital por Amortizar
Capital Amortizado
80,000,000.00 76,666,666.67 73,333,333.33 70,000,000.00 66,666,666.67 63,333,333.33 60,000,000.00 56,666,666.67 53,333,333.33 50,000,000.00 46,666,666.67 43,333,333.33 40,000,000.00 36,666,666.67 33,333,333.33 30,000,000.00 26,666,666.67 23,333,333.33 20,000,000.00 16,666,666.67 13,333,333.33 10,000,000.00 6,666,666.67 3,333,333.33 0.00
3,333,333.33 6,666,666.67 10,000,000.00 13,333,333.33 16,666,666.67 20,000,000.00 23,333,333.33 26,666,666.67 30,000,000.00 33,333,333.33 36,666,666.67 40,000,000.00 43,333,333.33 46,666,666.67 50,000,000.00 53,333,333.33 56,666,666.67 60,000,000.00 63,333,333.33 66,666,666.67 70,000,000.00 73,333,333.33 76,666,666.67 80,000,000.00
TABLA DE AMORTIZACION DE CREDITO ANUALIZADA MONTO DEL CREDITO TASA ANUALIZADA CUOTAS
80,000,000.00 24% 24
TABLA DE AMORTIZACION ANUAL DEL PRESTAMO Período 0 1 2 3 4 5
Cuota ANUAL
Intereses
Cuota Amortización
Capital por Amortizar
0.00 0.00 0.00 80,000,000.00 0.00 53,384,811.04 13,384,811.04 40,000,000.00 40,000,000.00 40,000,000.00 44,702,771.45 4,702,771.45 40,000,000.00 0.00 80,000,000.00 0.00 0.00 0.00 0.00 80,000,000.00 0.00 0.00 0.00 0.00 80,000,000.00 0.00 0.00 0.00 0.00 80,000,000.00 98,087,582.48 18,087,582.48
PRESTAMOS ANUALIZADO amortizacion vs. intereses
44,702,771.45
53,384,811.04
60,000,000.00
50,000,000.00
40,000,000.00
13,384,811.04 10,000,000.00
40,000,000.00
40,000,000.00
30,000,000.00
20,000,000.00
Capital Amortizado
40,000,000.
40,000,000.
20,000,000.00
13,384,811.04 10,000,000.00
2 Interes es
0.003
Cuota Amortiza ci ón
0.004
Cuota ANUAL
0.00 0.00
1
0.00 0.00
0.00
0.00 0.00
4,702,771.45
0.005
PERSONAL
cantidad
SUELDO
TOTAL SUELDO
Gerente General
1
12,000.00
12,000.00
Encargado de Produccion
1
10,000.00
10,000.00
Engargado de Ventas
1
10,000.00
10,000.00
Operarios
9
4,500.00
40,500.00 0.00 0.00 0.00 0.00
12 BONO DE ALIMENTACION MENSUAL:
72,500.00 450.00
VARIABLES DE LA NOMINA VALOR NOMINA AÑO 1 VAR. INTER ANUAL SUELDO
870,000.00 5000%
VALOR CESTATICKETS AÑO 1
64,800.00
VALOR UNIDAD TRIBUTARIA (U.T.)
0.0012
DIAS VAC.+BONO VAC.
28
VARIACION U.T. INTERANUAL
200%
DIAS UTILIDADES
60
VALOR CESTATICKETS
450.00
NUMERO DE EMPLEADOS
2
SUELDO MENSUAL PROM. AÑO 1
11,000.00
NUMERO DE OBREROS
10
SALARIO MENSUAL PROM. AÑO 1
1,450.00
PRESUPUESTO DE NOMINA
AÑO
NOMINA
CESTATICKETS
VACACIONES
1
870,000.00
64,800.00
67,666.67
2
44,370,000.00
194,400.00
3,451,000.00
3
2,262,870,000.00
583,200.00
176,001,000.00
4
115,406,370,000.00
1,749,600.00
8,976,051,000.00
5
5,885,724,870,000.00
5,248,800.00
457,778,601,000.00
PORCENTAJE AÑO
TOTAL NOMINA
8%
83%
ISTRACION
PRODUCCION
1
1,303,266.67
108,605.56
1,086,055.56
2
62,837,800.00
5,236,483.33
52,364,833.33
3
3,193,841,400.00
266,153,450.00
2,661,534,500.00
4
162,853,252,200.00
13,571,104,350.00
135,711,043,500.00
5
8,305,417,884,600.00
692,118,157,050.00
6,921,181,570,500.00
PRESUPUESTO DE NOMINA 1,200,000,000,000.00 1,000,000,000,000.00 800,000,000,000.00 600,000,000,000.00 400,000,000,000.00
1,000,000,000,000.00 800,000,000,000.00 600,000,000,000.00 400,000,000,000.00 200,000,000,000.00 0.00
1
2 CESTATICKETS
VACACIONES
3 UTILIDADES
4 ANTIGÜEDAD
5
BONO DE ALIMENTACION
TOTAL MENSUAL
AREA
450.00
12,450.00
ISTRACION
450.00
10,450.00
PRODUCCION
450.00
10,450.00
VENTAS
4,050.00
44,550.00
PRODUCCION
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
5,400.00
DISTRIBUCION DE LA N
Opera ri os
Engargado de Ventas
77,900.00
Encargado de Producci on
Gerente Genera l
0.00
OMINA
10,000.00
TOTAL SUELDO
UTILIDADES
ANTIGÜEDAD
TOTAL
145,000.00
155,800.00
1,303,266.67
7,395,000.00
7,427,400.00
62,837,800.00
377,145,000.00
377,242,200.00
3,193,841,400.00
19,234,395,000.00
19,234,686,600.00
162,853,252,200.00
980,954,145,000.00
980,955,019,800.00
8,305,417,884,600.00
20,000.00
BONO DE ALIM
EVOLUCION DE LA NO 8,000,000,000,000.00 7,000,000,000,000.00 6,000,000,000,000.00 5,000,000,000,000.00 4,000,000,000,000.00
8%
3,000,000,000,000.00
VENTAS 108,605.56
2,000,000,000,000.00
5,236,483.33 266,153,450.00 13,571,104,350.00 692,118,157,050.00
1,000,000,000,000.00 0.00
1
2
3
ISTRACION
PRODUCCIO
AD
4
5
STRIBUCION DE LA NOMINA
10,000.00
OTAL SUELDO
20,000.00
30,000.00
40,000.00
50,000.00
BONO DE ALIMENTACION
VOLUCION DE LA NOMINA
2
MINISTRACION
3 PRODUCCION
4 VENTAS
5
PRESUPUESTO DE MATERIA PRIMA DE ACUERDO A PRODUCTO AÑO 1
PRODUCTO
PROPORCION POR PORCION (KG)
1.00
CAÑA DE AZUCAR
KG/AÑO
Costo Unitario
500,000.00
60.00
Produccion Anual (PORCIONES)
500,000.00
PESO DE LA PORCION
1.00
totales anuales C.U. AÑO 1
500,000.00
60
Se asume que la produccion sera constante por los años en estudio, de manera que solo la inflacion sea la variable independiente
E 20,000,000,000,000.00 AÑO
Inflacion Anual
1
BOLIVARES 30,000,000.00
2
20000%
6,030,000,000.00
3
6000%
367,830,000,000.00
4
1500% 5,885,280,000,000.00
5
200% 17,655,840,000,000.00
18,000,000,000,000.00 16,000,000,000,000.00 14,000,000,000,000.00 12,000,000,000,000.00 10,000,000,000,000.00 8,000,000,000,000.00 6,000,000,000,000.00 4,000,000,000,000.00 2,000,000,000,000.00
0.00 30,00 1
AÑO 1
Costo Anual
30,000,000.00
30,000,000.00
60.00 independiente
EVOLUCION COSTO MATERIA PRIMA 20,000,000,000,000.00 18,000,000,000,000.00
17,655,840,000,000.00
16,000,000,000,000.00 14,000,000,000,000.00 12,000,000,000,000.00 10,000,000,000,000.00 8,000,000,000,000.00 6,000,000,000,000.00
5,885,280,000,000.00
4,000,000,000,000.00 2,000,000,000,000.00 0.00 30,000,000.00 1
2
6,030,000,000.00
BOLIVARES
367,830,000,000.00
3
4
5
PRESUPUESTO DE COSTOS INDIRECTOS VARIABLES:
EV
GASTO ANUAL AÑO 1 BASE PARA REPARACIONES
15,000.00
INSUMOS DE PRODUCCION
50,000.00
BASE PARA ALQUILERES:
45,000,000,000.00 40,000,000,000.00
-
BASE PARA SERVICIOS PUBLICOS
480.00
aumento 20% interanual
35,000,000,000.00 30,000,000,000.00
AÑO
INFLACION 1
REPARACIONES
INSUMOS
SERVICIOS PUBLICOS
TOTAL COSTOS INDIRECTOS
15,000.00
50,000.00
480.00
65,480.00
2
20000%
3,015,000.00
10,050,000.00
576.00
13,065,576.00
3
6000%
183,915,000.00
613,050,000.00
691.20
796,965,691.20
4
1500%
2,942,640,000.00
9,808,800,000.00
829.44 12,751,440,829.44
5
200%
8,827,920,000.00 29,426,400,000.00
995.33 38,254,320,995.33
25,000,000,000.00 20,000,000,000.00 15,000,000,000.00 10,000,000,000.00 5,000,000,000.00 0.00
RE SE
EVOLUCION COSTOS INDIRECTOS 45,000,000,000.00 40,000,000,000.00
38,254,320,995.33
35,000,000,000.00 30,000,000,000.00 25,000,000,000.00 20,000,000,000.00 15,000,000,000.00 12,751,440,829.44
10,000,000,000.00 5,000,000,000.00 0.00
1
65,480.00
2
13,065,576.00
REPARACIONES SERVICIOS PUBLICOS
796,965,691.20
3
4
INSUMOS TOTAL COSTOS INDIRECTOS
5
PRESUPUESTO GASTOS ISTRATIVOS Y VENTAS VARIABLES: PAPELERIA Y ART OFICINA:
0.01% DE LAS VENTAS
IMPUESTOS MUNICIPALES
0.10% DE LAS VENTAS
AGUA POTABLE
16,200.00 ANUAL BASE AÑO 1
MANTENIMIENTO OFICINAS
10,000.00 ANUAL BASE AÑO 1
HONORARIOS CONTADOR
25,000.00 ANUAL BASE AÑO 1
INSUMOS DE ASEO
12,000.00 ANUAL BASE AÑO 1
PUBLICIDAD
0.05% DE LAS VENTAS
AÑO
INFLACION 1
GASTOS ISTRATIVOS DEPENDIENTE DE VENTAS
GASTOS ISTRATIVOS GASTOS DE VENTAS DEPENDIENTES INFLACION
TOTAL
198,000.00
63,200.00
90,000.00
351,200.00
2
20000%
39,798,000.00
12,703,200.00
18,090,000.00
70,591,200.00
3
6000%
2,427,678,000.00
774,895,200.00
1,103,490,000.00
4,306,063,200.00
4
1500%
38,842,848,000.00
12,398,323,200.00
17,655,840,000.00
68,897,011,200.00
5
200%
116,528,544,000.00
37,194,969,600.00
52,967,520,000.00 206,691,033,600.00
EVOLUCION DE LOS GASTOS 140,000,000,000.00 120,000,000,000.00 100,000,000,000.00 80,000,000,000.00 60,000,000,000.00 40,000,000,000.00 20,000,000,000.00 0.00
1
2
3
4
GASTOS ISTRATIVOS DEPENDIENTE DE VENTAS GASTOS ISTRATIVOS DEPENDIENTES INFLACION GASTOS DE VENTAS
5
DEPRECIACION DE ACTIVO FIJO PRODUCCION
MOBILIARIO Y EQUIPOS NOMBRE
C.U.
CANTIDAD
COSTO
HORNO INDUSTRIAL
600,000.00
2
1,200,000.00
COCINA BALANZA
72,000.00 230,000.00 10,000.00
1 1 1
72,000.00 230,000.00 10,000.00
UTENCILIOS COCINA
6,000.00
3
18,000.00
CONGELADOR REFRIGERADOR
200,000.00 200,000.00
1 1
200,000.00 200,000.00
MOSTRADOR FRIO
480,000.00
1
480,000.00
BATIDORA
DEPRECIACION ACTIVO F
METODO DE LA LINEA RECTA
10 9 8 7 6 5
VALOR DE ADQUISICION
2,410,000.00
FECHA ADQUISICION: Año
1
VIDA UTIL:
4
10 AÑOS
VALOR DE RESCATE:
0.00
AÑO
DEPRECIACION
VALOR NETO
3 DEPRECIACION ACUMULADA
0
0
2,410,000.00
0
1
241,000.00
2,169,000.00
241,000.00
2
241,000.00
1,928,000.00
482,000.00
3
241,000.00
1,687,000.00
723,000.00
4
241,000.00
1,446,000.00
964,000.00
5
241,000.00
1,205,000.00
1,205,000.00
6
241,000.00
964,000.00
1,446,000.00
7
241,000.00
723,000.00
1,687,000.00
8
241,000.00
482,000.00
1,928,000.00
9
241,000.00
241,000.00
2,169,000.00
10
241,000.00
0.00
2,410,000.00
2 1 0 0
500000
1000000
DEPRECIACION
1500000 VALOR NETO
DEPRECIACION ACTIVO FIJO PRODUCCION
500000
1000000
DEPRECIACION
1500000 VALOR NETO
2000000
2500000
DEPRECIACION ACUMULADA
3000000
DEPRECIACION DE ACTIVO FIJO ISTRACION
DEPRECIACION ACTIVO FIJO AD MOBILIARIO Y EQUIPOS
METODO DE LA LINEA RECTA
NOMBRE
C.U.
CANTIDAD
COSTO
Computador
156,000.00
3
468,000.00
Estanteria
32,000.00
4
128,000.00
Mesas y Sillas
8,000.00
21
168,000.00
Aire Acondicionado
130,000.00
2
260,000.00
Escritorios
30,000.00
1
30,000.00
5
4
3 VALOR DE ADQUISICION
1,054,000.00
FECHA ADQUISICION: Año
1
VIDA UTIL:
5 AÑOS
VALOR DE RESCATE: AÑO
2
0.00 DEPRECIACION
VALOR NETO
DEPRECIACION ACUMULADA
0
0
1,054,000.00
0
1
210,800.00
843,200.00
210,800.00
2
210,800.00
632,400.00
421,600.00
3
210,800.00
421,600.00
632,400.00
4
210,800.00
210,800.00
843,200.00
5
210,800.00
0.00
1,054,000.00
1
0 0
200000
400000
DEPRECIACION
600000 VALOR NETO
8
DEPREC
ON ACTIVO FIJO ISTRACION
0000
N
600000 VALOR NETO
800000
1000000
DEPRECIACION ACUMULADA
1200000
PRESUPUESTO DE VENTAS BERENJENAS ACHOCOLATADAS UTILIDAD BRUTA ESPERADA POSTRE
500%
PRODUCTO
NATURALEZA
PORCION BERENJENA ACHOCOLATADA
Produccion
cantidad/año
PRECIO VENTA
500000
360.00
TOTAL INGRESOS VENTAS
AÑO
INFLACION
INGRESO ANUALES
1
Bs VENTAS
180,000,000.00
180,000,000.00
2
20000%
36,180,000,000.00
36,180,000,000.00
3
6000%
2,206,980,000,000.00
2,206,980,000,000.00
4
1500%
35,311,680,000,000.00
35,311,680,000,000.00
200% 105,935,040,000,000.00
105,935,040,000,000.00
5
AS
Bs/Año
EVOLUCION DE LAS VENTAS
180,000,000.00
180,000,000.00
120,000,000,000,000.00 105,935,040,000,000.00 100,000,000,000,000.00
80,000,000,000,000.00
60,000,000,000,000.00
40,000,000,000,000.00
35,311,680,000,000.00
20,000,000,000,000.00
0.00
2,206,980,000,000.00 180,000,000.0036,180,000,000.00 1
2 INGRESO ANUALES
3
4
5
TAS 105,935,040,000,000.00
35,311,680,000,000.00
000.00 4
5
FLUJO DE CAJA PROYECTADO 1 SALDO INICIAL INGRESOS CAPITAL PRESTAMO BANCARIO VENTAS TOTAL INGRESOS
2 -
2,000,000.00 80,000,000.00 180,000,000.00 262,000,000.00
EGRESOS PRODUCCION EQUIPOS PARA PRODUCCION MATERIA PRIMA MANO DE OBRA COSTOS INDIRECTOS EGRESOS PRODUCCION
2,410,000.00 30,000,000.00 1,086,055.56 65,480.00 33,561,535.56
ISTRACION MOBILIARIO SUELDOS ISTRACION GASTOS ISTRATIVOS EGRESOS ISTRACION
1,054,000.00 108,605.56 261,200.00 1,423,805.56
VENTAS NOMINA DE VENTAS PUBLICIDAD EGRESOS VENTAS FINANCIEROS E IMPUESTOS I.S.L.R PRESTAMO BANCARIO EGRESOS FINANCIEROS TOTAL EGRESOS
AÑOS 3
108,605.56 90,000.00 198,605.56
32,147,696.27 53,384,811.04 85,532,507.31 120,716,453.97
141,283,546.03
-
19,877,815,712.38
-
36,180,000,000.00
2,206,980,000,000.00
36,180,000,000.00
2,206,980,000,000.00
6,030,000,000.00 52,364,833.33 13,065,576.00 6,095,430,409.33
5,236,483.33 52,501,200.00 57,737,683.33
5,236,483.33 70,591,200.00 75,827,683.33
10,169,769,286.20 44,702,771.45 10,214,472,057.65 16,443,467,833.65
367,830,000,000.00 2,661,534,500.00 796,965,691.20 371,288,500,191.20
266,153,450.00 3,202,573,200.00 3,468,726,650.00
266,153,450.00 4,306,063,200.00 4,572,216,650.00
621,491,527,773.99 621,491,527,773.99 1,000,820,971,265.19
INGRESOS - EGRESOS
141,283,546.03
19,736,532,166.35
1,206,159,028,734.81
SALDO DE CAJA PROYECTADO
141,283,546.03
19,877,815,712.38
1,226,036,844,447.19
TADO
AÑOS 4
5
1,226,036,844,447.19
20,447,656,524,796.80
-
-
35,311,680,000,000.00
105,935,040,000,000.00
35,311,680,000,000.00
105,935,040,000,000.00
5,885,280,000,000.00 135,711,043,500.00 12,751,440,829.44 6,033,742,484,329.44
13,571,104,350.00 51,241,171,200.00 64,812,275,550.00
13,571,104,350.00 68,897,011,200.00 82,468,115,550.00
9,909,037,444,220.99 9,909,037,444,220.99 16,090,060,319,650.40
17,655,840,000,000.00 6,921,181,570,500.00 38,254,320,995.33 24,615,275,891,495.30
6,921,181,570,500.00 153,723,513,600.00 7,074,905,084,100.00
692,118,157,050.00 206,691,033,600.00 898,809,190,650.00
25,172,976,963,261.60 25,172,976,963,261.60 57,761,967,129,506.90
19,221,619,680,349.60
48,173,072,870,493.10
20,447,656,524,796.80
68,620,729,395,289.80
ESTADO DE COSTOS DE PRODUCCION PROYECTADO AÑOS 1
2
INVENTARIO INICIAL MATERIA PRIMA COMPRAS MATERIA PRIMA INVENTARIO FINAL MATERIA PRIMA
0.00 30,000,000.00 0.00
0.00 6,030,000,000.00 0.00
CONSUMO
30,000,000.00
6,030,000,000.00
1,086,055.56 65,480.00 241,000.00
52,364,833.33 13,065,576.00 241,000.00
31,392,535.56
6,095,671,409.33
MANO DE OBRA COSTOS INDIRECTOS DEPRECIACION ACTIVOS PRODUCCION COSTO DE PRODUCCION
ODUCCION PROYECTADO AÑOS 3
4
5
0.00 0.00 367,830,000,000.00 5,885,280,000,000.00 0.00 0.00
0.00 17,655,840,000,000.00 0.00
367,830,000,000.00 5,885,280,000,000.00
17,655,840,000,000.00
2,661,534,500.00 796,965,691.20 241,000.00
135,711,043,500.00 12,751,440,829.44 241,000.00
6,921,181,570,500.00 38,254,320,995.33 241,000.00
371,288,741,191.20 6,033,742,725,329.44
24,615,276,132,495.30
ESTADO DE GANANCIAS Y PERDIDAS PROYECTADO 1 INGRESOS VENTAS TOTAL INGRESOS
2
AÑOS 3
180,000,000.00 180,000,000.00
36,180,000,000.00 36,180,000,000.00
2,206,980,000,000.00 2,206,980,000,000.00
31,392,535.56
6,095,671,409.33
371,288,741,191.20
UTILIDAD BRUTA EN VENTAS
148,607,464.44
30,084,328,590.67
1,835,691,258,808.80
NOMINA ISTRACION GASTOS ISTRATIVOS DEPRECIACION MOBILIARIO GASTOS DE VENTAS GASTOS FINANCIEROS
108,605.56 261,200.00 210,800.00 90,000.00 53,384,811.04
5,236,483.33 52,501,200.00 210,800.00 70,591,200.00 44,702,771.45
266,153,450.00 3,202,573,200.00 210,800.00 4,306,063,200.00 -
TOTAL GASTOS
54,055,416.59
173,242,454.78
7,775,000,650.00
UTILIDAD NETA
94,552,047.85
29,911,086,135.89
1,827,916,258,158.80
I.S.L.R.
32,147,696.27
10,169,769,286.20
621,491,527,773.99
UTILIDAD DESPUES DE I.S.L.R.
62,404,351.58
19,741,316,849.69
1,206,424,730,384.81
COSTO DE PRODUCCION
AS PROYECTADO
AÑOS 4
5
35,311,680,000,000.00 35,311,680,000,000.00
105,935,040,000,000.00 105,935,040,000,000.00
6,033,742,725,329.44
24,615,276,132,495.30
29,277,937,274,670.60
81,319,763,867,504.70
13,571,104,350.00 51,241,171,200.00 210,800.00 68,897,011,200.00 -
6,921,181,570,500.00 153,723,513,600.00 210,800.00 206,691,033,600.00 -
133,709,497,550.00
7,281,596,328,500.00
29,144,227,777,120.60
74,038,167,539,004.70
9,909,037,444,220.99
25,172,976,963,261.60
19,235,190,332,899.60
48,865,190,575,743.10
TASA INTERNA DE RETORNO
19,235,190,332,899.60 1,206,424,730,384.81 19,741,316,849.69 62,404,351.58 0
1
2
3
82,000,000.00
=−50.073.510,00+ (−12.087.272,45)/((1+𝑇𝐼𝑅) )+1.108.347.188,15/(1+𝑇𝐼𝑅)^2 +68.466.614.697,45/(1+𝑇𝐼𝑅)^3 +1.071.361.369.523,15/(1+𝑇𝐼𝑅)^4 +915.
Haciendo (1+TIR)= t
la ecuacion queda:
0=−50.073.510,00∗𝑡^5−12.087.272,45∗𝑡^4+1.108.347.188,15∗𝑡^3+68,.466.6914.697,45∗𝑡^2+1.071.361.369.523,15∗𝑡+915
Calculando valor de t por aproximacion t
valor de la ecuacion 31
102685174241522
32
-139374042962768
31.4
11168139237301.3
31.5
-12797052568350.2
31.45
-759285083833.422
31.44
1635008433204.58
31.446
198961706197.203
31.447
-40533801959.6719
31.4468 31.4469
puntos extremos
aproximaciones 7368829369.32813 buscando valor cero de la ecuacion -16582265681.9219
31.44684
-2211555704.42188
31.44683
183547182.703125
31.446831
-55962907.921875
31.4468307
15890124.203125
31.4468308
-8060886.671875
31.4468307663
t= (1+ TIR) TIR= t-1 TIR:
18.078125 VALOR APROXIMADO
3044.68%
48,865,190,575,743.10
4
5
𝑅)^3 +1.071.361.369.523,15/(1+𝑇𝐼𝑅)^4 +915.846.116.322,60/(1+𝑇𝐼𝑅)^5
914.697,45∗𝑡^2+1.071.361.369.523,15∗𝑡+915.846.116.322,60
^
Related Documents c2h70
Costos Tesis Trapiche 2p3i57
July 2021 0
Trapiche Electrico 1q5x4e
June 2021 0
Plan De Costos Tesis 2e1j5z
November 2020 0
Plano De Trapiche 4w5z6g
April 2021 0
Proyecto Trapiche ero 5u2m30
March 2023 0
Tesis De Costos De Produccion 2k2jh
June 2022 0More Documents from "Mime Hernandez" 605i8
Costos Tesis Trapiche 2p3i57
July 2021 0
Informe Leche Saborizada 5v25m
April 2020 21
Inventario Materia Prima Mastervzla 2015 (gen) Ultimos c49i
December 2022 0
Tejar Santa Teresa 1 2g4tf
February 2023 0
Folleto Estilo De Vida Saludable m6m6g
February 2021 0