A free quality of earnings template in Excel, with a complete diligence case
The QoE bridge over three years, revenue quality, net debt and debt-like items, twelve months of working capital and the peg, the closing statement and capex: nine sheets, no macros.
The file runs financial due diligence on Quellmark, a fictional labels and packaging business sold at an enterprise value of $204 million. Reported EBITDA for FY2025 is $21.8 million and the sale memorandum claims $24.0 million adjusted. Diligence accepts $1.5 million of management adjustments and finds $1.9 million against the seller (rebates earned but not recorded, a reserve release, related-party rent at market, under-accrued bonuses), for a diligence-adjusted EBITDA of $21.4 million. Debt-like items add $7.6 million to net debt, and the working capital peg the seller proposed is $27.15 million against a twelve-month adjusted average of $28.98 million.
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.
Quality_of_Earnings_Model.xlsx (25 KB)
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.
The book behind this model
This file is one worked case from The Financial Due Diligence Associate. 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).
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
Nine sheets. Blue cells on a light blue background are inputs; everything else is a formula. Amounts in $ million.
Read Me and Inputs
Reported figures for three years and every adjustment driver: owner pay and its replacement, legal costs, a relocation, a run-rate claim, the rebate shortfall, the reserve release, rent and bonuses.
QoE
The bridge from reported to diligence-adjusted EBITDA for FY2023 to FY2025 and Q1, the margin, and the gap to the sale memorandum.
Revenue
Growth, gross margin, segments, price against volume, customer concentration and working capital days.
Net Debt
Debt, leases and cash, then each debt-like item with a flag for whether it is agreed and enters the price bridge.
NWC
Twelve month-ends of reported and adjusted working capital, the average and the seller's peg.
Closing
The estimated and final closing statements, the working capital adjustment, the buyer's claim and the escrow.
Capex and Checks
Maintenance against growth capex and cash conversion; then the book's figures against the formulas: all OK.
What the worked case returns
Measure
Value
Reported EBITDA, FY2025
$21.8m
Management adjustments accepted
+$1.5m
Diligence adjustments
-$1.9m
Diligence-adjusted EBITDA
$21.4m
CIM adjusted EBITDA
$24.0m
Debt-like items agreed
$7.6m (of $9.9m proposed)
NWC, twelve-month adjusted average
$28.98m
Seller's peg (six-month average)
$27.15m
Equity price at closing, final
$170.7m
The seller's peg is an average over the six lowest months of the year. Working capital peaks in the summer and troughs in December, so a six-month window from October to March sets the peg about $1.8 million below the twelve-month average, and every dollar of that gap comes back to the seller at closing.
How to use it on your own target
Enter three years of reported figures and each adjustment driver on Inputs.
Read the QoE bridge line by line: accept, reject or quantify each management claim.
Flag each debt-like item on Net Debt as agreed or not before it enters the price.
Set the peg on NWC over twelve months, not the window the seller chose.
Questions people ask about it
Is this 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.
Does it use macros or circular references?
No macros and no circular reference: every line of the bridge is a sum of drivers on the Inputs sheet.
What is the difference between adjusted EBITDA and diligence-adjusted EBITDA?
Adjusted EBITDA is the seller's figure, reported EBITDA plus the add-backs management claims. Diligence-adjusted EBITDA keeps only the claims the evidence supports and adds the adjustments the seller left out. Here they differ by $2.6 million.
Can I use it on a real deal?
You can reuse the structure. Quellmark and every figure are fictional, and nothing here is investment or accounting advice.
The rest of the files
This template is the companion workbook for The Financial Due Diligence Associate; the companion page also carries the other files that go with it. 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.
This template comes from The Financial Due Diligence Associate. The book is on Apple Books and Google Play.
If this book helped, or didn’t, a rating where you bought it is worth more than it looks: it is what the next reader goes on. The template stays free either way.