Financial Forecasting

What is Financial Forecasting?

Financial forecasting is the process of projecting a company’s future financial performance by estimating revenue, expenses, cash flows, and balance sheet positions. This is based on taking historical data, looking at operational drivers, and creating explicit assumptions about future performance.

A financial forecast typically produces forward-looking versions of the three core financial statements:

Financial Statement	Purpose
Income Statement	Forecasts revenue, expenses, and profitability
Balance Sheet	Forecasts assets, liabilities, and equity
Cash Flow Statement	Forecasts cash generation and financing needs

Why Financial Forecasting Is Important

Financial forecasting is essential for decision-making in corporate finance, investment analysis, and strategic planning. Companies need to evaluate future revenue growth potential, assess funding requirements, plan capital expenditure, and to estimate company valuation.

Financial forecasts are widely used in:

• Financial modeling
• Revenue modeling and analysis
• Budgeting and planning
• Mergers and acquisitions analysis
• Debt and credit analysis
• Equity valuation

Because financial forecasts connect business assumptions to projected financial performance, they are a core component of financial models used by analysts, investors, lenders, and management teams.

Types of Financial Forecasts

Before building a financial model, it is important to understand the type of forecast required and the purpose it will serve. Financial forecasts can vary depending on the time horizon of the projection and the specific financial focus of the analysis.

Financial Forecasting by Time Horizon

Analysts and investors must think carefully about what they expect to happen within a specific time frame. Typically, short-term should be ‘easier’ to forecast than long-term as it is deemed less volatile. This can allow for more detailed short-term assumptions and fine-tuning of which levers the company may use to grow.

If an analyst is looking at 12-month performance, they may focus on monthly sales figures, inter-year seasonality (e.g. Holiday traffic in stores and purchases) versus the previous year. Costs can be broken down to examine when price rises etc are likely during the year. These and other factors to help derive an accurate short-term forecast. For longer term forecasts (e.g. in five years’ time) this is not as helpful as can be overly complicated and be too reliant on specific scenarios playing out.

Longer-term is more difficult to predict, particularly in the wider macroeconomic and political environment, so forecasts tend to be broader and are typically more conservative.

There are also varying types of forecasts for these time horizons:

Operating Forecast (1–3 Years)

An operating forecast typically provides a detailed projection of financial performance over the next 12–36 months. These forecasts are commonly used for budgeting, financial planning, covenant analysis, and near-term valuation work. They can help organizations understand how the business is expected to perform in the short to medium term under current operating plans.

Strategic Forecast (3–10 Years)

Strategic forecasts extend beyond the operating budget and are used to evaluate the long-term trajectory of a business. These projections are often used in valuation models, including discounted cash flow (DCF) and leveraged buyout (LBO) analysis. Strategic forecasts help estimate long-term growth, steady-state profitability, and potential future financing structures.

Short-Term Cash Forecast (Weeks to 12-Months)

Short-term cash forecasts focus primarily on liquidity rather than accounting profitability. These projections assess whether a company will have sufficient cash to meet obligations such as interest payments, debt repayments, payroll, and operating expenses. Short-term cash forecasts are particularly important during periods of financial stress, refinancing, or when managing working capital closely.

Project Forecast (Timeframe can vary)

A project or transaction forecast focuses on the financial impact of a specific investment (or transaction). Examples include new capital projects, acquisitions, divestitures, or expansion initiatives. These forecasts are used to evaluate financial outcomes such as internal rate of return (IRR), payback periods, or the impact of integrating a new business into existing financial projections.

Putting Forecasts into Financial Statements

Revenue Forecasting

Revenue (or sales) forecasting involves projecting future sales based on key business drivers such as volumes, pricing, customer growth, or market demand. Depending on the industry, revenue forecasts may incorporate metrics such as same-store sales growth, sales pipeline conversion rates, or subscriber and churn dynamics.

Expense Forecasting

