trabajo individual 2 final

10
Diplomado en Evaluación Financiera de Proyectos Módulo I - Nivelación en Matemática Financiera Conferencista: Luis Fernando Gómez Página 1 de 10 EJERCICIO DE TABLAS DE AMORTIZACION 1.800% tasa de interés mensual monto $46,180,600 N = 12 periodo muerto 4 periodos inicial interés amort cuota final 1 $43,000,000.00 $774,000.00 $43,774,000.00 2 $43,774,000.00 $787,932.00 $44,561,932.00 3 $44,561,932.00 $802,114.78 $45,364,046.78 4 $45,364,046.78 $816,552.84 $46,180,599.62 1 $46,180,599.62 $831,250.79 $3,482,108.50 $4,313,359.30 $42,698,491.11 2 $42,698,491.11 $768,572.84 $3,544,786.46 $4,313,359.30 $39,153,704.66 3 $39,153,704.66 $704,766.68 $3,608,592.61 $4,313,359.30 $35,545,112.04 4 $35,545,112.04 $639,812.02 $3,673,547.28 $4,313,359.30 $31,871,564.76 5 $31,871,564.76 $573,688.17 $3,739,671.13 $4,313,359.30 $28,131,893.63 6 $28,131,893.63 $506,374.09 $3,806,985.21 $4,313,359.30 $24,324,908.42 7 $24,324,908.42 $437,848.35 $3,875,510.95 $4,313,359.30 $20,449,397.47 8 $20,449,397.47 $368,089.15 $3,945,270.14 $4,313,359.30 $16,504,127.33 9 $16,504,127.33 $297,074.29 $4,016,285.01 $4,313,359.30 $12,487,842.33 10 $12,487,842.33 $224,781.16 $4,088,578.14 $4,313,359.30 $8,399,264.19 11 $8,399,264.19 $151,186.76 $4,162,172.54 $4,313,359.30 $4,237,091.65 12 $4,237,091.65 $76,267.65 $4,237,091.65 $4,313,359.30 ($0.00) LAS CELDAS DE COLOR AMARILLO ( ) SON PARAMETROS

Upload: david-santiago-castaneda-vargas

Post on 16-Jan-2016

231 views

Category:

Documents


0 download

DESCRIPTION

FDG

TRANSCRIPT

Page 1: Trabajo Individual 2 Final

Diplomado en Evaluación Financiera de ProyectosMódulo I - Nivelación en Matemática Financiera

Conferencista: Luis Fernando Gómez

Página 1 de 9

EJERCICIO DE TABLAS DE AMORTIZACION

1.800% tasa de interés mensual monto $46,180,600N = 12 periodo muerto 4

periodos inicial interés amort cuota final1 $43,000,000.00 $774,000.00 $43,774,000.00

2 $43,774,000.00 $787,932.00 $44,561,932.00

3 $44,561,932.00 $802,114.78 $45,364,046.78 4 $45,364,046.78 $816,552.84 $46,180,599.62 1 $46,180,599.62 $831,250.79 $3,482,108.50 $4,313,359.30 $42,698,491.11 2 $42,698,491.11 $768,572.84 $3,544,786.46 $4,313,359.30 $39,153,704.66 3 $39,153,704.66 $704,766.68 $3,608,592.61 $4,313,359.30 $35,545,112.04 4 $35,545,112.04 $639,812.02 $3,673,547.28 $4,313,359.30 $31,871,564.76 5 $31,871,564.76 $573,688.17 $3,739,671.13 $4,313,359.30 $28,131,893.63 6 $28,131,893.63 $506,374.09 $3,806,985.21 $4,313,359.30 $24,324,908.42 7 $24,324,908.42 $437,848.35 $3,875,510.95 $4,313,359.30 $20,449,397.47 8 $20,449,397.47 $368,089.15 $3,945,270.14 $4,313,359.30 $16,504,127.33 9 $16,504,127.33 $297,074.29 $4,016,285.01 $4,313,359.30 $12,487,842.33 10 $12,487,842.33 $224,781.16 $4,088,578.14 $4,313,359.30 $8,399,264.19 11 $8,399,264.19 $151,186.76 $4,162,172.54 $4,313,359.30 $4,237,091.65 12 $4,237,091.65 $76,267.65 $4,237,091.65 $4,313,359.30 ($0.00)

