top of page

The Sales Scenario & Analysis Model Template 

You might already build plans, but how can you see whether your business can stand up to shifting markets, changing buyer habits and reducing demand?


Thanks to this free spreadsheet model, you can scenario test your capacity plans, using the same data inputs that you'll no-doubt have already used in Clevenues Ultimate Sales Capacity Planning Spreadsheet.

A different approach to predicting the future than revenue forecasting, this helps you predict revenue with a bottom-up sales capacity snapshot approach. Test to see what happens to your team needs and revenue projections if data points start changing fast, using it as another starting point for your sales capacity planning.

Get started with revenue scenario analysis and grab the sheet today.


Check your inbox!

Subscribe to our newsletter & marketing to get the template. 

Don’t worry, we don't spam and you can unsubscribe at any time.

Privacy Policy

Grab it for free      

Using the template

Our free scenario testing spreadsheet is both free to download into Google Sheets or Microsoft Excel and super easy to use, and can give you the confidence to make the tough decisions, that land your sales team revenue where it needs to be.


 Getting started is easy:

1. Add your current/planned performance into the table

Simply add your data into the yellow boxes, the spreadsheet will do the rest.

Typical rule of thumb with any of Clevenue's template - If it's yellow chuck in some data, if it's not probably leave it be!

The scenario tester can only handle 1 market - Any more than than and it becomes difficult within a spreadsheet to do effectively.  If you have more than 1 market you might want to find a more robust approach...


2. Navigate to a scenario

There's 5 different tabs by default in the sheet for you to create different business scenarios with, however you can duplicate it all you like. 

Try to not get lost in the tabs though!

3. Add your scenario

Your business scenarios are built off % changes to current performance.

Sense test what happens if deal sizes decrease by 18% or if conversions increase by 5%. Using the scenarios, you can sense test strategic decisions and their projected impact.

Everything from modelling seasonal patterns to pricing changes can be done in the sheet, with different scenarios modelled across each of your data tabs.

Be mindful that these do not account for the ability for your teams to deliver these figures, and so you'll need far more complex models to both interrogate these scenarios and understand how they play out over time.


4. See the results

Designed to help contextualise what is going on and why, the model will tell you the headcount needs vs. what you've got in the scenario, and project a revenue output based on the modelled GTM effort.

From here you can continue to iterate, or create alternate situations & scenarios for you and other to test.

Ready to ditch the spreadsheets?

Start using Clevenue today

bottom of page