Expense forecasting focuses on estimating future costs, including cost of goods sold (COGS) and operating expenses. This process often involves identifying which costs scale with revenue and which remain relatively fixed. Accurate expense forecasting is critical because changes in cost assumptions can significantly affect projected profitability.

Income Statement Forecasting

Income statement forecasting combines revenue and expense projections to estimate profitability metrics such as EBITDA, EBIT, and net income. These projections are frequently used in valuation analysis, financial planning, and performance assessment.

Cash Flow Forecasting

Cash flow forecasting converts projected accounting profits into expected cash generation. This includes adjustments for working capital movements, capital expenditures, and other non-cash items. Cash flow forecasts are essential for evaluating funding needs, debt capacity, and the ability of a business to generate sustainable cash flows.

Balance Sheet Forecasting

Balance sheet forecasting projects the future levels of assets, liabilities, and equity. This involves rolling forward key items such as debt balances, cash holdings, retained earnings, and working capital accounts. Balance sheet projections are used to assess financial structure, leverage ratios, and overall financial stability.

Financial Forecasting Methods

Financial forecasts are typically built using different forecasting methods depending on the level of information available and the objective of the analysis. Two of the most common approaches are top-down forecasting and bottom-up forecasting.

Top-down forecasting starts with macroeconomic or industry-level assumptions (the ‘top’) and works downward to estimate company performance. Analysts may begin with total market size or expected industry growth and then estimate the company’s future market share.

Bottom-up forecasting, by contrast, builds projections from detailed operational drivers such as units sold, pricing, customer growth, or production capacity. This approach links financial outcomes directly to business activity and is widely used in financial modelling.

Financial Forecasting Framework

Most financial forecasts follow a structured process:

1. Collect historical financial statements
2. Identify key operating drivers (both for the sector and company)
3. Develop explicit forecasting assumptions
4. Build projected income statements, balance sheets, and cash flows
5. Test scenarios and sensitivities to ensure forecasting is reliable

Five Core Building Blocks of a Forecast

Nearly every forecasting exercise rests on these five interlinked components:

Step 1: Historical data

The starting point for financial forecasting is always the historical data. (This can be publicly available or can be obtained from private sources such as company management.) It is used to understand the business drivers, to form the basis for forecast assumptions, and to sense check the forecasts against the history.

It is smart to put as much historical information into a model as possible, typically five years of annual data is considered a good backdrop for a company model.

Step 2: Building ratios and statistics (based on the historical data)

Once historical data has been inputted into a model, an analyst can look for patterns and trends in the data. This may be year-over-year percentage changes or comparing ratios such as sales/profit. The most recent two years of historic sales may show 5% growth per annum, and this would be a useful statistic for looking at future sales expectations.

Analysts should look through all the data for key links and performance drivers. Ratios vary from sector to sector and an understanding of the key links and relationships between numbers is essential for producing a reasonable forecast. These ratios will also be used as a benchmark for the forward assumptions.

If there has been an event which has impacted historical performance (e.g., M&A or political unrest), this needs to be factored into the model before deriving forecasts from these figures.

Step 3: Making future assumptions (this links nicely with the previous component)

Assuming that sales have increased historically by 5% every period, analysts may assume that future sales might also increase by 5% per annum. Historical data is the primary place to look for assumptions but there may also be some important influence and inputs from industry research (such as expanding demand for products or markets).

A good guide to making assumptions is to look at historical performance and then decide if the company is in a better or worse position vs. market conditions to continue that growth (or decline) trajectory.

Always keep an eye on the overall actual figures when making percentage growth assumptions. E.g., if you expect a company to grow sales by 20% per year for five years, you need to know how much market share they will gain by doing this, and most importantly that the market is large enough to ensure this type of growth is deliverable.

Step 4: Forecasting financial data

The final financial forecasting step is to use the forward assumptions to build the forecast financial data. For example, we can now calculate that if last year’s sales were $100, and we are assuming sales will grow by 5%, then $100 x 1.05 = $105 sales expectation for next year. Forecasting is typically done in Excel, and the financial forecasts should be built with formulas wherever possible.

