Tabla Amortizacion Met Frances
description
Transcript of Tabla Amortizacion Met Frances
Datos Iniciales Valor Total Capital:Capital pendiente 100,000.00 € Total Intereses:Tipo de Interés Anual 5.000% Total PagadoNº Años de amortización 20Nº pagos por año 12Total pagos pendientes 240Tipo de Interés por periodo 0.4167%
Nº PAGO CAPITAL INICIAL PAGO CUOTA INTERESES CAP. AMORTIZADO1 100,000.00 € 659.96 € 416.67 € 243.29 €2 99,756.71 € 659.96 € 415.65 € 244.30 €3 99,512.41 € 659.96 € 414.64 € 245.32 €4 99,267.09 € 659.96 € 413.61 € 246.34 €5 99,020.74 € 659.96 € 412.59 € 247.37 €6 98,773.38 € 659.96 € 411.56 € 248.40 €7 98,524.98 € 659.96 € 410.52 € 249.44 €8 98,275.54 € 659.96 € 409.48 € 250.47 €9 98,025.07 € 659.96 € 408.44 € 251.52 €
10 97,773.55 € 659.96 € 407.39 € 252.57 €11 97,520.98 € 659.96 € 406.34 € 253.62 €12 97,267.36 € 659.96 € 405.28 € 254.68 €13 97,012.69 € 659.96 € 404.22 € 255.74 €14 96,756.95 € 659.96 € 403.15 € 256.80 €15 96,500.15 € 659.96 € 402.08 € 257.87 €16 96,242.28 € 659.96 € 401.01 € 258.95 €17 95,983.33 € 659.96 € 399.93 € 260.03 €18 95,723.31 € 659.96 € 398.85 € 261.11 €19 95,462.20 € 659.96 € 397.76 € 262.20 €20 95,200.00 € 659.96 € 396.67 € 263.29 €21 94,936.71 € 659.96 € 395.57 € 264.39 €22 94,672.33 € 659.96 € 394.47 € 265.49 €23 94,406.84 € 659.96 € 393.36 € 266.59 €24 94,140.25 € 659.96 € 392.25 € 267.70 €25 93,872.54 € 659.96 € 391.14 € 268.82 €26 93,603.72 € 659.96 € 390.02 € 269.94 €27 93,333.78 € 659.96 € 388.89 € 271.06 €28 93,062.72 € 659.96 € 387.76 € 272.19 €29 92,790.52 € 659.96 € 386.63 € 273.33 €30 92,517.19 € 659.96 € 385.49 € 274.47 €31 92,242.72 € 659.96 € 384.34 € 275.61 €32 91,967.11 € 659.96 € 383.20 € 276.76 €33 91,690.35 € 659.96 € 382.04 € 277.91 €34 91,412.44 € 659.96 € 380.89 € 279.07 €35 91,133.37 € 659.96 € 379.72 € 280.23 €36 90,853.14 € 659.96 € 378.55 € 281.40 €37 90,571.74 € 659.96 € 377.38 € 282.57 €38 90,289.16 € 659.96 € 376.20 € 283.75 €39 90,005.41 € 659.96 € 375.02 € 284.93 €40 89,720.48 € 659.96 € 373.84 € 286.12 €41 89,434.36 € 659.96 € 372.64 € 287.31 €42 89,147.05 € 659.96 € 371.45 € 288.51 €43 88,858.54 € 659.96 € 370.24 € 289.71 €
44 88,568.82 € 659.96 € 369.04 € 290.92 €45 88,277.91 € 659.96 € 367.82 € 292.13 €46 87,985.77 € 659.96 € 366.61 € 293.35 €47 87,692.43 € 659.96 € 365.39 € 294.57 €48 87,397.86 € 659.96 € 364.16 € 295.80 €49 87,102.06 € 659.96 € 362.93 € 297.03 €50 86,805.03 € 659.96 € 361.69 € 298.27 €51 86,506.76 € 659.96 € 360.44 € 299.51 €52 86,207.25 € 659.96 € 359.20 € 300.76 €53 85,906.49 € 659.96 € 357.94 € 302.01 €54 85,604.48 € 659.96 € 356.69 € 303.27 €55 85,301.21 € 659.96 € 355.42 € 304.53 €56 84,996.67 € 659.96 € 354.15 € 305.80 €57 84,690.87 € 659.96 € 352.88 € 307.08 €58 84,383.79 € 659.96 € 351.60 € 308.36 €59 84,075.44 € 659.96 € 350.31 € 309.64 €60 83,765.79 € 659.96 € 349.02 € 310.93 €61 83,454.86 € 659.96 € 347.73 € 312.23 €62 83,142.64 € 659.96 € 346.43 € 313.53 €63 82,829.11 € 659.96 € 345.12 € 314.83 €64 82,514.27 € 659.96 € 343.81 € 316.15 €65 82,198.13 € 659.96 € 342.49 € 317.46 €66 81,880.66 € 659.96 € 341.17 € 318.79 €67 81,561.88 € 659.96 € 339.84 € 320.11 €68 81,241.76 € 659.96 € 338.51 € 321.45 €69 80,920.31 € 659.96 € 337.17 € 322.79 €70 80,597.53 € 659.96 € 335.82 € 324.13 €71 80,273.39 € 659.96 € 334.47 € 325.48 €72 79,947.91 € 659.96 € 333.12 € 326.84 €73 79,621.07 € 659.96 € 331.75 € 328.20 €74 79,292.87 € 659.96 € 330.39 € 329.57 €75 78,963.30 € 659.96 € 329.01 € 330.94 €76 78,632.36 € 659.96 € 327.63 € 332.32 €77 78,300.04 € 659.96 € 326.25 € 333.71 €78 77,966.33 € 659.96 € 324.86 € 335.10 €79 77,631.24 € 659.96 € 323.46 € 336.49 €80 77,294.74 € 659.96 € 322.06 € 337.89 €81 76,956.85 € 659.96 € 320.65 € 339.30 €82 76,617.55 € 659.96 € 319.24 € 340.72 €83 76,276.83 € 659.96 € 317.82 € 342.14 €84 75,934.70 € 659.96 € 316.39 € 343.56 €85 75,591.14 € 659.96 € 314.96 € 344.99 €86 75,246.14 € 659.96 € 313.53 € 346.43 €87 74,899.71 € 659.96 € 312.08 € 347.87 €88 74,551.84 € 659.96 € 310.63 € 349.32 €89 74,202.52 € 659.96 € 309.18 € 350.78 €90 73,851.74 € 659.96 € 307.72 € 352.24 €91 73,499.50 € 659.96 € 306.25 € 353.71 €92 73,145.79 € 659.96 € 304.77 € 355.18 €93 72,790.61 € 659.96 € 303.29 € 356.66 €94 72,433.95 € 659.96 € 301.81 € 358.15 €95 72,075.80 € 659.96 € 300.32 € 359.64 €96 71,716.16 € 659.96 € 298.82 € 361.14 €97 71,355.02 € 659.96 € 297.31 € 362.64 €
98 70,992.38 € 659.96 € 295.80 € 364.15 €99 70,628.22 € 659.96 € 294.28 € 365.67 €
100 70,262.55 € 659.96 € 292.76 € 367.20 €101 69,895.36 € 659.96 € 291.23 € 368.73 €102 69,526.63 € 659.96 € 289.69 € 370.26 €103 69,156.37 € 659.96 € 288.15 € 371.80 €104 68,784.57 € 659.96 € 286.60 € 373.35 €105 68,411.21 € 659.96 € 285.05 € 374.91 €106 68,036.30 € 659.96 € 283.48 € 376.47 €107 67,659.83 € 659.96 € 281.92 € 378.04 €108 67,281.79 € 659.96 € 280.34 € 379.61 €109 66,902.18 € 659.96 € 278.76 € 381.20 €110 66,520.98 € 659.96 € 277.17 € 382.78 €111 66,138.20 € 659.96 € 275.58 € 384.38 €112 65,753.82 € 659.96 € 273.97 € 385.98 €113 65,367.83 € 659.96 € 272.37 € 387.59 €114 64,980.24 € 659.96 € 270.75 € 389.20 €115 64,591.04 € 659.96 € 269.13 € 390.83 €116 64,200.21 € 659.96 € 267.50 € 392.45 €117 63,807.76 € 659.96 € 265.87 € 394.09 €118 63,413.67 € 659.96 € 264.22 € 395.73 €119 63,017.94 € 659.96 € 262.57 € 397.38 €120 62,620.56 € 659.96 € 260.92 € 399.04 €121 62,221.52 € 659.96 € 259.26 € 400.70 €122 61,820.82 € 659.96 € 257.59 € 402.37 €123 61,418.45 € 659.96 € 255.91 € 404.05 €124 61,014.40 € 659.96 € 254.23 € 405.73 €125 60,608.68 € 659.96 € 252.54 € 407.42 €126 60,201.26 € 659.96 € 250.84 € 409.12 €127 59,792.14 € 659.96 € 249.13 € 410.82 €128 59,381.32 € 659.96 € 247.42 € 412.53 €129 58,968.78 € 659.96 € 245.70 € 414.25 €130 58,554.53 € 659.96 € 243.98 € 415.98 €131 58,138.55 € 659.96 € 242.24 € 417.71 €132 57,720.84 € 659.96 € 240.50 € 419.45 €133 57,301.39 € 659.96 € 238.76 € 421.20 €134 56,880.19 € 659.96 € 237.00 € 422.95 €135 56,457.23 € 659.96 € 235.24 € 424.72 €136 56,032.52 € 659.96 € 233.47 € 426.49 €137 55,606.03 € 659.96 € 231.69 € 428.26 €138 55,177.77 € 659.96 € 229.91 € 430.05 €139 54,747.72 € 659.96 € 228.12 € 431.84 €140 54,315.88 € 659.96 € 226.32 € 433.64 €141 53,882.24 € 659.96 € 224.51 € 435.45 €142 53,446.79 € 659.96 € 222.69 € 437.26 €143 53,009.53 € 659.96 € 220.87 € 439.08 €144 52,570.45 € 659.96 € 219.04 € 440.91 €145 52,129.53 € 659.96 € 217.21 € 442.75 €146 51,686.79 € 659.96 € 215.36 € 444.59 €147 51,242.19 € 659.96 € 213.51 € 446.45 €148 50,795.74 € 659.96 € 211.65 € 448.31 €149 50,347.44 € 659.96 € 209.78 € 450.17 €150 49,897.26 € 659.96 € 207.91 € 452.05 €151 49,445.21 € 659.96 € 206.02 € 453.93 €
152 48,991.28 € 659.96 € 204.13 € 455.83 €153 48,535.45 € 659.96 € 202.23 € 457.72 €154 48,077.73 € 659.96 € 200.32 € 459.63 €155 47,618.10 € 659.96 € 198.41 € 461.55 €156 47,156.55 € 659.96 € 196.49 € 463.47 €157 46,693.08 € 659.96 € 194.55 € 465.40 €158 46,227.68 € 659.96 € 192.62 € 467.34 €159 45,760.34 € 659.96 € 190.67 € 469.29 €160 45,291.05 € 659.96 € 188.71 € 471.24 €161 44,819.81 € 659.96 € 186.75 € 473.21 €162 44,346.60 € 659.96 € 184.78 € 475.18 €163 43,871.42 € 659.96 € 182.80 € 477.16 €164 43,394.26 € 659.96 € 180.81 € 479.15 €165 42,915.12 € 659.96 € 178.81 € 481.14 €166 42,433.98 € 659.96 € 176.81 € 483.15 €167 41,950.83 € 659.96 € 174.80 € 485.16 €168 41,465.67 € 659.96 € 172.77 € 487.18 €169 40,978.48 € 659.96 € 170.74 € 489.21 €170 40,489.27 € 659.96 € 168.71 € 491.25 €171 39,998.02 € 659.96 € 166.66 € 493.30 €172 39,504.73 € 659.96 € 164.60 € 495.35 €173 39,009.37 € 659.96 € 162.54 € 497.42 €174 38,511.96 € 659.96 € 160.47 € 499.49 €175 38,012.47 € 659.96 € 158.39 € 501.57 €176 37,510.90 € 659.96 € 156.30 € 503.66 €177 37,007.24 € 659.96 € 154.20 € 505.76 €178 36,501.48 € 659.96 € 152.09 € 507.87 €179 35,993.61 € 659.96 € 149.97 € 509.98 €180 35,483.63 € 659.96 € 147.85 € 512.11 €181 34,971.52 € 659.96 € 145.71 € 514.24 €182 34,457.28 € 659.96 € 143.57 € 516.38 €183 33,940.90 € 659.96 € 141.42 € 518.54 €184 33,422.36 € 659.96 € 139.26 € 520.70 €185 32,901.66 € 659.96 € 137.09 € 522.87 €186 32,378.80 € 659.96 € 134.91 € 525.04 €187 31,853.76 € 659.96 € 132.72 € 527.23 €188 31,326.52 € 659.96 € 130.53 € 529.43 €189 30,797.09 € 659.96 € 128.32 € 531.63 €190 30,265.46 € 659.96 € 126.11 € 533.85 €191 29,731.61 € 659.96 € 123.88 € 536.07 €192 29,195.54 € 659.96 € 121.65 € 538.31 €193 28,657.23 € 659.96 € 119.41 € 540.55 €194 28,116.68 € 659.96 € 117.15 € 542.80 €195 27,573.88 € 659.96 € 114.89 € 545.06 €196 27,028.81 € 659.96 € 112.62 € 547.34 €197 26,481.48 € 659.96 € 110.34 € 549.62 €198 25,931.86 € 659.96 € 108.05 € 551.91 €199 25,379.95 € 659.96 € 105.75 € 554.21 €200 24,825.75 € 659.96 € 103.44 € 556.52 €201 24,269.23 € 659.96 € 101.12 € 558.83 €202 23,710.40 € 659.96 € 98.79 € 561.16 €203 23,149.24 € 659.96 € 96.46 € 563.50 €204 22,585.73 € 659.96 € 94.11 € 565.85 €205 22,019.89 € 659.96 € 91.75 € 568.21 €
206 21,451.68 € 659.96 € 89.38 € 570.57 €207 20,881.11 € 659.96 € 87.00 € 572.95 €208 20,308.15 € 659.96 € 84.62 € 575.34 €209 19,732.82 € 659.96 € 82.22 € 577.74 €210 19,155.08 € 659.96 € 79.81 € 580.14 €211 18,574.94 € 659.96 € 77.40 € 582.56 €212 17,992.38 € 659.96 € 74.97 € 584.99 €213 17,407.39 € 659.96 € 72.53 € 587.42 €214 16,819.97 € 659.96 € 70.08 € 589.87 €215 16,230.09 € 659.96 € 67.63 € 592.33 €216 15,637.76 € 659.96 € 65.16 € 594.80 €217 15,042.96 € 659.96 € 62.68 € 597.28 €218 14,445.69 € 659.96 € 60.19 € 599.77 €219 13,845.92 € 659.96 € 57.69 € 602.26 €220 13,243.66 € 659.96 € 55.18 € 604.77 €221 12,638.88 € 659.96 € 52.66 € 607.29 €222 12,031.59 € 659.96 € 50.13 € 609.82 €223 11,421.77 € 659.96 € 47.59 € 612.37 €224 10,809.40 € 659.96 € 45.04 € 614.92 €225 10,194.48 € 659.96 € 42.48 € 617.48 €226 9,577.01 € 659.96 € 39.90 € 620.05 €227 8,956.95 € 659.96 € 37.32 € 622.64 €228 8,334.32 € 659.96 € 34.73 € 625.23 €229 7,709.09 € 659.96 € 32.12 € 627.83 €230 7,081.25 € 659.96 € 29.51 € 630.45 €231 6,450.80 € 659.96 € 26.88 € 633.08 €232 5,817.73 € 659.96 € 24.24 € 635.72 €233 5,182.01 € 659.96 € 21.59 € 638.36 €234 4,543.65 € 659.96 € 18.93 € 641.02 €235 3,902.62 € 659.96 € 16.26 € 643.69 €236 3,258.93 € 659.96 € 13.58 € 646.38 €237 2,612.55 € 659.96 € 10.89 € 649.07 €238 1,963.48 € 659.96 € 8.18 € 651.77 €239 1,311.71 € 659.96 € 5.47 € 654.49 €240 657.22 € 659.96 € 2.74 € 657.22 €
100,000.00 €58,389.38 €
158,389.38 €
CAP. PENDIENTE99,756.71 €99,512.41 €99,267.09 €99,020.74 €98,773.38 €98,524.98 €98,275.54 €98,025.07 €97,773.55 €97,520.98 €97,267.36 €97,012.69 €96,756.95 €96,500.15 €96,242.28 €95,983.33 €95,723.31 €95,462.20 €95,200.00 €94,936.71 €94,672.33 €94,406.84 €94,140.25 €93,872.54 €93,603.72 €93,333.78 €93,062.72 €92,790.52 €92,517.19 €92,242.72 €91,967.11 €91,690.35 €91,412.44 €91,133.37 €90,853.14 €90,571.74 €90,289.16 €90,005.41 €89,720.48 €89,434.36 €89,147.05 €88,858.54 €88,568.82 €
100,000.00 €
58,389.38 €
Distribución Capital - Intereses
Total Capital: Total Intereses:
88,277.91 €87,985.77 €87,692.43 €87,397.86 €87,102.06 €86,805.03 €86,506.76 €86,207.25 €85,906.49 €85,604.48 €85,301.21 €84,996.67 €84,690.87 €84,383.79 €84,075.44 €83,765.79 €83,454.86 €83,142.64 €82,829.11 €82,514.27 €82,198.13 €81,880.66 €81,561.88 €81,241.76 €80,920.31 €80,597.53 €80,273.39 €79,947.91 €79,621.07 €79,292.87 €78,963.30 €78,632.36 €78,300.04 €77,966.33 €77,631.24 €77,294.74 €76,956.85 €76,617.55 €76,276.83 €75,934.70 €75,591.14 €75,246.14 €74,899.71 €74,551.84 €74,202.52 €73,851.74 €73,499.50 €73,145.79 €72,790.61 €72,433.95 €72,075.80 €71,716.16 €71,355.02 €70,992.38 €
70,628.22 €70,262.55 €69,895.36 €69,526.63 €69,156.37 €68,784.57 €68,411.21 €68,036.30 €67,659.83 €67,281.79 €66,902.18 €66,520.98 €66,138.20 €65,753.82 €65,367.83 €64,980.24 €64,591.04 €64,200.21 €63,807.76 €63,413.67 €63,017.94 €62,620.56 €62,221.52 €61,820.82 €61,418.45 €61,014.40 €60,608.68 €60,201.26 €59,792.14 €59,381.32 €58,968.78 €58,554.53 €58,138.55 €57,720.84 €57,301.39 €56,880.19 €56,457.23 €56,032.52 €55,606.03 €55,177.77 €54,747.72 €54,315.88 €53,882.24 €53,446.79 €53,009.53 €52,570.45 €52,129.53 €51,686.79 €51,242.19 €50,795.74 €50,347.44 €49,897.26 €49,445.21 €48,991.28 €
48,535.45 €48,077.73 €47,618.10 €47,156.55 €46,693.08 €46,227.68 €45,760.34 €45,291.05 €44,819.81 €44,346.60 €43,871.42 €43,394.26 €42,915.12 €42,433.98 €41,950.83 €41,465.67 €40,978.48 €40,489.27 €39,998.02 €39,504.73 €39,009.37 €38,511.96 €38,012.47 €37,510.90 €37,007.24 €36,501.48 €35,993.61 €35,483.63 €34,971.52 €34,457.28 €33,940.90 €33,422.36 €32,901.66 €32,378.80 €31,853.76 €31,326.52 €30,797.09 €30,265.46 €29,731.61 €29,195.54 €28,657.23 €28,116.68 €27,573.88 €27,028.81 €26,481.48 €25,931.86 €25,379.95 €24,825.75 €24,269.23 €23,710.40 €23,149.24 €22,585.73 €22,019.89 €21,451.68 €
20,881.11 €20,308.15 €19,732.82 €19,155.08 €18,574.94 €17,992.38 €17,407.39 €16,819.97 €16,230.09 €15,637.76 €15,042.96 €14,445.69 €13,845.92 €13,243.66 €12,638.88 €12,031.59 €11,421.77 €10,809.40 €10,194.48 €
9,577.01 €8,956.95 €8,334.32 €7,709.09 €7,081.25 €6,450.80 €5,817.73 €5,182.01 €4,543.65 €3,902.62 €3,258.93 €2,612.55 €1,963.48 €1,311.71 €
657.22 €0.00 €