taller n-13 amortizacion de creditos 8b cristian johany montoya

Download Taller N-13 Amortizacion de Creditos 8b Cristian Johany Montoya

Post on 05-Jan-2016

20 views

Category:

Documents

0 download

Embed Size (px)

DESCRIPTION

UYUT6

TRANSCRIPT

hoja1DISEO DEL FORMATO: YECID CIROTALLER N-13 AMORTIZACION DE CREDITOS (CUOTA FIJA)ESTUDIANTE: CRISTIAN JOHANY MONTOYA BETANCUR GRADO: 8B

VALOR DE PRESTAMO$ 10,000,000INTERES (EFECTIVO ANUAL)26.1%PLAZO (AOS)1NO. PAGOS POR AO12TAZA INTERES MENSUAL1.95%(FUNCION TAZA NOMINAL)VALOR DE CUOTA MENSUAL$942,772.21(FUNCION PAGO)TABLA DE ARMOTIZACION (CUOTA FIJA) #CUOTA VALOR CUOTAINTERES AMORTIZACIONSALDO0000$ 10,000,0001$942,772.21$ 195,134$ 747,638.55$ 9,252,361.452$942,772.21$ 180,545$ 762,227.49$ 8,490,133.963$942,772.21$ 165,671$ 777,101.12$ 7,713,032.844$942,772.21$ 150,507$ 792,264.98$ 6,920,767.865$942,772.21$ 135,047$ 807,724.73$ 6,113,043.136$942,772.21$ 119,286$ 823,486.16$ 5,289,556.977$942,772.21$ 103,217$ 839,555.15$ 4,450,001.828$942,772.21$ 86,835$ 855,937.70$ 3,594,064.139$942,772.21$ 70,132$ 872,639.92$ 2,721,424.2110$942,772.21$ 53,104$ 889,668.06$ 1,831,756.1411$942,772.21$ 35,744$ 907,028.48$ 924,727.6612$942,772.21$ 18,045$ 924,727.660.0total1313266.5200137910000000

hoja2DISEO DEL FORMATO: YECID CIROTALLER N-13 AMORTIZACION DE CREDITOS (CUOTA FIJA)ESTUDIANTE: CRISTIAN JOHANY MONTOYA BETANCUR GRADO: 8B

VALOR DE PRESTAMO$ 20,000,000.00INTERES (EFECTIVO ANUAL)16.68%PLAZO (AOS)2NO. PAGOS POR AO12TAZA INTERES MENSUAL1.29%(FUNCION TAZA NOMINAL)VALOR DE CUOTA MENSUAL$ 974,263.89(FUNCION PAGO)TABLA DE ARMOTIZACION (CUOTA FIJA) #CUOTA VALOR CUOTAINTERES AMORTIZACIONSALDO0000$ 20,000,000.001$ 974,263.89$ 257,936.35$ 716,327.54$ 19,283,672.462$ 974,263.89$ 248,698.00$ 725,565.88$ 18,558,106.583$ 974,263.89$ 239,340.51$ 734,923.38$ 17,823,183.204$ 974,263.89$ 229,862.34$ 744,401.55$ 17,078,781.655$ 974,263.89$ 220,261.93$ 754,001.96$ 16,324,779.706$ 974,263.89$ 210,537.70$ 763,726.18$ 15,561,053.517$ 974,263.89$ 200,688.06$ 773,575.82$ 14,787,477.698$ 974,263.89$ 190,711.40$ 783,552.49$ 14,003,925.209$ 974,263.89$ 180,606.07$ 793,657.82$ 13,210,267.3810$ 974,263.89$ 170,370.41$ 803,893.48$ 12,406,373.9011$ 974,263.89$ 160,002.74$ 814,261.15$ 11,592,112.7612$ 974,263.89$ 149,501.36$ 824,762.52$ 10,767,350.2313$ 974,263.89$ 138,864.55$ 835,399.34$ 9,931,950.8914$ 974,263.89$ 128,090.56$ 846,173.33$ 9,085,777.5615$ 974,263.89$ 117,177.61$ 857,086.27$ 8,228,691.2916$ 974,263.89$ 106,123.93$ 868,139.96$ 7,360,551.3417$ 974,263.89$ 94,927.69$ 879,336.20$ 6,481,215.1418$ 974,263.89$ 83,587.05$ 890,676.84$ 5,590,538.3019$ 974,263.89$ 72,100.15$ 902,163.73$ 4,688,374.5620$ 974,263.89$ 60,465.11$ 913,798.78$ 3,774,575.7921$ 974,263.89$ 48,680.01$ 925,583.87$ 2,848,991.9222$ 974,263.89$ 36,742.93$ 937,520.96$ 1,911,470.9623$ 974,263.89$ 24,651.89$ 949,611.99$ 961,858.9724$ 974,263.89$ 12,404.92$ 961,858.97$ (0.00)total3382333.2533697420000000

