- The Mind 🧠 of a CFO
- Posts
- Forecasting Without a Crystal Ball
Forecasting Without a Crystal Ball
Why It's Okay to Keep It Simple
The Mind 🧠 of a CFO
Welcome to The Mind of a CFO newsletter. This newsletter is designed to provide entrepreneurs with financial clarity to grow their businesses profitably.
In less than three minutes, you will learn one actionable insight into each issue, which dives deeper into my Inc. column.
Disclaimer: Some links below support my writing this newsletter, and some give you a deal.
Part 2 in our series on predicting cash flow.
Forecasting doesn't need to be complicated to be useful.
When I joined a $15M landscaping company as its CFO, we were two years behind on financials. There was no forecast, no forward-looking plan, so we started simple—with scenario forecasting.
Why? Because the business was evolving fast. Demand shifted with the seasons, opportunities popped up unexpectedly, and the books were not up-to-date. Instead of chasing a perfect forecast, we built flexible models to help guide singular decisions.
🔋Powered by FinDaily.io
Running a small business is challenging enough without the hassle of logging into multiple apps to monitor your company's financial health. That's where FinDaily comes in! Our automated platform streamlines the process, giving you more time to focus on what matters most - growing your business. Try FinDaily today and see the difference for yourself! Use the code “MINDofCFO” for 30% for 3 months.
Forecasting in the Real World
Here's how we used scenario forecasting to shape key moves:
An invasive species hits town. The Emerald Ash Borer was killing trees. I modeled a new service line to treat infected trees. On paper, it looked like a moneymaker. But the owner passed. It didn't align with the company's values, which mattered more than the numbers.
The aging fleet required commercial driver's licenses (CDLs). I analyzed replacing them with non-CDL trucks. Financially, it was a toss-up. But there were hidden costs: employees left once they got their CDLs, and replacement parts for the old trucks had to be shipped from France, causing massive delays in repair time. That analysis helped leadership confidently move forward to non-CDL trucks.
Both examples show that forecasting isn't just about numbers. It's a decision-making tool that requires factoring in intangibles.
Most Companies Start Simple
I surveyed 39 CFOs across industries and company sizes to see how other finance leaders handle forecasting. Here's what I found interesting:
81% used Excel or Google Sheets
38% used historical growth to forecast. For example, last year's sales plus 10% growth.
19% used moving averages. This is our primary method at a2 for our fractional CFO clients.
38% used a hybrid approach of historical growth and moving averages
Most updated their forecasts quarterly. Our team does it monthly.
How to Start Forecasting in Your Business
If you're not forecasting yet, start here:
Export your income statement by month to Excel.
Use 3- to 6-month averages to project near-term revenue and expenses.
Review margins and net income percentages to ensure they align with your industry (ask ChatGPT if you are unsure of your targets).
Dig in if the percentages are off. How can you correct them?
Cutting expenses
Increasing revenue
Getting more capital
Collecting AR faster
Add actuals as each month closes to compare with the forecast. Where were you off and why?
Keep it simple. Focus on revenue, cost of sales, operating expenses, and cash.
Bottom Line
Your forecast should help you make better decisions—not add complexity. Start small. Keep it flexible. And let your forecast evolve as your business grows.
Stay tuned—next time, we'll cover how to fill in the forecast with actuals.
Thanks for reading, Luke Templin!
P.S. Want to make smarter financial decisions in 2025? Then, get a free financial health check.
If you're a service-based business generating $1M+ in annual revenue, you could be leaving money on the table without realizing it. We’re offering a free Financial Health Check—designed to uncover hidden profit opportunities and pinpoint what’s holding you back from financial growth.
Here’s What You’ll Get—At No Cost:
✅ 45-Minute Deep Dive Call: Discuss your biggest financial roadblocks & goals with me.
✅ Financial Health Check: We’ll analyze your accounting file for missed opportunities.
✅ 30-Minute Key Findings Session: Get tailored insights & actionable recommendations.
📢 Spots are limited! If you're serious about growing your business value, apply today: