Are you a law firm CFO experiencing signs of procrastination, insomnia, and occasional loss of concentration? There is a technical name for this disorder, it’s:
SuperMicroCalculatingBudgetingNeurosis
The very sound of it
Suggests a bad prognosis
But have no fear, this is a
Common accounting work psychosis
If you are a CFO,
There’s a simple diagnosis
It’s a simple fear your
Budget numbers might be atrocious
It’s SuperMicroCalculatingBudgetingNeurosis.
apologies to Mary Poppins, CFO
If you suffer from SuperMicroCalculatingBudgetingNeurosis, there is good news: It is never too late to publish the Law Firm Budget.
A comprehensive law firm budget entails three distinct components:
In most law firms, the individual lawyers and other timekeepers are the revenue generators. Their annualized billable hours, rates, billing realization, and collection realization efforts produce the firm’s revenue. Since most firms use a modified cash basis of accounting, the revenue budget needs to analyze:
I typically break this process into three phases — estimating the billable hours and billable time value projections, then the fee billing and fee revenue projections.
This process involves a spreadsheet consisting of columns detailing annualized billable hours of the prior year and projecting billable hours of the coming year, and the effective hourly rate for those hours for last year’s timekeepers and continuing timekeepers and those expected to be added during the year. I generally present two alternative columns for the coming year’s annualized billable hours projections — one labeled “Reasonable Projection” and the other representing a “Reasonable Projection plus a 6% increase (“R.P.+6%”) — which represent an additional two billable hours per week for a lawyer working 1,800 billable hours annually. The Reasonable Projection and R.P +6% columns are then multiplied by the applicable projected hourly rate for each timekeeper to yield two potential billable time value projections.
Among the year-to-year statistics I track for my law firm clients are the relative mathematical relationship between their actual billable time value for prior years and each respective year’s fee billing total, as well as the relationship between total fee billing and total fee revenue for the year. Assume a typical growing transactional/commercial litigation firm with the annual statistics shown in Columns C, D, and E.
A | B | C | D | E | F | G | H |
2016 Actual | 2017 Actual | 2018 Actual | 2019 Reasonable Projection | 2019 R.P +6% | |||
1 | Billable Hours | 23,269.7 | 25,732.8 | 28,053.8 | 1 | 29,456.0 | 31,223.3 |
2=3/1 | Effective hourly rate | $321.62 | $323.82 | $335.00 | 2=3/1 | $345.00 | $345.00 |
3 | Billable Time Value | $7,484,054 | $8,332,811 | $9,397,752 | 3 | $10,162,308 | $10,772,046 |
4=5/3 | "Inventory Turn" | 95.6% | 95.4% | 95.1% | 4 | 95.2% | 95.2% |
5 | Fee Billing | $7,152,772 | $7,952,072 | $8,940,632 | 5=3*4 | $9,674,517 | $10,254,988 |
6=7/5 | "Inventory Turn" | 91.5% | 94.0% | 91.2% | 6 | 93.0% | 93.0% |
7 | Fee Revenue | $6,544,786 | $7,474,948 | $8,151,370 | 7=5*6 | $8,997,301 | $9,537,139 |
Over the last three years, this firm invoiced clients (i.e., fee billings for the year) an amount equal to 95.6%, 95.4%and 95.1% of its billable time value recorded during the year. Similarly, the firm collected (i.e., fee revenue) equal to 91.5%, 94.0% and 91.2% of the aggregate annual fee billing. Assuming a continuation of those historic trends, absent other factors, the law firm’s revenue budget adopted the following revenue goals:
Word to the Wise #1: If your firm is achieving its revenue budget number each year, you may not be setting the bar high enough. Remember, reach should exceed your grasp. If you have questions or would like to discuss your law firm's budget then feel free to contact 4L Law Services.
Note: This article is the first of a two-part blog series on the law firm budget process.