Transcript

Hoja1MENU PRINCIPALEJERCICIO 1EJERCICIO 2EJERCICIO 3EJERCICIO 4EJERCICIO 5EJERCICIO 6EJERCICIO 7EJERCICIO 8EJERCICIO 9EJERCICIO 10EJERCICIO 11EJERCICIO 12EJERCICIO 13

EJER 11. Una persona solicita un prstamo el da 15 de abril de 2015 y debe efectuar pagos mensuales de $ 220.000,00, desde el 15 de mayo de 2015, hasta el 15 de abril de 2019. Si le cobran un inters del 2,5% efectivo mensual, cul es el valor del prstamo?

interes EM2.5%valor cuota$ 220,000.00n48valor prestamo$ 6,110,093.82nfechaSaldo anteriorInteresesCuotaSaldo actual04/15/15$ 0.00$ 0.00$ 0.00$ 6,110,093.8215/15/15$ 6,110,093.82$ 152,752.35-$ 220,000.00$ 6,042,846.1626/15/15$ 6,042,846.16$ 151,071.15-$ 220,000.00$ 5,973,917.3237/15/15$ 5,973,917.32$ 149,347.93-$ 220,000.00$ 5,903,265.25REGRESAR48/15/15$ 5,903,265.25$ 147,581.63-$ 220,000.00$ 5,830,846.8859/15/15$ 5,830,846.88$ 145,771.17-$ 220,000.00$ 5,756,618.05610/15/15$ 5,756,618.05$ 143,915.45-$ 220,000.00$ 5,680,533.50711/15/15$ 5,680,533.50$ 142,013.34-$ 220,000.00$ 5,602,546.84812/15/15$ 5,602,546.84$ 140,063.67-$ 220,000.00$ 5,522,610.5191/15/16$ 5,522,610.51$ 138,065.26-$ 220,000.00$ 5,440,675.77102/15/16$ 5,440,675.77$ 136,016.89-$ 220,000.00$ 5,356,692.67113/15/16$ 5,356,692.67$ 133,917.32-$ 220,000.00$ 5,270,609.99124/15/16$ 5,270,609.99$ 131,765.25-$ 220,000.00$ 5,182,375.23135/15/16$ 5,182,375.23$ 129,559.38-$ 220,000.00$ 5,091,934.62146/15/16$ 5,091,934.62$ 127,298.37-$ 220,000.00$ 4,999,232.98157/15/16$ 4,999,232.98$ 124,980.82-$ 220,000.00$ 4,904,213.81168/15/16$ 4,904,213.81$ 122,605.35-$ 220,000.00$ 4,806,819.15179/15/16$ 4,806,819.15$ 120,170.48-$ 220,000.00$ 4,706,989.631810/15/16$ 4,706,989.63$ 117,674.74-$ 220,000.00$ 4,604,664.371911/15/16$ 4,604,664.37$ 115,116.61-$ 220,000.00$ 4,499,780.982012/15/16$ 4,499,780.98$ 112,494.52-$ 220,000.00$ 4,392,275.50211/15/17$ 4,392,275.50$ 109,806.89-$ 220,000.00$ 4,282,082.39222/15/17$ 4,282,082.39$ 107,052.06-$ 220,000.00$ 4,169,134.45233/15/17$ 4,169,134.45$ 104,228.36-$ 220,000.00$ 4,053,362.81244/15/17$ 4,053,362.81$ 101,334.07-$ 220,000.00$ 3,934,696.88255/15/17$ 3,934,696.88$ 98,367.42-$ 220,000.00$ 3,813,064.31266/15/17$ 3,813,064.31$ 95,326.61-$ 220,000.00$ 3,688,390.91277/15/17$ 3,688,390.91$ 92,209.77-$ 220,000.00$ 3,560,600.69288/15/17$ 3,560,600.69$ 89,015.02-$ 220,000.00$ 3,429,615.70299/15/17$ 3,429,615.70$ 85,740.39-$ 220,000.00$ 3,295,356.103010/15/17$ 3,295,356.10$ 82,383.90-$ 220,000.00$ 3,157,740.003111/15/17$ 3,157,740.00$ 78,943.50-$ 220,000.00$ 3,016,683.503212/15/17$ 3,016,683.50$ 75,417.09-$ 220,000.00$ 2,872,100.59331/15/18$ 2,872,100.59$ 71,802.51-$ 220,000.00$ 2,723,903.10342/15/18$ 2,723,903.10$ 68,097.58-$ 220,000.00$ 2,572,000.68353/15/18$ 2,572,000.68$ 64,300.02-$ 220,000.00$ 2,416,300.69364/15/18$ 2,416,300.69$ 60,407.52-$ 220,000.00$ 2,256,708.21375/15/18$ 2,256,708.21$ 56,417.71-$ 220,000.00$ 2,093,125.92386/15/18$ 2,093,125.92$ 52,328.15-$ 220,000.00$ 1,925,454.06397/15/18$ 1,925,454.06$ 48,136.35-$ 220,000.00$ 1,753,590.42408/15/18$ 1,753,590.42$ 43,839.76-$ 220,000.00$ 1,577,430.18419/15/18$ 1,577,430.18$ 39,435.75-$ 220,000.00$ 1,396,865.934210/15/18$ 1,396,865.93$ 34,921.65-$ 220,000.00$ 1,211,787.584311/15/18$ 1,211,787.58$ 30,294.69-$ 220,000.00$ 1,022,082.274412/15/18$ 1,022,082.27$ 25,552.06-$ 220,000.00$ 827,634.33451/15/19$ 827,634.33$ 20,690.86-$ 220,000.00$ 628,325.18462/15/19$ 628,325.18$ 15,708.13-$ 220,000.00$ 424,033.31473/15/19$ 424,033.31$ 10,600.83-$ 220,000.00$ 214,634.15484/15/19$ 214,634.15$ 5,365.85-$ 220,000.00-$ 0.00

