taller n°13 juan luis giraldo 8°e terminado

Taller N°13 Amortizacion de creditos (Cuota Fija)Nombre del Estudiante:Juan Luis Giraldo Giraldo

Valor total Prestamo 10000000 Interes(efectivo Anual) 26.1%Plazo (AÑOS) 1 AÑO NO.Pagos por Año 12

Tasa Interes mensual 1.95% Funcion tasa NominalValor de cuota mensual $ 942,772.21 Funcion Pago

Tabla De Amortizacion cuota fija#cuota Valor cuota Interes Amortizacion Saldo

0 0 0 0 $ 10,000,000 1 $ 942,772.21 $ 195,133.66 $ 747,638.55 $ 9,252,361.45 2 $ 942,772.21 $ 180,544.72 $ 762,227.49 $ 8,490,133.96 3 $ 942,772.21 $ 165,671.09 $ 777,101.12 $ 7,713,032.84 4 $ 942,772.21 $ 150,507.23 $ 792,264.98 $ 6,920,767.86 5 $ 942,772.21 $ 135,047.48 $ 807,724.73 $ 6,113,043.13 6 $ 942,772.21 $ 119,286.05 $ 823,486.16 $ 5,289,556.97 7 $ 942,772.21 $ 103,217.06 $ 839,555.15 $ 4,450,001.82 8 $ 942,772.21 $ 86,834.51 $ 855,937.70 $ 3,594,064.13

20 $ 942,772.21 $ 70,132.29 $ 872,639.92 $ 2,721,424.21 10 $ 942,772.21 $ 53,104.15 $ 889,668.06 $ 1,831,756.14 11 $ 942,772.21 $ 35,743.73 $ 907,028.48 $ 924,727.66 12 $ 942,772.21 $ 18,044.55 $ 924,727.66 $ 0.00

total $ 11,313,266.52 $ 1,313,266.52 $ 10,000,000.00

Grado 8°E


Valor total Prestamo $ 20,000,000 Interes(efectivo Anual) 16.68%Plazo (AÑOS) 4 Años NO.Pagos por Año 12

Tasa Interes mensual 1.29% Funcion tasa NominalValor de cuota mensual $ 561,963 Funcion Pago


0 $ 20,000,000 1 $ 561,963 $ 258,767.99 $ 303,194.99 $ 19,696,805.01 2 $ 561,963 $ 254,845.13 $ 307,117.85 $ 19,389,687.16 3 $ 561,963 $ 250,871.51 $ 311,091.46 $ 19,078,595.70 4 $ 561,963 $ 246,846.49 $ 315,116.49 $ 18,763,479.21 5 $ 561,963 $ 242,769.39 $ 319,193.59 $ 18,444,285.61 6 $ 561,963 $ 238,639.53 $ 323,323.45 $ 18,120,962.17 7 $ 561,963 $ 234,456.24 $ 327,506.73 $ 17,793,455.44 8 $ 561,963 $ 230,218.83 $ 331,744.15 $ 17,461,711.29 9 $ 561,963 $ 225,926.59 $ 336,036.38 $ 17,125,674.90

10 $ 561,963 $ 221,578.82 $ 340,384.16 $ 16,785,290.75 11 $ 561,963 $ 217,174.79 $ 344,788.18 $ 16,440,502.56 12 $ 561,963 $ 212,713.79 $ 349,249.19 $ 16,091,253.37 13 $ 561,963 $ 208,195.06 $ 353,767.92 $ 15,737,485.46 14 $ 561,963 $ 203,617.87 $ 358,345.11 $ 15,379,140.35 15 $ 561,963 $ 198,981.46 $ 362,981.52 $ 15,016,158.83 16 $ 561,963 $ 194,285.06 $ 367,677.92 $ 14,648,480.91 17 $ 561,963 $ 189,527.90 $ 372,435.08 $ 14,276,045.83 18 $ 561,963 $ 184,709.18 $ 377,253.80 $ 13,898,792.03 19 $ 561,963 $ 179,828.12 $ 382,134.86 $ 13,516,657.17 20 $ 561,963 $ 174,883.91 $ 387,079.07 $ 13,129,578.10 21 $ 561,963 $ 169,875.72 $ 392,087.25 $ 12,737,490.85 22 $ 561,963 $ 164,802.74 $ 397,160.24 $ 12,340,330.61 23 $ 561,963 $ 159,664.13 $ 402,298.85 $ 11,938,031.76 24 $ 561,963 $ 154,459.02 $ 407,503.96 $ 11,530,527.81 25 $ 561,963 $ 149,186.57 $ 412,776.40 $ 11,117,751.40 26 $ 561,963 $ 143,845.91 $ 418,117.07 $ 10,699,634.33 27 $ 561,963 $ 138,436.14 $ 423,526.84 $ 10,276,107.49 28 $ 561,963 $ 132,956.38 $ 429,006.60 $ 9,847,100.90 29 $ 561,963 $ 127,405.72 $ 434,557.25 $ 9,412,543.64 30 $ 561,963 $ 121,783.25 $ 440,179.73 $ 8,972,363.91 31 $ 561,963 $ 116,088.03 $ 445,874.95 $ 8,526,488.96 32 $ 561,963 $ 110,319.12 $ 451,643.86 $ 8,074,845.10 33 $ 561,963 $ 104,475.57 $ 457,487.41 $ 7,617,357.70 34 $ 561,963 $ 98,556.42 $ 463,406.56 $ 7,153,951.13 35 $ 561,963 $ 92,560.68 $ 469,402.30 $ 6,684,548.83

