Blog · Finance metrics and formulas · Finance and FP&A teams
The working investment to sales ratio measures operating funds tied up relative to revenue. Define the accounts, calculate a quarterly example, and reconcile the result to broader working capital.
The working investment to sales ratio compares average operating funds tied up in customers and inventory, after supplier funding, with net sales for the same period. Under the definition below, an average investment of $800,000 supporting $3,200,000 of quarterly sales produces a 25.0% ratio. That means 25 cents of average operating investment per dollar of that quarter's sales.
Operating working investment = Trade receivables + Inventory − Trade payables
Working investment to sales ratio = Average operating working investment / Net sales for the period
This article uses a narrow operating definition. It excludes cash, interest-bearing borrowing, income taxes, operating prepayments and accrued expenses. A company may include additional operating accounts in its management measure, but it must name them and apply the same mapping consistently.
The measure differs from working capital. The SEC's financial statement guide defines working capital as current assets minus current liabilities. That broader balance includes current cash and borrowing, so it can move when financing changes even if receivables, inventory and trade payables stay unchanged.
It also differs from working capital turnover, which puts sales above the capital balance. The ratios are reciprocals only when their account definitions, averaging conventions and sales periods match. A ratio labeled simply "working capital" is not enough information to make that comparison.
Use a balance-sheet export with reporting date, business unit, account code, account description, currency and closing balance. Add a sales export with recognized period, business unit and net sales. Keep the account mapping beside the report so reviewers can identify every included balance.
Receivables should be trade balances. State whether they are gross or net of the credit-loss allowance. Inventory should use the recorded carrying value, with valuation adjustments handled consistently. Trade payables should cover suppliers supporting those operations, rather than including borrowing or unrelated liabilities.
Inventory is a dollar balance, not a quantity multiplied by a current selling price. The IRS inventory guidance explains that purchased merchandise cost is the invoice price less appropriate discounts, plus acquisition charges such as transportation. Use the financial workbook's approved inventory basis; do not quietly substitute replacement prices for recorded values.
Normalize liability signs before calculation. The tables below show liabilities as positive amounts and subtract them explicitly. If a ledger stores trade payables as a negative credit balance, subtracting that negative number would incorrectly increase the investment.
A US distributor reviews January through March 2026. It uses the simple average of the three month-end observations, stated in advance, and recognized net sales for those same months. All amounts below are USD.
| Month | Trade receivables (USD) | Inventory (USD) | Trade payables (USD) | Working investment (USD) | Net sales (USD) |
|---|---|---|---|---|---|
| January | 600,000 | 500,000 | 350,000 | 750,000 | 1,000,000 |
| February | 660,000 | 520,000 | 380,000 | 800,000 | 1,050,000 |
| March | 720,000 | 560,000 | 430,000 | 850,000 | 1,150,000 |
| Sum of observations | 1,980,000 | 1,580,000 | 1,160,000 | 2,400,000 | 3,200,000 |
January's working investment is 600,000 + 500,000 − 350,000 = $750,000. The same calculation produces February's $800,000 and March's $850,000. Summing balance observations is an intermediate step, not a claim that the company invested $2,400,000 at once.
| Calculation step | Formula | Result |
|---|---|---|
| Average working investment | 2,400,000 / 3 | 800,000 USD |
| Quarterly net sales | 1,000,000 + 1,050,000 + 1,150,000 | 3,200,000 USD |
| Investment to quarterly sales | 800,000 / 3,200,000 | 25.0% |
| Inverse, on the identical basis | 3,200,000 / 800,000 | 4.0 quarterly turns |
With months on rows 2 through 4, receivables in B, inventory in C, payables in D and sales in F, calculate working investment in E2 and copy down:
=B2+C2-D2
Then calculate the ratio:
=AVERAGE(E2:E4)/SUM(F2:F4)
Format the result as a percentage. The example percentages and turns are shown to one decimal place; calculations retain their underlying values. For seasonal operations, inspect more frequent observations before assuming these month-end balances represent the funding peak.
First, reconcile each account total to the corresponding monthly trial balance and net sales to the income statement. The investment identity must also hold across observations: 1,980,000 + 1,580,000 − 1,160,000 = $2,400,000. Dividing that by the observation count must reproduce the average used in the ratio.
Next, explain the difference from net working capital. March includes the following additional accounts; there are no other current accounts in this simplified example.
| March balance | Amount (USD) | Treatment in the narrow operating measure |
|---|---|---|
| Cash | 160,000 | Excluded |
| Trade receivables | 720,000 | Included as asset |
| Inventory | 560,000 | Included as asset |
| Operating prepayments | 40,000 | Excluded |
| Trade payables | 430,000 | Included as liability |
| Operating accruals | 110,000 | Excluded |
| Current borrowing | 200,000 | Excluded |
Current assets total $1,480,000 and current liabilities total $740,000, producing net working capital of $740,000. The narrow operating investment is $850,000. Its bridge is 850,000 + 160,000 + 40,000 − 110,000 − 200,000 = $740,000. The difference comes from the declared account boundary, not an arithmetic disagreement.
A lower target should identify an operating action. At unchanged quarterly sales, a hypothetical 23.0% target implies average investment of 3,200,000 × 23.0% = $736,000, or $64,000 below the example's average. That is an average-balance planning gap, not a promise of an immediate cash receipt.
Finance can ask whether faster collections, slower inventory purchases or negotiated supplier terms could support that change. Each proposal needs an owner and an operating safeguard. Do not treat a temporarily depleted inventory balance or an overdue payable as a durable improvement.
Two similarly named measures answer different questions: the working ratio formula compares operating expenses with revenue, while the investment income ratio concerns investment income. Neither substitutes for operating investment relative to sales.
Bring a monthly balance-sheet export, the account mapping and matching sales file to Covirage. Covirage maps the columns, and its tools compute and check the investment balances and ratios; the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, then set up your business and bring a sample of your own data.
See how this supports finance teams reviewing operating investment across periods and business units.
Not necessarily. Net working capital includes all current assets less current liabilities. The operating definition used here includes only trade receivables, inventory and trade payables. Cash, borrowing and other current accounts create a difference that should be reconciled rather than ignored.
Use average balances when asking how much operating investment supported a period's sales. Closing balances answer a separate reporting-date question. Monthly observations are useful, but daily or weekly balances may be necessary when month-end snapshots miss substantial seasonal peaks.
There is no universal target. Payment terms, inventory requirements and supplier arrangements differ. Compare consistent periods within the business, then investigate changes in receivables, inventory and payables separately. A lower ratio achieved by stock shortages or overdue supplier payments may create operating problems.
Yes. Under this definition, trade payables can exceed trade receivables plus inventory. That produces negative operating investment when sales are positive. Check the underlying balances and payment arrangements before interpreting it; a negative result is not automatically evidence of strong liquidity.