Financial Data API

Working Capital Ratios API

Retrieve working capital efficiency ratios for any publicly traded company. This endpoint returns turnover metrics and the cash conversion cycle that measure how effectively a company manages its receivables, inventory, and payables to fund day-to-day operations.

Working capital ratios reveal the operational efficiency of a business. A company that collects receivables quickly, turns inventory efficiently, and manages payable terms strategically will have a shorter (or even negative) cash conversion cycle, meaning it needs less capital tied up in operations. Companies like Apple famously operate with negative cash conversion cycles, effectively funding operations with supplier capital. These metrics are especially valuable for comparing operational efficiency across competitors and identifying companies that generate cash more efficiently from their asset base.

Data is available for both annual and quarterly periods, with up to 250 historical periods per request.

GEThttps://api.roic.ai/v2/fundamental/ratios/working-capital/{identifier}

Parameters

Path Parameters

identifierstringrequired

Company identifier — supports ticker symbol (e.g., `AAPL`), CIK, CUSIP, or ISIN.

Example: AAPL

Query Parameters

apikeystringrequired

Your API key for authentication.

periodstringoptional

Reporting period for financial data.

Default: annualValues: annual, quarterly
limitnumberoptional

Maximum number of periods to return.

Default: 10Example: 10
fiscal_year_startnumberoptional

Filter results starting from this fiscal year.

Example: 2020
fiscal_year_endnumberoptional

Filter results ending at this fiscal year.

Example: 2024
date_startstringoptional

Filter results starting from this date (YYYY-MM-DD format).

Example: 2020-01-01
date_endstringoptional

Filter results ending at this date (YYYY-MM-DD format).

Example: 2024-12-31
orderstringoptional

Sort order for time-series data.

Default: DESCValues: ASC, DESC
formatstringoptional

Response format. Use `json` for JSON (default) or `excel` for tab-separated values compatible with Google Sheets and Excel.

Default: jsonValues: json, excel

Code Examples

curl "https://api.roic.ai/v2/fundamental/ratios/working-capital/AAPL?apikey=YOUR_API_KEY"

Response

Response200 OK
[
  {
    "ticker": "AAPL",
    "date": "2025-09-30",
    "period": "annual",
    "period_label": "2025",
    "fiscal_year": "2025",
    "currency": "USD",
    "acct_rcv_turn": 11.372538838864825,
    "acct_rcv_days": 32.09485631762708,
    "invent_turn": 33.98338972623808,
    "invent_days": 10.740541274438813,
    "accounts_payable_turnover": 3.1608125630312633,
    "accounts_payable_turnover_days": 115.47663542882148,
    "cash_conversion_cycle": -72.6412378367556,
    "inv_to_cash_days": 21.354315043188265,
    "bs_inventories": 5718000000,
    "bs_other_inv": 5718000000
  }
]

Field Dictionary

FieldDescription
acct_rcv_turnAccounts receivable turnover
acct_rcv_daysAccounts receivable days
invent_turnInventory turnover
invent_daysInventory days
accounts_payable_turnoverAccounts payable turnover
accounts_payable_turnover_daysAccounts payable turnover days
cash_conversion_cycleCash conversion cycle (days)
inv_to_cash_daysInventory to cash days
bs_inventoriesTotal inventories
bs_other_invOther inventories

Metadata

FieldDescription
tickerCompany ticker symbol
datePeriod end date
periodReporting period (e.g. Annual, Quarterly)
period_labelHuman-readable period label
fiscal_yearFiscal year
currencyReporting currency

Cash Conversion Cycle Interpretation

CCC ValueMeaning
NegativeCompany receives cash before paying suppliers. strong working capital position
0-30 daysEfficient cash management. typical for well-run businesses
30-90 daysNormal range for most industries. depends on sector norms
Above 90 daysSignificant capital tied up in operations. may indicate inefficiency

Use Cases

  • Compare cash conversion cycles across industry peers to identify the most capital-efficient operators
  • Track inventory turnover trends to detect supply chain issues or changing demand patterns
  • Monitor receivables turnover to identify companies with deteriorating collection performance
  • Use asset turnover alongside profit margins to decompose return on assets (DuPont analysis)
  • Screen for companies with negative cash conversion cycles as indicators of operational excellence