PASIVOS(Préstamo) 200,000,000.00 38.

5%
RECURSOS PROPIOS(capital) 319,950,000.00 61.5%

INVERSIONES
MYE 230,000,000.00
PUESTA EN MARCHA 17,700,000.00
CONSTRUCCIONES 250,000,000.00
EST VIABILIDAD 10,000,000.00
CAPITAL DE TRABAJO 12,250,000.00
TOTAL INVERSIÓN 519,950,000.00

IMPUESTOS 25%
IMPUESTO G.OCA
TD Ke 28%
%CAPITAL TRABAJO 7%
ESTUDIO DE CREDITO 3%
TASA DE INTERES 14.0% ATA
3.5% ETA
3.6% ET
14.5% NT
15.3% EA

TABLA DE AMORTIZACIÓN
0 1

saldo 200,000,000.00 $ 160,000,000.00

abono a capital $ 40,000,000.00
intereses $ 30,632,625.12
Estudio crédito $ 6,000,000
Flujo $ 194,000,000 ($ 70,632,625.12)

INC MATERIA PRIMA 4.5%

INCREMENTO NÓMINA 2%
INCREMENTO MANTENIMIENTO 1.0%

CAPACIDAD DE PRODUCCIÓN 70,000.00

0 1
CAPACIDAD DE PRODX AÑO 25%
UNIDADES PRODUCIDAS 17,500.00
PRECIO DE VENTA 10,000.00
INGRESOS POR VENTAS 175,000,000.00

MATERIA PRIMA X UNIDAD 3,200.00

COSTO TOTOAL DE LA MP 56,000,000.00
SALARIOS 52,000,000.00
COSTOS DE MANTENIMIENTO 30,000,000.00
COSTOS FIJOS 45,000,000.00

0 1
CAPITAL DE TRABAJO 12,250,000.00
VARIACIÓN DE CAPITAL DE T 12,250,000.00 19,600,000.00
RECUPERACIÓN DE CAPITAL DE T

DEPRECICIACIONES
0 1
MYE $ 45,036,363.64
CONSTRUCCIONES $ 12,500,000.00
TOTAL DEPRECIACIONES $ 57,536,363.64

VALOR MECADO M y E 80,000,000.00

VALOR MERCADO CONSTRUCC 250,000,000.00

VALOR DE DESECHO VLA VDCOM

MYE 45,036,363.64
CONSTRUCCIONES 175,000,000.00
TOTAL VALOR DE DESECHO 220,036,363.64

INFLACIÓN 4% FLUJO D

0 1
FACTOR INFLACIONARIO 1.04
= TOTAL INGRESOS 182,000,000.00
- Costo matetria prima 58,240,000.00
- costo de mantenim 31,200,000.00
- Salarios 54,080,000.00
Costos fijos 46,800,000.00
= Costos y gastos totales 190,320,000.00
= UTILIDAD BRUTA (8,320,000.00)
- Depreciaciones 57,536,363.64
= UAII (65,856,363.64)
- Gastos financieros 30,632,625.12
= UAI (96,488,988.76)
- IMPUESTOS -
= UTILIDAD NETA (96,488,988.76)
+ Depreciación 57,536,363.64
+ Ingresos X Préstamos 194,000,000.00
- Abono a capital 40,000,000.00
- Inversión Activos Fijos 497,700,000.00
- Inversión en capital de W 12,250,000.00
- Estudio de viabilidad 10,000,000.00
- Variación capital de trabajo 20,384,000.00

+ Recuperación capital de trabajo

+ Valor de Desecho

= F. DE C. NETO (325,950,000.00) (99,336,625.12)

Factor descuento 1.00 0.78
valores presentes (325,950,000.00) (77,606,738.38)
suma acumulada (403,556,738.38)

TD(Ke) 28%
VPN $ 75,425,244.69
TIR 33.31%
TVR 31.25%
RBC 1.0435
PRI 4 x
PRID 6 x
PRID Exacto 5.42

Ingresos 0 1
TOTAL INGRESO 182,000,000.00
Ingresos X prestamos $ 194,000,000
Recuperación capital trabajo
Valor de desecho
TOTAL INGRESO $ 194,000,000 $ 182,000,000
VP INGRESOS $ 1,808,710,619.00

Egresos 0 1
Costos y gastos totales 190,320,000.00
Gastos financieros 30,632,625.12
Impuestos -
Abono a capital 40,000,000.00
Inversión en activos fijos 497,700,000.00
Inversión en w de trabajo 12,250,000.00
Estudio de viabilidad 10,000,000.00
Variación capital de trabajo 20,384,000.00
Total egresos 519,950,000.00 281,336,625.12
VP EGRESOS $ 1,733,285,374.31
 D/E
ESTRUCTUS DE CAP
62.51%
62.51%

TIZACIÓN
2 3 4 5

$ 120,000,000.00 $ 80,000,000.00 $ 40,000,000.00 $ 0.00

