Total Liabilities (Historical)

Returns the historical total liabilities from the balance sheet - the sum of all current and non-current obligations owed by the company.

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

Liability Components

Category Examples
Current Liabilities Payables, short-term debt, accruals
Non-Current Liabilities Long-term debt, deferred taxes, pensions

Notes

  • Total Liabilities + Equity = Total Assets
  • Includes both interest-bearing and operating liabilities
  • Banks have very high liabilities (deposits)
  • Key for leverage and solvency analysis

Examples

=hf_Total_Liabilities("AAPL", 2023, 4)
Q4 2023 total liabilities
=hf_Total_Liabilities("MSFT", "ly")
Last fiscal year
=hf_Total_Liabilities("JPM", 2023, , "TTM")
Trailing period
=hf_Total_Liabilities(A1, B1, C1)
From cell references

When to Use

  • Calculating stockholders' equity
  • Debt-to-equity ratio
  • Asset coverage analysis
  • Leverage assessment
  • Solvency analysis

When NOT to Use

Scenario Use Instead
Need current liabilities hf_Current_Liabilities()
Need non-current liabilities hf_Liabilities_Non_Current()
Need just debt hf_Total_Debt()
Need total assets hf_Total_Assets()

Common Issues & FAQ

Q: How do I calculate equity from liabilities? A: Equity = Assets - Liabilities: =hf_Total_Assets("AAPL","lq") - hf_Total_Liabilities("AAPL","lq")

Q: How do I calculate debt-to-equity? A: D/E = Total Liabilities / Equity, or more specifically: =hf_Total_Debt("AAPL","lq") / (hf_Total_Assets("AAPL","lq") - hf_Total_Liabilities("AAPL","lq"))

Q: Why are bank liabilities so high? A: Bank deposits are liabilities. A bank with $3T in assets will have most of that funded by deposit liabilities, not equity.

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 Total Liabilities (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions