Quality Of Earnings Model

Private Equity Financial Model (Free Excel Download)

Find out what the target actually earns. This model takes a reported monthly trial balance and runs the four tests a quality of earnings report runs: it bridges reported EBITDA of 8,275 to an adjusted 10,015 and a run-rate 10,928 through thirteen categorised adjustments, proves every month's revenue and costs back to the bank statements, and sets a working capital peg from the twelve-month average of a normalised balance. Every adjustment carries a diligence quality rating, and the credit factor that rating selects is applied to addbacks only - a buyer does not discount bad news - so the workbook ends with two prices rather than one: 67,323 of equity on the seller's basis against 59,745 on the buyer's, a gap worth 0.69 turns of the purchase multiple.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

A buy-side quality of earnings review of a target's trailing twelve months, built at the monthly grain diligence is actually performed at rather than as an annual summary. The workbook takes a reported trial balance as its input - twelve months of profit and loss, balance sheet and bank activity, all editable - and produces the four deliverables a QoE report carries: a categorised bridge from reported to adjusted EBITDA, a run-rate normalisation, a proof of cash, and a net working capital peg. The signature mechanic is that each of the thirteen adjustments carries a diligence quality rating, and the rating selects a credit factor - 100% for fully documented items, 50% where the support rests on a management estimate, 25% for pro-forma claims that cannot be verified from the records. The credit is applied to addbacks only, because a buyer does not discount bad news, and that single asymmetry splits the model into two prices instead of one answer with a sensitivity around it. On the shipped base case a 60,526 revenue services business reports 8,275 of EBITDA at a 13.7% margin. Nine normalising adjustments worth 1,740 - owner compensation, related-party rent, ERP implementation and a legal settlement, net of deferred revenue cut-off, inventory count and unrecorded-liability deductions - lift it to 10,015. Four run-rate normalisations worth 913 annualise a mid-year price increase, contract wins and a headcount programme against a lost customer, reaching 10,928. Apply the credit factors and the buyer gets 10,036, an 892 gap worth 7,578 of enterprise value at the 8.50x letter-of-intent multiple, or 0.69 turns. The two blocks stay separate on purpose: a normalising adjustment says the reported number was wrong, while a run-rate normalisation concedes it was right and asks the buyer to pay for a period that has not happened yet, which is where most of the haircut correctly lands. The proof of cash reconciles reported revenue to bank deposits and cash operating costs to bank payments through the receivable, payable, inventory, prepaid, accrual and deferred revenue movements, opening off real prior-period balances so month one is not assumed to be zero. It leaves 85 of unexplained receipts variance across the year - 0.14% of revenue, within tolerance - but 86 of it sits in the final month, which is the finding. The working capital peg is struck as the twelve-month average of a normalised balance rather than the reported one: deferred revenue and the bonus accrual are lifted out of working capital precisely because they are taken as debt-like items in the price bridge, and a reclassification check row proves the two treatments never double-count, while an aged receivable reserve and the unrecorded liability are pushed in. The peg lands at 7,538 against a 9,173 closing balance, a 1,635 true-up the seller earns because closing receivable days have stretched to 72 from 58 over the period. The equity bridge then runs twice, taking enterprise value through reported net debt, 2,700 of debt-like items and the true-up, and because everything below enterprise value is identical in both columns the entire equity gap is the quality gap. Five validation rows tie the proof of cash, the category subtotals, the earnings bridge, the debt-like reclassification and the price impact to zero.

What every model includes

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

What's inside the Quality Of Earnings Model

  • Transaction and diligence terms: reporting period end, purchase multiple, reported net debt, and the credit factors for high, medium and low quality adjustments
  • Debt-like item balances: unrecorded liabilities, finance lease obligations and unpaid sales tax
  • Opening balances for receivables, inventory, prepaid, payables, accruals and deferred revenue, so month one's movement is real
  • Reported profit and loss: three revenue streams, two cost of sales lines and five operating expense lines, month by month
  • Reported balance sheet: six working capital balances plus an aged receivable reserve, at each month end
  • Bank activity: monthly cash receipts and cash disbursements per the statements
  • Nine normalising adjustments across owner, non-recurring, pro-forma and accounting categories, each with its own monthly profile
  • Four run-rate normalisations annualising a price increase, contract wins, a cost programme and a lost customer

Quality of Earnings Model: Diligence Workflow, Peg and Price Impact

A quality of earnings review tests what a target business actually earned in the trailing twelve months and how those findings move the purchase price. This model takes a reported monthly trial balance, re-states earnings through graded adjustments, proves reported flows against bank activity, and sets a working capital peg, producing a seller and a buyer view of equity value.

Rates and financial results described here reflect illustrative model settings, not industry benchmarks.

What Drives the Adjustment Schedule

The model separates thirteen adjustments into nine normalising items and four run-rate normalisations.

  • Normalising adjustments restate what was reported, covering areas such as owner compensation, related-party rent, one-off projects, legal costs, discontinued products and accounting true-ups.
  • Run-rate normalisations instead restate the period as if later changes, such as a price increase, new contract wins, cost actions or a lost customer, had applied for the whole year.
  • This distinction is deliberate: the two blocks answer different questions, and keeping them separate preserves the different weights a buyer may place on each.

