Certamen de Caro - Fuentes

Vida util del proyecto 10 años
AÑO 0 1 2 3
UNIDADES A VENDER 5,000 5,250 5,513

Precio de Venta 800,000 808,000 816,000
costo materia prima 376,800 380,568 384,374

costo produccion 64,000 64,800 65,600
mano de obra 16,000 16,000 16,000
Cuadros de Activos
Inversiones Valor de compra Vida util valor de Venta Depreciacon

HORNO 6,000,000,000 25 4,200,000,000 240,000,000
INFRAESTRUCTURA 1,250,000,000 20 500,000,000 62,500,000

EQUIPOS Y HERRAMIENTAS 2,860,000,000 10 429,000,000 286,000,000
TERRENO 500,000,000 0 500,000,000 0
MATERIALES E INSUMOS 800,000,000 10 - 80,000,000
INSTALACION Y PUESTA EN
MARCHA 600,000,000 0 0 0
Cuadro de deuda
Deuda Inicial Amortizaciones Interes Cuota Deuda Final

8,000,000,000 606,943,666 480,000,000 1,086,943,666 7,393,056,334
7,393,056,334 643,360,286 443,583,380 1,086,943,666 6,749,696,049
6,749,696,049 681,961,903 404,981,763 1,086,943,666 6,067,734,146
6,067,734,146 722,879,617 364,064,049 1,086,943,666 5,344,854,529
5,344,854,529 766,252,394 320,691,272 1,086,943,666 4,578,602,135
4,578,602,135 812,227,538 274,716,128 1,086,943,666 3,766,374,597
3,766,374,597 860,961,190 225,982,476 1,086,943,666 2,905,413,407
2,905,413,407 912,618,861 174,324,804 1,086,943,666 1,992,794,546
1,992,794,546 967,375,993 119,567,673 1,086,943,666 1,025,418,553
1,025,418,553 1,025,418,553 61,525,113 1,086,943,666 0
Flujo de caja
Año 0 1 2 3
Ingresos por venta 4,000,000,000 4,242,000,000 4,498,200,000
costo materia prima 1,884,000,000 1,997,982,000 2,118,859,911
costo produccion 320,000,000 340,200,000 361,620,000
mano de obra 80,000,000 84,000,000 88,200,000
Gasto de operación - - -
Gasto de marketing - - -
Gasto de adm 320,000,000 339,360,000 359,856,000
Gasto Financiero 480,000,000 443,583,380 404,981,763
Depreciacion 668,500,000 668,500,000 668,500,000
Ventas de activos - - -
Valor Libro - - -
Utilidad Antes de Impuestos - 247,500,000 368,374,620 496,182,326
Impuesto 30% - 74,250,000 110,512,386 148,854,698
Utilidad Neta - 173,250,000 257,862,234 347,327,628
Depreciacion - 668,500,000 668,500,000 668,500,000

Valor Libro - - - -
Amortizacion 606,943,666 643,360,286 681,961,903
Capital De Trabajo 781,200,000

Inversion incicial 12,010,000,000
Prestamos 8,000,000,000
Fujo De Caja -4,791,200,000 234,806,334 283,001,948 333,865,725
Valor actual Neto van (20%) -2,252,700,948

Tasa interna de retorno 10% SE RECHAZA EL PROYECTO, YA QUE NO ES POSIBLE CUMPLIR CON L
RENTABILIDAD EXIGIDA, SI YO ME ENDUEDO Y SOLO DESEMBOLSO
MILLONES , EL PROYECTO NO ES CAPAS DE DEVOLVERME LO INVER
HACE PERDER 2 MILL MILLONES APRIXIMADAMENTE
EL PROYECTO SOLO PUEDE ENTREGAR 10% DE RENTABILIDAD.
4 5 6 7 8
5,788 6,078 6,381 6,700 7,036

824,000 832,000 840,000 848,000 856,000
388,217 392,100 396,021 399,981 403,981

