Skip to main content

📊Subscription Cohort Revenue Decay Visualizer: Understand How Your Customer Groups Generate Revenue Over Time

Last updated: December 24, 2025

In subscription businesses, not all customers are created equal—and not all customers behave the same way over time. A cohort is a group of customers who started their subscriptions in the same period (e.g., all customers who signed up in January 2025). Understanding how different cohorts generate revenue over time is critical for forecasting, pricing strategy, and customer lifetime value analysis. But revenue doesn't stay constant; it decays as customers churn, downgrade, or cancel.

Whether you're a SaaS founder analyzing customer retention patterns, a finance professional building revenue forecasts, a product manager understanding customer lifecycle, or a business student learning subscription economics, visualizing cohort revenue decay helps you see the bigger picture. This tool lets you define multiple cohorts with different start periods, initial MRR, and retention rates, then visualize how their revenue decays over time and how they stack together to create total subscription revenue.

The key insight from cohort analysis is that revenue from older cohorts naturally decays due to churn, while new cohorts add fresh revenue. The question is: are you adding new cohorts fast enough to offset the decay of older ones? This visualizer shows you exactly how different retention rates, cohort sizes, and timing affect your total subscription revenue trajectory.

Our Subscription Cohort Revenue Decay Visualizer uses a simple exponential decay model to show how each cohort's revenue decreases over time based on retention percentage. You can define multiple cohorts, see stacked revenue charts showing how cohorts contribute to total revenue, analyze individual decay curves, and calculate lifetime revenue per cohort. This helps you understand the long-term value of different customer acquisition periods and retention strategies.

📚Understanding Subscription Cohort Analysis: The Complete Guide

What is a Subscription Cohort?

A subscription cohort is a group of customers who started their subscriptions in the same time period. Cohorts are typically defined by month or quarter (e.g., "January 2025 cohort" or "Q1 2025 cohort"). By grouping customers this way, you can track how different acquisition periods perform over time and identify trends in customer behavior.

Example: If you acquired 100 customers in January 2025 at $50/month each, that cohort starts with $5,000 MRR. If 5% churn each month, by month 12, that cohort contributes only $2,700 MRR. Meanwhile, a new February cohort might add $6,000 MRR, offsetting some of the decay.

Key Concepts Explained

Initial MRR

The starting monthly recurring revenue from a cohort when it first begins contributing revenue.

Initial MRR = Customers × Price per Customer

Retention Rate

The percentage of revenue retained from one period to the next. 95% retention means 5% churn per period.

Retention = 1 - Churn Rate

Revenue Decay

How cohort revenue decreases over time due to churn. Higher retention = slower decay.

Revenue(age) = Initial MRR × Retention^age

How Revenue Decay Works

Revenue decay follows an exponential model: each period, the cohort retains a fixed percentage of its previous period's revenue. This creates a smooth decay curve where revenue decreases faster in early periods and gradually slows down.

Revenue at Age N = Initial MRR × (Retention Rate)^N

Where N = number of periods since cohort start

Period95% Retention90% Retention85% Retention
0 (Start)$10,000$10,000$10,000
6 months$7,350$5,314$3,771
12 months$5,400$2,824$1,422
24 months$2,916$797$202

Key Insight: Small differences in retention rate compound dramatically over time. A 5 percentage point difference (95% vs 90%) results in revenue being cut in half by month 12.

Stacked Revenue: How Cohorts Combine

When you have multiple cohorts, their revenues stack together to create total subscription revenue. New cohorts add fresh revenue while older cohorts decay. The total revenue trajectory depends on:

  • Retention rates: Higher retention means older cohorts contribute more revenue for longer.
  • Cohort sizes: Larger initial cohorts generate more revenue, but also decay more if retention is low.
  • Acquisition timing: Adding new cohorts regularly offsets decay from older cohorts.
  • Cohort age distribution: A mix of old and new cohorts creates more stable total revenue than relying on a single cohort.

Lifetime Revenue per Cohort

Lifetime revenue is the total revenue a cohort generates across all simulated periods. It helps you understand which cohorts contribute the most long-term value. Cohorts with higher initial MRR, higher retention, or earlier start periods tend to have higher lifetime revenue.

Lifetime Revenue = Sum of Revenue across all periods

🛠️How to Use This Calculator