hoja 3DISEO DEL FORMATO: YECID CIROTALLER N-13 AMORTIZACION DE CREDITOS (CUOTA FIJA)ESTUDIANTE: CRISTIAN JOHANY MONTOYA BETANCUR GRADO: 8B

VALOR DE PRESTAMO$ 12,000,000.00INTERES (EFECTIVO ANUAL)23.7%PLAZO (AOS)2NO. PAGOS POR AO12TAZA INTERES MENSUAL1.78%(FUNCION TAZA NOMINAL)VALOR DE CUOTA MENSUAL$ 618,772.03(FUNCION PAGO)TABLA DE ARMOTIZACION (CUOTA FIJA) #CUOTA VALOR CUOTAINTERES AMORTIZACIONSALDO0000$ 12,000,000.001$ 618,772.03$ 213,634.31$ 405,137.71$ 11,594,862.292$ 618,772.03$ 206,421.70$ 412,350.32$ 11,182,511.973$ 618,772.03$ 199,080.69$ 419,691.34$ 10,762,820.634$ 618,772.03$ 191,608.98$ 427,163.04$ 10,335,657.595$ 618,772.03$ 184,004.26$ 434,767.77$ 9,900,889.826$ 618,772.03$ 176,264.15$ 442,507.88$ 9,458,381.947$ 618,772.03$ 168,386.24$ 450,385.78$ 9,007,996.168$ 618,772.03$ 160,368.09$ 458,403.94$ 8,549,592.239$ 618,772.03$ 152,207.19$ 466,564.84$ 8,083,027.3910$ 618,772.03$ 143,901.00$ 474,871.03$ 7,608,156.3711$ 618,772.03$ 135,446.94$ 483,325.09$ 7,124,831.2812$ 618,772.03$ 126,842.37$ 491,929.66$ 6,632,901.6213$ 618,772.03$ 118,084.62$ 500,687.41$ 6,132,214.2114$ 618,772.03$ 109,170.95$ 509,601.08$ 5,622,613.1315$ 618,772.03$ 100,098.59$ 518,673.43$ 5,103,939.7016$ 618,772.03$ 90,864.72$ 527,907.30$ 4,576,032.3917$ 618,772.03$ 81,466.46$ 537,305.56$ 4,038,726.8318$ 618,772.03$ 71,900.89$ 546,871.14$ 3,491,855.6919$ 618,772.03$ 62,165.02$ 556,607.01$ 2,935,248.6820$ 618,772.03$ 52,255.82$ 566,516.21$ 2,368,732.4721$ 618,772.03$ 42,170.21$ 576,601.81$ 1,792,130.6622$ 618,772.03$ 31,905.05$ 586,866.98$ 1,205,263.6823$ 618,772.03$ 21,457.14$ 597,314.89$ 607,948.8024$ 618,772.03$ 10,823.23$ 607,948.800.0total2850528.6220906212000000

hoja4DISEO DEL FORMATO: YECID CIROTALLER N-13 AMORTIZACION DE CREDITOS (CUOTA FIJA)ESTUDIANTE: CRISTIAN JOHANY MONTOYA BETANCUR GRADO: 8B

