# The IT Consulting Firm Owner: companion files

Julian R. Sterling

## What is here

- ITCF_1_Contracts_and_Pricing.xlsx (Chapters 2 and 3; Contracts and Pricing workbook of Appendix A): tabs Inputs, MRR, Renewals, Effective rate, then Checks. Users and devices by contract, monthly fees and renewal months, MRR month by month ($226,710 in January 2024, $270,612 in December 2025), the 2025 renewals, and the effective hourly rate ($160.67 per user and $72.92 per device in 2025).
- ITCF_2_Technician_Capacity.xlsx (Chapters 5 and 6; Technician Capacity workbook): tabs Inputs, Available hours, Client hours, Utilization, Standard cost, Hiring trigger, then Checks. Available hours by technician and by level, client hours by work type and by level, utilization (78.8 then 73.8 percent), the standard cost per hour ($39.17 for level 1 in 2025) and the hiring trigger.
- ITCF_3_Client_Profitability.xlsx (Chapters 4 and 7; Client Profitability workbook): tabs Inputs, Contract margin, Line margins, Concentration, then Checks. Contract margins ranked from the lowest, line margins, company gross margin and EBITDA, and the concentration of revenue.
- ITCF_4_Projects.xlsx (Chapter 9; Projects workbook): tabs Inputs, Tracking, Close-out, Register, then Checks. Every project from the quote to the close-out: hours worked against hours quoted, fees, labor, margin and revenue per hour worked ($446,775 of project revenue in 2025).
- ITCF_5_Cash_and_Credit_Line.xlsx (Chapters 12 and 13; Cash and Credit Line workbook): tabs Inputs, Receivables, Monthly cash, Line, then Checks. Receipts and payments by month, receivables (31.8 days at the end of 2025), the line of credit drawn and repaid in steps ($4,781 of interest in 2024) and closing cash ($495,626 at 31 December 2025).
- ITCF_6_Valuation_and_Decision.xlsx (Chapters 15 and 16; Valuation and Decision workbook): tabs Inputs, Adjusted EBITDA, Offer, Options, then Checks. Adjusted EBITDA ($351,492 for 2025), the consolidator's offer ($2,390,000, 6.80 times adjusted EBITDA; $2,018,626 to the founder at closing) and the options over three years. All projections, never results.
- ITCF_IT_Consulting_Firm_Owner_Checklists.docx: the 8 checklists of Appendix B, editable (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).

## How to use the workbooks

Each workbook opens on an Inputs tab that names the chapters it serves and lists its tabs in reading order. Inputs show the case's figures in blue on a light blue background, an empty yellow column for yours, and a Used column that takes your figure when you type one and the case figure otherwise; every formula reads the Used column. Where the case figures sit in a grid (contracts, technicians, months, projects), they are typed in place: overwrite them with your own. Black type is a formula, green type a link to another tab. Every cell that divides stays empty, never an error, until its divisor is entered. Rebuild the case first: the Checks tab of each workbook compares the live cells with the figures printed in the book and reads ALL CHECKS OK while the yellow cells are empty. Each of the 18 exercises of Appendix A is done in the workbook it names.

The arithmetic is plain: add, subtract, multiply, divide and round. When a figure is rounded, the note at the top of the tab says how, and which chapter explains it.

Two inputs to try first:

1. In ITCF_1_Contracts_and_Pricing.xlsx, on Inputs, change the price factor at renewal: every new price on Renewals moves, and the status column flags each fee on Inputs that no longer matches.
2. In ITCF_5_Cash_and_Credit_Line.xlsx, on Inputs, raise the cash floor: the Line tab draws earlier and more, the interest moves, and Monthly cash flags every month that would have sat below the floor.

To use a workbook on your own company, fill the inputs from your billing runs, the ticket system, the payroll register, the general ledger and the bank statements, in the order Appendix A gives, and keep a copy with the case for comparison. Keep your revenue lines apart from the first month, as chapter 1 defines them. Date every input. The workbooks are separate files with no link between them: when one needs a figure another computes (a standard cost per hour, EBITDA, closing cash), copy it across; its note says where it comes from.

## A word of caution

Brovaine Technology Group, the city of Ashwendle, Quellmore County, the company's founder, staff and clients, Fenstrick Bank and Strathenby Managed Services Group are fictional. Prices, salaries, rates, hours, tool costs, margins, multiples and terms are teaching assumptions, not market norms, targets or recommendations, and nothing here promises growth, a renewal or a sale price. Where state law or a contract decides, ask counsel; for insurance, ask your broker. No real vendor, distributor, software, platform, insurer, bank or consolidator is described or recommended. Nothing here is legal, tax, insurance, technical or accounting advice.
