simulador de crÉditos

54
EJERCICIOS TERCER CORTE GESTIÓN ECONOM ICA PRESENTADO POR: DARW IN ALBERTO M ORENO CASTRO PRESENTADO A: INGENIERO JOSE GERM AN GUTIERREZ UNIVERSIDAD ANTONIO NARIÑO FACULTAD DE INGENIERIA INGENIERIA M ECANICA Bogotá 2015

Upload: darwin-alberto-moreno-castro

Post on 09-Nov-2015

30 views

Category:

Documents


0 download

DESCRIPTION

TIPOS DE SIMULADORES

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