Every figure this model derived for DTE, 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 2018-03-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
cash
1,309,000,000
CashAndCashEquivalentsAtCarryingValue
2026-03-31
current assets
4,392,000,000
AssetsCurrent
2026-03-31
current liabilities
4,610,000,000
LiabilitiesCurrent
2026-03-31
equity
12,323,000,000
StockholdersEquity
2026-03-31
revenue
13,124,000,000
Revenues
2018-03-31
sbc
0
AllocatedShareBasedCompensationExpense
2014-06-30
The ratios
The figures themselves rather than their scores — what somebody looking up
DTE on one particular measure came for.
Ratio
Value
current ratio
0.95
current ratio reported
0.95
ev sales
3.99
growth cv
1.73
revenue growth
16.14
revenue growth per share
16.14
rpo growth
6.48
sbc pct revenue
0.0
What to be careful about
What this model itself distrusts about DTE's figures. Written by the
derivation as it ran, not added afterwards.
operating income last tagged 2026-03-31, -2922 days before the revenue period (2018-03-31); dropped rather than divided by current revenue
operating cash flow last tagged 2026-03-31, -2922 days before the revenue period (2018-03-31); dropped rather than divided by current revenue
revenue period ends 2018-03-31 (3072 days ago) - the tag chain found nothing recent, so treat this row as unscored
no current stock compensation tagged (last tagged 2014-06-30); 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 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 (contracted coverage, gross margin stability, 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 2 of 4 inputs could be computed (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
no interest expense tagged while 25,321M of debt is on the balance sheet, so interest cover is unmeasured rather than perfect