Learn how to use pricing analysis to maximize firm profits with scenario analysis, price optimization, and data analytics in Excel.
Overview
Syllabus
Introduction
- Build effective pricing models with Excel
- Practical considerations in pricing
- What price matters
- Models of pricing
- Supply and demand
- Optimizing price in business
- Assessing price in a scenario
- Gathering data to set pricing
- Pricing in practice
- Demand curves and business
- Estimating linear and power demand curves
- Estimating profit-maximizing price with Goal Seek
- Optimization and scenario analysis
- Advanced analytics tools
- Fundamentals of price discrimination
- Price elasticity
- Estimating price elasticity
- Determining feasible degrees of price discrimination
- Calculating profitability under price discrimination
- Price discrimination with multiple variables
- Applied pricing discrimination
- Price differentiation and marketing attribution
- Business forecasting
- Assessing the impact of competition
- Scenario analysis in pricing
- Variance analysis walks and pricing
- Building variance waterfalls
- Best practices in pricing
- Tools for pricing
- Continue using Excel for pricing analytics
Taught by
Michael McDonald