of 27/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

Taller Amortizacion

  • View
    246

  • Download
    0

Embed Size (px)

DESCRIPTION

f

Text of Taller Amortizacion

Punto 1tabla amortizacin

monto $ 175.000.000.00

plazo meses60

tasa13.91%EA1.091%MV

forma de pagoCuotas mesuales vencidas

noSaldo InicialAbono a KInteresesCuotaSaldo Final

0175000000.00175000000.00

1175000000.001424157.521909008.193333165.71173575842.48

2173575842.481464693.111893472.603358165.71172111149.38

3172111149.381505670.881877494.833383165.71170605478.49

4170605478.491547095.671861070.043408165.71169058382.82

5169058382.821588972.351844193.363433165.71167469410.47

6167469410.471631305.841826859.873458165.71165838104.63

7165838104.631674101.141809064.583483165.71164164003.49

8164164003.491717363.271790802.453508165.71162446640.23

9162446640.231761097.331772068.393533165.71160685542.90

10160685542.901805308.461752857.253558165.71158880234.44

11158880234.441850001.881733163.833583165.71157030232.55

12157030232.551895182.851712982.863608165.71155135049.70

13155135049.701940856.681692309.043633165.71153194193.03

14153194193.031987028.741671136.973658165.71151207164.29

15151207164.292033704.481649461.233683165.71149173459.81

16149173459.812080889.381627276.333708165.71147092570.42

17147092570.422128589.011604576.703733165.71144963981.41

18144963981.412176808.981581356.733758165.71142787172.44

19142787172.442225554.951557610.763783165.71140561617.48

20140561617.482274832.681533333.033808165.71138286784.80

21138286784.802324647.971508517.753833165.71135962136.83

22135962136.832375006.661483159.053858165.71133587130.17

23133587130.172425914.701457251.013883165.71131161215.46

24131161215.462477378.081430787.633908165.71128683837.38

25128683837.382529402.851403762.863933165.71126154434.53

26126154434.532581995.141376170.573958165.71123572439.39

27123572439.392635161.141348004.573983165.71120937278.24

28120937278.242688907.111319258.604008165.71118248371.13

29118248371.132743239.371289926.344033165.71115505131.76

30115505131.762798164.321260001.394058165.71112706967.44

31112706967.442853688.431229477.284083165.71109853279.01

32109853279.012909818.231198347.484108165.71106943460.79

33106943460.792966560.321166605.394133165.71103976900.46

34103976900.463023921.401134244.314158165.71100952979.07

35100952979.073081908.201101257.514183165.7197871070.87

3697871070.873140527.561067638.154208165.7194730543.31

3794730543.313199786.381033379.334233165.7191530756.93

3891530756.933259691.62998474.094258165.7188271065.31

3988271065.313320250.36962915.354283165.7184950814.95

4084950814.953381469.70926696.014308165.7181569345.25

4181569345.253443356.86889808.854333165.7178125988.39

4278125988.393505919.13852246.584358165.7174620069.26

4374620069.263569163.86814001.854383165.7171050905.40

4471050905.403633098.51775067.204408165.7167417806.89

4567417806.893697730.59735435.124433165.7163720076.30

4663720076.303763067.72695097.994458165.7159957008.58

4759957008.583829117.59654048.124483165.7156127890.98

4856127890.983895887.97612277.744508165.7152232003.01

4952232003.013963386.73569778.984533165.7148268616.28

5048268616.284031621.80526543.914558165.7144236994.48

5144236994.484100601.23482564.494583165.7140136393.25

5240136393.254170333.12437832.594608165.7135966060.13

5335966060.134240825.69392340.024633165.7131725234.44

5431725234.444312087.24346078.474658165.7127413147.20

5527413147.204384126.15299039.564683165.7123029021.05

5623029021.054456950.91251214.804708165.7118572070.14

5718572070.144530570.09202595.624733165.7114041500.05

5814041500.054604992.35153173.364758165.719436507.71

599436507.714680226.45102939.264783165.714756281.25

604756281.254756281.2551884.464808165.710.00

Punto 2GRADIENTE CRECIENTE

monto $ 1.000.000.00

plazo meses6

tasa18.00%NAMVIP1.5%

forma de pagoCuotas mensuales vencidas

noSaldo InicialAbono a KInteresesCuotaSaldo FinalGradiente

0 $ 1.000.000.00 $ 1.000.000.00

11000000.00140159.7215000.00155159.72859840.280.00

2859840.28150020.1012897.60162917.71709820.177757.99

3709820.17160416.2910647.30171063.59549403.888145.89

4549403.88171375.728241.06179616.77378028.178553.18

5378028.17182927.195670.42188597.61195100.988980.84

6195100.98195100.982926.51198027.490.009429.88

GRADIENTE DECRECIENTE

monto $ 1.000.000.00

plazo meses6

tasa18.00%NAMVIP1.5%

forma de pagoCuotas mensuales vencidas

noSaldo InicialAbono a KInteresesCuotaSaldo FinalGradiente

0 $ 1.000.000.00 $ 1.000.000.00

11000000.00183335.5415000.00198335.54816664.460.00

2816664.46176168.7912249.97188418.76640495.67-9916.78

3640495.67169390.399607.44178997.82471105.28-9420.94

4471105.28162981.357066.58170047.93308123.93-8949.89

5308123.93156923.684621.86161545.53151200.25-8502.40

6151200.25151200.252268.00153468.260.00-8077.28

Punto 3tabla amortizacion

monto $ 70.000.000.00 IP1.35%

plazo meses36EA 17.46%

tasa16.20%NAMV

forma de pagoCuotas uniformes mesuales vencidas

noAbono a KInteresesCuotaSaldo Final

070000000.0070000000.00

170000000.001522909.73945000.002467909.7368477090.27

268477090.271543469.01924440.722467909.7366933621.26

366933621.261564305.84903603.892467909.7365369315.42

465369315.421585423.97882485.762467909.7363783891.45

563783891.451606827.19861082.532467909.7362177064.26

662177064.261628519.36839390.372467909.7360548544.90

760548544.901650504.37817405.362467909.7358898040.53

858898040.531672786.18795123.552467909.7357225254.35

