PLAZOS IGUALESLa empresa Maya S.A., ha decidido lanzar un nuevo producto llamado Miel de Abeja Maya.Para este propsito es necesario comprar maquinaria, hacer unos estudios y abastecer de materia primala planta de produccin. Ha logrado conseguir dos crditos con dos entidades financieras diferentes:Primer crdito: Con Bancolombia por un monto de 80 millones de pesos, una tasa de inters del 1% mes vencidocon el pago de cuotas mensuales iguales y un ao de plazo para su pagoSegundo crdito: Con Helm Bank por un monto de 20 millones de pesos, una tasa de inters del 5% trimestrevencido y el pago de cuotas trimestrales iguales y un ao de plazo para su pago.La Gerente desea conocer cul es el costo de la deuda para el ao en que van a tener contratados los dos crditos ypara cada uno de los meses en que van a estar contratados los crditos.BancolombiaVA$ 80,000,000.00i1%MVn12mesSaldo InicialinteresescuotaamortizacionSaldo Final180,000,000800,000$7,107,9036,307,90373,692,097273,692,097736,921$7,107,9036,370,98267,321,115367,321,115673,211$7,107,9036,434,69260,886,423460,886,423608,864$7,107,9036,499,03954,387,384554,387,384543,874$7,107,9036,564,02947,823,355647,823,355478,234$7,107,9036,629,67041,193,685741,193,685411,937$7,107,9036,695,96634,497,719834,497,719344,977$7,107,9036,762,92627,734,793927,734,793277,348$7,107,9036,830,55520,904,2381020,904,238209,042$7,107,9036,898,86114,005,3771114,005,377140,054$7,107,9036,967,8497,037,528127,037,52870,375$7,107,9037,037,52805,294,837HELM BANKVA$ 20,000,000.00i5%TVCUOTA TRIMESTRAL IGUALESn4TRIMESTRESCuota$5,640,237mesSaldo InicialinteresescuotaamortizacionSaldo Final120,000,0001,000,000$5,640,2374,640,23715,359,763215,359,763767,988$5,640,2374,872,24810,487,515310,487,515524,376$5,640,2375,115,8615,371,65445,371,654268,583$5,640,2375,371,6540.02,560,947mesSaldo InicialinteresescuotaAbono a KSaldo Final020,000,000120,000,00020,000,000220,000,00020,000,000320,000,0001,000,000$5,640,2374,640,23715,359,763415,359,76315,359,763515,359,76315,359,763615,359,763767,988$5,640,2374,872,24810,487,515710,487,51510,487,515810,487,51510,487,515910,487,515524,376$5,640,2375,115,8615,371,654105,371,6545,371,654115,371,6545,371,654125,371,654268,583$5,640,2375,371,6540.0respuestas al ejercicioCosto mensual de los interes7,855,784costo mensualmesInteres cr 1intereses Cr 2Costo mensual1800,000800,0002736,921736,9213673,2111,000,0001,673,2114608,864608,8645543,874543,8746478,234767,9881,246,2227411,937411,9378344,977344,9779277,348524,376801,72410209,042209,04211140,054140,0541270,375268,583338,9587,855,784CONSOLIDADO PARA EL CALCULO DE LA DEUDA USANDO PROMEDIOS PONDERADOSTIPmesSaldo InicialinteresescuotaAbono a KSaldo FinalKD MensualF2CONTROL ENTER1100,000,000800,0007,107,9036,307,90393,692,0970.80%MV293,692,097736,9217,107,9036,370,98287,321,1150.79%MV387,321,1151,673,21112,748,14011,074,92976,246,1861.92%MV476,246,186608,8647,107,9036,499,03969,747,1470.80%MV569,747,147543,8747,107,9036,564,02963,183,1180.78%MV663,183,1181,246,22212,748,14011,501,91851,681,2001.97%MV751,681,200411,9377,107,9036,695,96644,985,2340.80%MV844,985,234344,9777,107,9036,762,92638,222,3080.77%MV938,222,308801,72412,748,14011,946,41626,275,8922.10%MV1026,275,892209,0427,107,9036,898,86119,377,0310.80%MV1119,377,031140,0547,107,9036,967,84912,409,1820.72%MV1212,409,182338,95812,748,14012,409,18202.73%MV7,855,784107,855,784100,000,00014.96%NAMVcomo hallo al nominal anual mes vencido16.04%EAsolo se suman la periodicas MV

PLAZOS DIFERENTESEl Gerente del motel "El ltimo Suspiro", ha decido ampliar las zonas de esparcimiento para sus clientespara lo cual, de acuerdo al presupuesto dado por el arquitecto, se necesitan 200 millones de pesos.El gerente financiero logr adquirir dos crditos para suplir esta necesidad, pero sus plazos son diferentes:Primer Crdito: Con el BBVA por un monto de 140 millones de pesos, con cuotas mensuales iguales,tasa de inters del 0,95% mensual vencido y un plazo de ao y medio.Segundo Crdito: Con Davivienda por un monto de 60 millones de pesos, con cuotas trimestrales igualestasa de inters del 5,8% trimestral vencido con un plazo de dos aos.El Gerente desea conocer cul va a ser el costo de los recursos externos al finalizar el primer y segundoao y para cada uno de los meses en que estn contratados los crditos.BBVAVA$ 140,000,000i0.95%MVn18Cuota$8,498,518mesSaldo InicialinteresescuotaamortizacionSaldo Final1140,000,0001,330,000$8,498,5187,168,518132,831,4822132,831,4821,261,899$8,498,5187,236,619125,594,8633125,594,8631,193,151$8,498,5187,305,367118,289,4964118,289,4961,123,750$8,498,5187,374,768110,914,7295110,914,7291,053,690$8,498,5187,444,828103,469,9016103,469,901982,964$8,498,5187,515,55495,954,347795,954,347911,566$8,498,5187,586,95288,367,395888,367,395839,490$8,498,5187,659,02880,708,367980,708,367766,729$8,498,5187,731,78872,976,5791072,976,579693,278$8,498,5187,805,24065,171,3391165,171,339619,128$8,498,5187,879,39057,291,9481257,291,948544,274$8,498,5187,954,24449,337,7041349,337,704468,708$8,498,5188,029,81041,307,8941441,307,894392,425$8,498,5188,106,09333,201,8011533,201,801315,417$8,498,5188,183,10125,018,7001625,018,700237,678$8,498,5188,260,84016,757,8601716,757,860159,200$8,498,5188,339,3188,418,542188,418,54279,976$8,498,5188,418,542-0DAVIVIENDAVA$ 60,000,000i5.80%TVn8Cuota$9,585,817mesSaldo InicialinteresescuotaamortizacionSaldo Final060,000,000160,000,00060,000,000260,000,00060,000,000360,000,0003,480,000$9,585,8176,105,81753,894,183453,894,18353,894,183553,894,18353,894,183653,894,1833,125,863$9,585,8176,459,95547,434,228747,434,22847,434,228847,434,22847,434,228947,434,2282,751,185$9,585,8176,834,63240,599,5961040,599,59640,599,5961140,599,59640,599,5961240,599,5962,354,777$9,585,8177,231,04133,368,5551333,368,55533,368,5551433,368,55533,368,5551533,368,5551,935,376$9,585,8177,650,44125,718,1141625,718,11425,718,1141725,718,11425,718,1141825,718,1141,491,651$9,585,8178,094,16717,623,9471917,623,94717,623,9472017,623,94717,623,9472117,623,9471,022,189$9,585,8178,563,6289,060,319229,060,3199,060,319239,060,3199,060,319249,060,319525,498$9,585,8179,060,3190.0CONSOLIDADOmesSaldo InicialinteresescuotaamortizacionSaldo FinalKD Mensual1200,000,0001,330,0008,498,5187,168,518192,831,4820.67%MV2192,831,4821,261,8998,498,5187,236,619185,594,8630.65%MV3185,594,8634,673,15118,084,33513,411,184172,183,6792.52%MV4172,183,6791,123,7508,498,5187,374,768164,808,9110.65%MV5164,808,9111,053,6908,498,5187,444,828157,364,0830.64%MV6157,364,0834,108,82718,084,33513,975,509143,388,5752.61%MV7143,388,575911,5668,498,5187,586,952135,801,6230.64%MV8135,801,623839,4908,498,5187,659,028128,142,5950.62%MV9128,142,5953,517,91518,084,33514,566,421113,576,1752.75%MV10113,576,175693,2788,498,5187,805,240105,770,9340.61%MV11105,770,934619,1288,498,5187,879,39097,891,5440.59%MVCALCULO POR AO 11297,891,5442,899,05018,084,33515,185,28582,706,2592.96%MV15.90%NAMV1382,706,259468,7088,498,5188,029,81074,676,4490.57%MV17.11%EACOSTO DE LA DEUDA AO 11474,676,449392,4258,498,5188,106,09366,570,3560.53%MV1566,570,3562,250,79318,084,33515,833,54250,736,8143.38%MV1650,736,814237,6788,498,5188,260,84042,475,9740.47%MV1742,475,974159,2008,498,5188,339,31834,136,6560.37%MV1834,136,6561,571,62718,084,33516,512,70917,623,9474.60%MV1917,623,94717,623,9470.00%MV2017,623,94717,623,9470.00%MV2117,623,9471,022,189$9,585,8178,563,6289,060,3195.80%MV229,060,3199,060,3190.00%MV239,060,3199,060,3190.00%MVCALCULO POR AO 2249,060,319525,498$9,585,8179,060,319-05.80%MV21.52%NAMV29,659,862229,659,862200,000,00037.42%NAMV23.78%EACOSTO DE LA DEUDA AO 244.96%