LAS CELDAS DE COLOR AMARILLO ( ) SON PARAMETROS

Page 2: Trabajo Individual 2 Final

Diplomado en Evaluación Financiera de ProyectosMódulo I - Nivelación en Matemática Financiera

Conferencista: Luis Fernando Gómez

Página 2 de 9

EJERCICIO DE TABLAS DE AMORTIZACION

1.800% tasa de interés mensual monto $43,000,000N = 12 Periodo de gracia 4

periodos inicial interés amort cuota final1 $43,000,000.00 $774,000.00 $0.00 $774,000.00

2 $43,000,000.00 $774,000.00 $0.00 $774,000.00

3 $43,000,000.00 $774,000.00 $0.00 $774,000.00 4 $43,000,000.00 $774,000.00 $0.00 $774,000.00 $43,000,000.00 5 $43,000,000.00 $774,000.00 $3,242,285.01 $4,016,285.01 $39,757,714.99 6 $39,757,714.99 $715,638.87 $3,300,646.14 $4,016,285.01 $36,457,068.86 7 $36,457,068.86 $656,227.24 $3,360,057.77 $4,016,285.01 $33,097,011.09 8 $33,097,011.09 $595,746.20 $3,420,538.81 $4,016,285.01 $29,676,472.29 9 $29,676,472.29 $534,176.50 $3,482,108.50 $4,016,285.01 $26,194,363.78 10 $26,194,363.78 $471,498.55 $3,544,786.46 $4,016,285.01 $22,649,577.33 11 $22,649,577.33 $407,692.39 $3,608,592.61 $4,016,285.01 $19,040,984.71 12 $19,040,984.71 $342,737.72 $3,673,547.28 $4,016,285.01 $15,367,437.43 13 $15,367,437.43 $276,613.87 $3,739,671.13 $4,016,285.01 $11,627,766.30 14 $11,627,766.30 $209,299.79 $3,806,985.21 $4,016,285.01 $7,820,781.09 15 $7,820,781.09 $140,774.06 $3,875,510.95 $4,016,285.01 $3,945,270.14 16 $3,945,270.14 $71,014.86 $3,945,270.14 $4,016,285.01 ($0.00)

LAS CELDAS DE COLOR AMARILLO ( ) SON PARAMETROS

Page 3: Trabajo Individual 2 Final

Diplomado en Evaluación Financiera de ProyectosMódulo I - Nivelación en Matemática Financiera

Conferencista: Luis Fernando Gómez

Página 3 de 9

EJERCICIO DE TABLAS DE AMORTIZACION

LAS CELDAS DE COLOR AMARILLO ( ) SON PARAMETROS

Page 4: Trabajo Individual 2 Final

Diplomado en Evaluación Financiera de ProyectosMódulo I - Nivelación en Matemática Financiera

Conferencista: Luis Fernando Gómez

Página 4 de 9

EJERCICIO DE TABLAS DE AMORTIZACION

1.460% tasa de interés mensual monto $43,000,000N = 18

periodos inicial interés amort cuota final0 $43,000,000.00 1 $43,000,000.00 $627,800.00 $2,388,888.89 $3,016,688.89 $40,611,111.11 2 $40,611,111.11 $592,922.22 $2,388,888.89 $2,981,811.11 $38,222,222.22 3 $38,222,222.22 $558,044.44 $2,388,888.89 $2,946,933.33 $35,833,333.33 4 $35,833,333.33 $523,166.67 $2,388,888.89 $2,912,055.56 $33,444,444.44 5 $33,444,444.44 $488,288.89 $2,388,888.89 $2,877,177.78 $31,055,555.56 6 $31,055,555.56 $453,411.11 $2,388,888.89 $2,842,300.00 $28,666,666.67 7 $28,666,666.67 $418,533.33 $2,388,888.89 $2,807,422.22 $26,277,777.78 8 $26,277,777.78 $383,655.56 $2,388,888.89 $2,772,544.44 $23,888,888.89 9 $23,888,888.89 $348,777.78 $2,388,888.89 $2,737,666.67 $21,500,000.00 10 $21,500,000.00 $313,900.00 $2,388,888.89 $2,702,788.89 $19,111,111.11 11 $19,111,111.11 $279,022.22 $2,388,888.89 $2,667,911.11 $16,722,222.22 12 $16,722,222.22 $244,144.44 $2,388,888.89 $2,633,033.33 $14,333,333.33 13 $14,333,333.33 $209,266.67 $2,388,888.89 $2,598,155.56 $11,944,444.44 14 $11,944,444.44 $174,388.89 $2,388,888.89 $2,563,277.78 $9,555,555.56 15 $9,555,555.56 $139,511.11 $2,388,888.89 $2,528,400.00 $7,166,666.67 16 $7,166,666.67 $104,633.33 $2,388,888.89 $2,493,522.22 $4,777,777.78 17 $4,777,777.78 $69,755.56 $2,388,888.89 $2,458,644.44 $2,388,888.89 18 $2,388,888.89 $34,877.78 $2,388,888.89 $2,423,766.67 $0.00

