# Expansion revenue calculator > What a systematic expansion motion adds compared to relying on new business alone. See the formula, change the inputs and save your results. Source: https://saas-marketing.net/calculators/saas-upsell-revenue/ Topic: SaaS Customer Marketing Type: calculator Published: 2026-09-17 Last updated: 2026-09-17 Publisher: SaaS Marketing (saas-marketing.net) License: CC BY 4.0. Quote or republish with attribution and a link to https://saas-marketing.net/calculators/saas-upsell-revenue/ ## Short answer Expansion revenue uses customers, monthly revenue per account, share eligible for an upgrade and the additional inputs below to estimate mrr added by expansion. Change the example inputs to your own figures. The result is a planning calculation, not an industry benchmark or a prediction. ## Key takeaways - The main result is mrr added by expansion; the formula is shown below. - Keep the reporting period, currency and customer cohort consistent across inputs. - Defaults are an illustrative scenario. A blank, invalid or undefined ratio displays as n/a. --- Use this tool alongside the [saas customer marketing guide](/saas-customer-marketing/). What a systematic expansion motion adds compared to relying on new business alone. ## Which inputs do you need? | Input | Example value | What to check | | --- | --- | --- | | Customers | 810 | Use the value from the same reporting period as the other inputs. | | Monthly revenue per account | 420 | Use the value from the same reporting period as the other inputs. | | Share eligible for an upgrade | 42% | Use the value from the same reporting period as the other inputs. | | Upgrade take rate | 18% | Use the value from the same reporting period as the other inputs. | | Average revenue uplift on upgrade | 45% | Use the value from the same reporting period as the other inputs. | | Cost to run the expansion play per account | 120 | Use the value from the same reporting period as the other inputs. | Before entering numbers, choose the unit of analysis. An account, a user and a paying subscription are different objects. Counting users in one field and accounts in another can produce a precise answer to the wrong question. Record the start and end dates beside your source export so another person can reproduce your work. ## What formulas does the calculator use? ### Accounts that upgrade ```text upgraded = customers * eligible / 100 * takerate / 100 ``` This output is expressed as a number. ### MRR added by expansion ```text newmrr = upgraded * arpa * uplift / 100 ``` This output is expressed as currency in the same units as the inputs. ### ARR added ```text annual = upgraded * arpa * uplift / 100 * 12 ``` This output is expressed as currency in the same units as the inputs. ### Cost to run the play ```text cost = customers * eligible / 100 * expcost ``` This output is expressed as currency in the same units as the inputs. ### Effective CAC on expansion revenue ```text expcac = newmrr > 0 ? (customers * eligible / 100 * expcost) / (newmrr / arpa) : NaN ``` Compare this against new business CAC. ### New customers this expansion is worth ```text equiv = arpa > 0 ? (upgraded * arpa * uplift / 100) / arpa : NaN ``` This output is expressed as a number. Percent fields use whole percentages: enter 5 for five percent. The formula divides by 100 where a decimal rate is needed. Values in the formulas correspond to the labelled inputs above; earlier outputs can be used by later formulas. ## Worked example The defaults are a constructed scenario, not results from a named company or survey. With the example inputs above, the calculation produces: | Output | Example result | | --- | --- | | Accounts that upgrade | 61.24 | | MRR added by expansion | 11,573.6 | | ARR added | 138,883.25 | | Cost to run the play | 40,824 | | Effective CAC on expansion revenue | 1,481.48 | | New customers this expansion is worth | 27.56 | Change one assumption at a time and watch the main result. Then test a conservative case by reducing the expected benefit or increasing the associated cost. If a decision works only at the most optimistic settings, investigate the uncertain input before committing the budget. ## How should you interpret the result? A formula describes the assumptions entered into it. It cannot establish that a channel caused a sale, that historical retention will continue, or that a projected cost is achievable. Compare the output with your own previous cohorts before using a broad market comparison. For a management review, save the result together with the source date, segment, owner and planned action. Recalculate when the underlying input changes. Keep a separate copy of the original scenario so the team can explain the difference between the plan and the observed outcome. ## Continue the analysis Use the [metrics guide](/saas-metrics/) to align definitions, browse [all calculators](/calculators/) for adjacent calculations, and keep a [measurement worksheet](/resources/) beside the model. The [pricing hub](/saas-pricing/) and [growth hub](/saas-growth/) cover decisions that often change these inputs. {/* expanded-practice-2026-09 */} ## Apply expansion revenue calculator in a working review Record the source and unit of every input before using the result. Change one assumption at a time to understand which inputs matter most. Keep outputs that describe money, time and percentages distinct, and preserve undefined cases rather than converting them into plausible-looking zeroes. For this topic, involve the customer marketing owner and the account’s success or support owner and work from current customer outcome, account context and requested participation. The relevant unit is an eligible customer account at a defined lifecycle moment. State the question the review should resolve before choosing a chart, an asset or a tool. If participants disagree about the unit or scope, resolve that disagreement before combining their evidence. ### Evidence to prepare Start with the value the customer has actually achieved. Coordinate promotional, educational and service messages so they do not contradict the account’s current situation. Advocacy and expansion should follow appropriate evidence, not simply the passage of time since purchase. | Review field | What to record | | --- | --- | | Topic | Expansion revenue calculator | | Decision | The specific action this explanation should help you choose | | Working evidence | current customer outcome, account context and requested participation | | Unit and scope | an eligible customer account at a defined lifecycle moment | | Responsible people | customer marketing owner and the account’s success or support owner | | Remaining uncertainty | The missing fact that could change the decision | ### Two situations that can change the interpretation #### When expansion targets customers who have not adopted An account with unused purchased capacity may need better onboarding rather than a larger package. Use this check: Check first-value completion and current operating outcomes before applying expansion criteria. A high contract value does not establish that the customer is ready for more scope. The [focused diagnostic guide](/guides/expansion-campaign-targets-unadopted-accounts/) provides the correction process and a working evidence sheet. #### When a customer campaign ignores an open problem A renewal value review may be appropriate, but an enthusiastic upsell message can be tone-deaf during an unresolved implementation failure. Use this check: Compare campaign eligibility with current account ownership and support context. Do not hide necessary service updates while pausing promotional outreach. The [focused diagnostic guide](/guides/customer-campaign-ignores-support-escalation/) provides the correction process and a working evidence sheet. ### Record the decision and the limit A customer in an unresolved escalation may need a repair plan before an expansion offer. A customer with a verified outcome may be willing to share a story, but that participation should have a clear scope and remain voluntary. Treat the two situations differently. Keep the conclusion beside the evidence that supports it. Record what the team will do, who owns the next action and which event or date will trigger a review. If the underlying definition, audience or product behavior changes, revisit the conclusion rather than assuming the old result still applies. A clear limit is useful information; it tells the next reader where additional investigation is required. Use the [complete topic collection](/topics/saas-customer-marketing/) for related methods and the [category field guides](/industries/) when the product's buying situation or implementation requirements change how the method should be applied. ### A reproducible sensitivity exercise The [expansion revenue calculator tool](/calculators/saas-upsell-revenue/) provides a related numerical exercise. Its current default inputs are constructed examples, not industry observations. Under those defaults, the output labelled **MRR added by expansion** is **11,573.6** in the tool's displayed units. The table changes one input at a time and leaves the others at their defaults. | Input changed | Default input | Alternative input | MRR added by expansion after change | | --- | --- | --- | --- | | Customers | 810 | 972 | 13,888.32 | | Monthly revenue per account | 420 | 504 | 13,888.32 | | Share eligible for an upgrade | 42 | 50.4 | 13,888.32 | | Upgrade take rate | 18 | 21.6 | 13,888.32 | | Average revenue uplift on upgrade | 45 | 54 | 13,888.32 | | Cost to run the expansion play per account | 120 | 144 | 11,573.6 | The alternative inputs are sensitivity cases, not recommended targets. A result marked not defined means the proposed combination does not satisfy the model or produces an undefined ratio. Keep that state visible. If the output changes sharply after a small input change, investigate the uncertain input before using the model to justify a larger commitment. Compare the model's scope with the concept on this page. The calculator may represent one particular application rather than every use of the term. Record the reporting period, currency where relevant, and the source of the real values you enter. ## Frequently asked questions ### How does this expansion revenue calculator work? It evaluates the formulas shown on this page in your browser. What a systematic expansion motion adds compared to relying on new business alone. Inputs are not sent to a calculation server. ### Are the default values SaaS industry benchmarks? No. They are example inputs chosen to demonstrate the calculation. Replace them with your billing, CRM or finance records before making a decision. ### Why does a result show n/a? The calculation is undefined or an input is outside its allowed range. Check for an empty field, a zero denominator or an impossible percentage before interpreting the result. ### Can I save or share my calculation? Use Print or save results to create a local PDF with your browser. Review the inputs before sharing and remove confidential customer or company information.