Administración de Empresas

Matemática financiera
Unidad 4
Actividad 7

Estudio de caso sobre alternativas de financiación

Estudiantes:

Jairo Andrés Jiménez Sierra ID 852105

Eduard José Herrera López ID 487935
Heidy Liliana Moreno Ricaurte ID 853167

Tutor:

Elizabeth Peña Sierra

Matemáticas financieras

UNIMINUTO

Abril 2024
 Estudio de caso sobre alternativas de financiación

La señora María Claudia Pinilla adquirió un crédito de libre inversión por

$250.000.000, durante 7 años, con una tasa de interés del 10,9 % EM.
La prestataria tiene varias alternativas de financiación que le ofrece su entidad
financiera con respecto a la forma de amortizar la deuda. Para ayudarle a
encontrar la mejor opción, construya las tablas de amortización y calcule las
cuotas mensuales, los intereses y los abonos a capital correspondientes.

1. Amortización gradual

PRESTAMO ORIGINAL 250.000.000

PRESTAMO AJUSTADO 250.000.000

TASA ANUAL 216,94%

PLAZO ORIGINAL 84 meses

TASA BANCO 0,1009

CUOTA 25,232,854,98

CONDICIONES DEL BANCO

ME
CUOTA INTERES CAPITAL SALDO
S
250.000.000,00
1 25.232.854,98 25.225.000,00 7.854,98 249.992.145,02
2 25.232.854,98 25.224.207,43 8.647,55 249.983.497,47
3 25.232.854,98 25.223.334,89 9.520,09 249.973.977,38
4 25.232.854,98 25.222.374,32 10.480,66 249.963.496,72
5 25.232.854,98 25.221.316,82 11.538,16 249.951.958,56
6 25.232.854,98 25.220.152,62 12.702,36 249.939.256,19
7 25.232.854,98 25.218.870,95 13.984,03 249.925.272,16
8 25.232.854,98 25.217.459,96 15.395,02 249.909.877,14
 9 25.232.854,98 25.215.906,60 16.948,38 249.892.928,76
