taller amortizacion

27
Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera Punto 1 tabla amortización monto $ 175.000.000. 00 plazo meses 60 tasa 13.91% EA 1.091% MV forma de pago Cuotas mesuales vencidas n o Saldo Inicial Abono a K Intereses Cuota Saldo Final 0 175000000.00 175000000.0 0 1 175000000.00 1424157.52 1909008.19 3333165.71 173575842.4 8 2 173575842.48 1464693.11 1893472.60 3358165.71 172111149.3 8 3 172111149.38 1505670.88 1877494.83 3383165.71 170605478.4 9 4 170605478.49 1547095.67 1861070.04 3408165.71 169058382.8 2 5 169058382.82 1588972.35 1844193.36 3433165.71 167469410.4 7 6 167469410.47 1631305.84 1826859.87 3458165.71 165838104.6 3 7 165838104.63 1674101.14 1809064.58 3483165.71 164164003.4 9 8 164164003.49 1717363.27 1790802.45 3508165.71 162446640.2 3 9 162446640.23 1761097.33 1772068.39 3533165.71 160685542.9 0 1 0 160685542.90 1805308.46 1752857.25 3558165.71 158880234.4 4 1 1 158880234.44 1850001.88 1733163.83 3583165.71 157030232.5 5 1 2 157030232.55 1895182.85 1712982.86 3608165.71 155135049.7 0 1 3 155135049.70 1940856.68 1692309.04 3633165.71 153194193.0 3 1 4 153194193.03 1987028.74 1671136.97 3658165.71 151207164.2 9

Upload: diegoruiz

Post on 10-Dec-2015

264 views

Category:

Documents


0 download

DESCRIPTION

f

TRANSCRIPT

Page 1: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

Punto 1

tabla amortización

monto $ 175.000.000.00

plazo meses 60tasa 13.91% EA 1.091% MV

forma de pago Cuotas mesuales vencidasno Saldo Inicial Abono a K Intereses Cuota Saldo Final

0 175000000.00 175000000.001 175000000.00 1424157.52 1909008.19 3333165.71 173575842.482 173575842.48 1464693.11 1893472.60 3358165.71 172111149.383 172111149.38 1505670.88 1877494.83 3383165.71 170605478.494 170605478.49 1547095.67 1861070.04 3408165.71 169058382.825 169058382.82 1588972.35 1844193.36 3433165.71 167469410.476 167469410.47 1631305.84 1826859.87 3458165.71 165838104.637 165838104.63 1674101.14 1809064.58 3483165.71 164164003.498 164164003.49 1717363.27 1790802.45 3508165.71 162446640.239 162446640.23 1761097.33 1772068.39 3533165.71 160685542.90

10 160685542.90 1805308.46 1752857.25 3558165.71 158880234.4411 158880234.44 1850001.88 1733163.83 3583165.71 157030232.5512 157030232.55 1895182.85 1712982.86 3608165.71 155135049.7013 155135049.70 1940856.68 1692309.04 3633165.71 153194193.0314 153194193.03 1987028.74 1671136.97 3658165.71 151207164.2915 151207164.29 2033704.48 1649461.23 3683165.71 149173459.8116 149173459.81 2080889.38 1627276.33 3708165.71 147092570.4217 147092570.42 2128589.01 1604576.70 3733165.71 144963981.4118 144963981.41 2176808.98 1581356.73 3758165.71 142787172.4419 142787172.44 2225554.95 1557610.76 3783165.71 140561617.4820 140561617.48 2274832.68 1533333.03 3808165.71 138286784.8021 138286784.80 2324647.97 1508517.75 3833165.71 135962136.8322 135962136.83 2375006.66 1483159.05 3858165.71 133587130.1723 133587130.17 2425914.70 1457251.01 3883165.71 131161215.4624 131161215.46 2477378.08 1430787.63 3908165.71 128683837.3825 128683837.38 2529402.85 1403762.86 3933165.71 126154434.5326 126154434.53 2581995.14 1376170.57 3958165.71 123572439.3927 123572439.39 2635161.14 1348004.57 3983165.71 120937278.2428 120937278.24 2688907.11 1319258.60 4008165.71 118248371.1329 118248371.13 2743239.37 1289926.34 4033165.71 115505131.7630 115505131.76 2798164.32 1260001.39 4058165.71 112706967.4431 112706967.44 2853688.43 1229477.28 4083165.71 109853279.0132 109853279.01 2909818.23 1198347.48 4108165.71 106943460.7933 106943460.79 2966560.32 1166605.39 4133165.71 103976900.46

Page 2: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

34 103976900.46 3023921.40 1134244.31 4158165.71 100952979.0735 100952979.07 3081908.20 1101257.51 4183165.71 97871070.8736 97871070.87 3140527.56 1067638.15 4208165.71 94730543.3137 94730543.31 3199786.38 1033379.33 4233165.71 91530756.9338 91530756.93 3259691.62 998474.09 4258165.71 88271065.3139 88271065.31 3320250.36 962915.35 4283165.71 84950814.9540 84950814.95 3381469.70 926696.01 4308165.71 81569345.2541 81569345.25 3443356.86 889808.85 4333165.71 78125988.3942 78125988.39 3505919.13 852246.58 4358165.71 74620069.2643 74620069.26 3569163.86 814001.85 4383165.71 71050905.4044 71050905.40 3633098.51 775067.20 4408165.71 67417806.8945 67417806.89 3697730.59 735435.12 4433165.71 63720076.3046 63720076.30 3763067.72 695097.99 4458165.71 59957008.5847 59957008.58 3829117.59 654048.12 4483165.71 56127890.9848 56127890.98 3895887.97 612277.74 4508165.71 52232003.0149 52232003.01 3963386.73 569778.98 4533165.71 48268616.2850 48268616.28 4031621.80 526543.91 4558165.71 44236994.4851 44236994.48 4100601.23 482564.49 4583165.71 40136393.2552 40136393.25 4170333.12 437832.59 4608165.71 35966060.1353 35966060.13 4240825.69 392340.02 4633165.71 31725234.4454 31725234.44 4312087.24 346078.47 4658165.71 27413147.2055 27413147.20 4384126.15 299039.56 4683165.71 23029021.0556 23029021.05 4456950.91 251214.80 4708165.71 18572070.1457 18572070.14 4530570.09 202595.62 4733165.71 14041500.0558 14041500.05 4604992.35 153173.36 4758165.71 9436507.7159 9436507.71 4680226.45 102939.26 4783165.71 4756281.2560 4756281.25 4756281.25 51884.46 4808165.71 0.00

Punto 2

GRADIENTE CRECIENTE

Page 3: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

monto $ 1.000.000.00

plazo meses 6tasa 18.00% NAMV IP 1.5%

forma de pago Cuotas mensuales vencidasno Saldo Inicial Abono a K Intereses Cuota Saldo Final Gradiente

0 $ 1.000.000.00 $ 1.000.000.00

1 1000000.00 140159.72 15000.00 155159.72 859840.28 0.002 859840.28 150020.10 12897.60 162917.71 709820.17 7757.993 709820.17 160416.29 10647.30 171063.59 549403.88 8145.894 549403.88 171375.72 8241.06 179616.77 378028.17 8553.185 378028.17 182927.19 5670.42 188597.61 195100.98 8980.846 195100.98 195100.98 2926.51 198027.49 0.00 9429.88

GRADIENTE DECRECIENTE

monto $ 1.000.000.00

plazo meses 6tasa 18.00% NAMV IP 1.5%

forma de pago Cuotas mensuales vencidasno Saldo Inicial Abono a K Intereses Cuota Saldo Final Gradiente

0 $ 1.000.000.00 $ 1.000.000.00

1 1000000.00 183335.54 15000.00 198335.54 816664.46 0.002 816664.46 176168.79 12249.97 188418.76 640495.67 -9916.783 640495.67 169390.39 9607.44 178997.82 471105.28 -9420.944 471105.28 162981.35 7066.58 170047.93 308123.93 -8949.895 308123.93 156923.68 4621.86 161545.53 151200.25 -8502.406 151200.25 151200.25 2268.00 153468.26 0.00 -8077.28