66,400 67,200 68,000 68,800 69,600
16,000 17,600 17,600 17,600 17,600
Valor Libro
3,600,000,000
625,000,000
-
500,000,000
0
Formula De cuota constante
𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)
4 5 6 7 8
4,769,415,000 5,056,506,000 5,360,382,563 5,682,005,516 6,022,389,809
2,247,050,936 2,382,997,517 2,527,168,867 2,680,062,583 2,842,206,370
384,331,500 408,410,100 433,935,731 460,992,900 489,670,947
92,610,000 106,964,550 112,312,778 117,928,416 123,824,837
- - - - -
- - - - -
381,553,200 404,520,480 428,830,605 454,560,441 481,791,185
364,064,049 320,691,272 274,716,128 225,982,476 174,324,804
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000
- - - - -
- - - - -
631,305,316 764,422,081 914,918,454 1,073,978,699 1,242,071,666
189,391,595 229,326,624 274,475,536 322,193,610 372,621,500
441,913,721 535,095,457 640,442,918 751,785,089 869,450,166
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

- - - - -
722,879,617 766,252,394 812,227,538 860,961,190 912,618,861
387,534,104 437,343,063 496,715,380 559,323,899 625,331,305
O ES POSIBLE CUMPLIR CON LA

UEDO Y SOLO DESEMBOLSO 4 MIL
S DE DEVOLVERME LO INVERTIDO Y ME
XIMADAMENTE
10% DE RENTABILIDAD.
9 10
7,387 7,757
864,000 872,000
408,020 412,101
70,400 71,200
18,400 18,400
valor dólar costo variablepor unidad

800 76800 0.8 coque
280000 2 hierro
20000 0.5 piedra

376800 1 tonedala
9 10
6,382,607,517 6,763,791,022
3,014,159,855 3,196,516,526
520,064,316 552,272,845
135,925,901 142,722,196
- -
- -
510,608,601 541,103,282
119,567,673 61,525,113
668,500,000 668,500,000
- 5,629,000,000
- 4,725,000,000
1,413,781,171 2,505,151,060
424,134,351 751,545,318
989,646,820 1,753,605,742
668,500,000 668,500,000
- 4,725,000,000
967,375,993 1,025,418,553
690,770,827 6,121,687,189
AÑO 0 1 2 3
UNIDADES A VENDER 7730 8,117 8,522
Precio de Venta 800,000 808,000 816,000
mano de obra 16,000 16,000 16,000
Porcentaje 54.6%
Cuadros de Activos

HORNO 6,000,000,000 25 4,200,000,000 240,000,000
TERRENO 500,000,000 0 500,000,000 0
MARCHA 600,000,000 0 0 0
Cuadro de deuda

8,000,000,000 606,943,666 480,000,000 1,086,943,666 7,393,056,334
7,393,056,334 643,360,286 443,583,380 1,086,943,666 6,749,696,049
6,749,696,049 681,961,903 404,981,763 1,086,943,666 6,067,734,146
6,067,734,146 722,879,617 364,064,049 1,086,943,666 5,344,854,529
5,344,854,529 766,252,394 320,691,272 1,086,943,666 4,578,602,135
4,578,602,135 812,227,538 274,716,128 1,086,943,666 3,766,374,597
3,766,374,597 860,961,190 225,982,476 1,086,943,666 2,905,413,407
2,905,413,407 912,618,861 174,324,804 1,086,943,666 1,992,794,546
1,992,794,546 967,375,993 119,567,673 1,086,943,666 1,025,418,553
1,025,418,553 1,025,418,553 61,525,113 1,086,943,666 0
Flujo de caja
Año 0 1 2 3
mano de obra 123,680,000 129,864,000 136,357,200
Gasto de adm 494,720,000 524,650,560 556,337,376
Depreciacion 668,500,000 668,500,000 668,500,000
Valor Libro - - -
Utilidad Antes de Impuestos - 1,009,716,000 1,176,704,688 1,353,218,919
Impuesto 30% - 302,914,800 353,011,406 405,965,676
Utilidad Neta - 706,801,200 823,693,282 947,253,243
Depreciacion - 668,500,000 668,500,000 668,500,000

