Curso:
Matematicas Financiera
 
Presenta:
Martínez Henao Dany Marcela ID 571347
Rendón Benavides Andrés David ID 774103
Vivas Varón Johana Andrea ID 784368
 
 
Actividad 6
Estudio de caso sobre alternativas de financiación
Tutor:
Doris Amparo Portilla Pabon
NRC 9343
 
 
Corporación Universitaria Minuto de Dios
Bogotá, D.C.
Agosto de 2021
 AMORTIZACION Y CAPITALIZACION

El préstamo es una operación financiera en la que el Banco entrega al cliente un importe y este se compromete a devolverlo en
uno o varios pagos. Los préstamos suelen ser operaciones a largo plazo.
Conceptos de manejo:
* Cuota periodica
* Interes periodico
* Capital Inicial
* Saldo de la operación
* Capital amortizado

Tablas de amortización
Es la representación gráfica de la manera como se comporta una obligación financiera a medida que se cancela el capital e intereses
Es una herramienta importante para determinar el saldo de la obligación a la altura de las diferentes cuotas pagadas.

Existen dos formas de amortización: La primera con cuota uniforme y la segunda con cuota gradual.

Distribución de un pago.
La distribución de los pagos incluye la amortización del capital y de los intereses. Se hace en primer lugar la distribución a los
intereses de mora, después a los intereses corrientes y por último al capital, Esta es la razón por la cual cuando se entra en
mora, el valor del saldo de la deuda se incrementa.

Sin embargo no es necesario construir la tabla de amortización para establecer la proporción en que una cuota dada se divide en
interes y capital, basta con calcularse los intereses al saldo del capital del periodo inmediatamente anterior y luego restarselo
al valor de la cuota.

Clases de Amortización
a) Préstamo con cuota de amortización constante
b) Préstamo con devolución de principal constante ó cuota gradual
c) Préstamo con una sola devolución de principal al vencimiento
e) Préstamo con intereses anticipados.

Funciones de Excel
PAGO Cuota
PAGOINT Interes
PAGOPRIN Abono a Capital
a) Amortización con cuota fija-Metodo Frances

Se caracteriza porque a lo largo de la oblicación la cuota siempre es la misma. Cuando se utiliza este sistema, en la medida en que
cancelamos más cuotas, el valor de los intereses pagados disminuyen y el valor de la amortizacion del capital aumenta.

Ejercicio: La señora Maria Claudia Pinilla adquirio un credito de libre inversión por $250.000.000, durante 7 años, con una tasa de interés

del 10,9 % EA La prestaria tiene varias alternativas de financiación de ofrece su entidad financiera con respecto a la forma de amortizar a ña deuda .
Para ayudarle a encontrar la mejor opción. Construya las tablas de amortización y calcule mensuales, los intereses y los abonos a caítal correspondiente.

Ejemplo formulas P= A 1-(1+i)^-n / i

Monto del préstamo 250,000,000 A = P *i /(1-(1+i)^(-n))
Plazo (años) 84
Tasa de interes 10.90% mensual

Tabla de amortización

Valor cuota $ 27,254,583 $ 27,254,583 Interes: Saldo anterior por la tasa

Amortizacion Cuota-interes
PER CUOTA INTERES AMORTIZACION SALDO Saldo Saldo anterior -Amortizacion
0 250,000,000
1 27,254,583.42 27,250,000.00 4,583 249,995,416.58
2 27,254,583.42 27,249,500.41 5,083 249,990,333.57
3 27,254,583.42 27,248,946.36 5,637 249,984,696.51
4 27,254,583.42 27,248,331.92 6,252 249,978,445.00
5 27,254,583.42 27,247,650.51 6,933 249,971,512.09
6 27,254,583.42 27,246,894.82 7,689 249,963,823.49
7 27,254,583.42 27,246,056.76 8,527 249,955,296.83
8 27,254,583.42 27,245,127.35 9,456 249,945,840.76 7
9 27,254,583.42 27,244,096.64 10,487 249,935,353.98
10 27,254,583.42 27,242,953.58 11,630 249,923,724.15
11 27,254,583.42 27,241,685.93 12,897 249,910,826.66
12 27,254,583.42 27,240,280.11 14,303 249,896,523.35
13 27,254,583.42 27,238,721.04 15,862 249,880,660.97
14 27,254,583.42 27,236,992.05 17,591 249,863,069.60
15 27,254,583.42 27,235,074.59 19,509 249,843,560.76
16 27,254,583.42 27,232,948.12 21,635 249,821,925.46
17 27,254,583.42 27,230,589.88 23,994 249,797,931.92
18 27,254,583.42 27,227,974.58 26,609 249,771,323.08
19 27,254,583.42 27,225,074.22 29,509 249,741,813.87
20 27,254,583.42 27,221,857.71 32,726 249,709,088.17
21 27,254,583.42 27,218,290.61 36,293 249,672,795.36
22 27,254,583.42 27,214,334.69 40,249 249,632,546.63
23 27,254,583.42 27,209,947.58 44,636 249,587,910.79
24 27,254,583.42 27,205,082.28 49,501 249,538,409.65
25 27,254,583.42 27,199,686.65 54,897 249,483,512.88
26 27,254,583.42 27,193,702.90 60,881 249,422,632.37
27 27,254,583.42 27,187,066.93 67,516 249,355,115.87
28 27,254,583.42 27,179,707.63 74,876 249,280,240.08
29 27,254,583.42 27,171,546.17 83,037 249,197,202.83
30 27,254,583.42 27,162,495.11 92,088 249,105,114.52
31 27,254,583.42 27,152,457.48 102,126 249,002,988.58
32 27,254,583.42 27,141,325.76 113,258 248,889,730.92
33 27,254,583.42 27,128,980.67 125,603 248,764,128.17
34 27,254,583.42 27,115,289.97 139,293 248,624,834.72
35 27,254,583.42 27,100,106.98 154,476 248,470,358.28
36 27,254,583.42 27,083,269.05 171,314 248,299,043.91
37 27,254,583.42 27,064,595.79 189,988 248,109,056.28
38 27,254,583.42 27,043,887.13 210,696 247,898,360.00
39 27,254,583.42 27,020,921.24 233,662 247,664,697.81
40 27,254,583.42 26,995,452.06 259,131 247,405,566.46
41 27,254,583.42 26,967,206.74 287,377 247,118,189.78
42 27,254,583.42 26,935,882.69 318,701 246,799,489.05
43 27,254,583.42 26,901,144.31 353,439 246,446,049.93
44 27,254,583.42 26,862,619.44 391,964 246,054,085.95
45 27,254,583.42 26,819,895.37 434,688 245,619,397.90
46 27,254,583.42 26,772,514.37 482,069 245,137,328.85
47 27,254,583.42 26,719,968.85 534,615 244,602,714.28
48 27,254,583.42 26,661,695.86 592,888 244,009,826.72
49 27,254,583.42 26,597,071.11 657,512 243,352,314.41
50 27,254,583.42 26,525,402.27 729,181 242,623,133.26
51 27,254,583.42 26,445,921.53 808,662 241,814,471.36
52 27,254,583.42 26,357,777.38 896,806 240,917,665.32
53 27,254,583.42 26,260,025.52 994,558 239,923,107.42
54 27,254,583.42 26,151,618.71 1,102,965 238,820,142.71
55 27,254,583.42 26,031,395.56 1,223,188 237,596,954.84
56 27,254,583.42 25,898,068.08 1,356,515 236,240,439.50
57 27,254,583.42 25,750,207.91 1,504,376 234,736,063.99
58 27,254,583.42 25,586,230.97 1,668,352 233,067,711.54
59 27,254,583.42 25,404,380.56 1,850,203 231,217,508.68
60 27,254,583.42 25,202,708.45 2,051,875 229,165,633.71
61 27,254,583.42 24,979,054.07 2,275,529 226,890,104.36
62 27,254,583.42 24,731,021.38 2,523,562 224,366,542.31
63 27,254,583.42 24,455,953.11 2,798,630 221,567,912.01
64 27,254,583.42 24,150,902.41 3,103,681 218,464,230.99
65 27,254,583.42 23,812,601.18 3,441,982 215,022,248.75
66 27,254,583.42 23,437,425.11 3,817,158 211,205,090.45
67 27,254,583.42 23,021,354.86 4,233,229 206,971,861.88
68 27,254,583.42 22,559,932.95 4,694,650 202,277,211.41
69 27,254,583.42 22,048,216.04 5,206,367 197,070,844.03
70 27,254,583.42 21,480,722.00 5,773,861 191,296,982.61
71 27,254,583.42 20,851,371.10 6,403,212 184,893,770.30
72 27,254,583.42 20,153,420.96 7,101,162 177,792,607.84
73 27,254,583.42 19,379,394.25 7,875,189 169,917,418.67
74 27,254,583.42 18,520,998.64 8,733,585 161,183,833.89
75 27,254,583.42 17,569,037.89 9,685,546 151,498,288.36
76 27,254,583.42 16,513,313.43 10,741,270 140,757,018.38
77 27,254,583.42 15,342,515.00 11,912,068 128,844,949.96
78 27,254,583.42 14,044,099.55 13,210,484 115,634,466.08
79 27,254,583.42 12,604,156.80 14,650,427 100,984,039.47
80 27,254,583.42 11,007,260.30 16,247,323 84,736,716.35
81 27,254,583.42 9,236,302.08 18,018,281 66,718,435.01
82 27,254,583.42 7,272,309.42 19,982,274 46,736,161.01
83 27,254,583.42 5,094,241.55 22,160,342 24,575,819.13
84 27,254,583.42 2,678,764.29 24,575,819 -0.00
b) Abono constante a capital

El valor de la cuota es descendente, porque los intereses se cancelan sobre los saldo. Al inicio del crédito los intereses son mayores
miestras que la amortización de capital es la misma.

En este tipo de préstamo se calcula fácilmente el importe de la amortización de capital constante, basta con dividir el importe del
préstamo por el número de periodos.

AMs = Co / n (Siendo "Co" el importe del préstamo y "n" el número de periodos)

Una vez conocido el importe de la amortización constante de capital, se puede conocer como evoluciona el saldo vivo del préstamo,
así como el capital amortizado.

Ejercicio: La señora Maria Claudia Pinilla adquirio un credito de libre inversión por $250.000.000, durante 7 años, con una tasa de interés
del 10,9 % EA La prestaria tiene varias alternativas de financiación de ofrece su entidad financiera con respecto a la forma de amortizar a ña deuda .
Para ayudarle a encontrar la mejor opción. Construya las tablas de amortización y calcule mensuales, los intereses y los abonos a caítal correspondiente.

Ejemplo
Monto del préstamo 250,000,000
Plazo (años) 84
Tasa de interes 10.90%

Tabla de amortización

Valor Amortizaciones 2,976,190.48 Interes: saldo * tasa

A. Con intereses vencidos

PER CUOTA INTERES AMORTIZACION SALDO

