Revenue Growth Without Cash: A Distributor's Quality of Earnings
Northline Industrial Supply reports FY revenue of $480 million, up 18% from $407 million. Gross margin fell to 31.2% from 32.8%. Days sales outstanding rose to 67 from 45, and inventory days rose to 102 from 78. Cash flow from operations was $21 million against net income of $52 million; capital expenditures were $8 million. Management attributes growth to new big-box customers and says extended payment terms are temporary. The receivables allowance is 1.2% of gross receivables versus a 2.5% historical average. Northline also capitalized $6 million of software implementation costs as an intangible this year, up from $1 million last year, and now reports adjusted EBITDA that adds back restructuring and “transition” costs. The company has a $250 million revolver with a 3.5x EBITDA covenant and is negotiating a covenant reset. A credit analyst must decide whether to recommend a waiver.
1. Compute the cash conversion ratio and quantify the working-capital drain. Identify the three most important red flags in the revenue and expense recognition policies.
Read the worked answer
Cash conversion: CFO/net income = $21m/$52m = 0.40x, versus roughly 1.0x or better for a healthy distributor. Using revenue/365 = $1.315m per day, DSO of 67 days implies receivables of about $88m. At the old 45-day DSO, receivables on the new revenue base would be about $59m, so roughly $29m of additional receivables are funding growth. COGS is 68.8% of $480m, or $330m; inventory days of 102 imply inventory of about $92m, versus about $71m at 78 days-another $21m absorbed. Together, working capital absorbed roughly $50m, which explains the CFO/NI gap.
Red flags: (1) Receivable growth outpaces revenue growth by a wide margin, suggesting either looser credit terms or revenue recognition ahead of cash collection; the declining allowance despite a 22-day DSO increase looks like under-reserving. At a 2.5% allowance on $88m, the allowance would be $2.2m versus $1.05m reported-about $1.15m pre-tax understated. (2) Inventory days rising from 78 to 102 while gross margin falls is consistent with obsolete stock, price concessions, or channel stuffing; inventory growth needs to be tested against subsequent sell-through. (3) Capitalized software rising from $1m to $6m and expanding “adjusted EBITDA” addbacks shift costs out of current earnings. If the $6m were expensed, pre-tax income would fall by $6m. An analyst should treat capitalized implementation costs as operating unless clearly recoverable and should compare adjusted EBITDA with CFO.
2. Adjust net income for the allowance shortfall and the capitalized software, and explain whether the adjusted figure changes the covenant conclusion.
Read the worked answer
Start with reported net income of $52m. The allowance shortfall is about $1.15m pre-tax; at a 25% tax rate, the after-tax effect is about $0.86m. The $6m of capitalized software, if expensed, reduces pre-tax income by $6m; after tax at 25%, net income falls by $4.5m. Adjusted net income is approximately $52m − $0.86m − $4.5m = $46.6m. That is still positive, but it is 10% below reported earnings and, more importantly, CFO remains only $21m.
For covenant purposes, EBITDA adjustments matter more than net income. If the $6m software spend is treated as an operating expense rather than capex, EBITDA falls by $6m. If the allowance is increased, bad-debt expense rises by about $1.15m and EBITDA falls by that amount unless the company adds it back. A lender should also deduct the $29m receivables build and $21m inventory build from any “cash EBITDA” calculation. The covenant conclusion: reported EBITDA may pass 3.5x, but adjusted EBITDA including the software expense and a normalized bad-debt charge likely cuts headroom materially. The analyst should require a 13-week cash-flow forecast, aging schedules, and a borrowing-base availability test before recommending a waiver.
3. List the follow-up analyses and questions you would require before relying on management's “temporary terms” explanation.
Read the worked answer
Follow-up should reconcile the revenue story with cash and collateral. Request: (1) receivables aging by customer and by invoice date, plus subsequent cash collections through the latest possible date; (2) top-10 customer concentration, credit terms, rights of return, and side agreements; (3) inventory by SKU with sell-through and obsolescence reserves; (4) a bridge from gross revenue to cash collected, separating price, volume, and terms; (5) documentation for the capitalized software, including useful life and recoverability; (6) the covenant calculation as defined in the credit agreement, not the company's adjusted metric.
Key questions: Are new big-box customers receiving extended terms that are truly temporary, or are they permanent price/terms concessions? Has revenue been recognized before customer acceptance or on consignment? Why did the allowance ratio fall while DSO rose? What portion of inventory is more than 90 days old? If terms normalize, what happens to the revolver draw? The analyst should also test a downside case in which DSO stays at 67 days and inventory days stay at 102-under that case, CFO may be negative, and the covenant reset should be priced as a distressed amendment rather than a routine waiver.