Taller#13 Amortizacion de Creditos-Valentina Buitrago Chala 8b

DISEÑO DEL FORMATO: YESID CIROTALLER#13 AMORTIZACIÓN DE CREDITOS (CUOTA FIJA)

Nombre:

Valor total préstamo $ 10,000,000.00 Interés (Efectivo Anual)Plazo (AÑOS) 1 NO. Pagos por año

Tasa interes mensual 1.95% (FUNCION TASA NOMINAL)Valor de cuota mensual $ 942,772.21 (Funcion pago

TABLA DE AMORTIZACION CUOTA FIJA#CUOTVALOR CUOTA INTERES AMORTIZACION

0 $ - $ - $ - 1 $ 942,772 $ 195,134 $ 747,639 2 $ 942,772 $ 180,545 $ 762,227 3 $ 942,772 $ 165,671 $ 777,101 4 $ 942,772 $ 150,507 $ 792,265 5 $ 942,772 $ 135,047 $ 807,725 6 $ 942,772 $ 119,286 $ 823,486 7 $ 942,772 $ 103,217 $ 839,555 8 $ 942,772 $ 86,835 $ 855,938 9 $ 942,772 $ 70,132 $ 872,640

10 $ 942,772 $ 53,104 $ 889,668 11 $ 942,772 $ 35,744 $ 907,028 12 $ 942,772 $ 18,045 $ 924,728

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


Grado

26.1%12

(FUNCION TASA NOMINAL)(Funcion pago

TABLA DE AMORTIZACION CUOTA FIJASALDO $ 10,000,000.00

$ 9,252,361 $ 8,490,134 $ 7,713,033 $ 6,920,768 $ 6,113,043 $ 5,289,557 $ 4,450,002 $ 3,594,064 $ 2,721,424 $ 1,831,756

$ 924,728 $ 0


Nombre:



TABLA DE AMORTIZACION CUOTA FIJA#CUOTA VALOR CUOTA INTERES AMORTIZACION

0 $ - $ - $ - 1 $ 561,962.98 $ 258,767.99 $ 303,194.99 2 $ 561,962.98 $ 254,845.13 $ 307,117.85 3 $ 561,962.98 $ 250,871.51 $ 311,091.46 4 $ 561,962.98 $ 246,846.49 $ 315,116.49 5 $ 561,962.98 $ 242,769.39 $ 319,193.59 6 $ 561,962.98 $ 238,639.53 $ 323,323.45 7 $ 561,962.98 $ 234,456.24 $ 327,506.73 8 $ 561,962.98 $ 230,218.83 $ 331,744.15 9 $ 561,962.98 $ 225,926.59 $ 336,036.38

10 $ 561,962.98 $ 221,578.82 $ 340,384.16 11 $ 561,962.98 $ 217,174.79 $ 344,788.18 12 $ 561,962.98 $ 212,713.79 $ 349,249.19 13 $ 561,962.98 $ 208,195.06 $ 353,767.92 14 $ 561,962.98 $ 203,617.87 $ 358,345.11 15 $ 561,962.98 $ 198,981.46 $ 362,981.52 16 $ 561,962.98 $ 194,285.06 $ 367,677.92 17 $ 561,962.98 $ 189,527.90 $ 372,435.08 18 $ 561,962.98 $ 184,709.18 $ 377,253.80 19 $ 561,962.98 $ 179,828.12 $ 382,134.86 20 $ 561,962.98 $ 174,883.91 $ 387,079.07 21 $ 561,962.98 $ 169,875.72 $ 392,087.25 22 $ 561,962.98 $ 164,802.74 $ 397,160.24 23 $ 561,962.98 $ 159,664.13 $ 402,298.85 24 $ 561,962.98 $ 154,459.02 $ 407,503.96 25 $ 561,962.98 $ 149,186.57 $ 412,776.40 26 $ 561,962.98 $ 143,845.91 $ 418,117.07 27 $ 561,962.98 $ 138,436.14 $ 423,526.84 28 $ 561,962.98 $ 132,956.38 $ 429,006.60 29 $ 561,962.98 $ 127,405.72 $ 434,557.25 30 $ 561,962.98 $ 121,783.25 $ 440,179.73 31 $ 561,962.98 $ 116,088.03 $ 445,874.95 32 $ 561,962.98 $ 110,319.12 $ 451,643.86 33 $ 561,962.98 $ 104,475.57 $ 457,487.41 34 $ 561,962.98 $ 98,556.42 $ 463,406.56 35 $ 561,962.98 $ 92,560.68 $ 469,402.30 36 $ 561,962.98 $ 86,487.36 $ 475,475.62 37 $ 561,962.98 $ 80,335.47 $ 481,627.51

38 $ 561,962.98 $ 74,103.98 $ 487,859.00 39 $ 561,962.98 $ 67,791.87 $ 494,171.11 40 $ 561,962.98 $ 61,398.08 $ 500,564.90 41 $ 561,962.98 $ 54,921.57 $ 507,041.40 42 $ 561,962.98 $ 48,361.27 $ 513,601.71 43 $ 561,962.98 $ 41,716.09 $ 520,246.89 44 $ 561,962.98 $ 34,984.92 $ 526,978.05 45 $ 561,962.98 $ 28,166.67 $ 533,796.31 46 $ 561,962.98 $ 21,260.20 $ 540,702.78 47 $ 561,962.98 $ 14,264.37 $ 547,698.61 48 $ 561,962.98 $ 7,178.03 $ 554,784.95

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


Grado

16.68%12


TABLA DE AMORTIZACION CUOTA FIJASALDO $ 20,000,000.00 $ 19,696,805.01 $ 19,389,687.16 $ 19,078,595.70 $ 18,763,479.21 $ 18,444,285.61 $ 18,120,962.17 $ 17,793,455.44 $ 17,461,711.29 $ 17,125,674.90 $ 16,785,290.75 $ 16,440,502.56 $ 16,091,253.37 $ 15,737,485.46 $ 15,379,140.35 $ 15,016,158.83 $ 14,648,480.91 $ 14,276,045.83 $ 13,898,792.03 $ 13,516,657.17 $ 13,129,578.10 $ 12,737,490.85 $ 12,340,330.61 $ 11,938,031.76 $ 11,530,527.81 $ 11,117,751.40 $ 10,699,634.33 $ 10,276,107.49 $ 9,847,100.90 $ 9,412,543.64 $ 8,972,363.91 $ 8,526,488.96 $ 8,074,845.10 $ 7,617,357.70 $ 7,153,951.13 $ 6,684,548.83 $ 6,209,073.22 $ 5,727,445.71

$ 5,239,586.71 $ 4,745,415.60 $ 4,244,850.70 $ 3,737,809.29 $ 3,224,207.59 $ 2,703,960.69 $ 2,176,982.64 $ 1,643,186.33 $ 1,102,483.55 $ 554,784.95 $ 0.00


Nombre:



TABLA DE AMORTIZACION CUOTA FIJA#CUOTVALOR CUOTA INTERES AMORTIZACION

0 0 0 01 $ 619,333.70 $ 214,585.14 $ 404,748.56 2 $ 619,333.70 $ 207,347.39 $ 411,986.31 3 $ 619,333.70 $ 199,980.21 $ 419,353.49 4 $ 619,333.70 $ 192,481.29 $ 426,852.41 5 $ 619,333.70 $ 184,848.27 $ 434,485.42 6 $ 619,333.70 $ 177,078.76 $ 442,254.93 7 $ 619,333.70 $ 169,170.32 $ 450,163.38 8 $ 619,333.70 $ 161,120.46 $ 458,213.24 9 $ 619,333.70 $ 152,926.64 $ 466,407.06

10 $ 619,333.70 $ 144,586.31 $ 474,747.39 11 $ 619,333.70 $ 136,096.83 $ 483,236.87 12 $ 619,333.70 $ 127,455.54 $ 491,878.16 13 $ 619,333.70 $ 118,659.73 $ 500,673.97 14 $ 619,333.70 $ 109,706.63 $ 509,627.07 15 $ 619,333.70 $ 100,593.43 $ 518,740.27 16 $ 619,333.70 $ 91,317.27 $ 528,016.43 17 $ 619,333.70 $ 81,875.23 $ 537,458.47 18 $ 619,333.70 $ 72,264.35 $ 547,069.35 19 $ 619,333.70 $ 62,481.60 $ 556,852.10 20 $ 619,333.70 $ 52,523.92 $ 566,809.78 21 $ 619,333.70 $ 42,388.17 $ 576,945.53 22 $ 619,333.70 $ 32,071.18 $ 587,262.52 23 $ 619,333.70 $ 21,569.69 $ 597,764.01 24 $ 619,333.70 $ 10,880.42 $ 608,453.28

$ 14,864,008.77 $ 2,864,008.77 $ 12,000,000.00


Grado

23.7%12


TABLA DE AMORTIZACION CUOTA FIJASALDO $ 12,000,000.00 $ 11,595,251.44 $ 11,183,265.13 $ 10,763,911.64 $ 10,337,059.23 $ 9,902,573.80 $ 9,460,318.87 $ 9,010,155.49 $ 8,551,942.25 $ 8,085,535.19 $ 7,610,787.80 $ 7,127,550.93 $ 6,635,672.78 $ 6,134,998.81 $ 5,625,371.74 $ 5,106,631.47 $ 4,578,615.04 $ 4,041,156.57 $ 3,494,087.22 $ 2,937,235.12 $ 2,370,425.34 $ 1,793,479.81 $ 1,206,217.29 $ 608,453.28 $ -


Nombre:


Tasa interes mensual 1.4% (FUNCION TASA NOMINAL)Valor de cuota mensual $ 1,233,670.08 (Funcion pago

TABLA DE AMORTIZACION CUOTA FIJA#CUOTA VALOR CUOTA INTERES AMORTIZACION

0 $ - $ - $ - 1 $ 1,233,670.08 $ 694,421.52 $ 539,248.56 2 $ 1,233,670.08 $ 686,932.20 $ 546,737.88 3 $ 1,233,670.08 $ 679,338.87 $ 554,331.21 4 $ 1,233,670.08 $ 671,640.08 $ 562,030.00 5 $ 1,233,670.08 $ 663,834.37 $ 569,835.71 6 $ 1,233,670.08 $ 655,920.24 $ 577,749.84 7 $ 1,233,670.08 $ 647,896.20 $ 585,773.87 8 $ 1,233,670.08 $ 639,760.72 $ 593,909.35 9 $ 1,233,670.08 $ 631,512.26 $ 602,157.82

10 $ 1,233,670.08 $ 623,149.23 $ 610,520.85 11 $ 1,233,670.08 $ 614,670.05 $ 619,000.03 12 $ 1,233,670.08 $ 606,073.11 $ 627,596.97 13 $ 1,233,670.08 $ 597,356.78 $ 636,313.30 14 $ 1,233,670.08 $ 588,519.38 $ 645,150.70 15 $ 1,233,670.08 $ 579,559.25 $ 654,110.83 16 $ 1,233,670.08 $ 570,474.68 $ 663,195.40 17 $ 1,233,670.08 $ 561,263.94 $ 672,406.14 18 $ 1,233,670.08 $ 551,925.27 $ 681,744.81 19 $ 1,233,670.08 $ 542,456.91 $ 691,213.17 20 $ 1,233,670.08 $ 532,857.04 $ 700,813.04 21 $ 1,233,670.08 $ 523,123.85 $ 710,546.23 22 $ 1,233,670.08 $ 513,255.48 $ 720,414.60 23 $ 1,233,670.08 $ 503,250.05 $ 730,420.03 24 $ 1,233,670.08 $ 493,105.66 $ 740,564.42 25 $ 1,233,670.08 $ 482,820.38 $ 750,849.70 26 $ 1,233,670.08 $ 472,392.26 $ 761,277.82 27 $ 1,233,670.08 $ 461,819.30 $ 771,850.77 28 $ 1,233,670.08 $ 451,099.51 $ 782,570.57 29 $ 1,233,670.08 $ 440,230.83 $ 793,439.25 30 $ 1,233,670.08 $ 429,211.21 $ 804,458.87 31 $ 1,233,670.08 $ 418,038.54 $ 815,631.54 32 $ 1,233,670.08 $ 406,710.69 $ 826,959.39 33 $ 1,233,670.08 $ 395,225.53 $ 838,444.55 34 $ 1,233,670.08 $ 383,580.85 $ 850,089.23 35 $ 1,233,670.08 $ 371,774.44 $ 861,895.64 36 $ 1,233,670.08 $ 359,804.06 $ 873,866.01 37 $ 1,233,670.08 $ 347,667.44 $ 886,002.64

38 $ 1,233,670.08 $ 335,362.25 $ 898,307.83 39 $ 1,233,670.08 $ 322,886.16 $ 910,783.91 40 $ 1,233,670.08 $ 310,236.81 $ 923,433.27 41 $ 1,233,670.08 $ 297,411.77 $ 936,258.31 42 $ 1,233,670.08 $ 284,408.61 $ 949,261.47 43 $ 1,233,670.08 $ 271,224.86 $ 962,445.22 44 $ 1,233,670.08 $ 257,858.00 $ 975,812.07 45 $ 1,233,670.08 $ 244,305.51 $ 989,364.57 46 $ 1,233,670.08 $ 230,564.78 $ 1,003,105.29 47 $ 1,233,670.08 $ 216,633.23 $ 1,017,036.85 48 $ 1,233,670.08 $ 202,508.18 $ 1,031,161.90 49 $ 1,233,670.08 $ 188,186.96 $ 1,045,483.12 50 $ 1,233,670.08 $ 173,666.84 $ 1,060,003.24 51 $ 1,233,670.08 $ 158,945.06 $ 1,074,725.02 52 $ 1,233,670.08 $ 144,018.82 $ 1,089,651.26 53 $ 1,233,670.08 $ 128,885.27 $ 1,104,784.81 54 $ 1,233,670.08 $ 113,541.54 $ 1,120,128.53 55 $ 1,233,670.08 $ 97,984.72 $ 1,135,685.36 56 $ 1,233,670.08 $ 82,211.83 $ 1,151,458.25 57 $ 1,233,670.08 $ 66,219.88 $ 1,167,450.20 58 $ 1,233,670.08 $ 50,005.83 $ 1,183,664.25 59 $ 1,233,670.08 $ 33,566.59 $ 1,200,103.49 60 $ 1,233,670.08 $ 16,899.04 $ 1,216,771.04

$ 74,020,204.71 $ 24,020,204.71 $ 50,000,000.00


Grado

18%12


TABLA DE AMORTIZACION CUOTA FIJASALDO $ 50,000,000.00 $ 49,460,751.44 $ 48,914,013.56 $ 48,359,682.35 $ 47,797,652.36 $ 47,227,816.64 $ 46,650,066.81 $ 46,064,292.93 $ 45,470,383.58 $ 44,868,225.75 $ 44,257,704.90 $ 43,638,704.88 $ 43,011,107.91 $ 42,374,794.61 $ 41,729,643.91 $ 41,075,533.09 $ 40,412,337.69 $ 39,739,931.55 $ 39,058,186.74 $ 38,366,973.57 $ 37,666,160.53 $ 36,955,614.30 $ 36,235,199.69 $ 35,504,779.66 $ 34,764,215.24 $ 34,013,365.55 $ 33,252,087.73 $ 32,480,236.95 $ 31,697,666.38 $ 30,904,227.14 $ 30,099,768.26 $ 29,284,136.72 $ 28,457,177.34 $ 27,618,732.78 $ 26,768,643.55 $ 25,906,747.91 $ 25,032,881.90 $ 24,146,879.26

$ 23,248,571.43 $ 22,337,787.52 $ 21,414,354.24 $ 20,478,095.93 $ 19,528,834.46 $ 18,566,389.24 $ 17,590,577.17 $ 16,601,212.59 $ 15,598,107.30 $ 14,581,070.45 $ 13,549,908.55 $ 12,504,425.43 $ 11,444,422.20 $ 10,369,697.18 $ 9,280,045.92 $ 8,175,261.11 $ 7,055,132.58 $ 5,919,447.21 $ 4,767,988.97 $ 3,600,538.77 $ 2,416,874.52 $ 1,216,771.04 $ -

Taller#13 Amortizacion de Creditos-Valentina Buitrago Chala 8b

Documents

Transcript of Taller#13 Amortizacion de Creditos-Valentina Buitrago Chala 8b