{
  "version": "18.4.14",
  "sheets": [
    {
      "id": "Sheet1",
      "name": "Dashboard",
      "colNumber": 4,
      "rowNumber": 40,
      "rows": {},
      "cols": {
        "0": { "size": 225 },
        "1": { "size": 445 },
        "2": { "size": 225 },
        "3": { "size": 445 }
      },
      "merges": [],
      "cells": {
        "B2": "=_t(\"(Net sales – COGS) / Net sales\")",
        "B3": "=_t(\"> 50%: hugely profitable business\")",
        "B4": "=_t(\"< 20%: hard to become profitable\")",
        "B5": "=_t(\"possible issue in the business model\")",
        "B10": "=_t(\"EBIT / Net sales\")",
        "B11": "=_t(\"< 5%: not efficient at operating business\")",
        "B12": "=_t(\"> 10%: very efficient at operating business\")",
        "B13": "=_t(\"possible issue in COGS (Cost of Goods sold)\")",
        "B18": "=_t(\"Current assets / Current liabilities\")",
        "B19": "=_t(\"> 1.5: strong financial performance\")",
        "B20": "=_t(\"< 1: weak financial performance\")",
        "B21": "=_t(\"possible issue with asset distribution and cash availability\")",
        "B26": "=_t(\"Current assets – Current liabilities\")",
        "B27": "=_t(\"> 0: company can meet financial obligations at any time\")",
        "B28": "=_t(\"< 0: company might not be able to meet obligations\")",
        "B29": "=_t(\"possible issues in cash availability at short term\")",
        "B34": "=_t(\"Sales on account / Average accounts receivable balance for period\")",
        "B35": "=_t(\"< 45: company gets paid for sales quickly\")",
        "B36": "=_t(\"> 60: company might not get paid for sales quickly enough\")",
        "B37": "=_t(\"possible issue in payment terms agreement with clients to get paid faster\")",
        "B38": "=_t(\"Very dependent on the sector\")",
        "B39": "=_t(\"Best if compared with competitors\")",
        "D2": "=_t(\"Net income / Revenue\")",
        "D3": "=_t(\"< 3%: not efficient at generating business\")",
        "D4": "=_t(\"> 10%: very efficient\")",
        "D5": "=_t(\"possible issue in direct and indirect costs\")",
        "D10": "=_t(\"Total liabilities / Total shareholders’ equity\")",
        "D11": "=_t(\"< 2.5: mature company who accumulated a lot of money\")",
        "D12": "=_t(\"> 5: company owns a lot of debt and not of a lot of own money\")",
        "D13": "=_t(\"possible issue in ressources allocation or missed growth opportunities\")",
        "D18": "=_t(\"Cash flow / Current liabilities\")",
        "D19": "=_t(\"> 1: income allow to meet financial obligations\")",
        "D20": "=_t(\"< 0.8: income might be too low\")",
        "D21": "=_t(\"number of times you can pay off current debts with cash generated per year\")",
        "D26": "=_t(\"Quick assets / Current liabilities\")",
        "D27": "=_t(\"> 1: company in highly solvent position\")",
        "D28": "=_t(\"< 0.7: company might be stuck with non liquid assets\")",
        "D29": "=_t(\"possible issues in cash availability at short term\")",
        "D34": "=_t(\"Net Credit Purchases / Average accounts payable balance for period\")",
        "D35": "=_t(\"< 45: company liquidates debts to suppliers quickly\")",
        "D36": "=_t(\"> 70: company might be slow to pay suppliers\")",
        "D37": "=_t(\"possible issue in providers payments, could lead to loss of suppliers trust\")",
        "D38": "=_t(\"Very dependent on the sector\")",
        "D39": "=_t(\"Best if compared with competitors\")"
      },
      "styles": {
        "B2": 1,
        "B10": 1,
        "B18": 1,
        "B26": 1,
        "B34": 1,
        "D2": 1,
        "D10": 1,
        "D18": 1,
        "D26": 1,
        "D34": 1
      },
      "formats": {},
      "borders": {},
      "conditionalFormats": [],
      "dataValidationRules": [],
      "figures": [
        {
          "id": "3d4e431e-fdfb-4aba-baba-14a9990b0a22",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#EA9999",
                "middleColor": "#F9CB9C",
                "upperColor": "#B6D7A8"
              },
              "rangeMin": "0",
              "rangeMax": "1",
              "lowerInflectionPoint": { "type": "number", "value": "0.2", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "0.5", "operator": "<=" }
            },
            "title": { "text": "Gross profit margin", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B2"
          },
          "offset": { "x": 0, "y": 0 },
          "col": 0,
          "row": 0
        },
        {
          "id": "777d58a8-e76e-4ef6-a16a-8ded6a18a524",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#EA9999",
                "middleColor": "#F9CB9C",
                "upperColor": "#B6D7A8"
              },
              "rangeMin": "0",
              "rangeMax": "0.5",
              "lowerInflectionPoint": { "type": "number", "value": "0.03", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "0.06", "operator": "<=" }
            },
            "title": { "text": "Net profit margin", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B3"
          },
          "offset": { "x": 670, "y": 0 },
          "col": 0,
          "row": 0
        },
        {
          "id": "7c87cbda-1869-4ada-a479-f83447de6c35",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#EA9999",
                "middleColor": "#F9CB9C",
                "upperColor": "#B6D7A8"
              },
              "rangeMin": "0",
              "rangeMax": "0.5",
              "lowerInflectionPoint": { "type": "number", "value": "0.05", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "0.1", "operator": "<=" }
            },
            "title": { "text": "Operating margin", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B4"
          },
          "offset": { "x": 0, "y": 184 },
          "col": 0,
          "row": 0
        },
        {
          "id": "da7d6686-f16e-4ecc-9e4f-6e855e2472b1",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#EA9999",
                "middleColor": "#F9CB9C",
                "upperColor": "#B6D7A8"
              },
              "rangeMin": "0",
              "rangeMax": "10",
              "lowerInflectionPoint": { "type": "number", "value": "1", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "1.5", "operator": "<=" }
            },
            "title": { "text": "Current ratio", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B6"
          },
          "offset": { "x": 0, "y": 368 },
          "col": 0,
          "row": 0
        },
        {
          "id": "dd3e9285-4be0-4511-b6e9-c1d6b27aa6fa",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#EA9999",
                "middleColor": "#F9CB9C",
                "upperColor": "#B6D7A8"
              },
              "rangeMin": "-2",
              "rangeMax": "12",
              "lowerInflectionPoint": { "type": "number", "value": "0.8", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "1", "operator": "<=" }
            },
            "title": { "text": "Cash flow ratio", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B7"
          },
          "offset": { "x": 670, "y": 368 },
          "col": 0,
          "row": 0
        },
        {
          "id": "ce3a4fe4-5bd7-4571-942e-913061864e42",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#EA9999",
                "middleColor": "#F9CB9C",
                "upperColor": "#B6D7A8"
              },
              "rangeMin": "-1000",
              "rangeMax": "1000",
              "lowerInflectionPoint": { "type": "number", "value": "0", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "0", "operator": "<=" }
            },
            "title": { "text": "Working capital", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B8"
          },
          "offset": { "x": 0, "y": 552 },
          "col": 0,
          "row": 0
        },
        {
          "id": "262de936-0aa6-42f5-9c2a-94ca9f3fd6f9",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#EA9999",
                "middleColor": "#F9CB9C",
                "upperColor": "#B6D7A8"
              },
              "rangeMin": "0",
              "rangeMax": "5",
              "lowerInflectionPoint": { "type": "number", "value": "0.7", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "1", "operator": "<=" }
            },
            "title": { "text": "Quick ratio", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B9"
          },
          "offset": { "x": 670, "y": 552 },
          "col": 0,
          "row": 0
        },
        {
          "id": "244bf3e6-9fb6-4979-b01c-303b7737bd7f",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#B6D7A8",
                "middleColor": "#F9CB9C",
                "upperColor": "#EA9999"
              },
              "rangeMin": "0",
              "rangeMax": "90",
              "lowerInflectionPoint": { "type": "number", "value": "45", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "60", "operator": "<=" }
            },
            "title": { "text": "Average debtor days", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B10"
          },
          "offset": { "x": 0, "y": 736 },
          "col": 0,
          "row": 0
        },
        {
          "id": "19747691-3f23-4572-bda0-4090744d9d13",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#B6D7A8",
                "middleColor": "#F9CB9C",
                "upperColor": "#EA9999"
              },
              "rangeMin": "0",
              "rangeMax": "100",
              "lowerInflectionPoint": { "type": "number", "value": "45", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "70", "operator": "<=" }
            },
            "title": { "text": "Average payable days", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B11"
          },
          "offset": { "x": 670, "y": 736 },
          "col": 0,
          "row": 0
        },
        {
          "id": "c73f1479-08b5-4598-86b3-90ae40a81528",
          "width": 225,
          "height": 184,
          "tag": "chart",
          "data": {
            "sectionRule": {
              "colors": {
                "lowerColor": "#B6D7A8",
                "middleColor": "#F9CB9C",
                "upperColor": "#EA9999"
              },
              "rangeMin": "0",
              "rangeMax": "10",
              "lowerInflectionPoint": { "type": "number", "value": "2.5", "operator": "<=" },
              "upperInflectionPoint": { "type": "number", "value": "5", "operator": "<=" }
            },
            "title": { "text": "Debt-to-equity", "bold": true, "color": "#434343" },
            "type": "gauge",
            "dataRange": "Data!B5"
          },
          "offset": { "x": 670, "y": 184 },
          "col": 0,
          "row": 0
        }
      ],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    },
    {
      "id": "15fc34c2-8752-4a36-9ecf-84aa216ecf2c",
      "name": "Data",
      "colNumber": 30,
      "rowNumber": 91,
      "rows": {
        "3": { "size": 23 },
        "4": { "size": 23 },
        "13": { "size": 23 },
        "14": { "size": 23 },
        "21": { "size": 23 },
        "22": { "size": 23 },
        "23": { "size": 23 },
        "33": { "size": 23 }
      },
      "cols": {
        "0": { "size": 280 },
        "1": { "size": 175 },
        "2": { "size": 175 },
        "3": { "size": 175 },
        "4": { "size": 175 },
        "5": { "size": 119 }
      },
      "merges": [],
      "cells": {
        "A1": "=_t(\"KPI\")",
        "A2": "=_t(\"Gross profit margin\")",
        "A3": "=_t(\"Net profit margin\")",
        "A4": "=_t(\"Operating margin\")",
        "A5": "=_t(\"Debt-to-equity\")",
        "A6": "=_t(\"Current ratio\")",
        "A7": "=_t(\"Cash flow ratio\")",
        "A8": "=_t(\"Working capital\")",
        "A9": "=_t(\"Quick ratio\")",
        "A10": "=_t(\"Average debtor days\")",
        "A11": "=_t(\"Average creditors days\")",
        "A13": "=_t(\"Aggregate\")",
        "A14": "=_t(\"Net sales\")",
        "A15": "=_t(\"COGS\")",
        "A16": "=_t(\"Gross profit\")",
        "A17": "=_t(\"Total income\")",
        "A18": "=_t(\"Total expense\")",
        "A19": "=_t(\"Net profit\")",
        "A20": "=_t(\"Total Current assets\")",
        "A21": "=_t(\"Total Current liabilities\")",
        "A22": "=_t(\"Total assets\")",
        "A23": "=_t(\"Total liabilities\")",
        "A24": "=_t(\"Total shareholder's equity\")",
        "A25": "=_t(\"Cash flow\")",
        "A26": "=_t(\"Quick assets\")",
        "A27": "=_t(\"Payables\")",
        "A28": "=_t(\"Receivables\")",
        "A30": "=_t(\"Account type\")",
        "A31": "=_t(\"Receivable\")",
        "A32": "=_t(\"Bank and Cash\")",
        "A33": "=_t(\"Current Assets\")",
        "A34": "=_t(\"Prepayments\")",
        "A35": "=_t(\"Non-current Assets\")",
        "A36": "=_t(\"Fixed Assets\")",
        "A37": "=_t(\"Payable\")",
        "A38": "=_t(\"Credit Card\")",
        "A39": "=_t(\"Current Liabilities\")",
        "A40": "=_t(\"Non-current Liabilities\")",
        "A41": "=_t(\"Equity\")",
        "A42": "=_t(\"Income\")",
        "A43": "=_t(\"Other Income\")",
        "A44": "=_t(\"Expenses\")",
        "A45": "=_t(\"Depreciation\")",
        "A46": "=_t(\"Cost of Revenue\")",
        "A47": "=_t(\"Off-Balance Sheet\")",
        "B1": "=_t(\"Value\")",
        "B2": "=IFERROR((B14-B15)/B14)",
        "B3": "=IFERROR(B19/B17)",
        "B4": "=IFERROR((B14-B18)/B14)",
        "B5": "=IFERROR(B23/B24)",
        "B6": "=IFERROR(B20/ABS(B21))",
        "B7": "=IFERROR(B25/B21)",
        "B8": "=FORMAT.LARGE.NUMBER(IFERROR(B20-B21))",
        "B9": "=IFERROR(B26/ABS(B21))",
        "B10": "=IFERROR(B28/ABS(B14)*30)",
        "B11": "=IFERROR(B27/ABS(B15)*30)",
        "B13": "=_t(\"Value\")",
        "B14": "=B42",
        "B15": "=B46",
        "B16": "=B14-B15",
        "B17": "=B42+B43",
        "B18": "=B44+B45+B46",
        "B19": "=B17-B18",
        "B20": "=B31+B32+B33+B34",
        "B21": "=B37+B38+B39",
        "B22": "=B31+B32+B33+B35+B34+B36",
        "B23": "=B37+B38+B39+B40",
        "B24": "=B22-B23",
        "B25": "=B32",
        "B26": "=B31+B32+B34",
        "B27": "=B37",
        "B28": "=B31",
        "B30": "=F1",
        "B31": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C31),B$30)",
        "B32": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C32),B$30)",
        "B33": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C33),B$30)",
        "B34": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C34),B$30)",
        "B35": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C35),B$30)",
        "B36": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C36),B$30)",
        "B37": "=-ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C37),B$30)",
        "B38": "=-ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C38),B$30)",
        "B39": "=-ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C39),B$30)",
        "B40": "=-ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C40),B$30)",
        "B41": "=-ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C41),B$30)",
        "B42": "=-ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C42),B$30)",
        "B43": "=-ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C43),B$30)",
        "B44": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C44),B$30)",
        "B45": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C45),B$30)",
        "B46": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C46),B$30)",
        "B47": "=ODOO.BALANCE(ODOO.ACCOUNT.GROUP($C47),B$30)",
        "C1": "=_t(\"Formula\")",
        "C2": "=_t(\"(Net sales – COGS) / Net sales\")",
        "C3": "=_t(\"Net income / Revenue\")",
        "C4": "=_t(\"(Net sales - Total expenses) / Net sales\")",
        "C5": "=_t(\"Total liabilities / Total shareholders’ equity\")",
        "C6": "=_t(\"Current assets / Current liabilities\")",
        "C7": "=_t(\"Cash flow / Current liabilities\")",
        "C8": "=_t(\"Current assets – Current liabilities\")",
        "C9": "=_t(\"Quick assets / Current liabilities\")",
        "C10": "=_t(\"Receivables / Income * 30\")",
        "C11": "=_t(\"Payables / Expenses * 30\")",
        "C14": "=_t(\"income\")",
        "C15": "=_t(\"cost of revenue\")",
        "C16": "=_t(\"net sales - COGS\")",
        "C17": "=_t(\"income + other income\")",
        "C18": "=_t(\"expenses + depreciation + cost of revenue\")",
        "C19": "=_t(\"total income - total expense\")",
        "C20": "=_t(\"receivable + bank and cash + current assets + prepayments\")",
        "C21": "=_t(\"payable + credit card + current liabilities\")",
        "C22": "=_t(\"receivable + bank and cash + current assets + non-current assets + prepayments + fixed assets\")",
        "C23": "=_t(\"payable + credit card + current liabilities + non-current liabilities\")",
        "C24": "=_t(\"total assets - total liabilities\")",
        "C25": "=_t(\"bank and cash\")",
        "C26": "=_t(\"receivable + bank and cash + prepayments\")",
        "C27": "=_t(\"payable\")",
        "C28": "=_t(\"receivable\")",
        "C30": "=_t(\"Technical name\")",
        "C31": "asset_receivable",
        "C32": "asset_cash",
        "C33": "asset_current",
        "C34": "asset_prepayments",
        "C35": "asset_non_current",
        "C36": "asset_fixed",
        "C37": "liability_payable",
        "C38": "liability_credit_card",
        "C39": "liability_current",
        "C40": "liability_non_current",
        "C41": "equity",
        "C42": "income",
        "C43": "income_other",
        "C44": "expense",
        "C45": "expense_depreciation",
        "C46": "expense_direct_cost",
        "C47": "off_balance",
        "E1": "=_t(\"Month-Year\")",
        "E2": "=_t(\"Month\")",
        "E3": "=_t(\"Year\")",
        "E4": "=_t(\"Start date\")",
        "E5": "=_t(\"Offset -1 - Start date\")",
        "E6": "=_t(\"Offset -1 - Month\")",
        "E7": "=_t(\"Offset -1 - Year\")",
        "E8": "=_t(\"Offset -1 - Month-Year\")",
        "E9": "=_t(\"Offset -4 - Start date\")",
        "E10": "=_t(\"Offset -4 - Month\")",
        "E11": "=_t(\"Offset -4 - Year\")",
        "E12": "=_t(\"Offset -4 - Month-Year\")",
        "F1": "=ODOO.FILTER.VALUE(\"Month\")",
        "F2": "=MONTH(F1)",
        "F3": "=YEAR(F1)",
        "F4": "=CONCATENATE(F2,\"/01/\",F3)",
        "F5": "=EDATE(F4,-1)",
        "F6": "=IF(LEN(MONTH(F5))=1,CONCATENATE(\"0\",MONTH(F5)),MONTH(F5))",
        "F7": "=YEAR(F5)",
        "F8": "=CONCATENATE(F6,\"/\",F7)",
        "F9": "=EDATE(F4,-4)",
        "F10": "=IF(LEN(MONTH(F9))=1,CONCATENATE(\"0\",MONTH(F9)),MONTH(F9))",
        "F11": "=YEAR(F9)",
        "F12": "=CONCATENATE(F10,\"/\",F11)"
      },
      "styles": {
        "A13": 1,
        "A1:C1": 1,
        "E2:E7": 1,
        "E9:E11": 1,
        "A14:B15": 2,
        "A17:B18": 2,
        "A20:B23": 2,
        "A25:B28": 2,
        "A16": 3,
        "B16": 4,
        "A19:B19": 4,
        "A24:B24": 4,
        "A30": 5,
        "C30": 5,
        "A31:C41": 6,
        "F8": 6,
        "F12": 6,
        "A42:C46": 7,
        "A47:C47": 8,
        "B13": 9,
        "B30": 10,
        "E1": 11,
        "E8": 11,
        "E12": 11
      },
      "formats": { "B2:B4": 1, "B5:B11": 2, "F5": 3 },
      "borders": {},
      "conditionalFormats": [],
      "dataValidationRules": [],
      "figures": [],
      "tables": [],
      "areGridLinesVisible": true,
      "isVisible": true,
      "headerGroups": {
        "ROW": [],
        "COL": []
      },
      "comments": {}
    }
  ],
  "styles": {
    "1": { "bold": true },
    "2": { "fillColor": "#d9ead3" },
    "3": { "fillColor": "#B6D7A8" },
    "4": { "fillColor": "#b6d7a8" },
    "5": { "fillColor": "#a4c2f4", "bold": true },
    "6": { "fillColor": "#c9daf8" },
    "7": { "fillColor": "#ead1dc" },
    "8": { "fillColor": "#f3f3f3" },
    "9": { "align": "right", "bold": true },
    "10": { "fillColor": "#a4c2f4", "bold": true, "align": "right" },
    "11": { "bold": true, "fillColor": "#c9daf8" }
  },
  "formats": { "1": "0.0%", "2": "0.0", "3": "m/d/yyyy" },
  "borders": {},
  "revisionId": "START_REVISION",
  "uniqueFigureIds": true,
  "settings": {
    "locale": {
      "name": "English (US)",
      "code": "en_US",
      "thousandsSeparator": ",",
      "decimalSeparator": ".",
      "dateFormat": "mm/dd/yyyy",
      "timeFormat": "hh:mm:ss",
      "formulaArgSeparator": ",",
      "weekStart": 7
    }
  },
  "pivots": {},
  "pivotNextId": 1,
  "customTableStyles": {},
  "globalFilters": [
    {
      "id": "069d7cf1-9623-4d6e-8226-ad7c60112662",
      "type": "date",
      "label": "Month",
      "defaultValue": "this_month"
    }
  ],
  "lists": {},
  "listNextId": 1,
  "chartOdooMenusReferences": {}
}
