n Saldo Inicial Tasa Pago Interés Amort Cap1 200000 0.09 44583.9567 18000 26583.95672 173416.043 0.09 44583.9567 15607.4439 28976.51283 144439.531 0.09 44583.9567 12999.5578 31584.39894 112855.132 0.09 44583.9567 10156.9619 34426.99485 78428.1369 0.09 44583.9567 7058.53232 37525.42436 40902.7125 0.09 44583.9567 3681.24413 40902.7125

n Saldo Inicial Tasa Pago Interés Amort Cap1 200000 0.09 44583.9567 18000 26583.95672 173416.043 0.15 45822.9188 26012.4065 19810.51233 153605.531 0.58 95211.1196 89091.208 6119.911624 147485.619 0.2 44349.7732 29497.1239 14852.64935 132632.97 0.05 26131.012 6631.6485 19499.36346 113133.607 0.14 29093.155 15838.7049 13254.45

Saldo Insoluto A 200000173416.043 i 0.09144439.531 m 1112855.132 n 678428.136940902.7125

2.32831E-10

Saldo Insoluto173416.043 0.09153605.531 0.15147485.619 0.58

132632.97 0.2113133.607 0.0599879.1566 0.14

0.403732674.48591859

0.40373267 4.485918590.5676724 3.78448269

0.93572272 1.613315040.66510202 3.32551012

0.2537846 5.075692070.54441345 3.88866752

n S.Inic Tasa Pago Int Amort Cap1 200000 0.09 51333.3333 18000 33333.33332 166666.667 0.09 48333.3333 15000 33333.33333 133333.333 0.09 45333.3333 12000 33333.33334 100000 0.09 42333.3333 9000 33333.33335 66666.6667 0.09 39333.3333 6000 33333.33336 33333.3333 0.09 36333.3333 3000 33333.3333

n S.Inic Tasa Pago Int Amort Cap1 200000 0.09 51333.3333 18000 33333.33332 166666.667 0.15 58333.3333 25000 33333.33333 133333.333 0.58 110666.667 77333.3333 33333.33334 100000 0.2 53333.3333 20000 33333.33335 66666.6667 0.05 36666.6667 3333.33333 33333.33336 33333.3333 0.14 38000 4666.66667 33333.3333

Saldo Insoluto A166666.667 i133333.333 m

100000 n66666.666733333.3333

0

Saldo Insoluto166666.667 i1133333.333 i2

100000 i366666.6667 i433333.3333 i5

0 i6

2000000.09

16

0.090.150.58

0.20.050.14

n S.Inic tasa Pago Int1 200000 0.09 18000 180002 200000 0.09 18000 180003 200000 0.09 18000 180004 200000 0.09 18000 180005 200000 0.09 18000 180006 200000 0.09 218000 18000

n S.Inic Tasa Pago Intereses1 200000 0.09 18000 180002 200000 0.15 30000 300003 200000 0.58 116000 1160004 200000 0.2 40000 400005 200000 0.05 10000 100006 200000 0.14 28000 200000

Amort Cap Saldo Insoluto A0 200000 i0 200000 m0 200000 n0 2000000 200000

200000 0

Capital Saldo Insoluto0 2000000 2000000 2000000 2000000 200000

200000 0

2000000.09

16

0.090.150.58

0.20.050.14

n S. Inic Tasa Intereses S.Inic.+InterePago1 200000 15% 30000 230000 230002 207000 15% 31050 238050 264503 211600 15% 31740 243340 30417.54 212922.5 15% 31938.375 244860.875 34980.1255 209880.75 15% 31482.1125 241362.863 40227.14376 201135.719 15% 30170.3578 231306.077 46261.21537 185044.861 15% 27756.7292 212801.59 53200.39768 159601.193 15% 23940.1789 183541.372 61180.45739 122360.915 15% 18354.1372 140715.052 70357.5258

10 70357.5258 15% 10553.6289 80911.1547 80911.1547

n S.Inic Tasa Intereses S.Inic+InteresPago1 200000 15% 30000 230000 230002 207000 18% 37260 244260 271403 217120 30% 65136 282256 352824 246974 25% 61743.5 308717.5 44102.55 264615 40% 105846 370461 61743.56 308717.5 10% 30871.75 339589.25 67917.857 271671.4 8% 21733.712 293405.112 73351.2788 220053.834 17% 37409.1518 257462.986 85820.99539 171641.991 14% 24029.8787 195671.869 97835.9346

10 97835.9346 18% 17610.4682 115446.403 115446.403

Saldo insoluto A207000 i211600 m

212922.5 n209880.75

201135.719185044.861159601.193122360.91570357.5258

3.34694E-10

Saldo Insoluto207000217120246974264615

308717.5271671.4

220053.834171641.99197835.9346

0

20000015% 20000 1.15

