Rolling Forecasts

Rolling Forecasts

name: rolling-forecasts description: Rolling forecast methodology and implementation

When to Activate

• User wants to implement or improve a rolling forecast process
• Transitioning from static annual budgets to continuous forecasting
• Building driver-based forecast models
• Tracking forecast accuracy and reducing bias
• Designing forecast cadence and governance

Core Concepts

Rolling Forecast vs Static Budget

A rolling forecast does not replace the budget. The budget remains the accountability benchmark. The forecast provides the latest view of where the business is actually heading.

Forecast Horizon

12-month rolling: Always see 12 months ahead regardless of where you are in the fiscal year. When January actuals close, add the next January to the forecast.

18-month rolling: Provides visibility beyond the fiscal year boundary. Useful for businesses with long lead times, capex planning, or seasonal dynamics.

Quarterly cadence with monthly granularity: Most common approach. Full re-forecast quarterly; interim months updated only for material changes.

Driver-Based Forecasting

Instead of forecasting every line item, identify the 15-25 key drivers that determine 80%+ of financial outcomes.

Revenue drivers by business model:

SaaS:        Customers × ARPU × Retention Rate
E-commerce:  Traffic × Conversion Rate × AOV
Manufacturing: Units × Price × Utilization Rate
Professional Services: Headcount × Utilization × Bill Rate × Realization
Subscription Media: Subscribers × ARPU + Ad Impressions × CPM

Cost drivers:

Personnel:   Headcount × Avg Cost (driven by hiring plan)
COGS:        Revenue × (1 - Gross Margin %) or Unit Volume × Unit Cost
Marketing:   Revenue × Marketing Spend Ratio or Campaign-level build
Facilities:  Fixed (lease) + Variable (utilities per sqft)

Advantages of driver-based approach:

• Faster to update (change the driver, formulas recalculate)
• More intuitive for business owners (they think in drivers, not GL codes)
• Enables scenario modeling (what if conversion rate drops 2%?)
• Facilitates accountability (driver owners vs line item owners)

Re-Forecast Cadence

=== ROLLING FORECAST CALENDAR ===

Frequency: Quarterly full re-forecast, monthly actuals comparison

Day      | Activity
Day 1-3  | Month-end close (actuals finalized)
Day 4-5  | FP&A distributes driver templates to forecast owners
Day 6-8  | Business units update driver assumptions
Day 9-10 | FP&A consolidates, identifies key changes vs prior forecast
Day 11   | FP&A review meeting (challenge assumptions, resolve issues)
Day 12   | Forecast finalized, loaded into system
Day 13-15| Executive review: forecast vs budget, forecast vs prior forecast

Forecast Accuracy Measurement

MAPE (Mean Absolute Percentage Error):

MAPE = (1/n) × Σ |Actual - Forecast| / |Actual| × 100%

Tracking accuracy over time:

• Measure MAPE at different lead times (1-month ahead, 3-month ahead, 12-month ahead)
• Revenue forecast accuracy target: MAPE < 5% at 1-quarter lead
• EBITDA forecast accuracy target: MAPE < 10% at 1-quarter lead
• Track bias (systematic over- or under-forecasting) separately from accuracy

Forecast accuracy scorecard:

Metric     | 1Q Ahead | 2Q Ahead | 3Q Ahead | 4Q Ahead | Target
Revenue    |   ___%   |   ___%   |   ___%   |   ___%   | < 5%
Gross Profit|  ___%   |   ___%   |   ___%   |   ___%   | < 8%
EBITDA     |   ___%   |   ___%   |   ___%   |   ___%   | < 10%
Cash Flow  |   ___%   |   ___%   |   ___%   |   ___%   | < 15%

Forecast vs Actual (FvA) Analysis

Every forecast cycle should include a disciplined FvA review:

1. Compare latest actuals to prior forecast — what changed and why?
2. Categorize variances:
   • Timing (shifted between periods, self-correcting)
   • Volume/mix (demand different from forecast)
   • Rate/price (pricing, FX, inflation different from assumption)
   • One-time (unforeseeable events)
3. Update drivers — incorporate learnings into forward forecast
4. Document assumptions — every material change should be traceable

Scenario Overlays

Layer scenarios on top of the base rolling forecast:

Base Forecast (most likely outcome)
± Upside Scenario (favorable market, accelerated wins)
± Downside Scenario (demand slowdown, cost inflation)
± Stress Scenario (recession, key customer loss)

Scenarios should modify specific drivers, not arbitrary percentage adjustments.

Methodology

Implementation Roadmap

Phase 1: Foundation (Month 1-2)

• Define forecast horizon and cadence
• Identify key drivers (15-25 for the business)
• Assign driver owners (who is accountable for each assumption)
• Build driver-based model in planning tool or spreadsheet

Phase 2: First Cycle (Month 3-4)

• Run parallel with existing budget process
• Collect driver inputs from business owners
• Consolidate and review
• Identify gaps in process and data

Phase 3: Refinement (Month 5-8)

• Iterate on driver selection (add/remove based on explanatory power)
• Improve data collection workflow (reduce manual effort)
• Begin tracking forecast accuracy
• Train business partners on driver-based thinking

Phase 4: Maturity (Month 9+)

• Forecast becomes primary management tool for forward-looking decisions
• Accuracy improves as institutional memory develops
• Scenario planning integrated into regular cadence
• Consider technology upgrade (Anaplan, Adaptive, Pigment, etc.)

Best Practices

• Limit detail: Forecast at a higher level than the budget. Not every GL line needs a separate forecast.
• Separate known from unknown: Committed items (signed contracts, fixed costs) vs assumptions
• Time-bound assumptions: Every driver assumption should have an expiration/review date
• No gaming: Forecast should reflect the most likely outcome, not a sandbagged or stretched number
• Speed over precision: A roughly right forecast delivered quickly beats a precise one delivered late
• Close the loop: Every forecast cycle should begin with reviewing the accuracy of the prior forecast

Templates

Rolling Forecast Summary

=== ROLLING FORECAST SUMMARY ===

Company: [Name]
Forecast Date: [Date]
Horizon: [Next 12/18 months]

--- P&L Forecast ($ thousands) ---
              | Q1 Act | Q2 Fcst | Q3 Fcst | Q4 Fcst | FY Fcst | FY Budget | Δ to Budget
Revenue       | _____  | _____   | _____   | _____   | _____   |  _____    |  ____
Gross Profit  | _____  | _____   | _____   | _____   | _____   |  _____    |  ____
EBITDA        | _____  | _____   | _____   | _____   | _____   |  _____    |  ____
Net Income    | _____  | _____   | _____   | _____   | _____   |  _____    |  ____

--- Key Driver Assumptions ---
Driver                    | Prior Fcst | Current Fcst | Change  | Owner
Revenue growth rate       |    ___%    |     ___%     |  ___ bp | [Name]
Gross margin              |    ___%    |     ___%     |  ___ bp | [Name]
Headcount (year-end)      |    ___     |     ___      |  ± ___  | [Name]
Customer churn rate       |    ___%    |     ___%     |  ___ bp | [Name]

--- Forecast Change Bridge ---
Prior Forecast EBITDA:    $____k
+ Revenue volume impact:  $____k
+ Pricing impact:         $____k
- Cost increase:          ($____k)
± Timing / phasing:       $____k
± Other:                  $____k
= Current Forecast EBITDA: $____k

Driver Input Template

=== DRIVER INPUT FORM ===

Department: [Name]
Forecast Owner: [Name]
Submission Date: [Date]

Driver              | Current Value | Forecast Value | Assumption Basis
New logos per month  |     ___      |      ___       | [Pipeline, win rate]
Avg deal size       |    $___k     |     $___k      | [Mix shift, pricing]
Churn rate (monthly)|    ___%      |     ___%       | [Cohort analysis]
Hiring plan (FTEs)  |     ___      |      ___       | [Approved reqs]
Unit COGS           |    $___      |     $___       | [Supplier contract]

Comments / risks:
[Free text for qualitative context]

Quality Gate

Before finalizing a rolling forecast, verify:

• Forecast horizon extends at least 12 months from current date
• Key drivers are identified, owned, and documented with assumption basis
• Actuals are incorporated for closed periods (not still showing forecast)
• Forecast vs prior forecast changes are explained with a variance bridge
• Forecast vs budget delta is quantified and communicated to management
• Seasonality is reflected in monthly/quarterly phasing
• Known items (signed contracts, committed costs) are reflected at actual amounts
• Headcount forecast ties to personnel cost forecast
• Cash flow implications are included (not just P&L)
• Forecast accuracy is tracked over time (MAPE by metric and lead time)
• Bias is measured separately from accuracy (systematic over/under-forecasting)
• Scenario overlays are driver-based, not arbitrary percentage adjustments