Grado 8°E

36 $ 561,963 $ 86,487.36 $ 475,475.62 $ 6,209,073.22 37 $ 561,963 $ 80,335.47 $ 481,627.51 $ 5,727,445.71 38 $ 561,963 $ 74,103.98 $ 487,859.00 $ 5,239,586.71 39 $ 561,963 $ 67,791.87 $ 494,171.11 $ 4,745,415.60 40 $ 561,963 $ 61,398.08 $ 500,564.90 $ 4,244,850.70 41 $ 561,963 $ 54,921.57 $ 507,041.40 $ 3,737,809.29 42 $ 561,963 $ 48,361.27 $ 513,601.71 $ 3,224,207.59 43 $ 561,963 $ 41,716.09 $ 520,246.89 $ 2,703,960.69 44 $ 561,963 $ 34,984.92 $ 526,978.05 $ 2,176,982.64 45 $ 561,963 $ 28,166.67 $ 533,796.31 $ 1,643,186.33 46 $ 561,963 $ 21,260.20 $ 540,702.78 $ 1,102,483.55 47 $ 561,963 $ 14,264.37 $ 547,698.61 $ 554,784.95 48 $ 561,963 $ 7,178.03 $ 554,784.95 $ 0.00

total $ 26,974,223 $ 6,974,222.94 $ 20,000,000.00



Tasa Interes mensual 1.39% Funcion tasa NominalValor de cuota mensual $ 1,233,670 Funcion Pago


0 $ 50,000,000 1 $ 1,233,670 $ 694,421.52 $ 539,248.56 $ 49,460,751 2 $ 1,233,670 $ 686,932.20 $ 546,737.88 $ 48,914,014 3 $ 1,233,670 $ 679,338.87 $ 554,331.21 $ 48,359,682 4 $ 1,233,670 $ 671,640.08 $ 562,030.00 $ 47,797,652 5 $ 1,233,670 $ 663,834.37 $ 569,835.71 $ 47,227,817 6 $ 1,233,670 $ 655,920.24 $ 577,749.84 $ 46,650,067 7 $ 1,233,670 $ 647,896.20 $ 585,773.87 $ 46,064,293 8 $ 1,233,670 $ 639,760.72 $ 593,909.35 $ 45,470,384 9 $ 1,233,670 $ 631,512.26 $ 602,157.82 $ 44,868,226

10 $ 1,233,670 $ 623,149.23 $ 610,520.85 $ 44,257,705 11 $ 1,233,670 $ 614,670.05 $ 619,000.03 $ 43,638,705 12 $ 1,233,670 $ 606,073.11 $ 627,596.97 $ 43,011,108 13 $ 1,233,670 $ 597,356.78 $ 636,313.30 $ 42,374,795 14 $ 1,233,670 $ 588,519.38 $ 645,150.70 $ 41,729,644 15 $ 1,233,670 $ 579,559.25 $ 654,110.83 $ 41,075,533 16 $ 1,233,670 $ 570,474.68 $ 663,195.40 $ 40,412,338 17 $ 1,233,670 $ 561,263.94 $ 672,406.14 $ 39,739,932 18 $ 1,233,670 $ 551,925.27 $ 681,744.81 $ 39,058,187 19 $ 1,233,670 $ 542,456.91 $ 691,213.17 $ 38,366,974 20 $ 1,233,670 $ 532,857.04 $ 700,813.04 $ 37,666,161 21 $ 1,233,670 $ 523,123.85 $ 710,546.23 $ 36,955,614 22 $ 1,233,670 $ 513,255.48 $ 720,414.60 $ 36,235,200 23 $ 1,233,670 $ 503,250.05 $ 730,420.03 $ 35,504,780 24 $ 1,233,670 $ 493,105.66 $ 740,564.42 $ 34,764,215 25 $ 1,233,670 $ 482,820.38 $ 750,849.70 $ 34,013,366 26 $ 1,233,670 $ 472,392.26 $ 761,277.82 $ 33,252,088 27 $ 1,233,670 $ 461,819.30 $ 771,850.77 $ 32,480,237 28 $ 1,233,670 $ 451,099.51 $ 782,570.57 $ 31,697,666 29 $ 1,233,670 $ 440,230.83 $ 793,439.25 $ 30,904,227 30 $ 1,233,670 $ 429,211.21 $ 804,458.87 $ 30,099,768 31 $ 1,233,670 $ 418,038.54 $ 815,631.54 $ 29,284,137 32 $ 1,233,670 $ 406,710.69 $ 826,959.39 $ 28,457,177 33 $ 1,233,670 $ 395,225.53 $ 838,444.55 $ 27,618,733 34 $ 1,233,670 $ 383,580.85 $ 850,089.23 $ 26,768,644 35 $ 1,233,670 $ 371,774.44 $ 861,895.64 $ 25,906,748

