Skip to content
UseCalcNow
Finance

Revenue Calculator — Project MRR, ARR & Growth

Forecast subscription revenue from customers, churn, and ARPU. Project MRR, ARR, and cumulative sales over 12 to 120 months.

About This Calculator

This revenue calculator forecasts recurring revenue from five inputs: starting customers, new signups per month, monthly churn, average revenue per customer, and a horizon up to 120 months. It simulates the subscriber base month by month, then reports projected MRR, ARR, cumulative revenue, and the churn ceiling your current acquisition engine can support. On the default run, 200 customers growing by 40 signups a month at 3% churn reaches 788 customers and $38,599 MRR after two years.

The Formula Behind This Calculator

The simulation steps forward one month at a time. Each month the base shrinks by the churn rate and grows by the new signups: customers(m) = customers(m-1) x (1 - churn) + new. Monthly revenue is the resulting customer count times ARPU, and the calculator sums those months into cumulative revenue. The closed-form equivalent is customers(n) = (start - new/churn) x (1 - churn)^n + new/churn, which shows the base converging on an equilibrium of new/churn customers. With 40 signups and 3% churn that equilibrium is 1,333 customers, so the default run lands at (200 - 1,333) x 0.97^24 + 1,333 = 788. Ending MRR is customers x ARPU, ARR is MRR x 12, and the explanation labels whether the base is growing toward that ceiling or shrinking toward it.

Understanding the math helps you verify results and make better decisions for your project.

How to Use

  1. 1Enter your current customer count, or the count for the cohort you want to model.
  2. 2Enter average new customers per month from your last few months of signups.
  3. 3Enter your monthly logo churn rate; if you only know annual churn, divide by 12 for a close approximation.
  4. 4Enter ARPU as your current MRR divided by current customers, so discounts and plan mix are baked in.
  5. 5Set the horizon, then read the MRR headline, the ARR line, cumulative revenue, and the churn ceiling in the explanation.

When to Use

  • →Building a 12 to 24 month revenue plan for a subscription business before committing to a budget.
  • →Preparing ARR projections for investors or board meetings and checking they survive churn assumptions.
  • →Testing what a churn-reduction program is worth before funding the retention team behind it.
  • →Estimating the revenue impact of a price change by raising ARPU and holding everything else constant.

Tips

  • ✓Derive ARPU from real data: divide this month's MRR by this month's customer count rather than using list price.
  • ✓Do the ceiling check in your head: new signups divided by churn equals the customers your engine can ever support.
  • ✓Segment the model by cohort when churn differs wildly, such as 8% for self-serve and 1% for enterprise accounts.
  • ✓Model expansion revenue as a higher ARPU rather than a lower churn rate so the customer count stays honest.
  • ✓Re-run the forecast every month against actuals and adjust one assumption at a time to see which number moved.

What This Revenue Calculator Does

The tool takes a recurring-revenue business apart into its four moving parts: the existing customer base, the acquisition engine that adds customers each month, the churn rate that removes them, and the price each one pays. It then rebuilds the future month by month. On the default inputs of 200 customers, 40 monthly signups, 3% churn, and $49 ARPU, the base lands at 788 customers after 24 months carrying $38,599 in monthly recurring revenue.

A single-period revenue estimate, which the price and quantity calculator handles well, multiplies units by price and stops there. That works for a one-time sale. Forecasting a subscription business needs the time dimension, because revenue two years out depends on how signups and churn compound against each other, and that interaction is exactly what a static multiplication misses.

The output panel goes past the headline number. Cumulative revenue over the horizon, $636,844 on the default run averaging $26,535 per month, is the figure you can actually budget against, since it represents the total sales the model expects to book across the whole period. That is the number to carry into a business budget calculator when planning headcount and spend.

The Revenue Formula Behind the Forecast

Each simulated month applies one update: customers(m) = customers(m-1) x (1 - churn) + new signups. Revenue for the month is that customer count times ARPU, and the months sum into cumulative sales. The arithmetic is simple, but the shape it produces is not, because the churn term scales with the size of the base while the signup term stays fixed.

The closed form makes the behavior visible: customers(n) = (start - new/churn) x (1 - churn)^n + new/churn. The base decays exponentially toward the equilibrium at new/churn, the same compounding mathematics that drives a compound growth calculator, except the growth here has a ceiling built in rather than running forever.