Punto 3

Page 4: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

tabla amortizacion

Page 5: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

monto $ 70.000.000.00 IP 1.35%plazo meses 36 EA 17.46%

tasa 16.20% NAMVforma de pago Cuotas uniformes mesuales vencidas

no Abono a K Intereses Cuota Saldo Final0 70000000.00 70000000.001 70000000.00 1522909.73 945000.00 2467909.73 68477090.272 68477090.27 1543469.01 924440.72 2467909.73 66933621.263 66933621.26 1564305.84 903603.89 2467909.73 65369315.424 65369315.42 1585423.97 882485.76 2467909.73 63783891.455 63783891.45 1606827.19 861082.53 2467909.73 62177064.266 62177064.26 1628519.36 839390.37 2467909.73 60548544.907 60548544.90 1650504.37 817405.36 2467909.73 58898040.538 58898040.53 1672786.18 795123.55 2467909.73 57225254.359 57225254.35 1695368.79 772540.93 2467909.73 55529885.55

10 55529885.55 1718256.27 749653.45 2467909.73 53811629.2811 53811629.28 1741452.73 726457.00 2467909.73 52070176.5512 52070176.55 1764962.34 702947.38 2467909.73 50305214.2013 50305214.20 1788789.34 679120.39 2467909.73 48516424.8714 48516424.87 1812937.99 654971.74 2467909.73 46703486.8715 46703486.87 1837412.66 630497.07 2467909.73 44866074.2216 44866074.22 1862217.73 605692.00 2467909.73 43003856.4917 43003856.49 1887357.67 580552.06 2467909.73 41116498.8318 41116498.83 1912836.99 555072.73 2467909.73 39203661.8319 39203661.83 1938660.29 529249.43 2467909.73 37265001.5420 37265001.54 1964832.21 503077.52 2467909.73 35300169.3321 35300169.33 1991357.44 476552.29 2467909.73 33308811.8922 33308811.89 2018240.77 449668.96 2467909.73 31290571.1223 31290571.12 2045487.02 422422.71 2467909.73 29245084.1124 29245084.11 2073101.09 394808.64 2467909.73 27171983.0125 27171983.01 2101087.96 366821.77 2467909.73 25070895.0626 25070895.06 2129452.64 338457.08 2467909.73 22941442.4127 22941442.41 2158200.26 309709.47 2467909.73 20783242.1628 20783242.16 2187335.96 280573.77 2467909.73 18595906.2029 18595906.20 2216864.99 251044.73 2467909.73 16379041.2030 16379041.20 2246792.67 221117.06 2467909.73 14132248.5331 14132248.53 2277124.37 190785.36 2467909.73 11855124.1632 11855124.16 2307865.55 160044.18 2467909.73 9547258.6133 9547258.61 2339021.74 128887.99 2467909.73 7208236.8734 7208236.87 2370598.53 97311.20 2467909.73 4837638.3435 4837638.34 2402601.61 65308.12 2467909.73 2435036.7336 2435036.73 2435036.73 32873.00 2467909.73 0.00

88844750.2

tabla amortizacion

Page 6: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

monto $ 70.000.000.00 IP 4%plazo meses 30 EA 17%

tasa 16.00% NATVforma de pago Abono a K uniforme

no No. Saldo inicial Abono a K Intereses Cuota Saldo Final0 70000000.00 70000000.001 70000000.00 2333333.33 2800000.00 5133333.33 67666666.672 67666666.67 2333333.33 2706666.67 5040000.00 65333333.333 65333333.33 2333333.33 2613333.33 4946666.67 63000000.004 63000000.00 2333333.33 2520000.00 4853333.33 60666666.675 60666666.67 2333333.33 2426666.67 4760000.00 58333333.336 58333333.33 2333333.33 2333333.33 4666666.67 56000000.007 56000000.00 2333333.33 2240000.00 4573333.33 53666666.678 53666666.67 2333333.33 2146666.67 4480000.00 51333333.339 51333333.33 2333333.33 2053333.33 4386666.67 49000000.00

10 49000000.00 2333333.33 1960000.00 4293333.33 46666666.6711 46666666.67 2333333.33 1866666.67 4200000.00 44333333.3312 44333333.33 2333333.33 1773333.33 4106666.67 42000000.0013 42000000.00 2333333.33 1680000.00 4013333.33 39666666.6714 39666666.67 2333333.33 1586666.67 3920000.00 37333333.3315 37333333.33 2333333.33 1493333.33 3826666.67 35000000.0016 35000000.00 2333333.33 1400000.00 3733333.33 32666666.6717 32666666.67 2333333.33 1306666.67 3640000.00 30333333.3318 30333333.33 2333333.33 1213333.33 3546666.67 28000000.0019 28000000.00 2333333.33 1120000.00 3453333.33 25666666.6720 25666666.67 2333333.33 1026666.67 3360000.00 23333333.3321 23333333.33 2333333.33 933333.33 3266666.67 21000000.0022 21000000.00 2333333.33 840000.00 3173333.33 18666666.6723 18666666.67 2333333.33 746666.67 3080000.00 16333333.3324 16333333.33 2333333.33 653333.33 2986666.67 14000000.0025 14000000.00 2333333.33 560000.00 2893333.33 11666666.6726 11666666.67 2333333.33 466666.67 2800000.00 9333333.3327 9333333.33 2333333.33 373333.33 2706666.67 7000000.0028 7000000.00 2333333.33 280000.00 2613333.33 4666666.6729 4666666.67 2333333.33 186666.67 2520000.00 2333333.3330 2333333.33 2333333.33 93333.33 2426666.67 0.00

113400000

Page 7: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

Punto 4

monto $ 100.000.000.00 UVR 3.00% 0.25% Reflejo de inflación UVR 218.98

plazo en meses 144 Spread 11.00% 0.87%

tasa UVR+11%EA Cf 14.33% 1.12%

forma de pago CUMV en UVR

no. saldo inicial abono a k intereses cuota saldo final UVR saldo inicial abono a k intereses cuota saldo final

0 456662.709 456662.709 218.98 100000000 100000000

1 456662.709 1.596.49 3988.76328 5585.2580 455.066.21 219.520064 100000000 103.835.65 1122240.55 1226076.1995 99.896.164.35

2 455066.214 1.610.44 3974.81854 5585.2580 453.455.77 220.061459 99896164.3 108.024.77 1121075.26 1229100.0342 99.788.139.57

3 453455.775 1.624.51 3960.75201 5585.2580 451.831.27 220.60419 99788139.6 112.268.36 1119862.96 1232131.3264 99.675.871.21

4 451831.269 1.638.70 3946.56261 5585.2580 450.192.57 221.14826 99675871.2 116.567.05 1118603.04 1235170.0947 99.559.304.16

5 450192.573 1.653.01 3932.24927 5585.2580 448.539.56 221.693671 99559304.2 120.921.48 1117294.88 1238216.3574 99.438.382.68

6 448539.564 1.667.45 3917.81091 5585.2580 446.872.12 222.240427 99438382.7 125.332.28 1115937.85 1241270.1329 99.313.050.39

7 446872.117 1.682.01 3903.24644 5585.2580 445.190.11 222.788532 99313050.4 129.800.12 1114531.32 1244331.4399 99.183.250.27

8 445190.106 1.696.70 3888.55475 5585.2580 443.493.40 223.337989 99183250.3 134.325.65 1113074.65 1247400.2970 99.048.924.62

9 443493.402 1.711.52 3873.73473 5585.2580 441.781.88 223.888801 99048924.6 138.909.53 1111567.19 1250476.7226 98.910.015.09

10 441781.879 1.726.47 3858.78527 5585.2580 440.055.41 224.440971 98910015.1 143.552.44 1110008.29 1253560.7355 98.766.462.65

