Retrieve “Other Non-Current Assets” for Deeper Fundamental Analysis

The hf_Other_non-current_assets function in MarketXLS allows you to quickly pull a company’s “Other Non-Current Assets” from its balance sheet into Excel. This line item can include intangible assets, long-term investments, deferred charges, and other assets not expected to be liquidated within a year. Tracking it helps you gain better insight into a company’s long-term asset composition and overall financial strength. With this function, you can specify specific years, quarters, or even retrieve trailing 12 months (TTM) data for more dynamic analysis.

Why Use This Function?

• Leverage Fundamental Analysis: “Other Non-Current Assets” can offer clues about intangibles, deferred costs, and other long-term resources that might not be captured in more standard asset categories.
• Flexible Date Ranges: Retrieve data for a specific year, a given quarter, or opt for TTM data to see the most recent 12-month figure.
• Quick Comparisons: Easily compare multiple companies side by side within Excel by entering separate function calls for each.
• Automated Updates: Once the formula is in place and you refresh data, MarketXLS can automatically pull in the latest values from our database—no manual searching required.
• Integrate in Dashboards: Combine with other MarketXLS functions to build more comprehensive dashboards tracking a broad set of fundamentals.

How to Use in Excel

Use the function in a cell as follows:

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

• Symbol: The company’s ticker symbol.
• Year: A four-digit year (e.g., 2022).
• Quarter (optional): A number between 1 and 4, representing Q1 to Q4. This defaults to “1” if left blank.
• TTM (optional): Enter “TTM” (or leave blank) to indicate trailing 12-month data. If “TTM” is specified, the function returns rolling 12-month data, and the Quarter parameter may or may not be used depending on the underlying data availability.

Once entered, the function will retrieve the chosen period’s “Other Non-Current Assets” directly into your Excel spreadsheet. If the data isn’t available for that symbol and period, the function returns “NA”.

Parameters Explained

Example Usage

Basic Examples

1. Yearly Data for 2022:
   =hf_Other_non-current_assets("AAPL", 2022)
   This retrieves Apple’s “Other Non-Current Assets” for fiscal (or calendar, as applicable) year 2022.

2. Quarterly Data for Q3 2021:
   =hf_Other_non-current_assets("MSFT", 2021, 3)
   Pulls Microsoft’s “Other Non-Current Assets” for third quarter of 2021.

3. Trailing 12 Months (TTM) for Q1 2023:
   =hf_Other_non-current_assets("TSLA", 2023, 1, "TTM")
   Fetches Tesla’s rolling 12-month figure as of roughly Q1 2023, depending on most recently available data.

Advanced Scenarios

• Comparing Quarters Year Over Year:
By placing multiple formulas side by side, you can compare "Other Non-Current Assets" for Q1 2022 vs. Q1 2023 to see how a company’s long-term assets have changed.
Example:
=hf_Other_non-current_assets("AAPL", 2022, 1) in one cell
=hf_Other_non-current_assets("AAPL", 2023, 1) in another cell

• Rolling Trend Analysis:
Use consecutive TTM calls to track how “Other Non-Current Assets” changed each quarter for a rolling 12-month perspective.
Example:
=hf_Other_non-current_assets("AMZN", 2022, 4, "TTM")
=hf_Other_non-current_assets("AMZN", 2023, 1, "TTM")

• Integration with Other Functions:
Combine hf_Other_non-current_assets with MarketXLS ratio functions like hf_ROA or hf_ROE to see how intangible or deferred assets might be affecting a company’s performance metrics.

Common Questions and Troubleshooting

• “I get ‘NA’ instead of a value.”

• Confirm the ticker symbol is spelled correctly and is supported.
• Check if the selected year or quarter is valid. Data may not be available for very recent or very old dates.
• If using TTM, ensure the company has enough reported data in the trailing 12-month window.

• “How do I handle partial-year data if the year isn’t finished?”

• If the company has reported partial-year results, specifying a quarter can help. Alternatively, TTM might give the rolling last 12 months if those results are posted.

• “Does this function support industries outside the US?”

• The function primarily focuses on US equity coverage. Some non-US symbols may be available, but coverage can vary based on your plan.

• “Do I need to refresh anything?”

• MarketXLS updates can be set to refresh automatically or on-demand. Ensure your MarketXLS add-in settings are correct to pull the latest data.

By harnessing the hf_Other_non-current_assets function in MarketXLS, you can deepen your fundamental analysis by tracking intangible or other long-term asset entries for your favored stocks. It provides a comprehensive snapshot needed for more informed investment decisions and portfolio reviews—all seamlessly inside Excel.