EJERCICION DE WORDUNIVERSIDAD EANESPECIALIZACIN EN GERENCIA FINANCIERAFORMULACIN Y EVALUACIN DE PROYECTOSEjercicios Costo de la Deuda.1. Hallar el KD por ao para financiar el proyecto PKS que requiere dos crditos con las siguientes condiciones:a. Primer crdito: $70 millones, plazo de 5 aos, forma de pago en cuotas anuales iguales, con las siguientes tasas de inters: 20% anual S.V. para los dos primeros aos y 24% anual S.A. para los tres ltimos aos.se usa la funcion BUSCAR OBJETIVO DE EXCELb. Segundo crdito: $120 millones, plazo 4 aos, forma de pago en cuotas anuales iguales, con las siguientes tasas de inters: 18% anual T.V. para el primer ao y 22% anual T.V. para los tres ltimos aos.a. Elabore la tabla de amortizacin de la deuda.b. Elabore el costo promedio de la deuda (Kd) para la empresa PKS.2. La empresa "Faroe" decide, que para realizar su proyecto de expansin de planta es necesario contratar deuda. Para tal efecto toma dos crditos. El primero de ellos con BBVA por un valor de 400 millones de pesos. El plazo de dicha deuda es de 6 aos, con pagos o cuotas anuales iguales. La tasa convenida con el banco fue de 26% Trimestre vencido para los primeros dos aos, 22% semestre anticipado para el ao 3 y 4, y 16% Efectiva anual para los dos ltimos.El segundo crdito que toma lo hace con Bancolombia, por un valor de 600 millones de pesos. El plazo de este crdito es de 5 aos, con cuotas anuales iguales. La tasa convenida con el banco fue de 21% Semestre anticipado para los dos primeros aos, 18% trimestre vencido para el ao 3, y 15% Bimensual anticipada para los dos ltimos.a. Elabore la tabla de amortizacin de la deuda.b. Elabore el costo promedio de la deuda (Kd) para la empresa Faroe.PUNTO 1 aVA$ 70,000,000iMVn5AOSCUOTABuscar ObjetivoEn el menu de datos,en la opcion de analisis Y si, la opcion buscar objetivo, en la tabla le coloco que laultima celda debe dar cero(0) porque quiero que se pague el credito y la celda que debe cambiar es ls de la cuota que me invente.PeriodoTasa nominalDebo converti los que no sean E.A.PASO A SEM VENCIDOCALCULO LA E.A.mesSaldo InicialinteresescuotaamortizacionSaldo Final120%NASV21.00%E.A.21.00%E.A.170,000,00014,700,000$25,314,81110,614,81159,385,189220%NASV21%E.A.21.00%E.A.259,385,18912,470,890$25,314,81112,843,92246,541,267324%NASA12%S.A.13.64%S.V.29.13%E.A.346,541,26713,558,510$25,314,81111,756,30234,784,965424%NASA12%S.A.13.64%S.V.29.13%E.A.434,784,96510,133,636$25,314,81115,181,17519,603,790524%NASA12%S.A.13.64%S.V.29.13%E.A.519,603,7905,711,021$25,314,81119,603,7900.027.27%NASVPUNTO 1 bVA$ 120,000,000iMVn4AOSCUOTAPeriodoTasa nominalDebo converti los que no sean E.A.mesSaldo InicialinteresescuotaamortizacionSaldo Final118%NATV19.25%E.A.1120,000,00023,102,232$47,943,70524,841,47395,158,527222%NATV23.88%E.A.295,158,52722,726,202$47,943,70525,217,50369,941,025322%NATV23.88%E.A.369,941,02516,703,641$47,943,70531,240,06438,700,961422%NATV23.88%E.A.438,700,9619,242,744$47,943,70538,700,9610.0LEER EL CAPITULO 3Y5REPASAR LO QUE SE VIO HOYCONSOLIDADOmesSaldo InicialinteresescuotaamortizacionSaldo Final1190,000,00037,802,23273,258,51635,456,284154,543,7162154,543,71635,197,09273,258,51638,061,424116,482,2923116,482,29230,262,15073,258,51642,996,36673,485,926473,485,92619,376,38073,258,51653,882,13619,603,790519,603,7905,711,021$25,314,81119,603,7900.0