957225254.351695368.79772540.932467909.7355529885.55

1055529885.551718256.27749653.452467909.7353811629.28

1153811629.281741452.73726457.002467909.7352070176.55

1252070176.551764962.34702947.382467909.7350305214.20

1350305214.201788789.34679120.392467909.7348516424.87

1448516424.871812937.99654971.742467909.7346703486.87

1546703486.871837412.66630497.072467909.7344866074.22

1644866074.221862217.73605692.002467909.7343003856.49

1743003856.491887357.67580552.062467909.7341116498.83

1841116498.831912836.99555072.732467909.7339203661.83

1939203661.831938660.29529249.432467909.7337265001.54

2037265001.541964832.21503077.522467909.7335300169.33

2135300169.331991357.44476552.292467909.7333308811.89

2233308811.892018240.77449668.962467909.7331290571.12

2331290571.122045487.02422422.712467909.7329245084.11

2429245084.112073101.09394808.642467909.7327171983.01

2527171983.012101087.96366821.772467909.7325070895.06

2625070895.062129452.64338457.082467909.7322941442.41

2722941442.412158200.26309709.472467909.7320783242.16

2820783242.162187335.96280573.772467909.7318595906.20

2918595906.202216864.99251044.732467909.7316379041.20

3016379041.202246792.67221117.062467909.7314132248.53

3114132248.532277124.37190785.362467909.7311855124.16

3211855124.162307865.55160044.182467909.739547258.61

339547258.612339021.74128887.992467909.737208236.87

347208236.872370598.5397311.202467909.734837638.34

354837638.342402601.6165308.122467909.732435036.73

362435036.732435036.7332873.002467909.730.00

88844750.2

tabla amortizacion

monto $ 70.000.000.00 IP4%

plazo meses30EA17%

tasa16.00%NATV

forma de pagoAbono a K uniforme

noNo. Saldo inicialAbono a KInteresesCuotaSaldo Final

070000000.0070000000.00

170000000.002333333.332800000.005133333.3367666666.67

267666666.672333333.332706666.675040000.0065333333.33

365333333.332333333.332613333.334946666.6763000000.00

463000000.002333333.332520000.004853333.3360666666.67

560666666.672333333.332426666.674760000.0058333333.33

658333333.332333333.332333333.334666666.6756000000.00

756000000.002333333.332240000.004573333.3353666666.67

853666666.672333333.332146666.674480000.0051333333.33

951333333.332333333.332053333.334386666.6749000000.00

1049000000.002333333.331960000.004293333.3346666666.67

1146666666.672333333.331866666.674200000.0044333333.33

1244333333.332333333.331773333.334106666.6742000000.00

1342000000.002333333.331680000.004013333.3339666666.67

1439666666.672333333.331586666.673920000.0037333333.33

1537333333.332333333.331493333.333826666.6735000000.00

1635000000.002333333.331400000.003733333.3332666666.67

1732666666.672333333.331306666.673640000.0030333333.33

1830333333.332333333.331213333.333546666.6728000000.00

1928000000.002333333.331120000.003453333.3325666666.67

2025666666.672333333.331026666.673360000.0023333333.33

2123333333.332333333.33933333.333266666.6721000000.00

2221000000.002333333.33840000.003173333.3318666666.67

2318666666.672333333.33746666.673080000.0016333333.33

2416333333.332333333.33653333.332986666.6714000000.00

2514000000.002333333.33560000.002893333.3311666666.67

2611666666.672333333.33466666.672800000.009333333.33

279333333.332333333.33373333.332706666.677000000.00

287000000.002333333.33280000.002613333.334666666.67

294666666.672333333.33186666.672520000.002333333.33

302333333.332333333.3393333.332426666.670.00

113400000

Diego Hernn Ruiz Malpica. Taller Tablas de Amortizacin - Parcial. Matemtica Financiera

Punto 4monto $ 100.000.000.00 UVR3.00%0.25%Reflejo de inflacinUVR218.98

plazo en meses144Spread11.00%0.87%

tasaUVR+11%EACf14.33%1.12%

forma de pagoCUMV en UVR

no.saldo inicialabono a kintereses cuota saldo finalUVRsaldo inicialabono a kintereses cuota saldo final

0456662.709456662.709218.98100000000100000000

1456662.7091.596.493988.763285585.2580455.066.21219.520064100000000103.835.651122240.551226076.199599.896.164.35

2455066.2141.610.443974.818545585.2580453.455.77220.06145999896164.3108.024.771121075.261229100.034299.788.139.57

3453455.7751.624.513960.752015585.2580451.831.27220.6041999788139.6112.268.361119862.961232131.326499.675.871.21

4451831.2691.638.703946.562615585.2580450.192.57221.1482699675871.2116.567.051118603.041235170.094799.559.304.16

5450192.5731.653.013932.249275585.2580448.539.56221.69367199559304.2120.921.481117294.881238216.357499.438.382.68

6448539.5641.667.453917.810915585.2580446.872.12222.24042799438382.7125.332.281115937.851241270.132999.313.050.39

7446872.1171.682.013903.246445585.2580445.190.11222.78853299313050.4129.800.121114531.321244331.439999.183.250.27

8445190.1061.696.703888.554755585.2580443.493.40223.33798999183250.3134.325.651113074.651247400.297099.048.924.62

9443493.4021.711.523873.734735585.2580441.781.88223.88880199048924.6138.909.531111567.191250476.722698.910.015.09

10441781.8791.726.473858.785275585.2580440.055.41224.44097198910015.1143.552.441110008.291253560.735598.766.462.65

11440055.4061.741.553843.705235585.2580438.313.85224.99450398766462.7148.255.061108397.291256652.354598.618.207.59

12438313.8541.756.763828.493485585.2580436.557.09225.549498618207.6153.018.091106733.511259751.598298.465.189.50

13436557.0891.772.113813.148855585.2580434.784.98226.10566698465189.5157.842.211105016.281262858.485598.307.347.30

14434784.981.787.593797.67025585.2580432.997.39226.66330398307347.3162.728.121103244.911265973.035298.144.619.17

15432997.3921.803.203782.056355585.2580431.194.19227.22231698144619.2167.676.561101418.711269095.266297.976.942.61

