SaaS renewal bookings variance FP&A interview case
Explain a renewals miss through eligibility, conversion, and contract value. Different causes call for different actions.
Wall Street Playbook ·
Work the sales bridge
The plan expects 500 accounts to come up for renewal, an 80% renewal rate, and $1,000 of average annual contract value. Plan bookings are $400,000. Actuals are 450 eligible accounts, a 76% renewal rate, and $1,050 annual contract value. Actual bookings are $359,100.
At plan rates and price, eligibility explains negative $40,000. Applying the 4-point rate miss to the 450 eligible accounts explains negative $18,000. Charging $50 more on the 342 actual renewals adds $17,100. The three movements reconcile to negative $40,900.
Give a recommendation
Look at renewal dates before treating missing eligibility as churn. Give Customer Success a cohort view of the 18-account rate gap. Communicate booked annual value separately from cash and recognized revenue.
FP&A Interview & Case Workbook
Get the complete guide when you’re ready for more practice.
Sale price $50.15 Original price $59