{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["LEE PRIMERO","1 PRODUCTOS","2 NOMINA Y GASTOS","3 ACTIVOS","4 CREDITO","5 RESULTADOS","6 REGISTRO DIARIO"],"read":"whole","date_system":"1900"}

{"sheet":"LEE PRIMERO","index":0,"n_rows":19,"n_cols":1,"rows_kept":19}
[]
["MODELO FINANCIERO — RUTA DEL EMPRENDIMIENTO 2026"]
["Cámara de Comercio del Huila · Seccional Sur · Módulo 2: Finanzas básicas"]
[]
["Este archivo es la versión SIN INTERNET del Laboratorio Financiero de"]
["rutadelemprendimiento.site/finanzas.php — misma lógica, mismos resultados."]
[]
["CÓMO USARLO:"]
["1. Llena SOLO las celdas amarillas, en orden: 1 PRODUCTOS - 2 NOMINA Y GASTOS - 3 ACTIVOS - 4 CREDITO."]
["2. La hoja 5 RESULTADOS calcula todo sola: punto de equilibrio, VAN, TIR, proyeccion a 5 anos y recuperacion."]
["3. La hoja 6 REGISTRO DIARIO es tu cuaderno de ingresos y egresos del mes: usala TODOS los dias."]
[]
["LAS HOJAS ESTAN PROTEGIDAS:"]
["Solo puedes escribir en las celdas amarillas. Las formulas y resultados estan bloqueados para que"]
["no se danen por accidente. No necesitas ninguna clave para usar el archivo."]
[]
["Cifras de referencia al 2 de agosto de 2026: SMMLV $1.750.905 - factor prestacional 53,76% -"]
["IPC anual 6,14% - usura consumo 29,66% EA. Verificalas antes de firmar un credito."]
["Herramienta pedagogica: no reemplaza la asesoria de un contador."]

{"sheet":"1 PRODUCTOS","index":1,"n_rows":68,"n_cols":6,"rows_kept":68}
["TUS PRODUCTOS Y SU COSTEO — la receta de UNA unidad"]
["Tipos de item: Materia prima · Insumo · Empaque · Mercancia comprada · Servicio por unidad · Mano de obra por unidad · Jornal · Transporte · Otro"]
["Margen objetivo para el precio sugerido (%):",null,null,{"v":40,"d":"40%"},"← Comercial 30 · Agro 35 · Produccion 40 · Servicios 50. El precio sugerido es referencia: tu decides el precio final."]
[]
["PRODUCTO 1 — nombre:",null,"Café tostado 500 g"]
["Tipo de ítem","¿Qué es?","Unidad de medida","Cantidad por unidad","Costo de esa unidad","Subtotal"]
["Materia prima","Café pergamino","kg",0.55,{"v":21818,"d":"$21,818"},{"$f":"IF(N(D7)*N(E7)=0,\"\",D7*E7)","v":{"v":11999.900000000001,"d":"$12,000"}}]
["Servicio por unidad","Trilla y tueste","unidad",{"v":1,"d":"1.00"},{"v":3000,"d":"$3,000"},{"v":3000,"d":"$3,000"}]
["Empaque","Bolsa y etiqueta","unidad",{"v":1,"d":"1.00"},{"v":1800,"d":"$1,800"},{"v":1800,"d":"$1,800"}]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":4},"COSTO VARIABLE por unidad:",{"$f":"SUM(F7:F12)","v":{"v":16799.9,"d":"$16,800"}}]
["Precio SUGERIDO (según margen objetivo):",null,{"$f":"IF(F13>0,ROUND(F13/(1-$D$3/100),-2),\"\")","v":{"v":28000,"d":"$28,000"}},"Tu PRECIO de venta (acéptalo o cámbialo):",null,{"v":28000,"d":"$28,000"}]
["Margen que trabajarías con ese precio:",null,{"$f":"IF(N(F14)>0,(F14-F13)/F14*100,\"\")","v":{"v":40.00035714285714,"d":"40.0%"}},"Ventas actuales (unds/mes):",null,300]
["Capacidad máxima (unds/mes). Por máquina: unds/hora × horas/día × días. Por personas: unds/persona/día × personas × días:",{"$nulls":4},600]
[]
["PRODUCTO 2 — nombre:"]
["Tipo de ítem","¿Qué es?","Unidad de medida","Cantidad por unidad","Costo de esa unidad","Subtotal"]
[{"$nulls":5},{"$f":"IF(N(D20)*N(E20)=0,\"\",D20*E20)","v":""}]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":4},"COSTO VARIABLE por unidad:",{"$f":"SUM(F20:F25)","v":{"v":0,"d":"$0"}}]
["Precio SUGERIDO (según margen objetivo):",null,{"$f":"IF(F26>0,ROUND(F26/(1-$D$3/100),-2),\"\")","v":""},"Tu PRECIO de venta (acéptalo o cámbialo):"]
["Margen que trabajarías con ese precio:",null,{"$f":"IF(N(F27)>0,(F27-F26)/F27*100,\"\")","v":""},"Ventas actuales (unds/mes):"]
["Capacidad máxima (unds/mes). Por máquina: unds/hora × horas/día × días. Por personas: unds/persona/día × personas × días:"]
[]
["PRODUCTO 3 — nombre:"]
["Tipo de ítem","¿Qué es?","Unidad de medida","Cantidad por unidad","Costo de esa unidad","Subtotal"]
[{"$nulls":5},{"$f":"IF(N(D33)*N(E33)=0,\"\",D33*E33)","v":""}]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":4},"COSTO VARIABLE por unidad:",{"$f":"SUM(F33:F38)","v":{"v":0,"d":"$0"}}]
["Precio SUGERIDO (según margen objetivo):",null,{"$f":"IF(F39>0,ROUND(F39/(1-$D$3/100),-2),\"\")","v":""},"Tu PRECIO de venta (acéptalo o cámbialo):"]
["Margen que trabajarías con ese precio:",null,{"$f":"IF(N(F40)>0,(F40-F39)/F40*100,\"\")","v":""},"Ventas actuales (unds/mes):"]
["Capacidad máxima (unds/mes). Por máquina: unds/hora × horas/día × días. Por personas: unds/persona/día × personas × días:"]
[]
["PRODUCTO 4 — nombre:"]
["Tipo de ítem","¿Qué es?","Unidad de medida","Cantidad por unidad","Costo de esa unidad","Subtotal"]
[{"$nulls":5},{"$f":"IF(N(D46)*N(E46)=0,\"\",D46*E46)","v":""}]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":4},"COSTO VARIABLE por unidad:",{"$f":"SUM(F46:F51)","v":{"v":0,"d":"$0"}}]
["Precio SUGERIDO (según margen objetivo):",null,{"$f":"IF(F52>0,ROUND(F52/(1-$D$3/100),-2),\"\")","v":""},"Tu PRECIO de venta (acéptalo o cámbialo):"]
["Margen que trabajarías con ese precio:",null,{"$f":"IF(N(F53)>0,(F53-F52)/F53*100,\"\")","v":""},"Ventas actuales (unds/mes):"]
["Capacidad máxima (unds/mes). Por máquina: unds/hora × horas/día × días. Por personas: unds/persona/día × personas × días:"]
[]
["PRODUCTO 5 — nombre:"]
["Tipo de ítem","¿Qué es?","Unidad de medida","Cantidad por unidad","Costo de esa unidad","Subtotal"]
[{"$nulls":5},{"$f":"IF(N(D59)*N(E59)=0,\"\",D59*E59)","v":""}]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":5},""]
[{"$nulls":4},"COSTO VARIABLE por unidad:",{"$f":"SUM(F59:F64)","v":{"v":0,"d":"$0"}}]
["Precio SUGERIDO (según margen objetivo):",null,{"$f":"IF(F65>0,ROUND(F65/(1-$D$3/100),-2),\"\")","v":""},"Tu PRECIO de venta (acéptalo o cámbialo):"]
["Margen que trabajarías con ese precio:",null,{"$f":"IF(N(F66)>0,(F66-F65)/F66*100,\"\")","v":""},"Ventas actuales (unds/mes):"]
["Capacidad máxima (unds/mes). Por máquina: unds/hora × horas/día × días. Por personas: unds/persona/día × personas × días:"]

{"sheet":"2 NOMINA Y GASTOS","index":2,"n_rows":29,"n_cols":6,"rows_kept":29}
["TU EQUIPO DE TRABAJO"]
["Laboral suma automáticamente el 53,76% de prestaciones y seguridad social. Incluye TU propio sueldo."]
[]
["Cargo","Vinculación","Valor $ (mes o por jornal)","Jornales al mes (solo si aplica)","Costo mensual real","¿Dónde trabaja?"]
["Yo (mi sueldo)","Mi propio sueldo",{"v":1200000,"d":"$1,200,000"},null,{"$f":"IF(N(C5)=0,\"\",IF(B5=\"Laboral\",C5*1.5376,IF(B5=\"Jornal\",C5*N(D5),C5)))","v":{"v":1200000,"d":"$1,200,000"}},"Admón. y ventas (gasto)"]
["Recolector","Jornal",{"v":60000,"d":"$60,000"},4,{"v":240000,"d":"$240,000"},"Producción (costo)"]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":4},""]
[{"$nulls":3},"TOTAL NÓMINA MENSUAL:",{"$f":"SUM(E5:E12)","v":{"v":1440000,"d":"$1,440,000"}}]
[]
["TUS GASTOS FIJOS DEL MES"]
["La nómina de arriba y la cuota del crédito (hoja 4) se suman automáticamente: no las repitas aquí."]
[]
["Arriendo del local o lote",{"v":800000,"d":"$800,000"}]
["Servicios públicos",{"v":250000,"d":"$250,000"}]
["Internet y celular"]
["Publicidad"]
["Transporte y domicilios fijos",{"v":150000,"d":"$150,000"}]
["Papelería y aseo"]
["Mantenimiento"]
["Impuestos y tasas fijas"]
["Cuotas de créditos YA existentes"]
["Otros gastos fijos",{"v":100000,"d":"$100,000"}]
["TOTAL RUBROS:",{"$f":"SUM(B18:B27)","v":{"v":1300000,"d":"$1,300,000"}}]
["TOTAL FIJOS (rubros + nómina):",{"$f":"B28+E13","v":{"v":2740000,"d":"$2,740,000"}}]

{"sheet":"3 ACTIVOS","index":3,"n_rows":18,"n_cols":9,"rows_kept":18}
["TUS ACTIVOS: ¿ya lo tienes o de verdad debes comprarlo?"]
["Solo lo que COMPRAS sale de tu bolsillo. Pero TODO se desgasta: la depreciación se calcula según la vida útil."]
[]
["Activo","Categoría","¿Ya lo tienes?","Valor $","Vida útil (años)","Depreciación / mes",null,"Vida útil (años)"]
["Tostadora","Maquinaria y equipo","Debo comprarlo",{"v":6000000,"d":"$6,000,000"},{"$f":"IF(B5=\"\",\"\",INDEX($I$5:$I$10,MATCH(B5,$H$5:$H$10,0)))","v":10},{"$f":"IF(OR(N(D5)=0,B5=\"\"),\"\",D5/(E5*12))","v":{"v":50000,"d":"$50,000"}},null,"Maquinaria y equipo",10]
["Molino","Maquinaria y equipo","Ya lo tengo",{"v":1500000,"d":"$1,500,000"},10,{"v":12500,"d":"$12,500"},null,"Herramientas",5]
["Selladora","Herramientas","Debo comprarlo",{"v":400000,"d":"$400,000"},5,{"v":6666.666666666667,"d":"$6,667"},null,"Muebles y enseres",10]
[{"$nulls":4},"","",null,"Equipos de cómputo",5]
[{"$nulls":4},"","",null,"Vehículos",5]
[{"$nulls":4},"","",null,"Construcciones y adecuaciones",20]
[{"$nulls":4},"",""]
[{"$nulls":4},"",""]
[]
[null,null,"Inversión en COMPRAS:",{"$f":"SUMIF(C5:C12,\"Debo comprarlo\",D5:D12)","v":{"v":6400000,"d":"$6,400,000"}},"Depreciación total/mes:",{"$f":"SUM(F5:F12)","v":{"v":69166.66666666667,"d":"$69,167"}}]
[]
["Gastos diferidos (registro, licencias, INVIMA, publicidad de apertura):",null,null,{"v":1500000,"d":"$1,500,000"}]
["Capital de trabajo (inventario inicial + caja; sugerido: 2 meses de tus fijos):",null,null,{"v":2000000,"d":"$2,000,000"}]
["INVERSIÓN TOTAL:",null,null,{"$f":"D14+D16+D17","v":{"v":9900000,"d":"$9,900,000"}}]