VALOR DE PRESTAMO$ 50,000,000INTERES (EFECTIVO ANUAL)18%PLAZO (AOS)5NO. PAGOS POR AO12TAZA INTERES MENSUAL1.3888%(FUNCION TAZA NOMINAL)VALOR DE CUOTA MENSUAL$1,233,670.08(FUNCION PAGO)TABLA DE ARMOTIZACION (CUOTA FIJA) #CUOTA VALOR CUOTAINTERES AMORTIZACIONSALDO0000$ 50,000,0001$1,233,670.08$694,421.52$539,248.56$49,460,751.442$1,233,670.08$686,932.20$546,737.88$48,914,013.563$1,233,670.08$679,338.87$554,331.21$48,359,682.354$1,233,670.08$671,640.08$562,030.00$47,797,652.365$1,233,670.08$663,834.37$569,835.71$47,227,816.646$1,233,670.08$655,920.24$577,749.84$46,650,066.817$1,233,670.08$647,896.20$585,773.87$46,064,292.938$1,233,670.08$639,760.72$593,909.35$45,470,383.589$1,233,670.08$631,512.26$602,157.82$44,868,225.7510$1,233,670.08$623,149.23$610,520.85$44,257,704.9011$1,233,670.08$614,670.05$619,000.03$43,638,704.8812$1,233,670.08$606,073.11$627,596.97$43,011,107.9113$1,233,670.08$597,356.78$636,313.30$42,374,794.6114$1,233,670.08$588,519.38$645,150.70$41,729,643.9115$1,233,670.08$579,559.25$654,110.83$41,075,533.0916$1,233,670.08$570,474.68$663,195.40$40,412,337.6917$1,233,670.08$561,263.94$672,406.14$39,739,931.5518$1,233,670.08$551,925.27$681,744.81$39,058,186.7419$1,233,670.08$542,456.91$691,213.17$38,366,973.5720$1,233,670.08$532,857.04$700,813.04$37,666,160.5321$1,233,670.08$523,123.85$710,546.23$36,955,614.3022$1,233,670.08$513,255.48$720,414.60$36,235,199.6923$1,233,670.08$503,250.05$730,420.03$35,504,779.6624$1,233,670.08$493,105.66$740,564.42$34,764,215.2425$1,233,670.08$482,820.38$750,849.70$34,013,365.5526$1,233,670.08$472,392.26$761,277.82$33,252,087.7327$1,233,670.08$461,819.30$771,850.77$32,480,236.9528$1,233,670.08$451,099.51$782,570.57$31,697,666.3829$1,233,670.08$440,230.83$793,439.25$30,904,227.1430$1,233,670.08$429,211.21$804,458.87$30,099,768.2631$1,233,670.08$418,038.54$815,631.54$29,284,136.7232$1,233,670.08$406,710.69$826,959.39$28,457,177.3433$1,233,670.08$395,225.53$838,444.55$27,618,732.7834$1,233,670.08$383,580.85$850,089.23$26,768,643.5535$1,233,670.08$371,774.44$861,895.64$25,906,747.9136$1,233,670.08$359,804.06$873,866.01$25,032,881.9037$1,233,670.08$347,667.44$886,002.64$24,146,879.2638$1,233,670.08$335,362.25$898,307.83$23,248,571.4339$1,233,670.08$322,886.16$910,783.91$22,337,787.5240$1,233,670.08$310,236.81$923,433.27$21,414,354.2441$1,233,670.08$297,411.77$936,258.31$20,478,095.9342$1,233,670.08$284,408.61$949,261.47$19,528,834.4643$1,233,670.08$271,224.86$962,445.22$18,566,389.2444$1,233,670.08$257,858.00$975,812.07$17,590,577.1745$1,233,670.08$244,305.51$989,364.57$16,601,212.5946$1,233,670.08$230,564.78$1,003,105.29$15,598,107.3047$1,233,670.08$216,633.23$1,017,036.85$14,581,070.4548$1,233,670.08$202,508.18$1,031,161.90$13,549,908.5549$1,233,670.08$188,186.96$1,045,483.12$12,504,425.4350$1,233,670.08$173,666.84$1,060,003.24$11,444,422.2051$1,233,670.08$158,945.06$1,074,725.02$10,369,697.1852$1,233,670.08$144,018.82$1,089,651.26$9,280,045.9253$1,233,670.08$128,885.27$1,104,784.81$8,175,261.1154$1,233,670.08$113,541.54$1,120,128.53$7,055,132.5855$1,233,670.08$97,984.72$1,135,685.36$5,919,447.2156$1,233,670.08$82,211.83$1,151,458.25$4,767,988.9757$1,233,670.08$66,219.88$1,167,450.20$3,600,538.7758$1,233,670.08$50,005.83$1,183,664.25$2,416,874.5259$1,233,670.08$33,566.59$1,200,103.49$1,216,771.0460$1,233,670.08$16,899.04$1,216,771.040.0TOTAL$24,020,204.7150000000