Working Capital (Historical)
Current assets minus current liabilities.
Syntax
=hf_Working_Capital(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Quarter (1-4)
TTMstring
TTM for trailing twelve months
Returns
number
Working capital in USD
Examples
=hf_Working_Capital("AAPL", 2023, 4)=hf_Working_Capital("MSFT", "ly")When to Use
- Liquidity analysis
- Short-term financial health
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Current ratio | current_ratio() |
Common Issues & FAQ
Why is working capital negative?
Some companies like Apple operate with negative working capital due to supplier payment terms.
Excel Templates Using Working Capital (Historical)
These ready-made MarketXLS templates call hf_Working_Capital() 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:
- Working Capital As A Percentage Of Equity (Historical)
- Working Capital As Percentage Of Price (Historical)
- Working Capital Per Share (Historical)
- Accounts Receivable (Historical)
- Accrued Expenses (Historical)
- Accrued Liabilities (Historical)
- Accumulated Depreciation And Depletion (Historical)
- Accumulated Other Comprehensive Income (Historical)
Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS
Get started today
▶
How does MarketXLS work?