Skip to main content

SaaS Churn Forecastv1.0.0

Projects MRR, active customers, churn count, and cumulative revenue month by month over a horizon up to 120 months. Inputs are starting customers, ARPU, monthly churn rate, and monthly new-customer growth rate, with optional expansion revenue per existing customer, reactivation rate, and a churn-trend change in percentage points per month (positive worsens, negative improves). A breakdown table lists every monthly row, with an optional step-by-step formula view.

SaaS
Churn
Revenue Forecasting
Subscription Metrics
Reference

Documentation

Model how customer churn affects your SaaS business over time. Enter your current customer count, average revenue per user, churn rate, and growth rate to generate a month-by-month revenue and customer forecast. The tool calculates net customer changes each period by applying churn losses, new customer acquisitions, and optional reactivations and expansion revenue to produce a complete financial picture of your subscription business trajectory.

  • Enter your Starting Customers count. This is your current active subscriber base at month zero.
  • Set the Average Revenue per User (ARPU) as your monthly subscription price or average monthly spend per customer. Enter the value in dollars. Fractions (such as 49.99 or 99 1/2) and formatted numbers (such as 1,200) are accepted.
  • Enter the Monthly Churn Rate as a percentage. For example, if you lose 5 out of every 100 customers each month, enter 5. Industry benchmarks range from 2 percent for enterprise SaaS to 8 percent or more for consumer subscriptions.
  • Set the Monthly New Customer Growth Rate as a percentage of your current base. An 8 percent growth rate on 1,000 customers means 80 new customers in the first month.
  • Choose a Forecast Horizon in months. Typical planning windows are 12, 24, or 36 months.
  • Open Advanced Settings to configure expansion revenue per customer, a reactivation rate for returning churned users, or a churn trend that models improving or worsening retention over time.
  • Enable Show step-by-step formulas to display the mathematical derivation for each period.
  • Click Forecast or simply type your values and the results update automatically after a short delay.
  • Click Reset to clear all saved data and return every field to its default value.
  • Share a pre-filled forecast by copying the page URL. Query parameters such as ?customers=500&churn=3&arpu=99&growth=10&months=12 override saved settings.

Churn forecasting is essential for any subscription or recurring revenue business. Understanding how retention rates translate into long-term revenue helps founders, finance teams, and investors make informed decisions about growth investment, pricing changes, and customer success initiatives.

  • Startup Planning: Model different churn scenarios when preparing investor pitch decks. Compare an optimistic 2 percent monthly churn against a conservative 7 percent to show the revenue spread over 24 months and justify customer success investment.
  • Board Reporting: Generate quarterly forecasts showing projected MRR and customer count trajectories. Present best-case and worst-case scenarios by adjusting the churn trend parameter to model improving or deteriorating retention.
  • Pricing Strategy: Evaluate the revenue impact of changing ARPU. Compare a lower price point with potentially reduced churn against a higher price point with higher churn to find the optimal balance.
  • Customer Success ROI: Calculate the revenue saved by reducing churn from 6 percent to 4 percent monthly. Use the side-by-side comparison to justify investment in onboarding, support, and engagement programs.
  • Expansion Revenue Modeling: Use the expansion revenue setting to model upsell and cross-sell contributions. See how even small per-customer expansion amounts compound across a growing base over 12 to 36 months.
  • Reactivation Campaigns: Estimate the impact of win-back campaigns by setting a reactivation rate. Model scenarios where 2 to 5 percent of churned customers return each month through targeted outreach.
  • Investor Due Diligence: Validate the growth assumptions in a SaaS company financial model. Enter reported metrics and compare forecast output against claimed projections to identify overly optimistic assumptions.
Inputs, outputs, and what the SaaS Churn Forecast computes

The form above accepts the following inputs and produces the outputs listed below. This summary is rendered in the page so the parameters are visible to crawlers, assistive tech, and indexing agents that don't fetch the embedded tool frame.

Inputs

  • Starting Customers (numeric input) · default: 1000 · minimum: 0
  • Average Revenue per User (ARPU) per Month ($) (text input) · default: 49
  • Monthly Churn Rate (%) (text input) · default: 5
  • Monthly New Customer Growth Rate (%) (numeric input) · default: 8 · minimum: 0
  • Forecast Horizon (Months) (numeric input) · default: 24 · range: 1 to 120
  • Monthly Expansion Revenue per Existing Customer ($) (text input) · default: 0
  • Monthly Reactivation Rate (%) (text input) · default: 0
  • Monthly Churn Rate Change (pp/month) (text input) · default: 0
  • Show step-by-step formulas

Controls

Reset

Worked example

For example, if you lose 5 out of every 100 customers each month, enter 5.