Stock Screener · Library
How should a derived value be distinguished from an as-reported fact?
Label a calculation separately from the reported facts used as its inputs.
Do not put a new formula under a source tag
A reported fact comes from a particular concept, unit, period and filing. A derived value applies an additional method to selected inputs. Keep those categories visible so another reader can distinguish what the filer reported from what the worksheet calculated.
For example, subtracting a chosen capex measure from operating cash flow creates a defined remainder. It should not inherit either input’s source tag or be presented as a separately reported fact unless an actual reported concept supplies it.
Retain enough information to reproduce the result
The two Apple rows below provide operating cash flow and the selected property, plant and equipment payment measure for the same stated duration. A subtraction can be documented separately after checking definitions and signs.
Record the formula, input rows, unit and handling of missing values. A derived remainder or ratio is not a forecast, investment recommendation or guarantee of dividend safety; its meaning depends on the exact definition and source coverage.
Reported source example
Apple Inc. · CIK 320193 · Operating cash flow
| Reported value | Unit | Period type | Start | End | Concept | Filed | Filing FY / FP | Frame | Source filing |
|---|---|---|---|---|---|---|---|---|---|
| 111482000000 | USD | duration | 2024-09-29 | 2025-09-27 | us-gaap:NetCashProvidedByUsedInOperatingActivities | 2025-10-31 | 2025 / FY | CY2025 | 10-K · 0000320193-25-000079 |
Reported source example
Apple Inc. · CIK 320193 · Capital expenditure
| Reported value | Unit | Period type | Start | End | Concept | Filed | Filing FY / FP | Frame | Source filing |
|---|---|---|---|---|---|---|---|---|---|
| 12715000000 | USD | duration | 2024-09-29 | 2025-09-27 | us-gaap:PaymentsToAcquirePropertyPlantAndEquipment | 2025-10-31 | 2025 / FY | CY2025 | 10-K · 0000320193-25-000079 |
Separately labelled derivation
Subtracting the selected property, plant and equipment payment measure from operating cash flow gives the following defined remainder for these inputs. It is a calculation from the two rows above, not an additional as-reported fact or a safety assessment.
- Defined remainder
- 98767000000 USD
- Method
- Operating cash flow minus the selected payment measure
- Period
- 2024-09-29 to 2025-09-27