Live demo
This is what a company scan looks like
Below runs the same calculation I use to assess companies for clients: fourteen ratios, five modules, one score and one number to act on. Move the assumptions and watch the result change.
Every figure here is invented. This is not a real company and not a client — client filings do not go on a public website. The data is, however, internally consistent: the ratios come from the balance sheet, the score from the ratios, and the valuation from the same result as the analysis.
Sample company
Technical integration · project-based sales
Revenue
31,6m
+31,1%y/y
EBITDA
3,4m
+30,8%y/y
Net profit
1,9m
+35,7%y/y
Equity
8,5m
+28,8%y/y
The revenue path
Three years of filed accounts and three years of assumptions. The boundary is marked because these are two different kinds of number.
Where the revenue actually goes
The income statement drawn as a flow. Ribbon width is the amount, so it is immediately clear that cost of sales decides the outcome, not tax.
Overall score
Five modules weighted into a single number. Click a module to see the ratios behind it.
Scale: A from 85, B from 70, C from 55, D from 40, below that E.
Click a module to expand
- EBITDA margin10,8%73
sector median: 9,00 · better than the market
- Net margin6,0%75
sector median: 4,20 · better than the market
- Return on equity22,4%86
sector median: 14,00 · better than the market
- Return on assets9,1%83
sector median: 5,50 · better than the market
- Current ratio1,52×71
sector median: 1,45 · better than the market
- Quick ratio1,07×68
sector median: 1,05 · better than the market
- Net debt / EBITDA0,76×95
sector median: 1,80 · better than the market
- Debt / equity0,49×90
sector median: 0,85 · better than the market
- Interest cover7,44×86
sector median: 5,00 · better than the market
- Days sales outstanding106 d19
sector median: 62 · worse than the market
- Days inventory64 d54
sector median: 48 · worse than the market
- Asset turnover1,52×65
sector median: 1,55 · worse than the market
- Revenue growth31,1%97
sector median: 8,00 · better than the market
- Net profit growth35,7%94
sector median: 6,00 · better than the market
The diagnosis in one sentence
A score without a narrative is useless. A board needs to know which module drags it down, for what reason, and which single number has to change.
The module dragging it down
Efficiency
46 / 100
Cause
The company collects its receivables in 106 days against a sector median of 62. Every day of delay ties up cash that then has to be funded with a working capital facility — even though the income statement looks healthy.
One number to act on
Bringing collection down to 75 days releases this much cash:
2,71m
That is the amount worth fighting for at the next board meeting — rather than a general “let’s work on liquidity”.
The same company, now valued
Three methods calculated independently and combined with weights chosen to fit the profile. Move the assumptions — everything recalculates at once.
Assumptions
Here the asset approach is a floor on value rather than a valuation of a growing company — hence the 10% weight. For a loss-making company the order would be reversed.
- Enterprise value
- 20,4 m
- Net debt
- −2,6 m
Equity value
17,8m
Range at cost of capital ±1 pp: 16,9 – 19,0 m
Why a future pound is worth less
Every forecast year is brought back to today. The further out the year, the harder the shrink — and that is all the phrase “cost of capital” really means.
Want to see this on your own numbers?
I run the same calculation on filed accounts or straight from the ledgers. Write to me and I will tell you what I need and how long it takes.