16431194.191.818.953766.306115585.2580429.375.24227.78270897976942.6172.688.221099536.981272225.197597.804.254.39

17429375.2381.834.843750.418315585.2580427.540.40228.34448197804254.4177.763.8510975991275362.848197.626.490.54

18427540.3991.850.873734.391735585.2580425.689.53228.9076497626490.5182.904.181095604.061278508.236997.443.586.37

19425689.5321.867.033718.225165585.2580423.822.50229.47218897443586.4188.109.951093551.441281661.383197.255.476.42

20423822.51.883.343701.917395585.2580421.939.16230.03812997255476.4193.381.921091440.391284822.305997.062.094.50

21421939.1591.899.793685.467175585.2580420.039.37230.60546597062094.5198.720.841089270.181287991.024396.863.373.66

22420039.3681.916.383668.873275585.2580418.122.98231.174296863373.7204.127.501087040.051291167.557696.659.246.15

23418122.9831.933.123652.134435585.2580416.189.86231.74433896659246.2209.602.671084749.251294351.925196.449.643.48

24416189.861.950.013635.249385585.2580414.239.85232.31588296449643.5215.147.141082397.011297544.146296.234.496.34

25414239.8511.967.043618.216845585.2580412.272.81232.88883696234496.3220.761.701079982.541300744.240196.013.734.64

26412272.811.984.223601.035545585.2580410.288.59233.46320296013734.6226.447.171077505.061303952.226395.787.287.47

27410288.5872.001.553583.704165585.2580408.287.03234.03898695787287.5232.204.351074963.781307168.124295.555.083.13

28408287.0332.019.043566.22145585.2580406.268.00234.61618995555083.1238.034.071072357.891310391.953595.317.049.06

29406267.9972.036.673548.585945585.2580404.231.32235.19481695317049.1243.937.161069686.571313623.733595.073.111.90

30404231.3252.054.463530.796435585.2580402.176.86235.7748795073111.9249.914.471066949.011316863.484094.823.197.42

31402176.8632.072.413512.851545585.2580400.104.46236.35635494823197.4255.966.861064144.371320111.224694.567.230.57

32400104.4572.090.513494.749925585.2580398.013.95236.93927294567230.6262.095.171061271.81323366.975094.305.135.40

33398013.9482.108.773476.490185585.2580395.905.18237.52362994305135.4268.300.291058330.471326630.755094.036.835.11

34395905.1812.127.193458.070955585.2580393.777.99238.10942694036835.1274.583.091055319.491329902.584393.762.252.02

35393777.9942.145.773439.490835585.2580391.632.23238.69666893762252280.944.471052238.011333182.482993.481.307.54

36391632.2262.164.513420.748435585.2580389.467.72239.28535893481307.5287.385.331049085.141336470.470593.193.922.21

37389467.7172.183.423401.842315585.2580387.284.30239.87550193193922.2293.906.591045859.981339766.567392.900.015.62

38387284.3012.202.493382.771065585.2580385.081.81240.46709892900015.6300.509.151042561.641343070.793092.599.506.47

39385081.8142.221.723363.533235585.2580382.860.09241.06015592599506.5307.193.961039189.211346383.167992.292.312.51

40382860.0892.241.133344.127375585.2580380.618.96241.65467592292312.5313.961.961035741.751349703.712191.978.350.55

41380618.9592.260.713324.5525585.2580378.358.25242.2506691978350.6320.814.101032218.341353032.445591.657.536.45

42378358.2532.280.453304.805665585.2580376.077.80242.84811691657536.4327.751.351028618.041356369.388591.329.785.10

43376077.82.300.373284.886835585.2580373.777.43243.44704591329785.1334.774.681024939.881359714.561490.995.010.41

44373777.4292.320.463264.794025585.2580371.456.96244.04745190995010.4341.885.081021182.91363067.984390.653.125.33

45371456.9652.340.733244.525715585.2580369.116.23244.64933890653125.3349.083.551017346.131366429.677790.304.041.78

46369116.2332.361.183224.080375585.2580366.755.05245.25270990304041.8356.371.091013428.571369799.661989.947.670.69

47366755.0552.381.803203.456445585.2580364.373.25245.85756889947670.7363.748.731009429.231373177.957489.583.921.97

48364373.2532.402.613182.652375585.2580361.970.65246.46391989583922371.217.491005347.11376564.584789.212.704.48

49361970.6482.423.593161.666585585.2580359.547.06247.07176689212704.5378.778.421001181.141379959.564388.833.926.05

50359547.0562.444.763140.49755585.2580357.102.30247.68111188833926.1386.432.58996930.3371383362.916888.447.493.47

51357102.2962.466.113119.143515585.2580354.636.18248.2919688447493.5394.181.03992593.6341386774.663088.053.312.45

52354636.1812.487.663097.6035585.2580352.148.53248.90431588053312.4402.024.85988169.9741390194.823487.651.287.60

53352148.5262.509.383075.874345585.2580349.639.14249.5181887651287.6409.965.13983658.2891393623.418987.241.322.47

54349639.1422.531.303053.955895585.2580347.107.84250.13355987241322.5418.002.98979057.4941397060.470286.823.319.49

55347107.842.553.413031.8465585.2580344.554.43250.75045686823319.5426.139.50974366.4951400505.998286.397.179.99

56344554.4282.575.723009.542985585.2580341.978.71251.36887486397180434.375.84969584.1841403960.023885.962.804.15

57341978.7132.598.212987.045165585.2580339.380.50251.98881885962804.1442.713.13964709.4431407422.568085.520.091.02

58339380.52.620.912964.350825585.2580336.759.59252.6102985520091451.152.52959741.1361410893.651785.068.938.51

59336759.5932.643.802941.458265585.2580334.115.79253.23329585068938.5459.695.18954678.121414373.296184.609.243.33

60334115.7932.666.892918.365755585.2580331.448.90253.85783784609243.3468.342.29949519.2341417861.522284.140.901.04

61331448.9012.690.192895.071525585.2580328.758.71254.48391984140901477.095.04944263.3071421358.351283.663.806.00

62328758.7152.713.682871.573845585.2580326.045.03255.11154583663806485.954.65938909.1531424863.804383.177.851.35

63326045.032.737.392847.870915585.2580323.307.64255.74071983177851.3494.922.33933455.5731428377.902982.682.929.02

64323307.6432.761.302823.960945585.2580320.546.35256.37144482682929503.999.31927901.3541431900.668182.178.929.70

65320546.3462.785.422799.842145585.2580317.760.93257.00372582178929.7513.186.85922245.2691435432.121581.665.742.85

66317760.932.809.752775.512665585.2580314.951.18257.63756681665742.9522.486.21916486.0791438972.284381.143.256.65

67314951.1852.834.292750.970675585.2580312.116.90258.2729781143256.6531.898.65910622.5261442521.178280.611.357.99

68312116.8982.859.042726.214335585.2580309.257.85258.9099480611358541.425.48904653.3441446078.824580.069.932.51

69309257.8542.884.022701.241745585.2580306.373.84259.54848280069932.5551.068.00898577.2481449645.245079.518.864.52

70306373.8382.909.212676.051035585.2580303.464.63260.18859979518864.5560.827.52892392.9391453220.461378.958.036.99

71303464.6312.934.622650.640295585.2580300.530.01260.83029478958037570.705.39886099.1061456804.495078.387.331.60

72300530.0132.960.252625.007595585.2580297.569.76261.47357278387331.6580.702.95879694.4181460397.367977.806.628.66

73297569.7622.986.112599.151015585.2580294.583.66262.11843677806628.7590.821.57873177.5341463999.101777.215.807.09

74294583.6553.012.192573.068585585.2580291.571.47262.76489177215807.1601.062.62866547.0951467609.718576.614.744.46

75291571.4663.038.502546.758335585.2580288.532.97263.4129476614744.5611.427.51859801.7271471229.240076.003.316.95

76288532.9663.065.042520.218265585.2580285.467.93264.06258876003317621.917.65852940.0391474857.688275.381.399.30

77285467.9263.091.812493.446395585.2580282.376.11264.71383775381399.3632.534.46845960.6271478495.085174.748.864.84

78282376.1153.118.822466.440675585.2580279.257.30265.36669374748864.8643.279.38838862.0691482141.452874.105.585.46

79279257.2973.146.062439.199075585.2580276.111.24266.02115974105585.5654.153.89831642.9271485796.813573.451.431.57

80276111.2383.173.542411.719525585.2580272.937.70266.67723973451431.6665.159.44824301.7471489461.189372.786.272.13

81272937.73.201.262383.999955585.2580269.736.44267.33493772786272.1676.297.54816837.0581493134.602472.109.974.59

82269736.4423.229.222356.038265585.2580266.507.22267.99425772109974.6687.569.70809247.3731496817.075171.422.404.88

83266507.2223.257.432327.832345585.2580263.249.80268.65520371422404.9698.977.44801531.1871500508.629870.723.427.44

84263249.7963.285.882299.380055585.2580259.963.92269.31777970723427.4710.522.31793686.9781504209.288970.012.905.13

85259963.9183.314.582270.679245585.2580256.649.34269.98198970012905.1722.205.87785713.2091507919.074869.290.699.26

86256649.343.343.532241.727745585.2580253.305.81270.64783869290699.3734.029.69777608.3221511638.010068.556.669.58

87253305.8093.372.732212.523365585.2580249.933.07271.31532868556669.6745.995.37769370.7431515366.117267.810.674.20

88249933.0753.402.192183.063895585.2580246.530.88271.98446567810674.2758.104.54760998.881519103.418867.052.569.66

89246530.883.431.912153.347115585.2580243.098.97272.65525267052569.7770.358.81752491.1241522849.937666.282.210.85

90243098.973.461.892123.370765585.2580239.637.08273.32769466282210.9782.759.85743845.8451526605.696465.499.451.00

91239637.0823.492.132093.132585585.2580236.144.96274.00179365499451795.309.32735061.3971530370.717964.704.141.68

92236144.9573.522.632062.630285585.2580232.622.33274.67755664704141.7808.008.91726136.1131534145.024963.896.132.77

93232622.3293.553.402031.861565585.2580229.068.93275.35498563896132.8820.860.33717068.3091537928.640463.075.272.43

94229068.9333.584.432000.824085585.2580225.484.50276.03408463075272.4833.865.31707856.2821541721.587462.241.407.13

95225484.4993.615.741969.515515585.2580221.868.76276.71485962241407.1847.025.58698498.3071545523.888761.394.381.55

96221868.7563.647.321937.933475585.2580218.221.43277.39731261394381.5860.342.92688992.6431549335.567660.534.038.62

97218221.4323.679.181906.075575585.2580214.542.25278.08144960534038.6873.819.12679337.5261553156.647059.660.219.50

98214542.2493.711.321873.93945585.2580210.830.93278.76727359660219.5887.455.98669531.1731556987.150358.772.763.52

99210830.933.743.741841.522545585.2580207.087.19279.45478858772763.5901.255.32659571.7821560827.100757.871.508.21

100207087.1953.776.441808.822535585.2580203.310.76280.14399957871508.2915.218.99649457.531564676.521456.956.289.21

101203310.7593.809.421775.83695585.2580199.501.34280.8349156956289.2929.348.86639186.5711568535.435856.026.940.35

102199501.3383.842.691742.563165585.2580195.658.64281.52752456026940.3943.646.83628757.0411572403.867355.083.293.52

103195658.6433.876.261708.998785585.2580191.782.38282.22184755083293.5958.114.79618167.0541576281.839454.125.178.74

104191782.3843.910.121675.141235585.2580187.872.27282.91788254125178.7972.754.67607414.7011580169.375753.152.424.06

105187872.2673.944.271640.987955585.2580183.928.00283.61563453152424.1987.568.45596498.0541584066.499752.164.855.62

106183927.9973.978.721606.536355585.2580179.949.28284.31510752164855.61.002.558.07585415.1611587973.235051.162.297.54

107179949.2764.013.471571.783835585.2580175.935.80285.01630551162297.51.017.725.56574164.0471591889.605450.144.571.98

108175935.8014.048.531536.727765585.2580171.887.27285.719232501445721.033.072.92562742.7181595815.634649.111.499.07

