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

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

Q: Higher or lower is better? A: Higher is generally better as it indicates faster collection of receivables.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Receivable Turnover (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions