Driver-Based Forecast: Units × Price with Seasonality, Subscribers × ARPU, and a Mid-Year Price Rise
This lesson is part of the course
In this lesson
You build a twelve-month forecast from a handful of drivers – annual units, a seasonality index, a price rise from July, subscribers and ARPU – and total the year in one formula as a cross-check.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Budget vs Actual: Variances in € and %, Favourable or Unfavourable, and Which Lines Need a Comment Locked
- Price, Volume & Mix as an Interview Drill: Split a Revenue Variance in Four Lines Locked
- Driver-Based Forecast: Units × Price with Seasonality, Subscribers × ARPU, and a Mid-Year Price Rise Locked
- Headcount Cost Forecast: Loaded Monthly Cost, Start Months, Part-Year Cost and the Year-End Run-Rate Locked
- Bridging Last Year to This Year: Driver Steps, the Unexplained Gap, Underlying Growth and a Waterfall Locked
- Three-Statement Links: What Revenue, Depreciation, Receivables and Accruals Do to Profit and Cash Locked
- The Exhibit Case: Rank the Segments, Name the Three Biggest Drivers of a Profit Drop Locked
- Timed Mock Round: Eight Mixed Questions on One Data Set and a Self-Score Locked