Law Firm Pro Forma
Operating Businesses Excel Template (Free Download)
Project partner growth, leverage, utilisation, practice revenue, profitability, cash flow, and valuation for a law firm.
professionals from Deloitte
About this pro forma
This pro forma presents the projected economics of a corporatized law firm, linking equity partners and associate leverage to billable capacity, practice mix, rates, realization, and success fees. Compensation, support staff, occupancy, business development, technology, and insurance flow through to projected profit per equity partner.
Use the output to assess hiring, pricing, partner leverage, cash requirements, and enterprise value. The Excel model is the underlying calculation engine; the pro forma is the projected decision output.
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 Law Firm Pro Forma
- Projected equity-partner and associate capacity
- Billable hours, utilisation, rates, and realization forecast
- Practice-group revenue and success-fee projection
- Compensation, overhead, EBITDA, and PEP outputs
- Working capital, capex, and unlevered cash flow
- Enterprise value, equity value, and value per share outputs
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 does this law firm pro forma project?+
It projects fee-earner capacity, billable revenue, costs, EBITDA, profit per equity partner, cash flow, and valuation.
Can I test partner leverage?+
Yes. Partner additions, associate leverage, utilisation, rates, realization, and practice mix are model drivers.
Is PEP included?+
Yes. The projected output includes profit per equity partner alongside revenue, EBITDA, and cash flow.
What is the underlying engine?+
The linked Excel financial model calculates the forecast, while this pro forma presents the projected decision outputs.
Have more financial modelling questions? Contact us
Related pro formas
Consulting Firm Pro Forma
Five-year pyramid model: headcount, utilization, billable rate, comp, and margins.
Staffing Agency Pro Forma
Plan and value a staffing agency using recruiter capacity, worker placements, client billing, and operating costs.
CRO Pro Forma
Aggregate risk metrics and exposures across the organization with heat maps and limits.
Food Manufacturing Pro Forma
Operating model for food production and processing businesses with ingredient sourcing, production scheduling, and margin analysis.
