A flat reserve on slow stock leaves a shortfall in the balance sheet, and only part of it is an EBITDA adjustment.
On $6.00 million of inventory, an age-based reserve requires $0.56 million against $0.18 million booked, a $0.38 million shortfall. Of that, $0.10 million arose in FY2025 and lowers EBITDA from $5.20 million to $5.10 million, worth $0.80 million of price at 8.0 times; the remaining stock sits in working capital and is claimed through the peg only if the peg is on a reported basis.
| Item | Value |
|---|---|
| Inventory at cost | 6.00 |
| Obsolescence reserve booked by the company at year end | 0.18 |
| Reserve booked a year earlier | 0.16 |
| Reserve the buyer's policy would have required a year earlier | 0.44 |
| Reported EBITDA | 5.20 |
| Price multiple | 8.0x |
The company holds a flat reserve of 3.0% of inventory. The buyer’s accountants propose a reserve that rises with the age of the stock, because slow stock converts to cash at a lower and lower value.
| Age | Inventory | Reserve rate | Reserve required |
|---|---|---|---|
| 0-90 days | 3.60 | 0% | 0.000 |
| 91-180 days | 1.20 | 5% | 0.060 |
| 181-365 days | 0.80 | 25% | 0.200 |
| Over 365 days | 0.40 | 75% | 0.300 |
| Total | 6.00 | 9.3% | 0.560 |
Reserve required = Σ (inventory in each age band × reserve rate of that band)
Excel: =SUMPRODUCT(Inventory, Rate)
The required reserve is $0.56 million, 9.3% of inventory. The company has booked 0.18, so the shortfall is 0.56 − 0.18 = $0.38 million.
The shortfall is a stock built over several years. Only the part that arose in the year is a charge to this year’s EBITDA; the opening shortfall belongs to earlier years and sits in the balance sheet.
| Line | $ million |
|---|---|
| Opening shortfall (0.44 − 0.16) | 0.28 |
| Closing shortfall (0.56 − 0.18) | 0.38 |
| Charge missing from FY2025 EBITDA | 0.10 |
EBITDA falls from 5.20 to 5.10, down 1.9%. At 8.0 times the price falls by 0.10 × 8 = $0.80 million.
The closing shortfall of $0.38 million overstates inventory, and therefore net working capital. If the peg was set on reported working capital, the buyer takes delivery of 0.38 less real value than the peg assumes and claims it in the completion adjustment. If the peg is built on adjusted figures, the same shortfall is already in it and nothing is claimed twice. The check is which basis the peg uses.
On a reported-basis peg, the two channels add to 0.80 + 0.38 = $1.18 million of value, 2.8% of the $41.60 million headline price.
The seller argues that its oldest stock still sells to a niche customer at half of cost. The required reserve becomes 0.560 − 0.4 × (0.75 − 0.50) = $0.46 million and the shortfall $0.28 million. That 25-point change in one rate moves the shortfall by 0.10, or 26.3% of it; the ageing policy is where the negotiation happens.
Group the stock by age, apply a reserve rate that rises with age to each band and add the results. On $6.00 million of inventory the example needs $0.56 million.
No. Only the increase in the shortfall during the year does: $0.38 million at year end less $0.28 million a year earlier is $0.10 million. The rest is a cumulative balance sheet item.
Not for the same dollar. A $0.10 million EBITDA charge is capitalised at the multiple; the $0.38 million stock is claimed through working capital only if the peg was set on reported figures.
The free companion files for The Financial Due Diligence Associate rebuild a fictional buy-side quality of earnings engagement, with net debt, the working capital peg and the closing statement, and an editable toolkit for transaction services work. The inventory reserve in this article uses invented figures and is not in them. No account and no email address.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: corporate finance, valuation and markets → · All 1908 articles →