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
Syntax
=hf_Net_Income_from_Discontinued_Operations(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year or period code (e.g., 2023, lq, ly)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Net income from discontinued operations
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
| Scenario | Use Instead |
|---|---|
| Need total net income | hf_Net_Income() |
| Need continuing operations only | hf_Net_Income_Common_Stock_USD() |
| Need operating income | hf_Operating_Income() |
| Need current EPS | EarningsPerShare() |
Common Issues & FAQ
Why is the value zero?
Most companies don't have discontinued operations in any given period. Zero is a valid result indicating no discontinued operations.
Is this included in total net income?
Yes, hf_Net_Income() includes both continuing and discontinued operations. Use this function to separate them.
How do I calculate continuing operations income?
Subtract this from total net income: =hf_Net_Income("AAPL",2023) - hf_Net_Income_from_Discontinued_Operations("AAPL",2023)
Excel Templates Using Net Income From Discontinued Operations (Historical)
These ready-made MarketXLS templates call hf_Net_Income_from_Discontinued_Operations() in their worksheet formulas. Open one to see the function working inside a complete model.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Net Income from Total Operations (Historical)
- Net Income Growth (Historical)
- Net Income Loss (Historical)
- Net Income To Non Controlling Interests (Historical)
- Net Profit Indicator (Historical)
- Non Current Deferred Income Taxes (Historical)
- Normalized Income (Historical)
- Normalized Income Per Employee (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today