Grado 8°E

36 $ 1,233,670 $ 359,804.06 $ 873,866.01 $ 25,032,882 37 $ 1,233,670 $ 347,667.44 $ 886,002.64 $ 24,146,879 38 $ 1,233,670 $ 335,362.25 $ 898,307.83 $ 23,248,571 39 $ 1,233,670 $ 322,886.16 $ 910,783.91 $ 22,337,788 40 $ 1,233,670 $ 310,236.81 $ 923,433.27 $ 21,414,354 41 $ 1,233,670 $ 297,411.77 $ 936,258.31 $ 20,478,096 42 $ 1,233,670 $ 284,408.61 $ 949,261.47 $ 19,528,834 43 $ 1,233,670 $ 271,224.86 $ 962,445.22 $ 18,566,389 44 $ 1,233,670 $ 257,858.00 $ 975,812.07 $ 17,590,577 45 $ 1,233,670 $ 244,305.51 $ 989,364.57 $ 16,601,213 46 $ 1,233,670 $ 230,564.78 $ 1,003,105.29 $ 15,598,107 47 $ 1,233,670 $ 216,633.23 $ 1,017,036.85 $ 14,581,070 48 $ 1,233,670 $ 202,508.18 $ 1,031,161.90 $ 13,549,909 49 $ 1,233,670 $ 188,186.96 $ 1,045,483.12 $ 12,504,425 50 $ 1,233,670 $ 173,666.84 $ 1,060,003.24 $ 11,444,422 51 $ 1,233,670 $ 158,945.06 $ 1,074,725.02 $ 10,369,697 52 $ 1,233,670 $ 144,018.82 $ 1,089,651.26 $ 9,280,046 53 $ 1,233,670 $ 128,885.27 $ 1,104,784.81 $ 8,175,261 54 $ 1,233,670 $ 113,541.54 $ 1,120,128.53 $ 7,055,133 55 $ 1,233,670 $ 97,984.72 $ 1,135,685.36 $ 5,919,447 56 $ 1,233,670 $ 82,211.83 $ 1,151,458.25 $ 4,767,989 57 $ 1,233,670 $ 66,219.88 $ 1,167,450.20 $ 3,600,539 58 $ 1,233,670 $ 50,005.83 $ 1,183,664.25 $ 2,416,875 59 $ 1,233,670 $ 33,566.59 $ 1,200,103.49 $ 1,216,771 60 $ 1,233,670 $ 16,899.04 $ 1,216,771.04 $ -

total $ 74,020,205 $ 24,020,204.71 $ 50,000,000



Tasa Interes mensual 1.79% Funcion tasa NominalValor de cuota mensual $ 619,333.70 Funcion Pago


0 $ 12,000,000 1 $ 619,334 $ 214,585 $ 404,749 $ 11,595,251 2 $ 619,334 $ 207,347 $ 411,986 $ 11,183,265 3 $ 619,334 $ 199,980 $ 419,353 $ 10,763,912 4 $ 619,334 $ 192,481 $ 426,852 $ 10,337,059 5 $ 619,334 $ 184,848 $ 434,485 $ 9,902,574 6 $ 619,334 $ 177,079 $ 442,255 $ 9,460,319 7 $ 619,334 $ 169,170 $ 450,163 $ 9,010,155 8 $ 619,334 $ 161,120 $ 458,213 $ 8,551,942 9 $ 619,334 $ 152,927 $ 466,407 $ 8,085,535

10 $ 619,334 $ 144,586 $ 474,747 $ 7,610,788 11 $ 619,334 $ 136,097 $ 483,237 $ 7,127,551 12 $ 619,334 $ 127,456 $ 491,878 $ 6,635,673 13 $ 619,334 $ 118,660 $ 500,674 $ 6,134,999 14 $ 619,334 $ 109,707 $ 509,627 $ 5,625,372 15 $ 619,334 $ 100,593 $ 518,740 $ 5,106,631 16 $ 619,334 $ 91,317 $ 528,016 $ 4,578,615 17 $ 619,334 $ 81,875 $ 537,458 $ 4,041,157 18 $ 619,334 $ 72,264 $ 547,069 $ 3,494,087 19 $ 619,334 $ 62,482 $ 556,852 $ 2,937,235 20 $ 619,334 $ 52,524 $ 566,810 $ 2,370,425 21 $ 619,334 $ 42,388 $ 576,946 $ 1,793,480 22 $ 619,334 $ 32,071 $ 587,263 $ 1,206,217 23 $ 619,334 $ 21,570 $ 597,764 $ 608,453 24 $ 619,334 $ 10,880 $ 608,453 $ -

total $ 14,864,009 $ 2,864,009 $ 12,000,000

Grado 8°E

taller n°13 juan luis giraldo 8°e terminado

Documents