CPM, CPC & CPV calculator
Enter any two of budget, rate and results to work out the third.
Media plan template
A ready-to-use Excel media plan for digital, video and CTV campaigns. Type in your channels, rates and volumes, and the budgets, GST and totals work themselves out.
What’s inside
- Media plan sheetChannel, platform, format, targeting, dates, buying model, rate and volume for up to 20 lines.
- Budgets work themselves outBuilt-in formulas for CPM, CPC, CPV, CPA and fixed fees, plus days, share of budget, GST and the total payable.
- Summary sheet with a chartBudget by channel and by buying model, ready to paste into a presentation.
- Indian number formatAmounts show in lakh and crore style: ₹9,46,000 or ₹1,25,00,000.
- Drop-down listsChannels from CTV, OTT and FAST to search, social, print and outdoor.
Excel file, 19 KB. Works in Microsoft Excel, Google Sheets (File → Import) and Apple Numbers. No sign-up.
Preview
| Channel | Platform | Model | Rate | Volume | Budget | Share |
|---|---|---|---|---|---|---|
| CTV | Smart TV apps | CPM | ₹400.00 | 10,00,000 | ₹4,00,000 | 42.3% |
| OTT | Streaming apps | CPV | ₹1.50 | 2,00,000 | ₹3,00,000 | 31.7% |
| Social | Instagram Reels | CPM | ₹120.00 | 8,00,000 | ₹96,000 | 10.1% |
| Search | Google Search | CPC | ₹25.00 | 6,000 | ₹1,50,000 | 15.9% |
| Total before GST | ₹9,46,000 | |||||
| GST @ 18% | ₹1,70,280 | |||||
| Total payable | ₹11,16,280 | |||||
The example rows show the format. Their rates are placeholders, not quotes: replace them with your own.
How to fill it in
- Add the campaign details at the top: brand, campaign name and dates.
- Add one row per channel or platform, for example CTV, YouTube pre-roll, Instagram Reels and Google Search.
- Choose the buying model and enter the rate from your quote. Use our CPM calculator if you need to work out volumes.
- Check the share column. It shows at a glance whether your budget is balanced the way you want.
- Share the Summary sheet with your team or client.
Questions
Can I use it in Google Sheets?
Yes. In Google Sheets, choose File → Import → Upload and pick the file. The formulas and drop-downs carry across.
Are the example rates real quotes?
No. They are placeholders that show the format. Rates change with platform, audience and season. Ask Team Manzi for a quote for your campaign.
Can I add more rows?
Yes. Copy the last row and paste it below. Then make sure the total formula at the bottom of the Budget column includes the new rows.
Planning a campaign? Let Team Manzi run it.
CTV, OTT, video pre-roll, display and social campaigns across India, the GCC and South East Asia.