0 250,000,000
1 30,226,190 27,250,000 2,976,190 247,023,810
2 29,901,786 26,925,595 2,976,190 244,047,619
3 29,577,381 26,601,190 2,976,190 241,071,429
4 29,252,976 26,276,786 2,976,190 238,095,238
5 28,928,571 25,952,381 2,976,190 235,119,048
6 28,604,167 25,627,976 2,976,190 232,142,857
7 28,279,762 25,303,571 2,976,190 229,166,667
8 27,955,357 24,979,167 2,976,190 226,190,476
9 27,630,952 24,654,762 2,976,190 223,214,286
10 27,306,548 24,330,357 2,976,190 220,238,095
11 26,982,143 24,005,952 2,976,190 217,261,905
12 26,657,738 23,681,548 2,976,190 214,285,714
13 26,333,333 23,357,143 2,976,190 211,309,524
14 26,008,929 23,032,738 2,976,190 208,333,333
15 25,684,524 22,708,333 2,976,190 205,357,143
16 25,360,119 22,383,929 2,976,190 202,380,952
17 25,035,714 22,059,524 2,976,190 199,404,762
18 24,711,310 21,735,119 2,976,190 196,428,571
19 24,386,905 21,410,714 2,976,190 193,452,381
20 24,062,500 21,086,310 2,976,190 190,476,190
21 23,738,095 20,761,905 2,976,190 187,500,000
22 23,413,690 20,437,500 2,976,190 184,523,810
23 23,089,286 20,113,095 2,976,190 181,547,619
24 22,764,881 19,788,690 2,976,190 178,571,429
25 22,440,476 19,464,286 2,976,190 175,595,238
26 22,116,071 19,139,881 2,976,190 172,619,048
27 21,791,667 18,815,476 2,976,190 169,642,857
28 21,467,262 18,491,071 2,976,190 166,666,667
29 21,142,857 18,166,667 2,976,190 163,690,476
30 20,818,452 17,842,262 2,976,190 160,714,286
31 20,494,048 17,517,857 2,976,190 157,738,095
32 20,169,643 17,193,452 2,976,190 154,761,905
33 19,845,238 16,869,048 2,976,190 151,785,714
34 19,520,833 16,544,643 2,976,190 148,809,524
35 19,196,429 16,220,238 2,976,190 145,833,333
36 18,872,024 15,895,833 2,976,190 142,857,143
37 18,547,619 15,571,429 2,976,190 139,880,952
38 18,223,214 15,247,024 2,976,190 136,904,762
39 17,898,810 14,922,619 2,976,190 133,928,571
40 17,574,405 14,598,214 2,976,190 130,952,381
41 17,250,000 14,273,810 2,976,190 127,976,190
42 16,925,595 13,949,405 2,976,190 125,000,000
43 16,601,190 13,625,000 2,976,190 122,023,810
44 16,276,786 13,300,595 2,976,190 119,047,619
45 15,952,381 12,976,190 2,976,190 116,071,429
46 15,627,976 12,651,786 2,976,190 113,095,238
47 15,303,571 12,327,381 2,976,190 110,119,048
48 14,979,167 12,002,976 2,976,190 107,142,857
49 14,654,762 11,678,571 2,976,190 104,166,667
50 14,330,357 11,354,167 2,976,190 101,190,476
51 14,005,952 11,029,762 2,976,190 98,214,286
52 13,681,548 10,705,357 2,976,190 95,238,095
53 13,357,143 10,380,952 2,976,190 92,261,905
54 13,032,738 10,056,548 2,976,190 89,285,714
55 12,708,333 9,732,143 2,976,190 86,309,524
56 12,383,929 9,407,738 2,976,190 83,333,333
57 12,059,524 9,083,333 2,976,190 80,357,143
58 11,735,119 8,758,929 2,976,190 77,380,952
59 11,410,714 8,434,524 2,976,190 74,404,762
60 11,086,310 8,110,119 2,976,190 71,428,571
61 10,761,905 7,785,714 2,976,190 68,452,381
62 10,437,500 7,461,310 2,976,190 65,476,190
63 10,113,095 7,136,905 2,976,190 62,500,000
64 9,788,690 6,812,500 2,976,190 59,523,810
65 9,464,286 6,488,095 2,976,190 56,547,619
66 9,139,881 6,163,690 2,976,190 53,571,429
67 8,815,476 5,839,286 2,976,190 50,595,238
68 8,491,071 5,514,881 2,976,190 47,619,048
69 8,166,667 5,190,476 2,976,190 44,642,857
70 7,842,262 4,866,071 2,976,190 41,666,667
71 7,517,857 4,541,667 2,976,190 38,690,476
72 7,193,452 4,217,262 2,976,190 35,714,286
73 6,869,048 3,892,857 2,976,190 32,738,095
74 6,544,643 3,568,452 2,976,190 29,761,905
75 6,220,238 3,244,048 2,976,190 26,785,714
76 5,895,833 2,919,643 2,976,190 23,809,524
77 5,571,429 2,595,238 2,976,190 20,833,333
78 5,247,024 2,270,833 2,976,190 17,857,143
79 4,922,619 1,946,429 2,976,190 14,880,952
80 4,598,214 1,622,024 2,976,190 11,904,762
81 4,273,810 1,297,619 2,976,190 8,928,571
82 3,949,405 973,214 2,976,190 5,952,381
83 3,625,000 648,810 2,976,190 2,976,190
84 3,300,595 324,405 2,976,190 -0

Intereses

