# Consulting Firm Model A five-year pyramid operating model for a professional-services / consulting firm. Project revenue from per-level headcount, utilization, and billable rate, run it through a P&L with fully-loaded compensation and non-comp opex, and read margin, utilization, revenue per FTE, and partner leverage off a one-page dashboard with traffic-light status. - Canonical: https://finamodel.com/templates/consulting-firm - Excel download: https://finamodel.com/templates/consulting-firm.xlsx - Category: Operating Businesses - Model type: Operating model - Difficulty: Intermediate - Audiences: Founders & operators, CFOs & FP&A, Managing partners, CFOs, Operations leaders, PE / search-fund buyers - Tags: consulting, professional services, utilization, billable, partner leverage ## Overview 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's included - 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 - Headcount sheet with closing and average HC and a partner-leverage block - P&L with total comp by level, non-comp opex, EBITDA, D&A, tax, net income, EBITDA margin, and net margin - Dashboard with traffic-light status on Y5 EBITDA margin, blended utilization, revenue per FTE, plus pyramid mix and Y5 partner leverage - Status thresholds in Assumptions so the on-track / watch logic can be tuned by the user ## 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. ## Built around partner leverage Each of the five levels carries its own utilization, billable rate, and fully-loaded comp, so the model captures the leverage that drives partner economics rather than blending it away into a single average. ## Named-range driven assumptions Every per-level driver lives in Assumptions as a single-cell named range. Flexing a starting headcount, growth rate, or rate card recomputes everything downstream immediately. ## Dashboard with status logic Headline metrics resolve to On track / Watch / Stretched against user-set thresholds, alongside a Y5 pyramid-mix table that makes the org structure tradeoffs visible on one page. ## Built around partner leverage Each of the five levels carries its own utilization, billable rate, and fully-loaded comp, so the model captures the leverage that drives partner economics rather than blending it away into a single average. ## Named-range driven assumptions Every per-level driver lives in Assumptions as a single-cell named range. Flexing a starting headcount, growth rate, or rate card recomputes everything downstream immediately. ## Dashboard with status logic Headline metrics resolve to On track / Watch / Stretched against user-set thresholds, alongside a Y5 pyramid-mix table that makes the org structure tradeoffs visible on one page. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: per-level inputs, operating parameters, status thresholds. - Five levels with starting HC, growth, utilization, billable rate, comp per FTE - Billable hours per FTE, non-comp opex ratio, D&A ratio, tax rate - EBITDA margin, utilization, revenue per FTE thresholds for status logic ### Headcount Closing and average HC per level, plus partner leverage block. - Closing HC built from starting headcount × growth compounding - Average HC = (opening + closing) / 2 for the activity base - Partner leverage = non-partner HC / partner HC per year ### Revenue Billable hours and revenue per level, totals, and revenue per FTE. - Billable hours = avg HC × hours per FTE × per-level utilization - Revenue = billable hours × per-level rate - Total revenue and revenue per FTE roll up at the bottom ### P&L Revenue to net income, with margins. - Total revenue from Revenue sheet - Compensation per level (avg HC × comp per FTE) - Non-comp opex (% revenue), EBITDA, D&A, EBIT, tax, net income - EBITDA margin and net margin lines - Identity check that closes the P&L bridge ### Dashboard One-page metrics with traffic-light status. - Y5 revenue, EBITDA, EBITDA margin (with status) - Blended utilization across all years (with status) - Revenue per FTE (with status), partner leverage, comp ratio, total HC - Y5 pyramid mix as HC and % of total ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: per-level inputs, operating parameters, status thresholds. - Five levels with starting HC, growth, utilization, billable rate, comp per FTE - Billable hours per FTE, non-comp opex ratio, D&A ratio, tax rate - EBITDA margin, utilization, revenue per FTE thresholds for status logic ### Headcount Closing and average HC per level, plus partner leverage block. - Closing HC built from starting headcount × growth compounding - Average HC = (opening + closing) / 2 for the activity base - Partner leverage = non-partner HC / partner HC per year ### Revenue Billable hours and revenue per level, totals, and revenue per FTE. - Billable hours = avg HC × hours per FTE × per-level utilization - Revenue = billable hours × per-level rate - Total revenue and revenue per FTE roll up at the bottom ### P&L Revenue to net income, with margins. - Total revenue from Revenue sheet - Compensation per level (avg HC × comp per FTE) - Non-comp opex (% revenue), EBITDA, D&A, EBIT, tax, net income - EBITDA margin and net margin lines - Identity check that closes the P&L bridge ### Dashboard One-page metrics with traffic-light status. - Y5 revenue, EBITDA, EBITDA margin (with status) - Blended utilization across all years (with status) - Revenue per FTE (with status), partner leverage, comp ratio, total HC - Y5 pyramid mix as HC and % of total ## Features - **Per-level pyramid economics:** Each of the five levels carries its own utilization, billable rate, and fully-loaded comp, so the model captures the leverage that drives partner economics rather than blending it away. - **Named-range driven assumptions:** Every per-level driver is a single-cell named range (StartHC_Analyst, Rate_Partner, etc.), so formulas read cleanly across sheets and a flex on one assumption recomputes everything immediately. - **Dashboard with status logic:** Headline metrics resolve to On track / Watch / Stretched against user-set thresholds. Pyramid mix and partner leverage make the org structure tradeoffs visible on one page. ## Use cases - **Partner economics negotiation:** Flex partner headcount, utilization, and comp-per-FTE to see how each lever moves Y5 EBITDA margin and revenue per FTE. - **Hiring plan stress test:** Increase associate or manager growth rate to see whether leverage stays in the 4-8x healthy band or compresses partner economics. - **Search-fund or PE diligence:** Drop a target firm's rate card, headcount, and utilization into the inputs and validate revenue per FTE and margin against industry benchmarks before signing an LOI. ## Frequently asked questions ### 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. ## Related templates - [Hiring Model](https://finamodel.com/templates/hiring-model) - [Sales Rep Forecast](https://finamodel.com/templates/sales-rep-forecast) - [3 Statement Model](https://finamodel.com/templates/3-statement-model)