17
CUOTA FIJA CAPITAL ### TASA MENSUAL 2.00% PERIODOS $ 18.00 PAGO ### PERIODO SALDO INICIAL CUOTA INTERESES 1 1 ### ### $ 900,000.00 2 2 ### ### $ 857,968.11 3 0 ### ### $ 815,095.58 4 1 ### ### $ 771,365.60 5 2 ### ### $ 726,761.02 6 0 ### ### $ 681,264.35 7 1 ### ### $ 634,857.74 8 2 ### ### $ 587,523.00 9 0 ### ### $ 539,241.57 10 1 ### ### $ 489,994.51 11 2 ### ### $ 439,762.51 12 0 ### ### $ 388,525.87 13 1 ### ### $ 336,264.49 14 2 ### ### $ 282,957.89 15 0 ### ### $ 228,585.16 16 1 ### ### $ 173,124.97 17 2 ### ### $ 116,555.58 18 0 ### ### $ 58,854.80 1 $ - $ - $ - ###

Tabla Amortizaciones

Embed Size (px)

DESCRIPTION

MATEMATICA FINANCIERA

Citation preview

CFCUOTA FIJACAPITAL$ 45,000,000.00TASA MENSUAL2.00%PERIODOS$ 18.00PAGO$ 3,001,594.60PERIODOSALDO INICIALCUOTAINTERESESAMORTIZACIONSALDO FINAL11$ 45,000,000.00$ 3,001,594.60$ 900,000.00$ 2,101,594.60$ 42,898,405.4022$ 42,898,405.40$ 3,001,594.60$ 857,968.11$ 2,143,626.49$ 40,754,778.9130$ 40,754,778.91$ 3,001,594.60$ 815,095.58$ 2,186,499.02$ 38,568,279.9041$ 38,568,279.90$ 3,001,594.60$ 771,365.60$ 2,230,229.00$ 36,338,050.9052$ 36,338,050.90$ 3,001,594.60$ 726,761.02$ 2,274,833.58$ 34,063,217.3260$ 34,063,217.32$ 3,001,594.60$ 681,264.35$ 2,320,330.25$ 31,742,887.0771$ 31,742,887.07$ 3,001,594.60$ 634,857.74$ 2,366,736.86$ 29,376,150.2182$ 29,376,150.21$ 3,001,594.60$ 587,523.00$ 2,414,071.59$ 26,962,078.6290$ 26,962,078.62$ 3,001,594.60$ 539,241.57$ 2,462,353.02$ 24,499,725.60101$ 24,499,725.60$ 3,001,594.60$ 489,994.51$ 2,511,600.08$ 21,988,125.51112$ 21,988,125.51$ 3,001,594.60$ 439,762.51$ 2,561,832.09$ 19,426,293.42120$ 19,426,293.42$ 3,001,594.60$ 388,525.87$ 2,613,068.73$ 16,813,224.70131$ 16,813,224.70$ 3,001,594.60$ 336,264.49$ 2,665,330.10$ 14,147,894.59142$ 14,147,894.59$ 3,001,594.60$ 282,957.89$ 2,718,636.70$ 11,429,257.89150$ 11,429,257.89$ 3,001,594.60$ 228,585.16$ 2,773,009.44$ 8,656,248.45161$ 8,656,248.45$ 3,001,594.60$ 173,124.97$ 2,828,469.63$ 5,827,778.82172$ 5,827,778.82$ 3,001,594.60$ 116,555.58$ 2,885,039.02$ 2,942,739.80180$ 2,942,739.80$ 3,001,594.60$ 58,854.80$ 2,942,739.80($ 0.00)10.00.00.0$ 0.00$ 0.00$ 9,028,702.74

AFCAMORTIZACION CUOTA FIJA A CAPITALCAPITAL$ 15,000,000.00TASA MENSUAL1.52%PERIODOS$ 12

PERIODOSALDO INICIALCUOTAINTERESESAMORTIZACIONSALDO FINAL1$ 15,000,000.00$ 1,478,000.00$ 228,000.00$ 1,250,000.00$ 13,750,000.002$ 13,750,000.00$ 1,459,000.00$ 209,000.00$ 1,250,000.00$ 12,500,000.003$ 12,500,000.00$ 1,440,000.00$ 190,000.00$ 1,250,000.00$ 11,250,000.004$ 11,250,000.00$ 1,421,000.00$ 171,000.00$ 1,250,000.00$ 10,000,000.005$ 10,000,000.00$ 1,402,000.00$ 152,000.00$ 1,250,000.00$ 8,750,000.006$ 8,750,000.00$ 1,383,000.00$ 133,000.00$ 1,250,000.00$ 7,500,000.007$ 7,500,000.00$ 1,364,000.00$ 114,000.00$ 1,250,000.00$ 6,250,000.008$ 6,250,000.00$ 1,345,000.00$ 95,000.00$ 1,250,000.00$ 5,000,000.009$ 5,000,000.00$ 1,326,000.00$ 76,000.00$ 1,250,000.00$ 3,750,000.0010$ 3,750,000.00$ 1,307,000.00$ 57,000.00$ 1,250,000.00$ 2,500,000.0011$ 2,500,000.00$ 1,288,000.00$ 38,000.00$ 1,250,000.00$ 1,250,000.0012$ 1,250,000.00$ 1,269,000.00$ 19,000.00$ 1,250,000.000.0

