Tabla para generar 192 meses o 16 aos, elegir de lista despegableGasto financiero Meses 36

Mes Saldo Interes Amortizacion Cuota0 $11,720,000 $0 $0 $0

1 $11,476,725 $187,520 $243,275 $430,795

2 $11,229,558 $183,628 $247,167 $430,795

3 $10,978,437 $179,673 $251,122 $430,795

4 $10,723,297 $175,655 $255,140 $430,795

5 $10,464,075 $171,573 $259,222 $430,795

6 $10,200,706 $167,425 $263,369 $430,795

7 $9,933,123 $163,211 $267,583 $430,795

8 $9,661,258 $158,930 $271,865 $430,795

9 $9,385,044 $154,580 $276,214 $430,795

10 $9,104,410 $150,161 $280,634 $430,795

11 $8,819,286 $145,671 $285,124 $430,795

12 $8,529,600 $141,109 $289,686 $430,795

13 $8,235,279 $136,474 $294,321 $430,795

14 $7,936,248 $131,764 $299,030 $430,795

15 $7,632,434 $126,980 $303,815 $430,795

16 $7,323,758 $122,119 $308,676 $430,795

17 $7,010,144 $117,180 $313,614 $430,795

18 $6,691,511 $112,162 $318,632 $430,795

19 $6,367,781 $107,064 $323,730 $430,795

20 $6,038,871 $101,884 $328,910 $430,795

21 $5,704,698 $96,622 $334,173 $430,795

22 $5,365,179 $91,275 $339,519 $430,795

23 $5,020,227 $85,843 $344,952 $430,795

24 $4,669,756 $80,324 $350,471 $430,795

25 $4,313,678 $74,716 $356,079 $430,795

26 $3,951,902 $69,019 $361,776 $430,795

27 $3,584,338 $63,230 $367,564 $430,795

28 $3,210,892 $57,349 $373,445 $430,795

29 $2,831,472 $51,374 $379,420 $430,795

30 $2,445,981 $45,304 $385,491 $430,795

31 $2,054,322 $39,136 $391,659 $430,795

32 $1,656,397 $32,869 $397,925 $430,795

33 $1,252,104 $26,502 $404,292 $430,795

34 $841,344 $20,034 $410,761 $430,795

35 $424,010 $13,461 $417,333 $430,795

36 $0 $6,784 $424,010 $430,795

0.016 tanto por uno 1,19% - 14,28%Plazo de la deuda 36 mesesCosto total Deuda 15,508,605

Tasa de inters mensual

123456789

101112131415161718192021222324252627282930313233343536373839404142434445464748495051

525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899

100101102103104105

106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159

160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192

Descripcin Costo [unid] Cantidad Costo Vida til Meses Depreciacin

Colectivo Corsa 2006 11,000,000 1 11,000,000 36 305,556

Neumticos 300,000 2 600,000 36 16,667

Batera 60,000 2 120,000 36 3,333

Total 11,720,000 Total 325,556

Total sin IVA 9,848,739

Inversion Total 11,720,000

% de Prestamo 1

Crdito 11,720,000

Valor Residual igual al 10% del valor

Proyeccin de ingresos por ventas en funcin crecimiento de poblacin de 1,97%

Meses

Totales 0 0 0 0 0 0 0 0 0 0 0 0

al crecer la poblacin se compran ms productos

Ventas Mes 1

Ventas Mes2

Ventas 2016

Ventas 2017

Ventas 2018

Ventas 2019

Ventas 2020

Ventas 2021

Ventas 2022

Ventas 2023

Ventas 2024

Ventas 2025

0 0 0

Ventas 2026

Ventas 2027

Ventas 2028

Costos Operacin y Mantencin

Nota: Se considera un aumento anual del sueldo segn IPC del 2,5%

Costos Operacin Mes 1 Mes 2 Mes 3 Mes 4 Mes 5 Mes 6 Mes 7 Mes 8 Mes 9 Mes 10

9,720,000 9,963,000 10,212,075 10,467,377 10,729,061 10,997,288 11,272,220 11,554,026 11,842,876 12,138,948

Insumos Operacin 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000

Total 9,765,000 10,008,000 10,257,075 10,512,377 10,774,061 11,042,288 11,317,220 11,599,026 11,887,876 12,183,948

Costos Mantencin Ao 1 Ao 2 Ao 3 Ao 4 Ao 5 Ao 6 Ao 7 Ao 8 Ao 9 Ao 10

9,720,000 9,963,000 10,212,075 10,467,377 10,729,061 10,997,288 11,272,220 11,554,026 11,842,876 12,138,948

Insumos Mantencin 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000

