{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Balance del flujo de caja"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Balance del flujo de caja","index":0,"n_rows":48,"n_cols":18,"rows_kept":48,"merged":[[13,1,13,18],[37,1,37,18],[46,1,46,18]]}
[null,"Flujo de caja Declaración"]
[]
[null,"Comienza el año fiscal:",null,"(Pre) Lanzamiento",{"$f":"UPPER(TEXT(FechaDeInicioelañoFiscal,\"mmm\"))","v":"ENE"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,1),\"mmm\"))","v":"FEB"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,2),\"mmm\"))","v":"MAR"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,3),\"mmm\"))","v":"ABR"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,4),\"mmm\"))","v":"MAY"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,5),\"mmm\"))","v":"JUN"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,6),\"mmm\"))","v":"JUL"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,7),\"mmm\"))","v":"AGO"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,8),\"mmm\"))","v":"SEP"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,9),\"mmm\"))","v":"OCT"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,10),\"mmm\"))","v":"NOV"},{"$f":"UPPER(TEXT(EOMONTH(FechaDeInicioelañoFiscal,11),\"mmm\"))","v":"DIC"},null,"Total"]
[null,"2012-01-05",null,"EST",{"$f":"FechaDeInicioelañoFiscal","v":"2012-01-05"},{"$f":"EOMONTH(E4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-02-05"},{"$f":"EOMONTH(F4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-03-05"},{"$f":"EOMONTH(G4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-04-05"},{"$f":"EOMONTH(H4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-05-05"},{"$f":"EOMONTH(I4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-06-05"},{"$f":"EOMONTH(J4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-07-05"},{"$f":"EOMONTH(K4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-08-05"},{"$f":"EOMONTH(L4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-09-05"},{"$f":"EOMONTH(M4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-10-05"},{"$f":"EOMONTH(N4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-11-05"},{"$f":"EOMONTH(O4,0)+DAY(FechaDeInicioelañoFiscal)","v":"2012-12-05"},null,"EST del elemento"]
[]
[null,"Efectivo en la mano (al principio del mes)",null,100,{"$f":"D48","v":100},{"$f":"E48","v":-125},45,-1,224,269,269,269,269,269,269,269,null,{"$f":"P6","v":269}]
[]
[null,"Recibos de efectivo"]
[null,"Ventas en efectivo",null,null,125,120,130,100,{"$nulls":9},{"$f":"SUM(Recibosdeefectivo[[#This Row],[Period 0]:[Period 12]])","v":475}]
[null,"Cobros de las cuentas fm CR",{"$nulls":5},75,45,{"$nulls":8},{"$f":"SUM(Recibosdeefectivo[[#This Row],[Period 0]:[Period 12]])","v":120}]
[null,"Préstamo / Otras inyecciones de efectivo",null,null,50,50,50,50,{"$nulls":9},{"$f":"SUM(Recibosdeefectivo[[#This Row],[Period 0]:[Period 12]])","v":200}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 0])","v":0},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 1])","v":175},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 2])","v":170},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 3])","v":180},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 4])","v":225},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 5])","v":45},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 6])","v":0},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 7])","v":0},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 8])","v":0},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 9])","v":0},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 10])","v":0},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 11])","v":0},{"$f":"SUBTOTAL(109,Recibosdeefectivo[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,Recibosdeefectivo[Total])","v":795}]
[null,"Efectivo total disponible (antes del retiro)",null,{"$f":"D6+SUM(Recibosdeefectivo[Period 0])","v":100},{"$f":"E6+SUM(Recibosdeefectivo[Period 1])","v":275},{"$f":"F6+SUM(Recibosdeefectivo[Period 2])","v":45},{"$f":"G6+SUM(Recibosdeefectivo[Period 3])","v":225},{"$f":"H6+SUM(Recibosdeefectivo[Period 4])","v":224},{"$f":"I6+SUM(Recibosdeefectivo[Period 5])","v":269},{"$f":"J6+SUM(Recibosdeefectivo[Period 6])","v":269},{"$f":"K6+SUM(Recibosdeefectivo[Period 7])","v":269},{"$f":"L6+SUM(Recibosdeefectivo[Period 8])","v":269},{"$f":"M6+SUM(Recibosdeefectivo[Period 9])","v":269},{"$f":"N6+SUM(Recibosdeefectivo[Period 10])","v":269},{"$f":"O6+SUM(Recibosdeefectivo[Period 11])","v":269},{"$f":"P6+SUM(Recibosdeefectivo[Period 12])","v":269},null,{"$f":"R6+SUM(Recibosdeefectivo[Total])","v":1064}]
[]
[null,"Efectivo pagado"]
[null,"Compras (mercadería)",null,null,400,null,226,{"$nulls":10},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":626}]
[null,"Compras (especifique)",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Compras (especifique)",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Salarios brutos (retiro exacto)",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Gastos de personal (impuestos, etc.)",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Servicios externos",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Suministros (oficina y operaciones)",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Reparaciones y mantenimiento",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Publicidad",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Auto, envíos y viajes",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Contabilidad y asesoría legal",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Alquiler",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Teléfono",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Servicios públicos",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Seguro",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Impuestos (bienes raíces, etc.)",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Interés",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Otros gastos (especifique)",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Otro (especifique)",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Otro (especifique)",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Varios",{"$nulls":15},{"$f":"SUM(Efectivopagado[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Efectivopagado[Period 0])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 1])","v":400},{"$f":"SUBTOTAL(109,Efectivopagado[Period 2])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 3])","v":226},{"$f":"SUBTOTAL(109,Efectivopagado[Period 4])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 5])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 6])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 7])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 8])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 9])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 10])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 11])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,Efectivopagado[Total])","v":626}]
[]
[null,"Efectivo pagado (No Pérdidas y Ganancias)"]
[null,"Pago principal del préstamo",{"$nulls":15},{"$f":"SUM(Efectivopagado2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Compra de capital (especifique)",{"$nulls":15},{"$f":"SUM(Efectivopagado2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Otros costos de lanzamiento",{"$nulls":15},{"$f":"SUM(Efectivopagado2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Reserva y/o garantía",{"$nulls":15},{"$f":"SUM(Efectivopagado2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Retiro de los dueños",{"$nulls":15},{"$f":"SUM(Efectivopagado2[[#This Row],[Period 0]:[Period 12]])","v":0}]
[null,"Total",null,{"$f":"SUBTOTAL(109,Efectivopagado2[Period 0])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 1])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 2])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 3])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 4])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 5])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 6])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 7])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 8])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 9])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 10])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 11])","v":0},{"$f":"SUBTOTAL(109,Efectivopagado2[Period 12])","v":0},null,{"$f":"SUBTOTAL(109,Efectivopagado2[Total])","v":0}]
[null,"Efectivo total pagado",null,{"$f":"SUM(Efectivopagado[Period 0],Efectivopagado2[Period 0])","v":0},{"$f":"SUM(Efectivopagado[Period 1],Efectivopagado2[Period 1])","v":400},{"$f":"SUM(Efectivopagado[Period 2],Efectivopagado2[Period 2])","v":0},{"$f":"SUM(Efectivopagado[Period 3],Efectivopagado2[Period 3])","v":226},{"$f":"SUM(Efectivopagado[Period 4],Efectivopagado2[Period 4])","v":0},{"$f":"SUM(Efectivopagado[Period 5],Efectivopagado2[Period 5])","v":0},{"$f":"SUM(Efectivopagado[Period 6],Efectivopagado2[Period 6])","v":0},{"$f":"SUM(Efectivopagado[Period 7],Efectivopagado2[Period 7])","v":0},{"$f":"SUM(Efectivopagado[Period 8],Efectivopagado2[Period 8])","v":0},{"$f":"SUM(Efectivopagado[Period 9],Efectivopagado2[Period 9])","v":0},{"$f":"SUM(Efectivopagado[Period 10],Efectivopagado2[Period 10])","v":0},{"$f":"SUM(Efectivopagado[Period 11],Efectivopagado2[Period 11])","v":0},{"$f":"SUM(Efectivopagado[Period 12],Efectivopagado2[Period 12])","v":0},null,{"$f":"SUM(Efectivopagado[Total],Efectivopagado2[Total])","v":626}]
[]
[null,"Posición del efectivo (al final del mes)",null,{"$f":"D13-D46","v":100},-125,45,-1,224,269,269,269,269,269,269,269,269,null,{"$f":"R13-R46","v":438}]