Learn about the list of Sales and Profit variances, and where Price, Volume, Quantity and Mix fit in.
Learn how to explain precisely and accurately, the variances for Sales, Cost of Sales, Gross Profit and EBITDA.
Gross Profit (GP) margin and EBITDA margin walks! (Explain the variances in Profit margin percentage (%) and EBITDA % vs budget and vs previous period, and the impact of price, mix, volume and costs on variance $ and margin points (%).
Learn how to summarize the variance results and present them to management with easy to follow graphs/charts (EBITDA waterfall and several other visualizations)!
Learn how to create automated Excel templates for all variances and update as soon as new data replaces existing data (Great for monthly and weekly updates)!
Learn when to use Selling price, and when to use Profit as a base for variance calculations.
You will receive downloadable and solved income statement variance analysis Excel file, and powerpoint slides presented during the course.
Bonus lectures and updates based on Frequently Asked Questions from fellow finance professionals and students!
Welcome and Course outline (P&L and EBITDA analysis)
FREE PREVIEWCourse Slides - Income statement and EBITDA analysis
Solved Excel File - P&L and EBITDA analysis course (price, volume, mix, cost)
Practice File - Apply what you learn!
The example income statement for analysis
FREE PREVIEWThe profit variance hierarchy
FREE PREVIEWThe sample data for gross profit variance analysis
FREE PREVIEWAutomate variance calculation using Pivot Tables (Set and Forget 1)
FREE PREVIEWAutomate variance calculations using Pivot Table (Set and Forget 2)
FREE PREVIEWPivot Table fields and formatting for variance analysis (Set and Forget 3)
FREE PREVIEWSales price variance
FREE PREVIEWCost of sales variance
FREE PREVIEWIntro to Quantity variance
FREE PREVIEWHow to calculate Quantity variance
FREE PREVIEWFAQ: How to deal with new products or unbudgeted products in price volume mix analysis
FREE PREVIEWFAQ: Impact of variances - Profit vs Sales
FREE PREVIEWVolume and Mix Variance (formula and Key points to remember)
FREE PREVIEWHow to calculate Volume variance (impact on Gross profit)
FREE PREVIEWHow to calculate Volume variance (impact on Net Sales)
FREE PREVIEWHow to calculate Mix variance (Option 1)
FREE PREVIEWHow to calculate Mix variance (Option 2) - Recommended
Mix variance (impact on Net Sales)
How to create Net Sales variance bridge (sales walk)
FREE PREVIEWHow to create Gross profit variance bridge (Gross profit walk)
How to create EBITDA variance bridge (EBITDA walk)
How to create EBITDA variance bridge Part 2
How to create a Waterfall Chart in Excel
FREE PREVIEWIntro to Gross profit % and EBITDA % changes
FREE PREVIEWPercentage changes - How the math works!
Gross Profit % change (GP Margin (%) walk)
EBITDA % change (EBITDA margin (%) walk)
Income statement - Asking the right questions!
Presenting variances using waterfall charts
Presenting Price variances with charts
Charts and Graphs linked Excel file
Presenting Quantity variance
Presenting Mix variance
Presenting Gross profit and Gross profit margin (%)
Presenting Cost of sales expense
Presenting Selling and advertising expenses
Presenting General and admin expenses
Depreciation expense visualization
Clearly explain income statement variances, and present with confidence.
Add your email to the mailing list to get the latest updates.
