Law Firm Pro Forma Template

Start on the Assumptions sheet — it drives the entire model. Enter your billing rates by attorney level, target billable hours, realization rate, and collection rate. If you're projecting a new practice, use conservative benchmarks for Year 1 (70–75% realization, 85% collection) and build toward industry norms by Year 3. If you're modeling an established firm or a lateral expansion, pull actual numbers from your current financials. Getting these inputs right takes 20–30 minutes, but it's what makes the rest of the model credible.

With assumptions set, move to the Revenue Projections sheet and fill in your expected matter volume and average matter value by billing type and practice area. Be specific: a litigation group projecting 40 matters per year at an average $15,000 flat fee is a very different model than an hourly practice billing 1,800 hours per attorney. Once revenue is in, review the Expense Projections sheet and adjust compensation, overhead, and headcount ramp for each year. The model will flag if your expense growth outpaces revenue growth.

Use the Cash Flow sheet to understand how the billing-to-collection lag affects your first two years — this is where many new and expanding practices run into trouble even when the annual numbers look fine. Share the Dashboard with your banker, prospective partner, or managing committee. The pre-built charts and summary metrics communicate your financial plan clearly without requiring them to dig through the underlying worksheets. Update the model quarterly with actuals as you build your firm.

A law firm pro forma is a specific kind of financial projection — one that has to account for how legal practices actually generate and collect revenue. Unlike a retail business where a sale is a sale, law firms bill for time or matters, apply a realization rate (the percentage of billed time actually invoiced), and then collect a percentage of invoiced amounts, typically 60–120 days later. A pro forma that ignores this sequence will show profitability that doesn't materialize as cash, which is the single most common financial surprise for attorneys starting or expanding a practice.

The numbers that matter most in a law firm pro forma are billable hours per attorney, realization rate, and collection rate — in that order. An attorney billing 1,800 hours at a $400 rate looks like $720,000 in gross production. At a 90% realization rate and 95% collection, that becomes $615,600 in collected revenue. Add a second attorney and you're modeling $1.2 million — subtract compensation, malpractice insurance, overhead, and technology costs, and you have a realistic picture of what the practice can generate. Most lenders and potential partners will build exactly this model; having it ready in your first conversation signals credibility.

The other function of a law firm pro forma is scenario planning. What happens to revenue if realization drops from 90% to 78% — a realistic outcome in Year 1 while building client relationships? What's the cash position in month 9 if a major contingency matter settles in month 12 instead? What does the model look like if you bring in one lateral partner versus two associates? This template is designed so you can answer those questions in minutes by adjusting the Assumptions sheet, not rebuilding the entire spreadsheet.