Valor Libro - - - -
Amortizacion 606,943,666 643,360,286 681,961,903
Capital De Trabajo 1,207,735,200

Prestamos 8,000,000,000
Fujo De Caja -5,217,735,200 768,357,534 848,832,996 933,791,340
Valor actual Neto van (20%) 21,657,283

La empresa debe aumentar sus deudas
Tasa interna de retorno 20% en un 54,6% para que su VAN sea
positivo y la tasa interna sea a la misma
a la exigida.
4 5 6 7 8
8,948 9,396 9,866 10,359 10,877
824,000 832,000 840,000 848,000 856,000
388,217 392,100 396,021 399,981 403,981
66,400 67,200 68,000 68,800 69,600
16,000 17,600 17,600 17,600 17,600
Valor Libro
3,600,000,000
625,000,000
-
500,000,000
0
𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)
4 5 6 7 8
7,373,515,590 7,817,358,276 8,287,151,442 8,784,380,528 9,310,614,645
3,473,940,746 3,684,114,162 3,907,003,068 4,143,376,754 4,394,051,048
594,176,499 631,402,015 670,864,641 712,695,024 757,031,284
143,175,060 165,367,194 173,635,554 182,317,332 191,433,198
- - - - -
- - - - -
589,881,247 625,388,662 662,972,115 702,750,442 744,849,172
364,064,049 320,691,272 274,716,128 225,982,476 174,324,804
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000
- - - - -
- - - - -
1,539,777,989 1,721,894,972 1,929,459,935 2,148,758,500 2,380,425,139
461,933,397 516,568,492 578,837,981 644,627,550 714,127,542
1,077,844,592 1,205,326,480 1,350,621,955 1,504,130,950 1,666,297,597
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

- - - - -
722,879,617 766,252,394 812,227,538 860,961,190 912,618,861
1,023,464,975 1,107,574,086 1,206,894,417 1,311,669,760 1,422,178,736

9 10
11,421 11,992
864,000 872,000
408,020 412,101
70,400 71,200
18,400 18,400

800 76800 0.8 coque
280000 2 hierro
20000 0.5 piedra
376800 1 tonedala
9 10
9,867,511,222 10,456,820,919
4,659,891,136 4,941,814,550
804,019,433 853,813,818
210,141,443 220,648,515
- -
- -
789,400,898 836,545,674
119,567,673 61,525,113
668,500,000 668,500,000
- 5,629,000,000
- 4,725,000,000
2,615,990,639 3,777,973,250
784,797,192 1,133,391,975
1,831,193,448 2,644,581,275
668,500,000 668,500,000
- 4,725,000,000
967,375,993 1,025,418,553
1,532,317,455 7,012,662,722
AÑO 0 1 2 3
Precio de Venta 800,000 808,000 816,000
mano de obra 16,000 16,000 16,000
Porcentaje 31.0% 116,808
Cuadros de Activos

HORNO 6,000,000,000 25 4,200,000,000 240,000,000
TERRENO 500,000,000 0 500,000,000 0
MARCHA 600,000,000 0 0 0
Cuadro de deuda

8,000,000,000 606,943,666 480,000,000 1,086,943,666 7,393,056,334
7,393,056,334 643,360,286 443,583,380 1,086,943,666 6,749,696,049
6,749,696,049 681,961,903 404,981,763 1,086,943,666 6,067,734,146
6,067,734,146 722,879,617 364,064,049 1,086,943,666 5,344,854,529
5,344,854,529 766,252,394 320,691,272 1,086,943,666 4,578,602,135
4,578,602,135 812,227,538 274,716,128 1,086,943,666 3,766,374,597
3,766,374,597 860,961,190 225,982,476 1,086,943,666 2,905,413,407
2,905,413,407 912,618,861 174,324,804 1,086,943,666 1,992,794,546
1,992,794,546 967,375,993 119,567,673 1,086,943,666 1,025,418,553
1,025,418,553 1,025,418,553 61,525,113 1,086,943,666 0
Flujo de caja
Año 0 1 2 3
mano de obra 80,000,000 84,000,000 88,200,000
Gasto de adm 320,000,000 339,360,000 359,856,000
Depreciacion 668,500,000 668,500,000 668,500,000
Valor Libro - - -
Utilidad Antes de Impuestos - 831,540,000 987,749,040 1,153,028,898
Impuesto 30% - 249,462,000 296,324,712 345,908,670
Utilidad Neta - 582,078,000 691,424,328 807,120,229
Depreciacion - 668,500,000 668,500,000 668,500,000

