Every figure this model derived for PNW, 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 2026-06-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
capex
2,649,578,000
PaymentsToAcquireProductiveAssets
2026-06-30
cash
9,124,000
CashAndCashEquivalentsAtCarryingValue
2026-06-30
current assets
2,002,916,000
AssetsCurrent
2026-06-30
current liabilities
3,371,525,000
LiabilitiesCurrent
2026-06-30
equity
7,034,754,000
StockholdersEquity
2026-06-30
interest expense
463,254,000
InterestExpenseNonoperating
2026-06-30
ocf
1,771,041,000
NetCashProvidedByUsedInOperatingActivities
2026-06-30
revenue
5,554,254,000
Revenues
2026-06-30
sbc
27,959,000
ShareBasedCompensation
2026-06-30
The ratios
The figures themselves rather than their scores — what somebody looking up
PNW on one particular measure came for.
Ratio
Value
cash operating margin
38.93
current ratio
0.61
current ratio reported
0.59
deferred revenue growth
48.41
dilution pct
4.94
ebit cagr
13.5
ebit yoy
14.39
fcf margin
-15.82
growth cv
0.39
interest cover
2.46
net debt ebitda
4.94
operating margin
20.52
owner earnings margin
-16.32
revenue growth
5.69
revenue growth per share
0.71
roic
5.12
rule of 40
26.21
sbc pct revenue
0.5
What to be careful about
What this model itself distrusts about PNW's figures. Written by the
derivation as it ran, not added afterwards.
no market cap; set `market_cap` in overrides.yaml
gross profit not tagged; rebuilt from Revenues - CostOfGoodsAndServiceExcludingDepreciationDepletionAndAmortization - dep_amort
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