Blog · Finance metrics and formulas · Finance and FP&A teams
Compare two companies after aligning their reporting periods, accounting definitions and units. Work through revenue, margins, operating cash flow and working capital, with spreadsheet formulas and checks.
Comparing financial statements of two companies starts with making their numbers comparable: the same periods, units, business scope and accounting definitions. Only then should you compare revenue, margins, cash generation and working capital. A larger profit can coexist with weaker cash generation relative to sales.
Collect each company's income statement, balance sheet, cash flow statement and notes. The SEC's guide to financial statements distinguishes balances measured at a date from income and cash flows measured over a period, and explains why accounting-policy notes matter.
Create a source register before copying numbers. Record the company, statement, reporting dates, currency, units, page or workbook tab, and whether the statements are consolidated. Keep the original reported amounts beside any adjusted comparison amounts.
For internal workbooks, retain the account codes and original row identifiers. A reporting package assembled from a trial balance can use the monthly financial report template as a starting structure. Do not combine a subsidiary's standalone results with another company's consolidated results without explaining the difference.
Write down the comparison basis explicitly. For this example, both companies are illustrative US distributors reporting in USD for the year ended December 31, 2025. Amounts are whole dollars. Their cost classifications are assumed consistent, and neither workbook contains acquisitions or discontinued operations.
Check these items before calculating:
If the disclosures cannot support an adjustment, leave the reported result intact and flag the limitation. An unsupported adjustment creates apparent precision without evidence.
Put the measure in column A, Company Alder in B and Company Birch in C. Enter source amounts on the input rows; calculate the other rows. Costs and capital spending are shown as positive inputs to be subtracted.
| Spreadsheet row | Measure | Alder (USD) | Birch (USD) | Source or calculation |
|---|---|---|---|---|
| 2 | Revenue | 12,000,000 | 8,000,000 | Income statement |
| 3 | Cost of goods sold | 7,800,000 | 4,800,000 | Income statement |
| 4 | Gross profit | 4,200,000 | 3,200,000 | Revenue minus cost of goods sold |
| 5 | Operating expenses | 2,700,000 | 2,200,000 | Income statement, below gross profit |
| 6 | Operating profit | 1,500,000 | 1,000,000 | Gross profit minus operating expenses |
| 7 | Operating cash flow | 1,050,000 | 960,000 | Cash flow statement |
| 8 | Cash capital spending | 450,000 | 400,000 | Cash flow statement |
| 9 | Operating cash after capital spending | 600,000 | 560,000 | Operating cash flow minus capital spending |
| 10 | Closing trade receivables | 1,800,000 | 1,000,000 | Balance sheet |
| 11 | Closing inventory | 1,500,000 | 800,000 | Balance sheet |
| 12 | Closing trade payables | 1,200,000 | 700,000 | Balance sheet |
| 13 | Defined operating working capital | 2,100,000 | 1,100,000 | Receivables plus inventory minus payables |
Use the following spreadsheet formulas. Enter them in the named cells and copy across to column C:
B4 = B2-B3
B6 = B4-B5
B9 = B7-B8
B13 = B10+B11-B12
The working-capital definition here excludes cash, debt and other current balances. Label it clearly; it is not total current assets minus total current liabilities. Operating cash after capital spending is also a defined comparison measure, rather than a substitute for the cash flow statement.
The CFA Institute explains that ratios and common-size statements help remove size as a factor in comparisons. The common-size statement definition covers the basic convention; here the denominator for every percentage is annual revenue.
| Measure | Alder calculation | Alder | Birch calculation | Birch |
|---|---|---|---|---|
| Cost of goods sold / revenue | 7,800,000 / 12,000,000 | 65.00% | 4,800,000 / 8,000,000 | 60.00% |
| Gross margin | 4,200,000 / 12,000,000 | 35.00% | 3,200,000 / 8,000,000 | 40.00% |
| Operating expenses / revenue | 2,700,000 / 12,000,000 | 22.50% | 2,200,000 / 8,000,000 | 27.50% |
| Operating margin | 1,500,000 / 12,000,000 | 12.50% | 1,000,000 / 8,000,000 | 12.50% |
| Operating cash flow / revenue | 1,050,000 / 12,000,000 | 8.75% | 960,000 / 8,000,000 | 12.00% |
| Closing operating working capital / revenue | 2,100,000 / 12,000,000 | 17.50% | 1,100,000 / 8,000,000 | 13.75% |
For example, gross margin in a separate comparison sheet can reference the source sheet as:
=Statements!B4/Statements!B2
Format as a percentage with two decimal places. Calculate from the dollar inputs, keeping full precision until display. The detailed gross profit margin method explains the underlying cost and revenue choices.
Birch retains more gross profit per sales dollar, but also spends more on operating expenses relative to revenue. Operating margins match. Birch generates more operating cash relative to sales and holds less defined closing working capital relative to revenue; those observations require investigation of collections, inventory, payment timing and seasonality before drawing a conclusion.
Each statement must reconcile independently. For Alder, revenue less cost of goods sold less operating expenses is 12,000,000 - 7,800,000 - 2,700,000 = $1,500,000. Birch's equivalent is 8,000,000 - 4,800,000 - 2,200,000 = $1,000,000.
In the worksheet, this check should return zero for both columns:
=B2-B3-B5-B6
Then tie operating cash flow to the cash flow statement and each working-capital input to the balance sheet. Reconcile any adjusted amounts to their reported originals. Record the source and reason for each reclassification so another reviewer can reproduce it.
Use the comparison to choose the next question, rather than declare a winner. A broader financial KPI set helps select follow-up measures, but this comparison needs only the measures relevant to the business decision.
Bring the company statement workbooks and a consistent account and period mapping; Covirage maps the columns, and its tools compute and check the comparable figures. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.
See Covirage for finance teams for the supporting workflow.
Yes, when you can build matching periods from their quarterly or monthly statements. Use the same start and end dates and disclose any remaining mismatch. Annual reports with different year ends may contain different seasonal conditions, so their annual growth rates need qualification.
Common-size statements put amounts on a consistent scale, such as each income statement line divided by revenue. This makes cost structures easier to compare across company sizes. Keep the dollar amounts too, because percentages alone hide the scale of earnings and cash needs.
A higher gross margin needs context. Cost classification, product mix, inventory policies and delivery obligations can differ. Compare operating margin and cash generation alongside it, then investigate the statement notes before treating the gap as an operating advantage.
Use income statements, balance sheets and cash flow statements, together with their notes. Income statements explain earnings over a period; balance sheets show balances at a date; cash flow statements explain cash movements. Beginning balances help when calculating measures based on average assets or working capital.