1 23000 1.1510 26450 1.15

30417.5 1.1534980.125 1.15

40227.1437 1.1546261.2153 1.1553200.3976 1.1561180.4573 1.1570357.5258 1.15

15% 20000 1.1518% 23000 1.1830% 27140 1.325% 35282 1.2540% 44102.5 1.410% 61743.5 1.1

8% 67917.85 1.0817% 73351.278 1.1714% 85820.9953 1.1418% 97835.9346 1.18

A 800000i 18%m 6n 8

n Saldo Inicial Tasa Pago1 800000 18% 31662.2192 792337.781 18% 31662.2193 784445.695 18% 31662.2194 776316.847 18% 31662.2195 767944.134 18% 31662.2196 759320.238 18% 31662.2197 750437.627 18% 31662.2198 741288.536 18% 31662.2199 731864.973 18% 31662.219

10 722158.704 18% 31662.21911 712161.246 18% 31662.21912 701863.864 18% 31662.21913 691257.561 18% 31662.21914 680333.069 18% 31662.21915 669080.842 18% 31662.21916 657491.048 18% 31662.21917 645553.56 18% 31662.21918 633257.948 18% 31662.21919 620593.467 18% 31662.21920 607549.052 18% 31662.21921 594113.305 18% 31662.21922 580274.485 18% 31662.21923 566020.5 18% 31662.21924 551338.896 18% 31662.21925 536216.844 18% 31662.21926 520641.131 18% 31662.21927 504598.145 18% 31662.21928 488073.871 18% 31662.21929 471053.868 18% 31662.21930 453523.265 18% 31662.21931 435466.744 18% 31662.21932 416868.527 18% 31662.21933 397712.364 18% 31662.21934 377981.516 18% 31662.21935 357658.742 18% 31662.21936 336726.285 18% 31662.21937 315165.855 18% 31662.21938 292958.611 18% 31662.219

39 270085.151 18% 31662.21940 246525.486 18% 31662.21941 222259.032 18% 31662.21942 197264.584 18% 31662.21943 171520.302 18% 31662.21944 145003.692 18% 31662.21945 117691.584 18% 31662.21946 89560.1123 18% 31662.21947 60584.6966 18% 31662.21948 30740.0185 18% 31662.21949

Interés Amort Cap Saldo Insoluto24000 7662.21904 792337.781

23770.1334 7892.08562 784445.69523533.3709 8128.84818 776316.84723289.5054 8372.71363 767944.134

23038.324 8623.89504 759320.23822779.6072 8882.61189 750437.62722513.1288 9149.09025 741288.53622238.6561 9423.56295 731864.97321955.9492 9706.26984 722158.70421664.7611 9997.45794 712161.24621364.8374 10297.3817 701863.86421055.9159 10606.3031 691257.56120737.7268 10924.4922 680333.06920409.9921 11252.227 669080.84220072.4252 11589.7938 657491.04819724.7314 11937.4876 645553.5619366.6068 12295.6122 633257.94818997.7384 12664.4806 620593.467

18617.804 13044.415 607549.05218226.4716 13435.7475 594113.30517823.3991 13838.8199 580274.48517408.2345 14253.9845 566020.5

16980.615 14681.604 551338.89616540.1669 15122.0522 536216.84416086.5053 15575.7137 520641.13115619.2339 16042.9851 504598.14515137.9444 16524.2747 488073.87114642.2161 17020.0029 471053.868

14131.616 17530.603 453523.26513605.6979 18056.5211 435466.74413064.0023 18598.2167 416868.52712506.0558 19156.1632 397712.36411931.3709 19730.8481 377981.51611339.4455 20322.7736 357658.74210729.7623 20932.4568 336726.28510101.7886 21560.4305 315165.8559454.97564 22207.2434 292958.6118788.75834 22873.4607 270085.151

8102.55452 23559.6645 246525.4867395.76459 24266.4545 222259.0326667.77095 24994.4481 197264.5845917.93751 25744.2815 171520.3025145.60906 26516.61 145003.6924350.11076 27312.1083 117691.5843530.74752 28131.4715 89560.11232686.80337 28975.4157 60584.6966

1817.5409 29844.6781 30740.0185922.200555 30740.0185 -8.9858E-10

0.758001225.2667066

n S Inic Tasa Interés1 1575000 8.25% 21656.252 1558640.63 8.25% 21431.30863 1541533.59 8.25% 21196.08694 1523661.44 8.25% 20950.3448

SI 1575000n 7m 6i 8.25%

SI+Interés Pago Saldo Insoluto1596656.25 38015.625 1558640.63 375001580071.93 38538.3398 1541533.59 38015.6251562729.68 39068.242 1523661.44 38538.33981544611.78 39605.4303 1505006.35 39068.242

38015.62538538.3398

39068.24239605.4303