Follow these steps to visualize subscription cohort revenue decay:

  1. Set Time Horizon: Choose how many periods you want to simulate (e.g., 24 months). This determines how far into the future the visualization extends.
  2. Add Your First Cohort: Click "Add Cohort" and enter:
    • Start Period: When this cohort begins contributing revenue (e.g., period 0, 3, 6)
    • Initial MRR: Starting monthly recurring revenue from this cohort
    • Retention Rate: Percentage of revenue retained each period (e.g., 95% = 5% churn)
  3. Add Additional Cohorts: Add more cohorts to model different customer acquisition periods. Each cohort can have different start periods, initial MRR, and retention rates.
  4. Review the Charts: The visualizer displays:
    • Stacked Area Chart: Shows how each cohort contributes to total revenue over time
    • Total Revenue Decay Line: Overall revenue trajectory across all cohorts
    • Individual Cohort Decay Lines: How each cohort's revenue decays independently
  5. Analyze Lifetime Revenue: Review the lifetime revenue summary to see which cohorts generate the most total value over the simulation period.
  6. Experiment with Scenarios: Try different retention rates, cohort sizes, and timing to see how they affect total revenue and decay patterns.

📐Formulas and Behind-the-Scenes Logic

Revenue Decay Formula

Revenue(age) = Initial MRR × (Retention Rate)^age

Where age = current period - start period

This exponential decay model assumes constant retention rate per period. Each period, the cohort retains a fixed percentage of its previous period's revenue.

Total Revenue Calculation

Total Revenue(period) = Sum of all cohort revenues in that period

Where cohort revenue = 0 if period < start period

Cohorts only contribute revenue starting from their start period. Before that, their contribution is zero.

Lifetime Revenue Calculation

Lifetime Revenue = Sum of Revenue(age) for all ages from 0 to (horizon - start period)

Lifetime revenue sums all revenue contributions from a cohort across the entire simulation horizon.

Full Example Calculation

Scenario:

  • Cohort 1: Start period 0, Initial MRR $10,000, Retention 95%
  • Cohort 2: Start period 6, Initial MRR $8,000, Retention 92%
  • Time horizon: 24 periods

Calculations (Period 12):

  • Cohort 1 revenue: $10,000 × 0.95^12 = $5,400
  • Cohort 2 revenue: $8,000 × 0.92^6 = $4,200 (age = 12 - 6 = 6)
  • Total revenue: $5,400 + $4,200 = $9,600

Lifetime Revenue:

  • Cohort 1: Sum of $10,000 × 0.95^age for age 0-23 = ~$155,000
  • Cohort 2: Sum of $8,000 × 0.92^age for age 0-17 = ~$95,000

💼Practical Use Cases

Use Case 1: SaaS Founder Analyzing Customer Acquisition Periods

Scenario: A founder wants to understand which customer acquisition periods (cohorts) are most valuable. They acquired customers in Q1, Q2, and Q3 with different retention rates.

Analysis: Using the visualizer, they model three cohorts with their actual initial MRR and observed retention rates. The Q1 cohort has highest lifetime revenue due to longer time horizon, but Q2 has best retention and highest per-period contribution by month 12.

Decision: They focus marketing efforts on channels that produced Q2-style customers (high retention) rather than just high initial MRR.

Use Case 2: Finance Team Forecasting Revenue Trajectory

Scenario: Finance needs to forecast subscription revenue for next 18 months based on existing cohorts and planned new customer acquisition.

Analysis: They model existing cohorts with historical retention rates, then add new cohorts representing planned acquisition targets. The visualization shows revenue declining in months 6-12 as older cohorts decay, then recovering as new cohorts mature.

Result: They identify a revenue dip in month 9 and adjust acquisition plans to add a cohort in month 6 to smooth the curve.

Use Case 3: Product Manager Testing Retention Improvement Impact

Scenario: A PM wants to show the revenue impact of improving retention from 90% to 95% through product improvements.

Analysis: They model the same cohorts with 90% vs 95% retention. The 95% scenario shows 40% higher lifetime revenue per cohort and significantly higher total revenue by month 18.

Result: They use the visualization to justify investing in retention improvements, showing it could increase revenue by $X over 18 months.

Use Case 4: Investor Evaluating SaaS Company Unit Economics

Scenario: An investor wants to understand if a SaaS company's revenue growth is sustainable or if it's masking high churn with aggressive acquisition.

Analysis: They model the company's cohorts with observed retention rates. The visualization shows revenue declining rapidly after month 12 as older cohorts decay faster than new ones can replace them.

