Creative and Marketing Agency 5 Year Financial Model: Dashboard, 3 Statements, Hiring, Retainers

Description
A fully linked five year financial model for a small creative, digital or marketing agency. Built for the three questions that decide an agency's year: when to hire, what utilisation the team has to hold to pay for itself, and what losing the biggest retainer does to cash before a replacement lands. Revenue is built from four lines an agency actually bills, each with its own volume, monthly growth, direct cost percentage and a capacity ceiling: retainer clients times a monthly fee, projects times average value, managed ad accounts times a management fee, and productized packages times price. The direct cost percentage carries contractor and pass through costs per line, so a heavily subcontracted project line shows its real margin next to a retainer that the in house team delivers. Fifteen linked worksheets: Start Here, Dashboard, Inputs, Revenue, COGS, Payroll, Opex, CapEx, P&L, Cash Flow, Balance Sheet, Break even, Scenarios, Funding and Checks. Monthly across 60 months with annual summaries. A hiring roster of eight roles with start and end months, employer burden and wage inflation, and a headcount row that shows the team growing. Equipment waves as capital expenditure with depreciation. A lost retainer stress test on a single scenario switch. A funding view with capital required, an optional loan schedule and use of funds. Benchmarks beside your own numbers: payroll as a share of revenue, overheads, EBITDA margin. A Checks tab proves the balance sheet balances every month. Excel 2016 or later and Google Sheets, no macros. Includes a one page quick start guide with a Google Sheets copy link.