Articles

How much does an unrecorded customer rebate accrual cut EBITDA and the price?

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.

The assumptions

ItemValue
Unrecorded rebate shortfall at year end, 2022 / 2023 / 2024 / 20250.2 / 0.5 / 1.0 / 1.7
Reported EBITDA, FY2023 / FY2024 / FY202519.6 / 21.0 / 21.8
Revenue, FY2023 / FY2024 / FY2025168.0 / 181.5 / 194.2
Multiple of the letter of intent9 times
Agreed enterprise value$204 million
Shortfall built up in Q1 2025 / Q1 20260.4 / 0.5
US$ million. The shortfall is the rebate earned by customers on the year’s sales and not accrued. It accumulates until it is paid or booked.

Step 1: the charge for each year

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.

Step 2: earnings and margins on an earned basis

Subtract each year’s charge from reported EBITDA:

Reported EBITDAShortfall, year endChargeEBITDA, rebate onlyReported marginEarned-basis margin
FY202319.60.50.319.311.67%11.49%
FY202421.01.00.520.511.57%11.29%
FY202521.81.70.721.111.23%10.87%
US$ million. Only the rebate adjustment is applied; the other diligence adjustments in the case are separate.

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%.

Step 3: what it does to the price

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.

Step 4: the liability already built up

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.

What if the multiple or the run-rate were different?

The common mistakes

Takeaway

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.

Reproducing it in the workbook

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.

Questions readers ask

How do you adjust EBITDA for an unrecorded rebate accrual?

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.

How much does the adjustment reduce the price?

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.

Why not capitalise the whole accumulated shortfall at the multiple?

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.

The workbooks behind this article

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.

Open the companion files →

Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: corporate finance, valuation and markets → · All 1908 articles →