EJER 22. Otra persona solicita un prstamo de $ 25.000.000,00 el da 27 de abril de 2015 y debe efectuar pagos mensuales de $ 1.200.000,00, desde el 27 de mayo de 2015, hasta el 27 de abril de 2018. cul es el inters efectivo mensual, para este prstamo?

valor prestamo$ 25,000,000.00valor cuota$ 1,200,000.00n36interes EM3.32%nfechaSaldo anteriorInteresesCuotaSaldo actual04/27/15$ 0.00$ 0.00$ 0.00$ 25,000,000.0015/27/15$ 25,000,000.00$ 829,398.77-$ 1,200,000.00$ 24,629,398.7726/27/15$ 24,629,398.77$ 817,103.72-$ 1,200,000.00$ 24,246,502.49REGRESAR37/27/15$ 24,246,502.49$ 804,400.77-$ 1,200,000.00$ 23,850,903.2648/27/15$ 23,850,903.26$ 791,276.39-$ 1,200,000.00$ 23,442,179.6559/27/15$ 23,442,179.65$ 777,716.60-$ 1,200,000.00$ 23,019,896.24610/27/15$ 23,019,896.24$ 763,706.94-$ 1,200,000.00$ 22,583,603.19711/27/15$ 22,583,603.19$ 749,232.51-$ 1,200,000.00$ 22,132,835.69812/27/15$ 22,132,835.69$ 734,277.87-$ 1,200,000.00$ 21,667,113.5691/27/16$ 21,667,113.56$ 718,827.09-$ 1,200,000.00$ 21,185,940.65102/27/16$ 21,185,940.65$ 702,863.72-$ 1,200,000.00$ 20,688,804.37113/27/16$ 20,688,804.37$ 686,370.75-$ 1,200,000.00$ 20,175,175.13124/27/16$ 20,175,175.13$ 669,330.62-$ 1,200,000.00$ 19,644,505.74135/27/16$ 19,644,505.74$ 651,725.15-$ 1,200,000.00$ 19,096,230.90146/27/16$ 19,096,230.90$ 633,535.61-$ 1,200,000.00$ 18,529,766.51157/27/16$ 18,529,766.51$ 614,742.62-$ 1,200,000.00$ 17,944,509.13168/27/16$ 17,944,509.13$ 595,326.15-$ 1,200,000.00$ 17,339,835.28179/27/16$ 17,339,835.28$ 575,265.52-$ 1,200,000.00$ 16,715,100.801810/27/16$ 16,715,100.80$ 554,539.36-$ 1,200,000.00$ 16,069,640.161911/27/16$ 16,069,640.16$ 533,125.59-$ 1,200,000.00$ 15,402,765.752012/27/16$ 15,402,765.75$ 511,001.40-$ 1,200,000.00$ 14,713,767.15211/27/17$ 14,713,767.15$ 488,143.21-$ 1,200,000.00$ 14,001,910.36222/27/17$ 14,001,910.36$ 464,526.69-$ 1,200,000.00$ 13,266,437.05233/27/17$ 13,266,437.05$ 440,126.66-$ 1,200,000.00$ 12,506,563.71244/27/17$ 12,506,563.71$ 414,917.14-$ 1,200,000.00$ 11,721,480.85255/27/17$ 11,721,480.85$ 388,871.27-$ 1,200,000.00$ 10,910,352.12266/27/17$ 10,910,352.12$ 361,961.30-$ 1,200,000.00$ 10,072,313.43277/27/17$ 10,072,313.43$ 334,158.57-$ 1,200,000.00$ 9,206,472.00288/27/17$ 9,206,472.00$ 305,433.46-$ 1,200,000.00$ 8,311,905.46299/27/17$ 8,311,905.46$ 275,755.37-$ 1,200,000.00$ 7,387,660.833010/27/17$ 7,387,660.83$ 245,092.67-$ 1,200,000.00$ 6,432,753.503111/27/17$ 6,432,753.50$ 213,412.71-$ 1,200,000.00$ 5,446,166.213212/27/17$ 5,446,166.21$ 180,681.74-$ 1,200,000.00$ 4,426,847.95331/27/18$ 4,426,847.95$ 146,864.89-$ 1,200,000.00$ 3,373,712.84342/27/18$ 3,373,712.84$ 111,926.13-$ 1,200,000.00$ 2,285,638.97353/27/18$ 2,285,638.97$ 75,828.25-$ 1,200,000.00$ 1,161,467.22364/27/18$ 1,161,467.22$ 38,532.78-$ 1,200,000.00-$ 0.00