Amortización Ejemplo
Monto del préstamo 250,000,000
Plazo (años) 84
B. Con intereses anticipados Tasa de interes 10.90%
Amortizacion 2,976,190 fijar
PER CUOTA INTERES-fijar AMORTIZACION SALDO
0 250,000,000
1 30,226,190 27,250,000 2,976,190 247,023,810
2 29,901,786 26,925,595 2,976,190 244,047,619
3 29,577,381 26,601,190 2,976,190 241,071,429
4 29,252,976 26,276,786 2,976,190 238,095,238
5 28,928,571 25,952,381 2,976,190 235,119,048
6 28,604,167 25,627,976 2,976,190 232,142,857
7 28,279,762 25,303,571 2,976,190 229,166,667
8 27,955,357 24,979,167 2,976,190 226,190,476
9 27,630,952 24,654,762 2,976,190 223,214,286
10 27,306,548 24,330,357 2,976,190 220,238,095
11 26,982,143 24,005,952 2,976,190 217,261,905
12 26,657,738 23,681,548 2,976,190 214,285,714
13 26,333,333 23,357,143 2,976,190 211,309,524
14 26,008,929 23,032,738 2,976,190 208,333,333
15 25,684,524 22,708,333 2,976,190 205,357,143
16 25,360,119 22,383,929 2,976,190 202,380,952
17 25,035,714 22,059,524 2,976,190 199,404,762
18 24,711,310 21,735,119 2,976,190 196,428,571
19 24,386,905 21,410,714 2,976,190 193,452,381
20 24,062,500 21,086,310 2,976,190 190,476,190
21 23,738,095 20,761,905 2,976,190 187,500,000
22 23,413,690 20,437,500 2,976,190 184,523,810
23 23,089,286 20,113,095 2,976,190 181,547,619
24 22,764,881 19,788,690 2,976,190 178,571,429
25 22,440,476 19,464,286 2,976,190 175,595,238
26 22,116,071 19,139,881 2,976,190 172,619,048
27 21,791,667 18,815,476 2,976,190 169,642,857
28 21,467,262 18,491,071 2,976,190 166,666,667
29 21,142,857 18,166,667 2,976,190 163,690,476
30 20,818,452 17,842,262 2,976,190 160,714,286
31 20,494,048 17,517,857 2,976,190 157,738,095
32 20,169,643 17,193,452 2,976,190 154,761,905
33 19,845,238 16,869,048 2,976,190 151,785,714
34 19,520,833 16,544,643 2,976,190 148,809,524
35 19,196,429 16,220,238 2,976,190 145,833,333
36 18,872,024 15,895,833 2,976,190 142,857,143
37 18,547,619 15,571,429 2,976,190 139,880,952
38 18,223,214 15,247,024 2,976,190 136,904,762
39 17,898,810 14,922,619 2,976,190 133,928,571
40 17,574,405 14,598,214 2,976,190 130,952,381
41 17,250,000 14,273,810 2,976,190 127,976,190
42 16,925,595 13,949,405 2,976,190 125,000,000
43 16,601,190 13,625,000 2,976,190 122,023,810
44 16,276,786 13,300,595 2,976,190 119,047,619
45 15,952,381 12,976,190 2,976,190 116,071,429
46 15,627,976 12,651,786 2,976,190 113,095,238
47 15,303,571 12,327,381 2,976,190 110,119,048
48 14,979,167 12,002,976 2,976,190 107,142,857
49 14,654,762 11,678,571 2,976,190 104,166,667
50 14,330,357 11,354,167 2,976,190 101,190,476
51 14,005,952 11,029,762 2,976,190 98,214,286
52 13,681,548 10,705,357 2,976,190 95,238,095
53 13,357,143 10,380,952 2,976,190 92,261,905
54 13,032,738 10,056,548 2,976,190 89,285,714
55 12,708,333 9,732,143 2,976,190 86,309,524
56 12,383,929 9,407,738 2,976,190 83,333,333
57 12,059,524 9,083,333 2,976,190 80,357,143
58 11,735,119 8,758,929 2,976,190 77,380,952
59 11,410,714 8,434,524 2,976,190 74,404,762
60 11,086,310 8,110,119 2,976,190 71,428,571
61 10,761,905 7,785,714 2,976,190 68,452,381
62 10,437,500 7,461,310 2,976,190 65,476,190
63 10,113,095 7,136,905 2,976,190 62,500,000
64 9,788,690 6,812,500 2,976,190 59,523,810
65 9,464,286 6,488,095 2,976,190 56,547,619
66 9,139,881 6,163,690 2,976,190 53,571,429
67 8,815,476 5,839,286 2,976,190 50,595,238
68 8,491,071 5,514,881 2,976,190 47,619,048
69 8,166,667 5,190,476 2,976,190 44,642,857
70 7,842,262 4,866,071 2,976,190 41,666,667
71 7,517,857 4,541,667 2,976,190 38,690,476
72 7,193,452 4,217,262 2,976,190 35,714,286
73 6,869,048 3,892,857 2,976,190 32,738,095
74 6,544,643 3,568,452 2,976,190 29,761,905
75 6,220,238 3,244,048 2,976,190 26,785,714
76 5,895,833 2,919,643 2,976,190 23,809,524
77 5,571,429 2,595,238 2,976,190 20,833,333
78 5,247,024 2,270,833 2,976,190 17,857,143
79 4,922,619 1,946,429 2,976,190 14,880,952
80 4,598,214 1,622,024 2,976,190 11,904,762
81 4,273,810 1,297,619 2,976,190 8,928,571
82 3,949,405 973,214 2,976,190 5,952,381
83 3,625,000 648,810 2,976,190 2,976,190
84 3,300,595 324,405 2,976,190 -0

NOTA: Se escoge esta opción como recomendación para la señora Patricia, porque es la mas rentable ya que al abonar a capital paga menos
intereses en el mismo periodo de tiempo que las otras opciones.
 AMORTIZACION CON PERIODO DE GRACIA

El periodo de gracia consiste en que luego de desembolsado el préstamo, va ha pasar cierto tiempo antesde que se empiece a
efectuar el pago, existen dos modalidades:

1. Periodo de gracia muerto

Durante cierto tiempo, no hay pagos de ninguna clase, sin embargo, se causan unos intereses los que se van acumulando a la
deuda, es decir, que durante el periodo de gracia muerto la deuda se incrementa.

2. Periodo de gracia con cuota reducida

Durante cierto tiempo se pagan unas cuotas reducidas equivalentes al valor de los intereses que se causan, pero sin hacer
amortización de capital, en consecuencia, la deuda permanece constante, porque en la medida que se van causando los intereses
se van pagando.

Ejercicio: La señora Maria Claudia Pinilla adquirio un credito de libre inversión por $250.000.000, durante 7 años, con una tasa de interés
del 10,9 % EA La prestaria tiene varias alternativas de financiación de ofrece su entidad financiera con respecto a la forma de amortizar a ña deuda .
Para ayudarle a encontrar la mejor opción. Construya las tablas de amortización y calcule mensuales, los intereses y los abonos a caítal correspondiente.

a. Periodo de gracia muerto. Prestamo 250,000,000.00

Tasa 10.9%
Periodos 84
Cuota $ 27,260,489.05
PER CUOTA INTERES AMORTIZACION SALDO
0 250,000,000.00
1 $ 27,260,489 27,260,489.00 - 250,000,000.00
2 $ 27,260,489 27,260,489.00 - 250,000,000.00
3 $ 27,260,489 27,260,489.00 - 250,000,000.00
4 $ 27,260,489 27,260,489.00 - 250,000,000.00
5 $ 27,250,000 27,250,000.00 - 250,000,000.00
6 $ 27,250,000 27,250,000.00 - 250,000,000.00
7 $ 27,250,000 27,250,000.00 - 250,000,000.00
8 $ 27,250,000 27,250,000.00 - 250,000,000.00
9 $ 27,260,489 27,250,000.00 10,489.05 249,989,510.95
10 $ 27,260,489 27,248,856.69 11,632.36 249,977,878.59
11 $ 27,260,489 27,247,588.77 12,900.28 249,964,978.31
12 $ 27,260,489 27,246,182.64 14,306.41 249,950,671.90
13 $ 27,260,489 27,244,623.24 15,865.81 249,934,806.09
14 $ 27,260,489 27,242,893.86 17,595.19 249,917,210.90
15 $ 27,260,489 27,240,975.99 19,513.06 249,897,697.84
16 $ 27,260,489 27,238,849.06 21,639.99 249,876,057.85
17 $ 27,260,489 27,236,490.31 23,998.74 249,852,059.11
18 $ 27,260,489 27,233,874.44 26,614.61 249,825,444.50
19 $ 27,260,489 27,230,973.45 29,515.60 249,795,928.90
20 $ 27,260,489 27,227,756.25 32,732.80 249,763,196.11
21 $ 27,260,489 27,224,188.38 36,300.67 249,726,895.43
22 $ 27,260,489 27,220,231.60 40,257.45 249,686,637.98
23 $ 27,260,489 27,215,843.54 44,645.51 249,641,992.47
24 $ 27,260,489 27,210,977.18 49,511.87 249,592,480.60
25 $ 27,260,489 27,205,580.39 54,908.66 249,537,571.94
26 $ 27,260,489 27,199,595.34 60,893.71 249,476,678.23
27 $ 27,260,489 27,192,957.93 67,531.12 249,409,147.11
28 $ 27,260,489 27,185,597.04 74,892.01 249,334,255.10
29 $ 27,260,489 27,177,433.81 83,055.24 249,251,199.85
30 $ 27,260,489 27,168,380.78 92,108.27 249,159,091.59
31 $ 27,260,489 27,158,340.98 102,148.07 249,056,943.52
32 $ 27,260,489 27,147,206.84 113,282.21 248,943,661.31
33 $ 27,260,489 27,134,859.08 125,629.97 248,818,031.35
34 $ 27,260,489 27,121,165.42 139,323.63 248,678,707.72
35 $ 27,260,489 27,105,979.14 154,509.91 248,524,197.81
36 $ 27,260,489 27,089,137.56 171,351.49 248,352,846.32
37 $ 27,260,489 27,070,460.25 190,028.80 248,162,817.52
38 $ 27,260,489 27,049,747.11 210,741.94 247,952,075.58
39 $ 27,260,489 27,026,776.24 233,712.81 247,718,362.77
40 $ 27,260,489 27,001,301.54 259,187.51 247,459,175.26
41 $ 27,260,489 26,973,050.10 287,438.95 247,171,736.31
42 $ 27,260,489 26,941,719.26 318,769.79 246,852,966.52
43 $ 27,260,489 26,906,973.35 353,515.70 246,499,450.82
44 $ 27,260,489 26,868,440.14 392,048.91 246,107,401.91
45 $ 27,260,489 26,825,706.81 434,782.24 245,672,619.67
46 $ 27,260,489 26,778,315.54 482,173.51 245,190,446.17
47 $ 27,260,489 26,725,758.63 534,730.42 244,655,715.75
48 $ 27,260,489 26,667,473.02 593,016.03 244,062,699.72
49 $ 27,260,489 26,602,834.27 657,654.78 243,405,044.93
50 $ 27,260,489 26,531,149.90 729,339.15 242,675,705.78
51 $ 27,260,489 26,451,651.93 808,837.12 241,866,868.66
52 $ 27,260,489 26,363,488.68 897,000.37 240,969,868.30
53 $ 27,260,489 26,265,715.64 994,773.40 239,975,094.89
54 $ 27,260,489 26,157,285.34 1,103,203.71 238,871,891.19
55 $ 27,260,489 26,037,036.14 1,223,452.91 237,648,438.28
56 $ 27,260,489 25,903,679.77 1,356,809.28 236,291,629.00
57 $ 27,260,489 25,755,787.56 1,504,701.49 234,786,927.51
58 $ 27,260,489 25,591,775.10 1,668,713.95 233,118,213.56
59 $ 27,260,489 25,409,885.28 1,850,603.77 231,267,609.79
60 $ 27,260,489 25,208,169.47 2,052,319.58 229,215,290.21
61 $ 27,260,489 24,984,466.63 2,276,022.42 226,939,267.79
62 $ 27,260,489 24,736,380.19 2,524,108.86 224,415,158.93
63 $ 27,260,489 24,461,252.32 2,799,236.73 221,615,922.20
64 $ 27,260,489 24,156,135.52 3,104,353.53 218,511,568.68
65 $ 27,260,489 23,817,760.99 3,442,728.06 215,068,840.61
66 $ 27,260,489 23,442,503.63 3,817,985.42 211,250,855.19
67 $ 27,260,489 23,026,343.22 4,234,145.83 207,016,709.35
68 $ 27,260,489 22,564,821.32 4,695,667.73 202,321,041.62
69 $ 27,260,489 22,052,993.54 5,207,495.51 197,113,546.11
70 $ 27,260,489 21,485,376.53 5,775,112.52 191,338,433.59
71 $ 27,260,489 20,855,889.26 6,404,599.79 184,933,833.80
72 $ 27,260,489 20,157,787.88 7,102,701.17 177,831,132.64
73 $ 27,260,489 19,383,593.46 7,876,895.59 169,954,237.04
74 $ 27,260,489 18,525,011.84 8,735,477.21 161,218,759.83
75 $ 27,260,489 17,572,844.82 9,687,644.23 151,531,115.60
76 $ 27,260,489 16,516,891.60 10,743,597.45 140,787,518.15
77 $ 27,260,489 15,345,839.48 11,914,649.57 128,872,868.58
78 $ 27,260,489 14,047,142.68 13,213,346.37 115,659,522.21
79 $ 27,260,489 12,606,887.92 14,653,601.13 101,005,921.08
80 $ 27,260,489 11,009,645.40 16,250,843.65 84,755,077.43
81 $ 27,260,489 9,238,303.44 18,022,185.61 66,732,891.82
82 $ 27,260,489 7,273,885.21 19,986,603.84 46,746,287.98
83 $ 27,260,489 5,095,345.39 22,165,143.66 24,581,144.32
84 $ 27,260,489 2,679,344.73 24,581,144.32 -0.00

