Net Income From Discontinued Operations (Historical)
Returns the historical net income (or loss) from discontinued operations. This represents earnings from business segments that have been sold, disposed of, or classified as held for sale.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol (e.g., AAPL, MSFT) |
| Year | Yes | Fiscal year (2023) or period code (lq, ly) |
| Quarter | No | Quarter number 1-4 (default: 1) |
| TTM | No | Set to "TTM" for trailing twelve months |
Period Codes
| Code | Description |
|---|---|
lq |
Last reported quarter |
lq-1 |
One quarter ago |
ly |
Last fiscal year |
ly-1 |
Previous fiscal year |
lt |
Last twelve months (TTM) |
Notes
- Often zero for companies without discontinued operations
- Includes gains/losses from disposal of business segments
- Reported net of applicable taxes
- Important for understanding one-time vs recurring earnings
Examples
=hf_Net_Income_from_Discontinued_Operations("GE", 2023, 4)=hf_Net_Income_from_Discontinued_Operations("IBM", "ly")=hf_Net_Income_from_Discontinued_Operations("JNJ", 2022, , "TTM")=hf_Net_Income_from_Discontinued_Operations(A1, B1, C1)When to Use
- Analyzing companies undergoing restructuring
- Separating recurring from non-recurring earnings
- Understanding divestitures impact on earnings
- Adjusting earnings for valuation purposes
- Comparing core business performance
When NOT to Use
Common Issues & FAQ
Q: Why is the value zero? A: Most companies don't have discontinued operations in any given period. Zero is a valid result indicating no discontinued operations.
Q: Is this included in total net income?
A: Yes, hf_Net_Income() includes both continuing and discontinued operations. Use this function to separate them.
Q: How do I calculate continuing operations income?
A: Subtract this from total net income: =hf_Net_Income("AAPL",2023) - hf_Net_Income_from_Discontinued_Operations("AAPL",2023)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?