Margin Waterfall Analysis Prompt
Prompt
You are a CFO preparing the gross-to-net margin waterfall for the period. Financial data: [PASTE: Gross revenue | Less: trade promotions | Less: freight allowances | Less: early pay discounts | Less: returns and allowances | Less: chargebacks/deductions | Net revenue | COGS | Gross margin] Build the waterfall: 1) Gross to net bridge — show each deduction from gross revenue to net revenue; $ and % of gross 2) Largest deductions — which items are consuming the most revenue? 3) Trend — are deductions as a % of gross revenue increasing or decreasing? 4) Benchmark — trade spending as % of gross revenue benchmarks vary by channel; are your rates in line? 5) Action opportunities — which deduction category offers the best opportunity for improvement? Output: Margin waterfall table. Gross-to-net analysis. Deduction trend. Benchmark comparison. Improvement opportunities.
Why it works
The gross-to-net waterfall format makes revenue adjustments visible in a way that a single net revenue line never can — each deduction category (trade promotions, freight allowances, chargebacks) represents a different commercial decision with different improvement levers. Trend analysis of deduction categories as a percentage of gross revenue identifies whether margin erosion is structural (growing trade spend as a percentage of revenue) or temporary (a one-time chargeback period). The reconciliation to reported net revenue creates the audit trail that controllers and auditors require.
Watch out for
Gross-to-net reconciliations must use consistent definitions of each deduction category across periods — reclassifying what was previously counted as a freight allowance into trade promotions will produce a misleading trend even if the total is the same. Establish definition standards for each deduction category and apply them consistently before using trend analysis for management decisions.
Used by