Packaging a new SaaS offer
Compare role-based or tiered packages before sales starts improvising exceptions.
Free Excel model · SaaS pricing & unit economics
B2B SaaS Pricing Model & Unit Economics Template (Excel)
A working SaaS pricing spreadsheet for testing packages, customer shapes, discounts, break-even and unit economics before you change live pricing.
The workbook connects pricing architecture to customer scenarios, contribution margin, CAC payback and LTV/CAC. Download it directly, change the input assumptions and inspect the formulas. No email gate.
FormatExcel .xlsx
AccessFree · no email required
Best forB2B SaaS pricing, packaging & unit economics
What is inside
The model is built around pricing decisions, not a single vanity metric
Pricing inputsRole, package and contract assumptions that can be changed without rewriting the model.
Customer scenariosDifferent customer shapes so you can see how the same price behaves across small and larger accounts.
Break-even & contributionMinimum viable account size and contribution logic before discounts or complexity eat the economics.
LTV, CAC & paybackUnit-economics outputs that connect pricing to acquisition economics rather than treating price as an isolated number.
SensitivityTest what happens when the assumptions are less flattering than the base case.
Use cases
Use it when the pricing question has consequences
Reviewing discounts
See whether annual discounts, negotiated terms or smaller accounts still leave acceptable economics.
Checking unit economics
Connect ARPU, contribution, CAC, LTV and payback to the pricing architecture you are actually selling.
How to use it
Start with the summary, then break the assumptions on purpose
1. Open the CEO viewRead the current pricing logic and headline economics before touching inputs.
2. Change hardcoded assumptionsEdit pricing, customer and cost inputs. Leave the formulas alone.
3. Compare the ugly cases tooUse scenarios and sensitivity to see where margin, payback or break-even starts to fail.
Questions
Before you download
Is this a SaaS pricing calculator or a full financial model?
It is a pricing and unit-economics model. It goes deeper than a one-cell calculator but is narrower than the separate 36-month SaaS financial model.
Can I use it for LTV/CAC and CAC payback?
Yes. LTV/CAC and payback are part of the model so the pricing decision can be checked against acquisition economics.
Can this be adapted to our own tiers, roles or usage model?
Yes. The public workbook is the example. A custom version can be rebuilt around your actual packages, customer mix, cost structure and commercial rules.
Related work
Keep going from the same problem
Custom SaaS pricing model
Need this built around your actual pricing architecture?
Send your current plans, customer assumptions, role structure and cost base. I can build the model around the decision you actually need to make.