Valor Libro - - - -
Amortizacion 606,943,666 643,360,286 681,961,903

Prestamos 8,000,000,000
Fujo De Caja -4,615,988,000 643,634,334 716,564,042 793,658,326
Valor actual Neto van (20%) 1,528,617

SI LOS PRECIOS DE MATERIA PRIMA DISMINUYEN EN UN 31% PODRIA
Tasa interna de retorno 20% CONSIDERAR QUE EL PROYECTO ES RENTABLE, YA QUE HAY NOS GENE
GANANCIA DE 1 MILLON APROXIMADAMENTE.
NOS GENRA UNA TASA INTERNA DE RETORNO IGUAL A LA EXIGIDA PO
INVERSIONISTA
4 5 6 7 8
5,788 6,078 6,381 6,700 7,036
824,000 832,000 840,000 848,000 856,000
267,870 270,549 273,254 275,987 278,747
66,400 67,200 68,000 68,800 69,600
16,000 17,600 17,600 17,600 17,600
Valor Libro
3,600,000,000
625,000,000
-
500,000,000
0
𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)
4 5 6 7 8
4,769,415,000 5,056,506,000 5,360,382,563 5,682,005,516 6,022,389,809
1,550,465,146 1,644,268,287 1,743,746,518 1,849,243,183 1,961,122,395
384,331,500 408,410,100 433,935,731 460,992,900 489,670,947
92,610,000 106,964,550 112,312,778 117,928,416 123,824,837
- - - - -
- - - - -
381,553,200 404,520,480 428,830,605 454,560,441 481,791,185
364,064,049 320,691,272 274,716,128 225,982,476 174,324,804
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000
- - - - -
- - - - -
1,327,891,106 1,503,151,311 1,698,340,802 1,904,798,100 2,123,155,640
398,367,332 450,945,393 509,502,241 571,439,430 636,946,692
929,523,774 1,052,205,918 1,188,838,562 1,333,358,670 1,486,208,948
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

- - - - -
722,879,617 766,252,394 812,227,538 860,961,190 912,618,861
875,144,157 954,453,524 1,045,111,024 1,140,897,480 1,242,090,087
MINUYEN EN UN 31% PODRIAMOS

ABLE, YA QUE HAY NOS GENERA UNA
MENTE.
ORNO IGUAL A LA EXIGIDA POR LOS
9 10
7,387 7,757
864,000 872,000
281,534 284,349
70,400 71,200
18,400 18,400

800 76800 0.8 coque
280000 2 hierro
20000 0.5 piedra
376800 1 tonedala
9 10
6,382,607,517 6,763,791,022
2,079,770,300 2,205,596,403
520,064,316 552,272,845
135,925,901 142,722,196
- -
- -
510,608,601 541,103,282
119,567,673 61,525,113
668,500,000 668,500,000
- 5,629,000,000
- 4,725,000,000
2,348,170,726 3,496,071,183
704,451,218 1,048,821,355
1,643,719,508 2,447,249,828
668,500,000 668,500,000
- 4,725,000,000
967,375,993 1,025,418,553
1,344,843,515 6,815,331,275
AÑO 0 1 2 3
Precio de Venta 792000 800,000 808,000
mano de obra 16,000 16,000 16,000
Porcentaje 1% 8000
Cuadros de Activos

HORNO 6,000,000,000 25 4,200,000,000 240,000,000
TERRENO 500,000,000 0 500,000,000 0
MARCHA 600,000,000 0 0 0
Cuadro de deuda

8,000,000,000 606,943,666 480,000,000 1,086,943,666 7,393,056,334
7,393,056,334 643,360,286 443,583,380 1,086,943,666 6,749,696,049
6,749,696,049 681,961,903 404,981,763 1,086,943,666 6,067,734,146
6,067,734,146 722,879,617 364,064,049 1,086,943,666 5,344,854,529
5,344,854,529 766,252,394 320,691,272 1,086,943,666 4,578,602,135
4,578,602,135 812,227,538 274,716,128 1,086,943,666 3,766,374,597
3,766,374,597 860,961,190 225,982,476 1,086,943,666 2,905,413,407
2,905,413,407 912,618,861 174,324,804 1,086,943,666 1,992,794,546
1,992,794,546 967,375,993 119,567,673 1,086,943,666 1,025,418,553
1,025,418,553 1,025,418,553 61,525,113 1,086,943,666 0
Flujo de caja
Año 0 1 2 3
mano de obra 80,000,000 84,000,000 88,200,000
Gasto de adm 316,800,000 336,000,000 356,328,000
Depreciacion 668,500,000 668,500,000 668,500,000
Valor Libro - - -
Impuesto 30% - 63,210,000 98,920,386 136,683,098
Utilidad Neta - 147,490,000 230,814,234 318,927,228
Depreciacion - 668,500,000 668,500,000 668,500,000

Valor Libro - - - -
Amortizacion 606,943,666 643,360,286 681,961,903

Prestamos 8,000,000,000
Fujo De Caja -4,790,240,000 209,046,334 255,953,948 305,465,325

Tasa interna de retorno 9% Al disminuir el precio de venta no
tiene mayor relevancia ya que sigue
arrojando un VAN negativo. la taza
interna de retorno disminuyo en un
1%
4 5 6 7 8
5,788 6,078 6,381 6,700 7,036
816,000 824,000 832,000 840,000 848,000
388,217 392,100 396,021 399,981 403,981
66,400 67,200 68,000 68,800 69,600
16,000 17,600 17,600 17,600 17,600
Valor Libro
3,600,000,000
625,000,000
-
500,000,000
0
𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)
4 5 6 7 8
4,723,110,000 5,007,885,750 5,309,331,300 5,628,401,691 5,966,105,792
2,247,050,936 2,382,997,517 2,527,168,867 2,680,062,583 2,842,206,370
384,331,500 408,410,100 433,935,731 460,992,900 489,670,947
92,610,000 106,964,550 112,312,778 117,928,416 123,824,837
- - - - -
- - - - -
377,848,800 400,630,860 424,746,504 450,272,135 477,288,463
364,064,049 320,691,272 274,716,128 225,982,476 174,324,804
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000
- - - - -
- - - - -
588,704,716 719,691,451 867,951,292 1,024,663,179 1,190,290,370
176,611,415 215,907,435 260,385,388 307,398,954 357,087,111
412,093,301 503,784,016 607,565,905 717,264,226 833,203,259
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

- - - - -
722,879,617 766,252,394 812,227,538 860,961,190 912,618,861
357,713,684 406,031,622 463,838,367 524,803,036 589,084,398

9 10
7,387 7,757
856,000 864,000
408,020 412,101
70,400 71,200
18,400 18,400

800 76800 0.8 coque
280000 2 hierro
20000 0.5 piedra
376800 1 tonedala
9 10
6,323,509,299 6,701,737,893
3,014,159,855 3,196,516,526
520,064,316 552,272,845
135,925,901 142,722,196
- -
- -
505,880,744 536,139,031
119,567,673 61,525,113
668,500,000 668,500,000
- 5,629,000,000
- 4,725,000,000
1,359,410,811 2,448,062,181
407,823,243 734,418,654
951,587,567 1,713,643,527
668,500,000 668,500,000
- 4,725,000,000
967,375,993 1,025,418,553
652,711,574 6,081,724,974
AÑO 0 1 2 3
Precio de Venta 800,000 808,000 816,000
mano de obra 16,000 16,000 16,000
Cuadros de Activos

