Trade And Non Trade Payables (Historical)

Returns the historical total payables balance - amounts owed by the company to suppliers (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, WMT)
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

Payable Components

Type Description
Trade Payables Amounts owed to suppliers for goods/services
Non-Trade Payables Interest, taxes, other amounts owed
Accrued Expenses May be included (varies by company)

Notes

  • Higher payables = free financing from suppliers
  • Compare to COGS for days payables outstanding (DPO)
  • Apple has very high payables (supplier leverage)
  • Seasonality affects payable levels

Examples

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

When to Use

  • Days payables outstanding (DPO) calculation
  • Working capital analysis
  • Cash conversion cycle analysis
  • Supplier payment analysis
  • Liquidity assessment

When NOT to Use

Scenario Use Instead
Need total current liabilities hf_Current_Liabilities()
Need accounts receivable hf_Trade_and_Non_Trade_Receivables()
Need total liabilities hf_Total_Liabilities()
Need cash hf_Cash_and_Equivalents()

Common Issues & FAQ

Q: How do I calculate Days Payables Outstanding (DPO)? A: DPO = (Payables / COGS) x 365: =(hf_Trade_and_Non_Trade_Payables("AAPL","lq") / hf_Cost_of_Revenue("AAPL","lq",,"TTM")) * 365

Q: Why are Apple's payables so high? A: Apple has significant supplier leverage and extends payment terms. This is free financing that improves their cash position.

Q: How do I calculate Cash Conversion Cycle? A: CCC = DSO + DIO - DPO. Lower (even negative) is better. Apple's strong supplier terms give them a negative CCC.

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

Related Functions