taller n°13 camilo gomez duque 8°e (2)

DISEO DEL FORMATOTALLER#13 MORTIZACION DE CREDITOS (CUOTAS FIJAS)NOMBRE ESTUDIANTE: Camilo Gomez Duque

VALOR TOTAL PRESTAMO 10000000PLAZO (AOS) 1 AO

TASAS INTERES MENSUAL 1.95%VALOR DE CUOTA MENSUAL $ 942,772.21

TABLA DE AMORTIZACION CUOTA FIJA# CUOTA valor cuota INTERESES

0 0 01 $ 942,772.21 $ 195,133.662 $ 942,772.21 $ 180,544.723 $ 942,772.21 $ 165,671.094 $ 942,772.21 $ 150,507.235 $ 942,772.21 $ 135,047.486 $ 942,772.21 $ 119,286.057 $ 942,772.21 $ 103,217.068 $ 942,772.21 $ 86,834.519 $ 942,772.21 $ 70,132.29

10 $ 942,772.21 $ 53,104.1511 $ 942,772.21 $ 35,743.7312 $ 942,772.21 $ 18,044.55

$ 11,313,266.52 $ 1,313,266.52

DISEO DEL FORMATO

NOMBRE ESTUDIANTE: Camilo Gomez Duque Interes(efectivo Anual) 26.1%

NO.Pagos por Ao 12

TABLA DE AMORTIZACION CUOTA FIJAAMORTIZACION SALDO

0 $ 10,000,000$ 747,638.55 $ 9,252,361.45 $ 762,227.49 $ 8,490,133.96 $ 777,101.12 $ 7,713,032.84 $ 792,264.98 $ 6,920,767.86 $ 807,724.73 $ 6,113,043.13 $ 823,486.16 $ 5,289,556.97 $ 839,555.15 $ 4,450,001.82 $ 855,937.70 $ 3,594,064.13 $ 872,639.92 $ 2,721,424.21 $ 889,668.06 $ 1,831,756.14 $ 907,028.48 $ 924,727.66 $ 924,727.66 $ 0.00

$ 10,000,000.00

DISEO DEL FORMATOTALLER#13 MORTIZACION DE CREDITOS (CUOTAS FIJAS)

NOMBRE ESTUDIANTE:VALOR TOTAL PRESTAMO 20000000

PLAZO (AOS) 4 AOTASAS INTERES MENSUAL 1.29%

VALOR DE CUOTA MENSUAL $ 561,963 TABLA DE AMORTIZACION CUOTA FIJA

# CUOTA valor cuota INTERESES01 $ 561,963 $ 258,767.992 $ 561,963 $ 254,845.133 $ 561,963 $ 250,871.514 $ 561,963 $ 246,846.495 $ 561,963 $ 242,769.396 $ 561,963 $ 238,639.537 $ 561,963 $ 234,456.248 $ 561,963 $ 230,218.839 $ 561,963 $ 225,926.59

10 $ 561,963 $ 221,578.8211 $ 561,963 $ 217,174.7912 $ 561,963 $ 212,713.7913 $ 561,963 $ 208,195.0614 $ 561,963 $ 203,617.8715 $ 561,963 $ 198,981.4616 $ 561,963 $ 194,285.0617 $ 561,963 $ 189,527.9018 $ 561,963 $ 184,709.1819 $ 561,963 $ 179,828.1220 $ 561,963 $ 174,883.9121 $ 561,963 $ 169,875.7222 $ 561,963 $ 164,802.7423 $ 561,963 $ 159,664.1324 $ 561,963 $ 154,459.0225 $ 561,963 $ 149,186.5726 $ 561,963 $ 143,845.9127 $ 561,963 $ 138,436.1428 $ 561,963 $ 132,956.3829 $ 561,963 $ 127,405.7230 $ 561,963 $ 121,783.2531 $ 561,963 $ 116,088.0332 $ 561,963 $ 110,319.1233 $ 561,963 $ 104,475.5734 $ 561,963 $ 98,556.4235 $ 561,963 $ 92,560.6836 $ 561,963 $ 86,487.3637 $ 561,963 $ 80,335.4738 $ 561,963 $ 74,103.98

39 $ 561,963 $ 67,791.8740 $ 561,963 $ 61,398.0841 $ 561,963 $ 54,921.5742 $ 561,963 $ 48,361.2743 $ 561,963 $ 41,716.0944 $ 561,963 $ 34,984.9245 $ 561,963 $ 28,166.6746 $ 561,963 $ 21,260.2047 $ 561,963 $ 14,264.3748 $ 561,963 $ 7,178.03

Total $ 26,974,223 $ 6,974,223


NOMBRE ESTUDIANTE:Interes(efectivo Anual) 16.68%

NO.Pagos por Ao 12

TABLA DE AMORTIZACION CUOTA FIJAAMORTIZACION SALDO

$ 20,000,000$ 303,194.99 $ 19,696,805.01$ 307,117.85 $ 19,389,687.16$ 311,091.46 $ 19,078,595.70$ 315,116.49 $ 18,763,479.21$ 319,193.59 $ 18,444,285.61$ 323,323.45 $ 18,120,962.17$ 327,506.73 $ 17,793,455.44$ 331,744.15 $ 17,461,711.29$ 336,036.38 $ 17,125,674.90$ 340,384.16 $ 16,785,290.75$ 344,788.18 $ 16,440,502.56$ 349,249.19 $ 16,091,253.37$ 353,767.92 $ 15,737,485.46$ 358,345.11 $ 15,379,140.35$ 362,981.52 $ 15,016,158.83$ 367,677.92 $ 14,648,480.91$ 372,435.08 $ 14,276,045.83$ 377,253.80 $ 13,898,792.03$ 382,134.86 $ 13,516,657.17$ 387,079.07 $ 13,129,578.10$ 392,087.25 $ 12,737,490.85$ 397,160.24 $ 12,340,330.61$ 402,298.85 $ 11,938,031.76$ 407,503.96 $ 11,530,527.81$ 412,776.40 $ 11,117,751.40$ 418,117.07 $ 10,699,634.33$ 423,526.84 $ 10,276,107.49$ 429,006.60 $ 9,847,100.90$ 434,557.25 $ 9,412,543.64$ 440,179.73 $ 8,972,363.91$ 445,874.95 $ 8,526,488.96$ 451,643.86 $ 8,074,845.10$ 457,487.41 $ 7,617,357.70$ 463,406.56 $ 7,153,951.13$ 469,402.30 $ 6,684,548.83$ 475,475.62 $ 6,209,073.22$ 481,627.51 $ 5,727,445.71$ 487,859.00 $ 5,239,586.71

$ 494,171.11 $ 4,745,415.60$ 500,564.90 $ 4,244,850.70$ 507,041.40 $ 3,737,809.29$ 513,601.71 $ 3,224,207.59$ 520,246.89 $ 2,703,960.69$ 526,978.05 $ 2,176,982.64$ 533,796.31 $ 1,643,186.33$ 540,702.78 $ 1,102,483.55$ 547,698.61 $ 554,784.95$ 554,784.95 $ 0.00$ 20,000,000



PLAZO (AOS) 2 aosTASAS INTERES MENSUAL 1.79%

VALOR DE CUOTA MENSUAL $ 619,333.70 TABLA DE AMORTIZACION CUOTA FIJA

# CUOTA valor cuota INTERESES0 0 01 $ 619,333.70 $ 214,585.142 $ 619,333.70 $ 207,347.393 $ 619,333.70 $ 199,980.214 $ 619,333.70 $ 192,481.295 $ 619,333.70 $ 184,848.276 $ 619,333.70 $ 177,078.767 $ 619,333.70 $ 169,170.328 $ 619,333.70 $ 161,120.469 $ 619,333.70 $ 152,926.64

10 $ 619,333.70 $ 144,586.3111 $ 619,333.70 $ 136,096.8312 $ 619,333.70 $ 127,455.5413 $ 619,333.70 $ 118,659.7314 $ 619,333.70 $ 109,706.6315 $ 619,333.70 $ 100,593.4316 $ 619,333.70 $ 91,317.2717 $ 619,333.70 $ 81,875.2318 $ 619,333.70 $ 72,264.3519 $ 619,333.70 $ 62,481.6020 $ 619,333.70 $ 52,523.9221 $ 619,333.70 $ 42,388.1722 $ 619,333.70 $ 32,071.1823 $ 619,333.70 $ 21,569.6924 $ 619,333.70 $ 10,880.42

$ 14,864,009 $ 2,864,009



NO.Pagos por Ao 12Funcion tasa Nominal

Funcion PagoTABLA DE AMORTIZACION CUOTA FIJA

AMORTIZACION SALDO0 $ 12,000,000

$ 404,748.56 $ 11,595,251.44$ 411,986.31 $ 11,183,265.13$ 419,353.49 $ 10,763,911.64$ 426,852.41 $ 10,337,059.23$ 434,485.42 $ 9,902,573.80$ 442,254.93 $ 9,460,318.87$ 450,163.38 $ 9,010,155.49$ 458,213.24 $ 8,551,942.25$ 466,407.06 $ 8,085,535.19$ 474,747.39 $ 7,610,787.80$ 483,236.87 $ 7,127,550.93$ 491,878.16 $ 6,635,672.78$ 500,673.97 $ 6,134,998.81$ 509,627.07 $ 5,625,371.74$ 518,740.27 $ 5,106,631.47$ 528,016.43 $ 4,578,615.04$ 537,458.47 $ 4,041,156.57$ 547,069.35 $ 3,494,087.22$ 556,852.10 $ 2,937,235.12$ 566,809.78 $ 2,370,425.34$ 576,945.53 $ 1,793,479.81$ 587,262.52 $ 1,206,217.29$ 597,764.01 $ 608,453.28$ 608,453.28 $ 0.00

$ 12,000,000.00



PLAZO (AOS) 5 AOTASAS INTERES MENSUAL 1.39%

VALOR DE CUOTA MENSUAL $ 1,233,670.08 TABLA DE AMORTIZACION CUOTA FIJA

# CUOTA valor cuota INTERESES0 0 01 $ 1,233,670.08 $ 694,421.522 $ 1,233,670.08 $ 686,932.203 $ 1,233,670.08 $ 679,338.874 $ 1,233,670.08 $ 671,640.085 $ 1,233,670.08 $ 663,834.376 $ 1,233,670.08 $ 655,920.247 $ 1,233,670.08 $ 647,896.208 $ 1,233,670.08 $ 639,760.729 $ 1,233,670.08 $ 631,512.26

10 $ 1,233,670.08 $ 623,149.2311 $ 1,233,670.08 $ 614,670.0512 $ 1,233,670.08 $ 606,073.1113 $ 1,233,670.08 $ 597,356.7814 $ 1,233,670.08 $ 588,519.3815 $ 1,233,670.08 $ 579,559.2516 $ 1,233,670.08 $ 570,474.6817 $ 1,233,670.08 $ 561,263.9418 $ 1,233,670.08 $ 551,925.2719 $ 1,233,670.08 $ 542,456.9120 $ 1,233,670.08 $ 532,857.0421 $ 1,233,670.08 $ 523,123.8522 $ 1,233,670.08 $ 513,255.4823 $ 1,233,670.08 $ 503,250.0524 $ 1,233,670.08 $ 493,105.6625 $ 1,233,670.08 $ 482,820.3826 $ 1,233,670.08 $ 472,392.2627 $ 1,233,670.08 $ 461,819.3028 $ 1,233,670.08 $ 451,099.5129 $ 1,233,670.08 $ 440,230.8330 $ 1,233,670.08 $ 429,211.2131 $ 1,233,670.08 $ 418,038.5432 $ 1,233,670.08 $ 406,710.6933 $ 1,233,670.08 $ 395,225.5334 $ 1,233,670.08 $ 383,580.8535 $ 1,233,670.08 $ 371,774.4436 $ 1,233,670.08 $ 359,804.0637 $ 1,233,670.08 $ 347,667.4438 $ 1,233,670.08 $ 335,362.25

