Tabla Amortizacion Met Frances

  • Published on
    14-Nov-2014

  • View
    16

  • Download
    1

Embed Size (px)

DESCRIPTION

Hoja de excel que realiza los cuadros de amortizacin de cualquier prstamo con el mtodo francs

Transcript

<p>Datos InicialesCapital pendiente Tipo de Inters Anual N Aos de amortizacin N pagos por ao Total pagos pendientes Tipo de Inters por periodo</p> <p>Valor100,000.00 5.000% 20 12 240 0.4167%</p> <p>Total Capital: Total Intereses: Total Pagado</p> <p>N PAGO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41</p> <p>CAPITAL INICIAL PAGO CUOTA INTERESES CAP. AMORTIZADO 100,000.00 659.96 416.67 243.29 99,756.71 659.96 415.65 244.30 99,512.41 659.96 414.64 245.32 99,267.09 659.96 413.61 246.34 99,020.74 659.96 412.59 247.37 98,773.38 659.96 411.56 248.40 98,524.98 659.96 410.52 249.44 98,275.54 659.96 409.48 250.47 98,025.07 659.96 408.44 251.52 97,773.55 659.96 407.39 252.57 97,520.98 659.96 406.34 253.62 97,267.36 659.96 405.28 254.68 97,012.69 659.96 404.22 255.74 96,756.95 659.96 403.15 256.80 96,500.15 659.96 402.08 257.87 96,242.28 659.96 401.01 258.95 95,983.33 659.96 399.93 260.03 95,723.31 659.96 398.85 261.11 95,462.20 659.96 397.76 262.20 95,200.00 659.96 396.67 263.29 94,936.71 659.96 395.57 264.39 94,672.33 659.96 394.47 265.49 94,406.84 659.96 393.36 266.59 94,140.25 659.96 392.25 267.70 93,872.54 659.96 391.14 268.82 93,603.72 659.96 390.02 269.94 93,333.78 659.96 388.89 271.06 93,062.72 659.96 387.76 272.19 92,790.52 659.96 386.63 273.33 92,517.19 659.96 385.49 274.47 92,242.72 659.96 384.34 275.61 91,967.11 659.96 383.20 276.76 91,690.35 659.96 382.04 277.91 91,412.44 659.96 380.89 279.07 91,133.37 659.96 379.72 280.23 90,853.14 659.96 378.55 281.40 90,571.74 659.96 377.38 282.57 90,289.16 659.96 376.20 283.75 90,005.41 659.96 375.02 284.93 89,720.48 659.96 373.84 286.12 89,434.36 659.96 372.64 287.31 </p> <p>42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93</p> <p>89,147.05 88,858.54 88,568.82 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 </p> <p>659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 </p> <p>371.45 370.24 369.04 367.82 366.61 365.39 364.16 362.93 361.69 360.44 359.20 357.94 356.69 355.42 354.15 352.88 351.60 350.31 349.02 347.73 346.43 345.12 343.81 342.49 341.17 339.84 338.51 337.17 335.82 334.47 333.12 331.75 330.39 329.01 327.63 326.25 324.86 323.46 322.06 320.65 319.24 317.82 316.39 314.96 313.53 312.08 310.63 309.18 307.72 306.25 304.77 303.29 </p> <p>288.51 289.71 290.92 292.13 293.35 294.57 295.80 297.03 298.27 299.51 300.76 302.01 303.27 304.53 305.80 307.08 308.36 309.64 310.93 312.23 313.53 314.83 316.15 317.46 318.79 320.11 321.45 322.79 324.13 325.48 326.84 328.20 329.57 330.94 332.32 333.71 335.10 336.49 337.89 339.30 340.72 342.14 343.56 344.99 346.43 347.87 349.32 350.78 352.24 353.71 355.18 356.66 </p> <p>94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145</p> <p>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 </p> <p>659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 </p> <p>301.81 300.32 298.82 297.31 295.80 294.28 292.76 291.23 289.69 288.15 286.60 285.05 283.48 281.92 280.34 278.76 277.17 275.58 273.97 272.37 270.75 269.13 267.50 265.87 264.22 262.57 260.92 259.26 257.59 255.91 254.23 252.54 250.84 249.13 247.42 245.70 243.98 242.24 240.50 238.76 237.00 235.24 233.47 231.69 229.91 228.12 226.32 224.51 222.69 220.87 219.04 217.21 </p> <p>358.15 359.64 361.14 362.64 364.15 365.67 367.20 368.73 370.26 371.80 373.35 374.91 376.47 378.04 379.61 381.20 382.78 384.38 385.98 387.59 389.20 390.83 392.45 394.09 395.73 397.38 399.04 400.70 402.37 404.05 405.73 407.42 409.12 410.82 412.53 414.25 415.98 417.71 419.45 421.20 422.95 424.72 426.49 428.26 430.05 431.84 433.64 435.45 437.26 439.08 440.91 442.75 </p> <p>146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197</p> <p>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 </p> <p>659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 </p> <p>215.36 213.51 211.65 209.78 207.91 206.02 204.13 202.23 200.32 198.41 196.49 194.55 192.62 190.67 188.71 186.75 184.78 182.80 180.81 178.81 176.81 174.80 172.77 170.74 168.71 166.66 164.60 162.54 160.47 158.39 156.30 154.20 152.09 149.97 147.85 145.71 143.57 141.42 139.26 137.09 134.91 132.72 130.53 128.32 126.11 123.88 121.65 119.41 117.15 114.89 112.62 110.34 </p> <p>444.59 446.45 448.31 450.17 452.05 453.93 455.83 457.72 459.63 461.55 463.47 465.40 467.34 469.29 471.24 473.21 475.18 477.16 479.15 481.14 483.15 485.16 487.18 489.21 491.25 493.30 495.35 497.42 499.49 501.57 503.66 505.76 507.87 509.98 512.11 514.24 516.38 518.54 520.70 522.87 525.04 527.23 529.43 531.63 533.85 536.07 538.31 540.55 542.80 545.06 547.34 549.62 </p> <p>198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240</p> <p>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 </p> <p>659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 659.96 </p> <p>108.05 105.75 103.44 101.12 98.79 96.46 94.11 91.75 89.38 87.00 84.62 82.22 79.81 77.40 74.97 72.53 70.08 67.63 65.16 62.68 60.19 57.69 55.18 52.66 50.13 47.59 45.04 42.48 39.90 37.32 34.73 32.12 29.51 26.88 24.24 21.59 18.93 16.26 13.58 10.89 8.18 5.47 2.74 </p> <p>551.91 554.21 556.52 558.83 561.16 563.50 565.85 568.21 570.57 572.95 575.34 577.74 580.14 582.56 584.99 587.42 589.87 592.33 594.80 597.28 599.77 602.26 604.77 607.29 609.82 612.37 614.92 617.48 620.05 622.64 625.23 627.83 630.45 633.08 635.72 638.36 641.02 643.69 646.38 649.07 651.77 654.49 657.22 </p> <p>100,000.00 58,389.38 158,389.38 </p> <p>Distribucin Capital - Intereses</p> <p>CAP. PENDIENTE 99,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 </p> <p>100,000.00 </p> <p>58,389.38 </p> <p>Total Capital:</p> <p>Total Intereses:</p> <p>88,858.54 88,568.82 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 </p> <p>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 </p> <p>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 </p> <p>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 </p>