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.