Advertising agency financial model: revenue and capacity

An advertising agency financial model connects client fee commitments to the staff hours and outside costs needed to deliver them. Build the fee plan and capacity plan together, then add collections and client media payments. That shows whether a full project calendar produces profit and enough cash to meet payroll.

Assemble the records before forecasting fees

Start with signed retainers, project statements of work, approved project budgets, timesheets, payroll and freelancer commitments. Add client invoices, open receivables and any media billing and payment records. Give every project a consistent client identifier and service month.

Keep the approved budget, latest outlook and actual results in separate columns. A revised project estimate should not erase the fee or delivery commitment management originally approved. The IRS recordkeeping guidance identifies sales, payroll and purchasing documents as the support behind business transactions; preserve those references when combining exports.

For the example below, a US agency plans October 2026. The fees are assumed earned and invoiced in that month. There is no opening or closing unbilled work, deferred fee revenue or sales tax. These simplifying assumptions make the reconciliation visible; add separate schedules when your contracts require them.

Calculate fees and required delivery hours

Use one row per project group. Retainers contain three clients, campaigns contain two projects, and advisory contains one engagement. All monetary amounts are USD.

Put these columns in A:F, starting on row 2. Fee revenue in F2 is:

=B2*C2

Fill down through row 4. Total fees are =SUM(F2:F4), delivery demand is =SUM(D2:D4) and freelancer costs are =SUM(E2:E4).

The agency's effective fee per staff delivery hour is 240,000 / 1,368 = $175.44, rounded to cents. It is a management ratio for this mix of work, not a contractual billing rate. A fixed-fee project can consume more hours without generating additional fees, which is why utilization and realization need to be read together.

Check whether the staffing plan can deliver it

Available hours exclude planned absences. Loaded payroll includes salaries, employer taxes and benefits. The utilization assumptions below represent the share of available time assigned to client delivery.

With these columns in A:G, compute capacity as follows:

E2 = B2*C2
F2 = E2*D2
Total utilization = SUM(F2:F4)/SUM(E2:E4)

Total utilization is 71.25%. Delivery demand equals capacity at 1,368 hours. That company total is only the first check: map each project's hours to creative, strategy and client services before concluding that every role fits. Spare strategy time cannot automatically replace a designer.

Reconcile fee contribution and scope changes

Subtract the full loaded payroll, freelancer costs and the supplied overhead budget. This management schedule treats all delivery-team payroll as a direct cost, including internal time. Keep that classification consistent with your gross profit margin reporting.

Delivery contribution margin is 69,000 / 240,000 = 28.75%. Now change one assumption: campaigns need another 160 delivery hours while their contracted fees stay unchanged. Staff capacity is already assigned, so assume the extra work goes to freelancers at a supplied $75 an hour.

Outside cost rises by 160 × 75 = $12,000. Operating profit falls to $12,000. Required staff-scope hours rise to 1,528: employees cover the original 1,368 hours and freelancers cover the incremental 160. Hours for the original freelancer commitments remain outside this staff-capacity schedule. The extra work has halved profit without changing the fee forecast; that is the case for a scope discussion before assigning the hours.

Separate agency cash from client media flows

Suppose the agency opens with $90,000 cash, collects $220,000 of fees and receives $180,000 specifically for client media. It pays that same $180,000 to media suppliers. All base-case delivery costs and overhead are paid during October.

The check is =90000+220000+180000-141000-30000-45000-180000. Gross receipts are $400,000, but the media flow contributes zero net cash in this example. The management fee schedule does not determine gross-versus-net financial-statement presentation; finance must reconcile it to the applicable accounting policy.

Opening fee receivables of $180,000 plus invoices of $240,000 less collections of $220,000 leave $200,000. Tie that amount to the aging report before changing collection assumptions. The SBA finance guide specifically includes receivables, payables, available cash and bank reconciliation among core finance responsibilities.

Where agency planning goes wrong

• Fees without hours. Retainer revenue looks stable while extra rounds of work absorb capacity.
• One utilization percentage for every role. A company total hides bottlenecks in individual disciplines.
• Media cash treated as spendable agency income. Supplier obligations can fall due before other customers pay.
• Freelancers counted twice. Deduct outside costs once and distinguish outside hours from employee capacity.

For the broader funding view, use the startup financial model; keep this schedule focused on agency delivery economics.

Compare your agency workbook in Covirage

Bring a sample of your own project budgets, timesheets, fee invoices and payment exports to Covirage. Covirage maps the columns, and its tools compute and check fee, capacity, cost and cash figures; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring your agency's files after setting up your business.

See Covirage for professional services for the supporting industry context.