{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Índice","Variables","Cálculos","Indicadores","Hoja4","Ppto MP","Inversiones","Hoja7","Hoja8","cargos","costo personal","arrendamiento","actividades","predecesoras","tabla amortización","diag. flujo"],"not_rendered":{"charts":14,"images":1,"macros":1,"external_links":0,"defined_names":1,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Índice","index":0,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[null,"ÍNDICE DEL ANÁLISIS FINANCIERO"]
["Gráfica"]
[null,"Cuadro 3.1 INGRESOS POR CONCEPTOS DE VENTAS DE SERVICIOS"]
[null,"Cuadro 5.1 COSTO EQUIPOS, MUEBLES Y ENSERES"]
[null,"Cuadro 5.2 PRESUPUESTO DE MATERIA PRIMA"]
[null,"Cuadro 5.3 PERSONAL TÉCNICO REQUERIDO - Descripción de cargos"]
[null,"Cuadro 5.4 PERSONAL TÉCNICO REQUERIDO - Costos"]
[null,"Cuadro 5.5 COSTOS DE ARRENDAMIENTO"]
[null,"Cuadro 6.1 ACTIVIDADES, DURACIÓN Y PREDECESORAS"]
[null,"Cuadro 7.1 ORGANIZACIÓN PARA LA EJECUCIÓN DEL PROYECTO - Descripción de cargos"]
[null,"Cuadro 7.2 ORGANIZACIÓN PARA LA EJECUCIÓN DEL PROYECTO - Costos"]
[null,"Cuadro 7.3 ORGANIZACIÓN ADMINISTRATIVA PARA LA OPERACIÓN DEL PROYECTO"]
[null,"Cuadro 7.4 ORGANIZACIÓN ADMINISTRATIVA PARA LA OPERACIÓN DEL PROYECTO"]
[null,"Cuadro 8.1 CAPITAL DE TRABAJO - SALDO DE EFECTIVO REQUERIDO EN CAJA"]
[null,"Cuadro 8.2 CÁLCULO DE CAPITAL DE TRABAJO"]
[null,"Cuadro 8.3 GASTOS PREOPERATIVOS"]
[null,"Cuadro 8.4 INVERSIONES EN EL PROYECTO"]
[null,"Cuadro 9.1 COSTO DE LA MANO DE OBRA DE LAS UNIDADES VENDIDAS"]
[null,"Cuadro 9.2 COSTOS DE OPERACIÓN Y DE FINANCIACIÓN"]
[null,"Cuadro 10.1 ACTIVOS TOTALES"]
[null,"Cuadro 10.2 RECURSOS FINANCIEROS"]
[null,"Cuadro 10.3 TABLA DE AMORTIZACIÓN DEL PRÉSTAMO (O CRÉDITO)"]
[null,"Cuadro 11.1 ESTADO DE RESULTADOS O ESTADO DE PÉRDIDAS Y GANANCIAS"]
[null,"Cuadro 11.2 FLUJO DE CAJA DEL PROYECTO"]
[null,"Cuadro 11.3 BALANCE PROYECTADO"]
[null,"Cuadro 11.4 INDICADORES PARA EL ANÁLISIS FINANCIERO"]
[null,"Cuadro 11.5 PUNTO DE EQUILIBRIO"]
[null,"Cuadro 11.6 PUNTO DE EQUILIBRIO DETALLADO"]
[null,"Cuadro 11.7 VARIACIÓN DEL PRECIO DE VENTAS"]
[null,"Cuadro 11.8 VARIACIÓN EN LOS COSTOS VARIABLES"]
[null,"Cuadro 11.9 VARIACIÓN EN LOS COSTOS FIJOS"]
[null,"Cuadro 12.1 FLUJO DE EFECTIVO NETO"]

{"sheet":"Variables","index":1,"n_rows":85,"n_cols":13,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
["VARIACIÓN",{"$f":"Hoja7!B2","v":1.0000000000000007}]
["PORCENTAGE DE VARIACIÓN",{"$f":"1-B1","v":0}]
["VARIABLES DEL PROYECTO","AÑO",2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
["(A precios del Año 2014 del proyecto)"]
["Número de años del proyecto",11,10]
["Programa de servicio asesorías individuales",{"$f":"C6*$C$5","v":1000},100,{"$f":"B6*D15","v":20000000.000000015}]
["Programa de servicio actividades educativas (dos horas)",{"$f":"C7*$C$5","v":100},10,{"$f":"B7*D16","v":20000000.000000015}]
["Programa de servicio seminarios (por participante)",{"$f":"C8*$C$5","v":1000},100,30000000.000000019]
["Programa de servicio asesorías técnicas",250,25,112500000.00000007]
["Programa de servicio cursos virtuales (adolescentes y jóvenes)",3150,315,37800000.000000022]
["Programa de servicio cursos virtuales (padres y madres)",1150,115,17250000.000000011]
["Programa de servicio cursos virtuales (docentes y profesionales)",1150,115,28750000.000000022]
["TOTAL 100% DE PRODUCCION",{"$f":"SUM(B6:B12)","v":7800}]
["Programa De Produccion (Porcentaje)",null,null,0.65,0.67,0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
["Programa de venta asesorías individuales",null,null,{"$f":"20000*B1","v":20000.000000000015},{"$f":"$D15","v":20000.000000000015},{"$f":"$D15","v":20000.000000000015},20000.000000000015,20000.000000000015,20000.000000000015,20000.000000000015,20000.000000000015,20000.000000000015,20000.000000000015]
["Programa de venta actividades educativas",null,null,{"$f":"200000*B1","v":200000.00000000015},{"$f":"$D16","v":200000.00000000015},200000.00000000015,200000.00000000015,200000.00000000015,200000.00000000015,200000.00000000015,200000.00000000015,200000.00000000015,200000.00000000015]
["Programa de venta seminarios (por participante)",null,null,{"$f":"30000*B1","v":30000.000000000018},30000.000000000018,30000.000000000018,30000.000000000018,30000.000000000018,30000.000000000018,30000.000000000018,30000.000000000018,30000.000000000018,30000.000000000018]
["Programa de venta asesorías técnicas",null,null,{"$f":"450000*B1","v":450000.00000000029},450000.00000000029,450000.00000000029,450000.00000000029,450000.00000000029,450000.00000000029,450000.00000000029,450000.00000000029,450000.00000000029,450000.00000000029]
["Programa de venta cursos virtuales (adolescentes y jóvenes)",null,null,{"$f":"12000*B1","v":12000.000000000007},12000.000000000007,12000.000000000007,12000.000000000007,12000.000000000007,12000.000000000007,12000.000000000007,12000.000000000007,12000.000000000007,12000.000000000007]
["Programa de venta cursos virtuales (padres y madres)",null,null,{"$f":"15000*B1","v":15000.000000000009},15000.000000000009,15000.000000000009,15000.000000000009,15000.000000000009,15000.000000000009,15000.000000000009,15000.000000000009,15000.000000000009,15000.000000000009]
["Programa de venta cursos virtuales (docentes y profesionales)",null,null,{"$f":"25000*B1","v":25000.000000000018},25000.000000000018,25000.000000000018,25000.000000000018,25000.000000000018,25000.000000000018,25000.000000000018,25000.000000000018,25000.000000000018,25000.000000000018]
["PRECIO PROMEDIO",{"$f":"(ROUND((Cálculos!I41/Cálculos!I40),2))*Variables!B1","v":34419.970000000023}]
["Inversiones Fijas - Millones"]
[" (Iniciales  Y Reposiciones)"]
["* Terrenos",null,0]
["* Edificios",null,0]
["Depreciacion",10,null,null,{"$f":"($C$26+$D$26)/$B$27","v":0},0,0,0,0,0]
["* Maquinaria Y Equipo",null,{"$f":"Inversiones!D28","v":350000}]
["Depreciacion",10,null,{"$f":"$C$28/$B$29","v":35000},35000,35000,35000,35000,35000,35000]
["* Vehiculo",null,0]
["Depreciacion",5,null,null,{"$f":"$C$30/$B$31","v":0},0,0,0,0,0]
["* Muebles Y Enseres",null,{"$f":"Inversiones!D57","v":16983000}]
["Depreciacion",5,null,null,{"$f":"$C$32/$B$33","v":3396600},3396600,3396600,3396600,3396600,3396600]
["* Herramientas",null,0]
["Depreciacion",10]
["Total Depreciacion",null,null,null,{"$f":"SUM(E27:E35)","v":3431600},3431600,3431600,3431600,3431600,3431600]
["Saldo En Libros Activos Depreciables",null,null,{"$f":"(J27*12)+(J29*2)+(J33*2)+C25","v":6863200}]
["Gastos Preoperativos (Millones)",5,{"$f":"Inversiones!B87","v":5610000}]
["  Amortizacion Diferidos",null,null,null,{"$f":"Cálculos!D79","v":1122000},{"$f":"Cálculos!E79","v":1122000},{"$f":"Cálculos!F79","v":1122000},{"$f":"Cálculos!G79","v":1122000},{"$f":"Cálculos!H79","v":0},{"$f":"Cálculos!I79","v":0}]
["Costo Unitarios En Dolares"]
["* Materiales E Insumos"]
["* Mano De Obra"]
["Gastos Generales De Fabricacion"]
["Gastos Generales De Administracion"]
["Gastos Generales De Ventas"]
["Gastos Generales De Distribucion"]
["Tasa De Impuestos",0.3]
["Dividendos (Porcentaje De Utilidades Netas",0]
["Prestamos Bancarios ",null,10000000]
["Credito Abastecedores"]
["Rendimientos Financieros"]
["Otros Recursos (Arrendamientos-Participaciones)"]
["Costos Financieros (Intereses En Millones)",0.24,null,{"$f":"$C$49*$B$53","v":2400000},{"$f":"(C49-D54)*$B$53","v":1999999.9999999998},{"$f":"(C49-(D54+E54))*B53","v":1599999.9999999998},{"$f":"(C49-(D54+E54+F54))*B53","v":1200000},{"$f":"(C49-(D54+E54+F54+G54))*B53","v":799999.99999999988},{"$f":"(C49-(D54+E54+F54+G54+H54))*B53","v":399999.99999999983}]
["Pago De Prestamos (En Millones)",6,null,{"$f":"$C$49/$B$54","v":1666666.6666666667},{"$f":"$C$49/$B$54","v":1666666.6666666667},{"$f":"$C$49/$B$54","v":1666666.6666666667},{"$f":"$C$49/$B$54","v":1666666.6666666667},{"$f":"$C$49/$B$54","v":1666666.6666666667},0]
["NECESIDADES MINIMAS DE ACTIVOS Y PASIVOS CORRIENTES"]
[null,"DIAS DE COBERTURA"]
["Efectivo En Caja Para Cubrir:"]
["* Materiales E Insumos",10]
["* Mano De Obra Directa",10]
["* Gastos Generales De Fabricacion",10]
["* Gastos Generales De Administracion",10]
["* Gastos Generales De Ventas",10]
["* Gastos Generales De Distribucion",10]
["Cuentas Por Cobrar",30]
["Existencias:"]
["* Materiales E Insumos",30]
["* Productos En Procesos",0]
["* Productos Terminados",0]
["* Inventarios De Repuestos",0]
["Cuentas Por Pagar"]
["* Materiales E Insumos",60]
["* Mano De Obra Directa",0]
["* Gastos Generales De Fabricacion",0]
["* Gastos Generales De Administracion",0]
["* Gastos Generales De Ventas",0]
["* Gastos Generales De Distribucion",0]
["Otros Ingresos"]
["Otros Egresos"]
["Capital De Trabajo (Calculado Por El Programa)"]
["EVALUACION FINANCIERA DEL PROYECTO"]
["Tasa De Inflacion",0.2]
["Tasa De Interes De Oportunidad Del Inversionista",{"$f":"(1+B83)/(1+B81)-1","v":0.10000000000000009}]
["* En Terminos Corrientes Anual",0.32]
["* En Terminos Constantes Anual",0.1]
["Tasa Para Evaluacion",0.1]

{"sheet":"Cálculos","index":2,"n_rows":792,"n_cols":17,"rows_kept":792,"cut":false,"hidden":false,"merged":[[758,2,758,4],[778,2,778,4],[704,13,704,16],[705,13,706,13],[705,14,706,14],[705,15,706,15],[705,16,706,16],[736,0,736,4],[756,0,756,4],[755,0,755,4],[735,0,735,4],[775,0,775,4],[776,0,776,4],[738,2,738,4]]}
[]
["Cuadro 3.1"]
["INGRESOS POR CONCEPTOS DE VENTAS DE SERVICIOS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+Variables!C$3","v":2014},{"$f":"+Variables!D$3","v":2015},{"$f":"+Variables!E$3","v":2016},{"$f":"+Variables!F$3","v":2017},{"$f":"+Variables!G$3","v":2018},{"$f":"+Variables!H$3","v":2019},{"$f":"+Variables!I$3","v":2020},{"$f":"+Variables!J$3","v":2021},{"$f":"+Variables!K$3","v":2022},{"$f":"+Variables!L$3","v":2023},{"$f":"+Variables!M$3","v":2024}]
[]
["Nivel de Producción",null,{"$f":"+Variables!D14","v":0.65},{"$f":"+Variables!E14","v":0.67},{"$f":"+Variables!F14","v":0.7},{"$f":"+Variables!G14","v":0.72},{"$f":"+Variables!H14","v":0.77},{"$f":"+Variables!I14","v":0.81},{"$f":"+Variables!J14","v":0.86},{"$f":"+Variables!K14","v":0.9},{"$f":"+Variables!L14","v":0.95},{"$f":"+Variables!M14","v":1}]
["1. ASESORÍAS INDIVIDUALES"]
["Unidades vendidas",null,{"$f":"+ROUND((C10*Variables!$B$6),-2)","v":700},{"$f":"+ROUND((D10*Variables!$B$6),-2)","v":700},{"$f":"+ROUND((E10*Variables!$B$6),-2)","v":700},{"$f":"+ROUND((F10*Variables!$B$6),-2)","v":700},{"$f":"+ROUND((G10*Variables!$B$6),-2)","v":800},{"$f":"+ROUND((H10*Variables!$B$6),-2)","v":800},{"$f":"+ROUND((I10*Variables!$B$6),-2)","v":900},{"$f":"+ROUND((J10*Variables!$B$6),-2)","v":900},{"$f":"+ROUND((K10*Variables!$B$6),-2)","v":1000},{"$f":"+ROUND((L10*Variables!$B$6),-2)","v":1000}]
["Precio de Venta",null,{"$f":"Variables!D15","v":20000.000000000015},{"$f":"Variables!E15","v":20000.000000000015},{"$f":"Variables!F15","v":20000.000000000015},{"$f":"Variables!G15","v":20000.000000000015},{"$f":"Variables!H15","v":20000.000000000015},{"$f":"Variables!I15","v":20000.000000000015},{"$f":"Variables!J15","v":20000.000000000015},{"$f":"Variables!K15","v":20000.000000000015},{"$f":"Variables!L15","v":20000.000000000015},{"$f":"Variables!M15","v":20000.000000000015}]
["Subtotal ingresos por ventas 1",null,{"$f":"+C12*C13","v":14000000.000000009},14000000.000000009,14000000.000000009,14000000.000000009,16000000.000000011,16000000.000000011,18000000.000000015,{"$f":"+J12*J13","v":18000000.000000015},20000000.000000015,20000000.000000015]
["2. ACTIVIDADES EDUCATIVAS"]
["Unidades vendidas",null,{"$f":"ROUND((C10*Variables!$B$7),-1)","v":70},{"$f":"ROUND((D10*Variables!$B$7),-1)","v":70},{"$f":"ROUND((E10*Variables!$B$7),-1)","v":70},{"$f":"ROUND((F10*Variables!$B$7),-1)","v":70},{"$f":"ROUND((G10*Variables!$B$7),-1)","v":80},{"$f":"ROUND((H10*Variables!$B$7),-1)","v":80},{"$f":"ROUND((I10*Variables!$B$7),-1)","v":90},{"$f":"ROUND((J10*Variables!$B$7),-1)","v":90},{"$f":"ROUND((K10*Variables!$B$7),-1)","v":100},{"$f":"ROUND((L10*Variables!$B$7),-1)","v":100}]
["Precio de Venta",null,{"$f":"Variables!D16","v":200000.00000000015},{"$f":"Variables!E16","v":200000.00000000015},{"$f":"Variables!F16","v":200000.00000000015},{"$f":"Variables!G16","v":200000.00000000015},{"$f":"Variables!H16","v":200000.00000000015},{"$f":"Variables!I16","v":200000.00000000015},{"$f":"Variables!J16","v":200000.00000000015},{"$f":"Variables!K16","v":200000.00000000015},{"$f":"Variables!L16","v":200000.00000000015},{"$f":"Variables!M16","v":200000.00000000015}]
["Subtotal ingresos por ventas 2",null,{"$f":"+C16*C17","v":14000000.000000009},14000000.000000009,14000000.000000009,14000000.000000009,16000000.000000011,16000000.000000011,18000000.000000015,{"$f":"+J16*J17","v":18000000.000000015},20000000.000000015,20000000.000000015]
["3. SEMINARIOS POR PATICIPANTE"]
["Unidades vendidas",null,{"$f":"ROUND((C10*Variables!$B$8),-2)","v":700},{"$f":"ROUND((D10*Variables!$B$8),-2)","v":700},{"$f":"ROUND((E10*Variables!$B$8),-2)","v":700},{"$f":"ROUND((F10*Variables!$B$8),-2)","v":700},{"$f":"ROUND((G10*Variables!$B$8),-2)","v":800},{"$f":"ROUND((H10*Variables!$B$8),-2)","v":800},{"$f":"ROUND((I10*Variables!$B$8),-2)","v":900},{"$f":"ROUND((J10*Variables!$B$8),-2)","v":900},{"$f":"ROUND((K10*Variables!$B$8),-2)","v":1000},{"$f":"ROUND((L10*Variables!$B$8),-2)","v":1000}]
["Precio de Venta",null,{"$f":"Variables!D17","v":30000.000000000018},{"$f":"Variables!E17","v":30000.000000000018},{"$f":"Variables!F17","v":30000.000000000018},{"$f":"Variables!G17","v":30000.000000000018},{"$f":"Variables!H17","v":30000.000000000018},{"$f":"Variables!I17","v":30000.000000000018},{"$f":"Variables!J17","v":30000.000000000018},{"$f":"Variables!K17","v":30000.000000000018},{"$f":"Variables!L17","v":30000.000000000018},{"$f":"Variables!M17","v":30000.000000000018}]
["Subtotal ingresos por ventas 3",null,{"$f":"+C20*C21","v":21000000.000000011},{"$f":"+D20*D21","v":21000000.000000011},21000000.000000011,21000000.000000011,24000000.000000015,24000000.000000015,27000000.000000015,{"$f":"+J20*J21","v":27000000.000000015},30000000.000000019,30000000.000000019]
["4. ASESORÍAS TÉCNICAS"]
["Unidades vendidas",null,{"$f":"ROUND((C10*Variables!$B$9),-1)","v":160},{"$f":"ROUND((D10*Variables!$B$9),-1)","v":170},{"$f":"ROUND((E10*Variables!$B$9),-1)","v":180},{"$f":"ROUND((F10*Variables!$B$9),-1)","v":180},{"$f":"ROUND((G10*Variables!$B$9),-1)","v":190},{"$f":"ROUND((H10*Variables!$B$9),-1)","v":200},{"$f":"ROUND((I10*Variables!$B$9),-1)","v":220},{"$f":"ROUND((J10*Variables!$B$9),-1)","v":230},{"$f":"ROUND((K10*Variables!$B$9),-1)","v":240},{"$f":"ROUND((L10*Variables!$B$9),-1)","v":250}]
["Precio de Venta",null,{"$f":"Variables!D18","v":450000.00000000029},{"$f":"Variables!E18","v":450000.00000000029},{"$f":"Variables!F18","v":450000.00000000029},{"$f":"Variables!G18","v":450000.00000000029},{"$f":"Variables!H18","v":450000.00000000029},{"$f":"Variables!I18","v":450000.00000000029},{"$f":"Variables!J18","v":450000.00000000029},{"$f":"Variables!K18","v":450000.00000000029},{"$f":"Variables!L18","v":450000.00000000029},{"$f":"Variables!M18","v":450000.00000000029}]
["Subtotal ingresos por ventas 4",null,{"$f":"+C24*C25","v":72000000.000000045},{"$f":"+D24*D25","v":76500000.000000045},81000000.00000006,81000000.00000006,85500000.00000006,90000000.00000006,99000000.00000006,{"$f":"+J24*J25","v":103500000.00000006},108000000.00000007,112500000.00000007]
["5. CURSOS INDIVIDUALES (ADOLESCENTES Y JÓVENES)"]
["Unidades vendidas",null,{"$f":"ROUND((C10*Variables!$B$10),-2)","v":2000},{"$f":"ROUND((D10*Variables!$B$10),-2)","v":2100},{"$f":"ROUND((E10*Variables!$B$10),-2)","v":2200},{"$f":"ROUND((F10*Variables!$B$10),-2)","v":2300},{"$f":"ROUND((G10*Variables!$B$10),-2)","v":2400},{"$f":"ROUND((H10*Variables!$B$10),-2)","v":2600},{"$f":"ROUND((I10*Variables!$B$10),-2)","v":2700},{"$f":"ROUND((J10*Variables!$B$10),-2)","v":2800},{"$f":"ROUND((K10*Variables!$B$10),-2)","v":3000},{"$f":"ROUND((L10*Variables!$B$10),-2)","v":3200}]
["Precio de Venta",null,{"$f":"Variables!D19","v":12000.000000000007},{"$f":"Variables!E19","v":12000.000000000007},{"$f":"Variables!F19","v":12000.000000000007},{"$f":"Variables!G19","v":12000.000000000007},{"$f":"Variables!H19","v":12000.000000000007},{"$f":"Variables!I19","v":12000.000000000007},{"$f":"Variables!J19","v":12000.000000000007},{"$f":"Variables!K19","v":12000.000000000007},{"$f":"Variables!L19","v":12000.000000000007},{"$f":"Variables!M19","v":12000.000000000007}]
["Subtotal ingresos por ventas 5",null,{"$f":"+C28*C29","v":24000000.000000015},{"$f":"+D28*D29","v":25200000.000000015},26400000.000000015,27600000.000000015,28800000.000000019,31200000.000000019,32400000.000000019,{"$f":"+J28*J29","v":33600000.000000022},36000000.000000022,38400000.000000022]
["6. CURSOS INDIVIDUALES (PADRES Y MADRES)"]
["Unidades vendidas",null,{"$f":"ROUND((C10*Variables!$B$11),-2)","v":700},{"$f":"ROUND((D10*Variables!$B$11),-2)","v":800},{"$f":"ROUND((E10*Variables!$B$11),-2)","v":800},{"$f":"ROUND((F10*Variables!$B$11),-2)","v":800},{"$f":"ROUND((G10*Variables!$B$11),-2)","v":900},{"$f":"ROUND((H10*Variables!$B$11),-2)","v":900},{"$f":"ROUND((I10*Variables!$B$11),-2)","v":1000},{"$f":"ROUND((J10*Variables!$B$11),-2)","v":1000},{"$f":"ROUND((K10*Variables!$B$11),-2)","v":1100},{"$f":"ROUND((L10*Variables!$B$11),-2)","v":1200}]
["Precio de Venta",null,{"$f":"Variables!D20","v":15000.000000000009},{"$f":"Variables!E20","v":15000.000000000009},{"$f":"Variables!F20","v":15000.000000000009},{"$f":"Variables!G20","v":15000.000000000009},{"$f":"Variables!H20","v":15000.000000000009},{"$f":"Variables!I20","v":15000.000000000009},{"$f":"Variables!J20","v":15000.000000000009},{"$f":"Variables!K20","v":15000.000000000009},{"$f":"Variables!L20","v":15000.000000000009},{"$f":"Variables!M20","v":15000.000000000009}]
["Subtotal ingresos por ventas 6",null,{"$f":"+C32*C33","v":10500000.000000006},{"$f":"+D32*D33","v":12000000.000000007},12000000.000000007,12000000.000000007,13500000.000000007,13500000.000000007,15000000.000000009,{"$f":"+J32*J33","v":15000000.000000009},16500000.000000009,18000000.000000011]
["7. CURSOS INDIVIDUALES (DOCENTES Y PROFESIONALES)"]
["Unidades vendidas",null,{"$f":"ROUND((C10*Variables!$B$12),-2)","v":700},{"$f":"ROUND((D10*Variables!$B$12),-2)","v":800},{"$f":"ROUND((E10*Variables!$B$12),-2)","v":800},{"$f":"ROUND((F10*Variables!$B$12),-2)","v":800},{"$f":"ROUND((G10*Variables!$B$12),-2)","v":900},{"$f":"ROUND((H10*Variables!$B$12),-2)","v":900},{"$f":"ROUND((I10*Variables!$B$12),-2)","v":1000},{"$f":"ROUND((J10*Variables!$B$12),-2)","v":1000},{"$f":"ROUND((K10*Variables!$B$12),-2)","v":1100},{"$f":"ROUND((L10*Variables!$B$12),-2)","v":1200}]
["Precio de Venta",null,{"$f":"Variables!D21","v":25000.000000000018},{"$f":"Variables!E21","v":25000.000000000018},{"$f":"Variables!F21","v":25000.000000000018},{"$f":"Variables!G21","v":25000.000000000018},{"$f":"Variables!H21","v":25000.000000000018},{"$f":"Variables!I21","v":25000.000000000018},{"$f":"Variables!J21","v":25000.000000000018},{"$f":"Variables!K21","v":25000.000000000018},{"$f":"Variables!L21","v":25000.000000000018},{"$f":"Variables!M21","v":25000.000000000018}]
["Subtotal ingresos por ventas 7",null,{"$f":"+C36*C37","v":17500000.000000011},{"$f":"+D36*D37","v":20000000.000000015},20000000.000000015,20000000.000000015,22500000.000000015,22500000.000000015,25000000.000000019,{"$f":"+J36*J37","v":25000000.000000019},27500000.000000019,30000000.000000022]
[]
["TOTAL UNIDADES DE PRODUCCIÓN",null,{"$f":"+C12+C16+C36+C20+C24+C28+C32","v":5030},{"$f":"+D12+D16+D36+D20+D24+D28+D32","v":5340},5450,5550,6070,6280,6810,{"$f":"+J12+J16+J36+J20+J24+J28+J32","v":6920},7540,7950]
["TOTAL INGRESOS POR VENTAS",null,{"$f":"+C14+C18+C38+C22+C26+C30+C34","v":173000000.00000012},{"$f":"+D14+D18+D38+D22+D26+D30+D34","v":182700000.00000012},188400000.00000012,189600000.00000012,206300000.00000015,213200000.00000015,234400000.00000015,{"$f":"+J14+J18+J38+J22+J26+J30+J34","v":240100000.00000015},258000000.00000015,268900000.00000018]
["TOTAL PRECIO PROMEDIO",null,{"$f":"ROUND((C41/C40),0)","v":34394},{"$f":"ROUND((D41/D40),0)","v":34213},34569,34162,33987,33949,34420,{"$f":"ROUND((J41/J40),0)","v":34697},34218,33824]
[]
[]
["Cuadro 12,10"]
["DEPRECIACIÓN DE INVERSIONES FIJAS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[null,null,null,null,null,null,null,null,null,null,null,null,"VALOR EN"]
["Año",{"$f":"+B8","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"LIBROS"]
[null,null,null,null,null,null,null,null,null,null,null,null,"EN EL"]
["Nivel de Producción",{"$f":"+B10","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,0.9,0.95,1,"AÑO 11"]
[]
["Edificios",null,{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0},{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0},{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0},{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0},{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0},{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0},{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0},{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0},{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0},{"$f":"IF(Variables!$B27=0,0,Variables!$C26/Variables!$B27)","v":0}]
[null,null,{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0},{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0},{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0},{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0},{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0},{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0},{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0},{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0},{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0},{"$f":"IF(Variables!$B28=0,0,Variables!$C27/Variables!$B28)","v":0}]
["Maquinaria y Equipos",null,{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"IF(Variables!$B29=0,0,Variables!$C28/Variables!$B29)","v":35000},{"$f":"Variables!C28-SUM(C57:L57)","v":0}]
[null,null,{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0},{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0},{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0},{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0},{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0},{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0},{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0},{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0},{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0},{"$f":"IF(Variables!$B30=0,0,Variables!$C29/Variables!$B30)","v":0}]
["Vehículos",null,{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0},{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0},{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0},{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0},{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0},{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0},{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0},{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0},{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0},{"$f":"IF(Variables!$B31=0,0,Variables!$C30/Variables!$B31)","v":0}]
[null,null,{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0},{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0},{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0},{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0},{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0},{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0},{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0},{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0},{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0},{"$f":"IF(Variables!$B32=0,0,Variables!$C31/Variables!$B32)","v":0}]
["Muebles y enseres ",null,{"$f":"IF(Variables!$B33=0,0,Variables!$C32/Variables!$B33)","v":3396600},{"$f":"IF(Variables!$B33=0,0,Variables!$C32/Variables!$B33)","v":3396600},{"$f":"IF(Variables!$B33=0,0,Variables!$C32/Variables!$B33)","v":3396600},{"$f":"IF(Variables!$B33=0,0,Variables!$C32/Variables!$B33)","v":3396600},{"$f":"IF(Variables!$B33=0,0,Variables!$C32/Variables!$B33)","v":3396600},{"$f":"IF(Variables!$B33=0,0,Variables!$C32/Variables!$B33)","v":3396600},0,0,0,0,{"$f":"Variables!C32-SUM(C61:L61)","v":-3396600}]
[null,null,{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0},{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0},{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0},{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0},{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0},{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0},{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0},{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0},{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0},{"$f":"IF(Variables!$B34=0,0,Variables!$C33/Variables!$B34)","v":0}]
["Herramientas",{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0},{"$f":"IF(Variables!$B35=0,0,Variables!$C34/Variables!$B35)","v":0}]
[]
["Total Depreciación",{"$f":"SUM(B55:B63)","v":0},{"$f":"SUM(C55:C63)","v":3431600},3431600,3431600,3431600,3431600,3431600,35000,{"$f":"SUM(J55:J63)","v":35000},35000,35000,{"$f":"SUM(M55:M63)","v":-3396600}]
[]
[]
[]
["Cuadro 12,11"]
["AMORTIZACIÓN DE DIFERIDOS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B51","v":2014},{"$f":"+C51","v":2015},2016,2017,2018,2019,2020,2021,{"$f":"+J51","v":2022},2023,2024]
[]
["Nivel de Producción",{"$f":"+B53","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,{"$f":"+J53","v":0.9},0.95,1]
[]
["Amortización de Diferidos",null,{"$f":"Variables!$C$38/Variables!$B$38","v":1122000},{"$f":"Variables!$C$38/Variables!$B$38","v":1122000},{"$f":"Variables!$C$38/Variables!$B$38","v":1122000},{"$f":"Variables!$C$38/Variables!$B$38","v":1122000},{"$f":"Variables!$C$38/Variables!$B$38","v":1122000}]
[]
[]
[]
["Cuadro 12,12"]
["COSTOS DE FINANCIACIÓN Y PAGO PRESTAMOS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},{"$f":"+C$51","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["Cuota fija",null,{"$f":"PMT(Variables!$B$53,Variables!$B$54,-Variables!$C$49)","v":3310741.6015507118},{"$f":"PMT(Variables!$B$53,Variables!$B$54,-Variables!$C$49)","v":3310741.6015507118},{"$f":"PMT(Variables!$B$53,Variables!$B$54,-Variables!$C$49)","v":3310741.6015507118},{"$f":"PMT(Variables!$B$53,Variables!$B$54,-Variables!$C$49)","v":3310741.6015507118},{"$f":"PMT(Variables!$B$53,Variables!$B$54,-Variables!$C$49)","v":3310741.6015507118},{"$f":"PMT(Variables!$B$53,Variables!$B$54,-Variables!$C$49)","v":3310741.6015507118}]
[]
["Costos de Financiación e Intereses",null,{"$f":"B99*Variables!$B$53","v":2400000},{"$f":"C99*Variables!$B$53","v":2181422.0156278294},{"$f":"D99*Variables!$B$53","v":1910385.3150063376},{"$f":"E99*Variables!$B$53","v":1574299.8062356878},{"$f":"F99*Variables!$B$53","v":1157553.7753600818},{"$f":"G99*Variables!$B$53","v":640788.69707433076}]
[]
["Pago de Prestamos",null,{"$f":"C93-C95","v":910741.60155071178},1129319.5859228824,1400356.2865443742,1736441.795315024,2153187.82619063,2669952.9044763809]
[]
["Saldo de la deuda",{"$f":"Variables!C49","v":10000000},{"$f":"+B99-C97","v":9089258.3984492887},7959938.8125264067,6559582.5259820325,4823140.7306670081,2669952.9044763781,0]
[]
[]
[]
["Cuadro 12,13"]
["COSTOS DE MATERIA PRIMA DE LAS UNIDADES VENDIDAS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},{"$f":"+C$51","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["Unidades Producidas (Miles)",null,{"$f":"C40","v":5030},5340,5450,5550,6070,6280,6810,6920,7540,7950]
[]
["Costos Unitario (Unidades Monetarias)",null,{"$f":"C118/C113","v":13359.840954274354},13213.483146067416,13594.128440366972,14016.648648648648,13456.675453047776,13657.025636942677,13223.85125550661,{"$f":"J118/J113","v":13664.327803829483},13167.772655520561,13113.113976573117]
[]
[]
["Total Costos Materia Prima (Millones)",null,{"$f":"'Ppto MP'!F39","v":67200000},{"$f":"'Ppto MP'!I39","v":70560000},{"$f":"'Ppto MP'!L39","v":74088000},{"$f":"'Ppto MP'!O39","v":77792400},{"$f":"'Ppto MP'!R39","v":81682020},{"$f":"'Ppto MP'!U39","v":85766121.000000015},{"$f":"'Ppto MP'!X39","v":90054427.050000012},{"$f":"'Ppto MP'!AA39","v":94557148.402500018},{"$f":"'Ppto MP'!AD39","v":99285005.822625026},{"$f":"'Ppto MP'!AG39","v":104249256.11375628}]
[]
[]
[]
["Cuadro 9.1"]
["COSTO DE LA MANO DE OBRA DE LAS UNIDADES VENDIDAS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},{"$f":"+C$51","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},{"$f":"+C$53","v":0.65},{"$f":"+D$53","v":0.67},0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["Unidades Producidas (Miles)",null,{"$f":"C113","v":5030},5340,5450,5550,6070,6280,6810,{"$f":"J113","v":6920},7540,7950]
[]
["Costos Unitario (Unidades Monetarias)",null,{"$f":"C137/C132","v":6400.2689463220668},6028.7177528089878,5907.0372110091739,5800.6041081081075,5303.6825041186157,5126.3300636942668,4727.3645814977972,{"$f":"J137/J132","v":4652.2186127167624},4269.6754376657818,4049.4783396226412]
[]
[]
["Total Costos Mano de Obra (Millones)",null,{"$f":"Inversiones!$N$94","v":32193352.799999997},{"$f":"Inversiones!$N$94","v":32193352.799999997},{"$f":"Inversiones!$N$94","v":32193352.799999997},{"$f":"Inversiones!$N$94","v":32193352.799999997},{"$f":"Inversiones!$N$94","v":32193352.799999997},{"$f":"Inversiones!$N$94","v":32193352.799999997},{"$f":"Inversiones!$N$94","v":32193352.799999997},{"$f":"Inversiones!$N$94","v":32193352.799999997},{"$f":"Inversiones!$N$94","v":32193352.799999997},{"$f":"Inversiones!$N$94","v":32193352.799999997}]
[]
[]
[]
["Cuadro 12,15"]
["GASTOS GENERALES DE FABRICACIÓN DE LAS UNIDADES VENDIDAS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},{"$f":"+C$51","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},{"$f":"+C$53","v":0.65},{"$f":"+D$53","v":0.67},0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["Unidades Producidas (Miles)",null,{"$f":"C132","v":5030},{"$f":"D132","v":5340},{"$f":"E132","v":5450},{"$f":"F132","v":5550},{"$f":"G132","v":6070},{"$f":"H132","v":6280},6810,6920,7540,7950]
[]
["Costos Unitario (Unidades Monetarias)",null,{"$f":"C156/C151","v":0},{"$f":"D156/D151","v":0},{"$f":"E156/E151","v":0},{"$f":"F156/F151","v":0},{"$f":"G156/G151","v":0},{"$f":"H156/H151","v":0},0,0,0,0]
[]
[]
["Total Gasto generales de fabricacion (Millones)",null,{"$f":"Inversiones!B200","v":0},{"$f":"Inversiones!C200","v":0},{"$f":"Inversiones!D200","v":0},{"$f":"Inversiones!E200","v":0},{"$f":"Inversiones!F200","v":0},{"$f":"Inversiones!G200","v":0},{"$f":"Inversiones!H200","v":0},{"$f":"Inversiones!I200","v":0},{"$f":"Inversiones!J200","v":0},{"$f":"Inversiones!K200","v":0}]
[]
[]
[]
[]
["Cuadro 9.2"]
["COSTOS DE OPERACIÓN Y FINANCIACIÓN"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},{"$f":"+C$51","v":2015},2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},{"$f":"+C$53","v":0.65},{"$f":"+D$53","v":0.67},0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["Materiales e Insumos",null,{"$f":"C118","v":67200000},70560000,74088000,77792400,81682020,85766121.000000015,90054427.050000012,{"$f":"J118","v":94557148.402500018},99285005.822625026,104249256.11375628]
[]
["Mano de Obra Directa",null,{"$f":"C137","v":32193352.799999997},32193352.799999997,32193352.799999997,32193352.799999997,32193352.799999997,32193352.799999997,32193352.799999997,{"$f":"J137","v":32193352.799999997},32193352.799999997,32193352.799999997]
[]
["Gastos Generales de Fabricación",null,{"$f":"C156","v":0},0,0,0,0,0,0,{"$f":"J156","v":0},0,0]
[]
["Depreciación",null,{"$f":"C65","v":3431600},3431600,3431600,3431600,3431600,3431600,35000,{"$f":"J65","v":35000},35000,35000]
[]
[]
["1. COSTOS DE VENTAS",null,{"$f":"SUM(C171:C177)","v":102824952.8},{"$f":"SUM(D171:D177)","v":106184952.8},{"$f":"SUM(E171:E177)","v":109712952.8},113417352.8,117306972.8,121391073.80000001,122282779.85000001,{"$f":"SUM(J171:J177)","v":126785501.20250002},131513358.62262502,136477608.91375628]
[]
[]
["Gastos Generales de Administración",null,{"$f":"Inversiones!B184","v":49703352.799999997},{"$f":"Inversiones!C184","v":49703352.799999997},{"$f":"Inversiones!D184","v":49703352.799999997},{"$f":"Inversiones!E184","v":49703352.799999997},{"$f":"Inversiones!F184","v":49703352.799999997},{"$f":"Inversiones!G184","v":49703353.799999997},{"$f":"Inversiones!H184","v":49703354.799999997},{"$f":"Inversiones!I184","v":49703354.799999997},{"$f":"Inversiones!J184","v":49703354.799999997},{"$f":"Inversiones!K184","v":49703354.799999997}]
[]
["Gastos Generales de Ventas",null,{"$f":"Inversiones!B190","v":6520000},{"$f":"Inversiones!C190","v":6520000},{"$f":"Inversiones!D190","v":6520000},{"$f":"Inversiones!E190","v":6520000},{"$f":"Inversiones!F190","v":6520000},{"$f":"Inversiones!G190","v":6520000},{"$f":"Inversiones!H190","v":6520000},{"$f":"Inversiones!I190","v":6520000},{"$f":"Inversiones!J190","v":6520000},{"$f":"Inversiones!K190","v":6520000}]
[]
["Gastos Generales de Distribución",null,{"$f":"Inversiones!B192","v":4800000},{"$f":"Inversiones!C192","v":4800000},{"$f":"Inversiones!D192","v":4800000},{"$f":"Inversiones!E192","v":4800000},{"$f":"Inversiones!F192","v":4800000},{"$f":"Inversiones!G192","v":4800000},{"$f":"Inversiones!H192","v":4800000},{"$f":"Inversiones!I192","v":4800000},{"$f":"Inversiones!J192","v":4800000},{"$f":"Inversiones!K192","v":4800000}]
[]
["Amortización de Diferidos",null,{"$f":"C79","v":1122000},1122000,1122000,1122000,1122000,0,0,0,0,0]
[]
[]
["2. GASTOS OPERATIVOS",null,{"$f":"SUM(C183:C189)","v":62145352.799999997},{"$f":"SUM(D183:D189)","v":62145352.799999997},62145352.799999997,62145352.799999997,62145352.799999997,61023353.799999997,61023354.799999997,{"$f":"SUM(J183:J189)","v":61023354.799999997},61023354.799999997,61023354.799999997]
[]
[]
["COSTOS DE OPERACIÓN (1+2)",null,{"$f":"+C180+C192","v":164970305.59999999},168330305.59999999,171858305.59999999,175562705.59999999,179452325.59999999,182414427.60000002,183306134.65000001,{"$f":"+J180+J192","v":187808856.0025},192536713.42262501,197500963.71375626]
[]
["COSTOS DE FINANCIACIÓN (Intereses)",null,{"$f":"C95","v":2400000},2181422.0156278294,1910385.3150063376,1574299.8062356878,1157553.7753600818,640788.69707433076,0,{"$f":"J95","v":0},0,0]
[]
[]
["TOTAL COSTOS DE OPERACIÓN"]
["Y FINANCIACIÓN",null,{"$f":"+C195+C197","v":167370305.59999999},{"$f":"+D195+D197","v":170511727.61562783},173768690.91500634,177137005.40623569,180609879.37536007,183055216.29707435,183306134.65000001,{"$f":"+J195+J197","v":187808856.0025},192536713.42262501,197500963.71375626]
[]
[]
[]
["Cuadro 8.1"]
["CAPITAL DE TRABAJO - SALDO DE EFECTIVO REQUERIDO EN CAJA"]
["(Millones del año 2014)"]
[null,"Días de","Coeficiente de"]
[null,"Cobertura","Renovación","Año"]
[]
[null,null,null,{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,{"$f":"+J$51","v":2022},{"$f":"+K$51","v":2023},{"$f":"+L$51","v":2024}]
[]
[]
["Materiales e Insumos",{"$f":"Variables!B58","v":10},{"$f":"IF(B214=0,0,(360/B214))","v":36},null,{"$f":"IF($C$214=0,0,C$171/$C$214)","v":1866666.6666666667},1960000,2058000,2160900,2268945,2382392.2500000005,2501511.8625000003,{"$f":"IF($C$214=0,0,J$171/$C$214)","v":2626587.4556250004},{"$f":"IF($C$214=0,0,K$171/$C$214)","v":2757916.8284062506},{"$f":"IF($C$214=0,0,L$171/$C$214)","v":2895812.6698265634}]
[]
["Mano de Obra Directa",{"$f":"+Variables!B59","v":10},{"$f":"IF(B216=0,0,(360/B216))","v":36},null,{"$f":"IF($C$216=0,0,C$173/$C$216)","v":894259.79999999993},894259.79999999993,894259.79999999993,894259.79999999993,894259.79999999993,894259.79999999993,894259.79999999993,{"$f":"IF($C$216=0,0,J$173/$C$216)","v":894259.79999999993},{"$f":"IF($C$216=0,0,K$173/$C$216)","v":894259.79999999993},{"$f":"IF($C$216=0,0,L$173/$C$216)","v":894259.79999999993}]
[]
["Gastos Generales de Fabricación",{"$f":"+Variables!B60","v":10},{"$f":"IF(B218=0,0,(360/B218))","v":36},null,{"$f":"IF($C$218=0,0,C$175/$C$218)","v":0},0,0,0,0,0,0,{"$f":"IF($C$218=0,0,J$175/$C$218)","v":0},{"$f":"IF($C$218=0,0,K$175/$C$218)","v":0},{"$f":"IF($C$218=0,0,L$175/$C$218)","v":0}]
[]
["Gastos Generales de Administración",{"$f":"+Variables!B61","v":10},{"$f":"IF(B220=0,0,(360/B220))","v":36},null,{"$f":"IF($C$220=0,0,C$183/$C$220)","v":1380648.6888888888},1380648.6888888888,1380648.6888888888,1380648.6888888888,1380648.6888888888,1380648.7166666666,1380648.7444444443,{"$f":"IF($C$220=0,0,J$183/$C$220)","v":1380648.7444444443},{"$f":"IF($C$220=0,0,K$183/$C$220)","v":1380648.7444444443},{"$f":"IF($C$220=0,0,L$183/$C$220)","v":1380648.7444444443}]
[]
["Gastos Generales de Ventas",{"$f":"+Variables!B62","v":10},{"$f":"IF(B222=0,0,(360/B222))","v":36},null,{"$f":"IF($C$222=0,0,C$185/$C$222)","v":181111.11111111112},181111.11111111112,181111.11111111112,181111.11111111112,181111.11111111112,181111.11111111112,181111.11111111112,{"$f":"IF($C$222=0,0,J$185/$C$222)","v":181111.11111111112},{"$f":"IF($C$222=0,0,K$185/$C$222)","v":181111.11111111112},{"$f":"IF($C$222=0,0,L$185/$C$222)","v":181111.11111111112}]
[]
["Gastos Generales de Distribución",{"$f":"+Variables!B63","v":10},{"$f":"IF(B224=0,0,(360/B224))","v":36},null,{"$f":"IF($C$224=0,0,C$187/$C$224)","v":133333.33333333334},133333.33333333334,133333.33333333334,133333.33333333334,133333.33333333334,133333.33333333334,133333.33333333334,{"$f":"IF($C$224=0,0,J$187/$C$224)","v":133333.33333333334},{"$f":"IF($C$224=0,0,K$187/$C$224)","v":133333.33333333334},{"$f":"IF($C$224=0,0,L$187/$C$224)","v":133333.33333333334}]
[]
[]
["Saldo de Efectivo Requerido en Caja",null,null,null,{"$f":"SUM(E214:E224)","v":4456019.5999999996},{"$f":"SUM(F214:F224)","v":4549352.9333333327},4647352.9333333327,4750252.9333333327,4858297.9333333327,4971745.2111111106,5090864.8513888884,{"$f":"SUM(L214:L224)","v":5215940.444513889},5347269.8172951387,5485165.6587154511]
[]
[]
[]
[]
[]
["Cuadro 8.2"]
["CALCULO DEL CAPITAL DE TRABAJO"]
["(Millones del año 2014)"]
[null,"Días de","Coeficiente de"]
[null,"Cobertura","Renovación","Año"]
[]
[null,null,null,{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,{"$f":"+J$51","v":2022},{"$f":"+K$51","v":2023},{"$f":"+L$51","v":2024}]
[]
[]
["Activo Corriente"]
[]
["1. Saldo de Efectivo",null,null,null,{"$f":"E227","v":4456019.5999999996},4549352.9333333327,4647352.9333333327,4750252.9333333327,4858297.9333333327,4971745.2111111106,5090864.8513888884,{"$f":"L227","v":5215940.444513889},5347269.8172951387,5485165.6587154511]
["    Requerido en Caja"]
["2. Cuentas por Cobrar",{"$f":"+Variables!B64","v":30},{"$f":"IF(B246=0,0,(360/B246))","v":12},null,{"$f":"IF($C$246=0,0,C$195/$C$246)","v":13747525.466666667},14027525.466666667,14321525.466666667,14630225.466666667,14954360.466666667,15201202.300000003,15275511.220833333,{"$f":"IF($C$246=0,0,J$195/$C$246)","v":15650738.000208333},{"$f":"IF($C$246=0,0,K$195/$C$246)","v":16044726.118552083},{"$f":"IF($C$246=0,0,L$195/$C$246)","v":16458413.642813021}]
["3. Existencias o Inventarios"]
["    Materiales e Insumos",{"$f":"+Variables!B66","v":30},{"$f":"IF(B248=0,0,(360/B248))","v":12},null,{"$f":"IF($C$248=0,0,C$171/$C$248)","v":5600000},5880000,6174000,6482700,6806835,7147176.7500000009,7504535.5875000013,{"$f":"IF($C$248=0,0,J$171/$C$248)","v":7879762.3668750012},{"$f":"IF($C$248=0,0,K$171/$C$248)","v":8273750.4852187522},{"$f":"IF($C$248=0,0,L$171/$C$248)","v":8687438.0094796903}]
["    Productos en Proceso",{"$f":"Variables!B67","v":0},{"$f":"IF(B249=0,0,(360/B249))","v":0},null,{"$f":"IF($C$249=0,0,C$180/$C$249)","v":0},0,0,0,0,0,0,{"$f":"IF($C$249=0,0,J$180/$C$249)","v":0},{"$f":"IF($C$249=0,0,K$180/$C$249)","v":0},{"$f":"IF($C$249=0,0,L$180/$C$249)","v":0}]
["    Productos Terminados",{"$f":"Variables!B68","v":0},{"$f":"IF(B250=0,0,(360/B250))","v":0},null,{"$f":"IF($C$250=0,0,(C$180+C$183)/$C$250)","v":0},0,0,0,0,0,0,{"$f":"IF($C$250=0,0,(J$180+J$183)/$C$250)","v":0},{"$f":"IF($C$250=0,0,(K$180+K$183)/$C$250)","v":0},{"$f":"IF($C$250=0,0,(L$180+L$183)/$C$250)","v":0}]
[]
["Total Activo Corriente",null,null,null,{"$f":"+SUM(E244:E250)","v":23803545.066666666},{"$f":"+SUM(F244:F250)","v":24456878.399999999},25142878.399999999,25863178.399999999,26619493.399999999,27320124.261111114,27870911.659722224,{"$f":"+SUM(L244:L250)","v":28746440.811597221},29665746.421065975,30631017.311008163]
[]
["Incremento del Activo Corriente",null,null,null,{"$f":"+E252","v":23803545.066666666},{"$f":"F252-E254","v":653333.33333333209},{"$f":"+G252-F252","v":686000},{"$f":"+H252-G252","v":720300},{"$f":"+I252-H252","v":756315},{"$f":"+J252-I252","v":700630.86111111566},{"$f":"+K252-J252","v":550787.3986111097},{"$f":"+L252-K252","v":875529.15187499672},919305.60946875438,965270.88994218782]
[]
[]
["Pasivo Corriente"]
[]
["1. Cuentas por Pagar"]
["    Materiales e Insumos",{"$f":"+Variables!B71","v":60},{"$f":"IF(B260=0,0,(360/B260))","v":6},null,{"$f":"IF($C$260=0,0,C$171/$C$260)","v":11200000},11760000,12348000,12965400,13613670,{"$f":"IF($C$260=0,0,H$171/$C$260)","v":14294353.500000002},{"$f":"IF($C$260=0,0,I$171/$C$260)","v":15009071.175000003},{"$f":"IF($C$260=0,0,J$171/$C$260)","v":15759524.733750002},{"$f":"IF($C$260=0,0,K$171/$C$260)","v":16547500.970437504},{"$f":"IF($C$260=0,0,L$171/$C$260)","v":17374876.018959381}]
["    Mano de Obra Directa",{"$f":"+Variables!B72","v":0},0,null,{"$f":"IF($C$261=0,0,C$173/$C$261)","v":0},0,0,0,0,0,0,{"$f":"IF($C$261=0,0,J$173/$C$261)","v":0},{"$f":"IF($C$261=0,0,K$173/$C$261)","v":0},{"$f":"IF($C$261=0,0,L$173/$C$261)","v":0}]
["    Gastos Generales de Fabricación",{"$f":"+Variables!B73","v":0},0,null,{"$f":"IF($C$262=0,0,C$175/$C$262)","v":0},{"$f":"IF($C$262=0,0,D$175/$C$262)","v":0},0,0,0,0,0,{"$f":"IF($C$262=0,0,J$175/$C$262)","v":0},{"$f":"IF($C$262=0,0,K$175/$C$262)","v":0},{"$f":"IF($C$262=0,0,L$175/$C$262)","v":0}]
["    Gastos Generales de Administración",{"$f":"+Variables!B74","v":0},0,null,{"$f":"IF(C263=0,0,C183/C263)","v":0},{"$f":"IF(D263=0,0,D183/D263)","v":0},0,0,0,0,0,{"$f":"IF(J263=0,0,J183/J263)","v":0},{"$f":"IF(K263=0,0,K183/K263)","v":0},{"$f":"IF(L263=0,0,L183/L263)","v":0}]
["    Gastos Generales de Ventas",{"$f":"+Variables!B75","v":0},0,null,{"$f":"IF(C264=0,0,C185/C264)","v":0},{"$f":"IF(D264=0,0,D185/D264)","v":0},0,0,0,0,0,{"$f":"IF(J264=0,0,J185/J264)","v":0},{"$f":"IF(K264=0,0,K185/K264)","v":0},{"$f":"IF(L264=0,0,L185/L264)","v":0}]
["    Gastos Generales de Distribución",{"$f":"+Variables!B76","v":0},0,null,{"$f":"IF(C265=0,0,C187/C265)","v":0},{"$f":"IF(D265=0,0,D187/D265)","v":0},0,0,0,0,0,{"$f":"IF(J265=0,0,J187/J265)","v":0},{"$f":"IF(K265=0,0,K187/K265)","v":0},{"$f":"IF(L265=0,0,L187/L265)","v":0}]
[]
["Total Pasivo Corriente",null,null,null,{"$f":"SUM(E260:E265)","v":11200000},11760000,12348000,12965400,13613670,14294353.500000002,15009071.175000003,{"$f":"SUM(L260:L265)","v":15759524.733750002},16547500.970437504,17374876.018959381]
[]
["Incremento del Pasivo Corriente",null,null,null,{"$f":"+E267","v":11200000},{"$f":"+F267","v":11760000},{"$f":"+G267-F267","v":588000},{"$f":"+H267-G267","v":617400},{"$f":"+I267-H267","v":648270},{"$f":"+J267-I267","v":680683.50000000186},{"$f":"+K267-J267","v":714717.67500000075},{"$f":"+L267-K267","v":750453.55874999985},787976.23668750189,827375.04852187634]
[]
["CAPITAL DE TRABAJO"]
["(Activo Corriente menos Pasivo Corriente)",null,null,null,{"$f":"+E252-E267","v":12603545.066666666},{"$f":"+F252-F267","v":12696878.399999999},12794878.399999999,12897778.399999999,13005823.399999999,13025770.761111112,12861840.484722221,{"$f":"+L252-L267","v":12986916.077847218},13118245.450628471,13256141.292048782]
[]
["Incremento del Capital de Trabajo",null,null,null,{"$f":"+E272","v":12603545.066666666},{"$f":"+F272-E272","v":93333.333333332092},98000,102900,108045,{"$f":"+J272-I272","v":19947.361111113802},{"$f":"+K272-J272","v":-163930.27638889104},{"$f":"+L272-K272","v":125075.59312499687},{"$f":"+M272-L272","v":131329.37278125249},{"$f":"+N272-M272","v":137895.84142031148}]
[]
[]
[]
["Cuadro 8.4"]
["INVERSIONES EN EL PROYECTO"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["1. Inversiones Fijas"]
["    (Iniciales y Reposiciones)"]
["    Terrenos",{"$f":"+Variables!C25","v":0}]
["    Edificios",{"$f":"+Variables!C26","v":0}]
["    Maquinaria y Equipos",{"$f":"Variables!C28","v":350000}]
["    Vehículos",{"$f":"Variables!C30","v":0},null,null,null,null,null,null,{"$f":"+Variables!J30","v":0},{"$f":"+Variables!K30","v":0},{"$f":"+Variables!L30","v":0},{"$f":"+Variables!M30","v":0}]
["    Muebles y Enseres",{"$f":"Variables!C32","v":16983000}]
["    Herramientas",{"$f":"Variables!C34","v":0}]
[]
[]
["    Total Inversiones",{"$f":"SUM(B290:B297)","v":17333000},null,null,null,null,null,null,{"$f":"SUM(I290:I297)","v":0},{"$f":"SUM(J290:J297)","v":0},0,0]
[]
["2. Gastos Preoperativos",{"$f":"Variables!C38","v":5610000}]
[]
["3. Incremento del"]
["    Capital de Trabajo",{"$f":"+D274","v":0},12603545.066666666,93333.333333332092,98000,102900,108045,19947.361111113802,-163930.27638889104,{"$f":"+L274","v":125075.59312499687},{"$f":"+M274","v":131329.37278125249},{"$f":"+N274","v":137895.84142031148}]
[]
[]
["TOTAL INVERSIONES",{"$f":"+B298+B300+B303","v":22943000},{"$f":"+C298+C300+C303","v":12603545.066666666},{"$f":"+D298+D300+D303","v":93333.333333332092},98000,102900,108045,19947.361111113802,-163930.27638889104,{"$f":"+J298+J300+J303","v":125075.59312499687},131329.37278125249,137895.84142031148]
[]
[]
[]
["Cuadro 11.1"]
["ESTADO DE GANANCIAS Y PERDIDAS O ESTADO DE RESULTADOS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión"," ","Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["Ingresos por Concepto de Ventas",{"$f":"+$B$40","v":0},{"$f":"C41","v":173000000.00000012},182700000.00000012,188400000.00000012,189600000.00000012,206300000.00000015,213200000.00000015,234400000.00000015,240100000.00000015,258000000.00000015,268900000.00000018]
["Mas Otros Ingresos",0,0,0,0,0,0,0,0,0,0,0]
["Menos Costos de Operación"]
["y de Financiación",{"$f":"+B$201","v":0},{"$f":"C$201","v":167370305.59999999},170511727.61562783,173768690.91500634,177137005.40623569,180609879.37536007,183055216.29707435,183306134.65000001,187808856.0025,192536713.42262501,197500963.71375626]
["Menos Otros Egresos",0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["Utilidad Antes de Impuestos",{"$f":"+B320+B321-B323-B324","v":0},{"$f":"+C320+C321-C323-C324","v":5629694.4000001252},{"$f":"+D320+D321-D323-D324","v":12188272.384372294},14631309.08499378,12462994.593764424,25690120.624640077,30144783.702925801,51093865.350000143,{"$f":"+J320+J321-J323-J324","v":52291143.997500151},65463286.577375144,71399036.286243916]
[]
["Menos Impuestos (30%)",{"$f":"+B327*Variables!$B$47","v":0},{"$f":"IF(C327<0,0,C327*Variables!B47)","v":1688908.3200000376},{"$f":"+D327*Variables!$B$47","v":3656481.7153116879},{"$f":"+E327*Variables!$B$47","v":4389392.7254981333},{"$f":"+F327*Variables!$B$47","v":3738898.3781293272},{"$f":"+G327*Variables!$B$47","v":7707036.1873920225},{"$f":"+H327*Variables!$B$47","v":9043435.1108777393},{"$f":"+I327*Variables!$B$47","v":15328159.605000041},{"$f":"+J327*Variables!$B$47","v":15687343.199250044},{"$f":"+K327*Variables!$B$47","v":19638985.973212544},{"$f":"+L327*Variables!$B$47","v":21419710.885873172}]
[]
[]
["Utilidad Neta",{"$f":"+B327-B329","v":0},{"$f":"+C327-C329","v":3940786.0800000876},{"$f":"+D327-D329","v":8531790.6690606065},10241916.359495647,8724096.2156350967,17983084.437248055,21101348.592048064,35765705.745000102,{"$f":"+J327-J329","v":36603800.798250109},45824300.604162604,49979325.400370747]
[]
["Menos Dividendos",{"$f":"+B332*Variables!$B$48","v":0},{"$f":"+C332*Variables!$B$48","v":0},{"$f":"+D332*Variables!$B$48","v":0},{"$f":"+E332*Variables!$B$48","v":0},{"$f":"+F332*Variables!$B$48","v":0},{"$f":"+G332*Variables!$B$48","v":0},{"$f":"+H332*Variables!$B$48","v":0},{"$f":"+I332*Variables!$B$48","v":0},{"$f":"+J332*Variables!$B$48","v":0},{"$f":"+K332*Variables!$B$48","v":0},{"$f":"+L332*Variables!$B$48","v":0}]
[]
[]
[]
["Utilidades no Repartidas",{"$f":"+B332-B334","v":0},{"$f":"+C332-C334","v":3940786.0800000876},{"$f":"+D332-D334","v":8531790.6690606065},10241916.359495647,8724096.2156350967,17983084.437248055,21101348.592048064,35765705.745000102,{"$f":"+J332-J334","v":36603800.798250109},45824300.604162604,49979325.400370747]
[]
["Acumuladas (Reservas)",{"$f":"+B338","v":0},{"$f":"+B340+C338","v":3940786.0800000876},{"$f":"+C340+D338","v":12472576.749060694},22714493.108556341,31438589.324191436,49421673.761439487,70523022.353487551,106288728.09848765,{"$f":"+I340+J338","v":142892528.89673775},{"$f":"+J340+K338","v":188716829.50090036},{"$f":"+K340+L338","v":238696154.9012711}]
[]
[]
[]
["Cuadro 12,21"]
["ESTADO DE GANANCIAS Y PERDIDAS O ESTADO DE RESULTADOS"]
["(En la forma que lo exige la banca comercial)"]
["(Millones del año 2014)"]
[]
["Fase","Inversión"," ","Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["Ingresos por Concepto de Ventas",{"$f":"+$B$40","v":0},{"$f":"C41","v":173000000.00000012},182700000.00000012,188400000.00000012,189600000.00000012,206300000.00000015,213200000.00000015,234400000.00000015,240100000.00000015,258000000.00000015,268900000.00000018]
["Menos Costos de Ventas",{"$f":"+$B$180","v":0},{"$f":"+C$180","v":102824952.8},106184952.8,109712952.8,113417352.8,117306972.8,121391073.80000001,122282779.85000001,126785501.20250002,131513358.62262502,136477608.91375628]
[]
["Utilidad Bruta en Ventas",{"$f":"+B355-B356","v":0},70175047.200000122,76515047.200000122,78687047.200000122,76182647.200000122,88993027.200000152,91808926.200000137,112117220.15000014,{"$f":"+J355-J356","v":113314498.79750013},126486641.37737513,132422391.0862439]
["Menos Gastos Operativos",{"$f":"+B192","v":0},62145352.799999997,62145352.799999997,62145352.799999997,62145352.799999997,62145352.799999997,61023353.799999997,61023354.799999997,{"$f":"+J192","v":61023354.799999997},61023354.799999997,61023354.799999997]
[]
[]
["Utilidad Operativa",{"$f":"+B358-B359","v":0},8029694.4000001252,14369694.400000125,16541694.400000125,14037294.400000125,26847674.400000155,30785572.40000014,51093865.350000143,{"$f":"+J358-J359","v":52291143.997500136},65463286.577375129,71399036.286243901]
[]
["Mas Otros Ingresos",{"$f":"+B321","v":0},0,0,0,0,0,0,0,{"$f":"+J321","v":0},0,0]
["Menos Otros Egresos",{"$f":"+B324","v":0},0,0,0,0,0,0,0,{"$f":"+J324","v":0},0,0]
["Menos Costos de Financiación",{"$f":"+B197","v":0},2400000,2181422.0156278294,1910385.3150063376,1574299.8062356878,1157553.7753600818,640788.69707433076,0,{"$f":"+J197","v":0},0,0]
[]
[]
["Utilidad Antes de Impuestos",{"$f":"+B362+B364-B365-B366","v":0},5629694.4000001252,12188272.384372296,14631309.084993787,12462994.593764437,25690120.624640074,30144783.702925809,51093865.350000143,{"$f":"+J362+J364-J365-J366","v":52291143.997500136},65463286.577375129,71399036.286243901]
[]
["Menos Impuestos (30%)",{"$f":"+B369*Variables!$B$47","v":0},{"$f":"IF(C369<0,0,C369*Variables!$B$47)","v":1688908.3200000376},{"$f":"+D369*Variables!$B$47","v":3656481.7153116888},{"$f":"+E369*Variables!$B$47","v":4389392.7254981361},{"$f":"+F369*Variables!$B$47","v":3738898.3781293309},{"$f":"+G369*Variables!$B$47","v":7707036.1873920215},{"$f":"+H369*Variables!$B$47","v":9043435.110877743},{"$f":"+I369*Variables!$B$47","v":15328159.605000041},{"$f":"+J369*Variables!$B$47","v":15687343.199250041},{"$f":"+K369*Variables!$B$47","v":19638985.973212536},{"$f":"+L369*Variables!$B$47","v":21419710.885873169}]
[]
[]
["Utilidad Neta",{"$f":"+B369-B371","v":0},3940786.0800000876,8531790.6690606065,10241916.359495651,8724096.215635106,17983084.437248051,21101348.592048064,35765705.745000102,{"$f":"+J369-J371","v":36603800.798250094},45824300.604162589,49979325.400370732]
[]
["Menos Dividendos",{"$f":"+B374*Variables!$B$48","v":0},{"$f":"+C374*Variables!$B$48","v":0},{"$f":"+D374*Variables!$B$48","v":0},{"$f":"+E374*Variables!$B$48","v":0},{"$f":"+F374*Variables!$B$48","v":0},{"$f":"+G374*Variables!$B$48","v":0},{"$f":"+H374*Variables!$B$48","v":0},{"$f":"+I374*Variables!$B$48","v":0},{"$f":"+J374*Variables!$B$48","v":0},{"$f":"+K374*Variables!$B$48","v":0},{"$f":"+L374*Variables!$B$48","v":0}]
[]
[]
[]
["Utilidades no Repartidas",{"$f":"+B374-B376","v":0},3940786.0800000876,8531790.6690606065,10241916.359495651,8724096.215635106,17983084.437248051,21101348.592048064,35765705.745000102,{"$f":"+J374-J376","v":36603800.798250094},45824300.604162589,49979325.400370732]
[]
["Acumuladas (Reservas)",{"$f":"+B380","v":0},{"$f":"+B382+C380","v":3940786.0800000876},{"$f":"+D380+C382","v":12472576.749060694},22714493.108556345,31438589.324191451,49421673.761439502,70523022.353487566,106288728.09848768,{"$f":"+J380+I382","v":142892528.89673775},{"$f":"+K380+J382","v":188716829.50090033},{"$f":"+L380+K382","v":238696154.90127105}]
[]
[]
[]
["Cuadro 10.1"]
["ACTIVOS TOTALES"]
["(Millones del año 2014)"]
[]
["Fase","Inversión"," ","Operacional"]
[null,null," "]
["Año",{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["Inversiones Fijas"]
["(Iniciales y Reposición)",{"$f":"+B298","v":17333000},{"$f":"+C298","v":0}]
["Gastos Preoperativos",{"$f":"+B300","v":5610000},{"$f":"+C300","v":0}]
[]
["Incremento del Activo"]
["Corriente",{"$f":"+D254","v":0},23803545.066666666,653333.33333333209,686000,720300,756315,700630.86111111566,550787.3986111097,{"$f":"+L254","v":875529.15187499672},{"$f":"+M254","v":919305.60946875438},{"$f":"+N254","v":965270.88994218782}]
[]
[]
["TOTAL ACTIVOS FIJOS",{"$f":"+B397+B398+B401","v":22943000},{"$f":"+C397+C398+C401","v":23803545.066666666},{"$f":"+D397+D398+D401","v":653333.33333333209},686000,720300,756315,700630.86111111566,550787.3986111097,{"$f":"+J397+J398+J401","v":875529.15187499672},919305.60946875438,965270.88994218782]
[]
[]
[]
["Cuadro 10.2"]
["RECURSOS FINANCIEROS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión"," ","Operacional"]
[null,null," "]
["Año",{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["Aportes de Capital o"]
["Capital Social",{"$f":"+B404-SUM(B421:B425)","v":12943000},{"$f":"+C404-SUM(C421:C425)","v":12603545.066666666},{"$f":"+D404-SUM(D421:D425)","v":-11106666.666666668},98000,102900,108045,19947.361111113802,-163930.27638889104,{"$f":"+J404-SUM(J421:J425)","v":125075.59312499687},131329.37278125249,137895.84142031148]
["Crédito de los Abastecedores"]
["Prestamos Bancarios",{"$f":"Variables!C49","v":10000000}]
["Rendimientos Financieros",null,{"$f":"+Variables!$D$49","v":0}]
["Incremento en el Pasivo Corrientes",null,{"$f":"E269","v":11200000},{"$f":"F269","v":11760000},588000,617400,648270,680683.50000000186,714717.67500000075,{"$f":"L269","v":750453.55874999985},{"$f":"M269","v":787976.23668750189},{"$f":"N269","v":827375.04852187634}]
["Otros Recursos (Arrendamientos"]
["Participaciones, Etc.)"]
[]
["TOTAL RECURSOS FINANCIEROS",{"$f":"+B419+SUM(B421:B425)","v":22943000},{"$f":"+C419+SUM(C421:C425)","v":23803545.066666666},{"$f":"+D419+SUM(D421:D425)","v":653333.33333333209},686000,720300,756315,700630.86111111566,550787.3986111097,{"$f":"+J419+SUM(J421:J425)","v":875529.15187499672},919305.60946875438,965270.88994218782]
[]
[]
[]
[]
["Cuadro 11.2"]
["FLUJO DE CAJA DEL PROYECTO"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Valor"]
["Año",{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Remanente"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ultimo"]
["Nivel de Producción",{"$f":"+B$53","v":0},{"$f":"+C$53","v":0.65},{"$f":"+D$53","v":0.67},0.7,0.72,0.77,0.81,0.86,0.9,0.95,1,"Año"]
[]
["ENTRADAS DE EFECTIVO"]
["1. Recursos Financieros",{"$f":"+B$427","v":22943000},{"$f":"+C$427","v":23803545.066666666},653333.33333333209,686000,720300,756315,700630.86111111566,550787.3986111097,875529.15187499672,919305.60946875438,965270.88994218782]
["2. Ingresos por Concepto "]
["    de Ventas",{"$f":"+$B$355","v":0},{"$f":"C$355","v":173000000.00000012},{"$f":"D$355","v":182700000.00000012},188400000.00000012,189600000.00000012,206300000.00000015,213200000.00000015,234400000.00000015,240100000.00000015,258000000.00000015,268900000.00000018]
["3. Valor Remanente en el Ultimo "]
["    Año",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$M$65+$B$290+$N$272","v":9859541.2920487821}]
[]
[]
["TOTAL ENTRADAS EFECTIVO",{"$f":"SUM(B443:B447)","v":22943000},{"$f":"SUM(C443:C447)","v":196803545.06666678},183353333.33333346,189086000.00000012,190320300.00000012,207056315.00000015,213900630.86111125,234950787.39861125,{"$f":"SUM(J443:J447)","v":240975529.15187514},258919305.60946891,269865270.88994235,{"$f":"SUM(M443:M447)","v":9859541.2920487821}]
[]
[]
["SALIDAS DE EFECTIVO"]
["1. Incremento de Activos",{"$f":"+B$404","v":22943000},{"$f":"+C$404","v":23803545.066666666},653333.33333333209,686000,720300,756315,700630.86111111566,550787.3986111097,875529.15187499672,919305.60946875438,965270.88994218782]
["   Totales"]
["2. Costos de Operación, Netos",{"$f":"+B195-B189-B177","v":0},{"$f":"+C195-C189-C177","v":160416705.59999999},{"$f":"+D195-D189-D177","v":163776705.59999999},167304705.59999999,171009105.59999999,174898725.59999999,178982827.60000002,183271134.65000001,{"$f":"+J195-J189-J177","v":187773856.0025},192501713.42262501,197465963.71375626]
["    de Depreciación y de Amortización"]
["    de Diferidos"]
["3. Costos de Financiación",{"$f":"+B197","v":0},2400000,2181422.0156278294,1910385.3150063376,1574299.8062356878,1157553.7753600818,640788.69707433076,0,{"$f":"+J197","v":0},0,0]
["    (Intereses)"]
["4. Pago de Prestamos",null,{"$f":"C97","v":910741.60155071178},{"$f":"D97","v":1129319.5859228824},1400356.2865443742,1736441.795315024,2153187.82619063,2669952.9044763809,0,{"$f":"J97","v":0},0,0]
["5. Impuestos",{"$f":"+B371","v":0},{"$f":"C371","v":1688908.3200000376},{"$f":"D371","v":3656481.7153116888},4389392.7254981361,3738898.3781293309,7707036.1873920215,9043435.110877743,15328159.605000041,{"$f":"J371","v":15687343.199250041},19638985.973212536,21419710.885873169]
["6. Dividendos",{"$f":"+B376","v":0},{"$f":"+C376","v":0},{"$f":"+D376","v":0},0,0,0,0,0,{"$f":"+J376","v":0},0,0]
[]
[]
["TOTAL SALIDAS EFECTIVO",{"$f":"SUM(B454:B464)","v":22943000},{"$f":"SUM(C454:C464)","v":189219900.58821738},171397262.25019574,175690839.92704886,178779045.57968006,186672818.38894272,192037635.17353958,199150081.65361115,{"$f":"SUM(J454:J464)","v":204336728.35362503},213060005.0053063,219850945.48957163,{"$f":"SUM(M454:M464)","v":0}]
[]
["ENTRADAS MENOS SALIDAS",{"$f":"+B450-B466","v":0},{"$f":"+C450-C466","v":7583644.4784494042},11956071.083137721,13395160.072951257,11541254.420320064,20383496.611057431,21862995.687571675,35800705.745000094,{"$f":"+J450-J466","v":36638800.798250109},45859300.604162604,50014325.400370717,{"$f":"+M450-M466","v":9859541.2920487821}]
[]
[]
["SALDO ACUMULADO DE EFECTIVO",{"$f":"+B468","v":0},{"$f":"+B471+C468","v":7583644.4784494042},{"$f":"+C471+D468","v":19539715.561587125},{"$f":"+D471+E468","v":32934875.634538382},44476130.054858446,64859626.665915877,86722622.353487551,122523328.09848765,{"$f":"+I471+J468","v":159162128.89673775},{"$f":"+J471+K468","v":205021429.50090036},{"$f":"+K471+L468","v":255035754.90127108},{"$f":"+L471+M468","v":264895296.19331986}]
[]
[]
[]
[]
["Cuadro 12,25"]
["CUADRO DE FUENTES Y USOS DE FONDO DE EFECTIVOS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Valor"]
["Año",{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"Remanente"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ultimo"]
["Nivel de Producción",{"$f":"+B$53","v":0},{"$f":"+C$53","v":0.65},{"$f":"+D$53","v":0.67},0.7,0.72,0.77,0.81,0.86,0.9,0.95,1,"Año"]
[]
["ENTRADAS DE EFECTIVO"]
["1. Recursos Financieros",{"$f":"+B$427","v":22943000},{"$f":"+C$427","v":23803545.066666666},653333.33333333209,686000,720300,756315,700630.86111111566,550787.3986111097,875529.15187499672,919305.60946875438,965270.88994218782]
["2. Utilidad Operativa",{"$f":"+B362","v":0},{"$f":"C$362","v":8029694.4000001252},{"$f":"D$362","v":14369694.400000125},16541694.400000125,14037294.400000125,26847674.400000155,30785572.40000014,51093865.350000143,52291143.997500136,65463286.577375129,71399036.286243901]
["3. Depreciación",{"$f":"+B65","v":0},{"$f":"+C$65","v":3431600},{"$f":"+D$65","v":3431600},3431600,3431600,3431600,3431600,35000,35000,35000,35000]
["4. Amortización de Diferidos",{"$f":"+B79","v":0},{"$f":"+C$79","v":1122000},{"$f":"+D$79","v":1122000},1122000,1122000,1122000,0,0,0,0,0]
["5. Valor Remanente en el Ultimo",{"$f":"+B447","v":0},{"$f":"+C$447","v":0},{"$f":"+D$447","v":0},0,0,0,0,0,0,0,0,{"$f":"M450","v":9859541.2920487821}]
["    año"]
[]
["TOTAL ENTRADAS EFECTIVO",{"$f":"SUM(B487:B491)","v":22943000},{"$f":"SUM(C487:C491)","v":36386839.466666788},19576627.733333457,21781294.400000125,19311194.400000125,32157589.400000155,34917803.261111259,51679652.748611256,{"$f":"SUM(J487:J491)","v":53201673.149375133},66417592.186843887,72399307.176186085,{"$f":"SUM(M487:M491)","v":9859541.2920487821}]
[]
[]
["SALIDAS DE EFECTIVO"]
["1. Incremento de Activos",{"$f":"+B$404","v":22943000},{"$f":"+C$404","v":23803545.066666666},653333.33333333209,686000,720300,756315,700630.86111111566,550787.3986111097,875529.15187499672,919305.60946875438,965270.88994218782]
["   Totales"]
["2. Costos de Financiación",{"$f":"+B197","v":0},{"$f":"+C197","v":2400000},{"$f":"+D197","v":2181422.0156278294},1910385.3150063376,1574299.8062356878,1157553.7753600818,640788.69707433076,0,{"$f":"+J197","v":0},0,0]
["    (Intereses)"]
["3. Pago de Prestamos",{"$f":"+B461","v":0},910741.60155071178,1129319.5859228824,1400356.2865443742,1736441.795315024,2153187.82619063,2669952.9044763809,0,{"$f":"+J461","v":0},0,0]
["4. Impuestos",0,1688908.3200000376,3656481.7153116888,4389392.7254981361,3738898.3781293309,7707036.1873920215,9043435.110877743,15328159.605000041,{"$f":"+J462","v":15687343.199250041},19638985.973212536,21419710.885873169]
["5. Dividendos",0,0,0,0,0,0,0,0,{"$f":"+J463","v":0},0,0]
[]
[]
["TOTAL SALIDAS EFECTIVO",{"$f":"SUM(B498:B505)","v":22943000},{"$f":"SUM(C498:C505)","v":28803194.988217417},{"$f":"SUM(D498:D505)","v":7620556.6501957327},8386134.3270488475,7769939.9796800427,11774092.788942734,13054807.57353957,15878947.003611151,{"$f":"SUM(J498:J505)","v":16562872.351125037},20558291.582681291,22384981.775815357]
[]
["ENTRADAS MENOS SALIDAS",{"$f":"+B494-B507","v":0},{"$f":"+C494-C507","v":7583644.4784493707},{"$f":"+D494-D507","v":11956071.083137725},13395160.072951278,11541254.420320082,20383496.611057423,21862995.687571689,35800705.745000109,{"$f":"+J494-J507","v":36638800.798250094},45859300.604162596,50014325.400370732,{"$f":"M468","v":9859541.2920487821}]
[]
[]
["SALDO ACUMULADO DE EFECTIVO",{"$f":"+B509","v":0},{"$f":"+B512+C509","v":7583644.4784493707},19539715.561587095,32934875.634538375,44476130.054858461,64859626.665915884,86722622.353487581,122523328.09848769,{"$f":"+I512+J509","v":159162128.89673778},{"$f":"+J512+K509","v":205021429.50090039},{"$f":"+K512+L509","v":255035754.9012711},{"$f":"+L512+M509","v":264895296.19331989}]
[]
[]
[]
[]
["Cuadro 11.3"]
["BALANCE PROYECTADO"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["Nivel de Producción",{"$f":"+B$53","v":0},{"$f":"+C$53","v":0.65},{"$f":"+D$53","v":0.67},0.7,0.72,0.77,0.81,0.86,0.9,0.95,1]
[]
["ACTIVOS"]
["Activos Corrientes"]
["1. Efectivo",{"$f":"+B471+D227","v":0},{"$f":"+C471+E227","v":12039664.078449404},{"$f":"+D471+F227","v":24089068.494920459},37582228.567871712,49226382.988191776,69717924.599249214,91694367.564598665,127614192.94987653,{"$f":"+J471+L227","v":164378069.34125164},{"$f":"+K471+M227","v":210368699.31819549},{"$f":"+L471+N227","v":260520920.55998653}]
["2. Cuentas por Cobrar",{"$f":"+D246","v":0},{"$f":"+E246","v":13747525.466666667},{"$f":"+F246","v":14027525.466666667},14321525.466666667,14630225.466666667,14954360.466666667,15201202.300000003,15275511.220833333,{"$f":"+L246","v":15650738.000208333},{"$f":"+M246","v":16044726.118552083},{"$f":"+N246","v":16458413.642813021}]
["3. Inventario de Materias Primas",{"$f":"+D248","v":0},5600000,{"$f":"+F248","v":5880000},6174000,6482700,6806835,7147176.7500000009,7504535.5875000013,{"$f":"+L248","v":7879762.3668750012},{"$f":"+M248","v":8273750.4852187522},{"$f":"+N248","v":8687438.0094796903}]
["4. Inventario de Productos en Proceso",0,0,0,0,0,0,0,0,0,0,0]
["5. Inventario de Productos Terminados",0,0,0,0,0,0,0,0,0,0,0]
["6. Inventario de Repuestos y Suministros"]
["Total Activos Corrientes",{"$f":"SUM(B529:B534)","v":0},{"$f":"SUM(C529:C534)","v":31387189.545116071},43996593.961587124,58077754.034538381,70339308.454858452,91479120.065915883,114042746.61459866,150394239.75820988,{"$f":"SUM(J529:J534)","v":187908569.70833498},234687175.92196634,285666772.21227926]
[]
["Activos Fijos"]
["No Depreciables"]
["7. Terrenos",{"$f":"+B290","v":0},{"$f":"+C290+B539","v":0}]
["Depreciables"]
["8. Edificios",{"$f":"+B291-B55","v":0},{"$f":"+C291-C55+B541","v":0}]
["9. Maquinaria y Equipos",{"$f":"+B292-B57","v":350000},{"$f":"+C292-C57+B542","v":315000},{"$f":"+D292-D57+C542","v":280000},245000,210000,175000,140000,105000,{"$f":"+J292-J57+I542","v":70000},{"$f":"+K292-K57+J542","v":35000},{"$f":"+L292-L57+K542","v":0}]
["10. Muebles y Enseres",{"$f":"+B294-B61","v":16983000},{"$f":"+C294-C61+B543","v":13586400},{"$f":"+D294-D61+C543","v":10189800},{"$f":"+E294-E61+D543","v":6793200},{"$f":"+F294-F61+E543","v":3396600},{"$f":"+G294-G61+F543","v":0}]
["11. Vehículos",{"$f":"+B293-B59","v":0},{"$f":"+C293-C59+B544","v":0}]
["12. Herramientas"]
["Total Activos Fijos",{"$f":"SUM(B539:B545)","v":17333000},{"$f":"SUM(C539:C545)","v":13901400},10469800,7038200,3606600,175000,140000,105000,{"$f":"SUM(J539:J545)","v":70000},35000,0]
["Activos Diferidos"]
["13. Gastos Preoperativos",{"$f":"+B300-B79","v":5610000},{"$f":"+B548+C300-C79","v":4488000},{"$f":"+C548+D300-D79","v":3366000},{"$f":"+D548+E300-E79","v":2244000},{"$f":"+E548+F300-F79","v":1122000},{"$f":"+F548+G300-G79","v":0}]
["Total Activos Diferidos",{"$f":"+B548","v":5610000},{"$f":"+C548","v":4488000},3366000,2244000,1122000,0,0,0,{"$f":"+J548","v":0},0,0]
[]
["TOTAL ACTIVOS",{"$f":"+B549+B546+B535","v":22943000},{"$f":"+C549+C546+C535","v":49776589.545116067},57832393.961587124,67359954.034538388,75067908.454858452,91654120.065915883,114182746.61459866,150499239.75820988,{"$f":"+J549+J546+J535","v":187978569.70833498},234722175.92196634,285666772.21227926]
[]
["PASIVO Y PATRIMONIO"]
[]
["Pasivo"]
["14. Pasivo Corriente",{"$f":"+D269","v":0},{"$f":"+E269+B556","v":11200000},{"$f":"+F269+C556","v":22960000},23548000,24165400,24813670,25494353.5,26209071.175000001,{"$f":"+L269+I556","v":26959524.733750001},{"$f":"+M269+J556","v":27747500.970437504},{"$f":"+N269+K556","v":28574876.018959381}]
["15. Prestamos a Corto-Mediano y ",{"$f":"B421-B97","v":10000000},{"$f":"C422-C97+B557","v":9089258.3984492887},7959938.8125264067,6559582.5259820325,4823140.7306670081,2669952.9044763781,0]
["Largo Plazo"]
["Total Pasivo",{"$f":"+B556+B557","v":10000000},{"$f":"+C556+C557","v":20289258.398449287},30919938.812526405,30107582.525982033,28988540.73066701,27483622.904476378,25494353.5,26209071.175000001,{"$f":"+J556+J557","v":26959524.733750001},27747500.970437504,28574876.018959381]
[]
["Patrimonio"]
["16. Capital Social",{"$f":"+B419","v":12943000},{"$f":"+C419+B562","v":25546545.066666666},{"$f":"+D419+C562","v":14439878.399999999},14537878.399999999,14640778.399999999,14748823.399999999,14768770.761111112,14604840.484722221,{"$f":"+J419+I562","v":14729916.077847218},{"$f":"+K419+J562","v":14861245.450628471},{"$f":"+L419+K562","v":14999141.292048782}]
["17. Reservas",{"$f":"+B382","v":0},{"$f":"+C382","v":3940786.0800000876},{"$f":"+D382","v":12472576.749060694},22714493.108556345,31438589.324191451,49421673.761439502,70523022.353487566,106288728.09848768,{"$f":"+J382","v":142892528.89673775},188716829.50090033,238696154.90127105]
[]
["Total Patrimonio",{"$f":"+B562+B563","v":12943000},{"$f":"+C562+C563","v":29487331.146666754},26912455.149060693,37252371.508556344,46079367.72419145,64170497.161439501,85291793.114598677,120893568.5832099,{"$f":"+J562+J563","v":157622444.97458497},203578074.95152879,253695296.19331983]
[]
["TOTAL PASIVO-PATRIMONIO",{"$f":"+B565+B559","v":22943000},{"$f":"+C565+C559","v":49776589.545116037},57832393.961587101,67359954.034538373,75067908.454858452,91654120.065915883,110786146.61459868,147102639.75820991,{"$f":"+J565+J559","v":184581969.70833498},231325575.92196628,282270172.2122792]
[]
[]
[]
["Cuadro 11.4"]
["INDICADORES PARA LOS ANÁLISIS FINANCIEROS"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B$51","v":2014},2015,2016,2017,2018,2019,2020,2021,2022,2023,2024]
[]
["a.INDICADORES DE LIQUIDEZ"]
[" 1.Razón corriente o circulante (# veces)",{"$f":"IF(+B556=0,0,+B535/B556)","v":0},{"$f":"IF(+C556=0,0,+C535/C556)","v":2.8024276379567921},1.9162279599994392,2.4663561251290291,2.9107446371613319,3.6866420834127269,4.4732550921363297,5.7382514150927317,{"$f":"IF(+J556=0,0,+J535/J556)","v":6.9700253088325637},8.4579572110657697,9.9971307669975484]
[{"$f":"+MID(A580,4,60)","v":"Razón corriente o circulante (# veces)"}]
[]
[" 2.Prueba ácida o razón ácida (# veces)",{"$f":"IF(+B556=0,0,+(B535-B531-B532-B533-B534)/B556)","v":0},{"$f":"IF(+C556=0,0,+(C535-C531-C532-C533-C534)/C556)","v":2.3024276379567921},1.6601303990238294,2.2041682535475786,2.6424809212700162,3.4123241368937318,4.1929115741098775,5.4519178957783065,{"$f":"IF(+J556=0,0,+(J535-J531-J532-J533-J534)/J556)","v":6.6777441041490659},8.1597771877896665,9.6931071203607058]
[{"$f":"+MID(A583,4,60)","v":"Prueba ácida o razón ácida (# veces)"}]
[]
[" 3.Respaldo de activos fijos (# veces)",{"$f":"IF(+B557=0,0,+B546/B557)","v":1.7333000000000001},{"$f":"IF(+C557=0,0,+C546/C557)","v":1.5294317083527635},1.3153116181651889,1.0729646242153672,0.7477700115752649,6.5544227280788084E-2,0,0,{"$f":"IF(+J557=0,0,+J546/J557)","v":0},0,0]
[{"$f":"+MID(A586,4,60)","v":"Respaldo de activos fijos (# veces)"}]
[]
[" 4.Capital de trabajo neto (unidades monetarias)",{"$f":"B535-B556","v":0},{"$f":"C535-C556","v":20187189.545116071},21036593.961587124,34529754.034538381,46173908.454858452,66665450.065915883,88548393.114598662,124185168.58320989,{"$f":"J535-J556","v":160949044.974585},206939674.95152885,257091896.19331989]
[{"$f":"+MID(A589,4,60)","v":"Capital de trabajo neto (unidades monetarias)"}]
[]
[]
[]
["b.INDICADORES DE APROVECHAMIENTO DE RECURSOS"]
[" 1.Rotación de inventarios",{"$f":"+IF(AVERAGE(B531:B534)=0,0,B118/AVERAGE(B531:B534))","v":0},{"$f":"+IF(AVERAGE(C531:C534)=0,0,C118/AVERAGE(C531:C534))","v":36},36,36,36,36,36,36,{"$f":"+IF(AVERAGE(J531:J534)=0,0,J118/AVERAGE(J531:J534))","v":36},36,36]
[{"$f":"+MID(A595,4,60)","v":"Rotación de inventarios"}]
[]
[" 2.Disponibilidad de inventario de materia prima ( # veces)",{"$f":"IF(B118=0,0,(360*AVERAGE(B531:B534)/B118))","v":0},{"$f":"IF(C118=0,0,(360*AVERAGE(C531:C534)/C118))","v":10},10,10,10,10,10,10,{"$f":"IF(J118=0,0,(360*AVERAGE(J531:J534)/J118))","v":9.9999999999999982},9.9999999999999982,10]
[{"$f":"+MID(A598,4,60)","v":"Disponibilidad de inventario de materia prima ( # veces)"}]
[]
[" 3.Rotación de inventario productos terminados ( # veces)",{"$f":"IF(B533=0,0,+B356/B533)","v":0},{"$f":"IF(C533=0,0,+C356/C533)","v":0},0,0,0,0,0,0,{"$f":"IF(J533=0,0,+J356/J533)","v":0},0,0]
[{"$f":"+MID(A601,4,60)","v":"Rotación de inventario productos terminados ( # veces)"}]
[]
[" 4.Disponibilidad de inventario de productos terminados(# veces)",{"$f":"IF(B356=0,0,+B533/B356)","v":0},{"$f":"IF(C356=0,0,+C533/C356)","v":0},0,0,0,0,0,0,{"$f":"IF(J356=0,0,+J533/J356)","v":0},0,0]
[{"$f":"+MID(A604,4,60)","v":"Disponibilidad de inventario de productos terminados(# veces"}]
[]
[" 5.Rotación de Cartera (# veces)",{"$f":"+IF(B530=0,0,B355/B530)","v":0},{"$f":"+IF(C530=0,0,C355/C530)","v":12.584082889642179},13.024392679531863,13.155023215822986,12.959472185304493,13.795307426208144,14.025206414100555,15.344821957926774,{"$f":"+IF(J530=0,0,J355/J530)","v":15.341129600201862},16.080050110776384,16.338148125072923]
[{"$f":"+MID(A607,4,60)","v":"Rotación de Cartera (# veces)"}]
[]
[" 6.Período promedio de cobro (días)",{"$f":"+IF(B355=0,0,360*B530/B355)","v":0},{"$f":"+IF(C355=0,0,360*C530/C355)","v":28.607567445086687},27.640444269293905,27.365972229299345,27.778909113924033,26.09583018904506,25.668071425891167,23.460682762371999,{"$f":"+IF(J355=0,0,360*J530/J355)","v":23.466329363077868},22.387989932863359,22.034320979593467]
[{"$f":"+MID(A610,4,60)","v":"Período promedio de cobro (días)"}]
[]
[" 7.Rotación de activo corriente o circulante (# Veces)"]
[{"$f":"+MID(A613,4,60)","v":"Rotación de activo corriente o circulante (# Veces)"}]
[]
[" 8.Rotación de cuentas por pagar (# veces)",{"$f":"+IF(B556=0,0,B118/B556)","v":0},{"$f":"+IF(C556=0,0,C118/C556)","v":6},3.0731707317073171,3.146254458977408,3.219164590695788,3.2918153582279444,3.3641222163174294,3.4360022317730996,{"$f":"+IF(J556=0,0,J118/J556)","v":3.5073744562019717},3.5781602793132388,3.6482837596421094]
[{"$f":"+MID(A616,4,60)","v":"Rotación de cuentas por pagar (# veces)"}]
[]
[" 9.Período promedio de cuentas por pagar (días)",{"$f":"+IF(B118=0,0,360*B556/B118)","v":0},{"$f":"+IF(C118=0,0,360*C556/C118)","v":60},117.14285714285714,114.421768707483,111.83025591188857,109.36214848751293,107.01156998810752,104.77292379819764,{"$f":"+IF(J118=0,0,360*J556/J118)","v":102.64087980780727},100.61036172172123,98.676534973067817]
[{"$f":"+MID(A619,4,60)","v":"Período promedio de cuentas por pagar (días)"}]
[]
["10.Rotación del activo fijo(# veces)",{"$f":"+IF(B546=0,0,B355/B546)","v":0},{"$f":"+IF(C546=0,0,C355/C546)","v":12.444789733408154},17.450190070488464,26.768207780398413,52.570287805689603,1178.8571428571438,1522.857142857144,2232.3809523809537,{"$f":"+IF(J546=0,0,J355/J546)","v":3430.0000000000023},7371.4285714285761,0]
[{"$f":"+MID(A622,4,60)","v":"Rotación del activo fijo(# veces)"}]
[]
["11.Rotación del activo total (# veces)",{"$f":"+IF(B551=0,0,B355/B551)","v":0},{"$f":"+IF(C551=0,0,C355/C551)","v":3.4755293920488044},3.1591291227084835,2.7969140225867615,2.5257131030101192,2.2508535333887134,1.8671822698363938,1.557482950588881,{"$f":"+IF(J551=0,0,J355/J551)","v":1.2772732571193413},1.0991718144508533,0.94130653669507047]
[{"$f":"+MID(A625,4,60)","v":"Rotación del activo total (# veces)"}]
[]
[]
[]
["c.INDICADORES DE ESTRUCTURA O ENDEUDAMIENTO"]
[" 1.Indice de endeudamiento total(%)",{"$f":"+IF(B551=0,0,B559/B551)","v":0.43586279039358411},{"$f":"+IF(C551=0,0,C559/C551)","v":0.40760643876695662},0.5346473955939598,0.44696560378507033,0.38616422553052826,0.29986238354272221,0.22327675814325226,0.17414753202147168,{"$f":"+IF(J551=0,0,J559/J551)","v":0.14341807566458259},0.11821422863625035,0.1000287005648853]
[{"$f":"+MID(A631,4,60)","v":"Indice de endeudamiento total(%)"}]
[]
[" 2.Indice de endeudamiento a corto plazo(%)",{"$f":"+IF(B551=0,0,B556/B551)","v":0},{"$f":"+IF(C551=0,0,C556/C551)","v":0.22500537104593402},0.39700933036336472,0.34958456159168266,0.32191385769768305,0.27073163740107359,0.22327675814325226,0.17414753202147168,{"$f":"+IF(J551=0,0,J556/J551)","v":0.14341807566458259},0.11821422863625035,0.1000287005648853]
[{"$f":"+MID(A634,4,60)","v":"Indice de endeudamiento a corto plazo(%)"}]
[]
[" 3.Indice de endeudamiento a largo plazo(%)",{"$f":"+IF(B551=0,0,B557/B551)","v":0.43586279039358411},{"$f":"+IF(C551=0,0,C557/C551)","v":0.18260106772102269},0.13763806523059516,9.7381042193387612E-2,6.4250367832845226E-2,2.9130746141648615E-2,0,0,{"$f":"+IF(J551=0,0,J557/J551)","v":0},0,0]
[{"$f":"+MID(A637,4,60)","v":"Indice de endeudamiento a largo plazo(%)"}]
[]
[" 4.Indice de cobertura de intereses (# veces)",{"$f":"+IF(B366=0,0,(B369+B366)/B366)","v":0},{"$f":"+IF(C366=0,0,(C369+C366)/C366)","v":3.3457060000000522},6.5873060311369516,8.6588261907495081,8.9165318730266083,23.193457592627706,48.043251294161088,0,{"$f":"+IF(J366=0,0,(J369+J366)/J366)","v":0},0,0]
[{"$f":"+MID(A640,4,60)","v":"Indice de cobertura de intereses (# veces)"}]
[]
[" 5.Indice de participación patrimonial(%)",{"$f":"+B565/B551","v":0.56413720960641589},{"$f":"+C565/C551","v":0.59239356123304288},0.4653526044060397,0.55303439621492956,0.6138357744694718,0.70013761645727779,0.74697619074170896,0.80328358320903104,{"$f":"+J565/J551","v":0.83851284334778076},0.86731504661582781,0.88808122214787588]
[{"$f":"+MID(A643,4,60)","v":"Indice de participación patrimonial(%)"}]
[]
[" 6.Razón deuda a largo plazo a capital",{"$f":"+B557/B565","v":0.77261840377037783},{"$f":"+C557/C565","v":0.30824282988651341},0.29577155887259238,0.17608496480486857,0.10467028887062793,4.1607171871511875E-2,0,0,{"$f":"+J557/J565","v":0},0,0]
[{"$f":"+MID(A646,4,60)","v":"Razón deuda a largo plazo a capital"}]
[]
[]
[]
["d.INDICADORES DE COSTOS"]
[" 1. Indice de costos de ventas(%)",{"$f":"IF(B355=0,0,+B356/B355)","v":0},{"$f":"IF(C355=0,0,+C356/C355)","v":0.59436388901734061},0.58119842802408284,0.58234051380042429,0.59819278902953543,0.56862323218613631,0.56937651876172579,0.52168421437713286,{"$f":"IF(J355=0,0,+J356/J355)","v":0.52805289963556823},0.50974170008769359,0.50754038272129487]
[{"$f":"+MID(A652,4,60)","v":" Indice de costos de ventas(%)"}]
[]
[" 2.Indice de gastos operativos(%)",{"$f":"IF(B355=0,0,+B359/B355)","v":0},{"$f":"IF(C355=0,0,+C359/C355)","v":0.35922169248554886},0.34014971428571406,0.32985856050955392,0.32777084810126561,0.30123777411536573,0.28622586210131312,0.26033854436860049,{"$f":"IF(J355=0,0,+J359/J355)","v":0.25415807913369415},0.23652463100775178,0.22693698326515416]
[{"$f":"+MID(A655,4,60)","v":"Indice de gastos operativos(%)"}]
[]
[" 3.Indice de costos financieros(%)",{"$f":"IF(B355=0,0,+B366/B355)","v":0},{"$f":"IF(C355=0,0,+C366/C355)","v":1.3872832369942186E-2},1.1939912510278204E-2,1.0140049442708791E-2,8.3032690202304148E-3,5.6110216934565247E-3,3.0055755022248137E-3,0,{"$f":"IF(J355=0,0,+J366/J355)","v":0},0,0]
[{"$f":"+MID(A658,4,60)","v":"Indice de costos financieros(%)"}]
[]
[]
[]
["e.INDICADORES DE RENTABILIDAD"]
[" 1.Indice de rendimiento bruto en ventas(%)",{"$f":"IF(B355=0,0,+B358/B355)","v":0},{"$f":"IF(C355=0,0,+C358/C355)","v":0.40563611098265939},0.41880157197591722,0.41765948619957577,0.40180721097046451,0.43137676781386375,0.43062348123827426,0.4783157856228672,{"$f":"IF(J355=0,0,+J358/J355)","v":0.47194710036443177},0.49025829991230641,0.49245961727870513]
[{"$f":"+MID(A664,4,60)","v":"Indice de rendimiento bruto en ventas(%)"}]
[]
[" 2.Indice de rendimiento operativo en ventas(%)",{"$f":"IF(B355=0,0,+B362/B355)","v":0},{"$f":"IF(C355=0,0,+C362/C355)","v":4.6414418497110518E-2},7.865185769020315E-2,8.7800925690021847E-2,7.403636286919893E-2,0.13013899369849799,0.14439761913696117,0.21797724125426668,{"$f":"IF(J355=0,0,+J362/J355)","v":0.21778902123073762},0.25373366890455462,0.26552263401355097]
[{"$f":"+MID(A667,4,60)","v":"Indice de rendimiento operativo en ventas(%)"}]
[]
[" 3.Indice de rendimiento neto en ventas(%)",{"$f":"IF(B355=0,0,+B374/B355)","v":0},{"$f":"IF(C355=0,0,+C374/C355)","v":2.2779110289017832E-2},4.6698361625947461E-2,5.436261337311913E-2,4.6013165694277956E-2,8.7169580403529026E-2,9.8974430544315428E-2,0.15258406887798667,{"$f":"IF(J355=0,0,+J374/J355)","v":0.15245231486151634},0.17761356823318822,0.18586584380948568]
[{"$f":"+MID(A670,4,60)","v":"Indice de rendimiento neto en ventas(%)"}]
[]
[" 4.Indice de rendimiento patrimonial(%)",{"$f":"IF(B565=0,0,+B374/B565)","v":0},{"$f":"IF(C565=0,0,+C374/C565)","v":0.13364336231037829},0.31702015374685671,0.27493327121853778,0.18932760249344735,0.28023913219818736,0.24740186390144403,0.29584456943532861,{"$f":"IF(J565=0,0,+J374/J565)","v":0.23222454647339147},0.22509447844554573,0.19700532942591767]
[{"$f":"+MID(A673,4,60)","v":"Indice de rendimiento patrimonial(%)"}]
[]
[" 5.Indice de rendimiento de la inversión(%)",{"$f":"IF(B551=0,0,+B374/B551)","v":0},{"$f":"IF(C551=0,0,+C374/C551)","v":7.9169467334202812E-2},0.14752615419530291,0.1520475556477395,0.11621605550501356,0.19620595805529487,0.18480330187949939,0.23764708580894375,{"$f":"IF(J551=0,0,+J374/J551)","v":0.19472326475855231},0.19522782806596395,0.17495673372621387]
[{"$f":"+MID(A676,4,60)","v":"Indice de rendimiento de la inversión(%)"}]
[]
[]
[]
[]
[]
["Cuadro 11.5"]
["PUNTO DE EQUILIBRIO"]
[]
[]
["Fase","Inversión",null,"Operacional"]
[]
["Año",{"$f":"+B577","v":2014},{"$f":"+C577","v":2015},2016,2017,2018,2019,2020,2021,{"$f":"+J577","v":2022},2023,2024]
[]
["Nivel de Producción",{"$f":"+B525","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,{"$f":"+J525","v":0.9},0.95,1]
[]
["Expresado en Unidades",{"$f":"+B720","v":0},{"$f":"+C720","v":4645.2879677421233},{"$f":"+D720","v":4525.8898801631294},4478.9582545239964,4681.1904284966658,4382.7978233103968,4292.3036987759333,3707.5271058555095,{"$f":"+J720","v":3727.619616305868},3638.7450414022705,3664.6797636527781]
[]
["Expresado en Unidades Monetarias (Millones)",{"$f":"+B726","v":0},{"$f":"+C726","v":159768353.56250256},{"$f":"+D726","v":154846457.13591841},154832244.98207733,159919586.53026456,148957362.59455281,145719609.64634231,127612974.09875652,{"$f":"+J726","v":129335472.52529474},124508782.58379129,123953759.55298525]
[]
["Tasa de la Utilización de la Capacidad en el Punto",{"$f":"+B732","v":0},{"$f":"+C732","v":0.68212745488136917},{"$f":"+D732","v":0.66459469605919674},0.65770312107547668,0.68739947555017111,0.64358264659477193,0.6302942288951443,0.54442395093326124,{"$f":"+J732","v":0.54737439299645629},0.53432379462588397,0.53813212388440201]
[" de Equilibrio (%)"]
[]
[]
[]
["Cuadro 11.6"]
["PUNTO DE EQUILIBRIO DETALLADO"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"DATOS PARA ELABORAR LA GRÁFICA DE PUNTO DE EQUILIBRIO AÑO 2015"]
["Fase","Inversión",null,"Operacional",null,null,null,null,null,null,null,null,null,"UNIDADES\nPRODUCIDAS","VENTAS","COSTOS\nFIJOS","COSTOS\nTOTALES"]
[]
["Año",{"$f":"+B523","v":2014},{"$f":"+C523","v":2015},2016,2017,2018,2019,2020,2021,{"$f":"+J523","v":2022},2023,2024,null,0,0,{"$f":"C717","v":67976952.799999997},{"$f":"P708","v":67976952.799999997}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C713","v":5030},{"$f":"C713*C718","v":173000000.00000012},{"$f":"P708","v":67976952.799999997},{"$f":"+P709+C712","v":167370305.59999999}]
["Nivel de Producción",{"$f":"+B484","v":0},0.65,0.67,0.7,0.72,0.77,0.81,0.86,{"$f":"+J484","v":0.9},0.95,1]
[]
["Cv= COSTOS VARIABLES (miles $)",null,{"$f":"+SUM(C171:C175)","v":99393352.799999997},{"$f":"+SUM(D171:D175)","v":102753352.8},106281352.8,109985752.8,113875372.8,117959473.80000001,122247779.85000001,{"$f":"+SUM(J171:J175)","v":126750501.20250002},131478358.62262502,136442608.91375628]
["UNIDADES -(miles $)",null,{"$f":"C40","v":5030},5340,5450,5550,6070,6280,6810,6920,7540,7950]
["v= COSTOS VARIABLES /UNIDAD (CV/Unidades)",null,{"$f":"C712/C713","v":19760.109900596421},{"$f":"D712/D713","v":19242.200898876403},19501.165651376145,19817.252756756756,18760.35795716639,18783.355700636945,17951.215837004405,{"$f":"J712/J713","v":18316.546416546244},17437.448093186344,17162.592316195758]
[]
["PUNTO DE EQUILIBRIO EXPRESADO EN UNIDADES - x=F/(p-v)"]
["F = COSTOS FIJOS - (miles $)",null,{"$f":"C197+C177+C183+C185+C187+C189","v":67976952.799999997},{"$f":"D197+D177+D183+D185+D187+D189","v":67758374.815627828},67487338.115006328,67151252.606235683,66734506.575360075,65095742.497074328,61058354.799999997,{"$f":"J197+J177+J183+J185+J187+J189","v":61058354.799999997},61058354.799999997,61058354.799999997]
["p= Precio promedio unitario",null,{"$f":"C41/C40","v":34393.638170974176},34213.48314606744,34568.807339449566,34162.162162162182,33986.820428336105,33949.044585987285,34419.970631424396,34696.531791907539,34217.506631299751,33823.899371069208]
["v= COSTOS VARIABLES /UNIDAD (CV/Unidades)",null,{"$f":"C714","v":19760.109900596421},{"$f":"D714","v":19242.200898876403},19501.165651376145,19817.252756756756,18760.35795716639,18783.355700636945,17951.215837004405,{"$f":"J714","v":18316.546416546244},17437.448093186344,17162.592316195758]
["Pto de Equilibrio Expresado en Unidades x=F/(p-v)",null,{"$f":"+C717/(C718-C719)","v":4645.2879677421233},{"$f":"+D717/(D718-D719)","v":4525.8898801631294},4478.9582545239964,4681.1904284966658,4382.7978233103968,4292.3036987759333,3707.5271058555095,{"$f":"+J717/(J718-J719)","v":3727.619616305868},3638.7450414022705,3664.6797636527781]
[]
["PUNTO DE EQUILIBRIO EXPRESADO EN TERMINO DE VENTAS - I=p[F/(p-v)] (Millones)"]
["F = COSTOS FIJOS - (miles $)",null,{"$f":"C717","v":67976952.799999997},{"$f":"D717","v":67758374.815627828},67487338.115006328,67151252.606235683,66734506.575360075,65095742.497074328,61058354.799999997,{"$f":"J717","v":61058354.799999997},61058354.799999997,61058354.799999997]
["p= Precio promedio por unidad",null,{"$f":"C718","v":34393.638170974176},{"$f":"D718","v":34213.48314606744},34568.807339449566,34162.162162162182,33986.820428336105,33949.044585987285,34419.970631424396,{"$f":"J718","v":34696.531791907539},34217.506631299751,33823.899371069208]
["v= COSTOS VARIABLES /UNIDAD (CV/Unidades)",null,{"$f":"C719","v":19760.109900596421},19242.200898876403,19501.165651376145,19817.252756756756,18760.35795716639,18783.355700636945,17951.215837004405,{"$f":"J719","v":18316.546416546244},17437.448093186344,17162.592316195758]
["Pto de Equilibrio Expresado en Term de Vtas  - I=p[F/(p-v)]",null,{"$f":"+C724*(C723/(C724-C725))","v":159768353.56250256},{"$f":"+D724*(D723/(D724-D725))","v":154846457.13591841},154832244.98207733,159919586.53026456,148957362.59455281,145719609.64634231,127612974.09875652,{"$f":"+J724*(J723/(J724-J725))","v":129335472.52529474},124508782.58379129,123953759.55298525]
[]
["TASA DE UTILIZACIÓN DE LA CAPACIDAD EN EL PUNTO DE EQUILIBRIO - NU=F/(IQ-VQ) (%)"]
["F = COSTOS FIJOS - (miles $)",null,{"$f":"C723","v":67976952.799999997},67758374.815627828,67487338.115006328,67151252.606235683,66734506.575360075,65095742.497074328,61058354.799999997,{"$f":"J723","v":61058354.799999997},61058354.799999997,61058354.799999997]
["IQ= INGRESOS POR VTAS CAPAC.TOTAL",null,{"$f":"C724*$I$40","v":234220675.94433415},{"$f":"D724*$I$40","v":232993820.22471926},235413577.98165154,232644324.32432446,231450247.11696887,231192993.63057342,234400000.00000015,{"$f":"J724*$I$40","v":236283381.50289035},233021220.15915132,230340754.71698132]
["IV= COSTOS VARIABLES CAPAC.TOTAL",null,{"$f":"C725*$I$40","v":134566348.42306164},{"$f":"D725*$I$40","v":131039388.12134831},132802938.08587155,134955491.2735135,127758037.68830311,127914652.3213376,122247779.84999999,{"$f":"J725*$I$40","v":124735681.09667993},118749021.514599,116877253.67329311]
["Tasa Utilizac. Capac. En el Pto de Equilibrio  - NU=F/(IQ-VQ) (%)",null,{"$f":"C729/(C730-C731)","v":0.68212745488136917},{"$f":"D729/(D730-D731)","v":0.66459469605919674},0.65770312107547668,0.68739947555017111,0.64358264659477193,0.6302942288951443,0.54442395093326124,{"$f":"J729/(J730-J731)","v":0.54737439299645629},0.53432379462588397,0.53813212388440201]
[]
[]
[]
["Cuadro 11.7"]
["VARIACIÓN DEL PRECIO DE VENTAS"]
[]
[null,null,"Punto de equilibrio"]
["Variaciondel precio de venta K,(%)","Precio de venta promedio","Unidades en miles","Ingresos en millones","Porcentaje de utilizacion capacidad"]
[1.2,{"$f":"$C$718*A741","v":41272.365805169007},{"$f":"+($L$717/(B741-$L$719))*1000","v":2532514.6595809124},{"$f":"B741*($L$717/(B741-$L$719))","v":104522871.43717648},{"$f":"$L$729/((B741*$L$40)-($L$40*$L$725))","v":0.31855530309193869}]
[1.1499999999999999,{"$f":"$C$718*A742","v":39552.683896620299},{"$f":"+($L$717/(B742-$L$719))*1000","v":2727025.6836904935},{"$f":"B742*($L$717/(B742-$L$719))","v":107861184.84497495},0.34302209857742061]
[1.1000000000000001,37833.001988071599,2953901.5321537629,111754962.53854105,0.37155994115141666]
[1.05,36113.320079522884,3221953.0332844672,116355421.1721916,0.40527711110496445]
[1,34393.638170974176,3543508.3461905844,121874143.91470605,0.44572432027554515]
[0.95,32673.956262425465,3936362.7216574489,128616543.40047756,0.49513996498835838]
[0.9,30954.274353876761,4427186.9546571011,137040359.61036006,0.5568788622210189]
[0.85,29234.59244532805,5057849.0843993006,147864156.63238919,0.63620743199991214]
[0.8,27514.910536779342,5898036.8936686339,162283957.47191638,0.74189143316586592]
[0.75,25795.22862823063,7072967.3523808401,182448809.93467486,0.88968142797243277]
[0.7,24075.546719681923,8832454.4378896244,212646169.46887359,1.1110005582251099]
[0.59999999999999898,20636.182902584471,17577878.935778312,362740324.75820816,2.2110539541859526]
[]
[]
[]
["Cuadro 11.8"]
["VARIACIÓN EN LOS COSTOS VARIABLES"]
[]
[null,null,"Punto de equilibrio"]
["Variacion de los costos de operacion K,(%)","Costo unitario variable","Unidades en miles","Ingresos en millones","Porcentaje de utilizacion capacidad"]
[1.2,{"$f":"+$L$719*A761","v":20595.110779434908},{"$f":"+$L$717/($L$724-B761)*1000","v":4615566.6013600407},{"$f":"+$L$724*($L$717/($L$724-B761))","v":156116460.2648699},{"$f":"+$L$729/(($L$724*$L$40)-($L$40*B761))","v":0.58057441526541398}]
[1.1499999999999999,{"$f":"+$L$719*A762","v":19736.981163625122},{"$f":"+$L$717/($L$724-B762)*1000","v":4334401.1728366781},{"$f":"+$L$724*($L$717/($L$724-B762))","v":146606349.10387215},0.54520769469643759]
[1.1000000000000001,18878.851547815335,4085524.2165900422,138188359.98000795,0.51390241718113749]
[1.05,18020.721932005548,3863675.8357892432,130684582.67216708,0.48599696047663449]
[1,17162.592316195758,3664679.7636527782,123953759.55298525,0.46096600800663884]
[0.95,16304.46270038597,3485177.9739113492,117882309.07984434,0.43838716652972959]
[0.9,15446.333084576183,3322439.6445178976,112377864.20262432,0.41791693641734573]
[0.85,14588.203468766395,3174221.2556339256,107364540.33207084,0.39927311391621712]
[0.8,13730.073852956608,3038662.5356611121,102779415.82883945,0.38222170259888216]
[0.75,12871.944237146818,2914207.9777148385,98569877.384593785,0.36656704122199235]
[0.7,12013.814621337029,2799546.8839592552,94691592.087628201,0.35214426213323974]
[0.59999999999999898,10297.555389717438,2595318.4586775615,87783790.382188275,0.32645515203491338]
[]
[]
[]
["Cuadro 11.9"]
["VARIACION EN LOS COSTOS FIJOS"]
[]
[null,null,"Punto de equilibrio"]
["Variacion de los costos de operación fijos con excepcion de la Depreciacion K,(%)","Costos fijos (millones)","Unidades en miles","Ingresos en millones","Porcentaje de utilizacion capacidad"]
[1.2,{"$f":"+(($L$717-$L$65)*A781)+$L$65","v":73263025.75999999},{"$f":"(B781/($L$724-$L$725))*1000","v":4397195.5812776685},{"$f":"$L$724*(B781/($L$724-$L$725))","v":148730300.85604605},{"$f":"+B781/(($L$724*$L$40)-($L$40*$L$725))","v":0.55310636242486422}]
[1.1499999999999999,{"$f":"+(($L$717-$L$65)*A782)+$L$65","v":70211858.019999996},{"$f":"(B782/($L$724-$L$725))*1000","v":4214066.6268714471},{"$f":"$L$724*(B782/($L$724-$L$725))","v":142536165.53028086},{"$f":"+B782/(($L$724*$L$40)-($L$40*$L$725))","v":0.53007127382030783}]
[1.1000000000000001,{"$f":"+(($L$717-$L$65)*A783)+$L$65","v":67160690.280000001},4030937.6724652238,136342030.20451567,0.50703618521575156]
[1.05,64109522.539999999,3847808.718059001,130147894.87875046,0.48400109661119523]
[1,61058354.799999997,3664679.7636527782,123953759.55298525,0.46096600800663884]
[0.95,58007187.059999995,3481550.809246555,117759624.22722004,0.43793091940208251]
[0.9,54956019.32,3298421.8548403322,111565488.90145485,0.41489583079752618]
[0.85,51904851.579999998,3115292.9004341094,105371353.57568964,0.39186074219296979]
[0.8,48853683.840000004,2932163.9460278866,99177218.249924436,0.36882565358841352]
[0.75,45802516.099999994,2749034.9916216633,92983082.924159229,0.34579056498385707]
[0.7,42751348.359999992,2565906.0372154405,86788947.598394021,0.32275547637930074]
[0.59999999999999898,36649012.879999936,2199648.1284029912,74400676.946863487,0.27668529917018764]

{"sheet":"Indicadores","index":3,"n_rows":178,"n_cols":13,"rows_kept":178,"cut":false,"hidden":false,"merged":[[40,0,40,5],[52,12,54,12],[76,1,76,6],[51,0,51,11]]}
["Cuadro 12.1"]
["FLUJO DE EFECTIVO NETO"]
["(Millones del año 2014)"]
[]
["Fase","Inversión",null,"Operacional",null,null,null,null,null,null,null,null,"Valor"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Remanente"]
["Año",{"$f":"+Variables!C3","v":2014},{"$f":"+Variables!D3","v":2015},{"$f":"+Variables!E3","v":2016},{"$f":"+Variables!F3","v":2017},{"$f":"+Variables!G3","v":2018},{"$f":"+Variables!H3","v":2019},{"$f":"+Variables!I3","v":2020},{"$f":"+Variables!J3","v":2021},{"$f":"+Variables!K3","v":2022},{"$f":"+Variables!L3","v":2023},{"$f":"+Variables!M3","v":2024},"en el"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ultimo"]
["Nivel de Producción",{"$f":"+Cálculos!B10","v":0},{"$f":"+Cálculos!C10","v":0.65},{"$f":"+Cálculos!D10","v":0.67},{"$f":"+Cálculos!E10","v":0.7},{"$f":"+Cálculos!F10","v":0.72},{"$f":"+Cálculos!G10","v":0.77},{"$f":"+Cálculos!H10","v":0.81},{"$f":"+Cálculos!I10","v":0.86},{"$f":"+Cálculos!J10","v":0.9},{"$f":"+Cálculos!K10","v":0.95},{"$f":"+Cálculos!L10","v":1},"Año"]
[]
["ENTRADAS DE EFECTIVO"]
["Prestamos",{"$f":"Variables!C49","v":10000000},{"$f":"+Variables!D49","v":0}]
["Ingresos por concepto de ventas",{"$f":"+Cálculos!B445","v":0},{"$f":"+Cálculos!C445","v":173000000.00000012},{"$f":"+Cálculos!D445","v":182700000.00000012},{"$f":"+Cálculos!E445","v":188400000.00000012},{"$f":"+Cálculos!F445","v":189600000.00000012},{"$f":"+Cálculos!G445","v":206300000.00000015},{"$f":"+Cálculos!H445","v":213200000.00000015},{"$f":"+Cálculos!I445","v":234400000.00000015},{"$f":"+Cálculos!J445","v":240100000.00000015},{"$f":"+Cálculos!K445","v":258000000.00000015},{"$f":"+Cálculos!L445","v":268900000.00000018}]
["Otros Ingresos"]
["Valor Remanente en el ultimo año",{"$f":"+Cálculos!B447","v":0},{"$f":"+Cálculos!C447","v":0},null,null,null,null,null,null,null,null,null,{"$f":"Cálculos!M447","v":9859541.2920487821}]
[]
[]
[]
["TOTAL ENTRADAS EFECTIVO",{"$f":"SUM(B12:B16)","v":10000000},{"$f":"SUM(C12:C16)","v":173000000.00000012},182700000.00000012,188400000.00000012,189600000.00000012,206300000.00000015,213200000.00000015,234400000.00000015,{"$f":"SUM(J12:J16)","v":240100000.00000015},258000000.00000015,268900000.00000018,9859541.2920487821]
[]
[]
["SALIDAS DE EFECTIVO"]
["Inversiones basicas",{"$f":"+Cálculos!B306","v":22943000},{"$f":"+Cálculos!C306","v":12603545.066666666},{"$f":"+Cálculos!D306","v":93333.333333332092},{"$f":"+Cálculos!E306","v":98000},{"$f":"+Cálculos!F306","v":102900},{"$f":"+Cálculos!G306","v":108045},{"$f":"+Cálculos!H306","v":19947.361111113802},{"$f":"+Cálculos!I306","v":-163930.27638889104},{"$f":"+Cálculos!J306","v":125075.59312499687},{"$f":"+Cálculos!K306","v":131329.37278125249},{"$f":"+Cálculos!L306","v":137895.84142031148}]
["Costos de operación netos de"]
["depreciacion y amortizacion diferidos",{"$f":"+Cálculos!B195-Cálculos!B177-Cálculos!B189","v":0},{"$f":"+Cálculos!C195-Cálculos!C177-Cálculos!C189","v":160416705.59999999},{"$f":"+Cálculos!D195-Cálculos!D177-Cálculos!D189","v":163776705.59999999},{"$f":"+Cálculos!E195-Cálculos!E177-Cálculos!E189","v":167304705.59999999},{"$f":"+Cálculos!F195-Cálculos!F177-Cálculos!F189","v":171009105.59999999},{"$f":"+Cálculos!G195-Cálculos!G177-Cálculos!G189","v":174898725.59999999},{"$f":"+Cálculos!H195-Cálculos!H177-Cálculos!H189","v":178982827.60000002},{"$f":"+Cálculos!I195-Cálculos!I177-Cálculos!I189","v":183271134.65000001},{"$f":"+Cálculos!J195-Cálculos!J177-Cálculos!J189","v":187773856.0025},{"$f":"+Cálculos!K195-Cálculos!K177-Cálculos!K189","v":192501713.42262501},{"$f":"+Cálculos!L195-Cálculos!L177-Cálculos!L189","v":197465963.71375626}]
["Costos de Financiacion",{"$f":"+Cálculos!B197","v":0},{"$f":"+Cálculos!C197","v":2400000},{"$f":"+Cálculos!D197","v":2181422.0156278294},{"$f":"+Cálculos!E197","v":1910385.3150063376},{"$f":"+Cálculos!F197","v":1574299.8062356878},{"$f":"+Cálculos!G197","v":1157553.7753600818},{"$f":"+Cálculos!H197","v":640788.69707433076},{"$f":"+Cálculos!I197","v":0},{"$f":"+Cálculos!J197","v":0},{"$f":"+Cálculos!K197","v":0},{"$f":"+Cálculos!L197","v":0}]
["Pago prestamos",{"$f":"Cálculos!B97","v":0},{"$f":"Cálculos!C97","v":910741.60155071178},{"$f":"Cálculos!D97","v":1129319.5859228824},{"$f":"Cálculos!E97","v":1400356.2865443742},{"$f":"Cálculos!F97","v":1736441.795315024},{"$f":"Cálculos!G97","v":2153187.82619063},{"$f":"Cálculos!H97","v":2669952.9044763809},{"$f":"Cálculos!I97","v":0},{"$f":"Cálculos!J97","v":0},{"$f":"Cálculos!K97","v":0},{"$f":"Cálculos!L97","v":0}]
["Impuestos",{"$f":"+Cálculos!B371","v":0},{"$f":"+Cálculos!C371","v":1688908.3200000376},{"$f":"+Cálculos!D371","v":3656481.7153116888},{"$f":"+Cálculos!E371","v":4389392.7254981361},{"$f":"+Cálculos!F371","v":3738898.3781293309},{"$f":"+Cálculos!G371","v":7707036.1873920215},{"$f":"+Cálculos!H371","v":9043435.110877743},{"$f":"+Cálculos!I371","v":15328159.605000041},{"$f":"+Cálculos!J371","v":15687343.199250041},{"$f":"+Cálculos!K371","v":19638985.973212536},{"$f":"+Cálculos!L371","v":21419710.885873169}]
[]
[]
[]
["TOTAL SALIDAS EFECTIVO",{"$f":"SUM(B23:B30)","v":22943000},{"$f":"SUM(C23:C30)","v":178019900.58821738},170837262.25019574,175102839.92704886,178161645.57968006,186024548.38894272,191356951.67353958,198435363.97861117,{"$f":"SUM(J23:J30)","v":203586274.79487503},212272028.76861879,219023570.44104975,0]
[]
["ENTRADAS MENOS SALIDAS",{"$f":"+B19-B32","v":-12943000},-5019900.5882172585,11862737.749804378,13297160.072951257,11438354.420320064,20275451.611057431,21843048.32646057,35964636.021388978,{"$f":"+J19-J32","v":36513725.205125123},45727971.231381357,49876429.558950424,9859541.2920487821]
[]
[]
["FLUJO DE EFECTIVO NETO (FEN)",{"$f":"+B34","v":-12943000},{"$f":"+C34","v":-5019900.5882172585},11862737.749804378,13297160.072951257,11438354.420320064,20275451.611057431,21843048.32646057,35964636.021388978,36513725.205125123,45727971.231381357,{"$f":"+L34+M34","v":59735970.850999206}]
[]
[]
[]
["CALCULO DE LA TIO - COSTO DE CAPITAL"]
["FUENTES DE FINANCIACIÓN","VALORES","PROPORCIONES","TASAS DE INTERES","TADA DE INTERES EFECTIVA","TASAS PONDERADAS"]
["Aporte de los socios",{"$f":"B37*-1","v":12943000},{"$f":"B43/$B$45","v":0.56413720960641589},0.2,{"$f":"D43","v":0.2},{"$f":"E43*C43","v":0.11282744192128319}]
["Crédito bancario",{"$f":"B19","v":10000000},{"$f":"B44/$B$45","v":0.43586279039358411},0.24,{"$f":"D44*(1-Variables!$B$47)","v":0.16799999999999998},{"$f":"E44*C44","v":7.3224948786122124E-2}]
["Total inversión",{"$f":"SUM(B43:B44)","v":22943000},{"$f":"SUM(C43:C44)","v":1},null,"TOTAL",{"$f":"SUM(F43:F44)","v":0.18605239070740531}]
[null,null,null,null,"RIESGO",0.1]
[null,null,null,null,"TREMA",{"$f":"F45+F46","v":0.28605239070740529}]
["TASA DE INTERES DE OPORTUNIDAD DEFLACTADA",null,{"$f":"ROUND((((1+F47)/(1.065))-1),2)","v":0.21}]
[]
[null,null,null,{"$f":"2.16/100","v":2.1600000000000001E-2}]
[]
["INDICADORES DE RENTABILIDAD FLUJO DE FONDOS CON FINANCIACIÓN"]
["Fase ","Inversión","Operacional",null,null,null,null,null,null,null,null,null,"Valor remanente en el último año"]
["Año",{"$f":"Variables!C$3","v":2014},{"$f":"Variables!D$3","v":2015},{"$f":"Variables!E$3","v":2016},{"$f":"Variables!F$3","v":2017},{"$f":"Variables!G$3","v":2018},{"$f":"Variables!H$3","v":2019},{"$f":"Variables!I$3","v":2020},{"$f":"Variables!J$3","v":2021},{"$f":"Variables!K$3","v":2022},{"$f":"Variables!L$3","v":2023},{"$f":"Variables!M$3","v":2024}]
["Nivel de producción",{"$f":"Variables!C14","v":0},{"$f":"Variables!D14","v":0.65},{"$f":"Variables!E14","v":0.67},{"$f":"Variables!F14","v":0.7},{"$f":"Variables!G14","v":0.72},{"$f":"Variables!H14","v":0.77},{"$f":"Variables!I14","v":0.81},{"$f":"Variables!J14","v":0.86},{"$f":"Variables!K14","v":0.9},{"$f":"Variables!L14","v":0.95},{"$f":"Variables!M14","v":1}]
["FLUJO DE FONDOS NETO",{"$f":"B37","v":-12943000},-5019900.5882172585,11862737.749804378,13297160.072951257,11438354.420320064,20275451.611057431,{"$f":"H37","v":21843048.32646057},{"$f":"I37","v":35964636.021388978},{"$f":"J37","v":36513725.205125123},45727971.231381357,59735970.850999206,{"$f":"+H15","v":0}]
["INGRESOS DEL FLUJO DE FONDOS O INGRESOS DEL PROYECTO",null,{"$f":"C56","v":-5019900.5882172585},{"$f":"IF(D56>0,D56,0)","v":11862737.749804378},13297160.072951257,11438354.420320064,20275451.611057431,21843048.32646057,35964636.021388978,{"$f":"IF(J56>0,J56,0)","v":36513725.205125123},45727971.231381357,59735970.850999206]
["EGRESOS DEL PROYECTO ",{"$f":"IF(B56<0,(B56*-1),0)","v":12943000},null,{"$f":"IF(D56<0,D56,0)","v":0},0,0,0,0,0,{"$f":"IF(J56<0,J56,0)","v":0},0,0]
["TIO",{"$f":"C48","v":0.21}]
["Valor presente neto (VPN)",{"$f":"NPV(B59,C56:L56)+B56","v":53150653.122874379},{"$f":"B56+((C56/(1+B59)^1))+(D56/(1+B59)^2)+(E56/(1+B59)^3)+(F56/(1+B59)^4)+(G56/(1+B59)^5)+(H56/(1+B59)^6)+(I56/(1+B59)^7)+(J56/(1+B59)^8)+(K56/(1+B59)^9)+(L56/(1+B59)^10)","v":53150653.122874394}]
["Tasa interna de retorno (TIR)",{"$f":"IF(ISERROR(IRR(B56:L56)),0,IRR(B56:L56))","v":0.60426399155356436}]
["RELACIÓN BENEFICIO COSTO"]
["Valor presente de ingresos",{"$f":"NPV(B59,C57:L57)","v":66093653.122874379}]
["Valor presente de egresos",{"$f":"B58","v":12943000}]
["(B/C)-1",{"$f":"(B63/B64)-1","v":4.1065172775148246}]
["COSTO ANUAL EQUIVALENTE",{"$f":"PMT(B59,5,-B60)","v":18165050.464565739}]
["Valor futuro VF",{"$f":"FV(B59,5,-B66)","v":137859105.78684592}]
["TASA VERDADERA DE RENTABILIDAD"]
["Costo anual equivalente de los ingresos",{"$f":"PMT(B59,5,-B63)","v":22588519.12109087}]
["Valor futuro de ingresos  VFi",{"$f":"FV(B59,8,-B69)","v":386691028.7720719}]
["TASA VERDADERA DE RENTABILIDAD"]
["Nuevo flujo de fondos",{"$f":"CONCATENATE(\"AÑO \",B54)","v":"AÑO 2014"},{"$f":"CONCATENATE(\"AÑO \",C54)","v":"AÑO 2015"},{"$f":"CONCATENATE(\"AÑO \",D54)","v":"AÑO 2016"},"AÑO 2017","AÑO 2018","AÑO 2019","AÑO 2020","AÑO 2021","AÑO 2022","AÑO 2023","AÑO 2024"]
["VALORES",{"$f":"B64*-1","v":-12943000},0,0,0,0,0,0,0,0,0,{"$f":"B70","v":386691028.7720719}]
["TVR",{"$f":"IRR(B73:L73)","v":0.40453612726793842}]
[]
[]
[null,"SIGNIFICADO DE LA TASA INTERNA DE RETORNO - FLUJO DE FONDOS SIN FINANCIACIÓN"]
[null,"Períodos","Saldo al incio del período","Rentabilidad ganada durante el período","Saldo inicial más rentabilidad","Retiro al final del período","Saldo al final del período"]
[null,null,"TIR=",{"$f":"B61","v":0.60426399155356436}]
[null,"  1  -  2",{"$f":"B56*-1","v":12943000},{"$f":"C80*$D$79","v":7820988.8426777832},{"$f":"+C80+D80","v":20763988.842677783},{"$f":"C56","v":-5019900.5882172585},{"$f":"E80-F80","v":25783889.430895042}]
[null,"  2  -  3",{"$f":"G80","v":25783889.430895042},{"$f":"C81*$D$79","v":15580275.945288399},{"$f":"+C81+D81","v":41364165.376183443},{"$f":"D56","v":11862737.749804378},{"$f":"E81-F81","v":29501427.626379065}]
[null,"  3  -  4",{"$f":"G81","v":29501427.626379065},{"$f":"C82*$D$79","v":17826650.41404441},{"$f":"+C82+D82","v":47328078.040423475},{"$f":"E56","v":13297160.072951257},{"$f":"E82-F82","v":34030917.967472218}]
[null,"  4  -  5",{"$f":"G82","v":34030917.967472218},{"$f":"C83*$D$79","v":20563658.327256676},{"$f":"+C83+D83","v":54594576.29472889},{"$f":"F56","v":11438354.420320064},{"$f":"E83-F83","v":43156221.874408826}]
[null,"  5  -  6",{"$f":"G83","v":43156221.874408826},{"$f":"C84*$D$79","v":26077750.890201524},{"$f":"+C84+D84","v":69233972.76461035},{"$f":"G56","v":20275451.611057431},{"$f":"E84-F84","v":48958521.15355292}]
[null,"  6  -  7",{"$f":"G84","v":48958521.15355292},{"$f":"C85*$D$79","v":29583871.412805505},{"$f":"+C85+D85","v":78542392.566358417},{"$f":"H56","v":21843048.32646057},{"$f":"E85-F85","v":56699344.239897847}]
[null,"  7  -  8",56699344.239897847,34261372.068870269,90960716.308768123,{"$f":"I56","v":35964636.021388978},54996080.287379146]
[null,"  8  -  9",{"$f":"G86","v":54996080.287379146},33232150.994252019,{"$f":"+C87+D87","v":88228231.281631172},{"$f":"J56","v":36513725.205125123},{"$f":"E87-F87","v":51714506.076506048}]
[null,"  9  -  10",51714506.076506048,31249213.863010604,82963719.939516649,{"$f":"K56","v":45727971.231381357},37235748.708135292]
[null,"  10  -  11",{"$f":"G88","v":37235748.708135292},22500222.142863311,{"$f":"+C89+D89","v":59735970.850998603},{"$f":"L56","v":59735970.850999206},{"$f":"E89-F89","v":-6.0349702835083008E-7}]
[]
[]
[]
[]
[null,null,"i","VP"]
[null,null,0,{"$f":"NPV(C95,$C$56:$L$56)+$B$56","v":238696154.9012711}]
[null,null,0.05,{"$f":"NPV(C96,$C$56:$L$56)+$B$56","v":162541594.3232941}]
[null,null,0.1,112932957.85077246]
[null,null,0.15,79690055.49308002]
[null,null,0.2,56825576.609083548]
[null,null,0.25,40716334.479802832]
[null,null,0.3,29111356.795414768]
[null,null,0.35,20577726.253479343]
[null,null,0.4,14182426.977145482]
[null,null,0.45,9305021.2546351366]
[null,null,0.5,5524744.3940182142]
[null,null,0.55000000000000004,2550953.8145551402]
[null,null,0.6,179403.85346502624]
[null,null,0.65,-1735772.1455667522]
[null,null,0.7,-3300338.7880351674]
[null,null,0.75,-4592083.3428099137]
[null,null,0.8,-5668987.4831202487]
[null,null,0.85,-6574817.7041374501]
[null,null,0.9,-7343004.1690759603]
[null,null,0.95,-7999368.1717730202]
[null,null,1,-8564064.3924770411]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"TASAS DE INTERÉS","VPN INGRESOS","VPN EGRESOS ","B/C-1","VP","TIR"]
[null,0,{"$f":"NPV(B129,$C$56:$L$56)","v":251639154.9012711},{"$f":"$B$56*-1","v":12943000},{"$f":"(C129/D129)-1","v":18.442104218594693},{"$f":"NPV(B129,$C$56:$L$56)+$B$56","v":238696154.9012711},{"$f":"$B$61","v":0.60426399155356436}]
[null,0.05,{"$f":"NPV(B130,$C$56:$L$56)","v":175484594.3232941},{"$f":"$B$56*-1","v":12943000},{"$f":"(C130/D130)-1","v":12.55826271523558},{"$f":"NPV(B130,$C$56:$L$56)+$B$56","v":162541594.3232941},{"$f":"$B$61","v":0.60426399155356436}]
[null,0.1,125875957.85077246,12943000,8.7254081627731175,112932957.85077246,0.60426399155356436]
[null,0.15,92633055.49308002,12943000,6.1570003471436312,79690055.49308002,0.60426399155356436]
[null,0.2,69768576.609083548,12943000,4.3904486293041449,56825576.609083548,0.60426399155356436]
[null,0.25,53659334.479802832,12943000,3.1458189353166057,40716334.479802832,0.60426399155356436]
[null,0.3,42054356.795414768,12943000,2.2491970018863299,29111356.795414768,0.60426399155356436]
[null,0.35,33520726.253479343,12943000,1.5898730011187006,20577726.253479343,0.60426399155356436]
[null,0.4,27125426.977145482,12943000,1.0957604092672089,14182426.977145482,0.60426399155356436]
[null,0.45,22248021.254635137,12943000,0.71892306688056373,9305021.2546351366,0.60426399155356436]
[null,0.5,18467744.394018214,12943000,0.42685191949456969,5524744.3940182142,0.60426399155356436]
[null,0.55000000000000004,15493953.81455514,12943000,0.19709138642935486,2550953.8145551402,0.60426399155356436]
[null,0.6,13122403.853465026,12943000,1.3861071889440302E-2,179403.85346502624,0.60426399155356436]
[null,0.65,11207227.854433248,12943000,-0.1341089504416868,-1735772.1455667522,0.60426399155356436]
[null,0.7,9642661.2119648326,12943000,-0.25499024863131947,-3300338.7880351674,0.60426399155356436]
[null,0.75,8350916.6571900863,12943000,-0.35479281023023357,-4592083.3428099137,0.60426399155356436]
[null,0.8,7274012.5168797513,12943000,-0.4379964060202618,-5668987.4831202487,0.60426399155356436]
[null,0.85,6368182.2958625499,12943000,-0.50798251596518962,-6574817.7041374501,0.60426399155356436]
[null,0.9,5599995.8309240397,12943000,-0.56733401599906985,-7343004.1690759603,0.60426399155356436]
[null,0.95,4943631.8282269798,12943000,-0.61804590680468363,-7999368.1717730202,0.60426399155356436]
[null,1,4378935.6075229589,12943000,-0.66167537607023419,-8564064.3924770411,0.60426399155356436]
[]
[]
[]
[]
[]
[]
[]
[null,"TASAS DE INTERES","CAE INGRESOS","AÑO 2014","AÑO 2024","TVR","TIR"]
[null,0,{"$f":"PMT(B158,11,-C129)","v":22876286.809206463},{"$f":"D129*-1","v":-12943000},{"$f":"FV(B158,11,-C158)","v":251639154.9012711},{"$f":"((E158/(D158*-1))^(1/5))-1","v":0.81029208823620014},0.60426399155356436]
[null,0.05,{"$f":"PMT(B159,11,-C130)","v":21126395.784270957},{"$f":"D130*-1","v":-12943000},{"$f":"FV(B159,11,-C159)","v":300138208.4142046},{"$f":"((E159/(D159*-1))^(1/5))-1","v":0.87524176485194816},0.60426399155356436]
[null,0.1,19380257.97606289,-12943000,359138798.24163765,0.94377268455377972,0.60426399155356436]
[null,0.15,17699303.701331891,-12943000,430965230.36713296,1.015957891175935,0.60426399155356436]
[null,0.2,16123782.766955355,-12943000,518386364.31536061,1.0918171708775457,0.60426399155356436]
[null,0.25,14675444.722717235,-12943000,624676869.24853873,1.1713213104545681,0.60426399155356436]
[null,0.3,13361880.985579045,-12943000,753681526.45443165,1.2543979655409028,0.60426399155356436]
[null,0.35,12181011.888867417,-12943000,909881579.48251772,1.3409383925273115,0.60426399155356436]
[null,0.4,11124888.900947798,-12943000,1098461842.989125,1.4308043500699283,0.60426399155356436]
[null,0.45,10182535.477172405,-12943000,1325376955.9805019,1.5238346168776991,0.60426399155356436]
[null,0.5,9341873.786164239,-12943000,1597414802.8159883,1.6198507496284487,0.60426399155356436]
[null,0.55000000000000004,8590920.0086985771,-12943000,1922254724.272891,1.7186618763297501,0.60426399155356436]
[null,0.6,7918453.5090333978,-12943000,2308517699.4011846,1.8200684607100475,0.60426399155356436]
[null,0.65,7314336.2857950851,-12943000,2765805195.0311089,1.9238650724672772,0.60426399155356436]
[null,0.7,6769615.5211202884,-12943000,3304722851.8609333,2.0298422577458677,0.60426399155356436]
[null,0.75,6276501.2025224688,-12943000,3936884602.2668176,2.1377876313736857,0.60426399155356436]
[null,0.8,5828278.6658302629,-12943000,4674892193.5629463,2.2474863163518322,0.60426399155356436]
[null,0.85,5419192.9548132783,-12943000,5532284419.6187954,2.3587208453634658,0.60426399155356436]
[null,0.9,5044326.5038990611,-12943000,6523449641.7328844,2.471270620330853,0.60426399155356436]
[null,0.95,4699481.8183196252,-12943000,7663494404.6893816,2.584911003906837,0.60426399155356436]
[null,1,4381074.8042046996,-12943000,8968060124.2070198,2.6994120940114157,0.60426399155356436]

{"sheet":"Hoja4","index":4,"n_rows":65,"n_cols":6,"rows_kept":65,"cut":false,"hidden":true,"merged":[[24,1,24,3],[6,1,6,3],[39,1,39,3],[59,1,59,3]]}
["MÉTODO DE LÍNEA RECTA"]
["TIPO DE ACTIVO:","VEHÍCULO"]
["VIDA ÚTIL (AÑOS):",3]
["COSTO DEL ACTIVO",1000000]
["VALOR DE SALVAMENTO:",0.1,"DEL COSTO DEL ACTIVO"]
[]
[null,"TABLA DE DEPRECIACIÓN"]
[null,"AÑOS","DEPRECIACIÓN ANUAL","VALOR EN LIBROS"]
[null,0,null,{"$f":"B4","v":1000000}]
[null,1,{"$f":"+($B$4-($B$4*$B$5))/$B$3","v":300000},{"$f":"+D9-C10","v":700000}]
[null,2,{"$f":"+($B$4-($B$4*$B$5))/$B$3","v":300000},{"$f":"+D10-C11","v":400000},"VALOR COMERCIAL",{"$f":"D9","v":1000000}]
[null,3,{"$f":"+($B$4-($B$4*$B$5))/$B$3","v":300000},{"$f":"+D11-C12","v":100000},"MENOS V L",{"$f":"D11","v":400000}]
[null,null,null,null,"GANANCIA OCASIONAL",{"$f":"F11-F12","v":600000}]
[null,null,null,null,"IMP. RENTA 25%",{"$f":"F13*25%","v":150000}]
[]
[]
["MÉTODO DE LA SUMA DE LOS DÍGITOS"]
["TIPO DE ACTIVO:","VEHÍCULO"]
["VIDA ÚTIL (AÑOS):",3]
["COSTO DEL ACTIVO",1000000]
["VALOR DE SALVAMENTO:",0.1,"DEL COSTO DEL ACTIVO"]
["SUMA DE LOS DÍGITOS",{"$f":"1+2+3","v":6}]
[]
[]
[null,"TABLA DE DEPRECIACIÓN"]
[null,"AÑOS","DEPRECIACIÓN ANUAL","VALOR EN LIBROS"]
[null,0,null,{"$f":"B20","v":1000000}]
[null,1,{"$f":"($B$20*$B$19)/$B$22","v":500000},{"$f":"+D27-C28","v":500000}]
[null,2,{"$f":"($B$20*($B$19-1))/$B$22","v":333333.33333333331},{"$f":"+D28-C29","v":166666.66666666669}]
[null,3,{"$f":"($B$20*($B$19-2))/$B$22","v":166666.66666666666},{"$f":"+D29-C30","v":0}]
[]
[]
["MÉTODO DOBLE SALDO DECLINANTE"]
["TIPO DE ACTIVO:","VEHÍCULO"]
["VIDA ÚTIL (AÑOS):",3]
["COSTO DEL ACTIVO",1000000]
["CÁLCULO DEL FACTOR",{"$f":"1/B35","v":0.33333333333333331},{"$f":"+B37*2","v":0.66666666666666663}]
[]
[]
[null,"TABLA DE DEPRECIACIÓN"]
[null,"AÑOS","DEPRECIACIÓN ANUAL","VALOR EN LIBROS"]
[null,0,null,{"$f":"B36","v":1000000}]
[null,1,{"$f":"+D42*$C$37","v":666666.66666666663},{"$f":"+D42-C43","v":333333.33333333337}]
[null,2,{"$f":"+D43*$C$37","v":222222.22222222225},{"$f":"+D43-C44","v":111111.11111111112}]
[null,3,{"$f":"+D44*$C$37","v":74074.074074074073},{"$f":"+D44-C45","v":37037.037037037051}]
[]
[]
["MÉTODO UNIDADES DE PRODUCCIÓN"]
["TIPO DE ACTIVO:","VEHÍCULO"]
["VIDA ÚTIL (AÑOS):",3]
["COSTO DEL ACTIVO",1000000]
["CAPACIDAD MÁXIMA EN KM",90000,{"$f":"+B52*2","v":180000}]
["COSTO UNITARIO POR KM",{"$f":"+B51/B52","v":11.111111111111111}]
[]
[]
[null,"AÑO1","AÑO2","AÑO3"]
[null,40000,30000,20000]
["KM RECORRIDOS"]
[]
[null,"TABLA DE DEPRECIACIÓN"]
[null,"AÑOS","DEPRECIACIÓN ANUAL","VALOR EN LIBROS"]
[null,0,null,{"$f":"B36","v":1000000}]
[null,1,{"$f":"+B57*B53","v":444444.44444444444},{"$f":"+D62-C63","v":555555.5555555555}]
[null,2,{"$f":"+C57*B53","v":333333.33333333331},{"$f":"+D63-C64","v":222222.22222222219}]
[null,3,{"$f":"+D57*B53","v":222222.22222222222},{"$f":"+D64-C65","v":0}]

{"sheet":"Ppto MP","index":5,"n_rows":39,"n_cols":36,"rows_kept":39,"cut":false,"hidden":false,"merged":[[0,0,0,35],[2,27,2,29],[2,30,2,32],[2,33,2,35],[1,0,1,35],[2,0,3,1],[2,2,3,2],[2,3,2,5],[2,6,2,8],[2,9,2,11],[2,12,2,14],[2,15,2,17],[13,0,13,1],[4,0,4,1],[5,0,5,1],[6,0,6,1],[7,0,7,1],[8,0,8,1],[37,0,37,1],[26,0,26,1],[28,0,28,1],[29,0,29,1],[30,0,30,1],[31,0,31,1],[32,0,32,1],[35,0,35,1],[34,0,34,1],[21,0,21,1],[22,0,22,1],[23,0,23,1],[24,0,24,1],[36,0,36,1],[25,0,25,1],[2,18,2,20],[2,21,2,23],[2,24,2,26],[33,0,33,1],[14,0,14,1],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[9,0,9,1],[10,0,10,1],[11,0,11,1],[12,0,12,1],[20,0,20,1]]}
["Cuadro 5.2"]
["PRESUPUESTO DE MATERIA PRIMA DIRECTA"]
["Nombre genérico",null,"Unidad de medida","A  Ñ  O  1",null,null,"A  Ñ  O  2",null,null,"A  Ñ  O  3",null,null,"A  Ñ  O  4",null,null,"A  Ñ  O  5",null,null,"A  Ñ  O  6",null,null,"A  Ñ  O  7",null,null,"A  Ñ  O  8",null,null,"A  Ñ  O  9",null,null,"A  Ñ  O  10",null,null,"A  Ñ  O  11"]
[null,null,null,"Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total","Cantidad","Costo unitario","Costo total"]
["INSUMOS"]
["Material didáctico",null,"un",{"$f":"300*12","v":3600},10000,{"$f":"D6*E6","v":36000000},{"$f":"+D6*1.05","v":3780},{"$f":"E6","v":10000},{"$f":"G6*H6","v":37800000},{"$f":"+G6*1.05","v":3969},{"$f":"E6","v":10000},{"$f":"J6*K6","v":39690000},{"$f":"+J6*1.05","v":4167.45},{"$f":"E6","v":10000},{"$f":"M6*N6","v":41674500},{"$f":"+M6*1.05","v":4375.8225000000002},{"$f":"E6","v":10000},{"$f":"P6*Q6","v":43758225},{"$f":"+P6*1.05","v":4594.6136250000009},{"$f":"K6","v":10000},{"$f":"S6*T6","v":45946136.250000007},{"$f":"+S6*1.05","v":4824.344306250001},{"$f":"K6","v":10000},{"$f":"V6*W6","v":48243443.062500007},{"$f":"+V6*1.05","v":5065.5615215625012},{"$f":"N6","v":10000},{"$f":"Y6*Z6","v":50655615.21562501},{"$f":"+Y6*1.05","v":5318.8395976406264},{"$f":"Q6","v":10000},{"$f":"AB6*AC6","v":53188395.976406261},{"$f":"+AB6*1.05","v":5584.7815775226582},{"$f":"T6","v":10000},{"$f":"AE6*AF6","v":55847815.775226578},{"$f":"+AE6*1.05","v":5864.0206563987913},{"$f":"W6","v":10000},{"$f":"AH6*AI6","v":58640206.563987911}]
["Refrigerio",null,"un",{"$f":"300*12","v":3600},3000,{"$f":"D7*E7","v":10800000},3780,{"$f":"E7","v":3000},11340000,3969,3000,11907000,4167.45,3000,12502350,4375.8225000000002,{"$f":"E7","v":3000},13127467.5,4594.6136250000009,3000,13783840.875000002,4824.344306250001,{"$f":"K7","v":3000},14473032.918750003,5065.5615215625012,{"$f":"N7","v":3000},15196684.564687504,5318.8395976406264,{"$f":"Q7","v":3000},15956518.792921878,5584.7815775226582,{"$f":"T7","v":3000},16754344.732567975,5864.0206563987913,{"$f":"W7","v":3000},17592061.969196375]
["Lápices",null,"un",{"$f":"500*12","v":6000},1000,6000000,6300,1000,6300000,6615,1000,6615000,6945.75,1000,6945750,7293.0375000000004,1000,7293037.5,7657.6893750000008,1000,7657689.3750000009,8040.5738437500013,1000,8040573.8437500009,8442.6025359375017,1000,8442602.5359375011,8864.7326627343773,1000,8864732.6627343781,9307.9692958710966,1000,9307969.2958710957,9773.3677606646525,1000,9773367.760664653]
["Métodos de planificación",null,"un",{"$f":"1000*12","v":12000},1200,14400000,12600,1200,15120000,13230,1200,15876000,13891.5,1200,16669800,14586.075000000001,1200,17503290,15315.378750000002,1200,18378454.500000004,16081.147687500003,1200,19297377.225000001,16885.205071875003,1200,20262246.086250003,17729.465325468755,1200,21275358.390562505,18615.938591742193,1200,22339126.310090631,19546.735521329305,1200,23456082.625595167]
[null,null,null,null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["SUBTOTAL INSUMOS",null,null,null,null,{"$f":"SUM(F6:F10)","v":67200000},null,null,{"$f":"SUM(I6:I10)","v":70560000},null,null,{"$f":"SUM(L6:L10)","v":74088000},null,null,{"$f":"SUM(O6:O10)","v":77792400},null,null,{"$f":"SUM(R6:R10)","v":81682020},null,null,{"$f":"SUM(U6:U10)","v":85766121.000000015},null,null,{"$f":"SUM(X6:X10)","v":90054427.050000012},null,null,{"$f":"SUM(AA6:AA10)","v":94557148.402500018},null,null,{"$f":"SUM(AD6:AD10)","v":99285005.822625026},null,null,{"$f":"SUM(AG6:AG10)","v":104249256.11375628},null,null,{"$f":"SUM(AJ6:AJ10)","v":109461718.91944411}]
["SABORIZANTES"]
["Sabor mandarina",null,"kg",null,null,{"$f":"D13*E13","v":0},null,{"$f":"E13","v":0},{"$f":"G13*H13","v":0},null,{"$f":"E13","v":0},{"$f":"J13*K13","v":0},null,{"$f":"E13","v":0},{"$f":"M13*N13","v":0},null,{"$f":"E13","v":0},{"$f":"P13*Q13","v":0},null,{"$f":"K13","v":0},{"$f":"S13*T13","v":0},null,{"$f":"K13","v":0},{"$f":"V13*W13","v":0},null,{"$f":"N13","v":0},{"$f":"Y13*Z13","v":0},null,{"$f":"Q13","v":0},{"$f":"AB13*AC13","v":0},null,{"$f":"T13","v":0},{"$f":"AE13*AF13","v":0},null,{"$f":"W13","v":0},{"$f":"AH13*AI13","v":0}]
["Sabor limón",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Sabor Fresa",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Sabor manzana",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Sabor naranja",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Sabor mango",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["SUBTOTAL SABORIZANTES",null,null,null,null,{"$f":"SUM(F13:F18)","v":0},null,null,{"$f":"SUM(I13:I18)","v":0},null,null,{"$f":"SUM(L13:L18)","v":0},null,null,{"$f":"SUM(O13:O18)","v":0},null,null,{"$f":"SUM(R13:R18)","v":0},null,null,{"$f":"SUM(U13:U18)","v":0},null,null,{"$f":"SUM(X13:X18)","v":0},null,null,{"$f":"SUM(AA13:AA18)","v":0},null,null,{"$f":"SUM(AD13:AD18)","v":0},null,null,{"$f":"SUM(AG13:AG18)","v":0},null,null,{"$f":"SUM(AJ13:AJ18)","v":0}]
["COLORANTES"]
["Color limón",null,"kg",null,null,{"$f":"D21*E21","v":0},null,{"$f":"E21","v":0},{"$f":"G21*H21","v":0},null,{"$f":"E21","v":0},{"$f":"J21*K21","v":0},null,{"$f":"E21","v":0},{"$f":"M21*N21","v":0},null,{"$f":"E21","v":0},{"$f":"P21*Q21","v":0},null,{"$f":"K21","v":0},{"$f":"S21*T21","v":0},null,{"$f":"K21","v":0},{"$f":"V21*W21","v":0},null,{"$f":"N21","v":0},{"$f":"Y21*Z21","v":0},null,{"$f":"Q21","v":0},{"$f":"AB21*AC21","v":0},null,{"$f":"T21","v":0},{"$f":"AE21*AF21","v":0},null,{"$f":"W21","v":0},{"$f":"AH21*AI21","v":0}]
["Color Mandarina",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Color Mango",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Color manzana",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Color fresa",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Color Naranja",null,"kg",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["SUBTOTAL COLORANTES",null,null,null,null,{"$f":"SUM(F21:F26)","v":0},null,null,{"$f":"SUM(I21:I26)","v":0},null,null,{"$f":"SUM(L21:L26)","v":0},null,null,{"$f":"SUM(O21:O26)","v":0},null,null,{"$f":"SUM(R21:R26)","v":0},null,null,{"$f":"SUM(U21:U26)","v":0},null,null,{"$f":"SUM(X21:X26)","v":0},null,null,{"$f":"SUM(AA21:AA26)","v":0},null,null,{"$f":"SUM(AD21:AD26)","v":0},null,null,{"$f":"SUM(AG21:AG26)","v":0},null,null,{"$f":"SUM(AJ21:AJ26)","v":0}]
["TOTAL DE INSUMOS",null,null,null,null,{"$f":"+F27+F19+F11","v":67200000},null,null,{"$f":"+I27+I19+I11","v":70560000},null,null,{"$f":"+L27+L19+L11","v":74088000},null,null,{"$f":"+O27+O19+O11","v":77792400},null,null,{"$f":"+R27+R19+R11","v":81682020},null,null,{"$f":"+U27+U19+U11","v":85766121.000000015},null,null,{"$f":"+X27+X19+X11","v":90054427.050000012},null,null,{"$f":"+AA27+AA19+AA11","v":94557148.402500018},null,null,{"$f":"+AD27+AD19+AD11","v":99285005.822625026},null,null,{"$f":"+AG27+AG19+AG11","v":104249256.11375628},null,null,{"$f":"+AJ27+AJ19+AJ11","v":109461718.91944411}]
["EMPAQUES"]
["Envse plástico 473 ml",null,"Unidad",null,null,{"$f":"D30*E30","v":0},null,{"$f":"E30","v":0},{"$f":"H30*G30","v":0},null,{"$f":"E30","v":0},{"$f":"J30*K30","v":0},null,{"$f":"E30","v":0},{"$f":"M30*N30","v":0},null,{"$f":"E30","v":0},{"$f":"P30*Q30","v":0},null,{"$f":"K30","v":0},{"$f":"S30*T30","v":0},null,{"$f":"K30","v":0},{"$f":"V30*W30","v":0},null,{"$f":"N30","v":0},{"$f":"Y30*Z30","v":0},null,{"$f":"Q30","v":0},{"$f":"AB30*AC30","v":0},null,{"$f":"T30","v":0},{"$f":"AE30*AF30","v":0},null,{"$f":"W30","v":0},{"$f":"AH30*AI30","v":0}]
["Bolsa  plástica de 500 ml ",null,"Unidad",null,null,0,null,0,{"$f":"H31*G31","v":0},null,{"$f":"E31","v":0},0,null,0,{"$f":"M31*N31","v":0},null,{"$f":"E31","v":0},{"$f":"P31*Q31","v":0},null,0,{"$f":"S31*T31","v":0},null,{"$f":"K31","v":0},0,null,{"$f":"N31","v":0},0,null,{"$f":"Q31","v":0},0,null,{"$f":"T31","v":0},0,null,{"$f":"W31","v":0},0]
["Bolsa plásticas de 300 ml",null,"Unidad",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Etiqueta ",null,"Unidad",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Empaque Bolsa de 500 ml",null,"Unidad",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Empaque Bolsa de 300 ml",null,"Unidad",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Caja empaque de envase",null,"Unidad",null,null,0,null,0,0,null,0,0,null,0,0,null,0,{"$f":"P36*Q36","v":0},null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["Plástico caja de empaque",null,"Unidad",null,null,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0,null,0,0]
["SUBTOTAL EMPAQUES",null,null,null,null,{"$f":"SUM(F30:F37)","v":0},null,null,{"$f":"SUM(I30:I37)","v":0},null,null,{"$f":"SUM(L30:L37)","v":0},null,null,{"$f":"SUM(O30:O37)","v":0},null,null,{"$f":"SUM(R30:R37)","v":0},null,null,{"$f":"SUM(U30:U37)","v":0},null,null,{"$f":"SUM(X30:X37)","v":0},null,null,{"$f":"SUM(AA30:AA37)","v":0},null,null,{"$f":"SUM(AD30:AD37)","v":0},null,null,{"$f":"SUM(AG30:AG37)","v":0},null,null,{"$f":"SUM(AJ30:AJ37)","v":0}]
["TOTAL DE MATERIA PRIMA DIRECTA",null,null,null,null,{"$f":"+F28+F38","v":67200000},null,null,{"$f":"+I28+I38","v":70560000},null,null,{"$f":"+L28+L38","v":74088000},null,null,{"$f":"+O28+O38","v":77792400},null,null,{"$f":"+R28+R38","v":81682020},null,null,{"$f":"+U28+U38","v":85766121.000000015},null,null,{"$f":"+X28+X38","v":90054427.050000012},null,null,{"$f":"+AA28+AA38","v":94557148.402500018},null,null,{"$f":"+AD28+AD38","v":99285005.822625026},null,null,{"$f":"+AG28+AG38","v":104249256.11375628},null,null,{"$f":"+AJ28+AJ38","v":109461718.91944411}]

{"sheet":"Inversiones","index":6,"n_rows":200,"n_cols":16,"rows_kept":200,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[122,0,122,3],[150,0,150,15],[151,0,152,0],[151,1,151,3],[151,4,151,6],[151,7,151,9],[3,0,3,4],[29,0,29,4],[30,0,31,0],[30,1,31,1],[58,0,58,1],[59,0,60,0],[194,0,194,7],[88,0,88,13],[95,0,95,13],[106,0,106,3],[107,0,108,0],[107,1,107,3],[138,1,138,3],[151,13,151,15],[151,10,151,12],[123,0,124,0],[123,1,123,3],[137,0,137,3],[138,0,139,0],[117,0,117,13],[172,0,172,10]]}
["Cuadro 5.1"]
["COSTO MAQUINARIA Y EQUIPO DE OFICINA"]
[]
["Maquinaria y equipo"]
["Artículo","Cant.","Valor unitario","Valor total","Vida útil"]
["Filtros Ametek 1/2 pulgada.",0,134560,{"$f":"B6*C6","v":0},10]
["Planta de Ozono.",0,765000,{"$f":"B7*C7","v":0},10]
["Esterilizador de bolsa y envase en acero quirúrgico.",0,550000,0,10]
["Tanque de almacenamiento con tapa.",0,1000000,0,10]
["Aspa con bandeja de acero inoxidable.",0,200000,0,10]
["Mesa con bandeja de acero de 0,75 m por 1,20 m.",0,330000,0,10]
["Selladora de bolsa plástica.",0,200000,0,10]
["Mesa para selladora.",0,30000,0,10]
["Motor de HP.",0,160000,0,10]
["Brazo del motor.",0,30000,0,10]
["Estibas de madera.",0,12000,0,10]
["Un metro de tubería en acero inoxidable 1/2\".",0,133334,0,10]
["Balanza electrónica.",0,200000,0,10]
["Estantería metálica.",0,200000,0,10]
["Canastillas plásticas.",0,13000,0,10]
["Escalera metálica portátil.",0,50000,0,10]
["Dispensador de líquidos.",0,300000,0,10]
["Móvil (carreta)",0,140000,0,10]
["Selladora de tapa.",0,300000,0,10]
["Secador de manos infrarojo",1,180000,180000,10]
["Dispensador de jabón ",1,40000,40000,10]
["Casillero de cuatro cajones.",1,130000,130000,10]
["TOTAL",null,null,{"$f":"SUM(D6:D27)","v":350000}]
[]
["Equipo de oficina"]
["Detalle","Cantidad","Valor","Valor ","Vida "]
[null,null," unitario","total","útil"]
["Escritorio con archivador y portateclado",4,200000,{"$f":"B33*C33","v":800000},5]
["Silla de escritorio graduable",4,120000,{"$f":"B34*C34","v":480000},5]
["Silla interlocutora",8,100000,800000,5]
["Módulo de recepción",1,1200000,{"$f":"B36*C36","v":1200000},5]
["Sofá",1,800000,800000,5]
["Centro de mesa",1,150000,150000,5]
["Biblioteca de madera",1,260000,260000,5]
["Archivador con ruedas",1,240000,240000,5]
["Tableros acrílicos 2 mts x 120 cms",2,120000,240000,5]
["Computador",4,1800000,7200000,5]
["Software Office y Windows.",1,1200000,{"$f":"B43*C43","v":1200000},5]
["Tablet",2,1200000,{"$f":"B44*C44","v":2400000},5]
["Disco duro externo 1000 Gb",1,180000,{"$f":"B45*C45","v":180000},5]
["Multifuncional HP",1,310000,310000,5]
["Calculadora casio",1,32000,32000,5]
["Teléfono inalámbrico Panasonic",1,80000,80000,5]
["Celular Nokia",2,120000,240000,5]
["Papelera en madera",3,25000,75000,5]
["Caneca en acero",2,40000,80000,5]
["Regulador de voltaje - estabilizador",1,80000,80000,5]
["Grapadora",2,13000,26000,5]
["Saca-ganchos",2,2500,5000,5]
["Extintor ABC multirpopósito 10 lb",1,55000,55000,5]
["Cafetera",1,50000,50000,5]
["TOTAL",null,null,{"$f":"SUM(D33:D56)","v":16983000}]
[]
["Cuadro 8.3 GASTOS PREOPERATIVOS"]
["CONCEPTO","VALOR"]
[null,"(En pesos)"]
["GASTOS PRE-OPERATIVOS"]
["Estudio de factibilidad",3000000]
["Contratación de personal",300000]
["Capacitación de personal",600000]
["Experimentación del producto",0]
["Análisis de laboratorio",0]
["SUBTOTAL GASTOS PRE-OPERATIVOS",{"$f":"SUM(B63:B67)","v":3900000}]
["ADECUACIÓN LOCATIVAS"]
["Instalaciones eléctricas",200000]
["Construcción de plancha para tanque de almacenamiento.",0]
["Instalaciones para recepción del agua.",0]
["Adecuación de oficina",900000]
["Red telefónica.",120000]
["Curvatura de unión del piso con la pared.",0]
["SUBTOTAL ADECUACIONES LOCATIVAS",{"$f":"SUM(B70:B75)","v":1220000}]
["GASTOS DE CONSTITUCIÓN"]
["Escritura pública. ",0]
["Registro en la oficina de instrumentos públicos.",0]
["Permiso de uso de suelos.",0]
["Registro sanitario (INVIMA)",0]
["Instalaciones de equipos de producción",0]
["Registro ante la Cámara de comercio",290000]
["Registro Único Tributario - RUT",120000]
["Registro Único Empresarial - RUE",80000]
["SUBTOTAL GASTOS DE CONSTITUCIÓN",{"$f":"SUM(B78:B85)","v":490000}]
["TOTAL INVERSIÓN EN ACTIVOS INTANGIBLES",{"$f":"B86+B76+B68","v":5610000}]
[]
["NÓMINA ÁREA OPERACIONAL"]
["Cargo","Salario básico","Auxilio de transporte","Total devengado","Cesantías","Intereses sobre cesantías","Prima de servicios","Vacaciones","Aportes parafiscales","Pensión","Salud","Riesgos profesionales","Total nómina mensual","Total nómina anual"]
["Factores",null,null,null,8.3299999999999999E-2,0.01,8.3299999999999999E-2,4.1700000000000001E-2,0.09,0.1013,0.08,0.01]
["Profesional de apoyo",1800000,0,{"$f":"B92+C92","v":1800000},{"$f":"D92*$E$91","v":149940},{"$f":"E92*$F$91","v":1499.4},{"$f":"D92*$G$91","v":149940},{"$f":"B92*$H$91","v":75060},{"$f":"B92*$I$91","v":162000},{"$f":"B92*$J$91","v":182340},{"$f":"B92*$K$91","v":144000},{"$f":"B92*$L$91","v":18000},{"$f":"SUM(D92:L92)","v":2682779.4},{"$f":"M92*12","v":32193352.799999997}]
[null,0,0,{"$f":"B93+C93","v":0},{"$f":"D93*$E$91","v":0},{"$f":"E93*$F$91","v":0},{"$f":"D93*$G$91","v":0},{"$f":"B93*$H$91","v":0},{"$f":"B93*$I$91","v":0},{"$f":"B93*$J$91","v":0},{"$f":"B93*$K$91","v":0},{"$f":"B93*$L$91","v":0},{"$f":"SUM(D93:L93)","v":0},{"$f":"M93*12","v":0}]
["TOTALES",{"$f":"SUM(B92:B93)","v":1800000},0,1800000,149940,1499.4,149940,75060,162000,182340,144000,18000,2682779.4,32193352.799999997]
[]
["NÓMINA ÁREA DE ADMINISTRACIÓN"]
["Cargo","Salario básico","Auxilio de transporte","Total devengado","Cesantías","Intereses sobre cesantías","Prima de servicios","Vacaciones","Aportes parafiscales","Pensión","Salud","Riesgos profesionales","Total nómina mensual","Total nómina anual"]
["Factores",null,null,null,8.3299999999999999E-2,0.01,8.3299999999999999E-2,4.1700000000000001E-2,0.05,0.1013,0.08,0.01]
["Gerente Proyecto",2500000,0,{"$f":"B99+C99","v":2500000},{"$f":"D99*$E$98","v":208250},{"$f":"E99*$F$98","v":2082.5},{"$f":"D99*$G$91","v":208250},{"$f":"D99*$H$91","v":104250},{"$f":"B99*$I$91","v":225000},{"$f":"B99*$J$91","v":253250},{"$f":"B99*$K$91","v":200000},{"$f":"B99*$L$91","v":25000},{"$f":"SUM(D99:L99)","v":3726082.5},{"$f":"M99*12","v":44712990}]
["Dirección Administrativa y Financiera",2100000,0,2100000,174930,1749.3,174930,87570,189000,212730,168000,21000,3129909.3,37558911.599999994]
["Coordinador Programa",2100000,0,2100000,174930,1749.3,174930,87570,189000,212730,168000,21000,3129909.3,37558911.599999994]
["Asistente Logístico",800000,26400,826400,68839.12,688.39119999999991,68839.12,34460.879999999997,72000,81040,64000,8000,1224267.5112000001,14691210.134400001]
["Técnico en Sistemas",900000,26400,926400,77169.119999999995,771.69119999999998,77169.119999999995,38630.879999999997,81000,91170,72000,9000,1373310.8111999999,16479729.734399999]
["Psicóloga",1800000,0,1800000,149940,1499.4,149940,{"$f":"B104*$H$91","v":75060},162000,182340,144000,18000,2682779.4,32193352.799999997]
["TOTALES",{"$f":"SUM(B99:B104)","v":10200000},52800,10252800,854058.24,8540.5824000000011,854058.24,427541.76000000001,918000,1033260,816000,102000,15266258.8224,183195105.86879998]
[]
["GASTOS DE DOTACIÓN AREA ADMINISTRATIVA"]
["DOTACIÓN","A Ñ O 1"]
[null,"Cantidad","Valor unitario","Costos total"]
["Overoles",0,26000,{"$f":"B110*C110","v":0}]
["Tapabocas",0,2000,0]
["Guantes",0,1200,0]
["Uniforme sec.",2,50000,100000]
["Zapatos sec.",2,40000,80000]
["Botas",0,18500,0]
["TOTAL ",null,null,{"$f":"SUM(D110:D115)","v":180000}]
[]
["NÓMINA ÁREA DE VENTAS"]
["Cargo","Salario básico","Auxilio de transporte","Total devengado","Cesantías","Intereses sobre cesantías","Prima de servicios","Vacaciones","Aportes parafiscales","Pensión","Salud","Riesgos profesionales","Total nómina mensual","Total nómina anual"]
["Factores",null,null,null,8.3299999999999999E-2,0.01,8.3299999999999999E-2,4.1700000000000001E-2,0.09,0.1013,0.08,0.01]
["Subgerente de ventas",0,null,{"$f":"B121+C121","v":0},{"$f":"D121*$E$98","v":0},{"$f":"E121*$F$98","v":0},{"$f":"D121*$G$91","v":0},{"$f":"B121*$H$91","v":0},{"$f":"B121*$I$91","v":0},{"$f":"B121*$J$91","v":0},{"$f":"B121*$K$91","v":0},{"$f":"B121*$L$91","v":0},{"$f":"SUM(D121:L121)","v":0},{"$f":"M121*12","v":0}]
[]
["GASTOS DE DOTACIÓN AREA  DE VENTAS"]
["DOTACIÓN","A Ñ O 1"]
[null,"Cantidad","Valor unitario","Costos total"]
["Overoles",0,0,{"$f":"B126*C126","v":0}]
["Botas",0,0,{"$f":"B127*C127","v":0}]
["TOTAL ",null,null,{"$f":"SUM(D126:D127)","v":0}]
[]
["COMISIÓN EN VENTAS"]
["AÑOS",0.02]
[2,0]
[3,0]
[4,0]
[5,0]
[6,0]
[]
["GASTOS DE PUBLICIDAD"]
["MEDIO","A Ñ O  1"]
[null,"COSTO UNITARIO","CANTIDAD","COSTO TOTAL"]
["Tarjetas de presentación x 1000",45000,20,{"$f":"B141*C141","v":900000}]
["Carpetas institucionales x 100",50000,30,{"$f":"B142*C142","v":1500000}]
["Hojas membreteadas x 500",20000,80,1600000]
["Pendones 150x250",150000,2,300000]
["Pendones 80x120",100000,2,200000]
["Aviso al exterior",500000,1,500000]
["Grabación de jingle",80000,4,320000]
["Flayers (dos tintas) x 1000",30000,40,{"$f":"B148*C148","v":1200000}]
["TOTAL",null,null,{"$f":"SUM(D141:D148)","v":6520000}]
[]
["PRESUPUESTO DE PROMOCIÓN EN VENTAS"]
["Concepto","Año 2",null,null,"Año 3",null,null,"Año 4",null,null,"Año 5",null,null,"Año 6"]
[null,"Cantidad","Valor Unitario","Costo total","Cantidad","Valor Unitario","Costo total","Cantidad","Valor Unitario","Costo total","Cantidad","Valor Unitario","Costo total","Cantidad","Valor Unitario","Costo total"]
[]
["Maletines"]
["Biscicleteros"]
["Bolso Canguro"]
["Llaveros"]
["PROMOCIÓN BEBIDAS"]
["Envase 473 ml"]
["Bolsa 500 ml"]
["Bolsa 300 ml"]
["DEGUSTACIÓN"]
["Bolsa 300 ml"]
["OBSEQUIO DE BEBIDAS"]
["Envase 473 ml"]
["Bolsa 500 ml"]
["Bolsa 300 ml"]
["TOTAL ",null,null,{"$f":"SUM(D155:D168)","v":0},null,null,{"$f":"SUM(G155:G168)","v":0},null,null,{"$f":"SUM(J155:J168)","v":0},null,null,{"$f":"SUM(M155:M168)","v":0},null,null,{"$f":"SUM(P155:P168)","v":0}]
[]
[]
[]
["RESUMEN DE GASTOS DE ADMINISTRACIÓN, VENTAS Y DISTRIBUCIÓN"]
["GASTOS DE ADMINISTRACIÓN","AÑO 2","AÑO 3","AÑO 4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10","AÑO 11"]
["Nómina",{"$f":"$N$94","v":32193352.799999997},{"$f":"$N$94","v":32193352.799999997},32193352.799999997,32193352.799999997,32193352.799999997,32193352.799999997,32193352.799999997,32193352.799999997,32193352.799999997,32193352.799999997]
["Gastos de dotación",{"$f":"$D$116","v":180000},180000,180000,180000,180000,180000,180000,180000,180000,180000]
["Honorarios",{"$f":"550000*12","v":6600000},{"$f":"550000*12","v":6600000},6600000,6600000,6600000,6600000,6600000,6600000,6600000,6600000]
["Gastos de arrendamiento ",{"$f":"165000*12","v":1980000},{"$f":"165000*12","v":1980000},1980000,1980000,1980000,1980000,1980000,1980000,1980000,1980000]
["Impuesto de cámara de comercio",230000,230000,230000,230000,230000,230001,230002,230002,230002,230002]
["Servicio públicos ",{"$f":"260000*12","v":3120000},{"$f":"260000*12","v":3120000},3120000,3120000,3120000,3120000,3120000,3120000,3120000,3120000]
["Útiles y papelería",{"$f":"300000*12","v":3600000},{"$f":"300000*12","v":3600000},3600000,3600000,3600000,3600000,3600000,3600000,3600000,3600000]
["Servicio de alarma",{"$f":"70000*12","v":840000},{"$f":"70000*12","v":840000},840000,840000,840000,840000,840000,840000,840000,840000]
["Implementos de aseo",{"$f":"80000*12","v":960000},{"$f":"80000*12","v":960000},960000,960000,960000,960000,960000,960000,960000,960000]
["SUBTOTAL GASTOS DE ADMINISTRACIÓN",{"$f":"SUM(B175:B183)","v":49703352.799999997},49703352.799999997,49703352.799999997,49703352.799999997,49703352.799999997,49703353.799999997,49703354.799999997,{"$f":"SUM(I175:I183)","v":49703354.799999997},49703354.799999997,49703354.799999997]
["GASTOS EN VENTAS"]
["Nómina",{"$f":"$N$121","v":0},0,0,0,0,0,0,0,0,0]
["Comisión de dos vendedores",{"$f":"B132","v":0},{"$f":"B133","v":0},{"$f":"B134","v":0},{"$f":"B135","v":0},{"$f":"B136","v":0},{"$f":"C136","v":0},{"$f":"D136","v":0},{"$f":"E136","v":0},0,0]
["Gastos de publicidad",{"$f":"D149","v":6520000},{"$f":"B188","v":6520000},6520000,6520000,6520000,6520000,6520000,{"$f":"H188","v":6520000},{"$f":"I188","v":6520000},{"$f":"J188","v":6520000}]
["Gastos de promoción",{"$f":"D169","v":0},{"$f":"G169","v":0},{"$f":"J169","v":0},{"$f":"M169","v":0},{"$f":"P169","v":0},{"$f":"Q169","v":0},{"$f":"R169","v":0},{"$f":"S169","v":0},0,0]
["SUBTOTAL GASTOS EN VENTAS",{"$f":"SUM(B186:B189)","v":6520000},6520000,6520000,6520000,6520000,6520000,6520000,{"$f":"SUM(I186:I189)","v":6520000},6520000,6520000]
["GASTOS GENERALES DE DISTRIBUCIÓN"]
["Imprevistos (gastos de transporte)",{"$f":"400000*12","v":4800000},{"$f":"400000*12","v":4800000},4800000,4800000,4800000,4800000,4800000,4800000,4800000,4800000]
["SUBTOTAL GASTOS DE DISTRIBUCIÓN",{"$f":"B192","v":4800000},4800000,4800000,4800000,4800000,4800000,4800000,{"$f":"I192","v":4800000},4800000,4800000]
[]
["GASTOS GENERALES DE FABRICACION"]
["DETALLE","AÑO 2","AÑO 3","AÑO 4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10","AÑO 11"]
["Servicio Público",0,0,0,0,0,0,0,0,0,0]
["Mantenimiento",0,0,0,0,0,0,0,0,0,0]
["Gastos de Arrendamientos",0,0,0,0,0,0,0,0,0,0]
["SUBTOTAL COSTOS INDIRECTOS",{"$f":"SUM(B197:B199)","v":0},0,0,0,0,0,0,{"$f":"SUM(I197:I199)","v":0},0,0]

{"sheet":"Hoja7","index":7,"n_rows":49,"n_cols":7,"rows_kept":49,"cut":false,"hidden":false,"merged":[[3,1,3,20]]}
[null,"VARIACIÓN","PRECIO PROMEDIO","TIR","VP","B/C","TIO"]
[null,1.0000000000000007,{"$f":"Variables!B22","v":34419.970000000023},{"$f":"Indicadores!B61","v":0.60426399155356436},{"$f":"+Indicadores!B60","v":53150653.122874379},{"$f":"+Indicadores!B65","v":4.1065172775148246},{"$f":"+Indicadores!C48","v":0.21}]
[]
[null,"ANALISIS DE SENSIBILIDAD - VARIACION PRECIO UNITARIO DE VENTAS"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VARIACION","%DE VARIACION","PRECIO PROMEDIO","TIR","VPN","B/C","TIO"]
[0.78000000000000047,0.21999999999999953,20941.112400000013,-0.21575269652986562,-79688371.438274309,-3.3491504201837849,0.21]
[0.79000000000000048,0.20999999999999952,21481.506200000011,-0.17928588662527545,-73586788.867313027,-3.1407965073027211,0.21]
[0.80000000000000049,0.19999999999999951,22028.784000000014,-0.14487865544895184,-67485206.296351731,-2.921974584077077,0.21]
[0.8100000000000005,0.1899999999999995,22582.945800000016,-0.11196936305203853,-61383623.725390427,-2.7031526608514334,0.21]
[0.82000000000000051,0.17999999999999949,23143.991600000016,-8.0113276230413977E-2,-55282041.154429123,-2.4843307376257893,0.21]
[0.83000000000000052,0.16999999999999948,23711.921400000017,-4.8945820971714293E-2,-49180458.583467826,-2.2655088144001478,0.21]
[0.84000000000000052,0.15999999999999948,24286.735200000014,-1.8157177908829092E-2,-43078876.01250653,-2.0466868911745033,0.21]
[0.85000000000000053,0.14999999999999947,24868.433000000015,1.2525754436878422E-2,-36977293.441545159,-1.8278649679488583,0.21]
[0.86000000000000054,0.13999999999999946,25457.006200000014,4.3352574169853719E-2,-30875710.870583862,-1.5839402937599441,0.21]
[0.87000000000000055,0.12999999999999945,26052.471900000015,7.4559396451518545E-2,-24774128.299622554,-1.285361923295165,0.21]
[0.88000000000000056,0.11999999999999944,26654.821600000017,0.10637671938145399,-18672545.728661258,-0.98678355283038599,0.21]
[0.89000000000000057,0.10999999999999943,27264.055300000018,0.13903578605780953,-12570963.157699954,-0.68820518236560724,0.21]
[0.90000000000000058,9.9999999999999423E-2,27880.173000000021,0.1727738205596161,-6469380.58673866,-0.38486609063189914,0.21]
[0.91000000000000059,8.9999999999999414E-2,28503.174700000018,0.20783830450134921,-367798.01577731967,-1.0162822775402369E-2,0.21]
[0.9200000000000006,7.9999999999999405E-2,29133.060400000017,0.24449027737406515,5733784.5551839806,0.44300274705894926,0.21]
[0.9300000000000006,6.9999999999999396E-2,29769.830100000017,0.28300646862311396,11835367.126145281,0.91442224570387709,0.21]
[0.94000000000000061,5.9999999999999387E-2,30413.48380000002,0.32367989765876848,17936949.697106577,1.3858417443488045,0.21]
[0.95000000000000062,4.9999999999999378E-2,31064.021500000021,0.36681842424960309,24038532.268067881,1.8572612429937325,0.21]
[0.96000000000000063,3.9999999999999369E-2,31721.44320000002,0.41274063631720526,30140114.839029215,2.3286807416386628,0.21]
[0.97000000000000064,2.9999999999999361E-2,32385.748900000024,0.46032585305082763,36132682.269494615,2.7916775298999164,0.21]
[0.98000000000000065,1.9999999999999352E-2,33056.938600000023,0.50618211148068148,41805339.220621206,3.2299574457715527,0.21]
[0.99000000000000066,9.9999999999993427E-3,33735.012300000017,0.55413980082298164,47477996.171747804,3.6682373616431896,0.21]
[1.0000000000000007,-6.6613381477509392E-16,34419.970000000023,0.60426399155356436,53150653.122874379,4.1065172775148246,0.21]

{"sheet":"Hoja8","index":8,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[[3,1,3,15]]}
[null,"VARIAICON","UNIDAD PROMEDIO","TIR","VP","B/C","TIO"]
[null,1.0000000000000007,{"$f":"+Variables!B13","v":7800},{"$f":"+Indicadores!B61","v":0.60426399155356436},{"$f":"+Indicadores!B60","v":53150653.122874379},{"$f":"+Indicadores!B65","v":4.1065172775148246},{"$f":"+Indicadores!C48","v":0.21}]
[]
[null,"ANALISIS DE SENSIBILIDAD - VARIACION EN UNIDADES DE PRODUCCION"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["VARIACION","%DE VARIACION","PRODUCCION PROIMEDIO EN UNIDADES","TIR","VPN","B/C","TIO"]
[0.75000000000000044]
[0.76000000000000045]
[0.77000000000000046]
[0.78000000000000047]
[0.79000000000000048]
[0.80000000000000049]
[0.8100000000000005]
[0.82000000000000051]
[0.83000000000000052]
[0.84000000000000052]
[0.85000000000000053]
[0.86000000000000054]
[0.87000000000000055]
[0.88000000000000056]
[0.89000000000000057]
[0.90000000000000058]
[0.91000000000000059]
[0.9200000000000006]
[0.9300000000000006]
[0.94000000000000061]
[0.95000000000000062]
[0.96000000000000063]
[0.97000000000000064]
[0.98000000000000065]
[0.99000000000000066]
[1.0000000000000007]

{"sheet":"cargos","index":9,"n_rows":34,"n_cols":4,"rows_kept":34,"cut":false,"hidden":false,"merged":[[1,0,1,3],[14,0,14,2],[25,0,25,3]]}
[]
["PERSONAL TÉCNICO REQUERIDO\nDescripción de cargos"]
["Cargo","Funciones","Herramientas","Requisitos"]
["Director General","Planificar, organizar, coordinar, controlar, liderar, motivar, comunicar.","Capacidad de integrar los esfuerzos internos y externos, para ejecutar las actividades con éxito.","Profesional universitario con conocimientos y habilidades en la ejecución de proyectos."]
["Coordinador General","Coordinar y supervisar actividades, recursos, equipos de información y presentar informes a la gerencia.","Capacidad administrativa.\nHabilidades de comunicación.","Profesional universitario con conocimientos en programación del proyecto inicial.\nConocimiento paquete informático (Internet, Excel, Word, Power Point y Acces), estados financieros y administrativos de la empresa"]
["Área de Logística","Coordinar la planificación de actividades","Capacidad de organización y comunicación.","Técnico o profesional universitario con conocimientos de administración e informática."]
["Área de Personal","Planificar plantillas, seleccionar y formar el personal.  \nDescribir las funciones.","Capacidad administrativa de personal.\nHabilidades de comunicación.","Profesional universitario con conocimientos en administración, salud ocupacional e informática."]
["Comunicaciones","Gestión de canales de publicación.","Capacidad de relaciones sociales.","Técnico o profesional universitario con conocimientos en marketing y web."]
["Asesor","Recopilar y analizar la información.\nIdentificar las necesidades. \nDirigir y supervisar las actividades.","Capacidad de implementación de programas y proyectos.\nCapacidad de comunicación.","Profesional universitario con conocimientos en salud y comercialización."]
["Profesional de apoyo","Diseñar estrategias, orientar, promover la participación, innovar y motivar al grupo.","Capacidad de liderazgo.\nConocimientos en el ámbito social.\nHabilidades de comunicación. ","Profesional universitario en afines a la psicología y/o trabajador social.  Conocimiento paquete informático."]
[]
[]
[]
[]
["PERSONAL PARA LA EJECUCIÓN DEL PROYECTO\nDescripción de cargos"]
["Cargo","Funciones","Requisitos"]
["Socios","Tomar decisiones, máxima autoridad de la empresa.","Socios accionistas que aporten capital a la empresa."]
["Gerente General","Planificar, organizar, coordinar, controlar, liderar, motivar, comunicar.","Profesional universitario con conocimientos y habilidades en la ejecución de proyectos, y administración de empresas o afines."]
["Asesor Logístico","Planificar las actividades.\nGestión directa con organizaciones y/o instituciones.","Técnico o profesional universitario con conocimientos de administración e informática."]
["Asesor Financiero","Planificar plantillas, seleccionar y formar el personal.  Describir las funciones.\nContrato de arrendamientos.","Profesional universitario con conocimientos en administración, salud ocupacional e informática."]
["Asesor Técnico","Implementar la instalación de equipos.\nCapacitar personal.","Técnico o profesional universitario con conocimientos informáticos."]
[]
[]
[]
[]
["PERSONAL ADMINISTRATIVO OPERACIÓN DEL PROYECTO"]
["Cargo","Funciones","Herramientas","Requisitos"]
["Gerente Proyecto","1. Planear, diseñar y organizar el proyecto\n2. Dirigir y controlar actividades del personal\n3. Ejercer el liderazgo y velar por el logro de objetivos\n4. Toma de decisiones","1. Computador\n2. Celular","1. Título Universitario.\n2. Tres años de experiencia"]
["Dirección Administrativa y Financiera","1. Análisis de los aspectos financieros, cuentas y flujos de efectivo\n2. Control de costos\n3. Negociación con clientes y proveedores","1. Computador","1. Título Universitario.\n2. Tres años de experiencia"]
["Coordinador Programa","1. Planear, organizar y coordinar las actividades\n2. Apoyar y realizar seguimiento a los procesos\n3. Evaluar cada uno de los procesos de actividades\n4. Presentar informe de seguimiento","1. Computador","1. Título Universitario.\n2. Dos años de experiencia"]
["Asistente Logístico","1. Coordinar la logística para el desarrollo de las actividades\n2. Establecer contacto con Instituciones\n3. Seguimiento de las actividades realizadas","1. Computador\n2. Teléfono\n3. Formatos\n4. Expresarse claramente de forma escrita y verbal","1. Título Universitario o Tecnológico\n2. Experiencia en manejo de información y datos, al menos 1 año."]
["Profesional de Apoyo SSR","1. Evaluar las necesidades del cliente y determinar los recursos necesarios\n2. Acompañar y evaluar a los integrantes\n3. Establecer canales de comunicación\n5. Desarrollar programas de prevención","1. Conocimiento de las determinantes de salud\n2. Expresarse claramente y facilidad de comunicación","1. Título Universitario\n2. Conocimiento en salud sexual y reproductiva\n3. De uno a dos años de experiencia"]
["Profesional en Psicóloga","1. Intervención ante las necesidades del adolescente y demás integrantes\n2. Evaluar y valorar las capacidades personales, grupales e institucionales\n3. Proponer o realizar intervenciones al desarrollo de las actividades","1. Conocimiento de las determinantes de salud\n2. Expresarse claramente y facilidad de comunicación","1. Título Universitario en Psicología\n2. Conocimiento en salud sexual y reproductiva\n3. Dos años de experiencia"]
["Técnico en Sistemas","1. Administración de sistemas y soporte\n2. Instalación, configuración y mantenimiento de servicios como correo electrónico, Web, FTP","1. Computador\n2. Herramientas de HW y SW","1. Título Universitario reciente\n2. Conocimiento en redes y desarrollo web\n3. Mínimo 1 año de experiencia"]

{"sheet":"costo personal","index":10,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,0,28,4],[0,0,0,4],[1,0,1,4],[15,0,15,4],[16,0,16,4],[27,0,27,4]]}
["PERSONAL TÉCNICO REQUERIDO"]
["COSTOS"]
["Cargo","Nº personas","Costo mensual","Total mensual","Total anual"]
["Director General",1,2500000,{"$f":"+C4*B4","v":2500000},{"$f":"+D4*12","v":30000000}]
["Coordinador General",1,2100000,2100000,{"$f":"+D5*12","v":25200000}]
["Área de Personal",1,2100000,2100000,25200000]
["Área de LogístIca",1,800000,800000,9600000]
["Profesional de Apoyo",2,1800000,3600000,43200000]
["Comunicaciones",1,900000,900000,10800000]
["Asesor",2,1800000,3600000,43200000]
["TOTAL",null,null,{"$f":"SUM(D4:D10)","v":15600000},{"$f":"SUM(E4:E10)","v":187200000}]
[]
[]
[]
[]
["PERSONAL EJECUCIÓN DEL PROYECTO"]
["COSTOS"]
["Cargo","Nº personas","Costo mensual","Total mensual","Total anual"]
["Director General",1,2500000,{"$f":"+C19*B19","v":2500000},{"$f":"+D19*12","v":30000000}]
["Asesor Logístico",1,800000,800000,{"$f":"+D20*12","v":9600000}]
["Asesor Financiero",1,2100000,2100000,25200000]
["Asesor Técnico",1,900000,900000,10800000]
["TOTAL",null,null,{"$f":"SUM(D19:D22)","v":6300000},{"$f":"SUM(E19:E22)","v":75600000}]
[]
[]
[]
[]
["PERSONAL ADMINISTRATIVO REQUERIDO"]
["COSTOS"]
["Cargo","Nº personas","Costo mensual","Total mensual","Total anual"]
["Gerente Proyecto",1,2500000,2500000,30000000]
["Dirección Administrativa y Financiera",1,2100000,2100000,25200000]
["Coordinador Programa",1,2100000,2100000,25200000]
["Asistente Logístico",1,815000,815000,9780000]
["Profesional de Apoyo",2,1810000,3620000,43440000]
["Técnico en Sistemas",1,900000,900000,10800000]
["Psicóloga",2,1810000,3620000,43440000]
["TOTAL",null,null,15655000,187860000]

{"sheet":"arrendamiento","index":11,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4]]}
["INSTALACIONES REQUERIDAS"]
["COSTOS"]
["Local","Unidad","Cantidad","Costo unitario","Costo total"]
["Arrendamiento",1,12,{"$f":"Inversiones!B178","v":1980000},{"$f":"+D4*12","v":23760000}]
["TOTAL",null,null,{"$f":"SUM(D4:D4)","v":1980000},{"$f":"SUM(E4:E4)","v":23760000}]

{"sheet":"actividades","index":12,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["ACTIVIDADES, DURACIÓN Y PREDECESORAS"]
["N°","Actividad","Duración","Predecesoras"]
[1,"EMPRESA DE CONSULTORÍA EN SALUD SEXUAL Y REPRODUCTIVA","238 días"]
[2,"Establecimiento de la organización encargada de la ejecución del proyecto","120 días"]
[3,"Convocatorias","30 días"]
[4,"Entrevista y selección de personal","30 días","3"]
[5,"Contratación de personal","30 días","4"]
[6,"Capacitación","30 días","5"]
[7,"Elección de la tecnología","75 días"]
[8,"Cotizaciones de equipos y enseres","30 días","3"]
[9,"Cotización publicidad","20 días","8"]
[10,"Selección proveedor","5 días","8;9"]
[11,"Estudio y decisión final","20 días","10"]
[12,"Estudios técnicos detallados de equipos","65 días"]
[13,"Presupuesto","5 días","8"]
[14,"Identificación de recursos","5 días","11;13"]
[15,"Diseño de adecuaciones","5 días","14"]
[16,"Instalación de muebles y redes","10 días","15"]
[17,"Evaluación de propuestas y adjudicación de contratos","23 días"]
[18,"Contratos institucionales","3 días","11"]
[19,"Contratos de equipos","3 días","16"]
[20,"Financiación del proyecto","58 días"]
[21,"Solicitud crédito bancario","20 días","11;15"]
[22,"Donaciones institucionales","30 días","21"]
[23,"Aportes socios","8 días","21;22"]
[24,"Arreglos sobre suministros","38 días"]
[25,"Suministro de material","10 días","23"]
[26,"Generar publicidad","20 días","25"]
[27,"Entrega volantes","8 días","26"]
[28,"Redes sociales","5 días","26"]
[29,"Comercialización previa a la producción","65 días"]
[30,"Identificación de recursos","15 días","23"]
[31,"Conocer las necesidades del usuario","20 días","30"]
[32,"Búsqueda de instituciones","30 días","31"]
[33,"Aprobaciones requeridas","20 días"]
[34,"Permiso de la Alcaldía","20 días","11"]

{"sheet":"predecesoras","index":13,"n_rows":36,"n_cols":36,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,35]]}
["MATRIZ DE PREDECESORAS"]
["N°","Actividad / Predecesoras",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34]
[1,"PROYECTO"]
[2,"Establecimiento de la organización…"]
[3,"Convocatorias"]
[4,"Entrevista y selección de personal",null,null,"X"]
[5,"Contratación de personal",null,null,null,"X"]
[6,"Capacitación",null,null,null,null,"X"]
[7,"Elección de la tecnología"]
[8,"Cotizaciones de equipos y enseres",null,null,"X"]
[9,"Cotización publicidad",null,null,null,null,null,null,null,"X"]
[10,"Selección proveedor",null,null,null,null,null,null,null,"X","X"]
[11,"Estudio y decisión final",null,null,null,null,null,null,null,null,null,"X"]
[12,"Estudios técnicos detallados de equipos"]
[13,"Presupuesto",null,null,null,null,null,null,null,"X"]
[14,"Identificación de recursos",null,null,null,null,null,null,null,null,null,null,"X",null,"X"]
[15,"Diseño de adecuaciones",null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[16,"Instalación de muebles y redes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[17,"Evaluación de propuestas y adjudicaci…"]
[18,"Contratos institucionales",null,null,null,null,null,null,null,null,null,null,"X"]
[19,"Contratos de equipos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[20,"Financiación del proyecto"]
[21,"Solicitud crédito bancario",null,null,null,null,null,null,null,null,null,null,"X",null,null,null,"X"]
[22,"Donaciones institucionales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[23,"Aportes socios",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X","X"]
[24,"Arreglos sobre suministros"]
[25,"Suministro de material",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[26,"Generar publicidad",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[27,"Entrega volantes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[28,"Redes sociales",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[29,"Comercialización previa a la producción"]
[30,"Identificación de recursos",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[31,"Conocer las necesidades del usuario",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[32,"Búsqueda de instituciones",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"X"]
[33,"Aprobaciones requeridas"]
[34,"Permiso de la Alcaldía",null,null,null,null,null,null,null,null,null,null,"X"]

{"sheet":"tabla amortización","index":14,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[6,0,6,5],[5,0,5,5]]}
["crédito",10000000]
["tasa interés",0.24,"anual"]
["plazo",6,"años"]
["cuota",{"$f":"PMT(B2,B3,-B1,,)","v":3310741.6015507118},"mensual"]
[]
["Cuadro 10.3"]
["TABLA DE AMORTIZACIÓN"]
["PERIODO","SALDO INICIAL","CUOTA","INTERESES","AMORTIZACIÓN","SALDO"]
[1,{"$f":"B1","v":10000000},{"$f":"B4","v":3310741.6015507118},{"$f":"B9*$B$2","v":2400000},{"$f":"C9-D9","v":910741.60155071178},{"$f":"+B9-E9","v":9089258.3984492887}]
[2,{"$f":"F9","v":9089258.3984492887},{"$f":"C9","v":3310741.6015507118},{"$f":"B10*$B$2","v":2181422.0156278294},1129319.5859228824,7959938.8125264067]
[3,7959938.8125264067,3310741.6015507118,1910385.3150063376,1400356.2865443742,6559582.5259820325]
[4,6559582.5259820325,3310741.6015507118,1574299.8062356878,1736441.795315024,4823140.7306670081]
[5,4823140.7306670081,3310741.6015507118,1157553.7753600818,2153187.82619063,2669952.9044763781]
[6,2669952.9044763781,3310741.6015507118,640788.69707433076,2669952.9044763809,0]

{"sheet":"diag. flujo","index":15,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[null,null,{"$f":"Indicadores!D$37","v":11862737.749804378},{"$f":"Indicadores!E$37","v":13297160.072951257},{"$f":"Indicadores!F$37","v":11438354.420320064},{"$f":"Indicadores!G$37","v":20275451.611057431},{"$f":"Indicadores!H$37","v":21843048.32646057},{"$f":"Indicadores!I$37","v":35964636.021388978},{"$f":"Indicadores!J$37","v":36513725.205125123},{"$f":"Indicadores!K$37","v":45727971.231381357},{"$f":"Indicadores!L$37","v":59735970.850999206}]
[]
[]
[2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,"AÑO"]
[]
[]
[]
[{"$f":"Indicadores!B$37","v":-12943000},{"$f":"Indicadores!C$37","v":-5019900.5882172585}]