You can verify the default run by hand. The equilibrium is 40/0.03 = 1,333 customers, so after 24 months the formula gives (200 - 1,333) x 0.97^24 + 1,333 = 788. That cross-check matches the simulation exactly, and it is worth reproducing whenever you change assumptions, since a model you cannot sanity-check by hand is a model you should not present to investors.

MRR, ARR, and What Each One Is For

Monthly recurring revenue is the current run rate: customers times ARPU, $38,599 on the default 24-month mark. Annual recurring revenue is that figure times twelve, $463,184, and it is the standard metric for valuation multiples and year-over-year comparisons because it smooths out single-month noise.

Multiplying the current month by twelve misleads in both directions when growth is fast. The default scenario collects $234,270 of revenue in year one and $402,574 in year two, 72% more, so the final-month run rate understates what the following year will actually deliver. Track the monthly trajectory itself, ideally through a month over month growth calculator, rather than trusting a single annualized snapshot.

Keep the accounting straight as well. MRR is a management metric, not a GAAP figure: an annual contract billed upfront is cash today but recognized ratably over twelve months in the books. Forecast with MRR, report with recognized revenue, and reconcile the two so a board deck never mixes a bookings number into an ARR chart.

The Churn Ceiling: Why Growth Stalls

Divide monthly signups by monthly churn and you get the largest customer base your acquisition engine can ever support: 40/0.03 = 1,333 customers, worth $65,333 of MRR at $49 ARPU. The default run is still 788 customers after two years and 955 after three, grinding toward a ceiling it never quite reaches, because net adds shrink as the base grows.

The sensitivity is brutal in both directions. Cut churn from 3% to 2% and the ceiling jumps from 1,333 to 2,000 customers, $98,000 MRR; let it slip to 5% and the ceiling collapses to 800 customers, $39,200. Halving churn doubles the terminal value of the exact same acquisition spend, which is why retention work usually outranks new logo campaigns once churn crosses a few percent. The underlying rates are measurable with a churn rate calculator and its mirror, the customer retention rate calculator.

The stall is silent, which makes it dangerous. Signups hold at 40 every month, the team feels busy, and reported revenue still rises, while net adds have fallen from 34 per month at the start to roughly 16 by month 24 because churn removes about 24 customers from a 788-strong base. Any plan built on linear extrapolation of early growth will miss the ceiling by a wide margin.

Reading the Cumulative Revenue Number

Cumulative revenue, $636,844 over the default 24 months, answers a different question than the ending MRR: how much money the business books across the whole horizon. The year-one share is $234,270 and the year-two share is $402,574, a split worth knowing when a budget assumes revenue arrives evenly and the model says it arrives back-loaded.

Collections lag bookings, and the lag matters for cash. A business billing annually in advance collects earlier than the model shows; one billing on net-30 invoices with slow payers collects later. Measure the gap directly with a days sales outstanding calculator and hold a working-capital buffer sized to that gap times daily revenue.

Convert the cumulative figure into a coverage test before spending against it. At an 80% gross margin the default run generates $509,475 of gross profit over the horizon, and fixed costs have to fit under that line. A break even calculator tells you the sales level where they exactly do, and the distance between the two is the real margin of safety in the plan.

From Revenue to Money You Keep

Revenue is the top line, and the distance between it and profit is where forecasts die. Hosting, payment processing, support, and COGS consume the first slice; at an 80% gross margin each $49 of ARPU retains $39.20. Margin targets and the pricing moves needed to hit them belong to a gross margin calculator, and the revenue forecast should inherit its output as an input.

Price is the quietest lever in the model because it multiplies through the entire base. Lifting ARPU from $49 to $59, a 20.4% increase, moves the 24-month MRR from $38,599 to $46,476 and cumulative revenue from $636,844 to $766,813 without acquiring a single extra customer. A change that size usually costs some churn, so re-run the forecast with both the higher ARPU and a churn penalty before crediting the full gain.

Beware of revenue quality as the base grows. Discounted annual contracts, grandfathered legacy plans, and usage-based credits all drag realized ARPU below list, which is why the tip to compute ARPU as actual MRR divided by actual customers matters. Forecasting with list prices builds a compounding error into every single month of the simulation.

