9
Cantidad 1,400,000 Años 20 PRINCIPAL 1,400,000.00 Comisión de Apertura 0.00% INTERESES 1,968,166.67 Interés Nominal 14.00% COMISIÓN 0.00 Periodo de Pago 12 TOTAL 3,368,166.67 Tipo Amortización 2 Cuotas Constantes Costo Efectivo 14.93% Meses Cuota Intereses Amortización Amortizado Pendiente 0 1,400,000.00 1 22,166.67 16,333.33 5833.33 5,833.33 1,394,166.67 2 22,098.61 16,265.28 5833.33 11,666.67 1,388,333.33 3 22,030.56 16,197.22 5833.33 17,500.00 1,382,500.00 4 21,962.50 16,129.17 5833.33 23,333.33 1,376,666.67 5 21,894.44 16,061.11 5833.33 29,166.67 1,370,833.33 6 21,826.39 15,993.06 5833.33 35,000.00 1,365,000.00 7 21,758.33 15,925.00 5833.33 40,833.33 1,359,166.67 8 21,690.28 15,856.94 5833.33 46,666.67 1,353,333.33 9 21,622.22 15,788.89 5833.33 52,500.00 1,347,500.00 10 21,554.17 15,720.83 5833.33 58,333.33 1,341,666.67 11 21,486.11 15,652.78 5833.33 64,166.67 1,335,833.33 12 21,418.06 15,584.72 5833.33 70,000.00 1,330,000.00 13 21,350.00 15,516.67 5833.33 75,833.33 1,324,166.67 14 21,281.94 15,448.61 5833.33 81,666.67 1,318,333.33 15 21,213.89 15,380.56 5833.33 87,500.00 1,312,500.00 16 21,145.83 15,312.50 5833.33 93,333.33 1,306,666.67 17 21,077.78 15,244.44 5833.33 99,166.67 1,300,833.33 18 21,009.72 15,176.39 5833.33 105,000.00 1,295,000.00 19 20,941.67 15,108.33 5833.33 110,833.33 1,289,166.67 20 20,873.61 15,040.28 5833.33 116,666.67 1,283,333.33 21 20,805.56 14,972.22 5833.33 122,500.00 1,277,500.00 22 20,737.50 14,904.17 5833.33 128,333.33 1,271,666.67 23 20,669.44 14,836.11 5833.33 134,166.67 1,265,833.33 24 20,601.39 14,768.06 5833.33 140,000.00 1,260,000.00 25 20,533.33 14,700.00 5833.33 145,833.33 1,254,166.67 26 20,465.28 14,631.94 5833.33 151,666.67 1,248,333.33 27 20,397.22 14,563.89 5833.33 157,500.00 1,242,500.00 28 20,329.17 14,495.83 5833.33 163,333.33 1,236,666.67 29 20,261.11 14,427.78 5833.33 169,166.67 1,230,833.33 30 20,193.06 14,359.72 5833.33 175,000.00 1,225,000.00 31 20,125.00 14,291.67 5833.33 180,833.33 1,219,166.67 32 20,056.94 14,223.61 5833.33 186,666.67 1,213,333.33 33 19,988.89 14,155.56 5833.33 192,500.00 1,207,500.00 34 19,920.83 14,087.50 5833.33 198,333.33 1,201,666.67 35 19,852.78 14,019.44 5833.33 204,166.67 1,195,833.33 36 19,784.72 13,951.39 5833.33 210,000.00 1,190,000.00 37 19,716.67 13,883.33 5833.33 215,833.33 1,184,166.67 38 19,648.61 13,815.28 5833.33 221,666.67 1,178,333.33 39 19,580.56 13,747.22 5833.33 227,500.00 1,172,500.00 40 19,512.50 13,679.17 5833.33 233,333.33 1,166,666.67 41 19,444.44 13,611.11 5833.33 239,166.67 1,160,833.33 PAGOS TOTALES CUADRO DE AMORTIZACIÓN DE PRÉSTAMOS

