Academy/Module 3

Expense Modelling

Scaling ad budget without going broke: the payback check

Lesson 6 of 7 6 min

Turning up the ad budget is the fastest way to grow a store — and the fastest way to run out of cash if the maths doesn't work. The good news: there's a simple check that tells you whether you're scaling or just spending. It comes down to margin and payback.

The payback check, in one line

For every €1 you put into ads, you get some revenue back (that's your ROAS), and a slice of that revenue is actual margin. Scaling is safe as long as the margin an order produces covers what you paid to win it, fast enough that you're not funding the gap out of your dwindling bank balance.

The numbers you need
  • Contribution margin per order — AOV minus product cost, shipping and fees.
  • Cost to acquire an order — ad spend ÷ orders from ads (or 1 ÷ ROAS × AOV).
  • The rule: if margin per order > acquisition cost, each new order adds cash. If not, you're buying revenue at a loss.
B4=B2-B3
Per order (€)
Contribution margin29.40
− Acquisition cost (ads ÷ orders)18.00
Margin after acquisition11.40
The payback check — margin per order beats the cost to win it, so every new order adds cash. Positive means it's safe to scale.

So the discipline is simple: track your margin and stay inside it. Scale the budget while acquisition cost sits comfortably below contribution margin, and ease off when the gap closes. (If you haven't nailed your margin yet, what an order really costs shows exactly how to work it out.)

B5=B2/B3 (ad budget ÷ orders → acquisition cost)
JanFebMar
Ad budget (€)5,0006,0007,000
Orders from ads280280280
Revenue (€)50,00050,00050,000
Acquisition cost / order (€)17.8621.4325.00
Contribution margin / order (€)29.4029.4029.40
The simple method — you scale the ad budget (top row), but the revenue projection sits flat: the spreadsheet never links the two. All it tracks is that acquisition cost per order (rising) stays under your €29.40 margin — solvent, but blind to the extra sales a bigger budget should bring.

This keeps you solvent — but notice what the sheet quietly assumes. It holds orders (and revenue) fixed while you change the budget. In reality, spending more on well-targeted ads should win more orders, which lifts revenue too. The simple method is safe precisely because it ignores that upside: your projected revenue doesn't budge when the budget does. Great for staying inside your margin — but it undersells how much a bigger budget can actually grow the top line.

ROAS on its own can lie

A 3× ROAS sounds great until you remember your product, shipping and fees eat most of the order. On a 30% margin, a 3× ROAS is barely break-even on the first order. Always run ad spend through margin, not just revenue.

Model the upside: split paid and organic revenue

To let the forecast actually react to your budget, split revenue into two streams. Organic revenue is the baseline you'd earn with no ads at all — repeat customers, SEO, word of mouth. Paid revenue is what the ad budget buys: ad budget × ROAS. Total revenue is just the two added together.

Now the model has a lever. Raise the ad budget and paid revenue rises with it at your ROAS, while organic stays put — so total revenue climbs by exactly the extra sales your spend should win. To see how far a bigger budget takes you, bump the budget row and watch paid and total revenue follow. You keep the payback check running on top: the extra revenue is only worth it while margin still covers the extra spend.

B4=B2*B3 (ad budget × ROAS → paid revenue)
JanFebMar
Ad budget (€)5,0006,0008,000
ROAS (×)4.04.04.0
Paid revenue (€)20,00024,00032,000
Organic revenue (€)30,00030,00030,000
Total revenue (€)50,00054,00062,000
The advanced way — raise the March budget from €6,000 to €8,000 and paid revenue jumps €24k → €32k, pulling total revenue up with it. The forecast finally reflects that ads drive sales, not just costs.

The same model, kept in sync for you

You can absolutely build all of this by hand — but keeping the organic/paid split, ROAS and twelve months of budgets linked is real upkeep, and it goes stale the moment you forget an update. Foreqast wires it up out of the box: your Shopify orders and revenue and your Meta (Facebook / Instagram) ad spend sync in automatically, advertising is a driver that feeds paid revenue through your real ROAS, and the whole forecast recalculates the moment you change a budget — no formulas to maintain. Here's the same example inside the app:

Forecast Mar 26Apr 26May 26Jun 26Jul 26Aug 26
Revenue50,00050,00054,00054,00054,00062,000
Shop revenue Σ organic + paid€50,000€50,000€54,000€54,000€54,000€62,000
Orders Shopify8608609309309301,070
Avg order value Shopify€58€58€58€58€58€58
Σ Organic revenue€30,000€30,000€30,000€30,000€30,000€30,000
Σ Paid revenue (budget × ROAS)€20,000€20,000€24,000€24,000€24,000€32,000
Cost of goods11,76012,04012,04013,02013,02013,020
COGS Σ prev-month orders × €14€11,760€12,040€12,040€13,020€13,020€13,020
Avg purchase cost Manual€14€14€14€14€14€14
Marketing5,0005,0006,0006,0006,0008,000
Advertising driver-based€5,000€5,000€6,000€6,000€6,000€8,000
Ad budget Meta Ads€5,000€5,000€6,000€6,000€6,000€8,000
ROAS Manual4.04.04.04.04.04.0
Other expenses9,4009,4009,4009,4009,4009,400
Other expenses last period€9,400€9,400€9,400€9,400€9,400€9,400
The Foreqast forecast — Shopify feeds orders and revenue, Meta feeds ad spend, and paid revenue computes from budget × ROAS. The dashed cells are the levers you plan ahead; the purple €8,000 is an adjusted August budget, and paid + total revenue for that month already reflect it — automatically.

Change a future ad-budget cell (one of the dashed pills) and it becomes a decision in the simulator, which replays the month-by-month cash impact before you commit. Either way — spreadsheet or app — the rule that keeps you solvent is the same: scale inside your margin.

Before you raise the budget
  • Know your contribution margin per order.
  • Keep acquisition cost below it — that's the payback check.
  • Simple: hold the margin line and grow steadily.
  • Advanced: model budget → revenue together for faster, efficient growth.

Test a bigger ad budget before you spend it

Foreqast models budget, ROAS and revenue together and simulates the cash impact — so you scale inside your margin, not past it.

Get early access →

No credit card required.

Prefer to read this on its own? Open the full article.