The Exhibit Case: Rank the Segments, Name the Three Biggest Drivers of a Profit Drop
This lesson is part of the course
In this lesson
You read a segment exhibit under time pressure: change per segment, a rank of the declines with RANK.EQ, the three biggest drivers by name and how much of the total drop they explain.
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