example of business plan forecast

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.

Applications are open for the CO—100! Now is your chance to join an exclusive group of outstanding small businesses. Share your story with us — apply today.

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 .

Become a small business member and save!

Become an integral voice in the world’s largest business organization when you join the U.S. Chamber of Commerce as a small business member. Members also receive exclusive discounts from B2B partners, including a special offer from FedEx that can help your business save hundreds a year on shipping. Become a member today and start saving!

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

What is ai price optimization, what is enterprise resource planning, choosing an enterprise resource planning tool for your small business.

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.

• Search Search Please fill out this field.
• Building Your Business
• Becoming an Owner
• Business Plans

Writing a Business Plan—Financial Projections

Spell out your financial forecast in dollars and sense

Creating financial projections for your startup is both an art and a science. Although investors want to see cold, hard numbers, it can be difficult to predict your financial performance three years down the road, especially if you are still raising seed money. Regardless, short- and medium-term financial projections are a required part of your business plan if you want serious attention from investors.

The financial section of your business plan should include a sales forecast , expenses budget , cash flow statement , balance sheet , and a profit and loss statement . Be sure to follow the generally accepted accounting principles (GAAP) set forth by the Financial Accounting Standards Board , a private-sector organization responsible for setting financial accounting and reporting standards in the U.S. If financial reporting is new territory for you, have an accountant review your projections.

Sales Forecast

As a startup business, you do not have past results to review, which can make forecasting sales difficult. It can be done, though, if you have a good understanding of the market you are entering and industry trends as a whole. In fact, sales forecasts based on a solid understanding of industry and market trends will show potential investors that you've done your homework and your forecast is more than just guesswork.

In practical terms, your forecast should be broken down by monthly sales with entries showing which units are being sold, their price points, and how many you expect to sell. When getting into the second year of your business plan and beyond, it's acceptable to reduce the forecast to quarterly sales. In fact, that's the case for most items in your business plan.

Expenses Budget

What you're selling has to cost something, and this budget is where you need to show your expenses. These include the cost to your business of the units being sold in addition to overhead. It's a good idea to break down your expenses by fixed costs and variable costs. For example, certain expenses will be the same or close to the same every month, including rent, insurance, and others. Some costs likely will vary month by month such as advertising or seasonal sales help.

Cash Flow Statement

As with your sales forecast, cash flow statements for a startup require doing some homework since you do not have historical data to use as a reference. This statement, in short, breaks down how much cash is coming into your business on a monthly basis vs. how much is going out. By using your sales forecasts and your expenses budget, you can estimate your cash flow intelligently.

Keep in mind that revenue often will trail sales, depending on the type of business you are operating. For example, if you have contracts with clients, they may not be paying for items they purchase until the month following delivery. Some clients may carry balances 60 or 90 days beyond delivery. You need to account for this lag when calculating exactly when you expect to see your revenue.

Profit and Loss Statement

Your P&L statement should take the information from your sales projections, expenses budget, and cash flow statement to project how much you expect in profits or losses through the three years included in your business plan. You should have a figure for each individual year as well as a figure for the full three-year period.

Balance Sheet

You provide a breakdown of all of your assets and liabilities in the balances sheet. Many of these assets and liabilities are items that go beyond monthly sales and expenses. For example, any property, equipment, or unsold inventory you own is an asset with a value that can be assigned to it. The same goes for outstanding invoices owed to you that have not been paid. Even though you don't have the cash in hand, you can count those invoices as assets. The amount you owe on a business loan or the amount you owe others on invoices you've not paid would count as liabilities. The balance is the difference between the value of everything you own vs. the value of everything you owe.

Break-Even Projection

If you've done a good job projecting your sales and expenses and inputting the numbers into a spreadsheet, you should be able to identify a date when your business breaks even—in other words, the date when you become profitable, with more money coming in than going out. As a startup business, this is not expected to happen overnight, but potential investors want to see that you have a date in mind and that you can support that projection with the numbers you've supplied in the financial section of your business plan.

Additional Tips

When putting together your financial projections, keep some general tips in mind:

• Get comfortable with spreadsheet software if you aren't already. It is the starting point for all financial projections and offers flexibility, allowing you to quickly change assumptions or weigh alternative scenarios. Microsoft Excel is the most common, and chances are you already have it on your computer. You can also buy special software packages to help with financial projections.
• Prepare a five-year projection . Don’t include this one in the business plan, since the further into the future you project, the harder it is to predict. However, have the projection available in case an investor asks for it.
• Offer two scenarios only . Investors will want to see a best-case and worst-case scenario, but don’t inundate your business plan with myriad medium-case scenarios. They likely will just cause confusion.
• Be reasonable and clear . As mentioned before, financial forecasting is as much art as science. You’ll have to assume certain things, such as your revenue growth, how your raw material and administrative costs will grow, and how effective you’ll be at collecting on accounts receivable. It’s best to be realistic in your projections as you try to recruit investors. If your industry is going through a contraction period and you’re projecting revenue growth of 20 percent a month, expect investors to see red flags.

• 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
• 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 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.

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.

Access your free e-book today.

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

• Search Search Please fill out this field.
• Corporate Finance
• Financial Analysis

What Is Business Forecasting? Definition, Methods, and Model

What Is Business Forecasting?

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 has 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.

Types of Business Forecasting

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.

Criticism of Forecasting

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.

But 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.

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
• Your Privacy Choices

Financial forecast example for new businesses and startups

The financial forecast is an essential step when creating a business plan. The financial forecast allows you to anticipate the revenues and expenses of your new business over a given period.

Even if the exercise is sometimes delicate to carry out, it is nevertheless essential for any entrepreneur. Indeed, it allows you to define quantified objectives, which, if meticulously tracked, will allow you to grow your business in good conditions.

To help you, here's a financial forecast example as well as tools you can use to create yours. 

Financial forecast examples for new businesses

Example of a sales forecast.

The sales forecast is used to estimate the company's turnover. It is generally presented by category of products and services, types of customers, or time slots.

In our financial forecast example, we have included below a sales forecast for a hostel, organised by categories of services with the bed's occupancy forecast broken down based on seasonality:

To ensure a fair and realistic evaluation of your company's revenues, You will need to base your forecast on thorough and reliable market analysis, including an analysis of what your competition offers. You will also need to think carefully about your pricing policy and distribution strategy beforehand.

Examples of financial statements to include in your forecast

Your forecast will need to include 3 financial statements:

• The P&L statement
• The cash flow statement
• The balance sheet

P&L statement

The profit and loss statement enables you to assess:

• the growth of the company by analyzing the evolution of the turnover over several years;
• the profitability of the company by looking at the difference between the expected revenues and the costs which will need to be incurred to generate these sales.

The main shortcoming of the projected income statement is that it does not take into account cash flows. Your profits should turn into cash at some point, but based on when your clients pay you, how much inventory you keep, or when you pay your suppliers, the cash flow could be very different from your profit.

To overcome this shortcoming, we need to look at the forecasted cash flow statement included in our financial forecast example.

Cash flow statement

The cash flow statement shows all anticipated cash movements for a given year.

It enables you to evaluate:

• the ability to generate operating cash flow;
• the company's investment and financing policies.

The cash flow statement is highly complementary to the P&L statement. Together they provide a clear view of the company's profitability, the cash generated by the operations, the investments made and the financing flows.

Balance sheet

The forecasted balance sheet, the last link in the chain, provides an overview of the company's net worth at a given moment in time and is part of our financial forecast example. It enables you to evaluate:

• the value of the company's assets;
• the weight of its working capital;
• the level of financial indebtedness;
• the book value of shareholders' equity.

The forecasted balance sheet complements the other two tables. Nevertheless, it has two weak points:

• It provides a snapshot of the company's net worth at a specific moment in time - giving a very static view of the company. Especially given the balance sheet is usually produced several months after the end of the financial year (and therefore the information it contains is already stale!)
• It gives an accounting vision of the company, based on historical cost, and not a financial vision, based on market value.

Where can I find other financial forecast examples?

At The Business Plan Shop, we offer an online software that includes a financial forecasting tool and helps you throughout the drafting of the business plan on top of financial forecast examples included in our business plan templates . 

Using a software like ours to realize your business plan has several advantages:

• You can easily create your financial forecast by letting the software take care of the calculations and financial aspects for you.
• You are guided in the drafting process by detailed instructions and examples for each part of the plan.
• You get a professional document, formatted and ready to be sent to your bank or investors.

If you are interested in our solution, you can try our software for free here .

Our article is coming to an end. We hope that our financial forecast example has given you a better understanding of what this exercise is all about.

The forecast is a crucial element of a business plan that will be of particular interest to your financial partners if you are looking for financing; but don't forget that it is also a mean for you, as an entrepreneur, to evaluate the viability of your new business idea.

Also on The Business Plan Shop

• How to do financial projections for a new business?
• How to establish a Profit & Loss forecast in your business plan?
• How to do a financial forecast for a restaurant?

