How a status is born
Every ratio has three thresholds: a Critical threshold, a Watch threshold and a Good threshold. The calculation reads them in this order:
- if the value meets the Good threshold, the ratio is Good;
- otherwise, if it falls within the Critical threshold, it is Critical;
- otherwise, it is To watch.
So the watch threshold is only an indication: anything that is neither good nor critical is to watch. A threshold reads "> 1,2", "< 1,0", "1,0 – 1,2" (both ends included) or holds two conditions: "< 30 d or > 120 d". A ratio with no value has no status.
Example, the current ratio, thresholds "< 1,0 / 1,0 – 1,2 / > 1,2": 1,56 is Good, 1,10 is To watch, 0,85 is Critical.
The working capital requirement and its word thresholds
The standard thresholds of the Working capital requirement (WCR, « BFR » in French) are not numbers: "Très élevé / CA" (critical: very high compared with revenue), "En augmentation" (to watch: rising), "Maîtrisé / en baisse" (good: under control or falling). IntegraSys reads them this way:
| Situation | WCR status |
|---|---|
| The WCR, in days of revenue, exceeds the critical threshold of "WCR in days of revenue" (more than 90 days in the standard) | Critical |
| Otherwise, the WCR is zero or negative | Good |
| Otherwise, it has not risen since the previous year | Good |
| Otherwise, it has risen | To watch |
| First year, with no previous year | The status of "WCR in days of revenue": good under 30 days, to watch from 30 to 90 days; to watch if there is no revenue |
A negative WCR is good news: suppliers and other operating debts finance the business.
The score and the risk
The score: a Good ratio is worth 100, To watch 50, Critical 0. The score is their average, rounded to a whole number. Only ratios that have a status count.
Example: 26 good ratios, 3 to watch, 2 critical, so 31 ratios analysed. (26 × 100 + 3 × 50 + 2 × 0) ÷ 31 = 2 750 ÷ 31 = 88,7, rounded to 89.
The risk:
- high as soon as one ratio is critical;
- medium when there are more ratios to watch than good ones;
- low otherwise.
In the example, two ratios are critical: the risk is high, despite a score of 89.
The order of the lists: the alert and recommendation lists of the dashboard, and the points of attention, poor KPIs and main risks of the report, run from the most serious to the least: critical ratios, then ratios to watch. Equal severity keeps the catalogue order. The lists of good ratios hold only ratios with the Good status, in catalogue order.
The ratios, family by family
The tables below give the ratios of the standard settings, with their thresholds: critical / to watch / good. Amounts are in dinars. The catalogue can change: when in doubt, it prevails (Settings › Reference data › Accounting reference, tab Financial ratios).
Where revenue and purchases come from
The ratios take revenue and purchases from the intermediate management balances of the file's financial statements template. In the standard templates:
| Template | "Revenue" for the ratios | "Purchases" for the ratios |
|---|---|---|
| Commercial | Ventes de marchandises (sales of goods) | Coût d'achat des marchandises vendues (cost of goods sold) |
| Industrial | Revenus (revenue) | Achats de matières consommés (materials consumed) |
| Services | Revenus (prestations de services) (service revenue) | Achats consommés (purchases consumed) |
Three ratios use an average: return on equity (ROE), return on assets (ROA) and return on capital employed (ROCE) divide by the average of the two years (equity, total assets or capital employed) when the previous year exists; otherwise by the year's own value.
Liquidity & cash
| Ratio | What it computes | Thresholds: critical · to watch · good |
|---|---|---|
| Current ratio | Current assets ÷ current liabilities | < 1,0 · 1,0 – 1,2 · > 1,2 |
| Quick ratio | (Trade receivables + investments + cash) ÷ current liabilities | < 0,7 · 0,7 – 1,0 · > 1,0 |
| Cash ratio | Cash and cash equivalents ÷ current liabilities | < 0,2 · 0,2 – 0,5 · > 0,5 |
| Net cash | Working capital − WCR, in dinars | < 0 · about 0 · > 0 |
| Net cash / Revenue | Net cash ÷ revenue | < 0 % · 0 % – 10 % · > 10 % |
These ratios tell whether the company can pay what it owes in the short term. The current ratio counts all current assets; the quick ratio keeps only trade receivables, investments and cash: it leaves out inventories and other current assets; the cash ratio keeps only the cash available.
Financial structure & solvency
| Ratio | What it computes | Thresholds: critical · to watch · good |
|---|---|---|
| Working capital | Permanent capital (equity + loans) − net fixed assets, in dinars | < 0 · 0 – 100 000 · > 100 000 |
| Financial autonomy | Equity ÷ total equity and liabilities | < 20 % · 20 % – 30 % · > 30 % |
| Overall debt ratio | Total liabilities ÷ total equity and liabilities | > 70 % · 50 % – 70 % · < 50 % |
| Financial debt / Equity | (Loans + bank overdrafts) ÷ equity | > 2 · 1 – 2 · < 1 |
| Interest coverage | EBITDA ÷ financial expenses | < 1 · 1 – 3 · > 3 |
| Net gearing | (Financial debt − cash − investments) ÷ equity | > 1 · 0,5 – 1 · < 0,5 |
| Fixed asset coverage | Permanent capital ÷ fixed assets | < 1 · 1 – 1,5 · > 1,5 |
| Financial debt / EBITDA | Financial debt ÷ EBITDA | > 4 · 2 – 4 · < 2 |
| Tax and social security liabilities / Revenue | Other current liabilities of the balance sheet ÷ revenue | > 15 % · 5 % – 15 % · < 5 % |
| Equity / Fixed assets | Equity ÷ fixed assets | < 0,5 · 0,5 – 1 · > 1 |
These ratios tell who finances the company and whether it can carry its debt.
Profitability
| Ratio | What it computes | Thresholds: critical · to watch · good |
|---|---|---|
| Net margin | Net income ÷ revenue | < 2 % · 2 % – 5 % · > 5 % |
| Return on equity (ROE) | Net income ÷ (average) equity | < 5 % · 5 % – 10 % · > 10 % |
| Self-financing capacity / Revenue | (Net income + depreciation and provisions) ÷ revenue | < 5 % · 5 % – 10 % · > 10 % |
| Gross margin | Gross margin ÷ revenue | < 20 % · 20 % – 40 % · > 40 % |
| EBITDA margin | EBITDA ÷ revenue | < 8 % · 8 % – 15 % · > 15 % |
| Operating margin | (EBITDA − depreciation and provisions) ÷ revenue | < 5 % · 5 % – 12 % · > 12 % |
| Return on assets (ROA) | Net income ÷ (average) total assets | < 3 % · 3 % – 7 % · > 7 % |
| Return on capital employed (ROCE) | (EBITDA − depreciation and provisions) ÷ (average) capital employed | < 8 % · 8 % – 15 % · > 15 % |
Self-financing capacity is net income plus depreciation, amortisation and provisions. EBITDA is the gross operating surplus of the intermediate management balances. Capital employed is equity plus financial debt.
Activity / working capital
| Ratio | What it computes | Thresholds: critical · to watch · good |
|---|---|---|
| Working capital requirement | Inventories + trade receivables + other current assets − suppliers − other current liabilities, in dinars | Very high vs revenue · Rising · Under control / falling |
| Average customer collection period | Trade receivables incl. VAT ÷ revenue incl. VAT × 360 | > 120 d · 60 – 120 d · < 60 d |
| Average supplier payment period | Trade payables incl. VAT ÷ purchases incl. VAT × 360 | < 30 d or > 120 d · 30 – 45 d · 45 – 90 d |
| Inventory turnover | Purchases consumed ÷ inventories | < 3 · 3 – 6 · > 6 |
| Days inventory outstanding | Inventories ÷ purchases consumed × 360 | > 120 d · 30 – 120 d · < 30 d |
| WCR in days of revenue | WCR ÷ revenue × 360 | > 90 d · 30 – 90 d · < 30 d |
These ratios tell how many days of business the company advances to its customers and its inventories, and how many its suppliers advance to it. Both payment periods are computed including VAT thanks to the VAT rate of the additional information (chapter 5). For the supplier period, a period that is too short weighs on cash and one that is too long may hide late payments: the good level is between 45 and 90 days, and any period between 30 and 45 days or between 90 and 120 days is to watch.
Growth & productivity
| Ratio | What it computes | Thresholds: critical · to watch · good |
|---|---|---|
| Revenue growth | Revenue of the year ÷ revenue of the previous year − 1 | < 0 % · 0 % – 10 % · > 10 % |
| Net income growth | Net income of the year ÷ net income of the previous year − 1 | < 0 % · 0 % – 10 % · > 10 % |
| Value added / Revenue | Value added ÷ revenue | < 20 % · 20 % – 40 % · > 40 % |
| Staff costs / Revenue | Staff costs ÷ revenue | > 30 % · 15 % – 30 % · < 15 % |
| Revenue per employee (inactive) | Revenue ÷ average headcount | < 50 000 · 50 000 – 100 000 · > 100 000 |
| Value added per employee (inactive) | Value added ÷ average headcount | < 25 000 · 25 000 – 60 000 · > 60 000 |
Both growth ratios need the previous year: without it, they stay empty. When the previous year's net income was a loss, the net income growth percentage reads badly: compare the two amounts instead.
Third-party analysis (inactive in the standard)
| Ratio | What it computes | Thresholds: critical · to watch · good |
|---|---|---|
| Top 5 customer concentration | Top 5 customer balances ÷ total customer balances | > 50 % · 30 % – 50 % · < 30 % |
| Overdue receivables / Trade receivables | Overdue customer receivables ÷ total customer balances | > 25 % · 10 % – 25 % · < 10 % |
| Top 5 supplier concentration | Top 5 supplier balances ÷ total supplier balances | > 70 % · 40 % – 70 % · < 40 % |
| Receivable provisions / Trade receivables | Provisions on receivables ÷ net trade receivables of the balance sheet | > 8 % · 2 % – 8 % · < 2 % |
These four ratios read the third-party balance boxes (chapter 5). Once entered, the customer total, the supplier total and the provisions replace the balance sheet amounts; left empty, the balance sheet amounts are used.