{"sheet":"4 CREDITO","index":4,"n_rows":73,"n_cols":5,"rows_kept":73}
["TU CRÉDITO (si aplica)"]
[]
["Monto del crédito:",{"v":8000000,"d":"$8,000,000"}]
["Tasa de interés MENSUAL (%):",{"v":2,"d":"2.00"}]
["Plazo (meses):",36]
[]
["Cuota mensual:",{"$f":"IF(N(B3)*N(B5)=0,0,IF(B4=0,B3/B5,B3*(B4/100)/(1-(1+B4/100)^-B5)))","v":{"v":313862.82078238524,"d":"$313,863"}}]
["Tasa efectiva anual equivalente:",{"$f":"((1+B4/100)^12-1)*100","v":{"v":26.824179456254527,"d":"26.8%"}}]
["Total que pagarás:",{"$f":"B7*B5","v":{"v":11299061.548165869,"d":"$11,299,062"}}]
["Solo intereses:",{"$f":"B9-B3","v":{"v":3299061.548165869,"d":"$3,299,062"}}]
["Usura consumo vigente (ago-2026): 29,66% EA — si tu tasa EA la supera, es ilegal."]
[]
["Mes","Cuota","Interés","Abono a capital","Saldo"]
[{"$f":"IF(1<=$B$5,1,\"\")","v":1},{"$f":"IF(1<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(1<=$B$5,$B$3*$B$4/100,\"\")","v":{"v":160000,"d":"$160,000"}},{"$f":"IF(1<=$B$5,B14-C14,\"\")","v":{"v":153862.82078238524,"d":"$153,863"}},{"$f":"IF(1<=$B$5,$B$3-D14,\"\")","v":{"v":7846137.179217615,"d":"$7,846,137"}}]
[{"$f":"IF(2<=$B$5,2,\"\")","v":2},{"$f":"IF(2<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(2<=$B$5,E14*$B$4/100,\"\")","v":{"v":156922.7435843523,"d":"$156,923"}},{"$f":"IF(2<=$B$5,B15-C15,\"\")","v":{"v":156940.07719803293,"d":"$156,940"}},{"$f":"IF(2<=$B$5,E14-D15,\"\")","v":{"v":7689197.102019582,"d":"$7,689,197"}}]
[{"$f":"IF(3<=$B$5,3,\"\")","v":3},{"$f":"IF(3<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(3<=$B$5,E15*$B$4/100,\"\")","v":{"v":153783.94204039164,"d":"$153,784"}},{"$f":"IF(3<=$B$5,B16-C16,\"\")","v":{"v":160078.8787419936,"d":"$160,079"}},{"$f":"IF(3<=$B$5,E15-D16,\"\")","v":{"v":7529118.223277588,"d":"$7,529,118"}}]
[{"$f":"IF(4<=$B$5,4,\"\")","v":4},{"$f":"IF(4<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(4<=$B$5,E16*$B$4/100,\"\")","v":{"v":150582.36446555177,"d":"$150,582"}},{"$f":"IF(4<=$B$5,B17-C17,\"\")","v":{"v":163280.45631683347,"d":"$163,280"}},{"$f":"IF(4<=$B$5,E16-D17,\"\")","v":{"v":7365837.766960755,"d":"$7,365,838"}}]
[{"$f":"IF(5<=$B$5,5,\"\")","v":5},{"$f":"IF(5<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(5<=$B$5,E17*$B$4/100,\"\")","v":{"v":147316.7553392151,"d":"$147,317"}},{"$f":"IF(5<=$B$5,B18-C18,\"\")","v":{"v":166546.06544317014,"d":"$166,546"}},{"$f":"IF(5<=$B$5,E17-D18,\"\")","v":{"v":7199291.701517585,"d":"$7,199,292"}}]
[{"$f":"IF(6<=$B$5,6,\"\")","v":6},{"$f":"IF(6<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(6<=$B$5,E18*$B$4/100,\"\")","v":{"v":143985.8340303517,"d":"$143,986"}},{"$f":"IF(6<=$B$5,B19-C19,\"\")","v":{"v":169876.98675203355,"d":"$169,877"}},{"$f":"IF(6<=$B$5,E18-D19,\"\")","v":{"v":7029414.7147655515,"d":"$7,029,415"}}]
[{"$f":"IF(7<=$B$5,7,\"\")","v":7},{"$f":"IF(7<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(7<=$B$5,E19*$B$4/100,\"\")","v":{"v":140588.29429531103,"d":"$140,588"}},{"$f":"IF(7<=$B$5,B20-C20,\"\")","v":{"v":173274.5264870742,"d":"$173,275"}},{"$f":"IF(7<=$B$5,E19-D20,\"\")","v":{"v":6856140.188278478,"d":"$6,856,140"}}]
[{"$f":"IF(8<=$B$5,8,\"\")","v":8},{"$f":"IF(8<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(8<=$B$5,E20*$B$4/100,\"\")","v":{"v":137122.80376556955,"d":"$137,123"}},{"$f":"IF(8<=$B$5,B21-C21,\"\")","v":{"v":176740.0170168157,"d":"$176,740"}},{"$f":"IF(8<=$B$5,E20-D21,\"\")","v":{"v":6679400.171261662,"d":"$6,679,400"}}]
[{"$f":"IF(9<=$B$5,9,\"\")","v":9},{"$f":"IF(9<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(9<=$B$5,E21*$B$4/100,\"\")","v":{"v":133588.00342523324,"d":"$133,588"}},{"$f":"IF(9<=$B$5,B22-C22,\"\")","v":{"v":180274.817357152,"d":"$180,275"}},{"$f":"IF(9<=$B$5,E21-D22,\"\")","v":{"v":6499125.35390451,"d":"$6,499,125"}}]
[{"$f":"IF(10<=$B$5,10,\"\")","v":10},{"$f":"IF(10<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(10<=$B$5,E22*$B$4/100,\"\")","v":{"v":129982.5070780902,"d":"$129,983"}},{"$f":"IF(10<=$B$5,B23-C23,\"\")","v":{"v":183880.31370429503,"d":"$183,880"}},{"$f":"IF(10<=$B$5,E22-D23,\"\")","v":{"v":6315245.040200215,"d":"$6,315,245"}}]
[{"$f":"IF(11<=$B$5,11,\"\")","v":11},{"$f":"IF(11<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(11<=$B$5,E23*$B$4/100,\"\")","v":{"v":126304.9008040043,"d":"$126,305"}},{"$f":"IF(11<=$B$5,B24-C24,\"\")","v":{"v":187557.91997838096,"d":"$187,558"}},{"$f":"IF(11<=$B$5,E23-D24,\"\")","v":{"v":6127687.120221834,"d":"$6,127,687"}}]
[{"$f":"IF(12<=$B$5,12,\"\")","v":12},{"$f":"IF(12<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(12<=$B$5,E24*$B$4/100,\"\")","v":{"v":122553.74240443668,"d":"$122,554"}},{"$f":"IF(12<=$B$5,B25-C25,\"\")","v":{"v":191309.07837794855,"d":"$191,309"}},{"$f":"IF(12<=$B$5,E24-D25,\"\")","v":{"v":5936378.041843886,"d":"$5,936,378"}}]
[{"$f":"IF(13<=$B$5,13,\"\")","v":13},{"$f":"IF(13<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(13<=$B$5,E25*$B$4/100,\"\")","v":{"v":118727.56083687772,"d":"$118,728"}},{"$f":"IF(13<=$B$5,B26-C26,\"\")","v":{"v":195135.2599455075,"d":"$195,135"}},{"$f":"IF(13<=$B$5,E25-D26,\"\")","v":{"v":5741242.781898378,"d":"$5,741,243"}}]
[{"$f":"IF(14<=$B$5,14,\"\")","v":14},{"$f":"IF(14<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(14<=$B$5,E26*$B$4/100,\"\")","v":{"v":114824.85563796757,"d":"$114,825"}},{"$f":"IF(14<=$B$5,B27-C27,\"\")","v":{"v":199037.96514441766,"d":"$199,038"}},{"$f":"IF(14<=$B$5,E26-D27,\"\")","v":{"v":5542204.816753961,"d":"$5,542,205"}}]
[{"$f":"IF(15<=$B$5,15,\"\")","v":15},{"$f":"IF(15<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(15<=$B$5,E27*$B$4/100,\"\")","v":{"v":110844.09633507923,"d":"$110,844"}},{"$f":"IF(15<=$B$5,B28-C28,\"\")","v":{"v":203018.724447306,"d":"$203,019"}},{"$f":"IF(15<=$B$5,E27-D28,\"\")","v":{"v":5339186.092306655,"d":"$5,339,186"}}]
[{"$f":"IF(16<=$B$5,16,\"\")","v":16},{"$f":"IF(16<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(16<=$B$5,E28*$B$4/100,\"\")","v":{"v":106783.72184613309,"d":"$106,784"}},{"$f":"IF(16<=$B$5,B29-C29,\"\")","v":{"v":207079.09893625215,"d":"$207,079"}},{"$f":"IF(16<=$B$5,E28-D29,\"\")","v":{"v":5132106.993370403,"d":"$5,132,107"}}]
[{"$f":"IF(17<=$B$5,17,\"\")","v":17},{"$f":"IF(17<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(17<=$B$5,E29*$B$4/100,\"\")","v":{"v":102642.13986740806,"d":"$102,642"}},{"$f":"IF(17<=$B$5,B30-C30,\"\")","v":{"v":211220.6809149772,"d":"$211,221"}},{"$f":"IF(17<=$B$5,E29-D30,\"\")","v":{"v":4920886.312455425,"d":"$4,920,886"}}]
[{"$f":"IF(18<=$B$5,18,\"\")","v":18},{"$f":"IF(18<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(18<=$B$5,E30*$B$4/100,\"\")","v":{"v":98417.7262491085,"d":"$98,418"}},{"$f":"IF(18<=$B$5,B31-C31,\"\")","v":{"v":215445.09453327674,"d":"$215,445"}},{"$f":"IF(18<=$B$5,E30-D31,\"\")","v":{"v":4705441.217922148,"d":"$4,705,441"}}]
[{"$f":"IF(19<=$B$5,19,\"\")","v":19},{"$f":"IF(19<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(19<=$B$5,E31*$B$4/100,\"\")","v":{"v":94108.82435844297,"d":"$94,109"}},{"$f":"IF(19<=$B$5,B32-C32,\"\")","v":{"v":219753.99642394227,"d":"$219,754"}},{"$f":"IF(19<=$B$5,E31-D32,\"\")","v":{"v":4485687.221498206,"d":"$4,485,687"}}]
[{"$f":"IF(20<=$B$5,20,\"\")","v":20},{"$f":"IF(20<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(20<=$B$5,E32*$B$4/100,\"\")","v":{"v":89713.74442996412,"d":"$89,714"}},{"$f":"IF(20<=$B$5,B33-C33,\"\")","v":{"v":224149.07635242114,"d":"$224,149"}},{"$f":"IF(20<=$B$5,E32-D33,\"\")","v":{"v":4261538.145145785,"d":"$4,261,538"}}]
[{"$f":"IF(21<=$B$5,21,\"\")","v":21},{"$f":"IF(21<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(21<=$B$5,E33*$B$4/100,\"\")","v":{"v":85230.7629029157,"d":"$85,231"}},{"$f":"IF(21<=$B$5,B34-C34,\"\")","v":{"v":228632.05787946953,"d":"$228,632"}},{"$f":"IF(21<=$B$5,E33-D34,\"\")","v":{"v":4032906.0872663157,"d":"$4,032,906"}}]
[{"$f":"IF(22<=$B$5,22,\"\")","v":22},{"$f":"IF(22<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(22<=$B$5,E34*$B$4/100,\"\")","v":{"v":80658.12174532631,"d":"$80,658"}},{"$f":"IF(22<=$B$5,B35-C35,\"\")","v":{"v":233204.69903705892,"d":"$233,205"}},{"$f":"IF(22<=$B$5,E34-D35,\"\")","v":{"v":3799701.388229257,"d":"$3,799,701"}}]
[{"$f":"IF(23<=$B$5,23,\"\")","v":23},{"$f":"IF(23<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(23<=$B$5,E35*$B$4/100,\"\")","v":{"v":75994.02776458515,"d":"$75,994"}},{"$f":"IF(23<=$B$5,B36-C36,\"\")","v":{"v":237868.79301780008,"d":"$237,869"}},{"$f":"IF(23<=$B$5,E35-D36,\"\")","v":{"v":3561832.595211457,"d":"$3,561,833"}}]
[{"$f":"IF(24<=$B$5,24,\"\")","v":24},{"$f":"IF(24<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(24<=$B$5,E36*$B$4/100,\"\")","v":{"v":71236.65190422913,"d":"$71,237"}},{"$f":"IF(24<=$B$5,B37-C37,\"\")","v":{"v":242626.1688781561,"d":"$242,626"}},{"$f":"IF(24<=$B$5,E36-D37,\"\")","v":{"v":3319206.426333301,"d":"$3,319,206"}}]
[{"$f":"IF(25<=$B$5,25,\"\")","v":25},{"$f":"IF(25<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(25<=$B$5,E37*$B$4/100,\"\")","v":{"v":66384.12852666601,"d":"$66,384"}},{"$f":"IF(25<=$B$5,B38-C38,\"\")","v":{"v":247478.69225571922,"d":"$247,479"}},{"$f":"IF(25<=$B$5,E37-D38,\"\")","v":{"v":3071727.7340775817,"d":"$3,071,728"}}]
[{"$f":"IF(26<=$B$5,26,\"\")","v":26},{"$f":"IF(26<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(26<=$B$5,E38*$B$4/100,\"\")","v":{"v":61434.554681551635,"d":"$61,435"}},{"$f":"IF(26<=$B$5,B39-C39,\"\")","v":{"v":252428.2661008336,"d":"$252,428"}},{"$f":"IF(26<=$B$5,E38-D39,\"\")","v":{"v":2819299.467976748,"d":"$2,819,299"}}]
[{"$f":"IF(27<=$B$5,27,\"\")","v":27},{"$f":"IF(27<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(27<=$B$5,E39*$B$4/100,\"\")","v":{"v":56385.98935953496,"d":"$56,386"}},{"$f":"IF(27<=$B$5,B40-C40,\"\")","v":{"v":257476.8314228503,"d":"$257,477"}},{"$f":"IF(27<=$B$5,E39-D40,\"\")","v":{"v":2561822.6365538975,"d":"$2,561,823"}}]
[{"$f":"IF(28<=$B$5,28,\"\")","v":28},{"$f":"IF(28<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(28<=$B$5,E40*$B$4/100,\"\")","v":{"v":51236.45273107795,"d":"$51,236"}},{"$f":"IF(28<=$B$5,B41-C41,\"\")","v":{"v":262626.3680513073,"d":"$262,626"}},{"$f":"IF(28<=$B$5,E40-D41,\"\")","v":{"v":2299196.2685025902,"d":"$2,299,196"}}]
[{"$f":"IF(29<=$B$5,29,\"\")","v":29},{"$f":"IF(29<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(29<=$B$5,E41*$B$4/100,\"\")","v":{"v":45983.9253700518,"d":"$45,984"}},{"$f":"IF(29<=$B$5,B42-C42,\"\")","v":{"v":267878.8954123334,"d":"$267,879"}},{"$f":"IF(29<=$B$5,E41-D42,\"\")","v":{"v":2031317.373090257,"d":"$2,031,317"}}]
[{"$f":"IF(30<=$B$5,30,\"\")","v":30},{"$f":"IF(30<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(30<=$B$5,E42*$B$4/100,\"\")","v":{"v":40626.34746180514,"d":"$40,626"}},{"$f":"IF(30<=$B$5,B43-C43,\"\")","v":{"v":273236.4733205801,"d":"$273,236"}},{"$f":"IF(30<=$B$5,E42-D43,\"\")","v":{"v":1758080.8997696768,"d":"$1,758,081"}}]
[{"$f":"IF(31<=$B$5,31,\"\")","v":31},{"$f":"IF(31<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(31<=$B$5,E43*$B$4/100,\"\")","v":{"v":35161.617995393535,"d":"$35,162"}},{"$f":"IF(31<=$B$5,B44-C44,\"\")","v":{"v":278701.2027869917,"d":"$278,701"}},{"$f":"IF(31<=$B$5,E43-D44,\"\")","v":{"v":1479379.696982685,"d":"$1,479,380"}}]
[{"$f":"IF(32<=$B$5,32,\"\")","v":32},{"$f":"IF(32<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(32<=$B$5,E44*$B$4/100,\"\")","v":{"v":29587.5939396537,"d":"$29,588"}},{"$f":"IF(32<=$B$5,B45-C45,\"\")","v":{"v":284275.2268427315,"d":"$284,275"}},{"$f":"IF(32<=$B$5,E44-D45,\"\")","v":{"v":1195104.4701399535,"d":"$1,195,104"}}]
[{"$f":"IF(33<=$B$5,33,\"\")","v":33},{"$f":"IF(33<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(33<=$B$5,E45*$B$4/100,\"\")","v":{"v":23902.089402799073,"d":"$23,902"}},{"$f":"IF(33<=$B$5,B46-C46,\"\")","v":{"v":289960.73137958616,"d":"$289,961"}},{"$f":"IF(33<=$B$5,E45-D46,\"\")","v":{"v":905143.7387603674,"d":"$905,144"}}]
[{"$f":"IF(34<=$B$5,34,\"\")","v":34},{"$f":"IF(34<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(34<=$B$5,E46*$B$4/100,\"\")","v":{"v":18102.874775207347,"d":"$18,103"}},{"$f":"IF(34<=$B$5,B47-C47,\"\")","v":{"v":295759.9460071779,"d":"$295,760"}},{"$f":"IF(34<=$B$5,E46-D47,\"\")","v":{"v":609383.7927531896,"d":"$609,384"}}]
[{"$f":"IF(35<=$B$5,35,\"\")","v":35},{"$f":"IF(35<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(35<=$B$5,E47*$B$4/100,\"\")","v":{"v":12187.675855063791,"d":"$12,188"}},{"$f":"IF(35<=$B$5,B48-C48,\"\")","v":{"v":301675.14492732147,"d":"$301,675"}},{"$f":"IF(35<=$B$5,E47-D48,\"\")","v":{"v":307708.6478258681,"d":"$307,709"}}]
[{"$f":"IF(36<=$B$5,36,\"\")","v":36},{"$f":"IF(36<=$B$5,$B$7,\"\")","v":{"v":313862.82078238524,"d":"$313,863"}},{"$f":"IF(36<=$B$5,E48*$B$4/100,\"\")","v":{"v":6154.172956517362,"d":"$6,154"}},{"$f":"IF(36<=$B$5,B49-C49,\"\")","v":{"v":307708.64782586787,"d":"$307,709"}},{"$f":"IF(36<=$B$5,E48-D49,\"\")","v":{"v":2.3283064365386963E-10,"d":"$0"}}]
[{"$f":"IF(37<=$B$5,37,\"\")","v":""},{"$f":"IF(37<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(37<=$B$5,E49*$B$4/100,\"\")","v":""},{"$f":"IF(37<=$B$5,B50-C50,\"\")","v":""},{"$f":"IF(37<=$B$5,E49-D50,\"\")","v":""}]
[{"$f":"IF(38<=$B$5,38,\"\")","v":""},{"$f":"IF(38<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(38<=$B$5,E50*$B$4/100,\"\")","v":""},{"$f":"IF(38<=$B$5,B51-C51,\"\")","v":""},{"$f":"IF(38<=$B$5,E50-D51,\"\")","v":""}]
[{"$f":"IF(39<=$B$5,39,\"\")","v":""},{"$f":"IF(39<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(39<=$B$5,E51*$B$4/100,\"\")","v":""},{"$f":"IF(39<=$B$5,B52-C52,\"\")","v":""},{"$f":"IF(39<=$B$5,E51-D52,\"\")","v":""}]
[{"$f":"IF(40<=$B$5,40,\"\")","v":""},{"$f":"IF(40<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(40<=$B$5,E52*$B$4/100,\"\")","v":""},{"$f":"IF(40<=$B$5,B53-C53,\"\")","v":""},{"$f":"IF(40<=$B$5,E52-D53,\"\")","v":""}]
[{"$f":"IF(41<=$B$5,41,\"\")","v":""},{"$f":"IF(41<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(41<=$B$5,E53*$B$4/100,\"\")","v":""},{"$f":"IF(41<=$B$5,B54-C54,\"\")","v":""},{"$f":"IF(41<=$B$5,E53-D54,\"\")","v":""}]
[{"$f":"IF(42<=$B$5,42,\"\")","v":""},{"$f":"IF(42<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(42<=$B$5,E54*$B$4/100,\"\")","v":""},{"$f":"IF(42<=$B$5,B55-C55,\"\")","v":""},{"$f":"IF(42<=$B$5,E54-D55,\"\")","v":""}]
[{"$f":"IF(43<=$B$5,43,\"\")","v":""},{"$f":"IF(43<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(43<=$B$5,E55*$B$4/100,\"\")","v":""},{"$f":"IF(43<=$B$5,B56-C56,\"\")","v":""},{"$f":"IF(43<=$B$5,E55-D56,\"\")","v":""}]
[{"$f":"IF(44<=$B$5,44,\"\")","v":""},{"$f":"IF(44<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(44<=$B$5,E56*$B$4/100,\"\")","v":""},{"$f":"IF(44<=$B$5,B57-C57,\"\")","v":""},{"$f":"IF(44<=$B$5,E56-D57,\"\")","v":""}]
[{"$f":"IF(45<=$B$5,45,\"\")","v":""},{"$f":"IF(45<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(45<=$B$5,E57*$B$4/100,\"\")","v":""},{"$f":"IF(45<=$B$5,B58-C58,\"\")","v":""},{"$f":"IF(45<=$B$5,E57-D58,\"\")","v":""}]
[{"$f":"IF(46<=$B$5,46,\"\")","v":""},{"$f":"IF(46<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(46<=$B$5,E58*$B$4/100,\"\")","v":""},{"$f":"IF(46<=$B$5,B59-C59,\"\")","v":""},{"$f":"IF(46<=$B$5,E58-D59,\"\")","v":""}]
[{"$f":"IF(47<=$B$5,47,\"\")","v":""},{"$f":"IF(47<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(47<=$B$5,E59*$B$4/100,\"\")","v":""},{"$f":"IF(47<=$B$5,B60-C60,\"\")","v":""},{"$f":"IF(47<=$B$5,E59-D60,\"\")","v":""}]
[{"$f":"IF(48<=$B$5,48,\"\")","v":""},{"$f":"IF(48<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(48<=$B$5,E60*$B$4/100,\"\")","v":""},{"$f":"IF(48<=$B$5,B61-C61,\"\")","v":""},{"$f":"IF(48<=$B$5,E60-D61,\"\")","v":""}]
[{"$f":"IF(49<=$B$5,49,\"\")","v":""},{"$f":"IF(49<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(49<=$B$5,E61*$B$4/100,\"\")","v":""},{"$f":"IF(49<=$B$5,B62-C62,\"\")","v":""},{"$f":"IF(49<=$B$5,E61-D62,\"\")","v":""}]
[{"$f":"IF(50<=$B$5,50,\"\")","v":""},{"$f":"IF(50<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(50<=$B$5,E62*$B$4/100,\"\")","v":""},{"$f":"IF(50<=$B$5,B63-C63,\"\")","v":""},{"$f":"IF(50<=$B$5,E62-D63,\"\")","v":""}]
[{"$f":"IF(51<=$B$5,51,\"\")","v":""},{"$f":"IF(51<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(51<=$B$5,E63*$B$4/100,\"\")","v":""},{"$f":"IF(51<=$B$5,B64-C64,\"\")","v":""},{"$f":"IF(51<=$B$5,E63-D64,\"\")","v":""}]
[{"$f":"IF(52<=$B$5,52,\"\")","v":""},{"$f":"IF(52<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(52<=$B$5,E64*$B$4/100,\"\")","v":""},{"$f":"IF(52<=$B$5,B65-C65,\"\")","v":""},{"$f":"IF(52<=$B$5,E64-D65,\"\")","v":""}]
[{"$f":"IF(53<=$B$5,53,\"\")","v":""},{"$f":"IF(53<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(53<=$B$5,E65*$B$4/100,\"\")","v":""},{"$f":"IF(53<=$B$5,B66-C66,\"\")","v":""},{"$f":"IF(53<=$B$5,E65-D66,\"\")","v":""}]
[{"$f":"IF(54<=$B$5,54,\"\")","v":""},{"$f":"IF(54<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(54<=$B$5,E66*$B$4/100,\"\")","v":""},{"$f":"IF(54<=$B$5,B67-C67,\"\")","v":""},{"$f":"IF(54<=$B$5,E66-D67,\"\")","v":""}]
[{"$f":"IF(55<=$B$5,55,\"\")","v":""},{"$f":"IF(55<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(55<=$B$5,E67*$B$4/100,\"\")","v":""},{"$f":"IF(55<=$B$5,B68-C68,\"\")","v":""},{"$f":"IF(55<=$B$5,E67-D68,\"\")","v":""}]
[{"$f":"IF(56<=$B$5,56,\"\")","v":""},{"$f":"IF(56<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(56<=$B$5,E68*$B$4/100,\"\")","v":""},{"$f":"IF(56<=$B$5,B69-C69,\"\")","v":""},{"$f":"IF(56<=$B$5,E68-D69,\"\")","v":""}]
[{"$f":"IF(57<=$B$5,57,\"\")","v":""},{"$f":"IF(57<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(57<=$B$5,E69*$B$4/100,\"\")","v":""},{"$f":"IF(57<=$B$5,B70-C70,\"\")","v":""},{"$f":"IF(57<=$B$5,E69-D70,\"\")","v":""}]
[{"$f":"IF(58<=$B$5,58,\"\")","v":""},{"$f":"IF(58<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(58<=$B$5,E70*$B$4/100,\"\")","v":""},{"$f":"IF(58<=$B$5,B71-C71,\"\")","v":""},{"$f":"IF(58<=$B$5,E70-D71,\"\")","v":""}]
[{"$f":"IF(59<=$B$5,59,\"\")","v":""},{"$f":"IF(59<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(59<=$B$5,E71*$B$4/100,\"\")","v":""},{"$f":"IF(59<=$B$5,B72-C72,\"\")","v":""},{"$f":"IF(59<=$B$5,E71-D72,\"\")","v":""}]
[{"$f":"IF(60<=$B$5,60,\"\")","v":""},{"$f":"IF(60<=$B$5,$B$7,\"\")","v":""},{"$f":"IF(60<=$B$5,E72*$B$4/100,\"\")","v":""},{"$f":"IF(60<=$B$5,B73-C73,\"\")","v":""},{"$f":"IF(60<=$B$5,E72-D73,\"\")","v":""}]

{"sheet":"5 RESULTADOS","index":5,"n_rows":40,"n_cols":7,"rows_kept":40}
["TUS RESULTADOS FINANCIEROS"]
["Esta hoja no se edita (salvo los 3 parámetros de proyección): todo se calcula desde las hojas 1 a 4."]
[]
["Ventas del mes",{"$f":"N('1 PRODUCTOS'!F14)*N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F27)*N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F40)*N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F53)*N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F66)*N('1 PRODUCTOS'!F67)","v":{"v":8400000,"d":"$8,400,000"}}]
["Margen de contribución del mes",{"$f":"(N('1 PRODUCTOS'!F14)-N('1 PRODUCTOS'!F13))*N('1 PRODUCTOS'!F15)+(N('1 PRODUCTOS'!F27)-N('1 PRODUCTOS'!F26))*N('1 PRODUCTOS'!F28)+(N('1 PRODUCTOS'!F40)-N('1 PRODUCTOS'!F39))*N('1 PRODUCTOS'!F41)+(N('1 PRODUCTOS'!F53)-N('1 PRODUCTOS'!F52))*N('1 PRODUCTOS'!F54)+(N('1 PRODUCTOS'!F66)-N('1 PRODUCTOS'!F65))*N('1 PRODUCTOS'!F67)","v":{"v":3360029.9999999995,"d":"$3,360,030"}}]
["Margen de contribución %",{"$f":"IF(B4>0,B5/B4*100,0)","v":{"v":40.00035714285713,"d":"40.0%"}}]
["Gastos fijos + nómina (mes)",{"$f":"'2 NOMINA Y GASTOS'!B29","v":{"v":2740000,"d":"$2,740,000"}}]
["Depreciación del mes (desgaste de equipos)",{"$f":"'3 ACTIVOS'!F14","v":{"v":69166.66666666667,"d":"$69,167"}}]
["Cuota del crédito",{"$f":"'4 CREDITO'!B7","v":{"v":313862.82078238524,"d":"$313,863"}}]
["PUNTO DE EQUILIBRIO ($ ventas/mes)",{"$f":"IF(B6>0,B7/(B6/100),0)","v":{"v":6849938.839831789,"d":"$6,849,939"}}]
["Punto de equilibrio cubriendo también la cuota",{"$f":"IF(B6>0,(B7+B9)/(B6/100),0)","v":{"v":7634588.885983769,"d":"$7,634,589"}}]
["CAJA del mes (margen − fijos − cuota)",{"$f":"B5-B7-B9","v":{"v":306167.1792176143,"d":"$306,167"}}]
["Utilidad contable (margen − fijos − depreciación)",{"$f":"B5-B7-B8","v":{"v":550863.3333333329,"d":"$550,863"}}]
["Inversión total",{"$f":"'3 ACTIVOS'!D18","v":{"v":9900000,"d":"$9,900,000"}}]
["Tu aporte propio (inversión − crédito)",{"$f":"MAX(0,B14-'4 CREDITO'!B3)","v":{"v":1900000,"d":"$1,900,000"}}]
["Uso de tu capacidad instalada hoy",{"$f":"IF((N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))>0,(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))/(N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))*100,\"\")","v":{"v":50,"d":"50.0%"}}]
[]
["PARÁMETROS DE PROYECCIÓN (estos sí puedes editarlos):"]
["Crecimiento anual de ventas (%)",{"v":10,"d":"10.0"}]
["Inflación anual para gastos (%) — ref. IPC 6,14",6.14]
["Tasa de oportunidad anual (%)",{"v":15,"d":"15.0"}]
[]
["PROYECCIÓN A 5 AÑOS"]
[null,"Año 1","Año 2","Año 3","Año 4","Año 5"]
["Unidades/mes (topadas por tu capacidad)",{"$f":"IF((N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))>0,MIN((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^0,(N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))),(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^0)","v":300},{"$f":"IF((N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))>0,MIN((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^1,(N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))),(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^1)","v":330},{"$f":"IF((N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))>0,MIN((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^2,(N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))),(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^2)","v":{"v":363.00000000000006,"d":"363"}},{"$f":"IF((N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))>0,MIN((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^3,(N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))),(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^3)","v":{"v":399.3000000000001,"d":"399"}},{"$f":"IF((N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))>0,MIN((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^4,(N('1 PRODUCTOS'!F16)+N('1 PRODUCTOS'!F29)+N('1 PRODUCTOS'!F42)+N('1 PRODUCTOS'!F55)+N('1 PRODUCTOS'!F68))),(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))*(1+$B$19/100)^4)","v":{"v":439.23000000000013,"d":"439"}}]
["Margen de contribución anual",{"$f":"IF((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))>0,$B$5*12*B25/(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67)),0)","v":{"v":40320359.99999999,"d":"$40,320,360"}},{"$f":"IF((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))>0,$B$5*12*C25/(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67)),0)","v":{"v":44352395.99999999,"d":"$44,352,396"}},{"$f":"IF((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))>0,$B$5*12*D25/(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67)),0)","v":{"v":48787635.6,"d":"$48,787,636"}},{"$f":"IF((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))>0,$B$5*12*E25/(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67)),0)","v":{"v":53666399.160000004,"d":"$53,666,399"}},{"$f":"IF((N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67))>0,$B$5*12*F25/(N('1 PRODUCTOS'!F15)+N('1 PRODUCTOS'!F28)+N('1 PRODUCTOS'!F41)+N('1 PRODUCTOS'!F54)+N('1 PRODUCTOS'!F67)),0)","v":{"v":59033039.07600001,"d":"$59,033,039"}}]
["Gastos fijos anuales",{"$f":"$B$7*12*(1+$B$20/100)^0","v":{"v":32880000,"d":"$32,880,000"}},{"$f":"$B$7*12*(1+$B$20/100)^1","v":{"v":34898832,"d":"$34,898,832"}},{"$f":"$B$7*12*(1+$B$20/100)^2","v":{"v":37041620.28479999,"d":"$37,041,620"}},{"$f":"$B$7*12*(1+$B$20/100)^3","v":{"v":39315975.77028671,"d":"$39,315,976"}},{"$f":"$B$7*12*(1+$B$20/100)^4","v":{"v":41729976.68258231,"d":"$41,729,977"}}]
["FLUJO OPERATIVO del año",{"$f":"B26-B27","v":{"v":7440359.999999993,"d":"$7,440,360"}},{"$f":"C26-C27","v":{"v":9453563.999999993,"d":"$9,453,564"}},{"$f":"D26-D27","v":{"v":11746015.315200008,"d":"$11,746,015"}},{"$f":"E26-E27","v":{"v":14350423.389713295,"d":"$14,350,423"}},{"$f":"F26-F27","v":{"v":17303062.3934177,"d":"$17,303,062"}}]
["Cuota anual del crédito",{"$f":"$B$9*MIN(12,MAX(0,'4 CREDITO'!$B$5-0))","v":{"v":3766353.8493886227,"d":"$3,766,354"}},{"$f":"$B$9*MIN(12,MAX(0,'4 CREDITO'!$B$5-12))","v":{"v":3766353.8493886227,"d":"$3,766,354"}},{"$f":"$B$9*MIN(12,MAX(0,'4 CREDITO'!$B$5-24))","v":{"v":3766353.8493886227,"d":"$3,766,354"}},{"$f":"$B$9*MIN(12,MAX(0,'4 CREDITO'!$B$5-36))","v":{"v":0,"d":"$0"}},{"$f":"$B$9*MIN(12,MAX(0,'4 CREDITO'!$B$5-48))","v":{"v":0,"d":"$0"}}]
["CAJA del año",{"$f":"B28-B29","v":{"v":3674006.15061137,"d":"$3,674,006"}},{"$f":"C28-C29","v":{"v":5687210.15061137,"d":"$5,687,210"}},{"$f":"D28-D29","v":{"v":7979661.465811386,"d":"$7,979,661"}},{"$f":"E28-E29","v":{"v":14350423.389713295,"d":"$14,350,423"}},{"$f":"F28-F29","v":{"v":17303062.3934177,"d":"$17,303,062"}}]
["Flujo acumulado",{"$f":"-$B$14+B28","v":{"v":-2459640.0000000075,"d":"-$2,459,640"}},{"$f":"B31+C28","v":{"v":6993923.999999985,"d":"$6,993,924"}},{"$f":"C31+D28","v":{"v":18739939.315199994,"d":"$18,739,939"}},{"$f":"D31+E28","v":{"v":33090362.70491329,"d":"$33,090,363"}},{"$f":"E31+F28","v":{"v":50393425.09833099,"d":"$50,393,425"}}]
[]
["INDICADORES DEL PROYECTO"]
["Flujos para TIR (año 0 → 5):",{"$f":"-B14","v":{"v":-9900000,"d":"-$9,900,000"}},{"$f":"B28","v":{"v":7440359.999999993,"d":"$7,440,360"}},{"$f":"C28","v":{"v":9453563.999999993,"d":"$9,453,564"}},{"$f":"D28","v":{"v":11746015.315200008,"d":"$11,746,015"}},{"$f":"E28","v":{"v":14350423.389713295,"d":"$14,350,423"}},{"$f":"F28","v":{"v":17303062.3934177,"d":"$17,303,062"}}]
["VAN (valor presente neto, 5 años)",{"$f":"IF(B14>0,NPV(B21/100,B28:F28)-B14,\"\")","v":{"v":28248907.76911795,"d":"$28,248,908"}}]
["TIR anual",{"$f":"IFERROR(IRR(B34:G34)*100,\"no aplica\")","v":{"v":91.27665538289693,"d":"91.3%"}}]
["Recuperas la inversión total en (meses)",{"$f":"IF(B14=0,\"\",IF(B31>=0,ROUND(B14/(B28/12),0),IF(C31>=0,12+ROUND(-B31/(C28/12),0),IF(D31>=0,24+ROUND(-C31/(D28/12),0),IF(E31>=0,36+ROUND(-D31/(E28/12),0),IF(F31>=0,48+ROUND(-E31/(F28/12),0),\"más de 60\"))))))","v":15}]
[]
["ESCENARIO PESIMISTA: caja mensual si vendes −20%",{"$f":"B5*0.8-B7-B9","v":{"v":-365838.82078238524,"d":"-$365,839"}}]
["ESCENARIO OPTIMISTA: caja mensual si vendes +20%",{"$f":"B5*1.2-B7-B9","v":{"v":978173.1792176138,"d":"$978,173"}}]

{"sheet":"6 REGISTRO DIARIO","index":6,"n_rows":39,"n_cols":6,"rows_kept":39}
["REGISTRO DIARIO DE INGRESOS Y EGRESOS — mes: ______"]
["Anota TODO, todos los días, separado de las cuentas de la casa. Tres meses de registro ordenado abren la puerta al crédito formal."]
[]
["Día","¿Qué entró? (venta, abono…)","Entró $","¿Qué salió? (compra, pago…)","Salió $","Saldo"]
[1,{"$nulls":4},{"$f":"N(C5)-N(E5)","v":{"v":0,"d":"$0"}}]
[2,{"$nulls":4},{"$f":"F5+N(C6)-N(E6)","v":{"v":0,"d":"$0"}}]
[3,{"$nulls":4},{"v":0,"d":"$0"}]
[4,{"$nulls":4},{"v":0,"d":"$0"}]
[5,{"$nulls":4},{"v":0,"d":"$0"}]
[6,{"$nulls":4},{"v":0,"d":"$0"}]
[7,{"$nulls":4},{"v":0,"d":"$0"}]
[8,{"$nulls":4},{"v":0,"d":"$0"}]
[9,{"$nulls":4},{"v":0,"d":"$0"}]
[10,{"$nulls":4},{"v":0,"d":"$0"}]
[11,{"$nulls":4},{"v":0,"d":"$0"}]
[12,{"$nulls":4},{"v":0,"d":"$0"}]
[13,{"$nulls":4},{"v":0,"d":"$0"}]
[14,{"$nulls":4},{"v":0,"d":"$0"}]
[15,{"$nulls":4},{"v":0,"d":"$0"}]
[16,{"$nulls":4},{"v":0,"d":"$0"}]
[17,{"$nulls":4},{"v":0,"d":"$0"}]
[18,{"$nulls":4},{"v":0,"d":"$0"}]
[19,{"$nulls":4},{"v":0,"d":"$0"}]
[20,{"$nulls":4},{"v":0,"d":"$0"}]
[21,{"$nulls":4},{"v":0,"d":"$0"}]
[22,{"$nulls":4},{"v":0,"d":"$0"}]
[23,{"$nulls":4},{"v":0,"d":"$0"}]
[24,{"$nulls":4},{"v":0,"d":"$0"}]
[25,{"$nulls":4},{"v":0,"d":"$0"}]
[26,{"$nulls":4},{"v":0,"d":"$0"}]
[27,{"$nulls":4},{"v":0,"d":"$0"}]
[28,{"$nulls":4},{"v":0,"d":"$0"}]
[29,{"$nulls":4},{"v":0,"d":"$0"}]
[30,{"$nulls":4},{"v":0,"d":"$0"}]
[31,{"$nulls":4},{"v":0,"d":"$0"}]
[null,"TOTALES DEL MES:",{"$f":"SUM(C5:C35)","v":{"v":0,"d":"$0"}},null,{"$f":"SUM(E5:E35)","v":{"v":0,"d":"$0"}},{"$f":"C36-E36","v":{"v":0,"d":"$0"}}]
[]
["Apps gratuitas que ayudan: Treinta (ventas, gastos e inventario; gratis para empezar, funciones avanzadas de pago),"]
["Nequi y Daviplata (cuentas sin costo para separar la plata del negocio). La planilla en papel también vale: lo importante es HACERLO."]