If you are raising investment for your agency, you need a financial model. Not a set of management accounts. Not a three-year plan scribbled on a napkin. A real, working Excel model that an investor can stress-test.

Most agency founders skip this step or outsource it to someone who does not understand how agencies actually make money. The result is a model that looks pretty but falls apart when an investor asks: "What happens if your biggest retainer client leaves in month seven?"

This guide walks you through building an agency financial model from scratch in Excel. It is designed for a founder of a 10-to-50 person agency billing between £500k and £5m per year. The same structure works for smaller and larger agencies with minor adjustments.

We are ICAEW qualified accountants who work exclusively with agency founders. We see these models every day. The good ones share a common structure. The bad ones share common mistakes. This guide gives you the structure and helps you avoid the mistakes.

Why Most Agency Financial Models Fail

Before you open Excel, understand why most models fail. It is rarely the maths. It is the assumptions.

A typical bad model assumes linear growth. Revenue goes up 20% every year. Costs go up 15%. Gross margin stays flat. No client churn. No seasonality. No delayed payments. The model shows a beautiful upward slope and the investor ignores it completely.

Investors have seen hundreds of these. They know the real world does not work that way. What they want is a model that reflects how your specific agency operates. That means modelling revenue by type (retainer vs project), headcount by role, utilisation rates, and cash collection cycles.

This is where agency finance fundamentals matter. The fundamentals are not complicated. They are specific. Revenue per head, utilisation, gross margin, and cash conversion. Get these right in your model and you have something worth presenting.

What You Need Before You Start

You need three things before you open Excel:

  • 12-24 months of actual historical data from your accounting software (Xero, QuickBooks, FreeAgent). Monthly P&L, balance sheet, and cash flow if you have it.
  • Your current headcount and salary data. Not just total payroll. Names, roles, salaries, and start dates for every employee and contractor.
  • A clear understanding of your revenue mix. What percentage is retainer vs project vs one-off? Who are your top five clients and what do they pay?

If you do not have clean historical data, spend a weekend organising it. A model built on bad data is worse than no model at all. Investors will spot the inconsistencies within five minutes.

The Core Structure of an Agency Financial Model

A good agency financial model has five core tabs. You can add complexity later, but start with these:

  1. Inputs, all assumptions in one place
  2. Revenue, monthly revenue forecast by type
  3. Costs, payroll, freelancers, overheads, and cost of sales
  4. Cash flow, monthly cash movements including VAT and corporation tax
  5. Outputs, summary dashboard with KPIs and charts

Do not merge these into one sheet. Keep them separate. It makes the model easier to audit and easier for an investor to follow.

Tab 1: Inputs

Every assumption goes here. No hard-coded numbers anywhere else in the model. If an investor wants to change the utilisation rate from 70% to 65%, they click one cell.

Your inputs tab should include:

  • Headcount plan by role (creative, strategy, account management, production, support)
  • Average salary by role, including employer NI at 13.8% and pension contributions
  • Utilisation rate (billable hours divided by total available hours)
  • Average billable rate by role
  • Retainer growth rate and churn rate
  • Project pipeline conversion rate
  • Payment terms (net 30, net 60, net 90)
  • Overhead costs (rent, software, subscriptions, travel, professional fees)
  • Tax rates (corporation tax, VAT, dividend tax)

Be realistic with your utilisation rate. A healthy agency runs at 65-75% utilisation. If you model 85% utilisation for a creative agency, an investor will assume you have never run an agency. They are right.

Tab 2: Revenue

Model revenue in two streams: retainer and project. Do not lump them together. They behave differently and investors know this.

Retainer revenue is predictable. Model it as a monthly recurring number with a churn rate. If you have 10 retainers at £5,000 per month and 2% monthly churn, your retainer book shrinks by one client every five months unless you replace them. Model the replacement separately.

Project revenue is lumpier. Model it based on your pipeline. Take your average project value (say £24,700) and your conversion rate from proposal to signed (say 35%). Then apply a probability-weighted forecast. Do not model every project you hope to win. Model the ones in your pipeline with a realistic conversion rate.

If you have a 12-person digital agency billing £800k per year, your revenue tab should show exactly where that £800k comes from. Client by client if you are small. Service line by service line if you are larger.

Tab 3: Costs

Costs break into three categories in an agency model:

  • Direct costs, salaries and freelancers for billable roles. These move with revenue.
  • Overheads, rent, software, insurance, legal, accounting. These are relatively fixed.
  • Sales and marketing, business development salaries, advertising, events. These should be modelled as a percentage of revenue or as a fixed headcount plan.

Model headcount growth explicitly. Do not use a percentage of revenue. If you plan to hire two midweight creatives in month six and a senior account director in month nine, put those rows in. Investors want to see that you understand the timing of hiring and the lag between hiring and billing.