109171887.2714.083.891501.36555585.2580167.803.38286.42389249111499.11.048.602.19551149.1551599751.346448.062.896.88

110167803.3794.119.561465.694355585.2580163.683.81287.13029148062896.91.064.315.45539381.3161603696.764846.998.581.43

111163683.8154.155.551429.711645585.2580159.528.27287.83843246998581.41.080.214.78527437.1371607651.913745.918.366.65

112159528.2694.191.841393.414635585.2580155.336.43288.54831945918366.71.096.302.29515314.5291611616.817044.822.064.36

113155336.4254.228.461356.800585585.2580151.107.97289.25995744822064.41.112.580.12503011.381615591.498943.709.484.25

114151107.9684.265.391319.866725585.2580146.842.58289.9733543709484.21.129.050.43490525.5551619575.983342.580.433.82

115146842.5764.302.651282.610265585.2580142.539.93290.68850342580433.81.145.715.40477854.8931623570.294641.434.718.41

116142539.9294.340.231245.028385585.2580138.199.70291.40541941434718.41.162.577.25464997.211627574.457040.272.141.17

117138199.6994.378.141207.118245585.2580133.821.56292.12410340272141.21.179.638.20451950.2971631588.494639.092.502.97

118133821.5594.416.381168.876965585.2580129.405.18292.84456390925031.196.900.51438711.9191635612.432037.895.602.46

119129405.1784.454.961130.301675585.2580124.950.22293.56679437895602.51.214.366.48425279.8161639646.293536.681.235.98

120124950.2224.493.871091.389435585.2580120.456.35294.290809366812361.232.038.40411651.7031643690.103635.449.197.58

121120456.3534.533.121052.137325585.2580115.923.23295.01660935449197.61.249.918.62397825.2681647743.886834.199.278.96

122115923.2324.572.721012.542355585.2580111.350.52295.7442341992791.268.009.49383798.1751651807.667832.931.269.47

123111350.5174.612.66972.6015365585.2580106.737.86296.47358532931269.51.286.313.41369568.0581655881.471131.644.956.05

124106737.864.652.95932.3118555585.2580102.084.91297.20476931644956.11.304.832.79355132.5281659965.321530.340.123.26

125102084.9144.693.59891.670265585.258097.391.33297.93775630340123.31.323.570.08340489.1651664059.243829.016.553.18

12697391.32634.734.58850.6736775585.258092.656.74298.67255129016553.21.342.527.74325635.5251668163.262827.674.025.44

12792656.74194.775.94809.3190065585.258087.880.80299.40915827674025.41.361.708.27310569.1341672277.403526.312.317.17

12887880.80294.817.65767.6031185585.258083.063.15300.14758126312317.21.381.114.20295287.4921676401.690724.931.202.98

12983063.1484.859.74725.5228595585.258078.203.41300.887826249312031.400.748.08279788.0681680536.149523.530.454.90

13078203.41284.902.18683.0750465585.258073.301.23301.62989723530454.91.420.612.50264068.3061684680.805022.109.842.40

13173301.22984.945.00640.2564695585.258068.356.23302.37379822109842.41.440.710.07248125.6161688835.682320.669.132.33

13268356.22834.988.19597.0638895585.258063.368.03303.11953320669132.31.461.043.42231957.3841693000.806719.208.088.91

13363368.03415.031.76553.4940395585.258058.336.27303.86710819208088.91.481.615.24215560.9621697176.203417.726.473.66

13458336.27015.075.71509.5436255585.258053.260.56304.61652617726473.71.502.428.22198933.6751701361.897816.224.045.44

13553260.55575.120.05465.2093215585.258048.140.51305.36779216224045.41.523.485.10182072.8161705557.915214.700.560.34

13648140.5075.164.77420.4877755585.258042.975.74306.12091214700560.31.544.788.63164975.6491709764.281213.155.771.71

13742975.73675.209.88375.3756055585.258037.765.85306.87588813155771.71.566.341.62147639.4041713981.021111.589.430.09

13837765.85435.255.39329.8693985585.258032.510.47307.63272711589430.11.588.146.88130061.2841718208.160710.001.283.22

13932510.46575.301.29283.9657135585.258027.209.17308.39143210001283.21.610.207.27112238.4551722445.72568.391.075.95

14027209.17335.347.60237.6610775585.258021.861.58309.1520098391075.951.632.525.6894168.05651726693.74146.758.550.26

14121861.57645.394.31190.951995585.258016.467.27309.9144616758550.261.655.105.0475847.19141730952.23405.103.445.22

14216467.27045.441.42143.8349185585.258011.025.85310.6787945103445.221.677.948.3057272.93151735221.22913.425.496.92

14311025.84725.488.9596.30629725585.25805.536.90311.4450123425496.921.701.058.4438442.31531739500.75281.724.438.48

1445536.89555.536.9048.36253325585.25800.00312.2131191724438.481.724.438.4819352.34781743790.83090.00

monto $ 100.000.000.00 UVR3.00%0.25%Reflejo de inflacionUVR218.98

plazo en meses144Spread0.00%0.00%

tasaUVRCf3.00%0.25%

forma de pagoCUMV en UVR

no.saldo inicialabono a kintereses cuota saldo finalUVRsaldo inicialabono a kintereses cuota saldo final

0456662.709456662.709218.98100000000100000000

1456662.7092.645.271126.253443771.5256454.017.44219.52006410000000032.543.681.631122240.5533665922.175567.456.318.37

2454017.4372.651.801119.729483771.5256451.365.64220.06145967456318.472.945.28757022.156829967.434367.383.373.09

3451365.6412.658.341113.189443771.5256448.707.30220.6041967383373.175.810.82756203.534832014.357967.307.562.27

4448707.3042.664.891106.633263771.5256446.042.41221.1482667307562.378.713.58755352.754834066.329767.228.848.69

5446042.4122.671.461100.060923771.5256443.370.95221.69367167228848.781.653.96754469.399836123.362367.147.194.73

6443370.9472.678.051093.472373771.5256440.692.89222.24042767147194.784.632.42753553.045838185.468167.062.562.31

