Build a robust financial model comparing three consolidation options for [Company]: (1) retire [Brand A], (2) endorse under [Brand B], (3) dual-brand for [Timeframe]. Estimate cannibalisation, trial, repeat, and price realisation by channel in [Region]. Include one-offs, ongoing synergies, and working capital effects. Deliver NPV, IRR, payback, and sensitivity (±[Variance %] on key assumptions).
Output format:
Assumption sheet with sources and confidence levels.
P&L and cash flow by quarter for 12/24/36 months.
Tornado chart description of top 10 sensitivities.
Decision criteria table (Metric, Threshold, Option Win).