Rolling 12-Month Forecast

What's Inside

This template helps organize your Rolling Forecast for your OpEx Spending.

You can download the monthly actuals from your ERP and copy those into the actualized periods in the template. You may also input the actuals into this template and pull in the summarized data via spreadsheet formulas (SUMIFs, VLOOKUP's, etc.). 

Next, you can pull in, enter, or update formulas to calculate your forecast figures. There's a "Latest Closed Month" filter on each tab to update the time horizon you are planning for.

This model has eight components:

1. Department variances
2. OpEx variances
3. Steps
4. OpEx plan
5. Headcount
6. Sales & Marketing
7. T&E
8. Drivers

Use with Cube

This is an Excel template. You don't need to be a Cube customer to use it!

But if you are a Cube user, you can start using this template in under two minutes. Here's how.

Step 1: Open the template in Excel or Sheets.

Step 2: Customize the row and column headers to match your Cube's dimensions and filters.

Step 3: Select the range where you want to fetch your data. 

Step 4: Fetch your data.

All About Rolling 12-Month Forecast

The rolling 12-month forecast always forecasts 12 months into the future. Whenever you close a month, you add another month to your rolling 12-month forecast. This means you're always planning and predicting future performance based on actual performance.

Unlike a traditional forecast, the rolling 12-month forecast is never more than a month out of date. Using a rolling forecast allows you to always have a plan for a set time period that is continuously updated based on the latest period of actuals. 

So the rolling 12-month forecast makes you a more nimble planner. You're better able to react to what's happening in your organization right now.