Other Receivable (Historical)
Returns other receivables from historical balance sheets that are not classified as accounts receivable or loans receivable.
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
- May include tax receivables, insurance claims, employee advances
- Category varies by company and industry
Examples
=hf_Other_receivable("AAPL", 2023, 4)=hf_Other_receivable("MSFT", "ly", 2)=hf_Other_receivable(A1, B1, C1)When to Use
- Detailed balance sheet analysis
- Understanding receivable composition
- Identifying unusual receivable items
- Financial statement analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need accounts receivable | hf_Accounts_receivable() |
| Need loans receivable | hf_Loans_receivable() |
| Need total current assets | hf_Total_current_assets() |
Common Issues & FAQ
Q: What's included in other receivables? A: Typically includes tax refunds due, insurance claims, employee advances, and other non-trade amounts owed to the company.
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?