TUI AG (TUI1.DE)
Every figure this model derived for TUI1.DE, 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 2023-09-30.
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 |
|---|---|---|---|
| cash | 2,060,300,000 | CashAndCashEquivalents |
2023-10-01 |
| current assets | 4,546,500,000 | CurrentAssets |
2023-10-01 |
| current liabilities | 8,876,900,000 | CurrentLiabilities |
2023-10-01 |
| equity | 1,122,900,000 | EquityAttributableToOwnersOfParent |
2023-10-01 |
| interest expense | 533,600,000 | FinanceCosts |
2023-09-30 |
| revenue | 20,665,900,000 | Revenue |
2023-09-30 |
The ratios
The figures themselves rather than their scores — what somebody looking up TUI1.DE on one particular measure came for.
| Ratio | Value |
|---|---|
| current ratio | 0.51 |
| current ratio reported | 0.51 |
| revenue growth | 24.91 |
| revenue growth per share | 24.91 |
| sbc pct revenue | 0.0 |
What to be careful about
What this model itself distrusts about TUI1.DE's figures. Written by the derivation as it ran, not added afterwards.
- newest fact in the filing is 2023-10-01 (2y old); this company's data is not usable and the scores below should be ignored
- revenue is annual, not TTM
- no operating income found in XBRL
- revenue period ends 2023-09-30 (1084 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 current capital expenditure tagged; treated as zero, so free cash flow is overstated and equals operating cash flow
- 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`
- quality DROPPED from the total: only 1 of 5 inputs could be computed (operating margin, roic, owner earnings, cash operating margin not tagged), so the score is not meaningful. Its weight is spread over the other dimensions
- valuation DROPPED from the total: only 0 of 2 inputs could be computed (ev ebit, 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 1 of 4 inputs could be computed (worst year, contracted coverage, cash flow stability not tagged), so the score is not meaningful. Its weight is spread over the other dimensions
- resilience rests on 2 of 3 inputs; not tagged: interest cover
- growth DROPPED from the total: only 1 of 4 inputs could be computed (sustained growth, margin trend, margin recent not tagged), so the score is not meaningful. Its weight is spread over the other dimensions
- 4 of 5 dimensions could not be measured (quality, valuation, durability, growth -- 85% of the model), so this row is not comparable with the others; its total rests on what was left