2,289,839,123.76 2,039,839,123.76 250,000,000.00

a. Periodo de gracia con cuota reducida

Prestamo 250,000,000
Tasa 10.9%
Periodos 84
Valor cuota $ 27,260,489.05
PER CUOTA INTERES AMORTIZACION SALDO
0 250,000,000
1 27,250,000 27,250,000 - 250,000,000
2 27,250,000 27,250,000 - 250,000,000
3 27,250,000 27,250,000 - 250,000,000
4 27,250,000 27,250,000 - 250,000,000
5 27,260,489 27,250,000 - 250,000,000
6 27,260,489 27,250,000 - 250,000,000
7 27,260,489 27,250,000 - 250,000,000
8 27,260,489 27,250,000 - 250,000,000
9 27,260,489 27,250,000 10,489 249,989,511
10 27,260,489 27,248,857 11,632 249,977,879
11 27,260,489 27,247,589 12,900 249,964,978
12 27,260,489 27,246,183 14,306 249,950,672
13 27,260,489 27,244,623 15,866 249,934,806
14 27,260,489 27,242,894 17,595 249,917,211
15 27,260,489 27,240,976 19,513 249,897,698
16 27,260,489 27,238,849 21,640 249,876,058
17 27,260,489 27,236,490 23,999 249,852,059
18 27,260,489 27,233,874 26,615 249,825,445
19 27,260,489 27,230,973 29,516 249,795,929
20 27,260,489 27,227,756 32,733 249,763,196
21 27,260,489 27,224,188 36,301 249,726,895
22 27,260,489 27,220,232 40,257 249,686,638
23 27,260,489 27,215,844 44,646 249,641,992
24 27,260,489 27,210,977 49,512 249,592,481
25 27,260,489 27,205,580 54,909 249,537,572
26 27,260,489 27,199,595 60,894 249,476,678
27 27,260,489 27,192,958 67,531 249,409,147
28 27,260,489 27,185,597 74,892 249,334,255
29 27,260,489 27,177,434 83,055 249,251,200
30 27,260,489 27,168,381 92,108 249,159,092
31 27,260,489 27,158,341 102,148 249,056,944
32 27,260,489 27,147,207 113,282 248,943,661
33 27,260,489 27,134,859 125,630 248,818,031
34 27,260,489 27,121,165 139,324 248,678,708
35 27,260,489 27,105,979 154,510 248,524,198
36 27,260,489 27,089,138 171,351 248,352,846
37 27,260,489 27,070,460 190,029 248,162,818
38 27,260,489 27,049,747 210,742 247,952,076
39 27,260,489 27,026,776 233,713 247,718,363
40 27,260,489 27,001,302 259,188 247,459,175
41 27,260,489 26,973,050 287,439 247,171,736
42 27,260,489 26,941,719 318,770 246,852,967
43 27,260,489 26,906,973 353,516 246,499,451
44 27,260,489 26,868,440 392,049 246,107,402
45 27,260,489 26,825,707 434,782 245,672,620
46 27,260,489 26,778,316 482,174 245,190,446
47 27,260,489 26,725,759 534,730 244,655,716
48 27,260,489 26,667,473 593,016 244,062,700
49 27,260,489 26,602,834 657,655 243,405,045
50 27,260,489 26,531,150 729,339 242,675,706
51 27,260,489 26,451,652 808,837 241,866,869
52 27,260,489 26,363,489 897,000 240,969,868
53 27,260,489 26,265,716 994,773 239,975,095
54 27,260,489 26,157,285 1,103,204 238,871,891
55 27,260,489 26,037,036 1,223,453 237,648,438
56 27,260,489 25,903,680 1,356,809 236,291,629
57 27,260,489 25,755,788 1,504,701 234,786,928
58 27,260,489 25,591,775 1,668,714 233,118,214
59 27,260,489 25,409,885 1,850,604 231,267,610
60 27,260,489 25,208,169 2,052,320 229,215,290
61 27,260,489 24,984,467 2,276,022 226,939,268
62 27,260,489 24,736,380 2,524,109 224,415,159
63 27,260,489 24,461,252 2,799,237 221,615,922
64 27,260,489 24,156,136 3,104,354 218,511,569
65 27,260,489 23,817,761 3,442,728 215,068,841
66 27,260,489 23,442,504 3,817,985 211,250,855
67 27,260,489 23,026,343 4,234,146 207,016,709
68 27,260,489 22,564,821 4,695,668 202,321,042
69 27,260,489 22,052,994 5,207,496 197,113,546
70 27,260,489 21,485,377 5,775,113 191,338,434
71 27,260,489 20,855,889 6,404,600 184,933,834
72 27,260,489 20,157,788 7,102,701 177,831,133
73 27,260,489 19,383,593 7,876,896 169,954,237
74 27,260,489 18,525,012 8,735,477 161,218,760
75 27,260,489 17,572,845 9,687,644 151,531,116
76 27,260,489 16,516,892 10,743,597 140,787,518
77 27,260,489 15,345,839 11,914,650 128,872,869
78 27,260,489 14,047,143 13,213,346 115,659,522
79 27,260,489 12,606,888 14,653,601 101,005,921
80 27,260,489 11,009,645 16,250,844 84,755,077
81 27,260,489 9,238,303 18,022,186 66,732,892
82 27,260,489 7,273,885 19,986,604 46,746,288
83 27,260,489 5,095,345 22,165,144 24,581,144
84 27,260,489 2,679,345 24,581,144 -0

2,289,839,124 2,039,797,168 250,000,000

 
 

Curso:
Matematicas Financiera
 
Presenta:
Martínez Henao Dany Marcela ID 571347
Rendón Benavides Andrés David ID 774103
Vivas Varón Johana Andrea ID 784368
 
 
Actividad 6

