Activo 0 1 2 3
Activo Circulante 62,500,000 86,692,000 121,272,292 153,582,251
Activo no circulante 187,500,000 168,750,000 150,000,000 131,250,000
PPE 187,500,000 187,500,000 187,500,000 187,500,000
Depreciación - 18,750,000 - 18,750,000 - 18,750,000
Depreciación acumulada - 18,750,000 - 37,500,000
Total Activo 250,000,000 255,442,000 271,272,292 284,832,251
Pasivo 0 1,904,700 6,207,247 6,918,522
Impto 1,904,700 6,207,247 6,918,522
Capital 250,000,000 253,537,300 265,065,045 277,913,729
Capital Social 250,000,000 250,000,000 250,000,000 250,000,000
Utilidad del ejercicio - 3,537,300 11,527,745 12,848,684
Utilidades acumuladas 3,537,300 15,065,045
Total Pasivo + Capital 250,000,000 255,442,000 271,272,292 284,832,251
- - - -
4 5
187,326,343 526,184,169
112,500,000 93,750,000
187,500,000 187,500,000
- 18,750,000 - 18,750,000
- 56,250,000 - 75,000,000
299,826,343 619,934,169
7,669,415 114,722,034
7,669,415 114,722,034
292,156,928 505,212,135
250,000,000 250,000,000
14,243,199 213,055,207
27,913,729 42,156,928
299,826,343 619,934,169
- -
Item 1 2 3 4
Demanda 1,600 1,656 1,714 1,774
Precio 54,000 55,080 56,182 57,305
Maduración 80% 100% 100% 100%
IPC 2% 2% 2% 2%
SECTOR 3.5% 3.5% 3.5% 3.5%
Tasa impositiva 35% 35% 35% 35%
Detalle 1 2 3 4
Ventas 69,120,000 91,212,480 96,293,015 101,656,536
Costo de Ventas 46,398,000 55,234,992 57,267,206 59,412,614
COSTOS DIRECTOS 27,648,000 36,484,992 38,517,206 40,662,614
Depreciación 18,750,000 18,750,000 18,750,000 18,750,000
= Utilidad Bruta 22,722,000 35,977,488 39,025,809 42,243,922
Gastos de Administración y ventas 17,280,000 18,242,496 19,258,603 20,331,307
=Utilidad Operacional 5,442,000 17,734,992 19,767,206 21,912,614
Otros Ingresos
Otros Egresos
=Utilidad antes de imptos e intereses 5,442,000 17,734,992 19,767,206 21,912,614
Gastos Financieros
=Utilidad antes de imptos 5,442,000 17,734,992 19,767,206 21,912,614
Impto 1,904,700 6,207,247 6,918,522 7,669,415
=Utilidad Neta 3,537,300 11,527,745 12,848,684 14,243,199
5
1,836
58,451
100%
2%
3.5%
35%
5
107,318,805
61,677,522
42,927,522
18,750,000
45,641,283
21,463,761
24,177,522
303,599,719
327,777,241
327,777,241
114,722,034
213,055,207
Flujo de caja 0 1 2 3
Flujo de caja inicial 250,000,000 62,500,000 86,692,000 121,272,292
Flujo del periodo 24,192,000 34,580,292 32,309,959
Ingresos 69,120,000 91,212,480 96,293,015
Ventas 69,120,000 91,212,480 96,293,015
Otros Ingresos - - -
Egresos 44,928,000 56,632,188 63,983,056
COSTOS DIRECTOS 27,648,000 36,484,992 38,517,206
Gastos de Administración y ventas 17,280,000 18,242,496 19,258,603
Otros Egresos - - -
Gastos Financieros - - -
Impto 1,904,700 6,207,247
Flujo al final del periodo - 250,000,000 86,692,000 121,272,292 153,582,251
VPN $320.979.848
TIR 53% En este caso el proyecto es viable debido a la TIR e
VPN ingresos 407,833,840
VPN Egresos 181,709,486
vpn Cotso de proyecto + inversión 431,709,486
Relación costo Beneficio 94.47%
4 5
153,582,251 187,326,343
33,744,092 338,857,826
101,656,536 410,918,524
101,656,536 107,318,805
- 303,599,719
67,912,444 72,060,698
40,662,614 42,927,522
20,331,307 21,463,761
- -
- -
6,918,522 7,669,415
187,326,343 526,184,169
to es viable debido a la TIR esta dando superior a la TIO exigida por los inversionistas
Valor PPE 187,500,000
% depreciación anual 10%
Depreciación PPE 18,750,000
18,750,000 18,750,000 18,750,000
1 2 3
187,500,000
Se expresa todo en el año 5
Valor PPE Valor depreciación
VA 187,500,000 PAGO 18,750,000
Periodos 5 PERIODOS 5
TIO 18.56% TIO 18.56%
VF 439,230,233 Vf $135,630,513
Valor de Salvamento en
el año 5 303,599,719
VS Valor de salvamento
Valor de salvamento
VS=Valor PPE-Depreciación
18,750,000 18,750,000
4 5
Costo Vida util Costo operación
Máquina A 1,200,000 4 320,000
Máquina B 1,800,000 6 380,000
Máquina A 240,000 240,000
1 2
320,000 320,000
1,200,000
Máquina B 300,000 300,000
1 2
380,000 380,000
1,800,000
Valor de salvamento Tir TIO
240,000 0%
360,000 0%
240,000 Maquina A
Inversión
240,000 240,000 Costos de operación
Depreciación
Salvamento
3 4 FCL
VAN
320,000 320,000 CAE
TIR
360,000 Maquina B
Inversión
300,000 300,000 300,000 300,000 Costos de operación
Depreciación
Salvamento
3 4 5 6 FCL
VAN
380,000 380,000 380,000 380,000 CAE
TIR
18.65%
0 1 2 3 4
- 1,200,000
- 320,000 - 320,000 - 320,000 - 320,000
240,000 240,000 240,000 240,000
240,000
- 1,200,000 - 80,000 - 80,000 - 80,000 160,000
($ 1,291,414.18)
$ 485,306.01
-48%
0 1 2 3 4 5 6
- 1,800,000
- 380,000 - 380,000 - 380,000 - 380,000 - 380,000 - 380,000
300,000 300,000 300,000 300,000 300,000 300,000
360,000
- 1,800,000 - 80,000 - 80,000 - 80,000 - 80,000 - 80,000 280,000
($ 1,946,176.53)
$ 564,441.17
-34%
- 1,800,000 - 80,000 - 80,000 - 80,000 - 80,000 - 80,000 280,000