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.
https://api.roic.ai/v2/fundamental/ratios/working-capital/{identifier}Parameters
Path Parameters
identifierstringrequiredCompany identifier — supports ticker symbol (e.g., `AAPL`), CIK, CUSIP, or ISIN.
AAPLQuery Parameters
apikeystringrequiredYour API key for authentication.
periodstringoptionalReporting period for financial data.
annualValues: annual, quarterlylimitnumberoptionalMaximum number of periods to return.
10Example: 10fiscal_year_startnumberoptionalFilter results starting from this fiscal year.
2020fiscal_year_endnumberoptionalFilter results ending at this fiscal year.
2024date_startstringoptionalFilter results starting from this date (YYYY-MM-DD format).
2020-01-01date_endstringoptionalFilter results ending at this date (YYYY-MM-DD format).
2024-12-31orderstringoptionalSort order for time-series data.
DESCValues: ASC, DESCformatstringoptionalResponse format. Use `json` for JSON (default) or `excel` for tab-separated values compatible with Google Sheets and Excel.
jsonValues: json, excelCode Examples
curl "https://api.roic.ai/v2/fundamental/ratios/working-capital/AAPL?apikey=YOUR_API_KEY"Response
[
{
"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
| Field | Description |
|---|---|
acct_rcv_turn | Accounts receivable turnover |
acct_rcv_days | Accounts receivable days |
invent_turn | Inventory turnover |
invent_days | Inventory days |
accounts_payable_turnover | Accounts payable turnover |
accounts_payable_turnover_days | Accounts payable turnover days |
cash_conversion_cycle | Cash conversion cycle (days) |
inv_to_cash_days | Inventory to cash days |
bs_inventories | Total inventories |
bs_other_inv | Other inventories |
Metadata
| Field | Description |
|---|---|
ticker | Company ticker symbol |
date | Period end date |
period | Reporting period (e.g. Annual, Quarterly) |
period_label | Human-readable period label |
fiscal_year | Fiscal year |
currency | Reporting currency |
Cash Conversion Cycle Interpretation
| CCC Value | Meaning |
|---|---|
| Negative | Company receives cash before paying suppliers. strong working capital position |
| 0-30 days | Efficient cash management. typical for well-run businesses |
| 30-90 days | Normal range for most industries. depends on sector norms |
| Above 90 days | Significant 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
Related Endpoints
- Liquidity Ratios - current ratio and quick ratio for short-term solvency
- Profitability Ratios - margins to combine with turnover for DuPont analysis
- Balance Sheet - detailed receivables, inventory, and payables data
- Income Statement - revenue and cost of goods sold used in turnover calculations