HORNO 6,000,000,000 25 4,200,000,000 240,000,000
TERRENO 500,000,000 0 500,000,000 0
MARCHA 600,000,000 0 0 0
Cuadro de deuda

8,000,000,000 606,943,666 480,000,000 1,086,943,666 7,393,056,334
7,393,056,334 643,360,286 443,583,380 1,086,943,666 6,749,696,049
6,749,696,049 681,961,903 404,981,763 1,086,943,666 6,067,734,146
6,067,734,146 722,879,617 364,064,049 1,086,943,666 5,344,854,529
5,344,854,529 766,252,394 320,691,272 1,086,943,666 4,578,602,135
4,578,602,135 812,227,538 274,716,128 1,086,943,666 3,766,374,597
3,766,374,597 860,961,190 225,982,476 1,086,943,666 2,905,413,407
2,905,413,407 912,618,861 174,324,804 1,086,943,666 1,992,794,546
1,992,794,546 967,375,993 119,567,673 1,086,943,666 1,025,418,553
1,025,418,553 1,025,418,553 61,525,113 1,086,943,666 0
Flujo de caja
Año 0 1 2 3
mano de obra 80,000,000 84,000,000 88,200,000
Gasto de adm 320,000,000 339,360,000 359,856,000
Gasto Financiero
Depreciacion 668,500,000 668,500,000 668,500,000
Valor Libro - - -
Impuesto 30% - 218,250,000 243,587,400 270,349,227
Utilidad Neta - 509,250,000 568,370,600 630,814,862
Depreciacion - 668,500,000 668,500,000 668,500,000

Valor Libro - - - -
Amortizacion

Prestamos
Fujo De Caja -12,791,200,000 1,177,750,000 1,236,870,600 1,299,314,862

EL PROYECTO NO ES RENTABLE , YA QUE EL VAN NEGATIVO AUMENTA M
Tasa interna de retorno 7% DUDA LA RENTABILIDAD DE 20 % EXIGIDA POR LOS INVERSIONISTA NO
ENTREGAR UN 7% DE RENTABILIDAD PARA QUE EL PROYECTO SE APRU
4 5 6 7 8
5,788 6,078 6,381 6,700 7,036
824,000 832,000 840,000 848,000 856,000
388,217 392,100 396,021 399,981 403,981
66,400 67,200 68,000 68,800 69,600
16,000 17,600 17,600 17,600 17,600
Valor Libro
3,600,000,000
625,000,000
-
500,000,000
0
𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)
4 5 6 7 8
4,769,415,000 5,056,506,000 5,360,382,563 5,682,005,516 6,022,389,809
2,247,050,936 2,382,997,517 2,527,168,867 2,680,062,583 2,842,206,370
384,331,500 408,410,100 433,935,731 460,992,900 489,670,947
92,610,000 106,964,550 112,312,778 117,928,416 123,824,837
- - - - -
- - - - -
381,553,200 404,520,480 428,830,605 454,560,441 481,791,185
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

- - - - -
- - - - -
995,369,364 1,085,113,353 1,189,634,582 1,299,961,175 1,416,396,470
298,610,809 325,534,006 356,890,375 389,988,352 424,918,941
696,758,555 759,579,347 832,744,207 909,972,822 991,477,529
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

- - - - -
1,365,258,555 1,428,079,347 1,501,244,207 1,578,472,822 1,659,977,529
L VAN NEGATIVO AUMENTA MUCHO MAS CASI EN 3 MIL MILLONES, SIN

POR LOS INVERSIONISTA NO SE PUEDE ASEGURAR, SOLO PODEMOS
A QUE EL PROYECTO SE APRUEBE.
9 10
7,387 7,757
864,000 872,000
408,020 412,101
70,400 71,200
18,400 18,400

800 76800 0.8 coque
280000 2 hierro
20000 0.5 piedra
376800 1 tonedala
9 10
6,382,607,517 6,763,791,022
3,014,159,855 3,196,516,526
520,064,316 552,272,845
135,925,901 142,722,196
- -
- -
510,608,601 541,103,282
668,500,000 668,500,000
- 5,629,000,000
- 4,725,000,000
1,533,348,844 2,566,676,173
460,004,653 770,002,852
1,073,344,191 1,796,673,321
668,500,000 668,500,000
- 4,725,000,000
1,741,844,191 7,190,173,321
AÑO 0 1 2 3
Precio de Venta 800,000 808,000 816,000
mano de obra 16,000 16,000 16,000
Cuadros de Activos

