Marketing Agency Model
Operating Businesses Financial Model (Free Excel Download)
Forecast marketing-agency performance from clients, retainers, project revenue, utilization, pricing, delivery payroll, contractors, sales pipeline, and cash flow.
professionals from Deloitte
Used by professionals from
About this model
This model helps a marketing agency plan recurring retainers, project work, and client growth. It connects new business, churn, pricing, and team capacity to the cost of delivering work and acquiring clients.
Use it to test a hiring plan, changes in client mix, or a growth target. The summary shows how those decisions affect margins, cash flow, and the value of the agency.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Marketing Agency Model
- Client-roster inputs: starting clients, new wins, win growth, churn rate, retainer share
- Retainer & project economics: monthly retainer, projects per client, average project fee, fee escalation
- Media pass-through: ad spend per client, ad-spend growth, media management fee
- Delivery capacity: billable FTEs Year-1, FTE growth, clients per FTE, billable comp, freelance %, wage growth
- Cost structure: CAC per client, G&A staff %, facilities %, depreciation %, tax
- Capital & working capital: maintenance capex %, NWC % of revenue growth, base-year revenue
- Valuation: WACC, terminal growth, net debt, shares outstanding
- Clients sheet: roster roll-forward, retainer/project mix, delivery capacity, serviceable clients, utilisation, ad spend managed
Marketing Agency Financial Model: Mechanics, Outputs, and Use Cases
This marketing agency financial model is a seven-year operating and valuation template for a multi-service digital or creative agency. It links client retention, delivery capacity, and three revenue streams—retainers, projects, and media pass-through—into a P&L, client economics, free cash flow, and a DCF valuation.
The model helps test hiring plans, client mix, and growth targets.
Operating Drivers: Client Roster and Delivery Capacity
The model's volume engine is a client roster roll-forward: opening clients plus new wins less churn gives closing clients. New wins grow at a win-growth rate, while churn is a percentage of the opening base shown as a negative row so the roll nets out.
- The average of opening and closing clients drives revenue on a mid-year convention. Active clients split into a retainer cohort and a project cohort.
- Delivery capacity is the constraint: billable creative, strategy, and media FTEs grow at an FTE growth rate, and each FTE services a set number of clients. Serviceable clients equal billable FTEs times clients-per-FTE, and utilization is average active clients divided by serviceable clients.
Utilization above 100% signals the agency cannot staff its wins without hiring. Revenue per FTE, based on agency fee revenue, is the productivity yield.
Revenue Streams: Agency Fees Versus Media Pass-Through
Revenue is built from three distinct streams. Retainer revenue equals retainer clients times monthly retainer times twelve, escalated at a fee step-up.
- Project revenue equals project clients times projects per client times average project fee, likewise escalated. Together these form agency fee revenue, the high-margin business.
- Media pass-through is kept separate: ad spend managed (average clients times ad spend per client, escalated at ad-spend growth) is billed to clients grossed up by a thin management fee. Media pass-through revenue equals ad spend managed times one plus the media fee percentage.
- Total revenue is agency fee plus media pass-through. The P&L charges the ad spend straight back out as a pass-through cost, so the agency keeps only the management fee.
This separation prevents pass-through from flattering the blended margin.
P&L and Client Economics: From Gross Profit to LTV/CAC
Cost of delivery comprises media pass-through cost (ad spend managed, paid to platforms), billable staff compensation (FTEs times loaded comp, wage-escalated), and freelance overflow (a percentage of project revenue). Revenue less cost of delivery is gross profit; because media flows through at cost, the blended gross margin sits below the agency-fee margin.
- Client acquisition cost (new clients times CAC) is sales and marketing. G&A staff and facilities are set as a percentage of agency fee revenue.
- Gross profit less these is EBITDA. Client economics include average client lifetime (one divided by churn), annual fee per client, client LTV (annual fee times gross margin times lifetime), CAC, LTV/CAC, and CAC payback in months.
A healthy agency typically runs LTV/CAC above 3x.
Valuation and Practical Use: Free Cash Flow and Dashboard
Unlevered free cash flow is NOPAT plus depreciation, less maintenance capex and the change in working capital (a modest receivables drag as clients pay on net terms).
- The DCF sums the present value of explicit UFCF and the present value of a Gordon-growth terminal value to enterprise value, then subtracts net debt for equity value and value per share.
- A dashboard shows active clients, retainer/project mix, revenue per FTE, utilization, EBITDA margin, churn, LTV/CAC, enterprise value, and value per share, supported by a Checks tab of PASS/FAIL ties.
- Use the model to test a hiring plan, changes in client mix, or a growth target, and see how those decisions affect margins, cash flow, and agency value.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is a marketing agency financial model?+
A marketing agency financial model captures the seven-year operating economics and intrinsic value of a multi-service digital and creative agency - the retainer-and-project fee business that runs SEO, paid media, branding, web and content for a roster of clients. It rolls a client roster forward with churn, builds delivery capacity from billable FTEs with utilisation as the constraint, keeps high-margin agency fees apart from low-margin media pass-through, reports LTV, CAC and LTV/CAC, and discounts an unlevered free-cash-flow stream to enterprise value, equity value and value per share.
Why keep media pass-through separate from agency fees?+
Ad budgets an agency places for clients are pass-through: billed gross to the client but paid straight out to the platforms, earning only a thin management fee. Booking that gross spend as agency margin is the single biggest agency modelling error. The model bills media gross, charges the spend straight back out as a pass-through cost, and keeps retainer and project fees on their own agency-fee subtotal, with productivity and overhead ratios geared to fee revenue rather than gross revenue.
How is LTV/CAC calculated and why does it matter?+
Average client lifetime is one over churn, annual fee per client is agency fee revenue over average clients, and client LTV is annual fee times gross margin times lifetime. LTV/CAC divides that by the cost to acquire a client, and CAC payback expresses the same in months. A healthy agency runs LTV/CAC above 3x; below 1x it burns cash growing, so both sit on the dashboard and a Checks row asserts LTV/CAC is at least 1.
Why an unlevered DCF instead of an EBITDA multiple?+
Agencies are asset-light, so the model bridges to unlevered free cash flow - NOPAT plus depreciation, less maintenance capex, less a modest receivables working-capital drag - and discounts it at WACC before adding a Gordon-growth terminal value. Enterprise value bridges through net debt to equity value and value per share, and the implied EV/EBITDA falls out as a sanity check against where agency platforms trade rather than as the valuation input.
Have more financial modelling questions? Contact us
Related templates
Consulting Firm
Five-year pyramid model: headcount, utilization, billable rate, comp, and margins.
Staffing Agency Model
Plan and value a staffing agency using recruiter capacity, worker placements, client billing, and operating costs.
AdTech Revenue Model
Advertising technology platform financial projections.
Food Manufacturing Model
Operating model for food production and processing businesses with ingredient sourcing, production scheduling, and margin analysis.