11 440055.406 1.741.55 3843.70523 5585.2580 438.313.85 224.994503 98766462.7 148.255.06 1108397.29 1256652.3545 98.618.207.59

12 438313.854 1.756.76 3828.49348 5585.2580 436.557.09 225.5494 98618207.6 153.018.09 1106733.51 1259751.5982 98.465.189.50

13 436557.089 1.772.11 3813.14885 5585.2580 434.784.98 226.105666 98465189.5 157.842.21 1105016.28 1262858.4855 98.307.347.30

14 434784.98 1.787.59 3797.6702 5585.2580 432.997.39 226.663303 98307347.3 162.728.12 1103244.91 1265973.0352 98.144.619.17

15 432997.392 1.803.20 3782.05635 5585.2580 431.194.19 227.222316 98144619.2 167.676.56 1101418.71 1269095.2662 97.976.942.61

16 431194.19 1.818.95 3766.30611 5585.2580 429.375.24 227.782708 97976942.6 172.688.22 1099536.98 1272225.1975 97.804.254.39

17 429375.238 1.834.84 3750.41831 5585.2580 427.540.40 228.344481 97804254.4 177.763.85 1097599 1275362.8481 97.626.490.54

18 427540.399 1.850.87 3734.39173 5585.2580 425.689.53 228.90764 97626490.5 182.904.18 1095604.06 1278508.2369 97.443.586.37

19 425689.532 1.867.03 3718.22516 5585.2580 423.822.50 229.472188 97443586.4 188.109.95 1093551.44 1281661.3831 97.255.476.42

20 423822.5 1.883.34 3701.91739 5585.2580 421.939.16 230.038129 97255476.4 193.381.92 1091440.39 1284822.3059 97.062.094.50

21 421939.159 1.899.79 3685.46717 5585.2580 420.039.37 230.605465 97062094.5 198.720.84 1089270.18 1287991.0243 96.863.373.66

22 420039.368 1.916.38 3668.87327 5585.2580 418.122.98 231.1742 96863373.7 204.127.50 1087040.05 1291167.5576 96.659.246.15

Page 8: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

23 418122.983 1.933.12 3652.13443 5585.2580 416.189.86 231.744338 96659246.2 209.602.67 1084749.25 1294351.9251 96.449.643.48

24 416189.86 1.950.01 3635.24938 5585.2580 414.239.85 232.315882 96449643.5 215.147.14 1082397.01 1297544.1462 96.234.496.34

25 414239.851 1.967.04 3618.21684 5585.2580 412.272.81 232.888836 96234496.3 220.761.70 1079982.54 1300744.2401 96.013.734.64

26 412272.81 1.984.22 3601.03554 5585.2580 410.288.59 233.463202 96013734.6 226.447.17 1077505.06 1303952.2263 95.787.287.47

27 410288.587 2.001.55 3583.70416 5585.2580 408.287.03 234.038986 95787287.5 232.204.35 1074963.78 1307168.1242 95.555.083.13

28 408287.033 2.019.04 3566.2214 5585.2580 406.268.00 234.616189 95555083.1 238.034.07 1072357.89 1310391.9535 95.317.049.06

29 406267.997 2.036.67 3548.58594 5585.2580 404.231.32 235.194816 95317049.1 243.937.16 1069686.57 1313623.7335 95.073.111.90

30 404231.325 2.054.46 3530.79643 5585.2580 402.176.86 235.77487 95073111.9 249.914.47 1066949.01 1316863.4840 94.823.197.42

31 402176.863 2.072.41 3512.85154 5585.2580 400.104.46 236.356354 94823197.4 255.966.86 1064144.37 1320111.2246 94.567.230.57

32 400104.457 2.090.51 3494.74992 5585.2580 398.013.95 236.939272 94567230.6 262.095.17 1061271.8 1323366.9750 94.305.135.40

33 398013.948 2.108.77 3476.49018 5585.2580 395.905.18 237.523629 94305135.4 268.300.29 1058330.47 1326630.7550 94.036.835.11

34 395905.181 2.127.19 3458.07095 5585.2580 393.777.99 238.109426 94036835.1 274.583.09 1055319.49 1329902.5843 93.762.252.02

35 393777.994 2.145.77 3439.49083 5585.2580 391.632.23 238.696668 93762252 280.944.47 1052238.01 1333182.4829 93.481.307.54

36 391632.226 2.164.51 3420.74843 5585.2580 389.467.72 239.285358 93481307.5 287.385.33 1049085.14 1336470.4705 93.193.922.21

37 389467.717 2.183.42 3401.84231 5585.2580 387.284.30 239.875501 93193922.2 293.906.59 1045859.98 1339766.5673 92.900.015.62

38 387284.301 2.202.49 3382.77106 5585.2580 385.081.81 240.467098 92900015.6 300.509.15 1042561.64 1343070.7930 92.599.506.47

39 385081.814 2.221.72 3363.53323 5585.2580 382.860.09 241.060155 92599506.5 307.193.96 1039189.21 1346383.1679 92.292.312.51

40 382860.089 2.241.13 3344.12737 5585.2580 380.618.96 241.654675 92292312.5 313.961.96 1035741.75 1349703.7121 91.978.350.55

41 380618.959 2.260.71 3324.552 5585.2580 378.358.25 242.25066 91978350.6 320.814.10 1032218.34 1353032.4455 91.657.536.45

42 378358.253 2.280.45 3304.80566 5585.2580 376.077.80 242.848116 91657536.4 327.751.35 1028618.04 1356369.3885 91.329.785.10

43 376077.8 2.300.37 3284.88683 5585.2580 373.777.43 243.447045 91329785.1 334.774.68 1024939.88 1359714.5614 90.995.010.41

44 373777.429 2.320.46 3264.79402 5585.2580 371.456.96 244.047451 90995010.4 341.885.08 1021182.9 1363067.9843 90.653.125.33

45 371456.965 2.340.73 3244.52571 5585.2580 369.116.23 244.649338 90653125.3 349.083.55 1017346.13 1366429.6777 90.304.041.78

46 369116.233 2.361.18 3224.08037 5585.2580 366.755.05 245.252709 90304041.8 356.371.09 1013428.57 1369799.6619 89.947.670.69

47 366755.055 2.381.80 3203.45644 5585.2580 364.373.25 245.857568 89947670.7 363.748.73 1009429.23 1373177.9574 89.583.921.97

48 364373.253 2.402.61 3182.65237 5585.2580 361.970.65 246.463919 89583922 371.217.49 1005347.1 1376564.5847 89.212.704.48

49 361970.648 2.423.59 3161.66658 5585.2580 359.547.06 247.071766 89212704.5 378.778.42 1001181.14 1379959.5643 88.833.926.05

50 359547.056 2.444.76 3140.4975 5585.2580 357.102.30 247.681111 88833926.1 386.432.58 996930.337 1383362.9168 88.447.493.47

51 357102.296 2.466.11 3119.14351 5585.2580 354.636.18 248.29196 88447493.5 394.181.03 992593.634 1386774.6630 88.053.312.45

52 354636.181 2.487.66 3097.603 5585.2580 352.148.53 248.904315 88053312.4 402.024.85 988169.974 1390194.8234 87.651.287.60

Page 9: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

53 352148.526 2.509.38 3075.87434 5585.2580 349.639.14 249.51818 87651287.6 409.965.13 983658.289 1393623.4189 87.241.322.47

54 349639.142 2.531.30 3053.95589 5585.2580 347.107.84 250.133559 87241322.5 418.002.98 979057.494 1397060.4702 86.823.319.49

55 347107.84 2.553.41 3031.846 5585.2580 344.554.43 250.750456 86823319.5 426.139.50 974366.495 1400505.9982 86.397.179.99

56 344554.428 2.575.72 3009.54298 5585.2580 341.978.71 251.368874 86397180 434.375.84 969584.184 1403960.0238 85.962.804.15

