Blog · Finance metrics and formulas · Finance and FP&A teams
Industry ratio benchmarks are useful only when the companies and definitions are comparable. Build a dated peer workbook, calculate average, median and pooled ratios, and reconcile the comparison before acting on a gap.
Industry averages for financial ratios are useful only after you define comparable peers and calculate each ratio consistently. Keep the arithmetic average, median and ratio of pooled totals separate: the same company records can produce a different answer under each method.
Write a short benchmark specification. It should identify the operating question, peer selection rule, financial period and ratio definition. A US regional distributor deciding whether to change customer terms needs distributors with a similar business mix, rather than every company selling into the same end market.
Record these fields beside the workbook:
| Field | What to specify |
|---|---|
| Business activity | Products, service mix and revenue recognition |
| Company scope | Consolidated group or comparable operating segment |
| Scale and geography | Relevant operating size and US exposure |
| Financial period | Fiscal dates and annual or interim statements |
| Calculation policy | Numerator, denominator and treatment of adjustments |
| Benchmark date | When the peer records were collected and approved |
Do not mix a segment's operating profit with its parent's total assets. Similarly, a company with substantial manufacturing operations may be a poor profitability peer for a business that only distributes finished goods.
For published context, NYU's US industry margin dataset identifies its analysis date, company counts and different margin measures. Those are fields to preserve when taking any published benchmark into a management workbook. They do not establish that its companies match your operating question.
The financial ratios by industry guide covers industry selection more broadly. This workflow starts once you have a proposed peer set to test.
Keep source document references and financial dates alongside the amounts. Preserve original reported figures separately from adjustments, and explain each adjustment before recalculating a peer.
Here is an illustrative peer set of US distributors for the year ended December 31, 2025, in USD. These invented companies demonstrate the method; they are not a published industry average. Interest-bearing debt excludes operating lease liabilities consistently across the rows.
| Company | Revenue (USD) | Operating income (USD) | Current assets (USD) | Current liabilities (USD) | Debt (USD) | Total assets (USD) |
|---|---|---|---|---|---|---|
| Peer A | 10,000,000 | 600,000 | 2,400,000 | 1,200,000 | 3,000,000 | 6,000,000 |
| Peer B | 20,000,000 | 2,000,000 | 5,000,000 | 4,000,000 | 6,000,000 | 10,000,000 |
| Peer C | 70,000,000 | 9,800,000 | 14,000,000 | 8,000,000 | 15,000,000 | 30,000,000 |
| Total | 100,000,000 | 12,400,000 | 21,400,000 | 13,200,000 | 24,000,000 | 46,000,000 |
Columns A:G follow the table. Put operating margin in H, current ratio in I and debt to assets in J. For the first company in row 2, use these formulas and fill down through row 4:
H2: =IF(OR(B2="",B2<=0,C2=""),NA(),C2/B2)
I2: =IF(OR(D2="",E2="",E2<=0),NA(),D2/E2)
J2: =IF(OR(F2="",G2="",G2<=0),NA(),F2/G2)
The formulas deliberately surface missing inputs and unusable denominators. Investigate those rows rather than replacing an unavailable ratio with zero. OpenStax's liquidity ratio explanation defines the current ratio as current assets divided by current liabilities; apply that definition identically across peers.
| Company | Operating margin | Current ratio | Debt / total assets |
|---|---|---|---|
| Peer A | 600,000 / 10,000,000 = 6.0% | 2,400,000 / 1,200,000 = 2.00 | 3,000,000 / 6,000,000 = 50.0% |
| Peer B | 2,000,000 / 20,000,000 = 10.0% | 5,000,000 / 4,000,000 = 1.25 | 6,000,000 / 10,000,000 = 60.0% |
| Peer C | 9,800,000 / 70,000,000 = 14.0% | 14,000,000 / 8,000,000 = 1.75 | 15,000,000 / 30,000,000 = 50.0% |
Percentages are shown to one decimal place and current ratios to two. The general financial ratios formulas explain the individual measures; keep their definitions fixed while selecting the benchmark.
For operating margin, these formulas answer separate questions:
Arithmetic average: =AVERAGE(H2:H4)
Median company: =MEDIAN(H2:H4)
Pooled margin: =SUM(C2:C4)/SUM(B2:B4)
| Method | Worked calculation | Result |
|---|---|---|
| Arithmetic average | (6.0% + 10.0% + 14.0%) / 3 | 10.0% |
| Median | Middle of 6.0%, 10.0%, 14.0% | 10.0% |
| Pooled operating margin | 12,400,000 / 100,000,000 | 12.4% |
| Pooled current ratio | 21,400,000 / 13,200,000 | 1.62 |
| Pooled debt / assets | 24,000,000 / 46,000,000 | 52.2% |
The pooled margin gives more influence to the largest revenue base. Prove it with the revenue-weighted identity:
=SUMPRODUCT(B2:B4,H2:H4)/SUM(B2:B4)
That must equal the pooled margin calculated from operating income and revenue totals. Use unrounded ratios in H. The count-weighted and value-weighted guide explains why equal company weights and denominator weights describe different populations.
Suppose your company reports these figures for the same year:
| Company input | Amount (USD) |
|---|---|
| Revenue | 12,000,000 |
| Operating income | 900,000 |
Its operating margin is 900,000 / 12,000,000 = 7.5%: 7.5% − 10.0% = −2.5 percentage points against the median, or 7.5% − 12.4% = −4.9 points against the pooled margin.
Neither gap proves underperformance. FP&A should check product mix, service commitments and cost classification before assigning an action. The controller owns the financial definitions and reconciliation; the operating leader owns the decision about prices, service levels or spending.
Bring a sample of your own company statements and dated peer workbook to Covirage. Covirage maps the columns, its tools compute and check the ratios and comparisons, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.
See Covirage for finance teams for the supporting workflow.
Use documented financial statements, industry research or a financial dataset that discloses its coverage and calculation method. Record the publication date, financial periods, company count and definitions. A headline average without that information is difficult to reproduce or assess.
Use the median to describe the middle company in a peer group. An arithmetic average gives every company equal weight but can move sharply with extreme observations. A pooled ratio describes the combined financial totals, so larger denominators carry more weight.
They can provide context when activities, scale and accounting treatment are comparable. Separate structural differences such as ownership, financing, lease treatment and acquisition history before interpreting a gap. The benchmark should inform an operating investigation rather than become an automatic target.