QuiizPopularVA$ 192,500,000i12.00%NAMV1%MVn36Cuotacuota$6,393,754.64mesSaldo InicialinteresescuotaamortizacionSaldo Final1192,500,0001,925,000$6,393,7554,468,755188,031,2452188,031,2451,880,312$6,393,7554,513,442183,517,8033183,517,8031,835,178$6,393,7554,558,577178,959,2274178,959,2271,789,592$6,393,7554,604,162174,355,0645174,355,0641,743,551$6,393,7554,650,204169,704,8606169,704,8601,697,049$6,393,7554,696,706165,008,1547165,008,1541,650,082$6,393,7554,743,673160,264,4818160,264,4811,602,645$6,393,7554,791,110155,473,3719155,473,3711,554,734$6,393,7554,839,021150,634,35010150,634,3501,506,344$6,393,7554,887,411145,746,93911145,746,9391,457,469$6,393,7554,936,285140,810,65412140,810,6541,408,107$6,393,7554,985,648135,825,00613135,825,0061,358,250$6,393,7555,035,505130,789,50114130,789,5011,307,895$6,393,7555,085,860125,703,64215125,703,6421,257,036$6,393,7555,136,718120,566,92316120,566,9231,205,669$6,393,7555,188,085115,378,83817115,378,8381,153,788$6,393,7555,239,966110,138,87218110,138,8721,101,389$6,393,7555,292,366104,846,50619104,846,5061,048,465$6,393,7555,345,29099,501,2162099,501,216995,012$6,393,7555,398,74294,102,4742194,102,474941,025$6,393,7555,452,73088,649,7442288,649,744886,497$6,393,7555,507,25783,142,4872383,142,487831,425$6,393,7555,562,33077,580,1572477,580,157775,802$6,393,7555,617,95371,962,2042571,962,204719,622$6,393,7555,674,13366,288,0712666,288,071662,881$6,393,7555,730,87460,557,1972760,557,197605,572$6,393,7555,788,18354,769,0152854,769,015547,690$6,393,7555,846,06448,922,9502948,922,950489,230$6,393,7555,904,52543,018,4253043,018,425430,184$6,393,7555,963,57037,054,8553137,054,855370,549$6,393,7556,023,20631,031,6493231,031,649310,316$6,393,7556,083,43824,948,2103324,948,210249,482$6,393,7556,144,27318,803,9383418,803,938188,039$6,393,7556,205,71512,598,2233512,598,223125,982$6,393,7556,267,7726,330,450366,330,45063,305$6,393,7556,330,4500CITY30 MES10VA$ 202,900,000i12.00%NATV3%TVn10Cuotacuota$23,786,069.79mesSaldo InicialinteresescuotaamortizacionSaldo Final0202,900,0001202,900,000202,900,0002202,900,000202,900,0003202,900,0006,087,000$23,786,07017,699,070185,200,9304185,200,930185,200,9305185,200,930185,200,9306185,200,9305,556,028$23,786,07018,230,042166,970,8887166,970,888166,970,8888166,970,888166,970,8889166,970,8885,009,127$23,786,07018,776,943148,193,94510148,193,945148,193,94511148,193,945148,193,94512148,193,9454,445,818$23,786,07019,340,251128,853,69413128,853,694128,853,69414128,853,694128,853,69415128,853,6943,865,611$23,786,07019,920,459108,933,23516108,933,235108,933,23517108,933,235108,933,23518108,933,2353,267,997$23,786,07020,518,07388,415,1621988,415,16288,415,1622088,415,16288,415,1622188,415,1622,652,455$23,786,07021,133,61567,281,5472267,281,54767,281,5472367,281,54767,281,5472467,281,5472,018,446$23,786,07021,767,62345,513,9242545,513,92445,513,9242645,513,92445,513,9242745,513,9241,365,418$23,786,07022,420,65223,093,2722823,093,27223,093,2722923,093,27223,093,2723023,093,272692,798$23,786,07023,093,2720.0CONSOLIDADOmesSaldo InicialinteresescuotaamortizacionSaldo FinalKD Mensual1395,400,0001,925,0006,393,7554,468,755390,931,2450.49%2390,931,2451,880,3126,393,7554,513,442386,417,8030.48%3386,417,8037,922,17830,179,82422,257,646364,160,1572.05%4364,160,1571,789,5926,393,7554,604,162359,555,9940.49%5359,555,9941,743,5516,393,7554,650,204354,905,7900.48%6354,905,7907,253,07730,179,82422,926,748331,979,0422.04%7331,979,0421,650,0826,393,7554,743,673327,235,3690.50%8327,235,3691,602,6456,393,7554,791,110322,444,2600.49%9322,444,2606,563,86030,179,82423,615,964298,828,2952.04%10298,828,2951,506,3446,393,7554,887,411293,940,8840.50%11293,940,8841,457,4696,393,7554,936,285289,004,5990.50%CALCULO POR AO 112289,004,5995,853,92530,179,82424,325,900264,678,7002.03%12.09%NAMV13264,678,7001,358,2506,393,7555,035,505259,643,1950.51%12.78%EACOSTO DE LA DEUDA AO 114259,643,1951,307,8956,393,7555,085,860254,557,3350.50%15254,557,3355,122,64730,179,82425,057,177229,500,1582.01%16229,500,1581,205,6696,393,7555,188,085224,312,0730.53%17224,312,0731,153,7886,393,7555,239,966219,072,1070.51%18219,072,1074,369,38630,179,82425,810,439193,261,6681.99%19193,261,6681,048,4656,393,7555,345,290187,916,3780.54%20187,916,378995,0126,393,7555,398,742182,517,6360.53%21182,517,6363,593,48030,179,82426,586,345155,931,2911.97%22155,931,291886,4976,393,7555,507,257150,424,0340.57%23150,424,034831,4256,393,7555,562,330144,861,7040.55%CALCULO POR AO 224144,861,7042,794,24830,179,82427,385,576117,476,1281.93%12.15%NAMV25117,476,128719,6226,393,7555,674,133111,801,9950.61%12.85%EACOSTO DE LA DEUDA AO 226111,801,995662,8816,393,7555,730,874106,071,1210.59%27106,071,1211,970,99030,179,82428,208,83577,862,2861.86%2877,862,286547,6906,393,7555,846,06472,016,2220.70%2972,016,222489,2306,393,7555,904,52566,111,6970.68%3066,111,6971,122,98230,179,82429,056,84237,054,8551.70%3137,054,855370,5496,393,7556,023,20631,031,6491.00%3231,031,649310,3166,393,7556,083,43824,948,2101.00%3324,948,210249,4826,393,7556,144,27318,803,9381.00%3418,803,938188,0396,393,7556,205,71512,598,2231.00%CALCULO POR AO 23512,598,223125,9826,393,7556,267,7726,330,4501.00%12.15%NAMV366,330,45063,3056,393,7556,330,45001.00%12.84%EACOSTO DE LA DEUDA AO 2