Business

Subscription Pricing Scenario Calculator

Compare three coherent subscription-pricing futures over eighteen months. Each path combines its own price change and churn response while sharing an acquisition baseline, allowing teams to see subscriber retention, MRR, cumulative revenue, and the point at which a higher price overcomes account loss.

Opening subscribers New subscribers per month Monthly expansion MRR (%) Current monthly price Hold-price churn (%) Measured uplift (%) Measured-path churn (%) Premium uplift (%) Premium-path churn (%)

Best month-18 MRR path-

Hold-price MRR-

Measured-uplift MRR-

Premium-path MRR-

Measured crossover month-

Premium crossover month-

Winner ending subscribers-

Cumulative revenue advantage-

Winner month-18 MRR relative to holding price

Pricing migration map

Follow retention loss, price lift, and cumulative revenue through the crossover

Hold / measuredPremium path

18-month MRR migration fanEach curve has its own price and churn response

Month	Hold subscribers	Hold MRR	Measured subscribers	Measured MRR	Premium subscribers	Premium MRR

Scenario construction

Pair every price decision with a retention response

Enter the active paying subscriber base and monthly acquisition flow.
Use the hold path as the no-change control.
Set a measured uplift and the churn response supported by research.
Use the premium path for a stronger repositioning, not merely a larger number.
Compare both month-18 MRR and cumulative revenue before choosing a path.

Crossover logic

A higher monthly price can win late even when it loses subscribers early

The crossover uses cumulative MRR, so a one-month spike cannot disguise the revenue sacrificed before the uplift overcomes retention loss.

Hold pathCurrent price paired with baseline churn.

Measured pathModerate uplift paired with its expected churn response.

Premium pathStronger price repositioning paired with higher retention risk.

Crossover monthFirst month cumulative MRR exceeds the hold-price control.

Detailed calculation process

Roll subscribers first, then price each scenario independently

Subscribers(s,m) = Subscribers(s,m − 1) × (1 − Churn(s)) + New subscribers
Price(s) = Current price × (1 + Uplift(s))

MRR(s,m) = Subscribers(s,m) × Price(s) × (1 + Expansion rate)
Cumulative MRR(s,m) = Σ MRR(s,1…m)

s is the scenario, m is the month, subscribers are expected active accounts, rates are decimal values, and MRR is currency per month. The winner is the largest month-18 MRR; the advantage reconciles winner cumulative MRR less hold cumulative MRR.

Decision examples

Two different pricing questions this model can answer

Renewal test: a team models a 10% uplift with churn moving from 3.2% to 3.8%, then checks whether the measured path crosses the hold path before the planning horizon.

Premium repositioning: a product adds service and raises price 20%; the premium path shows how many subscribers may be lost before month-18 MRR falls below the control.

Evidence before launch

Replace guesses with price-response signals

Van Westendorp or conjoint research by segment
Renewal cohorts after earlier price changes
Win/loss notes and discount approval data
Expansion behavior by plan and tenure

Limitation

Churn response is entered, not predicted

The model omits acquisition elasticity, grandfathering, taxes, annual contracts, and billing timing. Use controlled experiments and segment-level cohorts before rollout.

Subscription pricing scenario FAQ

Questions about uplift and retention tradeoffs

Why use cumulative MRR for crossover?

It accounts for revenue lost before the higher price catches up.

Can a path win MRR but lose subscriber share?

Yes. That is precisely why both measures remain visible.

Does expansion change churn?

Not in this simplified model; enter a separate scenario if the offer changes both behaviors.

Practical examples