MarketXLS

Liabilities Non Current (Historical)

Returns the historical non-current liabilities - obligations due after one year. This includes long-term debt, deferred taxes, pension obligations, and other long-term commitments.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol (e.g., AAPL, MSFT)
Year Yes Fiscal year (2023) or period code (lq, ly)
Quarter No Quarter number 1-4 (default: 1)
TTM No Set to "TTM" for trailing twelve months

Non-Current Liability Components

Liability Description
Long-term Debt Bonds, term loans due after 1 year
Deferred Taxes Tax obligations deferred to future
Pension Liabilities Defined benefit plan obligations
Lease Liabilities Long-term operating/finance leases
Other Long-term Deferred revenue, other obligations

Notes

  • Obligations due after 12 months
  • Total Liabilities = Current + Non-Current
  • Often dominated by long-term debt
  • Includes ASC 842 lease liabilities

Syntax

=hf_Liabilities_Non_Current(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (e.g., 2023, lq, ly)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Total non-current (long-term) liabilities value

Examples

=hf_Liabilities_Non_Current("AAPL", 2023, 4)
Q4 2023 long-term liabilities
=hf_Liabilities_Non_Current("MSFT", "ly")
Last fiscal year
=hf_Liabilities_Non_Current("T", 2023, , "TTM")
Trailing period
=hf_Liabilities_Non_Current(A1, B1, C1)
From cell references

When to Use

  • Long-term solvency analysis
  • Capital structure analysis
  • Debt maturity analysis
  • Leverage assessment
  • Pension and lease liability review

When NOT to Use

Scenario Use Instead
Need total liabilities hf_Total_Liabilities()
Need current liabilities hf_Current_Liabilities()
Need just debt hf_Total_Debt()
Need total assets hf_Total_Assets()

Common Issues & FAQ

How do I calculate total liabilities from this?

Total Liabilities = Current + Non-Current: =hf_Current_Liabilities("AAPL","lq") + hf_Liabilities_Non_Current("AAPL","lq") should equal hf_Total_Liabilities("AAPL","lq")

Is this the same as total debt?

No. Non-current liabilities include non-debt items like deferred taxes and pension obligations. hf_Total_Debt() is more specific to interest-bearing debt.

Why did this increase after 2019?

ASC 842 lease accounting standard (effective 2019) required companies to recognize operating leases as liabilities, significantly increasing reported non-current liabilities.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

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?

Related Functions