Step 5: Test scenarios and sensitivities to ensure forecasting is reliable

This step can be done once the forecasting is complete. It’s an exercise to see how the model performs if it were in a different scenario, such as an economic downturn, rising costs, or better-than-expected sales etc. If a company can still drive profitability in tough times, it will be a good sign for investors. Sensitivities are also helpful to analyze the impact of a certain unit (or division) or to look at fluctuating costs such as oil price if relevant for the company.

Step-by-Step: Financial  Forecast Examples

This section walks through the workflow for a single company forecast model. You can implement this layout in one worksheet or across multiple worksheets, depending on the complexity.

How to Build a Simple Forecast Model

Building a model is straight-forward if you stick to the key steps in creating one. These are often best created with assumptions to block rather than integrated through the model. This example is very simplistic, but it shows how you can follow the first 4 steps of creating a model and producing some forecasts.

To create the model, first upload all the historical data, and create the income statement and balance sheet. From this data, you can look at some ratios and growth rates, such as YoY revenue growth, and costs as a percentage of revenues.

Examining this data and looking for trends will form the basis of your assumptions for future growth. In this model, historical revenue growth was 5%, so 5% has been used for future growth assumptions. Note here that it is important to look at the historical performance and check it hasn’t been impacted by any one-off events which may have distorted the growth or the underlying base future being used for future calculations.

Once assumptions have been made, these can be used to drive the financial statements. It is good practice to keep to the same formatting structure when creating a model: keep the percentages in their own assumption boxes (rather than typing directly into the formulae) and link to the dollar figure first, and then add the percentage growth (as shown on row 13) and keep that structure throughout the model.

Once totals have been calculated and you have checked that the model is complete, you can consider adding scenarios.

Always check that the cells are formatted correctly for percentages, ratios, and currency.

3-Statement Financial Forecast

A 3-statement model goes further than a simple model as it includes a cash flow and links it up to the income statement and balance sheet. The strength of this type of model is that it can improve the accuracy for forecasts as an adjustment in one area will impact all three statements and ‘flow’ through. Get the entire explanation of a 3-statement model and a free template.

Scenario and Sensitivity Analysis

Once a base case forecast is working, you can turn it into a powerful decision tool by adding scenarios and sensitivities.  This will create an increased level of sophistication in the forecasting and is useful as will allow the model to instantly adapt (if modeled well) to a new scenario such as economic downturn, or better-than-expected sales growth.

Building Scenarios

When building scenarios, it’s best to create at least three sets of assumptions (unless for example, it is based on a binary yes/no decision-type scenario):

• Base case: this is the main or central view of performance
• Upside case: this explores better outcomes on key drivers (e.g., higher revenue growth, better margins, lower churn, more favorable terms etc.)
• Downside case: this looks at weaker performance or adverse conditions which may impact the business

For each scenario, adjust only the assumptions; the model logic remains the same. Use flags or a simple selector to switch between scenarios and see the impact on revenue, profit, cash, and funding needs.

Running Sensitivities

Sensitivities test how sensitive outputs are to changes in one or two inputs, this could be varying revenue growth while holding other assumptions constant . It could also look at expanding (or contracting) an operating margin such as EBIT or gross margin. Sensitivities may also focus on other operational aspects such as working capital days, project capex, maintenance capex, or debt scenarios.

In Excel, you can use data tables or manual “what if” changes to show, for example, how a 1–2 percentage point change in margin affects cash flow or valuation.

Adding Scenarios and Sensitivity to Forecasts

Here we have an example of simple income statement assumptions and how it can be impacted by sensitivity analysis.

In the example, we have created 3 scenarios for revenue and EBITDA growth for The Kroger Group. We have used a scenario button in the excel modelling and its been set up to assume that sales growth is 2.2% (as the previous year). There is an upside case where revenue is 1% higher, and a downside case where it is 1% below the base case.

