forecast of business plan

Everything that you need to know to start your own business. From business ideas to researching the competition.

Practical and real-world advice on how to run your business — from managing employees to keeping the books

Our best expert advice on how to grow your business — from attracting new customers to keeping existing customers happy and having the capital to do it.

Entrepreneurs and industry leaders share their best advice on how to take your company to the next level.

• Business Ideas
• Human Resources
• Business Financing
• Growth Studio
• Ask the Board

Looking for your local chamber?

Interested in partnering with us?

Run » finance, how to create a financial forecast for a startup business plan.

Financial forecasting allows you to measure the progress of your new business by benchmarking performance against anticipated sales and costs.

When starting a new business, a financial forecast is an important tool for recruiting investors as well as for budgeting for your first months of operating. A financial forecast is used to predict the cash flow necessary to operate the company day-to-day and cover financial liabilities.

Many lenders and investors ask for a financial forecast as part of a business plan; however, with no sales under your belt, it can be tricky to estimate how much money you will need to cover your expenses. Here’s how to begin creating a financial forecast for a new business.

[Read more: Startup 2021: Business Plan Financials ]

Start with a sales forecast

A sales forecast attempts to predict what your monthly sales will be for up to 18 months after launching your business. Creating a sales forecast without any past results is a little difficult. In this case, many entrepreneurs make their predictions using industry trends, market analysis demonstrating the population of potential customers and consumer trends. A sales forecast shows investors and lenders that you have a solid understanding of your target market and a clear vision of who will buy your product or service.

A sales forecast typically breaks down monthly sales by unit and price point. Beyond year two of being in business, the sales forecast can be shown quarterly, instead of monthly. Most financial lenders and investors like to see a three-year sales forecast as part of your startup business plan.

Lower fixed costs mean less risk, which might be theoretical in business schools but are very concrete when you have rent and payroll checks to sign.

Tim Berry, president and founder of Palo Alto Software

Create an expenses budget

An expenses budget forecasts how much you anticipate spending during the first years of operating. This includes both your overhead costs and operating expenses — any financial spending that you anticipate during the course of running your business.

Most experts recommend breaking down your expenses forecast by fixed and variable costs. Fixed costs are things such as rent and payroll, while variable costs change depending on demand and sales — advertising and promotional expenses, for instance. Breaking down costs into these two categories can help you better budget and improve your profitability.

"Lower fixed costs mean less risk, which might be theoretical in business schools but are very concrete when you have rent and payroll checks to sign," Tim Berry, president and founder of Palo Alto Software, told Inc . "Most of your variable costs are in those direct costs that belong in your sales forecast, but there are also some variable expenses, like ads and rebates and such."

Project your break-even point

Together, your expenses budget and sales forecast paints a picture of your profitability. Your break-even projection is the date at which you believe your business will become profitable — when more money is earned than spent. Very few businesses are profitable overnight or even in their first year. Most businesses take two to three years to be profitable, but others take far longer: Tesla , for instance, took 18 years to see its first full-year profit.

Lenders and investors will be interested in your break-even point as a projection of when they can begin to recoup their investment. Likewise, your CFO or operations manager can make better decisions after measuring the company’s results against its forecasts.

[Read more: ​​ Startup 2021: Writing a Business Plan? Here’s How to Do It, Step by Step ]

Develop a cash flow projection

A cash flow statement (or projection, for a new business) shows the flow of dollars moving in and out of the business. This is based on the sales forecast, your balance sheet and other assumptions you’ve used to create your expenses projection.

“If you are starting a new business and do not have these historical financial statements, you start by projecting a cash-flow statement broken down into 12 months,” wrote Inc . The cash flow statement will include projected cash flows from operating, investing and financing your business activities.

Keep in mind that most business plans involve developing specific financial documents: income statements, pro formas and a balance sheet, for instance. These documents may be required by investors or lenders; financial projections can help inform the development of those statements and guide your business as it grows.

CO— aims to bring you inspiration from leading respected experts. However, before making any business decision, you should consult a professional who can advise you based on your individual situation.

Follow us on Instagram for more expert tips & business owners’ stories.

CO—is committed to helping you start, run and grow your small business. Learn more about the benefits of small business membership in the U.S. Chamber of Commerce, here .

Subscribe to our newsletter, Midnight Oil

Expert business advice, news, and trends, delivered weekly

By signing up you agree to the CO— Privacy Policy. You can opt out anytime.

For more finance tips

5 inflation-beating deals your small business can offer, mobile credit card readers: choosing the best for your small businesses, mastering mobile payments: top credit card payment apps for entrepreneurs.

By continuing on our website, you agree to our use of cookies for statistical and personalisation purposes. Know More

Welcome to CO—

Designed for business owners, CO— is a site that connects like minds and delivers actionable insights for next-level growth.

U.S. Chamber of Commerce 1615 H Street, NW Washington, DC 20062

Social links

Looking for local chamber, stay in touch.

• Start free trial

Start selling with Shopify today

Start your free trial with Shopify today—then use these resources to guide you through every step of the process.

How To Create Financial Projections for Your Business Plan

Building a financial projection as you write out your business plan can help you forecast how much money your business will bring in.

Planning for the future, whether it’s with growth in mind or just staying the course, is central to being a business owner. Part of this planning effort is making financial projections of sales, expenses, and—if all goes well—profits.

Even if your business is a startup that has yet to open its doors, you can still make projections. Here’s how to prepare your business plan financial projections, so your company will thrive.

What are business plan financial projections?

Business plan financial projections are a company’s estimates, or forecasts, of its financial performance at some point in the future. For existing businesses, draw on historical data to detail how your company expects metrics like revenue, expenses, profit, and cash flow to change over time.

Companies can create financial projections for any span of time, but typically they’re for between one and five years. Many companies revisit and amend these projections at least annually. 

Creating financial projections is an important part of building a business plan . That’s because realistic estimates help company leaders set business goals, execute financial decisions, manage cash flow , identify areas for operational improvement, seek funding from investors, and more.

What are financial projections used for? 

Financial forecasting serves as a useful tool for key stakeholders, both within and outside of the business. They often are used for:

Business planning

Accurate financial projections can help a company establish growth targets and other goals . They’re also used to determine whether ideas like a new product line are financially feasible. Future financial estimates are helpful tools for business contingency planning, which involves considering the monetary impact of adverse events and worst-case scenarios. They also provide a benchmark: If revenue is falling short of projections, for example, the company may need changes to keep business operations on track.

Projections may reveal potential problems—say, unexpected operating expenses that exceed cash inflows. A negative cash flow projection may suggest the business needs to secure funding through outside investments or bank loans, increase sales, improve margins, or cut costs.

When potential investors consider putting their money into a venture, they want a return on that investment. Business projections are a key tool they will use to make that decision. The projections can figure in establishing the valuation of your business, equity stakes, plans for an exit, and more. Investors may also use your projections to ensure that the business is meeting goals and benchmarks.

Loans or lines of credit 

Lenders rely on financial projections to determine whether to extend a business loan to your company. They’ll want to see historical financial data like cash flow statements, your balance sheet , and other financial statements—but they’ll also look very closely at your multi-year financial projections. Good candidates can receive higher loan amounts with lower interest rates or more flexible payment plans.

Lenders may also use the estimated value of company assets to determine the collateral to secure the loan. Like investors, lenders typically refer to your projections over time to monitor progress and financial health.

What information is included in financial projections for a business?

Before sitting down to create projections, you’ll need to collect some data. Owners of an existing business can leverage three financial statements they likely already have: a balance sheet, an annual income statement , and a cash flow statement .

A new business, however, won’t have this historical data. So market research is crucial: Review competitors’ pricing strategies, scour research reports and market analysis , and scrutinize any other publicly available data that can help inform your projections. Beginning with conservative estimates and simple calculations can help you get started, and you can always add to the projections over time.

One business’s financial projections may be more detailed than another’s, but the forecasts typically rely on and include the following:

True to its name, a cash flow statement shows the money coming into and going out of the business over time: cash outflows and inflows. Cash flows fall into three main categories:

Income statement

Projected income statements, also known as projected profit and loss statements (P&Ls), forecast the company’s revenue and expenses for a given period.

Generally, this is a table with several line items for each category. Sales projections can include the sales forecast for each individual product or service (many companies break this down by month). Expenses are a similar setup: List your expected costs by category, including recurring expenses such as salaries and rent, as well as variable expenses for raw materials and transportation.

This exercise will also provide you with a net income projection, which is the difference between your revenue and expenses, including any taxes or interest payments. That number is a forecast of your profit or loss, hence why this document is often called a P&L.

Balance sheet

A balance sheet shows a snapshot of your company’s financial position at a specific point in time. Three important elements are included as balance sheet items:

• Assets. Assets are any tangible item of value that the company currently has on hand or will in the future, like cash, inventory, equipment, and accounts receivable. Intangible assets include copyrights, trademarks, patents and other intellectual property .
• Liabilities. Liabilities are anything that the company owes, including taxes, wages, accounts payable, dividends, and unearned revenue, such as customer payments for goods you haven’t yet delivered.
• Shareholder equity. The shareholder equity figure is derived by subtracting total liabilities from total assets. It reflects how much money, or capital, the company would have left over if the business paid all its liabilities at once or liquidated (this figure can be a negative number if liabilities exceed assets). Equity in business is the amount of capital that the owners and any other shareholders have tied up in the company.

They’re called balance sheets because assets always equal liabilities plus shareholder equity. 

5 steps for creating financial projections for your business

• Identify the purpose and timeframe for your projections
• Collect relevant historical financial data and market analysis
• Forecast expenses
• Forecast sales
• Build financial projections

The following five steps can help you break down the process of developing financial projections for your company:

1. Identify the purpose and timeframe for your projections

The details of your projections may vary depending on their purpose. Are they for internal planning, pitching investors, or monitoring performance over time? Setting the time frame—monthly, quarterly, annually, or multi-year—will also inform the rest of the steps.

2. Collect relevant historical financial data and market analysis

If available, gather historical financial statements, including balance sheets, cash flow statements, and annual income statements. New companies without this historical data may have to rely on market research, analyst reports, and industry benchmarks—all things that established companies also should use to support their assumptions.

3. Forecast expenses

Identify future spending based on direct costs of producing your goods and services ( cost of goods sold, or COGS) as well as operating expenses, including any recurring and one-time costs. Factor in expected changes in expenses, because this can evolve based on business growth, time in the market, and the launch of new products.

4. Forecast sales

Project sales for each revenue stream, broken down by month. These projections may be based on historical data or market research, and they should account for anticipated or likely changes in market demand and pricing.

5. Build financial projections

Now that you have projected expenses and revenue, you can plug that information into Shopify’s cash flow calculator and cash flow statement template . This information can also be used to forecast your income statement. In turn, these steps inform your calculations on the balance sheet, on which you’ll also account for any assets and liabilities .

Business plan financial projections FAQ

What are the main components of a financial projection in a business plan.

Generally speaking, most financial forecasts include projections for income, balance sheet, and cash flow.

What’s the difference between financial projection and financial forecast?

These two terms are often used interchangeably. Depending on the context, a financial forecast may refer to a more formal and detailed document—one that might include analysis and context for several financial metrics in a more complex financial model.

Do I need accounting or planning software for financial projections?

Not necessarily. Depending on factors like the age and size of your business, you may be able to prepare financial projections using a simple spreadsheet program. Large complicated businesses, however, usually use accounting software and other types of advanced data-management systems.

What are some limitations of financial projections?

Projections are by nature based on human assumptions and, of course, humans can’t truly predict the future—even with the aid of computers and software programs. Financial projections are, at best, estimates based on the information available at the time—not ironclad guarantees of future performance.

Keep up with the latest from Shopify

Get free ecommerce tips, inspiration, and resources delivered directly to your inbox.

By entering your email, you agree to receive marketing emails from Shopify.

popular posts

The point of sale for every sale.

Subscribe to our blog and get free ecommerce tips, inspiration, and resources delivered directly to your inbox.

Unsubscribe anytime. By entering your email, you agree to receive marketing emails from Shopify.

Latest from Shopify

Aug 8, 2024

Aug 7, 2024

Learn on the go. Try Shopify for free, and explore all the tools you need to start, run, and grow your business.

Try Shopify for free, no credit card required.

• Business Essentials
• Leadership & Management
• Credential of Leadership, Impact, and Management in Business (CLIMB)
• Entrepreneurship & Innovation
• Digital Transformation
• Finance & Accounting
• Business in Society
• For Organizations
• Support Portal
• Media Coverage
• Founding Donors
• Leadership Team

• Harvard Business School →
• HBS Online →
• Business Insights →

Business Insights

Harvard Business School Online's Business Insights Blog provides the career insights you need to achieve your goals and gain confidence in your business skills.

• Career Development
• Communication
• Decision-Making
• Earning Your MBA
• Negotiation
• News & Events
• Productivity
• Staff Spotlight
• Student Profiles
• Work-Life Balance
• AI Essentials for Business
• Alternative Investments
• Business Analytics
• Business Strategy
• Business and Climate Change
• Creating Brand Value
• Design Thinking and Innovation
• Digital Marketing Strategy
• Disruptive Strategy
• Economics for Managers
• Entrepreneurship Essentials
• Financial Accounting
• Global Business
• Launching Tech Ventures
• Leadership Principles
• Leadership, Ethics, and Corporate Accountability
• Leading Change and Organizational Renewal
• Leading with Finance
• Management Essentials
• Negotiation Mastery
• Organizational Leadership
• Power and Influence for Positive Impact
• Strategy Execution
• Sustainable Business Strategy
• Sustainable Investing
• Winning with Digital Platforms

7 Financial Forecasting Methods to Predict Business Performance

• 21 Jun 2022

Much of accounting involves evaluating past performance. Financial results demonstrate business success to both shareholders and the public. Planning and preparing for the future, however, is just as important.

Shareholders must be reassured that a business has been, and will continue to be, successful. This requires financial forecasting.

Here's an overview of how to use pro forma statements to conduct financial forecasting, along with seven methods you can leverage to predict a business's future performance.

Access your free e-book today.

What Is Financial Forecasting?

Financial forecasting is predicting a company’s financial future by examining historical performance data, such as revenue, cash flow, expenses, or sales. This involves guesswork and assumptions, as many unforeseen factors can influence business performance.

Financial forecasting is important because it informs business decision-making regarding hiring, budgeting, predicting revenue, and strategic planning . It also helps you maintain a forward-focused mindset.

Each financial forecast plays a major role in determining how much attention is given to individual expense items. For example, if you forecast high-level trends for general planning purposes, you can rely more on broad assumptions than specific details. However, if your forecast is concerned with a business’s future, such as a pending merger or acquisition, it's important to be thorough and detailed.

Forecasting with Pro Forma Statements

A common type of forecasting in financial accounting involves using pro forma statements . Pro forma statements focus on a business's future reports, which are highly dependent on assumptions made during preparation⁠, such as expected market conditions.

Because the term "pro forma" refers to projections or forecasts, pro forma statements apply to any financial document, including:

