Liabilities Non Current (Historical) Formula in Excel

Understanding Liabilities Non Current (Historical)

Noncurrent liabilities, also known as long-term liabilities, are debts or obligations that are due beyond one year. With the Liabilities Non Current (Historical) formula in Excel using MarketXLS, you can quickly retrieve historical fundamental data for a company's long-term liabilities, helping you:

  • Evaluate a company’s financial health and leverage.
  • Analyze trends in the long-term debt structure over specific reporting periods.
  • Make informed decisions about investments or corporate strategies.

Syntax and Parameters

Use the formula in your Excel worksheet to pull historical data:

=hf_Liabilities_Non_Current(Symbol, year, [quarter], [TTM])
Parameter Description Required Example
Symbol The ticker symbol used in the market. Supports many formats: regular equities (e.g., "MSFT"), indices (e.g., "^SPX"), options (e.g., "@MSFT 110122C00020000"), and crypto (e.g., "BTCUSD:DEFAULT"). Yes "MSFT"
year The year you want data for. You can input a specific year (e.g., "2022") or a special string like "ly" (last year), "lq" (last quarter), or "lt" (last 12 months). You can also reference a cell that contains a date or provide a direct date, e.g., "2024-03-15", and the function will interpret that year. Yes "2022" or "ly" or "2024-03-15"
quarter The quarter of the year (1 to 4). Defaults to "1" if not specified. You may also use "lq" (last quarter), "lq-1" (previous quarter), and so forth. No "2"
TTM Set this parameter to "TTM" to retrieve trailing twelve months data based on the specified year and quarter. Defaults to an empty string if not used. No "TTM"

?? Note: If the symbol is invalid or your data plan does not support historical fundamentals, this function may return "NA".

Return Value:
• Returns a numeric value representing the noncurrent (long-term) liabilities for the specified period.
• If an error or data unavailability occurs, the function returns "NA".

Examples and Usage

Below are common ways to use the Liabilities Non Current (Historical) formula in Excel:

  1. Retrieve noncurrent liabilities for a specific year:
    =hf_Liabilities_Non_Current("MSFT", 2022)
  2. Retrieve noncurrent liabilities for a specific year and quarter:
    =hf_Liabilities_Non_Current("MSFT", 2022, 2)
  3. Retrieve trailing twelve months (TTM) data:
    =hf_Liabilities_Non_Current("MSFT", 2022, 3, "TTM")
  4. Use special strings to fetch the last quarter or last year:
    • Last quarter (lq):
      =hf_Liabilities_Non_Current("MSFT", "lq")
    • Last year (ly):
      =hf_Liabilities_Non_Current("MSFT", "ly")
  5. Reference a date in a cell (e.g., cell A1 contains "2024-03-15"):
    =hf_Liabilities_Non_Current("MSFT", A1)

? Pro Tip: Combine this function with other historical metrics—like revenue, cost of revenue, and gross profit—to gain deeper insight into a company’s overall financial position.

Common Questions

Why am I getting "NA"?

  • You may be trying to retrieve data for a symbol or date range not supported by your plan.
  • Verify that your subscription includes historical fundamental data.
  • Check that the Symbol is valid and properly formatted.

Can I use this formula for real-time analysis?

  • This formula is designed for historical fundamentals rather than live data.
  • To get real-time insights on a symbol, explore other MarketXLS real-time functions.

How can I improve performance with multiple calls?

  • If you need data for multiple symbols, structure your spreadsheet so that repeated parameters (like year or TTM) are referenced from cells, reducing repeated recalculations.

Are date inputs directly recognized by the function?

  • Yes, you can reference a cell containing a date or use direct date strings ("yyyy-mm-dd"). The function will interpret the year accordingly.

Use the Liabilities Non Current (Historical) formula in Excel with MarketXLS to profile a company’s debt structure and spot trends in long-term liabilities over time. This information is crucial for financial analysis and strategic planning.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Liabilities Non Current (Historical) and Other Financial Formulas
▶
How does MarketXLS work?