57 341978.713 2.598.21 2987.04516 5585.2580 339.380.50 251.988818 85962804.1 442.713.13 964709.443 1407422.5680 85.520.091.02

58 339380.5 2.620.91 2964.35082 5585.2580 336.759.59 252.61029 85520091 451.152.52 959741.136 1410893.6517 85.068.938.51

59 336759.593 2.643.80 2941.45826 5585.2580 334.115.79 253.233295 85068938.5 459.695.18 954678.12 1414373.2961 84.609.243.33

60 334115.793 2.666.89 2918.36575 5585.2580 331.448.90 253.857837 84609243.3 468.342.29 949519.234 1417861.5222 84.140.901.04

61 331448.901 2.690.19 2895.07152 5585.2580 328.758.71 254.483919 84140901 477.095.04 944263.307 1421358.3512 83.663.806.00

62 328758.715 2.713.68 2871.57384 5585.2580 326.045.03 255.111545 83663806 485.954.65 938909.153 1424863.8043 83.177.851.35

63 326045.03 2.737.39 2847.87091 5585.2580 323.307.64 255.740719 83177851.3 494.922.33 933455.573 1428377.9029 82.682.929.02

64 323307.643 2.761.30 2823.96094 5585.2580 320.546.35 256.371444 82682929 503.999.31 927901.354 1431900.6681 82.178.929.70

65 320546.346 2.785.42 2799.84214 5585.2580 317.760.93 257.003725 82178929.7 513.186.85 922245.269 1435432.1215 81.665.742.85

66 317760.93 2.809.75 2775.51266 5585.2580 314.951.18 257.637566 81665742.9 522.486.21 916486.079 1438972.2843 81.143.256.65

67 314951.185 2.834.29 2750.97067 5585.2580 312.116.90 258.27297 81143256.6 531.898.65 910622.526 1442521.1782 80.611.357.99

68 312116.898 2.859.04 2726.21433 5585.2580 309.257.85 258.90994 80611358 541.425.48 904653.344 1446078.8245 80.069.932.51

69 309257.854 2.884.02 2701.24174 5585.2580 306.373.84 259.548482 80069932.5 551.068.00 898577.248 1449645.2450 79.518.864.52

70 306373.838 2.909.21 2676.05103 5585.2580 303.464.63 260.188599 79518864.5 560.827.52 892392.939 1453220.4613 78.958.036.99

71 303464.631 2.934.62 2650.64029 5585.2580 300.530.01 260.830294 78958037 570.705.39 886099.106 1456804.4950 78.387.331.60

72 300530.013 2.960.25 2625.00759 5585.2580 297.569.76 261.473572 78387331.6 580.702.95 879694.418 1460397.3679 77.806.628.66

73 297569.762 2.986.11 2599.15101 5585.2580 294.583.66 262.118436 77806628.7 590.821.57 873177.534 1463999.1017 77.215.807.09

74 294583.655 3.012.19 2573.06858 5585.2580 291.571.47 262.764891 77215807.1 601.062.62 866547.095 1467609.7185 76.614.744.46

75 291571.466 3.038.50 2546.75833 5585.2580 288.532.97 263.41294 76614744.5 611.427.51 859801.727 1471229.2400 76.003.316.95

76 288532.966 3.065.04 2520.21826 5585.2580 285.467.93 264.062588 76003317 621.917.65 852940.039 1474857.6882 75.381.399.30

77 285467.926 3.091.81 2493.44639 5585.2580 282.376.11 264.713837 75381399.3 632.534.46 845960.627 1478495.0851 74.748.864.84

78 282376.115 3.118.82 2466.44067 5585.2580 279.257.30 265.366693 74748864.8 643.279.38 838862.069 1482141.4528 74.105.585.46

79 279257.297 3.146.06 2439.19907 5585.2580 276.111.24 266.021159 74105585.5 654.153.89 831642.927 1485796.8135 73.451.431.57

80 276111.238 3.173.54 2411.71952 5585.2580 272.937.70 266.677239 73451431.6 665.159.44 824301.747 1489461.1893 72.786.272.13

81 272937.7 3.201.26 2383.99995 5585.2580 269.736.44 267.334937 72786272.1 676.297.54 816837.058 1493134.6024 72.109.974.59

82 269736.442 3.229.22 2356.03826 5585.2580 266.507.22 267.994257 72109974.6 687.569.70 809247.373 1496817.0751 71.422.404.88

Page 10: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

83 266507.222 3.257.43 2327.83234 5585.2580 263.249.80 268.655203 71422404.9 698.977.44 801531.187 1500508.6298 70.723.427.44

84 263249.796 3.285.88 2299.38005 5585.2580 259.963.92 269.317779 70723427.4 710.522.31 793686.978 1504209.2889 70.012.905.13

85 259963.918 3.314.58 2270.67924 5585.2580 256.649.34 269.981989 70012905.1 722.205.87 785713.209 1507919.0748 69.290.699.26

86 256649.34 3.343.53 2241.72774 5585.2580 253.305.81 270.647838 69290699.3 734.029.69 777608.322 1511638.0100 68.556.669.58

87 253305.809 3.372.73 2212.52336 5585.2580 249.933.07 271.315328 68556669.6 745.995.37 769370.743 1515366.1172 67.810.674.20

88 249933.075 3.402.19 2183.06389 5585.2580 246.530.88 271.984465 67810674.2 758.104.54 760998.88 1519103.4188 67.052.569.66

89 246530.88 3.431.91 2153.34711 5585.2580 243.098.97 272.655252 67052569.7 770.358.81 752491.124 1522849.9376 66.282.210.85

90 243098.97 3.461.89 2123.37076 5585.2580 239.637.08 273.327694 66282210.9 782.759.85 743845.845 1526605.6964 65.499.451.00

91 239637.082 3.492.13 2093.13258 5585.2580 236.144.96 274.001793 65499451 795.309.32 735061.397 1530370.7179 64.704.141.68

92 236144.957 3.522.63 2062.63028 5585.2580 232.622.33 274.677556 64704141.7 808.008.91 726136.113 1534145.0249 63.896.132.77

93 232622.329 3.553.40 2031.86156 5585.2580 229.068.93 275.354985 63896132.8 820.860.33 717068.309 1537928.6404 63.075.272.43

94 229068.933 3.584.43 2000.82408 5585.2580 225.484.50 276.034084 63075272.4 833.865.31 707856.282 1541721.5874 62.241.407.13

95 225484.499 3.615.74 1969.51551 5585.2580 221.868.76 276.714859 62241407.1 847.025.58 698498.307 1545523.8887 61.394.381.55

96 221868.756 3.647.32 1937.93347 5585.2580 218.221.43 277.397312 61394381.5 860.342.92 688992.643 1549335.5676 60.534.038.62

97 218221.432 3.679.18 1906.07557 5585.2580 214.542.25 278.081449 60534038.6 873.819.12 679337.526 1553156.6470 59.660.219.50

98 214542.249 3.711.32 1873.9394 5585.2580 210.830.93 278.767273 59660219.5 887.455.98 669531.173 1556987.1503 58.772.763.52

99 210830.93 3.743.74 1841.52254 5585.2580 207.087.19 279.454788 58772763.5 901.255.32 659571.782 1560827.1007 57.871.508.21

100 207087.195 3.776.44 1808.82253 5585.2580 203.310.76 280.143999 57871508.2 915.218.99 649457.53 1564676.5214 56.956.289.21

101 203310.759 3.809.42 1775.8369 5585.2580 199.501.34 280.83491 56956289.2 929.348.86 639186.571 1568535.4358 56.026.940.35

102 199501.338 3.842.69 1742.56316 5585.2580 195.658.64 281.527524 56026940.3 943.646.83 628757.041 1572403.8673 55.083.293.52

103 195658.643 3.876.26 1708.99878 5585.2580 191.782.38 282.221847 55083293.5 958.114.79 618167.054 1576281.8394 54.125.178.74

