How to Annualize 9 Months of Data in Excel

You have nine months of strong data for your business tucked away in an Excel sheet, and now you want to figure out what your full-year performance will look like. Projecting annual numbers from partial data is common, whether you're building a budget, setting next year's targets, or just checking on your internal forecasts. This guide will break down simple and advanced ways to annualize your data in Microsoft Excel for an accurate picture of your year-end results.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Bother Annualizing Data?

Annualizing data takes partial info — like months of sales — and expands it to create a forecast for a full year. Think of it as a scaling function. It's a convenient way of estimating what your full-year metrics might look like based on current performance. However, it's crucial not to use this as a prediction of the future since there is no way to guarantee the accuracy of the forecast, considering external factors could influence your performance.

So, why might you do this? Here’s when it’s most useful:

• Budgeting and forecasting: When you’re creating your budget for next year, you need a solid estimate of this year’s total revenue to use as a baseline.
• Goal setting: You can see if you're on track to meet your annual goals before the year ends, allowing you time to make adjustments if you're not.
• Investor reporting: Shareholders want to know where the business is headed, and annualized metrics give them an estimate of year-end performance.
• Comparative analysis: It allows comparison against a full year, even if you only have a portion of the year’s results to identify trends.

The trick is to make the most of a reliable projection without fooling yourself or your team by relying only on data from your most successful period of the year.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

First Things First: Prepare Your Data

Before writing a single formula, you need your data clean and organized. This means having everything in a simple table, with one metric per column. For these examples, let's say we want to annualize our company’s monthly revenue. Your data arrangement should be simple:

Step 2: Calculate the Prorated Growth Factor

Next, you need to identify how much to “scale up” your nine-month total. Since you have nine months of data, it will be divided by twelve to get an estimate per month, and the equation could look like 12/9 to get the growth factor. In this case, it's 1.334.

Step 3: Calculate Your Annualized Numbers

Finally, multiply your total income from the nine months by your prorated growth factor to get the annualized figure. Be cautious, as this method does not account for seasonality, so the results may not always align with actual outcomes.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 4: Advanced Forecasting, Factoring in Seasonality

This method is more reliable, especially for businesses with obvious cycles, like e-commerce sales during the holidays or certain B2B transactions where a majority of business occurs in a specific part of the year. You’ll utilize last year’s data to get a better idea of where the next quarters will land. It’s more complex but provides far better accuracy when you have the data.

Data Gathering: Add Last Year's Numbers

In order to use this approach, we’ll need your turnover for every month of last year as well. Set up your spreadsheet similarly:

To calculate last year's growth, find out what percentage of your income from last year’s final quarter came from October through December. This will help you understand the importance of the final quarter on your business. Use the SUM formula to get your totals and then divide the final quarter total to see its percentage of the whole year. Similarly, calculate this year’s totals and project using these ratios.

Step 2: Determine Your Year-over-Year Growth Rate

To gain more accuracy in the calculation of your sales numbers, recognize the rate at which your turnover has been increasing or shrinking over time. Simply divide your totals for the last three months of the past year by the sum of the whole previous year. For example, if your sum for last year was $23 million and the previous three months’ sales were $4 million, you will understand a growth rate of around 16% for this period.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 3: Forecast the Rest of This Year’s Revenue

Now, make your past-year end a baseline and apply the current growth rate to it to get an estimate of where it will be for the remainder of the present year. Use the following formula to accomplish this:

="Last year's final three months' sales value" * (1 + "Current growth rate")

Final Thoughts

Finally, you can get the final result from your nine-month totals to begin your forecasts for the final three months and acquire a definitive annual forecast. Use the spreadsheet to enter the next formulas for projection. Choose the right method based on the stability of your business income.

Proper annualization can help with more realistic planning for your business by using the right data and forecast model. This could assist in creating more accurate budgets for your operations as a whole.

The method to connect last year's data with current period results can be challenging as it requires going back and retrieving past information to set everything up. Graphed helps alleviate this by directly integrating with your databases to pull up necessary data without manual entry, speeding up your processes significantly.