Brill (5ZQ.F)
Every figure this model derived for 5ZQ.F, the value it took, and the element in the company's own XBRL it was read from — so any of it can be checked against the filing rather than taken on trust. As at 2022-12-31.
The figures, and where each came from
This is the part no other screener shows. Each figure below names the XBRL element it was read from, so it can be checked against the filing itself.
| Figure | Value | XBRL tag | As at |
|---|---|---|---|
| capex | 1,088,000 | PurchaseOfPropertyPlantAndEquipmentClassifiedAsInvestingActivities |
2022-12-31 |
| cash | 3,701,000 | CashAndCashEquivalents |
2023-01-01 |
| current assets | 17,271,000 | CurrentAssets |
2023-01-01 |
| current liabilities | 27,200,000 | CurrentLiabilities |
2023-01-01 |
| equity | 19,713,000 | Equity |
2023-01-01 |
| interest expense | 293,000 | FinanceCosts |
2022-12-31 |
| ocf | 8,096,000 | CashFlowsFromUsedInOperatingActivities |
2022-12-31 |
| revenue | 48,048,000 | Revenue |
2022-12-31 |
The ratios
The figures themselves rather than their scores — what somebody looking up 5ZQ.F on one particular measure came for.
| Ratio | Value |
|---|---|
| cash operating margin | -9.39 |
| current ratio | 0.63 |
| current ratio reported | 0.63 |
| fcf margin | 14.59 |
| interest cover | -15.4 |
| operating margin | -9.39 |
| owner earnings margin | 14.59 |
| revenue growth | 2.52 |
| revenue growth per share | 2.52 |
| roic | -16.81 |
| rule of 40 | -6.87 |
| sbc pct revenue | 0.0 |
What to be careful about
What this model itself distrusts about 5ZQ.F's figures. Written by the derivation as it ran, not added afterwards.
- newest fact in the filing is 2023-01-01 (3y old); this company's data is not usable and the scores below should be ignored
- revenue is annual, not TTM
- operating income is annual, not TTM
- revenue period ends 2022-12-31 (1357 days ago) - the tag chain found nothing recent, so treat this row as unscored
- no current stock compensation tagged; treated as zero, so owner earnings are overstated
- no market cap; set `market_cap` in overrides.yaml
- no usable diluted share count, so growth is measured on total revenue rather than per share; a company issuing shares to fund that growth reads better than it is
- no forward EPS estimate; growth rests on filings only. Analyst consensus is not published in XBRL, so it has to be fetched from a data provider or set by hand in overrides.yaml as `eps_growth_2y`
- valuation DROPPED from the total: only 0 of 2 inputs could be computed (ev sales, ev owner earnings not tagged), so the score is not meaningful. Its weight is spread over the other dimensions
- durability DROPPED from the total: only 2 of 4 inputs could be computed (worst year, contracted coverage not tagged), so the score is not meaningful. Its weight is spread over the other dimensions
- growth rests on 3 of 4 inputs; not tagged: sustained growth
- 2 of 5 dimensions could not be measured (valuation, durability -- 35% of the model), so this row is not comparable with the others; its total rests on what was left