Renewal Revenue Forecast
Use accounts due for renewal, expected renewal (%), annual value per account to prepare the renewal revenue forecast record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Use accounts due for renewal, expected renewal (%), annual value per account to prepare the renewal revenue forecast record. The worksheet applies the displayed arithmetic to your supplied values; it does not retrieve account data.
Separating growth, retention and subscription capacity
This worksheet calculates the displayed relationship from the supplied quantities. Its label and period conventions determine how the amount should be interpreted. Recurring revenue should be compared across the same starting cohort. Expansion, contraction and churn change retention in different directions. Adding new customers to a retained-customer calculation can conceal losses in the original population.
Scope of this operation
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options. The example output for renewal revenue forecast is shown below so the supplied source can be checked against the actual format. It is not evidence that the operation has run against your own file or account.
How it works
Expected annual renewed revenue = [Accounts due for renewal] × [Expected renewal (%)] ÷ 100 × [Annual value per account]
Inputs
| Field | Example | Definition |
|---|---|---|
| Accounts due for renewal | 100 | Use the source quantity represented by accounts due for renewal. Keep the counted population fixed and avoid mixing a unit value with a period total. |
| Expected renewal (%) | 85 | Enter expected renewal (%) on the percentage scale used in the formula (20 means 20%, not 0.20). Keep its base and reporting period consistent with the other inputs. |
| Annual value per account | 1200 | Use the source quantity represented by annual value per account. Keep the counted population fixed and avoid mixing a unit value with a period total. |
Step-by-step guide
Prepare the source
Supply Accounts due for renewal, Expected renewal (%), Annual value per account. Keep the original material so the output can be compared with it.
Build output
Check Accounts due for renewal, Expected renewal (%), then select Generate output.
Use the result
Compare the renewal revenue forecast result with the unchanged source before copying or downloading it.
When to use it
Expected annual renewed revenue = [Accounts due for renewal] × [Expected renewal (%)] ÷ 100 × [Annual value per account] The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Example and scope
Example inputs: Accounts due for renewal: 100; Expected renewal (%): 85; Annual value per account: 1200.
The figure includes only the listed inputs. It does not add unlisted tax, overhead, provider charges or conversion losses. Negative results can represent a shortfall or the signed difference between options.
Worked output
Expected annual renewed revenue: 102000 Assumptions: accounts: 100 renewal: 85 annual_value: 1200
Related tool family
This focused tool is associated with Gross Revenue Retention Calculator. Use it when you need to isolate a specific part of that wider workflow.
Several parent models may support the same step. Keep the business question visible and choose the version that best matches the process you actually need to manage.
Related parent models
Gross Revenue Retention Calculator, Net Revenue Retention Calculator, Logo Churn Calculator, Revenue Churn Calculator, Customer Retention Value Calculator, Renewal Rate Calculator, Renewal Revenue Forecast Calculator, Churn Cost Calculator
Keep the displayed formula, input units and model scope with the result. Corrections or questions can be sent through the request section on this page.
Content updated: October 11, 2026