Work & Resources→Pricing Scenario Analysis
Free Excel model · Pricing scenarios & sensitivity

Pricing Scenario Analysis Template (Excel)

Compare the baseline with a few pricing scenarios and see what changes total revenue.

The public model was rebuilt from real pricing work involving memberships, events, sponsorship and related revenue lines. Useful when several prices affect the same business.

FormatExcel .xlsx
AccessFree · no email required
Best forPricing scenarios, sensitivity & revenue mix
Pricing scenario analysis Excel dashboard comparing baseline and scenario revenue
Pricing scenario Excel assumptions sheet with editable price and volume inputs
What is inside

Current prices, proposed changes and their effect on revenue

BaselineCurrent prices, volumes and revenue lines kept separately from the scenario being tested.
Scenario selectorThe dashboard shows one active scenario at a time. Spreadsheet cemetery avoided.
Price & volume inputsEditable assumptions for the pricing changes you are considering.
Revenue-stream comparisonMemberships, events, sponsorship and other lines can be compared in the same model.
DashboardA concise view of baseline versus scenario outcomes before live pricing changes.
Use cases

Useful when one pricing change touches several parts of the business

Annual price review

Test an increase before announcing it and see how the total mix changes.

Discount policy

Compare discount levels against expected volume or retention assumptions.

Multi-revenue businesses

Model several revenue streams together.

How to use it

Run a scenario in three moves

1. Choose the scenarioPick the active scenario in the assumptions sheet.
2. Change the coloured inputsEdit prices, volumes, discounts or revenue-stream assumptions.
3. Return to DashboardCompare the scenario with baseline before anybody changes live pricing.
Questions

What this spreadsheet is and is not

Is this a price elasticity model?

This is a scenario model. It does not estimate a demand curve unless you provide the evidence for one.

Can I use it with different revenue streams?

Yes. Replace the demo revenue lines with yours.

Does the model tell me the “right” price?

No spreadsheet can manufacture willingness to pay. It helps quantify the business consequences of pricing assumptions so you can combine them with customer and market evidence.

Custom pricing scenario

Testing a real pricing change?

Send your current prices, volumes, discounts and revenue streams. I can rebuild the model around your business.