Restricted Cash (Historical)
Returns the amount of cash that is restricted and not available for general corporate use from historical balance sheets.
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Calendar quarter 1-4 |
| TTM | No | Set to "TTM" for trailing twelve months |
Notes
- Restricted cash is typically held as collateral or for specific purposes
- May include customer deposits, escrow amounts, or regulatory requirements
Examples
=hf_Restricted_cash("AAPL", 2023, 4)=hf_Restricted_cash("TSLA", "ly", 2)=hf_Restricted_cash(A1, B1, C1)When to Use
- Analyzing liquidity constraints
- Understanding cash availability
- Balance sheet analysis
- Collateral requirements review
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need total cash | hf_Cash_and_equivalents() |
| Need free cash flow | hf_Free_cash_flow() |
| Need current cash | Cash() |
Common Issues & FAQ
Q: Why is restricted cash 0 or NA? A: Many companies don't have significant restricted cash. It depends on business model and industry.
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?