Target

Knowledge base · Templates

Marketing budget template 2027: a free Excel calculator for small business

Enter your revenue and a percentage, and the template gives you the annual and monthly marketing budget, a split by category and a monthly plan that follows the Finnish year.

Quick answer

Annual budget = annual revenue × percentage. Monthly budget = annual budget ÷ 12. A common guideline is roughly 5–12 percent of revenue, and the template lets you test your own percentage.

What is inside the template

Calculator

Revenue and percentage in, annual and monthly budget out, plus a split by category that checks it adds up to 100 percent.

Category split

A starting split: tools 25 percent, content 25 percent, paid promotion 40 percent and testing 10 percent. Change it to fit your business.

Monthly plan

The annual budget divided across the months with seasonal weights for Finland, with planned and actual columns.

Results tracking

Enter spend, leads and new customers each month and the sheet calculates cost per lead and customer acquisition cost.

Example: €120,000 revenue and 8 percent

The annual budget is €9,600 and the monthly budget €800. Split by the starting percentages, that is €200 for tools, €200 for content, €320 for paid promotion and €80 for testing.

Seasonal weights

Marketing budget is rarely spent evenly. The suggested weights give more to September and to November and December, and less to July. They are an example, not a rule, so change them to fit your industry.

Frequently asked questions

How much should marketing cost as a share of revenue?

A common guideline is roughly 5–12 percent of revenue. Established businesses with steady demand usually sit at the lower end, while new or fast-growing businesses spend more. The exact figure depends on your industry, margin and goals.

How do I calculate my monthly marketing budget?

Multiply annual revenue by your chosen percentage and divide by twelve. For example, €120,000 × 8 percent ÷ 12 = €800 per month.

Is €1,000 a month enough for marketing?

For many small businesses, yes. For a company with €150,000–200,000 in annual revenue, €1,000 a month is about 6–8 percent, in line with common guidelines. It covers tools, regular content and a focused paid campaign, but not an agency retainer on top of ad spend. What matters most is that it is spent on a clear plan.

Is the template free?

Yes. Download it without signing up and use it in Excel or Google Sheets.

Related guides

Marketing calendar 2027: a month-by-month plan for Finnish businesses

A month-by-month marketing calendar with a free template.

Content calendar template: a free Excel template for small business social media

A free Excel calendar with pillars, rhythm, publishing plan and tracking.

Turn your budget into a plan

Write your strategy, year plan and tasks in Target and keep them next to the content calendar.

See strategy and brand book

Plan once, publish to every channel

Build your content calendar in Target, schedule posts for each channel and let them publish automatically.

Start your free week
Target Marketing Platform Logo
Privacy Overview

This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

For more information about how we use this information, please see our Privacy Policy page.