Blog · Finance metrics and formulas · Finance and FP&A teams
Compare company ratios with a supplied industry benchmark workbook using a defensible NAICS peer group. This guide covers matching, spreadsheet calculations, weighted ratios and the checks that make a performance gap meaningful.
Industry financial ratios by NAICS code are useful only after the company and its benchmark group use comparable activities, periods and definitions. Start with your financial export and a supplied peer workbook, select defensible matches, then calculate the gap using the same formula on both sides. The code narrows the search; it does not establish a performance target.
NAICS classifies establishments by their economic activities. The Census Bureau explains its production-oriented structure: establishments are grouped by similar processes, and the hierarchy runs from sectors to detailed national industries. That makes a broad sector an initial screen, rather than a ready-made financial peer group.
Start with the operating business you want to assess. A consolidated company with distribution, service and manufacturing activities may need separate comparisons. Do not assign a group-level benchmark to a division merely because the parent appears under that code.
Record the classification version and the source's exact code. Then review sales channels, owned versus leased facilities, product mix and geographic scope. For the wider question of which measures belong in a sector review, use financial ratios by industry; this workflow addresses selecting and calculating against a supplied benchmark.
Keep the original benchmark sheet intact and make an eligible-peer table. Each candidate needs these fields:
| Matching field | What to record | Reason to flag a row |
|---|---|---|
| NAICS code and version | Source classification and release | Different activity or incompatible version |
| Reporting period | Fiscal start and end | Seasonal quarter compared with a full year |
| Accounting basis | Cost and expense definitions | Occupancy included in COGS on one side only |
| Operating profile | Distributor, manufacturer or mixed business | Different production responsibilities |
| Scope and size | Consolidation perimeter and revenue band | A division compared with an unrelated group |
| Eligibility | Yes or Review, with a reason | Missing data or unresolved mismatch |
Do not fill a missing balance with zero. Return to the source or exclude that ratio for that peer. A peer can qualify for operating margin while lacking the average inventory needed for turnover.
Write the definitions beside the sheet. The SEC's financial statement guide defines operating margin as income from operations divided by net revenue, and inventory turnover as cost of sales divided by average inventory. For the underlying ratio families, keep the broader financial ratios guide beside your worksheet.
Consider an illustrative US distributor and three already matched peers for one full fiscal year. These are teaching figures, not observed industry benchmarks. Average inventory uses opening plus closing inventory divided by two for every business; a seasonal review would need more frequent balances.
| Business | Net revenue (USD) | Cost of sales (USD) | Operating income (USD) | Average inventory (USD) | Operating margin | Inventory turns |
|---|---|---|---|---|---|---|
| Peer A | 12,000,000 | 10,800,000 | 960,000 | 1,500,000 | 8.0% | 7.20 |
| Peer B | 18,000,000 | 16,200,000 | 1,260,000 | 3,000,000 | 7.0% | 5.40 |
| Peer C | 30,000,000 | 27,000,000 | 1,500,000 | 4,500,000 | 5.0% | 6.00 |
| Peer totals | 60,000,000 | 54,000,000 | 3,720,000 | 9,000,000 | 6.2% | 6.00 |
| Your company | 15,000,000 | 13,500,000 | 900,000 | 2,250,000 | 6.0% | 6.00 |
In an Excel sheet named Eligible, put Peer A through Peer C in rows 2 through 4, with the columns shown above starting at A. Calculate F2 and G2 and fill down:
=D2/B2
=C2/E2
Format F as a percentage. The peer median and the ratio of pooled totals answer different questions:
=MEDIAN(F2:F4)
=SUM(D2:D4)/SUM(B2:B4)
=MEDIAN(G2:G4)
=SUM(C2:C4)/SUM(E2:E4)
The median operating margin is 7.0%; the pooled margin is 6.2%. The median and pooled inventory turnover both happen to be 6.00 here. Do not assume they generally agree.
If a larger prepared table marks eligible rows with Yes in H, pooled margin can use:
=SUMIFS(D2:D100,H2:H100,"Yes")/SUMIFS(B2:B100,H2:H100,"Yes")
Microsoft documents SUMIFS as adding values meeting specified criteria. Apply the same eligibility filter to numerator and denominator, and stop the calculation when eligible revenue is zero. Covirage is not affiliated with Microsoft.
Your company's operating margin is 900,000 / 15,000,000 = 6.0%. Against the peer median, the gap is 6.0% minus 7.0%, or negative 1.0 percentage point. At unchanged company revenue, a 7.0% margin would mean $1,050,000 of operating income: 15,000,000 × 7.0%. The difference from $900,000 is $150,000.
That is a sensitivity, not a savings commitment. Investigate freight classification, customer mix and selling expenses before assuming the gap can be removed. The company's gross profit is 15,000,000 minus 13,500,000 = $1,500,000; subtracting operating income of $900,000 implies $600,000 of other operating expenses. Those amounts must tie to the ledger before allocating responsibility for the gap.
Inventory turns equal the peer median. That says nothing by itself about obsolete stock or service levels. Read the aging detail before concluding that inventory needs no attention.
The industry averages guide explains the separate interpretation problem behind published averages. Keep its population and weighting questions attached to any benchmark you bring into a management report.
Rebuild the pooled operating margin as 3,720,000 / 60,000,000 = 6.2%. Rebuild pooled turnover as 54,000,000 / 9,000,000 = 6.00. Show percentages to one decimal place and turns to two, retaining unrounded calculations underneath.
The controller should approve accounting mappings, while the finance analyst records exclusions and the operating manager explains business differences. Save the benchmark's original date with the reporting package so an updated source cannot silently change last month's comparison.
Bring your company financial export and a benchmark table your organization is entitled to use; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the comparison with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.
See Covirage for finance teams for the supporting team context.
No. Businesses sharing a code can differ in customer mix, outsourcing, asset ownership and company size. Review those characteristics before including a peer. A narrowly matched internal history can be more useful than a larger group with incompatible economics.
Use the statistic that answers the question and identify it explicitly. A median describes the middle peer. A ratio calculated from pooled financial totals describes the combined group. An arithmetic average gives each company equal weight regardless of its size.
Use a source your organization is entitled to use and can document, such as a purchased report or a prepared peer analysis. Keep its publication date, population, definitions and permission restrictions. Covirage does not supply the benchmark data described here.
Only with careful adjustments and clear labeling. Margins may be comparable when seasonality and cost classifications match, but turnover uses a period flow against an average balance. Prefer the same reporting period rather than assuming a short quarter represents the year.