A Forecast With Stated Assumptions

I’ve spent eleven years sitting in boardrooms where consultants try to sell “predictive modeling” and “multi-touch attribution” to founders who barely have time to eat lunch. It makes me sick. They hand you a thirty-page deck filled with complex algorithms and tell you this is the only way to know how to forecast marketing results, but for a small firm, it’s just expensive noise. If you don’t have a dedicated data science team, these enterprise-grade models aren’t tools; they are distractions that leave you guessing while your budget bleeds out.

I’m not here to sell you a software subscription or a complicated math degree. My promise is much simpler: I am going to show you how to build a working forecast using nothing but your last six months of data and a basic spreadsheet. We are going to strip away the jargon and focus on the only numbers that actually matter to your bank account. By the time you finish reading, you’ll have a practical system you can update in twenty minutes every Monday morning.

Simple Marketing Budget Projection Models for Solo Founders

Stop looking for “predictive analytics for marketing ROI” software that costs more than your monthly rent. You don’t need a data scientist; you need a basic spreadsheet and some honesty about your past performance. I always suggest the Reverse-Engineering Model for founders who are drowning in guesswork. Start with your revenue goal for next month, subtract your COGS and desired profit, and what’s left is your ceiling. From there, work backward using your average customer acquisition cost. If you know a lead costs you £40 and you need ten sales to hit your target, you know exactly what your spend needs to be.

If you’re starting from scratch with no historical data, use the Percentage of Revenue Method. It’s blunt, but it works. Take your gross revenue from the last six months and set aside a fixed percentage—usually 5% to 10%—for your next push. This isn’t about complex marketing attribution modeling or tracking every single click; it’s about ensuring your growth is funded by your actual success rather than your hope. Pick a number, stick to it, and spend your afternoon auditing where those pounds actually went last month.

Quickly Calculating Marketing Return on Investment Without a Data Team

Stop trying to build a complex marketing attribution modeling system. Unless you have a team of analysts and a six-figure software budget, you aren’t going to untangle every single touchpoint a customer has with your brand. It’s a waste of your Tuesday. Instead, focus on the “back-of-the-napkin” approach to calculating marketing return on investment. Look at your total spend for the month and divide it by the number of paying customers that came through your primary channel. If you spent £500 on ads and got five customers, your cost per acquisition is £100. That is your baseline.

Once you have that number, you can actually start doing some real marketing performance metrics forecasting without losing your mind. If you know your average customer lifetime value—the total amount they spend with you before they quit—you can work backward. If a customer is worth £500 and it costs you £100 to get them, you have a 5:1 ratio. That is the only number that actually matters when you’re deciding whether to increase your spend next month. Don’t get bogged down in predictive analytics for marketing ROI that requires a PhD; just stick to the math you can verify in an hour.

Five ways to stop guessing and start calculating

• Stop looking at vanity metrics like “impressions” or “reach.” They don’t pay the rent. When I forecast, I only look at two numbers: how much it costs to get a click and how many of those clicks actually turn into a conversation. If you can’t track the path from spend to lead, stop forecasting entirely.
• Use your “gut” math to find your baseline. Look at your last three months of sales. If you spent £500 on ads and got 5 customers, your cost-per-acquisition is £100. Don’t try to build a predictive model that assumes a 50% improvement next month; assume you’ll hit that same £100 mark until you prove otherwise.
• Build a “Worst-Case” scenario in ten minutes. Open a spreadsheet, take your current lead conversion rate, and cut it in half. If your business survives that math, your forecast is realistic. If it doesn’t, you’re over-leveraged and your marketing plan is a fantasy.
• Factor in the “Lag Time.” Most founders forget that a lead generated on Tuesday doesn’t become cash on Wednesday. If your sales cycle is three weeks, your forecast for March shouldn’t be based on the ad spend you start in March; it should be based on the work you did in February.
• Limit your variables to three. I see people trying to forecast based on seasonality, platform algorithm changes, creative fatigue, and economic shifts all at once. It’s nonsense. Pick your three biggest drivers—usually spend, conversion rate, and average order value—and ignore the rest of the noise.

The Afternoon Audit: Three Rules for Realistic Forecasting

Stop chasing “predictive modeling” software; if you can’t run the calculation on a single sheet of paper in under sixty minutes, you’re wasting time you don’t have.

Base your numbers on what actually happened last quarter, not what a glossy agency deck says could happen if you just “optimized your funnel.”

Always build a 20% error margin into your projections because, in the real world, your cost-per-lead will almost certainly be higher than your best-case scenario.

Stop Guessing and Start Measuring

Look, we’ve covered the essentials: stop trying to build a predictive model that requires a PhD and a team of analysts. You don’t need a complex dashboard to see if your marketing is working. You just need to track your spend, understand your cost-per-lead, and ensure your ROI isn’t a total fantasy. If you can’t calculate your projected results on a single sheet of paper in under an hour, your model is too complicated to be useful. Stick to the math that actually moves the needle for your specific business, and ignore the enterprise-grade fluff that’s designed to make consultants look smart while leaving you in the dark.

At the end of the day, forecasting isn’t about being a psychic; it’s about reducing the amount of money you throw at things that don’t work. You are going to get some numbers wrong, and that is perfectly fine. The goal is to move from “I think this might work” to “I know exactly what happens if I spend an extra £500 next month.” Stop waiting for the perfect data set to arrive. Grab your spreadsheet, do the math, and get back to running your business. You have enough on your plate without trying to play data scientist.

Frequently Asked Questions

What do I do if my past data is a complete mess or non-existent?

Stop panicking. If your data is a graveyard of broken spreadsheets, stop trying to excavate it. You’re wasting time. Instead, start from zero today. Pick one metric—just one—like lead volume or total sales from a specific source. Use a “proxy” method: look at your competitors’ basic presence or use industry averages as a placeholder for the next thirty days. Clean data starts with a single, consistent entry point. Build the trail as you walk it.

How much of a "buffer" should I add to my budget to account for things going wrong?

Add 15%. No more, no less. If you’re planning for 20% or 30%, you aren’t forecasting; you’re guessing, and you’re overcomplicating your math. That 15% buffer covers the inevitable spikes in ad costs or the one tool that suddenly jumps in price. If your entire business model collapses because a single campaign went 15% over budget, you don’t have a marketing problem—you have a structural stability problem. Keep the math tight and the buffer realistic.

Is it better to forecast based on how much I spend or how many leads I actually get?

Neither. You’re asking the wrong question. If you forecast based on spend, you’re just planning how to lose money. If you forecast based on leads, you’re dreaming.

How often should I actually sit down and update these numbers so I'm not flying blind?

Don’t let this turn into a weekly chore, or you’ll stop doing it. If you’re a solo founder, a monthly ritual is your sweet spot. Pick one Friday afternoon a month, grab your bank statements and your lead tracker, and run the math. Checking every day is just neuroticism; checking once a quarter is too late to fix a sinking ship. Once a month keeps you honest without wasting your life on spreadsheets.