Unit Economics That Make the Forecast Credible

The forecast is only as good as the customers feeding it. A customer paying $49 at 80% gross margin and churning at 3% per month is worth ARPU x margin / churn = 49 x 0.8 / 0.03 = $1,307 of lifetime gross profit, the figure a customer lifetime value (CLTV) calculator formalizes. If acquiring that customer costs $500, the LTV-to-CAC ratio is 2.6, below the 3.0 threshold most investors treat as healthy.

Payback tells you whether the growth engine finances itself. At $500 of blended CAC (customer acquisition cost) and $39.20 of monthly gross profit per customer, payback runs 500 / 39.2 = 12.8 months. Until month 13 every new signup makes the cash position worse, which is how a business can hit every revenue target in this forecast and still run out of money.

The ceiling caps unit economics at the top. A 1,333-customer ceiling at $49 and 80% margin supports at most 1,333 x 39.2 = $52,267 of monthly gross profit, so sales and marketing spend above that level is buying growth the engine cannot hold. Either churn falls, ARPU rises, or acquisition volume grows, and each of those moves deserves its own scenario in the calculator before it earns a line in the budget.

Common Revenue Forecasting Mistakes

Bookings, billings, and revenue get conflated constantly. A $1,200 annual contract is $1,200 of bookings the day it signs, $1,200 of billings when invoiced, and $100 of recognized monthly revenue for a year. This calculator works in the MRR convention, so annual deals enter at their monthly equivalent and the forecast stays comparable to the P&L.

Applying churn to revenue instead of customers is the second common slip. Expansion revenue from upgrades can offset downgrades and cancellations, producing net revenue churn far below logo churn, and models that ignore it understate mature cohorts. The workaround is to keep customer-count churn honest in this tool and lift ARPU to represent expansion, rather than quietly shrinking the churn field.

Linear extrapolation is the third. Taking the 98.5% annualized MRR growth from the first two years and stretching it across a five-year plan ignores the ceiling entirely, since the same inputs push annual growth toward zero as the base approaches 1,333 customers. Frame long horizons with a revenue CAGR calculator on actual results and use this simulation to test whether the assumptions behind that growth rate survive contact with churn.

FAQ

How do you calculate revenue?

For one-time sales, revenue is units sold times price. For subscriptions, monthly revenue is active customers times average revenue per customer, and the forecast dimension comes from how that customer count evolves with signups and churn. This tool handles the recurring case; for a single-period units-times-price estimate, the price quantity calculator covers it directly.

Is MRR times 12 the same as ARR?

Yes, by convention ARR is MRR x 12, treating the current month as a steady run rate. The caveat is that a fast-growing business will beat that number: in the default scenario the run-rate ARR after 24 months is $463,184, while actual cash collected over the final 12 months is $402,574 from the earlier, smaller base and the following year would exceed the run rate.

What is a good monthly churn rate?

Consumer and self-serve SaaS commonly runs 3% to 5% monthly, healthy SMB products sit under 3%, and annual-contract enterprise business often churns under 1% per month. The difference compounds hard: at the same 40 monthly signups, a 2% churn ceiling is 2,000 customers while a 5% ceiling is 800.

Why does my revenue growth slow down when signups are steady?

Because churn scales with the size of the base. At 200 customers, 3% churn removes about 6 per month against 40 signups, a net gain of 34. At 788 customers the same 3% removes about 24 per month, cutting net growth to roughly 16. Net adds decay until churn equals signups, which is the ceiling this tool reports.

Does this calculator include expansion revenue?

Not explicitly. The model tracks customer count, so upsells and plan upgrades should be folded into a higher ARPU input. Net revenue churn, where expansion offsets downgrades and losses, can be approximated by lowering the churn field accordingly, though that mixes customer and dollar effects.

What is the difference between revenue and profit?

Revenue is the top line before any costs. At an 80% gross margin, each $49 of ARPU keeps $39.20 after hosting, support, and payment fees, and the remaining gross profit still has to cover salaries and marketing before anything becomes operating profit.

How do annual plans billed upfront fit this model?

Enter the monthly equivalent as ARPU, such as $600 a year becoming $50 per month, since the simulation works in monthly periods. Cash arrives earlier than the model shows, but recognized revenue and the churn math line up correctly.

Related Calculators