Current Liabilities (Historical)

Returns the historical current liabilities - obligations due within one year. This is essential for liquidity analysis and working capital calculation.

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

Current Liability Components

Liability Description
Accounts Payable Trade payables to suppliers
Short-term Debt Debt due within 12 months
Accrued Expenses Wages, taxes, interest owed
Deferred Revenue Prepaid customer deposits
Current Portion LTD Long-term debt due within year

Notes

  • Obligations due within 12 months
  • Denominator for current ratio and quick ratio
  • Working Capital = Current Assets - Current Liabilities
  • Apple has high current liabilities (payables)

Examples

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

When to Use

  • Current ratio calculation
  • Quick ratio calculation
  • Working capital analysis
  • Short-term liquidity assessment
  • Cash conversion cycle analysis

When NOT to Use

Scenario Use Instead
Need total liabilities hf_Total_Liabilities()
Need long-term liabilities hf_Liabilities_Non_Current()
Need payables only hf_Trade_and_Non_Trade_Payables()
Need total debt hf_Total_Debt()

Common Issues & FAQ

Q: How do I calculate current ratio? A: Current Ratio = Current Assets / Current Liabilities: =hf_Current_Assets("AAPL","lq") / hf_Current_Liabilities("AAPL","lq")

Q: How do I calculate working capital? A: Working Capital = Current Assets - Current Liabilities: =hf_Current_Assets("AAPL","lq") - hf_Current_Liabilities("AAPL","lq")

Q: Why does Apple have negative working capital? A: Apple's current liabilities exceed current assets due to large payables. They manage suppliers effectively, using their cash for buybacks while delaying payments.

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

Related Functions