Founder & CEO at The Business Plan Shop Ltd

Guillaume Le Brouster is a seasoned entrepreneur and financier.

Guillaume has been an entrepreneur for more than a decade and has first-hand experience of starting, running, and growing a successful business.

Prior to being a business owner, Guillaume worked in investment banking and private equity, where he spent most of his time creating complex financial forecasts, writing business plans, and analysing financial statements to make financing and investment decisions.

Guillaume holds a Master's Degree in Finance from ESCP Business School and a Bachelor of Science in Business & Management from Paris Dauphine University.

Create a convincing business plan

Assess the profitability of your business idea and create a persuasive business plan to pitch to investors

500,000+ entrepreneurs have already tried our solution - why not join them?

Not ready to try our on-line tool ? Learn more about our solution here

Need some inspiration for your business plan?

Subscribe to The Business Plan Shop and gain access to our business plan template library.

Need a professional business plan? Discover our solution

Write your business plan with ease!

It's easy to create a professional business plan with The Business Plan Shop

Want to find out more before you try? Learn more about our solution here

• 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.

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

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

What is a mission statement (and how to write one)

When starting a small business, you’ll need a plan to get things up

Planning, Startups, Stories

Tim berry on business planning, starting and growing your business, and having a life in the meantime., standard business plan financials: how to forecast sales.

Real Goals of Sales Forecast

Your sales forecast won’t accurately predict the future. We know that from the start. What you want is to understand the sales drivers and interdependencies, to connect the dots, so that as you review plan vs. actual results every month, you can easily make course corrections.

Sure, people shy from doing forecasts, because it can feel like real numbers and you can think only the numbers people can do it. Don’t believe that. You don’t have to have an MBA degree or be a CPA. You don’t need sophisticated financial models or spreadsheets. 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. So let’s look at how to forecast sales, step by step.

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 vs. actual use, even if you do no other numbers.

If nothing else, just forecast your sales, track plan vs. actual results, and make corrections; that’s already business planning.

Match Your Forecast to Your Accounting

It should be obvious: Make sure the way you organize the sales forecast in rows or items or groups matches the way your accounting (or bookkeeping) tracks them.

Match your chart of accounts, which is what accountants call your list of items that show up in your financial statements.

If the accounting divides sales into meals, drinks, and other, then the business plan should divide sales into meals, drinks, and other. So if your chart of accounts divides sales by product or service groups, keep those groups intact in your sales forecast. If bookkeeping tracks sales by product, don’t forecast your sales by channel instead.

If you’re planning for a startup business, coordinate the bookkeeping categories with the forecasting categories.

Get your last Income Statement (also called Profit & Loss) and keep it in view while you develop your future projections.

If you don’t have more than 20 or so each rows of sales, costs, and expenses, then make the rows in the projected statement match the rows in the accounting.

If your accounting summarizes categories for you – most systems do – consider using the summary categories in your business plan. Accounting needs detail, while planning needs a summary.

If your categories in the projections don’t match the accounting output, you’re not going to be able to track plan vs. actual well. It will take retyping and recalculating. And you’ll lose the most valuable business benefit of business planning: management, steering your company.

The math is simple

Normally your sales forecast will group sales into a few manageable rows of sales and show projected units, prices, and sales monthly for the next 12 months and annually for the second and third years in the future. Here’s a quick example from a bicycle retailer named Garrett (with columns for April-November hidden on purpose, to make viewing easier):

If you’re a LivePlan customer, don’t worry about this spreadsheet view, which is generic. LivePlan will guide you through the sales forecast assumptions and do the calculations automatically. For the generic spreadsheet option, shown here, you multiply units times prices to calculate sales. For example, unit sales of 36 new bicycles in March multiplied by $500 average revenue per bicycle means an estimated $18,000 of sales for new bicycles for that month.

Total Unit Sales is the sum of the projected units for each of the five categories of sales.

Total Sales is the sum of the projected sales for each of the five categories of sales.

Calculate Year 1 totals from the 12 month columns. Units and sales are sums of the 12 columns, and price is the average, calculated by dividing sales by units.

The numbers for Year 2 and Year 3 are just single columns; unless you have a special case, projecting monthly results for two and three years hence is overkill. It’s a problem of diminishing returns; you don’t get enough value to justify the time it takes. Other experts will disagree, by the way; and there may be special cases in which extended monthly projections are worth the effort.

Estimate Direct Costs

A normal sales forecast includes units, price per unit, sales, direct cost per unit, and direct costs. Direct costs are also called COGS, cost of goods sold, and unit costs.

COGS stands for Cost of Goods Sold, and applies to businesses that sell goods. COGS for a manufacturer include raw materials and labor costs to manufacture or assemble finished goods. COGS for a bookstore include what the storeowner pays to buy books. COGS for Garrett are what he paid for the bicycles, accessories, and clothing he sold during the month. Direct costs are the same thing for a service business, the direct cost of delivering the service. So, for example, it’s the gasoline and maintenance costs of a taxi ride.

Direct costs are specific to the business. The direct costs of a bookstore are its COGS, what it pays to buy books from a distributor. The distributor’s direct costs are COGS, what it paid to get the books from the publishers. The direct costs of the book publisher include the cost of printing, binding, shipping, and author royalties. The direct costs of the author are very small, probably just printer paper and photocopying; unless the author is paying an editor, in which case what the editor was paid is part of the author’s direct costs.

The costs of manufacturing and assembly labor are always supposed to be included in COGS. And some professional service businesses will include the salaries of their professionals as direct costs. In that case, the accounting firm, law office, or consulting company records the salaries of some of their associates as direct costs.

The illustration below shows how Garrett uses estimated margins to project the direct costs for his bicycle store. For the highlighted estimates, the direct entry for bicycles unit cost is the product of multiplying the price by 68 percent. The total direct costs for bicycles in January are the result of multiplying 30 units by $340 per unit. And here again, LivePlan users don’t need to do these calculations; your software does it automatically.

Some Quick Notes About Standards

Timing matters.

Standard accounting and financial analysis have rules about sales and direct costs and timing. A sale is when the ownership of the goods changes hands, or the service is performed. That seems simple enough but what happens sometimes is people confuse promises with sales. In the bike store example, if a customer tells Garrett in May that he is definitely going to buy 5 bicycles in July, that transaction should not be part of sales for May. Garrett should put those 5 bicycles into his July forecast and then they will actually be recorded as sales in the bookkeeping actual sales in July when the transaction takes place. In a service business, when a client promises in November to start a monthly service in January, that is not a November sale.

Direct costs also happen when the goods change hands. Technically, according to accounting standards (called accrual accounting), when Garrett the bike storeowner buys a bicycle he wants to sell, the money he spent on it remains in inventory until he sells it. It goes from inventory to direct costs for the income statement in the month in which it was sold. If it is never sold, it never affects profit or loss, and remains an asset until some day when the accountants write off old never-sold obsolete inventory, at which time its lowered value becomes an expense. In that case it was never a direct cost.

Most of this has to do with proper accounting. My standard business plan financials series includes What’s Accrual Accounting and Why Do You Care , which is directly related. When in doubt, please read that one.

Gross Margin

The distinction isn’t always obvious. For example, manufacturing and assembly labor are supposed to be included in direct costs, but factory workers are paid sometimes when there is no job to work on. And some professional firms put lawyers’ accountants’ or consultants’ salaries into direct costs. These are judgment calls. When I was a young associate in a brand-name management consulting firm, I had to assign all of my 40 hour work week to specific consulting jobs for cost accounting.

Garrett can easily calculate the gross margin he’s projecting with his sales forecast. The illustration below shows his simple calculation of gross margin using his sales and direct costs.

How do I know what numbers to use?

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. Don’t try to guess the future accurately for months in advance. Instead, aim for making clear assumptions and understanding what drives sales, such as web traffic and conversions, in one example, or the direct sales pipeline and leads, in another. And you review results every month, and revise your forecast. Your educated guesses become more accurate over time.

Use experience and past results

• Experience in the field is a huge advantage . In the example above, Garrett the bike storeowner has ample experience with past sales. He doesn’t know accounting or technical forecasting, but he knows his bicycle store and the bicycle business. He’s aware of changes in the market, and his own store’s promotions, and other factors that business owners know. He’s comfortable making educated guesses. In another example that follows, the café startup entrepreneur makes guesses based on her experience as an employee.
• 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.
• Start with your best guess , and follow up. Update your forecast each month. Compare the actual results to the forecast. You will get better at forecasting. Your business will teach you.

How to Forecast a New Business or New Product

What? You say you can’t forecast because your business or product is new? Join the club. Lots of people start new businesses, or new groups or divisions or products or territories within existing businesses, and can’t turn to existing data to forecast the future.

Think of the weather experts doing a 10-day forecast. Of course they don’t know the future, but they have some relevant information and they have some experience in the field. They look at weather drivers such as high and low pressure areas, wind directions, cloud formations, storms gathering elsewhere. They consider past experience, so they know how these same factors have generally behaved in the past. And they make educated guesses. When they project a high of 85 and low of 55 tomorrow, those are educated guesses.