EJER 33. Cuntos depsitos mensuales de $ 750.000,00 cada uno sern necesarios para acumular $ 15.000.000,00 si la tasa de inters es del 5,0% efectivo anual?valor cuota$ 750,000.00valor futuro$ 15,000,000.00interes EA5.0%interes EM0.4074%n19.5nfechaSaldo anteriorInteresesCuotaSaldo actual04/27/15$ 0.00$ 0.00$ 0.00$ 0.0015/27/15$ 0.00$ 0.00$ 750,000.00$ 750,000.00REGRESAR26/27/15$ 750,000.00$ 3,055.59$ 750,000.00$ 1,503,055.5937/27/15$ 1,503,055.59$ 6,123.63$ 750,000.00$ 2,259,179.2348/27/15$ 2,259,179.23$ 9,204.18$ 750,000.00$ 3,018,383.4059/27/15$ 3,018,383.40$ 12,297.27$ 750,000.00$ 3,780,680.67610/27/15$ 3,780,680.67$ 15,402.96$ 750,000.00$ 4,546,083.63711/27/15$ 4,546,083.63$ 18,521.31$ 750,000.00$ 5,314,604.94812/27/15$ 5,314,604.94$ 21,652.36$ 750,000.00$ 6,086,257.3091/27/16$ 6,086,257.30$ 24,796.17$ 750,000.00$ 6,861,053.46102/27/16$ 6,861,053.46$ 27,952.78$ 750,000.00$ 7,639,006.24113/27/16$ 7,639,006.24$ 31,122.26$ 750,000.00$ 8,420,128.50124/27/16$ 8,420,128.50$ 34,304.65$ 750,000.00$ 9,204,433.15135/27/16$ 9,204,433.15$ 37,500.00$ 750,000.00$ 9,991,933.15146/27/16$ 9,991,933.15$ 40,708.37$ 750,000.00$ 10,782,641.52157/27/16$ 10,782,641.52$ 43,929.82$ 750,000.00$ 11,576,571.34168/27/16$ 11,576,571.34$ 47,164.38$ 750,000.00$ 12,373,735.72179/27/16$ 12,373,735.72$ 50,412.13$ 750,000.00$ 13,174,147.851810/27/16$ 13,174,147.85$ 53,673.11$ 750,000.00$ 13,977,820.961911/27/16$ 13,977,820.96$ 56,947.37$ 750,000.00$ 14,784,768.332012/27/16$ 14,784,768.33$ 60,234.98$ 750,000.00$ 15,595,003.31211/27/17$ 15,595,003.31$ 63,535.97$ 750,000.00$ 16,408,539.28222/27/17$ 16,408,539.28$ 66,850.42$ 750,000.00$ 17,225,389.70233/27/17$ 17,225,389.70$ 70,178.37$ 750,000.00$ 18,045,568.07244/27/17$ 18,045,568.07$ 73,519.88$ 750,000.00$ 18,869,087.95

EJER 44. Una mquina tiene un precio de contado de $ 150000.000,00. Una empresa la adquiere mediante un pago inicial del 40% sobre este valor de la mquina, y el resto a 36 pagos mensuales de $ 4500.000,00 Qu tasa nominal capitalizable mensualmente se est cobrando?

valor maquina$ 150,000,000.00cuota inicial 40%$ 60,000,000.00valor presente$ 90,000,000.00n36valor cuota$ 4,500,000.00interes EM3.60%nfechaSaldo anteriorInteresesCuotaSaldo actual04/27/15$ 0.00$ 0.00$ 0.00$ 90,000,000.0015/27/15$ 90,000,000.00$ 3,240,616.81-$ 4,500,000.00$ 88,740,616.81REGRESAR26/27/15$ 88,740,616.81$ 3,195,270.39-$ 4,500,000.00$ 87,435,887.2037/27/15$ 87,435,887.20$ 3,148,291.18-$ 4,500,000.00$ 86,084,178.3748/27/15$ 86,084,178.37$ 3,099,620.40-$ 4,500,000.00$ 84,683,798.7759/27/15$ 84,683,798.77$ 3,049,197.13-$ 4,500,000.00$ 83,232,995.90610/27/15$ 83,232,995.90$ 2,996,958.29-$ 4,500,000.00$ 81,729,954.19711/27/15$ 81,729,954.19$ 2,942,838.48-$ 4,500,000.00$ 80,172,792.67812/27/15$ 80,172,792.67$ 2,886,770.00-$ 4,500,000.00$ 78,559,562.6791/27/16$ 78,559,562.67$ 2,828,682.66-$ 4,500,000.00$ 76,888,245.33102/27/16$ 76,888,245.33$ 2,768,503.78-$ 4,500,000.00$ 75,156,749.11113/27/16$ 75,156,749.11$ 2,706,158.05-$ 4,500,000.00$ 73,362,907.16124/27/16$ 73,362,907.16$ 2,641,567.45-$ 4,500,000.00$ 71,504,474.61135/27/16$ 71,504,474.61$ 2,574,651.14-$ 4,500,000.00$ 69,579,125.75146/27/16$ 69,579,125.75$ 2,505,325.38-$ 4,500,000.00$ 67,584,451.14157/27/16$ 67,584,451.14$ 2,433,503.43-$ 4,500,000.00$ 65,517,954.56168/27/16$ 65,517,954.56$ 2,359,095.39-$ 4,500,000.00$ 63,377,049.95179/27/16$ 63,377,049.95$ 2,282,008.15-$ 4,500,000.00$ 61,159,058.101810/27/16$ 61,159,058.10$ 2,202,145.24-$ 4,500,000.00$ 58,861,203.351911/27/16$ 58,861,203.35$ 2,119,406.72-$ 4,500,000.00$ 56,480,610.072012/27/16$ 56,480,610.07$ 2,033,689.05-$ 4,500,000.00$ 54,014,299.12211/27/17$ 54,014,299.12$ 1,944,884.95-$ 4,500,000.00$ 51,459,184.07222/27/17$ 51,459,184.07$ 1,852,883.30-$ 4,500,000.00$ 48,812,067.37233/27/17$ 48,812,067.37$ 1,757,568.96-$ 4,500,000.00$ 46,069,636.33244/27/17$ 46,069,636.33$ 1,658,822.64-$ 4,500,000.00$ 43,228,458.97255/27/17$ 43,228,458.97$ 1,556,520.79-$ 4,500,000.00$ 40,284,979.76266/27/17$ 40,284,979.76$ 1,450,535.36-$ 4,500,000.00$ 37,235,515.12277/27/17$ 37,235,515.12$ 1,340,733.74-$ 4,500,000.00$ 34,076,248.86288/27/17$ 34,076,248.86$ 1,226,978.50-$ 4,500,000.00$ 30,803,227.36299/27/17$ 30,803,227.36$ 1,109,127.29-$ 4,500,000.00$ 27,412,354.653010/27/17$ 27,412,354.65$ 987,032.64-$ 4,500,000.00$ 23,899,387.293111/27/17$ 23,899,387.29$ 860,541.74-$ 4,500,000.00$ 20,259,929.023212/27/17$ 20,259,929.02$ 729,496.30-$ 4,500,000.00$ 16,489,425.32331/27/18$ 16,489,425.32$ 593,732.32-$ 4,500,000.00$ 12,583,157.64342/27/18$ 12,583,157.64$ 453,079.91-$ 4,500,000.00$ 8,536,237.55353/27/18$ 8,536,237.55$ 307,363.05-$ 4,500,000.00$ 4,343,600.61364/27/18$ 4,343,600.61$ 156,399.39-$ 4,500,000.00$ 0.00