How the Credit Factor Works

Each adjustment carries a category and a diligence quality rating. The rating resolves to a credit factor, so fully documented addbacks are credited at 100%, management-estimate items at 50%, and unverifiable pro-forma claims at 25%.

  • The credit is applied to addbacks only; deductions are taken in full. That asymmetry is central to the analysis because it prevents a buyer from discounting bad news.
  • The model therefore presents a seller view and a buyer view rather than a single answer, and the difference between them is the value of the quality gap.

Proof of Cash and Working Capital Peg

The monthly period axis supports the proof of cash, which reconciles reported revenue and costs to bank activity through receivables, deferred revenue, inventory, prepaid items, payables and accruals.

  • The LTM unexplained variance is small relative to revenue, and a check proves the reconciliation identity in every month.
  • Separately, normalised working capital adds deferred revenue and bonus accrual and subtracts unrecorded liabilities and an aged receivable reserve.
  • The peg is the twelve-month average of that line, with the closing balance compared against it.

From Earnings to Equity Value

Adjusted EBITDA bridges reported earnings to a normalised figure and then to run-rate views for seller and buyer.

  • The seller view applies run-rate normalisations in full, while the buyer view reflects credited addbacks only.
  • Enterprise value is calculated at the purchase multiple, then adjusted for net debt, debt-like items and the working capital true-up to reach equity value on each basis.
  • The difference between the two equity values is explained by the quality gap, and a check confirms it matches the value of the earnings at risk.
income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Formatted to IB standards

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Frequently asked

What is a quality of earnings analysis?+

A quality of earnings analysis is the diligence exercise that establishes what a target business actually earns, as distinct from what its accounts report. It normalises the reported result for owner-related, non-recurring and accounting items, annualises in-period changes onto a run-rate basis, tests whether the reported revenue and costs moved through the bank, and sets the working capital balance the purchase price will be adjusted against. It is performed before signing and it is about the past, not a forecast.

Why does the model produce two different EBITDA numbers?+

Because the seller and the buyer credit the adjustments differently. Every adjustment carries a diligence quality rating, and the rating selects a credit factor: full credit for fully documented items, half where the support rests on a management estimate, a quarter for pro-forma claims that cannot be verified from the records. The seller's run-rate EBITDA of 10,928 assumes every adjustment is credited in full; the buyer's 10,036 applies the factors. The 892 difference is the negotiating range.

Why is the quality credit applied only to addbacks?+

Because a buyer does not discount bad news. If a diligence provider finds an unrecorded liability or a deferred revenue cut-off error, the buyer takes the full deduction regardless of how well it is documented; it is only the seller's proposed addbacks that get haircut for weak support. The model implements that asymmetry with a guard on the credited column, which is why the buyer's total falls by 892 rather than by half of everything.

What is the difference between a normalising adjustment and a run-rate normalisation?+

They make different claims. A normalising adjustment says the reported number was wrong - the owner was overpaid, the ERP project was a one-off, the deferred revenue was cut off incorrectly. A run-rate normalisation concedes the reported number was right and asks the buyer to pay as though an in-period change had applied all year, such as a price increase that took effect in month eight. The model keeps them in separate blocks and separate subtotals, and most of the quality haircut correctly lands on the second.

How is the working capital peg set?+

As the twelve-month average of a normalised balance, not the reported one. Deferred revenue and the bonus accrual are lifted out of working capital because they are taken as debt-like items in the price bridge, and an aged receivable reserve and an unrecorded liability are pushed in. The peg lands at 7,538 against a closing normalised balance of 9,173, so the base case carries a 1,635 true-up in the seller's favour - a consequence of receivable days stretching from 58 to 72 across the period.

Why does the proof of cash not tie to exactly zero?+

Because it is not supposed to. The reconciliation identity itself ties to zero in every month, and the model carries a check row proving it. What is left over after the receivable, payable, inventory, prepaid, accrual and deferred revenue movements are taken out is the unexplained variance, and on the shipped case that is 85 across the year - 0.14% of revenue - with 86 of it concentrated in the final month. A variance sitting in one month is a finding; one spread evenly is usually noise.

Can I run this on my own target's numbers?+

Yes. The entire reported trial balance is an input block on the assumptions sheet: twelve months of revenue by stream, cost of sales, five operating expense lines, six working capital balances, an aged receivable reserve, and monthly bank receipts and disbursements, plus real opening balances. Paste your target's figures over them and the bridge, the proof of cash, the peg and both price columns recompute without touching a formula.

How does this differ from an EBITDA bridge model?+

An EBITDA bridge decomposes a movement in earnings between two periods into volume, price and mix. A quality of earnings review decomposes a single period's earnings between what was reported and what is defensible. Different axis entirely: one asks why this year differs from last year, the other asks whether this year's number is real.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview