Module I· Working Capital & NWCIntermediate
Question
How does seasonality affect working-capital modeling?
Answer
Mechanics
seasonal businesses show large intra-year NWC swings that are hidden in year-end snapshots. Examples:
- Toys (Mattel, Lego): a Q4 sales peak means an AR peak in December/January, then a cash inflow in February — year-end AR overstates the steady state by 30–50%.
- Construction / heating equipment (HVAC manufacturers): a Q3–Q4 delivery peak, low activity in Q1 — year-end inventory above average.
- Agricultural machinery / seeds: a Q1–Q2 spring season — year-end inventory is a seasonal build.
- Travel / hotels: advances drive deferred revenue seasonally. Modeling approach: (a) a 12-month rolling average instead of a year-end snapshot. (b) quarterly modeling for liquidity / covenant stress. (c) in DD: 24 monthly data points as a plausibility check.
Deep diveShow more details
Pitch tip
'reported year-end NWC overstates the steady state by 25% because of the seasonal Q4 sales concentration; the LTM average of 18% of sales is the right valuation basis'.