Let's grow your business in 2026,book a free 30 min calltoday.

Google225+ 5 star Google reviews300+ businesses grown since 2021

Free Download: Marketing Budget Spreadsheet

Built around a $5M example, works at any size.

The spreadsheet's cover and its Budget tab: your proposed budget, 7 business assumptions and the calculation behind them

Enter your revenue target, margins and win rate to see how much you can spend winning new customers, then plan where the money goes across the year.

  • Know how many customers you need to hit your target
  • See what you can afford to spend before you commit
  • Split the year across agency, media, production, tools and reserve
Tab 1: revenue to budget calculator. Tab 2: 12 month spend plan.
The $5M Business Marketing Budget spreadsheet from Q Agency

Download our Free Marketing Budget Spreadsheet

12 month budget calculator for service businesses. Sent to your inbox straight away.

We will email the download and occasionally share things we think are useful. Unsubscribe any time. Privacy policy.

Worked example

$5M target, 40% margin, 25% win rate = $100,000 a year to spend on new customers.

  • $1Mnew-customer revenue neededGrowing from $4M to the $5M target
  • 40new customers to winAt $25K revenue each
  • 160qualified opportunitiesAt a 25% win rate
  • $2,500to spend winning each customer$10K gross profit at 40%, less $7,500 kept for overhead and profit

Run through the spreadsheet's own formulas. Put in your numbers and it works out yours.

What is inside

What the spreadsheet works out.

  1. 01

    Your business assumptions

    Enter 7 inputs for one 12 month period: current revenue, your revenue target, revenue from existing customers, revenue and gross margin per new customer, what to keep for overhead and profit, and your win rate.

  2. 02

    The calculation, step by step

    From the revenue gap to the new customers and qualified opportunities you need, the gross profit each new customer brings and the acquisition allowance that leaves.

  3. 03

    Your proposed budget

    The annual and monthly budget, the share that goes to winning new customers, and how much of the modelled allowance your plan uses.

  4. 04

    Where the money goes

    The year's costs in 7 lines: agency services, paid media, production, tools and data, internal time, website projects and an uncommitted reserve, each with its share for new customers.

  5. 05

    Quarterly timing

    An optional split of the year by quarter, so launches and seasonal campaigns line up with the budget.

  6. 06

    Where investment can help

    Prompts to check follow-up, conversion and retention before adding spend, and to test new activity against your customer economics.

Get the free spreadsheet
The spreadsheet's cover with its Budget tab: your proposed budget and the 7 assumptions behind it

Who it's for

Owners and marketing leads of service businesses setting next year's budget from their own numbers.

Trusted by 300+ brands, locally and nationally

$100M+generated revenue
300+businesses grown
50+case studies
agriwebb logo
art of marble logo
battery world trim logo
bettertiles fixed logo
business insider logo
clear path accounting logo
cookieman logo
dott and crossitt logo

Get in touch

Want a second opinion on your budget?

Talk it through with a senior strategist. You do not need to fill in the spreadsheet first.

Email info@qagency.com.auCall 1300 087 136