Receivable Turnover (Historical)
Returns how many times accounts receivable are collected during a period. Higher values indicate faster collection.
Formula
Receivable Turnover = Net Credit Sales / Average Accounts Receivable
Parameters
| Parameter | Required | Description |
|---|---|---|
| Symbol | Yes | Stock ticker symbol |
| Year | Yes | Fiscal year or period code |
| Quarter | No | Calendar quarter 1-4 (default: 1) |
| TTM | No | Enter "TTM" for trailing twelve months |
Syntax
=hf_Receivable_turnover(Symbol, Year, [Quarter], [TTM])Parameters
symbolstringRequired
Stock ticker symbol
yearstringRequired
Fiscal year or period code
quarterstring
Calendar quarter (1-4)
TTMstring
Use TTM for trailing twelve months
Returns
number
Receivable turnover ratio
Examples
=hf_Receivable_turnover("AAPL", 2023, 4)=hf_Receivable_turnover("MSFT", 2022, , "TTM")When to Use
- Analyzing collection efficiency
- Comparing credit management across companies
- Cash flow analysis
When NOT to Use
| Scenario | Use Instead |
|---|---|
| Need receivables as % of revenue | hf_Receivables_as_a_percentage_of_revenue() |
| Need inventory turnover | hf_Inventory_turnover() |
Common Issues & FAQ
Higher or lower is better?
Higher is generally better as it indicates faster collection of receivables.
Related Formulas
More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:
- Report Period (Historical)
- Repurchase Of Capital Stock (Historical)
- Research & Development Expense As Percentage Of Revenue (Historical)
- Research And Development Expense As Percentage Of Revenue (Historical)
- Restricted Cash (Historical)
- Retun On Invested Capital (ROIC - Historical)
- Return Equity Indicator (Historical)
- Return On Average Assets (ROA - Historical)
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?