Companion files · The Private Markets Career Guides
Marketing Agency Business by the Numbers: Retainers, Billable Hours, Utilization, Client Profitability, Pricing, Freelancers, Client Money, Cash Flow and What Your Agency Is Worth.
These are the companion files of the book. Seven workbooks follow Sorrelby Digital, the fictional digital marketing agency of the case, across two fiscal years: client gross profit, utilization, a fixed-fee project, a client’s media money, receivables and the line of credit, a hire set against bought hours, and a buyer’s letter of intent. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the seven workbooks, the toolkit and 00_START_HERE.md. No macros, no date functions, no links between files, no password; the only functions are SUM, ROUND, MIN, IF and AND. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapter 5
One client in one month: its share of delivery staff cost by hours, the studio hours bought for it and its client gross profit, checked against the monthly client report. Sheets: Inputs, Client. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 111 KBChapter 3
Billable hours by client group, available hours and utilization for a year, checked against the time records. Sheets: Inputs, Utilization. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 211 KBChapter 7
A fixed-fee project read after the fact: fee per estimated and per recorded hour, staff cost month by month, project gross profit and hours above the estimate. Sheets: Inputs, Project. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 311 KBChapter 13
One month of a client’s media money: the fee, the card charged and paid, the deposit applied and the deposit held. Sheets: Inputs, Media. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 411 KBChapter 14
Receivables rolled forward over a year, and the line of credit tested against its borrowing base and limit at a month end. Sheets: Inputs, Roll-Forward, Borrowing Base. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 513 KBChapter 10
A designer’s cost set beside the same hours bought from a studio, and the designer’s utilization. Sheets: Inputs, Comparison. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 611 KBChapter 16
Net income to EBITDA to adjusted EBITDA, a buyer’s letter of intent with its earn-out, and the working capital adjustment at closing. Sheets: Inputs, Bridge, Letter, Closing. An Inputs sheet holds every number; a Checks sheet tests the controls of Appendix A.
Download workbook 714 KBAppendix B
The monthly numbers review; A retainer renewal; Quoting a fixed-fee project; Opening a new client; Client money; A freelancer file; A campaign with creators, reviews or email; Preparing for a sale.
Download the toolkit41 KBRead first
What each file holds, which workbook answers which chapter, and how to use the workbooks on your own agency.
Download the read-me4 KB| Utilization | FY2026 billable hours 17,751 over 24,640 available hours: 72.0 percent, against 67.3 percent in FY2025 |
| A client’s month | Hadrowe in September 2026: revenue $26,000, less a share of delivery staff cost of $15,874 and studio hours of $380: client gross profit $9,746 |
| The adjusted EBITDA | EBITDA $190,151, the owner’s pay added back, a replacement’s pay deducted, the unpaid milestone treated as one-time: $202,351 |
The files are provided as they are, without warranty of any kind. The model is illustrative: Sorrelby Digital, Lindercombe and every party are fictional, and the fees, hours, rates, wages, payment terms, line terms, prices and multiples are the book’s assumptions, not market terms or the practice of any real agency, client, studio, bank or buyer. Rules change: check the current texts, your outside CPA and counsel in your state.