• Income statements
• Balance sheets
• Cash flow statements

These statements serve both internal and external purposes. Internally, you can use them for strategic planning. Identifying future revenues and expenses can greatly impact business decisions related to hiring and budgeting. Pro forma statements can also inform endeavors by creating multiple statements and interchanging variables to conduct side-by-side comparisons of potential outcomes.

Externally, pro forma statements can demonstrate the risk of investing in a business. While this is an effective form of forecasting, investors should know that pro forma statements don't typically comply with generally accepted accounting principles (GAAP) . This is because pro forma statements don't include one-time expenses—such as equipment purchases or company relocations—which allows for greater accuracy because those expenses don't reflect a company’s ongoing operations.

7 Financial Forecasting Methods

Pro forma statements are incredibly valuable when forecasting revenue, expenses, and sales. These findings are often further supported by one of seven financial forecasting methods that determine future income and growth rates.

There are two primary categories of forecasting: quantitative and qualitative.

Quantitative Methods

When producing accurate forecasts, business leaders typically turn to quantitative forecasts , or assumptions about the future based on historical data.

1. Percent of Sales

Internal pro forma statements are often created using percent of sales forecasting . This method calculates future metrics of financial line items as a percentage of sales. For example, the cost of goods sold is likely to increase proportionally with sales; therefore, it’s logical to apply the same growth rate estimate to each.

To forecast the percent of sales, examine the percentage of each account’s historical profits related to sales. To calculate this, divide each account by its sales, assuming the numbers will remain steady. For example, if the cost of goods sold has historically been 30 percent of sales, assume that trend will continue.

2. Straight Line

The straight-line method assumes a company's historical growth rate will remain constant. Forecasting future revenue involves multiplying a company’s previous year's revenue by its growth rate. For example, if the previous year's growth rate was 12 percent, straight-line forecasting assumes it'll continue to grow by 12 percent next year.

Although straight-line forecasting is an excellent starting point, it doesn't account for market fluctuations or supply chain issues.

3. Moving Average

Moving average involves taking the average—or weighted average—of previous periods⁠ to forecast the future. This method involves more closely examining a business’s high or low demands, so it’s often beneficial for short-term forecasting. For example, you can use it to forecast next month’s sales by averaging the previous quarter.

Moving average forecasting can help estimate several metrics. While it’s most commonly applied to future stock prices, it’s also used to estimate future revenue.

To calculate a moving average, use the following formula:

A1 + A2 + A3 … / N

Formula breakdown:

A = Average for a period

N = Total number of periods

Using weighted averages to emphasize recent periods can increase the accuracy of moving average forecasts.

4. Simple Linear Regression

Simple linear regression forecasts metrics based on a relationship between two variables⁠: dependent and independent. The dependent variable represents the forecasted amount, while the independent variable is the factor that influences the dependent variable.

The equation for simple linear regression is:

Y ⁠ = Dependent variable⁠ (the forecasted number)

B = Regression line's slope

X = Independent variable

A = Y-intercept

5. Multiple Linear Regression

If two or more variables directly impact a company's performance, business leaders might turn to multiple linear regression . This allows for a more accurate forecast, as it accounts for several variables that ultimately influence performance.

To forecast using multiple linear regression, a linear relationship must exist between the dependent and independent variables. Additionally, the independent variables can’t be so closely correlated that it’s impossible to tell which impacts the dependent variable.

Qualitative Methods

When it comes to forecasting, numbers don't always tell the whole story. There are additional factors that influence performance and can't be quantified. Qualitative forecasting relies on experts’ knowledge and experience to predict performance rather than historical numerical data.

These forecasting methods are often called into question, as they're more subjective than quantitative methods. Yet, they can provide valuable insight into forecasts and account for factors that can’t be predicted using historical data.

6. Delphi Method

The Delphi method of forecasting involves consulting experts who analyze market conditions to predict a company's performance.

A facilitator reaches out to those experts with questionnaires, requesting forecasts of business performance based on their experience and knowledge. The facilitator then compiles their analyses and sends them to other experts for comments. The goal is to continue circulating them until a consensus is reached.

7. Market Research

Market research is essential for organizational planning. It helps business leaders obtain a holistic market view based on competition, fluctuating conditions, and consumer patterns. It’s also critical for startups when historical data isn’t available. New businesses can benefit from financial forecasting because it’s essential for recruiting investors and budgeting during the first few months of operation.

When conducting market research, begin with a hypothesis and determine what methods are needed. Sending out consumer surveys is an excellent way to better understand consumer behavior when you don’t have numerical data to inform decisions.

Improve Your Forecasting Skills

Financial forecasting is never a guarantee, but it’s critical for decision-making. Regardless of your business’s industry or stage, it’s important to maintain a forward-thinking mindset—learning from past patterns is an excellent way to plan for the future.

If you’re interested in further exploring financial forecasting and its role in business, consider taking an online course, such as Financial Accounting , to discover how to use it alongside other financial tools to shape your business.

Do you want to take your financial accounting skills to the next level? Consider enrolling in Financial Accounting —one of three courses comprising our Credential of Readiness (CORe) program —to learn how to use financial principles to inform business decisions. Not sure which course is right for you? Download our free flowchart .

About the Author

• Business Planning

Business Plan Financial Projections

Written by Dave Lavinsky

Financial projections are forecasted analyses of your business’ future that include income statements, balance sheets and cash flow statements. We have found them to be an crucial part of your business plan for the following reasons:

• They can help prove or disprove the viability of your business idea. For example, if your initial projections show your company will never make a sizable profit, your venture might not be feasible. Or, in such a case, you might figure out ways to raise prices, enter new markets, or streamline operations to make it profitable. 
• Financial projections give investors and lenders an idea of how well your business is likely to do in the future. They can give lenders the confidence that you’ll be able to comfortably repay their loan with interest. And for equity investors, your projections can give them faith that you’ll earn them a solid return on investment. In both cases, your projections can help you secure the funding you need to launch or grow your business.
• Financial projections help you track your progress over time and ensure your business is on track to meet its goals. For example, if your financial projections show you should generate $500,000 in sales during the year, but you are not on track to accomplish that, you’ll know you need to take corrective action to achieve your goal.

Below you’ll learn more about the key components of financial projections and how to complete and include them in your business plan.

What Are Business Plan Financial Projections?

Financial projections are an estimate of your company’s future financial performance through financial forecasting. They are typically used by businesses to secure funding, but can also be useful for internal decision-making and planning purposes. There are three main financial statements that you will need to include in your business plan financial projections:

1. Income Statement Projection

The income statement projection is a forecast of your company’s future revenues and expenses. It should include line items for each type of income and expense, as well as a total at the end.

There are a few key items you will need to include in your projection:

• Revenue: Your revenue projection should break down your expected sales by product or service, as well as by month. It is important to be realistic in your projections, so make sure to account for any seasonal variations in your business.
• Expenses: Your expense projection should include a breakdown of your expected costs by category, such as marketing, salaries, and rent. Again, it is important to be realistic in your estimates.
• Net Income: The net income projection is the difference between your revenue and expenses. This number tells you how much profit your company is expected to make.

Sample Income Statement

2. Cash Flow Statement & Projection

The cash flow statement and projection are a forecast of your company’s future cash inflows and outflows. It is important to include a cash flow projection in your business plan, as it will give investors and lenders an idea of your company’s ability to generate cash.

There are a few key items you will need to include in your cash flow projection:

• The cash flow statement shows a breakdown of your expected cash inflows and outflows by month. It is important to be realistic in your projections, so make sure to account for any seasonal variations in your business.
• Cash inflows should include items such as sales revenue, interest income, and capital gains. Cash outflows should include items such as salaries, rent, and marketing expenses.
• It is important to track your company’s cash flow over time to ensure that it is healthy. A healthy cash flow is necessary for a successful business.

Sample Cash Flow Statements

3. Balance Sheet Projection

The balance sheet projection is a forecast of your company’s future financial position. It should include line items for each type of asset and liability, as well as a total at the end.

A projection should include a breakdown of your company’s assets and liabilities by category. It is important to be realistic in your projections, so make sure to account for any seasonal variations in your business.

It is important to track your company’s financial position over time to ensure that it is healthy. A healthy balance is necessary for a successful business.

Sample Balance Sheet

How to Create Financial Projections

Creating financial projections for your business plan can be a daunting task, but it’s important to put together accurate and realistic financial projections in order to give your business the best chance for success.  

Cost Assumptions

When you create financial projections, it is important to be realistic about the costs your business will incur, using historical financial data can help with this. You will need to make assumptions about the cost of goods sold, operational costs, and capital expenditures.

It is important to track your company’s expenses over time to ensure that it is staying within its budget. A healthy bottom line is necessary for a successful business.

Capital Expenditures, Funding, Tax, and Balance Sheet Items

You will also need to make assumptions about capital expenditures, funding, tax, and balance sheet items. These assumptions will help you to create a realistic financial picture of your business.

Capital Expenditures

When projecting your company’s capital expenditures, you will need to make a number of assumptions about the type of equipment or property your business will purchase. You will also need to estimate the cost of the purchase.

When projecting your company’s funding needs, you will need to make a number of assumptions about where the money will come from. This might include assumptions about bank loans, venture capital, or angel investors.

When projecting your company’s tax liability, you will need to make a number of assumptions about the tax rates that will apply to your business. You will also need to estimate the amount of taxes your company will owe.

Balance Sheet Items

When projecting your company’s balance, you will need to make a number of assumptions about the type and amount of debt your business will have. You will also need to estimate the value of your company’s assets and liabilities.

Financial Projection Scenarios

Write two financial scenarios when creating your financial projections, a best-case scenario, and a worst-case scenario. Use your list of assumptions to come up with realistic numbers for each scenario.

Presuming that you have already generated a list of assumptions, the creation of best and worst-case scenarios should be relatively simple. For each assumption, generate a high and low estimate. For example, if you are assuming that your company will have $100,000 in revenue, your high estimate might be $120,000 and your low estimate might be $80,000.

Once you have generated high and low estimates for all of your assumptions, you can create two scenarios: a best case scenario and a worst-case scenario. Simply plug the high estimates into your financial projections for the best-case scenario and the low estimates into your financial projections for the worst-case scenario.

Conduct a Ratio Analysis

A ratio analysis is a useful tool that can be used to evaluate a company’s financial health. Ratios can be used to compare a company’s performance to its industry average or to its own historical performance.

There are a number of different ratios that can be used in ratio analysis. Some of the more popular ones include the following:

• Gross margin ratio
• Operating margin ratio
• Return on assets (ROA)
• Return on equity (ROE)

To conduct a ratio analysis, you will need financial statements for your company and for its competitors. You will also need industry average ratios. These can be found in industry reports or on financial websites.

Once you have the necessary information, you can calculate the ratios for your company and compare them to the industry averages or to your own historical performance. If your company’s ratios are significantly different from the industry averages, it might be indicative of a problem.

Be Realistic

When creating your financial projections, it is important to be realistic. Your projections should be based on your list of assumptions and should reflect your best estimate of what your company’s future financial performance will be. This includes projected operating income, a projected income statement, and a profit and loss statement.

Your goal should be to create a realistic set of financial projections that can be used to guide your company’s future decision-making.

Sales Forecast

One of the most important aspects of your financial projections is your sales forecast. Your sales forecast should be based on your list of assumptions and should reflect your best estimate of what your company’s future sales will be.

Your sales forecast should be realistic and achievable. Do not try to “game” the system by creating an overly optimistic or pessimistic forecast. Your goal should be to create a realistic sales forecast that can be used to guide your company’s future decision-making.

Creating a sales forecast is not an exact science, but there are a number of methods that can be used to generate realistic estimates. Some common methods include market analysis, competitor analysis, and customer surveys.

Create Multi-Year Financial Projections

When creating financial projections, it is important to generate projections for multiple years. This will give you a better sense of how your company’s financial performance is likely to change over time.

It is also important to remember that your financial projections are just that: projections. They are based on a number of assumptions and are not guaranteed to be accurate. As such, you should review and update your projections on a regular basis to ensure that they remain relevant.

Creating financial projections is an important part of any business plan. However, it’s important to remember that these projections are just estimates. They are not guarantees of future success.

Business Plan Financial Projections FAQs

What is a business plan financial projection.

A business plan financial projection is a forecast of your company's future financial performance. It should include line items for each type of asset and liability, as well as a total at the end.

What are annual income statements? 

The Annual income statement is a financial document and a financial model that summarize a company's revenues and expenses over the course of a fiscal year. They provide a snapshot of a company's financial health and performance and can be used to track trends and make comparisons with other businesses.

What are the necessary financial statements?

The necessary financial statements for a business plan are an income statement, cash flow statement, and balance sheet.

How do I create financial projections?

You can create financial projections by making a list of assumptions, creating two scenarios (best case and worst case), conducting a ratio analysis, and being realistic.

• Contact sales

Start free trial

Business Forecasting: Why You Need It & How to Do It

Table of Contents

What is business forecasting, the importance of business forecasting, business forecasting process, business forecasting methods, elements of business forecasting, sources of data for forecasting, business forecasting only goes so far, how projectmanager helps business forecasting.

Well-run organizations don’t fly by the seat of their pants; they’re constantly working on business forecasting and business planning. Every decision and every process is based on data obtained from business forecasting, business intelligence tools, market research and scenario planning. Companies focus their energies on ways to predict market trends to help them set successful long-term strategies.

Some business forecasts are based on highly sophisticated statistical methods while others are based on experience and past data. Others simply follow a gut feeling. One thing remains constant: all industries rely on business forecasting.

Business forecasting refers to the process of predicting future market conditions by using business intelligence tools and forecasting methods to analyze historical data.

Business forecasting can be either qualitative or quantitative. Quantitative business forecasting relies on subject matter experts and market research while quantitative business forecasting focuses only on data analysis.

You can access historical data with project management tools such as ProjectManager , project management software that delivers real-time data for more insightful business forecasting. Our live dashboard requires no setup and automatically captures six project metrics which are displayed in easy-to-read graphs and charts. Get a high-level view of your project for better business planning. Get started with ProjectManager for free today.

Quantitative Forecasting

Quantitative forecasting is applicable when there is accurate past data available to predict the probability of future events. This method pulls patterns from the data that allow for more probable outcomes. The data used in quantitative forecasting can include in-house data such as sales numbers and professionally gathered data such as census statistics. Generally, quantitative forecasting seeks to connect different variables in order to establish cause and effect relationships that can be exploited to benefit the business.

Qualitative Forecasting

Qualitative forecasting is based on the opinion and judgment of consumers and experts. This business forecasting method is useful if you have insufficient historical data to make any statistically relevant conclusions. In such cases, an expert can help piece together the known bits of data you do have to try to make a qualitative prediction from that known information.

Qualitative business forecasting is also useful when little is known about the future in your industry. Relying on historical data is useless if that data is not relevant to the uncharted future you are approaching. This can be the case in innovative industries, or if there’s a new constraint entering the market that has never occurred before such as new tax law.

Business forecasting is critical for businesses whenever the future is uncertain or whenever an important strategic business decision is being made. The more the business can focus on the probable outcome, the more success the organization has as it moves forward.

