MarketXLS

Trade And Non Trade Receivables (Historical)

Returns the historical total receivables balance - amounts owed to the company by customers (trade) and others (non-trade). This is a key component of working capital and the cash conversion cycle.

Parameters

Parameter Required Description
Symbol Yes Stock ticker symbol (e.g., AAPL, MSFT)
Year Yes Fiscal year (2023) or period code (lq, ly)
Quarter No Quarter number 1-4 (default: 1)
TTM No Set to "TTM" for trailing twelve months

Receivable Components

Type Description
Trade Receivables Amounts owed from normal business sales
Non-Trade Receivables Interest, tax refunds, other amounts due
Allowance for Bad Debt Typically netted against gross receivables

Notes

  • Higher receivables tie up working capital
  • Compare to revenue for days sales outstanding (DSO)
  • Rapid growth may indicate collection issues
  • Seasonality affects receivable levels

Syntax

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

Parameters

symbolstringRequired

Stock ticker symbol

yearstringRequired

Fiscal year or period code (e.g., 2023, lq, ly)

quarterstring

Calendar quarter (1-4)

TTMstring

Set to 'TTM' for trailing twelve months

Returns

number

Total receivables balance

Examples

=hf_Trade_and_Non_Trade_Receivables("AAPL", 2023, 4)
Q4 2023 receivables
=hf_Trade_and_Non_Trade_Receivables("MSFT", "ly")
Last fiscal year
=hf_Trade_and_Non_Trade_Receivables("WMT", 2023, , "TTM")
Trailing period
=hf_Trade_and_Non_Trade_Receivables(A1, B1, C1)
From cell references

When to Use

  • Days sales outstanding (DSO) calculation
  • Working capital analysis
  • Cash conversion cycle analysis
  • Credit policy assessment
  • Quick ratio calculation

When NOT to Use

Scenario Use Instead
Need total current assets hf_Current_Assets()
Need accounts payable hf_Trade_and_Non_Trade_Payables()
Need cash balance hf_Cash_and_Equivalents()
Need inventory hf_Inventory()

Common Issues & FAQ

How do I calculate Days Sales Outstanding (DSO)?

DSO = (Receivables / Revenue) x 365: =(hf_Trade_and_Non_Trade_Receivables("AAPL","lq") / hf_Revenue("AAPL","lq",,"TTM")) * 365

Why might receivables spike?

Revenue growth, extended payment terms, customer concentration, or collection problems. Compare receivables growth to revenue growth.

What's a good receivables level?

Depends on industry and payment terms. Compare DSO to industry averages. Lower DSO means faster collection.

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 Trade And Non Trade Receivables (Historical) and Other Financial Formulas
▶
How does MarketXLS work?

Related Functions