Consulting Pro Forma Template

Start with the Assumptions sheet — this is where you set the foundation for every projection in the model. Fill in your current or projected headcount by role, your target billable hours per week, and billing rates for each tier. If you're a solo consultant, you'll just have one row; if you're projecting a team build-out, add rows for each hire. Spend time here getting the inputs right rather than editing individual cells elsewhere — the whole model will recalculate instantly when you adjust an assumption.

Move to the Revenue Projections sheet and review how the model translates your assumptions into monthly revenue. Check that the utilization rate feels realistic — most solo consultants are fully booked at 60–70% utilization once you account for business development, admin, and downtime between projects. Adjust the retainer count and average retainer value to reflect your current book of business, then set growth rate assumptions for how many new clients you expect to add each quarter. Run both the base case and optimistic scenario to understand your revenue range.

Once revenue looks right, review the Expense Projections and make sure every material cost category is included. Consulting firms often underestimate subcontractor fees when they're projecting rapid growth, and they frequently forget to budget for business development travel and conference attendance. After expenses are set, the Projected P&L and Cash Flow sheets will show you whether your margins are healthy enough to support the business plan and whether you'll have enough cash on hand during the early months when invoices are outstanding but expenses are being paid.

Consulting firms face a projection challenge that product companies don't: revenue is entirely time-dependent. You can't build inventory during slow periods and sell it later — if your consultants aren't billing, that capacity is gone. A pro forma forces you to model utilization rate explicitly, which is the number most consulting firm owners either don't track at all or track informally. When you see utilization at 55% in a projection and know your break-even is 60%, you have a target. Without that model, you're flying without instruments.

The right consulting pro forma separates direct project costs from overhead, which is the distinction that makes gross margin meaningful. If you're paying subcontractors to deliver client work, that cost should show up as cost of revenue — not as an operating expense — because it moves with revenue. When gross margin is calculated properly, you can see what the business earns before paying for the fixed infrastructure that supports it. Most healthy consulting firms run 50–70% gross margins and 20–35% net margins, depending on whether they're delivery-heavy (using lots of subcontractors) or leverage-heavy (senior partners billing at premium rates with junior staff doing execution).

A pro forma also solves a practical problem: lenders and investors who don't know the consulting industry will ask for projections in a standard format. The standard format is a P&L, a balance sheet, and a cash flow statement — forward-looking versions of the documents your accountant files each year. This template generates all three in a format that's immediately recognizable to a bank loan officer or potential business partner, without requiring you to rebuild a model from scratch or hire a financial consultant to prepare the projections for you.