Include employer NI and pension contributions in your salary calculations. A £45,000 salary actually costs around £52,300 once you add employer NI at 13.8% and a 3% pension contribution. Model the real cost, not the headline salary.

Tab 4: Cash Flow

This is the tab that separates serious models from amateur ones. Profit is not cash. An agency can be profitable and run out of money because clients pay late.

Model your cash flow month by month. Start with opening cash. Add cash received from clients based on your payment terms. Subtract cash paid for salaries, overheads, VAT, corporation tax, and dividends.

Key cash flow items agencies often miss:

  • VAT, if you are VAT registered, you collect 20% on invoices and pay it quarterly. Model the timing gap.
  • Corporation tax, due nine months and one day after your year end. If you are growing fast, the tax bill on year one profits lands in year two when you have already spent the cash.
  • Directors' loan account, if you have taken money from the company, model the repayment. S455 tax at 33.75% applies if loans are not repaid within nine months of year end.
  • Dividend payments, model these as a separate line. Investors want to see what you plan to take out versus reinvest.

A good cash flow model will show you exactly when you need the investment. If you are raising £250,000, the model should show that you run out of cash in month 14 without it and stay positive through month 36 with it.

Tab 5: Outputs

This is what the investor sees. Keep it clean. Three charts and a KPI table.

Chart 1: Revenue and gross margin over time. Monthly revenue with gross margin percentage on a secondary axis. Investors want to see that margin holds as you scale.

Chart 2: Cash balance over time. The classic hockey stick. Show the dip before investment and the recovery after. If there is no dip, you probably do not need the investment.

Chart 3: Revenue per head and utilisation. Two lines showing efficiency over time. Revenue per head should increase as you scale. Utilisation should stay in a healthy range.

KPI table with the numbers investors actually care about:

  • Gross margin (target 50-65% for most agencies)
  • Net profit margin (target 15-25%)
  • Revenue per head (varies by agency type, but £80k-£150k is typical)
  • Cash runway in months
  • Client concentration (percentage of revenue from top client and top five)
  • Retainer vs project split

Common Mistakes to Avoid

Here are the mistakes we see most often when reviewing agency financial models for investment rounds:

Modelling 100% utilisation. No agency runs at 100%. People take holidays, get sick, do internal work, and attend meetings. 70-75% is a realistic ceiling for most agencies.

Ignoring client concentration. If your top client is 40% of revenue, model what happens if they leave. Investors will ask this question. Have the answer in your model.

Flat headcount costs. Salaries go up. People get promoted. You hire senior people who cost more. Model salary inflation of 3-5% per year and promotion costs for key staff.

No working capital line. If you are growing fast, you need cash to pay salaries before clients pay you. Model the working capital requirement explicitly. This is often the real reason you need investment.

Overcomplicating the model. A model with 20 tabs and 50 linked cells is impossible to audit. Keep it simple. Five tabs. Clear labels. One colour for inputs (blue), one for calculations (black), one for outputs (green).

What Investors Actually Look For

We have sat in on enough investment meetings to know what gets asked. Here is what investors look for in an agency financial model:

  • Reasonable assumptions. They have seen hundreds of models. They know what 70% utilisation looks like. They know what 15% net margin looks like. If your numbers are outside normal ranges, be ready to explain why.
  • Scenario analysis. Show three scenarios: base case, upside, and downside. The downside should show you surviving, not thriving. Investors want to know you have thought about what goes wrong.
  • Cash focus. They care more about cash than profit. An agency that runs out of cash fails regardless of its P&L.
  • Founder understanding. If you cannot explain your own model, they will not invest. Build it yourself. Understand every assumption. Know which levers matter most.

When to Get Help

Building a financial model is not accounting. It is financial modelling. If you have never built one before, expect to spend 20-40 hours on your first version. That is normal.

If you get stuck, ask your accountant to review the assumptions and the structure. At Agency Founder Finance, we regularly review financial models for agency founders raising investment. We do not build them for you, but we check that the numbers make sense and that the model will survive investor scrutiny.

If your agency is structured as a group with multiple trading companies, a holding company, or international entities in the UAE, the model gets more complex. You need someone who understands both the agency finance fundamentals and the cross-border tax implications.

For most UK agency founders, the five-tab structure in this guide is enough to start conversations with investors. Build it. Test it. Break it. Then rebuild it until it tells the story of your agency honestly.

If you need a second set of eyes on your model before you present it, get in touch. Our ICAEW qualified team works with agency founders every day. We know what investors ask and we know when a model is ready.

The agency finance fundamentals are not complicated. Revenue, costs, cash. Get those right in your model and you have a tool that helps you run your agency better, regardless of whether you raise investment or not.