$ 40,000,000.00 $ 40,000,000.00 $ 40,000,000.00 $ 40,000,000.00
$ 24,506,100.10 $ 18,379,575.07 $ 12,253,050.05 $ 6,126,525.02

($ 64,506,100.10) ($ 58,379,575.07) ($ 52,253,050.05) ($ 46,126,525.02)

16.73% EA

2 3 4 5 6
65% 75% 80% 90% 100%
45,500.00 52,500.00 56,000.00 63,000.00 70,000.00
10,000.00 11,500.00 11,500.00 11,500.00 11,500.00
455,000,000.00 603,750,000.00 644,000,000.00 724,500,000.00 805,000,000.00

3,344.00 3,494.48 3,651.73 3,816.06 3,987.78

152,152,000.00 183,460,200.00 204,496,969.60 240,411,749.89 279,144,754.03
53,040,000.00 54,100,800.00 55,182,816.00 56,286,472.32 57,412,201.77
30,300,000.00 30,603,000.00 30,909,030.00 31,218,120.30 31,530,301.50
45,000,000.00 45,000,000.00 45,000,000.00 45,000,000.00 45,000,000.00

2 3 4 5 6
31,850,000.00 42,262,500.00 45,080,000.00 50,715,000.00 56,350,000.00
10,412,500.00 2,817,500.00 5,635,000.00 5,635,000.00
56,350,000.00

2 3 4 5 6
$ 40,532,727.27 $ 36,029,090.91 $ 31,525,454.55 $ 27,021,818.18 $ 22,518,181.82
$ 12,500,000.00 $ 12,500,000.00 $ 12,500,000.00 $ 12,500,000.00 $ 12,500,000.00
$ 53,032,727.27 $ 48,529,090.91 $ 44,025,454.55 $ 39,521,818.18 $ 35,018,181.82

FLUJO DE CAJA

2 3 4 5 6
1.08 1.12 1.17 1.22 1.27
492,128,000.00 679,136,640.00 753,388,912.64 881,465,027.79 1,018,581,809.89
164,567,603.20 206,367,774.41 239,232,530.38 292,497,653.27 353,207,166.19
32,772,480.00 34,424,212.99 36,159,193.33 37,981,616.67 39,895,890.15
57,368,064.00 60,856,042.29 64,556,089.66 68,481,099.91 72,644,750.79
48,672,000.00 50,618,880.00 52,643,635.20 54,749,380.61 56,939,355.83
303,380,147.20 352,266,909.70 392,591,448.57 453,709,750.46 522,687,162.96
188,747,852.80 326,869,730.30 360,797,464.07 427,755,277.33 495,894,646.92
53,032,727.27 48,529,090.91 44,025,454.55 39,521,818.18 35,018,181.82
135,715,125.53 278,340,639.39 316,772,009.52 388,233,459.14 460,876,465.11
24,506,100.10 18,379,575.07 12,253,050.05 6,126,525.02 -
111,209,025.43 259,961,064.32 304,518,959.47 382,106,934.12 460,876,465.11
27,802,256.36 64,990,266.08 76,129,739.87 95,526,733.53 115,219,116.28
83,406,769.07 194,970,798.24 228,389,219.61 286,580,200.59 345,657,348.83
53,032,727.27 48,529,090.91 44,025,454.55 39,521,818.18 35,018,181.82

40,000,000.00 40,000,000.00 40,000,000.00 40,000,000.00 -

 11,262,160.00 3,169,304.32 6,592,152.99 6,855,839.11 -

71,300,726.69

278,416,195.67
85,177,336.34 200,330,584.83 225,822,521.17 279,246,179.67 730,392,453.01
0.61 0.48 0.37 0.29 0.23
51,988,120.33 95,525,066.77 84,125,444.73 81,271,334.69 166,072,016.56
(351,568,618.05) (256,043,551.28) (171,918,106.55) (90,646,771.87) 75,425,244.69

x x 4 5 6
x x x x 6

2 3 4 5 6
492,128,000.00 679,136,640.00 753,388,912.64 881,465,027.79 1,018,581,809.89

71,300,726.69
278,416,195.67
$ 492,128,000 $ 679,136,640 $ 753,388,913 $ 881,465,028 $ 1,368,298,732

2 3 4 5 6
303,380,147.20 352,266,909.70 392,591,448.57 453,709,750.46 522,687,162.96
24,506,100.10 18,379,575.07 12,253,050.05 6,126,525.02 -
27,802,256.36 64,990,266.08 76,129,739.87 95,526,733.53 115,219,116.28
40,000,000.00 40,000,000.00 40,000,000.00 40,000,000.00 -

11,262,160.00 3,169,304.32 6,592,152.99 6,855,839.11 -

406,950,663.66 478,806,055.17 527,566,391.47 602,218,848.12 637,906,279.24
7

7
730,392,453.01
0.18
129,743,762.94
205,169,007.63

7
7