Total 9,761,000 10,004,000 10,253,075 10,508,377 10,770,061 11,038,288 11,313,220 11,595,026 11,883,876 12,179,948

19,526,000 20,012,000 20,510,150 21,020,754 21,544,123 22,080,576 22,630,440 23,194,051 23,771,752 24,363,896

Sueldo (01 Operador) 180 HH Mensuales

Sueldo (02 Mantenedores) 72 HH Mensuales

Total Costos Operacin y Mantencin

Mes 11 Mes 12 Mes 13 Mes 14 Mes 15 Mes 16 Mes 17 Mes 18 Mes 19 Mes 20 Mes 21 Mes 22

12,442,422 12,753,482 13,072,319 13,399,127 13,734,106 14,077,458 14,429,395 14,790,129 15,159,883 15,538,880 15,927,352 16,325,536

45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000

12,487,422 12,798,482 13,117,319 13,444,127 13,779,106 14,122,458 14,474,395 14,835,129 15,204,883 15,583,880 15,972,352 16,370,536

Ao 11 Ao 12 Ao 13 Ao 14 Ao 15 Ao 16 Ao 17 Ao 18 Ao 19 Ao 20 Ao 21 Ao 22

12,442,422 12,753,482 13,072,319 13,399,127 13,734,106 14,077,458 14,429,395 14,790,129 15,159,883 15,538,880 15,927,352 16,325,536

41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000

12,483,422 12,794,482 13,113,319 13,440,127 13,775,106 14,118,458 14,470,395 14,831,129 15,200,883 15,579,880 15,968,352 16,366,536

24,970,844 25,592,965 26,230,639 26,884,255 27,554,211 28,240,916 28,944,789 29,666,259 30,405,765 31,163,760 31,940,704 32,737,071

Mes 23 Mes 24 Mes 25 Mes 26 Mes 27 Mes 28 Mes 29 Mes 30 Mes 31 Mes 32 Mes 33 Mes 34

16,733,674 17,152,016 17,580,816 18,020,337 18,470,845 18,932,616 19,405,932 19,891,080 20,388,357 20,898,066 21,420,517 21,956,030

45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000 45,000

16,778,674 17,197,016 17,625,816 18,065,337 18,515,845 18,977,616 19,450,932 19,936,080 20,433,357 20,943,066 21,465,517 22,001,030

Ao 23 Ao 24 Ao 25 Ao 26 Ao 27 Ao 28 Ao 29 Ao 30 Ao 31 Ao 32 Ao 33 Ao 34

16,733,674 17,152,016 17,580,816 18,020,337 18,470,845 18,932,616 19,405,932 19,891,080 20,388,357 20,898,066 21,420,517 21,956,030

41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000 41,000

16,774,674 17,193,016 17,621,816 18,061,337 18,511,845 18,973,616 19,446,932 19,932,080 20,429,357 20,939,066 21,461,517 21,997,030

33,553,348 34,390,032 35,247,632 36,126,673 37,027,690 37,951,232 38,897,863 39,868,160 40,862,714 41,882,132 42,927,035 43,998,061

Mes 35 Mes 36

22,504,931 23,067,554

45,000 45,000

22,549,931 23,112,554

Ao 35 Ao 36

22,504,931 23,067,554

41,000 41,000

22,545,931 23,108,554

45,095,862 46,221,109

Tiempo (meses)

Item 0 1 2 3 4 5 6 7 8

0 0 0 0 0 0 0 0

Ingresos por venta de productos 0 0 0 0 0 0 0 0

Valor Residual 0 0 0 0 0 0 0 0

Costos Totales -20,039,076 -20,521,183 -21,015,378 -21,521,964 -22,041,251 -22,573,556 -23,119,207 -23,678,537

19,526,000 20,012,000 20,510,150 21,020,754 21,544,123 22,080,576 22,630,440 23,194,051

0 0 0 0 0 0 0 0

Depreciacin 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556

187,520 183,628 179,673 175,655 171,573 167,425 163,211 158,930

-20,039,076 -20,521,183 -21,015,378 -21,521,964 -22,041,251 -22,573,556 -23,119,207 -23,678,537

Impuesto (19%) 0 0 0 0 0 0 0 0

-20,039,076 -20,521,183 -21,015,378 -21,521,964 -22,041,251 -22,573,556 -23,119,207 -23,678,537

Depreciacin 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556

Inversin -11,720,000

11,720,000

-243,275 -247,167 -251,122 -255,140 -259,222 -263,369 -267,583 -271,865

Valor Libro

Flujo de Caja 0 -19,956,795 -20,442,795 -20,940,945 -21,451,548 -21,974,917 -22,511,370 -23,061,235 -23,624,846

