Current Assets (Historical)
Returns the historical current assets - assets expected to be converted to cash or used within one year. This is a key component of working capital and liquidity analysis.
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 Asset Components
| Asset | Description |
|---|---|
| Cash & Equivalents | Cash and short-term investments |
| Accounts Receivable | Money owed by customers |
| Inventory | Goods held for sale |
| Prepaid Expenses | Advance payments |
| Other Current Assets | Miscellaneous liquid assets |
Notes
- Assets convertible to cash within 12 months
- Used for current ratio: Current Assets / Current Liabilities
- Higher is generally better for liquidity
- Industry dependent (retail has more inventory)
Syntax
=hf_Current_Assets(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 assets value
Examples
=hf_Current_Assets("AAPL", 2023, 4)=hf_Current_Assets("MSFT", "ly")=hf_Current_Assets("AMZN", 2023, , "TTM")=hf_Current_Assets(A1, B1, C1)When to Use
- Current ratio calculation
- Working capital analysis
- Liquidity assessment
- Short-term financial health
- Cash conversion cycle analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total assets | hf_Total_Assets() |
| Need non-current assets | hf_Assets_Non_Current() |
| Need just cash | hf_Cash_and_Equivalents() |
| Need inventory only | hf_Inventory() |
| Need receivables | hf_Trade_and_Non_Trade_Receivables() |
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")
What's a good current ratio?
Typically 1.5-3.0, but varies by industry. Retail and manufacturing need higher ratios. Tech companies often operate with lower ratios.
Excel Templates Using Current Assets (Historical)
These ready-made MarketXLS templates call hf_Current_Assets() 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