Build a Pricing Model
This guide shows how to build a pricing model in Model Reef that lets you test different price points, discount strategies and mix, and see how these flow into revenue, margin, cash and valuation.
What you will build
Drivers for price per unit by product, plan or segment.
Revenue variables that respond to price changes and volume assumptions.
A view of gross margin under different pricing strategies.
A way to compare pricing scenarios through separate models.
Create price drivers
In the Data Library:
Create Economic drivers for key prices, for example:
Price per Unit - StandardPrice per Unit - PremiumSubscription Fee - Basic
For each price driver:
Set current price levels.
Define escalation rules if you expect regular price increases.
Optionally define promotional periods where price is discounted.
These drivers are the main levers you will move when exploring pricing.
Link revenue variables to price drivers
Ensure your Revenue variables reference price drivers explicitly.
For example:
Revenue - Standardmight be:Units - Standard × Price per Unit - Standard
Revenue - Premiummight be:Units - Premium × Price per Unit - Premium
If your revenue variables do not yet use such formulas, update them to reference the new price drivers.
Now price and units are cleanly separated.
Model discounting or promotional pricing
If you run discounts or promotions:
Create Modifier drivers for discounts, for example:
Discount Rate - Seasonal Sale
Adjust revenue formulas to incorporate discount factors, for example:
Effective price = Base price × (1 minus Discount driver)Schedule the discount driver values to be non zero only during relevant periods.
This yields time bound pricing changes that flow into revenue and margin.
Review gross margin under different prices
Gross margin is driven by revenue and COGS.
Ensure COGS variables are also linked to unit or volume drivers.
Open P&L and focus on:
Revenue by product or segment.
COGS by product or segment.
Gross Profit and Gross Margin.
When you adjust price drivers, observe how:
Revenue changes through volume times price.
COGS changes if volume changes.
Gross margin ratio moves.
Use charts for margin versus time under different pricing assumptions.
Build and compare pricing scenarios
To explore alternative strategies, create separate models, for example:
Model - Pricing - CurrentModel - Pricing - Moderate IncreaseModel - Pricing - Aggressive IncreaseModel - Pricing - Discount Led Growth
In each model:
Adjust price drivers.
Optionally adjust unit drivers to reflect expected demand elasticity.
Leave other assumptions constant where possible.
Compare across models:
Revenue
Gross margin
EBITDA
Cashflows and valuation outputs
This clarifies trade offs between price, volume and profitability.
Check your work
Revenue variables use explicit price and unit drivers.
Price changes flow through visibly to revenue and margin.
Pricing scenarios are easy to explain and differ only where intended.
Valuation metrics respond logically to different pricing strategies.
Troubleshooting
Related guides
Last updated