# Marketing Agency Model See how new clients, retention, pricing, and team capacity shape a marketing agency's performance. - Canonical: https://finamodel.com/templates/marketing-agency - Excel download: https://finamodel.com/templates/marketing-agency.xlsx - Category: Operating Businesses - Model type: Operating model - Difficulty: Intermediate - Audiences: Investors & analysts, Founders & operators, Agency founders and principals, Marketing-services PE and platform buyers, Professional-services investors, Lenders and analysts - Tags: marketing-agency, professional-services, retainer, ltv-cac, dcf ## Overview 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's included - 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 - Revenue sheet: retainer revenue, project revenue, agency-fee subtotal, media pass-through revenue billed gross, total revenue - P&L sheet: revenue to net income with cost of delivery to gross profit, client acquisition, G&A and facilities to EBITDA, margins, identity check - Client_Economics sheet: annual fee per client, gross margin, average client lifetime, client LTV, CAC, LTV/CAC and CAC payback in months - FCF sheet: NOPAT, depreciation add-back, maintenance capex, change in NWC, unlevered FCF, discount factor, PV - Valuation sheet: sum of PV, terminal value, enterprise value, equity value, value per share, implied EV/EBITDA - Dashboard with active clients, retainer/project mix, revenue per FTE, utilisation, EBITDA margin, churn, LTV/CAC and enterprise value, plus a Checks tab of PASS/FAIL ties ## 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. ## Agency fee kept apart from media pass-through The single biggest agency modelling error is booking placed ad budgets as margin. Here media is billed gross at a thin management fee and the spend is charged straight back out as a pass-through cost, while high-margin retainer and project fees sit on their own subtotal - so the pass-through never flatters the blended margin, and revenue per FTE and the G&A stack are geared to agency fee revenue rather than gross revenue. ## Retention economics at the centre A client roster rolls forward with an explicit negative churn row, and a client-economics block reports average lifetime (one over churn), LTV, CAC and the flagship LTV/CAC ratio and payback. Utilisation - active clients over serviceable clients - is the capacity constraint that flags when the agency cannot staff the work it has won. These are the numbers that decide whether winning clients builds or burns enterprise value. ## An unlevered DCF with a Checks tab Agencies are asset-light, so the free-cash-flow bridge charges only maintenance capex and a modest receivables working-capital drag before discounting at WACC and adding a Gordon-growth terminal value. Enterprise value bridges through net debt to value per share, and a Checks tab ties the roster roll-forward, revenue, P&L identity, media-fee and LTV/CAC relationships to PASS. ## Workbook structure ### Cover Workbook overview, sheet legend, units, and tab-colour key. - Title and scope framing - Sheet-by-sheet purpose summary - Units and tab-colour legend ### Assumptions Every driver in one sheet: roster, fees, media, capacity, costs, valuation. - Starting clients, new wins, win growth, churn, retainer share - Monthly retainer, projects per client, average project fee, fee escalation - Ad spend per client, ad-spend growth, media management fee - Billable FTEs, FTE growth, clients per FTE, comp, freelance %, wage growth - CAC per client, G&A staff and facilities %, depreciation, tax - Maintenance capex, NWC %, base-year revenue; WACC, terminal growth, net debt, shares ### Clients Roster roll-forward and delivery capacity. - Opening plus new wins less churn equals closing active clients - Average active clients on a mid-year convention - Retainer and project cohort split - Billable FTEs times clients-per-FTE equals serviceable clients - Utilisation equals average active over serviceable - Ad spend managed ### Revenue Three revenue streams, agency fee kept apart. - Retainer revenue equals retainer clients times monthly retainer times twelve - Project revenue equals project clients times projects per client times average project fee - Agency-fee subtotal - Media pass-through revenue billed gross at the management-fee markup - Total revenue ### P&L Revenue to net income. - Cost of delivery: media pass-through cost, billable staff comp, freelance overflow - Gross profit and gross margin - Client acquisition, G&A staff and facilities to EBITDA - Depreciation, EBIT, tax on positive EBIT, net income, margins - Identity check ### Client_Economics Retention and unit economics. - Annual fee per client and gross margin - Average client lifetime equals one over churn - Client LTV equals annual fee times gross margin times lifetime - CAC and LTV/CAC - CAC payback in months ### FCF Unlevered free cash flow bridge. - EBIT and unlevered tax to NOPAT - Add back depreciation - Less maintenance capex (asset-light) - Less the change in working capital (a modest receivables drag) - Unlevered free cash flow, discount factor and PV ### Valuation Discounted cash flow. - Sum of PV of explicit UFCF - Gordon-growth terminal value and its PV - Enterprise value - Less net debt to equity value - Shares outstanding and value per share - Implied EV/EBITDA ### Dashboard Headline metrics and a Checks tab. - Active clients and retainer/project mix - Revenue per FTE, utilisation and EBITDA margin - Churn and LTV/CAC - Enterprise value and value per share - A Checks tab of PASS/FAIL identity and sanity ties ## Features - **Agency fee kept apart from media pass-through:** The single biggest agency modelling error is booking placed ad budgets as margin. Here media is billed gross at a thin management fee and the spend is charged straight back out as a pass-through cost, while high-margin retainer and project fees sit on their own subtotal - so the pass-through never flatters the blended margin. - **Retention is the whole game:** A client roster rolls forward with an explicit negative churn row, and a client-economics block reports average lifetime (1 / churn), LTV, CAC and the flagship LTV/CAC ratio and payback - the numbers that tell you whether the agency is building or burning enterprise value as it wins clients. - **Utilisation is the capacity constraint:** Billable FTEs times clients-per-FTE gives serviceable clients, and utilisation is active over serviceable - push wins too hard without hiring and it climbs past 100%, signalling the agency cannot staff the work, which a Checks row flags. - **Productivity geared to fee revenue:** Revenue per FTE and the G&A stack are geared to agency fee revenue, not gross revenue, so pass-through media never inflates the productivity or overhead ratios. - **One-edit responsiveness:** Every driver is a named-range cell - flex the win rate, churn, the retainer/project mix, the media markup or the FTE build and the roster, revenue, P&L, client economics, cash-flow bridge, valuation and dashboard all recompute, with a Checks tab tying the identities to PASS. ## Use cases - **Agency profitability planning:** Test how the retainer/project mix, the win rate and the hiring pace flow through to agency-fee margin, EBITDA and revenue per FTE before committing to a growth plan. - **Retention and unit-economics work:** Stress churn and CAC and read the effect on average client lifetime, LTV and the LTV/CAC ratio - the retention economics that make or break an agency. - **PE platform underwriting:** Underwrite a marketing-services roll-up: flex the roster, keep media apart from fees, and read enterprise value and implied EV/EBITDA against where agency platforms trade. - **Board and lender reporting:** Hand the dashboard to the board or a lender as a one-page view of active clients, utilisation, revenue per FTE, EBITDA margin, churn, LTV/CAC and valuation. ## Frequently asked questions ### 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. ## Related templates - [Consulting Firm](https://finamodel.com/templates/consulting-firm) - [Staffing Agency Model](https://finamodel.com/templates/staffing-agency) - [AdTech Revenue Model](https://finamodel.com/templates/adtech-revenue-model)