Taller sobre gradientes y anualidades

Tutor:
Doris Amparo Portilla Pabon
NRC 9343
 
 
Corporación Universitaria Minuto de Dios
Bogotá, D.C.
Agosto de 2021
 INTRODUCCIÓN

El taller se desarrolla en base al conocimiento adquirido durante las tutorias, las cuales nos han brindado la
oportunidad de entender el tema de las gradientes y anualidades, estos se enfocan en establecer pagos
periodicos(bimestrales,semestrales,anuales etc) En matematicas financieras la palabra anualidad no siempre
hace referencia a 12 meses si no a los diferentes periodos que podemos encontrar en un año, por lo tanto cada
cuota es igual al anterior mas una cantidad establecida. Un ejemplo de anualidad o gradiente son los
dividendos , fondos de amortización y los pagos a plazos.
s han brindado la
ablecer pagos
alidad no siempre
ño, por lo tanto cada
nte son los
 En grupos de trabajo, desarrollen en un documento Word los siguientes puntos. Es importante que, en el desarr
sustentación, se muestren la formulación y la gráfica o los diagramas de flujo de caja.

1. Al señor Carmona se le hace un préstamo por cincuenta y cinco millones de pesos para q
pague en cuotas mensuales iguales durante cinco años. La entidad financiera cobra intereses
1,25 % TV. ¿Cuál es el valor de la cuota?

Ejemplo formulas P= A 1-(1+i)^-n / i

Monto del préstamo 55,000,000 A = P *i /(1-(1+i)^(-n))
Plazo (meses) 60
Tasa de interes 1.25% mensual

Tabla de amortización

Valor cuota $ 1,308,446 $ 1,308,446

PER CUOTA INTERES AMORTIZACION SALDO

0 55,000,000
1 $ 1,308,446 687,500.00 620,946 54,379,053.85
2 $ 1,308,446 679,738.17 628,708 53,750,345.86
3 $ 1,308,446 671,879.32 636,567 53,113,779.03
4 $ 1,308,446 663,922.24 644,524 52,469,255.12
5 $ 1,308,446 655,865.69 652,580 51,816,674.65
6 $ 1,308,446 647,708.43 660,738 51,155,936.93
7 $ 1,308,446 639,449.21 668,997 50,486,939.98
8 $ 1,308,446 631,086.75 677,359 49,809,580.58
9 $ 1,308,446 622,619.76 685,826 49,123,754.18
10 $ 1,308,446 614,046.93 694,399 48,429,354.95
11 $ 1,308,446 605,366.94 703,079 47,726,275.74
12 $ 1,308,446 596,578.45 711,868 47,014,408.03
13 $ 1,308,446 587,680.10 720,766 46,293,641.97
14 $ 1,308,446 578,670.52 729,776 45,563,866.34
15 $ 1,308,446 569,548.33 738,898 44,824,968.52
16 $ 1,308,446 560,312.11 748,134 44,076,834.47
17 $ 1,308,446 550,960.43 757,486 43,319,348.75
18 $ 1,308,446 541,491.86 766,954 42,552,394.45
19 $ 1,308,446 531,904.93 776,541 41,775,853.23
20 $ 1,308,446 522,198.17 786,248 40,989,605.24
21 $ 1,308,446 512,370.07 796,076 40,193,529.15
22 $ 1,308,446 502,419.11 806,027 39,387,502.11
 23 $ 1,308,446 492,343.78 816,102 38,571,399.73
24 $ 1,308,446 482,142.50 826,304 37,745,096.07
25 $ 1,308,446 471,813.70 836,632 36,908,463.62
26 $ 1,308,446 461,355.80 847,090 36,061,373.26
27 $ 1,308,446 450,767.17 857,679 35,203,694.27
28 $ 1,308,446 440,046.18 868,400 34,335,294.29
29 $ 1,308,446 429,191.18 879,255 33,456,039.32
30 $ 1,308,446 418,200.49 890,246 32,565,793.65
31 $ 1,308,446 407,072.42 901,374 31,664,419.92
32 $ 1,308,446 395,805.25 912,641 30,751,779.01
33 $ 1,308,446 384,397.24 924,049 29,827,730.10
34 $ 1,308,446 372,846.63 935,600 28,892,130.57
35 $ 1,308,446 361,151.63 947,295 27,944,836.05
36 $ 1,308,446 349,310.45 959,136 26,985,700.34
37 $ 1,308,446 337,321.25 971,125 26,014,575.44
38 $ 1,308,446 325,182.19 983,264 25,031,311.48
39 $ 1,308,446 312,891.39 995,555 24,035,756.72
40 $ 1,308,446 300,446.96 1,007,999 23,027,757.52
41 $ 1,308,446 287,846.97 1,020,599 22,007,158.34
42 $ 1,308,446 275,089.48 1,033,357 20,973,801.66
43 $ 1,308,446 262,172.52 1,046,274 19,927,528.03
44 $ 1,308,446 249,094.10 1,059,352 18,868,175.97
45 $ 1,308,446 235,852.20 1,072,594 17,795,582.02
46 $ 1,308,446 222,444.78 1,086,001 16,709,580.64
47 $ 1,308,446 208,869.76 1,099,576 15,610,004.24
48 $ 1,308,446 195,125.05 1,113,321 14,496,683.14
49 $ 1,308,446 181,208.54 1,127,238 13,369,445.52
50 $ 1,308,446 167,118.07 1,141,328 12,228,117.44
51 $ 1,308,446 152,851.47 1,155,595 11,072,522.75
52 $ 1,308,446 138,406.53 1,170,040 9,902,483.13
53 $ 1,308,446 123,781.04 1,184,665 8,717,818.02
54 $ 1,308,446 108,972.73 1,199,473 7,518,344.59
55 $ 1,308,446 93,979.31 1,214,467 6,303,877.74
56 $ 1,308,446 78,798.47 1,229,648 5,074,230.06
57 $ 1,308,446 63,427.88 1,245,018 3,829,211.78
58 $ 1,308,446 47,865.15 1,260,581 2,568,630.77
59 $ 1,308,446 32,107.88 1,276,338 1,292,292.50
60 $ 1,308,446 16,153.66 1,292,292 - 0.00
19,089,761.91 28,014,299.66

