Net Income From Discontinued Operations (Historical) Formula in Excel

Gain insights into a company's financial performance by using the “Net Income From Discontinued Operations (Historical)” formula in Excel with MarketXLS. This function returns the net income derived from discontinued operations for the specified time period—an important metric when evaluating a company’s overall profitability and financial stability.

Understanding Net Income From Discontinued Operations (Historical)

Net Income From Discontinued Operations refers to the portion of net income generated (or lost) from operations that the company has discontinued or divested. Including this metric in your analysis can help you:

• Distinguish ongoing operational income from income related to discontinued business segments
• Evaluate historical trends for strategic decision-making
• Gain a clearer picture of how one-off operational shifts might have impacted the bottom line

Use this formula when you want to isolate discontinued operations’ contribution to net income from other ongoing segments and compare historical performance across multiple periods.

Syntax and Parameters

Below is the complete syntax for using this function in Excel:

=hf_Net_Income_from_Discontinued_Operations(symbol, year, [quarter], [TTM])

?? Note: This function returns "NA" if the symbol is invalid, if the user does not have a valid subscription, or if an unexpected error occurs.

Return Value

• Returns the company's net income from discontinued operations for the specified historical period.
• If no valid data is found or the symbol is not covered, the function returns "NA".

? Pro Tip: You can reference cells in your spreadsheet for any parameter, such as symbol or year. For instance:

1. =hf_Net_Income_from_Discontinued_Operations(A1, B1) (where A1 has the symbol and B1 has the year)
2. =hf_Net_Income_from_Discontinued_Operations("MSFT", TEXT(A2,"yyyy")) (where A2 is an Excel date, and you convert it to YYYY format for the year parameter)

Examples and Usage

Below are a few common usage scenarios for the “Net Income From Discontinued Operations (Historical)” formula:

1. Basic Yearly Usage

   =hf_Net_Income_from_Discontinued_Operations("MSFT", 2022)

   Retrieves the net income from discontinued operations for Microsoft in 2022.

2. Quarterly Breakdown

   =hf_Net_Income_from_Discontinued_Operations("MSFT", 2022, 2)

   Retrieves the same metric for the second calendar quarter of 2022.

3. Trailing Twelve Months

   =hf_Net_Income_from_Discontinued_Operations("MSFT", 2022, 3, "TTM")

   Retrieves the trailing twelve months value from the third quarter of 2022.

4. Last Quarter (LQ) and Last Year (LY)
   » Last Quarter:

   =hf_Net_Income_from_Discontinued_Operations("MSFT","lq")

   » Last Quarter Minus One (LQ-1):

   =hf_Net_Income_from_Discontinued_Operations("MSFT","lq-1")

   » Last Year:

   =hf_Net_Income_from_Discontinued_Operations("MSFT","ly")

   » Last Year Minus One (LY-1):

   =hf_Net_Income_from_Discontinued_Operations("MSFT","ly-1")

5. Last 12 Months (LT)
   » Last 12 Months:

   =hf_Net_Income_from_Discontinued_Operations("MSFT","lt")

   » Previous Last 12 Months:

   =hf_Net_Income_from_Discontinued_Operations("MSFT","lt-1")

6. Different Symbol Types

   • Indices:

     =hf_Net_Income_from_Discontinued_Operations("^SPX", 2023)

   • Options:

     =hf_Net_Income_from_Discontinued_Operations("@MSFT 110122C00020000", "ly")

   • Crypto:

     =hf_Net_Income_from_Discontinued_Operations("BTCUSD:DEFAULT", 2023, 1)

?? Note: For best performance, ensure you have a valid MarketXLS subscription. Large volumes of requests may affect calculation speed.

Common Questions

1. What if I receive “NA” as a result?

• This typically indicates an invalid symbol, insufficient subscription level, or a data retrieval error. Verify your subscription, confirm the symbol is valid, and check the period parameters.

2. Can I reference cell ranges for the parameters?

• Yes. References like =hf_Net_Income_from_Discontinued_Operations(A1, B1) are recommended for dynamic spreadsheets.

3. Do I need any special subscription for historical data?

• Historical fundamentals (hf_) functions require a MarketXLS historical data subscription. Contact MarketXLS support for details.

4. Are there any limitations on the year range?

• Data availability may vary depending on the company’s reporting history. If data for a specific year is unavailable, the function will return “NA.”

5. How do I differentiate this from net income for continuing operations?

• This function specifically returns net income from discontinued operations. You may use a separate formula (e.g., net income continuing operations) for the remaining net income components.

For further analysis, you can also explore related formulas:

• Revenue (Historical)
• Cost Of Revenue (Historical)
• Gross Profit (Historical)
• R & D Expenses (Historical)
• Selling General and Administrative Expense (Historical)

? Pro Tip: Combine multiple historical fundamental functions in your Excel worksheet to create a complete financial overview of a company’s performance over time.