CFPGPAGO A CUOTA FIJA CON PERIODO DE GRACIA

CAPITAL$ 15,000,000.00PERIODOS DE GRACIA$ 6.00TASA MENSUAL$ 0.02PERIODOS TOTALES$ 18.00PERIODOS DE AMORTIZACION$ 12.00PERIODOSALDO INICIALCUOTAINTERESESAMORTIZACIONSALDO FINAL1$ 15,000,000.00$ 322,500.00$ 322,500.000.0$ 15,000,000.002$ 15,000,000.00$ 322,500.00$ 322,500.000.0$ 15,000,000.003$ 15,000,000.00$ 322,500.00$ 322,500.000.0$ 15,000,000.004$ 15,000,000.00$ 322,500.00$ 322,500.000.0$ 15,000,000.005$ 15,000,000.00$ 322,500.00$ 322,500.000.0$ 15,000,000.006$ 15,000,000.00$ 322,500.00$ 322,500.000.0$ 15,000,000.007$ 15,000,000.00$ 1,431,492.68$ 322,500.00$ 1,108,992.68$ 13,891,007.328$ 13,891,007.32$ 1,431,492.68$ 298,656.66$ 1,132,836.03$ 12,758,171.299$ 12,758,171.29$ 1,431,492.68$ 274,300.68$ 1,157,192.00$ 11,600,979.2910$ 11,600,979.29$ 1,431,492.68$ 249,421.05$ 1,182,071.63$ 10,418,907.6611$ 10,418,907.66$ 1,431,492.68$ 224,006.51$ 1,207,486.17$ 9,211,421.4912$ 9,211,421.49$ 1,431,492.68$ 198,045.56$ 1,233,447.12$ 7,977,974.3613$ 7,977,974.36$ 1,431,492.68$ 171,526.45$ 1,259,966.24$ 6,718,008.1314$ 6,718,008.13$ 1,431,492.68$ 144,437.17$ 1,287,055.51$ 5,430,952.6215$ 5,430,952.62$ 1,431,492.68$ 116,765.48$ 1,314,727.20$ 4,116,225.4216$ 4,116,225.42$ 1,431,492.68$ 88,498.85$ 1,342,993.84$ 2,773,231.5817$ 2,773,231.58$ 1,431,492.68$ 59,624.48$ 1,371,868.21$ 1,401,363.3718$ 1,401,363.37$ 1,431,492.68$ 30,129.31$ 1,401,363.37$ 0.00

CFPMCUOTA FIJA CON PERIODO MUERTOCAPITAL$ 15,000,000.00PERIODOS MUERTOS6TASA MENSUAL2.15%PERIODOS TOTALES11PERIODOS AMORTIZACION5CAPITAL AMORTIZAR$ 17,042,036.25PERIODOSALDO INICIALCUOTAINTERESESAMORTIZACION SALDO FINAL1$ 15,000,000.000.0$ 322,500.00$ (322,500.00)$ 15,322,500.002$ 15,322,500.000.0$ 329,433.75$ (329,433.75)$ 15,651,933.753$ 15,651,933.750.0$ 336,516.58$ (336,516.58)$ 15,988,450.334$ 15,988,450.330.0$ 343,751.68$ (343,751.68)$ 16,332,202.015$ 16,332,202.010.0$ 351,142.34$ (351,142.34)$ 16,683,344.356$ 16,683,344.350.0$ 358,691.90$ (358,691.90)$ 17,042,036.257$ 17,042,036.25$ 3,631,366.58$ 366,403.78$ 3,264,962.80$ 13,777,073.458$ 13,777,073.45$ 3,631,366.58$ 296,207.08$ 3,335,159.50$ 10,441,913.959$ 10,441,913.95$ 3,631,366.58$ 224,501.15$ 3,406,865.43$ 7,035,048.5110$ 7,035,048.51$ 3,631,366.58$ 151,253.54$ 3,480,113.04$ 3,554,935.4711$ 3,554,935.47$ 3,631,366.58$ 76,431.11$ 3,554,935.47$ 0.00

