Financial model template

Agency financial model template with a sales funnel and bonuses

For an agency every client starts as an ad click. The template runs the funnel from budget to signed contracts, pays the sales team a bonus per deal, waits for clients to pay and depreciates equipment.

Try free for 7 days Open the demo
The model answers
  • What a signed client costs
  • How payment delays affect cash
  • Which bonus scheme the margin can afford
Open this template

What is inside the template

Each line is a block with plain fields. Change the numbers, delete blocks or add new ones.

  • A funnel: ad budget, cost per lead, conversion to clients
  • Contracts at an average value
  • Sales bonuses as a share of revenue
  • Account managers and specialists
  • Client payment delay
  • Equipment with depreciation

Numbers to watch

Cost per acquired client
Ad spend plus sales bonuses divided by new clients.
Average contract value
Larger contracts make an expensive funnel pay off.
Days to payment
The longer clients take to pay, the more cash you need.
Margin after bonuses
Bonuses grow with revenue and can eat the margin.

Common mistakes in this kind of model

Leads equal clients

Only a share of leads sign. Put the conversion you see.

Payment on signing

Many clients pay after delivery. Add a delay.

No depreciation

Laptops and cameras lose value. Depreciation shows the real cost.

AI assistant

Check the template against your market

Tell the assistant your city and format. It looks up prices, rent and salaries online, compares them with the template and proposes changes as cards with the effect on profit and cash. You decide what to apply.

How the assistant works

Questions

How do I account for sales bonuses?

Add an expense as a percentage of revenue. It grows automatically with the number of deals.

What is depreciation here?

The cost of equipment spread over its useful life. It lowers profit evenly instead of one big hit in the month of purchase.

Related reading

Unit economics in plain words Unit economics explained with examples: contribution margin per order, customer acquisition cost (CAC), lifetime value (LTV), LTV/CAC and CAC payback for e-commerce and SaaS. Cash flow gap: how to spot it before it happens What a cash flow gap is, the typical causes (stock, payment terms, seasonality, loans), how to find it in a monthly forecast and six ways to close it.

Similar templates

Barbershop or beauty salon Masters on commission, rent and supplies: the classic service business. Fitness studio Memberships with churn, trainers and hall rent. The January rush is visible.

Open the agency with a sales funnel template now

The demo works without sign-up. To save your model, start the free trial.

Start free trial Open the demo