104 191782.384 3.910.12 1675.14123 5585.2580 187.872.27 282.917882 54125178.7 972.754.67 607414.701 1580169.3757 53.152.424.06

105 187872.267 3.944.27 1640.98795 5585.2580 183.928.00 283.615634 53152424.1 987.568.45 596498.054 1584066.4997 52.164.855.62

106 183927.997 3.978.72 1606.53635 5585.2580 179.949.28 284.315107 52164855.6 1.002.558.07 585415.161 1587973.2350 51.162.297.54

107 179949.276 4.013.47 1571.78383 5585.2580 175.935.80 285.016305 51162297.5 1.017.725.56 574164.047 1591889.6054 50.144.571.98

108 175935.801 4.048.53 1536.72776 5585.2580 171.887.27 285.719232 50144572 1.033.072.92 562742.718 1595815.6346 49.111.499.07

109 171887.271 4.083.89 1501.3655 5585.2580 167.803.38 286.423892 49111499.1 1.048.602.19 551149.155 1599751.3464 48.062.896.88

110 167803.379 4.119.56 1465.69435 5585.2580 163.683.81 287.130291 48062896.9 1.064.315.45 539381.316 1603696.7648 46.998.581.43

111 163683.815 4.155.55 1429.71164 5585.2580 159.528.27 287.838432 46998581.4 1.080.214.78 527437.137 1607651.9137 45.918.366.65

112 159528.269 4.191.84 1393.41463 5585.2580 155.336.43 288.548319 45918366.7 1.096.302.29 515314.529 1611616.8170 44.822.064.36

Page 11: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

113 155336.425 4.228.46 1356.80058 5585.2580 151.107.97 289.259957 44822064.4 1.112.580.12 503011.38 1615591.4989 43.709.484.25

114 151107.968 4.265.39 1319.86672 5585.2580 146.842.58 289.97335 43709484.2 1.129.050.43 490525.555 1619575.9833 42.580.433.82

115 146842.576 4.302.65 1282.61026 5585.2580 142.539.93 290.688503 42580433.8 1.145.715.40 477854.893 1623570.2946 41.434.718.41

116 142539.929 4.340.23 1245.02838 5585.2580 138.199.70 291.405419 41434718.4 1.162.577.25 464997.21 1627574.4570 40.272.141.17

117 138199.699 4.378.14 1207.11824 5585.2580 133.821.56 292.124103 40272141.2 1.179.638.20 451950.297 1631588.4946 39.092.502.97

118 133821.559 4.416.38 1168.87696 5585.2580 129.405.18 292.84456 39092503 1.196.900.51 438711.919 1635612.4320 37.895.602.46

119 129405.178 4.454.96 1130.30167 5585.2580 124.950.22 293.566794 37895602.5 1.214.366.48 425279.816 1639646.2935 36.681.235.98

120 124950.222 4.493.87 1091.38943 5585.2580 120.456.35 294.290809 36681236 1.232.038.40 411651.703 1643690.1036 35.449.197.58

121 120456.353 4.533.12 1052.13732 5585.2580 115.923.23 295.016609 35449197.6 1.249.918.62 397825.268 1647743.8868 34.199.278.96

122 115923.232 4.572.72 1012.54235 5585.2580 111.350.52 295.7442 34199279 1.268.009.49 383798.175 1651807.6678 32.931.269.47

123 111350.517 4.612.66 972.601536 5585.2580 106.737.86 296.473585 32931269.5 1.286.313.41 369568.058 1655881.4711 31.644.956.05

124 106737.86 4.652.95 932.311855 5585.2580 102.084.91 297.204769 31644956.1 1.304.832.79 355132.528 1659965.3215 30.340.123.26

125 102084.914 4.693.59 891.67026 5585.2580 97.391.33 297.937756 30340123.3 1.323.570.08 340489.165 1664059.2438 29.016.553.18

126 97391.3263 4.734.58 850.673677 5585.2580 92.656.74 298.672551 29016553.2 1.342.527.74 325635.525 1668163.2628 27.674.025.44

127 92656.7419 4.775.94 809.319006 5585.2580 87.880.80 299.409158 27674025.4 1.361.708.27 310569.134 1672277.4035 26.312.317.17

128 87880.8029 4.817.65 767.603118 5585.2580 83.063.15 300.147581 26312317.2 1.381.114.20 295287.492 1676401.6907 24.931.202.98

129 83063.148 4.859.74 725.522859 5585.2580 78.203.41 300.887826 24931203 1.400.748.08 279788.068 1680536.1495 23.530.454.90

130 78203.4128 4.902.18 683.075046 5585.2580 73.301.23 301.629897 23530454.9 1.420.612.50 264068.306 1684680.8050 22.109.842.40

131 73301.2298 4.945.00 640.256469 5585.2580 68.356.23 302.373798 22109842.4 1.440.710.07 248125.616 1688835.6823 20.669.132.33

132 68356.2283 4.988.19 597.063889 5585.2580 63.368.03 303.119533 20669132.3 1.461.043.42 231957.384 1693000.8067 19.208.088.91

133 63368.0341 5.031.76 553.494039 5585.2580 58.336.27 303.867108 19208088.9 1.481.615.24 215560.962 1697176.2034 17.726.473.66

134 58336.2701 5.075.71 509.543625 5585.2580 53.260.56 304.616526 17726473.7 1.502.428.22 198933.675 1701361.8978 16.224.045.44

135 53260.5557 5.120.05 465.209321 5585.2580 48.140.51 305.367792 16224045.4 1.523.485.10 182072.816 1705557.9152 14.700.560.34

136 48140.507 5.164.77 420.487775 5585.2580 42.975.74 306.120912 14700560.3 1.544.788.63 164975.649 1709764.2812 13.155.771.71

137 42975.7367 5.209.88 375.375605 5585.2580 37.765.85 306.875888 13155771.7 1.566.341.62 147639.404 1713981.0211 11.589.430.09

138 37765.8543 5.255.39 329.869398 5585.2580 32.510.47 307.632727 11589430.1 1.588.146.88 130061.284 1718208.1607 10.001.283.22

139 32510.4657 5.301.29 283.965713 5585.2580 27.209.17 308.391432 10001283.2 1.610.207.27 112238.455 1722445.7256 8.391.075.95

140 27209.1733 5.347.60 237.661077 5585.2580 21.861.58 309.152009 8391075.95 1.632.525.68 94168.0565 1726693.7414 6.758.550.26

141 21861.5764 5.394.31 190.95199 5585.2580 16.467.27 309.914461 6758550.26 1.655.105.04 75847.1914 1730952.2340 5.103.445.22

142 16467.2704 5.441.42 143.834918 5585.2580 11.025.85 310.678794 5103445.22 1.677.948.30 57272.9315 1735221.2291 3.425.496.92

Page 12: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

143 11025.8472 5.488.95 96.3062972 5585.2580 5.536.90 311.445012 3425496.92 1.701.058.44 38442.3153 1739500.7528 1.724.438.48

144 5536.8955 5.536.90 48.3625332 5585.2580 0.00 312.213119 1724438.48 1.724.438.48 19352.3478 1743790.8309 0.00

monto $ 100.000.000.00 UVR 3.00% 0.25% Reflejo de inflacion UVR 218.98

plazo en meses 144 Spread 0.00% 0.00%

tasa UVR Cf 3.00% 0.25%

forma de pago CUMV en UVR

no. saldo inicial abono a k intereses cuota saldo final UVR saldo inicial abono a k intereses cuota saldo final

0 456662.709 456662.709 218.98 100000000 100000000

1 456662.709 2.645.27 1126.25344 3771.5256 454.017.44 219.520064 100000000 32.543.681.63 1122240.55 33665922.1755 67.456.318.37

2 454017.437 2.651.80 1119.72948 3771.5256 451.365.64 220.061459 67456318.4 72.945.28 757022.156 829967.4343 67.383.373.09

3 451365.641 2.658.34 1113.18944 3771.5256 448.707.30 220.60419 67383373.1 75.810.82 756203.534 832014.3579 67.307.562.27

4 448707.304 2.664.89 1106.63326 3771.5256 446.042.41 221.14826 67307562.3 78.713.58 755352.754 834066.3297 67.228.848.69

5 446042.412 2.671.46 1100.06092 3771.5256 443.370.95 221.693671 67228848.7 81.653.96 754469.399 836123.3623 67.147.194.73

6 443370.947 2.678.05 1093.47237 3771.5256 440.692.89 222.240427 67147194.7 84.632.42 753553.045 838185.4681 67.062.562.31

7 440692.894 2.684.66 1086.86756 3771.5256 438.008.24 222.788532 67062562.3 87.649.39 752603.265 840252.6595 66.974.912.91

8 438008.236 2.691.28 1080.24647 3771.5256 435.316.96 223.337989 66974912.9 90.705.32 751619.628 842324.9493 66.884.207.59

9 435316.957 2.697.92 1073.60905 3771.5256 432.619.04 223.888801 66884207.6 93.800.65 750601.696 844402.3498 66.790.406.94

10 432619.04 2.704.57 1066.95526 3771.5256 429.914.47 224.440971 66790406.9 96.935.85 749549.028 846484.8738 66.693.471.09

11 429914.47 2.711.24 1060.28506 3771.5256 427.203.23 224.994503 66693471.1 100.111.36 748461.174 848572.5339 66.593.359.73

12 427203.229 2.717.93 1053.59841 3771.5256 424.485.30 225.5494 66593359.7 103.327.66 747337.684 850665.3427 66.490.032.07

13 424485.302 2.724.63 1046.89527 3771.5256 421.760.67 226.105666 66490032.1 106.585.21 746178.099 852763.3129 66.383.446.86

14 421760.672 2.731.35 1040.1756 3771.5256 419.029.32 226.663303 66383446.9 109.884.50 744981.957 854866.4573 66.273.562.36

15 419029.322 2.738.09 1033.43935 3771.5256 416.291.24 227.222316 66273562.4 113.226.00 743748.788 856974.7886 66.160.336.36

16 416291.235 2.744.84 1026.68649 3771.5256 413.546.40 227.782708 66160336.4 116.610.20 742478.12 859088.3196 66.043.726.16

17 413546.396 2.751.61 1019.91698 3771.5256 410.794.79 228.344481 66043726.2 120.037.59 741169.473 861207.0632 65.923.688.57

18 410794.788 2.758.39 1013.13077 3771.5256 408.036.39 228.90764 65923688.6 123.508.67 739822.363 863331.0321 65.800.179.90

19 408036.393 2.765.20 1006.32782 3771.5256 405.271.19 229.472188 65800179.9 127.023.94 738436.298 865460.2393 65.673.155.96

Page 13: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

20 405271.195 2.772.02 999.508098 3771.5256 402.499.18 230.038129 65673156 130.583.91 737010.784 867594.6978 65.542.572.04

21 402499.177 2.778.85 992.671555 3771.5256 399.720.32 230.605465 65542572 134.189.10 735545.318 869734.4203 65.408.382.94

22 399720.323 2.785.71 985.818151 3771.5256 396.934.62 231.1742 65408382.9 137.840.03 734039.394 871879.4200 65.270.542.92

23 396934.616 2.792.58 978.947845 3771.5256 394.142.04 231.744338 65270542.9 141.537.21 732492.497 874029.7099 65.129.005.70

24 394142.038 2.799.47 972.060595 3771.5256 391.342.57 232.315882 65129005.7 145.281.19 730904.109 876185.3030 64.983.724.51

25 391342.573 2.806.37 965.156359 3771.5256 388.536.20 232.888836 64983724.5 149.072.51 729273.705 878346.2123 64.834.652.00

26 388536.204 2.813.29 958.235095 3771.5256 385.722.91 233.463202 64834652 152.911.70 727600.753 880512.4510 64.681.740.30

27 385722.913 2.820.23 951.296761 3771.5256 382.902.68 234.038986 64681740.3 156.799.32 725884.716 882684.0322 64.524.940.99

28 382902.684 2.827.18 944.341316 3771.5256 380.075.50 234.616189 64524941 160.735.92 724125.05 884860.9692 64.364.205.07

29 380075.5 2.834.16 937.368717 3771.5256 377.241.34 235.194816 64364205.1 164.722.07 722321.206 887043.2751 64.199.483.00

30 377241.343 2.841.15 930.378922 3771.5256 374.400.20 235.77487 64199483 168.758.33 720472.629 889230.9631 64.030.724.66

31 374400.196 2.848.15 923.371887 3771.5256 371.552.04 236.356354 64030724.7 172.845.29 718578.754 891424.0465 63.857.879.37

32 371552.043 2.855.18 916.347572 3771.5256 368.696.86 236.939272 63857879.4 176.983.52 716639.014 893622.5387 63.680.895.85

33 368696.865 2.862.22 909.305932 3771.5256 365.834.64 237.523629 63680895.8 181.173.62 714652.833 895826.4529 63.499.722.23

34 365834.645 2.869.28 902.246927 3771.5256 362.965.37 238.109426 63499722.2 185.416.17 712619.629 898035.8027 63.314.306.05

35 362965.366 2.876.36 895.170511 3771.5256 360.089.01 238.696668 63314306.1 189.711.79 710538.814 900250.6012 63.124.594.27

36 360089.011 2.883.45 888.076644 3771.5256 357.205.56 239.285358 63124594.3 194.061.07 708409.791 902470.8621 62.930.533.20

37 357205.562 2.890.56 880.96528 3771.5256 354.315.00 239.875501 62930533.2 198.464.64 706231.959 904696.5987 62.732.068.56

38 354315.002 2.897.69 873.836379 3771.5256 351.417.31 240.467098 62732068.6 202.923.12 704004.709 906927.8245 62.529.145.44

39 351417.313 2.904.84 866.689895 3771.5256 348.512.48 241.060155 62529145.4 207.437.13 701727.423 909164.5532 62.321.708.31

40 348512.477 2.912.00 859.525787 3771.5256 345.600.48 241.654675 62321708.3 212.007.32 699399.48 911406.7983 62.109.700.99

41 345600.477 2.919.18 852.34401 3771.5256 342.681.30 242.25066 62109701 216.634.33 697020.248 913654.5733 61.893.066.67

42 342681.295 2.926.38 845.14452 3771.5256 339.754.91 242.848116 61893066.7 221.318.80 694589.089 915907.8920 61.671.747.86

43 339754.914 2.933.60 837.927275 3771.5256 336.821.32 243.447045 61671747.9 226.061.41 692105.36 918166.7679 61.445.686.46

44 336821.316 2.940.83 830.69223 3771.5256 333.880.48 244.047451 61445686.5 230.862.81 689568.407 920431.2149 61.214.823.65

45 333880.483 2.948.09 823.439342 3771.5256 330.932.40 244.649338 61214823.6 235.723.68 686977.571 922701.2465 60.979.099.97

46 330932.396 2.955.36 816.168565 3771.5256 327.977.04 245.252709 60979100 240.644.69 684332.185 924976.8767 60.738.455.28

47 327977.039 2.962.65 808.879858 3771.5256 325.014.39 245.857568 60738455.3 245.626.55 681631.572 927258.1192 60.492.828.73

48 325014.393 2.969.95 801.573174 3771.5256 322.044.44 246.463919 60492828.7 250.669.94 678875.052 929544.9879 60.242.158.80

Page 14: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

49 322044.441 2.977.28 794.24847 3771.5256 319.067.16 247.071766 60242158.8 255.775.56 676061.932 931837.4966 59.986.383.23

50 319067.164 2.984.62 786.905701 3771.5256 316.082.54 247.681111 59986383.2 260.944.14 673191.515 934135.6593 59.725.439.09