HORNO 6,000,000,000 25 4,200,000,000 240,000,000
TERRENO 500,000,000 0 500,000,000 0
MARCHA 600,000,000 0 0 0
Cuadro de deuda

12,010,000,000 911,174,178 720,600,000 1,631,774,178 11,098,825,822
11,098,825,822 965,844,629 665,929,549 1,631,774,178 10,132,981,193
10,132,981,193 1,023,795,307 607,978,872 1,631,774,178 9,109,185,886
9,109,185,886 1,085,223,025 546,551,153 1,631,774,178 8,023,962,861
8,023,962,861 1,150,336,407 481,437,772 1,631,774,178 6,873,626,455
6,873,626,455 1,219,356,591 412,417,587 1,631,774,178 5,654,269,864
5,654,269,864 1,292,517,986 339,256,192 1,631,774,178 4,361,751,877
4,361,751,877 1,370,069,066 261,705,113 1,631,774,178 2,991,682,812
2,991,682,812 1,452,273,210 179,500,969 1,631,774,178 1,539,409,602
1,539,409,602 1,539,409,602 92,364,576 1,631,774,178 0
Flujo de caja
Año 0 1 2 3
mano de obra 80,000,000 84,000,000 88,200,000
Gasto de adm 320,000,000 339,360,000 359,856,000
Depreciacion 668,500,000 668,500,000 668,500,000
Valor Libro - - -
Impuesto 30% - 2,070,000 43,808,535 87,955,565
Utilidad Neta - 4,830,000 102,219,915 205,229,652
Depreciacion - 668,500,000 668,500,000 668,500,000

Valor Libro - - - -
Amortizacion 911,174,178 965,844,629 1,023,795,307

Prestamos 12,010,000,000
Fujo De Caja -781,200,000 -237,844,178 -195,124,713 -150,065,654
Valor actual Neto van (20%) -304,997,384

La perdida disminuye al tener un prestamo igual a la
Tasa interna de retorno 16% inversión pero aun asi el proyecto no es rentable.
4 5 6 7 8
5,788 6,078 6,381 6,700 7,036
824,000 832,000 840,000 848,000 856,000
388,217 392,100 396,021 399,981 403,981
66,400 67,200 68,000 68,800 69,600
16,000 17,600 17,600 17,600 17,600
Valor Libro
3,600,000,000
625,000,000
-
500,000,000
0
𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)
4 5 6 7 8
4,769,415,000 5,056,506,000 5,360,382,563 5,682,005,516 6,022,389,809
2,247,050,936 2,382,997,517 2,527,168,867 2,680,062,583 2,842,206,370
384,331,500 408,410,100 433,935,731 460,992,900 489,670,947
92,610,000 106,964,550 112,312,778 117,928,416 123,824,837
- - - - -
- - - - -
381,553,200 404,520,480 428,830,605 454,560,441 481,791,185
546,551,153 481,437,772 412,417,587 339,256,192 261,705,113
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000
- - - - -
- - - - -
448,818,211 603,675,581 777,216,994 960,704,983 1,154,691,358
134,645,463 181,102,674 233,165,098 288,211,495 346,407,407
314,172,748 422,572,907 544,051,896 672,493,488 808,283,950
668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

- - - - -
1,085,223,025 1,150,336,407 1,219,356,591 1,292,517,986 1,370,069,066
-102,550,277 -59,263,500 -6,804,695 48,475,502 106,714,885
tamo igual a la
es rentable.
9 10
7,387 7,757
864,000 872,000
408,020 412,101
70,400 71,200
18,400 18,400