Tabla de amortización para 12 periodos, con tasa de interés 1.95% mensual con prestamos de $ 10.000.000 de pesos, con cuota fija a través del tiempo.

LAS CELDAS DE COLOR AMARILLO ( ) SON PARAMETROS

Page 5: Trabajo Individual 2 Final

Diplomado en Evaluación Financiera de ProyectosMódulo I - Nivelación en Matemática Financiera

Conferencista: Luis Fernando Gómez

Página 5 de 9

EJERCICIO DE TABLAS DE AMORTIZACION

Tabla de amortización para 12 periodos, con tasa de interés 1.95% mensual con prestamos de $ 10.000.000 de pesos, con cuota fija a

Page 6: Trabajo Individual 2 Final

Diplomado en Evaluación Financiera de ProyectosMódulo I - Nivelación en Matemática Financiera

Conferencista: Luis Fernando Gómez

Página 6 de 9

EJERCICIO DE TABLAS DE AMORTIZACION

1.460% tasa de interés mensual monto $43,000,000N = 12

periodos inicial interés amort cuota final0 $43,000,000.00 1 $43,000,000.00 $627,800.00 $3,304,623.50 $3,932,423.50 $39,695,376.50 2 $39,695,376.50 $579,552.50 $3,352,871.01 $3,932,423.50 $36,342,505.49 3 $36,342,505.49 $530,600.58 $3,401,822.92 $3,932,423.50 $32,940,682.57 4 $32,940,682.57 $480,933.97 $3,451,489.54 $3,932,423.50 $29,489,193.03 5 $29,489,193.03 $430,542.22 $3,501,881.29 $3,932,423.50 $25,987,311.74 6 $25,987,311.74 $379,414.75 $3,553,008.75 $3,932,423.50 $22,434,302.99 7 $22,434,302.99 $327,540.82 $3,604,882.68 $3,932,423.50 $18,829,420.31 8 $18,829,420.31 $274,909.54 $3,657,513.97 $3,932,423.50 $15,171,906.34 9 $15,171,906.34 $221,509.83 $3,710,913.67 $3,932,423.50 $11,460,992.67 10 $11,460,992.67 $167,330.49 $3,765,093.01 $3,932,423.50 $7,695,899.66 11 $7,695,899.66 $112,360.14 $3,820,063.37 $3,932,423.50 $3,875,836.29 12 $3,875,836.29 $56,587.21 $3,875,836.29 $3,932,423.50 $0.00

LAS CELDAS DE COLOR AMARILLO ( ) SON PARAMETROS

Page 7: Trabajo Individual 2 Final

Diplomado en Evaluación Financiera de ProyectosMódulo I - Nivelación en Matemática Financiera

Conferencista: Luis Fernando Gómez

Página 7 de 9

EJERCICIO DE TABLAS DE AMORTIZACION

Page 8: Trabajo Individual 2 Final

INTRODUCCION

a Matemática Financiera constituye el fundamento para la toma de decisiones prácticas en el campo

de las finanzas empresariales.

Page 9: Trabajo Individual 2 Final

TRABAJO COLABORATIVO 1 INVIDIDUALMATEMATICAS FINANCIERA

PRESENTADO POR:

LUCY LEYTON ERAZO

TUTOR:

UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA INGENIERIA AMBIENTAL

Mar-15

Maria Crisalia Gallo AraqueGRUPO: 102007_267