taller amortizacion

Download Taller Amortizacion

Post on 10-Dec-2015

222 views

Category:

Documents

0 download

Embed Size (px)

DESCRIPTION

f

TRANSCRIPT

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