800 76800 0.8 coque
280000 2 hierro
20000 0.5 piedra
376800 1 tonedala
9 10
6,382,607,517 6,763,791,022
3,014,159,855 3,196,516,526
520,064,316 552,272,845
135,925,901 142,722,196
- -
- -
510,608,601 541,103,282
179,500,969 92,364,576
668,500,000 668,500,000
- 5,629,000,000
- 4,725,000,000
1,353,847,875 2,474,311,597
406,154,362 742,293,479
947,693,512 1,732,018,118
668,500,000 668,500,000
- 4,725,000,000
1,452,273,210 1,539,409,602
163,920,303 5,586,108,516

Certamen de Caro - Fuentes

Cargado por

Copyright:

Formatos disponibles

Certamen de Caro - Fuentes

Cargado por

Información del documento

Título original

Derechos de autor

Formatos disponibles

Compartir este documento

Compartir o incrustar documentos

Opciones para compartir

¿Le pareció útil este documento?

¿Este contenido es inapropiado?

Copyright:

Formatos disponibles

Certamen de Caro - Fuentes

Cargado por

Copyright:

Formatos disponibles

Vida util del proyecto 10 años

UNIDADES A VENDER 5,000 5,250 5,513

costo materia prima 376,800 380,568 384,374

Inversiones Valor de compra Vida util valor de Venta Depreciacon

INFRAESTRUCTURA 1,250,000,000 20 500,000,000 62,500,000

Deuda Inicial Amortizaciones Interes Cuota Deuda Final

Depreciacion - 668,500,000 668,500,000 668,500,000

Capital De Trabajo 781,200,000

Valor actual Neto van (20%) -2,252,700,948

5,788 6,078 6,381 6,700 7,036

388,217 392,100 396,021 399,981 403,981

Formula De cuota constante

𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)

668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

387,534,104 437,343,063 496,715,380 559,323,899 625,331,305

O ES POSIBLE CUMPLIR CON LA

valor dólar costo variablepor unidad

20000 0.5 piedra

Inversiones Valor de compra Vida util valor de Venta Depreciacon

Deuda Inicial Amortizaciones Interes Cuota Deuda Final

Depreciacion - 668,500,000 668,500,000 668,500,000

Capital De Trabajo 1,207,735,200

Valor actual Neto van (20%) 21,657,283

Formula De cuota constante

𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)

668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

1,023,464,975 1,107,574,086 1,206,894,417 1,311,669,760 1,422,178,736

valor dólar costo variablepor unidad

Inversiones Valor de compra Vida util valor de Venta Depreciacon

Deuda Inicial Amortizaciones Interes Cuota Deuda Final

Depreciacion - 668,500,000 668,500,000 668,500,000

Capital De Trabajo 605,988,000

Valor actual Neto van (20%) 1,528,617

Formula De cuota constante

𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)

668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

875,144,157 954,453,524 1,045,111,024 1,140,897,480 1,242,090,087

MINUYEN EN UN 31% PODRIAMOS

valor dólar costo variablepor unidad

Inversiones Valor de compra Vida util valor de Venta Depreciacon

Deuda Inicial Amortizaciones Interes Cuota Deuda Final

Depreciacion - 668,500,000 668,500,000 668,500,000

Capital De Trabajo 780,240,000

Valor actual Neto van (20%) -2,378,295,436

Formula De cuota constante

𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)

668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

357,713,684 406,031,622 463,838,367 524,803,036 589,084,398

valor dólar costo variablepor unidad

Inversiones Valor de compra Vida util valor de Venta Depreciacon

Deuda Inicial Amortizaciones Interes Cuota Deuda Final

Depreciacion - 668,500,000 668,500,000 668,500,000

Capital De Trabajo 781,200,000

Valor actual Neto van (20%) -6,138,393,845

Formula De cuota constante

𝐶=𝑉𝑃 (( 〖 1+𝑖) 〗 ^𝑛∗𝑖)/( 〖 (1+𝑖) 〗 ^𝑛−1)

668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

668,500,000 668,500,000 668,500,000 668,500,000 668,500,000

1,365,258,555 1,428,079,347 1,501,244,207 1,578,472,822 1,659,977,529