A free comparable company analysis template in Excel, with a complete worked valuation
Trading comparables, precedent transactions, quartiles and drop-one tests, the control premium converted into synergies, and what a multiple contains: seven linked sheets, one fictional company, no macros.
The file values Cawdrey Instruments, a specialist industrial manufacturer with 48,000,000 of revenue and 8,400,000 of EBITDA, on trading multiples and on precedent transactions. Five peers give a median of 8.20x and an enterprise value of 68,880,000; five deals give 10.40x and 87,360,000. The gap of 18,480,000 is a control premium of 26.8%, and the file converts it into the cash flow it demands: 1,724,800 of pre-tax synergies every year, for ever, which is 20.53% of the target's EBITDA.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
Need the full deal structure? The LBO Model, Pro Edition adds four debt tranches, covenants, a management ratchet and 31 checks, with no circular reference and no macros. $99 → · Watch the 60-second preview
The book behind this model
This file is one worked case from Business Valuation. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
LBO Model, Pro Edition: seven-year buyout model with four debt tranches, covenants, a management ratchet, 31 checks, a blank copy and an 18-page guide. $99 → · See what is inside · Watch the 5-minute demo
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Seven sheets, in the order the calculation runs. Inputs are blue figures in yellow cells, on Inputs and in the optional peer and deal column of Multiples; everything else is a formula.
Read me
What the workbook does, the premium test in one paragraph, and what the September 2026 revision added.
Inputs
Cawdrey's revenue, margin, depreciation, tax rate, capex, working capital, net debt and shares, plus the five-year growth plan, the 9.0% cost of capital and 2.0% terminal growth.
Multiples
The five trading peers and the five precedent deals at EV/EBITDA, their medians and the enterprise value each gives. Column D takes a sixth and seventh peer or deal of your own.
The Premium
The premium in currency, per cent and turns of EBITDA, converted into the perpetual after-tax flow and pre-tax synergies it requires; the same test at five premiums, against the cost base, with a three-year delay and with a third attributed elsewhere.
The Sets, Tested
Lowest, highest, mean, median and quartiles of each set, the value at each, equity value per share, the effect of dropping any one name, and what a reported deal multiple can hide.
What a Multiple Contains
An EBITDA multiple rebuilt from tax, reinvestment, cash conversion and the spread between discount rate and growth; the five-year DCF beside it; the three prices on free cash flow, EBIT and revenue; historic against forward EBITDA.
Checks
Every figure the book prints set against what the workbook computes: 71 of 71 pass.
What the worked valuation returns
Measure
Value
EBITDA
8,400,000 (17.50% of revenue)
Trading comparables: median and enterprise value
8.20x, 68,880,000
Equity value at the trading median
57,680,000 (14.42 a share)
Trading quartiles
8.00x to 8.90x (67,200,000 to 74,760,000)
Precedent transactions: median and enterprise value
10.40x, 87,360,000
Control premium
18,480,000 (26.8%, 2.20x EBITDA)
Required pre-tax synergies, every year
1,724,800 (20.53% of EBITDA)
The same if the synergies start three years late
2,233,666 (26.59% of EBITDA)
Discounted cash flow, for comparison
73,060,585 (8.70x)
The trading set on its own runs from 7.40x to 9.60x, a range of 18,480,000: as wide as the gap between the two methods. So the premium is not a finding until it is priced. The test the file prints is simple: the premium is justified only if the buyer can name, and cost, more than a fifth of Cawdrey's EBITDA in recurring synergies. Put a third of it down to competitive tension and a recovered minority discount, and the burden is still 1,149,867 a year.
How to use it on your own case
Open Inputs and overwrite the yellow cells with your company: revenue, margin, depreciation, tax, capex, working capital, net debt and shares.
On Multiples, replace the five peer and five deal multiples with your own sets. Add a sixth or seventh in column D if you have them.
Read The Sets, Tested before the median. If dropping one name moves the value by millions, the set is doing the valuation, not the company.
Go to The Premium and read the synergy line, not the percentage. Ask whether the buyer can name that much recurring cash flow.
Use What a Multiple Contains to check that your multiple fits the company's cash conversion and growth, and that you are not applying a historic multiple to forward EBITDA.
Keep the Checks sheet: once you change inputs it stops matching the book, which is expected. Use its structure for your own tie-outs.
Questions people ask about it
Is this comparable company analysis template really free?
Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.
How does it turn a control premium into synergies?
It asks what perpetual flow, growing at the terminal rate, is worth the premium. 18,480,000 multiplied by the cost of capital less growth (9.0% less 2.0%) is 1,293,600 after tax, and at a 25% tax rate that is 1,724,800 before tax. No macros and no circular reference are involved: every line is a plain formula.
Why the median and not the mean?
With five names one outlier moves the mean. Here the mean of 8.42x gives 70,728,000, 1,848,000 above the median value. The file shows both, the quartiles, and the median with each peer dropped in turn, so you can see how much one name is worth.
Can I use it for a real valuation?
You can reuse the structure. Cawdrey Instruments, its peers, the deals and every figure in the file are fictional, and nothing here is investment advice.
The rest of the files
This template is one of the companion files for Business Valuation: the full set adds Cawdrey: The Three Values, The Discounted Cash Flow and Backing Out the Assumption. Free, like this one.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
If this book helped — or didn’t — a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.