{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Flujo de efectivo","Gráfico del flujo de efectivo"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Flujo de efectivo","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Proyección de flujo de efectivo para pymes"]
[null,"Nombre de la compañía"]
[null,"Fecha de inicio",{"$f":"TODAY()","v":"2019-05-22"}]
[null,"Mínimo de alerta de saldo de efectivo",null,{"$f":"Efectivo_mínimo","v":0},{"$f":"Efectivo_mínimo","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Inicio","ene-18","feb-18","mar-18","abr-18","may-18","jun-18","jul-18","ago-18","sep-18","oct-18","nov-18","dic-18","Total"]
[null,"Efectivo disponible (a principios de mes)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"RECIBOS DE COBROS"," ","ene-18","feb-18","mar-18","abr-18","may-18","jun-18","jul-18","ago-18","sep-18","oct-18","nov-18","dic-18","Total"]
[null,"Ventas en efectivo",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Devoluciones y concesiones",{"$nulls":13},0]
[null,"Cobros pendientes",{"$nulls":13},0]
[null,"Intereses y otros ingresos",{"$nulls":13},0]
[null,"Fondos de préstamos",{"$nulls":13},0]
[null,"Contribuciones del propietario",{"$nulls":13},0]
[null,"RECIBOS DE COBROS TOTALES",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,RecibosDeCobro[Total])","v":0}]
[null,"Total de efectivo disponible",{"$f":"(C7+RecibosDeCobro[[#Totals],[ ]])","v":0},{"$f":"(D7+RecibosDeCobro[[#Totals],[ene-18]])","v":0},{"$f":"(E7+RecibosDeCobro[[#Totals],[feb-18]])","v":0},{"$f":"(F7+RecibosDeCobro[[#Totals],[mar-18]])","v":0},{"$f":"(G7+RecibosDeCobro[[#Totals],[abr-18]])","v":0},{"$f":"(H7+RecibosDeCobro[[#Totals],[may-18]])","v":0},{"$f":"(I7+RecibosDeCobro[[#Totals],[jun-18]])","v":0},{"$f":"(J7+RecibosDeCobro[[#Totals],[jul-18]])","v":0},{"$f":"(K7+RecibosDeCobro[[#Totals],[ago-18]])","v":0},{"$f":"(L7+RecibosDeCobro[[#Totals],[sep-18]])","v":0},{"$f":"(M7+RecibosDeCobro[[#Totals],[oct-18]])","v":0},{"$f":"(N7+RecibosDeCobro[[#Totals],[nov-18]])","v":0},{"$f":"(O7+RecibosDeCobro[[#Totals],[dic-18]])","v":0}]
[]
[null,"DINERO EN EFECTIVO DESEMBOLSADO"," ","ene-18","feb-18","mar-18","abr-18","may-18","jun-18","jul-18","ago-18","sep-18","oct-18","nov-18","dic-18","Total"]
[null,"Publicidad",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Comisiones y honorarios",{"$nulls":13},0]
[null,"Mano de obra contratada",{"$nulls":13},0]
[null,"Programas de ventajas para los empleados",{"$nulls":13},0]
[null,"Seguros (distintos al sanitario)",{"$nulls":13},0]
[null,"Gasto de intereses",{"$nulls":13},0]
[null,"Materiales y suministros (en COGS)",{"$nulls":13},0]
[null,"Comidas y entretenimiento",{"$nulls":13},0]
[null,"Interés de la hipoteca",{"$nulls":13},0]
[null,"Gastos de la oficina",{"$nulls":13},0]
[null,"Gastos de otros intereses",{"$nulls":13},0]
[null,"Planes de pensiones y de reparto de utilidades",{"$nulls":13},0]
[null,"Compras para revender",{"$nulls":13},0]
[null,"Alquiler o alquiler con opción a compra",{"$nulls":13},0]
[null,"Alquiler o alquiler con opción a compra: vehículos, equipamiento",{"$nulls":13},0]
[null,"Reparaciones y mantenimiento",{"$nulls":13},0]
[null,"Suministros (no en COGS)",{"$nulls":13},0]
[null,"Impuestos y licencias",{"$nulls":13},0]
[null,"Viajes",{"$nulls":13},0]
[null,"Suministros",{"$nulls":13},0]
[null,"Sueldos (menos créditos de los emp.)",{"$nulls":13},0]
[null,"Otros gastos",{"$nulls":13},0]
[null,"Otros gastos",{"$nulls":13},0]
[null,"Otros gastos",{"$nulls":13},0]
[null,"Varios",{"$nulls":13},0]
[null,"SUBTOTAL",null,{"$f":"SUBTOTAL(109,Gastos[ene-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[feb-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[mar-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[abr-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[may-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[jun-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[jul-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[ago-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[sep-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[oct-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[nov-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[dic-18])","v":0},{"$f":"SUBTOTAL(109,Gastos[Total])","v":0}]
[null,"DINERO EN EFECTIVO DESEMBOLSADO"," ","ene-18","feb-18","mar-18","abr-18","may-18","jun-18","jul-18","ago-18","sep-18","oct-18","nov-18","dic-18","Total"]
[null,"Pago principal del préstamo",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Compras de capital",{"$nulls":13},0]
[null,"Otros gastos de inicio",{"$nulls":13},0]
[null,"Depósitos y reservas pendientes",{"$nulls":13},0]
[null,"Dinero retirado para los propietarios",{"$nulls":13},0]
[null,"DINERO EN EFECTIVO DESEMBOLSADO TOTAL",null,{"$f":"Gastos[[#Totals],[ene-18]]+SUBTOTAL(109,PagosEnEfectivo[ene-18])","v":0},{"$f":"Gastos[[#Totals],[feb-18]]+SUBTOTAL(109,PagosEnEfectivo[feb-18])","v":0},{"$f":"Gastos[[#Totals],[mar-18]]+SUBTOTAL(109,PagosEnEfectivo[mar-18])","v":0},{"$f":"Gastos[[#Totals],[abr-18]]+SUBTOTAL(109,PagosEnEfectivo[abr-18])","v":0},{"$f":"Gastos[[#Totals],[may-18]]+SUBTOTAL(109,PagosEnEfectivo[may-18])","v":0},{"$f":"Gastos[[#Totals],[jun-18]]+SUBTOTAL(109,PagosEnEfectivo[jun-18])","v":0},{"$f":"Gastos[[#Totals],[jul-18]]+SUBTOTAL(109,PagosEnEfectivo[jul-18])","v":0},{"$f":"Gastos[[#Totals],[ago-18]]+SUBTOTAL(109,PagosEnEfectivo[ago-18])","v":0},{"$f":"Gastos[[#Totals],[sep-18]]+SUBTOTAL(109,PagosEnEfectivo[sep-18])","v":0},{"$f":"Gastos[[#Totals],[oct-18]]+SUBTOTAL(109,PagosEnEfectivo[oct-18])","v":0},{"$f":"Gastos[[#Totals],[nov-18]]+SUBTOTAL(109,PagosEnEfectivo[nov-18])","v":0},{"$f":"Gastos[[#Totals],[dic-18]]+SUBTOTAL(109,PagosEnEfectivo[dic-18])","v":0},0]
[null,"Efectivo disponible (finales de mes)",{"$f":"C17","v":0},{"$f":"D17-PagosEnEfectivo[[#Totals],[ene-18]]","v":0},{"$f":"E17-PagosEnEfectivo[[#Totals],[feb-18]]","v":0},{"$f":"F17-PagosEnEfectivo[[#Totals],[mar-18]]","v":0},{"$f":"G17-PagosEnEfectivo[[#Totals],[abr-18]]","v":0},{"$f":"H17-PagosEnEfectivo[[#Totals],[may-18]]","v":0},{"$f":"I17-PagosEnEfectivo[[#Totals],[jun-18]]","v":0},{"$f":"J17-PagosEnEfectivo[[#Totals],[jul-18]]","v":0},{"$f":"K17-PagosEnEfectivo[[#Totals],[ago-18]]","v":0},{"$f":"L17-PagosEnEfectivo[[#Totals],[sep-18]]","v":0},{"$f":"M17-PagosEnEfectivo[[#Totals],[oct-18]]","v":0},{"$f":"N17-PagosEnEfectivo[[#Totals],[nov-18]]","v":0},{"$f":"O17-PagosEnEfectivo[[#Totals],[dic-18]]","v":0}]
[]
[null,"OTROS DATOS OPERATIVOS"," ","ene-18","feb-18","mar-18","abr-18","may-18","jun-18","jul-18","ago-18","sep-18","oct-18","nov-18","dic-18","Total"]
[null,"Volumen de ventas (en dólares)",{"$nulls":13},{"$f":"SUM(OtrosDatosOperativos[[#This Row],[ene-18]:[dic-18]])","v":0}]
[null,"Saldo de cuentas por cobrar",{"$nulls":13},{"$f":"SUM(OtrosDatosOperativos[[#This Row],[ene-18]:[dic-18]])","v":0}]
[null,"Saldo de deuda incobrable",{"$nulls":13},{"$f":"SUM(OtrosDatosOperativos[[#This Row],[ene-18]:[dic-18]])","v":0}]
[null,"Inventario disponible",{"$nulls":13},{"$f":"SUM(OtrosDatosOperativos[[#This Row],[ene-18]:[dic-18]])","v":0}]
[null,"Saldo de cuentas por pagar",{"$nulls":13},{"$f":"SUM(OtrosDatosOperativos[[#This Row],[ene-18]:[dic-18]])","v":0}]
[null,"Amortización",{"$nulls":13},{"$f":"SUM(OtrosDatosOperativos[[#This Row],[ene-18]:[dic-18]])","v":0}]

{"sheet":"Gráfico del flujo de efectivo","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"En esta celda, se encuentra el gráfico combinado en el que se muestran la alerta de efectivo disponible mínimo y la proyección de flujo de efectivo."]
{"$rows_empty":34}
[null,"Mínimo de alerta de saldo de efectivo",null,{"$f":"[0]!Efectivo_mínimo","v":{"v":0,"d":"0 €"}}]