The Ad Spend and Sales Target Calculator

How much should
I spend on ads?

Start from the sales you want, not from what is left in the bank. Type your target and the file tells you the ad budget for the month and the day, the orders and visits it takes, and what is left for you after the ads. Then it plans your whole year, month by month.

One Excel fileArabic and EnglishA month and a year plan2027 seasons includedExcel, Sheets and Numbers

14 days to change your mind. Open the file, decide, no questions.

The problem

A budget with no target
is a guess.

Most budgets are set by feel: what last month cost, or what a competitor seems to spend. Neither tells you whether the sales you want will make money after the ads.

And when the budget jumps for a busy month, ads cost more and results drop. The file shows you the jump before it happens, and how much money to have ready.

What is inside

Type your target.
Get your budget.

Your numbers

Your sales target, your average order, what you keep from each sale, and your ROAS from the last 30 days.

What the target needs

The ad budget for the month and the day, the orders and visits it takes, and the most you can pay for each visit.

Does it make money?

What is left after the ads, the lowest ROAS before the ads lose money, and a verdict in plain words.

What if ROAS changes?

The same target at eight levels of ROAS, so you see where the ads start to lose money.

Your year, month by month

Twelve months with the 2027 seasons, Ramadan, Eid, White Friday and the national days, and a warning before every big jump.

The file itself

Your target,
then the verdict.

A look inside, blurred on purpose. The verdicts are real. Your numbers and your plan are yours when you buy.

Section 3 of the Ad Spend Calculator and its verdict, blurred on purpose
Section 3. Does the target make money, with the verdict.
The year plan of the Ad Spend Calculator, blurred on purpose
The year plan, month by month, with a check for every month.
The Arabic tab of the Ad Spend Calculator, blurred on purpose
The Arabic tab, built right to left.
Who it is for

Owners who set the ad budget themselves.

  • Store owners planning next month or next year
  • Anyone asked 'how much should we spend?' by a partner or a boss
  • Marketers who need to defend a budget with numbers
What it will not do

It cannot promise the ROAS you type. It shows what your target needs at that ROAS, and warns you before the busy months, when ROAS usually drops.

Questions

Before you buy.

Which software?Excel, Google Sheets or Numbers. No add-ons.
Does it work in my currency?Yes. Type your currency once and every label follows it.
Does it work for any ad platform?Yes. It works from your total ad spend and sales, whatever platforms you use.
Is it part of the Toolkit?No. The Toolkit checks the account you run now. This file plans the budget your target needs.
Can I share or resell the file?No. Your copy is for your own business. Sharing, uploading or reselling it, or selling anything built from it, is not allowed. Read the licence.
What if it is not what I expected?Email me within 14 days and the money comes back. No questions.
Get the file

. One budget set right pays for it many times over.

Sent to you by email, Arabic and English, updates included, and 14 days to change your mind.

Asma Adel Farag
Performance Marketer · UAE & MENA
© Asma Adel Farag. All figures verified and available on request.