Blog · Finance metrics and formulas · Finance and FP&A teams
Compare companies over the same reporting period using consistent financial statement definitions. This guide builds a peer worksheet, calculates comparable ratios and shows how to check the results before interpreting a gap.
Cross sectional analysis of financial statements compares companies at the same date or over the same period using consistent definitions. Convert the supplied accounts into a peer worksheet, calculate identical ratios and investigate the differences that remain. A ratio gap is a starting question, not an operating explanation.
Write the business question first. A finance team examining operating cost structure needs peers with similar activities and a consistent split between cost of goods sold and operating expenses. A liquidity review instead needs comparable current-asset and current-liability classifications.
CFA Institute's financial analysis techniques defines cross-sectional comparison across companies for the same point or range of time. It also explains how ratios and common-size statements reduce the effect of company size. This supports comparing margins rather than simply ranking businesses by their profit dollars.
List the inclusion rules beside the worksheet: business activity, geography, reporting period, accounting basis and available detail. Exclude a peer only for a stated comparability reason. Selecting companies after seeing their results can produce a misleading reference group.
Use time-series versus cross-sectional analysis for the separate question of change within one company. This method holds the reporting period fixed and changes the company being observed.
For this example, use three illustrative US industrial distributors, each reporting in USD for the year ended December 31, 2025. Their balance-sheet amounts are all at that year-end. Assume identical COGS classification and no differences in reporting perimeter that affect the comparison.
In a real workbook, preserve the original company name, source file, statement page, currency, units and fiscal dates. A separate mapping column should show which source account became revenue, COGS or an operating expense. The financial statements guide covers the underlying statement types.
The input worksheet has these columns A through G, with the first peer in row 2:
| Peer | Revenue (USD) | COGS (USD) | Operating expenses (USD) | Current assets (USD) | Current liabilities (USD) | Reported operating profit (USD) |
|---|---|---|---|---|---|---|
| Distributor A | 20,000,000 | 14,000,000 | 4,000,000 | 5,000,000 | 2,500,000 | 2,000,000 |
| Distributor B | 12,000,000 | 7,800,000 | 3,240,000 | 3,000,000 | 2,000,000 | 960,000 |
| Distributor C | 8,000,000 | 5,600,000 | 1,600,000 | 1,600,000 | 2,000,000 | 800,000 |
The SEC's financial statement guide distinguishes balance-sheet snapshots from income statements covering a period and describes operating margin as operating income divided by net revenue. Match those bases before interpreting a difference.
Gross margin = (Revenue - COGS) / Revenue
Operating margin = Operating profit / Revenue
Current ratio = Current assets / Current liabilities
Gross margin describes the share remaining after COGS. Operating margin also includes the operating expenses below gross profit. The current ratio describes current balance-sheet coverage; it does not measure when individual cash receipts and payments occur.
In H2, calculate gross profit. In I2 through K2, calculate the comparable ratios:
=B2-C2
=IF(OR(B2="",B2=0,C2=""),"",H2/B2)
=IF(OR(B2="",B2=0,G2=""),"",G2/B2)
=IF(OR(E2="",F2="",F2=0),"",E2/F2)
Fill down through row 4. Validate that source amounts are numeric before calculating, and retain an explicit missing-data flag for incomplete peers. Format margins as percentages; a blank denominator must not become a zero ratio.
| Peer | Gross profit (USD) | Gross margin | Operating margin | Current ratio |
|---|---|---|---|---|
| Distributor A | 6,000,000 | 30.0% | 10.0% | 2.00 |
| Distributor B | 4,200,000 | 35.0% | 8.0% | 1.50 |
| Distributor C | 2,400,000 | 30.0% | 10.0% | 0.80 |
Calculate using full precision, then round margins to one decimal place and current ratios to two. Distributor B's gross margin is ($12,000,000 - $7,800,000) / $12,000,000 = 35.0%, but its operating margin is $960,000 / $12,000,000 = 8.0%.
The difference has a visible accounting location: B's operating expenses are $3,240,000 / $12,000,000 = 27.0% of revenue. A and C each report 20.0%. That points the next inquiry toward expense classification and operating cost structure; it does not prove waste or excess staffing.
In L2, compare the reconstructed operating profit with the reported figure:
=B2-C2-D2-G2
Every row must return zero. For B, $12,000,000 - $7,800,000 - $3,240,000 - $960,000 = $0. A nonzero result means the mapping or source statement needs attention before the peer comparison proceeds.
Choose a summary that matches the question:
| Peer-group operating margin measure | Calculation | Result |
|---|---|---|
| Median company margin | Middle of 8.0%, 10.0%, 10.0% | 10.0% |
| Simple average company margin | (10.0% + 8.0% + 10.0%) / 3 | 9.33% |
| Pooled margin | (2,000,000 + 960,000 + 800,000) / (20,000,000 + 12,000,000 + 8,000,000) | 9.40% |
The median describes the middle peer; the pooled result weights companies by revenue. Neither is automatically a target for your own company. This selected teaching group does not establish an industry benchmark.
The spreadsheet equivalents are:
=MEDIAN(J2:J4)
=AVERAGE(J2:J4)
=SUM(G2:G4)/SUM(B2:B4)
Ask the controller to confirm cost classification before explaining B's margin spread. Ask treasury to inspect the maturity and composition of C's current liabilities rather than calling its 0.80 current ratio an immediate cash shortage. Collections and inventory schedules provide context that a single balance-sheet subtotal cannot supply.
Document the unresolved question, source record and responsible owner. Qualitative analysis of financial statements covers the policies and business context behind the arithmetic. Keep that interpretation attached to the ratios so that a neat ranking does not lose its qualifications.
Upload your peer statement workbook; Covirage maps the columns, and its tools compute and check the comparable ratios against the supplied rows. The external AI model explains the differences with every figure traced to its rows. Create a free Covirage account and bring a sample of your own comparison file.
See the approach for finance teams.
Cross-sectional analysis compares companies over a matching period or at a matching date. Time-series analysis follows one company across periods. Use the first to locate differences among peers and the second to see whether a company's own performance is changing.
There is no universal count that guarantees a useful comparison. Start with businesses that share the operating characteristics relevant to your question and have comparable statements. State the inclusion rules and disclose missing companies rather than treating a small selected group as an industry norm.
It depends on the question. A median describes the middle company in the selected group. A ratio calculated from summed amounts describes the combined amounts represented by those companies. Label the method, because a large company's figures can dominate a pooled ratio.