MarketXLS

Receivables As A Percentage Of Revenue (Historical)

Returns accounts receivable as a percentage of total revenue. This metric shows how much revenue is tied up in receivables.

Supported Symbol Formats

Type Format Example
US Stocks SYMBOL AAPL, MSFT

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol
Year Yes Fiscal year (2020, 2021, etc.) or period code (lq, ly)
Quarter No Calendar quarter 1-4 (default: 1)
TTM No Enter "TTM" for trailing twelve months

Interpretation

Value Meaning
Low Fast collection, efficient credit management
High Slow collection, potential credit risk

Syntax

=hf_Receivables_as_a_percentage_of_revenue(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

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

Receivables as percentage of revenue

Examples

=hf_Receivables_as_a_percentage_of_revenue("AAPL", 2023, 4)
Q4 2023 receivables/revenue %
=hf_Receivables_as_a_percentage_of_revenue("MSFT", 2022, , "TTM")
2022 TTM receivables/revenue %
=hf_Receivables_as_a_percentage_of_revenue("GOOGL", "ly")
Last year receivables/revenue %

When to Use

  • Analyzing collection efficiency trends
  • Comparing working capital management
  • Assessing credit risk
  • Cash conversion cycle analysis

When NOT to Use

Scenario Use Instead
Need receivable turnover hf_Receivable_turnover()
Need cash to revenue hf_Cash_as_a_percentage_of_revenue()
Need sales per dollar receivables hf_Sales_per_dollar_receivables()

Common Issues & FAQ

What is a good receivables to revenue ratio?

Lower is generally better. Compare to industry peers for context.

Why is this high for B2B companies?

B2B companies often have longer payment terms than B2C companies.

Related Formulas

More MarketXLS Historical Fundamentals formulas you can use in the same worksheet:

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 Receivables As A Percentage Of Revenue (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions