Normalized Income (Historical) Formula in Excel

Normalized income, often referred to as recurrent or adjusted income, helps provide a more accurate portrayal of a company’s yearly earnings by removing non-recurring gains or losses. With MarketXLS, you can easily pull this value into Excel, allowing for deeper financial analysis and comparisons over time.

Understanding Normalized Income (Historical)

• Normalized income removes the impact of unusual or one-time events (e.g., restructuring costs, major acquisitions).
• Investors and analysts use this figure to assess a company’s ongoing earnings potential.
• Using the Normalized Income (Historical) formula in Excel helps you quickly compare earnings across multiple periods.

? Pro Tip: Normalized income is particularly useful when you suspect that a single year’s results may be distorted by extraordinary items.

Syntax and Parameters

Use the hf_Normalized_Income function in your Excel spreadsheet to retrieve normalized income data for a given symbol and year (with optional quarter and TTM arguments).

=hf_Normalized_Income(Symbol, Year, [Quarter], [TTM])

?? Note: If the symbol is invalid or you do not have a valid subscription plan, the function may return "NA".

Return Value

• Returns a numeric value representing the normalized income for the specified period.
• If the underlying data is unavailable or an error occurs, the function returns "NA".

Examples and Usage

Below are some practical examples showing how to use various parameter inputs:

1. Retrieve normalized income for Microsoft in 2022:

   =hf_Normalized_Income("MSFT", 2022)

2. Retrieve normalized income for Microsoft in 2022, Quarter 2:

   =hf_Normalized_Income("MSFT", 2022, 2)

3. Retrieve normalized income for Microsoft in 2022, Quarter 3, Trailing 12 Months:

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

4. Retrieve normalized income for Microsoft for the last quarter (lq):

   =hf_Normalized_Income("MSFT", "lq")

5. Retrieve normalized income for Microsoft for the last quarter minus one (lq-1):

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

6. Retrieve normalized income for Microsoft for the last year (ly):

   =hf_Normalized_Income("MSFT", "ly")

? Pro Tip: You can use “ly-1” or “lq-1” to go back multiple years or quarters. For instance, "ly-1" retrieves the value for one year before the last year.

Special Cases and Limitations

• The function retrieves data from MarketXLS servers; heavy usage might affect performance.
• When using relative parameters like “ly” (last year) or “lq” (last quarter), the function internally calculates the correct period based on the most recent data available.
• Ensure your Excel environment is configured to enable MarketXLS functions and that your subscription plan supports the data you’re trying to access.

Common Questions

1. Why do I get “NA” instead of a value?

   • The symbol may be invalid or not supported.
   • Your subscription may not include historical fundamentals.
   • Data might be temporarily unavailable.

2. How does this differ from revenue or net income?

   • Normalized income excludes one-time items to focus on typical recurring profitability.
   • Revenue tracks total sales without deducting costs, while net income is total profit but can include non-recurring items.

3. Can I reference cells and date functions?

   • Yes, simply use cell references or date functions for the Year parameter if needed. For instance:

     =hf_Normalized_Income(A2, A3)

4. Does the function work for all international stocks?

   • MarketXLS maintains extensive coverage, but some international symbols may not be supported. Check MarketXLS documentation for details.

?? Note: For large-scale or frequent data calls, consider using caching or limiting recalculations in Excel to improve performance.