Expansion Revenue Calculator

What the formula says

Expansion revenue is additional MRR from existing customers: upgrades, seat additions, usage growth and cross-sells, excluding anything from new customers.

Expansion rate = expansion MRR ÷ starting MRR × 100, and it is the term that allows net revenue retention to exceed 100%.

It is the cheapest revenue a subscription business can generate, since the customer is already acquired and already paying.

The numbers, worked through

$2,200 of expansion against $58,000 of starting MRR is a 3.8% monthly expansion rate.

Annualised that is roughly 56% growth from the existing base before any acquisition, which at 4% churn produces net revenue retention around 117%.

Acquiring the same $2,200 of MRR through new business would cost 76 subscribers at $58 CAC, $4,408 of spend plus the payback funding.

The expansion cost, by contrast, is whatever the upgrade prompt and the account management took, which is usually a fraction of that.

What the number leaves out

Expansion from price increases and expansion from genuine account growth are treated identically by the metric and are not equally repeatable. A business relying on annual price rises has a ceiling.

It also concentrates: most expansion typically comes from a small number of accounts, so a strong aggregate figure can rest on a few relationships whose loss would remove it.

Turning it into a decision

Separate expansion by source: upgrades, usage, seats, price, so the durable and the one-off parts are distinguishable.

Then check the concentration. If a third of expansion comes from three accounts, the metric is describing those relationships rather than a mechanism that scales.

Designing a product that can expand

Expansion requires somewhere to expand into, which is a packaging decision made long before any account management. A single flat plan offers none.

The models that work are usage-based pricing that grows with the customer's own success, seat-based pricing for team products, and clearly differentiated tiers with a reason to move up.

For a consumer subscription with one plan, expansion is structurally unavailable and the growth has to come from acquisition and retention. Recognising that early avoids chasing a metric the business model does not support, and directs the effort to where it can actually work.

Timing expansion prompts to usage milestones rather than to calendar intervals converts substantially better, since the customer is being asked at the moment the limitation is being felt.

That requires product usage data feeding the prompt, which is a build rather than a campaign, and it is why expansion is more of a product capability than a sales one.

Tracking the share of accounts that have ever expanded, rather than only the revenue, shows whether expansion is a broad mechanism or a few large exceptions.

Measuring the time from signup to first expansion identifies whether the upgrade path is discoverable, since a long gap usually means customers are finding it by accident rather than by design.

Setting an expansion target per account manager, where the model supports it, makes the mechanism someone's responsibility rather than an emergent property of the product.