Companion files · The Private Markets Career Guides
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 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.
Chapters 2 and 3
Users and devices by contract, monthly fees, MRR month by month, the 2025 renewals and the effective hourly rate of each kind of contract. Tabs: Inputs, MRR, Renewals, Effective rate. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 123 KBChapters 5 and 6
Available hours by technician and by level, client hours, utilization, the standard cost of an hour and the hiring trigger. Tabs: Inputs, Available hours, Client hours, Utilization, Standard cost, Hiring trigger. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 222 KBChapters 4 and 7
Contract margins ranked from the lowest, line margins, the company gross margin, EBITDA and the concentration of revenue. Tabs: Inputs, Contract margin, Line margins, Concentration. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 330 KBChapter 9
Every project from the quote to the close-out: hours against the quote, fees, labor, margin and revenue per hour worked. Tabs: Inputs, Tracking, Close-out, Register. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 422 KBChapters 12 and 13
Receipts and payments by month, receivables, the line of credit drawn and repaid in steps, interest and closing cash. Tabs: Inputs, Receivables, Monthly cash, Line. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 523 KBChapters 15 and 16
Adjusted EBITDA, the consolidator’s offer and the cash at closing, then the options over three years, all projections. Tabs: Inputs, Adjusted EBITDA, Offer, Options. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 617 KBAppendix B
The first 90 days of reading the numbers; Reviewing a managed contract before renewal; Quoting a project; The monthly close and the dashboard; A client profitability review; Recruiting and onboarding a technician; Reviewing contract and insurance risks; Preparing a sale.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me5 KB| 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 |
| Utilization | 10,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.