Here are the steps that a business forecaster should typically follow:

• Define the question or problem you need to solve with your business forecasting efforts. For example, you might be interested in estimating whether your organization will be able to meet product demand for the next quarter.
• Identify the datasets and variables that need to be taken into consideration. In this case, datasets such as the sales records from the previous year and variables related to capacity, production and demand planning .
• Choose a business forecasting method that adjusts to your dataset and forecasting goals. That depends on whether your problem or question can be solved using a qualitative, quantitative or mixed approach.
• Based on the analysis of historical data, you can proceed to estimate future business performance. Keep in mind that the accuracy of your business forecasting depends on the quality of your data.
• Determine the discrepancy between your business forecast and actual business performance. Document your findings and improve your business forecasting process.

As stated above, there are two main types of business forecasting methods, qualitative and quantitative. We’ve compiled some of the more common forecasting models from both sides below.

Delphi Method

This qualitative business forecasting method consists in gathering a panel of subject matter experts and getting their opinions on the same topic in a manner in which they can’t know each other’s thoughts. This is done to prevent bias , which makes it possible for a manager to objectively compare their opinions and see if there are patterns, consensus or division.

Market Research

There are many market research techniques that evaluate the behavior of customers and their response to a certain product or service. Some of those market research methods collect and analyze quantitative data, such as digital marketing metrics and others qualitative data, such as product testing, or customer interviews.

Time Series Analysis

Also referred to as “trend analysis method,” this business forecasting technique simply requires the forecaster to analyze historical data to identify trends. This data analysis process requires statistical analysis as outliers need to be removed. More recent data should be given more weight to better reflect the current state of the business.

The Average Approach

The average approach says that the predictions of all future values are equal to the mean of the past data. Past data is required to use this method, so it can be considered a type of quantitative forecasting. This approach is often used when you need to predict unknown values as it allows you to make calculations based on past averages, where one assumes that the future will closely resemble the past.

The Naïve Approach

The naïve approach is the most cost-effective and is often used as a benchmark to compare against more sophisticated methods. It’s only used for time series data where forecasts are made equal to the last observed value. This approach is useful in industries and sectors where past patterns are unlikely to be reproduced in the future. In such cases, the most recent observed value may prove to be the most informative.

• Develop the Basis: Before you can start forecasting, you must develop a system to investigate the current economic situation around you. That includes your industry and its present position as well as its popular products to better estimate sales and general business operations.
• Estimating Future Business Operations: Now comes the estimation of future conditions, such as the course that future events are likely to take in your industry. Again, this is based on collected data to help with quantitative estimates for the scale of operations in the future.
• Regulating Forecasts: Whatever your forecast is, it must be compared to actual results. This is the only way to find deviations from the norm. Then the reasons for those deviations must be figured out, so action can be taken to correct those deviations in the future.
• Reviewing Forecasting Process: By reviewing the deviations between forecasts and actual performance data, improvements are made in the process, allowing you to refine and review the information for accuracy.

Your forecast will only be as good as the data you put into it. Before collecting data, ask yourself these questions:

• Why collect data?
• What kind of data?
• When to collect it?
• Where to collect it?
• Who will collect it?
• How will it be collected?

These are the questions that will shape your plan for the collection of data, a crucial facet of business forecasting. Once you have your plan, you can collect data from a variety of sources.

Primary Sources

Primary sources contain first-hand data, often collected with reporting tools . These are the ones that you or the person assigned this task to collect personally. If primary data is not available, you must go out and source it through interviews, questionnaires or observations.

Secondary Sources

Secondary sources contain published data or data that has been collected by others. This includes official reports from governments, publications, financial statements from banks or other financial institutions, annual reports of companies, journals, newspapers, magazines and other periodicals.

If business forecasting were a crystal ball, then everyone would be reaping the rewards of their foresight. While business forecasting is a tool to get a better view of what the future might have in store, there’s the argument that it’s wasting valuable time and resources on little return.

It’s true; you can follow the steps, use a variety of methodologies and still get it wrong. It is, after all, the future. There’s no way to ever manage all the variables that can impact future events. There are errors in calculations and the innate prejudices of the people managing the process, all of which add to the unpredictability of the results.

While you’re not going to have a clear, unobscured vision of the future by using business forecasting, it can provide you with insight into probable future trends to give your organization an advantage. Even a small step can be a great leap forward in the highly competitive world of business. By combining statistical and econometric models with experience, skill and objectivity, business forecasting is a formidable tool for any organization looking for a competitive advantage.

Clearly, business forecasting is a project unto itself. To manage a project and collect the data in a way that’s useful in the future, you need a project management tool that can help you plan your process and select the data that helps you decide on a way forward. 

ProjectManager is award-winning software that organizes projects with features that address every phase. The first thing in forecasting is choosing how you’ll take action and make a plan. For example, if you’re going to interview customers to see where the market is likely headed, you’ll need to schedule those interviews. Our online Gantt chart places those interviews as tasks on a timeline so you can get everyone interviewed before your deadline. 

Store All of Your Data in One Place

Those interviews will produce a lot of paperwork, and your data needs to be collected and stored somewhere easily accessible. You can attach notes to each task so the paperwork for each interviewee is saved with the notes that you took. You can also tag those tasks to make it easier to filter the project and locate the interview subjects for which you’re looking. If you’re worried that there’ll be too many documents and images attached to one task, don’t worry as we have unlimited file storage. 

ProjectManager can’t predict the future, but it does provide you with the tools you need to take advantage of business forecasting. Our project management software collects data in real-time, and stores past data, allowing you to filter information and pull up the metrics you need to make the right decision. Try it today with this free 30-day trial.

Deliver your projects on time and on budget

Start planning your projects.

• Search Search Please fill out this field.

What Is Business Forecasting?

• How It Works

Types of Business Forecasting

Criticisms of forecasting, the bottom line.

• Corporate Finance
• Financial Analysis

What Is Business Forecasting? Definition, Methods, and Model

courtneyk / Getty Images

Business forecasting involves making informed guesses about certain business metrics, regardless of whether they reflect the specifics of a business, such as sales growth, or predictions for the economy as a whole. Financial and operational decisions are made based on economic conditions and how the future looks, albeit uncertain.

Key Takeaways:

• Forecasting is valuable to businesses so that they can make informed business decisions.
• Financial forecasts are fundamentally informed guesses, and there are risks involved in relying on past data and methods that cannot include certain variables.
• Forecasting approaches include qualitative models and quantitative models.

Understanding Business Forecasting

Companies use forecasting to help them develop business strategies. Past data is collected and analyzed so that patterns can be found. Today, big data and artificial intelligence have transformed business forecasting methods. There are several different methods by which a business forecast is made. All the methods fall into one of two overarching approaches: qualitative and quantitative .

While there might be large variations on a practical level when it comes to business forecasting, on a conceptual level, most forecasts follow the same process:

• A problem or data point is chosen. This can be something like "will people buy a high-end coffee maker?" or "what will our sales be in March next year?"
• Theoretical variables and an ideal data set are chosen. This is where the forecaster identifies the relevant variables that need to be considered and decides how to collect the data.
• Assumption time. To cut down the time and data needed to make a forecast, the forecaster makes some explicit assumptions to simplify the process.
• A model is chosen. The forecaster picks the model that fits the dataset, selected variables, and assumptions.
• Analysis. Using the model, the data is analyzed, and a forecast is made from the analysis.
• Verification. The forecast is compared to what actually happens to identify problems, tweak some variables, or, in the rare case of an accurate forecast, pat themselves on the back.

Once the analysis has been verified, it must be condensed into an appropriate format to easily convey the results to stakeholders or decision-makers. Data visualization and presentation skills are helpful here.

There are two key types of models used in business forecasting—qualitative and quantitative models.

Qualitative Models

Qualitative models have typically been successful with short-term predictions, where the scope of the forecast was limited. Qualitative forecasts can be thought of as expert-driven, in that they depend on market mavens or the market as a whole to weigh in with an informed consensus.

Qualitative models can be useful in predicting the short-term success of companies, products, and services, but they have limitations due to their reliance on opinion over measurable data. Qualitative models include:

• Market research : Polling a large number of people on a specific product or service to predict how many people will buy or use it once launched.
• Delphi method : Asking field experts for general opinions and then compiling them into a forecast.

Quantitative Models

Quantitative models discount the expert factor and try to remove the human element from the analysis. These approaches are concerned solely with data and avoid the fickleness of the people underlying the numbers. These approaches also try to predict where variables such as sales, gross domestic product , housing prices, and so on, will be in the long term, measured in months or years. Quantitative models include:

• The indicator approach : The indicator approach depends on the relationship between certain indicators, for example, GDP and the unemployment rate remaining relatively unchanged over time. By following the relationships and then following leading indicators, you can estimate the performance of the lagging indicators by using the leading indicator data.
• Econometric modeling : This is a more mathematically rigorous version of the indicator approach. Instead of assuming that relationships stay the same, econometric modeling tests the internal consistency of datasets over time and the significance or strength of the relationship between datasets. Econometric modeling is applied to create custom indicators for a more targeted approach. However, econometric models are more often used in academic fields to evaluate economic policies.
• Time series methods : Time series use past data to predict future events. The difference between the time series methodologies lies in the fine details, for example, giving more recent data more weight or discounting certain outlier points. By tracking what happened in the past, the forecaster hopes to get at least a better-than-average view of the future. This is one of the most common types of business forecasting because it is inexpensive and no better or worse than other methods.

Forecasting can be dangerous. Forecasts become a focus for companies and governments mentally limiting their range of actions by presenting the short to long-term future as pre-determined. Moreover, forecasts can easily break down due to random elements that cannot be incorporated into a model, or they can be just plain wrong from the start.

However, business forecasting is vital for businesses because it allows them to plan production, financing, and other strategies. However, there are three problems with relying on forecasts:

• The data is always going to be old. Historical data is all we have to go on, and there is no guarantee that the conditions in the past will continue in the future.
• It is impossible to factor in unique or unexpected events or externalities . Assumptions are dangerous, such as the assumption that banks were properly screening borrowers prior to the subprime meltdown .  Black swan events have become more common as our reliance on forecasts has grown.
• Forecasts cannot integrate their own impact. By having forecasts, accurate or inaccurate, the actions of businesses are influenced by a factor that cannot be included as a variable. This is a conceptual knot. In a worst-case scenario, management becomes a slave to historical data and trends rather than worrying about what the business is doing now.

Negatives aside, business forecasting is here to stay. Appropriately used, forecasting allows businesses to plan ahead for their needs, raising their chances of staying competitive in the markets. That's one function of business forecasting that all investors can appreciate.

What Are the Main Steps of Forecasting?

Forecasting should (1) start with identifying the problem. It should then (2) gather all the information necessary to solve the problem. After gathering data, (3) a business should run a preliminary analysis, (4) choose an appropriate forecasting model, (5) and once the forecasting is complete, analyze the results.

Is Forecasting a Business Strategy?

Yes, forecasting is a business strategy. The strategy seeks to take historical data and apply it to current data to predict the future business environment. From there, a business will make decisions to adapt to this predicted environment to ensure success.

What Do Business Forecasting Models Answer?

Business forecasting models seek to answer a variety of questions for a business, such as demand for a product or service, the ability to compete in an environment, predicting future sales, and estimating growth and expansion.

Businesses use forecasting to help make decisions about the direction of the company. Forecasting aims to predict the future to a degree and by doing so can help companies allocate resources, and make decisions on capital allocation, staffing, advertising, and more. Without forecasting, a business operates in the dark and may not be able to adjust itself to the right path for earnings success.

Kesh, Someswar and Raja, M.K. "Development of a Qualitative Reasoning Model for Financial Forecasting."  Information Management & Computer Security, vol. 13, no. 2, 2005, pp. 167-179.

Infiniti Research. " Business Forecasting: The Challenges in Knowing the Unknown ."

• Terms of Service
• Editorial Policy
• Privacy Policy

Free Financial Projection and Forecasting Templates

By Andy Marker | January 3, 2024

• Share on Facebook
• Share on LinkedIn

Link copied

We’ve collected the top free financial projection and forecasting templates. These templates enable business owners, CFOs, accountants, and financial analysts to plan future growth, manage cash flow, attract investors, and make informed decisions.  On this page, you'll find many helpful, free, customizable financial projection and forecasting templates, including a  1 2-month financial projection template , a  startup financial projection template , a  3-year financial projection template , and a  small business financial forecast template , among others. You’ll also find details on the  elements in a financial projection template ,  types of financial projection and forecasting templates , and  related financial templates .

Simple Financial Projection Template

Download a Sample Simple Financial Projection Template for 

Excel | Google Sheets  

Download a Blank Simple Financial Projection Template for 

Excel | Google Sheets    

Small business owners and new entrepreneurs are the ideal users for this simple financial projection template. Just input your expected revenues and expenses. This template stands out due to its ease of use and focus on basic, straightforward financial planning, making it perfect for small-scale or early-stage businesses. Available with or without sample text, this tool offers clear financial oversight, better budget management, and informed decision-making regarding future business growth. 

Looking for help with your business plan? Check out these  free financial templates for a business plan to streamline the process of organizing your business's financial information and presenting it effectively to stakeholders.

Financial Forecast Template

Download a Sample Financial Forecast Template for 

Download a Blank Financial Forecast Template for 

This template is perfect for businesses that require a detailed and all-encompassing forecast. Users can input various financial data, such as projected revenues, costs, and market trends, to generate a complete financial outlook. Available with or without example text, this template gives you a deeper understanding of your business's financial trajectory, aiding in strategic decision-making and long-term financial stability. 

These  free cash-flow forecast templates help you predict your business’s future cash inflows and outflows, allowing you to manage liquidity and optimize financial planning.

12-Month Financial Projection Template

Download a Sample 12-Month Financial Projection Template for 

Download a Blank 12-Month Financial Projection Template for 

Use this 12-month financial projection template for better cash-flow management, more accurate budgeting, and enhanced readiness for short-term financial challenges and opportunities. Input estimated monthly revenues and expenses, tracking financial performance over the course of a year. Available with or without sample text, this template is ideal for business owners who need to focus on short-term financial planning. This tool allows you to respond quickly to market shifts and plan effectively for the business's crucial first year. 

Download  free sales forecasting templates to help your business predict future sales, enabling better inventory management, resource planning, and decision-making.

Startup Financial Projection Template

Download a Sample Startup Financial Projection Template for 

Download a Blank Startup Financial Projection Template for 

This dynamic startup financial projection template is ideal for startup founders and entrepreneurs, as it's designed specifically for the unique needs of startups. Available with or without example text, this template focuses on clearly outlining a startup's initial financial trajectory, an essential component for attracting investors. Users can input projected revenues, startup costs, and funding sources to create a comprehensive financial forecast.

3-Year Financial Projection Template

Download a Sample 3-Year Financial Projection Template for 

Download a Blank 3-Year Financial Projection Template for 

This three-year financial projection template is particularly useful for business strategists and financial planners who are looking for a medium-term financial planning tool. Input data such as projected revenues, expenses, and growth rates for the next three years. Available with or without sample text, this template lets you anticipate financial challenges and opportunities in the medium term, aiding in strategic decision-making and ensuring sustained business growth.

5-Year Financial Forecasting Template

Download a Sample 5-Year Financial Forecasting Template for 

Download a Blank 5-Year Financial Forecasting Template for 

CFOs and long-term business planners can use this five-year financial forecasting template to get a clear, long-range financial vision. Available with or without example text, this template allows you to plan strategically and invest wisely, preparing your business for future market developments and opportunities. This unique tool offers an extensive outlook for your business’s financial strategy. Simply input detailed financial data spanning five years, including revenue projections, investment plans, and expected market growth. Visually engaging bar charts of key metrics help turn data into engaging narratives.

Small Business Financial Forecast Template

Download a Sample Small Business Financial Forecast Template for 

Download a Blank Small Business Financial Forecast Template for 

Excel | Google Sheets 

The small business financial forecast template is tailored specifically for the scale and specific requirements of small enterprises. Business owners and financial managers can simply input data such as projected sales or expenses. Available with or without sample text, this tool offers the ability to do the following: envision straightforward financial planning; anticipate future financial needs and challenges; make informed decisions; and steer the business toward steady growth.

Elements in a Financial Projection Template

The elements in a financial projection template include future sales, costs, profits, and cash flow. This template illustrates expected receivables, payables, and break-even dates. This tool helps you plan for your business's financial future and growth.   

Here are the standard elements in a financial projection template:   

• Revenue Projection: This estimates future income from various sources over a specific period.
• Expense Forecast: This predicts future costs, including both fixed and variable expenses.
• Profit and Loss Forecast:  This projects the profit or loss by subtracting projected expenses from projected revenues.
• Cash-Flow Projection: This assesses the inflows and outflows of cash, indicating liquidity over time.
• Balance Sheet Projection: This predicts the future financial position, showing assets, liabilities, and equity.
• Break-Even Analysis: This calculates the point at which total revenues equal total costs.
• Capital Expenditure Forecast: This estimates future spending on fixed assets such as equipment or property.
• Debt Repayment Plan: This outlines the schedule for paying back any borrowed funds.
• Sales Forecast:  This predicts future sales volume, often broken down by product or service.
• Gross Margin Analysis:  This looks at the difference between revenue and cost of goods sold.

Types of Financial Projection and Forecasting Templates

There are many types of financial projection and forecasting templates: basic templates for small businesses; detailed ones for big companies; special ones for startup businesses; and others. There are also sales forecasts, cash-flow estimates, and profit and loss projections. 

In addition, financial projection and forecasting templates include long-term planning templates, break-even analyses, budget forecasts, and templates made for specific industries such as retail or manufacturing. 

Each template serves different financial planning needs. Determine which one best suits your requirements based on the scale of your business, the complexity of its financial structure, and the specific department that you want to analyze.

Here's a list of the top types of financial projection and forecasting templates:  

• Basic Financial Projection Template: Ideal for small businesses or startups, this template provides a straightforward approach to forecasting revenue, expenses, and cash flow.
• Detailed Financial Projection Template: Best for larger businesses or those with complex financial structures, this template offers in-depth projections, including balance sheets, income statements, and cash-flow statements.
• Startup Financial Projection Template: Tailored for startups, this template focuses on funding requirements and early-stage revenue forecasts, both crucial for attracting investors and planning initial operations. 
• Sales Forecasting Template:  Used by sales and marketing teams to predict future sales, this template helps you set targets and plan marketing strategies. 
• Cash-Flow Forecast Template: Essential for financial managers who need to monitor the liquidity of the business, this template projects cash inflows and outflows over a period. 
• Profit and Loss Forecast Template (P&L):  Useful for business owners and financial officers who need to anticipate profit margins, this template enables you to forecast revenues and expenses.  
• Three-Year / Five-Year Financial Projection Template: Suitable for long-term business planning, these templates provide a broader view of your company’s financial future, improving your development strategy and investor presentations. 
• Break-Even Analysis Template:  Used by business strategists and financial analysts, this template helps you determine when your business will become profitable. 
• Budget Forecasting Template:  Designed for budget managers, this template uses historical financial data to help you plan your future spending. 
• Sector-Specific Financial Projection Template:  Designed for specific industries (such as retail or manufacturing), these templates take into account industry-specific factors and benchmarks.

Related Financial Templates

Check out this list of free financial templates related to financial projections and forecasting. You'll find templates for budgeting, tracking profits and losses, planning your finances, and more. These tools help keep your company’s money matters organized and clear.

Free Project Budget Templates

Use one of these  project budget templates to maintain control over project finances, ensuring costs stay aligned with the allocated budget and improving overall financial management.

Free Monthly Budget Templates

Use one of these  monthly budget templates to effectively track and manage your business’s income and expenses, helping you plan financially and save money.

Free Expense Report Templates

Use one of these  expense report templates to systematically track and document all business-related expenditures, ensuring accurate reimbursement and efficient financial record-keeping.

Free Balance Sheet Templates

Use one of these  balance sheet templates to summarize your company's financial position at a given time.

Free Cash-Flow Forecast Templates

Use one of these  cash-flow forecast templates to predict future cash inflows and outflows, helping you manage liquidity and make informed financial decisions.

Free Cash-Flow Statement Templates

Use one of these  cash-flow statement templates to track the movement of cash in and out of your business, so you can assess your company’s level of liquidity and financial stability.

Free Discounted Cash-Flow (DCF) Templates

Use one of these  discounted cash-flow (DCF) templates to evaluate the profitability of investments or projects by calculating their present value based on future cash flows.

Free Financial Dashboard Templates

Use one of these  financial dashboard templates to get an at-a-glance view of key financial metrics, so you can make decisions quickly and manage finances effectively.

Related Customer Stories

Free financial planning templates.

Use one of these  financial planning templates to strategically organize and forecast future finances, helping you set realistic financial goals and ensure long-term business growth.

Free Profit and Loss (P&L) Templates

Use one of these  profit and loss (P&L) templates to systematically track income and expenses, giving you a clear picture of your company's profitability over a specific period.

Free Billing and Invoice Templates

Use one of these  billing and invoice templates to streamline the invoicing process and ensure that you bill clients accurately and professionally for services or products.

Plan and Manage Your Company’s Financial Future with Financial Projection and Forecasting Templates from Smartsheet

Empower your people to go above and beyond with a flexible platform designed to match the needs of your team — and adapt as those needs change. 

The Smartsheet platform makes it easy to plan, capture, manage, and report on work from anywhere, helping your team be more effective and get more done. Report on key metrics and get real-time visibility into work as it happens with roll-up reports, dashboards, and automated workflows built to keep your team connected and informed. 

When teams have clarity into the work getting done, there’s no telling how much more they can accomplish in the same amount of time.  Try Smartsheet for free, today.

Discover why over 90% of Fortune 100 companies trust Smartsheet to get work done.

Financial Forecasting: How to Do It with Different Methods, Models, & Software

Published: June 07, 2023

Planning for your company's future is significantly easier and more effective when you have a picture of what that future might look like. That's why any business interested in sound financial planning needs to have a grip on financial forecasting — the process of making accurate projections that can frame thoughtful, productive financial decisions in real time.

Here, we'll explore the concept of financial forecasting in depth, review some popular financial forecasting models, go over some prominent financial forecasting methods, and see some of the best financial forecasting software solutions on the market.

1. What is financial forecasting?

Forecasting vs. Budgeting

2. Financial Forecasting Models

• Top-Down Financial Forecasting
• Delphi Financial Forecasting
• Statistical Forecasting
• Bottom-Up Financial Forecasting

3. Financial Forecasting Methods

• Straight Line
• Simple Linear Regression
• Multiple Linear Regression
• Moving Average

4. How to do Financial Forecasting

5. Financial Forecasting Software

What is financial forecasting?

Financial forecasting is a process where a business leverages its current and past financial information to project its future financial performance. Forecasts are typically applied to assist with budgeting, financial modeling, and other key financial planning activities.

Financial forecasting is often conflated with the other key financial planning processes it generally informs — namely, budgeting. Though the two activities are often closely linked, it's important to differentiate between them.

The difference between a financial forecast and a budget boils down to the distinction between expectations and goals. A forecast details what a business can realistically expect to achieve over a given period.

When done correctly, it represents a reasonable estimate of how a company will likely perform — based on current and historical financial data, broader economic trends, foreseeable factors that might impact performance, and other variables that can be viably accounted for.

A budget, on the other hand, is the byproduct of a financial analysis rooted in what a business would like to  achieve. It's typically updated once per year and is ultimately compared to the actual results a business sees to gauge the company's overall performance.

Now that we have a picture of what financial forecasting is, let's take a look at some of its most popular models.

Financial Forecasting Models

1. top-down financial forecasting.

Top-down forecasting is a financial forecasting model where a company starts by analyzing broader market data and ultimately whittles down company-specific revenue projections from there.

It's one of the more simple, straightforward forecasting models — essentially amounting to a company looking at its total market size and calculating potential revenue based on its assumed market share with the help of fp&a software to collect all the data you need.

Top-Down Financial Forecasting Example

Let's say a company occupies space in a market that generates an estimated $1,000,000,000 in revenue annually. If the business assumes it will have a market share of 2.5%, a top-down forecast would suggest that it will see $25,000,000 in revenue in the coming year.

Benefits of Top-Down Forecasting

• It provides a more streamlined approach for larger, established businesses with diverse revenue sources than a concentrated, product-level forecast.
• It's often the only viable forecasting avenue for early-stage companies without extensive financial data.

Drawbacks of Top-Down Forecasting

• It's often seen as hastier and more superficial than more granular forecasting methods.
• A top-down forecast is generally seen more as a starting point than a concrete projection.

2. Delphi Forecasting

The term "Delphi" here is a reference to the ancient Greek city where the Greeks consulted the mythical oracle Pythia . Fittingly, the Delphi forecasting method involves financial forecasters consulting experts for their takes on projections.

With this method, a business sends multiple rounds of questionnaires to a panel of experts, covering the company's financial data. With each new round, the experts see an aggregated summary of the previous round and adjust their perspectives accordingly. Ultimately, the hope is that a few rounds can produce a consensus among the experts that can be applied to the company's financial projections.

Delphi Financial Forecasting Example

If a company were to leverage the Delphi model, it would gather a diverse array of experts and send them questionnaires without any of them ever meeting face-to-face. After one round, the experts would each receive a summary, detailing what the other experts thought with respect to the business's potential financial performance.

The experts would be at least partially moved by the group response and submit a new questionnaire accordingly. The panel would continue to receive questionnaires until it arrived at a consensus, and the forecast would be based on that insight.

Benefits of Delphi Forecasting

• It tends to be more objective than conventional, in-house forecasting.
• Contributions are anonymous, so respondents can answer candidly.

Drawbacks of Delphi Forecasting

• The method doesn't allow for a productive, open dialogue like a face-to-face meeting would.
• Response times can be long or unpredictable, prolonging forecast delivery.

3. Statistical Forecasting

Statistical forecasting is a broad term that accounts for a variety of forecasting methods. At its core, the model is exactly what it sounds like — forecasting based on statistics. More specifically, the term is essentially a catch-all that covers forecasting rooted in the use of statistics derived from historical, quantitative data.

Statistical Financial Forecasting Example

One method that generally falls under the statistical financial forecasting umbrella is the moving average method listed below. A company might look at the revenue it generated over the past 100 days and apply that statistic to its potential performance over the next similar period.

Benefits of Statistical Forecasting

• It rests on a more solid basis than other methods.
• It can be more straightforward than other methods — provided you have the right data.

Drawbacks of Statistical Forecasting

• Certain methods that fall under this umbrella can provide relatively hasty estimates, relative to other models.
• Companies without extensive historical data might not be able to produce reliable statistical forecasts.

4. Bottom-Up Financial Forecasting

As you can probably assume, bottom-up financial forecasting is essentially the opposite of top-down forecasting — it's a model where a company starts by referencing its detailed, ground-level customer or product information and works its way up to a broader revenue projection.

Bottom-Up Financial Forecasting Example

A bottom-up financial forecast could start with a business taking a look at its sales volume — or the total number of units of its product it moved in a given period — from the previous year. Then, it would estimate the price it expects to charge for that product in the coming year. From there, it would calculate its projected revenue by multiplying the two figures.

Obviously, that example is unrealistically straightforward. In most cases, the business in question here would consider other lower-level variables as well — potentially including customer-related information like total customers or retention rate.

Benefits of Bottom-Up Forecasting

• The model allows for more detailed analysis than most others.
• It offers more room for input from various departments.

Drawbacks of Bottom-Up Forecasting

• Any errors made at the micro-level can be amplified to the macro-level with this model.
• A thorough bottom-up forecast can be time-consuming and particularly labor-intensive.

Financial Forecasting Methods

1. Straight Line

True to its name, straight line forecasting is probably the most straightforward financial forecasting method businesses can leverage. It's rooted in basic math and tends to provide rougher projections than the other, more sophisticated methods listed here.

With straight line forecasting, a business gathers rough growth estimates — typically pulled from past figures — and applies them to coming months, quarters, or years. It's generally employed when a company assumes it will see steady growth over a given period.

For instance, if your business has seen revenue reliably grow 5% year over year for the past four years, you might use that figure to guide your straight line forecasting and assume that level of growth will continue for the next few years.

2. Simple Linear Regression

The simple linear regression is a common financial forecasting method where a business explores the relationship between two variables — one independent and one dependent. For instance, a company could use this method to forecast revenue by gauging how it might be impacted by shifts in GDP.

3. Multiple Linear Regression

Simple linear regression analysis often isn't enough to make accurate financial projections, as financial performance is rarely a function of a single factor. The nature of the multiple linear regression is covered by its name — instead of trying to predict how financial performance will play out in response to a single variable, the model considers two or more independent factors.

4. Moving Average

Moving average forecasting is a method most commonly used to identify the trend-direction of a stock, but businesses can still leverage it to project their financial performance. It involves taking the arithmetic mean of a dataset from a past period and applying that average to future projections. The method is typically used to evaluate potential performance over shorter periods — like weeks, months, or quarters.

How to do Financial Forecasting

1. Define your purpose for using a financial forecast.

To get the most out of a financial forecast, you have to know why you're using it in the first place. Ask yourself questions such as:

• What are you hoping to learn and take away from its results?
• Are you trying to get a better gauge of the company budget?
• Are you trying to reach a certain goal or threshold for product sales?

When you have clear intent behind your financial forecast, you'll have a more concise and clear result to search for once you begin.

2. Gather historical data.

To track the progress of your financial forecast, you have to have a good idea of your current and past finances. Take the time to analyze your historical financial data and records, including:

• Revenue and losses
• Equity and liabilities
• Fixed costs
• Investments
• Earnings per share

Your forecast will only be as accurate as the information you collect, so get as much relevant data as possible for better results and understanding.

3. Set a time frame for your forecast.

Decide how far into the future you're committed to recording and documenting your business' financial performance. This can look like weeks, months, quarters, or even years of data collection. 

It's most common for a business to conduct a forecast over the course of a fiscal year, but it's unique for every business. And if you need to adjust your forecast as time goes by, or if your goals change, you're ultimately in control and can make adjustments if need be.

4. Choose a forecasting method.

We've already give you four financial forecasting methods, so when choosing the one for your business, make sure it aligns with your previously declared purpose and goals.

5. Monitor and analyze your forecast results.

As your financial forecast delivers new data, you should monitor and analyze it differently. When you get enough data, try to think about how you can use it:

• Identify potential issues: Monitoring and analyzing financial results can help a business identify potential issues before they become more significant problems. For example, if expenses are higher than anticipated, a business can identify the cause and take corrective action to prevent it from negatively impacting financial performance.
• Measure progress towards goals: A financial forecast provides a business with financial goals and expectations. Weighing financial results against these goals enables a business to measure its progress toward achieving them. This can help the business identify where it is falling short and adjust to get back on track.
• Manage cash flow: Monitoring and analyzing financial results can give a business insights into its cash flow situation. By understanding how much cash is coming in and going out, a business can make smarter decisions about budgeting and spending.

And it doesn't have to be a tedious task to analyze your financial data, thankfully there's plenty of forecasting, decision-making and financial-planning tools available for this purpose. Let's go through some of our favorites.

Financial Forecasting Software

1. sage intacct, pricing: contact for pricing.

Sage Intacct is a multifaceted accounting and financial planning software with an accessible interface and a suite of features that can streamline your financial forecasting time by over 50%. The platform's automated forecasting resources effectively eliminate the stress, legwork, and room for error that often come with financial planning via spreadsheets.

Best for Collaboration

Sage Intacct separates itself from similar applications through its accessibility and room for collaboration. The software is particularly user-friendly and offers a singular, centralized solution for virtually any stakeholder within an organization to easily contribute to and make sense of financial projections.

2. PlanGuru

Pricing: plans starting at $99 per month.

PlanGuru is a dedicated financial forecasting software — supporting 20 separate forecasting methods that can cover projections of up to 10 years. The program also allows you to incorporate non-financial data into your forecasts and has scenario analysis features to help you interpret the ramifications of potentially impactful events. PlanGuru also offers a range of plans to suit most SMBs' budgets.

Best for Pure Financial Forecasting

Some of the other resources listed here are multifaceted accounting solutions that happen to cover financial forecasting — not PlanGuru. This application is primarily dedicated to creating financial projections.

As I mentioned, it offers 20 unique financial forecasting methods to support more effective strategic planning — along with a host of other features tailored to help you gauge your future financial performance. If you're interested in a cost-effective, forecasting-specific platform, look into PlanGuru.

3. Workday Adaptive Planning

Workday Adaptive Planning provides financial forecasting resources that reconcile accessibility with powerful functionality. The software lets you leverage both real-time financial and operational data to create and compare multiple accurate, effective what-if scenario models. It also allows you to forecast across any time horizon — whether it be daily, monthly, quarterly, or long-term.

Best for a Dynamic Range of Forecasting Options

Workday Adaptive Planning's ability to support detailed bottom-up and top-down forecasts makes it a particularly attractive option for businesses of virtually any size. It allows you to create compelling forecasts based on targets from executive guidance or ground-level operational plans.

That dynamic range of forecasting options helps set the program apart from similar options. If you're interested in software that lets you forecast from various perspectives without sacrificing accuracy or effectiveness, look into Workday Adaptive Planning.

4. Limelight

Limelight is an integrated, web-based financial planning that provides businesses with a centralized solution for almost all of their forecasting needs. Designed primarily to suit finance and accounting teams, the software offers powerful general automation and automated data integration to streamline and simplify forecasting without losing out on quality.

Best for a Familiar, Excel-Esque UX

Limelight's user experience is designed to reflect Excel — making it a familiar, particularly easy option for CFOs, controllers, budget managers, and other users to adapt to. If you're interested in a powerful forecasting resource with that kind of accessibility, Limelight might be your best option.

It's never too late to run a financial forecast.

Forecasting is a central component of sound, productive financial planning. If you have no idea what to expect financially, you'll have a hard time preparing for obstacles, setting attainable goals, and identifying aspects of your business that should be of particular interest. No matter the scale or nature of your organization, having a pulse on your financial future is always in your best interest.

Editor's note: This article was originally published in June 2022 and has been updated for comprehensiveness.

Don't forget to share this post!

Related articles.

Barriers to Entry: What’s Keeping Your Business From Entering the Market

The $113B Opportunity In Building Better Senior Living Communities

Entrepreneurship vs. Employment: The Pros & Cons That 200+ Owners & I Weighed [Data]

How to Build A Winning Hair Brand in 2024 [+ Hair Care Trends]

Cruel Summer: 4 Business Opportunities Inspired by The Extreme Heat

78 Stats to Know About Entrepreneurship in 2024

Navigating the Early Challenges of Entrepreneurship & How to Overcome Them

I Found 10 Best Etsy Alternatives to Sell Your Crafts

3 Business Opportunities in Imaging Boutiques & Health Concierges

The Business of Helping Gen Alpha Manage Their Millions

2 Essential Templates For Starting Your Business

Powerful and easy-to-use sales software that drives productivity, enables customer connection, and supports growing sales orgs

• Search Search Please fill out this field.
• Building Your Business

How To Create Financial Projections for Your Business

Learn how to anticipate your business’s financial performance

• Understanding Financial Projections & Forecasting

Why Forecasting Is Critical for Your Business

Key financial statements for forecasting, how to create your financial projections, frequently asked questions (faqs).

Maskot / Getty Images

Just like a weather forecast lets you know that wearing closed-toe shoes will be important for that afternoon downpour later, a good financial forecast allows you to better anticipate financial highs and lows for your business.

Neglecting to compile financial projections for your business may signal to investors that you’re unprepared for the future, which may cause you to lose out on funding opportunities.

Read on to learn more about financial projections, how to compile and use them in a business plan, and why they can be crucial for every business owner.

Key Takeaways

• Financial forecasting is a projection of your business's future revenues and expenses based on comparative data analysis, industry research, and more.
• Financial projections are a valuable tool for entrepreneurs as they offer insight into a business's ability to generate profit, increase cash flow, and repay debts, which can be attractive to investors.
• Some of the key components to include in a financial projection include a sales projection, break-even analysis, and pro forma balance sheet and income statement.
• A financial projection can not only attract investors, but helps business owners anticipate fixed costs, find a break-even point, and prepare for the unexpected.

Understanding Financial Projections and Forecasting

Financial forecasting is an educated estimate of future revenues and expenses that involves comparative analysis to get a snapshot of what could happen in your business’s future.

This process helps in making predictions about future business performance based on current financial information, industry trends, and economic conditions. Financial forecasting also helps businesses make decisions about investments, financing sources, inventory management, cost control strategies, and even whether to move into another market.

Developing both short- and mid-term projections is usually necessary to help you determine immediate production and personnel needs as well as future resource requirements for raw materials, equipment, and machinery.

Financial projections are a valuable tool for entrepreneurs as they offer insight into a business's ability to generate profit, increase cash flow, and repay debts. They can also be used to make informed decisions about the business’s plans. Creating an accurate, adaptive financial projection for your business offers many benefits, including:

• Attracting investors and convincing them to fund your business
• Anticipating problems before they arise
• Visualizing your small-business objectives and budgets
• Demonstrating how you will repay small-business loans
• Planning for more significant business expenses
• Showing business growth potential
• Helping with proper pricing and production planning

Financial forecasting is essentially predicting the revenue and expenses for a business venture. Whether your business is new or established, forecasting can play a vital role in helping you plan for the future and budget your funds.

Creating financial projections may be a necessary exercise for many businesses, particularly those that do not have sufficient cash flow or need to rely on customer credit to maintain operations. Compiling financial information, knowing your market, and understanding what your potential investors are looking for can enable you to make intelligent decisions about your assets and resources.

The income statement, balance sheet, and statement of cash flow are three key financial reports needed for forecasting that can also provide analysts with crucial information about a business's financial health. Here is a closer look at each.

Income Statement

An income statement, also known as a profit and loss statement or P&L, is a financial document that provides an overview of an organization's revenues, expenses, and net income.

Balance Sheet

The balance sheet is a snapshot of the business's assets and liabilities at a certain point in time. Sometimes referred to as the “financial portrait” of a business, the balance sheet provides an overview of how much money the business has, what it owes, and its net worth.

The assets side of the balance sheet includes what the business owns as well as future ownership items. The other side of the sheet includes liabilities and equity, which represent what it owes or what others owe to the business.

A balance sheet that shows hypothetical calculations and future financial projections is also referred to as a “pro forma” balance sheet.

Cash Flow Statement

A cash flow statement monitors the business’s inflows and outflows—both cash and non-cash. Cash flow is the business’s projected earnings before interest, taxes, depreciation, and amortization ( EBITDA ) minus capital investments.

Here's how to compile your financial projections and fit the results into the three above statements.

A financial projections spreadsheet for your business should include these metrics and figures:

• Sales forecast
• Balance sheet
• Operating expenses
• Payroll expenses (if applicable)
• Amortization and depreciation
• Cash flow statement
• Income statement
• Cost of goods sold (COGS)
• Break-even analysis

Here are key steps to account for creating your financial projections.

Projecting Sales

The first step for a financial forecast starts with projecting your business’s sales, which are typically derived from past revenue as well as industry research. These projections allow businesses to understand what their risks are and how much they will need in terms of staffing, resources, and funding.

Sales forecasts also enable businesses to decide on important levels such as product variety, price points, and inventory capacity.

Income Statement Calculations

A projected income statement shows how much you expect in revenue and profit—as well as your estimated expenses and losses—over a specific time in the future. Like a standard income statement, elements on a projection include revenue, COGS, and expenses that you’ll calculate to determine figures such as the business’s gross profit margin and net income.

If you’re developing a hypothetical, or pro forma, income statement, you can use historical data from previous years’ income statements. You can also do a comparative analysis of two different income statement periods to come up with your figures.

Anticipate Fixed Costs

Fixed business costs are expenses that do not change based on the number of products sold. The best way to anticipate fixed business costs is to research your industry and prepare a budget using actual numbers from competitors in the industry. Anticipating fixed costs ensures your business doesn’t overpay for its needs and balances out its variable costs. A few examples of fixed business costs include:

• Rent or mortgage payments
• Operating expenses (also called selling, general and administrative expenses or SG&A)
• Utility bills
• Insurance premiums

Unfortunately, it might not be possible to predict accurately how much your fixed costs will change in a year due to variables such as inflation, property, and interest rates. It’s best to slightly overestimate fixed costs just in case you need to account for these potential fluctuations.

Find Your Break-Even Point

The break-even point (BEP) is the number at which a business has the same expenses as its revenue. In other words, it occurs when your operations generate enough revenue to cover all of your business’s costs and expenses. The BEP will differ depending on the type of business, market conditions, and other factors.

To find this number, you need to determine two things: your fixed costs and variable costs. Once you have these figures, you can find your BEP using this formula:

Break-even point = fixed expenses ➗ 1 – (variable expenses ➗ sales)

The BEP is an essential consideration for any projection because it is the point at which total revenue from a project equals total cost. This makes it the point of either profit or loss.

Plan for the Unexpected

It is necessary to have the proper financial safeguards in place to prepare for any unanticipated costs. A sudden vehicle repair, a leaky roof, or broken equipment can quickly derail your budget if you aren't prepared. Cash management is a financial management plan that ensures a business has enough cash on hand to maintain operations and meet short-term obligations.

To maintain cash reserves, you can apply for overdraft protection or an overdraft line of credit. Overdraft protection can be set up by a bank or credit card business and provides short-term loans if the account balance falls below zero. On the other hand, a line of credit is an agreement with a lending institution in which they provide you with an unsecured loan at any time until your balance reaches zero again.

How do you make financial projections for startups?

Financial projections for startups can be hard to complete. Historical financial data may not be available. Find someone with financial projections experience to give insight on risks and outcomes.

Consider business forecasting, too, which incorporates assumptions about the exponential growth of your business.

Startups can also benefit from using EBITDA to get a better look at potential cash flow.

What are the benefits associated with forecasting business finances?

Forecasting can be beneficial for businesses in many ways, including:

• Providing better understanding of your business cash flow
• Easing the process of planning and budgeting for the future based on income
• Improving decision-making
• Providing valuable insight into what's in their future
• Making decisions on how to best allocate resources for success

How many years should your financial forecast be?

Your financial forecast should either be projected over a specific time period or projected into perpetuity. There are various methods for determining how long a financial forecasting projection should go out, but many businesses use one to five years as a standard timeframe.

U.S. Small Business Administration. " Market Research and Competitive Analysis ."

Score. " Financial Projections Template ."

• Creative & Design
• See all teams

For industries

• Manufacturing
• Professional Services
• Consumer Goods
• Financial Services
• See all industries
• Resource Management
• Project Management
• Workflow Management
• Task Management
• See all use cases

Explore Wrike

• Book a Demo
• Take a Product Tour
• ROI Calculator
• Customer Stories
• Start with Templates
• Gantt Charts
• Custom Item Types
• Project Resource Planning
• Project Views
• Kanban Boards
• Dynamic Request Forms
• Cross-Tagging
• See all features
• Integrations
• Mobile & Desktop Apps
• Resource Hub
• Educational Guides

Upskill and Connect

• Training & Certifications
• Help Center
• Wrike's Community
• Premium Support Packages
• Wrike Professional Services

What Is Business Forecasting? Why It Matters

April 25, 2021 - 10 min read

Companies conduct business forecasts to determine their goals, targets, and project plans for each new period, whether quarterly, annually, or even 2–5 year planning.

Forecasting helps managers guide strategy and make informed decisions about critical business operations such as sales, expenses, revenue, and resource allocation . When done right, forecasting adds a competitive advantage and can be the difference between successful and unsuccessful companies.

In this guide to business forecasting, we'll cover: 

• What is business forecasting?
• What are the best forecasting techniques?
• Why forecasting in management is important
• How to conduct business forecasts
• A few forecasting examples for businesses

An introduction to business forecasting

What is business forecasting? Business forecasting is a projection of future developments of a business or industry based on trends and patterns of past and present data. 

This business practice helps determine how to allocate resources and plan strategically for upcoming projects, activities, and costs. Forecasting enables organizations to manage resources , align their goals with present trends, and increase their chances of surviving and staying competitive. 

The purpose of forecasts is to develop better strategies and project plans using available, relevant data from the past and present to secure your business's future . Good business forecasting allows organizations to gain unique, proprietary insights into likely future events, leverage their resources, set product team OKR , and become market leaders.

Managers conduct careful and detailed business forecasts to guarantee sound decision-making based on data and logic, not emotions or gut feelings.  

What are important business forecasting methods?

There are several business forecasting methods. They fall into two main approaches: 

• Quantitative forecasting

Qualitative forecasting

Quantitative and qualitative forecasting techniques use and provide different sets of data and are needed at different stages of a product's life cycle.

Note that significant changes in a company, such as new product focus, new competitors or competitive strategies, or changing compliance requirements diminish the connection between past and future trends. This makes choosing the right forecasting method even more important.

Quantitative business forecasting

Use quantitative forecasting when there is accurate past data available to analyze patterns and predict the probability of future events in your business or industry. 

Quantitative forecasting extracts trends from existing data to determine the more probable results. It connects and analyzes different variables to establish cause and effect between events, elements, and outcomes. An example of data used in quantitative forecasting is past sales numbers.

Quantitative models work with data, numbers, and formulas. There is little human interference in quantitative analysis. Examples of quantitative models in business forecasting include:

• The indicator approach : This approach depends on the relationship between specific indicators being stable over time, e.g., GDP and the unemployment rate. By following the relationship between these two factors, forecasters can estimate a business's performance. 
• The average approach : This approach infers that the predictions of future values are equal to the average of the past data. It is best to use this approach only when assuming that the future will resemble the past.
• Econometric modeling : Econometric modeling is a mathematically rigorous approach to forecasting. Forecasters assume the relationships between indicators stay the same and test the consistency and strength of the relationship between datasets.
• Time-series methods : Time-series methods use historical data to predict future outcomes. By tracking what happened in the past, forecasters expect to get a near-accurate view of the future.

Qualitative business forecasting is predictions and projections based on experts' and customers' opinions. This method is best when there is insufficient past data to analyze to reach a quantitative forecast. In these cases, industry experts and forecasters piece together available data to make qualitative predictions.

Qualitative models are most successful with short-term projections. They are expert-driven, bringing up contrasting opinions and reliance on judgment over calculable data. Examples of qualitative models in business forecasting include:

• Market research : This involves polling people – experts, customers, employees – to get their preferences, opinions, and feedback on a product or service.
• Delphi method : The Delphi method relies on asking a panel of experts for their opinions and recommendations and compiling them into a forecast.

How do you choose the right business forecasting technique?

• Choosing the right business forecasting technique depends on many factors. Some of these are:
• Context of the forecast
• Availability and relevance of past data
• Degree of accuracy required
• Allocated time to conduct the forecast
• Period to be forecast 
• Costs and benefits of the forecast
• Stage of the product or business needing the forecast

Managers and forecasters must consider the stage of the product or business as this influences the availability of data and how you establish relationships between variables. A new startup with no previous revenue data would be unable to use quantitative methods in its forecast.

The more you understand the use, capabilities, and impact of different forecasting techniques, the more likely you will succeed in business forecasting. 

Why is business forecasting important?

Any insight into the future puts your organization at an advantage. Forecasting helps you predict potential issues, make better decisions, and measure the impact of those decisions. 

By combining quantitative and qualitative techniques, statistical and econometric models , and objectivity, forecasting becomes a formidable tool for your company. 

Business forecasting helps managers develop the best strategies for current and future trends and events. Today, artificial intelligence, forecasting software, and big data make business forecasting easier, more accurate, and personalized to each organization.

Forecasting does not promise an accurate picture of the future or how your business will evolve, but it points in a direction informed by data, logic, and experiential reasoning. 

What are the integral elements of business forecasting?

While there are different forecasting techniques and methods, all forecasts follow the same process on a conceptual level. Standard elements of business forecasting include:

• Prepare the stage : Before you begin, develop a system to investigate the current state of business.
• Choose a data point : An example for any business could be "What is our sales projection for next quarter?"
• Choose indicators and data sets : Identify the relevant indicators and data sets you need and decide how to collect the data.
• Make initial assumptions : To kickstart the forecasting process, forecasters may make some assumptions to measure against variables and indicators.
• Select forecasting technique : Pick the technique that fits your forecast best.
• Analyze data : Analyze available data using your selected forecasting technique.
• Estimate forecasts : Estimate future conditions based on data you've gathered to reach data-backed estimates. 
• Verify forecasts : Compare your forecast to the eventual results. This helps you identify any problems, tweak errant variables, correct deviations, and continue to improve your forecasting technique.
• Review forecasting process : Review any deviations between your forecasts and actual performance data.

How do you do business forecasting?

Successful business forecasting begins with a collaboration between the manager and forecaster. They work together to answer the following questions:

• What is the purpose of the forecast? How will it be used? 
• What are the components and dynamics of the system the forecast is focused on? 
• How relevant is past data in estimating the future? 

Once these answers are clear, choose the best forecasting methods based on the stage of the product or business life cycle, availability of past data, and skills of the forecasters and managers leading the project.

With the right forecasting method, you can develop your process using the integral elements of business forecasting mentioned above. 

How do you get data for business forecasting?

A forecast is only as good as the data supplied. Before collecting data, ask:

• Why do you need it?
• What kind of data do you need?
• When will you collect it?
• Where will you gather it?
• Who is in charge of collecting it?
• How will you collect it?
• How will you analyze it?

When you have these answers, you can start collecting data from two main sources:

• Primary sources : These sources are gathered first-hand using reporting tools — you or members of your team source data through interviews, surveys, research, or observations.
• Secondary sources : Secondary sources are second-hand information or data that others have collected. Examples include government reports, publications, financial statements, competitors' annual reports, journals, and other periodicals.

Business forecasting examples

Some forecasting examples for business include: 

• Calculating cash flow forecasts, i.e., predicting your financial needs within a timeframe
• Estimating the threat of new entrants into your market
• Measuring the opportunity of developing a new product or service
• Estimating the costs of recurring bills
• Predicting future sales growth based on past sales performance
• Analyzing relationships between variables, e.g., Facebook ads and potential revenue
• Budgeting contingencies and efficient allocation of resources
• Comparing customer acquisition costs and customer lifetime value over time

What are the limits of business forecasting?

You can follow the rules, use the right methods, and still get your business forecast wrong. It is, after all, an attempt to predict the future. Some limits to business forecasting include:

• Biases and errors by the forecasters or managers 
• Incorrect information from employees, experts, or customers 
• Inaccurate past numbers 
• Sudden change in market conditions
• New industry regulations

How Wrike helps with business forecasting

The more accurate your business forecasting, the more effective your strategies and plans can be. While many things in business are out of your control, having an informed forecast of what lies ahead makes you prepared and confident about the future.

Wrike helps gather data in one central platform, extract insights, and communicate findings with forecasters and managers. Other benefits of Wrike include real-time data, integrations with other forecasting software, streamlined collaboration, and visibility into every business forecasting project. 

Are you ready to make projections for your business, allocate your resources for the best results, and improve your business forecasting process? Get started with a two-week free trial of Wrike today.

Kelechi Udoagwu

Kelechi is a freelance writer and founder of Week of Saturdays, a platform for digital freelancers and remote workers living in Africa.

Related articles

Strengthen and Optimize Agency Resource Management

Improve your agency’s resource management processes and learn how Wrike boosts performance across the board with our robust project management software.

Release Management: Definition, Phases, and Benefits

What is release management and how can it improve software development strategy? In this guide, we talk about release management processes and their benefits.

The Definitive Guide to Data-Driven Marketing

Wondering what data-driven marketing is and how to reap its benefits for your business? Find out how to create your own data-driven strategy with our guide.

Get weekly updates in your inbox!

You are now subscribed to wrike news and updates.

Let us know what marketing emails you are interested in by updating your email preferences here .

Sorry, this content is unavailable due to your privacy settings. To view this content, click the “Cookie Preferences” button and accept Advertising Cookies there.

• Newsletters
• Best Industries
• Business Plans
• Home-Based Business
• The UPS Store
• Customer Service
• Black in Business
• Your Next Move
• Female Founders
• Best Workplaces
• Company Culture
• Public Speaking
• HR/Benefits
• Productivity
• All the Hats
• Digital Transformation
• Artificial Intelligence
• Bringing Innovation to Market
• Cloud Computing
• Social Media
• Data Detectives
• Exit Interview
• Bootstrapping
• Crowdfunding
• Venture Capital
• Business Models
• Personal Finance
• Founder-Friendly Investors
• Upcoming Events
• Inc. 5000 Vision Conference
• Become a Sponsor
• Cox Business
• Verizon Business
• Branded Content
• Apply Inc. 5000 US

Inc. Premium

How to Write the Financial Section of a Business Plan

An outline of your company's growth strategy is essential to a business plan, but it just isn't complete without the numbers to back it up. here's some advice on how to include things like a sales forecast, expense budget, and cash-flow statement..

A business plan is all conceptual until you start filling in the numbers and terms. The sections about your marketing plan and strategy are interesting to read, but they don't mean a thing if you can't justify your business with good figures on the bottom line. You do this in a distinct section of your business plan for financial forecasts and statements. The financial section of a business plan is one of the most essential components of the plan, as you will need it if you have any hope of winning over investors or obtaining a bank loan. Even if you don't need financing, you should compile a financial forecast in order to simply be successful in steering your business. "This is what will tell you whether the business will be viable or whether you are wasting your time and/or money," says Linda Pinson, author of Automate Your Business Plan for Windows  (Out of Your Mind 2008) and Anatomy of a Business Plan (Out of Your Mind 2008), who runs a publishing and software business Out of Your Mind and Into the Marketplace . "In many instances, it will tell you that you should not be going into this business." The following will cover what the financial section of a business plan is, what it should include, and how you should use it to not only win financing but to better manage your business.

Dig Deeper: Generating an Accurate Sales Forecast

Editor's Note: Looking for Business Loans for your company? If you would like information to help you choose the one that's right for you, use the questionnaire below to have our partner, BuyerZone, provide you with information for free:

How to Write the Financial Section of a Business Plan: The Purpose of the Financial Section Let's start by explaining what the financial section of a business plan is not. Realize that the financial section is not the same as accounting. Many people get confused about this because the financial projections that you include--profit and loss, balance sheet, and cash flow--look similar to accounting statements your business generates. But accounting looks back in time, starting today and taking a historical view. Business planning or forecasting is a forward-looking view, starting today and going into the future. "You don't do financials in a business plan the same way you calculate the details in your accounting reports," says Tim Berry, president and founder of Palo Alto Software, who blogs at Bplans.com and is writing a book, The Plan-As-You-Go Business Plan. "It's not tax reporting. It's an elaborate educated guess." What this means, says Berry, is that you summarize and aggregate more than you might with accounting, which deals more in detail. "You don't have to imagine all future asset purchases with hypothetical dates and hypothetical depreciation schedules to estimate future depreciation," he says. "You can just guess based on past results. And you don't spend a lot of time on minute details in a financial forecast that depends on an educated guess for sales." The purpose of the financial section of a business plan is two-fold. You're going to need it if you are seeking investment from venture capitalists, angel investors, or even smart family members. They are going to want to see numbers that say your business will grow--and quickly--and that there is an exit strategy for them on the horizon, during which they can make a profit. Any bank or lender will also ask to see these numbers as well to make sure you can repay your loan. But the most important reason to compile this financial forecast is for your own benefit, so you understand how you project your business will do. "This is an ongoing, living document. It should be a guide to running your business," Pinson says. "And at any particular time you feel you need funding or financing, then you are prepared to go with your documents." If there is a rule of thumb when filling in the numbers in the financial section of your business plan, it's this: Be realistic. "There is a tremendous problem with the hockey-stick forecast" that projects growth as steady until it shoots up like the end of a hockey stick, Berry says. "They really aren't credible." Berry, who acts as an angel investor with the Willamette Angel Conference, says that while a startling growth trajectory is something that would-be investors would love to see, it's most often not a believable growth forecast. "Everyone wants to get involved in the next Google or Twitter, but every plan seems to have this hockey stick forecast," he says. "Sales are going along flat, but six months from now there is a huge turn and everything gets amazing, assuming they get the investors' money."  The way you come up a credible financial section for your business plan is to demonstrate that it's realistic. One way, Berry says, is to break the figures into components, by sales channel or target market segment, and provide realistic estimates for sales and revenue. "It's not exactly data, because you're still guessing the future. But if you break the guess into component guesses and look at each one individually, it somehow feels better," Berry says. "Nobody wins by overly optimistic or overly pessimistic forecasts."

Dig Deeper: What Angel Investors Look For

How to Write the Financial Section of a Business Plan: The Components of a Financial Section

A financial forecast isn't necessarily compiled in sequence. And you most likely won't present it in the final document in the same sequence you compile the figures and documents. Berry says that it's typical to start in one place and jump back and forth. For example, what you see in the cash-flow plan might mean going back to change estimates for sales and expenses.  Still, he says that it's easier to explain in sequence, as long as you understand that you don't start at step one and go to step six without looking back--a lot--in between.

• Start with a sales forecast. Set up a spreadsheet projecting your sales over the course of three years. Set up different sections for different lines of sales and columns for every month for the first year and either on a monthly or quarterly basis for the second and third years. "Ideally you want to project in spreadsheet blocks that include one block for unit sales, one block for pricing, a third block that multiplies units times price to calculate sales, a fourth block that has unit costs, and a fifth that multiplies units times unit cost to calculate cost of sales (also called COGS or direct costs)," Berry says. "Why do you want cost of sales in a sales forecast? Because you want to calculate gross margin. Gross margin is sales less cost of sales, and it's a useful number for comparing with different standard industry ratios." If it's a new product or a new line of business, you have to make an educated guess. The best way to do that, Berry says, is to look at past results.
• Create an expenses budget. You're going to need to understand how much it's going to cost you to actually make the sales you have forecast. Berry likes to differentiate between fixed costs (i.e., rent and payroll) and variable costs (i.e., most advertising and promotional expenses), because it's a good thing for a business to know. "Lower fixed costs mean less risk, which might be theoretical in business schools but are very concrete when you have rent and payroll checks to sign," Berry says. "Most of your variable costs are in those direct costs that belong in your sales forecast, but there are also some variable expenses, like ads and rebates and such." Once again, this is a forecast, not accounting, and you're going to have to estimate things like interest and taxes. Berry recommends you go with simple math. He says multiply estimated profits times your best-guess tax percentage rate to estimate taxes. And then multiply your estimated debts balance times an estimated interest rate to estimate interest.
• Develop a cash-flow statement. This is the statement that shows physical dollars moving in and out of the business. "Cash flow is king," Pinson says. You base this partly on your sales forecasts, balance sheet items, and other assumptions. If you are operating an existing business, you should have historical documents, such as profit and loss statements and balance sheets from years past to base these forecasts on. If you are starting a new business and do not have these historical financial statements, you start by projecting a cash-flow statement broken down into 12 months. Pinson says that it's important to understand when compiling this cash-flow projection that you need to choose a realistic ratio for how many of your invoices will be paid in cash, 30 days, 60 days, 90 days and so on. You don't want to be surprised that you only collect 80 percent of your invoices in the first 30 days when you are counting on 100 percent to pay your expenses, she says. Some business planning software programs will have these formulas built in to help you make these projections.
• Income projections. This is your pro forma profit and loss statement, detailing forecasts for your business for the coming three years. Use the numbers that you put in your sales forecast, expense projections, and cash flow statement. "Sales, lest cost of sales, is gross margin," Berry says. "Gross margin, less expenses, interest, and taxes, is net profit."
• Deal with assets and liabilities. You also need a projected balance sheet. You have to deal with assets and liabilities that aren't in the profits and loss statement and project the net worth of your business at the end of the fiscal year. Some of those are obvious and affect you at only the beginning, like startup assets. A lot are not obvious. "Interest is in the profit and loss, but repayment of principle isn't," Berry says. "Taking out a loan, giving out a loan, and inventory show up only in assets--until you pay for them." So the way to compile this is to start with assets, and estimate what you'll have on hand, month by month for cash, accounts receivable (money owed to you), inventory if you have it, and substantial assets like land, buildings, and equipment. Then figure out what you have as liabilities--meaning debts. That's money you owe because you haven't paid bills (which is called accounts payable) and the debts you have because of outstanding loans.
• Breakeven analysis. The breakeven point, Pinson says, is when your business's expenses match your sales or service volume. The three-year income projection will enable you to undertake this analysis. "If your business is viable, at a certain period of time your overall revenue will exceed your overall expenses, including interest." This is an important analysis for potential investors, who want to know that they are investing in a fast-growing business with an exit strategy.

Dig Deeper: How to Price Business Services

How to Write the Financial Section of a Business Plan: How to Use the Financial Section One of the biggest mistakes business people make is to look at their business plan, and particularly the financial section, only once a year. "I like to quote former President Dwight D. Eisenhower," says Berry. "'The plan is useless, but planning is essential.' What people do wrong is focus on the plan, and once the plan is done, it's forgotten. It's really a shame, because they could have used it as a tool for managing the company." In fact, Berry recommends that business executives sit down with the business plan once a month and fill in the actual numbers in the profit and loss statement and compare those numbers with projections. And then use those comparisons to revise projections in the future. Pinson also recommends that you undertake a financial statement analysis to develop a study of relationships and compare items in your financial statements, compare financial statements over time, and even compare your statements to those of other businesses. Part of this is a ratio analysis. She recommends you do some homework and find out some of the prevailing ratios used in your industry for liquidity analysis, profitability analysis, and debt and compare those standard ratios with your own. "This is all for your benefit," she says. "That's what financial statements are for. You should be utilizing your financial statements to measure your business against what you did in prior years or to measure your business against another business like yours."  If you are using your business plan to attract investment or get a loan, you may also include a business financial history as part of the financial section. This is a summary of your business from its start to the present. Sometimes a bank might have a section like this on a loan application. If you are seeking a loan, you may need to add supplementary documents to the financial section, such as the owner's financial statements, listing assets and liabilities. All of the various calculations you need to assemble the financial section of a business plan are a good reason to look for business planning software, so you can have this on your computer and make sure you get this right. Software programs also let you use some of your projections in the financial section to create pie charts or bar graphs that you can use elsewhere in your business plan to highlight your financials, your sales history, or your projected income over three years. "It's a pretty well-known fact that if you are going to seek equity investment from venture capitalists or angel investors," Pinson says, "they do like visuals."

Dig Deeper: How to Protect Your Margins in a Downturn

Related Links: Making It All Add Up: The Financial Section of a Business Plan One of the major benefits of creating a business plan is that it forces entrepreneurs to confront their company's finances squarely. Persuasive Projections You can avoid some of the most common mistakes by following this list of dos and don'ts. Making Your Financials Add Up No business plan is complete until it contains a set of financial projections that are not only inspiring but also logical and defensible. How many years should my financial projections cover for a new business? Some guidelines on what to include. Recommended Resources: Bplans.com More than 100 free sample business plans, plus articles, tips, and tools for developing your plan. Planning, Startups, Stories: Basic Business Numbers An online video in author Tim Berry's blog, outlining what you really need to know about basic business numbers. Out of Your Mind and Into the Marketplace Linda Pinson's business selling books and software for business planning. Palo Alto Software Business-planning tools and information from the maker of the Business Plan Pro software. U.S. Small Business Administration Government-sponsored website aiding small and midsize businesses. Financial Statement Section of a Business Plan for Start-Ups A guide to writing the financial section of a business plan developed by SCORE of northeastern Massachusetts.

Editorial Disclosure: Inc. writes about products and services in this and other articles. These articles are editorially independent - that means editors and reporters research and write on these products free of any influence of any marketing or sales departments. In other words, no one is telling our reporters or editors what to write or to include any particular positive or negative information about these products or services in the article. The article's content is entirely at the discretion of the reporter and editor. You will notice, however, that sometimes we include links to these products and services in the articles. When readers click on these links, and buy these products or services, Inc may be compensated. This e-commerce based advertising model - like every other ad on our article pages - has no impact on our editorial coverage. Reporters and editors don't add those links, nor will they manage them. This advertising model, like others you see on Inc, supports the independent journalism you find on this site.

The Daily Digest for Entrepreneurs and Business Leaders

Privacy Policy

Financial Forecasting

Preparing a prediction of the future

What is Financial Forecasting?

Financial forecasting is the process of estimating or predicting how a business will perform in the future. The most common type of financial forecast is an income statement; however, in a complete financial model, all three financial statements are forecasted. In this guide on how to build a financial forecast, we will complete the income statement model from revenue to operating profit or EBIT .

Forecasting Revenue

There are inherent tensions in model building between making your model realistic and keeping it simple and robust. The first-principles approach identifies various methods to model revenues with high degrees of detail and precision. For instance, when forecasting revenue for the retail industry, we can forecast the expansion rate and derive income per square meter.

When forecasting revenue for the telecommunications industry, we can predict the market size and use current market share and competitor analysis. When forecasting revenue for any service industries, we can estimate the headcount and use the income for customer trends.

On the other hand, the quick and dirty approach to robust models outlines how you can model revenues in a much more straightforward way, with the benefit that the model will be more simple and easy to use (although less accurate and detailed). With this approach, users predict future growth based on historical figures and trends.

Forecasting Gross Margin and SG&A Expenses

Once we finish forecasting revenues, we next want to forecast gross margin. Gross margin is usually forecast as a percent of revenues. Again, we can use historical figures or trends to forecast future gross margin.

However, it is advised to take a more detailed approach, considering factors such as the cost of input, economies of scale, and learning curve. This second approach will allow your model to be more realistic, but also make it harder to follow.

The next step is to forecast overhead costs: SG&A expenses . Forecasting Selling, General, and Administrative costs are often done as a percentage of revenues. Although these costs are fixed in the short term, they become increasingly variable in the long term.

Therefore, when forecasting over shorter periods (weeks and months), using revenues to predict SG&A may be inappropriate. Some models forecast gross and operating margins to leave SG&A as the balancing figure.

Financial Forecasting Example

Let’s go through an example of financial forecasting together and build the income statement forecast model in Excel. First off, you can see that all the forecast inputs are grouped in the same section, called “Assumptions and Drivers.”

I created separate output section groups for the income statement, balance sheet, and cash flow statement. I also created a “Supporting Schedules” section, where detailed processing calculations for PP&E and equity are broken down in order to make the model easier to follow and audit. In this article, we will only work on the assumptions and the income statement.

All income statement input assumptions from revenues down to EBIT can be found in rows 8-14. All expenses are being forecasted as a percentage of sales. Only the sales forecast is based on growth over the previous year. My inputs are also ordered in the order they appear on the income statement.

Now, let’s move to the “Income Statement” section, where we are going to work on Column D and move downwards. To forecast sales for the first forecast year (in this case 2017), I take the previous year (C42) and grow it by the sales growth assumption in the “Assumptions & Drivers” section. The “SalesGrowthPercent” assumption is located in cell “D8”. Therefore, the formula for the 2017 forecasted revenue is =C42*(1+D8).

I then calculated our Cost of Goods Sold. To calculate the first forecast year’s COGS, we put a minus sign in front of our forecast sales, then multiply by one minus the “GrossMargin” assumption located in cell D9. The formula reads =-D42*(1-D9).

I then sum forecasted sales and COGS to calculate “Gross Profit”, located in cell D44. The formula reads =SUM(D42:D43). A handy shortcut for summing is ALT + =.

Next, I forecast all the expenses in rows 45 to 48 as a percentage of sales. Let’s first start with “Distribution Expenses,” then copy the formula down to “Depreciation.” To calculate, we subtract the forecast sales and multiply by the appropriate assumption, which in this case is Distribution Expense as a Percent of Sales. The formula reads =D$42*D10. Be mindful of the $ sign because we want to make row 42 of cell D42 an absolute reference. I then copy this formula down, using the shortcut CTRL + D or fill down.

Then, over to the right, using the shortcut CTRL + R or fill right.

Finally, I net gross profit off with all the other operating expenses to calculate EBIT, using =SUM(D44:D48).

Additional Resources

Thank you for reading this guide to financial forecasting. CFI is a global provider of financial analyst training and career advancement for finance professionals. To learn more and expand your career, explore the additional relevant CFI resources below:

• Types of Financial Models
• 3 Statement Model
• Scenario Analysis
• Visibility in the Business Context
• See all financial modeling resources

Analyst Certification FMVA® Program

Below is a break down of subject weightings in the FMVA® financial analyst program. As you can see there is a heavy focus on financial modeling, finance, Excel, business valuation, budgeting/forecasting, PowerPoint presentations, accounting and business strategy.

A well rounded financial analyst possesses all of the above skills!

Additional Questions & Answers

CFI is the global institution behind the financial modeling and valuation analyst  FMVA® Designation . CFI is on a mission to enable anyone to be a great financial analyst and have a great career path. In order to help you advance your career, CFI has compiled many resources to assist you along the path.

In order to become a great financial analyst, here are some more  questions and answers  for you to discover:

• What is Financial Modeling?
• How Do You Build a DCF Model?
• What is Sensitivity Analysis?
• How Do You Value a Business?
• Share this article

Create a free account to unlock this Template

Access and download collection of free Templates to help power your productivity and performance.

Already have an account? Log in

Supercharge your skills with Premium Templates

Take your learning and productivity to the next level with our Premium Templates.

Upgrading to a paid membership gives you access to our extensive collection of plug-and-play Templates designed to power your performance—as well as CFI's full course catalog and accredited Certification Programs.

Already have a Self-Study or Full-Immersion membership? Log in

Access Exclusive Templates

Gain unlimited access to more than 250 productivity Templates, CFI's full course catalog and accredited Certification Programs, hundreds of resources, expert reviews and support, the chance to work with real-world finance and research tools, and more.

Already have a Full-Immersion membership? Log in

How to Create a Sales Forecast

11 min. read

Updated October 27, 2023

Business owners are often afraid to forecast sales. But, you shouldn’t be. Because you can successfully forecast your own business’s sales.

You don’t have to be an MBA or CPA. It’s not about some magic right answer that you don’t know. It’s not about training you don’t have. It doesn’t take spreadsheet modeling (much less econometric modeling) to estimate units and price per unit for future sales. You just have to know your own business. 

Forecasting isn’t about seeing into the future

Sales forecasting is much easier than you think and much more useful than you imagine.

I was a vice president of a market research firm for several years, doing expensive forecasts, and I saw many times that there’s nothing better than the educated guess of somebody who knows the business well. All those sophisticated techniques depend on data from the past — and the past, by itself, isn’t the best predictor of the future. You are.

It’s not about guessing the future correctly. We’re human; we don’t do that well. Instead, it’s about setting down assumptions, expectations, drivers, tracking, and management. It’s about doing your job, not having precognitive powers. 

• Successful forecasting is driven by regular reviews

What really matters is that you review and revise your forecast regularly. Spending should be tied to sales, so the forecast helps you budget and manage. You measure the value of a sales forecast like you do anything in business, by its measurable business results.

That also means you should not back off from forecasting because you have a new product, or new business, without past data. Lay out the sales drivers and interdependencies, to connect the dots, so that as you review plan-versus-actual results every month, you can easily make course corrections.

If you think sales forecasting is hard, try running a business without a forecast. That’s much harder.

Your sales forecast is also the backbone of your business plan . People measure a business and its growth by sales, and your sales forecast sets the standard for  expenses , profits, and growth. The sales forecast is almost always going to be the first set of numbers you’ll track for plan versus actual use, even if you do no other numbers.

If nothing else, just forecast your sales, track plan-versus-actual results, and make corrections — that process alone, just the sales forecast and tracking is in itself already business planning. To get started on building your forecast follow these steps.

And if you run a subscription-based business, we have a guide dedicated to building a sales forecast for that business model.

• Step 1: Set up your lines of sales

Most forecasts show several distinct lines of sales. Ideally, your sales lines match your accounting, but not necessarily in the same level of detail.   

For example, a restaurant ought not to forecast sales for each item on the menu. Instead, it forecasts breakfasts, lunches, dinners, and drinks, summarized. And a bookstore ought not to forecast sales by book, and not even by topic or author, but rather by lines of sales such as hardcover, softcover, magazines, and maybe categories (such as fiction, non-fiction, travel, etc.) if that works.

Always try to set your streams to match your accounting, so you can look at the difference between the forecast and actual sales later. This is excellent for real business planning. It makes the heart of the process, the regular review, and revision, much easier. The point is better management.

For instance, in a bicycle retail store business plan, the owner works with five lines of sales, as shown in the illustration here.  

In this sample case, the revenue includes new bikes, repair, clothing, accessories, and a service contract. The bookkeeping for this retail store tracks sales in those same five categories.

Brought to you by

Create a professional business plan

Using ai and step-by-step instructions.

Secure funding

Validate ideas

Build a strategy

• Step 2: Forecast line by line

There are many ways to forecast a line of sales.

The method for each row depends on the business model

Among the main methods are:.

• Unit sales : My personal favorite. Sales = units times price. You set an average price and forecast the units. And of course, you can change projected pricing over time. This is my favorite for most businesses because it gives you two factors to act on with course corrections: unit sales, or price.
• Service units : Even though services don’t sell physical units, most sell billable units, such as billable hours for lawyers and accountants, or trips for transportations services, engagements for consultants, and so forth.
• Recurring charges : Subscriptions. For each month or year, it has to forecast new signups, existing monthly charges, and cancellations. Estimates depend on both new signups and cancellations, which is often called “churn.”
• Revenue only : For those who prefer to forecast revenue by the stream as just the money, without the extra information of breaking it into units and prices.

Most sales forecast rows are simple math

For a business plan, I recommend you make your sales forecast a detailed look at the next 12 months and then broadly cover two years after that. Here’s how to approach each method of line-by-line forecasting.

Start with units if you can

For unit sales, start by forecasting units month by month, as shown here below for the new bike’s line of sales in the bicycle shop plan:

I recommend looking at the visual as you forecast the units because most of us can see trends easier when we look at the line, as shown in the illustration, rather than just the numbers. You can also see the numbers in the forecast near the bottom. The first year, fiscal 2021 in this forecast, is the sum of those months.

Estimate price assumptions

With a simple revenue-only assumption, you do one row of units as shown in the above illustration, and you are done. The units are dollars, or whatever other currency you are using in your forecast. In this example, the new bicycle product will be sold for an average of $550.00. 

