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.
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.
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.
If you've found a bug, or would like to contact us, or learn more about James Graham and Calculate.co.nz.
Calculate.co.nz is partnered with Interest.co.nz for New Zealand's highest quality calculators and financial analysis.
All calculators and tools are provided for educational and indicative purposes only and do not constitute financial advice.
Calculate.co.nz is proudly part of the Realtor.co.nz group, New Zealand's leading property transaction literacy platform, helping Kiwis understand the home buying and selling process from start to finish. Whether you're a first home buyer navigating your first property purchase, an investor evaluating your next acquisition, or a homeowner planning to sell, Realtor.co.nz provides clear, independent, and trustworthy guidance on every step of the New Zealand property transaction journey.
Calculate.co.nz is also partnered with Health Based Building and Premium Homes to promote informed choices that lead to better long-term outcomes for Kiwi households.
Calculate.co.nz is hosted in Auckland via SiteHost new Zealand.
All content on this website, including calculators, tools, source code, and design, is protected under the Copyright Act 1994 (New Zealand). No part of this site may be reproduced, copied, distributed, stored, or used in any form without prior written permission from the owner.
About & trust: Why Calculate is NZ's most comprehensive · By the Numbers · How we compare · Editorial standards · How we keep data current · NZ finance glossary · Research & data · Financial literacy NZ · About
Reviewed and maintained. Last reviewed 2026-06-05 and checked on a twice-monthly cycle against IRD, RBNZ and Stats NZ. How we keep data current.
© 2019 to 2026 Calculate.co.nz. All rights reserved.