10 25.232.854,98 25.214.196,51 18.658,47 249.874.270,29
11 25.232.854,98 25.212.313,87 20.541,11 249.853.729,18
12 25.232.854,98 25.210.241,27 22.613,71 249.831.115,48
13 25.232.854,98 25.207.959,55 24.895,43 249.806.220,05
14 25.232.854,98 25.205.447,60 27.407,38 249.778.812,67
15 25.232.854,98 25.202.682,20 30.172,78 249.748.639,89
16 25.232.854,98 25.199.637,76 33.217,22 249.715.422,67
17 25.232.854,98 25.196.286,15 36.568,83 249.678.853,84
18 25.232.854,98 25.192.596,35 40.258,63 249.638.595,21
19 25.232.854,98 25.188.534,26 44.320,73 249.594.274,48
20 25.232.854,98 25.184.062,30 48.792,69 249.545.481,79
21 25.232.854,98 25.179.139,11 53.715,87 249.491.765,93
22 25.232.854,98 25.173.719,18 59.135,80 249.432.630,13
23 25.232.854,98 25.167.752,38 65.102,60 249.367.527,52
24 25.232.854,98 25.161.183,53 71.671,45 249.295.856,07
25 25.232.854,98 25.153.951,88 78.903,10 249.216.952,97
26 25.232.854,98 25.145.990,55 86.864,43 249.130.088,54
27 25.232.854,98 25.137.225,93 95.629,05 249.034.459,49
28 25.232.854,98 25.127.576,96 105.278,02 248.929.181,47
29 25.232.854,98 25.116.954,41 115.900,57 248.813.280,90
30 25.232.854,98 25.105.260,04 127.594,94 248.685.685,96
31 25.232.854,98 25.092.385,71 140.469,27 248.545.216,70
32 25.232.854,98 25.078.212,36 154.642,62 248.390.574,08
33 25.232.854,98 25.062.608,92 170.246,06 248.220.328,02
34 25.232.854,98 25.045.431,10 187.423,88 248.032.904,14
35 25.232.854,98 25.026.520,03 206.334,95 247.826.569,18
36 25.232.854,98 25.005.700,83 227.154,15 247.599.415,03
37 25.232.854,98 24.982.780,98 250.074,00 247.349.341,03
38 25.232.854,98 24.957.548,51 275.306,47 247.074.034,56
39 25.232.854,98 24.929.770,09 303.084,89 246.770.949,66
40 25.232.854,98 24.899.188,82 333.666,16 246.437.283,50
41 25.232.854,98 24.865.521,91 367.333,08 246.069.950,42
42 25.232.854,98 24.828.458,00 404.396,98 245.665.553,44
43 25.232.854,98 24.787.654,34 445.200,64 245.220.352,80
44 25.232.854,98 24.742.733,60 490.121,38 244.730.231,42
45 25.232.854,98 24.693.280,35 539.574,63 244.190.656,79
46 25.232.854,98 24.638.837,27 594.017,71 243.596.639,07
47 25.232.854,98 24.578.900,88 653.954,10 242.942.684,98
48 25.232.854,98 24.512.916,91 719.938,07 242.222.746,91
49 25.232.854,98 24.440.275,16 792.579,82 241.430.167,09
50 25.232.854,98 24.360.303,86 872.551,12 240.557.615,97
51 25.232.854,98 24.272.263,45 960.591,53 239.597.024,44
52 25.232.854,98 24.175.339,77 1.057.515,22 238.539.509,22
53 25.232.854,98 24.068.636,48 1.164.218,50 237.375.290,72
54 25.232.854,98 23.951.166,83 1.281.688,15 236.093.602,57
55 25.232.854,98 23.821.844,50 1.411.010,48 234.682.592,09
56 25.232.854,98 23.679.473,54 1.553.381,44 233.129.210,65
57 25.232.854,98 23.522.737,35 1.710.117,63 231.419.093,02
58 25.232.854,98 23.350.186,49 1.882.668,50 229.536.424,53
59 25.232.854,98 23.160.225,23 2.072.629,75 227.463.794,78
60 25.232.854,98 22.951.096,89 2.281.758,09 225.182.036,69
61 25.232.854,98 22.720.867,50 2.511.987,48 222.670.049,21
62 25.232.854,98 22.467.407,97 2.765.447,02 219.904.602,20
63 25.232.854,98 22.188.374,36 3.044.480,62 216.860.121,58
64 25.232.854,98 21.881.186,27 3.351.668,71 213.508.452,86
65 25.232.854,98 21.543.002,89 3.689.852,09 209.818.600,78
66 25.232.854,98 21.170.696,82 4.062.158,16 205.756.442,61
67 25.232.854,98 20.760.825,06 4.472.029,92 201.284.412,69
68 25.232.854,98 20.309.597,24 4.923.257,74 196.361.154,95
69 25.232.854,98 19.812.840,53 5.420.014,45 190.941.140,50
70 25.232.854,98 19.265.961,08 5.966.893,90 184.974.246,60
71 25.232.854,98 18.663.901,48 6.568.953,50 178.405.293,10
72 25.232.854,98 18.001.094,07 7.231.760,91 171.173.532,19
73 25.232.854,98 17.271.409,40 7.961.445,58 163.212.086,61
74 25.232.854,98 16.468.099,54 8.764.755,44 154.447.331,16
75 25.232.854,98 15.583.735,71 9.649.119,27 144.798.211,90
76 25.232.854,98 14.610.139,58 10.622.715,40 134.175.496,50
77 25.232.854,98 13.538.307,60 11.694.547,38 122.480.949,11
78 25.232.854,98 12.358.327,77 12.874.527,22 109.606.421,90
79 25.232.854,98 11.059.287,97 14.173.567,01 95.432.854,88
80 25.232.854,98 9.629.175,06 15.603.679,92 79.829.174,96
81 25.232.854,98 8.054.763,75 17.178.091,23 62.651.083,73
82 25.232.854,98 6.321.494,35 18.911.360,63 43.739.723,10
83 25.232.854,98 4.413.338,06 20.819.516,92 22.920.206,18
84 25.232.854,98 2.312.648,80 22.920.206,18 -
 2.Amortización con abono constante a capital

CONDICIONES INICIALES DEL BANCO

