Know whether the plan pays before you fund it.

A working model that links market size, margins and marketing spend to sales and profit, quarter by quarter.

Usually a fixed project, kept up afterwards within ongoing management if you want.

Marketing budgets are often set backwards. Someone picks a number, the plan is built to spend it, and whether the business makes money at the end is left to hope. A commercial model starts from the other end: what you sell, what it costs to make and deliver, and how much you can afford to pay for each sale.

I build these for launches, new product lines and budget decisions. The model is a spreadsheet you can open and change, not a slide. Alter the price, the budget or the conversion rate and the sales, margin and break-even point move with it.

This is for you if

  • You’re launching a product or brand and need to know what it will cost to reach scale.
  • You’ve been handed a budget and a sales target that may not agree with each other.
  • You need a business case for a board, an owner or an investor.
  • You sell online and aren’t sure what you can afford to pay for a customer.

How the work runs.

  1. Market

    Size the market from the top down, narrow it to the part you can actually win, and set a share target that is plausible.

  2. Margin

    Price, cost of goods, delivery, returns and discounts, down to what one sale really leaves you.

  3. Marketing

    Budget by line, traffic, conversion rate and cost per sale, checked against benchmarks for your category.

  4. Project

    Sales, revenue, spend and profit by quarter over three years, including when it breaks even.

  5. Scenarios

    Two or three versions side by side, so you can see what each choice costs and returns.

Deliverables

What you end up with

  • A working spreadsheet model with every assumption on one sheet
  • Market size and target share
  • Margin per sale after delivery, returns and discounts
  • The most you can pay for a sale and still make money
  • Three-year projection by quarter with a break-even point
  • Scenarios compared side by side
  • A walkthrough, and a model your finance team can check

Where AI comes in

Every assumption has a source

I use AI to gather market and benchmark figures and to test the model for errors. Every assumption is listed with its source so you can challenge it, and the structure of the model and its conclusions are mine.

How I use AI

Fair things to ask.

Something else? Ask me directly.

How is this different from marketing mix modelling?

Marketing mix modelling looks back at your own history to measure what each channel contributed. A commercial model looks forward from assumptions, and suits a launch or a decision where there is little history to measure. Once there is data, the two feed each other.

How accurate is a projection?

It is only as good as its assumptions, which is why they are all visible and changeable. The value is less in the single forecast than in seeing which assumptions matter most, and what happens if they are wrong.

What do you need from us?

Prices, costs, any sales and marketing history, and the targets you have been given. Where figures don’t exist yet I use market and category benchmarks and mark them as estimates.

What usually comes out of it?

Most often a gap between the budget, the target and the margin. A common finding is that the first year loses money on every sale by design, and the plan only works if years two and three are funded and conversion improves as expected.

Can our finance team work with it?

Yes. It is built in a spreadsheet with ordinary formulas, so they can audit it, extend it and keep it running.

Something driving you mad?

Tell me what’s going on. I’ll come back with questions or a scoped proposal, and I’ll say so if I’m not the right person for it.