You do the same thing with your new business or new product forecast that the experts do with the weather. You can get what data is available on factors that drive your sales, equivalent to air pressure and wind speeds and cloud formations. For example:

• 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. So a restaurant that seats 36 people at a time might assume it can sell a maximum of 50 lunches when it is absolutely jammed, with some people eating early and some late for their lunch hours. And maybe that’s just 20 lunches per day the first month, then 25 the second month, and so on. Apply some reasonable assumption to a month, and you have some idea.
• 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. And a good web search might reveal some anecdotal evidence, blog posts and news stories perhaps, about the ramp-up of existing apps that were successful. Get those numbers and think about how your case might be different. And maybe you drive downloads with a website, so you can predict traffic on your website from past experience and then assume a percentage of web visitors who will download the app.
• So you take the information related to what I’m calling sales drivers, and apply common sense to it, human judgment, and then make your educated guesses. As more information becomes available — like the first month’s sales, for example – you add that into the mix, and revise or not, depending on how well it matches your expectations. It’s not a one-time forecast that you have to live with as the months go by. It’s all part of the lean planning process.

Sales forecast depends on product/service and marketing

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.

Thank you for this great informations I really learn a lot. Thanks

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

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

Sales | Templates

9 Free Sales Forecast Template Options for Small Business

Published March 7, 2023

Published Mar 7, 2023

REVIEWED BY: Jess Pingrey

WRITTEN BY: Jillian Ilao

This article is part of a larger series on Sales Management .

• 1 Simple Sales Forecast Template
• 2 Long-term Sales Forecast Template
• 3 Budget Sales Forecast Template
• 4 Month-to-month Sales Forecast Template
• 5 Individual Product Sales Forecast Template
• 6 Multi-product Sales Forecast Template
• 7 Retail Sales Forecast Template
• 8 Subscription-based Sales Forecast Template
• 9 B2B Lead Sales Forecast Template
• 10 CRMs with Built-in Sales Forecasting
• 11 Frequently Asked Questions (FAQ)
• 12 Bottom Line

Using a sales forecast, business owners can create realistic projections about incoming revenue and business performance based on their current data and how they have performed in the past. Sales forecasts may cover weekly, monthly, annual, and multi-annual projections, and can be done using Google Sheets or Excel templates, as well as through customer relationship management (CRM) software.

We’ve compiled nine free sales projection templates you can download. Each downloadable file contains an example forecast you can use as a reference. We also included a blank template you can copy and fill in with your own sales data.

Did you know? Sales forecasts create projections you can use for things like goal setting, performance measurement, budgeting, projecting growth, obtaining financing, and attracting investors. This is why it is important to use software tools or a CRM system that gives you realistic, data-driven forecasts.

1. Simple Sales Forecast Template

Our free simple sales forecast template will help you get started with sales estimates to plan and grow your business. You can modify this multi-year projection sheet in either Google Sheets or Excel. It can also generate future revenue estimates based on units sold, pipeline growth percentages, lead conversion rates, and your product pricing. This gives you an idea of how much your business can grow sales-wise in the next few years.

Sales projection template for multiple years

FILE TO DOWNLOAD OR INTEGRATE

FREE Sales Forecasting Template - One-Year

Thank you for downloading!

FREE Sales Forecasting Template - Multi-Year

2. Long-term Sales Projection Forecast

Part of creating a sales plan is forecasting long-term revenue goals and sales projections, then laying out the strategies and tactics you’ll use to hit your performance goals. Long-term sales projection templates usually provide three- to five-year projections. These templates are accessible in both Excel and Google Sheets.

Long-term sales prediction templates are best for businesses looking to scale and want insights about how much working capital they can expect to be able to tap into for growth initiatives. This type of sales projection template is also often required when applying for commercial loans or through other channels such as outside investors or crowdfunding.

Three-year forecast template

Projection of units sold and gross profit from a three-year forecast template

Three-year projection of units sold

FREE 3-Year Forecast Template

FREE 5-Year Forecast Template

3. Budget Sales Projection Template

A budget sales forecast template shows expense estimates in relation to revenue, allowing you to calculate how much you can spend during a specified period. Budget templates will enable you to enter income projections and available cash to indicate your spending capabilities for that time frame.

This type of template is best for new and growing businesses trying to figure out their future available expenditures. Additionally, businesses interested in making a large asset purchase, such as a company vehicle, piece of equipment, or commercial real estate, can use this template to see how much of the asset can be self-financed.

Budget forecast template example

Budget forecast template for services example

FREE Budget Sales Forecast Template

4. Month-to-Month Sales Forecast Template

The month-to-month (or monthly) sales projection template shows sales projections for a year divided into monthly increments. This type of revenue forecast template makes it easier to estimate your incoming revenue. This is because you can break down your pricing model, such as the average number of units sold, on a monthly rather than an annual basis.

This monthly sales projection example is best for seasonal businesses that experience significant revenue fluctuations in some months compared to others. It’s also appropriate for businesses that want to view rolling 12-month projections as a key performance indicator (KPI). You can also use it to project one-year sales estimates before implementing major campaigns or initiatives, such as a growth strategy.

Month-to-month forecast template example

FREE Month-to-Month Forecast Template

5. Individual Product Sales Forecast Template

An individual product sales projection template can be used by businesses that sell one product or service or for projecting sales of a new (or any single) product or service. This forecast indicates how you expect the product to perform based on units sold and the price per unit monthly.

An individual product forecast template benefits businesses that sell products through a storefront or ecommerce medium. It helps businesses that are adding a new product to their arsenal in estimating sales exclusively for that product. It is also recommended for companies that need to track individual performance for the most popular or profitable products.

Individual product forecast template example

FREE Individual Product Forecast Template

6. Multi-product Sales Forecast Template

Use this revenue projection template to generate sales projections if your business sells multiple products. Through this type of template, you can compare the estimated performance of specific products by tracking the units sold and the price per unit. In turn, this will yield a total sales revenue estimate.

The multi-product forecasting template is best for retail or wholesale businesses selling various products. You can also use it to project the revenue of multiple product categories. Here, each “item” represents a category rather than an individual product, and the price per unit is calculated in aggregate.

Multi-product sales forecast template example

FREE Multi-product Forecast Template

7. Retail Sales Forecast Template

A retail sales projection template forecasts revenue for brick-and-mortar stores since it includes data related to foot traffic. The retail sales template calculates projected revenue by year based on foot traffic, the percentage of foot traffic that enters the store, and the scale of conversions or those who make a purchase. Since it has a field for “other revenue,” it can be used by retail stores selling online.

This business forecast template is mostly designed for brick-and-mortar retail businesses. However, a combination of ecommerce and brick-and-mortar businesses, as well as ecommerce operations, can also use this forecast template. The estimated customers passing store data fields can be replaced with website traffic to convert this sales forecast Excel sheet into an ecommerce sales forecasting template.

Retail forecast template example

FREE Retail Forecast Template

8. Subscription-based Sales Forecasting Template

Businesses relying on recurring revenue from sign-ups or contract renewals should use the subscription-based sales prediction spreadsheet. Enter data into the visitor and sign-up fields to show the visitor-to-sign-up conversion rate. Then, enter the number of new customers to show the percentage of sign-ups that convert to paying customers.

This business projection template also helps you track customer churn. It calculates your churn and retention rate based on the number of paying customers at the end of the period compared to the number at the beginning, plus the number of new customers added. Knowing your churn rate is essential since a high or increasing rate of customer turnover could indicate problems with your organization or its products or services.

How to Calculate Churn Rate:

To manually calculate churn rate, divide the number of lost customers by the total customers at the start of the time period, then multiply the result by 100. For example, if your business had 200 customers at the beginning of January and lost 12 customers by the end, you would divide 12 by 200. The answer is 0.06. Then, multiply that by 100, giving you a 6% monthly churn rate.

Churn Rate Calculator

Manual calculation of monthly customer churn rate

The fields of this template can be altered for use by contract renewal businesses like insurance agencies, information technology (IT) companies, and payroll processors. For example, subscribers can be replaced with “leads,” and new subscribers can be replaced with “presentations,” “free trials,” or “demos.” Then, change the churn rate to “non-renewed contracts” to estimate new and recurring business revenue year-to-year.

Subscription-based forecast template example

FREE Subscription-based Forecast Template

9. B2B Lead Sales Forecast Template

A business-to-business (B2B) lead forecast template estimates sales revenue from current deal opportunities in the sales pipeline through business leads. Businesses can use estimated deal values and the percent chance of closing those deals to obtain a sales projection.

This revenue projection template is best for B2B organizations, aka businesses selling to other businesses or organizations, rather than business-to-consumer (B2C) organizations. It can also be used for direct sales prospecting activities and for businesses that submit business proposals in response to solicitation requests.

