Accountio / Templates / Financial due diligence / Quality of earnings workbook

Quality of earnings template in Excel for M&A

Work out what a business really earns before you agree a price: take reported EBITDA, add or take off each adjustment with its evidence, and carry the result through net debt and working capital to the equity price. This quality of earnings template is one Excel workbook covering three periods, with management's figure and yours side by side.

Finance teams
$19
In the pack
M&A financial due diligence
Files
4, Excel and Word
Buy the pack · $19
US library · 52 packs

Get this pack and 51 more for $79

Financial due diligence · this packBookkeeping and advisory lettersAudit and AUP lettersBook-to-tax reconciliationCompilation and review lettersIndependent contractorsCPA verification letters1040 checklistsIRS notices+ 43 more
$79$69889% off
Buy the US library · $79

Want every pack, for every region? Global library, 110 packs, $99

What the workbook looks like

Quality of earnings workbook template
What the workbook coversSheet or line in the workbook
Deal details and period names
✓
SettingsTarget, currency, two financial years and a trailing 12 months, the last balance sheet date and the headline enterprise value
Reported EBITDA
✓
EBITDA bridgeOperating profit plus depreciation and amortisation, checked against the management accounts
Every adjustment with its evidence
✓
AdjustmentsCategory, put forward by management or diligence, status, amount for each period and evidence reference
Adjustment categories
✓
SettingsNon-recurring items, owner and related-party costs, out-of-period items, policy and cut-off, run-rate and pro forma, reclassifications
Your figure against the seller's
✓
Diligence-adjusted EBITDA, Management-adjusted EBITDAAccepted adjustments only, against every adjustment management put forward, and the gap between them
What is still open
✓
Adjustments still under reviewAdjusted EBITDA if every open item is accepted
Net debt and debt-like items
✓
Net debtCash, bank loans, owner loans, leases, unpaid tax and bonuses, deferred consideration and provisions, with restricted cash kept out
The working capital peg
✓
Working capital24 month-end balances, normalisation adjustments and the average of the trailing 12 months
The true-up at completion
✓
Working capitalCompletion estimate against the peg, then the final completion accounts against the estimate
From enterprise value to equity price
✓
SummaryLess net debt and debt-like items, plus the true-up, with the multiple of adjusted EBITDA and a Check line

When you need a quality of earnings analysis

A quality of earnings analysis tests whether the profit a seller reports is recurring and supported, by adjusting reported EBITDA for one-off, out-of-period and owner-related items. Buyers use it to check the price, and sellers use it to prepare for questions. Use this one when:

  • You are buying a company and the price is a multiple of EBITDA
  • The seller's information memorandum shows an adjusted EBITDA you need to test line by line
  • You are preparing your own business for sale and want to answer the buyer's adjustments first
  • The purchase agreement adjusts the price for net debt and working capital at completion

How to use the quality of earnings template

  1. Fill in Settings. Name the target and the three periods, enter the last balance sheet date, the first of the 24 working capital months and the headline enterprise value.
  2. Enter the reported figures. Revenue, operating profit, depreciation and amortisation for each period from the accounts. Add the management accounts EBITDA to check the opening figure.
  3. List every adjustment. One row each, with a category, who put it forward and the evidence. Mark each one Accepted, Under review or Rejected.
  4. Build net debt and the peg. Enter each balance once. An item taken off the price is set to No in working capital, so nothing is counted twice.
  5. Read the Summary. Check adjusted EBITDA, the equity price and the Check line, which says OK only when every sheet is complete.

Questions

What is a quality of earnings report?

A report for a buyer or seller of a business on how much of the reported profit is recurring. It starts from reported EBITDA, lists each adjustment with its reasons and evidence, and usually covers net debt and working capital as well.

What is the difference between quality of earnings and an audit?

An audit gives an opinion on whether the annual accounts give a true and fair view. A quality of earnings review asks a different question: what the business earns on a normal, recurring basis, so a buyer can set a price.

What is adjusted EBITDA?

Reported EBITDA after taking out items that will not recur or do not reflect the business going forward, such as restructuring costs, an owner's salary above the market rate or income booked in the wrong year.

What is a working capital peg?

The normal level of working capital the buyer expects to receive with the business, often the average of the last 12 month ends. If working capital at completion is above the peg the price goes up, and if it is below the price goes down.

What are debt-like items?

Amounts that are not bank debt but will cost the buyer cash after completion, such as tax owed for earlier periods, unpaid bonuses, deferred consideration or overdue supplier invoices. They are taken off the price alongside net debt.

Also in the m&A financial due diligence

Due diligence request checklistFinancial due diligence findings report

See the whole pack →

Who it's for

Finance teams and advisers buying a company, and finance directors preparing a business for sale.

Last checked

Checked against the Companies Act 2006 auditor's report rules in November 2026.