Retrieve Other Non-Cash Items for a Company

The hf_Other_non-cash_items function in MarketXLS helps you quickly access “Other Non-Cash Items” from a company’s financial statements directly in Excel. It’s ideal for comparing non-cash charges (like depreciation or special write-downs) and analyzing how these items affect profitability over different periods—annual, quarterly, or trailing twelve months (TTM).

Why Use This Function?

• Better insight into non-cash charges that can impact earnings quality.
• Compare how “Other Non-Cash Items” change across quarterly or yearly periods.
• Evaluate how these items influence overall financial health and cash flow.
• Useful for advanced valuation models and more precise financial analysis.
• Helpful for detecting unusual, one-off charges or recurring non-cash trends.

How to Use in Excel

=hf_Other_non-cash_items(Symbol, Year, [Quarter], [TTM])

1. Select a cell in Excel where you want the reported “Other Non-Cash Items” value to appear.
2. Type the function =hf_Other_non-cash_items( … ), entering the appropriate parameters.
3. Press Enter to retrieve the result.

Depending on your inputs, the function will return:
• Annual data (if only Year is specified).
• Quarterly data (if Year and Quarter are specified).
• TTM data if you set the TTM parameter (when supported by the data source).

If the value is not found or supported for the chosen symbol or plan tier, the function typically returns “NA.”

Parameters Explained

• Special Year Strings:

• "LY" (Last Year) can also be extended with "-1" or "-2" to go back multiple years.
• "LQ" (Last Quarter) and "LT" (Last TTM) can also be used similarly, e.g., "LQ-1," "LT-2".

Example Usage

Basic Examples

1. Annual Data for the Latest Completed Year
   =hf_Other_non-cash_items("AAPL", 2022)
   • Returns Apple’s “Other Non-Cash Items” figure for the fiscal year 2022.
   • If 2022 data is not yet fully reported, it may return “NA.”

2. Quarterly Data
   =hf_Other_non-cash_items("TSLA", 2021, 3)
   • Returns Tesla’s “Other Non-Cash Items” for the third quarter of 2021.

3. Trailing Twelve Months
   =hf_Other_non-cash_items("AMZN", 2021, 3, "TTM")
   • Attempts to retrieve TTM data up to Q3 2021 for Amazon, if available.

Advanced Scenarios

1. Last Year (Automatic)
   =hf_Other_non-cash_items("MSFT", "LY")
   • Dynamically pulls data from Microsoft’s most recently completed fiscal year.

2. Multiple Quarters Back
   =hf_Other_non-cash_items("GOOGL", "LQ-2")
   • Retrieves Google’s “Other Non-Cash Items” from two quarters prior to the last reported quarter (no separate quarter parameter needed here).

3. Integrating Data for Quick Analysis
   • Combine with SUM or AVERAGE to calculate total or average non-cash items across multiple periods.
   • Reference dynamic cells that store Year or Quarter for quick toggling of financial periods.

Common Questions and Troubleshooting

• What if the function returns “NA” unexpectedly?

• This can happen if the data is unavailable for the selected Symbol, Year, or Quarter, or if you are not on a plan that supports the request.

• How do I ensure I’m getting the correct quarter data?

• Validate that your Quarter parameter is an integer between 1 and 4. If your entered Quarter extends beyond reported periods, the function might default or return “NA.”

• Can I get TTM data for every single quarter?

• The function tries to retrieve TTM data if you set the TTM parameter, but some symbols or historical quarters may not have TTM data. In such cases, you may receive “NA.”

• What about older years or partial data coverage?

• If data for those periods is not available or incomplete, the function returns “NA.”

Use hf_Other_non-cash_items to stay informed about unusual or recurring non-cash charges and refine your evaluations of company performance directly in Excel. By combining annual, quarterly, or TTM views, you’ll gain deeper insight into how non-cash items shape a company’s profitability and cash flow—without ever leaving your spreadsheet.