Cash And Equivalents (Historical)
Returns the historical cash and cash equivalents balance from the balance sheet - highly liquid assets that can be converted to cash immediately.
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 |
What's Included
| Item | Description |
|---|---|
| Cash | Currency on hand and demand deposits |
| Cash Equivalents | Money market funds, T-bills < 90 days |
| Short-term Investments | May be included (varies by company) |
Notes
- Most liquid asset on balance sheet
- Balance sheet item (point-in-time)
- Companies may also hold marketable securities separately
- For international companies, use USD version for comparison
Syntax
=hf_Cash_and_Equivalents(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
Cash and cash equivalents balance
Examples
=hf_Cash_and_Equivalents("AAPL", 2023, 4)=hf_Cash_and_Equivalents("MSFT", "ly")=hf_Cash_and_Equivalents("GOOGL", 2023, , "TTM")=hf_Cash_and_Equivalents(A1, B1, C1)When to Use
- Liquidity analysis
- Cash position monitoring
- Quick ratio calculation
- M&A capacity assessment
- Financial flexibility analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need USD-converted cash | hf_Cash_and_Equivalents_USD() |
| Need total current assets | hf_Current_Assets() |
| Need operating cash flow | hf_Net_Cash_Flow_from_Operations() |
| Need net cash change | hf_Net_Cash_Flow_Change_in_Cash_and_Cash_Equivalents() |
Common Issues & FAQ
Why is Apple's cash lower than expected?
Apple holds much of its liquidity in marketable securities, not pure cash. Check both cash and short-term investments for full picture.
How do I calculate quick ratio?
Quick Ratio = (Cash + Receivables) / Current Liabilities: =(hf_Cash_and_Equivalents("AAPL","lq") + hf_Trade_and_Non_Trade_Receivables("AAPL","lq")) / hf_Current_Liabilities("AAPL","lq")
Cash decreased but the company was profitable?
Common reasons: large CapEx, acquisitions, share buybacks, debt repayment, or working capital build. Check the cash flow statement sections.
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