Growth Forecaster

Forecast period (years):

Each year: members = members × annual retention + (monthly acquisition × 12).

Scenario	Starting members	Monthly acquisition	Annual retention (%)	End members	Net change	Growth (%)

Tip: Add scenarios to compare different acquisition and retention assumptions.

Forecast period: 5 year(s). Generated from Growth Forecaster.

How to use this forecast

Use this tool to build simple, evidence-led membership forecasts. It is designed for quick modelling rather than perfect prediction.

1) Start with a baseline

Create a “best estimate” scenario using your current starting members, typical monthly acquisition, and your annual retention rate. This gives you a baseline forecast you can compare everything else to.

2) Forecast by segment

You can use scenarios to create baseline forecasts for different segments of your membership, such as membership grade, region, career stage, or any other meaningful group. Treat each row as a separate segment, then compare growth rates and net change.

3) Model different strategic options

Add scenarios to explore “what if” questions while developing your strategy, for example:

What happens if acquisition improves but retention stays flat?
What happens if retention improves but acquisition stays flat?
How much improvement is needed to achieve a target end-of-period membership?

4) Compare scenarios side by side

Keep one scenario as your baseline, then create alternatives that change only one assumption at a time. This makes it clearer what is driving growth (or decline) and where to focus effort.

5) Share outputs

Use the Download (Excel) button to capture your scenarios, or Print to create a simple record for workshops, board packs, or planning sessions.