Net Cash From Discontinued Operations (Historical)
Returns the net cash provided by or used in discontinued operations for a company. This represents cash flows from business segments that have been or are being disposed of.
Understanding the Metric
Discontinued operations arise when a company:
- Has sold or is selling a business segment
- Has abandoned a line of business
- Is in the process of divesting operations
This line item can be:
- Positive if the discontinued business generated cash before disposal
- Negative if the discontinued business consumed cash
- Zero if the company has no discontinued operations
Parameters
| Parameter | Description |
|---|---|
| Symbol | Stock ticker (e.g., AAPL, MSFT) |
| Year | Fiscal year or period code (lq, ly, lq-1, ly-1, lt, lt-1) |
| Quarter | Optional: 1, 2, 3, or 4 (default: 1) |
| TTM | Optional: "TTM" for trailing twelve months |
Period Codes
| Code | Meaning |
|---|---|
| lq | Last reported quarter |
| lq-1 | Quarter before last |
| ly | Last fiscal year |
| ly-1 | Year before last |
| lt | Last trailing twelve months |
| lt-1 | Prior trailing twelve months |
Syntax
=hf_Net_cash_from_discontinued_operations(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year (e.g., 2023) or period code (lq, lq-1, ly, ly-1, lt, lt-1)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Net cash from discontinued operations (in currency units)
Examples
=hf_Net_cash_from_discontinued_operations("GE", 2023, 4)=hf_Net_cash_from_discontinued_operations("JNJ", "ly")=hf_Net_cash_from_discontinued_operations("IBM", 2023, , "TTM")=hf_Net_cash_from_discontinued_operations(A1, B1, C1)=hf_Net_cash_from_discontinued_operations("AAPL", "lq")When to Use
- Analyzing companies undergoing restructuring
- Understanding cash flows from divestitures
- Calculating total operating cash flow
- Assessing impact of business exits
- Evaluating company transformation
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need continuing operations cash | hf_Net_cash_from_continuing_operations() |
| Need total operating cash flow | Combine both functions |
| Company has no discontinued ops | Value will be zero/NA |
| Need divestiture proceeds | Check investing activities |
Common Issues & FAQ
Why is the value zero or NA?
Most companies don't have discontinued operations. This field only has values when a company is actively divesting business segments.
What qualifies as discontinued operations?
Under accounting rules, a discontinued operation is a component of an entity that has been disposed of or classified as held for sale and represents a separate major line of business or geographical area.
How does this affect total cash flow analysis?
When analyzing total operating cash flow, you should consider both continuing and discontinued operations to get the complete picture.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Net Income (Historical)
- Net Income Common Stock (Historical)
- Net Income Common Stock USD (Historical)
- Net Income from Continuing Operations (Historical)
- Net Income From Discontinued Operations (Historical)
- Net Income from Total Operations (Historical)
- Net Income Growth (Historical)
- Net Income Loss (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today