51 316082.544 2.991.98 779.544823 3771.5256 313.090.56 248.29196 59725439.1 266.176.40 670263.094 936439.4898 59.459.262.69

52 313090.563 2.999.36 772.165792 3771.5256 310.091.20 248.904315 59459262.7 271.473.05 667275.954 938749.0022 59.187.789.64

53 310091.203 3.006.76 764.768561 3771.5256 307.084.45 249.51818 59187789.6 276.834.84 664229.374 941064.2105 58.910.954.81

54 307084.446 3.014.17 757.353087 3771.5256 304.070.27 250.133559 58910954.8 282.262.51 661122.621 943385.1287 58.628.692.30

55 304070.274 3.021.61 749.919324 3771.5256 301.048.67 250.750456 58628692.3 287.756.81 657954.957 945711.7709 58.340.935.49

56 301048.667 3.029.06 742.467228 3771.5256 298.019.61 251.368874 58340935.5 293.318.52 654725.633 948044.1513 58.047.616.97

57 298019.609 3.036.53 734.996753 3771.5256 294.983.08 251.988818 58047617 298.948.39 651433.894 950382.2839 57.748.668.58

58 294983.08 3.044.02 727.507854 3771.5256 291.939.06 252.61029 57748668.6 304.647.21 648078.974 952726.1830 57.444.021.37

59 291939.062 3.051.53 720.000485 3771.5256 288.887.54 253.233295 57444021.4 310.415.76 644660.099 955075.8628 57.133.605.60

60 288887.537 3.059.05 712.4746 3771.5256 285.828.49 253.857837 57133605.6 316.254.85 641176.488 957431.3375 56.817.350.75

61 285828.486 3.066.60 704.930155 3771.5256 282.761.89 254.483919 56817350.8 322.165.27 637627.347 959792.6215 56.495.185.48

62 282761.891 3.074.16 697.367104 3771.5256 279.687.73 255.111545 56495185.5 328.147.85 634011.878 962159.7290 56.167.037.63

63 279687.732 3.081.74 689.785399 3771.5256 276.605.99 255.740719 56167037.6 334.203.40 630329.27 964532.6745 55.832.834.22

64 276605.992 3.089.34 682.184996 3771.5256 273.516.65 256.371444 55832834.2 340.332.77 626578.704 966911.4723 55.492.501.46

65 273516.651 3.096.96 674.565849 3771.5256 270.419.69 257.003725 55492501.5 346.536.79 622759.351 969296.1368 55.145.964.67

66 270419.691 3.104.60 666.927911 3771.5256 267.315.09 257.637566 55145964.7 352.816.31 618870.375 971686.6826 54.793.148.36

67 267315.094 3.112.25 659.271135 3771.5256 264.202.84 258.27297 54793148.4 359.172.20 614910.927 974083.1241 54.433.976.17

68 264202.839 3.119.93 651.595476 3771.5256 261.082.91 258.90994 54433976.2 365.605.32 610880.151 976485.4758 54.068.370.84

69 261082.909 3.127.62 643.900887 3771.5256 257.955.28 259.548482 54068370.8 372.116.57 606777.18 978893.7525 53.696.254.27

70 257955.284 3.135.34 636.18732 3771.5256 254.819.95 260.188599 53696254.3 378.706.83 602601.137 981307.9685 53.317.547.44

71 254819.946 3.143.07 628.45473 3771.5256 251.676.88 260.830294 53317547.4 385.377.00 598351.136 983728.1387 52.932.170.43

72 251676.875 3.150.82 620.703069 3771.5256 248.526.05 261.473572 52932170.4 392.128.00 594026.279 986154.2777 52.540.042.44

73 248526.053 3.158.59 612.932291 3771.5256 245.367.46 262.118436 52540042.4 398.960.74 589625.659 988586.4002 52.141.081.69

74 245367.459 3.166.38 605.142348 3771.5256 242.201.08 262.764891 52141081.7 405.876.16 585148.36 991024.5209 51.735.205.53

75 242201.076 3.174.19 597.333192 3771.5256 239.026.88 263.41294 51735205.5 412.875.20 580593.453 993468.6547 51.322.330.33

76 239026.883 3.182.02 589.504778 3771.5256 235.844.86 264.062588 51322330.3 419.958.82 575960 995918.8165 50.902.371.52

77 235844.863 3.189.87 581.657056 3771.5256 232.654.99 264.713837 50902371.5 427.127.97 571247.052 998375.0209 50.475.243.55

Page 15: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

78 232654.994 3.197.74 573.789979 3771.5256 229.457.26 265.366693 50475243.5 434.383.63 566453.649 1000837.2831 50.040.859.91

79 229457.258 3.205.62 565.9035 3771.5256 226.251.64 266.021159 50040859.9 441.726.80 561578.82 1003305.6178 49.599.133.11

80 226251.636 3.213.53 557.997572 3771.5256 223.038.11 266.677239 49599133.1 449.158.46 556621.582 1005780.0401 49.149.974.66

81 223038.108 3.221.45 550.072144 3771.5256 219.816.65 267.334937 49149974.7 456.679.62 551580.944 1008260.5650 48.693.295.04

82 219816.655 3.229.40 542.127171 3771.5256 216.587.26 267.994257 48693295 464.291.31 546455.9 1010747.2076 48.229.003.73

83 216587.256 3.237.36 534.162603 3771.5256 213.349.89 268.655203 48229003.7 471.994.55 541245.435 1013239.9829 47.757.009.18

84 213349.893 3.245.35 526.178393 3771.5256 210.104.55 269.317779 47757009.2 479.790.39 535948.521 1015738.9060 47.277.218.79

85 210104.546 3.253.35 518.174491 3771.5256 206.851.19 269.981989 47277218.8 487.679.87 530564.118 1018243.9922 46.789.538.92

86 206851.195 3.261.37 510.150849 3771.5256 203.589.82 270.647838 46789538.9 495.664.08 525091.177 1020755.2565 46.293.874.84

87 203589.82 3.269.42 502.107419 3771.5256 200.320.40 271.315328 46293874.8 503.744.08 519528.634 1023272.7144 45.790.130.76

88 200320.402 3.277.48 494.044152 3771.5256 197.042.92 271.984465 45790130.8 511.920.97 513875.413 1025796.3809 45.278.209.79

89 197042.92 3.285.56 485.960998 3771.5256 193.757.36 272.655252 45278209.8 520.195.84 508130.429 1028326.2716 44.758.013.95

90 193757.356 3.293.67 477.85791 3771.5256 190.463.69 273.327694 44758014 528.569.82 502292.58 1030862.4016 44.229.444.13

91 190463.688 3.301.79 469.734837 3771.5256 187.161.90 274.001793 44229444.1 537.044.03 496360.755 1033404.7863 43.692.400.10

92 187161.897 3.309.93 461.59173 3771.5256 183.851.96 274.677556 43692400.1 545.619.61 490333.829 1035953.4413 43.146.780.49

93 183851.963 3.318.10 453.42854 3771.5256 180.533.87 275.354985 43146780.5 554.297.72 484210.665 1038508.3820 42.592.482.77

94 180533.866 3.326.28 445.245217 3771.5256 177.207.59 276.034084 42592482.8 563.079.51 477990.111 1041069.6238 42.029.403.26

95 177207.586 3.334.48 437.041712 3771.5256 173.873.10 276.714859 42029403.3 571.966.18 471671.005 1043637.1824 41.457.437.08

96 173873.102 3.342.71 428.817976 3771.5256 170.530.39 277.397312 41457437.1 580.958.90 465252.168 1046211.0732 40.876.478.17

97 170530.394 3.350.95 420.573957 3771.5256 167.179.44 278.081449 40876478.2 590.058.90 458732.412 1048791.3119 40.286.419.27

98 167179.443 3.359.22 412.309606 3771.5256 163.820.23 278.767273 40286419.3 599.267.38 452110.532 1051377.9142 39.687.151.89

