Net Income To Non Controlling Interests (Historical) Formula in Excel

Gain quick insights into a company's profitability attributed to minority shareholders using the Net Income To Non Controlling Interests (Historical) formula in Excel (with MarketXLS). This function retrieves the historical net income assigned to non-controlling interests, which is especially useful for detailed financial analysis and reporting.

Understanding Net Income To Non Controlling Interests (Historical)

• Purpose and Use Cases
  The Net Income To Non Controlling Interests (Historical) formula helps users analyze the portion of net income allocated to shareholders with less than 50% ownership who do not have controlling power. This can be crucial for accurate equity and earnings evaluations.

• Key Benefits

  • Offers granular insights into minority interest earnings.
  • Ideal for investors comparing majority vs. minority earnings attribution.
  • Helps in detailed financial statement analysis.

• When to Use
  Use this function when you need historical net income figures specifically attributed to non-controlling interests across different quarters, years, or trailing twelve-month (TTM) periods.

Syntax and Parameters

Syntax

=hf_Net_Income_to_Non_Controlling_Interests(Symbol, year, [quarter], [TTM])

Parameters

?? Note: If the symbol is invalid, if data is not available, or if the subscription license is invalid, this function will return "NA".

? Pro Tip: Utilize "TTM" for quarter-based trailing 12 months, and leverage special year inputs like "lq", "ly", or offsets like "lq-1" to retrieve data for previous quarters or years.

Return Value

• Returns a numeric value representing the net income allocated to non-controlling interests for the specified period.
• Returns "NA" if there is an error or the data is unavailable.

Examples and Usage

Below are practical examples demonstrating how to use the function:

1. Basic usage with direct string input for symbol and year:

   =hf_Net_Income_to_Non_Controlling_Interests("MSFT", 2022)

   Retrieves the net income to non-controlling interests for Microsoft in 2022 for the default quarter (1).

2. Specifying a particular quarter:

   =hf_Net_Income_to_Non_Controlling_Interests("MSFT", 2022, 3)

   Returns the figure for the third quarter of 2022.

3. Using trailing twelve months (TTM):

   =hf_Net_Income_to_Non_Controlling_Interests("MSFT", 2022, 2, "TTM")

   Shows the TTM figure ending in the second quarter of 2022.

4. Referencing a cell for the symbol:
   Suppose A1 contains "MSFT":

   =hf_Net_Income_to_Non_Controlling_Interests(A1, 2023, 4)

   Retrieves data for the fourth quarter of 2023.

5. Using offsets like "lq" (last quarter) or "ly" (last year):

   =hf_Net_Income_to_Non_Controlling_Interests("MSFT", "lq")
   =hf_Net_Income_to_Non_Controlling_Interests("MSFT", "ly-1")

   Useful for rolling analysis without manually updating dates.

?? Note: Repeated use of this function across many cells may slow performance due to multiple web requests. Consider using references or caching results for efficiency.

Common Questions

1. What if I only have the symbol in a cell but want to reference the date in another cell?
   Simply reference both cells in the formula:

   =hf_Net_Income_to_Non_Controlling_Interests(A1, B1)

   Where A1 contains the symbol (e.g., "MSFT") and B1 contains the year or any valid year offset (e.g., "ly").

2. How do I handle invalid or unknown symbols?
   If you provide an invalid symbol, the function will return "NA". Verify the correctness of the ticker or symbol format.

3. Can I use an Excel date for the year input?
   While this function primarily expects a numeric or text-based parameter for the year, you can convert a date to a year using Excel functions:

   =hf_Net_Income_to_Non_Controlling_Interests("MSFT", TEXT(A2,"yyyy"))

   Where A2 contains a valid date.

4. Why am I getting "NA" even though I am sure my inputs are correct?
   Potential reasons include:

   • Data may not be available for that symbol and period.
   • The license type for your MarketXLS plan may not support certain historical fundamentals.
   • A temporary data retrieval issue from the server.

5. Is there a limit to how far back I can retrieve this data?
   Historical data availability may vary by symbol and can be subject to data provider limitations. Check MarketXLS documentation for specific coverage details.