Companion files · The Private Markets Career Guides

The IT Consulting Firm Owner

How to Run and Grow a Managed IT Services and Consulting Business: Recurring Contracts, Project Pricing, Technician Utilization, Margins, Cash Flow and Valuation.

These are the companion files of the book. Six workbooks follow Brovaine Technology Group, the fictional managed IT services and consulting company of the case, across two calendar years: contracts and pricing, technician capacity, client profitability, projects, cash and the line of credit, and the valuation and decision of the second year. Each keeps the case’s figures in one column and an empty column for yours. A toolkit holds the checklists of Appendix B in editable form.

The six workbooks, the toolkit and the read-me, in one archive171 KB

The archive holds the six workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in Excel, LibreOffice or Google Sheets.

The files

Three numbers to reproduce first

Effective hourly rate$127.41 / 0.793 = $160.67 per client hour on the per-user contracts in 2025: the average fee per user per month over the client hours per user per month
Utilization10,279 / 12,600 = 81.6 percent for level 2 in 2025: client hours over available hours
The offer$2,390,000 / $351,492 = 6.80 times 2025 adjusted EBITDA, for a price set from recurring revenue

The files are provided as they are, without warranty of any kind. The model is illustrative: Brovaine Technology Group, the city of Ashwendle, Quellmore County, the founder, the staff, the clients, the bank, the consolidator and every party are fictional; the prices, salaries, rates, hours, margins and multiples are the book’s assumptions, not market terms or the practice of any real company. Nothing here promises growth, a renewal or a sale price. Where state law or a contract decides, ask counsel.