99 163820.227 3.367.50 404.024873 3771.5256 160.452.73 279.454788 39687151.9 608.585.59 445385.31 1053970.8958 39.078.566.31

100 160452.726 3.375.81 395.719708 3771.5256 157.076.92 280.143999 39078566.3 618.014.76 438555.516 1056570.2724 38.460.551.55

101 157076.92 3.384.13 387.39406 3771.5256 153.692.79 280.83491 38460551.5 627.556.16 431619.904 1059176.0597 37.832.995.39

102 153692.788 3.392.48 379.047878 3771.5256 150.300.31 281.527524 37832995.4 637.211.06 424577.214 1061788.2736 37.195.784.33

103 150300.311 3.400.84 370.681113 3771.5256 146.899.47 282.221847 37195784.3 646.980.76 417426.173 1064406.9299 36.548.803.58

104 146899.466 3.409.23 362.293713 3771.5256 143.490.23 282.917882 36548803.6 656.866.55 410165.493 1067032.0446 35.891.937.03

105 143490.234 3.417.64 353.885627 3771.5256 140.072.59 283.615634 35891937 666.869.76 402793.87 1069663.6334 35.225.067.26

106 140072.594 3.426.07 345.456805 3771.5256 136.646.53 284.315107 35225067.3 676.991.73 395309.987 1072301.7125 34.548.075.54

Page 16: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

107 136646.525 3.434.52 337.007195 3771.5256 133.212.01 285.016305 34548075.5 687.233.79 387712.512 1074946.2978 33.860.841.75

108 133212.007 3.442.99 328.536746 3771.5256 129.769.02 285.719232 33860841.8 697.597.31 380000.095 1077597.4054 33.163.244.44

109 129769.018 3.451.48 320.045407 3771.5256 126.317.54 286.423892 33163244.4 708.083.68 372171.375 1080255.0513 32.455.160.76

110 126317.538 3.459.99 311.533125 3771.5256 122.857.55 287.130291 32455160.8 718.694.28 364224.973 1082919.2517 31.736.466.49

111 122857.545 3.468.53 302.99985 3771.5256 119.389.02 287.838432 31736466.5 729.430.53 356159.495 1085590.0227 31.007.035.96

112 119389.02 3.477.08 294.44553 3771.5256 115.911.94 288.548319 31007036 740.293.85 347973.53 1088267.3805 30.266.742.11

113 115911.939 3.485.66 285.870112 3771.5256 112.426.28 289.259957 30266742.1 751.285.69 339665.652 1090951.3415 29.515.456.42

114 112426.284 3.494.25 277.273546 3771.5256 108.932.03 289.97335 29515456.4 762.407.50 331234.419 1093641.9218 28.753.048.92

115 108932.032 3.502.87 268.655777 3771.5256 105.429.16 290.688503 28753048.9 773.660.76 322678.373 1096339.1378 27.979.388.15

116 105429.162 3.511.51 260.016755 3771.5256 101.917.65 291.405419 27979388.2 785.046.97 313996.038 1099043.0059 27.194.341.18

117 101917.653 3.520.17 251.356427 3771.5256 98.397.48 292.124103 27194341.2 796.567.62 305185.923 1101753.5424 26.397.773.56

118 98397.4839 3.528.85 242.67474 3771.5256 94.868.63 292.84456 26397773.6 808.224.25 296246.518 1104470.7639 25.589.549.32

119 94868.633 3.537.55 233.971642 3771.5256 91.331.08 293.566794 25589549.3 820.018.39 287176.298 1107194.6868 24.769.530.93

120 91331.079 3.546.28 225.247079 3771.5256 87.784.80 294.290809 24769530.9 831.951.61 277973.719 1109925.3275 23.937.579.32

121 87784.8005 3.555.02 216.501 3771.5256 84.229.78 295.016609 23937579.3 844.025.48 268637.221 1112662.7028 23.093.553.84

122 84229.7759 3.563.79 207.73335 3771.5256 80.665.98 295.7442 23093553.8 856.241.60 259165.225 1115406.8292 22.237.312.23

123 80665.9836 3.572.58 198.944077 3771.5256 77.093.40 296.473585 22237312.2 868.601.59 249556.134 1118157.7234 21.368.710.64

124 77093.402 3.581.39 190.133127 3771.5256 73.512.01 297.204769 21368710.6 881.107.07 239808.335 1120915.4020 20.487.603.58

125 73512.0095 3.590.23 181.300447 3771.5256 69.921.78 297.937756 20487603.6 893.759.69 229920.194 1123679.8817 19.593.843.89

126 69921.7843 3.599.08 172.445983 3771.5256 66.322.70 298.672551 19593843.9 906.561.12 219890.061 1126451.1795 18.687.282.77

127 66322.7047 3.607.96 163.569682 3771.5256 62.714.75 299.409158 18687282.8 919.513.05 209716.264 1129229.3120 17.767.769.72

128 62714.7487 3.616.85 154.671489 3771.5256 59.097.89 300.147581 17767769.7 932.617.18 199397.116 1132014.2961 16.835.152.54

129 59097.8946 3.625.77 145.751351 3771.5256 55.472.12 300.887826 16835152.5 945.875.24 188930.908 1134806.1487 15.889.277.30

130 55472.1203 3.634.72 136.809214 3771.5256 51.837.40 301.629897 15889277.3 959.288.97 178315.912 1137604.8868 14.929.988.33

131 51837.4039 3.643.68 127.845022 3771.5256 48.193.72 302.373798 14929988.3 972.860.14 167550.383 1140410.5274 13.957.128.18

132 48193.7233 3.652.67 118.858723 3771.5256 44.541.06 303.119533 13957128.2 986.590.54 156632.552 1143223.0874 12.970.537.65

133 44541.0564 3.661.68 109.850261 3771.5256 40.879.38 303.867108 12970537.6 1.000.481.95 145560.633 1146042.5839 11.970.055.70

134 40879.381 3.670.71 100.819582 3771.5256 37.208.67 304.616526 11970055.7 1.014.536.22 134332.818 1148869.0341 10.955.519.48

135 37208.675 3.679.76 91.7666304 3771.5256 33.528.92 305.367792 10955519.5 1.028.755.17 122947.282 1151702.4551 9.926.764.31

Page 17: Taller Amortizacion

Diego Hernán Ruiz Malpica. Taller Tablas de Amortización - Parcial. Matemática Financiera

136 33528.916 3.688.83 82.691352 3771.5256 29.840.08 306.120912 9926764.31 1.043.140.69 111402.174 1154542.8640 8.883.623.62

137 29840.0817 3.697.93 73.5936915 3771.5256 26.142.15 306.875888 8883623.62 1.057.694.65 99695.6262 1157390.2782 7.825.928.97

138 26142.1498 3.707.05 64.4735938 3771.5256 22.435.10 307.632727 7825928.97 1.072.418.97 87825.748 1160244.7148 6.753.510.00

139 22435.0977 3.716.19 55.3310034 3771.5256 18.718.90 308.391432 6753510 1.087.315.56 75790.6275 1163106.1913 5.666.194.43

140 18718.9031 3.725.36 46.1658649 3771.5256 14.993.54 309.152009 5666194.43 1.102.386.39 63588.3314 1165974.7250 4.563.808.04

141 14993.5434 3.734.55 36.9781227 3771.5256 11.259.00 309.914461 4563808.04 1.117.633.43 51216.9043 1168850.3332 3.446.174.61

142 11258.9958 3.743.76 27.7677211 3771.5256 7.515.24 310.678794 3446174.61 1.133.058.66 38674.3688 1171733.0334 2.313.115.95

143 7515.23794 3.752.99 18.5346042 3771.5256 3.762.25 311.445012 2313115.95 1.148.664.12 25958.725 1174622.8432 1.164.451.83

144 3762.24691 3.762.25 9.27871584 3771.5256 0.00 312.213119 1164451.83 1.164.451.83 13067.9506 1177519.7800 0.00