— How are we going to finish the year?
This is probably one of the most common questions in budgeting, management control and financial planning.
It is asked in companies of all sizes, educational institutions, healthcare organizations and nonprofits alike.
And the situation is usually very similar.
You have an annual budget.
You have actual year-to-date results.
You know how much budget is still available.
You may even have sophisticated ERP systems, dashboards and financial reports.
However, when somebody asks:
How are we going to finish the year?
The answer is not always obvious.
Most systems are very good at showing where you are today.
Far fewer are capable of showing where you are heading.
Waiting until the end of the year to discover there was a problem ❌
Detecting the problem early and acting on time ✅
That is precisely why forecasting matters.
Budgeting and forecasting combine data, experience and professional judgment. In this series of articles you will find practical methods, examples and best practices designed to support planning, management control and decision-making.
💡 Key Idea: A good forecast is not about predicting the future perfectly. It is about identifying potential problems before they happen.
The Importance of Having the Data
Before discussing forecasting methods, there is one essential requirement:
You need the data.
The more historical information you have available, the more reliable your forecasts will become.
📅 Annual Budget
The original estimate prepared at the beginning of the budget cycle.
📊 Current Results
Actual year-to-date figures available at the time of the analysis.
📈 Historical Data
Ideally two or three years of complete historical information.
📚 Annual Factors
Historical relationships between year-to-date results and full-year totals.
💡 Practical Experience: If we have the data in Excel, we can calculate almost anything.
And that is exactly what we will do next.
Four Methods to Forecast Year-End Results
There is no single correct way to forecast year-end results.
The following methods are practical approaches that have proven useful in real budgeting and management control processes.
Each one looks at the problem from a different perspective.
And by the end of the article, you will see why combining several methods often produces a better estimate than relying on a single one.
📈 Method 1: Historical
This method forecasts year-end results using actual historical behavior observed in previous years.
It starts by calculating how much of the annual result had already been achieved by the same point in time in prior years.
Advantage: Based on real historical performance.
Limitation: Exceptional years may distort the estimate.
📉 Method 2: Linear Trend
This method builds a linear trend using complete year-end historical results.
If revenue or expenses have shown a consistent long-term direction, this method tends to capture it effectively.
Advantage: Identifies long-term trends.
Limitation: May react slowly to recent changes.
📊 Method 3: YTD Linear
This method uses a trend calculated from historical year-to-date values at the same month of each year.
The result is then adjusted using the weighted historical factor.
Advantage: More responsive to current year behavior.
Limitation: More sensitive to temporary fluctuations.
📅 Method 4: Budget
The approved annual budget itself can be used as an additional forecasting reference.
Although it is not a calculated forecast, it contains assumptions and analysis performed during the budgeting process.
Advantage: Always available.
Limitation: Does not automatically reflect changes occurring during the year.
⭐ Recommended Result: Weighted Forecast
If I had to choose a single estimate to work with, I would choose the weighted forecast.
Not because it is more sophisticated.
But because it combines multiple perspectives into a single estimate.
In this example, the weights are:
- Historical: 30%
- Linear Trend: 30%
- YTD Linear: 15%
- Budget: 25%
Weights can be adjusted over time.
A method can even receive a 0% weight if experience shows that it adds little forecasting value.
Continuous monitoring and feedback are what ultimately determine the most appropriate weighting scheme.
📌 Important
More sophisticated methodologies exist, including statistical models, exponential smoothing, ETS forecasting, ARIMA and other advanced techniques.
However, in many organizations the simple methods presented in this article provide sufficiently good results with far lower complexity and much easier maintenance.
No model can replace your knowledge of your organization, your market or the specific circumstances that may influence future results.
📝 Practical Example: Forecasting Year-End Results
Assume you have budget and actual information available through the end of August.
You also have historical results from previous years and want to estimate how the current year may finish.
The following model combines historical factors, year-to-date analysis, linear trends and budget references.
Illustrative budget forecasting model combining historical factors, trends and weighted estimates.(Click the image to view it full size)
Sample budget forecasting model used throughout this article.
Notice that each method produces a different estimate.
That is perfectly normal.
The real value comes from comparing the results and combining them into a weighted forecast.
💻 Excel Implementation
Excel contains everything required to build this forecasting model.
1. Annual Factors (Columns AF:AH)
The first step is to calculate the relationship between year-to-date results and annual totals for each historical year.
[AG7] = IFERROR(AA7/AD7,0)
[AH7] = IFERROR(AB7/AE7,0)
2. Weighted Factor (Column AI)
3. Historical Method (Column AK)
4. Linear Trend Method (Column AL)
5. YTD Linear Method (Column AM)
6. Budget Method (Column AN)
7. Average and Weighted Forecast
8. Final Forecast (Column W)
The final forecast is not based on a single method.
It is the weighted combination of multiple forecasting approaches.
📈 The Real Value Lies in Interpretation
Many professionals focus exclusively on calculating the forecast.
But the calculation is only part of the story.
The real value comes from correctly interpreting what the numbers are telling you.
💡 Key Idea: The goal is not to predict the exact final result. The goal is to make better decisions.
If several estimates suggest that spending will exceed the budget, it may be time to investigate what is happening.
If forecasts indicate a favorable trend, you can anticipate future scenarios and build better budgets for the years ahead.
📊 Before Building Complex Models, Visualize the Data
In many situations, a simple chart provides more insight than a spreadsheet with hundreds of rows.
That is why I always recommend creating simple visualizations for:
- Revenue.
- Expenses.
- Operating Results.
- Forecasts.
- Historical Factors.
Especially when working with multiple years of historical information.
💡 A simple chart can reveal in ten seconds what one hundred spreadsheet rows take several minutes to explain.
More than once, I have worked with organizations that believed everything was going well simply because revenue continued to grow.
The problem was that expenses were growing even faster.
When both trends were displayed on the same chart, the issue became obvious almost immediately.
That is exactly the type of situation that forecasting helps identify long before it becomes a real problem.
✅ Best Practices
📚 Use Historical Data
Whenever possible, include two or three years of historical information instead of relying solely on the previous year.
📊 Compare Methods
Avoid depending on a single estimate. Different methods often provide complementary perspectives.
📈 Visualize Trends
Patterns become far easier to identify when represented graphically.
🔄 Refine Your Weights
Forecast accuracy often improves when weights are periodically reviewed and adjusted.
❌ Common Mistakes
- Relying on only one forecasting method.
- Ignoring available historical data.
- Assuming that the budget will automatically be achieved.
- Trusting a trend line without applying business judgment.
- Failing to review forecasts periodically.
- Using outdated weighting factors.
- Treating a forecast as an exact prediction.
❓ Frequently Asked Questions
What is the best method for forecasting year-end results?
There is no universal answer. In practice, combining several methods usually produces better results than relying on a single estimate.
How many years of historical data should be used?
For most organizations, two or three years of historical information are usually sufficient.
Should weighted forecasts be used?
Yes. They allow you to assign greater importance to methods that have historically produced better results.
Can weights be modified?
Absolutely. In fact, periodic review and adjustment is recommended.
Can a method have a weight of zero?
Yes. If a method consistently adds little forecasting value, it can receive a weight of zero and be excluded from the final forecast.
Do I need advanced statistical models?
Not necessarily. In many organizations, simple forecasting methods provide excellent results while remaining easy to understand and maintain.
📚 Related Articles
If you are interested in budget management and forecasting, these articles will complement what you have just learned:
- Coming Soon: How to Forecast Next Year's Budget.
- Coming Soon: How to Build Budget Scenarios.
- Coming Soon: How to Estimate Revenue Using Historical Data.
- Coming Soon: How to Estimate Expenses Using Historical Data.
- Coming Soon: How to Allocate Budgets Across Departments and Cost Centers.
Tools born from real-world challenges
Many budgeting, reporting, data analysis and information consolidation tasks are repetitive and consume a significant amount of time. Tools such as Data Tools Suite and MultiMail were developed to help automate these activities and allow professionals to focus more on analysis and decision-making.
🚀 Explore Data Tools Suite 📧 Explore MultiMail
TRY IT. YOU'LL GET IT.
