Recurring Revenue Model (SaaS / Subscriptions)
ForecastingA subscription forecast the way investors read it: new customers, ARPA, churn, and expansion drive a monthly MRR/ARR build that ties out automatically.
Build a subscription forecast the way investors read it: new customers, ARPA, churn, and expansion drive a monthly MRR/ARR build, with the new → expansion → churn bridge tying out automatically. Presets for SaaS, memberships, and subscription boxes.
Ending ARR
$2,437,331
916% vs. starting ARR
Ending customers
400
Total revenue · 24 mo
$2,397,621
MRR + one-time fees over the horizon
Best built on a bigger screen
This is a wide, multi-period grid — open it on a laptop or desktop to edit it comfortably. You can still download the Excel below and build it there.
Pick the model closest to your business, then tune the drivers. Customers grow by new adds minus churn, ARPA grows by expansion, and MRR = customers × ARPA — the new → expansion → churn bridge ties to it exactly. The download recomputes in Excel.
Starting base
Acquisition
Retention & expansion
| Line | Jan Y1 | Feb Y1 | Mar Y1 | Apr Y1 | May Y1 | Jun Y1 | Jul Y1 | Aug Y1 | Sep Y1 | Oct Y1 | Nov Y1 | Dec Y1 | Jan Y2 | Feb Y2 | Mar Y2 | Apr Y2 | May Y2 | Jun Y2 | Jul Y2 | Aug Y2 | Sep Y2 | Oct Y2 | Nov Y2 | Dec Y2 | Total |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Customers & acquisition | |||||||||||||||||||||||||
| New customers | 12 | 12 | 13 | 13 | 14 | 15 | 15 | 16 | 16 | 17 | 18 | 18 | 19 | 20 | 21 | 22 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 30 | 469 |
| Churned customers | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | 4 | 4 | 5 | 5 | 5 | 6 | 6 | 6 | 7 | 7 | 8 | 8 | 9 | 9 | 9 | 119 |
| Customers (ending) | 61 | 72 | 83 | 94 | 106 | 118 | 130 | 143 | 156 | 169 | 182 | 196 | 211 | 225 | 240 | 256 | 272 | 289 | 306 | 323 | 342 | 360 | 380 | 400 | 400 |
| ARPA ($/mo) | $404 | $408 | $412 | $416 | $420 | $425 | $429 | $433 | $437 | $442 | $446 | $451 | $455 | $460 | $464 | $469 | $474 | $478 | $483 | $488 | $493 | $498 | $503 | $508 | $508 |
| MRR bridge | |||||||||||||||||||||||||
| New MRR | $4,848 | $5,092 | $5,349 | $5,619 | $5,902 | $6,199 | $6,512 | $6,840 | $7,185 | $7,547 | $7,927 | $8,327 | $8,746 | $9,187 | $9,650 | $10,136 | $10,647 | $11,184 | $11,748 | $12,340 | $12,962 | $13,615 | $14,301 | $15,022 | $216,882 |
| Expansion MRR | $195 | $239 | $285 | $333 | $383 | $435 | $488 | $544 | $603 | $664 | $727 | $793 | $862 | $934 | $1,010 | $1,088 | $1,171 | $1,257 | $1,347 | $1,441 | $1,539 | $1,642 | $1,750 | $1,862 | $21,591 |
| Churned MRR | $500 | $614 | $732 | $854 | $982 | $1,114 | $1,252 | $1,396 | $1,546 | $1,702 | $1,864 | $2,034 | $2,211 | $2,396 | $2,589 | $2,791 | $3,002 | $3,222 | $3,453 | $3,694 | $3,946 | $4,210 | $4,486 | $4,775 | $55,363 |
| Ending MRR | $24,543 | $29,261 | $34,164 | $39,261 | $44,564 | $50,084 | $55,832 | $61,820 | $68,062 | $74,571 | $81,361 | $88,446 | $95,844 | $103,569 | $111,640 | $120,074 | $128,890 | $138,108 | $147,750 | $157,836 | $168,391 | $179,437 | $191,002 | $203,111 | $203,111 |
| ARR | $294,516 | $351,133 | $409,966 | $471,137 | $534,773 | $601,008 | $669,983 | $741,843 | $816,745 | $894,850 | $976,327 | $1,061,357 | $1,150,126 | $1,242,830 | $1,339,677 | $1,440,884 | $1,546,678 | $1,657,297 | $1,772,994 | $1,894,032 | $2,020,686 | $2,153,249 | $2,292,024 | $2,437,331 | $2,437,331 |
| Revenue | |||||||||||||||||||||||||
| One-time fees | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total revenue | $24,543 | $29,261 | $34,164 | $39,261 | $44,564 | $50,084 | $55,832 | $61,820 | $68,062 | $74,571 | $81,361 | $88,446 | $95,844 | $103,569 | $111,640 | $120,074 | $128,890 | $138,108 | $147,750 | $157,836 | $168,391 | $179,437 | $191,002 | $203,111 | $2,397,621 |
This builds your revenue line. Drop it into a full 3-statement model →
Want this on your real numbers? Wauvel builds it straight from your QuickBooks.
Meet your AI CFO →More free tools
Annual Operating Plan (AOP) Builder
The plan you set the year by: revenue built up stream by stream, cost of sales, and operating expenses by category — twelve months across, with gross profit and operating income falling out for you.
Open the tool →Capacity & Utilization Revenue Model
Forecast revenue for a capacity business: units × sellable slots × utilization × price, plus ancillary revenue. Industry presets for salons, restaurants, hotels, clinics, trucking/fleet, and professional services — tune capacity, occupancy, and rate and watch revenue (and RevPAR-style yield) build month by month.
Open the tool →Funnel / Transaction Revenue Model
Forecast a paid-acquisition business: spend → sessions → orders → revenue, with returns, repeat purchases, CAC, and contribution. Industry presets for ecommerce/DTC, marketplaces (take rate), and lead generation — see how spend and conversion translate into revenue month by month.
Open the tool →3-Statement Financial Model
Set a handful of assumptions — growth, margins, working-capital days, capex, financing — and project a fully linked income statement, balance sheet, and cash flow three years out, monthly. The balance sheet balances and cash ties, automatically.
Open the tool →13-Week Cash Flow Forecast
The rolling weekly forecast every CFO keeps: beginning balance, money in, money out, and the projected low point that tells you exactly when cash gets tight.
Open the tool →Cash Runway Calculator
How many months of cash you have — counted the way a CFO would. Set your cash on hand, what you collect, and your monthly burn, and it solves runway both ways: the flat-burn number, and the honest one that grows burn and collections forward to the month cash actually hits zero — or shows you're default alive. Then it prices the levers: trim burn, collect faster, and watch the runway move.
Open the tool →Budget vs. Actual (Monthly P&L)
A month's P&L with plan set beside reality and the variance computed for you — so every number turns into feedback instead of weather.
Open the tool →Unit Economics Calculator (by business model)
What one order, subscription, billable hour, or cover actually earns — the profit hiding in a single sale that your P&L nets away and QuickBooks won't break out. Switch between D2C, SaaS, services, and restaurant models and it resolves the three-margin ladder (gross → contribution → net) plus the reads each model lives by: CAC payback, LTV:CAC, break-even utilization, prime cost, and break-even covers. Download a branded Excel where every result is a live formula off your inputs.
Open the tool →CAC & LTV Calculator (Ecommerce Unit Economics)
The number every ecommerce founder needs and the books can't give you: how much you can afford to pay for a customer. Set your order value, margin, and repeat rate against your ad spend, and it solves CAC, a contribution-based LTV, the LTV:CAC ratio, payback period, break-even ROAS, and your maximum profitable CAC — with a sensitivity table showing how the ratio and payback move as CAC changes. Built for DTC and online stores.
Open the tool →Break-Even & Contribution Margin Calculator
The number every owner should know: how much you have to sell to cover your costs. Set price, variable cost, and your fixed costs, and it solves break-even in units and revenue — then shows your margin of safety, the volume to hit a profit target, and how break-even moves when you change price.
Open the tool →Price / Volume / Mix Bridge
Revenue or margin moved — but why? Enter what you sold in two periods, line by line, and it splits the change into the three things that actually cause it: price (you charged more or less), volume (you sold more or fewer units), and mix (you sold a different blend of products). Add unit costs and it does the same for gross profit, isolating a cost effect too. New and dropped lines are handled cleanly, the bridge always ties out to the penny, and the download recomputes every effect as a live Excel formula. The decomposition QuickBooks won't do for you.
Open the tool →Financial Health KPI Tracker
The vital signs on one page — margins, current ratio, days-to-get-paid, the cash conversion cycle, runway — tracked month over month with the formulas already in.
Open the tool →