Price-Volume-Mix Analysis template
Decomposes the revenue variance between two periods into price, volume, mix and interaction effects, by product.
Available in the ZAF Template Library: search, click Insert, and the schedule lands in your workbook with live formulas.
- Units and revenue by product for two periods
- Price effect
- Volume effect
- Mix and interaction effects
- Revenue bridge chart
Why it matters in due diligence
The 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.