7440692.8942.684.661086.867563771.5256438.008.24222.78853267062562.387.649.39752603.265840252.659566.974.912.91

8438008.2362.691.281080.246473771.5256435.316.96223.33798966974912.990.705.32751619.628842324.949366.884.207.59

9435316.9572.697.921073.609053771.5256432.619.04223.88880166884207.693.800.65750601.696844402.349866.790.406.94

10432619.042.704.571066.955263771.5256429.914.47224.44097166790406.996.935.85749549.028846484.873866.693.471.09

11429914.472.711.241060.285063771.5256427.203.23224.99450366693471.1100.111.36748461.174848572.533966.593.359.73

12427203.2292.717.931053.598413771.5256424.485.30225.549466593359.7103.327.66747337.684850665.342766.490.032.07

13424485.3022.724.631046.895273771.5256421.760.67226.10566666490032.1106.585.21746178.099852763.312966.383.446.86

14421760.6722.731.351040.17563771.5256419.029.32226.66330366383446.9109.884.50744981.957854866.457366.273.562.36

15419029.3222.738.091033.439353771.5256416.291.24227.22231666273562.4113.226.00743748.788856974.788666.160.336.36

16416291.2352.744.841026.686493771.5256413.546.40227.78270866160336.4116.610.20742478.12859088.319666.043.726.16

17413546.3962.751.611019.916983771.5256410.794.79228.34448166043726.2120.037.59741169.473861207.063265.923.688.57

18410794.7882.758.391013.130773771.5256408.036.39228.9076465923688.6123.508.67739822.363863331.032165.800.179.90

19408036.3932.765.201006.327823771.5256405.271.19229.47218865800179.9127.023.94738436.298865460.239365.673.155.96

20405271.1952.772.02999.5080983771.5256402.499.18230.03812965673156130.583.91737010.784867594.697865.542.572.04

21402499.1772.778.85992.6715553771.5256399.720.32230.60546565542572134.189.10735545.318869734.420365.408.382.94

22399720.3232.785.71985.8181513771.5256396.934.62231.174265408382.9137.840.03734039.394871879.420065.270.542.92

23396934.6162.792.58978.9478453771.5256394.142.04231.74433865270542.9141.537.21732492.497874029.709965.129.005.70

24394142.0382.799.47972.0605953771.5256391.342.57232.31588265129005.7145.281.19730904.109876185.303064.983.724.51

25391342.5732.806.37965.1563593771.5256388.536.20232.88883664983724.5149.072.51729273.705878346.212364.834.652.00

26388536.2042.813.29958.2350953771.5256385.722.91233.46320264834652152.911.70727600.753880512.451064.681.740.30

27385722.9132.820.23951.2967613771.5256382.902.68234.03898664681740.3156.799.32725884.716882684.032264.524.940.99

28382902.6842.827.18944.3413163771.5256380.075.50234.61618964524941160.735.92724125.05884860.969264.364.205.07

29380075.52.834.16937.3687173771.5256377.241.34235.19481664364205.1164.722.07722321.206887043.275164.199.483.00

30377241.3432.841.15930.3789223771.5256374.400.20235.7748764199483168.758.33720472.629889230.963164.030.724.66

31374400.1962.848.15923.3718873771.5256371.552.04236.35635464030724.7172.845.29718578.754891424.046563.857.879.37

32371552.0432.855.18916.3475723771.5256368.696.86236.93927263857879.4176.983.52716639.014893622.538763.680.895.85

33368696.8652.862.22909.3059323771.5256365.834.64237.52362963680895.8181.173.62714652.833895826.452963.499.722.23

34365834.6452.869.28902.2469273771.5256362.965.37238.10942663499722.2185.416.17712619.629898035.802763.314.306.05

35362965.3662.876.36895.1705113771.5256360.089.01238.69666863314306.1189.711.79710538.814900250.601263.124.594.27

36360089.0112.883.45888.0766443771.5256357.205.56239.28535863124594.3194.061.07708409.791902470.862162.930.533.20

37357205.5622.890.56880.965283771.5256354.315.00239.87550162930533.2198.464.64706231.959904696.598762.732.068.56

38354315.0022.897.69873.8363793771.5256351.417.31240.46709862732068.6202.923.12704004.709906927.824562.529.145.44

39351417.3132.904.84866.6898953771.5256348.512.48241.06015562529145.4207.437.13701727.423909164.553262.321.708.31

40348512.4772.912.00859.5257873771.5256345.600.48241.65467562321708.3212.007.32699399.48911406.798362.109.700.99

41345600.4772.919.18852.344013771.5256342.681.30242.2506662109701216.634.33697020.248913654.573361.893.066.67

42342681.2952.926.38845.144523771.5256339.754.91242.84811661893066.7221.318.80694589.089915907.892061.671.747.86

43339754.9142.933.60837.9272753771.5256336.821.32243.44704561671747.9226.061.41692105.36918166.767961.445.686.46

44336821.3162.940.83830.692233771.5256333.880.48244.04745161445686.5230.862.81689568.407920431.214961.214.823.65

45333880.4832.948.09823.4393423771.5256330.932.40244.64933861214823.6235.723.68686977.571922701.246560.979.099.97

46330932.3962.955.36816.1685653771.5256327.977.04245.25270960979100240.644.69684332.185924976.876760.738.455.28

47327977.0392.962.65808.8798583771.5256325.014.39245.85756860738455.3245.626.55681631.572927258.119260.492.828.73

48325014.3932.969.95801.5731743771.5256322.044.44246.46391960492828.7250.669.94678875.052929544.987960.242.158.80

49322044.4412.977.28794.248473771.5256319.067.16247.07176660242158.8255.775.56676061.932931837.496659.986.383.23

50319067.1642.984.62786.9057013771.5256316.082.54247.68111159986383.2260.944.14673191.515934135.659359.725.439.09

51316082.5442.991.98779.5448233771.5256313.090.56248.2919659725439.1266.176.40670263.094936439.489859.459.262.69

52313090.5632.999.36772.1657923771.5256310.091.20248.90431559459262.7271.473.05667275.954938749.002259.187.789.64

53310091.2033.006.76764.7685613771.5256307.084.45249.5181859187789.6276.834.84664229.374941064.210558.910.954.81

