Accounts Receivable (Historical)
Returns the accounts receivable balance from historical balance sheets, representing money owed to the company by customers.
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
- Accounts receivable is a current asset on the balance sheet
- Represents credit sales not yet collected
- Important for working capital and liquidity analysis
Examples
=hf_Accounts_receivable("AAPL", 2023, 4)=hf_Accounts_receivable("MSFT", "ly", 2)=hf_Accounts_receivable("GOOGL", 2022)=hf_Accounts_receivable(A1, B1, C1)When to Use
- Working capital analysis
- Liquidity assessment
- Cash conversion cycle calculation
- Credit policy analysis
- Historical trend analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need receivables turnover | hf_Receivables_turnover() |
| Need current AR | AccountsReceivable() |
| Need total current assets | hf_Total_current_assets() |
Common Issues & FAQ
Q: Why does AR vary significantly by quarter? A: Seasonal businesses may have varying AR levels. Also, collection timing affects quarter-end balances.
Q: How do I calculate Days Sales Outstanding? A: DSO = (Accounts Receivable / Revenue) * 365
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?