prestamo excel sistema frances

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

Upload: alejandro

Post on 07-Nov-2015

219 views

Category:

Documents


2 download

DESCRIPTION

Prestamo Excel Sistema Frances

TRANSCRIPT

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