54307084.4463.014.17757.3530873771.5256304.070.27250.13355958910954.8282.262.51661122.621943385.128758.628.692.30

55304070.2743.021.61749.9193243771.5256301.048.67250.75045658628692.3287.756.81657954.957945711.770958.340.935.49

56301048.6673.029.06742.4672283771.5256298.019.61251.36887458340935.5293.318.52654725.633948044.151358.047.616.97

57298019.6093.036.53734.9967533771.5256294.983.08251.98881858047617298.948.39651433.894950382.283957.748.668.58

58294983.083.044.02727.5078543771.5256291.939.06252.6102957748668.6304.647.21648078.974952726.183057.444.021.37

59291939.0623.051.53720.0004853771.5256288.887.54253.23329557444021.4310.415.76644660.099955075.862857.133.605.60

60288887.5373.059.05712.47463771.5256285.828.49253.85783757133605.6316.254.85641176.488957431.337556.817.350.75

61285828.4863.066.60704.9301553771.5256282.761.89254.48391956817350.8322.165.27637627.347959792.621556.495.185.48

62282761.8913.074.16697.3671043771.5256279.687.73255.11154556495185.5328.147.85634011.878962159.729056.167.037.63

63279687.7323.081.74689.7853993771.5256276.605.99255.74071956167037.6334.203.40630329.27964532.674555.832.834.22

64276605.9923.089.34682.1849963771.5256273.516.65256.37144455832834.2340.332.77626578.704966911.472355.492.501.46

65273516.6513.096.96674.5658493771.5256270.419.69257.00372555492501.5346.536.79622759.351969296.136855.145.964.67

66270419.6913.104.60666.9279113771.5256267.315.09257.63756655145964.7352.816.31618870.375971686.682654.793.148.36

67267315.0943.112.25659.2711353771.5256264.202.84258.2729754793148.4359.172.20614910.927974083.124154.433.976.17

68264202.8393.119.93651.5954763771.5256261.082.91258.9099454433976.2365.605.32610880.151976485.475854.068.370.84

69261082.9093.127.62643.9008873771.5256257.955.28259.54848254068370.8372.116.57606777.18978893.752553.696.254.27

70257955.2843.135.34636.187323771.5256254.819.95260.18859953696254.3378.706.83602601.137981307.968553.317.547.44

71254819.9463.143.07628.454733771.5256251.676.88260.83029453317547.4385.377.00598351.136983728.138752.932.170.43

72251676.8753.150.82620.7030693771.5256248.526.05261.47357252932170.4392.128.00594026.279986154.277752.540.042.44

73248526.0533.158.59612.9322913771.5256245.367.46262.11843652540042.4398.960.74589625.659988586.400252.141.081.69

74245367.4593.166.38605.1423483771.5256242.201.08262.76489152141081.7405.876.16585148.36991024.520951.735.205.53

75242201.0763.174.19597.3331923771.5256239.026.88263.4129451735205.5412.875.20580593.453993468.654751.322.330.33

76239026.8833.182.02589.5047783771.5256235.844.86264.06258851322330.3419.958.82575960995918.816550.902.371.52

77235844.8633.189.87581.6570563771.5256232.654.99264.71383750902371.5427.127.97571247.052998375.020950.475.243.55

78232654.9943.197.74573.7899793771.5256229.457.26265.36669350475243.5434.383.63566453.6491000837.283150.040.859.91

79229457.2583.205.62565.90353771.5256226.251.64266.02115950040859.9441.726.80561578.821003305.617849.599.133.11

80226251.6363.213.53557.9975723771.5256223.038.11266.67723949599133.1449.158.46556621.5821005780.040149.149.974.66

81223038.1083.221.45550.0721443771.5256219.816.65267.33493749149974.7456.679.62551580.9441008260.565048.693.295.04

82219816.6553.229.40542.1271713771.5256216.587.26267.99425748693295464.291.31546455.91010747.207648.229.003.73

83216587.2563.237.36534.1626033771.5256213.349.89268.65520348229003.7471.994.55541245.4351013239.982947.757.009.18

84213349.8933.245.35526.1783933771.5256210.104.55269.31777947757009.2479.790.39535948.5211015738.906047.277.218.79

85210104.5463.253.35518.1744913771.5256206.851.19269.98198947277218.8487.679.87530564.1181018243.992246.789.538.92

86206851.1953.261.37510.1508493771.5256203.589.82270.64783846789538.9495.664.08525091.1771020755.256546.293.874.84

87203589.823.269.42502.1074193771.5256200.320.40271.31532846293874.8503.744.08519528.6341023272.714445.790.130.76

88200320.4023.277.48494.0441523771.5256197.042.92271.98446545790130.8511.920.97513875.4131025796.380945.278.209.79

89197042.923.285.56485.9609983771.5256193.757.36272.65525245278209.8520.195.84508130.4291028326.271644.758.013.95

90193757.3563.293.67477.857913771.5256190.463.69273.32769444758014528.569.82502292.581030862.401644.229.444.13

91190463.6883.301.79469.7348373771.5256187.161.90274.00179344229444.1537.044.03496360.7551033404.786343.692.400.10

92187161.8973.309.93461.591733771.5256183.851.96274.67755643692400.1545.619.61490333.8291035953.441343.146.780.49

93183851.9633.318.10453.428543771.5256180.533.87275.35498543146780.5554.297.72484210.6651038508.382042.592.482.77

94180533.8663.326.28445.2452173771.5256177.207.59276.03408442592482.8563.079.51477990.1111041069.623842.029.403.26

95177207.5863.334.48437.0417123771.5256173.873.10276.71485942029403.3571.966.18471671.0051043637.182441.457.437.08

96173873.1023.342.71428.8179763771.5256170.530.39277.39731241457437.1580.958.90465252.1681046211.073240.876.478.17

97170530.3943.350.95420.5739573771.5256167.179.44278.08144940876478.2590.058.90458732.4121048791.311940.286.419.27

98167179.4433.359.22412.3096063771.5256163.820.23278.76727340286419.3599.267.38452110.5321051377.914239.687.151.89