AFC2AMORTIZACION FIJA A CAPITALCAPITAL$ 20,000,000.00TASA MENSUAL1.46%PERIODOS6PAGO$ 3,505,723.81PERIODOSALDO INICIALCUOTAINTERESESAMORTIZACIONSALDO FINAL1$ 20,000,000.00$ 3,505,723.81$ 292,000.00$ 3,213,723.81$ 16,786,276.192$ 16,786,276.19$ 3,505,723.81$ 245,079.63$ 3,260,644.17$ 13,525,632.023$ 13,525,632.02$ 3,505,723.81$ 197,474.23$ 3,308,249.58$ 10,217,382.444$ 10,217,382.44$ 3,505,723.81$ 149,173.78$ 3,356,550.02$ 6,860,832.425$ 6,860,832.42$ 3,505,723.81$ 100,168.15$ 3,405,555.65$ 3,455,276.776$ 3,455,276.77$ 3,505,723.81$ 50,447.04$ 3,455,276.77$ (0.00)

ACF2AMORTIZACION CUOTA FIJA A CAPITALCAPITAL20000000TASA MENSUAL1.46%PERIODOS6

PERIODOSALDO INICIALCUOTAINTERESESAMORTIZACION SALDO FINAL1$ 20,000,000.00$ 3,625,333.33$ 292,000.00$ 3,333,333.33$ 16,666,666.672$ 16,666,666.67$ 3,576,666.67$ 243,333.33$ 3,333,333.33$ 13,333,333.333$ 13,333,333.33$ 3,528,000.00$ 194,666.67$ 3,333,333.33$ 10,000,000.004$ 10,000,000.00$ 3,479,333.33$ 146,000.00$ 3,333,333.33$ 6,666,666.675$ 6,666,666.67$ 3,430,666.67$ 97,333.33$ 3,333,333.33$ 3,333,333.336$ 3,333,333.33$ 3,382,000.00$ 48,666.67$ 3,333,333.330.0

CFPG2PAGO A CUOTA FIJA CON PERIODO DE GRACIACAPITAL$ 20,000,000.00PERIODOS DE GRACIA4TASA MENSUAL1.8%PERIODOS TOTALES12PERIODOS AMORTIZACION8PERIODOSALDO INICIALCUOTAINTERESESAMORTIZACION SALDO FINAL1$ 20,000,000.00$ 360,000.00$ 360,000.000.0$ 20,000,000.002$ 20,000,000.00$ 360,000.00$ 360,000.000.0$ 20,000,000.003$ 20,000,000.00$ 360,000.00$ 360,000.000.0$ 20,000,000.004$ 20,000,000.00$ 360,000.00$ 360,000.000.0$ 20,000,000.005$ 20,000,000.00$ 2,706,713.23$ 360,000.00$ 2,346,713.23$ 17,653,286.776$ 17,653,286.77$ 2,706,713.23$ 317,759.16$ 2,388,954.07$ 15,264,332.717$ 15,264,332.71$ 2,706,713.23$ 274,757.99$ 2,431,955.24$ 12,832,377.478$ 12,832,377.47$ 2,706,713.23$ 230,982.79$ 2,475,730.43$ 10,356,647.039$ 10,356,647.03$ 2,706,713.23$ 186,419.65$ 2,520,293.58$ 7,836,353.4510$ 7,836,353.45$ 2,706,713.23$ 141,054.36$ 2,565,658.87$ 5,270,694.5811$ 5,270,694.58$ 2,706,713.23$ 94,872.50$ 2,611,840.73$ 2,658,853.8612$ 2,658,853.86$ 2,706,713.23$ 47,859.37$ 2,658,853.86$ 0.00

CFPM2CUOTA FIJA CON PERIODO MUERTOCAPITAL$20,000,000PERIODOS MUERTOS4TASA MENSUAL1.80%PERIODOS TOTALES12PERIODOS AMORTIZACION8CAPITAL AMORTIZAR$21,479,349PERIODOSALDO INICIALCUOTAINTERESESAMORTIZACION SALDO FINAL1$20,000,0000.0$360,000-$360,000$20,360,0002$20,360,0000.0$366,480-$366,480$20,726,4803$20,726,4800.0$373,077-$373,077$21,099,5574$21,099,5570.0$379,792-$379,792$21,479,3495$21,479,349$2,906,922$386,628$2,520,294$18,959,0556$18,959,055$2,906,922$341,263$2,565,659$16,393,3967$16,393,396$2,906,922$295,081$2,611,841$13,781,5558$13,781,555$2,906,922$248,068$2,658,854$11,122,7029$11,122,702$2,906,922$200,209$2,706,713$8,415,98810$8,415,988$2,906,922$151,488$2,755,434$5,660,55411$5,660,554$2,906,922$101,890$2,805,032$2,855,52212$2,855,522$2,906,922$51,399$2,855,522$0