If you are running or planning to run Facebook and Instagram ads, the first question is simple: how much should you invest to actually get results? We built a free Facebook Ads calculator to help businesses in McDonough and Henry County forecast their ad spend, leads, customers and revenue before launching a campaign.
What is the Facebook Ads calculator?
It’s a simple spreadsheet that works in Excel or Google Sheets. You enter a few numbers about your business, and it estimates what a Meta ads campaign could bring in, month by month, for a full year. It’s made for business owners, marketing managers and service companies that want clarity before they spend.
What you can forecast
- Monthly ad spend on Facebook and Instagram
- Leads you can expect from that budget
- New customers based on your closing rate
- Cost to win each customer, also called customer acquisition cost
- Revenue and gross margin month by month
- Return on investment for each quarter and the full year
Want the free calculator?
Send us a quick message and our team will share the calculator with you, free.
How to use it
Only edit the yellow rows. Everything else updates on its own.
- Monthly ads budget. How much you’re willing to invest in Meta ads each month.
- Cost per lead. What you typically pay to get one lead from ads in your industry. If you don’t know it yet, start with a conservative guess or ask us.
- Sales conversion rate. Out of every 10 leads, how many become paying customers?
- Average ticket. The average amount a customer pays you per sale. If most clients pay around $1,000, that’s your average ticket.
Once these are filled in, the calculator estimates your leads, customers, revenue and ROI for every month of the year.

A quick example
Say a McDonough business invests $2,000 a month in Meta ads and pays about $12 per lead. That’s roughly 167 leads a month. If 20% of them become customers, that’s about 33 new customers. With an average ticket of $500, that’s about $16,667 in revenue from $2,000 in ads, and each new customer costs about $60 to win.
These are example numbers, not a promise. Your real cost per lead depends on your industry, your offer, your area and your ads. The point is to see what has to be true for ads to pay off, before you spend a dollar.
Why this matters for local businesses
Most businesses run ads without a clear projection, which leads to wasted budget and inconsistent results. A forecast helps you:
- Set realistic expectations
- Plan your budget with confidence
- Know your break even point
- Make smarter marketing decisions
This matters even more in competitive local markets like McDonough, Stockbridge, Locust Grove and Hampton, where many businesses are trying to reach the same customers.
Want us to run the numbers with you?
Book a free strategy call. We’ll fill in the calculator together and recommend a budget that fits your goals.
See real numbers in our Henry County landscaper case study, or learn more about our ads management services.