Programmatic Advertising Cost Calculator: Budget, Fees and GST Worked Out

What does this worksheet work out?

Every programmatic brief arrives in one of two forms. Either there is a goal, such as "reach 16 lakh people in Maharashtra and Karnataka", and someone needs the budget, or there is a fixed number in the finance plan and someone has to say what it buys. The sums are the same in both cases, run in opposite directions, and most budget arguments start when they are done in the wrong order.

This post covers the formulas, two filled-in worksheets, a sensitivity check and a template you can rebuild in Excel or Google Sheets. It does not cover price levels. For CPMs by channel and why they differ, read our guide to programmatic advertising cost in India. For the deal minimums each OTT app, publisher or screen network sets, see our post on the minimum budget for DV360.

If you want the line-by-line sums done for you, ask for a free media plan and a DV360 specialist prices each line from our rate card. The worksheet below shows the arithmetic behind those sums and adds the fee and GST steps that sit outside the media lines.

How do you turn an all-in budget into working media, and back?

Five letters carry the whole calculation. B is the all-in budget, GST included, and g is the GST rate, usually 18%. f is the total of every fee charged as a percentage of media and added on top of it. X is fixed costs before GST, such as creative versions or a flat monthly fee. M is working media, the money that actually buys impressions and views.

From a budget to delivery:

M = (B ÷ (1 + g) − X) ÷ (1 + f)

From a goal to a budget:

Impressions needed = target reach × average frequency

B = (M × (1 + f) + X) × (1 + g)

For each line in the plan, a CPM line delivers line media ÷ CPM × 1,000 impressions, and a CPV line delivers line media ÷ CPV views. Going the other way, line media is line impressions ÷ 1,000 × CPM. A rough reach figure is impressions ÷ average frequency.

Keep working media share, M ÷ B, on the sheet too. It tells you how much of the budget actually reaches a screen.

Why divide rather than subtract? Because GST and percentage fees are charged on a smaller base than the total you hold. Taking 18% off ₹15 lakh gives ₹12.3 lakh, but the true pre-GST amount is ₹15,00,000 ÷ 1.18 = ₹12,71,186, and the gap grows with every layer you strip out the same way.

If a fee is already inside the CPM you were quoted, leave it out of f. Our guide to DV360 pricing explains which fees usually sit where.

How do you go from a goal to a budget?

A term insurance brand wants to reach 16 lakh people aged 28 to 45 across Maharashtra and Karnataka, at an average frequency of 3, over four weeks. The plan puts 60% of impressions on YouTube non-skippable in-stream and 40% on in-stream video across publisher sites, at the default rates on our rate card. The 15% fee and the ₹1 lakh for Marathi and Kannada creative versions are illustrative.

So the brief needs about ₹14.5 lakh all-in, of which ₹9.8 lakh, or 68%, is working media. The rest is fees, creative and tax. Show that ratio to whoever set the goal. It explains why "₹10 lakh for 16 lakh people" does not add up.

Two cautions. Step 1 treats both lines as one pool of people, but some people see both, so unique reach comes in lower; our reach and frequency calculator shows how to allow for overlap. And check every line against its channel minimum. These two auction lines have no deal to clear, but a PG line would.

How do you go from a budget to delivery?

A Hyderabad real estate developer has ₹15 lakh all-in, GST included, for a three-week project launch in Telugu and English. Creative is made in-house, so there are no fixed costs, and the quoted fees on top of media total 12% (illustrative). Working media is split 40% to YouTube skippable in-stream bought per view, 30% to YouTube Shorts and 30% to rich media on news sites. Figures are rounded to the nearest rupee.

Working media is about 76% of the budget here, higher than in the insurance worksheet because there are no fixed costs and the fee is lower.

Keep the views in their own row, because a paid view on a skippable ad and a served Shorts impression are different units. To put every line on one basis, convert the view line to an effective CPM using its view rate, as our CPM calculator guide shows.

What happens if the CPM or the fee changes?

Final rates rarely match the planning number. Festive weeks, a narrower audience or a late booking push them up, a quiet month can bring them down, and fees differ between providers. A sensitivity check shows how much this matters before you commit.

Here is the Hyderabad budget run five ways, with the ₹15 lakh held fixed:

Notice the asymmetry. Delivery changes by 1 ÷ (1 + the rate change), so a 20% rise cuts it by 16.7% and a 20% fall lifts it by 25%. A two or three point change in the fee moves it by under 3%. Fees still matter, but a quote with a slightly lower fee and optimistic rates can easily deliver less than one with a higher fee and realistic rates.

Now hold the goal fixed and rerun the insurance brief. At rates 20% higher, the all-in budget rises from ₹14,46,774 to ₹17,12,529. At rates 20% lower, it falls to ₹11,81,020. Both moves are about 18.4%, a little under 20%, because the ₹1 lakh of creative does not change with the rate. Cutting the fee from 15% to 10% saves ₹57,773, or 4%.

Plan on the base case, then check that the high-rate case still gives a reach and frequency you could live with. If not, trim a line now rather than find the shortfall in week two.

How do you set the calculator up in a spreadsheet?

Use one sheet for each direction. On the budget sheet, put the inputs at the top.

Then give each line its own row, starting at row 11.

Check that column D adds up to 100% before you read anything else.

The goal sheet runs the other way.

Lines again start at row 11, with the line in column A, CPM or CPV in B and the planning rate in C. On a CPM line, put its share of the impressions in D, and line media in E is =$B$4D11/1000C11. A CPV line is priced per view, not per thousand impressions, so that formula gives the wrong answer for it. Type a views target in D instead and use =D11*C11. The CPM shares should add up to 100%, with any views planned on top of the impressions target.

Copy the budget sheet into three tabs for base, high and low and change only B6 on each, and you have the rate rows of the sensitivity table. Two more copies with B4 at 10% and 15% give the fee rows.

Where do the input figures come from?

Rates belong to the channel, not the formula, so take the ranges from our guide to what programmatic advertising costs in India. Start from our default rate for each format, which is what both worksheets use, and move towards the top of the range for festive dates, a single language or narrow targeting, as our guide to choosing a planning CPM explains.

The fee rate comes from your quote, so ask every provider which fees are inside the CPM and which are added on top. Minimums come from our DV360 minimum budget guide, and every PG or private deal line should be held against them. Use 18% for GST unless your finance team says otherwise. For frequency, the worksheets here use 3 and 4, and the reach and frequency calculator linked above explains how to choose your own.

Which mistakes break a cost worksheet?

• Planning delivery on the all-in figure. Only working media buys impressions.
• Taking percentages off instead of dividing, which understates your media every time.
• Counting a fee twice, once inside the CPM and again in f.
• Adding reach across lines, which ignores the people who see both.
• Putting views and impressions in one total.
• Sending the output as a quote. Rates and availability are final only once confirmed in writing.

Next step

A free media plan from our team does the line-by-line part for you, pricing each line from our current rate card and showing estimated impressions, reach and cost. It works on media money, so share the working media figure from B7 of your budget sheet, not the all-in budget. When you are ready to book, talk to our team for confirmed rates and availability.