39 $ 1,233,670.08 $ 322,886.1640 $ 1,233,670.08 $ 310,236.8141 $ 1,233,670.08 $ 297,411.7742 $ 1,233,670.08 $ 284,408.6143 $ 1,233,670.08 $ 271,224.8644 $ 1,233,670.08 $ 257,858.0045 $ 1,233,670.08 $ 244,305.5146 $ 1,233,670.08 $ 230,564.7847 $ 1,233,670.08 $ 216,633.2348 $ 1,233,670.08 $ 202,508.1849 $ 1,233,670.08 $ 188,186.9650 $ 1,233,670.08 $ 173,666.8451 $ 1,233,670.08 $ 158,945.0652 $ 1,233,670.08 $ 144,018.8253 $ 1,233,670.08 $ 128,885.2754 $ 1,233,670.08 $ 113,541.5455 $ 1,233,670.08 $ 97,984.7256 $ 1,233,670.08 $ 82,211.8357 $ 1,233,670.08 $ 66,219.8858 $ 1,233,670.08 $ 50,005.8359 $ 1,233,670.08 $ 33,566.5960 $ 1,233,670.08 $ 16,899.04

$ 74,020,204.71 $ 24,020,204.71



NO.Pagos por Ao 12Funcion tasa Nominal

Funcion PagoTABLA DE AMORTIZACION CUOTA FIJA

AMORTIZACION SALDO0 50000000

$ 539,248.56 $ 49,460,751.44$ 546,737.88 $ 48,914,013.56$ 554,331.21 $ 48,359,682.35$ 562,030.00 $ 47,797,652.36$ 569,835.71 $ 47,227,816.64$ 577,749.84 $ 46,650,066.81$ 585,773.87 $ 46,064,292.93$ 593,909.35 $ 45,470,383.58$ 602,157.82 $ 44,868,225.75$ 610,520.85 $ 44,257,704.90$ 619,000.03 $ 43,638,704.88$ 627,596.97 $ 43,011,107.91$ 636,313.30 $ 42,374,794.61$ 645,150.70 $ 41,729,643.91$ 654,110.83 $ 41,075,533.09$ 663,195.40 $ 40,412,337.69$ 672,406.14 $ 39,739,931.55$ 681,744.81 $ 39,058,186.74$ 691,213.17 $ 38,366,973.57$ 700,813.04 $ 37,666,160.53$ 710,546.23 $ 36,955,614.30$ 720,414.60 $ 36,235,199.69$ 730,420.03 $ 35,504,779.66$ 740,564.42 $ 34,764,215.24$ 750,849.70 $ 34,013,365.55$ 761,277.82 $ 33,252,087.73$ 771,850.77 $ 32,480,236.95$ 782,570.57 $ 31,697,666.38$ 793,439.25 $ 30,904,227.14$ 804,458.87 $ 30,099,768.26$ 815,631.54 $ 29,284,136.72$ 826,959.39 $ 28,457,177.34$ 838,444.55 $ 27,618,732.78$ 850,089.23 $ 26,768,643.55$ 861,895.64 $ 25,906,747.91$ 873,866.01 $ 25,032,881.90$ 886,002.64 $ 24,146,879.26$ 898,307.83 $ 23,248,571.43

$ 910,783.91 $ 22,337,787.52$ 923,433.27 $ 21,414,354.24$ 936,258.31 $ 20,478,095.93$ 949,261.47 $ 19,528,834.46$ 962,445.22 $ 18,566,389.24$ 975,812.07 $ 17,590,577.17$ 989,364.57 $ 16,601,212.59

$ 1,003,105.29 $ 15,598,107.30$ 1,017,036.85 $ 14,581,070.45$ 1,031,161.90 $ 13,549,908.55$ 1,045,483.12 $ 12,504,425.43$ 1,060,003.24 $ 11,444,422.20$ 1,074,725.02 $ 10,369,697.18$ 1,089,651.26 $ 9,280,045.92$ 1,104,784.81 $ 8,175,261.11$ 1,120,128.53 $ 7,055,132.58$ 1,135,685.36 $ 5,919,447.21$ 1,151,458.25 $ 4,767,988.97$ 1,167,450.20 $ 3,600,538.77$ 1,183,664.25 $ 2,416,874.52$ 1,200,103.49 $ 1,216,771.04$ 1,216,771.04 $ 0.00

$ 50,000,000.00

Hoja1Hoja1 (2)Hoja1 (3)Hoja1 (4)

taller n°13 camilo gomez duque 8°e (2)

Documents