SPUE

Business

Subscription Pricing Unit Economics Calculator

The page separates list price from realized collected price, opening retention from new subscribers, and recurring service contribution from acquisition and platform costs. It also reports break-even active subscribers, net subscriber change, and a simple contribution LTV proxy.

Opening subscribers retained-
Ending active subscribers-
Average active subscribers billed-
Collected price after discount and failure-
Support cost per active subscriber-
Payment fee per active subscriber-
Hosting, support, and payment cost per subscriber-
Monthly contribution per active subscriber-
Collected recurring revenue-
Subscriber contribution before fixed and acquisition cost-
Acquisition spend on new subscribers-
Contribution after platform and acquisition cost-
Average active subscribers required for break-even-
Ending minus opening subscribers-
Contribution divided by monthly churn rate-

Decision view

Subscriber cohort bridge and unit ring

Subscriber cohort bridge and unit ringOpening subscribers lose churn, gain new accounts, and become ending active subscribers while realized price is split into service cost and contribution.
Exact scenario comparisonMonthly list price changes while all other entered assumptions remain constant.
Monthly list priceOpening subscribers retainedEnding active subscribersAverage active subscribers billedCollected price after discount and failureSupport cost per active subscriberPayment fee per active subscriberHosting, support, and payment cost per subscriberMonthly contribution per active subscriberCollected recurring revenueSubscriber contribution before fixed and acquisition costAcquisition spend on new subscribersContribution after platform and acquisition costAverage active subscribers required for break-evenEnding minus opening subscribersContribution divided by monthly churn rate

How to use Subscription Pricing Unit Economics Calculator

  1. Enter opening active subscribers, new subscribers, and churn for the same billing month.
  2. Convert list price to realized price using discount and payment-failure assumptions.
  3. Enter per-account service resources, fixed platform cost, and CAC, then compare average billed subscribers with break-even.

Calculator guide

Understanding Subscription Pricing Unit Economics Calculator

Connect monthly pricing with churn, new acquisition, payment failure, service delivery cost, acquisition spend, and fixed platform cost. The calculation uses average billed subscribers for monthly economics instead of treating the ending count as if it existed all month.

Cohort movement first Opening retention and new subscriber additions determine ending active accounts.
Billing uses an average The monthly revenue base lies between opening and ending counts.
Service cost is per account Hosting, support labor, and payment fees scale with active subscribers.
Acquisition is below unit contribution CAC for new subscribers is deducted separately from recurring service economics.

Detailed calculation process

Build subscriber movement, realized price, and monthly contribution

The default starts with 4,800 subscribers, adds 350, applies 4.5% churn, realizes a discounted $39 price, and includes hosting, support, payment fees, $95,000 platform cost, and $75 CAC.

General formula: N_ret = N_0(1 - c/100)N_1 = N_ret + N_newN_avg = (N_0 + N_1)/2p_real = p_list(1 - d/100)(1 - f/100)c_service = c_host + (m_support/60)r_support + p_real f_pay/100CM_sub = p_real - c_serviceProfit = N_avg CM_sub - F_platform - N_new CACN_BE = ceil((F_platform + N_new CAC)/CM_sub) The subscriber bridge and the unit-economics calculation meet at average billed subscribers. CAC is tied only to new accounts, while platform cost is a monthly commitment.

What each symbol means

N_0, N_ret, N_new, N_1, N_avg Opening, retained, new, ending, and average billed subscriber counts.
c, d, f Monthly churn, average discount, and payment failure rates (%).
p_list, p_real Monthly list and realized collected price ($/subscriber).
c_host, m_support, r_support, f_pay Hosting, support minutes, support hourly cost, and payment-fee rate.
F_platform, CAC Fixed monthly platform cost and acquisition cost per new subscriber.

Worked substitution with the default inputs

1. Move the subscriber cohort N_ret = 4,800 x 95.5% = 4,584N_1 = 4,584 + 350 = 4,934 The account base grows by 134 despite 216 opening-cohort churns.
2. Find the billing base N_avg = (4,800 + 4,934)/2 = 4,867 This approximates accounts active during the month.
3. Realize the monthly price p_real = $39 x 92% x 98% = $35.1624 Discount and payment failure reduce collected price before fees.
4. Calculate service contribution c_service = $3.20 + (12/60)x$35 + $35.1624x2.9% = $11.2197CM_sub = $23.9427 Support consumes $7 per subscriber and the payment fee is $1.0197.
5. Reconcile monthly economics Profit = 4,867x$23.9427 - $95,000 - 350x$75 = -$4,720.93N_BE = 5,065 The average billed base is 198 subscribers below the modeled break-even requirement.

The default ends at 4,934 active subscribers, realizes $35.16 per billed account, and produces a $4,720.93 monthly operating loss after platform and acquisition cost.

Cohort and price

Read subscriber movement beside the unit ring

The bridge explains account count; the ring explains what remains from one realized monthly payment.

Opening-cohort churn The retention branch removes monthly churn from opening subscribers before any newly acquired account enters the active base.
Ending-subscriber bridge Retained opening accounts and entered new subscribers reconcile exactly to ending active subscribers and the average billed cohort.
Subscriber contribution ring Discount and payment failure establish realized price, then hosting, support, and payment fees separate service cost from monthly unit contribution.

Worked situations

Practical examples

  • A 4.5% churn rate retains 4,584 of 4,800 opening subscribers; adding 350 new subscribers produces 4,934 ending active accounts.
  • A $39 list price with 8% discount and 2% payment failure realizes $35.1624 per average billed subscriber.

Better inputs

Useful tips

  • Match churn or retention rates to the billing period used for subscriber counts and revenue.
  • Include payment fees, support, hosting, fulfillment, and partner share in variable cost per active subscription.
  • Model grandfathered, discounted, annual, and trial cohorts separately when their realized prices differ.

Before relying on the result

Limitations and common mistakes

  • The average-balance method assumes subscriber changes are reasonably distributed through the month.
  • Upgrades, downgrades, annual revenue recognition, taxes, refunds, reactivation, and deferred revenue are not modeled.
  • The LTV proxy assumes constant monthly churn and contribution and ignores discounting.

Reference

Key terms

Average billed subscribers
Simple average of opening and ending active subscribers used as the monthly billing base.
Realized price
List price after the entered average discount and payment failure.
Unit contribution
Realized monthly price less hosting, support, and payment fees per subscriber.

Important note

Review unit economics by cohort; a blended churn and price can hide unprofitable acquisition channels or legacy plans.

Frequently asked questions

Why average opening and ending subscribers?

It avoids charging the ending count for a full month when additions and churn occur during the period.

Is payment failure the same as payment fee?

No. Failure removes revenue; the processor fee is charged on collected revenue.

Why is CAC not included in service cost?

Service cost applies to all active accounts, while CAC applies only to newly acquired subscribers.

Is contribution LTV a valuation?

No. It is a simple steady-churn proxy without discounting or cohort behavior.