Intereses

Amortización
 importante que, en el desarrollo de los ejercicios, como
aja.

millones de pesos para que lo

nanciera cobra intereses del

P= A 1-(1+i)^-n / i
(1-(1+i)^(-n))

Interes: Saldo anterior por la tasa

Amortizacion Cuota-interes
Saldo Saldo anterior -Amortizacion
7
2.¿La señora Lily Rodríguez desea ahorrar trimestralmente $200.000 durante cuatro años en
una institución financiera que le reconoce una tasa de interés del 1,9 % SA. Determinen el
valor que ella puede retirar al final del periodo.

VALOR ACTUAL(VP) $ 200,000.00

TASA(i) 2%
PERIODOS(n) 16 Trimestres
Valor Futuro (VF) $ 270,281.89

$ 3,200,000.00
$ 70,281.00 Intereses

$ 3,270,281.00 Valor a retirar al final del periodo

durante cuatro años en
% SA. Determinen el
3.El valor de un lote se está pagando con 24 cuotas mensuales que aumentan cada mes en $
cuota es de $1.500.000. La tasa de interés que se está cobrando es del 23 % NCBV. Calculen

Amortización Ejemplo
Valor del lote
Plazo (meses)
B. Con intereses anticipados Tasa de interes
Amortizacion (primera cuota)
PER CUOTA INTERES-fijar
0
1 1,500,000 14,628,000.00
2 1,600,000 14,283,000.00
3 1,700,000 13,915,000.00
4 1,800,000 13,524,000.00
5 1,900,000 13,110,000.00
6 2,000,000 12,673,000.00
7 2,100,000 12,213,000.00
8 2,200,000 11,730,000.00
9 2,300,000 11,224,000.00
10 2,400,000 10,695,000.00
11 2,500,000 10,143,000.00
12 2,600,000 9,568,000.00
13 2,700,000 8,970,000.00
14 2,800,000 8,349,000.00
15 2,900,000 7,705,000.00
16 3,000,000 7,038,000.00
17 3,100,000 6,348,000.00
18 3,200,000 5,635,000.00
19 3,300,000 4,899,000.00
20 3,400,000 4,140,000.00
21 3,500,000 3,358,000.00
22 3,600,000 2,553,000.00
23 3,700,000 1,725,000.00
24 3,800,000 874,000.00
63,600,000 138,138,000
s que aumentan cada mes en $100.000. El valor de la primera
do es del 23 % NCBV. Calculen el valor del lote.

63,600,000
24
23.00%
1,500,000
AMORTIZACION SALDO
63,600,000
1,500,000 62,100,000
1,600,000 60,500,000
1,700,000 58,800,000
1,800,000 57,000,000
1,900,000 55,100,000
2,000,000 53,100,000
2,100,000 51,000,000
2,200,000 48,800,000
2,300,000 46,500,000
2,400,000 44,100,000
2,500,000 41,600,000
2,600,000 39,000,000
2,700,000 36,300,000
2,800,000 33,500,000
2,900,000 30,600,000
3,000,000 27,600,000
3,100,000 24,500,000
3,200,000 21,300,000
3,300,000 18,000,000
3,400,000 14,600,000
3,500,000 11,100,000
3,600,000 7,500,000
3,700,000 3,800,000
3,800,000 -
63,600,000
4.Encuentren el valor presente y el valor final del siguiente flujo de caja:

TABLA
N 6 $ 200.0
i 24.87% $ 192.00
Vp $ 200.00 $ 184.3
$ 498.44 $ 176.95
$ 169.87
$ 163.07
$ 156.55
VF (6 MESES)
VP=
caja:

K = 4%
8
7.68
7.37
7.08
6.79
6.52
6.26
$ 156.55
$ 200.00
5. Calculen el valor de una máquina que se está financiando con 12 cuotas mensuales
anticipadas que aumentan cada mes en $30.000. La primera cuota tiene un valor de $80.000
paga el mismo día de la negociación. Asuman una tasa de interés del 2,5 % MA.

Amortización Ejemplo
Valor de la maquina
Plazo (meses)
B. Con intereses anticipados Tasa de interes
Amortizacion (primera cuota
PER CUOTA INTERES-fijar AMORTIZACION
0
1 80,000 73,500 80,000
2 110,000 73,500 110,000
3 140,000 71,500 140,000
4 170,000 68,750 170,000
5 200,000 65,250 200,000
6 230,000 61,000 230,000
7 260,000 56,000 260,000
8 290,000 50,250 290,000
9 320,000 43,750 320,000
10 350,000 36,500 350,000
11 380,000 28,500 380,000
12 410,000 19,750 410,000
2,940,000 648,250 2,940,000
ando con 12 cuotas mensuales
era cuota tiene un valor de $80.000 y se
e interés del 2,5 % MA.

2,940,000
12
2.50%
80,000
SALDO
2,940,000
2,860,000
2,750,000
2,610,000
2,440,000
2,240,000
2,010,000
1,750,000
1,460,000
1,140,000
790,000
410,000
-
 CONCLUSIÓN

Culminando el taller aprendimos a entender el funcionamiento de las anualidades y los gravaménes financieros,
los cuales nos enseñan otro punto de vista para realizar pagos o inversiones. En este caso resaltamos que a
momento e iniciar a pagar un credito se inicia con una cuota baja sin embargo a medida que aumenta el tiempo
aumenta proporcionalmente su valor. Asi mismo aprendimos que e termino anualidad no siempre se refiere a
periodos de 12 meses. Estos se pueden dividir en distintos intervalos que esten dentro del año. Este y todos los
temas aprendidos en esta materia son de gran utilidad para nuestra vida personal, pues como futuros
contadores publicos nos veremos entrentados a muchas situaciones similares en nuestra vida real y debemos
estar preparados.
avaménes financieros,
esaltamos que a
ue aumenta el tiempo
siempre se refiere a
año. Este y todos los
mo futuros
ida real y debemos