The Customer Bridge: New, Lost and Existing Customers
This lesson is part of the course
In this lesson
You tag ten retail accounts as New, Lost or Existing with IFS and bridge last year's revenue to this year's: revenue won from new customers, revenue lost and the change at existing customers, all with SUMIFS.
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 by Product: Revenue Variance & Favourable Flags Locked
- Price & Volume Effects: Calculation Order and the Interaction Term Locked
- The Mix Effect: Budget Mix at Actual Volume, Pure Volume vs Mix Locked
- The Gross-Margin Bridge: Price, Volume, Mix & Unit-Cost Effects Locked
- The FX Effect: Constant-Currency Revenue and Underlying Growth Locked
- The Customer Bridge: New, Lost and Existing Customers Locked
- Flexed Budgets for Costs: Fixed vs Variable, Spending vs Volume Variances Locked
- The Bridge Chart: Waterfall, Materiality Flags & the Biggest Driver Locked