23
Período 0 Capital ### 1 Frecuencia de pago Mensual 2 Tipo interés nominal 30% 3 Tipo de interés efec 0.0221044506 4 Duración en años 3 Años 5 Número total de pago 72 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 42 ttp://ambito-financiero.co

Prestamo Excel Sistema Frances

Embed Size (px)

DESCRIPTION

Prestamo Excel Sistema Frances

Citation preview

Prstamo francshttp://ambito-financiero.comPerodoMensualidadInteresesAmortizacinCapital vivoCapital Amortizado015,000.00 Capital15,000.00 1418.21 331.57 86.64 14,913.36 86.64 Frecuencia de pagoMensual2418.21 329.65 88.56 14,824.80 175.20 Tipo inters nominal30%3418.21 327.69 90.52 14,734.28 265.72 Tipo de inters efectivo0.02210445064418.21 325.69 92.52 14,641.77 358.23 Duracin en aos3.05418.21 323.65 94.56 14,547.20 452.80 Nmero total de pagos726418.21 321.56 96.65 14,450.55 549.45 7418.21 319.42 98.79 14,351.76 648.24 8418.21 317.24 100.97 14,250.79 749.21 9418.21 315.01 103.20 14,147.59 852.41 10418.21 312.72 105.49 14,042.10 957.90 11418.21 310.39 107.82 13,934.29 1,065.71 12418.21 308.01 110.20 13,824.09 1,175.91 13418.21 305.57 112.64 13,711.45 1,288.55 14418.21 303.08 115.13 13,596.32 1,403.68 15418.21 300.54 117.67 13,478.65 1,521.35 16418.21 297.94 120.27 13,358.38 1,641.62 17418.21 295.28 122.93 13,235.45 1,764.55 18418.21 292.56 125.65 13,109.80 1,890.20 19418.21 289.79 128.42 12,981.38 2,018.62 20418.21 286.95 131.26 12,850.11 2,149.89 21418.21 284.04 134.17 12,715.95 2,284.05 22418.21 281.08 137.13 12,578.82 2,421.18 23418.21 278.05 140.16 12,438.66 2,561.34 24418.21 274.95 143.26 12,295.40 2,704.60 25418.21 271.78 146.43 12,148.97 2,851.03 26418.21 268.55 149.66 11,999.31 3,000.69 27418.21 265.24 152.97 11,846.33 3,153.67 28418.21 261.86 156.35 11,689.98 3,310.02 29418.21 258.40 159.81 11,530.17 3,469.83 30418.21 254.87 163.34 11,366.83 3,633.17 31418.21 251.26 166.95 11,199.88 3,800.12 32418.21 247.57 170.64 11,029.24 3,970.76 33418.21 243.80 174.41 10,854.82 4,145.18 34418.21 239.94 178.27 10,676.55 4,323.45 35418.21 236.00 182.21 10,494.34 4,505.66 36418.21 231.97 186.24 10,308.10 4,691.90 37418.21 227.85 190.35 10,117.75 4,882.25 38418.21 223.65 194.56 9,923.18 5,076.82 39418.21 219.35 198.86 9,724.32 5,275.68 40418.21 214.95 203.26 9,521.06 5,478.94 41418.21 210.46 207.75 9,313.31 5,686.69 42418.21 205.87 212.34 9,100.96 5,899.04 43418.21 201.17 217.04 8,883.93 6,116.07 44418.21 196.37 221.84 8,662.09 6,337.91 45418.21 191.47 226.74 8,435.35 6,564.65 46418.21 186.46 231.75 8,203.60 6,796.40 47418.21 181.34 236.87 7,966.73 7,033.27 48418.21 176.10 242.11 7,724.62 7,275.38 49418.21 170.75 247.46 7,477.16 7,522.84 50418.21 165.28 252.93 7,224.22 7,775.78 51418.21 159.69 258.52 6,965.70 8,034.30 52418.21 153.97 264.24 6,701.47 8,298.53 53418.21 148.13 270.08 6,431.39 8,568.61 54418.21 142.16 276.05 6,155.34 8,844.66 55418.21 136.06 282.15 5,873.19 9,126.81 56418.21 129.82 288.39 5,584.80 9,415.20 57418.21 123.45 294.76 5,290.04 9,709.96 58418.21 116.93 301.28 4,988.77 10,011.23 59418.21 110.27 307.94 4,680.83 10,319.17 60418.21 103.47 314.74 4,366.09 10,633.91 61418.21 96.51 321.70 4,044.39 10,955.61 62418.21 89.40 328.81 3,715.58 11,284.42 63418.21 82.13 336.08 3,379.50 11,620.50 64418.21 74.70 343.51 3,035.99 11,964.01 65418.21 67.11 351.10 2,684.89 12,315.11 66418.21 59.35 358.86 2,326.03 12,673.97 67418.21 51.42 366.79 1,959.23 13,040.77 68418.21 43.31 374.90 1,584.33 13,415.67 69418.21 35.02 383.19 1,201.14 13,798.86 70418.21 26.55 391.66 809.48 14,190.52 71418.21 17.89 400.32 409.17 14,590.83 72418.21 9.04 409.17 0.00 15,000.00

Hoja2

Hoja3