Renewal and Churn Forecast Template
Two documents and four sheets, scoring renewal risk from usage trend and netting expansion into the same number leadership asks for.
Free download · No account needed
Risk-adjusted Forecast
Thornbury Cloud Services, a fictional B2B SaaS company. Q4 2026 renewal book, 42 accounts, scored into tiers from each account's own usage trend.
| Tier | Accounts | ARR | Calibrated churn rate | Exposure |
|---|---|---|---|---|
| Red | 6 | $1,100,000 | 45% | $495,000 |
| Yellow | 11 | $1,800,000 | 15% | $270,000 |
| Green | 25 | $3,500,000 | 3% | $105,000 |
| Risk-adjusted total | 42 | $6,400,000 | — | $870,000 |
| Flat 9% historic rate, for comparison | 42 | $6,400,000 | 9% | $576,000 (reads as lower risk) |
The flat rate understates exposure by $294,000. This quarter's book carries more red-tier ARR than a typical quarter, which a blended rate cannot see.
Expansion Pipeline
Every qualified expansion opportunity inside this same renewing book: named stakeholder, stated target, and a date, per the pack's rule on netting.
| Account | Tier | Opportunity | Close probability | Weighted value |
|---|---|---|---|---|
| Millbrook Software | Green | Add 40 seats | 85% | $80,750 |
| Ashford Biotech | Green | Upgrade to enterprise tier | 80% | $68,000 |
| Corbett Aerospace | Green | Add analytics add-on | 95% | $57,000 |
| Pemberton Analytics | Yellow | Add 15 seats | 70% | $31,500 |
| Marlowe Data Systems | Yellow | Upgrade tier | 45% | $11,250 |
| Total | $310,000 raw | $248,000 weighted |
No red-tier account appears here. An expansion pitch into a declining account is a risk signal, not pipeline, per the pack's rule.
Net Forecast
Starting ARR, minus risk-adjusted churn, plus weighted expansion, stated as one bridge.
| Component | Value |
|---|---|
| Starting ARR | $6,400,000 |
| Risk-adjusted churn exposure | −$870,000 |
| Probability-weighted qualified expansion | +$248,000 |
| Net forecast | $5,778,000 (90.3%) |
| Naive gross forecast at the flat 9% rate (no expansion visibility) | $5,824,000 (91.0%) |
The net forecast lands $46,000 below the naive figure despite the expansion offset, because the naive number's churn estimate was itself too low. The two look similar; the risk behind them is not.
Most renewal forecasting guidance now agrees that a historic churn rate is a lagging indicator: it reports what already happened rather than what a specific account's usage is telling you right now. Usage trend over the 90 days before renewal is the most predictive quantitative signal available in most SaaS products, more predictive than tenure or contract size. Account-level scoring built from it catches risk a company-wide average cannot.
This pack scores every account into a tier from its own usage trend, then calibrates each tier's churn probability from what actually happened to accounts in that tier over your own trailing few quarters, never an industry benchmark. Qualified expansion opportunities inside the same accounts get netted into one forecast bridge, because leadership asks for the net number, not a churn rate and an expansion pipeline reported separately with nobody reconciling the two.
On a worked run for Thornbury Cloud Services, a B2B SaaS company, a flat 9% historic rate predicted $576,000 at risk across a $6,400,000 renewal book. Scoring by usage trend found $870,000 of real exposure, $294,000 higher, concentrated in six accounts with declining usage or a departed champion. Netting $248,000 of qualified expansion still left the risk-adjusted number $46,000 below the naive forecast. The pack pairs with computing required pipeline from each segment's own conversion rate and with deriving loss reasons from free text rather than a picklist.
What's in the pack
Risk Definitions
Exact usage-decline, champion-change, and escalation thresholds for red, yellow, and green tiers, calibrated from your own churn history.
Renewal Methodology
How tier probabilities are calibrated and recalibrated, and how the net forecast bridge is built and stated.
Renewal Calendar
Every account renewing this period with ARR, date, and tier, in one register the forecast sheet aggregates from.
Risk-adjusted Forecast
Churn exposure by tier against the flat historic rate, with the dollar gap between them stated plainly.
Churn Reason Log
A specific reason on every past churn, tied back to the tier the account was sitting in, for calibrating the next quarter.
Expansion Pipeline
Qualified upsell and cross-sell opportunities in the same accounts, netted into the forecast once each clears its own bar.
How to use it
- 1
Send the renewal book and usage data
Accounts renewing this period with ARR, plus usage trend, closed-lost history, and any expansion already in motion.
- 2
Score tiers and calibrate probability
Every account scored from its own usage trend, with each tier's churn rate calibrated from your actual history.
- 3
Build the risk-adjusted forecast
Exposure computed by tier and compared against a flat historic rate, with the dollar gap stated by name.
- 4
Qualify expansion and net the number
Expansion opportunities checked against the pack's bar, then netted into one bridge for the final forecast.
Frequently asked questions
Why not just use our trailing churn rate like we always have?
A trailing rate is accurate on average, but it can't tell you when a specific quarter's book is riskier than average. Thornbury's flat 9% rate missed $294,000 of exposure that was sitting in six accounts with a clear usage decline, invisible inside a company-wide blend.
What if we don't track detailed product usage per account?
Start with whatever exists: login frequency and active seat count are usually available even without a full analytics instrumentation, and both are meaningful risk signals on their own. Add feature-level adoption once it's available, and note in Risk Definitions which signals the current tiers are actually built from.
How many quarters of history do we need to calibrate tier churn rates?
Two quarters is a workable start; four is stronger. The methodology doc records how many accounts and quarters each tier's rate is calibrated from, so a rate built on nine accounts is visibly weaker evidence than one built on forty.
Won't netting expansion into the forecast make the number look better than it is?
Only if expansion isn't qualified first. The pack's rule requires a named stakeholder, a stated target, and a date before any opportunity nets against churn. Thornbury's worked example still lands lower than a naive forecast even with real expansion included.
Can an account be both a churn risk and an expansion opportunity?
In principle yes, but in practice a real expansion pitch rarely survives contact with an account already in the red tier. The pack treats an expansion conversation on a declining account as a risk signal worth logging in Risk Definitions, not as pipeline to count.
How is this different from a pipeline coverage or forecast accuracy review?
Those tools cover new-business pipeline and a quarter's commit-versus-actual gap. Pipeline coverage checks whether enough new pipeline exists to hit the number; this pack covers the separate, ongoing question of what the existing customer base itself is worth net of churn and expansion.
Does this pack set next year's quota, or just forecast the current book?
Just the forecast. Quota-setting for a renewal-heavy book is a separate, earlier decision. The territory and quota model template builds next year's territories and quotas from scored account potential, before this pack's ongoing renewal and churn tracking takes over.
Find the renewal risk a flat rate can't see
Send your renewal book, usage data, churn history, and expansion pipeline, and get a risk-adjusted net forecast.
Get the template