taller amortizacion
Post on 10-Dec-2015
222 views
Embed Size (px)
DESCRIPTION
fTRANSCRIPT
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 Am