EJER 55. Determinar x en el siguiente diagrama de flujo de caja.

REGRESAR

valor prestamo$ 22,000,000.00interes EM2.70%valor X$ 1,289,216.84

nSaldo anteriorInteresesCuotaSaldo actual0$ 0.00$ 0.00$ 0.00$ 22,000,000.001$ 22,000,000.00$ 594,000.00-$ 1,289,216.84$ 21,304,783.162$ 21,304,783.16$ 575,229.15-$ 1,289,216.84$ 20,590,795.473$ 20,590,795.47$ 555,951.48-$ 1,289,216.84$ 19,857,530.114$ 19,857,530.11$ 536,153.31-$ 1,289,216.84$ 19,104,466.595$ 19,104,466.59$ 515,820.60-$ 1,289,216.84$ 18,331,070.356$ 18,331,070.35$ 494,938.90-$ 2,578,433.67$ 16,247,575.577$ 16,247,575.57$ 438,684.54-$ 2,578,433.67$ 14,107,826.448$ 14,107,826.44$ 380,911.31-$ 2,578,433.67$ 11,910,304.089$ 11,910,304.08$ 321,578.21-$ 2,578,433.67$ 9,653,448.6210$ 9,653,448.62$ 260,643.11-$ 2,578,433.67$ 7,335,658.0511$ 7,335,658.05$ 198,062.77-$ 2,578,433.67$ 4,955,287.1512$ 4,955,287.15$ 133,792.75-$ 2,578,433.67$ 2,510,646.2313$ 2,510,646.23$ 67,787.45-$ 2,578,433.67-$ 0.00

EJER 66. Una mquina tiene un precio de fbrica al contado de $60.000.000,00, sin embargo, se puede comprar a crdito segn los siguientes opciones:* Opcin A, cuota inicial del 20% y 24 cuotas mensuales de $2.500.000,00.*Opcin B, cuota inicial del 30% y 12 cuotas mensuales de $4.000.000,00.Determinar la mejor opcin.REGRESARDATOSvalor maquina$ 60,000,000.00OPCION AOPCION Bcuota inicial 20%$ 12,000,000.00cuota inicial 30%$ 18,000,000.00valor presente$ 48,000,000.00valor presente$ 42,000,000.00valor cuota$ 2,500,000.00valor cuota$ 4,000,000.00n24n12interes EM1.87%interes EM2.12%*nSaldo anteriorInteresesCuotaSaldo actualnSaldo anteriorInteresesCuotaSaldo actual0$ 0.00$ 0.00$ 0.00$ 48,000,000.000$ 0.00$ 0.00$ 0.00$ 42,000,000.001$ 48,000,000.00$ 896,600.95-$ 2,500,000.00$ 46,396,600.951$ 42,000,000.00$ 888,976.73-$ 4,000,000.00$ 38,888,976.732$ 46,396,600.95$ 866,650.76-$ 2,500,000.00$ 44,763,251.722$ 38,888,976.73$ 823,128.46-$ 4,000,000.00$ 35,712,105.203$ 44,763,251.72$ 836,141.13-$ 2,500,000.00$ 43,099,392.853$ 35,712,105.20$ 755,886.44-$ 4,000,000.00$ 32,467,991.644$ 43,099,392.85$ 805,061.60-$ 2,500,000.00$ 41,404,454.454$ 32,467,991.64$ 687,221.17-$ 4,000,000.00$ 29,155,212.815$ 41,404,454.45$ 773,401.53-$ 2,500,000.00$ 39,677,855.985$ 29,155,212.81$ 617,102.52-$ 4,000,000.00$ 25,772,315.336$ 39,677,855.98$ 741,150.07-$ 2,500,000.00$ 37,919,006.056$ 25,772,315.33$ 545,499.73-$ 4,000,000.00$ 22,317,815.067$ 37,919,006.05$ 708,296.19-$ 2,500,000.00$ 36,127,302.247$ 22,317,815.06$ 472,381.39-$ 4,000,000.00$ 18,790,196.458$ 36,127,302.24$ 674,828.62-$ 2,500,000.00$ 34,302,130.868$ 18,790,196.45$ 397,715.42-$ 4,000,000.00$ 15,187,911.869$ 34,302,130.86$ 640,735.90-$ 2,500,000.00$ 32,442,866.769$ 15,187,911.86$ 321,469.05-$ 4,000,000.00$ 11,509,380.9110$ 32,442,866.76$ 606,006.36-$ 2,500,000.00$ 30,548,873.1210$ 11,509,380.91$ 243,608.85-$ 4,000,000.00$ 7,752,989.7711$ 30,548,873.12$ 570,628.10-$ 2,500,000.00$ 28,619,501.2211$ 7,752,989.77$ 164,100.66-$ 4,000,000.00$ 3,917,090.4212$ 28,619,501.22$ 534,589.00-$ 2,500,000.00$ 26,654,090.2212$ 3,917,090.42$ 82,909.58-$ 4,000,000.00-$ 0.0013$ 26,654,090.22$ 497,876.72-$ 2,500,000.00$ 24,651,966.9514$ 24,651,966.95$ 460,478.69-$ 2,500,000.00$ 22,612,445.6415$ 22,612,445.64$ 422,382.09-$ 2,500,000.00$ 20,534,827.7316$ 20,534,827.73$ 383,573.88-$ 2,500,000.00$ 18,418,401.6117$ 18,418,401.61$ 344,040.76-$ 2,500,000.00$ 16,262,442.3618$ 16,262,442.36$ 303,769.19-$ 2,500,000.00$ 14,066,211.5619$ 14,066,211.56$ 262,745.39-$ 2,500,000.00$ 11,828,956.9520$ 11,828,956.95$ 220,955.29-$ 2,500,000.00$ 9,549,912.2421$ 9,549,912.24$ 178,384.59-$ 2,500,000.00$ 7,228,296.8422$ 7,228,296.84$ 135,018.71-$ 2,500,000.00$ 4,863,315.5423$ 4,863,315.54$ 90,842.78-$ 2,500,000.00$ 2,454,158.3224$ 2,454,158.32$ 45,841.68-$ 2,500,000.00-$ 0.00

EJER 77. Determinar x en el siguiente diagrama de flujo de caja.REGRESARDATOSvalor prestamo$ 20,000,000.00interes EA35.5%interes ET7.89%n12a=incremento$ 500,000.00*abono cuota 2$ 6,000,000.00*nvo prestamo cuota 4$ 5,000,000.00*X$ 3,836,470.65nvo valor presentenSaldo anteriorInteresesCuotaSaldo actual0$ 0.00$ 0.00$ 0.00$ 20,000,000.001$ 20,000,000.00$ 1,578,180.39$ 0.00$ 21,578,180.392$ 21,578,180.39$ 1,702,713.06-$ 6,000,000.00$ 17,280,893.453$ 17,280,893.45$ 1,363,618.36$ 0.00$ 18,644,511.814$ 18,644,511.81$ 1,471,220.15$ 5,000,000.00$ 25,115,731.965$ 25,115,731.96$ 1,981,857.79$ 0.00$ 27,097,589.756$ 27,097,589.75$ 2,138,244.24-$ 3,836,470.65$ 25,399,363.347$ 25,399,363.34$ 2,004,238.86-$ 4,336,470.65$ 23,067,131.568$ 23,067,131.56$ 1,820,204.74-$ 4,836,470.65$ 20,050,865.649$ 20,050,865.64$ 1,582,194.15-$ 5,336,470.65$ 16,296,589.1510$ 16,296,589.15$ 1,285,947.87-$ 5,836,470.65$ 11,746,066.3711$ 11,746,066.37$ 926,870.58-$ 6,336,470.65$ 6,336,466.3012$ 6,336,466.30$ 500,004.34-$ 6,836,470.65-$ 0.00

EJER 88. Una oficina se arrienda mediante un contrato que fija pagos de $2.200.000,00 mensuales al principio de cada mes, durante un ao. Si el inters es del 4,5% efectivo anual; Cul ser el pago nico al inicio del contrato que cubre todo el arriendo de todo el ao?

Datos:cuota$ 2,200,000.00anualidades anticipadasn12Interes EA4.50%Interes EM0.37%Valor presente$ 27,877,624.64nSaldo anteriorInteresesCuotaSaldo actual0$ 27,877,624.64$ 102,444.96-$ 2,200,000.00$ 25,780,069.601$ 25,780,069.60$ 94,736.84-$ 2,200,000.00$ 23,674,806.442$ 23,674,806.44$ 87,000.40-$ 2,200,000.00$ 21,561,806.843$ 21,561,806.84$ 79,235.53-$ 2,200,000.00$ 19,441,042.37REGRESAR4$ 19,441,042.37$ 71,442.13-$ 2,200,000.00$ 17,312,484.505$ 17,312,484.50$ 63,620.08-$ 2,200,000.00$ 15,176,104.586$ 15,176,104.58$ 55,769.29-$ 2,200,000.00$ 13,031,873.877$ 13,031,873.87$ 47,889.65-$ 2,200,000.00$ 10,879,763.528$ 10,879,763.52$ 39,981.06-$ 2,200,000.00$ 8,719,744.589$ 8,719,744.58$ 32,043.40-$ 2,200,000.00$ 6,551,787.9810$ 6,551,787.98$ 24,076.57-$ 2,200,000.00$ 4,375,864.5511$ 4,375,864.55$ 16,080.47-$ 2,200,000.00$ 2,191,945.0212$ 2,191,945.02$ 8,054.98-$ 2,200,000.00-$ 0.00

EJER 99. El primero de enero, Mara arrienda una casa en $1.400.000,00 que se deben pagar por mes anticipado. Tan pronto recibe el arriendo lo invierte en un fondo que le paga el 7,6% EA. Cul ser el monto de los ahorros de Mara al finalizar el ao?

Datos:cuota:$ 1,400,000.00anualidad anticipadaInteres EA7.6%Interes EM0.61%nFechaSaldo anteriorArriendoSaldo arriendoInteres fondoAhorros01/1/15$ 0.00$ 1,400,000.00$ 1,400,000.00$ 8,572.02$ 1,408,572.0212/1/15$ 1,400,000.00$ 1,400,000.00$ 2,800,000.00$ 17,144.05$ 2,817,144.0523/1/15$ 2,800,000.00$ 1,400,000.00$ 4,200,000.00$ 25,716.07$ 4,225,716.07REGRESAR34/1/15$ 4,200,000.00$ 1,400,000.00$ 5,600,000.00$ 34,288.09$ 5,634,288.0945/1/15$ 5,600,000.00$ 1,400,000.00$ 7,000,000.00$ 42,860.12$ 7,042,860.1256/1/15$ 7,000,000.00$ 1,400,000.00$ 8,400,000.00$ 51,432.14$ 8,451,432.1467/1/15$ 8,400,000.00$ 1,400,000.00$ 9,800,000.00$ 60,004.16$ 9,860,004.1678/1/15$ 9,800,000.00$ 1,400,000.00$ 11,200,000.00$ 68,576.19$ 11,268,576.1989/1/15$ 11,200,000.00$ 1,400,000.00$ 12,600,000.00$ 77,148.21$ 12,677,148.21910/1/15$ 12,600,000.00$ 1,400,000.00$ 14,000,000.00$ 85,720.23$ 14,085,720.231011/1/15$ 14,000,000.00$ 1,400,000.00$ 15,400,000.00$ 94,292.26$ 15,494,292.261112/1/15$ 15,400,000.00$ 1,400,000.00$ 16,800,000.00$ 102,864.28$ 16,902,864.28121/1/16$ 16,800,000.00$ 1,400,000.00$ 18,200,000.00$ 111,436.30$ 18,311,436.30$ 127,400,000.00$ 780,054.12$ 128,180,054.12

EJER 1010. Pedro Prez se afilia a un fondo de pensiones voluntarias, y para ello decide realizar inicialmente un pago de $ 400.000,00, el cual se incrementa en $20.000,00 cada mes durante los prximos 8 aos, si el fondo reconoce un inters del 8,0 % EA, determinar la pensin que recibir Pedro Prez a partir del noveno ao, para el resto de su vida.

Datos:Cuota 1$ 400,000.00Incremento mensual$ 20,000.00n96Interes EA8%Interes EM0.64%Anualidad perpetuaGradiente aritmeticonSaldo anteriorInteresesCuotaSaldo actual0$ 0.00$ 0.00$ 400,000.00$ 400,000.001$ 400,000.00$ 2,573.61$ 420,000.00$ 822,573.61REGRESAR2$ 822,573.61$ 5,292.46$ 440,000.00$ 1,267,866.083$ 1,267,866.08$ 8,157.49$ 460,000.00$ 1,736,023.564$ 1,736,023.56$ 11,169.63$ 480,000.00$ 2,227,193.195$ 2,227,193.19$ 14,329.83$ 500,000.00$ 2,741,523.026$ 2,741,523.02$ 17,639.04$ 520,000.00$ 3,279,162.067$ 3,279,162.06$ 21,098.23$ 540,000.00$ 3,840,260.298$ 3,840,260.29$ 24,708.35$ 560,000.00$ 4,424,968.649$ 4,424,968.64$ 28,470.38$ 580,000.00$ 5,033,439.0210$ 5,033,439.02$ 32,385.30$ 600,000.00$ 5,665,824.3211$ 5,665,824.32$ 36,454.08$ 620,000.00$ 6,322,278.4012$ 6,322,278.40$ 40,677.73$ 640,000.00$ 7,002,956.1313$ 7,002,956.13$ 45,057.23$ 660,000.00$ 7,708,013.3614$ 7,708,013.36$ 49,593.59$ 680,000.00$ 8,437,606.9515$ 8,437,606.95$ 54,287.82$ 700,000.00$ 9,191,894.7716$ 9,191,894.77$ 59,140.93$ 720,000.00$ 9,971,035.7017$ 9,971,035.70$ 64,153.94$ 740,000.00$ 10,775,189.6418$ 10,775,189.64$ 69,327.89$ 760,000.00$ 11,604,517.5419$ 11,604,517.54$ 74,663.82$ 780,000.00$ 12,459,181.3520$ 12,459,181.35$ 80,162.75$ 800,000.00$ 13,339,344.1021$ 13,339,344.10$ 85,825.74$ 820,000.00$ 14,245,169.8422$ 14,245,169.84$ 91,653.85$ 840,000.00$ 15,176,823.6923$ 15,176,823.69$ 97,648.14$ 860,000.00$ 16,134,471.8324$ 16,134,471.83$ 103,809.68$ 880,000.00$ 17,118,281.5125$ 17,118,281.51$ 110,139.54$ 900,000.00$ 18,128,421.0526$ 18,128,421.05$ 116,638.81$ 920,000.00$ 19,165,059.8627$ 19,165,059.86$ 123,308.57$ 940,000.00$ 20,228,368.4328$ 20,228,368.43$ 130,149.93$ 960,000.00$ 21,318,518.3629$ 21,318,518.36$ 137,163.99$ 980,000.00$ 22,435,682.3530$ 22,435,682.35$ 144,351.86$ 1,000,000.00$ 23,580,034.2131$ 23,580,034.21$ 151,714.65$ 1,020,000.00$ 24,751,748.8632$ 24,751,748.86$ 159,253.50$ 1,040,000.00$ 25,951,002.3533$ 25,951,002.35$ 166,969.53$ 1,060,000.00$ 27,177,971.8834$ 27,177,971.88$ 174,863.89$ 1,080,000.00$ 28,432,835.7735$ 28,432,835.77$ 182,937.72$ 1,100,000.00$ 29,715,773.4936$ 29,715,773.49$ 191,192.18$ 1,120,000.00$ 31,026,965.6837$ 31,026,965.68$ 199,628.43$ 1,140,000.00$ 32,366,594.1138$ 32,366,594.11$ 208,247.64$ 1,160,000.00$ 33,734,841.7539$ 33,734,841.75$ 217,050.99$ 1,180,000.00$ 35,131,892.7440$ 35,131,892.74$ 226,039.66$ 1,200,000.00$ 36,557,932.3941$ 36,557,932.39$ 235,214.84$ 1,220,000.00$ 38,013,147.2342$ 38,013,147.23$ 244,577.73$ 1,240,000.00$ 39,497,724.9643$ 39,497,724.96$ 254,129.55$ 1,260,000.00$ 41,011,854.5244$ 41,011,854.52$ 263,871.51$ 1,280,000.00$ 42,555,726.0245$ 42,555,726.02$ 273,804.82$ 1,300,000.00$ 44,129,530.8446$ 44,129,530.84$ 283,930.73$ 1,320,000.00$ 45,733,461.5747$ 45,733,461.57$ 294,250.47$ 1,340,000.00$ 47,367,712.0448$ 47,367,712.04$ 304,765.29$ 1,360,000.00$ 49,032,477.3349$ 49,032,477.33$ 315,476.44$ 1,380,000.00$ 50,727,953.7650$ 50,727,953.76$ 326,385.18$ 1,400,000.00$ 52,454,338.9551$ 52,454,338.95$ 337,492.80$ 1,420,000.00$ 54,211,831.7452$ 54,211,831.74$ 348,800.56$ 1,440,000.00$ 56,000,632.3053$ 56,000,632.30$ 360,309.75$ 1,460,000.00$ 57,820,942.0554$ 57,820,942.05$ 372,021.68$ 1,480,000.00$ 59,672,963.7455$ 59,672,963.74$ 383,937.65$ 1,500,000.00$ 61,556,901.3856$ 61,556,901.38$ 396,058.96$ 1,520,000.00$ 63,472,960.3457$ 63,472,960.34$ 408,386.94$ 1,540,000.00$ 65,421,347.2858$ 65,421,347.28$ 420,922.92$ 1,560,000.00$ 67,402,270.2059$ 67,402,270.20$ 433,668.24$ 1,580,000.00$ 69,415,938.4360$ 69,415,938.43$ 446,624.24$ 1,600,000.00$ 71,462,562.6761$ 71,462,562.67$ 459,792.28$ 1,620,000.00$ 73,542,354.9562$ 73,542,354.95$ 473,173.73$ 1,640,000.00$ 75,655,528.6863$ 75,655,528.68$ 486,769.95$ 1,660,000.00$ 77,802,298.6364$ 77,802,298.63$ 500,582.33$ 1,680,000.00$ 79,982,880.9665$ 79,982,880.96$ 514,612.26$ 1,700,000.00$ 82,197,493.2266$ 82,197,493.22$ 528,861.15$ 1,720,000.00$ 84,446,354.3767$ 84,446,354.37$ 543,330.39$ 1,740,000.00$ 86,729,684.7568$ 86,729,684.75$ 558,021.40$ 1,760,000.00$ 89,047,706.1669$ 89,047,706.16$ 572,935.62$ 1,780,000.00$ 91,400,641.7870$ 91,400,641.78$ 588,074.48$ 1,800,000.00$ 93,788,716.2671$ 93,788,716.26$ 603,439.42$ 1,820,000.00$ 96,212,155.6972$ 96,212,155.69$ 619,031.91$ 1,840,000.00$ 98,671,187.5973$ 98,671,187.59$ 634,853.39$ 1,860,000.00$ 101,166,040.9874$ 101,166,040.98$ 650,905.35$ 1,880,000.00$ 103,696,946.3475$ 103,696,946.34$ 667,189.28$ 1,900,000.00$ 106,264,135.6176$ 106,264,135.61$ 683,706.65$ 1,920,000.00$ 108,867,842.2677$ 108,867,842.26$ 700,458.98$ 1,940,000.00$ 111,508,301.2478$ 111,508,301.24$ 717,447.77$ 1,960,000.00$ 114,185,749.0079$ 114,185,749.00$ 734,674.55$ 1,980,000.00$ 116,900,423.5580$ 116,900,423.55$ 752,140.85$ 2,000,000.00$ 119,652,564.4081$ 119,652,564.40$ 769,848.20$ 2,020,000.00$ 122,442,412.6082$ 122,442,412.60$ 787,798.17$ 2,040,000.00$ 125,270,210.7783$ 125,270,210.77$ 805,992.31$ 2,060,000.00$ 128,136,203.0884$ 128,136,203.08$ 824,432.19$ 2,080,000.00$ 131,040,635.2685$ 131,040,635.26$ 843,119.39$ 2,100,000.00$ 133,983,754.6686$ 133,983,754.66$ 862,055.51$ 2,120,000.00$ 136,965,810.1787$ 136,965,810.17$ 881,242.15$ 2,140,000.00$ 139,987,052.3288$ 139,987,052.32$ 900,680.91$ 2,160,000.00$ 143,047,733.2389$ 143,047,733.23$ 920,373.42$ 2,180,000.00$ 146,148,106.6590$ 146,148,106.65$ 940,321.32$ 2,200,000.00$ 149,288,427.9791$ 149,288,427.97$ 960,526.24$ 2,220,000.00$ 152,468,954.2192$ 152,468,954.21$ 980,989.84$ 2,240,000.00$ 155,689,944.0593$ 155,689,944.05$ 1,001,713.79$ 2,260,000.00$ 158,951,657.8494$ 158,951,657.84$ 1,022,699.75$ 2,280,000.00$ 162,254,357.5995$ 162,254,357.59$ 1,043,949.42$ 2,300,000.00$ 165,598,307.0196$ 165,598,307.01$ 1,065,464.49$ 2,320,000.00$ 168,983,771.51Pension97-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.6798-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.6799-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67100-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67101-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67102-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67103-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67104-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67105-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67106-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67107-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67108-$ 168,983,771.51-$ 1,087,246.67-$ 168,983,771.51-$ 1,087,246.67

