spreadsheet, number, numbers, excel, price list, row, column, spreadsheet, spreadsheet, spreadsheet, spreadsheet, spreadsheet, price list
Photo by tomfield on Pixabay

Costs and pricing

Part of Before you price a brand deal, check what sponsorship rates really cost

How to build a sponsorship rates budget template that holds up

A step-by-step method for building a sponsorship rates budget template, with cost lines, a before and after table and the checks that keep a rate defensible.

What to take away

  • A sponsorship rates budget template is a spreadsheet model that turns a creator's delivery costs, time and risk into one floor rate per campaign.
  • Build it in five blocksdelivery costs, production days, usage and exclusivity, platform fees, contingency.
  • Label every input in pounds sterling and date it so a quote can be defended months later.
  • Check the finished model against advertising rules before you send it, because disclosure duties sit with both brand and creator.
  • Review the template each quarter rather than rebuilding it for every deal.

Start from the delivery cost, not the follower count

Rate arguments often fail because the number came from a follower count. The template starts lower: what the campaign costs you to deliver. List hard costs first: props, travel, editing software, a camera operator if you use one.

Cost Lines to Include

  • Productionprops, location hire, equipment rental, crew day rates
  • Post-productionediting, captions, thumbnails, extra revision rounds
  • Distributionpaid amplification, platform fees
  • Administrationcontracting time, invoicing, chasing payment

A creator paying £180 a month for editing software and £60 for music licensing carries £240 of fixed monthly cost before any campaign begins. Those figures are illustrative, not market data. Record whether each item is an overhead or campaign-specific cost, and keep evidence beside the dated input.

Split the list into fixed and variable lines. Software subscriptions repeat whether or not a campaign runs, so they belong in a monthly total. Props and travel only appear when you shoot, so they sit inside the campaign. Mixing the two is the fastest way to underquote a small job.

Cost lines to include

Use a separate row for each applicable line, mark it fixed or variable, and keep its evidence with the dated input:

  • Props and materials.
  • Travel and accommodation.
  • Location hire.
  • Crew and contractor fees.
  • Editing software allocated to the campaign.
  • Music licences.
  • Captions, outsourced post-production and agreed revisions.
  • Platform or payment-processing charges, using the amount in the applicable platform terms or payment statement; do not assume a standard commission.
  • Bookkeeping and project administration, where attributable.
  • Compliance review and any likely re-edit cost.
  • Usage rights, priced as a separate licence.
  • Exclusivity, priced as a separate line.

Fixed vs Variable Costs

Fixed

Editing software
Monthly
Music licensing
Monthly
Props
—
Travel
—

Variable

Editing software
—
Music licensing
—
Props
Per shoot
Travel
Per shoot

Cost lines to leave out

  • Your own salary, unless you are modelling a limited company.
  • Equipment you already own and have written down.
  • Anything you cannot evidence with a receipt or a diary entry.

Price the time block before you price the post

Time is the second block, counted in days, not deliverables. A single video may take three days: one day each to plan, shoot and edit.

Set the day rate from an annual income target: start with personal living costs and business overheads, allow for income tax and National Insurance, then divide the required gross income by realistic billable days. A tax forecast helps avoid treating the whole gross amount as spendable. If your required day rate is £350, a three-day campaign carries £1,050 in time cost, before hard costs and margin.

Use HMRC guidance for tax and VAT assumptions, and name the rate card, contract or dataset behind any market benchmark. The data and sources page explains where benchmark figures come from and why a template should record its source beside every assumption.

Add usage, exclusivity and contingency

Usage rights are where templates usually undercharge. A brand that wants to run the content as paid media for six months is buying a separate licence at a separate price. Give each licence a start and end date, because an open-ended grant is impossible to reprice later.

Exclusivity works the same way: a twelve-month category lockout removes other income, so it carries a premium. Finish with a contingency line, typically 10 to 15 per cent of the total, labelled so the brand reads it as a buffer.

Before and after: what the template changes

Before and after

Before the template

Basis for the quote
Follower count
Hard costs
Ignored
Usage rights
Included free
Exclusivity
Not mentioned
Contingency
None
Source of each figure
Unrecorded

After the template

Basis for the quote
Delivery cost plus days
Hard costs
Itemised, dated
Usage rights
Priced as a licence
Exclusivity
Priced by duration
Contingency
10 to 15 per cent
Source of each figure
Named and dated

Check the creative against the rules before you quote

A template is a commercial document, but the campaign it prices still has to comply with advertising rules. The ASA's Copy Advice service can pre-clear influencer creative, which is worth doing before you commit to a delivery date.

Where a campaign reaches United States audiences, the FTC's advertising and marketing guidance sets out disclosure and endorsement expectations that also make a useful cross-check. For video formats, the IAB UK principles for digital video creative best practice describe production standards brands increasingly expect. Build a compliance line into the template so the cost of a re-edit is captured.

Common questions

The answers below cover how to itemise costs, quote the rate, update the model and handle VAT.

How many cost lines should a sponsorship rates budget template have?

Enough to cover production, post-production, distribution and administration. Eight to twelve lines are workable; fewer hides costs.

Should the template quote a day rate or a campaign rate?

Both. The day rate keeps the model honest when scope changes, while the campaign rate is what the brand sees. Keep the day rate on a working tab.

How often should the template be updated?

Quarterly is enough, plus a review after any campaign that ran over budget. Update the dated source beside each figure.

Does the template need to show VAT?

Only if you are VAT registered. If you are, show the fee exclusive of VAT and add the tax as a separate line.

More in Costs and pricing