Articles

How much does an inventory obsolescence shortfall cut EBITDA and the price?

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.

The assumptions

Illustrative manufacturer, $ million at cost, year end FY2025
ItemValue
Inventory at cost6.00
Obsolescence reserve booked by the company at year end0.18
Reserve booked a year earlier0.16
Reserve the buyer's policy would have required a year earlier0.44
Reported EBITDA5.20
Price multiple8.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.

Step 1: the reserve the ageing implies

Reserve by age of stock
AgeInventoryReserve rateReserve required
0-90 days3.600%0.000
91-180 days1.205%0.060
181-365 days0.8025%0.200
Over 365 days0.4075%0.300
Total6.009.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.

Step 2: separate the EBITDA effect from the balance sheet effect

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.

Movement in the shortfall
Line$ million
Opening shortfall (0.44 − 0.16)0.28
Closing shortfall (0.56 − 0.18)0.38
Charge missing from FY2025 EBITDA0.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.

Step 3: the balance sheet side

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.

What if: the over-365-day stock is reserved at 50%, not 75%

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.

The common mistakes

Takeaway

Questions readers ask

How do you size an inventory obsolescence reserve in due diligence?

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.

Does the whole shortfall reduce EBITDA?

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.

Can the buyer claim the shortfall twice, in the price and in the peg?

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 workbooks behind this article

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.

Open the companion files →

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

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