VAN (5%) -3,257,021,553

Ingresos Totales

Costos Operacin y Mantencin

Costos Compra Materiales para fabricacin de piezas

Gastos Financieros (Prstamos)

Utilidad antes de impuestos

Utilidad despus de impuestos

Prstamos o Crdito

Amortizacin del Crdito

Tiempo (meses)

9 10 11 12 13 14 15 16 17 18 19 20 21

0 0 -24,794,691 -49,585,649 -74,994,167 -101,035,724 -127,726,187 -155,081,823 -183,142,854 -211,884,207 -241,342,090 -271,534,463 -302,479,731

0 0 -24,794,691 -49,585,649 -74,994,167 -101,035,724 -127,726,187 -155,081,823 -183,142,854 -211,884,207 -241,342,090 -271,534,463 -302,479,731

0 0 0 0 0 0 0 0 0 0 0 0 0

-24,251,888 -24,839,612 -25,116,514 -25,734,073 -26,367,112 -27,016,019 -27,681,191 -28,386,587 -29,066,908 -29,783,439 -30,517,928 -31,270,824 -32,037,326

23,771,752 24,363,896 24,970,844 25,592,965 26,230,639 26,884,255 27,554,211 28,240,916 28,944,789 29,666,259 30,405,765 31,163,760 31,940,704

0 0

325,556 325,556 0 0 0 0 0 0 0 0 0 0 0

154,580 150,161 145,671 141,109 136,474 131,764 126,980 145,671 122,119 117,180 112,162 107,064 96,622

-24,251,888 -24,839,612 -49,911,205 -75,319,722 -101,361,279 -128,051,743 -155,407,378 -183,468,410 -212,209,762 -241,667,646 -271,860,018 -302,805,286 -334,517,056

0 0

-24,251,888 -24,839,612 -49,911,205 -75,319,722 -101,361,279 -128,051,743 -155,407,378 -183,468,410 -212,209,762 -241,667,646 -271,860,018 -302,805,286 -334,517,056

325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556

-276,214 -280,634

-24,202,547 -24,794,691 -49,585,649 -74,994,167 -101,035,724 -127,726,187 -155,081,823 -183,142,854 -211,884,207 -241,342,090 -271,534,463 -302,479,731 -334,191,501

Tiempo (meses)

22 23 24 25 26 27 28 29 30 31 32 33

-334,191,501 -366,694,292 -400,007,927 -434,152,727 -469,149,520 -505,019,656 -541,785,021 -579,468,047 -618,091,729 -657,679,637 -698,255,931 -739,845,376

-334,191,501 -366,694,292 -400,007,927 -434,152,727 -469,149,520 -505,019,656 -541,785,021 -579,468,047 -618,091,729 -657,679,637 -698,255,931 -739,845,376

0 0 0 0 0 0 0 0 0 0 0 0

-32,828,346 -33,639,191 -34,470,355 -35,322,349 -36,195,692 -37,090,921 -38,008,582 -38,949,237 -39,913,463 -40,901,849 -41,915,001 -42,953,537

32,737,071 33,553,348 34,390,032 35,247,632 36,126,673 37,027,690 37,951,232 38,897,863 39,868,160 40,862,714 41,882,132 42,927,035

0 0 0 0 0 0 0 0 0 0 0 0

91,275 85,843 80,324 74,716 69,019 63,230 57,349 51,374 45,304 39,136 32,869 26,502

-367,019,847 -400,333,482 -434,478,282 -469,475,075 -505,345,212 -542,110,577 -579,793,603 -618,417,285 -658,005,193 -698,581,486 -740,170,932 -782,798,913

-367,019,847 -400,333,482 -434,478,282 -469,475,075 -505,345,212 -542,110,577 -579,793,603 -618,417,285 -658,005,193 -698,581,486 -740,170,932 -782,798,913

325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556 325,556

-366,694,292 -400,007,927 -434,152,727 -469,149,520 -505,019,656 -541,785,021 -579,468,047 -618,091,729 -657,679,637 -698,255,931 -739,845,376 -782,473,358

Tiempo (meses)

34 35 36

-782,473,358 -826,165,897 -870,949,665

-782,473,358 -826,165,897 -870,949,665

0 0 0

-44,018,094 -45,109,324 -46,227,893

43,998,061 45,095,862 46,221,109

0 0 0

20,034 13,461 6,784

-826,491,452 -871,275,220 -917,177,558

-826,491,452 -871,275,220 -917,177,558

325,556 325,556 325,556

-826,165,897 -870,949,665 -916,852,002

Gasto FinancieroInversin inicialIngreso MensualCostos Op y Mant MensualFlujo caja financiado 36 Meses