99163820.2273.367.50404.0248733771.5256160.452.73279.45478839687151.9608.585.59445385.311053970.895839.078.566.31

100160452.7263.375.81395.7197083771.5256157.076.92280.14399939078566.3618.014.76438555.5161056570.272438.460.551.55

101157076.923.384.13387.394063771.5256153.692.79280.8349138460551.5627.556.16431619.9041059176.059737.832.995.39

102153692.7883.392.48379.0478783771.5256150.300.31281.52752437832995.4637.211.06424577.2141061788.273637.195.784.33

103150300.3113.400.84370.6811133771.5256146.899.47282.22184737195784.3646.980.76417426.1731064406.929936.548.803.58

104146899.4663.409.23362.2937133771.5256143.490.23282.91788236548803.6656.866.55410165.4931067032.044635.891.937.03

105143490.2343.417.64353.8856273771.5256140.072.59283.61563435891937666.869.76402793.871069663.633435.225.067.26

106140072.5943.426.07345.4568053771.5256136.646.53284.31510735225067.3676.991.73395309.9871072301.712534.548.075.54

107136646.5253.434.52337.0071953771.5256133.212.01285.01630534548075.5687.233.79387712.5121074946.297833.860.841.75

108133212.0073.442.99328.5367463771.5256129.769.02285.71923233860841.8697.597.31380000.0951077597.405433.163.244.44

109129769.0183.451.48320.0454073771.5256126.317.54286.42389233163244.4708.083.68372171.3751080255.051332.455.160.76

110126317.5383.459.99311.5331253771.5256122.857.55287.13029132455160.8718.694.28364224.9731082919.251731.736.466.49

111122857.5453.468.53302.999853771.5256119.389.02287.83843231736466.5729.430.53356159.4951085590.022731.007.035.96

112119389.023.477.08294.445533771.5256115.911.94288.54831931007036740.293.85347973.531088267.380530.266.742.11

113115911.9393.485.66285.8701123771.5256112.426.28289.25995730266742.1751.285.69339665.6521090951.341529.515.456.42

114112426.2843.494.25277.2735463771.5256108.932.03289.9733529515456.4762.407.50331234.4191093641.921828.753.048.92

115108932.0323.502.87268.6557773771.5256105.429.16290.68850328753048.9773.660.76322678.3731096339.137827.979.388.15

116105429.1623.511.51260.0167553771.5256101.917.65291.40541927979388.2785.046.97313996.0381099043.005927.194.341.18

117101917.6533.520.17251.3564273771.525698.397.48292.12410327194341.2796.567.62305185.9231101753.542426.397.773.56

11898397.48393.528.85242.674743771.525694.868.63292.8445626397773.6808.224.25296246.5181104470.763925.589.549.32

11994868.6333.537.55233.9716423771.525691.331.08293.56679425589549.3820.018.39287176.2981107194.686824.769.530.93

12091331.0793.546.28225.2470793771.525687.784.80294.29080924769530.9831.951.61277973.7191109925.327523.937.579.32

12187784.80053.555.02216.5013771.525684.229.78295.01660923937579.3844.025.48268637.2211112662.702823.093.553.84

12284229.77593.563.79207.733353771.525680.665.98295.744223093553.8856.241.60259165.2251115406.829222.237.312.23

12380665.98363.572.58198.9440773771.525677.093.40296.47358522237312.2868.601.59249556.1341118157.723421.368.710.64

12477093.4023.581.39190.1331273771.525673.512.01297.20476921368710.6881.107.07239808.3351120915.402020.487.603.58

12573512.00953.590.23181.3004473771.525669.921.78297.93775620487603.6893.759.69229920.1941123679.881719.593.843.89

12669921.78433.599.08172.4459833771.525666.322.70298.67255119593843.9906.561.12219890.0611126451.179518.687.282.77

12766322.70473.607.96163.5696823771.525662.714.75299.40915818687282.8919.513.05209716.2641129229.312017.767.769.72

12862714.74873.616.85154.6714893771.525659.097.89300.14758117767769.7932.617.18199397.1161132014.296116.835.152.54

12959097.89463.625.77145.7513513771.525655.472.12300.88782616835152.5945.875.24188930.9081134806.148715.889.277.30

13055472.12033.634.72136.8092143771.525651.837.40301.62989715889277.3959.288.97178315.9121137604.886814.929.988.33

13151837.40393.643.68127.8450223771.525648.193.72302.37379814929988.3972.860.14167550.3831140410.527413.957.128.18

13248193.72333.652.67118.8587233771.525644.541.06303.11953313957128.2986.590.54156632.5521143223.087412.970.537.65

13344541.05643.661.68109.8502613771.525640.879.38303.86710812970537.61.000.481.95145560.6331146042.583911.970.055.70

13440879.3813.670.71100.8195823771.525637.208.67304.61652611970055.71.014.536.22134332.8181148869.034110.955.519.48

13537208.6753.679.7691.76663043771.525633.528.92305.36779210955519.51.028.755.17122947.2821151702.45519.926.764.31

13633528.9163.688.8382.6913523771.525629.840.08306.1209129926764.311.043.140.69111402.1741154542.86408.883.623.62

13729840.08173.697.9373.59369153771.525626.142.15306.8758888883623.621.057.694.6599695.62621157390.27827.825.928.97

13826142.14983.707.0564.47359383771.525622.435.10307.6327277825928.971.072.418.9787825.7481160244.71486.753.510.00

13922435.09773.716.1955.33100343771.525618.718.90308.39143267535101.087.315.5675790.62751163106.19135.666.194.43

14018718.90313.725.3646.16586493771.525614.993.54309.1520095666194.431.102.386.3963588.33141165974.72504.563.808.04

14114993.54343.734.5536.97812273771.525611.259.00309.9144614563808.041.117.633.4351216.90431168850.33323.446.174.61

14211258.99583.743.7627.76772113771.52567.515.24310.6787943446174.611.133.058.6638674.36881171733.03342.313.115.95

1437515.237943.752.9918.53460423771.52563.762.25311.4450122313115.951.148.664.1225958.7251174622.84321.164.451.83

1443762.246913.762.259.278715843771.52560.00312.2131191164451.831.164.451.8313067.95061177519.78000.00