Renewal-period ending ARR
What is a SaaS renewal forecast?
A SaaS renewal forecast estimates how much annual recurring revenue (ARR) you'll keep from contracts coming up for renewal, plus any expansion signed at renewal. It combines the ARR due for renewal, your expected gross renewal rate, and planned upsells to project ending ARR and the revenue at risk of churning. Customer success leaders, RevOps teams, and finance use renewal forecasts to set retention targets, plan board numbers, and decide which at-risk accounts need attention first.
Renewal-period ending ARR
Base ARR x renewal rate + expansion ARR
Embed this free calculator on your website—copy the snippet after signup and keep the Built with Calclet link for attribution (or upgrade to remove branding).

Renewal forecast formula
Multiply ARR up for renewal by the gross renewal rate, then add expected expansion ARR.
Projected ending ARR = ARR up for renewal × Gross renewal rate ÷ 100 + Expansion ARR- ARR not renewed = ARR up for renewal × (1 − Gross renewal rate ÷ 100).
- Net renewal rate = Projected ending ARR ÷ ARR up for renewal × 100.
- Renewal rate needed to keep ARR flat = (ARR up for renewal − Expansion ARR) ÷ ARR up for renewal × 100.
Inputs explained
Base the forecast on contracts that actually expire within the period, and keep expansion separate from the renewal rate so nothing is counted twice.
- ARR up for renewal ($)
- Total ARR from contracts expiring during the forecast period, such as the next quarter or fiscal year.
- Gross renewal rate (%)
- The percentage of expiring ARR you expect to renew, before any expansion. Base it on past renewal rates by segment, and adjust for known at-risk accounts.
- Expected expansion ARR on renewals ($)
- Extra ARR from upsells, added seats, or upgrades signed with those renewals. Leave out price increases if they're already reflected in the renewal rate.
Example renewal forecast calculation
A SaaS company has $5,200,000 of ARR up for renewal this year and expects an 88% gross renewal rate. Renewed ARR = $5,200,000 × 0.88 = $4,576,000, so $624,000 is expected to churn. Adding $420,000 of expansion gives projected ending ARR of $4,996,000, a net renewal rate of about 96.08%.
Put this calculator on your site
We'll copy this tool into your Calclet account—tweak branding and fields, then paste the embed on WordPress, Webflow, Shopify, or any HTML page. Every embed can link back to Calclet for discovery.
How to use the renewal-period ending arr
- In Renewal base, input ARR up for renewal ($) exported from your renewal waterfall tied to contract expiration dates you intend to close this forecast horizon.
- In Renewal assumptions, set gross renewal rate (%) using trailing cohort logo or dollar retention excluding expansion uplift booked separately.
- Input expected expansion ARR ($) staged on those renewal opportunities after AE commits attach incremental SKUs or seats.
- Review projected ending ARR plus implied ARR not renewed; reconcile both lines to pipeline-weighted scenarios before Board submission.
Common renewal forecast mistakes
- Counting price increases in both the renewal rate and expansion ARR.
- Using one blended renewal rate when enterprise and SMB customers renew very differently.
- Including contracts that don't expire in the forecast period.
- Relying on historical averages without adjusting for known at-risk accounts.
- Treating expansion that hasn't been agreed as certain.
Renewal forecast planning context
- Gross renewal rate discipline
- Gross retention math isolates how much of the expiring base resubscribes before expansion layers; conflating upsell as retention inflates both renewal and NRR storylines.
- Segment variance
- Enterprise motion renewals often print higher gross retention than high-churn SMB cohorts; roll up segment-level forecasts before publishing a single blended rate.
- Pipeline timing
- Booked expansion on renewals should align to signature dates in the same ARR period you model, or ARR phasing from ramps will miss the forecast window.
FAQs
What renewal rate do we need to keep ARR flat?
Subtract expected expansion from ARR up for renewal, then divide by ARR up for renewal. With $5,200,000 up for renewal and $420,000 of expansion, you need ($5,200,000 − $420,000) ÷ $5,200,000 ≈ 91.92%. At the current 88%, ending ARR falls $204,000 short of flat.
How much expansion do we need to fully offset renewal churn?
Expansion must equal the ARR not renewed. At an 88% renewal rate on $5,200,000, $624,000 churns, so you need $624,000 of expansion to stay flat, or $204,000 more than the $420,000 currently expected.
How much is each point of renewal rate worth?
One percentage point equals 1% of ARR up for renewal. On $5,200,000, every point is worth $52,000. Raising the renewal rate from 88% to 91% adds $156,000 to ending ARR, about 37% of the $420,000 expansion forecast.
How do I build best-case, base-case, and worst-case renewal forecasts?
Run the calculator at three renewal rates. With $5,200,000 up for renewal and $420,000 of expansion, 82% gives $4,684,000, 88% gives $4,996,000, and 93% gives $5,256,000. The $572,000 range shows how much the forecast depends on renewal performance.
How do I forecast renewals using account-level risk scores?
Multiply each group's ARR by its renewal probability and add them up. $2,000,000 of healthy accounts at 95%, $2,200,000 at 88%, and $1,000,000 of at-risk accounts at 75% give $4,586,000 of expected renewed ARR. That's a weighted renewal rate of about 88.19% to enter in the calculator.
How much would saving one at-risk $300,000 account improve the forecast?
Saving it adds $300,000 of renewed ARR, which is about 5.77 points of renewal rate on a $5,200,000 base. If that account was assumed lost, the renewal rate moves from 88% to roughly 93.77%. Focus customer success effort on the largest accounts at risk first.
Should a price increase at renewal go into the renewal rate or expansion?
Pick one and stay consistent. A 7% increase on $4,576,000 of renewed ARR adds $320,320, lifting ending ARR to $5,316,320 if no extra customers leave. If the increase drops renewals to 86%, ending ARR is about $5,205,040, so model the churn risk too.
We forecast an 88% renewal rate but hit 85%—how big is the miss?
Each point is 1% of the base, so 3 points on $5,200,000 is a $156,000 shortfall in ending ARR. Review which accounts churned unexpectedly and adjust the renewal rate for each segment in the next forecast.
What is the difference between gross and net renewal rate?
Gross renewal rate counts only retained ARR and can't exceed 100%. Net renewal rate adds expansion. With $4,576,000 renewed and $420,000 of expansion on a $5,200,000 base, gross renewal is 88% and net renewal is about 96.08%.
Should I use one renewal rate for all customers?
Usually not. Enterprise accounts often renew at higher rates than small business customers. Forecast each segment separately and add the results, because a single blended rate can hide risk in a fast-growing, high-churn segment.
Related calculators
Related guides
Step-by-step articles on building, embedding, and ranking calculator pages like this one.
Category: SaaS renewal forecastingTopics: Gross renewal rate, Renewal ARR, Expansion on renewals
Last reviewed: 2026-05-07
Reviewed by: Souhayb Kama Ldine