Revenue & Capacity
Revenue and Calc connect delivery-role FTE, 160 available hours per month, utilization, service mix, and hourly fees to monthly sold hours and revenue by practice.

This Marketing Agency Financial Model is an Excel planning template for a remote-first U.S. B2B agency based in Austin, Texas. It converts delivery capacity, billable utilization, practice mix, hourly fees, staffing, operating costs, startup funding, and working-capital assumptions into monthly and annual financial projections.
The illustrative case covers 2026 through 2030 and models five fee-for-service practices. Client advertising budgets are paid directly to media platforms, so media spend is excluded from agency revenue and client delivery costs unless it appears in the agency’s own operating assumptions.
The workbook connects agency operating assumptions to monthly calculations, financial statements, management reports, financing schedules, and model checks.
Revenue and Calc connect delivery-role FTE, 160 available hours per month, utilization, service mix, and hourly fees to monthly sold hours and revenue by practice.
COGS & OPEX separates direct, variable, and fixed operating costs, while Payroll models role-based FTE and salaries for delivery staff, the managing director, and account management.
CAPEX, CapTable, Debt, and Sources & Uses separate startup assets, equity contributions, financing schedules, and cash allocation from recurring operating expenses.
IS, CF, BS, Summary, Scenarios, Valuation, Returns, Ratios, DuPont, Charts, Benchmarks, and Checks support profitability, liquidity, return, valuation, and reconciliation review without implying unsourced case results.
Agency revenue is calculated from delivery FTE capacity, billable utilization, practice allocation, and fixed hourly fees rather than from client media budgets.
Each delivery-role FTE contributes 160 available hours per month. Billable utilization rises from 50% in 2026 to 70% in 2030, while the five practices divide the same sold-hour pool so hours are not duplicated across services.
Strategy & Research receives 20% of sold hours at $180 per hour, Paid Media Management 25% at $160, Content & SEO 20% at $145, Creative Design 20% at $140, and Email & CRM the residual 15% at $165.
The Revenue Forecast shows the operating drivers, service allocation, hourly pricing, and resulting revenue by stream. For this agency, it links delivery capacity and utilization to the five practice categories without counting client-paid media budgets as agency sales.
3 delivery FTE × 160 hours/month × 12 months × 50% utilization = 2,880 sold hours.
Applying the documented practice mix and hourly fees to those sold hours produces the 2026 illustrative revenue of $454,320. Later growth comes from both higher delivery staffing and higher utilization, not from an assumed advertising-spend pass-through.
The model keeps percentage-based delivery costs, revenue-linked operating expenses, fixed monthly overhead, and employee payroll as distinct cost layers.
The COGS & Operating Expense Forecast shows direct costs, variable operating expenses, and fixed expenses with their effective assumptions and monthly calculations. The agency case uses 7% of revenue for COGS and 5.5% for variable operating costs before fixed overhead and payroll.
COGS consists of purchased specialist support at 5% of revenue and client delivery tools at 2%. Variable expenses are payment and banking charges at 1%, agency campaign spend at 4%, and an uncollectible fee allowance at 0.5%.
Fixed coverage includes business software, coworking and meeting space, insurance, accounting and legal, telecom, training, and administration. These fixed inputs are modeled separately from salaries so each payment component is counted once.
The Payroll Forecast shows role-level FTE schedules, salaries, hiring timing, bonuses, and related personnel calculations. In this case, annual-average staffing grows across marketing specialists, design, content, and account management while the managing director remains at one FTE.
Startup assets, one-time opening cash needs, working capital, and owner funding are modeled separately from recurring operating expenses and EBITDA.
The Capital Expenditure Plan shows planned asset purchases and depreciation schedules. The agency opening assets include five business laptops for $6,000, monitors and docking stations for $1,500, and remote workstation equipment for $1,200.
Separate opening cash items include formation and legal setup, website and portfolio production, initial launch promotion, a refundable workspace deposit, and preopening managing director pay. These are funding needs, not additional recurring operating expenses.
Working-capital controls use 15 accounts-receivable days, zero accounts-payable days, and zero inventory days. Initial owner funding is $138,838 in the illustrative case and is intended to cover startup assets, opening cash needs, working capital, and the planning reserve.
The Sources and Uses of Funds report reconciles funding sources with operating, investment, financing, and retained-cash uses over the selected period. It helps distinguish equity or debt funding from earned revenue and from one-time startup cash requirements.
The documented base-case illustration grows revenue from $454,320 in 2026 to $1,484,112 in 2030 while EBITDA rises from $44,180 to $555,048.
| Year | Revenue | Expenses | EBITDA |
|---|---|---|---|
| 2026 | $454,320 | $410,140 | $44,180 |
| 2027 | $666,336 | $533,592 | $132,744 |
| 2028 | $908,640 | $660,830 | $247,810 |
| 2029 | $1,181,232 | $793,054 | $388,178 |
| 2030 | $1,484,112 | $929,064 | $555,048 |
Forecast amounts are illustrative model outputs and are rounded to whole dollars for display.
The expense progression reflects higher staffing and overhead alongside revenue growth. For example, modeled payroll increases from $328,750 in 2026 to $693,750 in 2030, while direct and variable percentages remain linked to revenue.
EBITDA is an operating earnings measure, not a cash balance. Startup investing, collections timing, equity contributions, debt drawdowns, repayments, and other financing activity are evaluated in the cash-flow and funding reports.
The Cash Flow Forecast shows operating, investing, and financing cash movements and reconciles opening to closing cash. It is the appropriate report for assessing liquidity effects from receivables, startup investment, equity, and any debt structure entered in the model.
The Returns and Scenarios reports help test operating coverage, recovery of invested cash, annual return on invested capital, and sensitivity to changed revenue and cost assumptions.
The Return on Invested Capital Analysis combines sales break-even, cash break-even timing, investment payback, and annual ROIC. These measures should be read separately because covering operating costs is not the same as recovering investment or earning a return on invested capital.
Sales break-even compares revenue with the level required to cover modeled costs, while cash break-even reflects cash timing. Investment payback tracks cumulative project cash flow, and ROIC compares operating returns with invested capital under the workbook’s calculation framework.
No payback month, ROIC percentage, or valuation is inferred from the EBITDA table above. Those outputs depend on the detailed cash-flow, investment, financing, and valuation calculations in the workbook.
The Financial Scenario Analysis compares Low, Base, and High cases for revenue, gross margin, contribution margin, and EBITDA. Dashboard multipliers can vary revenue, COGS, variable operating expenses, fixed operating expenses, and payroll without changing the core model structure.
This template fits agencies that sell professional service hours and want staffing, utilization, pricing, operating costs, funding, and financial statements connected in one forecast.
It is especially relevant when management needs to test how delivery hiring and utilization affect sellable capacity, how practice mix and rates affect revenue, and how payroll and overhead affect EBITDA.
Because the documented case excludes client-paid advertising budgets from agency revenue, users should keep pass-through media spend outside sales unless their own business economics and accounting treatment require a different structure.
These answers summarize the operating logic, editable inputs, and reporting scope of the template.
It multiplies delivery FTE capacity by billable utilization, allocates sold hours across five practices, and applies each practice’s hourly fee.
No. In the documented case, clients pay advertising platforms directly, so media budgets are outside agency revenue and costs.
Yes. Revenue and Payroll inputs let you adjust delivery FTE schedules, utilization, role staffing, salaries, launch timing, and related operating assumptions.
The case separates COGS, variable operating expenses, fixed overhead, and payroll, with startup assets and opening cash requirements modeled separately.
Yes. The declared workbook reports include projected income statement, cash flow statement, balance sheet, combined Summary, and supporting analysis reports.
No. EBITDA measures operating earnings before depreciation, interest, and tax, while cash flow also reflects working capital, investing, equity, debt, and financing movements.
Yes. Low, Base, and High controls can apply different multipliers to revenue and major cost groups and compare resulting profitability.
Yes. The Returns report includes break-even, investment payback, and annual ROIC calculations, but this product description does not invent unsourced case results.
KPIs, forecasts, and cash flow at a glance.
Key assumptions and calculations driving revenue forecasts.
Funding sources, spending, and closing cash.
Cash break-even, payback, and ROIC.
DCF valuation and sensitivity analysis.
Largest costs and spending trends.
Annual and monthly financial performance.
Compare margins and returns to benchmarks.
Starting from scratch felt huge, but this template gave me a clear place to begin and cut setup time by hours. One clean one-liner made it easier to move from idea to first draft.
I was worried one bad formula would throw off the whole model, but the built-in structure kept my assumptions steady and saved me from a costly rebuild. I got a clean forecast ready for review faster.
Our statements and charts used to live in different files, and it was a mess. This model pulled everything into one place, so I had a report ready for the client meeting without hunting through tabs.