Putting this in our model, we can choose ‘1’ to select the Base case, which will use the prescribed growth rate through the model (as shown in row 13). If we move to the Upside case by selecting ‘2’, we can see that the growth rate has increased in row 13.

The model has also added sensitivity analysis to the EBITDA margin assumptions as well. The Base case assumes a flat margin of 5.6% in the first projected year, and the Upside case uses 1% above this (and 1% below for the Downside case).

This example is simplistic in its assumptions, but it is an effective modelling tool. By creating three types of scenario analysis, investors can start to ‘layer’ assumptions about the future. Some may be more bullish about revenue growth but have concerns about rising costs. This allows the model to be tuned into the investor’s own viewpoint, invaluable in financial analysis.

Financial Forecasting Model Design Best Practices

Before you start typing formulas into excel, decide how the model will be laid out. A good design makes forecasting faster, clearer, and easier to audit.  There is nothing more infuriating than being sent an excel model and being unable to understand the logic behind it.

Where to Put Assumptions

There are two main approaches to creating an excel forecasting model:

• Local assumptions: this is when inputs are placed on the same sheet as the calculations they drive. This keeps everything in one place but can make it harder to see all assumptions briefly.

• Central assumptions sheet: all key inputs are stored on a dedicated assumptions tab, clearly grouped and labelled. Calculations on other tabs reference this central sheet.

This style puts all the assumptions for the balance sheet in a central place.

As a rule of thumb, for very simple models, keeping assumptions and calculations together can be acceptable. For anything more complex, a central assumptions sheet is usually easier to maintain.

Whichever approach you choose:

• Use a consistent color convention for input cells (e.g., blue ink for hardcoded inputs, black for formulas)
• Group assumptions logically (e.g., revenue, costs, capex, working capital, financing) so users know where to look

Positive or Negative Costs and Outflows (Sign Convention)

Analysts need a clear and consistent policy on whether costs and outflows are entered as positive or negative numbers in the workings. Here is an example below taken from figures downloaded from a company 10K. All the figures are displayed as positives, regardless of where there are inflows of outflow from the company.

Often companies themselves can present data in this way where a cost (e.g. Cost of Sales) is shown as a positive figure (e.g. $8,131m in 2025) along with other costs when actually they are an outgoing from the company. It is the responsibility of the analyst building the model to ensure that these are treated correctly in forecasting. Often Restructuring can be unclear if an outgoing or incoming amount, so it is important to check the details.

• One approach is to put costs and outflows as negative numbers in workings and present them as positive in the final outputs, matching how financial statements are usually displayed.
• Another is to keep everything as positive in workings and rely on formulas to determine whether items are added or subtracted.

Both can work. What matters is consistency and documentation, so that everyone reading or editing the model understands what the signs mean. State your convention on a cover sheet or in a legend. When building a model, it’s important to set up the formulas to reflect this. An early mistake when building models is taking the company information and extrapolating forward, which can lead to setting up some costs as positive figures and others as negative. When unsure about an item, always check the Notes to Financial Statements for full clarity.

One Tab vs. Multi-Tab Models

The layout of a financial model can also vary. Often this will depend on the level of detail required but also depends on the sector and the type of financial forecasting requires.

Forecasts can be built on:

• Single sheet models: all assumptions, calculations, and outputs on one single tab. These are quick to build and useful for small, one-off exercises.
• Multi-sheet models: separate tabs for assumptions, workings (sometimes by statement or schedule), and outputs. These can be better for recurring use, complex businesses, and collaborative work.

Often the format will be decided by the team you’re working on. However, the simple rule is small models are usually single sheet, and more complex models are multi-tab.

There are some styles of modelling that use the different formats regardless of the company and model size. For example, analysts might group:

• All short-term assets and liabilities on one working capital excel tab, regardless of whether they appear on the balance sheet as separate lines
• All fixed assets on a dedicated tangibles tab showing opening balance, additions (capex), disposals, and depreciation

The right level of granularity depends on materiality and purpose. Significant items (like long-term capex or key debt facilities) often justify their own schedules; smaller items can remain aggregated.

Financial Forecasting Best Practices and Common Mistakes

It’s always a good idea to follow best practices when building an excel model, an easy-to-follow model which is correct will be highly regarded by your peers and clients.

Best Practices

• Driver based modelling: where possible, link revenue, costs, and investment to operational drivers rather than pure ‘hard code’ percentages as this keeps the model flexible in case of new scenarios
• Clear separation of inputs and calculations: keep assumptions grouped together, use consistent colors, and avoid hardcoding numbers in formulas to avoid mistakes and keep the model readable
• Appropriate level of detail: build more granularity where it matters (e.g., working capital and cash in a leveraged transaction) and do less where it does not
• Documentation: briefly explain major assumptions and any unusual modelling choices so others can review and update the model efficiently

Common Mistakes to Avoid

Finding mistakes, particularly common ones, can be a frustration for those using your model. More than a couple of minor errors will lead others to disregard your hard work, so do always check a model once completed.

Here are some of the common pitfalls:

• Using straight-line revenue growth that ignores underlying drivers (e.g., such as a poor previous year’s sales figure or a fluctuating cost base)
• Forecasted margins or capital intensity that have no clear justification relative to history or peers
• Ignoring working capital, resulting in unrealistic cash flows
• Unbalanced statements caused by incomplete linkages between the income statement, balance sheet, and cash flow statement , always check your balance sheet balances, both for historic data and for the forecasts
• Be wary of ‘over-precision’ in inputs and outputs that implies more certainty than the business reality justifies

Reviewing and Sense Checking a Financial Forecast

A financial forecast is only useful if it is credible. Before relying on it, perform a structured review taking in some of the steps here to ensure the model is robust and working well:

Mechanical Checks

• Does the balance sheet balance in every forecast period?
• Does the cash flow statement reconcile opening and closing cash correctly?
• Are subtotals (such as EBITDA, EBIT, total assets, and total equity) calculated consistently over time?
• Are all the plus and minus signs working correctly in the forecasting?

Business and Market Checks

• Are revenue growth and margins reasonable compared to the company’s history and sector peers?
• Do capex and working capital assumptions support the growth story (e.g., is there sufficient investment to meet planned capacity needs)?
• Do leverage and interest coverage metrics stay within realistic and acceptable ranges?

Scenario and Risk Checks

• Does the downside scenario capture plausible adverse conditions (e.g., lower growth, higher costs, delayed payments)?
• Does the model highlight when additional funding would be required or covenants could be breached?
• Are the assumptions describing each scenario clearly documented?

A simple checklist like this makes it easier for managers, investors, and lenders to trust the forecast and to understand how it would behave under different conditions.

Instructor tip: always make an effort to check your model, it is time well spent. A good tip is to walk away from your desk for a few minutes and then go back to your model and look at it objectively and actively try and find mistakes in it. Start with the format and ensure it’s neat, then check the spellings of your headings and labels. Then slowly work through the formulas and take a break rather than plough through it for hours. Often numbers will look familiar as you’ve seen them on the screen, but the formula may be incorrect or often missing a really simple thing like a ‘+’ or ‘-’ sign.

Building a model isn’t easy, so stick with it until it’s in good shape. If you find an error and can’t fix it, make a best guess, move on and then come back to it later on. Just retrace the logic steps you used when creating it to make sure it is correct. A reliable well-made model is worth looking after.

 Conclusion

Once put together, a financial forecasting model is an invaluable tool for analysts looking closely at any company or potential financial deal. The key to a successful forecasting model lies in the attention to detail. Careful checks, smart formatting and intuitive forecasting will ensure the forecasting process is best in class.

Additional Resources

3-Statement Model

Modeling Assumptions

Financial Statement Analysis

Sensitivity Analysis