top of page

Customer Revenue Forecast Model Template

$20.00Price

Roll your customer ARR forward, show the best, expected and worst case, and walk into the room with a number you can explain.

Most CS leaders get asked for a forecast and answer with a renewal list. A renewal list tells you what's coming up. It doesn't tell you where ARR lands at the end of the year once churn, downgrades and expansion all hit at the same time. I'm not a math girlie, so this model keeps the math simple on purpose and still gives your CEO the answer.

Start from the ARR Finance reports and set four drivers for each of three scenarios: renewal rate, contraction at renewal, monthly expansion and monthly off-cycle churn. Enter ARR up for renewal by month, and the model rolls ARR forward for 12 months, with GRR and NRR on the starting cohort for each scenario. Type in actual ending ARR each month to see how you're tracking against the expected case. The Summary puts all three scenarios side by side with the spread between best and worst, plus a chart of ending ARR by month. The guide shows you how to set each driver from your own history and how to present it to your CEO or board.

What's included

  • Customer Revenue Forecast Model template in Excel, plus a make-a-copy link for Google Sheets

  • 5 tabs: start here, assumptions, forecast, summary and lists

  • 3 scenarios over 12 months, with 4 drivers and built-in sanity checks

  • GRR and NRR for each scenario, actual vs. expected tracking and a comparison chart

  • A step-by-step PDF guide with one month worked line by line, how to set drivers from your history and how to present it

  • A Steal This forecast confidence check

Who it's for

CS leaders, CROs and founders who get asked what customer revenue will look like in twelve months.

How it works

Digital download. Your files are ready right after checkout. Open the Excel file, or use the link included with your download to make your own copy in Google Sheets. No physical item will be shipped.

Bundle and save

This template is part of the Metrics and Board Bundle: 8 templates for $79, about half the price of buying them one at a time. Want everything? The Complete Architect Collection has every template in the collection for $299.

WHAT YOU GET

Every template comes with a game plan.

01. A step-by-step guide

I walk you through how to use it, what to fill in first and where people get stuck.

02. A worked example

Every template comes filled in for a made-up company, so you can see what good looks like.

03. Office and Google versions

Edit it in Word, Excel or PowerPoint, or make your own copy in Google with one click.

04. Instant download

Check out and download it right away, so you can put it to work the same day.

More just like it.

LET'S TALK

Rather have it built with you?

Templates get you started. If you want the whole system designed around your team, your customers and your numbers, let’s talk.

bottom of page