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)
Syntax
=hf_Current_Liabilities(Symbol, Year, [Quarter], [TTM])Parameters
Stock ticker symbol
Fiscal year or period code (e.g., 2023, lq, ly)
Calendar quarter (1-4)
Set to 'TTM' for trailing twelve months
Returns
Total current liabilities value
Examples
=hf_Current_Liabilities("AAPL", 2023, 4)=hf_Current_Liabilities("MSFT", "ly")=hf_Current_Liabilities("AMZN", 2023, , "TTM")=hf_Current_Liabilities(A1, B1, C1)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
How do I calculate current ratio?
Current Ratio = Current Assets / Current Liabilities: =hf_Current_Assets("AAPL","lq") / hf_Current_Liabilities("AAPL","lq")
How do I calculate working capital?
Working Capital = Current Assets - Current Liabilities: =hf_Current_Assets("AAPL","lq") - hf_Current_Liabilities("AAPL","lq")
Why does Apple have negative working capital?
Apple's current liabilities exceed current assets due to large payables. They manage suppliers effectively, using their cash for buybacks while delaying payments.
Excel Templates Using Current Liabilities (Historical)
These ready-made MarketXLS templates call hf_Current_Liabilities() in their worksheet formulas. Open one to see the function working inside a complete model.
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