actividad 5 individual
DESCRIPTION
Act 5 Matemática financieraTRANSCRIPT
PORTADA - 1CURSO 102007 MATEMTICA FINANCIERADESARROLLO ACTIVIDAD CINCO INDIVIDUALGLORIA JAQUELINE MENA FAJARDOUNIVERSIDAD ABIERTA Y A DISTANCIA UNAD
ABSTRACT - 2ConclusionesCon este trabajo se pretende que los estudiantes realice una revisin minuciosa de los temas que se tratan en la unidad 2 sobre Evaluacin de alternativas de inversin con el apoyo de hojas de clculo y simuladores, como herramienta para la toma de decisiones
FLUJO FONDOS CASO UNO -3RELACIN BENEFICIO COSTODatosEsperadoCASO 1Volumen de ventas en unidades$ 688,535.00$ 688,535.00Precio Unitario$ 1,021.00$ 1,021.00Costo Unitario$ 645.00$ 645.00VPB=$ 123,108,730.00+$ 109,530,687.00+$ 94,594,839.70+$ 78,165,407.67+$ 61,593,032.44Costo fijo$ 135,780,430.00Se incrementa en un 10% cada ao(1+0.11)1(1+0.11)2(1+0.11)3(1+0.11)(1+0.11)Valor residual$ 1,500,000.00Inversin$ 150,000,000.00VPB=$ 123,108,730.00+$ 109,530,687.00+$ 94,594,839.70+$ 78,165,407.67+GK25Tasa de descuento0.1111%1.1111.1121.1131.1141.115Rubros012345VPB=$ 123,108,730.00+$ 109,530,687.00+$ 94,594,839.70+$ 78,165,407.67+$ 61,593,032.441.111.231.371.521.69Ingresos$ 702,994,235.00$ 702,994,235.00$ 702,994,235.00$ 702,994,235.00$ 704,494,235.00VPB=$ 110,908,765.77+$ 88,897,562.70+$ 69,166,931.50+$ 51,489,975.14+$ 36,552,466.90Ventas$ 702,994,235.00$ 702,994,235.00$ 702,994,235.00$ 702,994,235.00$ 702,994,235.00Valor residual$ 1,500,000.00VPB=$ 357,015,702.01Egresos$ 150,000,000.00$ 579,885,505.00$ 593,463,548.00$ 608,399,395.30$ 624,828,827.33$ 642,901,202.56VPc=VF/(1+h)nCosto fijo$ 135,780,430.00$ 149,358,473.00$ 164,294,320.30$ 180,723,752.33$ 198,796,127.56Costo variable$ 444,105,075.00$ 444,105,075.00$ 444,105,075.00$ 444,105,075.00$ 444,105,075.00VPC=150,000,000.00Inversin$ 150,000,000.00RB/C=$ 2.38Flujo Neto-$ 150,000,000.00$ 123,108,730.00$ 109,530,687.00$ 94,594,839.70$ 78,165,407.67$ 61,593,032.44Indicadores de evaluacinVAN$ 207,015,702.01TIR66%RB/C=$ 2.38CON EXCEL RB/C=$ 2.38
FLUJO FONDOS CASO DOS -4RELACIN BENEFICIO COSTODatosEsperadoCASO 2Volumen de ventas en unidades$ 650,000.00$ 650,000.00Precio Unitario$ 1,100.00$ 1,100.00Costo Unitario$ 780.00$ 780.00VPB=$ 72,219,570.00+$ 72,219,570.00+$ 72,219,570.00+$ 72,219,570.00+$ 73,719,570.00Costo fijo$ 135,780,430.00(1+0.14)1(1+0.14)2(1+0.14)3(1+0.14)(1+0.14)Valor residual$ 1,500,000.00Inversin$ 150,000,000.00VPB=$ 72,219,570.00+$ 72,219,570.00+$ 72,219,570.00+$ 72,219,570.00+$ 73,719,570.00Tasa de descuento0.1414%1.1411.1421.1431.1441.145Rubros012345VPB=$ 72,219,570.00+$ 72,219,570.00+$ 72,219,570.00+$ 72,219,570.00+$ 73,719,570.001.141.301.481.691.93Ingresos$ 0.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 716,500,000.00VPB=$ 63,350,500.00+$ 55,570,614.04+$ 48,746,152.66+$ 42,759,783.04+$ 38,287,634.61Ventas$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00Valor residual$ 1,500,000.00VPB=$ 248,714,684.34Egresos$ 150,000,000.00$ 642,780,430.00$ 642,780,430.00$ 642,780,430.00$ 642,780,430.00$ 642,780,430.00VPc=VF/(1+h)nCosto fijo$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00Costo variable$ 507,000,000.00$ 507,000,000.00$ 507,000,000.00$ 507,000,000.00$ 507,000,000.00VPC=150,000,000.00Inversin$ 150,000,000.00RB/C=$ 1.66Flujo Neto-$ 150,000,000.00$ 72,219,570.00$ 72,219,570.00$ 72,219,570.00$ 72,219,570.00$ 73,719,570.00Indicadores de evaluacinVAN$ 98,714,684.34TIR39%RB/C=$ 1.66CON EXCEL RB/C=$ 1.66
FLUJO FONDOS CASO TRES -5RELACIN BENEFICIO COSTODatosEsperadoCASO 3Volumen de ventas en unidades$ 650,000.00$ 650,000.00Precio Unitario$ 1,100.00$ 1,100.00Costo Unitario$ 780.00$ 780.00VPB=$ 72,219,570.00+$ 72,219,570.00++$ 72,219,570.00+$ 73,719,570.00Costo fijo$ 135,780,430.00Se incrementa en un 10% cada ao(1+0.13)1(1+0.13)23(1+0.13)(1+0.13)Valor residual$ 1,500,000.00Inversin$ 150,000,000.00VPB=$ 72,219,570.00+$ 72,219,570.00++$ 72,219,570.00+$ 73,719,570.00Tasa de descuento0.1313%1.1311.13231.1341.135Rubros012345VPB=$ 72,219,570.00+$ 72,219,570.00++$ 72,219,570.00+$ 73,719,570.001.131.281.631.84Ingresos$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 716,500,000.00VPB=$ 63,911,123.89+$ 56,558,516.72++$ 44,293,614.79+$ 40,012,029.10Ventas$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00Valor residual$ 1,500,000.00VPB=$ 204,775,284.50Egresos$ 150,000,000.00$ 642,780,430.00$ 642,780,430.00$ 792,780,430.00$ 642,780,430.00$ 642,780,430.00VPc=VF/(1+h)nCosto fijo$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00Costo variable$ 507,000,000.00$ 507,000,000.00$ 507,000,000.00$ 507,000,000.00$ 507,000,000.00VPC=$ 150,000,000.00+$ 77,780,430.00Inversin$ 150,000,000.00$ 150,000,000.00(1+0.13)3Flujo Neto-$ 150,000,000.00$ 72,219,570.00$ 72,219,570.00-$ 77,780,430.00$ 72,219,570.00$ 73,719,570.00$ 150,000,000.00+$ 77,780,430.00Indicadores de evaluacin1.133VAN$ 869,544.86TIR13%$ 150,000,000.00+$ 77,780,430.00RB/C=$ 1.001.44CON EXCEL RB/C=$ 1.01$ 53,905,739.63VPC=203,905,739.63RB/C=$ 1.00
FLUJO FONDOS CASO CUATRO - 6RELACIN BENEFICIO COSTODatosEsperadoCASO 4Volumen de ventas en unidades$ 750,000.00$ 750,000.00Precio Unitario$ 980.00$ 980.00Costo Unitario$ 780.00$ 780.00VPB=$ 14,219,570.00+$ 14,219,570.00+$ 14,219,570.00+$ 14,219,570.00+$ 15,719,570.00Costo fijo$ 135,780,430.00Se incrementa en un 10% cada ao(1+0.12)1(1+0.12)2(1+0.12)3(1+0.12)(1+0.12)Valor residual$ 1,500,000.00Inversin$ 150,000,000.00VPB=$ 14,219,570.00+$ 14,219,570.00+$ 14,219,570.00+$ 14,219,570.00+$ 15,719,570.00Tasa de descuento0.1212%1.1211.1221.1231.1241.125Rubros012345VPB=$ 14,219,570.00+$ 14,219,570.00+$ 14,219,570.00+$ 14,219,570.00+$ 15,719,570.001.121.251.401.571.76Ingresos$ 735,000,000.00$ 735,000,000.00$ 735,000,000.00$ 735,000,000.00$ 736,500,000.00VPB=$ 12,696,044.64+$ 11,335,754.15+$ 10,121,209.06+$ 9,036,793.80+$ 8,919,706.18Ventas$ 735,000,000.00$ 735,000,000.00$ 735,000,000.00$ 735,000,000.00$ 735,000,000.00Valor residual$ 1,500,000.00VPB=$ 52,109,507.83Egresos$ 150,000,000.00$ 720,780,430.00$ 720,780,430.00$ 720,780,430.00$ 720,780,430.00$ 720,780,430.00VPc=VF/(1+h)nCosto fijo$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00Costo variable$ 585,000,000.00$ 585,000,000.00$ 585,000,000.00$ 585,000,000.00$ 585,000,000.00VPC=150,000,000.00Inversin$ 150,000,000.00RB/C=$ 0.35Flujo Neto-$ 150,000,000.00$ 14,219,570.00$ 14,219,570.00$ 14,219,570.00$ 14,219,570.00$ 15,719,570.00Indicadores de evaluacinVAN-$ 97,890,492.17TIR-20%RB/C=$ 0.35CON EXCEL RB/C=$ 0.35
FLUJO FONDOS CASO CINCO -7RELACIN BENEFICIO COSTODatosEsperadoCASO 5Volumen de ventas en unidades$ 722,952.00$ 722,952.00Precio Unitario$ 1,100.00$ 1,100.00Costo Unitario$ 650.00$ 650.00VPB=$ 89,547,970.00+++$ 89,547,970.00+Costo fijo$ 135,780,430.00(1+0.14)123(1+0.14)Valor residual$ 1,500,000.00Inversin$ 150,000,000.00$100.000.000,00 ao 1$250.000.000,00 ao 2$200.000.000,00 ao 3$100.000.000,00 ao 4$200.000.000,00 ao 5VPB=$ 89,547,970.00+++$ 89,547,970.00+Tasa de descuento0.1414%u1.141231.144Rubros012345VPB=$ 89,547,970.00+++$ 89,547,970.00+1.141.69Ingresos$ 795,247,200.00$ 795,247,200.00$ 795,247,200.00$ 795,247,200.00$ 796,747,200.00VPB=$ 78,550,850.88+++$ 53,019,586.92+Ventas$ 795,247,200.00$ 795,247,200.00$ 795,247,200.00$ 795,247,200.00$ 795,247,200.00Valor residual$ 1,500,000.00VPB=$ 131,570,437.79Egresos$ 150,000,000.00$ 705,699,230.00$ 855,699,230.00$ 805,699,230.00$ 705,699,230.00$ 805,699,230.00VPc=VF/(1+h)nCosto fijo$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00Costo variable$ 469,918,800.00$ 469,918,800.00$ 469,918,800.00$ 469,918,800.00$ 469,918,800.00VPC=$ 150,000,000.00+$ 60,452,030.00$ 150,000,000.00+$ 8,952,030.00$ 150,000,000.00+$ 10,452,030.00Inversin$ 150,000,000.00$ 100,000,000.00$ 250,000,000.00$ 200,000,000.00$ 100,000,000.00$ 200,000,000.00(1+0.14)2(1+0)5(1+0)3Flujo Neto-$ 150,000,000.00$ 89,547,970.00-$ 60,452,030.00-$ 10,452,030.00$ 89,547,970.00-$ 8,952,030.00$ 150,000,000.00+$ 60,452,030.00$ 150,000,000.00+$ 8,952,030.00$ 150,000,000.00+$ 10,452,030.00Indicadores de evaluacin1.1421.1451.143VAN-$ 76,649,662.72TIR-14%$ 150,000,000.00+$ 60,452,030.00$ 150,000,000.00+$ 8,952,030.00$ 150,000,000.00+$ 10,452,030.00RB/C=$ 0.631.301.931.48CON EXCEL RB/C=$ 0.67$ 46,515,874.12$ 4,649,403.86$ 7,054,822.54VPC=196,515,874.124,649,403.867,054,822.54208,220,100.52RB/C=$ 0.63
FLUJO FONDOS CASO SEIS -8RELACIN BENEFICIO COSTODatosEsperadoCASO 6Volumen de ventas en unidades$ 805,000.00$ 805,000.00Precio Unitario$ 1,300.00$ 1,300.00Costo Unitario$ 780.00$ 780.00VPB=$ 282,819,570.00+$ 282,819,570.00+$ 282,819,570.00+$ 282,819,570.00+$ 134,319,570.00Costo fijo$ 135,780,430.00(1+0.13)1(1+0.13)2(1+0.13)3(1+0.13)(1+0.13)Valor residual$ 1,500,000.00Inversin$ 150,000,000.00$150.000.000,00ao 5VPB=$ 282,819,570.00+$ 282,819,570.00+$ 282,819,570.00+$ 282,819,570.00+$ 134,319,570.00Tasa de descuento0.1313%1.1311.1321.1331.1341.135Rubros012345VPB=$ 282,819,570.00+$ 282,819,570.00+$ 282,819,570.00+$ 282,819,570.00+$ 134,319,570.001.131.281.441.631.84Ingresos$ 1,046,500,000.00$ 1,046,500,000.00$ 1,046,500,000.00$ 1,046,500,000.00$ 1,048,000,000.00VPB=$ 250,282,805.31+$ 221,489,208.24+$ 196,008,148.88+$ 173,458,538.84+$ 72,903,281.22Ventas$ 1,046,500,000.00$ 1,046,500,000.00$ 1,046,500,000.00$ 1,046,500,000.00$ 1,046,500,000.00Valor residual$ 1,500,000.00VPB=$ 914,141,982.48Egresos$ 150,000,000.00$ 763,680,430.00$ 763,680,430.00$ 763,680,430.00$ 763,680,430.00$ 913,680,430.00VPc=VF/(1+h)nCosto fijo$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00Costo variable$ 627,900,000.00$ 627,900,000.00$ 627,900,000.00$ 627,900,000.00$ 627,900,000.00VPC=150,000,000.00Inversin$ 150,000,000.00$ 150,000,000.00RB/C=$ 6.09Flujo Neto-$ 150,000,000.00$ 282,819,570.00$ 282,819,570.00$ 282,819,570.00$ 282,819,570.00$ 134,319,570.00Indicadores de evaluacinVAN$ 764,141,982.48TIR187%RB/C=$ 6.09CON EXCEL RB/C=$ 6.09
FLUJO FONDOS CASO SIETE -9RELACIN BENEFICIO COSTODatosEsperadoCASO 1Volumen de ventas en unidades$ 650,000.00$ 650,000.00Precio Unitario$ 1,100.00$ 1,100.00Costo Unitario$ 820.00$ 820.00VPB=$ 46,219,570.00+$ 46,219,570.00+$ 46,219,570.00+$ 46,219,570.00+$ 47,719,570.00Costo fijo$ 135,780,430.00Se incrementa en un 10% cada ao(1+0.13)1(1+0.13)2(1+0.13)3(1+0.13)(1+0.13)Valor residual$ 1,500,000.00Inversin$ 150,000,000.00VPB=$ 46,219,570.00+$ 46,219,570.00+$ 46,219,570.00+$ 46,219,570.00+$ 47,719,570.00Tasa de descuento0.1313%1.1311.1321.1331.1341.135Rubros012345VPB=$ 46,219,570.00+$ 46,219,570.00+$ 46,219,570.00+$ 46,219,570.00+$ 47,719,570.001.131.281.441.631.84Ingresos$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 716,500,000.00VPB=$ 40,902,274.34+$ 36,196,702.95+$ 32,032,480.49+$ 28,347,327.87+$ 25,900,270.76Ventas$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00$ 715,000,000.00Valor residual$ 1,500,000.00VPB=$ 163,379,056.40Egresos$ 150,000,000.00$ 668,780,430.00$ 668,780,430.00$ 668,780,430.00$ 668,780,430.00$ 668,780,430.00VPc=VF/(1+h)nCosto fijo$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00Costo variable$ 533,000,000.00$ 533,000,000.00$ 533,000,000.00$ 533,000,000.00$ 533,000,000.00VPC=150,000,000.00Inversin$ 150,000,000.00RB/C=$ 1.09Flujo Neto-$ 150,000,000.00$ 46,219,570.00$ 46,219,570.00$ 46,219,570.00$ 46,219,570.00$ 47,719,570.00Indicadores de evaluacinVAN$ 13,379,056.40TIR17%RB/C=$ 1.09CON EXCEL RB/C=$ 1.09
FLUJO FONDOS CASO OCHO -10RELACIN BENEFICIO COSTODatosEsperadoCASO 1Volumen de ventas en unidades$ 722,952.00$ 722,952.00Precio Unitario$ 980.00$ 980.00Costo Unitario$ 650.00$ 650.00VPB=$ 102,793,730.00+$ 102,793,730.00+$ 102,793,730.00+$ 102,793,730.00+$ 104,293,730.00Costo fijo$ 135,780,430.00(1+0.13)1(1+0.13)2(1+0.13)3(1+0.13)(1+0.13)Valor residual$ 1,500,000.00Inversin$ 150,000,000.00VPB=$ 102,793,730.00+$ 102,793,730.00+$ 102,793,730.00+$ 102,793,730.00+$ 104,293,730.00Tasa de descuento0.1313%1.1311.1321.1331.1341.135Rubros012345VPB=$ 102,793,730.00+$ 102,793,730.00+$ 102,793,730.00+$ 102,793,730.00+$ 104,293,730.001.131.281.441.631.84Ingresos$ 708,492,960.00$ 708,492,960.00$ 708,492,960.00$ 708,492,960.00$ 709,992,960.00VPB=$ 90,967,902.65+$ 80,502,568.72+$ 71,241,211.26+$ 63,045,319.70+$ 56,606,458.22Ventas$ 708,492,960.00$ 708,492,960.00$ 708,492,960.00$ 708,492,960.00$ 708,492,960.00Valor residual$ 1,500,000.00VPB=$ 362,363,460.55Egresos$ 150,000,000.00$ 605,699,230.00$ 605,699,230.00$ 605,699,230.00$ 605,699,230.00$ 605,699,230.00VPc=VF/(1+h)nCosto fijo$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00$ 135,780,430.00Costo variable$ 469,918,800.00$ 469,918,800.00$ 469,918,800.00$ 469,918,800.00$ 469,918,800.00VPC=150,000,000.00Inversin$ 150,000,000.00RB/C=$ 2.42Flujo Neto-$ 150,000,000.00$ 102,793,730.00$ 102,793,730.00$ 102,793,730.00$ 102,793,730.00$ 104,293,730.00Indicadores de evaluacinVAN$ 212,363,460.55TIR62.54%RB/C=$ 2.42CON EXCEL RB/C=$ 2.42
TABLA RESUMEN ESCENARIOS -11TABLA RESUMEN DE ESCENARIOS PROPUESTOS PARA ESTIMACION DE INDICADORESNombres y apellidos integrante del grupo (Diligencie en el cuadro siguiente el nombre completo de quien comparte la tabla)Volumen deventas enunidadesPrecioUnitarioCostoUnitarioVANTIRRB/CTasa de descuentoCaso 1$ 688,535.00$ 1,021.00$ 645.00$ 207,015,702.0166%2.3811%Caso 2$ 650,000.00$ 1,100.00$ 780.00$ 98,714,684.3439%1.6614%Caso 3$ 650,000.00$ 1,100.00$ 780.00$ 869,544.8613%1.0013%Caso 4$ 750,000.00$ 980.00$ 780.00-$ 97,890,492.17-20%0.3512%Caso 5$ 722,952.00$ 1,100.00$ 650.00-$ 76,649,662.72-14%0.6314%Caso 6$ 805,000.00$ 1,300.00$ 780.00$ 764,141,982.48187%6.0913%Caso 7$ 650,000.00$ 1,100.00$ 820.00$ 13,379,056.4017%1.0913%Caso 8$ 722,952.00$ 980.00$ 650.00$ 212,363,460.5563%2.4213%
CONCLUSIONES -12ConclusionesLa realizacin de esta actividad nos permite afianzar los conocimientos , la aplicacin de conceptos, conocer las ayudas que se tiene con Excel para realizar flujos de fondos, realizando pronostico de proyecciones para minimizar los riesgos en una empresa en sus actividades productivas.
REFERENCIAS -13ReferenciasAlba Sanchez, Doris Amelia, (2014). Syllabus Curso 102007 Matematica Financiera. Primera Edicin. Universidad Nacional Abierta y a Distancia UNAD. Recuperado de http//:campus12.unad.edu.co/campus12_20151/mod/lesson/view.php?id=1186Video desarrollo actividad 5. https://www.youtube.com/watch?v=wY2O3eiAzng&feature=youtu.be