Most budget templates get it backwards—they start with headcount and back into revenue. Real consulting firms forecast revenue first, then figure out what capacity they need to deliver it.
This model does it right.
What's inside:
Client-by-client revenue buildup with monthly timing
Pipeline opportunities weighted by win probability
Three complete scenarios (Downside / Base / Upside) with one-click switching
Capacity planning that derives hiring needs from revenue—not the other way around
Implied utilization by level to expose staffing imbalances
Realization rates by title (because Partners collect more than Consultants)
Admin fee revenue with realistic realization assumptions
Full P&L rollup with scenario comparison
Built for professional services:
5-level staff hierarchy (Partner through Consultant)
Delivery mix assumptions that drive blended rates
Utilization targets by level
Benefits load, bonus accruals, and attrition baked in
Ready to customize:
All inputs in blue, formulas in black
Assumptions centralized on one sheet
40-entry changelog documents every design decision
Instructions sheet explains the logic
10 sheets. 1,870 formulas. Zero circular references.

