{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Ratios Financieros","Ayuda"],"not_rendered":{"charts":2,"images":6,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Ratios Financieros","index":0,"n_rows":96,"n_cols":14,"rows_kept":96,"merged":[[0,0,0,2],[15,9,15,12]],"flags":["formulas_cached_only"]}
["MO_RF_5_2002",{"$nulls":3},"RATIOS F","2011-04-03T20:24:14.730"]
[]
[null,"BALANCE ABREVIADO \"INGESA\""]
[{"$nulls":3},"A C T I V O",{"v":2000,"d":"2,000"},{"v":2001,"d":"2,001"},{"$nulls":3},"Límites óptimos para la Empresa","Mínimo","Máximo"]
[null,"A)","ACCIONISTAS (SOCIOS) POR DESEMBOLSOS NO EXIGIDOS",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"1. Liquidez ",1.8,2.2]
[null,"B)","INMOVILIZADO",null,{"v":229604.61000000002,"d":"229,604.61"},{"v":234024.25,"d":"234,024.25"},{"$nulls":3},"2. Liquidez inmediata ",0.75,1]
[null,"  ","I.","Gastos de establecimiento",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"3. Tesorería ",0.1,0.15]
[null,"  ","II.","Inmovilizaciones inmateriales",{"v":101252.9,"d":"101,252.90"},{"v":111319.89,"d":"111,319.89"},{"$nulls":3},"4. Garantía",1.8,2]
[null,"  ","III.","Inmovilizaciones materiales",{"v":120350.74,"d":"120,350.74"},{"v":114703.39,"d":"114,703.39"},{"$nulls":3},"5. Firmeza",1.8,2]
[null,"  ","IV.","Inmovilizaciones financieras",{"v":8000.97,"d":"8,000.97"},{"v":8000.97,"d":"8,000.97"},{"$nulls":3},"6.1. Endeudamiento general",0.5,0.75]
[null,"  ","V.","Acciones propias",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"6.2. Endeudamiento a corto plazo",0.15,0.25]
[null,"  ","VI.","Deudores por operaciones de tráfico a largo plazo",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"6.3. Endeudamiento a largo plazo",0.35,0.5]
[null,"C)","GASTOS A DISTRIBUIR EN VARIOS EJERCICIOS",null,{"v":12579.82,"d":"12,579.82"},{"v":8865.33,"d":"8,865.33"},{"$nulls":3},"6.4. Autonomía financiera",0.35,1]
[null,"D)","ACTIVO CIRCULANTE",null,{"v":244936.43,"d":"244,936.43"},{"v":213924.65,"d":"213,924.65"},{"$nulls":3},"7. Inmovilizado explotación / Gastos personal",0.5,0.75]
[null,"  ","I.","Accionistas por desembolsos exigidos",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"8. Dotación amortización / Inmovilizado explotación",0.1,0.2]
[null,"  ","II.","Existencias",{"v":86935.05,"d":"86,935.05"},{"v":83740.32,"d":"83,740.32"},{"$nulls":3},"NOTA: Los valores Mínimo y Máximo deben ser introducidos por la empresa, de acuerdo con sus criterios."]
[null,"  ","III.","Deudores",{"v":103989.14,"d":"103,989.14"},{"v":107199.15,"d":"107,199.15"}]
[null,"  ","IV.","Inversiones financieras temporales",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ","V.","Acciones propias a corto plazo",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"ANÁLISIS DE RATIOS FINANCIEROS DE \"INGESA\""]
[null,"  ","VI.","Tesoreria",{"v":54012.24,"d":"54,012.24"},{"v":22985.18,"d":"22,985.18"},{"$nulls":3},"Ratios Financieros",{"v":2000,"d":"2,000"},{"v":2001,"d":"2,001"},"Variación","Diagnóstico 2001"]
[null,"  ","VII.","Ajustes por periodificación",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"1. Liquidez ",{"v":1.9516293402354483,"d":"1.95"},{"v":3.265011292676442,"d":"3.27"},"­","Alto"]
[{"$nulls":3},"TOTAL GENERAL (A+B+C+D)",{"v":487120.86,"d":"487,120.86"},{"v":456814.23,"d":"456,814.23"},{"$nulls":3},"2. Liquidez inmediata ",{"v":1.258939427694322,"d":"1.26"},{"v":1.9869300128784435,"d":"1.99"},"­","Alto"]
[{"$nulls":4},"",{"$nulls":4},"3. Tesorería ",{"v":0.4303642064017945,"d":"0.43"},{"v":0.3508098401198773,"d":"0.35"},"¯","Alto"]
[{"$nulls":9},"4. Garantía",{"v":1.5511298734197903,"d":"1.55"},{"v":1.8808459834654778,"d":"1.88"},"­","Normal"]
[{"$nulls":3},"P A S I V O",{"v":2000,"d":"2,000"},{"v":2001,"d":"2,001"},{"$nulls":3},"5. Firmeza",{"v":1.272548683154709,"d":"1.27"},{"v":1.3555371836871866,"d":"1.36"},"­","Bajo"]
[null,"A)","FONDOS PROPIOS",null,{"v":177206.65,"d":"177,206.65"},{"v":214669,"d":"214,669.00"},{"$nulls":3},"6.1. Endeudamiento general",{"v":0.6280422891353904,"d":"0.63"},{"v":0.5213574892358322,"d":"0.52"},"¯","Normal"]
[null,"  ","I.","Capital suscrito",{"v":7512.65,"d":"7,512.65"},{"v":7512.65,"d":"7,512.65"},{"$nulls":3},"6.2. Endeudamiento a corto plazo",{"v":0.2576435753541739,"d":"0.26"},{"v":0.14342885071684391,"d":"0.14"},"¯","Bajo"]
[null,"  ","II.","Prima de emision",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"6.3. Endeudamiento a largo plazo",{"v":0.37039871378121647,"d":"0.37"},{"v":0.37792863851898834,"d":"0.38"},"­","Normal"]
[null,"  ","III.","Reserva de revalorización",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"6.4. Autonomía financiera",{"v":0.5792344716563294,"d":"0.58"},{"v":0.9013513068668115,"d":"0.90"},"­","Normal"]
[null,"  ","IV.","Reservas",{"v":113970.43,"d":"113,970.43"},{"v":169693.99,"d":"169,693.99"},{"$nulls":3},"7. Inmovilizado explotación / Gastos personal",{"v":0.5513352892477353,"d":"0.55"},{"v":0.3856013607528169,"d":"0.39"},"¯","Bajo"]
[null,"  ","V.","Resultados de ejercicios anteriores",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"8. Dotación amortización / Inmovilizado explotación",{"v":0.16910656341204502,"d":"0.17"},{"v":0.2137114371581547,"d":"0.21"},"­","Alto"]
[null,"  ","VI.","Perdidas y ganancias",{"v":55723.57,"d":"55,723.57"},{"v":37462.36,"d":"37,462.36"}]
[null,"  ","VII.","Dividendo a cuenta entregado en el ejercicio",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ","VIII.","Acciones propias para reducción de capital",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"B)","INGRESOS A DISTRIBUIR EN VARIOS EJERCICIOS   ",null,{"v":3981.71,"d":"3,981.71"},{"v":3981.71,"d":"3,981.71"}]
[null,"C)","PROVISIONES PARA RIESGOS Y GASTOS            ",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"D)","ACREEDORES A LARGO PLAZO                     ",null,{"v":180428.94,"d":"180,428.94"},{"v":172643.18,"d":"172,643.18"}]
[null,"E)","ACREEDORES A CORTO PLAZO                     ",null,{"v":125503.56,"d":"125,503.56"},{"v":65520.34,"d":"65,520.34"}]
[null,"F)","PROVISIONES PARA RIESGOS Y GASTOS A CORTO PLAZO     ",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[{"$nulls":3},"TOTAL GENERAL (A+B+C+D+E+F)",{"v":487120.86,"d":"487,120.86"},{"v":456814.23,"d":"456,814.23"}]
[{"$nulls":4},""]
[]
[null,"CUENTA DE PÉRDIDAS Y GANANCIAS ABREVIADA \"INGESA\""]
[{"$nulls":3},"D E B E",{"v":2000,"d":"2,000"},{"v":2001,"d":"2,001"}]
[null,"A)","GASTOS (A.1 a A.15)",null,{"v":1499624.5899999999,"d":"1,499,624.59"},{"v":1871925.9599999997,"d":"1,871,925.96"}]
[null,"  ",null,"1. Consumos de explotación",{"v":803640.38,"d":"803,640.38"},{"v":870002.84,"d":"870,002.84"}]
[null,"  ",null,"2. Gastos de personal",{"v":401939.88,"d":"401,939.88"},{"v":586157.89,"d":"586,157.89"}]
[null,"  ",null,"     a) Sueldos, salarios y asimilados",{"v":322629.92,"d":"322,629.92"},{"v":471138.5,"d":"471,138.50"}]
[null,"  ",null,"     b) Cargas sociales",{"v":79309.96,"d":"79,309.96"},{"v":115019.38,"d":"115,019.38"}]
[null,"  ",null,"3. Dotaciones para amortización de inmovilizado",{"v":37474.63,"d":"37,474.63"},{"v":48303.76,"d":"48,303.76"}]
[null,"  ",null,"4. Variación de provisiones de tráfico y pérd.cred.incobrables.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"5. Otros gastos de explotación",{"v":220307.53,"d":"220,307.53"},{"v":318692.02,"d":"318,692.02"}]
[null,"  ","I. BENEFICIOS DE EXPLOTACION",null,{"v":19718.61000000022,"d":"19,718.61"},{"v":0,"d":"0.00"}]
[null,"  ",null,"6. Gastos financieros y gastos asimilados",{"v":12697.94,"d":"12,697.94"},{"v":16794.07,"d":"16,794.07"}]
[null,"  ",null,"     a) Por deudas con empresas del grupo",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"     b) Por deudas con empresas asociadas",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"     c) Por otras deudas",{"v":12697.94,"d":"12,697.94"},{"v":16794.07,"d":"16,794.07"}]
[null,"  ",null,"     d) Pérdidas de inversiones financieras",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"7. Variación de provisiones de inversiones financieras",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"8. Diferencias negativas de cambio",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ","II. RESULTADOS FINANCIEROS POSITIVOS",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ","III.BENEFICIOS DE ACTIVIDADES ORDINARIAS",null,{"v":7032.330000000218,"d":"7,032.33"},{"v":0,"d":"0.00"}]
[null,"  ",null,"9. Variación provisiones inmov.inmat., mat., cartera control",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"10.Pérdidas procedentes del inmovilizado y cartera control",431.03,{"v":0,"d":"0.00"}]
[null,"  ",null,"11.Pérdidas por operaciones con acciones y oblig. propias",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"12.Gastos extraordinarios",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"13.Gastos y pérdidas de otros ejercicios",{"v":0,"d":"0.00"},{"v":15920.09,"d":"15,920.09"},{"$nulls":3},"BALANCE ABREVIADO \"INGESA\""]
[null,"  ","IV.RESULTADOS EXTRAORDINARIOS POSITIVOS",null,{"v":71824.44,"d":"71,824.44"},{"v":91594.97,"d":"91,594.97"},{"$nulls":3},"A C T I V O",{"v":2001,"d":"2,001"}]
[null,"  ","V. BENEFICIOS ANTES DE IMPUESTOS",null,{"v":78856.77000000022,"d":"78,856.77"},{"v":53517.66000000035,"d":"53,517.66"},{"$nulls":3},"ACTIVO FIJO",{"v":242889.58,"d":"242,889.58"}]
[null,"  ",null,"14.Impuesto sobre Sociedades",{"v":23133.2,"d":"23,133.20"},{"v":16055.3,"d":"16,055.30"},{"$nulls":3},"ACTIVO CIRCULANTE",{"v":213924.65,"d":"213,924.65"}]
[null,"  ",null,"15.Otros impuestos",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$nulls":3},"TOTAL ACTIVO",{"v":456814.23,"d":"456,814.23"}]
[null,"  ","VI.RESULTADO DE EJERCICIO (BENEFICIOS)",null,{"v":55723.570000000225,"d":"55,723.57"},{"v":37462.36000000035,"d":"37,462.36"}]
[{"$nulls":9},"P A S I V O",{"v":2001,"d":"2,001"}]
[{"$nulls":9},"PASIVO FIJO",{"v":391293.89,"d":"391,293.89"}]
[{"$nulls":3},"H A B E R",{"v":2000,"d":"2,000"},{"v":2001,"d":"2,001"},{"$nulls":3},"PASIVO CIRCULANTE",{"v":65520.34,"d":"65,520.34"}]
[null,"B)","INGRESOS (B.1 a B.8)                         ",null,{"v":1555348.16,"d":"1,555,348.16"},{"v":1909388.3199999998,"d":"1,909,388.32"},{"$nulls":3},"TOTAL PASIVO",{"v":456814.23,"d":"456,814.23"}]
[null,"  ",null,"1. Ingresos de explotación",{"v":1483081.03,"d":"1,483,081.03"},{"v":1799649.88,"d":"1,799,649.88"}]
[null,"  ",null,"     a) Importe neto de la cifra de negocios",{"v":1481867.19,"d":"1,481,867.19"},{"v":1799649.88,"d":"1,799,649.88"}]
[null,"  ",null,"     b) Otros ingresos de explotación",{"v":1213.84,"d":"1,213.84"},{"v":0,"d":"0.00"}]
[null,"  ","I. PERDIDAS DE EXPLOTACION",null,{"v":0,"d":"0.00"},{"v":23506.619999999646,"d":"23,506.62"}]
[null,"  ",null,"2. Ingresos financieros",11.66,{"v":2223.38,"d":"2,223.38"}]
[null,"  ",null,"     a) En empresas del grupo",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"     b) En empresas asociadas",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"     c) Otros",11.66,{"v":2223.38,"d":"2,223.38"}]
[null,"  ",null,"     d) Beneficios en inversiones financieras",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"3. Diferencias positivas de cambio",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ","II. RESULTADOS FINANCIEROS NEGATIVOS",null,{"v":12686.28,"d":"12,686.28"},{"v":14570.689999999999,"d":"14,570.69"}]
[null,"  ","III.PÉRDIDAS DE LAS ACTIVIDADES ORDINARIAS",null,{"v":0,"d":"0.00"},{"v":38077.30999999965,"d":"38,077.31"}]
[null,"  ",null,"4. Beneficios enajenación de inmov. y cartera de control",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"5. Beneficios operaciones con acciones y obligaciones propias",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"6. Subvenciones de capital transferidas al resultado ejercicio",{"v":1577.66,"d":"1,577.66"},{"v":0,"d":"0.00"}]
[null,"  ",null,"7. Ingresos extraordinarios",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ",null,"8. Ingresos y benefic ios de otros ejercicios",{"v":70677.81,"d":"70,677.81"},{"v":107515.06,"d":"107,515.06"}]
[null,"  ","IV.RESULTADOS EXTRAORDINARIOS NEGATIVOS",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ","V. PERDIDAS ANTES DE IMPUESTOS",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"  ","VI.RESULTADO DEL EJERCICIO (PÉRDIDAS)",null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]

{"sheet":"Ayuda","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}