ME
CUOTA INTERES CAPITAL SALDO
S
250.000.000,00
1 28.201.190,48 25.225.000,00 2.976.190,48 247.023.809,52
2 27.900.892,86 24.924.702,38 2.976.190,48 244.047.619,05
3 27.600.595,24 24.624.404,76 2.976.190,48 241.071.428,57
4 27.300.297,62 24.324.107,14 2.976.190,48 238.095.238,10
5 27.000.000,00 24.023.809,52 2.976.190,48 235.119.047,62
6 26.699.702,38 23.723.511,90 2.976.190,48 232.142.857,14
7 26.399.404,76 23.423.214,29 2.976.190,48 229.166.666,67
8 26.099.107,14 23.122.916,67 2.976.190,48 226.190.476,19
9 25.798.809,52 22.822.619,05 2.976.190,48 223.214.285,71
10 25.498.511,90 22.522.321,43 2.976.190,48 220.238.095,24
11 25.198.214,29 22.222.023,81 2.976.190,48 217.261.904,76
12 24.897.916,67 21.921.726,19 2.976.190,48 214.285.714,29
13 24.597.619,05 21.621.428,57 2.976.190,48 211.309.523,81
14 24.297.321,43 21.321.130,95 2.976.190,48 208.333.333,33
15 23.997.023,81 21.020.833,33 2.976.190,48 205.357.142,86
16 23.696.726,19 20.720.535,71 2.976.190,48 202.380.952,38
17 23.396.428,57 20.420.238,10 2.976.190,48 199.404.761,90
18 23.096.130,95 20.119.940,48 2.976.190,48 196.428.571,43
19 22.795.833,33 19.819.642,86 2.976.190,48 193.452.380,95
20 22.495.535,71 19.519.345,24 2.976.190,48 190.476.190,48
21 22.195.238,10 19.219.047,62 2.976.190,48 187.500.000,00
22 21.894.940,48 18.918.750,00 2.976.190,48 184.523.809,52
23 21.594.642,86 18.618.452,38 2.976.190,48 181.547.619,05
24 21.294.345,24 18.318.154,76 2.976.190,48 178.571.428,57
25 20.994.047,62 18.017.857,14 2.976.190,48 175.595.238,10
26 20.693.750,00 17.717.559,52 2.976.190,48 172.619.047,62
27 20.393.452,38 17.417.261,90 2.976.190,48 169.642.857,14
28 20.093.154,76 17.116.964,29 2.976.190,48 166.666.666,67
29 19.792.857,14 16.816.666,67 2.976.190,48 163.690.476,19
30 19.492.559,52 16.516.369,05 2.976.190,48 160.714.285,71
31 19.192.261,90 16.216.071,43 2.976.190,48 157.738.095,24
32 18.891.964,29 15.915.773,81 2.976.190,48 154.761.904,76
33 18.591.666,67 15.615.476,19 2.976.190,48 151.785.714,29
34 18.291.369,05 15.315.178,57 2.976.190,48 148.809.523,81
35 17.991.071,43 15.014.880,95 2.976.190,48 145.833.333,33
36 17.690.773,81 14.714.583,33 2.976.190,48 142.857.142,86
37 17.390.476,19 14.414.285,71 2.976.190,48 139.880.952,38
38 17.090.178,57 14.113.988,10 2.976.190,48 136.904.761,90
39 16.789.880,95 13.813.690,48 2.976.190,48 133.928.571,43
40 16.489.583,33 13.513.392,86 2.976.190,48 130.952.380,95
41 16.189.285,71 13.213.095,24 2.976.190,48 127.976.190,48
42 15.888.988,10 12.912.797,62 2.976.190,48 125.000.000,00
43 15.588.690,48 12.612.500,00 2.976.190,48 122.023.809,52
44 15.288.392,86 12.312.202,38 2.976.190,48 119.047.619,05
45 14.988.095,24 12.011.904,76 2.976.190,48 116.071.428,57
46 14.687.797,62 11.711.607,14 2.976.190,48 113.095.238,10
47 14.387.500,00 11.411.309,52 2.976.190,48 110.119.047,62
48 14.087.202,38 11.111.011,90 2.976.190,48 107.142.857,14
49 13.786.904,76 10.810.714,29 2.976.190,48 104.166.666,67
50 13.486.607,14 10.510.416,67 2.976.190,48 101.190.476,19
51 13.186.309,52 10.210.119,05 2.976.190,48 98.214.285,71
52 12.886.011,90 9.909.821,43 2.976.190,48 95.238.095,24
53 12.585.714,29 9.609.523,81 2.976.190,48 92.261.904,76
54 12.285.416,67 9.309.226,19 2.976.190,48 89.285.714,29
55 11.985.119,05 9.008.928,57 2.976.190,48 86.309.523,81
56 11.684.821,43 8.708.630,95 2.976.190,48 83.333.333,33
57 11.384.523,81 8.408.333,33 2.976.190,48 80.357.142,86
58 11.084.226,19 8.108.035,71 2.976.190,48 77.380.952,38
59 10.783.928,57 7.807.738,10 2.976.190,48 74.404.761,90
60 10.483.630,95 7.507.440,48 2.976.190,48 71.428.571,43
61 10.183.333,33 7.207.142,86 2.976.190,48 68.452.380,95
62 9.883.035,71 6.906.845,24 2.976.190,48 65.476.190,48
63 9.582.738,10 6.606.547,62 2.976.190,48 62.500.000,00
64 9.282.440,48 6.306.250,00 2.976.190,48 59.523.809,52
65 8.982.142,86 6.005.952,38 2.976.190,48 56.547.619,05
66 8.681.845,24 5.705.654,76 2.976.190,48 53.571.428,57
67 8.381.547,62 5.405.357,14 2.976.190,48 50.595.238,10
68 8.081.250,00 5.105.059,52 2.976.190,48 47.619.047,62
69 7.780.952,38 4.804.761,90 2.976.190,48 44.642.857,14
70 7.480.654,76 4.504.464,29 2.976.190,48 41.666.666,67
71 7.180.357,14 4.204.166,67 2.976.190,48 38.690.476,19
72 6.880.059,52 3.903.869,05 2.976.190,48 35.714.285,71
73 6.579.761,90 3.603.571,43 2.976.190,48 32.738.095,24
74 6.279.464,29 3.303.273,81 2.976.190,48 29.761.904,76
75 5.979.166,67 3.002.976,19 2.976.190,48 26.785.714,29
76 5.678.869,05 2.702.678,57 2.976.190,48 23.809.523,81
77 5.378.571,43 2.402.380,95 2.976.190,48 20.833.333,33
78 5.078.273,81 2.102.083,33 2.976.190,48 17.857.142,86
79 4.777.976,19 1.801.785,71 2.976.190,48 14.880.952,38
80 4.477.678,57 1.501.488,10 2.976.190,48 11.904.761,90
81 4.177.380,95 1.201.190,48 2.976.190,48 8.928.571,43
82 3.877.083,33 900.892,86 2.976.190,48 5.952.380,95
83 3.576.785,71 600.595,24 2.976.190,48 2.976.190,48
84 3.276.488,10 300.297,62 2.976.190,48 -

