{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["GASTOS FINANCIEROS(A)","GASTOS CONSTITUCION(A.1)","INV.OBRA CIVIL  MAQUINARIA(A.2)","PROYECCION  INGRESOS (B)","GASTOS EN PUBLICIDAD(C)","GASTOS OPERATIVOS(D)","SUELDOS Y SALARIOS(E)","VALOR DE DESECHO Y TMAR(F)(F.1)","CAPITAL TRABAJO(G)","FLUJO DE CAJA(H)","ESTADO RESULTADO(I)","VAN Y TIR(J)(J.1)","PAY BACK(K)","ANALISIS DE SENSIBILIDAD(L)"],"not_rendered":{"charts":7,"images":5,"macros":1,"defined_names":42,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"GASTOS FINANCIEROS(A)","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[1,1,1,10],[10,8,10,9]]}
[null,"ANEXO A"]
[null,"Préstamo Bancario    "]
[null,"Monto",{"$f":"K6","v":{"v":99444.4959552114,"d":"$ 99,444.50"}}]
[null,"interes",{"v":0.16,"d":"16%"}]
[null,"Tiempo ","10 años"]
[{"$nulls":8},"Financiamiento",{"v":0.2,"d":"20%"},{"$f":"(J16*J6)","v":{"v":99444.4959552114,"d":"$ 99,444.50"}}]
[null,"Cuota","Pago","Interes","Amortizacion","Saldo",null,null,"Capital Propio",{"v":0.8,"d":"80%"},{"$f":"(J16*J7)","v":{"v":397777.9838208456,"d":"$ 397,777.98"}}]
[null,0,{"$nulls":3},{"$f":"K6","v":{"v":99444.4959552114,"d":"99444.50"}},null,null,"TOTAL",null,{"$f":"SUM(K6:K7)","v":{"v":497222.479776057,"d":"$ 497,222.48"}}]
[null,1,20575.173918143242,{"$f":"(F8*$C$4)","v":{"v":15911.119352833824,"d":"15911.12"}},{"$f":"(C9-D9)","v":{"v":4664.054565309418,"d":"4664.05"}},{"$f":"(F8-E9)","v":{"v":94780.44138990199,"d":"94780"}}]
[null,2,{"$f":"C9","v":20575.173918143242},{"v":15164.870622384318,"d":"15164.87"},{"$f":"(C10-D10)","v":{"v":5410.303295758924,"d":"5410.30"}},{"$f":"(F9-E10)","v":{"v":89370.13809414307,"d":"89370"}}]
[null,3,{"$f":"C10","v":20575.173918143242},{"v":14299.22209506289,"d":"14299.22"},{"v":6275.9518230803515,"d":"6275.95"},{"v":83094.18627106272,"d":"83094"},null,null,"CAPITAL REQUERIDO"]
[null,4,20575.173918143242,{"v":13295.069803370036,"d":"13295.07"},{"v":7280.104114773207,"d":"7280.10"},{"v":75814.08215628951,"d":"75814"},null,null,"INV. INICIAL EN OBRA FISICA (AÑO 0) (-)",{"v":133000,"d":"$ 133,000.00"}]
[null,5,20575.173918143242,{"v":12130.253145006323,"d":"12130.25"},{"v":8444.920773136919,"d":"8444.92"},{"v":67369.16138315259,"d":"67369"},null,null,"INV. INICIAL EN MAQUINARIAS Y EQUIPOS (AÑO 0) (-)",{"v":107001,"d":"$ 107,001.00"}]
[null,6,20575.173918143242,{"v":10779.065821304415,"d":"10779.07"},{"v":9796.108096838827,"d":"9796.11"},{"v":57573.05328631376,"d":"57573"},null,null,"GASTOS DE CONSTITUCION (AÑO 0) (-)",{"v":1161,"d":"$ 1,161.00"}]
[null,7,20575.173918143242,{"v":9211.688525810203,"d":"9211.69"},{"v":11363.48539233304,"d":"11363.49"},{"v":46209.567893980726,"d":"46210"},null,null,"CAPITAL DE TRABAJO (AÑO 0) (-)",{"v":256060.479776057,"d":"$ 256,060.48"}]
[null,8,20575.173918143242,{"v":7393.530863036916,"d":"7393.53"},{"v":13181.643055106326,"d":"13181.64"},{"v":33027.9248388744,"d":"33028"},null,null,"TOTAL INVERSION",{"$f":"SUM(J12:J15)","v":{"v":497222.479776057,"d":"$ 497,222.48"}}]
[null,9,20575.173918143242,{"v":5284.467974219904,"d":"5284.47"},{"v":15290.705943923338,"d":"15290.71"},{"v":17737.218894951064,"d":"17737"}]
[null,10,20575.173918143242,{"v":2837.9550231921703,"d":"2837.96"},{"v":17737.21889495107,"d":"17737.22"},{"v":-7.275957614183426e-12,"d":"-0"}]

{"sheet":"GASTOS CONSTITUCION(A.1)","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[0,0,0,13],[1,0,1,2],[7,4,7,13]]}
["GASTOS DE CONSTITUCION DE LA EMPRESA SIME"]
["Gastos de constitucion"]
["Aspectos legales",null,"RENOVACION"]
["Servicios legales",{"v":350,"d":"$ 350.00"}]
["Cuenta integracion capital",{"v":200,"d":"$ 200.00"}]
["Notarizar escritura ",{"v":50,"d":"$ 50.00"}]
["Afiliaciacion camara produccion",{"v":127,"d":"$ 127.00"}]
["Registro comercial",{"v":350,"d":"$ 350.00"},"10 AÑOS",null,"PROYECCION DE GASTOS DE CONSTITUCION"]
["Registro marca",{"v":16,"d":"$ 16.00"},null,null,"AÑO1","AÑO2","AÑO3","AÑO4","AÑO5","AÑO6","AÑO7","AÑO8","AÑO9","AÑO10"]
["Certificacion notario",{"v":28,"d":"$ 28.00"},null,null,{"$f":"B15","v":{"v":1161,"d":"$ 1,161.00"}},{"$f":"$E$10-$B$8","v":{"v":811,"d":"$ 811.00"}},{"v":811,"d":"$ 811.00"},{"v":811,"d":"$ 811.00"},{"v":811,"d":"$ 811.00"},{"v":811,"d":"$ 811.00"},{"v":811,"d":"$ 811.00"},{"v":811,"d":"$ 811.00"},{"v":811,"d":"$ 811.00"},{"v":811,"d":"$ 811.00"}]
["Aspectos tributarios"]
["Obtencion del ruc",0]
["Permiso cuerpo bomberos",{"v":8,"d":"$ 8.00"},"1 AÑO"]
["Permiso del municipio",{"v":32,"d":"$ 32.00"},"1 AÑO"]
["Total anual",{"$f":"SUM(B4:B14)","v":{"v":1161,"d":"$ 1,161.00"}}]

{"sheet":"INV.OBRA CIVIL  MAQUINARIA(A.2)","index":2,"n_rows":99,"n_cols":11,"rows_kept":99,"merged":[[0,0,0,4],[10,0,10,9],[38,0,38,10],[74,0,74,10]]}
["PRESUPUESTO DE OBRA FISICA"]
["Descripción","unidad de medida","Cantidad ","Costo unitario","costo total"]
["Reparación del Piso de Concreto","m2",500,200,{"$f":"(D3*C3)","v":100000}]
["Pintura de las Paredes","m2",300,30,{"$f":"(D4*C4)","v":9000}]
["Reparación del techo","m2",400,30,12000]
["Conexiones de Electricidad","m2",100,20,2000]
["Reconstrucción de la Oficina","m2",200,50,10000]
[null,null,"Total de inversion total de obras fisicas",null,{"$f":"SUM(E3:E7)","v":{"v":133000,"d":"$ 133,000.00"}}]
[]
[]
["INVENTARIO INICIAL ACTIVOS FIJOS"]
["DESCRIPCION","cantidad","costo unitario","costo total","vida util","valor de desecho","Depreciación anual","Depreciación total anual","depreciacion acumulada","valor en libros"]
["Maquinas",null,null,{"$f":"SUM(D14:D24)","v":83650},null,{"$f":"SUM(F14:F24)","v":30580},null,{"$f":"SUM(H14:H24)","v":{"v":9783.333333333332,"d":"9783.33"}}]
["tornos",2,15000,{"$f":"(B14*C14)","v":30000},10,8000,{"$f":"(C14/E14)","v":1500},{"$f":"(D14/E14)","v":3000},{"$f":"(G14*E14)","v":15000},{"$f":"(C14-I14)","v":0}]
["taladros de banco",1,5000,{"$f":"(B15*C15)","v":5000},10,2000,{"$f":"(C15/E15)","v":500},500,{"$f":"(G15*E15)","v":5000},{"$f":"(C15-I15)","v":0}]
["taladros portatiles",5,120,600,5,50,24,120,120,0]
["soldadoras electricas",5,350,1750,5,150,70,350,350,0]
["equipos de oxicorte",3,300,900,5,150,60,180,300,0]
["Prensa hidraulica",1,14000,14000,10,7000,1400,1400,14000,0]
["herramientas","-",4000,{"$f":"C20","v":4000},3,1500,{"v":1333.3333333333333,"d":"1333"},{"v":1333.3333333333333,"d":"1333"},4000,0]
["pulidoras",5,80,400,2,30,40,200,80,0]
["roladora ",1,8000,8000,10,3500,800,800,8000,0]
["fresadoras",1,16000,16000,10,7000,1600,1600,16000,0]
["cizallas",1,3000,{"$f":"(B24*C24)","v":3000},10,1200,300,300,3000,0]
["Tecnologia",null,null,2400,null,500,null,{"v":800,"d":"800.00"},null,0]
["Equipo computacion",2,1200,{"$f":"(B26*C26)","v":2400},3,500,400,{"$f":"(D26/E26)","v":800},1200,0]
["Vehiculos",null,null,20000,null,4500,null,{"v":4000,"d":"4000.00"},null,0]
["Camion repartidor",1,20000,20000,5,4500,4000,{"$f":"(D28/E28)","v":4000},20000,0]
["Muebles y Enseres",null,null,{"$f":"SUM(D30:D35)","v":{"v":951,"d":"951.00"}},null,{"$f":"SUM(F30:F35)","v":{"v":190,"d":"190.00"}},null,{"$f":"SUM(H30:H35)","v":{"v":95.1,"d":"95.10"}},null,0]
["Archivadores",5,90,450,10,60,9,{"$f":"(D30/E30)","v":45},90,0]
["Escritorio",2,35,70,10,25,3.5,7,35,0]
["sillas",5,15,75,10,10,1.5,7.5,15,0]
["mesa computador",2,43,86,10,25,4.3,8.6,43,0]
["Armario",2,110,220,10,55,11,22,110,0]
["Silla para computadora",2,25,50,10,15,2.5,5,25,0]
[null,null,"inversion",{"$f":"SUM(D13,D25,D27,D29)","v":{"v":107001,"d":"$ 107,001.00"}},"valor desecho",{"$f":"SUM(F13,F25,F27,F29)","v":{"v":35770,"d":"$ 35,770.00"}},"Depreciacion",{"$f":"SUM(H13,H25,H27,H29)","v":{"v":14678.433333333332,"d":"$ 14,678.43"}}]
[]
[]
["CALENDARIO DE REEINVERSIONES DE ACTIVOS FIJOS"]
["Maquinas",1,2,3,4,5,6,7,8,9,10]
["tornos",{"$nulls":9},30000]
["taladros de banco",{"$nulls":9},5000]
["taladros portatiles",{"$nulls":4},600]
["soldadoras electricas",{"$nulls":4},1750]
["equipos de oxicorte",{"$nulls":4},900]
["Prensa hidraulica",{"$nulls":9},14000]
["herramientas",null,null,4000]
["pulidoras",null,400]
["roladora ",{"$nulls":9},8000]
["fresadoras",{"$nulls":9},16000]
["cizallas",{"$nulls":9},3000]
["Tecnologia"]
["Equipo computacion",null,null,2400]
["Vehiculos"]
["Camion repartidor",{"$nulls":4},20000]
["Muebles y Enseres"]
["Archivadores",{"$nulls":9},450]
["Escritorio",{"$nulls":9},70]
["sillas",{"$nulls":9},75]
["mesa computador",{"$nulls":9},86]
["Armario",{"$nulls":9},220]
["Silla para computadora",{"$nulls":9},50]
["TOTAL ",{"$f":"SUM(B41:B62)","v":0},{"$f":"SUM(C41:C62)","v":400},6400,0,23250,0,0,0,0,76951]
{"$rows_empty":11}
["CALENDARIO DE INGRESO POR VENTA DE ACTIVOS FIJOS REEMPLAZO"]
["Maquinas",1,2,3,4,5,6,7,8,9,10]
["tornos",{"$nulls":9},8000]
["taladros de banco",{"$nulls":9},2000]
["taladros portatiles",{"$nulls":4},50]
["soldadoras electricas",{"$nulls":4},150]
["equipos de oxicorte",{"$nulls":4},150]
["Prensa hidraulica",{"$nulls":9},7000]
["herramientas",null,null,1500]
["pulidoras",null,30]
["roladora ",{"$nulls":9},3500]
["fresadoras",{"$nulls":9},7000]
["cizallas",{"$nulls":9},1200]
["Tecnologia"]
["Equipo computacion",null,null,500]
["Vehiculos"]
["Camion repartidor",{"$nulls":4},4500]
["Muebles y Enseres"]
["Archivadores",{"$nulls":4},60]
["Escritorio",{"$nulls":4},25]
["sillas",{"$nulls":4},10]
["mesa computador",{"$nulls":4},25]
["Armario",{"$nulls":4},55]
["Silla para computadora",{"$nulls":4},15]
["TOTAL ",{"$f":"SUM(B77:B97)","v":0},30,2000,0,5025,0,0,0,0,28700]

{"sheet":"PROYECCION  INGRESOS (B)","index":3,"n_rows":99,"n_cols":11,"rows_kept":99,"merged":[[2,0,2,10],[44,1,44,6],[45,2,45,3],[65,1,65,6],[66,2,66,3],[87,0,87,3]]}
[]
["ANEXO B"]
["DETALLE DE PROYECCION DE INGRESOS"]
[]
[null,"AÑO 1","AÑO 2","AÑO 3","AÑO4","AÑO 5","AÑO 6","AÑO 7","AÑO 8","AÑO 9","AÑO 10"]
["POBLACION OBJETIVO",264,{"$f":"(B6*1.05)","v":277.2},{"$f":"(C6*1.05)","v":291.06},{"v":305.613,"d":"305.61"},{"v":320.89365000000004,"d":"320.89"},{"$f":"(F6*1.05)","v":{"v":336.93833250000006,"d":"336.94"}},{"$f":"(G6*1.05)","v":{"v":353.78524912500006,"d":"353.79"}},{"$f":"(H6*1.05)","v":{"v":371.47451158125006,"d":"371.47"}},{"$f":"(I6*1.05)","v":{"v":390.04823716031257,"d":"390.05"}},{"$f":"(J6*1.05)","v":{"v":409.5506490183282,"d":"409.55"}}]
["CRITERIO DE PORTER (5% DE POBLAC. OBJETIVO)",0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
["DEMANDA POTENCIAL",{"$f":"B7*B6","v":13.200000000000001},{"$f":"C7*C6","v":13.86},{"v":14.553,"d":"14.55"},{"v":15.280650000000001,"d":"15.28"},{"v":16.044682500000004,"d":"16.04"},{"v":16.846916625000002,"d":"16.85"},{"v":17.689262456250002,"d":"17.69"},{"v":18.573725579062504,"d":"18.57"},{"v":19.50241185801563,"d":"19.50"},{"v":20.477532450916414,"d":"20.48"}]
["DISPONIBILIDAD DE CONSUMO",0.71,0.71,0.71,0.71,0.71,0.71,0.71,0.71,0.71,0.71]
["DEMANDA EFECTIVA",{"$f":"B9*B8","v":{"v":9.372,"d":"9"}},{"$f":"C9*C8","v":{"v":9.840599999999998,"d":"10"}},{"v":10.33263,"d":"10"},{"v":10.8492615,"d":"11"},{"v":11.391724575000001,"d":"11"},{"v":11.96131080375,"d":"12"},{"v":12.559376343937501,"d":"13"},{"v":13.187345161134377,"d":"13"},{"v":13.846712419191096,"d":"14"},{"v":14.539048040150654,"d":"15"}]
["FRECUENCIA DE CONSUMO",{"$f":"$G$72","v":{"v":52.596858638743456,"d":"53"}},{"$f":"$G$72","v":{"v":52.596858638743456,"d":"53"}},{"v":52.596858638743456,"d":"53"},{"v":52.596858638743456,"d":"53"},{"v":52.596858638743456,"d":"53"},{"v":52.596858638743456,"d":"53"},{"v":52.596858638743456,"d":"53"},{"v":52.596858638743456,"d":"53"},{"v":52.596858638743456,"d":"53"},{"v":52.596858638743456,"d":"53"}]
["SERVICIOS PRESTADOS",{"$f":"B11*B10","v":{"v":492.9377591623037,"d":"493"}},{"$f":"C11*C10","v":{"v":517.5846471204188,"d":"518"}},{"v":543.4638794764398,"d":"543"},{"v":570.6370734502618,"d":"571"},{"v":599.1689271227749,"d":"599"},{"v":629.1273734789137,"d":"629"},{"v":660.5837421528594,"d":"661"},{"v":693.6129292605024,"d":"694"},{"v":728.2935757235275,"d":"728"},{"v":764.708254509704,"d":"765"}]
[]
[]
[]
[null,"Disponibilidad del consumo"]
{"$rows_empty":28}
[null,"DETALLE DEL PRECIO"]
[null,"N-EMPRESAS","RANGO",null,"MEDIA SIMPLE","PONDERADOR","PRECIO"]
[null,22,100,500,{"$f":"AVERAGE(C47:D47)","v":300},{"$f":"(B47/$B$52)","v":{"v":0.05759162303664921,"d":"5.76%"}},{"$f":"+(E47*F47)","v":{"v":17.277486910994764,"d":"17.28"}}]
[null,44,501,1000,{"$f":"AVERAGE(C48:D48)","v":750.5},{"$f":"(B48/$B$52)","v":{"v":0.11518324607329843,"d":"11.52%"}},{"$f":"+(E48*F48)","v":{"v":86.44502617801047,"d":"86.45"}}]
[null,83,1001,2000,1500.5,{"v":0.21727748691099477,"d":"21.73%"},{"v":326.02486910994764,"d":"326.02"}]
[null,115,2001,3000,2500.5,{"v":0.3010471204188482,"d":"30.10%"},{"v":752.7683246073299,"d":"752.77"}]
[null,118,">3000",0,0,{"v":0.3089005235602094,"d":"30.89%"},{"v":0,"d":"0.00"}]
[null,{"$f":"SUM(B47:B51)","v":382},{"$nulls":3},"PRECIO TOTAL",{"$f":"SUM(G47:G51)","v":{"v":1182.5157068062827,"d":"1183"}}]
{"$rows_empty":13}
[null,"DETALLE FRECUENCIA DE CONSUMO"]
[null,"EMPRESAS","RANGO USO DEL SERVICIO POR MES",null,"MEDIA SIMPLE","PONDERADOR","FRECUENCIA DE CONSUMO"]
[null,127,1,20,{"$f":"SUM(C68:D68)","v":21},{"$f":"(B68/$B$72)","v":{"v":0.3324607329842932,"d":"33%"}},{"$f":"(F68*E68)","v":{"v":6.981675392670157,"d":"6.98"}}]
[null,111,21,30,{"$f":"SUM(C69:D69)","v":51},{"$f":"(B69/$B$72)","v":{"v":0.2905759162303665,"d":"29%"}},{"$f":"(F69*E69)","v":{"v":14.819371727748692,"d":"14.82"}}]
[null,67,31,40,71,{"$f":"(B70/$B$72)","v":{"v":0.17539267015706805,"d":"18%"}},{"v":12.452879581151832,"d":"12.45"}]
[null,77,41,50,91,{"$f":"(B71/$B$72)","v":{"v":0.20157068062827224,"d":"20%"}},{"v":18.342931937172775,"d":"18.34"}]
[null,{"$f":"SUM(B68:B71)","v":382},{"$nulls":4},{"$f":"SUM(G68:G71)","v":{"v":52.596858638743456,"d":"53"}}]
{"$rows_empty":15}
["PROYECCIONES DE INGRESOS"]
["DETALLE DE LOS INGRESOS ","CANTIDAD DEMANDADA","PRECIO POR SERVICIO","INGRESO"]
["AÑO 1",{"$f":"B12","v":{"v":492.9377591623037,"d":"493"}},{"$f":"$G$52","v":{"v":1182.5157068062827,"d":"1183"}},{"$f":"(B90*C90)","v":{"v":582906.6426873166,"d":"$ 582,906.64"}}]
["AÑO 2",{"$f":"C12","v":{"v":517.5846471204188,"d":"518"}},{"$f":"$G$52","v":{"v":1182.5157068062827,"d":"1183"}},{"v":612051.9748216824,"d":"$ 612,051.97"}]
["AÑO 3",{"$f":"D12","v":{"v":543.4638794764398,"d":"543"}},{"v":1182.5157068062827,"d":"1183"},{"v":642654.5735627667,"d":"$ 642,654.57"}]
["AÑO4",{"$f":"E12","v":{"v":570.6370734502618,"d":"571"}},{"v":1182.5157068062827,"d":"1183"},{"v":674787.302240905,"d":"$ 674,787.30"}]
["AÑO 5",{"$f":"F12","v":{"v":599.1689271227749,"d":"599"}},{"v":1182.5157068062827,"d":"1183"},{"v":708526.6673529502,"d":"$ 708,526.67"}]
["AÑO 6",{"$f":"G12","v":{"v":629.1273734789137,"d":"629"}},{"v":1182.5157068062827,"d":"1183"},{"v":743953.0007205978,"d":"$ 743,953.00"}]
["AÑO 7",{"$f":"H12","v":{"v":660.5837421528594,"d":"661"}},{"v":1182.5157068062827,"d":"1183"},{"v":781150.6507566277,"d":"$ 781,150.65"}]
["AÑO 8",{"$f":"I12","v":{"v":693.6129292605024,"d":"694"}},{"v":1182.5157068062827,"d":"1183"},{"v":820208.1832944591,"d":"$ 820,208.18"}]
["AÑO 9",{"$f":"J12","v":{"v":728.2935757235275,"d":"728"}},{"v":1182.5157068062827,"d":"1183"},{"v":861218.592459182,"d":"$ 861,218.59"}]
["AÑO 10",{"$f":"K12","v":{"v":764.708254509704,"d":"765"}},{"v":1182.5157068062827,"d":"1183"},{"v":904279.5220821414,"d":"$ 904,279.52"}]

{"sheet":"GASTOS EN PUBLICIDAD(C)","index":4,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[0,0,0,13],[2,0,2,2],[5,4,5,13],[13,0,13,2],[14,0,14,2]]}
["GASTOS DE PUBLICIDAD "]
[{"$nulls":4},"anexo C"]
["Precio de publicidad  "]
["diarios","ordinario ","domingo"]
["el universo",{"v":133,"d":"$ 133.00"},{"v":186,"d":"$ 186.00"}]
["expreso",{"v":44,"d":"$ 44.00"},{"v":66,"d":"$ 66.00"},null,"PROYECCION EN PUBLICIDAD"]
["metroquil",{"v":34,"d":"$ 34.00"},{"v":76,"d":"$ 76.00"},null,"año1","año 2","año3","año4","año5","año6","año7","año8","año9","año10"]
["extra",{"v":40,"d":"$ 40.00"},{"v":50,"d":"$ 50.00"},null,{"$f":"$D$13","v":{"v":9156,"d":"$ 9,156.00"}},{"$f":"$D$13","v":{"v":9156,"d":"$ 9,156.00"}},{"$f":"(F8-(F8*30%))","v":{"v":6409.200000000001,"d":"$ 6,409.20"}},{"$f":"(G8-(G8*30%))","v":{"v":4486.4400000000005,"d":"$ 4,486.44"}},{"$f":"(H8-(H8*30%))","v":{"v":3140.5080000000007,"d":"$ 3,140.51"}},{"$f":"($I$8-($I$8*50%))","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"$f":"($I$8-($I$8*50%))","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"v":1570.2540000000004,"d":"$ 1,570.25"},{"v":1570.2540000000004,"d":"$ 1,570.25"},{"v":1570.2540000000004,"d":"$ 1,570.25"}]
["telegrafo",{"v":44,"d":"$ 44.00"},{"v":60,"d":"$ 60.00"}]
["volantes",{"v":30,"d":"$ 30.00"}]
["Subtotal",{"$f":"SUM(B5:B10)","v":{"v":325,"d":"$ 325.00"}},{"$f":"SUM(C5:C9)","v":{"v":438,"d":"$ 438.00"}}]
["total","Mensual","mensual"]
["total",{"$f":"B11*12","v":{"v":3900,"d":"$ 3,900.00"}},{"$f":"C11*12","v":{"v":5256,"d":"$ 5,256.00"}},{"$f":"SUM(B13:C13)","v":{"v":9156,"d":"$ 9,156.00"}},"ANUAL"]
["ordinario:lunes -sabado",null,null,{"$f":"D13/12","v":{"v":763,"d":"$ 763.00"}},"MENSUAL"]
["iva incluido"]

{"sheet":"GASTOS OPERATIVOS(D)","index":5,"n_rows":51,"n_cols":12,"rows_kept":51,"merged":[[1,1,1,11],[14,1,14,4],[14,5,14,7],[27,1,27,2],[34,1,34,2],[42,1,42,2],[43,1,43,2]]}
[]
[null,"DETALLE DE GASTOS OPERATIVOS"]
[]
[null,"GASTOS ","AÑO 1","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"]
[null,"SERVICIOS BASICOS",{"$f":"$C$33","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"$C$33","v":{"v":8901.6,"d":"$ 8,901.60"}},{"v":8901.6,"d":"$ 8,901.60"},{"v":8901.6,"d":"$ 8,901.60"},{"v":8901.6,"d":"$ 8,901.60"},{"v":8901.6,"d":"$ 8,901.60"},{"v":8901.6,"d":"$ 8,901.60"},{"v":8901.6,"d":"$ 8,901.60"},{"v":8901.6,"d":"$ 8,901.60"},{"v":8901.6,"d":"$ 8,901.60"}]
[null,"SUMINISTRO DE OFICINAS",{"v":100,"d":"$ 100.00"},{"v":100,"d":"$ 100.00"},{"v":100,"d":"$ 100.00"},{"v":120,"d":"$ 120.00"},{"v":120,"d":"$ 120.00"},{"v":130,"d":"$ 130.00"},{"v":130,"d":"$ 130.00"},{"v":150,"d":"$ 150.00"},{"v":150,"d":"$ 150.00"},{"v":150,"d":"$ 150.00"}]
[null,"MANTENIMIENTO DE MAQUINARIAS",{"v":1000,"d":"$ 1,000.00"},{"v":1000,"d":"$ 1,000.00"},{"v":2000,"d":"$ 2,000.00"},{"v":3000,"d":"$ 3,000.00"},{"v":5000,"d":"$ 5,000.00"},{"v":1000,"d":"$ 1,000.00"},{"v":1000,"d":"$ 1,000.00"},{"v":2000,"d":"$ 2,000.00"},{"v":3000,"d":"$ 3,000.00"},{"v":5000,"d":"$ 5,000.00"}]
[null,"COMBUSTIBLES",{"$f":"$C$51","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"$C$51","v":{"v":5400,"d":"$ 5,400.00"}},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"}]
[null,"DEPRECIACION",{"$f":"$C$40","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"$C$40","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"v":14678.433333333332,"d":"$ 14,678.43"},{"v":14678.433333333332,"d":"$ 14,678.43"},{"v":14678.433333333332,"d":"$ 14,678.43"},{"v":14678.433333333332,"d":"$ 14,678.43"},{"v":14678.433333333332,"d":"$ 14,678.43"},{"v":14678.433333333332,"d":"$ 14,678.43"},{"v":14678.433333333332,"d":"$ 14,678.43"},{"v":14678.433333333332,"d":"$ 14,678.43"}]
[null,"CAPACITACION",{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"},{"v":5400,"d":"$ 5,400.00"}]
[]
[]
[]
[]
[null,"consumo de energia",{"$nulls":3},"Consumo Kw/hora"]
[null,"Equipos y maquinaria","Cantidad","Kw/hora","Horas /día","Diario","Mensual","Anual","Coste Kw/Hora","Total Costo Consumo Anual"]
[null,"tornos",2,1,8,{"$f":"D17*E17","v":8},{"$f":"(F17*30)","v":240},{"$f":"(G17*12)","v":2880},0.09,{"$f":"(H17*I17)*C17","v":518.4}]
[null,"taladros de banco",1,0.5,8,{"$f":"E18*D18","v":4},{"$f":"(F18*30)","v":120},{"$f":"(G18*12)","v":1440},{"$f":"I17","v":0.09},{"$f":"(H18*I18)*C18","v":129.6}]
[null,"taladros portatiles",5,0.5,8,{"$f":"E19*D19","v":4},120,1440,{"$f":"I18","v":0.09},648]
[null,"soldadoras electricas",5,1,8,{"$f":"E20*D20","v":8},240,2880,{"$f":"I19","v":0.09},1296]
[null,"Prensa hidraulica",1,0.75,8,{"$f":"E21*D21","v":6},180,2160,{"$f":"I20","v":0.09},194.4]
[null,"pulidoras",5,0.5,8,{"$f":"E22*D22","v":4},120,1440,{"$f":"I21","v":0.09},648]
[null,"fresadoras",1,1,8,{"$f":"E23*D23","v":8},240,2880,{"$f":"I22","v":0.09},259.2]
[null,"computador",2,1,8,8,240,2880,0.09,518.4]
[null,"aire condicionado",1,1,4,4,120,1440,0.09,129.6]
[null,"luminarias",10,1,4,4,120,1440,0.09,1296]
[{"$nulls":8},"Total ",{"$f":"SUM(J17:J25)","v":4341.6}]
[null,"Gastos Servicios Básicos"]
[null,"Total Consumo Energía ",{"$f":"J27","v":{"v":4341.6,"d":"$ 4,341.60"}}]
[null,"Total Consumo de Agua",{"$f":"(130*12)","v":{"v":1560,"d":"$ 1,560.00"}}]
[null,"Teléfono",{"v":2400,"d":"$ 2,400.00"}]
[null,"Internet",{"v":600,"d":"$ 600.00"}]
[null,"Total Servicios Básicos",{"$f":"SUM(C29:C32)","v":{"v":8901.6,"d":"$ 8,901.60"}}]
[]
[null,"Gastos Depreciacion"]
[null,"Depreciaciones muebles y enseres",{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!H29","v":{"v":95.1,"d":"$ 95.10"}}]
[null,"Depreciaciones Maquinarias",{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!H13","v":{"v":9783.333333333332,"d":"$ 9,783.33"}}]
[null,"Depreciacion equipos computacion",{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!H25","v":{"v":800,"d":"$ 800.00"}}]
[null,"Depreciacion vehiculo",{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!H27","v":{"v":4000,"d":"$ 4,000.00"}}]
[null,"total Depreciacion",{"$f":"SUM(C36:C39)","v":{"v":14678.433333333332,"d":"$ 14,678.43"}}]
[]
[]
[null,"Gastos combustibles"]
[null,"camion de 20 toneladas"]
[null,"Capacidad tanque","20 galones "]
[null,"Frecuencia de uso(Dias)",30]
[null,"Galones /dia",10]
[null,"Total galones (mensual)",{"$f":"(C47*C46)","v":300}]
[null,"precio/galon",1.5]
[null,"mensual",{"$f":"(C48*C49)","v":450}]
[null,"anual",{"$f":"(C50*12)","v":{"v":5400,"d":"$ 5,400.00"}}]

{"sheet":"SUELDOS Y SALARIOS(E)","index":6,"n_rows":20,"n_cols":10,"rows_kept":20,"merged":[[1,1,1,5],[1,7,1,8],[2,1,2,5],[12,1,12,5],[17,0,17,9]]}
["anexo E"]
[null,"Presupuesto  del Personal",{"$nulls":5},"TENDENCIA"]
[null,"Remuneracion Anual",{"$nulls":5},"AÑO","Porcentaje inflacion"]
[null,"Cargo","numero de puesto","unitario mensual","Total Mensual","total  Anual",null,2005,{"v":0.044,"d":"4.40%"}]
[null,"Gerente Tecnico",1,{"v":1400,"d":"$ 1,400.00"},{"$f":"(D5*C5)","v":{"v":1400,"d":"$ 1,400.00"}},{"$f":"(E5*12)","v":{"v":16800,"d":"$ 16,800.00"}},null,2006,{"v":0.042,"d":"4.20%"}]
[null,"Auxiliar contable",1,{"v":800,"d":"$ 800.00"},{"$f":"(D6*C6)","v":{"v":800,"d":"$ 800.00"}},{"$f":"(E6*12)","v":{"v":9600,"d":"$ 9,600.00"}},null,2007,{"v":0.0332,"d":"3.32%"}]
[null,"Jefe administrativo",1,{"v":1200,"d":"$ 1,200.00"},{"v":1200,"d":"$ 1,200.00"},{"v":14400,"d":"$ 14,400.00"},null,2008,{"v":0.0883,"d":"8.83%"}]
[null,"Jefe tecnico",1,{"v":1200,"d":"$ 1,200.00"},{"v":1200,"d":"$ 1,200.00"},{"v":14400,"d":"$ 14,400.00"},null,2009,{"v":0.0431,"d":"4.31%"}]
[null,"Mecanicos",10,{"v":800,"d":"$ 800.00"},{"v":8000,"d":"$ 8,000.00"},{"v":96000,"d":"$ 96,000.00"},null,2010,{"$f":"TREND(I4:I8,H4:H8,H9)","v":{"v":0.0634699999999988,"d":"6.35%"}}]
[null,"electricista ",8,{"v":700,"d":"$ 700.00"},{"v":5600,"d":"$ 5,600.00"},{"v":67200,"d":"$ 67,200.00"},null,2011,{"v":0.06986599999999932,"d":"6.99%"}]
[null,"ayudantes",10,{"v":400,"d":"$ 400.00"},{"v":4000,"d":"$ 4,000.00"},{"v":48000,"d":"$ 48,000.00"},null,2012,{"v":0.07413779999999726,"d":"7.41%"}]
[{"$nulls":3},"total",null,{"$f":"SUM(F5:F11)","v":{"v":266400,"d":"$ 266,400.00"}},null,2013,{"v":0.06730723999999721,"d":"6.73%"}]
[null,"ESTA INCLUIDOS LOS BENEFICIOS DE LEY",{"$nulls":5},2014,{"v":0.08130089199999624,"d":"8.13%"}]
[{"$nulls":7},2015,{"v":0.0811472935999964,"d":"8.11%"}]
[{"$nulls":7},2016,{"v":0.08366954887999523,"d":"8.37%"}]
[{"$nulls":7},2017,{"v":0.08738362030399482,"d":"8.74%"}]
[{"$nulls":7},2018,{"v":0.0929181442031961,"d":"9.29%"}]
["PRESUPUESTO DE LOS SUELDOS DE ACUERDO A LA INFLACION"]
["AÑO 1","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"]
[{"$f":"F12","v":{"v":266400,"d":"$ 266,400.00"}},{"$f":"(A20*I9)+A20","v":{"v":283308.4079999997,"d":"$ 283,308.41"}},{"$f":"(B20*I10)+B20","v":{"v":303102.0332333275,"d":"$ 303,102.03"}},{"$f":"(C20*I11)+C20","v":{"v":325573.35115277243,"d":"$ 325,573.35"}},{"$f":"(D20*$I$12)+D20","v":{"v":347486.79483641544,"d":"$ 347,486.79"}},{"$f":"(E20*$I$13)+E20","v":{"v":375737.7812148357,"d":"$ 375,737.78"}},{"$f":"(F20*$I$14)+F20","v":{"v":406227.8852636872,"d":"$ 406,227.89"}},{"$f":"(G20*$I$15)+G20","v":{"v":440216.78916617436,"d":"$ 440,216.79"}},{"$f":"(H20*$I$16)+H20","v":{"v":478684.5259221151,"d":"$ 478,684.53"}},{"$f":"(I20*$I$17)+I20","v":{"v":523163.00372958474,"d":"$ 523,163.00"}}]

{"sheet":"VALOR DE DESECHO Y TMAR(F)(F.1)","index":7,"n_rows":22,"n_cols":5,"rows_kept":22}
["anexo F"]
[]
[]
[]
[]
[]
[null,null,"VALOR DE DESECHO DEL PROYECTO"]
[]
[null,null,"VD = (FC. PROMEDIO-DEP. ANUAL)/TMAR"]
[]
[null,null,"FLUJO CAJA PROM. ANUAL",{"v":156765.89310462892,"d":"$ 156,765.89"}]
[null,null,"DEP. ANUAL",{"$f":"'GASTOS OPERATIVOS(D)'!C40","v":{"v":14678.433333333332,"d":"$ 14,678.43"}}]
[null,null,"TMAR",{"$f":"D18","v":{"v":0.13786,"d":"14%"}}]
[null,null,"VALOR DESECHO"]
[{"$nulls":3},{"v":1030664.8757529057,"d":"$ 1,030,664.88"}]
[null,null,"CALCULANDO LA TMAR"]
[null,null,"Ke = [ Rf + β ( Rm – Rf ) ] + Rp"]
[null,null,"tasa rentabilidad Ke=",{"$f":"(D19+(D21-D19)*D20)+D22","v":{"v":0.13786,"d":"13.79%"}},"FUENTE INFORMACION"]
[null,null,"Tasa libre de riesgo (Bonos del tesoro EEUU ) Rf=",{"v":0.0283,"d":"3%"},"rf : 2.83(Datos de la Reserva federal EEUU)."]
[null,null,"Coeficiente de riesgo del sector B=",0.394,"β= 0.65 (Yahoo Finance)."]
[null,null,"Tasa de Rentabilidad del Mercado Rm",{"v":0.2083,"d":"21%"},"rm : 20.83 (Yahoo finance)."]
[null,null,"Porcentaje riesgo país. Rp",{"v":0.03864,"d":"4%"},"RPecu : 3.864 (Datos publicados el 14-01-2009)."]

{"sheet":"CAPITAL TRABAJO(G)","index":8,"n_rows":17,"n_cols":14,"rows_kept":17,"merged":[[3,1,3,13]]}
[]
[null,"ANEXO G"]
[]
[null,"MÉTODO DÉFICIT MÁXIMO ACUMULADO"]
[]
[null,null,"Enero","Febrero","Marzo","Abril","Mayo","Junio","Julio","Agosto","Septiembre","Octubre","Noviembre","Diciembre"]
[null,"Cantidad de servicios contratados",{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}},{"$f":"'PROYECCION  INGRESOS (B)'!$B$12/12","v":{"v":41.07814659685864,"d":"41"}}]
[null,"Precio Por servicio",{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52/12","v":{"v":98.54297556719023,"d":"$ 99"}}]
[null,"Ingreso Mensual $",{"$f":"(C7*C8)","v":{"v":4047.962796439699,"d":"$ 4,048"}},{"$f":"(D7*D8)","v":{"v":4047.962796439699,"d":"$ 4,048"}},{"v":4047.962796439699,"d":"$ 4,048"},{"v":4047.962796439699,"d":"$ 4,048"},{"v":4047.962796439699,"d":"$ 4,048"},{"v":4047.962796439699,"d":"$ 4,048"},{"v":4047.962796439699,"d":"$ 4,048"},{"v":4047.962796439699,"d":"$ 4,048"},{"v":4047.962796439699,"d":"$ 4,048"},{"v":4047.962796439699,"d":"$ 4,048"},{"v":4047.962796439699,"d":"$ 4,048"},{"v":4047.962796439699,"d":"$ 4,048"}]
[null,"SERVICIOS BASICOS",{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$33/12","v":{"v":741.8000000000001,"d":"$ 742"}}]
[null,"SUMINISTRO DE OFICINA",{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$6/12","v":{"v":8.333333333333334,"d":"$ 8"}}]
[null,"COMBUSTIBLES ",{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$51/12","v":{"v":450,"d":"$ 450"}}]
[null,"GASTOS DE PUBLICIDAD",{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!$D$13/12","v":{"v":763,"d":"$ 763"}}]
[null,"GASTOS DEPRECIACION DE EQUIPOS ",{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}},{"$f":"'INV.OBRA CIVIL  MAQUINARIA(A.2)'!$H$36/12","v":{"v":1223.2027777777778,"d":"$ 1,223"}}]
[null,"SUELDOS Y SALARIOS",{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}},{"$f":"'SUELDOS Y SALARIOS(E)'!$A$20/12","v":{"v":22200,"d":"$ 22,200"}}]
[null,"Flujo Mensual",{"$f":"(C9-C10-C11-C12-C13-C14-C15)","v":{"v":-21338.37331467141,"d":"$ (21,338)"}},{"$f":"(D9-D10-D11-D12-D13-D14-D15)","v":{"v":-21338.37331467141,"d":"$ (21,338)"}},{"v":-21338.37331467141,"d":"$ (21,338)"},{"v":-21338.37331467141,"d":"$ (21,338)"},{"v":-21338.37331467141,"d":"$ (21,338)"},{"v":-21338.37331467141,"d":"$ (21,338)"},{"v":-21338.37331467141,"d":"$ (21,338)"},{"v":-21338.37331467141,"d":"$ (21,338)"},{"v":-21338.37331467141,"d":"$ (21,338)"},{"v":-21338.37331467141,"d":"$ (21,338)"},{"v":-21338.37331467141,"d":"$ (21,338)"},{"v":-21338.37331467141,"d":"$ (21,338)"}]
[null,"Saldo Acumulado",{"$f":"C16","v":{"v":-21338.37331467141,"d":"$ (21,338)"}},{"$f":"C17+D16","v":{"v":-42676.74662934282,"d":"$ (42,677)"}},{"$f":"D17+E16","v":{"v":-64015.11994401424,"d":"$ (64,015)"}},{"$f":"E17+F16","v":{"v":-85353.49325868564,"d":"$ (85,353)"}},{"v":-106691.86657335705,"d":"$ (106,692)"},{"v":-128030.23988802846,"d":"$ (128,030)"},{"v":-149368.61320269987,"d":"$ (149,369)"},{"v":-170706.9865173713,"d":"$ (170,707)"},{"v":-192045.3598320427,"d":"$ (192,045)"},{"v":-213383.73314671413,"d":"$ (213,384)"},{"v":-234722.10646138556,"d":"$ (234,722)"},{"v":-256060.47977605698,"d":"$ (256,060)"}]

{"sheet":"FLUJO DE CAJA(H)","index":9,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[2,0,2,11],[3,0,3,11]]}
["anexo H"]
[]
["FLUJO DE EFECTIVO"]
["PROYECTO SIME"]
[null,"AÑO 0","AÑO 1","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"]
["CANTIDAD SERVICOS CONTRADOS",null,{"$f":"'PROYECCION  INGRESOS (B)'!B12","v":{"v":492.9377591623037,"d":"493 "}},{"$f":"'PROYECCION  INGRESOS (B)'!C12","v":{"v":517.5846471204188,"d":"518 "}},{"$f":"'PROYECCION  INGRESOS (B)'!D12","v":{"v":543.4638794764398,"d":"543 "}},{"$f":"'PROYECCION  INGRESOS (B)'!E12","v":{"v":570.6370734502618,"d":"571 "}},{"$f":"'PROYECCION  INGRESOS (B)'!F12","v":{"v":599.1689271227749,"d":"599 "}},{"$f":"'PROYECCION  INGRESOS (B)'!G12","v":{"v":629.1273734789137,"d":"629 "}},{"$f":"'PROYECCION  INGRESOS (B)'!H12","v":{"v":660.5837421528594,"d":"661 "}},{"$f":"'PROYECCION  INGRESOS (B)'!I12","v":{"v":693.6129292605024,"d":"694 "}},{"$f":"'PROYECCION  INGRESOS (B)'!J12","v":{"v":728.2935757235275,"d":"728 "}},{"$f":"'PROYECCION  INGRESOS (B)'!K12","v":{"v":764.708254509704,"d":"765 "}}]
["PRECIO POR SERVICIOS",null,{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}},{"$f":"'PROYECCION  INGRESOS (B)'!$G$52","v":{"v":1182.5157068062827,"d":"$ 1,183"}}]
["INGRESOS VTA. (+)",null,{"$f":"(C7*C6)","v":{"v":582906.6426873166,"d":"$ 582,906.64"}},{"$f":"(D7*D6)","v":{"v":612051.9748216824,"d":"$ 612,051.97"}},{"v":642654.5735627667,"d":"$ 642,654.57"},{"v":674787.302240905,"d":"$ 674,787.30"},{"v":708526.6673529502,"d":"$ 708,526.67"},{"v":743953.0007205978,"d":"$ 743,953.00"},{"v":781150.6507566277,"d":"$ 781,150.65"},{"v":820208.1832944591,"d":"$ 820,208.18"},{"v":861218.592459182,"d":"$ 861,218.59"},{"v":904279.5220821414,"d":"$ 904,279.52"}]
["COSTO DE PRODUCCION (-)",null,0,0,0,0,0,0,0,0,0,0]
["MARGEN BRUTO",null,{"$f":"C8-C9","v":{"v":582906.6426873166,"d":"$ 582,906.64"}},{"$f":"D8-D9","v":{"v":612051.9748216824,"d":"$ 612,051.97"}},{"v":642654.5735627667,"d":"$ 642,654.57"},{"v":674787.302240905,"d":"$ 674,787.30"},{"v":708526.6673529502,"d":"$ 708,526.67"},{"v":743953.0007205978,"d":"$ 743,953.00"},{"v":781150.6507566277,"d":"$ 781,150.65"},{"v":820208.1832944591,"d":"$ 820,208.18"},{"v":861218.592459182,"d":"$ 861,218.59"},{"v":904279.5220821414,"d":"$ 904,279.52"}]
["GASTOS OPERATIVOS (-)"]
["SERVICIOS BASICOS",null,{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$5","v":{"v":8901.6,"d":"$ 8,901.60"}}]
["SUMINISTRO DE OFICINA",null,{"$f":"'GASTOS OPERATIVOS(D)'!C6","v":{"v":100,"d":"$ 100.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!D6","v":{"v":100,"d":"$ 100.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!E6","v":{"v":100,"d":"$ 100.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!F6","v":{"v":120,"d":"$ 120.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!G6","v":{"v":120,"d":"$ 120.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!H6","v":{"v":130,"d":"$ 130.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!I6","v":{"v":130,"d":"$ 130.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!J6","v":{"v":150,"d":"$ 150.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!K6","v":{"v":150,"d":"$ 150.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!L6","v":{"v":150,"d":"$ 150.00"}}]
["MANTENIMIENTO MAQUINARIAS ",null,{"$f":"'GASTOS OPERATIVOS(D)'!$C$7","v":{"v":1000,"d":"$ 1,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$D$7","v":{"v":1000,"d":"$ 1,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$E$7","v":{"v":2000,"d":"$ 2,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$F$7","v":{"v":3000,"d":"$ 3,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$G$7","v":{"v":5000,"d":"$ 5,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$H$7","v":{"v":1000,"d":"$ 1,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$I$7","v":{"v":1000,"d":"$ 1,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$J$7","v":{"v":2000,"d":"$ 2,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$K$7","v":{"v":3000,"d":"$ 3,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$L$7","v":{"v":5000,"d":"$ 5,000.00"}}]
["COMBUSTIBLES ",null,{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$8","v":{"v":5400,"d":"$ 5,400.00"}}]
["CAPACITACION",null,{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}}]
["GASTOS DE PUBLICIDAD",null,{"$f":"'GASTOS EN PUBLICIDAD(C)'!E8","v":{"v":9156,"d":"$ 9,156.00"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!F8","v":{"v":9156,"d":"$ 9,156.00"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!G8","v":{"v":6409.200000000001,"d":"$ 6,409.20"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!H8","v":{"v":4486.4400000000005,"d":"$ 4,486.44"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!I8","v":{"v":3140.5080000000007,"d":"$ 3,140.51"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!J8","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!K8","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!L8","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!M8","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"$f":"'GASTOS EN PUBLICIDAD(C)'!N8","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}}]
["GASTOS DEPRECIACION DE EQUIPOS COMPUTACION",null,{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$38","v":{"v":800,"d":"$ 800.00"}}]
["GASTOS DEPRECIACION MUEBLES ENSERES",null,{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$36","v":{"v":95.1,"d":"$ 95.10"}}]
["GASTOS DEPRECIACION VEHICULOS",null,{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$39","v":{"v":4000,"d":"$ 4,000.00"}}]
["GASTOS DEPRECIACION DE MAQUINARIAS",null,{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$37","v":{"v":9783.333333333332,"d":"$ 9,783.33"}}]
["SUELDOS Y SALARIOS",null,{"$f":"'SUELDOS Y SALARIOS(E)'!F12","v":{"v":266400,"d":"$ 266,400.00"}},{"$f":"'SUELDOS Y SALARIOS(E)'!B20","v":{"v":283308.4079999997,"d":"$ 283,308.41"}},{"$f":"'SUELDOS Y SALARIOS(E)'!C20","v":{"v":303102.0332333275,"d":"$ 303,102.03"}},{"$f":"'SUELDOS Y SALARIOS(E)'!D20","v":{"v":325573.35115277243,"d":"$ 325,573.35"}},{"$f":"'SUELDOS Y SALARIOS(E)'!E20","v":{"v":347486.79483641544,"d":"$ 347,486.79"}},{"$f":"'SUELDOS Y SALARIOS(E)'!F20","v":{"v":375737.7812148357,"d":"$ 375,737.78"}},{"$f":"'SUELDOS Y SALARIOS(E)'!G20","v":{"v":406227.8852636872,"d":"$ 406,227.89"}},{"$f":"'SUELDOS Y SALARIOS(E)'!H20","v":{"v":440216.78916617436,"d":"$ 440,216.79"}},{"$f":"'SUELDOS Y SALARIOS(E)'!I20","v":{"v":478684.5259221151,"d":"$ 478,684.53"}},{"$f":"'SUELDOS Y SALARIOS(E)'!J20","v":{"v":523163.00372958474,"d":"$ 523,163.00"}}]
["UTILIDAD OPERATIVA",null,{"$f":"(C10-C12-C13+C14+C15+C16+C17-C18-C19-C20-C21-C22)","v":{"v":313782.6093539833,"d":"$ 313,782.61"}},{"$f":"(D10-D12-D13+D14+D15+D16+D17-D18-D19-D20-D21-D22)","v":{"v":326019.5334883494,"d":"$ 326,019.53"}},{"v":335081.7069961058,"d":"$ 335,081.71"},{"v":343800.3577547992,"d":"$ 343,800.36"},{"v":356280.34718320146,"d":"$ 356,280.35"},{"v":357875.44017242873,"d":"$ 357,875.44"},{"v":364582.9861596071,"d":"$ 364,582.99"},{"v":370631.6147949514,"d":"$ 370,631.61"},{"v":374174.2872037336,"d":"$ 374,174.29"},{"v":374756.73901922326,"d":"$ 374,756.74"}]
["GASTOS FINANCIERO (PAGO DE INTERESES) (-)",null,{"$f":"'GASTOS FINANCIEROS(A)'!$D$9","v":{"v":15911.119352833824,"d":"$ 15,911.12"}},{"$f":"'GASTOS FINANCIEROS(A)'!$D$10","v":{"v":15164.870622384318,"d":"$ 15,164.87"}},{"$f":"'GASTOS FINANCIEROS(A)'!$D$11","v":{"v":14299.22209506289,"d":"$ 14,299.22"}},{"$f":"'GASTOS FINANCIEROS(A)'!$D$12","v":{"v":13295.069803370036,"d":"$ 13,295.07"}},{"$f":"'GASTOS FINANCIEROS(A)'!$D$13","v":{"v":12130.253145006323,"d":"$ 12,130.25"}},{"$f":"'GASTOS FINANCIEROS(A)'!$D$14","v":{"v":10779.065821304415,"d":"$ 10,779.07"}},{"$f":"'GASTOS FINANCIEROS(A)'!$D$15","v":{"v":9211.688525810203,"d":"$ 9,211.69"}},{"$f":"'GASTOS FINANCIEROS(A)'!$D$16","v":{"v":7393.530863036916,"d":"$ 7,393.53"}},{"$f":"'GASTOS FINANCIEROS(A)'!$D$17","v":{"v":5284.467974219904,"d":"$ 5,284.47"}},{"$f":"'GASTOS FINANCIEROS(A)'!$D$18","v":{"v":2837.9550231921703,"d":"$ 2,837.96"}}]
["UTILIDAD OPERATIVA",null,{"$f":"(C23-C24)","v":{"v":297871.4900011495,"d":"$ 297,871.49"}},{"$f":"(D23-D24)","v":{"v":310854.6628659651,"d":"$ 310,854.66"}},{"v":320782.4849010429,"d":"$ 320,782.48"},{"v":330505.28795142914,"d":"$ 330,505.29"},{"v":344150.09403819515,"d":"$ 344,150.09"},{"v":347096.37435112434,"d":"$ 347,096.37"},{"v":355371.29763379693,"d":"$ 355,371.30"},{"v":363238.0839319145,"d":"$ 363,238.08"},{"v":368889.8192295137,"d":"$ 368,889.82"},{"v":371918.7839960311,"d":"$ 371,918.78"}]
["PARTICIPACION DE TRABAJADORES (15%) (-)",null,{"$f":"(C25*0.15)","v":{"v":44680.72350017242,"d":"$ 44,680.72"}},{"$f":"(D25*0.15)","v":{"v":46628.19942989476,"d":"$ 46,628.20"}},{"v":48117.37273515643,"d":"$ 48,117.37"},{"v":49575.79319271437,"d":"$ 49,575.79"},{"v":51622.51410572927,"d":"$ 51,622.51"},{"v":52064.45615266865,"d":"$ 52,064.46"},{"v":53305.69464506954,"d":"$ 53,305.69"},{"v":54485.71258978717,"d":"$ 54,485.71"},{"v":55333.47288442705,"d":"$ 55,333.47"},{"v":55787.81759940466,"d":"$ 55,787.82"}]
["U.A.I.",null,{"$f":"C25-C26","v":{"v":253190.76650097704,"d":"$ 253,190.77"}},{"$f":"D25-D26","v":{"v":264226.46343607036,"d":"$ 264,226.46"}},{"v":272665.11216588644,"d":"$ 272,665.11"},{"v":280929.49475871475,"d":"$ 280,929.49"},{"v":292527.57993246586,"d":"$ 292,527.58"},{"v":295031.9181984557,"d":"$ 295,031.92"},{"v":302065.6029887274,"d":"$ 302,065.60"},{"v":308752.3713421273,"d":"$ 308,752.37"},{"v":313556.34634508664,"d":"$ 313,556.35"},{"v":316130.96639662643,"d":"$ 316,130.97"}]
["IMPUESTO A LA RENTA (25%) (-)",null,{"$f":"0.25*C27","v":{"v":63297.69162524426,"d":"$ 63,297.69"}},{"$f":"0.25*D27","v":{"v":66056.61585901759,"d":"$ 66,056.62"}},{"v":68166.27804147161,"d":"$ 68,166.28"},{"v":70232.37368967869,"d":"$ 70,232.37"},{"v":73131.89498311646,"d":"$ 73,131.89"},{"v":73757.97954961393,"d":"$ 73,757.98"},{"v":75516.40074718185,"d":"$ 75,516.40"},{"v":77188.09283553183,"d":"$ 77,188.09"},{"v":78389.08658627166,"d":"$ 78,389.09"},{"v":79032.74159915661,"d":"$ 79,032.74"}]
["UTILIDAD NETA",null,{"$f":"C27-C28","v":{"v":189893.07487573277,"d":"$ 189,893.07"}},{"$f":"D27-D28","v":{"v":198169.84757705277,"d":"$ 198,169.85"}},{"v":204498.83412441483,"d":"$ 204,498.83"},{"v":210697.12106903607,"d":"$ 210,697.12"},{"v":219395.68494934938,"d":"$ 219,395.68"},{"v":221273.93864884178,"d":"$ 221,273.94"},{"v":226549.20224154554,"d":"$ 226,549.20"},{"v":231564.2785065955,"d":"$ 231,564.28"},{"v":235167.259758815,"d":"$ 235,167.26"},{"v":237098.22479746983,"d":"$ 237,098.22"}]
["INV. INICIAL EN OBRA FISICA (AÑO 0) (-)",{"$f":"('INV.OBRA CIVIL  MAQUINARIA(A.2)'!E8)*-1","v":{"v":-133000,"d":"$ (133,000.00)"}}]
["INV. INICIAL EN MAQUINARIAS Y EQUIPOS (AÑO 0) (-)",{"$f":"('INV.OBRA CIVIL  MAQUINARIA(A.2)'!D36)*-1","v":{"v":-107001,"d":"$ (107,001.00)"}}]
["GASTOS DE CONSTITUCION (AÑO 0) (-)",{"$f":"('GASTOS CONSTITUCION(A.1)'!B15)*-1","v":{"v":-1161,"d":"$ (1,161.00)"}}]
["CAPITAL DE TRABAJO (AÑO 0) (-)",{"$f":"MIN('CAPITAL TRABAJO(G)'!C17:N17)","v":{"v":-256060.47977605698,"d":"$ (256,060.48)"}}]
["VALOR DE DESECHO DEL PROYECTO (+) ) (AÑO 10)",{"$nulls":10},{"v":1030664.8757529057,"d":"$ 1,030,664.88"}]
["GASTOS DE AMORTIZACION",null,{"$f":"('GASTOS FINANCIEROS(A)'!$E$9)*-1","v":{"v":-4664.054565309418,"d":"$ (4,664.05)"}},{"$f":"('GASTOS FINANCIEROS(A)'!$E$10)*-1","v":{"v":-5410.303295758924,"d":"$ (5,410.30)"}},{"$f":"('GASTOS FINANCIEROS(A)'!$E$11)*-1","v":{"v":-6275.9518230803515,"d":"$ (6,275.95)"}},{"$f":"('GASTOS FINANCIEROS(A)'!$E$12)*-1","v":{"v":-7280.104114773207,"d":"$ (7,280.10)"}},{"$f":"('GASTOS FINANCIEROS(A)'!$E$13)*-1","v":{"v":-8444.920773136919,"d":"$ (8,444.92)"}},{"$f":"('GASTOS FINANCIEROS(A)'!$E$14)*-1","v":{"v":-9796.108096838827,"d":"$ (9,796.11)"}},{"$f":"('GASTOS FINANCIEROS(A)'!$E$15)*-1","v":{"v":-11363.48539233304,"d":"$ (11,363.49)"}},{"$f":"('GASTOS FINANCIEROS(A)'!$E$16)*-1","v":{"v":-13181.643055106326,"d":"$ (13,181.64)"}},{"$f":"('GASTOS FINANCIEROS(A)'!$E$17)*-1","v":{"v":-15290.705943923338,"d":"$ (15,290.71)"}},{"$f":"('GASTOS FINANCIEROS(A)'!$E$18)*-1","v":{"v":-17737.21889495107,"d":"$ (17,737.22)"}}]
["GASTO DE DEPRECIACION ",null,{"$f":"'GASTOS OPERATIVOS(D)'!C9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"'GASTOS OPERATIVOS(D)'!D9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"'GASTOS OPERATIVOS(D)'!E9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"'GASTOS OPERATIVOS(D)'!F9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"'GASTOS OPERATIVOS(D)'!G9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"'GASTOS OPERATIVOS(D)'!H9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"'GASTOS OPERATIVOS(D)'!I9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"'GASTOS OPERATIVOS(D)'!J9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"'GASTOS OPERATIVOS(D)'!K9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}},{"$f":"'GASTOS OPERATIVOS(D)'!L9","v":{"v":14678.433333333332,"d":"$ 14,678.43"}}]
["FLUJO NETO DE EFECTIVO",{"$f":"SUM(B30:B36)","v":{"v":-497222.47977605695,"d":"$ (497,222.48)"}},{"$f":"SUM(C29:C36)","v":{"v":199907.45364375666,"d":"$ 199,907.45"}},{"$f":"SUM(D29:D36)","v":{"v":207437.97761462716,"d":"$ 207,437.98"}},{"v":212901.3156346678,"d":"$ 212,901.32"},{"v":218095.45028759618,"d":"$ 218,095.45"},{"v":225629.19750954577,"d":"$ 225,629.20"},{"v":226156.26388533626,"d":"$ 226,156.26"},{"v":229864.15018254583,"d":"$ 229,864.15"},{"v":233061.06878482248,"d":"$ 233,061.07"},{"v":234554.987148225,"d":"$ 234,554.99"},{"v":1264704.314988758,"d":"$ 1,264,704.31"}]
["FLUJO NETO DE EFECTIVO ACUMULADO",null,{"$f":"C37","v":{"v":199907.45364375666,"d":"$ 199,907.45"}},{"$f":"(D37+C38)","v":{"v":407345.4312583838,"d":"$ 407,345.43"}},{"$f":"(E37+D38)","v":{"v":620246.7468930515,"d":"$ 620,246.75"}},{"v":838342.1971806478,"d":"$ 838,342.20"},{"v":1063971.3946901935,"d":"$ 1,063,971.39"},{"v":1290127.6585755297,"d":"$ 1,290,127.66"},{"v":1519991.8087580756,"d":"$ 1,519,991.81"},{"v":1753052.877542898,"d":"$ 1,753,052.88"},{"v":1987607.8646911231,"d":"$ 1,987,607.86"},{"v":3252312.179679881,"d":"$ 3,252,312.18"}]
["TMAR",{"$f":"'VALOR DE DESECHO Y TMAR(F)(F.1)'!D18","v":{"v":0.13786,"d":"14%"}}]
["VAN (VALOR ACTUAL NETO) (VALOR PRESENTE FLUJOS NETOS)",{"$f":"NPV(B39,B37:L37)","v":{"v":819772.1937612949,"d":"$ 819,772.19"}}]
["TIR ",{"$f":"IRR(B37:L37)","v":{"v":0.43815096079537047,"d":"44%"}}]
[]
["FLUJO CAJA PROMEDIO ANUAL",{"$f":"AVERAGE(B37:L37)","v":{"v":250462.69999125676,"d":"$ 250,462.70"}}]

{"sheet":"ESTADO RESULTADO(I)","index":10,"n_rows":28,"n_cols":11,"rows_kept":28,"merged":[[0,0,0,10]]}
["ESTADO DE RESULTADOS"]
[null,"AÑO 1","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"]
[]
["INGRESOS POR SERVICIOS ",{"$f":"'FLUJO DE CAJA(H)'!C8","v":{"v":582906.6426873166,"d":"$ 582,906.64"}},{"$f":"'FLUJO DE CAJA(H)'!D8","v":{"v":612051.9748216824,"d":"$ 612,051.97"}},{"$f":"'FLUJO DE CAJA(H)'!E8","v":{"v":642654.5735627667,"d":"$ 642,654.57"}},{"$f":"'FLUJO DE CAJA(H)'!F8","v":{"v":674787.302240905,"d":"$ 674,787.30"}},{"$f":"'FLUJO DE CAJA(H)'!G8","v":{"v":708526.6673529502,"d":"$ 708,526.67"}},{"$f":"'FLUJO DE CAJA(H)'!H8","v":{"v":743953.0007205978,"d":"$ 743,953.00"}},{"$f":"'FLUJO DE CAJA(H)'!I8","v":{"v":781150.6507566277,"d":"$ 781,150.65"}},{"$f":"'FLUJO DE CAJA(H)'!J8","v":{"v":820208.1832944591,"d":"$ 820,208.18"}},{"$f":"'FLUJO DE CAJA(H)'!K8","v":{"v":861218.592459182,"d":"$ 861,218.59"}},{"$f":"'FLUJO DE CAJA(H)'!L8","v":{"v":904279.5220821414,"d":"$ 904,279.52"}}]
["COSTO DE PRODUCCION",0,0,0,0,0,0,0,0,0,0]
["UTILIDAD BRUTA",{"$f":"B4-B5","v":{"v":582906.6426873166,"d":"$ 582,906.64"}},{"$f":"C4-C5","v":{"v":612051.9748216824,"d":"$ 612,051.97"}},{"v":642654.5735627667,"d":"$ 642,654.57"},{"v":674787.302240905,"d":"$ 674,787.30"},{"v":708526.6673529502,"d":"$ 708,526.67"},{"v":743953.0007205978,"d":"$ 743,953.00"},{"v":781150.6507566277,"d":"$ 781,150.65"},{"v":820208.1832944591,"d":"$ 820,208.18"},{"v":861218.592459182,"d":"$ 861,218.59"},{"v":904279.5220821414,"d":"$ 904,279.52"}]
["GASTOS OPERATIVOS (-)"]
["SERVICIOS BASICOS",{"$f":"'FLUJO DE CAJA(H)'!C12","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'FLUJO DE CAJA(H)'!D12","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'FLUJO DE CAJA(H)'!E12","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'FLUJO DE CAJA(H)'!F12","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'FLUJO DE CAJA(H)'!G12","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'FLUJO DE CAJA(H)'!H12","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'FLUJO DE CAJA(H)'!I12","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'FLUJO DE CAJA(H)'!J12","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'FLUJO DE CAJA(H)'!K12","v":{"v":8901.6,"d":"$ 8,901.60"}},{"$f":"'FLUJO DE CAJA(H)'!L12","v":{"v":8901.6,"d":"$ 8,901.60"}}]
["SUMINISTRO DE OFICINA",{"$f":"'FLUJO DE CAJA(H)'!C13","v":{"v":100,"d":"$ 100.00"}},{"$f":"'FLUJO DE CAJA(H)'!D13","v":{"v":100,"d":"$ 100.00"}},{"$f":"'FLUJO DE CAJA(H)'!E13","v":{"v":100,"d":"$ 100.00"}},{"$f":"'FLUJO DE CAJA(H)'!F13","v":{"v":120,"d":"$ 120.00"}},{"$f":"'FLUJO DE CAJA(H)'!G13","v":{"v":120,"d":"$ 120.00"}},{"$f":"'FLUJO DE CAJA(H)'!H13","v":{"v":130,"d":"$ 130.00"}},{"$f":"'FLUJO DE CAJA(H)'!I13","v":{"v":130,"d":"$ 130.00"}},{"$f":"'FLUJO DE CAJA(H)'!J13","v":{"v":150,"d":"$ 150.00"}},{"$f":"'FLUJO DE CAJA(H)'!K13","v":{"v":150,"d":"$ 150.00"}},{"$f":"'FLUJO DE CAJA(H)'!L13","v":{"v":150,"d":"$ 150.00"}}]
["MANTENIMIENTO MAQUINARIAS ",{"$f":"'FLUJO DE CAJA(H)'!C14","v":{"v":1000,"d":"$ 1,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!D14","v":{"v":1000,"d":"$ 1,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!E14","v":{"v":2000,"d":"$ 2,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!F14","v":{"v":3000,"d":"$ 3,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!G14","v":{"v":5000,"d":"$ 5,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!H14","v":{"v":1000,"d":"$ 1,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!I14","v":{"v":1000,"d":"$ 1,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!J14","v":{"v":2000,"d":"$ 2,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!K14","v":{"v":3000,"d":"$ 3,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!L14","v":{"v":5000,"d":"$ 5,000.00"}}]
["COMBUSTIBLES ",{"$f":"'FLUJO DE CAJA(H)'!C15","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!D15","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!E15","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!F15","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!G15","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!H15","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!I15","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!J15","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!K15","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!L15","v":{"v":5400,"d":"$ 5,400.00"}}]
["CAPACITACION",{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}},{"$f":"'GASTOS OPERATIVOS(D)'!$C$10","v":{"v":5400,"d":"$ 5,400.00"}}]
["GASTOS DE PUBLICIDAD",{"$f":"'FLUJO DE CAJA(H)'!C17","v":{"v":9156,"d":"$ 9,156.00"}},{"$f":"'FLUJO DE CAJA(H)'!D17","v":{"v":9156,"d":"$ 9,156.00"}},{"$f":"'FLUJO DE CAJA(H)'!E17","v":{"v":6409.200000000001,"d":"$ 6,409.20"}},{"$f":"'FLUJO DE CAJA(H)'!F17","v":{"v":4486.4400000000005,"d":"$ 4,486.44"}},{"$f":"'FLUJO DE CAJA(H)'!G17","v":{"v":3140.5080000000007,"d":"$ 3,140.51"}},{"$f":"'FLUJO DE CAJA(H)'!H17","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"$f":"'FLUJO DE CAJA(H)'!I17","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"$f":"'FLUJO DE CAJA(H)'!J17","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"$f":"'FLUJO DE CAJA(H)'!K17","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}},{"$f":"'FLUJO DE CAJA(H)'!L17","v":{"v":1570.2540000000004,"d":"$ 1,570.25"}}]
["SUELDOS Y SALARIOS",{"$f":"'FLUJO DE CAJA(H)'!C22","v":{"v":266400,"d":"$ 266,400.00"}},{"$f":"'FLUJO DE CAJA(H)'!D22","v":{"v":283308.4079999997,"d":"$ 283,308.41"}},{"$f":"'FLUJO DE CAJA(H)'!E22","v":{"v":303102.0332333275,"d":"$ 303,102.03"}},{"$f":"'FLUJO DE CAJA(H)'!F22","v":{"v":325573.35115277243,"d":"$ 325,573.35"}},{"$f":"'FLUJO DE CAJA(H)'!G22","v":{"v":347486.79483641544,"d":"$ 347,486.79"}},{"$f":"'FLUJO DE CAJA(H)'!H22","v":{"v":375737.7812148357,"d":"$ 375,737.78"}},{"$f":"'FLUJO DE CAJA(H)'!I22","v":{"v":406227.8852636872,"d":"$ 406,227.89"}},{"$f":"'FLUJO DE CAJA(H)'!J22","v":{"v":440216.78916617436,"d":"$ 440,216.79"}},{"$f":"'FLUJO DE CAJA(H)'!K22","v":{"v":478684.5259221151,"d":"$ 478,684.53"}},{"$f":"'FLUJO DE CAJA(H)'!L22","v":{"v":523163.00372958474,"d":"$ 523,163.00"}}]
["EBITDA",{"$f":"(B6-B8-B9-B10-B11-B12+B13-B14)","v":{"v":304861.04268731666,"d":"$ 304,861.04"}},{"$f":"(C6-C8-C9-C10-C11-C12+C13-C14)","v":{"v":317097.96682168276,"d":"$ 317,097.97"}},{"v":324160.14032943913,"d":"$ 324,160.14"},{"v":330878.79108813254,"d":"$ 330,878.79"},{"v":339358.7805165348,"d":"$ 339,358.78"},{"v":348953.8735057621,"d":"$ 348,953.87"},{"v":355661.4194929405,"d":"$ 355,661.42"},{"v":359710.04812828475,"d":"$ 359,710.05"},{"v":361252.7205370669,"d":"$ 361,252.72"},{"v":357835.1723525566,"d":"$ 357,835.17"}]
["GASTOS DEPRECIACION DE EQUIPOS COMPUTACION",{"$f":"'FLUJO DE CAJA(H)'!C18","v":{"v":800,"d":"$ 800.00"}},{"$f":"'FLUJO DE CAJA(H)'!D18","v":{"v":800,"d":"$ 800.00"}},{"$f":"'FLUJO DE CAJA(H)'!E18","v":{"v":800,"d":"$ 800.00"}},{"$f":"'FLUJO DE CAJA(H)'!F18","v":{"v":800,"d":"$ 800.00"}},{"$f":"'FLUJO DE CAJA(H)'!G18","v":{"v":800,"d":"$ 800.00"}},{"$f":"'FLUJO DE CAJA(H)'!H18","v":{"v":800,"d":"$ 800.00"}},{"$f":"'FLUJO DE CAJA(H)'!I18","v":{"v":800,"d":"$ 800.00"}},{"$f":"'FLUJO DE CAJA(H)'!J18","v":{"v":800,"d":"$ 800.00"}},{"$f":"'FLUJO DE CAJA(H)'!K18","v":{"v":800,"d":"$ 800.00"}},{"$f":"'FLUJO DE CAJA(H)'!L18","v":{"v":800,"d":"$ 800.00"}}]
["GASTOS DEPRECIACION MUEBLES ENSERES",{"$f":"'FLUJO DE CAJA(H)'!C19","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'FLUJO DE CAJA(H)'!D19","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'FLUJO DE CAJA(H)'!E19","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'FLUJO DE CAJA(H)'!F19","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'FLUJO DE CAJA(H)'!G19","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'FLUJO DE CAJA(H)'!H19","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'FLUJO DE CAJA(H)'!I19","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'FLUJO DE CAJA(H)'!J19","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'FLUJO DE CAJA(H)'!K19","v":{"v":95.1,"d":"$ 95.10"}},{"$f":"'FLUJO DE CAJA(H)'!L19","v":{"v":95.1,"d":"$ 95.10"}}]
["GASTOS DEPRECIACION VEHICULOS",{"$f":"'FLUJO DE CAJA(H)'!C20","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!D20","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!E20","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!F20","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!G20","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!H20","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!I20","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!J20","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!K20","v":{"v":4000,"d":"$ 4,000.00"}},{"$f":"'FLUJO DE CAJA(H)'!L20","v":{"v":4000,"d":"$ 4,000.00"}}]
["GASTOS DEPRECIACION DE MAQUINARIAS",{"$f":"'FLUJO DE CAJA(H)'!C21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'FLUJO DE CAJA(H)'!D21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'FLUJO DE CAJA(H)'!E21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'FLUJO DE CAJA(H)'!F21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'FLUJO DE CAJA(H)'!G21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'FLUJO DE CAJA(H)'!H21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'FLUJO DE CAJA(H)'!I21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'FLUJO DE CAJA(H)'!J21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'FLUJO DE CAJA(H)'!K21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}},{"$f":"'FLUJO DE CAJA(H)'!L21","v":{"v":9783.333333333332,"d":"$ 9,783.33"}}]
["AMORTIZACIONES",{"$f":"'GASTOS FINANCIEROS(A)'!$E$9","v":{"v":4664.054565309418,"d":"$ 4,664.05"}},{"$f":"'GASTOS FINANCIEROS(A)'!$E$10","v":{"v":5410.303295758924,"d":"$ 5,410.30"}},{"$f":"'GASTOS FINANCIEROS(A)'!$E$11","v":{"v":6275.9518230803515,"d":"$ 6,275.95"}},{"$f":"'GASTOS FINANCIEROS(A)'!$E$12","v":{"v":7280.104114773207,"d":"$ 7,280.10"}},{"$f":"'GASTOS FINANCIEROS(A)'!$E$13","v":{"v":8444.920773136919,"d":"$ 8,444.92"}},{"$f":"'GASTOS FINANCIEROS(A)'!$E$14","v":{"v":9796.108096838827,"d":"$ 9,796.11"}},{"$f":"'GASTOS FINANCIEROS(A)'!$E$15","v":{"v":11363.48539233304,"d":"$ 11,363.49"}},{"$f":"'GASTOS FINANCIEROS(A)'!$E$16","v":{"v":13181.643055106326,"d":"$ 13,181.64"}},{"$f":"'GASTOS FINANCIEROS(A)'!$E$17","v":{"v":15290.705943923338,"d":"$ 15,290.71"}},{"$f":"'GASTOS FINANCIEROS(A)'!$E$18","v":{"v":17737.21889495107,"d":"$ 17,737.22"}}]
["UTILIDAD OPERATIVA",{"$f":"(B15-B16-B17-B18-B19-B20)","v":{"v":285518.55478867394,"d":"$ 285,518.55"}},{"$f":"(C15-C16-C17-C18-C19-C20)","v":{"v":297009.23019259056,"d":"$ 297,009.23"}},{"v":303205.7551730255,"d":"$ 303,205.76"},{"v":308920.253640026,"d":"$ 308,920.25"},{"v":316235.4264100646,"d":"$ 316,235.43"},{"v":324479.33207559,"d":"$ 324,479.33"},{"v":329619.5007672741,"d":"$ 329,619.50"},{"v":331849.9717398451,"d":"$ 331,849.97"},{"v":331283.5812598103,"d":"$ 331,283.58"},{"v":325419.52012427227,"d":"$ 325,419.52"}]
["OTROS GASTOS"]
["GASTOS FINANCIERO (PAGO DE INTERESES) (-)",{"$f":"'FLUJO DE CAJA(H)'!C24","v":{"v":15911.119352833824,"d":"$ 15,911.12"}},{"$f":"'FLUJO DE CAJA(H)'!D24","v":{"v":15164.870622384318,"d":"$ 15,164.87"}},{"$f":"'FLUJO DE CAJA(H)'!E24","v":{"v":14299.22209506289,"d":"$ 14,299.22"}},{"$f":"'FLUJO DE CAJA(H)'!F24","v":{"v":13295.069803370036,"d":"$ 13,295.07"}},{"$f":"'FLUJO DE CAJA(H)'!G24","v":{"v":12130.253145006323,"d":"$ 12,130.25"}},{"$f":"'FLUJO DE CAJA(H)'!H24","v":{"v":10779.065821304415,"d":"$ 10,779.07"}},{"$f":"'FLUJO DE CAJA(H)'!I24","v":{"v":9211.688525810203,"d":"$ 9,211.69"}},{"$f":"'FLUJO DE CAJA(H)'!J24","v":{"v":7393.530863036916,"d":"$ 7,393.53"}},{"$f":"'FLUJO DE CAJA(H)'!K24","v":{"v":5284.467974219904,"d":"$ 5,284.47"}},{"$f":"'FLUJO DE CAJA(H)'!L24","v":{"v":2837.9550231921703,"d":"$ 2,837.96"}}]
["UTILIDAD OPERATIVA",{"$f":"(B21-B23)","v":{"v":269607.4354358401,"d":"$ 269,607.44"}},{"$f":"(C21-C23)","v":{"v":281844.35957020626,"d":"$ 281,844.36"}},{"v":288906.5330779626,"d":"$ 288,906.53"},{"v":295625.183836656,"d":"$ 295,625.18"},{"v":304105.1732650583,"d":"$ 304,105.17"},{"v":313700.2662542856,"d":"$ 313,700.27"},{"v":320407.8122414639,"d":"$ 320,407.81"},{"v":324456.4408768082,"d":"$ 324,456.44"},{"v":325999.1132855904,"d":"$ 325,999.11"},{"v":322581.5651010801,"d":"$ 322,581.57"}]
["PARTICIPACION DE TRABAJADORES (15%) (-)",{"$f":"(B24*15%)","v":{"v":40441.11531537602,"d":"$ 40,441.12"}},{"$f":"(C24*15%)","v":{"v":42276.653935530936,"d":"$ 42,276.65"}},{"v":43335.979961694386,"d":"$ 43,335.98"},{"v":44343.777575498396,"d":"$ 44,343.78"},{"v":45615.775989758746,"d":"$ 45,615.78"},{"v":47055.039938142836,"d":"$ 47,055.04"},{"v":48061.17183621959,"d":"$ 48,061.17"},{"v":48668.46613152123,"d":"$ 48,668.47"},{"v":48899.866992838564,"d":"$ 48,899.87"},{"v":48387.234765162015,"d":"$ 48,387.23"}]
["UTILIDAD OPERATIVA ANTES IMPUESTO",{"$f":"(B24-B25)","v":{"v":229166.32012046408,"d":"$ 229,166.32"}},{"$f":"(C24-C25)","v":{"v":239567.70563467534,"d":"$ 239,567.71"}},{"v":245570.5531162682,"d":"$ 245,570.55"},{"v":251281.4062611576,"d":"$ 251,281.41"},{"v":258489.39727529956,"d":"$ 258,489.40"},{"v":266645.22631614277,"d":"$ 266,645.23"},{"v":272346.6404052443,"d":"$ 272,346.64"},{"v":275787.974745287,"d":"$ 275,787.97"},{"v":277099.24629275186,"d":"$ 277,099.25"},{"v":274194.3303359181,"d":"$ 274,194.33"}]
["IMPUESTO A LA RENTA (25%) (-)",{"$f":"(B26*25%)","v":{"v":57291.58003011602,"d":"$ 57,291.58"}},{"$f":"(C26*25%)","v":{"v":59891.926408668834,"d":"$ 59,891.93"}},{"v":61392.63827906705,"d":"$ 61,392.64"},{"v":62820.3515652894,"d":"$ 62,820.35"},{"v":64622.34931882489,"d":"$ 64,622.35"},{"v":66661.30657903569,"d":"$ 66,661.31"},{"v":68086.66010131108,"d":"$ 68,086.66"},{"v":68946.99368632174,"d":"$ 68,946.99"},{"v":69274.81157318797,"d":"$ 69,274.81"},{"v":68548.58258397953,"d":"$ 68,548.58"}]
["UTILIDAD NETA",{"$f":"(B26-B27)","v":{"v":171874.74009034806,"d":"$ 171,874.74"}},{"$f":"(C26-C27)","v":{"v":179675.7792260065,"d":"$ 179,675.78"}},{"v":184177.91483720113,"d":"$ 184,177.91"},{"v":188461.0546958682,"d":"$ 188,461.05"},{"v":193867.04795647468,"d":"$ 193,867.05"},{"v":199983.91973710706,"d":"$ 199,983.92"},{"v":204259.98030393323,"d":"$ 204,259.98"},{"v":206840.98105896523,"d":"$ 206,840.98"},{"v":207824.4347195639,"d":"$ 207,824.43"},{"v":205645.7477519386,"d":"$ 205,645.75"}]

{"sheet":"VAN Y TIR(J)(J.1)","index":11,"n_rows":16,"n_cols":2,"rows_kept":16,"merged":[[1,0,1,1]]}
["anexo K"]
["CALCULO DEL TIR Y VAN"]
["TASA","FLUJOS"]
[{"$f":"'VALOR DE DESECHO Y TMAR(F)(F.1)'!D13","v":{"v":0.13786,"d":"14%"}},{"$f":"'FLUJO DE CAJA(H)'!B37","v":{"v":-497222.47977605695,"d":"$ (497,222.48)"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!C37","v":{"v":199907.45364375666,"d":"$ 199,907.45"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!D37","v":{"v":207437.97761462716,"d":"$ 207,437.98"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!E37","v":{"v":212901.3156346678,"d":"$ 212,901.32"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!F37","v":{"v":218095.45028759618,"d":"$ 218,095.45"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!G37","v":{"v":225629.19750954577,"d":"$ 225,629.20"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!H37","v":{"v":226156.26388533626,"d":"$ 226,156.26"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!I37","v":{"v":229864.15018254583,"d":"$ 229,864.15"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!J37","v":{"v":233061.06878482248,"d":"$ 233,061.07"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!K37","v":{"v":234554.987148225,"d":"$ 234,554.99"}}]
[null,{"$f":"'FLUJO DE CAJA(H)'!L37","v":{"v":1264704.314988758,"d":"$ 1,264,704.31"}}]
["VAN",{"$f":"NPV(A4,B4:B14)","v":{"v":819772.1937612949,"d":"$ 819,772.19"}}]
["TIR",{"$f":"IRR(B4:B14)","v":{"v":0.43815096079537047,"d":"44%"}}]

{"sheet":"PAY BACK(K)","index":12,"n_rows":18,"n_cols":11,"rows_kept":18,"merged":[[0,0,0,2],[8,4,8,5],[19,0,19,1],[19,3,19,4],[20,0,20,1],[21,0,21,1]]}
["PERIODO DE RECUPERACION"]
["AÑO","FLUJO","REDUCIENDO"]
[0,{"$f":"'FLUJO DE CAJA(H)'!B37","v":{"v":-497222.47977605695,"d":"(497,222.48)"}},{"$f":"B3","v":{"v":-497222.47977605695,"d":"(497,222.48)"}}]
[1,{"$f":"'FLUJO DE CAJA(H)'!C37","v":{"v":199907.45364375666,"d":"199,907.45"}},{"$f":"(C3+B4)","v":{"v":-297315.02613230026,"d":"(297,315.03)"}}]
[2,{"$f":"'FLUJO DE CAJA(H)'!D37","v":{"v":207437.97761462716,"d":"207,437.98"}},{"$f":"(C4+B5)","v":{"v":-89877.0485176731,"d":"(89,877.05)"}}]
[3,{"$f":"'FLUJO DE CAJA(H)'!E37","v":{"v":212901.3156346678,"d":"212,901.32"}},{"$f":"(C5+B6)","v":{"v":123024.26711699468,"d":"123,024.27"}}]
[4,{"$f":"'FLUJO DE CAJA(H)'!F37","v":{"v":218095.45028759618,"d":"218,095.45"}},{"v":341119.71740459086,"d":"341,119.72"}]
[5,{"$f":"'FLUJO DE CAJA(H)'!G37","v":{"v":225629.19750954577,"d":"225,629.20"}},{"v":566748.9149141366,"d":"566,748.91"}]
[6,{"$f":"'FLUJO DE CAJA(H)'!H37","v":{"v":226156.26388533626,"d":"226,156.26"}},{"v":792905.1787994729,"d":"792,905.18"},null,"DATOS"]
[7,{"$f":"'FLUJO DE CAJA(H)'!I37","v":{"v":229864.15018254583,"d":"229,864.15"}},{"v":1022769.3289820186,"d":"1,022,769.33"},null,"AÑO",2]
[8,{"$f":"'FLUJO DE CAJA(H)'!J37","v":{"v":233061.06878482248,"d":"233,061.07"}},{"v":1255830.397766841,"d":"1,255,830.40"},null,"ULTIMO NEGATIVO",{"v":89877.05,"d":"89,877.05"}]
[9,{"$f":"'FLUJO DE CAJA(H)'!K37","v":{"v":234554.987148225,"d":"234,554.99"}},{"v":1490385.3849150662,"d":"1,490,385.38"},null,"FLUJO SIGUIENTE",{"$f":"B6","v":{"v":212901.3156346678,"d":"212,901.32"}}]
[10,{"$f":"'FLUJO DE CAJA(H)'!L37","v":{"v":1264704.314988758,"d":"1,264,704.31"}},{"v":2755089.6999038244,"d":"2,755,089.70"},null,"PR",{"$f":"(F10+(F11/F12))","v":{"v":2.4221535678728556,"d":"2.42"}}]
[{"$nulls":5},"AÑOS"]
[]
[]
[0,1,2,3,4,5,6,7,8,9,10]
[{"$f":"'FLUJO DE CAJA(H)'!$B$37","v":{"v":-497222.47977605695,"d":"(497,222.48)"}},{"$f":"'FLUJO DE CAJA(H)'!$C$37","v":{"v":199907.45364375666,"d":"199,907.45"}},{"$f":"'FLUJO DE CAJA(H)'!$D$37","v":{"v":207437.97761462716,"d":"207,437.98"}},{"$f":"'FLUJO DE CAJA(H)'!$E$37","v":{"v":212901.3156346678,"d":"212,901.32"}},{"$f":"'FLUJO DE CAJA(H)'!$F$37","v":{"v":218095.45028759618,"d":"218,095.45"}},{"$f":"'FLUJO DE CAJA(H)'!$G$37","v":{"v":225629.19750954577,"d":"225,629.20"}},{"$f":"'FLUJO DE CAJA(H)'!$H$37","v":{"v":226156.26388533626,"d":"226,156.26"}},{"$f":"'FLUJO DE CAJA(H)'!$I$37","v":{"v":229864.15018254583,"d":"229,864.15"}},{"$f":"'FLUJO DE CAJA(H)'!$J$37","v":{"v":233061.06878482248,"d":"233,061.07"}},{"$f":"'FLUJO DE CAJA(H)'!$K$37","v":{"v":234554.987148225,"d":"234,554.99"}},{"$f":"'FLUJO DE CAJA(H)'!$L$37","v":{"v":1264704.314988758,"d":"1,264,704.31"}}]

{"sheet":"ANALISIS DE SENSIBILIDAD(L)","index":13,"n_rows":22,"n_cols":8,"rows_kept":22,"merged":[[0,0,0,5],[2,0,4,0],[2,5,7,5],[5,0,7,0],[10,0,10,7]]}
["ANALISIS DE SENSABILIDAD DE UNA VARIABLE",{"$nulls":6},"ANEXO L"]
["Escenario","Variacion","tir","tmar","Analisis","Punto critico"]
["Aumento de ingresos",{"v":0.2,"d":"20%"},{"v":0.59,"d":"59%"},{"$f":"'FLUJO DE CAJA(H)'!$B$39","v":{"v":0.13786,"d":"14%"}},{"$f":"IF(C3<D3,\"No rentable\",\" Rentable\")","v":" Rentable"},"Se puede disminuir hasta 41%"]
[null,{"v":0.4,"d":"40%"},{"v":0.74,"d":"74%"},{"$f":"'FLUJO DE CAJA(H)'!$B$39","v":{"v":0.13786,"d":"14%"}},{"$f":"IF(C4<D4,\"No rentable\",\" Rentable\")","v":" Rentable"}]
[null,{"v":0.6,"d":"60%"},{"v":0.89,"d":"89%"},{"$f":"'FLUJO DE CAJA(H)'!$B$39","v":{"v":0.13786,"d":"14%"}}," Rentable"]
["Disminucion de ingresos",{"$f":"(20%)*-1","v":{"v":-0.2,"d":"-20%"}},{"v":0.29,"d":"29%"},{"$f":"'FLUJO DE CAJA(H)'!$B$39","v":{"v":0.13786,"d":"14%"}}," Rentable"]
[null,{"$f":"(40%)*-1","v":{"v":-0.4,"d":"-40%"}},{"v":0.14,"d":"14%"},{"$f":"'FLUJO DE CAJA(H)'!$B$39","v":{"v":0.13786,"d":"14%"}}," Rentable"]
[null,{"$f":"(60%)*-1","v":{"v":-0.6,"d":"-60%"}},{"v":-0.01,"d":"-1%"},{"$f":"'FLUJO DE CAJA(H)'!$B$39","v":{"v":0.13786,"d":"14%"}},"No rentable"]
[]
[]
["VARIACIONES DE LOS INGRESOS"]
["años","valor original",{"$f":"B3","v":{"v":0.2,"d":"20%"}},{"$f":"B4","v":{"v":0.4,"d":"40%"}},{"$f":"B5","v":{"v":0.6,"d":"60%"}},{"$f":"B6","v":{"v":-0.2,"d":"-20%"}},{"$f":"B7","v":{"v":-0.4,"d":"-40%"}},{"$f":"B8","v":{"v":-0.6,"d":"-60%"}}]
[1,{"$f":"'FLUJO DE CAJA(H)'!$C$8","v":582906.6426873166},{"$f":"(B13*$C$12)+B13","v":699487.97122478},{"$f":"(B13*$D$12)+B13","v":816069.2997622433},{"$f":"(B13*$E$12)+B13","v":932650.6282997066},{"$f":"(B13*$F$12)+B13","v":466325.3141498533},{"$f":"(B13*$G$12)+B13","v":349743.98561239},{"$f":"(B13*$H$12)+B13","v":233162.65707492665}]
[2,{"$f":"'FLUJO DE CAJA(H)'!$D$8","v":612051.9748216824},734462.369786019,856872.7647503554,979283.1597146918,489641.57985734596,367231.1848930095,244820.789928673]
[3,{"$f":"'FLUJO DE CAJA(H)'!$E$8","v":642654.5735627667},771185.48827532,899716.4029878733,1028247.3177004266,514123.65885021334,385592.74413766,257061.8294251067]
[4,{"$f":"'FLUJO DE CAJA(H)'!$F$8","v":674787.302240905},809744.762689086,944702.2231372669,1079659.683585448,539829.841792724,404872.381344543,269914.920896362]
[5,{"$f":"'FLUJO DE CAJA(H)'!$H$8","v":743953.0007205978},892743.6008647174,1041534.201008837,1190324.8011529564,595162.4005764782,446371.8004323587,297581.2002882391]
[6,{"$f":"'FLUJO DE CAJA(H)'!$H$8","v":743953.0007205978},892743.6008647174,1041534.201008837,1190324.8011529564,595162.4005764782,446371.8004323587,297581.2002882391]
[7,{"$f":"'FLUJO DE CAJA(H)'!$I$8","v":781150.6507566277},937380.7809079532,1093610.9110592788,1249841.0412106044,624920.5206053022,468690.3904539766,312460.2603026511]
[8,{"$f":"'FLUJO DE CAJA(H)'!$J$8","v":820208.1832944591},984249.8199533509,1148291.4566122429,1312333.0932711347,656166.5466355673,492124.90997667547,328083.27331778366]
[9,{"$f":"'FLUJO DE CAJA(H)'!$K$8","v":861218.592459182},1033462.3109510185,1205706.029442855,1377949.7479346911,688974.8739673456,516731.1554755092,344487.43698367284]
[10,{"$f":"'FLUJO DE CAJA(H)'!$L$8","v":904279.5220821414},1085135.4264985695,1265991.330914998,1446847.2353314261,723423.6176657131,542567.7132492848,361711.8088328566]