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 |
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
Q: Why is the value zero or NA? A: Most companies don't have discontinued operations. This field only has values when a company is actively divesting business segments.
Q: What qualifies as discontinued operations? A: 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.
Q: How does this affect total cash flow analysis? A: When analyzing total operating cash flow, you should consider both continuing and discontinued operations to get the complete picture.
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today