tabla de amortizacion (autoguardado)

Download Tabla de Amortizacion (Autoguardado)

Post on 01-Mar-2018

228 views

Category:

Documents

0 download

Embed Size (px)

TRANSCRIPT

  • 7/26/2019 Tabla de Amortizacion (Autoguardado)

    1/15

    N Deuda Tasa Renta Amortizacion Interes I.V.A Interes0 2000000 0.0463 155422.131 2000000 0.0463 155,422.13 62,922.13 92500 14 00.002 1,93!,0!!. ! 0.0463 155,422.13 65, 32.2 95 9. 5 14334.33 1, !1,245.59 0.0463 155,422.13 6 , !!.02 6545.11 13 4!.224 1, 02,36 .5! 0.0463 155,422.13 !2,062.5 3359.55 1333!.535 1,!30,305.99 0.0463 155,422.13 !5,395.4 0026.65 12 04.266 1,654,910.51 0.0463 155,422.13 ! , 2.52 !6539.61 12246.34! 1,5!6,02!.99 0.0463 155,422.13 2,530. 4 !2 91.29 11662.61

    1,493,49!.15 0.0463 155,422.13 6,34!. 9 690!4.24 11051.9 1,40!,149.2! 0.0463 155,422.13 90,341.4 650 0.65 10412.90

    10 1,316, 0!.!9 0.0463 155,422.13 94,519.!! 60902.36 9!44.311 1,222,2 .02 0.0463 155,422.13 9 , 91.31 56530. 2 9044.9312 1,123,396.!1 0.0463 155,422.13 103,465.03 5195!.10 313.1413 1,019,931.6 0.0463 155,422.13 10 ,250.29 4!1!1. 4 !54!.4914 911,6 1.39 0.0463 155,422.13 113,256. ! 42165.26 6!46.4415 !9 ,424.52 0.0463 155,422.13 11 ,495.00 3692!.13 590 .3416 6!9,929.53 0.0463 155,422.13 123,9!5.39 31446.!4 5031.41! 555,954.14 0.0463 155,422.13 129,!09.25 25!12. 4114.061 426,244. 9 0.0463 155,422.13 135,!0 .30 19!13. 3 3154.2119 290,536.5 0.0463 155,422.13 141,9 4. 1 1343!.31! 2149.9!20 14 ,551.!! 0.0463 155,422.13 14 ,551.61 6 !0.519 1099.2

  • 7/26/2019 Tabla de Amortizacion (Autoguardado)

    2/15

    "a#do inso#uto Tota# $arcia#2000000

    1,93!,0!!. ! 1!0,222.131, !1,245.59 169,!56.511, 02,36 .5! 169,269.351,!30,305.99 16 ,!59.661,654,910.51 16 ,226.391,5!6,02!.99 16!,66 .4!1,493,49!.15 16!,0 4.!4

    1,40!,149.2! 166,4!4.011,316, 0!.!9 165, 35.031,222,2 .02 165,166.511,123,396.!1 164,46!.061,019,931.6 163,!35.2!

    911,6 1.39 162,969.62!9 ,424.52 162,16 .5!6!9,929.53 161,330.4!555,954.14 160,453.61426,244. 9 159,536.19290,536.5 15 ,5!6.3414 ,551.!! 15!,5!2.10

    0.16 156,521.41

  • 7/26/2019 Tabla de Amortizacion (Autoguardado)

    3/15

    N Deuda Tasa Renta Amortizacion Interes

    0 500000 0.009 5,3 5.15 5,3 5.15 01 414,614. 5 0.009 5,3 5.15 1,30 .10 40!!.052 333,306.!5 0.009 5,3 5.15 2,10!.63 32!!.523 251,199.11 0.009 5,3 5.15 2,915.03 24!0.124 16 ,2 4.09 0.009 5,3 5.15 3,!30.36 1654.!95 4,553.!3 0.009 5,3 5.15 4,553.!0 31.456 0.03 0.009 5,3 5.15 5,3 5.15 0.00

    2122232425262!

  • 7/26/2019 Tabla de Amortizacion (Autoguardado)

    4/15

    I.V.A Intere Saldo insol Total parcial

    0.00 414,614. 5 5,3 5.15652.33 333,306.!5 6,03!.4524.40 251,199.11 5,909.55395.22 16 ,2 4.09 5,! 0.3!264.!! 4,553.!3 5,649.92133.03 0.03 5,51 .1

    0.00 % 5,3 5.12 5,3 5.15

  • 7/26/2019 Tabla de Amortizacion (Autoguardado)

    5/15

    N Deuda Tasa Renta AmortizacioInteres I.V.A Intere Saldo insoluto Total parcia0 1500000 0.0124 133,65!.12 133,65!.12 0 0.00 1,366,342. 133,65!.121 &&& 0.0124 133,65!.12 116,691.!0 16965.42 2!14.4! 1,249,651.1 136,3!1.592 &&& 0.0124 133,65!.12 11 ,140.62 15516.50 24 2.64 1,131,510.5! 136,139.!63 &&& 0.0124 133,65!.12 119,60!.53 14049.59 224!.93 1,011,903.04 135,905.054 &&& 0.0124 133,65!.12 121,092.66 12564.46 2010.31 90, 10.3 135,66!.435 90, 10.3 0.0124 133,65!.12 122,596.22 11060.90 1!69.!4 !6 ,214.15 135,426. 66 !6 ,214.15 0.0124 133,65!.12 124,11 .46 953 .66 1526.19 644,095.69 135,1 3.31! 644,095.69 0.0124 133,65!.12 125,659.60 !99!.52 12!9.60 51 ,436.09 134,936.!2

    51 ,436.09 0.0124 133,65!.12 12!,219. ! 643!.25 1029.96 391,216.22 134,6 !.09 391,216.22 0.0124 133,65!.12 12 ,!99.52 4 5!.60 !!!.22 262,416.!0 134,434.34

    10 262,416.!0 0.0124 133,65!.12 130,39 .! 325 .34 521.33 132,01!.93 134,1! .4511 132,01!.93 0.0124 133,65!.12 132,01!.90 1639.22 262.2 0.03 133,919.4012 0.03 0.0124 133,65 .12 133,65 .12 0.00 0.00 %133,65 .09 133,65 .12

  • 7/26/2019 Tabla de Amortizacion (Autoguardado)

    6/15

    l

  • 7/26/2019 Tabla de Amortizacion (Autoguardado)

    7/15

    N Deuda Tasa Renta AmortizacioInteres I.V.A Intere Saldo insol Total parcial0 2040000 0.00 3 ,309.10 20000001 2040000 0.00 3 ,309.10 20,459.10 1! 50 2 56.00 &&& 41,165.102 &&& 0.00 3 ,309.10 20,63 .12 1!6!0.9 2 2!.36 &&& 41,136.463 &&& 0.00 3 ,309.10 20, 1 .!0 1!490.40 2!9 .46 &&& 41,10!.564 &&& 0.00 3 ,309.10 21,000. 6 1!30 .24 2!69.32 &&& 41,0! .425 &&& 0.00 3 ,309.10 21,1 4.62 1!124.4 2!39.92 &&& 41,049.026 &&& 0.00 3 ,309.10 21,369.99 16939.11 2!10.26 &&& 41,019.36! &&& 0.00 3 ,309.10 21,556.9! 16!52.13 26 0.34 &&& 40,9 9.44

    &&& 0.00 3 ,309.10 21,!45.60 16563.50 2650.16 &&& 40,959.269 &&& 0.00 3 ,309.10 21,935. ! 163!3.23 2619.!2 &&& 40,92 . 2

    10 &&& 0.00 3 ,309.10 22,12!. 1 161 1.29 25 9.01 &&& 40, 9 .1011 &&& 0.00 3 ,309.10 22,321.43 159 !.6! 255 .03 &&& 40, 6!.1312 &&& 0.00 3 ,309.10 22,516.!4 15!92.36 2526.! &&& 40, 35.13 &&& 0.00 3 ,309.10 22,!13.!6 15595.34 2495.25 &&& 40, 04.3514 &&& 0.00 3 ,309.10 22,912.51 15396.59 2463.45 &&& 40,!!2.5515 &&& 0.00 3 ,309.10 23,112.99 15196.11 2431.3 &&& 40,!40.416 &&& 0.00 3 ,309.10 23,315.23 14993. ! 2399.02 &&& 40,!0 .121! &&& 0.00 3 ,309.10 23,519.24 14! 9. 6 2366.3 &&& 40,6!5.41 &&& 0.00 3 ,309.10 23,!25.03 145 4.0! 2333.45 &&& 40,642.5519 &&& 0.00 3 ,309.10 23,932.63 143!6.4!3 2300.24 &&& 40,609.3320 &&& 0.00 3 ,309.10 24,142.04 1416!.062 2266.!3 &&& 40,5!5. 321 &&& 0.00 3 ,309.10 24,353.2 13955. 19 2232.93 &&& 40,542.03

    22 &&& 0.00 3 ,309.10 24,566.3! 13!42.!2 219 . 4 &&& 40,50!.9423 &&& 0.00 3 ,309.10 24,! 1.33 1352!.!!2 2164.44 &&& 40,4!3.5424 &&& 0.00 3 ,309.10 24,99 .16 13310.936 2129.!5 &&& 40,43 . 525 &&& 0.00 3 ,309.10 25,216.90 13092.202 2094.!5 &&& 40,403. 526 &&& 0.00 3 ,309.10 25,43!.54 12 !1.554 2059.45 &&& 40,36 .552! &&& 0.00 3 ,309.10 25,660.12 1264 .9!5 2023. 4 &&& 40,332.932 &&& 0.00 3 ,309.10 25, 4.65 12424.449 19 !.91 &&& 40,29!.0129 &&& 0.00 3 ,309.10 26,111.14 1219!.959 1951.6! &&& 40,260.!!30 &&& 0.00 3 ,309.10 26,339.61 11969.4 6 1915.12 &&& 40,224.22

  • 7/26/2019 Tabla de Amortizacion (Autoguardado)

    8/15

    31 &&& 0.00 3 ,309.10 26,5!0.0 11!39.015 1 ! .24 &&& 40,1 !.3432 &&& 0.00 3 ,309.10 26, 02.5! 11506.526 1 41.04 &&& 40,150.1433 &&& 0.00 3 ,309.10 2!,03!.09 112!2.004 1 03.52 &&& 40,112.6234 &&& 0.00 3 ,309.10 2!,2!3.6! 11035.429 1!65.6! &&& 40,0!4.!!35 &&& 0.00 3 ,309.10 2!,512.31 10!96.! 5 1!2!.49 &&& 40,036.536 &&& 0.00 3 ,309.10 2!,!53.05 10556.052 16 .9! &&& 39,99 .0!3! &&& 0.00 3 ,309.10 2!,995. 9 10313.213 1650.11 &&& 39,959.213 &&& 0.00 3 ,309.10 2 ,240. 5 1006 .249 1610.92 &&& 39,920.0239 &&& 0.00 3 ,309.10 2 ,4 !.96 9 21.141 15!1.3 &&& 39, 0.440 &&& 0.00 3 ,309.10 2 ,!3!.23 95!1. !2 1531.50 &&& 39, 40.6041 &&& 0.00 3 ,309.10 2 ,9 .6 9320.421 1491.2! &&& 39, 00.3!42 &&& 0.00 3 ,309.10 29,242.33 9066.!!0 1450.6 &&& 39,!59.!43 &&& 0.00 3 ,309.10 29,49 .20 10.900 1409.!4 9!!,461.!6 39,!1 . 444 9!!,461.!6 0.00 3 ,309.10 29,!56.31 552.!90 136 .45 94!,!05.45 39,6!!.5545 94!,!05.45 0.00 3 ,309.10 30,016.6 292.423 1326.!9 91!,6 .!! 39,635. 946 91!,6 .!! 0.00 3 ,309.10 30,2!9.32 029.!!! 12 4.!6 !,409.45 39,593. 64! !,409.45 0.00 3 ,309.10 30,544.2! !!64. 33 1242.3! 56, 65.1 39,551.4!4 56, 65.1 0.00 3 ,309.10 30, 11.53 !49!.5!0 1199.61 26,053.66 39,50 .!149 26,053.66 0.00 3 ,309.10 31,0 1.13 !22!.969 1156.4 !94,9!2.53 39,465.5!50 !94,9!2.53 0.00 3 ,309.10 31,353.09 6956.010 1112.96 !63,619.44 39,422.0651 !63,619.44 0.00 3 ,309.10 31,62!.43 66 1.6!0 1069.0! !31,992.01 39,3! .1!52 !31,992.01 0.00 3 ,309.10 31,904.1! 6404.930 1024.!9 !00,0 !. 4 39,333. 953 !00,0 !. 4 0.00 3 ,309.10 32,1 3.33 6125.!69 9 0.12 66!,904.51 39,2 9.22

    54 66!,904.51 0.00 3 ,309.10 32,464.93 5 44.164 935.0! 635,439.5 39,244.1!55 635,439.5 0.00 3 ,309.10 32,!49.00 5560.096 9.62 602,690.5! 39,19 .!156 602,690.5! 0.00 3 ,309.10 33,035.56 52!3.543 43.!! 569,655.02 39,152. !5! 569,655.02 0.00 3 ,309.10 33,324.62 49 4.4 1 !9!.52 536,330.40 39,106.625 536,330.40 0.00 3 ,309.10 33,616.21 4692. 91 !50. 6 502,!14.19 39,059.9659 502,!14.19 0.00 3 ,309.10 33,910.35 439 .!49 !03. 0 46 , 03. 4 39,012.9060 46 , 03. 4 0.00 3 ,309.10 34,20!.0! 4102.034 656.33 434,596.! 3 ,965.4261 434,596.! 0.00 3 ,309.10 34,506.3 3 02.!22 60 .44 400,090.40 3 ,91!.5362 400,090.40 0.00 3 ,309.10 34, 0 .31 3500.!91 560.13 365,2 2.09 3 , 69.23

  • 7/26/2019 Tabla de Amortizacion (Autoguardado)

    9/15

    63 365,2 2.09 0.00 3 ,309.10 35,112. 3196.21 511.39 330,169.21 3 , 20.4964 330,169.21 0.00 3 ,309.10 35,420.12 2 .9 1 462.24 294,!49.09 3 ,!!1.3465 294,!49.09 0.00 3 ,309.10 35,!30.04 25!9.055 412.65 259,019.05 3 ,!21.!566 259,019.05 0.00 3 ,309.10 36,042.6 2266.41! 362.63 222,9!6.3! 3 ,6!1.!36! 222,9!6.3! 0.00 3 ,309.10 36,35 .06 1951.043 312.1! 1 6,61 .31 3 ,621.2!6 1 6,61 .31 0.00 3 ,309.10 36,6!6.19 1632.910 261.2! 149,942.12 3 ,5!0.3669 149,942.12 0.00 3 ,309.10 36,99!.11 1311.994 209.92 112,945.02 3 ,519.02!0 112,945.02 0.00 3 ,309.10 3!,320. 3 9 .269 15 .12 !5,624.19 3 ,46!.22!1 !5,624.19 0.00 3