2. Amortización con periodo de gracia de 8 meses

CUOTA 54.463.550,93
 Amortización periodo de gracia
CONDICIONES INICIALES DEL BANCO
ME
CUOTA INTERES CAPITAL SALDO
S
250.000.000,00
1 - 25.225.000,00 - 275.225.000,00
2 - 27.770.202,50 - 302.995.202,50
3 - 30.572.215,93 - 333.567.418,43
4 - 33.656.952,52 - 367.224.370,95
5 - 37.052.939,03 - 404.277.309,98
6 - 40.791.580,58 - 445.068.890,56
7 - 44.907.451,06 - 489.976.341,62
8 - 49.438.612,87 - 539.414.954,48
9 54.463.550,93 54.426.968,91 36.582,02 539.378.372,46
10 54.463.550,93 54.423.277,78 40.273,15 539.338.099,32
11 54.463.550,93 54.419.214,22 44.336,71 539.293.762,61
12 54.463.550,93 54.414.740,65 48.810,28 539.244.952,33
13 54.463.550,93 54.409.815,69 53.735,24 539.191.217,09
14 54.463.550,93 54.404.393,80 59.157,13 539.132.059,96
15 54.463.550,93 54.398.424,85 65.126,08 539.066.933,88
16 54.463.550,93 54.391.853,63 71.697,30 538.995.236,58
17 54.463.550,93 54.384.619,37 78.931,56 538.916.305,02
18 54.463.550,93 54.376.655,18 86.895,75 538.829.409,27
19 54.463.550,93 54.367.887,40 95.663,53 538.733.745,74
20 54.463.550,93 54.358.234,94 105.315,98 538.628.429,75
21 54.463.550,93 54.347.608,56 115.942,37 538.512.487,38
22 54.463.550,93 54.335.909,98 127.640,95 538.384.846,43
23 54.463.550,93 54.323.031,01 140.519,92 538.244.326,51
24 54.463.550,93 54.308.852,54 154.698,38 538.089.628,12
25 54.463.550,93 54.293.243,48 170.307,45 537.919.320,67
26 54.463.550,93 54.276.059,46 187.491,47 537.731.829,20
27 54.463.550,93 54.257.141,57 206.409,36 537.525.419,84
28 54.463.550,93 54.236.314,86 227.236,07 537.298.183,77
29 54.463.550,93 54.213.386,74 250.164,19 537.048.019,58
30 54.463.550,93 54.188.145,18 275.405,75 536.772.613,83
31 54.463.550,93 54.160.356,74 303.194,19 536.469.419,64
32 54.463.550,93 54.129.764,44 333.786,49 536.135.633,15
33 54.463.550,93 54.096.085,38 367.465,54 535.768.167,60
34 54.463.550,93 54.059.008,11 404.542,82 535.363.624,79
35 54.463.550,93 54.018.189,74 445.361,19 534.918.263,60
36 54.463.550,93 53.973.252,80 490.298,13 534.427.965,47
37 54.463.550,93 53.923.781,72 539.769,21 533.888.196,25
38 54.463.550,93 53.869.319,00 594.231,93 533.293.964,32
39 54.463.550,93 53.809.361,00 654.189,93 532.639.774,40
40 54.463.550,93 53.743.353,24 720.197,69 531.919.576,70
41 54.463.550,93 53.670.685,29 792.865,64 531.126.711,06
42 54.463.550,93 53.590.685,15 872.865,78 530.253.845,28
43 54.463.550,93 53.502.612,99 960.937,94 529.292.907,34
44 54.463.550,93 53.405.654,35 1.057.896,58 528.235.010,76
45 54.463.550,93 53.298.912,59 1.164.638,34 527.070.372,42
46 54.463.550,93 53.181.400,58 1.282.150,35 525.788.222,07
47 54.463.550,93 53.052.031,61 1.411.519,32 524.376.702,74
48 54.463.550,93 52.909.609,31 1.553.941,62 522.822.761,12
49 54.463.550,93 52.752.816,60 1.710.734,33 521.112.026,79
50 54.463.550,93 52.580.203,50 1.883.347,43 519.228.679,36
51 54.463.550,93 52.390.173,75 2.073.377,18 517.155.302,18
52 54.463.550,93 52.180.969,99 2.282.580,94 514.872.721,24
53 54.463.550,93 51.950.657,57 2.512.893,36 512.359.827,89
54 54.463.550,93 51.697.106,63 2.766.444,30 509.593.383,59
55 54.463.550,93 51.417.972,40 3.045.578,52 506.547.805,07
56 54.463.550,93 51.110.673,53 3.352.877,40 503.194.927,67
57 54.463.550,93 50.772.368,20 3.691.182,73 499.503.744,94
58 54.463.550,93 50.399.927,86 4.063.623,06 495.440.121,88
59 54.463.550,93 49.989.908,30 4.473.642,63 490.966.479,25
60 54.463.550,93 49.538.517,76 4.925.033,17 486.041.446,07
61 54.463.550,93 49.041.581,91 5.421.969,02 480.619.477,05
62 54.463.550,93 48.494.505,23 5.969.045,69 474.650.431,36
63 54.463.550,93 47.892.228,52 6.571.322,41 468.079.108,95
64 54.463.550,93 47.229.182,09 7.234.368,84 460.844.740,12
65 54.463.550,93 46.499.234,28 7.964.316,65 452.880.423,47
66 54.463.550,93 45.695.634,73 8.767.916,20 444.112.507,26
67 54.463.550,93 44.810.951,98 9.652.598,95 434.459.908,32
68 54.463.550,93 43.837.004,75 10.626.546,18 423.833.362,14
69 54.463.550,93 42.764.786,24 11.698.764,69 412.134.597,45
70 54.463.550,93 41.584.380,88 12.879.170,05 399.255.427,40
71 54.463.550,93 40.284.872,62 14.178.678,30 385.076.749,10
72 54.463.550,93 38.854.243,98 15.609.306,95 369.467.442,15
73 54.463.550,93 37.279.264,91 17.184.286,02 352.283.156,14
74 54.463.550,93 35.545.370,45 18.918.180,47 333.364.975,66
75 54.463.550,93 33.636.526,04 20.827.024,88 312.537.950,78
76 54.463.550,93 31.535.079,23 22.928.471,70 289.609.479,08
77 54.463.550,93 29.221.596,44 25.241.954,49 264.367.524,59
78 54.463.550,93 26.674.683,23 27.788.867,70 236.578.656,89
79 54.463.550,93 23.870.786,48 30.592.764,45 205.985.892,44
80 54.463.550,93 20.783.976,55 33.679.574,38 172.306.318,06
81 54.463.550,93 17.385.707,49 37.077.843,44 135.228.474,63
82 54.463.550,93 13.644.553,09 40.818.997,84 94.409.476,79
83 54.463.550,93 9.525.916,21 44.937.634,72 49.471.842,06
84 54.463.550,93 4.991.708,86 49.471.842,06 -