Insight: The company needs to either improve retention or significantly increase acquisition to maintain growth—valuable information for valuation and due diligence.

Use Case 5: Business Student Learning Subscription Economics

Scenario: A student needs to explain why retention matters more than acquisition volume for subscription businesses.

Analysis: They model two scenarios: (1) High acquisition, low retention (90%) vs (2) Lower acquisition, high retention (97%). By month 24, scenario 2 has higher total revenue despite lower initial acquisition.

Learning: Retention compounds over time. A 7 percentage point difference in retention can overcome 2× difference in initial acquisition within 2 years.

Use Case 6: Marketing Team Planning Campaign Timing

Scenario: Marketing wants to time a major campaign to maximize revenue impact. They can launch in month 3 or month 6.

Analysis: They model adding a new cohort in month 3 vs month 6. Month 3 launch creates smoother revenue growth and higher total revenue by month 18, as the cohort has more time to contribute before decay.

Decision: They launch in month 3, understanding that earlier acquisition means more lifetime revenue contribution.

⚠️Common Mistakes to Avoid

  • Assuming Constant Retention: Real-world retention rates often vary by cohort age (e.g., higher churn in months 1-3, then stabilization). This tool uses constant retention for simplicity, but actual retention curves may be more complex (bathtub curves, seasonality).
  • Ignoring Expansion Revenue: This model only shows decay. In reality, customers may upgrade, add seats, or purchase add-ons, increasing their MRR over time. The visualization shows a worst-case scenario without expansion.
  • Not Accounting for Reactivations: Some churned customers reactivate later. This model treats churn as permanent, which may underestimate lifetime revenue.
  • Using Wrong Retention Definition: This tool uses revenue retention (MRR retained), not customer retention (customers retained). If customers downgrade, revenue retention is lower than customer retention.
  • Extrapolating Too Far: Exponential decay models become less accurate over very long horizons. Real businesses may have minimum revenue floors, reactivation programs, or retention improvements that change the curve.
  • Not Modeling New Cohorts: If you only model existing cohorts without adding new ones, total revenue will always decline. Real businesses continuously acquire new customers, which offsets decay.
  • Comparing Cohorts with Different Ages: When comparing lifetime revenue, remember that older cohorts have more periods to contribute. Compare cohorts at the same age for fair comparison.

🎯Advanced Tips & Strategies

  • Model Best and Worst Case Scenarios: Create multiple scenarios with different retention rates (e.g., 90%, 95%, 97%) to understand the range of possible outcomes. This helps with risk planning.
  • Identify Critical Cohorts: Use lifetime revenue to identify which cohorts contribute most value. Focus retention efforts on high-value cohorts or replicate their acquisition channels.
  • Plan Cohort Timing Strategically: If you see revenue dips in the visualization, plan new cohort launches before those dips to smooth revenue curves. Regular, consistent acquisition beats irregular bursts.
  • Compare Retention vs Acquisition Trade-offs: Model scenarios where you invest in retention (higher retention rates) vs acquisition (more/larger cohorts). See which generates more total revenue over your planning horizon.
  • Use for Customer Lifetime Value (LTV) Estimation:Lifetime revenue per cohort divided by initial customer count gives you average LTV per customer for that cohort. Compare LTV across cohorts to identify high-value customer segments.
  • Model Seasonal Patterns: If you have seasonal acquisition (e.g., Q4 holiday campaigns), model those cohorts separately to see how seasonal timing affects long-term revenue.
  • Combine with CAC Analysis: Compare lifetime revenue to customer acquisition cost (CAC) to calculate LTV:CAC ratios. Cohorts with high lifetime revenue but low CAC are most profitable.

📊Subscription Retention Benchmarks

These are general industry guidelines. Your optimal retention depends on your specific business model, market, and customer segments.

Business TypeTypical Monthly RetentionAnnual RetentionNotes
B2B SaaS (Enterprise)97-99%64-89%Long contracts, high switching costs
B2B SaaS (SMB)92-96%28-61%More price-sensitive, higher churn
B2C SaaS85-95%14-54%Lower commitment, higher churn
Media/Content88-94%20-48%Content consumption patterns affect retention
Marketplace/Platform90-96%28-61%Network effects can improve retention

Note: Annual retention is calculated as (Monthly Retention)^12. A 95% monthly retention equals 54% annual retention, meaning 46% of customers churn within a year.

📋Limitations & Assumptions

  • Simplified Exponential Decay: This model assumes constant retention rate per period. Real-world retention often varies by cohort age, season, or customer segment.
  • No Expansion Revenue: The model only shows decay. It doesn't account for customers upgrading, adding seats, or purchasing add-ons that increase MRR over time.
  • No Reactivations: Churned customers are treated as permanently lost. In reality, some customers reactivate later.
  • No Downgrades: The model assumes customers either stay at their current MRR or churn completely. It doesn't model partial downgrades that reduce MRR without full churn.
  • Constant Retention: Retention rates are assumed constant across all periods for each cohort. Real retention may improve or worsen over time based on product improvements, market changes, or customer lifecycle stages.
  • No Seasonality: The model doesn't account for seasonal variations in retention (e.g., higher churn in January after holiday subscriptions).
  • Educational Purpose: This tool provides estimates for learning and planning. Actual subscription performance depends on many factors beyond this simple decay model.

📚Sources & References

The information in this guide is based on established subscription analytics principles and authoritative sources:

  • U.S. Securities and Exchange Commission (SEC) - Subscription metrics disclosure: sec.gov
  • Financial Accounting Standards Board (FASB) - Revenue recognition for subscriptions (ASC 606): fasb.org
  • U.S. Small Business Administration (SBA) - Subscription business model guidance: sba.gov
  • SCORE Association - SaaS financial planning resources: score.org
Sources: IRS, SSA, state revenue departments
Last updated: January 2025
Uses official IRS tax data

For Educational Purposes Only - Not Financial Advice

This calculator provides estimates for informational and educational purposes only. It does not constitute financial, tax, investment, or legal advice. Results are based on the information you provide and current tax laws, which may change. Always consult with a qualified CPA, tax professional, or financial advisor for advice specific to your personal situation. Tax rates and limits shown should be verified with official IRS.gov sources.

Frequently Asked Questions

What is a cohort in this tool?

A cohort is a group of customers that start their subscriptions in the same period (e.g., all customers who signed up in January 2025). Each cohort has a start period, initial monthly recurring revenue (MRR), and a retention percentage that determines how quickly its revenue decays over time.

What does the per-period retention percentage represent?

The retention percentage represents the share of revenue that remains from one period to the next in this simplified model. For example, 95% retention means that each period, the cohort retains 95% of its previous period's revenue, losing 5% due to churn. This creates an exponential decay curve.

What does it mean when the total revenue curve flattens or declines quickly?

A quickly declining curve indicates that your cohorts have lower retention rates, meaning revenue is lost faster to churn. A flattening curve suggests that new cohorts are being added at a rate that offsets the decay of older cohorts, or that retention rates are high enough that decay is slow. Note that this tool does not add new cohorts automatically—you must define them.

Why might this visualization look different from my analytics or billing system?

Real-world subscription systems have more complex dynamics: customers may upgrade, downgrade, pause, or reactivate; retention may vary by customer segment or season; and expansion revenue from upsells can offset churn. This tool uses a simplified exponential decay model with constant retention rates, which is useful for educational purposes but won't match actual business data.

Does this tool forecast my real subscription business?

No. This tool is an educational visualization only and does not provide forecasts, predictions, or financial advice. It shows what would happen under the specific assumptions you enter (initial MRR, start periods, and retention rates), but real-world results depend on many factors not captured in this simple model.

How do I interpret the stacked area chart?

The stacked area chart shows how each cohort contributes to total revenue over time. Each colored band represents one cohort's revenue. The total height at any point shows the combined revenue from all cohorts in that period. As older cohorts decay and new cohorts start, you can see how the mix changes.

What is lifetime revenue and why does it matter?

Lifetime revenue is the total revenue generated by a cohort across all simulated periods. It helps you understand which cohorts contribute the most over the long term. Cohorts with higher initial MRR, higher retention, or earlier start periods tend to have higher lifetime revenue within a fixed horizon.

Can I model real business scenarios with this tool?

You can use this tool to explore hypothetical scenarios and build intuition about how retention affects subscription revenue. For example, you can compare scenarios with different retention rates or see how adding new cohorts over time affects total revenue. However, for actual business planning, you should use more sophisticated tools and consult with professionals.

How helpful was this calculator?

Cohort Revenue Decay Calculator 2025 | SaaS Subscription Analysis | EverydayBudd