That’s a simplifying assumption, taking the average price, not the detailed price for each brand or line. Garrett, the shop owner, uses his past results to determine his actual average price for the most recent year. Then he rounds that estimate and adds his own judgment and educated guess on how that will change. 

Multiply price times units

Multiplying units times the revenue per unit generates the sales forecast for this row. So for example the $18,150 shown for October of 2020 is the product of 33 units times $550 each. And the $21,450 shown for the next month is the product of 39 units times $550 each. 

Subscription models are more complicated

Lately, a lot of businesses offer their buyers subscriptions, such as monthly packages, traditional or online newspapers, software, and even streaming services. All of these give a business recurring revenues, which is a big advantage. 

For subscriptions, you normally estimate new subscriptions per month and canceled subscriptions per month, and leave a calculation for the actual subscriptions charged. That’s a more complicated method, which demands more details. 

For that, you can refer to detailed discussions on subscription forecasting in How to Forecast Sales for a Subscription Business .

• But how do you know what numbers to put into your sales forecast?

The math may be simple, yes, but this is predicting the future, and humans don’t do that well. So, don’t try to guess the future accurately for months in advance.

Instead, aim for making clear assumptions and understanding what drives your sales, such as web traffic and conversions, in one example, or the direct sales pipeline and leads, in another. Review results every month, and revise your forecast. Your educated guesses become more accurate over time.

Experience in the field is a huge advantage

In a normal ongoing business, the business owner has ample experience with past sales. They may not know accounting or technical forecasting, but they know their business. They are aware of changes in the market, their own business’s promotions, and other factors that business owners should know. They are comfortable making educated guesses.

If you don’t personally have the experience, try to find information and make guesses based on the experience of an employee,  your mentor , or others you’ve spoken within your field.

Use past results as a guide

Use results from the recent past if your business has them. Start a forecast by putting last year’s numbers into next year’s forecast, and then focus on what might be different this year from next.

Do you have new opportunities that will make sales grow? New marketing activities, promotions? Then increase the forecast. New competition, and new problems? Nobody wants to forecast decreasing sales, but if that’s likely, you need to deal with it by cutting costs or changing your focus.

Look for drivers

To forecast sales for a new restaurant, first, draw a map of tables and chairs and then estimate how many meals per mealtime at capacity, and in the beginning. It’s not a random number; it’s a matter of how many people come in.

To forecast sales for a new mobile app, you might get data from the Apple and Android mobile app stores about average downloads for different apps. A good web search might also reveal some anecdotal evidence, blog posts, and news stories, about the ramp-up of existing apps that were successful.

Get those numbers and think about how your case might be different. Maybe you drive downloads with a website, so you can predict traffic from past experience and then assume a percentage of web visitors who will download the app.

• Estimate direct costs

Direct costs are also called the cost of goods sold (COGS) and per-unit costs. Direct costs are important because they help calculate gross margin, which is used as a basis for comparison in financial benchmarks, and are an instant measure (sales less direct costs) of your underlying profitability.

For example, I know from benchmarks that an average sporting goods store makes a 34 percent gross margin. That means that they spend $66 on average to buy the goods they sell for $100.

Not all businesses have direct costs. Service businesses supposedly don’t have direct costs, so they have a gross margin of 100 percent. That may be true for some professionals like accountants and lawyers, but a lot of services do have direct costs. For example, taxis have gasoline and maintenance. So do airlines.

A normal sales forecast includes units, price per unit, sales, direct cost per unit, and direct costs. The math is simple, with the direct costs per unit related to total direct costs the same way price per unit relates to total sales.

Multiply the units projected for any time period by the unit direct costs, and that gives you total direct costs. And here too, assume this view is just a cut-out, it flows to the right. In this example, Garrett the shop owner projected the direct costs of new bikes based on the assumption of 49 percent of sales.

Given the unit forecast estimate, the calculation of units times direct costs produces the forecast shown in the illustration below for direct costs for that product. So therefore the projected direct costs for new bikes in October is $8,894, which is 49% of the projected sales for that month, $18,150.

• Never forecast in a vacuum

Never think of your sales forecast in a vacuum. It flows from the strategic action plans with their assumptions,  milestones , and metrics. Your marketing milestones affect your sales. Your business offering milestones affect your sales.

When you change milestones—and you will, because all business plans change—you should change your sales forecast to match.

• Timing matters

Your sales are supposed to refer to when the ownership changes hands (for products) or when the service is performed (for services). It isn’t a sale when it’s ordered, or promised, or even when it’s contracted.

With proper  accrual accounting , it is a sale even if it hasn’t been paid for. With so-called cash-based accounting, by the way, it isn’t a sale until it’s paid for. Accrual is better because it gives you a more accurate picture, unless you’re very small and do all your business, both buying and selling, with cash only.

I know that seems simple, but it’s surprising how many people decide to do something different. The penalty for doing things differently is that then you don’t match the standard, and the bankers, analysts, and investors can’t tell what you meant.

This goes for direct costs, too. The direct costs in your monthly  profit and loss statement  are supposed to be just the costs associated with that month’s sales. Please notice how, in the examples above, the direct costs for the sample bicycle store are linked to the actual unit sales.

• Live with your assumptions

Sales forecasting is not about accurately guessing the future. It’s about laying out your assumptions so you can manage changes effectively as sales and direct costs come out different from what you expected. Use this to adjust your sales forecast and improve your business by making course corrections to deal with what is working and what isn’t.

I believe that even if you do nothing else, by the time you use a sales forecast and review plan versus actual results every month, you are already managing with a business plan . You can’t review actual results without looking at what happened, why, and what to do next.

Tim Berry is the founder and chairman of Palo Alto Software , a co-founder of Borland International, and a recognized expert in business planning. He has an MBA from Stanford and degrees with honors from the University of Oregon and the University of Notre Dame. Today, Tim dedicates most of his time to blogging, teaching and evangelizing for business planning.

Table of Contents

• Forecasting isn’t about seeing into the future

Related Articles

8 Min. Read

How to Plan Your Exit Strategy

9 Min. Read

How to Create a Cash Flow Forecast

6 Min. Read

How to Create a Profit and Loss Forecast

5 Min. Read

How to Highlight Risks in Your Business Plan

The Bplans Newsletter

The Bplans Weekly

Subscribe now for weekly advice and free downloadable resources to help start and grow your business.

We care about your privacy. See our privacy policy .

The quickest way to turn a business idea into a business plan

Fill-in-the-blanks and automatic financials make it easy.

No thanks, I prefer writing 40-page documents.

Discover the world’s #1 plan building software

How to write a sales forecast for a business plan

Table of Contents

What is a sales forecast?

Why do you need a sales forecast, how do you write a sales forecast, top-down or bottom-up, writing your sales forecast, calculating a sales forecast, how can countingup help manage your forecasting.

Sales forecasts are an important part of your business plan . If done correctly, they can give accurate projections of your business’ cash flow, and let you better prepare for the year ahead. They can also make it easier to find the right investors . While it’s easier for existing businesses with plenty of data, you can still calculate a sales forecast for a new business .

In this guide, we’ll explore:

• How can you manage your forecasting?

A sales forecast is a prediction of your business’ future revenue. In order to be an accurate prediction, the forecast is based on previous sales, current economic trends, and industry performance. Having a sales forecast is a useful tool, because it gives you a better idea of how to manage your business. 

Having a sales forecast is like using the past to have a peek into the future of your company. It might not be 100% accurate, but it can help you plan any future spending, or prevent any cash flow issues from occurring. 

You can also use your sales forecast to monitor your business’ progress. For instance, if your business regularly performs better than your forecast, it could be a sign that your business is continuing to grow. On the other hand, if your actual sales are frequently less than expected, this could be a sign that your business is struggling and needs adjustment. 

It’s important to remember that any projections you make aren’t guaranteed, there can be advantages and disadvantages of financial forecasting . 

Now we’ve run through why having a sales forecast can help you run your business, let’s look at how to write one. 

While there are two types of sales forecasting (top-down and bottom-up), one is a lot more accurate for small businesses than the other. A top-down forecast looks at the market as a whole and attributes a portion of the market to your business. 

A top-down approach may work for large businesses that already own a significant chunk of the market. When forecasting for a small business, it’s easy to overestimate your market share. For example, a 1% market share may not seem like a lot, but a small restaurant owning 1% of the £89.5 billion UK market is extremely unrealistic.

The alternative to top-down is bottom-up. A bottom-up sales forecast starts with existing company data (like customer or product information) and works up to revenue. Since this starts with the company, it’s easier to 

Your sales forecast is ultimately a prediction of your revenue over a set period. It considers the amount you think you’ll sell, and the cost of those sales. We’ve included how to calculate a sales forecast below.

A sales forecast consists of three separate values: revenue, cost of goods sold, and gross profit. For estimating values in the calculations below, it’s best to use any existing business data to be as accurate as possible. 

To calculate your predicted revenue:

• Make a list of your available goods and services
• Note the price of each of your goods and services
• Estimate the expected sales of each good or service
• Multiply the price by the estimated sales to get your estimated revenue
• Add them all together to get your total revenue

For example, if your food truck business sold pizzas at £10 and burgers at £5, you would multiply these values by how much you expected to sell. For calculating a weekly sales forecast, you might estimate selling 60 pizzas and 80 burgers. Your predicted revenue for that week would be £600 for pizzas and £400 for burgers — giving £1,000 total.

In order to figure out how much profit you’ll make, you also need to calculate your costs for those predicted sales. To calculate your predicted costs:

• Figure out how much each good or service will cost per unit
• Multiply each cost by the projected sales

Using the same example as above, assume a single pizza cost £3.50 to make and a burger cost £2. Using the estimated sales, the total cost for your pizzas (3.5 x 60) would be £210, and £160 for your burgers (2 x 80). Combining these two figures gives you a total cost of £370.

The last step is to work out your gross profit , and it’s a relatively simple calculation.

• Subtract the total predicted cost from your total predicted revenue

Continuing with the example above, your revenue (£1,000) minus your costs (£370), leaves you with a projected gross profit of £630 for the week. Using this estimate, you can then plan how much working capital your business should have access to. It’s important to remember that these are only estimates, and your actual values can be higher or lower than your forecast.

If you want your forecasts to be as accurate as possible, you need to refer to all of your business’ financial data. Since collecting and collating this data can be challenging, you may want to use financial management software like the Countingup app. 

When trying to calculate your sales forecasts, having an up-to-date log of your current sales can be hugely beneficial. By combining a business current account with accounting software, Countingup is the only software that provides real-time cash flow tracking. 

The Countingup app also provides business owners with access to automatically generated profit and loss statements. These can prove invaluable when trying to stay aware of all your business’ costs.

Start your three-month free trial today. Find out more here .

• Counting Up on Facebook
• Counting Up on Twitter
• Counting Up on LinkedIn

Related Resources

Business insurance from superscript.

We’re partnered with insurance experts, Superscript to provide you with small business insurance.

How to register a company in the UK

There are over five million companies registered in the UK and 500,000 new

How to set up a TikTok shop (2024)

TikTok can be an excellent platform for growing a business, big or small.

Best Side Hustle Ideas To Make Extra Money In 2024 (UK Edition)

Looking to start a new career? Or maybe you’re looking to embrace your

How to throw a launch party for a new business

So your business is all set up, what next? A launch party can

How to set sales goals

Want to make manageable and achievable sales goals for your business? Find out

10 key tips to starting a business in the UK

10 things you need to know before starting a business in the UK

How to set up your business: Sole trader or limited company

If you’ve just started a business, you’ll likely be faced with the early

How to register as a sole trader

Running a small business and considering whether to register as a sole trader? 

How to open a Barclays business account

When starting a new business, one of the first things you need to

6 examples of objectives for a small business plan

Your new company’s business plan is a crucial part of your success, as

How to start a successful business during a recession

Starting a business during a recession may sound like madness, but some big

Cookies on GOV.UK

We use some essential cookies to make this website work.

We’d like to set additional cookies to understand how you use GOV.UK, remember your settings and improve government services.

We also use cookies set by other sites to help us deliver content from their services.

You have accepted additional cookies. You can change your cookie settings at any time.

You have rejected additional cookies. You can change your cookie settings at any time.

• Business and self-employed
• Business finance and support

Write a business plan

Download free business plan templates and find help and advice on how to write your business plan.

Business plan templates

Download a free business plan template on The Prince’s Trust website.

You can also download a free cash flow forecast template or a business plan template on the Start Up Loans website to help you manage your finances.

Business plan examples

Read example business plans on the Bplans website.

How to write a business plan

Get detailed information about how to write a business plan on the Start Up Donut website.

Why you need a business plan

A business plan is a written document that describes your business. It covers objectives, strategies, sales, marketing and financial forecasts.

A business plan helps you to:

• clarify your business idea
• spot potential problems
• set out your goals
• measure your progress

You’ll need a business plan if you want to secure investment or a loan from a bank. Read about the finance options available for businesses on the Business Finance Guide website.

It can also help to convince customers, suppliers and potential employees to support you.

Related content

Is this page useful.

• Yes this page is useful
• No this page is not useful

Help us improve GOV.UK

Don’t include personal or financial information like your National Insurance number or credit card details.

To help us improve GOV.UK, we’d like to know more about your visit today. Please fill in this survey (opens in a new tab) .

Recommended

Lyft plunges nearly 20% after weak forecast sparks fears its losing race with uber.

Lyft’s shares tanked 17% on Wednesday after a soft forecast for the key summer quarter stirred worries that it may be losing ground to rival Uber.

Uber, which reported strong results on Tuesday, and Lyft are locked in a tussle for market share in the North American ride-hailing sector.

Benefiting from a global footprint and wider array of services, Uber has been wooing customers with subscription offerings while Lyft doubled down on competitive fares as well as company-wide cost cuts to boost its business.

“Lyft may struggle to gain the share that Uber has, but the market essentially requires a second competitor to maintain pricing balance,” said Mike Ramsey, a transportation analyst at Gartner.

On Wednesday, CEO David Risher announced Price Lock, a subscription-based feature that offers commuters on fixed routes a capped fare.

Lyft forecast gross bookings – the total value of transactions on the Lyft app excluding tips – between $4 billion and $4.1 billion in the three months ending September, a period of high tourism-related travel.

Analysts were $4.13 billion, according to estimates from LSEG.

Adjusted core earnings guidance of $90 million to $95 million also came in below the street target of $104.3 million.

For the quarter ended June 30, Lyft reported better-than-expected revenue and posted a net profit for the first time, driven in part by cost cuts last year.

Since Risher took charge last year, Lyft has cut hundreds of jobs , narrowed the firm’s losses and managed to keep fare increases in check.

In June, Lyft hosted its first-ever investor day and projected annual gross bookings to grow at a steady 15% rate through 2027.

Revenue rose 41% to $1.44 billion in the second quarter, beating estimate of $1.39 billion.

Net income was $5.0 million, compared to a $114.3 million net loss in the previous corresponding period when the company booked $46.6 million in restructuring-related charges.

With Post wires