EJER 1111. En la siguiente tabla de pagos mensuales con un inters del 22,5% EA, calcular el valor presente y el valor futuro, asumiendo pagos vencidos.DATOSincremento mensual$ 20,000.00interes EA22.50%interes EM1.71%valor presente0.0valor futuro$ 5,355,660.44Asumiendo un ahorro programadonSaldo anteriorInteresesCuotaSaldo actual0$ 0.00$ 0.00$ 0.00$ 0.001$ 0.00$ 0.00$ 300,000.00$ 300,000.00REGRESAR2$ 300,000.00$ 5,116.66$ 320,000.00$ 625,116.663$ 625,116.66$ 10,661.71$ 340,000.00$ 975,778.374$ 975,778.37$ 16,642.44$ 360,000.00$ 1,352,420.815$ 1,352,420.81$ 23,066.28$ 380,000.00$ 1,755,487.096$ 1,755,487.09$ 29,940.80$ 400,000.00$ 2,185,427.897$ 2,185,427.89$ 37,273.67$ 420,000.00$ 2,642,701.568$ 2,642,701.56$ 45,072.73$ 440,000.00$ 3,127,774.299$ 3,127,774.29$ 53,345.91$ 460,000.00$ 3,641,120.2010$ 3,641,120.20$ 62,101.31$ 480,000.00$ 4,183,221.5111$ 4,183,221.51$ 71,347.14$ 500,000.00$ 4,754,568.6512$ 4,754,568.65$ 81,091.78$ 520,000.00$ 5,355,660.44

EJER 1212. En la siguiente tabla de cuotas peridicas con un inters del 15,0% EA, calcular el valor presente y el valor futuro. Asumir cuota periodo vencido.Datosinteres EA15.00%interesEM1.1715%n24valor presente$ 5,519,606.55

nSaldo anteriorInteresesCuotaSaldo actualREGRESAR0$ 0.00$ 0.000.00$ 5,519,606.551$ 5,519,606.55$ 64,661.73-200,000.00$ 5,384,268.282$ 5,384,268.28$ 63,076.26-210,000.00$ 5,237,344.543$ 5,237,344.54$ 61,355.06-220,500.00$ 5,078,199.594$ 5,078,199.59$ 59,490.69-231,525.00$ 4,906,165.285$ 4,906,165.28$ 57,475.32-243,101.25$ 4,720,539.356$ 4,720,539.35$ 55,300.73-255,256.31$ 4,520,583.767$ 4,520,583.76$ 52,958.26-268,019.13$ 4,305,522.908$ 4,305,522.90$ 50,438.84-281,420.08$ 4,074,541.669$ 4,074,541.66$ 47,732.92-295,491.09$ 3,826,783.4910$ 3,826,783.49$ 44,830.45-310,265.64$ 3,561,348.3011$ 3,561,348.30$ 41,720.90-325,778.93$ 3,277,290.2712$ 3,277,290.27$ 38,393.18-342,067.87$ 2,973,615.5813$ 2,973,615.58$ 34,835.66-342,067.87$ 2,666,383.3714$ 2,666,383.37$ 31,236.46-325,778.93$ 2,371,840.9015$ 2,371,840.90$ 27,785.92-310,265.64$ 2,089,361.1816$ 2,089,361.18$ 24,476.69-295,491.09$ 1,818,346.7817$ 1,818,346.78$ 21,301.78-281,420.08$ 1,558,228.4818$ 1,558,228.48$ 18,254.52-268,019.13$ 1,308,463.8719$ 1,308,463.87$ 15,328.55-255,256.31$ 1,068,536.1120$ 1,068,536.11$ 12,517.81-243,101.25$ 837,952.6721$ 837,952.67$ 9,816.55-231,525.00$ 616,244.2122$ 616,244.21$ 7,219.25-220,500.00$ 402,963.4623$ 402,963.46$ 4,720.68-210,000.00$ 197,684.1524$ 197,684.15$ 2,315.85-200,000.00$ 0.00

EJER 1313. El sbado 18 de abril de 2015, Pepito Prez solicita un prstamo de $10.000.000,00. La entidad financiera le entrega la siguiente tabla de pagosDeterminar el inters mensual que le cobra la entidad financiera a Pepito Prez.DATOSvrl prestamo$ 10,000,000.00n8g$ 200,000.00k$ 1,000,000.00interes EM6.39%#CUOTAFECHAsaldo anteriorinteresVLR CUOTAsaldo actual042112.0$ 0.00$ 0.00$ 0.00$ 10,000,000.00142142.0$ 10,000,000.00$ 638,899.08-$ 1,000,000.00$ 9,638,899.08242173.0$ 9,638,899.08$ 615,828.38-$ 1,200,000.00$ 9,054,727.46342203.0$ 9,054,727.46$ 578,505.71-$ 1,400,000.00$ 8,233,233.17442234.0$ 8,233,233.17$ 526,020.51-$ 1,600,000.00$ 7,159,253.68542265.0$ 7,159,253.68$ 457,404.06-$ 1,800,000.00$ 5,816,657.74642295.0$ 5,816,657.74$ 371,625.73-$ 2,000,000.00$ 4,188,283.47742326.0$ 4,188,283.47$ 267,589.05-$ 2,200,000.00$ 2,255,872.51842356.0$ 2,255,872.51$ 144,127.49-$ 2,400,000.00-$ 0.00

REGRESAR

EJERCICIOS TERCER CORTE GESTIN ECONOMICAPRESENTADO POR:

DARWIN ALBERTO MORENO CASTROPRESENTADO A: INGENIERO JOSE GERMAN GUTIERREZUNIVERSIDAD ANTONIO NARIOFACULTAD DE INGENIERIAINGENIERIA MECANICABogot2015


Top Related