Expansion Opportunity Calculator
The Expansion Opportunity Calculator helps you size the revenue sitting inside your existing customer base before you spend a dollar on new acquisition. It takes three simple inputs, your current average revenue per account, the target average revenue per account you believe each customer could reach, and the number of customers who are actually eligible to expand, and multiplies the per account gap by the eligible count to show the total opportunity in dollars. Founders, customer success leaders and revenue teams use it to set expansion targets, to prioritise which segments to work first, and to build a credible case for hiring or investment based on revenue that is already within reach. Because expanding an existing account is usually cheaper than winning a new one, this number often points to the fastest path to growth. To get a useful figure, define your target ARPA from real plan tiers or usage data rather than wishful thinking, and count only customers who genuinely have room to grow, not your whole base. It pays to refresh the calculation each quarter as plans, pricing and customer mix change, and to pair it with your historical upsell rate so the headline opportunity is tempered by what you can realistically convert. Treat the result as a ceiling, the full prize if every eligible account reached target, then apply a sensible conversion rate to forecast bookings. Used this way the tool turns a vague sense that there is more revenue available into a concrete, dollar figure you can plan around, share with your board, and track over time as you close the gap between current and target value.
Opportunity = (target ARPA - current ARPA) x eligible customers. Estimate only, not financial or tax advice.
How it works
The tool subtracts your current average revenue per account from your target to find the gap each eligible customer could add. It multiplies that gap by the number of eligible customers to give the total expansion opportunity. The target total shows revenue if every eligible account reached the target ARPA.
Worked example
With a current ARPA of $50 and a target of $80, the gap per account is $30. Across 200 eligible customers that is $30 x 200, which equals $6,000 of expansion opportunity. The target total of all eligible accounts is $80 x 200, which is $16,000.
Related calculators
- Upsell Rate Calculator: track upsell conversion.
- Cross-Sell Rate Calculator: measure cross-sell reach.
- Average Contract Value Calculator: size contract value.
- MRR Per Customer Calculator: revenue per customer.