Price-Volume-Mix Analysis (3-Year Trend) template
Price, volume, mix and interaction effects across three consecutive periods, with a chained three-period revenue bridge.
Available in the ZAF Template Library: search, click Insert, and the schedule lands in your workbook with live formulas.
- Three periods of units and revenue by product
- Year-on-year PVM for each pair of periods
- Chained three-period revenue bridge
- Product-level drivers of growth
Why it matters in due diligence
The 3 year price volume mix analysis schedule is one of the analyses a buyer, lender or investment committee expects in a financial due diligence report. Built by hand, it means recreating the same layout, formulas and checks on every engagement. The ZAF version is formula-driven, so every number traces to an input cell and the checks tell you when something does not tie.
Build it from your trial balance instead
Inside ZAF Tools, Import and Map TB, AI Map and Build FS create the statements this schedule draws on. Run Full FDD then produces statements, commentary and management questions in one pass. See how Build financial statements works, or calculate the hours saved.
Comparing tools? See ZAF Tools vs Macabacus.
More from the template library
Insert this template from the ZAF ribbon
Book a 30-minute live demo on your own trial balance, or request a trial for your team.