# The Marketing Agency Owner: companion files

Julian R. Sterling

## What is here

- **Marketing_Agency_1_Client_Profitability.xlsx** (Chapter 5; Client Profitability workbook of Appendix A): sheets Inputs, Client, then Checks. One client in one month: its share of delivery staff cost, the studio cost and the client gross profit (Hadrowe in September 2026: $9,746).
- **Marketing_Agency_2_Utilization.xlsx** (Chapter 3; Utilization workbook): sheets Inputs, Utilization, then Checks. Billable hours, available hours and utilization for a year (72.0 percent in FY2026, 67.3 percent in FY2025).
- **Marketing_Agency_3_Project_Pricing.xlsx** (Chapter 7; Project Pricing workbook): sheets Inputs, Project, then Checks. A fixed-fee project read after the fact: the fee per estimated and per recorded hour, the staff cost month by month and the project gross profit (P-07: $16,362, 85 hours above the estimate).
- **Marketing_Agency_4_Media_and_Client_Money.xlsx** (Chapter 13; Media and Client Money workbook): sheets Inputs, Media, then Checks. One month of a client's media money: the fee, the card charged and paid, and the deposit held at the month end (Gorrindale in June 2026: $100,000 held).
- **Marketing_Agency_5_Receivables_and_Line.xlsx** (Chapter 14; Receivables and Line workbook): sheets Inputs, Roll-Forward, Borrowing Base, then Checks. Receivables rolled forward over a year ($280,350 at the end of FY2026) and the line of credit tested against its borrowing base at a month end (a room of $35,320 in December 2025).
- **Marketing_Agency_6_Hire_or_Subcontract.xlsx** (Chapter 10; Hire or Subcontract workbook): sheets Inputs, Comparison, then Checks. A hire set against the same hours bought (the designer: $72,373 against $85,120).
- **Marketing_Agency_7_Valuation.xlsx** (Chapter 16; Valuation workbook): sheets Inputs, Bridge, Letter, Closing, then Checks. The bridge to an adjusted EBITDA of $202,351, the letter's price ($809,404), cash at closing and earn-out, and an illustration of closing ($428,800 to the owner, before taxes and fees).
- **Marketing_Agency_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (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).

## How to use the workbooks

Every workbook opens on its Inputs sheet: blue type on a light blue background is an input, and nothing else is typed by hand. Each subject has its own sheet, read top to bottom, one line per step. Black type is a formula, green type a figure read from another sheet of the same workbook. The Checks sheet holds the checks of Appendix A: each one is an IF test on your own inputs that shows OK when they hold together and CHECK when they do not. A comparison set beside a result (the designer's cost beside the same hours bought) is a reading aid on the subject sheet, never OK or CHECK. The default inputs are the case figures, so a workbook opened for the first time shows the numbers of the chapter it serves, and each of the 7 exercises of Appendix A is done in its own workbook.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, IF and AND. No date function is used: a month or a fiscal year is a label you type, and every count of hours or months is an input.

To use a workbook on your own agency, start with a copy, replace every blue input from the record that owns each figure (the time records, the monthly client report, the aging report, the income statement), keep every check at OK, and compare a result only with the same agency's own earlier months and years. Never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share (the studio rate, the advance rate, the payroll taxes and benefits rate) is typed again where it is used.

## A word of caution

Sorrelby Digital, LLC, the town of Lindercombe, Hadrowe Home Services, Gorrindale Outdoor Supply, Sablewick Fitness, Yarrowcliff Studio, Dunwistle National Bank, Kestovar Media Group and every party in the case are fictional. Fees, hours, rates, wages, costs, payment terms, line terms, prices and multiples are teaching assumptions, not market norms or recommendations. Rules change: read them in their current text, with your outside CPA and counsel in your state. No platform, software, bank or real company is described or recommended. Nothing here is legal, tax, accounting or employment advice.
