
Last version published: 08/02/2021 07:59
Publication number: ELQ-20434-9
View all versions & Certificate

Price Volume Mix Analysis (PVM) excel template with Charts - Sales mix and Gross Profit by Product
Price volume mix analysis (PVM) excel template to better understand your sales and improve pricing strategy.
Further information
Give a strong and automated tool to analyse revenue and gross profit change on a product by product level and efficiently understand the impact of the change in price, change in volume and change in mix on your top line and your gross profit.
A business with multiple products. Retail, marketplace, services companies.
If you are using a microsoft excel version older than 2016
Reviews
4.9 / 5 (18 votes)- 89%
- 11%
- -
- -
- -
Write a review
- Nice toolReally helps us understand where our growth is and improve our pricing strategy! Highly recommend
- Very helpfulI have been using it on a daily basis. Saves time and makes my life a lot easier. Very good value for money, will definitely recommend it.
- Real time saver!This tool became a staple in my daily workflow. A real time saver. Highly recommend it
- GreatAmazing analysis tool!
People using this Best Practice also downloaded
More Best Practices from Pierre-Alexandre HEURTEBIZE
Multiple investing rounds Cap Table
Cap table for capital raise / buy in - by out and investor IRR and investment multiple forecast1,783Discussadd_shopping_cart$15.00by HEURTEBIZE
Multiple rounds Cap Table including Safe, pro-rata rights and Management Option Pool
Multiple rounds cap table including SAFE conversion, Management option pool and investment performance (IRR) 3 scenarios651Discussadd_shopping_cart$39.00by HEURTEBIZE
Due Diligences Excel Template - P&L starter pack
Starter Pack Template for Financial Due Diligence - P&L934Discussadd_shopping_cart$35.00by HEURTEBIZE
Inventory Management and Analysis best practice with dynamic charts
Inventory Management and Analysis best practice. Useful to the Management team as well as to external financial analyst.9691add_shopping_cart$29.00by HEURTEBIZE
Discounted Cash Flow (DCF) and Comparables Valuation Model
Discounted Cash Flow analysis of your business and compare it to a valuation comparables.475Discussadd_shopping_cart$49.00by HEURTEBIZE
DSO - DPO - DIO computation and graph - Countback method (Includes countforward method!)
DSO (Days Sales Outstanding)/ DPO (Days Payable Outstanding)/ DIO (Days Inventory Outstanding) charts countback method.962Discussadd_shopping_cart$35.00by HEURTEBIZE
Due Diligence Excel Best Practice - Balance Sheet starter pack
Starter Pack Best Practice for Financial Due Diligence - Balance Sheet720Discussadd_shopping_cart$39.00by HEURTEBIZE
Advanced multiple rounds Cap Table Model including SAFE an Management pool with 4 different structures
Multiple rounds cap table including SAFE conversion, Management option pool and performance (IRR) with 3 deal structures145Discussadd_shopping_cart$59.00by HEURTEBIZE
Simple Startup and SME Forecast Business Plan
A projection Model for startup and SME to forecast a complete P&L, Net Working Capital and Cash flow.326Discussadd_shopping_cart$19.00by HEURTEBIZE
P&L Due Diligence - Exhaustive Revenue Analysis model
Model for in depth understanding of high level P&L and Revenue Analysis. Big-4 like book of due diligence analyses.71Discussadd_shopping_cart$149.00by HEURTEBIZE
P&L (Profit & Loss) Constant Currency Analysis Excel Model
Best practice to assess the impact of FX on a P&L for a business trading in different currencies1,0962add_shopping_cart$15.00by HEURTEBIZE
Scorecard - Scoring and Valuation Model
Scorecard / scoring model to help valuation, target assessment and visually see strengths and weaknesses of a business143Discussadd_shopping_cart$19.00by HEURTEBIZE
Discussion feed for Price Volume Mix Analysis (PVM) Excel Template With Charts - Sales Mix And Gross Profit By Product
The user community and author are here to help. Go ahead!