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 Budget: How Much Should Your Business Spend on Marketing?
Plan your whole marketing year at once.
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 bookPlan 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