Amortizacion_prestamos

Embed Size (px)

DESCRIPTION

Tablas de amortizacion

Citation preview

  • Cantidad 1,400,000Aos 20 PRINCIPAL 1,400,000.00

    Comisin de Apertura 0.00% INTERESES 1,968,166.67Inters Nominal 14.00% COMISIN 0.00

    Periodo de Pago 12 TOTAL 3,368,166.67Tipo Amortizacin 2

    Cuotas Constantes

    Costo Efectivo 14.93%

    Meses Cuota Intereses Amortizacin Amortizado Pendiente0 1,400,000.001 22,166.67 16,333.33 5833.33 5,833.33 1,394,166.672 22,098.61 16,265.28 5833.33 11,666.67 1,388,333.333 22,030.56 16,197.22 5833.33 17,500.00 1,382,500.004 21,962.50 16,129.17 5833.33 23,333.33 1,376,666.675 21,894.44 16,061.11 5833.33 29,166.67 1,370,833.336 21,826.39 15,993.06 5833.33 35,000.00 1,365,000.007 21,758.33 15,925.00 5833.33 40,833.33 1,359,166.678 21,690.28 15,856.94 5833.33 46,666.67 1,353,333.339 21,622.22 15,788.89 5833.33 52,500.00 1,347,500.0010 21,554.17 15,720.83 5833.33 58,333.33 1,341,666.6711 21,486.11 15,652.78 5833.33 64,166.67 1,335,833.3312 21,418.06 15,584.72 5833.33 70,000.00 1,330,000.0013 21,350.00 15,516.67 5833.33 75,833.33 1,324,166.6714 21,281.94 15,448.61 5833.33 81,666.67 1,318,333.3315 21,213.89 15,380.56 5833.33 87,500.00 1,312,500.0016 21,145.83 15,312.50 5833.33 93,333.33 1,306,666.6717 21,077.78 15,244.44 5833.33 99,166.67 1,300,833.3318 21,009.72 15,176.39 5833.33 105,000.00 1,295,000.0019 20,941.67 15,108.33 5833.33 110,833.33 1,289,166.6720 20,873.61 15,040.28 5833.33 116,666.67 1,283,333.3321 20,805.56 14,972.22 5833.33 122,500.00 1,277,500.0022 20,737.50 14,904.17 5833.33 128,333.33 1,271,666.6723 20,669.44 14,836.11 5833.33 134,166.67 1,265,833.3324 20,601.39 14,768.06 5833.33 140,000.00 1,260,000.0025 20,533.33 14,700.00 5833.33 145,833.33 1,254,166.6726 20,465.28 14,631.94 5833.33 151,666.67 1,248,333.3327 20,397.22 14,563.89 5833.33 157,500.00 1,242,500.0028 20,329.17 14,495.83 5833.33 163,333.33 1,236,666.6729 20,261.11 14,427.78 5833.33 169,166.67 1,230,833.3330 20,193.06 14,359.72 5833.33 175,000.00 1,225,000.0031 20,125.00 14,291.67 5833.33 180,833.33 1,219,166.6732 20,056.94 14,223.61 5833.33 186,666.67 1,213,333.3333 19,988.89 14,155.56 5833.33 192,500.00 1,207,500.0034 19,920.83 14,087.50 5833.33 198,333.33 1,201,666.6735 19,852.78 14,019.44 5833.33 204,166.67 1,195,833.3336 19,784.72 13,951.39 5833.33 210,000.00 1,190,000.0037 19,716.67 13,883.33 5833.33 215,833.33 1,184,166.6738 19,648.61 13,815.28 5833.33 221,666.67 1,178,333.3339 19,580.56 13,747.22 5833.33 227,500.00 1,172,500.0040 19,512.50 13,679.17 5833.33 233,333.33 1,166,666.6741 19,444.44 13,611.11 5833.33 239,166.67 1,160,833.33

    PAGOS TOTALES

    CUADRO DE AMORTIZACIN DE PRSTAMOS

  • 42 19,376.39 13,543.06 5833.33 245,000.00 1,155,000.0043 19,308.33 13,475.00 5833.33 250,833.33 1,149,166.6744 19,240.28 13,406.94 5833.33 256,666.67 1,143,333.3345 19,172.22 13,338.89 5833.33 262,500.00 1,137,500.0046 19,104.17 13,270.83 5833.33 268,333.33 1,131,666.6747 19,036.11 13,202.78 5833.33 274,166.67 1,125,833.3348 18,968.06 13,134.72 5833.33 280,000.00 1,120,000.0049 18,900.00 13,066.67 5833.33 285,833.33 1,114,166.6750 18,831.94 12,998.61 5833.33 291,666.67 1,108,333.3351 18,763.89 12,930.56 5833.33 297,500.00 1,102,500.0052 18,695.83 12,862.50 5833.33 303,333.33 1,096,666.6753 18,627.78 12,794.44 5833.33 309,166.67 1,090,833.3354 18,559.72 12,726.39 5833.33 315,000.00 1,085,000.0055 18,491.67 12,658.33 5833.33 320,833.33 1,079,166.6756 18,423.61 12,590.28 5833.33 326,666.67 1,073,333.3357 18,355.56 12,522.22 5833.33 332,500.00 1,067,500.0058 18,287.50 12,454.17 5833.33 338,333.33 1,061,666.6759 18,219.44 12,386.11 5833.33 344,166.67 1,055,833.3360 18,151.39 12,318.06 5833.33 350,000.00 1,050,000.0061 18,083.33 12,250.00 5833.33 355,833.33 1,044,166.6762 18,015.28 12,181.94 5833.33 361,666.67 1,038,333.3363 17,947.22 12,113.89 5833.33 367,500.00 1,032,500.0064 17,879.17 12,045.83 5833.33 373,333.33 1,026,666.6765 17,811.11 11,977.78 5833.33 379,166.67 1,020,833.3366 17,743.06 11,909.72 5833.33 385,000.00 1,015,000.0067 17,675.00 11,841.67 5833.33 390,833.33 1,009,166.6768 17,606.94 11,773.61 5833.33 396,666.67 1,003,333.3369 17,538.89 11,705.56 5833.33 402,500.00 997,500.0070 17,470.83 11,637.50 5833.33 408,333.33 991,666.6771 17,402.78 11,569.44 5833.33 414,166.67 985,833.3372 17,334.72 11,501.39 5833.33 420,000.00 980,000.0073 17,266.67 11,433.33 5833.33 425,833.33 974,166.6774 17,198.61 11,365.28 5833.33 431,666.67 968,333.3375 17,130.56 11,297.22 5833.33 437,500.00 962,500.0076 17,062.50 11,229.17 5833.33 443,333.33 956,666.6777 16,994.44 11,161.11 5833.33 449,166.67 950,833.3378 16,926.39 11,093.06 5833.33 455,000.00 945,000.0079 16,858.33 11,025.00 5833.33 460,833.33 939,166.6780 16,790.28 10,956.94 5833.33 466,666.67 933,333.3381 16,722.22 10,888.89 5833.33 472,500.00 927,500.0082 16,654.17 10,820.83 5833.33 478,333.33 921,666.6783 16,586.11 10,752.78 5833.33 484,166.67 915,833.3384 16,518.06 10,684.72 5833.33 490,000.00 910,000.0085 16,450.00 10,616.67 5833.33 495,833.33 904,166.6786 16,381.94 10,548.61 5833.33 501,666.67 898,333.3387 16,313.89 10,480.56 5833.33 507,500.00 892,500.0088 16,245.83 10,412.50 5833.33 513,333.33 886,666.6789 16,177.78 10,344.44 5833.33 519,166.67 880,833.3390 16,109.72 10,276.39 5833.33 525,000.00 875,000.0091 16,041.67 10,208.33 5833.33 530,833.33 869,166.6792 15,973.61 10,140.28 5833.33 536,666.67 863,333.3393 15,905.56 10,072.22 5833.33 542,500.00 857,500.0094 15,837.50 10,004.17 5833.33 548,333.33 851,666.6795 15,769.44 9,936.11 5833.33 554,166.67 845,833.3396 15,701.39 9,868.06 5833.33 560,000.00 840,000.0097 15,633.33 9,800.00 5833.33 565,833.33 834,166.6798 15,565.28 9,731.94 5833.33 571,666.67 828,333.3399 15,497.22 9,663.89 5833.33 577,500.00 822,500.00

    100 15,429.17 9,595.83 5833.33 583,333.33 816,666.67101 15,361.11 9,527.78 5833.33 589,166.67 810,833.33

  • 102 15,293.06 9,459.72 5833.33 595,000.00 805,000.00103 15,225.00 9,391.67 5833.33 600,833.33 799,166.67104 15,156.94 9,323.61 5833.33 606,666.67 793,333.33105 15,088.89 9,255.56 5833.33 612,500.00 787,500.00106 15,020.83 9,187.50 5833.33 618,333.33 781,666.67107 14,952.78 9,119.44 5833.33 624,166.67 775,833.33108 14,884.72 9,051.39 5833.33 630,000.00 770,000.00109 14,816.67 8,983.33 5833.33 635,833.33 764,166.67110 14,748.61 8,915.28 5833.33 641,666.67 758,333.33111 14,680.56 8,847.22 5833.33 647,500.00 752,500.00112 14,612.50 8,779.17 5833.33 653,333.33 746,666.67113 14,544.44 8,711.11 5833.33 659,166.67 740,833.33114 14,476.39 8,643.06 5833.33 665,000.00 735,000.00115 14,408.33 8,575.00 5833.33 670,833.33 729,166.67116 14,340.28 8,506.94 5833.33 676,666.67 723,333.33117 14,272.22 8,438.89 5833.33 682,500.00 717,500.00118 14,204.17 8,370.83 5833.33 688,333.33 711,666.67119 14,136.11 8,302.78 5833.33 694,166.67 705,833.33120 14,068.06 8,234.72 5833.33 700,000.00 700,000.00121 14,000.00 8,166.67 5833.33 705,833.33 694,166.67122 13,931.94 8,098.61 5833.33 711,666.67 688,333.33123 13,863.89 8,030.56 5833.33 717,500.00 682,500.00124 13,795.83 7,962.50 5833.33 723,333.33 676,666.67125 13,727.78 7,894.44 5833.33 729,166.67 670,833.33126 13,659.72 7,826.39 5833.33 735,000.00 665,000.00127 13,591.67 7,758.33 5833.33 740,833.33 659,166.67128 13,523.61 7,690.28 5833.33 746,666.67 653,333.33129 13,455.56 7,622.22 5833.33 752,500.00 647,500.00130 13,387.50 7,554.17 5833.33 758,333.33 641,666.67131 13,319.44 7,486.11 5833.33 764,166.67 635,833.33132 13,251.39 7,418.06 5833.33 770,000.00 630,000.00133 13,183.33 7,350.00 5833.33 775,833.33 624,166.67134 13,115.28 7,281.94 5833.33 781,666.67 618,333.33135 13,047.22 7,213.89 5833.33 787,500.00 612,500.00136 12,979.17 7,145.83 5833.33 793,333.33 606,666.67137 12,911.11 7,077.78 5833.33 799,166.67 600,833.33138 12,843.06 7,009.72 5833.33 805,000.00 595,000.00139 12,775.00 6,941.67 5833.33 810,833.33 589,166.67140 12,706.94 6,873.61 5833.33 816,666.67 583,333.33141 12,638.89 6,805.56 5833.33 822,500.00 577,500.00142 12,570.83 6,737.50 5833.33 828,333.33 571,666.67143 12,502.78 6,669.44 5833.33 834,166.67 565,833.33144 12,434.72 6,601.39 5833.33 840,000.00 560,000.00145 12,366.67 6,533.33 5833.33 845,833.33 554,166.67146 12,298.61 6,465.28 5833.33 851,666.67 548,333.33147 12,230.56 6,397.22 5833.33 857,500.00 542,500.00148 12,162.50 6,329.17 5833.33 863,333.33 536,666.67149 12,094.44 6,261.11 5833.33 869,166.67 530,833.33150 12,026.39 6,193.06 5833.33 875,000.00 525,000.00151 11,958.33 6,125.00 5833.33 880,833.33 519,166.67152 11,890.28 6,056.94 5833.33 886,666.67 513,333.33153 11,822.22 5,988.89 5833.33 892,500.00 507,500.00154 11,754.17 5,920.83 5833.33 898,333.33 501,666.67155 11,686.11 5,852.78 5833.33 904,166.67 495,833.33156 11,618.06 5,784.72 5833.33 910,000.00 490,000.00157 11,550.00 5,716.67 5833.33 915,833.33 484,166.67158 11,481.94 5,648.61 5833.33 921,666.67 478,333.33159 11,413.89 5,580.56 5833.33 927,500.00 472,500.00160 11,345.83 5,512.50 5833.33 933,333.33 466,666.67161 11,277.78 5,444.44 5833.33 939,166.67 460,833.33

  • 162 11,209.72 5,376.39 5833.33 945,000.00 455,000.00163 11,141.67 5,308.33 5833.33 950,833.33 449,166.67164 11,073.61 5,240.28 5833.33 956,666.67 443,333.33165 11,005.56 5,172.22 5833.33 962,500.00 437,500.00166 10,937.50 5,104.17 5833.33 968,333.33 431,666.67167 10,869.44 5,036.11 5833.33 974,166.67 425,833.33168 10,801.39 4,968.06 5833.33 980,000.00 420,000.00169 10,733.33 4,900.00 5833.33 985,833.33 414,166.67170 10,665.28 4,831.94 5833.33 991,666.67 408,333.33171 10,597.22 4,763.89 5833.33 997,500.00 402,500.00172 10,529.17 4,695.83 5833.33 1,003,333.33 396,666.67173 10,461.11 4,627.78 5833.33 1,009,166.67 390,833.33174 10,393.06 4,559.72 5833.33 1,015,000.00 385,000.00175 10,325.00 4,491.67 5833.33 1,020,833.33 379,166.67176 10,256.94 4,423.61 5833.33 1,026,666.67 373,333.33177 10,188.89 4,355.56 5833.33 1,032,500.00 367,500.00178 10,120.83 4,287.50 5833.33 1,038,333.33 361,666.67179 10,052.78 4,219.44 5833.33 1,044,166.67 355,833.33180 9,984.72 4,151.39 5833.33 1,050,000.00 350,000.00181 9,916.67 4,083.33 5833.33 1,055,833.33 344,166.67182 9,848.61 4,015.28 5833.33 1,061,666.67 338,333.33183 9,780.56 3,947.22 5833.33 1,067,500.00 332,500.00184 9,712.50 3,879.17 5833.33 1,073,333.33 326,666.67185 9,644.44 3,811.11 5833.33 1,079,166.67 320,833.33186 9,576.39 3,743.06 5833.33 1,085,000.00 315,000.00187 9,508.33 3,675.00 5833.33 1,090,833.33 309,166.67188 9,440.28 3,606.94 5833.33 1,096,666.67 303,333.33189 9,372.22 3,538.89 5833.33 1,102,500.00 297,500.00190 9,304.17 3,470.83 5833.33 1,108,333.33 291,666.67191 9,236.11 3,402.78 5833.33 1,114,166.67 285,833.33192 9,168.06 3,334.72 5833.33 1,120,000.00 280,000.00193 9,100.00 3,266.67 5833.33 1,125,833.33 274,166.67194 9,031.94 3,198.61 5833.33 1,131,666.67 268,333.33195 8,963.89 3,130.56 5833.33 1,137,500.00 262,500.00196 8,895.83 3,062.50 5833.33 1,143,333.33 256,666.67197 8,827.78 2,994.44 5833.33 1,149,166.67 250,833.33198 8,759.72 2,926.39 5833.33 1,155,000.00 245,000.00199 8,691.67 2,858.33 5833.33 1,160,833.33 239,166.67200 8,623.61 2,790.28 5833.33 1,166,666.67 233,333.33201 8,555.56 2,722.22 5833.33 1,172,500.00 227,500.00202 8,487.50 2,654.17 5833.33 1,178,333.33 221,666.67203 8,419.44 2,586.11 5833.33 1,184,166.67 215,833.33204 8,351.39 2,518.06 5833.33 1,190,000.00 210,000.00205 8,283.33 2,450.00 5833.33 1,195,833.33 204,166.67206 8,215.28 2,381.94 5833.33 1,201,666.67 198,333.33207 8,147.22 2,313.89 5833.33 1,207,500.00 192,500.00208 8,079.17 2,245.83 5833.33 1,213,333.33 186,666.67209 8,011.11 2,177.78 5833.33 1,219,166.67 180,833.33210 7,943.06 2,109.72 5833.33 1,225,000.00 175,000.00211 7,875.00 2,041.67 5833.33 1,230,833.33 169,166.67212 7,806.94 1,973.61 5833.33 1,236,666.67 163,333.33213 7,738.89 1,905.56 5833.33 1,242,500.00 157,500.00214 7,670.83 1,837.50 5833.33 1,248,333.33 151,666.67215 7,602.78 1,769.44 5833.33 1,254,166.67 145,833.33216 7,534.72 1,701.39 5833.33 1,260,000.00 140,000.00217 7,466.67 1,633.33 5833.33 1,265,833.33 134,166.67218 7,398.61 1,565.28 5833.33 1,271,666.67 128,333.33219 7,330.56 1,497.22 5833.33 1,277,500.00 122,500.00220 7,262.50 1,429.17 5833.33 1,283,333.33 116,666.67221 7,194.44 1,361.11 5833.33 1,289,166.67 110,833.33

  • 222 7,126.39 1,293.06 5833.33 1,295,000.00 105,000.00223 7,058.33 1,225.00 5833.33 1,300,833.33 99,166.67224 6,990.28 1,156.94 5833.33 1,306,666.67 93,333.33225 6,922.22 1,088.89 5833.33 1,312,500.00 87,500.00226 6,854.17 1,020.83 5833.33 1,318,333.33 81,666.67227 6,786.11 952.78 5833.33 1,324,166.67 75,833.33228 6,718.06 884.72 5833.33 1,330,000.00 70,000.00229 6,650.00 816.67 5833.33 1,335,833.33 64,166.67230 6,581.94 748.61 5833.33 1,341,666.67 58,333.33231 6,513.89 680.56 5833.33 1,347,500.00 52,500.00232 6,445.83 612.50 5833.33 1,353,333.33 46,666.67233 6,377.78 544.44 5833.33 1,359,166.67 40,833.33234 6,309.72 476.39 5833.33 1,365,000.00 35,000.00235 6,241.67 408.33 5833.33 1,370,833.33 29,166.67236 6,173.61 340.28 5833.33 1,376,666.67 23,333.33237 6,105.56 272.22 5833.33 1,382,500.00 17,500.00238 6,037.50 204.17 5833.33 1,388,333.33 11,666.67239 5,969.44 136.11 5833.33 1,394,166.67 5,833.33240 5,901.39 68.06 5833.33 1,400,000.00 0.00