Consulting Firm Model
Operating Businesses Financial Model (Free Excel Download)
Forecast consultants, utilisation, billing rates, project mix, hiring, compensation, margins, and cash collection to plan a professional-services firm.
professionals from Deloitte
Used by professionals from
About this model
A consulting-firm operating model projects a five-year P&L for a professional-services business built on the pyramid: revenue is the product of billable headcount, utilization, and realized rate per level, and the partner leverage between non-billable and billable seats drives both revenue per FTE and EBITDA margin. The workbook organises five levels (Analyst, Associate, Manager, Principal, Partner) into a single Assumptions sheet with one row per level holding starting headcount, annual growth, utilization, billable hourly rate, and fully-loaded compensation, plus a small operating block for billable hours per FTE, non-comp opex ratio, D&A ratio, and tax rate, and a status-threshold block that drives traffic-light logic on the Dashboard.
The Headcount sheet builds closing HC by compounding the starting count at the level growth rate, then computes an average HC for each year (opening plus closing, divided by two) so revenue and compensation are charged against the activity base rather than the year-end snapshot. A partner-leverage block computes the ratio of non-partner FTEs to partner FTEs each year so the user can see whether the pyramid is staying healthy as the firm scales. The Revenue sheet multiplies average HC by hours per FTE and per-level utilization to derive billable hours, then by per-level rate to derive revenue. The P&L pulls revenue from the Revenue sheet, expands compensation across the five levels (average HC × comp per FTE), subtracts non-comp opex as a percentage of revenue to get EBITDA, then layers D&A, tax (max of EBIT and zero × tax rate), and net income. The Dashboard reads Y5 revenue, Y5 EBITDA, EBITDA margin, blended utilization (total billable hours / total potential hours), revenue per FTE, partner leverage, and comp ratio, attaching On track / Watch / Stretched status against user-set thresholds, alongside a Y5 pyramid-mix table.
Managing partners, CFOs, operations leaders, and PE / search-fund buyers use this template for partner-economics negotiation, hiring-plan stress tests, and quick valuation diligence on professional-services targets. The defaults reflect a high-end strategy boutique (78% analyst utilization, $1,100 partner rate, 18% non-comp opex) - flex the inputs down for a typical mid-market firm or up for elite strategy / law boutique benchmarks.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Consulting Firm Model
- Five consulting levels (Analyst, Associate, Manager, Principal, Partner) with editable HC, growth, utilization, billable rate, and comp per FTE
- Headcount sheet with closing and average HC and partner-leverage block
- Revenue sheet rolling billable hours and revenue per level into firm totals and revenue per FTE
- P&L from revenue through compensation, non-comp opex, EBITDA, D&A, tax, and net income, with EBITDA and net margin lines
- Dashboard with Y5 revenue, EBITDA, EBITDA margin, blended utilization, revenue per FTE, partner leverage, comp ratio, and total headcount
- Status thresholds in Assumptions so on-track / watch / stretched logic can be tuned
- Dashboard with traffic-light status on Y5 EBITDA margin, blended utilization, revenue per FTE, plus pyramid mix and Y5 partner leverage
How the Consulting Firm Model Builds Revenue and Profit from the Pyramid
This consulting firm model demonstrates a five-year operating plan built on a headcount pyramid. Revenue is driven by average billable headcount, utilization, and realized rates per level.
The model then flows through a detailed P&L, working capital, and cash flow, ending in a one-page dashboard with metric status. The public preview is values-only, so live formulas are not included.
Operating Drivers Behind Pyramid Revenue
The model begins with five billable levels: Analyst, Associate, Manager, Principal, and Equity Partner. For each level, you set starting headcount, annual growth, utilization percentage, billable rate, and fully-loaded compensation.
- Bench and support staff across business development, recruiting, operations, and marketing are also defined. Operating parameters include billable hours per FTE, non-compensation opex, depreciation, tax rate, and learning and development spend.
- Partner economics are separated into a base draw and a profit-share percentage. These assumptions feed every downstream sheet, linking headcount plans directly to revenue and cost outcomes.
Calculation Flow from Hours to Net Income
Revenue is calculated level by level as average headcount times billable hours times utilization times billing rate. That gross revenue is reduced by a per-level realization percentage and a portfolio-wide write-down percentage to produce realized revenue.
- Compensation for non-partner levels is average headcount times fully-loaded cost per FTE; equity partner compensation is the base draw above EBITDA. G&A compensation covers bench and support staff.
- A bonus accrual is calculated as a percentage of pre-bonus EBITDA, floored at zero. The P&L then deducts all compensation, non-comp opex, recruiting, and L&D to arrive at EBITDA, then subtracts D&A for EBIT, applies NOL carry-forward and tax, and reaches net income.
Partner distribution is a share of positive net income, with retained earnings holding the remainder.
Outputs and Diagnostic Dashboard
The model produces a one-page dashboard with headline metrics such as Year 5 revenue, EBITDA, EBITDA margin, blended utilization, average revenue per FTE, Associate-to-Equity-Partner leverage, profit per equity partner, compensation ratio, total headcount, book-to-bill, and backlog coverage.
- Each metric includes a traffic-light status based on user-flexible thresholds.
- The dashboard also shows leverage variants for Associates, Managers, and Principals per Partner, plus a Year 5 pyramid mix block.
- A Checks sheet provides ten PASS/FAIL diagnostics covering revenue tie, compensation tie, headcount roll, realization bounds, backlog non-negativity, working capital tie, bonus pool sanity, pyramid mix totaling 100%, P&L identity, and non-negative NOL.
Practical Use and Scenario Planning
This consulting firm model is designed for professionals evaluating how headcount, utilization, and pricing affect firm profitability over a five-year horizon. It captures the pyramid leverage effect and separates partner compensation into a base draw and profit share, which clarifies the economics of equity ownership.
- The working capital build tracks accounts receivable, unbilled work in progress, and accrued compensation, feeding a mini cash-flow block. A Pipeline and Backlog sheet adds forward bookings and coverage metrics.
- The model is asset-light, with capex out of scope but D&A included as a revenue-ratio line. The public download is a values-only preview, not a live formula workbook.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a consulting-firm model?+
A consulting-firm model projects revenue, compensation, and margin for a professional-services business built on the pyramid: revenue is the product of billable headcount, utilization, and realized rate per level, and partner leverage drives both revenue per FTE and EBITDA margin.
How is revenue calculated?+
Revenue per level = average headcount × billable hours per FTE × utilization × billable rate. Headcount is averaged between opening and closing each year so a mid-year hiring path does not overstate the activity base.
What utilization should I assume?+
Realistic ranges are 70–85% for analysts / associates, 60–75% for managers, and 40–60% for partners. The remainder is sales, recruiting, training, and management. Defaults reflect a high-end strategy boutique - flex them down for a more typical mid-market firm.
Why are partners shown as a comp line rather than a profit distribution?+
For simplicity. Partner comp is fully loaded into the compensation row so EBITDA is comparable across partner / non-partner pyramid mixes. To split partner comp from profit distribution, route partner comp through net income instead and adjust the EBITDA bridge.
Does the model include a balance sheet?+
No. Consulting firms are asset-light and most of the BS is cash + receivables + accrued comp. Capex and working capital are out of scope - pair with the working-capital or 3-statement template if you need a full BS view.
Have more financial modelling questions? Contact us
Related templates
Hiring Model
12-month headcount, comp expense, and sales-productivity forecast across five departments.
Sales Rep Forecast
Bottoms-up rep-level forecast with cohort ramp curves and attainment vs an annual target.
3 Statement Model
Integrated income statement, balance sheet, and cash flow forecasts.
Food Manufacturing Model
Operating model for food production and processing businesses with ingredient sourcing, production scheduling, and margin analysis.
