Where the profit leaks: an earnings shock, one bar at a time
A one-minute painted walk through this diagnostic's waterfall: how a sales dip, dearer milk, heavier marketing and write-downs pull a dairy company's operating profit below its target.
Read the narration
This diagnostic asks how far a dairy company's profit can fall short of plan. It starts from one thousand six hundred seventy-five million New Zealand dollars of sales at a fifteen and a half percent margin: about two hundred sixty million of operating profit. First, volume. The default shock trims sales by four percent. At a blended gross margin near forty percent, that costs about twenty-seven million. Then the costs pile on. A twelve percent premium on raw milk takes forty-eight million. Marketing at eighteen and a half percent of sales, against a sixteen percent norm, takes forty more. Inventory provisions take fourteen. Add it up and operating profit lands near one hundred thirty million. That's an eight percent margin, and about ninety-four million after tax. Channel mix is the lever that pushes back. China label formula earns forty-eight percent, local liquid milk only twenty-six, so shifting sales toward China label lifts the whole blend. Remember, this is a stress test: every lever counts as extra cost on top of the plan. Try the Margin Recovery Path preset and watch profit climb back to its target.
What the model assumes, and what to check in the real accounts
It starts from the target, not from last year
The tool takes NZ$1,675M of planned revenue at a 15.5% EBIT margin (NZ$259.6M) and subtracts each shock. With defaults it lands at NZ$130.1M EBIT, an 8.1% margin, NZ$93.7M after a flat 28% tax. The page's static placeholder (13.2%, NZ$221.1M) is replaced by these live numbers as soon as it loads.
Every lever is treated as extra cost
The full 12% farmgate premium (applied to an assumed 42% raw-milk share of cost of goods), every point of marketing above 16% of sales and all provisions are counted as new drag on top of the plan. A real plan would already budget some of these, so the tool's miss is a deliberately harsh stress case.
Mix is a weighted average
Each channel carries a fixed gross margin: China label 48%, cross-border e-commerce 41%, daigou resellers 34%, ANZ liquid milk 26%. The default mix equals the baseline, so its bar is zero; moving share toward higher-margin channels adds profit in proportion to sales.
Daigou is an informal channel
Daigou are individual resellers who buy products such as infant formula abroad for customers in mainland China. The channel shrank sharply around 2020, which is why the tool includes a Daigou Collapse preset.
Compare with reported results
The tool's NZ$1,675M base is in line with the company's reported FY2024 revenue of roughly NZ$1.7 billion. For actual margins, segment mix and guidance, use the company's own annual reports and NZX/ASX announcements rather than this model.
Try it in the tool
Click Margin Recovery Path and watch Operating EBIT move from about NZ$130M to about NZ$266M.
Drag A2 Farmgate Raw Milk Premium Surcharge from 12% to 26% and see the Milk Premium bar roughly double.
Move ten points from ANZ Liquid Milk (%) to China Label MBS (%) and watch the Channel Mix bar turn positive.
Definition of EBIT, the operating profit measure the waterfall tracks.
Figures in the video come from this tool's built-in model and default inputs; it is an illustrative stress test, not a forecast of any company's results or investment advice.
How do channel mix shifts, raw milk surcharges, and inventory provisions combine to alter a2 Milk's simulated EBIT in this diagnostic waterfall?
This diagnostic simulates operating earnings (EBIT) starting from a target base of NZD $1,675.0M revenue and a 15.5% EBIT margin (NZD $259.625M target EBIT). When initialized, the baseline model applies a -4.0% volume contraction shock, a 12.0% farmgate milk premium surcharge on raw milk COGS, 18.5% marketing reinvestment, and NZD $14.0M in channel inventory provisions, driving simulated revenue to NZD $1,608.0M and operating EBIT down to NZD $130.1M (an 8.1% margin). The waterfall decomposes this NZD $129.5M shortfall across five discrete cost and revenue variance components.
All gross margin percentages (48% MBS, 41% CBEC, 34% Daigou, 26% ANZ), the 42% raw milk weighting in COGS, the 16.0% target marketing intensity baseline, and tax rate assumptions are hardcoded simulation fixtures rather than certified audited segment filings. They serve as an educational diagnostic model rather than real-time trading forecasts.
Try a worked example
Click the scenario preset chip labeled 'Daigou Collapse (-80% Vol)'. The script shifts channel weights to 44% MBS, 34% CBEC, 2% Daigou, and 20% ANZ, deepens the volume shock to -9.0%, and increases inventory provisions to NZD $28.0M. The top KPI cards immediately update to display Simulated Revenue of NZD $1,524.3M, an Operating EBIT of NZD $93.1M, and an EBIT margin of 6.1% (-939 bps vs the 15.5% target).
Model Mechanics & Variance Bridge
The waterfall model calculates variance relative to a target EBIT of NZD $259.625M (1675.0M * 15.5%). Volume contraction reduces gross profit by (Actual Revenue - Target Revenue) multiplied by the baseline weighted gross margin (39.54%). Channel mix variance captures the shift in normalized gross margin against baseline gross margin across MBS, CBEC, Daigou, and ANZ. Cost of goods sold (COGS) is charged a surcharge equal to COGS * (farmgate_premium / 100) * 0.42. Marketing drag deducts actual marketing spend above 16.0% of revenue, and provisions directly subtract channel inventory write-downs.
Sensitivity Matrix Interpretation
The sensitivity matrix displays simulated EBIT across volume shock intervals (-10% to +5%) and raw milk surcharges (+5% to +28%). Cells highlight severe operating compression below NZD $180M in red, intermediate margins below NZD $230M in gold, and resilient scenarios in green, framing the compounding risk of commodity inflation and demand contraction.