Skip to main content

ChapterRatios & Financial Analysis

Chapter 7 — The ratios one by one

Keep this chapter at hand when you explain a result to a client: how a status is born, how the BFR's word thresholds are read, where the score and the risk come from, then every ratio of the standard settings, family by family.

In this chapter

  • How a status is born
  • The working capital requirement and its word thresholds
  • The score, the risk and the order of the lists
  • The six families and their ratios
  1. Thresholds
  2. Status
  3. Score
  4. Risk
Book contents

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:

  1. if the value meets the Good threshold, the ratio is Good;
  2. otherwise, if it falls within the Critical threshold, it is Critical;
  3. 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:

SituationWCR 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 negativeGood
Otherwise, it has not risen since the previous yearGood
Otherwise, it has risenTo watch
First year, with no previous yearThe 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
CommercialVentes de marchandises (sales of goods)Coût d'achat des marchandises vendues (cost of goods sold)
IndustrialRevenus (revenue)Achats de matières consommés (materials consumed)
ServicesRevenus (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

RatioWhat it computesThresholds: critical · to watch · good
Current ratioCurrent 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 ratioCash and cash equivalents ÷ current liabilities< 0,2 · 0,2 – 0,5 · > 0,5
Net cashWorking capital − WCR, in dinars< 0 · about 0 · > 0
Net cash / RevenueNet 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

RatioWhat it computesThresholds: critical · to watch · good
Working capitalPermanent capital (equity + loans) − net fixed assets, in dinars< 0 · 0 – 100 000 · > 100 000
Financial autonomyEquity ÷ total equity and liabilities< 20 % · 20 % – 30 % · > 30 %
Overall debt ratioTotal liabilities ÷ total equity and liabilities> 70 % · 50 % – 70 % · < 50 %
Financial debt / Equity(Loans + bank overdrafts) ÷ equity> 2 · 1 – 2 · < 1
Interest coverageEBITDA ÷ financial expenses< 1 · 1 – 3 · > 3
Net gearing(Financial debt − cash − investments) ÷ equity> 1 · 0,5 – 1 · < 0,5
Fixed asset coveragePermanent capital ÷ fixed assets< 1 · 1 – 1,5 · > 1,5
Financial debt / EBITDAFinancial debt ÷ EBITDA> 4 · 2 – 4 · < 2
Tax and social security liabilities / RevenueOther current liabilities of the balance sheet ÷ revenue> 15 % · 5 % – 15 % · < 5 %
Equity / Fixed assetsEquity ÷ fixed assets< 0,5 · 0,5 – 1 · > 1

These ratios tell who finances the company and whether it can carry its debt.

Profitability

RatioWhat it computesThresholds: critical · to watch · good
Net marginNet 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 marginGross margin ÷ revenue< 20 % · 20 % – 40 % · > 40 %
EBITDA marginEBITDA ÷ 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

RatioWhat it computesThresholds: critical · to watch · good
Working capital requirementInventories + trade receivables + other current assets − suppliers − other current liabilities, in dinarsVery high vs revenue · Rising · Under control / falling
Average customer collection periodTrade receivables incl. VAT ÷ revenue incl. VAT × 360> 120 d · 60 – 120 d · < 60 d
Average supplier payment periodTrade payables incl. VAT ÷ purchases incl. VAT × 360< 30 d or > 120 d · 30 – 45 d · 45 – 90 d
Inventory turnoverPurchases consumed ÷ inventories< 3 · 3 – 6 · > 6
Days inventory outstandingInventories ÷ purchases consumed × 360> 120 d · 30 – 120 d · < 30 d
WCR in days of revenueWCR ÷ 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

RatioWhat it computesThresholds: critical · to watch · good
Revenue growthRevenue of the year ÷ revenue of the previous year − 1< 0 % · 0 % – 10 % · > 10 %
Net income growthNet income of the year ÷ net income of the previous year − 1< 0 % · 0 % – 10 % · > 10 %
Value added / RevenueValue added ÷ revenue< 20 % · 20 % – 40 % · > 40 %
Staff costs / RevenueStaff 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)

RatioWhat it computesThresholds: critical · to watch · good
Top 5 customer concentrationTop 5 customer balances ÷ total customer balances> 50 % · 30 % – 50 % · < 30 %
Overdue receivables / Trade receivablesOverdue customer receivables ÷ total customer balances> 25 % · 10 % – 25 % · < 10 %
Top 5 supplier concentrationTop 5 supplier balances ÷ total supplier balances> 70 % · 40 % – 70 % · < 40 %
Receivable provisions / Trade receivablesProvisions 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.