Rebates earned by customers through the year but not accrued flatter EBITDA in the year and leave a liability behind. Diligence counts both, and counts each once.
The target’s unrecorded rebate shortfall grew from $1.0 million to $1.7 million in FY2025, so the earned-basis charge for the year is $0.7 million and EBITDA of $21.8 million becomes $21.1 million. At the 9 times used for the deal, that is $6.3 million of enterprise value, 3.1% of the agreed $204 million. The $1.7 million already built up is a separate cost, owed to customers in cash.
Volume rebates are paid to customers who pass a purchase threshold, and they are earned as the sales are made. A company that books them only when they are invoiced, or at a rate lower than the one customers will reach, overstates profit in the year and understates liabilities. This article follows the Quellmark target in the book.
| Item | Value |
|---|---|
| Unrecorded rebate shortfall at year end, 2022 / 2023 / 2024 / 2025 | 0.2 / 0.5 / 1.0 / 1.7 |
| Reported EBITDA, FY2023 / FY2024 / FY2025 | 19.6 / 21.0 / 21.8 |
| Revenue, FY2023 / FY2024 / FY2025 | 168.0 / 181.5 / 194.2 |
| Multiple of the letter of intent | 9 times |
| Agreed enterprise value | $204 million |
| Shortfall built up in Q1 2025 / Q1 2026 | 0.4 / 0.5 |
The balance at the end of each year is the stock of unrecorded rebate. The charge for a year is how much that stock grew:
Earned-basis charge = shortfall at year end − shortfall at the previous year end. In Excel: =-(D19-C19), entered as a negative adjustment to EBITDA.
FY2023: 0.5 − 0.2 = 0.3. FY2024: 1.0 − 0.5 = 0.5. FY2025: 1.7 − 1.0 = 0.7. The charge is rising by about 0.2 a year: 0.3, 0.5, 0.7.
Subtract each year’s charge from reported EBITDA:
| Reported EBITDA | Shortfall, year end | Charge | EBITDA, rebate only | Reported margin | Earned-basis margin | |
|---|---|---|---|---|---|---|
| FY2023 | 19.6 | 0.5 | 0.3 | 19.3 | 11.67% | 11.49% |
| FY2024 | 21.0 | 1.0 | 0.5 | 20.5 | 11.57% | 11.29% |
| FY2025 | 21.8 | 1.7 | 0.7 | 21.1 | 11.23% | 10.87% |
FY2025 EBITDA falls by 0.7 ÷ 21.8 = 3.2%, and the margin from 11.23% to 10.87%. Growth is flattered too: from FY2023 to FY2025 reported EBITDA compounds at 5.46% a year, the earned-basis figure at 4.56%.
The LOI priced the company at 9 times EBITDA, so every dollar of recurring EBITDA is worth $9:
Price effect = annual charge × multiple. In Excel: =B1*B2.
0.7 × 9 = $6.3 million, or 3.09% of the agreed enterprise value of $204 million. The shortfall is a recurring cost, since it grows with sales, so it belongs in run-rate earnings and is capitalised.
The charge is the run-rate. The stock of $1.7 million at the end of FY2025 is a separate item: it is rebate earned by customers on past sales and not yet paid, and it comes out of cash after the deal. It reduces the price once, by $1.7 million, dollar for dollar and not at 9 times. In the book’s net debt schedule the rebates owed are listed at 2.3 (0.6 accrued at the base rate plus the 1.7 unrecorded) with the agreed flag set to 0, and the month-end working capital carries a separate rebate adjustment column. Whichever route is chosen, the same dollar must not appear in both.
An unrecorded rebate has two prices. The annual charge, here $0.7 million, reduces EBITDA to $21.1 million and the price by $6.3 million at 9 times. The accumulated shortfall, here $1.7 million, is a cash liability that reduces the price once, dollar for dollar. Compute the change in the shortfall each year, subtract it from EBITDA, multiply by the deal multiple, and put the stock through net debt or working capital, not both. For the full bridge from reported to diligence-adjusted EBITDA, see The Financial Due Diligence Associate.
The inputs are in FDD_Quellmark_Model.xlsx: the Inputs sheet holds the shortfall by year end (row 19), reported EBITDA and revenue (rows 7 and 9), the LOI multiple and the agreed enterprise value (rows 47 and 48) and the quarterly shortfall (row 34). The QoE sheet has a volume rebate shortfall line on an earned basis for FY2023, FY2024, FY2025, the two first quarters and the twelve months to March 2026. The margin table and the price effect above are not in the workbook; they use the same inputs.
Subtract the growth in the unrecorded shortfall during the year. Here the shortfall grew from 1.0 to 1.7, so FY2025 EBITDA of 21.8 becomes 21.1.
The annual charge times the multiple: 0.7 × 9 = $6.3 million. The accumulated shortfall of 1.7 reduces the price once, dollar for dollar, through net debt or working capital.
Because it is a one-off liability for rebates already earned, not a recurring cost. At 9 times it would take $15.3 million off the price, 2.4 times the recurring effect.
Every figure above is built from the inputs in the free companion files for The Financial Due Diligence Associate, which also hold the full quality of earnings bridge, the revenue analysis, net debt, the working capital pegs, the closing statements and capex. No account and no email address.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: corporate finance, valuation and markets → · All 1908 articles →