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)
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
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: What's a good current ratio? A: Typically 1.5-3.0, but varies by industry. Retail and manufacturing need higher ratios. Tech companies often operate with lower ratios.
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?