FREE B2B Lead Forecast Template

CRMs With Built-in Sales Forecasting Features

Sales forecast sample templates are easy to modify. However, customer relationship management (CRM) systems generally offer more robust tools for managing revenue opportunities that can be converted into sales forecasts. They are valuable tools for providing sales predictions on premade charts through the data collected in the system. Below are examples of CRM platforms that could double as great sales forecasting software :

• HubSpot CRM

HubSpot CRM can instantly create revenue projections or automatically produce these reports for you monthly or quarterly at no additional cost, saving you time and helping your business stay on track.

Users can easily generate sales prediction reports on HubSpot with their historical data. (Source: HubSpot )

Starting price: Free for unlimited users or $45 per month (annual billing) for two users

Visit HubSpot

Pipedrive can take information such as potential deal value and probability of closing for a lead or opportunity to provide sales estimates in highly customizable templates.

Pipedrive weighted deal forecasting (Source: Pipedrive )

Starting price: $14.90 per user, per month (annual billing)

Visit Pipedrive

Zoho CRM provides sales forecasting through its native integration with Zoho Analytics, which analyzes and visualizes the data. Users can customize their forecasts by viewing them on different visual channels, including line, bar, and scatter charts.

Zoho Analytics sales prediction (Source: Zoho )

Starting price: Free for three users or $14 per user, per month (annual billing)

Providing the right tools for your sales team to organize leads, communicate with prospects, and analyze sales data is crucial for streamlining a sales operation, one of many responsibilities of a sales manager. Other insights for managing your sales team can be found in our ultimate guide to sales management .

Visit Zoho CRM

Frequently Asked Questions (FAQ)

Why is sales forecasting essential.

Sales forecasting provides a clear picture of your anticipated sales performance based on the number of opportunities in your pipeline and the industry that your business operates in. Having visibility will help you plan your business correctly—especially when the forecast is downward, and you need to scout for new opportunities to meet your sales targets.

What is a sales forecast template?

A sales forecast template is a predesigned spreadsheet that allows businesses to project their future sales revenue for a specific period. It is typically based on historical sales data figures and market trends. It also includes various factors that may potentially affect future sales performance, such as new product launches, seasonality, economic conditions, and changes in consumer behavior.

Bottom Line

Business forecast spreadsheets are available in both Excel and Google Sheets templates as well as other premade templates you can download, customize, and use. You may also take advantage of CRM features that organize, estimate, and visualize your company’s sales information, including sales predictions.

A CRM can save sales reps time in making projections as well as optimize your sales pipeline to generate leads and close more deals. We highly recommend CRMs such as HubSpot CRM , Pipedrive , and Zoho CRM , which all provide excellent sales forecasting features on top of robust sales management and lead nurturing tools.

About the Author

Jillian Ilao

Jill is a sales and customer service expert at Fit Small Business. Prior to joining the company, she has worked and produced marketing content for various small businesses and entrepreneurs from different markets, including Australia, the United Kingdom, the United States, and Singapore. She has extensive writing experience and has covered topics on business, lifestyle, finance, education, and technology.

Join Fit Small Business

Sign up to receive more well-researched small business articles and topics in your inbox, personalized for you. Select the newsletters you’re interested in below.

• Product overview
• All features
• App integrations

CAPABILITIES

• project icon Project management
• Project views
• Custom fields
• Status updates
• goal icon Goals and reporting
• Reporting dashboards
• workflow icon Workflows and automation
• portfolio icon Resource management
• Time tracking
• my-task icon Admin and security
• Admin console
• asana-intelligence icon Asana Intelligence
• list icon Personal
• premium icon Starter
• briefcase icon Advanced
• Goal management
• Organizational planning
• Campaign management
• Creative production
• Marketing strategic planning
• Request tracking
• Resource planning
• Project intake
• View all uses arrow-right icon
• Project plans
• Team goals & objectives
• Team continuity
• Meeting agenda
• View all templates arrow-right icon
• Work management resources Discover best practices, watch webinars, get insights
• What's new Learn about the latest and greatest from Asana
• Customer stories See how the world's best organizations drive work innovation with Asana
• Help Center Get lots of tips, tricks, and advice to get the most from Asana
• Asana Academy Sign up for interactive courses and webinars to learn Asana
• Developers Learn more about building apps on the Asana platform
• Community programs Connect with and learn from Asana customers around the world
• Events Find out about upcoming events near you
• Partners Learn more about our partner programs
• Support Need help? Contact the Asana support team
• Asana for nonprofits Get more information on our nonprofit discount program, and apply.

Featured Reads

• Business strategy |
• Sales forecasting: How to create a sale ...

Sales forecasting: How to create a sales forecast template (with examples)

A strong sales team is the key to success for most companies. They say a good salesperson can sell sand at the beach, but whether you’re selling products in the Caribbean or Antarctica, it all comes down to strategy. When you’re unsure if your current strategy is working, a sales forecast can help.

What is a sales forecast?

A sales forecast predicts future sales revenue using past business data. Your sales forecast can predict a number of different things, including the number of new sales for an existing product, the new customers you’ll gain, or the memberships you’ll sell in a given time period. These forecasts are then used during project planning to determine how much you should allocate towards new products and services. 

Why is sales forecasting important?

Sales forecasting helps you keep a finger on your business’s pulse. It sets the ground rules for a variety of business operations, including your sales strategy and project planning. Once you calculate your sales projections, you can use the results to assess your business health, predict cash flow, and adjust your plans accordingly.

An effective sales forecasting plan:

Predicts demand: When you have an idea of how many units you may sell, you can get a head start on production.

Helps you make smart investments: If you have future goals of expanding your business with new locations or products, knowing when you’ll have the income to do so is important. 

Contributes to goal setting: Your sales forecast can help you set goals outside of investments as well, like outshining competitors or hiring new team members.

Guides spending: Your sales forecast may be the wake-up call you need to set a budget and use cost control to reduce expenses.

Improves the sales process: You can change your current sales process based on the sales projections you’re unhappy with.

Highlights financial problems: Your sales forecast template will open your eyes to problem areas you may not have noticed otherwise. 

Helps with resource management: Do you have the resources you need to fill orders if it’s an accurate sales forecast? Your sales forecast can guide how you allocate and manage resources to hit targets.

When you have an accurate prediction of your future sales, you can use your projections to adjust your current sales process.

Sales forecasting methods

Sales forecasting is an important part of strategic business planning because it enables sales managers and teams to predict future sales and make informed decisions. But why are there multiple sales forecasting methods? Simply put, businesses vary in size, industry, and market dynamics, so no single methodology suits all.

Choosing the right sales forecasting method is more of an art than a science. It involves:

Analyzing your business size and industry

Assessing the available data and tools

Understanding your sales cycle's complexity

A few telltale signs that you've picked the correct approach include:

Improved accuracy in sales target predictions

Enhanced understanding of market trends

Better alignment with your business goals

Opportunity stage forecasting

Opportunity stage forecasting is a dynamic approach ideal for businesses using CRM systems like Salesforce. It assesses the likelihood of sales closing based on the stages of the sales pipeline. This method is particularly beneficial for sales organizations with a clearly defined sales process.

For example, a software company might use this method to forecast sales by examining the number of prospects in each stage of their funnel, from initial contact to final negotiation.

Pipeline forecasting method

The pipeline forecasting method is similar to opportunity stage forecasting but focuses more on the volume and quality of leads at each pipeline stage. It's particularly useful for businesses that rely heavily on sales forecasting tools and dashboards for decision-making.

A real estate agency could use it by examining the number of properties listed, the stage of negotiations, and the number of closings forecasted in the pipeline.

Length of sales cycle forecasting

Small businesses often prefer the length of sales cycle forecasting. It's straightforward and involves analyzing the duration of past sales cycles to predict future ones. This method is effective for businesses with consistent sales cycle lengths.

A furniture manufacturer, for instance, might use this method by analyzing the average time taken from initial customer contact to closing a sale in the past year.

Intuitive forecasting

Intuitive forecasting relies on the expertise and intuition of sales managers and their teams. It's less about spreadsheets and more about market research and understanding customer behavior. This method is often used with other, more data-driven approaches.

A boutique fashion store, for example, might use this method, relying on the owner's deep understanding of fashion trends and customer preferences.

Historical forecasting

Historical forecasting uses past performance data to predict future sales. This method is advantageous for businesses with ample historical sales data. It's less effective for new markets or rapidly changing industries.

An established book retailer could use historical data from previous years, considering seasonal trends and past marketing campaigns, to forecast next quarter's sales.

Multivariable analysis forecasting

Multivariable analysis forecasting is a more sophisticated method that's ideal for larger sales organizations. It analyzes factors like market trends, economic conditions, and marketing efforts to provide a holistic view of potential sales outcomes.

An automotive company, for example, could analyze factors like economic conditions, competitor activity, and past sales data to forecast future car sales.

How to calculate sales forecast

Sales forecasts determine how much you expect to do in sales for a given time frame. For example, let’s say you expect to sell 100 units in Q1 of fiscal year 2024. To calculate sales forecasts, you’ll use past data to predict future trends. 

When you’re first creating a forecast, it’s important to establish benchmarks that determine how much you normally sell of any given product to how many people. Compare historical sales data against sales quotas—i.e., how much you sold vs. how much you expected to sell. This type of analysis can help you set a baseline for what you expect to achieve every week, month, quarter, and so on.

For many companies, this means establishing a formula. The exact inputs will vary based on your products or services, but generally, you can use the following:

Sales forecast = Number of products you expect to sell x The value of each product

For example, if you sell SaaS products, your sales forecast might look something like this: 

SaaS FY24 Sales forecast = Number of expected subscribers x Subscription price

Ultimately, the sales forecasting process is a guess—but it’s an educated one. You’ll use the information you already have to create a data-driven forecasting model. How accurate your forecast is depends on your sales team. The sales team uses facts such as their prospects, current market conditions, and their sales pipeline. But they will also use their experience in the field to decide on final numbers for what they think will sell. Because of this, sales leaders are more likely to have better forecasting accuracy than new members of the sales team.

Sales forecast vs. sales goal

Your sales forecast is based on historical data and current market conditions. While you always hope your sales goals are attainable—and you can use data to estimate what your team is capable of—your goals might not line up directly with your forecast. This can be for a number of reasons, including wanting to create stretch goals that push your sales team beyond what they’ve done in the past or big, pie-in-the-sky goals that boost investor confidence.

How to create a sales forecast

There are different sales forecasting methods, and some are simpler than others. With the steps below, you’ll have a basic understanding of how to create a sales forecast template that you can customize to the method of your choice. 

1. Track your business data

Without details from your past sales, you won’t have anything to base your predictions on. If you don’t have past sales data, you can begin tracking sales now to create a sales forecast in the future. The data you’ll need to track includes:

Number of units sold per month

Revenue of each product by month

Number of units returned or canceled (so you can get an accurate sales calculation)

Other items you can track to make your predictions more accurate include:

Growth percentage

Number of sales representatives

Average sales cycle length

There are different ways to use these data points when forecasting sales. If you want to calculate your sales run rate, which is your projected revenue for the next year, use your revenue from the past month and multiply it by 12. Then, adjust this number based on other relevant data points, like seasonality.

Tip: The best way to track historical data is to use customer relationship management (CRM) software. When you have a CRM strategy in place, you can easily pull data into your sales forecast template and make quick projections.

2. Set your metrics

Before you perform the calculations in your sales forecast template, you need to decide what you’re measuring. The basic questions you should ask are:

What is the product or service you’re selling and forecasting for? Answering this question helps you decide what exactly you’re evaluating. For example, you can investigate future trends for a long-standing product to decide whether it’s worth continuing, or you can predict future sales for a new product. 

How far in the future do you want to make projections? You can decide to make projections for as little as six months or as much as five years in the future. The complexity of your sales forecast is up to you.

How much will you sell each product for, and how do you measure your products? Set your product’s metrics, whether they be units, hours, memberships, or something else. That way, you can calculate revenue on a price-per-unit basis.

How long is your sales cycle? Your sales cycle—also called a sales funnel—is how long it takes for you to make the average sale from beginning to end. Sales cycles are often monthly, quarterly, or yearly. Depending on the product you’re selling, your sales cycle may be unique. Steps in the sales cycle typically include:

Lead generation

Lead qualification

Initial contact

Making an offer

Negotiation

Closing the deal

Tip: You can still project customer growth versus revenue even if your company is in its early phases. If you don’t have enough historical data to use for your sales forecast template, you can use data from a company similar to yours in the market. 

3. Choose a forecasting method

While there are many forecasting methods to choose from, we’ll concentrate on two straightforward approaches to provide a clear understanding of how sales forecasting can be implemented efficiently. The top-down method starts with the total size of the market and works down, while the bottom-up method starts with your business and expands out.

Top-down method: To use the top-down method, start with the total size of the market—or total addressable market (TAM). Then, estimate how much of the market you think your business can capture. For example, if you’re in a large, oversaturated market, you may only capture 3% of the TAM. If the total addressable market is $1 billion, your projected annual sales would be $30 million. 

Bottom-up method: With the bottom-up method, you’ll estimate the total units your company will sell in a sales cycle, then multiply that number by your average cost per unit. You can expand out by adding other variables, like the number of sales reps, department expenses, or website views. The bottom-up forecasting method uses company data to project more specific results. 

You’ll need to choose one method to fill in your sales forecast template, but you can also try both methods to compare results.

Tip: The best forecasting method for you may depend on what type of business you’re running. If your company experiences little fluctuation in revenue, then the top-down forecasting method should work well. The top-down model can also work for new businesses that have little business data to work with. Bottom-up forecasting may be better for seasonal businesses or startups looking to make future budget and staffing decisions.

4. Calculate your sales forecast

You’ve already learned a basic way to calculate revenue using the top-down method. Below, you’ll see another way to estimate your projected sales revenue on an annual scale.

Divide your sales revenue for the year so far by the number of months so far to calculate your average monthly sales rate.

Multiply your average monthly sales rate by the number of months left in the year to calculate your projected sales revenue for the rest of the year.

Add your total sales revenue so far to your projected sales revenue for the rest of the year to calculate your annual sales forecast.

A more generalized way to estimate your future sales revenue for the year is to multiply your total sales revenue from the previous year.

Example: Let’s say your company sells a software application for $300 per unit and you sold 500 units from January to March. Your sales revenue so far is $150,000 ($300 per unit x 500 units sold). You’re three months into the calendar year, so your average monthly sales rate is $50,000 ($150,000 / 3 months). That means your projected sales revenue for the rest of the year is $450,000 ($50,000 x 9 months).

5. Adjust for external factors

A sales forecast predicts future revenue by making assumptions about your growth rate based on past success. But your past success is only one component of your growth rate. There are external factors outside of your control that can affect sales growth—and you should consider them if you want to make accurate projections. 

Some external factors you can adjust your calculations around include:

Inflation rate: Inflation is how much prices increase over a specific time period, and it usually fluctuates based on a country’s overall economic state. You can take your annual sales forecast and factor in inflation rate to ensure you’re not projecting a higher or lower number of sales than the economy will permit.

The competition: Is your market becoming more competitive as time goes on? For example, are you selling software during a tech boom? If so, assess whether your market share will shrink because of rising competition in the coming year(s).

Market changes: The market can shift as people change their behavior. Your audience may spend an average of six hours per day on their phones in one year. In the next year, mental health awareness may cause phone usage to drop. These changes are hard to predict, so you must stay on top of market news.

Industry changes: Industry changes happen when new products and technologies come on the market and make other products obsolete. One instance of this is the invention of AI technology.

Legislation: Although not as common, changes in legislation can affect the way companies sell their products. For example, vaping was a multi-million dollar industry until laws banned the sale of vape products to people under the age of 21. 

Seasonality: Many industries experience seasonality based on how human behavior and human needs change with the seasons. For example, people spend more time inside during the winter, so they may be on their computers more. Retail stores may also experience a jump in sales around Christmas time.

Tip: You can create a comprehensive sales plan to set goals for team members. Aside from revenue targets and training milestones, consider assigning each of these external factors to your team members so they can keep track of essential information. That way, you’ll have your bases covered on anything that may affect future sales growth. 

Sales forecast template

Below you’ll see an example of a software company’s six-month sales forecast template for two products. Product one is a software application, and product two is a software accessory. 

In this sales forecast template, the company used past sales data to fill in each month. They projected their sales would increase by 10% each month because of a 5% increase in inflation and because they gained 5% more of the market. They kept their price per unit the same as the previous year.

Putting both products in the same chart can help the company see that their lower-cost product—the software accessory—brings in more revenue than their higher-cost product. The company can then use this insight to create more low-cost products in the future.

Sales forecast examples

Sales forecasting is not a one-size-fits-all process. It varies significantly across industries and business sizes. Understanding this through practical examples can help businesses identify the most suitable forecasting method for their unique needs.

Sales forecasting example 1: E-commerce

In the e-commerce sector, where trends can shift rapidly, intuitive forecasting is often useful for making quick, informed decisions.

Scenario: An e-commerce retailer specializing in fashion accessories is planning for the upcoming festive season.

Trend analysis phase: The team spends the first week analyzing customer feedback and current fashion trends on social media, using intuitive forecasting to predict which products will be popular.

Inventory planning phase: Based on these insights, the next three weeks are dedicated to selecting and ordering inventory, focusing on products predicted to be in high demand.

Sales monitoring and adjustment: As the holiday season approaches, the team closely monitors early sales data, ready to adjust their inventory and marketing strategies based on real-time sales performance.

This approach allows the e-commerce retailer to stay agile , adapting quickly to market trends and customer preferences.

Sales forecasting example 2: Software development

For a software development company, especially one working with B2B clients, opportunity stage forecasting can help predict sales and manage the sales pipeline effectively.

Scenario: A software development company is launching a new project management tool.

Lead generation and qualification phase: In the initial month, the sales team focuses on generating leads, qualifying them, and categorizing potential clients based on their progress through the sales pipeline.

Proposal and negotiation phase: For the next two months, the team works on creating tailored proposals for high-potential leads and enters negotiation stages, using opportunity stage forecasting to predict the likelihood of deal closures.

Closure and review: In the final phase, the team aims to close deals, review the accuracy of their initial forecasts, and refine their approach based on the outcomes.

Opportunity stage forecasting enables the software company to efficiently manage its sales pipeline , focusing resources on the most promising leads and improving their chances of successful deal closures.

Pair your sales forecast with a strong sales process

A sales forecast is only one part of the larger sales picture. As your team members acquire leads and close deals, you can track them through the sales pipeline. A solid sales plan is the foundation of future success.  

Related resources

Grant management: A nonprofit’s guide

How Asana uses work management to optimize resource planning

How Asana uses work management for organizational planning

Solve your tech overload with an intelligent transformation

How to Create a Profit and Loss Forecast

Angelique O'Rourke

7 min. read

Updated May 10, 2024

An income statement, also called a profit and loss statement (or P&L), is a fundamental tool for understanding how the revenue and expenses of your business stack up.

Simply put, it tells anyone at-a-glance if your business is profitable or not. Typically, an income statement is a list of revenue and expenses, with the company’s net profit listed at the end (check out the  section on income statement examples below  to see what it looks like). 

Have you ever heard someone refer to a company’s “bottom line”? They’re talking about the last line in an income statement, the one that tells a reader the net profit of a company, or how profitable the company is over a given period of time (usually quarterly or annually) after all expenses have been accounted for.

This is the “profit” referred to when people say “profit and loss statement,” or what the “p” stands for in “P & L.” The “loss” is what happens when your expenses exceed your revenue; when a company is not profitable and therefore running at a loss.

As you read on, keep in mind that cash and profits aren’t the same thing. For more on how they’re different,  check out this article .

What’s included in an income statement?

The top line of your profit and loss statement will be the money that you have coming in, or your revenue from sales. This number should be your initial revenue from sales without any deductions.

The top line of your income statement is really just as important as the bottom line; all of the direct costs and expenses will be taken out of this beginning number. The smaller it is, the smaller the expenses have to be if you’re going to stay in the black.

If you’re  writing a business plan  document and don’t yet have money coming in, you might be wondering how you would arrive at a sales number for a financial forecast. It’s normal for the financials of a business plan to be your best educated guess at what the next few years of numbers will be. No one can predict the future, but you can make a reasonable plan.

Check out this article about forecasting sales  for more information.

Direct costs

Direct costs, also referred to as the cost of goods sold, or COGS, is just what it sounds like: How much does it cost you to make the product or deliver the service related to that sale? You wouldn’t include items such as rent for an office space in this area, but the things that directly contribute to the product you sell.

For example, to a bookstore, the direct cost of sales is what the store paid for the books it sold; but to a publisher, its direct costs include authors’ royalties, printing, paper, and ink. A manufacturer’s direct costs include materials and labor. A reseller’s direct costs are what the reseller paid to purchase the products it’s selling.

If you only sell services, it’s possible that you have no direct costs or very low direct costs as a percentage of sales; but even accountants and attorneys have subcontractors, research, and photocopying that can be included in direct costs.

Here’s a simple rule of thumb to distinguish between direct costs and regular expenses: If you pay for something, regardless of whether you make 1 sale or 100 sales, that’s a regular expense. Think salaries, utilities, insurance, and rent. If you only pay for something when you make a sale, that’s a direct cost. Think inventory and paper reports you deliver to clients.

Brought to you by

Create a professional business plan

Using ai and step-by-step instructions.

Secure funding

Validate ideas

Build a strategy

Gross margin

Gross margin is also referred to as gross profit. This number refers to the difference between the revenue and direct costs on your income statement.

Revenue – Direct Costs = Gross Margin

This number is very important because it conveys two critical pieces of information: 1.) how much of your revenue is being funneled into direct costs (the smaller the number, the better), and 2.) how much you have left over for all of the company’s other expenses. If the number after direct costs is smaller than the total of your operating expenses, you’ll know immediately that you’re not profitable.

Operating expenses

Operating expenses are where you list all of your regular expenses as line items, excluding your costs of goods sold.

So, you have to take stock of everything else your company pays for to keep the doors open: rent, payroll, utilities, marketing—include all of those fixed expenses here.

Remember that each individual purchase doesn’t need its own line item. For ease of reading, it’s better to group things together into categories of expenses—for example, office supplies, or advertising costs.

Operating income

Operating income is also referred to as EBITDA, or earnings before interest, taxes, depreciation, and amortization. You calculate your operating income by subtracting your total operating expenses from your gross margin.

Gross Margin – Operating Expenses = Operating Income

Operating income is considered the most reliable number reflecting a company’s profitability. As such, this is a line item to keep your eye on, especially if you’re  presenting to investors . Is it a number that inspires confidence?

This is fairly straightforward—here you would include any interest payments that the company is making on its loans. If this doesn’t apply to you, skip it.

Depreciation and amortization

These are non-cash expenses associated with your assets, both tangible and intangible. Depreciation is an accounting concept based on the idea that over time, a tangible asset, like a car or piece of machinery, loses its value, or depreciates. After several years, the asset will be worth less and you record that change in value as an expense on your P&L.

With intangible assets, you’ll use a concept called amortization to write off their cost over time. An example here would be a copyright or patent that your business might purchase from another company. If the patent lasts for 20 years and it cost your company $1 million to purchase the patent, you would then expense 1/20th of the cost every year for the life of the patent. This expense for an intangible asset would be included in the amortization row of the income statement.

This will reflect the income tax amount that has been paid, or the amount that you expect to pay, depending on whether you are recording planned or actual values. Some companies  set aside an estimated amount of money  to cover this expected expense.

Total expenses

Total expenses is exactly what it sounds like: it’s the total of all of your expenses, including interest, taxes, depreciation, and amortization.

The simplest way to calculate your total expenses is to just take your direct costs, add operating expenses, and then add the additional expenses of interest, taxes, depreciation, and amortization:

Total Expenses = Direct Costs + Operating Expenses + Interest + Taxes + Depreciation + Amortization

Net profit, also referred to as net income or net earnings, is the proverbial bottom line. This is the at-a-glance factor that will determine the answer to the question, are you in the red? You calculate net profit by subtracting total expenses from revenue:

Net Profit = Revenue – Total Expenses

Remember that this number started at the top line, with your revenue from sales. Then everything else was taken out of that initial sum. If this number is negative, you’ll know that you’re running at a loss. Either your expenses are too high, you’re revenue is in a slump, or both—and it might be time to reevaluate strategy.

• Income statement examples

Because the terminology surrounding income statements is variable and all businesses are different, not all of them will look exactly the same, but the core information of revenue minus all expenses (including direct costs) equals profit will be present in each one.

Here is an income statement from Nike, to give you a general idea:

An  income statement from Nike .

As you can see, while Nike uses a variety of terms to explain what their expenses are and name each line item as clearly as possible, the takeaway is still the bottom line, their net income.

See why 1.2 million entrepreneurs have written their business plans with LivePlan

Angelique is a skilled writer, editor, and social media specialist, as well as an actor and model with a demonstrated history of theater, film, commercial and print work.

Table of Contents

• What’s included in an income statement?

Related Articles

9 Min. Read

How to Create a Cash Flow Forecast

10 Min. Read

What Is a Balance Sheet? Definition, Formulas, and Example

3 Min. Read

What Is a Break-Even Analysis?

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

Salesforce is closed for new business in your area.

Free Marketing Plan Examples: Real-World Samples & Templates

By Joe Weller | April 27, 2024

• Share on Facebook
• Share on LinkedIn

Link copied

A  marketing plan  is a comprehensive document that outlines a company’s marketing strategy and tactics, and ensures that its marketing goals align with its overall objectives. Effective marketing plans include detailed analysis of the market along with roadmaps for upcoming campaigns. Inside this article, you’ll find the  elements of a marketing plan , 10 real-world examples of marketing plans with commentary from experienced marketing professionals, free marketing plan templates and samples , and a  chart to help you determine which template suits your needs .

Marketing Plan Elements

Typical marketing plans begin with an executive summary and include audience demographics, company objectives, situational analysis of the business, and marketing strategies and tactics. Market research and analysis provide campaign direction, and the budget and timeline offer practical parameters. A marketing plan can provide an overview of all strategies and campaigns to be executed in a certain time frame, or it can focus on a specific product, channel, or strategy. The level of detail and the sections included might vary, depending on the organization’s needs. The nine main elements of a marketing plan are:  

Executive Summary and Mission Statement:  A concise, high-level summary conveys the purpose of your marketing plan, introduces key strategies and research insights, and highlights the most important takeaways for stakeholders. For example, an executive summary might outline your brand’s identity, its place within the competitive landscape, and the major opportunities that upcoming marketing campaigns will target. Longer plans might include a separate mission statement or vision statement to align marketing efforts with your company’s larger goals. Discover more  examples of executive summaries with templates to help you write one effectively.  

Situational Analysis:  One of the most crucial elements of your marketing plan, a situational analysis is an assessment of the internal and external factors affecting a business’s performance. It should include research-based insights into market trends and dynamics, customer demographics and pain points, and internal resources.  A strong situational analysis often includes a SWOT (strengths, weaknesses, opportunities, threats) analysis, which provides a foundation for an effective marketing strategy. Learn more about  how to perform a SWOT analysis .  

Competitive Analysis:  Understanding the competition is key to developing a compelling marketing plan. This analysis should consider recent marketing campaigns from similar brands to identify successful ways to reach a shared target audience. Being aware of the competitive landscape can also help your business develop a unique selling proposition and stand out in the market. The competitive analysis might be included in the larger situational analysis, or it might be a stand-alone section. For example, a marketing plan could include data on how competitors rank on keywords, or it could evaluate the performance of competitors’ recent social media campaigns. One common framework for understanding market dynamics is a Porter’s five forces analysis, which identifies the forces that contribute to industry rivals. Learn how to evaluate the competitive landscape with  free industry analysis templates .  

Target Audience: In order to implement marketing strategies that engage consumers and drive conversions, businesses need to know who their audience is, what they want, and how they behave. A marketing plan should define a specific, segmented target audience with demographic, geographical, psychographic, and behavioral data.  This section often includes customer profiles or buyer personas — fictionalized representations of ideal customers or audience segments — which help marketers typify consumer behaviors. These profiles should include media habits and most-used platforms to ensure that your marketing plan selects the right channels for each campaign. Learn how to analyze your target market with  free customer profile templates .  

Goals and Objectives:  Marketing plans typically include both long-term goals, which provide broad direction for the company’s marketing strategy, and short-term objectives, which focus on more immediate tactics and campaigns. Goals should be SMART (specific, measurable, achievable, relevant, time-bound) and include corresponding key performance indicators (KPIs).  The goals and objectives in a marketing plan often focus on conversions, market share, brand awareness, or engagement. Clearly defined goals ensure strategically aligned marketing initiatives with measurable results. Take a look at  real-world examples of SMART goals for more insights.  

Marketing Strategy:  This section of a marketing plan details the business’s unique value proposition and the channels that will communicate it. A robust marketing strategy addresses the touchpoints in a consumer’s buying cycle and breaks down the 4 Ps (product, price, place, promotion) of the marketing mix. Channels might include digital marketing, advertisements, social media, and influencer partnerships. To develop an overarching marketing strategy, consider using a  marketing strategy template . To learn more about the 4 Ps, read this  product marketing guide .  

Tactics and Action Plan:  A marketing plan is not an abstract strategy document, but a concrete roadmap for executing specific campaigns with specific tactics. Your plan should detail the messaging for each campaign and the corresponding methods for communication — such as email newsletters, social content, targeted ads, and public relations.  This section provides KPIs and actionable steps such as resource allocation, deliverables, and distribution plans. It might also include the expected outcome for each campaign. To plan individual campaigns, consider using a  marketing project plan template .  

Budget:  Marketing expenses might include the cost of advertising, content creation, website maintenance, or promotional materials; no marketing plan is complete without a budget that breaks down the costs of such initiatives. A clear, comprehensive budget ensures that marketing efforts are financially feasible and resources can be allocated for maximum impact. The budget also enables the marketing team to track the return on investment (ROI) of each campaign. To create a comprehensive budget, try our  free marketing budget templates .    

Timeline:  Finally, a marketing plan includes a clear schedule for implementing its initiatives and tactics. This timeline details the start and end dates of each campaign, deadlines for deliverables, and key events or milestones. It keeps the marketing team aligned and initiatives on track, ensuring that marketing objectives can be achieved within the set time frame. Organize dates and deadlines with the help of a  marketing timeline template .  

Marketing Plan Examples

Real-world marketing plans show how businesses utilize effective planning documents. These 10 examples from various industries exhibit unique strengths and weaknesses. With insightful commentary from marketing experts, these plans offer practical takeaways any marketer can use.  

Delmarva and the Ground for Change This  in-depth marketing plan for a documentary produced by the USDA Northeast Climate Hub includes audience profiles, competitive analysis, and a distribution plan. Along with a detailed breakdown of its digital marketing strategy, it considers how different tactics will affect the viewer’s content journey.   

John Dinsmore , a marketing consultant and professor at Wright State University, praises this plan for its attractive design and thoughtful, thorough content: “They do a nice job of extrapolating on who the target market is and tying their tactics to achieving specific goals.”  He appreciates the inclusion of a SWOT analysis, but feels it could be done more effectively. “‘Opportunities’ is not a place for business ideas. It’s a place to identify external, positive trends that can help your initiative. In this context, an opportunity could be ‘Rising concern for and awareness of climate issues.’ Similarly, ‘threats’ is not a place to list things that are difficult. It’s for negative external trends such as ‘Increased skepticism over ability to combat climate change.’” 

Dekker Fraser , former Global Marketing Manager at Sony PlayStation, adds that this plan includes a strong focus on collaborations with media and influencers: “Many marketing plans place too much emphasis on target customers and not enough on target collaborators.”  

Minnesota Tourism This  marketing plan by Explore Minnesota , the state’s Department of Tourism, showcases Minnesota’s beauty with vivid imagery. It uses a variety of demographic information to identify priority audience segments and includes well-designed infographics that analyze audience and competition. As a result, the campaigns are clearly targeted at specific audiences and objectives. 

John Rarrick , Head of Marketing at Movius Corp., admires the strength of the message behind the strategy. “This plan has a very well-developed ‘why,’” he says. “You’ll see that often when the plan is to repair or save something that has undergone a time of great loss — such as a loss of revenue or reputation. The audience personas, goals, tactics, and budget are all detailed and measurable.” 

Gold Coast Transit District  

A  short, high-level marketing plan for Gold Coast Transit highlights key campaigns and includes the most important details, such as timelines, budgets, and tactics. It begins with a bulleted overview of the most important takeaways and takes into account general marketing efforts that don’t fit under a specific campaign umbrella. Fraser notes that this plan includes year-round marketing initiatives, with an effective “emphasis on strong offers, such as youth-free fares.” However, he points out that its brand awareness goals could be more specific. “Instead, use context-specific awareness goals such as ‘When commuting to work, residents first think of Gold Coast Transit’ or ‘When coming home from the library at night, I think of taking the bus,’” he says. “In other words, peg awareness to specific category-entry points.”  

University of Arizona College of Engineering This  marketing, branding, and communications plan for the University of Arizona College of Engineering sets out a long-term vision, high-level goals, and strategies for achieving these goals. It has a section for methodology — including promotional videos and email newsletters — and segments its audience to align with its strategies. This plan “demonstrates a clearly defined audience,” according to Rarrick. That said, not every section of the plan includes the same level of specificity. “The KPIs are vague,” he adds. “I would expect to see something more measurable, rather than ‘increase’ or ‘improve.’” 

Timberland Regional Library This  library's two-year marketing plan sets initiatives in motion with a clear schedule for action. It includes both promotional and production calendars for effective planning, which is especially important for campaigns pegged to external events.  Dinsmore cites this plan’s “professional and elegant graphic design” as a strength. It also offers a roadmap for tackling several marketing campaigns on different timelines. However, he suggests that the plan needs more measurable goals and defined strategies. “There’s no overarching strategy that ties all of these tactics and initiatives together,” he says. “It’s just a laundry list of dates and actions.” 

Safe Haven Family Shelter Nonprofit organizations need creative marketing strategies to reach their targets and use funds efficiently. With specific objectives and actionable steps, this  marketing plan for Safe Haven Family Shelter delineates high-level goals and details the path to achieving them. It identifies the roles and responsibilities of individual team members to ensure alignment. Rarrick commends this plan for its “clearly defined audience and very clearly defined goals.” The plan showcases the differences between strategic business goals and measurable marketing objectives.  

Visit Myrtle Beach This  destination marketing plan by the Myrtle Beach, South Carolina Chamber of Commerce  incorporates detailed information about target markets, audience personas, and key behaviors. It includes an infographic that illuminates the touchpoints in a traveler’s journey and shows the marketing team how each tactic contributes to conversions.  Overall, Dinsmore praises this plan as a “very smart and thoughtful presentation.” It outlines a distinct media mix for each target audience, defines its objectives clearly, and ties these objectives to success metrics. He continues, “I want to thank the Myrtle Beach folks for planning to measure their efforts. Measurement is often anathema to marketing people, but if you’re not measuring, you don’t know how to improve.”  With so much information to cover, the plan would benefit from an executive summary to introduce key takeaways. “The bigger the scope, the harder it is to make everything feel connected, and that’s a bit of an issue with this plan,” Dinsmore adds.  

Tropical Avocados This  example of a no-frills plan was commissioned by the nonprofit Improving Economies for Stronger Communities (IESC) to help brand and launch tropical avocados in the U.S. market. It shows the importance of making branding decisions backed by market and consumer research. A detailed SWOT analysis and competitive analysis provide essential insights that enable the company to determine the best unique selling proposition.  A key strength of this plan is its detailed research into its audience. Fraser cites its “excellent identification of consumer objections — e.g., concern over how natural the avocado size is — and consumer behavior.” As a result, the brand can adopt effective messaging in its marketing campaigns. As with USDA Northeast Climate Hub’s Delmarva and the Ground for Change documentary, “target collaborators — e.g., food writers, organizations, and chefs — are included in the target audience. Collaborators are often more critical to the marketing plan than the consumers themselves,” Fraser adds.  

Rochelle Community Hospital This  case study of Rochelle Community Hospital in Rochelle, Illinois, shows how a targeted marketing plan can be used to achieve significant results. The report by Legato Healthcare Marketing showcases the importance of reevaluating an existing marketing strategy — in this case, shifting the emphasis from print to digital. External marketing agencies often have more tools at their disposal, particularly if the business has not had a strong digital presence. With targeted ads and website updates, the agency employed tactics with direct metrics in order to track its impact.   

Visit Concord This  example from the Concord Tourism Improvement District marketing plan is concise and includes streamlined insights on the audience and market. It details each marketing channel with specific tactics and measurable KPIs.  The overall strategy, according to Fraser, offers “an excellent emphasis on social proof and word-of-mouth marketing,” as well as a “good balance of awareness and activation marketing.” In order to improve, he suggests, “the plan should factor in the following critical quantitative factors to help drive the media strategy: reach, frequency, and the total-addressable market.” 

Marketing Plan Templates

Using a template takes the guesswork out of organizing a marketing plan document. These customizable templates include essential elements and options for specific industries or marketing channels, and they range from one-page plans to comprehensive, presentation-ready reports.

Microsoft Word Simple Marketing Plan Template

Download the Simple Marketing Plan Example Template for Microsoft Word Download the Blank Simple Marketing Plan Template for Microsoft Word

This example of a simple, customizable plan focuses on key strategies and prioritizes readability. This one-page marketing plan template includes space to summarize marketing strategy and overarching business objectives, along with an action plan to highlight responsibilities and deadlines.

Microsoft Word Annual Marketing Plan Template

Download the Annual Marketing Plan Example Template for Microsoft Word Download the Blank Annual Marketing Plan Template for Microsoft Word  

This comprehensive marketing plan template includes a number of key sections — such as goals, target market, marketing channels, and performance standards — that can be customized to suit a variety of businesses. In the situational analysis, you can find space for both a 5C (company, collaborators, customers, competitors, climate) analysis and a SWOT analysis. The blank template begins with a table of contents, a business summary, and a mission statement to allow for easy readability. The sample focuses on marketing strategies for one fiscal year, but you can modify this plan for any time period. 

Microsoft Word Small Business Marketing Plan Template

Download the Small Business Marketing Plan Example Template for Microsoft Word Download the Blank Small Business Marketing Plan Template for Microsoft Word

A strong marketing plan is essential for small businesses looking to stand out from larger competitors. This small business marketing plan template provides an outline for a detailed marketing strategy, including a unique selling proposition, the 4Ps marketing mix, and marketing channels. It builds its strategy on situational analysis and identification of the business’s core capabilities. Find  more marketing plan templates  for different industries.

Microsoft Word Nonprofit Marketing Plan Template

Download the Nonprofit Marketing Plan Example Template for Microsoft Word Download the Blank Nonprofit Marketing Plan Template for Microsoft Word

This example marketing plan for a nonprofit incorporates information on the funding climate into its situational analysis, as well as a detailed organizational summary. With sections for short- and long-term goals, marketing strategies and channels, and stakeholder profiles, the template is comprehensive and customizable. Find  more nonprofit marketing plan templates here .

Excel Product Marketing Plan Template

Download the Product Marketing Plan Example Template for Excel Download the Blank Product Marketing Plan Template for Excel

When integrating a new product into existing marketing strategies, it’s important to take into account all the elements of the marketing mix. This product marketing plan template is organized by product, price, place, promotion, process, people, and physical evidence. In these sections, you can find space to consider market research, consumer behaviors, and marketing channels.

Excel Social Media Marketing Plan Template

Download the Social Media Marketing Plan Example Template for Excel Download the Blank Social Media Marketing Plan Template for Excel

For planning specific campaigns, this social media marketing action plan template begins with the campaign goal, highlights important promo dates, and separates actions by platform. It’s useful for executing targeted social media campaigns within a larger marketing strategy. Find  more marketing action plan templates here .

Excel Digital Marketing Plan Template

Download the Digital Marketing Plan Example Template for Excel Download the Blank Digital Marketing Plan Template for Excel

Focusing on digital marketing channels is an effective way to organize strategies into a streamlined and actionable plan. This strategic digital marketing template highlights important audience behaviors and access channels to ensure messaging reaches consumers. Customizable for a variety of digital marketing projects, the template includes space for keywords, goals, and tasks. Find  more digital marketing plan templates here .

Which Marketing Plan Format Is Right for You?

To choose the right marketing plan format for your needs, consider the plan’s role in your marketing strategy. Do you need a comprehensive plan to provide an overview of tactics that will take place over a long period of time? Or are you looking for a plan to focus on specific channels, campaigns, or product launches? 

Each template in this article offers space to detail market research, strategies, and access channels. The longer plans include more sections for in-depth situational analysis and audience demographics, while the shorter plans focus on the marketing mix and action plan. This chart highlights the key elements of each marketing plan:  

Streamline Your Marketing Plan Efforts with Smartsheet

The best marketing teams know the importance of effective campaign management, consistent creative operations, and powerful event logistics -- and Smartsheet helps you deliver on all three so you can be more effective and achieve more. 

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.

Improve your marketing efforts and deliver best-in-class campaigns.

• Using Demand Management

Plan Approval, Plan Attributes, and Plan Status

Use Oracle Demand Management to facilitate forecast reconciliation and agreement of cross-functional forecasts. With forecast reconciliation, you can view a forecast captured from cross-functional teams at both aggregate and detailed levels.

Forecast reconciliation helps you do the following:

Compare forecast at the plan level, show the variance over a period of time, or across different product segments.

Use built-in exceptions, such as deviation between sales and final shipments forecast to reconcile the sales forecast with your estimates.

Use user-defined exceptions and calculations to find more specific issues that fit your evaluation criteria.

Use conditional formatting to identify which specific weeks or items have a problem at a glance.

The forecast review and approval process describes a flow where you can approve the forecast of a plan after you generate statistical forecast. You review and modify forecast as needed. After you validate the forecast, you can approve the forecast for the plan.

The approve action copies the forecast data to the designated approved measure and changes the plan status to approved.

In case of the Bookings Forecast, the approve process copies the data from the Final Bookings Forecast measure to the Approved Final Bookings Forecast measure.

In case of the Shipments Forecast, the approve process copies the data from the Final Shipments Forecast measure to the Approved Final Shipments Forecast measure.

The approve action updates three approval-related plan attributes:

The Approval Status attribute is gets updated to Approved.

The Last Approved By attribute gets updated with the user name.

The Last Approved Date attribute gets updated with the approve plan process date and time.

You can review the plan attributes from the Manage Plans page.

To reset the approval status of a plan: Navigate to the plan's Actions menu, and select Reset Approval Status . This resets the Approval Status plan attribute.

Related Topics

• Approve a Demand Plan

Rivian sticks to production forecast below Wall Street targets

• Medium Text

• Company Rivian Automotive Inc Follow
• Company Rivian Automotive LLC Follow
• Company Amazon.com Inc Follow

Sign up here.

Reporting by Akash Sriram in Bengaluru and Abhirup Roy in San Francisco; Editing by Shailesh Kuber, Matthew Lewis and Richard Chang

Our Standards: The Thomson Reuters Trust Principles. New Tab , opens new tab

Thomson Reuters

Akash reports on technology companies in the United States, electric vehicle companies, and the space industry. His reporting usually appears in the Autos & Transportation and Technology sections. He has a postgraduate degree in Conflict, Development, and Security from the University of Leeds. Akash's interests include music, football (soccer), and Formula 1.

Business Chevron

US judge halts rule capping credit card late fees at $8

A federal judge in Texas on Friday halted the Consumer Financial Protection Bureau's new rule capping credit card late fees at $8, a victory for business and banking groups challenging part of the Biden administration's crackdown on "junk fees."