Renewal-period ending ARR
Finance and RevOps teams can model renewal outcomes with churn and expansion in one flow.
Example scenario
Customer Success stages $5.20 million in ARR up for renewal in the coming fiscal window and models an 88% gross renewal rate before counting incremental upsell. Retained base ARR is about $4.576 million while implied non-renewed ARR is roughly $624,000. Layering $420,000 in expansion ARR booked with those renewals projects about $4.996 million in ending ARR for the period when the deal cycle closes on these defaults.
Renewal-period ending ARR
Base ARR x renewal rate + expansion ARR
Want a similar calculator on your website?
Describe your fields and formula in plain English, match your brand, and embed the widget anywhere—WordPress, Webflow, Shopify, or custom HTML. Capture leads when you're ready.
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.
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.
Best use cases
- Forecasting and scenario planning
- Client education and pre-qualification
- Budget and performance decision support
Frequently asked questions
Does gross renewal rate include price increases baked into renewals?
Usually yes on dollar-based gross renewal definitions because uplift still counts as renewing base revenue; expansion ARR here should exclude duplicate uplift already baked into the renewal percentage your FP&A team applies.
Why add expansion ARR after multiplying by renewal rate?
The multiplier captures retained base economics while expansion captures incremental ARR layered once retention clears—mirror how net retention bridges separate churn from expansion.
Should paused or mothballed accounts lower renewal base?
Remove ARR you truly expect to exit before the numerator unless modeling downside churn inside gross renewal rate instead.
How does multi-year stacked contracting affect the wizard?
Fold co-term expansions into expansion ARR once procurement confirms signatures; avoid double-counting ARR already embedded in renewal uplift assumptions.
Glossary
Scenario modeling
Testing multiple assumptions to estimate possible outcomes before execution.
Commercial intent
User behavior indicating readiness to buy, subscribe, or request a quote.
Related calculators
Category: SaaS renewal forecastingTopics: Gross renewal rate, Renewal ARR, Expansion on renewals
Last reviewed: 2026-05-07
Reviewed by: Calclet Growth Team