example of financial forecast in business plan

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 Essentials
• Leadership & Management
• Credential of Leadership, Impact, and Management in Business (CLIMB)
• Entrepreneurship & Innovation
• *New* 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
• 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

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

Published: June 07, 2023

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

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

1. What is financial forecasting?

Forecasting vs. Budgeting

2. Financial Forecasting Models

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

3. Financial Forecasting Methods

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

4. How to do Financial Forecasting

5. Financial Forecasting Software

What is financial forecasting?

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

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

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

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

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

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

Financial Forecasting Models

1. top-down financial forecasting.

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

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

Top-Down Financial Forecasting Example

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

Benefits of Top-Down Forecasting

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

Drawbacks of Top-Down Forecasting

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

2. Delphi Forecasting

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

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

Delphi Financial Forecasting Example

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

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

Benefits of Delphi Forecasting

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

Drawbacks of Delphi Forecasting

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

3. Statistical Forecasting

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

Statistical Financial Forecasting Example

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

Benefits of Statistical Forecasting

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

Drawbacks of Statistical Forecasting

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

4. Bottom-Up Financial Forecasting

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

Bottom-Up Financial Forecasting Example

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

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

Benefits of Bottom-Up Forecasting

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

Drawbacks of Bottom-Up Forecasting

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

Financial Forecasting Methods

1. Straight Line

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

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

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

2. Simple Linear Regression

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

3. Multiple Linear Regression

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

4. Moving Average

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

How to do Financial Forecasting

1. Define your purpose for using a financial forecast.

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

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

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

2. Gather historical data.

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

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

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

3. Set a time frame for your forecast.

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

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

4. Choose a forecasting method.

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

5. Monitor and analyze your forecast results.

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

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

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

Financial Forecasting Software

1. sage intacct, pricing: contact for pricing.

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

Best for Collaboration

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

2. PlanGuru

Pricing: plans starting at $99 per month.

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

Best for Pure Financial Forecasting

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

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

3. Workday Adaptive Planning

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

Best for a Dynamic Range of Forecasting Options

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

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

4. Limelight

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

Best for a Familiar, Excel-Esque UX

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

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

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

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

Don't forget to share this post!

Related articles.

8+ Opportunities to Capitalize on The Legal Tech Boom

Top Industries for Entrepreneurs in 2024 According to Our Trends Team

3 Lucrative Ways to Help Seniors Live That Fit and Fabulous Lifestyle

How Canva Founder Melanie Perkins Found The Secret to A Winning Pitch

Want to Build A Subscription Business? Ask Yourself These 3 Questions

How to Cash in on The Rise of ‘Antisocial’ Foodies

How A Small Ice Cream Business Pivoted in Tough Times

The Billion-Dollar Opportunity to Help Women Navigate Menopause with Grace

3 Lessons from A Founder of 2 Million-Dollar Companies

Social Selling: Launch Your Product to A Crowd of 32 Million on TikTok

2 Essential Templates For Starting Your Business

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

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 write a financial forecast for your business.

Financial projections help leaders visualize growth. Here’s how to create one.

Financial forecasting is a critical yet often underused tactic for small business owners. In its simplest form, it involves calculating changes based on historical financial statements. The straight-line forecasting method uses data to make quantitative predictions.

Another option is to make assumptions related to your business goals and activities using research-based financial forecasts. The qualitative method considers market trends, industry benchmarks and competitor analysis.

You can use both methods for financial modeling, where you simulate scenarios to see the impact on your company's financial health.

Learn how to make predictions by following these steps to write your financial forecast.

Gather your financial statements

Before looking ahead, it's important to understand your past. First, determine the reporting period for your financial forecast. For business-planning purposes, many business owners predict income for the upcoming year. In comparison, vendors, investors and lenders require financial forecasts for the next three years.

Next, improve accuracy by pulling three years of historical financial statements. Your bookkeeper, accountant or accounting software can generate the following financial statements :

• Balance sheet.
• Income statement.
• Cash flow statement.

Review historical financial statements

For a straight-line forecast, calculate the line item differences for each period. Typically, business owners start with their income statement, also known as a profit and loss (P&L) statement. Ultimately, you'll need a complete model using all three financial statements if you're looking for funding .

Financial planners often recommend creating financial forecasts for worst-, best- and average-case scenarios.

Crunch the numbers line by line to see how your revenue and expenses changed over time. A financial forecast template in Microsoft Excel or Google Sheets can make this process easier. The formula for calculating change finds the difference between two periods (Year Two minus Year One). Then divide the difference by the original number (Year One) to get a decimal. Multiply that figure by 100 to express the change as a percentage.

Here's a financial forecast example based on a fictional company:

• Flowers Inc. had a gross profit of $30,000 in 2017 (Year One), $50,000 in 2018 (Year Two), $65,000 in 2019 (Year Three) and $55,000 in 2020 (Year Four).
• Subtract $30,000 (Year One) from $50,000 (Year Two) to get the difference, which is $20,000.
• Divide $20,000 by $30,000 (Year One) to get the decimal of 0.67.
• Multiply the decimal by 100 to get the percentage of 67%.

In this example, Flowers Inc. showed growth in profit of 67% in 2018 and 30% in 2019, and a decline in profit of 23% in 2020. Complete this step for each line item on your income statement, balance sheet and cash flow statement

[Read more: Roadmap For Rebuilding: Financial Management ]

Make a financial forecast or straight-line prediction

For a straight-line prediction, look at your historical performance and find the average rate for each category. Apply this figure to future years for each section. However, if you're a numbers whiz or have an accountant , you can make assumptions for pro forma statements. A pro forma statement makes predictions that may differ from your historical data.

For example, Flowers Inc. may want 2020's figure to carry less weight than previous years. Plus, the company recently added a delivery service, increasing sales and expenses. Overall, Flowers Inc. expects to achieve a higher gross profit. Since a pro forma statement isn't required to follow generally accepted accounting principles (GAAP), Flowers Inc. can include these predictions on a pro forma statement.

Likewise, Flowers Inc. may also make assumptions about its cost of goods sold (COGS) based on market data and recent cost hikes. Financial planners often recommend creating financial forecasts for worst-, best- and average-case scenarios. Doing so gives you a range of potential outcomes, which helps when planning your overall budget

Start small, dream big

Once you have a basic financial forecast, it's time to play with the numbers and figure out how to reach your business goals. In addition, think about future debt payments or large expenditures that will impact your financial statements. From our example, Flowers Inc. will pay off its startup loan next year, significantly increasing cash flow and decreasing liabilities, so it can purchase a new vehicle for delivery without negatively affecting its balance sheet.

Factor each assumption into your financial forecast for accuracy. Don't forget to update your financial forecast regularly. Doing so allows you to catch potential cash flow problems or adjust expectations over time.

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

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

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

Subscribe to our newsletter, Midnight Oil

Expert business advice, news, and trends, delivered weekly

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

For more finance tips

What is enterprise resource planning, choosing an enterprise resource planning tool for your small business, 10 benefits of erp systems for small businesses.

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.

How to Create a Cash Flow Forecast

10 min. read

Updated October 27, 2023

A good cash flow forecast might be the most important single piece of a business plan . All the strategy, tactics, and ongoing business activities mean nothing if there isn’t enough money to pay the bills.

That’s what a cash flow forecast is about—predicting your money needs in advance.

By cash, we mean money you can spend. Cash includes your checking account, savings, and liquid securities like money market funds. It is not just coins and bills.

Profits aren’t the same as cash

Profitable companies can run out of cash if they don’t know their numbers and manage their cash as well as their profits.

For example, your business can spend money that does not show up as an expense on your  profit and loss statement . Normal expenses reduce your profitability. But, certain spending, such as spending on inventory, debt repayment, new equipment, and purchasing assets reduces your cash but does not reduce your profitability. Because of this, your business can spend money and still look profitable.

On the sales side of things, your business can make a sale to a customer and send out an invoice, but not get paid right away. That sale adds to the revenue in your profit and loss statement but doesn’t show up in your bank account until the customer pays you.

That’s why a cash flow forecast is so important. It helps you predict how much money you’ll have in the bank at the end of every month, regardless of how profitable your business is.

Learn more about the differences between cash and profits .

• Two ways to create a cash flow forecast

There are several legitimate ways to do a cash flow forecast. The first method is called the “Direct Method” and the second is called the “Indirect Method.” Both methods are accurate and valid – you can choose the method that works best for you and is easiest for you to understand.

Unfortunately, experts can be annoying. Sometimes it seems like as soon as you use one method, somebody who is supposed to know business financials tells you you’ve done it wrong. Often that means that the expert doesn’t know enough to realize there is more than one way to do it.

• The direct method for forecasting cash flow

The direct method for forecasting cash flow is less popular than the indirect method but it can be much easier to use.

The reason it’s less popular is that it can’t be easily created using standard reports from your business’s accounting software. But, if you’re creating a forecast – looking forward into the future – you aren’t relying on reports from your accounting system so it may be a better choice for you.

That downside of choosing the direct method is that some bankers, accountants, and investors may prefer to see the indirect method of a cash flow forecast. Don’t worry, though, the direct method is just as accurate. After we explain the direct method, we’ll explain the indirect method as well.

The direct method of forecasting cash flow relies on this simple overall formula:

Cash Flow = Cash Received – Cash Spent

And here’s what that cash flow forecast actually looks like:

Let’s start by estimating your cash received and then we’ll move on to the other sections of the cash flow forecast.

Brought to you by

Create a professional business plan

Using ai and step-by-step instructions.

Secure funding

Validate ideas

Build a strategy

Forecasting cash received

You receive cash from four primary sources: 

1. Sales of your products and services

In your cash flow forecast, this is the “Cash from Operations” section. When you sell your products and services, some customers will pay you immediately in cash – that’s the “cash sales” row in your spreadsheet. You get that money right away and can deposit it in your bank account. You might also send invoices to customers and then have to collect payment. When you do that, you keep track of the money you are owed in  Accounts Receivable . When customers pay those invoices, that cash shows up on your cash flow forecast in the “Cash from Accounts Receivable” row. The easiest way to think about forecasting this row is to think about what invoices will be paid by your customers and when.

2. New loans and investments in your business

You can also receive cash by getting a new loan from a bank or an investment. When you receive this kind of cash, you’ll track it in the rows for loans and investments. It’s worth keeping these two different types of cash in-flows separate from each other, mostly because loans need to be repaid while investments do not need to be repaid.

3. Sales of assets

Assets  are things that your business owns, such as vehicles, equipment, or property. When you sell an asset, you’ll usually receive cash from that sale and you track that cash in the “Sales of Assets” section of your cash flow forecast. For example, if you sell a truck that your company no longer needs, the proceeds from that sale would show up in your cash flow statement.

4. Other income and sales tax

Businesses can bring in money from other sources besides sales. For example, your business may make interest income from the money that it has in a savings account. Many businesses also collect taxes from their customers in the form of sales tax, VAT, HST/GST, and other tax mechanisms. Ideally, businesses record the collection of this money not in sales but in the cash flow forecast in a specific row. You want to do this because the tax money collected isn’t yours – it’s the government’s money and you’ll eventually end up paying it to them.

Forecasting cash spent

Similar to how you forecast the cash that you plan on receiving, you’ll forecast the cash that you plan on spending in a few categories:

1. Cash spending and paying your bills

You’ll want to forecast two types of cash spending related to your business’s operations: Cash Spending and Payment of Accounts Payable. Cash spending is money that you spend when you use petty cash or pay a bill immediately. But, there are also bills that you get and then pay later. You track these bills in  Accounts Payable . When you pay bills that you’ve been tracking in accounts payable, that cash payment will show up in your cash flow forecast as “payment of accounts payable”. When you’re forecasting this row, think about what bills you’ll pay and when you’ll pay them. In this section of your cash flow forecast, you exclude a few things: loan payments, asset purchases, dividends, and sales taxes.

2. Loan Payments

When you make forecast loan repayments, you’ll forecast the repayment of the principal in your cash flow forecast. The interest on the loan is tracked in the “non-operating expense” that we’ll discuss below.

3. Purchasing Assets

Similar to how you track sales of assets, you’ll forecast asset purchases in your cash flow forecast. Asset purchases are purchases of long-lasting, tangible things. Typically, vehicles, equipment, buildings, and other things that you could potentially re-sell in the future. Inventory is an asset that your business might purchase if you keep inventory on hand.

4. Other non-operating expenses and sales tax

Your business may have other expenses that are considered “non-operating” expenses. These are expenses that are not associated with running your business, such as investments that your business may make and interest that you pay on loans. In addition, you’ll forecast when you make tax payments and include those cash outflows in this section. 

Forecasting cash flow and cash balance

In the direct cash flow forecasting method, calculating cash flow is simple. Just subtract the amount of cash you plan on spending in a month from the amount of cash you plan on receiving. This will be your “net cash flow”. If the number is positive, you receive more cash than you spend. If the number is negative, you will be spending more cash than you receive. You can predict your cash balance by adding your net cash flow to your cash balance.

• The indirect method

The indirect method of cash flow forecasting is as valid as the direct and reaches the same results.

Where the direct method looks at sources and uses of cash, the indirect method starts with net income and adds back items like depreciation that affect your profitability but don’t affect the cash balance.

The indirect method is more popular for creating cash flow statements about the past because you can easily get the data for the report from your accounting system.

You create the indirect cash flow statement by getting your Net Income (your profits) and then adding back in things that impact profit, but not cash. You also remove things like sales that have been booked, but not paid for yet.

Here’s what an indirect cash flow statement looks like:

There are five primary categories of adjustments that you’ll make to your profit number to figure out your actual cash flow:

1. Adjust for the change in accounts receivable

Not all of your sales arrive as cash immediately. In the indirect cash flow forecast, you need to adjust your net profit to account for the fact that some of your sales didn’t end up as cash in the bank but instead increased your accounts receivable.

2. Adjust for the change in accounts payable

Very similar to how you make an adjustment for accounts receivable, you’ll need to account for expenses that you may have booked on your income statement but not actually paid yet. You’ll need to add these expenses back because you still have that cash on hand and haven’t paid the bills yet.

3. Taxes & Depreciation

On your income statement, taxes and depreciation work to reduce your profitability. On the cash flow statement, you’ll need to add back in depreciation because that number doesn’t actually impact your cash. Taxes are may have been calculated as an expense, but you may still have that money in your bank account. If that’s the case, you’ll need to add that back in as well to get an accurate forecast of your cash flow.

4. Loans and Investments

Similar to the direct method of cash flow, you’ll want to add in any additional cash you’ve received in the form of loans and investments. Make sure to also subtract any loan payments in this row.

5. Assets Purchased and Sold

If you bought or sold assets, you’ll need to add that into your cash flow calculations. This is, again, similar to the direct method of forecasting cash flow.

• Cash flow is about management

Remember: You should be able to project cash flow using competently educated guesses based on an understanding of the flow in your business of sales, sales on credit, receivables, inventory, and payables.

These are useful projections. But, real management is minding the projections every month with plan versus actual analysis so you can catch changes in time to manage them. 

A good cash flow forecast will show you exactly when cash might run low in the future so you can prepare. It’s always better to plan ahead so you can set up a line of credit or secure additional investment so your business can survive periods of negative cash flow.

• Cash Flow Forecasting Tools

Forecasting cash flow is unfortunately not a simple task to accomplish on your own. You can do it with spreadsheets, but the process can be complicated and it’s easy to make mistakes. 

Fortunately, there are affordable options that can make the process much easier – no spreadsheets or in-depth accounting knowledge required.

If you’re interested in checking out a cash flow forecasting tool, take a look at LivePlan for cash flow forecasting. It’s affordable and makes cash flow forecasting simple.

One of the key views in LivePlan is the cash flow assumptions view, as shown below, which highlights key cash flow assumptions in an interactive view that you can use to test the results of key assumptions:

With simple tools like this, you can explore different scenarios quickly to see how they will impact your future cash.

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

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

Table of Contents

• Profits aren’t the same as cash

Related Articles

9 Min. Read

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

3 Min. Read

What Is a Break-Even Analysis?

8 Min. Read

How to Forecast Personnel Costs in 3 Steps

5 Min. Read

How to Highlight Risks in Your Business Plan

The Bplans Newsletter

The Bplans Weekly

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

We care about your privacy. See our privacy policy .

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

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

No thanks, I prefer writing 40-page documents.

Discover the world’s #1 plan building software

How to Create a Financial Forecast

Bryce Warnes

Reviewed by

July 15, 2022

This article is Tax Professional approved

Maybe your goal is world domination. Maybe you just want a sustainable side hustle. Either way, financial forecasting helps you understand the steps you need to take—and the numbers you need to hit—to make growth happen for your business.

I am the text that will be copied.

Plus, if you ever go looking for more funding, you’ll need financial forecasts to prove that your business is on track for growth.

Here’s everything you need on hand, and the steps you can take, to produce a reliable financial forecast.

What is a financial forecast?

A financial forecast tries to predict what your business will look like (financially) in the future. Pro forma financial statements are how you make those predictions somewhat concrete.

Pro forma statements are just like the financial statements you use each month to see how your business is performing. The only difference is that you prepare pro forma statements in advance, for future months and years.

There are three key pro forma statements you should be familiar with:

• The Income Statement
• The Cash Flow Statement
• The Balance Sheet

Helpful resource: How to Read and Analyze Financial Statements

Depending on your goals, these statements will cover different time spans. If you’re creating a financial forecast for your planning purposes, you should create pro forma statements covering six months to one year in the future.

If you’re presenting your forecast to a lender or investor, though, you should create pro forma statements covering the next one to three years.

Financial forecasting vs. budgeting

When you create a budget for your business , you plan to set aside money for certain costs, taking into account your income and expenses. The budget you make may be based on info from your financial forecast, but it’s distinct from the forecast itself.

Think of financial forecasting as a prediction, and budgeting as a plan. When you make a financial forecast, you see what direction your business is headed in, based on past performance and other factors, and use that to anticipate the future.

When you make a budget, you plan how you’re going to spend money based on what you expect your finances to look like in the future (your forecast).

For instance, if your financial forecast for next year says you’ll have an extra $5,000 in revenue, you might create a budget to decide how it will be spent—$2,000 for a new website, $1,000 for Facebook ads, and so on.

Three steps to creating your financial forecast

Ready to peer into the crystal ball and see the future of your business? There are three steps you need to follow:

• Gather your past financial statements. You’ll need to look at your past finances in order to project your income, cash flow, and balance.
• Decide how you’ll make projections. Besides past records, there’s other data you can draw on to make your projections more accurate.
• Prepare your pro forma statements. Pour a coffee and get ready to crunch some numbers.

Step one: Gather your records

If you’re not looking into the past to see how your business has grown, you’re not really forecasting—you’re just guessing.

You’ll need to gather past financial statements so you can see how your business has developed over time, and then project that development into the future.

Your bookkeeper or bookkeeping software should generate financial statements for you. If you don’t have either, and you don’t have financial statements, you’ll need to take care of that before you can start forecasting. You need complete bookkeeping in order to get the transaction history you base your financial statements on.

Put aside the task for financial forecasting for the moment, and learn how to catch up on your bookkeeping .

Once your books and financial statements are up to date, you’ll have everything you need to start planning for the future.

Step two: Decide how you’ll make your forecast

Depending what resources you choose to use, the type of forecast you create will fall between two poles— historical and researched-based.

Almost every financial forecast includes a little bit of historical forecasting, and a little bit that’s research-based. The blend you choose will depend on your needs and the resources at your disposal.

Remember, the goal is to create a realistic, useful forecast—without breaking the bank or eating up all your time.

Historical forecasting

When you use your financial history to plot the future, it’s historical forecasting . You’re looking at your last few annual Income Statements, Cash Flow Statements, and Balance Sheets to see how fast you’ve grown in the past. From there, you can make a guess about how fast you’ll grow this year.

The benefit of this is that it’s relatively easy to do and doesn’t take a lot of time, money, or expertise. The drawback is that you’re only using info about your own business, and not looking at broader market trends—like what your competition has been up to.

Historical forecasting is a good bet if you’re forecasting for modest growth, or else creating a quick-and-dirty forecast for your own use—not putting together a presentation for potential investors.

Research-based forecasting

When you do research about broader market trends, you’re using research-based forecasting . You may look at how your industry has performed over the past ten years, investigate new technologies and consumer trends, or try to measure the progress of your competitors. You might look at how companies similar to yours have planned their own growth.

The benefit of research-based forecasting is that you get a detailed, nuanced view of how your business could grow, taking into account a lot of different factors. And it’s the kind of forecast that investors and lenders want to see.

The drawback is that researched-based forecasting can be expensive. You may find you need to hire outside consultants and researchers to handle the heavy lifting.

Research-based forecasting is a good choice if you’re courting investors, or planning on rapid, aggressive growth. It’s also good if your company is brand new, and doesn’t have a lot of financial history to draw on for making projections

Step three: Create pro forma statements

Once you’ve collected the information you need to build your forecast, you can create pro forma statements.

We’ll cover the three key financial statements here. Whether you use all of them is up to you.

If you’re creating a quick forecast for your own planning, you may only need to create pro forma Income Statements. If you’re presenting to lenders or investors, you’ll want to use all three.

Rule of thumb: Any form you’d use in the month-to-month operation of your business should be created pro forma. For instance, if you move a lot of cash around every month, and you rely on Cash Flow Statements to make sure you’ve got enough money on hand to pay your vendors, then it’s wise to create pro forma Cash Flow Statements as part of your forecast.

Creating the pro forma Income Statement

First, set a goal—a projection—for sales in the period you’re looking at.

Let’s say you made $30,000 in sales this year. Next year, you want to make $60,000. So, your total sales will increase by $30,000.

Set a production schedule that will let you reach that goal, and map it out over the time period you’re covering. In our example, there will be 12 Income Statements in the year to come (one each month). Map out that $30,000 increase in sales over the 12 statements.

You could do this by increasing sales a fixed amount every month, or gradually increasing the amount of sales you make per month. It’s up to your instincts and experience as a business owner.

Then, it’s time for the “loss” part of “ profit and loss .” Calculate the cost of goods sold for each month, and deduct it from your sales. Deduct any other operating expenses you have, as well.

It’s important to take every expense into account so you get an accurate projection. If part of your plan is quadrupling your online advertising, be sure to include an expense that reflects that.

Once you’re done, your pro Forma Income Statements show you how much you can expect to earn and how much you can expect to spend in the time ahead.

Example Pro Forma Income Statement:

Karen’s Falafel Warehouse

Creating the pro forma Cash Flow Statement

You create a pro forma Cash Flow Statement a lot like the way you’d create a regular Cash Flow Statement. That means taking info from the Income Statement, and using the Cash Flow Statement format to plot out where your money is going, and how much you’ll have on hand at any one time.

Your projected cash flow can tell you a few things. If it’s in the negative, it means you’re not going to have enough cash on-hand to run your business, according to your current trajectory. You’ll need to make plans to borrow money and pay it off.

If your net cash flow is positive, you can plan on having enough surplus cash on hand to pay off loans, or save for a big investment.

Example Pro Forma Cash Flow Statement:

Ruth’s Raccoon Rescue and Rehabilitation Center

Creating the pro forma Balance Sheet

Drawing on info from the Income Statement and the Cash Flow Statement lets you create pro forma Balance Sheets. But you’ll also need previous Balance Sheets to make this useful—so you can follow the story of how your business got from “Balance A” to “Balance B.”

The Balance Sheet will project changes in your business accounts over time. That way, you can plan where to move money, when.

Example Pro Forma Balance Sheet:

Big Bill’s Budget Wedding Videos

Forecast vs. actuals

Once you’ve created a financial forecast, your work isn’t done. The vital second stage is to go back and record what your actual financials were in comparison to your forecast once the month or year is over.

Why is this so vital?

It helps you learn to forecast better next year, and when your forecast is way off, you can take notes for yourself on why that was.

For example:

• March revenue was much higher than I forecasted for. I didn’t realize there would be a seasonal boost over spring break.
• Sales were lower than I forecasted in the June. There was a miscommunication with the supplier and I didn’t have all the inventory I needed.

These mundane notes to yourself accumulate into invaluable business knowledge that help make every year more successful than the last.

Best, worst, and normal case projections

Whether you’re the kind of person who always sees the glass half full, or the kind who always sees it half empty, it’s a good idea to take into account different possible outcomes for your business.

Humans aren’t very good at predicting the future. Consider creating three different forecasts: One for the best case scenario, one for the worst, and one for the middle or “regular” scenario.

• Maybe the t-shirts you buy wholesale for your online store go up in price, like they did last year. Factor that into your worst case scenario .
• Maybe t-shirt prices stay the same, plus your new advertising plan takes off, and you get more business. Consider that the best case.
• Maybe everything more or less stays the same. Let’s call that the regular case.

The best/worst/regular trifecta is also useful when you’re making a budget for your business. For example, in January you might budget for a regular scenario. In this case, that means monthly sales revenue of $8,000.

However, in February say your revenue hits $10,000, and in March it’s $11,000. At that point, you may want to adjust your budget to the best case to scenario—since you’ll now have more money to reinvest in your business.

At the end of the day, the more robust your forecast, the better you’ll be able to plan the future of your business, and think on your feet. Plus, you’ll impress investors and lenders, by proving you’ve considered (almost) every possible outcome.

The better you understand how financial statements work, the easier you’ll find it to create financial forecasts. Before you start forecasting, take a look at our other helpful resources for understanding your small business financials:

• Financial Literacy 101 for Small Business Owners
• 10 Financial Ratios Every Small Business Owner Should Know
• Accounting Solutions: The Top 7 Ways to Get Your Accounting Done

Related Posts

What is an Invoice? (Example and Template)

Invoicing is the bread and butter of your business. Literally: If you don’t invoice, you don’t get paid, and you can’t afford bread or butter.

Finding Small Business CPAs: Tips Before You Choose

You don’t have to tackle your business finances alone. A certified public accountant (CPA) can help out at various stages during the growth of your small business.

Gross Profit: What Is It and What It Means For Your Business

If you want to have a profitable business, you must first turn a gross profit. But what exactly is it, how do you calculate it, and how do you make more of it?

Join over 140,000 fellow entrepreneurs who receive expert advice for their small business finances

Get a regular dose of educational guides and resources curated from the experts at Bench to help you confidently make the right decisions to grow your business. No spam. Unsubscribe at any time.

7-step guide to financial forecasting & planning for any business

What is financial forecasting, why is it important, and how to properly conduct financial planning and forecasting

• What is financial forecasting?
• Why is it important?
• 4 common types of financial forecasting
• How to do financial forecasting in 7 steps
• Financial forecasting FAQs

Join our newsletter for the latest in SaaS

By subscribing you agree to receive the Paddle newsletter. Unsubscribe at any time.

Uncertainty is one of the constant aspects of doing business. Many factors beyond your control can potentially influence the market in ways you didn't expect. For example, new technologies are constantly changing operations across almost all industries at a fundamental level. 

It pays to know what to expect in the near future and plan ahead, hence the need for financial forecasting. Every business (including monopolies) could benefit incredibly from regular  financial forecasting . Here is a comprehensive guide on the importance of financial forecasting for your business model and how to do it.

Failure to conduct regular financial forecasting leaves you flying blind.

What is financial forecasting? 

Financial forecasting refers to financial projections performed to facilitate any decision-making relevant for determining future business performance. The financial forecasting process includes the analysis of past business performance, current  business trends , and other relevant factors.

However, some aspects of financial forecasting may change depending on the type and purpose of the forecast, as will be discussed later. 

Importance of financial forecasting 

Hypothetically speaking, failure to conduct regular financial forecasting leaves you flying blind. Regular forecasting has extensive benefits for some of your business' fundamental operations, including: 

Annual budget planning 

A budget represents your business' cash flow, financial positions, and future goals and expectations for a set fiscal period.  Financial forecasting and planning  work in tandem, as forecasting essentially offers an insight into your business' future—these insights help make budgeting accurate.  

Establishing realistic business goals 

Accurate forecasting will help predict whether (and by how much) your business will grow or decline. As such, you can set realistic and achievable goals—and manage your expectations. 

Identifying problem areas 

Financial forecasting  can help you identify ongoing problems by analyzing the business' past performance. Additionally, you can identify potential problems by getting an insight into what the future holds. 

Reduction of financial risk 

You risk overspending by creating a budget without financial forecasting. In fact, most of your financial decisions would be ill-informed without the input of a financial forecast's results. 

Greater company appeal to attract investors 

Investors use a company's financial forecast to predict its future performance—and the potential ROIs on their investments. Additionally, regular forecasting shows your investors that you are in control and have a solid business plan prepared for the future.

4 common types of financial forecasting 

Businesses conduct financial forecasting for varying purposes. Consequently, forecasting practices are categorized into four types: 

1. Sales forecasting 

Sales forecasting entails predicting the amounts of products/services you expect to sell within a projected fiscal period. There are two sales forecasting methodologies: top-down forecasting and bottom-up forecasting. 

Sales forecasting has many uses and benefits, including budgeting and planning production cycles. It also helps companies manage and allocate resources more efficiently. 

2. Cash flow forecasting 

Cash flow forecasting  entails estimating the flow of cash in and out of the company over a set fiscal period. It's based on factors such as income and expenses. It has many uses and benefits, including identifying immediate funding needs and budgeting. However, it is worth noting that cash flow financial forecasting is more accurate over a short term. 

3. Budget forecasting 

As a financial guide for your business' future, a budget creates certain expectations about your company's performance. Budget forecasting aims to determine the ideal outcome of the budget, assuming that everything proceeds as planned. It relies on the budget's data, which relies on financial forecasting data. 

4. Income forecasting 

Income forecasting entails analyzing the company's past revenue performance and current growth rate to estimate future income. It is integral to doing  cash flow  and balance sheet forecasting. Additionally, the company's investors, suppliers, and other concerned third parties use this data to make crucial decisions. For example, suppliers use it when determining how much to credit the company in supplies. 

How to do financial forecasting in 7 steps 

Many integral aspects of your company's current and future operations hinge on the results of your financial forecasts. For example, forecasting results will influence investors' decisions, determine how much your company can get in credit, and more. 

As such, accuracy cannot be overemphasized. Here is a step-by-step guide to ensure that you do it right: 

1. Define the purpose of a financial forecast 

What do you hope to learn from the financial forecast? Do you hope to estimate how many units of your products or services you will sell? Or perhaps you wish to see how the company's current budget will shape its future? Defining your financial forecast's purpose is essential to determining which metrics and factors to consider when doing it. 

2. Gather past financial statements and historical data 

One of the components of financial forecasting involves analyzing past financial data, as explained. As such, it is important to gather all relevant historical  data and records , including: 

• Liabilities 
• Investments 
• Expenditures 
• Comprehensive income 
• Earnings per share 
• Fixed costs

It's important to ensure that you gather all required information as your financial forecast's results will be inaccurate if you exclude relevant data.

3. Choose a time frame for your forecast 

Financial forecasts are designed to give business owners an insight into the company's future. You get to decide how far into the future to look, and it can range from several weeks to several years. However, most companies do forecasts for one fiscal year. 

Financial forecasts change over time as factors such as business and market trends change. Consequently, it is worth noting that financial forecasting is more accurate in the short term than in the long term.

4. Choose a financial forecast method 

There are two financial forecasting methods: 

• Quantitative forecasting uses historical information and data to identify trends, reliable patterns, and trends. 
• Qualitative forecasting analyzes experts' opinions and sentiments about the company and market as a whole. 

Each method is suitable for different uses and has its strengths and shortcomings. However, qualitative forecasting is more suitable for startups without past data to which they can refer. 

5. Document and monitor results 

Financial forecasts are never 100% accurate and tend to change over time. As such, it is important to document and monitor your forecast's results over time, especially after major internal and external developments. It is also important to update your forecasts to reflect the latest developments. Using  forecasting software  to automate related tasks may help too.

6. Analyze financial data 

Regularly analyzing financial data is the best way to tell whether your financial forecasts are accurate. Additionally, continuous financial management and analysis helps you prepare better for the next financial forecast and gives you crucial insights into the company's current financial performance. 

7. Repeat based on the previously defined time frame 

Smart companies conduct regular financial forecasting to stay in the know and in control. As such, it is advisable to repeat the process once the time period set for the current financial forecast elapses. It's also prudent to keep collecting, recording, and analyzing data to improve your financial forecasts' accuracy.

Get accurate metrics for financial forecasting—absolutely free 

An efficient system of collecting, storing, and analyzing data is necessary for accurate financial forecasting. ProfitWell Metrics is a subscription analytics software designed to do all of this on one platform. Some of the metrics that you can get using this program include: 

• Monthly and annual recurring revenues 
• Market and customer segments 
• Customer acquisition and retention 
• Customer lifetime value 
• Churn rate 
• The average revenue per user 

ProfitWell Metrics collects and records all  important metrics , giving you enough data to work with when conducting a financial forecast. Additionally, the data collected in real-time offers crucial insights to help you update your forecasts and other projects accordingly. 

ProfitWell Metrics also integrates seamlessly with other popular data analytics programs, including Google Sheets and Stripe. More importantly, it's 100% free and secure. 

Take the headache out of growing your software business

We handle your payments, tax, subscription management and more, so you can focus on growing your software and subscription business.

Financial forecasting FAQs 

Some of the most frequently asked questions regarding financial forecasting include: 

What is the role of forecasting in financial planning? 

Financial forecasting estimates important financial metrics such as sales, income, and future revenue. These metrics are crucial for finance-related operations such as budgeting and financial planning as a whole. Consequently, forecasting functions as a guiding tool (or marking scheme) for financial planning. 

What is the difference between financial forecasting and modeling? 

On the one hand, financial forecasting entails predicting the business' future performance. On the other hand, financial modeling entails simulating how financial forecasts and other data may affect the company's future if everything goes according to plan. Financial modeling is done for very specific and often discrete purposes. 

What is the difference between financial forecasting and budgeting? 

Financial forecasting and budgeting work in tandem and are often misinterpreted as meaning the same thing. However, financial forecasting entails estimating and predicting the company's future performance (financially and in other aspects). On the other hand, budgeting is the company's financial expectations for the future (expectations based on financial forecasts and other data). 

What are the three pro forma statements needed for financial forecasting? 

Pro forma statements are financial reports designed to give insights into how different scenarios would play out based on hypothetical circumstances. There are three pro forma statements: 

• Pro forma statements of income 
• Pro forma cash flow statements 
• Pro forma balance sheets 

Pro forma statements may be hypothetical, but they help companies prepare for an uncertain future. Consequently, they're useful when conducting financial forecasts. 

Related reading

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

How To Create Financial Projections for Your Business

Learn how to anticipate your business’s financial performance

• Understanding Financial Projections & Forecasting

Why Forecasting Is Critical for Your Business

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

Maskot / Getty Images

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

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

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

Key Takeaways

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

Understanding Financial Projections and Forecasting

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

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

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

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

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

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

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

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

Income Statement

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

Balance Sheet

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

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

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

Cash Flow Statement

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

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

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

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

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

Projecting Sales

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

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

Income Statement Calculations

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

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

Anticipate Fixed Costs

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

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

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

Find Your Break-Even Point

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

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

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

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

Plan for the Unexpected

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

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

How do you make financial projections for startups?

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

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

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

What are the benefits associated with forecasting business finances?

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

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

How many years should your financial forecast be?

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

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

Score. " Financial Projections Template ."

What's Planergy?

Modern Spend Management and Accounts Payable software.

Helping organizations spend smarter and more efficiently by automating purchasing and invoice processing.

We saved more than $1 million on our spend in the first year and just recently identified an opportunity to save about $10,000 every month on recurring expenses with Planergy.

Cristian Maradiaga

Download a free copy of "preparing your ap department for the future", to learn:.

• How to transition from paper and excel to eInvoicing.
• How AP can improve relationships with your key suppliers.
• How to capture early payment discounts and avoid late payment penalties.
• How better management in AP can give you better flexibility for cash flow management.

Business Plan Financial Projections: How To Create Accurate Targets

• Written by Keith Murphy
• 16 min read

Small businesses and startups have a lot riding on their ability to create effective and accurate financial projections as part of their business plan. Solid financials are a strong enticement for investors, after all, and can help new businesses chart a course that will take them beyond the legendendarily difficult first year and into a productive and profitable future.

But the need for business owners to look ahead in order to secure funding, increase profits, and make intelligent financial decisions doesn’t end when startups become full-fledged businesses—and business plan financial projections aren’t just for startups. Existing businesses can also put them to good use by harvesting insights from their existing financial statements and creating sales projections and other financial forecasts that guide and improve their ongoing business planning.

What Are Business Plan Financial Projections?

Successful companies plan ahead, looking as best they can into the near and distant future to chart a course to growth, innovation, and competitive strength. Financial projections, both as part of an initial business plan and as part of ongoing business planning, use a company’s financial statements to help business owners forecast their upcoming expenses and revenue in a strategically useful way.

Most businesses use two types of financial projections:

• Short-term projections are broken down by month and generally cover the coming 12 months. They provide a guide companies can use to monitor and adjust their financial activity to set and hit targets for the financial year. In the first year, short-term projections will be entirely estimated, but in subsequent years, historical data can be used to help fine-tune them for greater accuracy and strategic utility.
• Long-term projections are focused on the coming three to five years and are generally used to secure investment (both initial and ongoing), provide a strategic roadmap for the company’s growth, or both.

For startups, creating financial projections is part of their initial business plan. Providing financial forecasts banks and potential investors can use to determine the financial viability of a business is key to obtaining financing and investments needed to get the business off the ground.

For existing businesses—for whom an initial business plan has evolved into business planning—financial projections are useful in attracting investors who want to see clear estimates for upcoming revenue, expenses, and potential growth. They’re also helpful in securing loans and lines of credit from financial institutions for the same reason. And even if you’re not trying to get funding or investments, financial projections provide a useful framework for building budgets focused on growth and competitive advantage.

So whether you’re a small business owner, an aspiring tycoon starting a new business, or part of the financial team at a well-established corporation, what matters most is viewing financial projections as a living, breathing reference tool that can help you plan and budget for growth in a realistic way while still setting aspirational goals for your business.

Financial projections, both as part of an initial business plan and as part of ongoing business planning, use a company’s financial statements to help business owners forecast their upcoming expenses and revenue in a strategically useful way.

Financial Projections: Core Components

Whether you’re preparing them as part of your business plan or to enhance your business planning, you’ll need the same financial statements to prepare financial projections: an income statement, a cash-flow statement, and a balance sheet.

• Income statements , sometimes called profit and loss statements , provide detailed information on your company’s revenue and expenses for a given period (e.g., a quarter, year, or multi-year period).
• Cash flow statements provide a comprehensive view of cash flowing into and out of a business. They record all cash flow from operations, investment, and financing activities.
• Balance sheets are used to showcase a company’s assets, liabilities, and owner’s equity for a specific period.

How to Create Financial Projections

The process of creating financial projections is the same whether you’re drafting a business plan or creating forecasts for an existing business. The primary difference is whether you’ll draw on your own research and expertise (a new business or startup business) or use historical data (existing businesses).

Keep in mind that while you’ll create the necessary documents separately, you’ll most likely finish them by consulting each of them as needed. For example, your sales forecast might change once you prepare your cash-flow statement. The best approach is to view each document as both its own piece of the financial projection puzzle and a reference for the others; this will help ensure you can assemble comprehensive and clear financial projections.

1. Start with a Sales Projection

A sales forecast is the first step in creating your income statement. You can start with a one, three, or five-year projection, but keep in mind that, without historical financial data, accuracy may decrease over time. It’s best to start with monthly income statements until you reach your projected break-even , which is the point at which revenue exceeds total operating expenses and you show a profit. Once you hit the break-even, you can transition to annual income statements.

Also, keep in mind factors outside of sales; market conditions, global environmental, political, and health concerns, sourcing challenges (including pricing changes and increased variable costs) and other business disruptors can put the kibosh on your carefully constructed forecasts if you leave them out of your considerations.

Start with a reasonable estimate of the units sold for the forecast period, and multiply them by the price per unit. This value is your total sales for the period.

Next, estimate the total cost of producing these units (i.e., the cost of goods sold , or COGS; sometimes called cost of sales ) by multiplying the per-unit cost by the number of units produced.

Deducting your COGS from your estimated sales yields your gross profit margin.

From the gross margin, subtract expenses such as wages, marketing costs, rent, and other operating expenses. The result is your projected operating income , or net income .

Using these figures, you can create an income statement:

2. Cash Flow Statement

Tracking your estimated cash inflows and outflows from investment and financing, combined with the cash generated by business operations, is the purpose of a cash flow projection .

Investment activities might include, for example, purchasing real estate or investing in research and development outside of daily operations.

Financing activities include cash inflows from investor funding or business loans, as well as cash outflows to repay debts or pay dividends to shareholders.

A reliable and accurate cash flow projection is essential to managing your working capital effectively and ensuring you have all the cash you need to cover your ongoing obligations while still having enough left to invest in growth and innovation or cover emergencies.

Drawing from our income statement, we can create a basic cash flow statement:

3. The Balance Sheet

Providing a “snapshot” of your businesses’ financial performance for a given period of time, the balance sheet contains your company’s assets, liabilities, and owner’s equity.

Assets include inventory, real estate, and capital, while liabilities represent financial obligations and include accounts payable, bank loans, and other debt.

Owner’s equity represents the amount remaining once liabilities have been paid.

Ideally, over time your company’s balance sheet will reflect your growth through a reduction of liabilities and an increase in owner’s equity.

We can complete our triumvirate of financial statements with a basic balance sheet:

Best Practices for Effective Financial Projections

Like a lot of other business processes, financial planning can be complex, time-consuming, and even frustrating if you’re still using manual workflows and paper documents or basic spreadsheet-style applications such as Microsoft Excel. You can get free templates for basic financial projections from the Service Corps of Retired Executives (SCORE), but even templates can only take you so far.

Without a doubt, the best advantage you can give yourself in creating effective and accurate financial projections—whether they’re for the financial section of your business plan or simply part of your ongoing business planning—is to invest in comprehensive procure-to-pay (P2P) software such as Planergy.

In addition to helpful templates, best-in-class P2P software also provides a rich array of real-time data analysis, reporting, and forecasting tools that make it easy to transform historical data (or market research) into accurate forecasts. In addition, artificial intelligence and process automation make it easy to collect, organize, manage and share your data with all internal stakeholders, so everyone has the information they need to create the most useful and complete forecasts and projections possible.

Beyond investing in P2P software, you can also improve the quality and accuracy of your financial projections by:

• Doing your homework. Invest in financial statement analysis and ratio analysis, with a focus not just on your own company, but your industry and the market in general. Learn the current ratios used for liquidity analysis, profitability, and debt and compare them to your own to get a more nuanced and useful understanding of how your company performs internally and within the context of the marketplace.
• Keeping it real. It can be all too easy to get carried away with pie-in-the-sky optimism when forecasting the future of your business. Rose-colored glasses aren’t exclusive to startups and small businesses; over-inflated estimates can hobble even veteran organizations if they don’t practice good data discipline and temper their hopes with practical considerations. Focus on creating realistic, but positive, projections, and you won’t have to worry about investors or lenders glancing askance at your hard work.
• Hoping for the best, but planning for the worst. Run two scenarios when performing your financial projections: the best-case scenario where everything goes perfectly to plan, and a worse-case scenario where Murphy’s Law holds sway. While actual performance will undoubtedly fall somewhere in between the two, having an upper and lower boundary appeals to investors and lenders who are assessing your company’s financial viability.

Financial Projections Help You Reach Your Goals for Growth

From startups to global corporations, every business needs reliable tools for financial forecasting. Take the time to create well-researched, data-driven financial projections, and you’ll be well-equipped to attract investors, secure funding, and chart a course for greater profits, growth, and performance in today’s competitive marketplace.

What’s your goal today?

1. use planergy to manage purchasing and accounts payable.

• Read our case studies, client success stories, and testimonials.
• Visit our “Solutions” page to see the areas of your business we can help improve to see if we’re a good fit for each other.
• Learn about us, and our long history of helping companies just like yours.

2. Download our guide “Preparing Your AP Department For The Future”

3. learn best practices for purchasing, finance, and more.

Browse hundreds of articles , containing an amazing number of useful tools, techniques, and best practices. Many readers tell us they would have paid consultants for the advice in these articles.

Related Posts

The Future of FP&A: How The Role Is Evolving With The Use Of Real-Time Data

• 17 min read

Days Sales Outstanding: What Is It and How To Calculate It

• 19 min read

Budgeting In UK Schools: MAT, Academy Budgeting Challenges and Best Practices

Procurement.

• Purchasing Software
• Purchase Order Software
• Procurement Solutions
• Procure-to-Pay Software
• E-Procurement Software
• PO System For Small Business
• Spend Analysis Software
• Vendor Management Software
• Inventory Management Software

AP & FINANCE

• Accounts Payable Software
• AP Automation Software
• Compliance Management Software
• Business Budgeting Software
• Workflow Automation Software
• Integrations
• Reseller Partner Program

Business is Our Business

Stay up-to-date with news sent straight to your inbox

Sign up with your email to receive updates from our blog

This website uses cookies

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners who may combine it with other information that you’ve provided to them or that they’ve collected from your use of their services.

Read our privacy statement 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.

Free Financial Templates for a Business Plan

By Andy Marker | July 29, 2020

• Share on Facebook
• Share on LinkedIn

Link copied

In this article, we’ve rounded up expert-tested financial templates for your business plan, all of which are free to download in Excel, Google Sheets, and PDF formats.

Included on this page, you’ll find the essential financial statement templates, including income statement templates , cash flow statement templates , and balance sheet templates . Plus, we cover the key elements of the financial section of a business plan .

Financial Plan Templates

Download and prepare these financial plan templates to include in your business plan. Use historical data and future projections to produce an overview of the financial health of your organization to support your business plan and gain buy-in from stakeholders

Business Financial Plan Template

Use this financial plan template to organize and prepare the financial section of your business plan. This customizable template has room to provide a financial overview, any important assumptions, key financial indicators and ratios, a break-even analysis, and pro forma financial statements to share key financial data with potential investors.

Download Financial Plan Template

Word | PDF | Smartsheet

Financial Plan Projections Template for Startups

This financial plan projections template comes as a set of pro forma templates designed to help startups. The template set includes a 12-month profit and loss statement, a balance sheet, and a cash flow statement for you to detail the current and projected financial position of a business.

‌ Download Startup Financial Projections Template

Excel | Smartsheet

Income Statement Templates for Business Plan

Also called profit and loss statements , these income statement templates will empower you to make critical business decisions by providing insight into your company, as well as illustrating the projected profitability associated with business activities. The numbers prepared in your income statement directly influence the cash flow and balance sheet forecasts.

Pro Forma Income Statement/Profit and Loss Sample

Use this pro forma income statement template to project income and expenses over a three-year time period. Pro forma income statements consider historical or market analysis data to calculate the estimated sales, cost of sales, profits, and more.

‌ Download Pro Forma Income Statement Sample - Excel

Small Business Profit and Loss Statement

Small businesses can use this simple profit and loss statement template to project income and expenses for a specific time period. Enter expected income, cost of goods sold, and business expenses, and the built-in formulas will automatically calculate the net income.

‌ Download Small Business Profit and Loss Template - Excel

3-Year Income Statement Template

Use this income statement template to calculate and assess the profit and loss generated by your business over three years. This template provides room to enter revenue and expenses associated with operating your business and allows you to track performance over time.

Download 3-Year Income Statement Template

For additional resources, including how to use profit and loss statements, visit “ Download Free Profit and Loss Templates .”

Cash Flow Statement Templates for Business Plan

Use these free cash flow statement templates to convey how efficiently your company manages the inflow and outflow of money. Use a cash flow statement to analyze the availability of liquid assets and your company’s ability to grow and sustain itself long term.

Simple Cash Flow Template

Use this basic cash flow template to compare your business cash flows against different time periods. Enter the beginning balance of cash on hand, and then detail itemized cash receipts, payments, costs of goods sold, and expenses. Once you enter those values, the built-in formulas will calculate total cash payments, net cash change, and the month ending cash position.

Download Simple Cash Flow Template

12-Month Cash Flow Forecast Template

Use this cash flow forecast template, also called a pro forma cash flow template, to track and compare expected and actual cash flow outcomes on a monthly and yearly basis. Enter the cash on hand at the beginning of each month, and then add the cash receipts (from customers, issuance of stock, and other operations). Finally, add the cash paid out (purchases made, wage expenses, and other cash outflow). Once you enter those values, the built-in formulas will calculate your cash position for each month with.

‌ Download 12-Month Cash Flow Forecast

3-Year Cash Flow Statement Template Set

Use this cash flow statement template set to analyze the amount of cash your company has compared to its expenses and liabilities. This template set contains a tab to create a monthly cash flow statement, a yearly cash flow statement, and a three-year cash flow statement to track cash flow for the operating, investing, and financing activities of your business.

Download 3-Year Cash Flow Statement Template

For additional information on managing your cash flow, including how to create a cash flow forecast, visit “ Free Cash Flow Statement Templates .”

Balance Sheet Templates for a Business Plan

Use these free balance sheet templates to convey the financial position of your business during a specific time period to potential investors and stakeholders.

Small Business Pro Forma Balance Sheet

Small businesses can use this pro forma balance sheet template to project account balances for assets, liabilities, and equity for a designated period. Established businesses can use this template (and its built-in formulas) to calculate key financial ratios, including working capital.

Download Pro Forma Balance Sheet Template

Monthly and Quarterly Balance Sheet Template

Use this balance sheet template to evaluate your company’s financial health on a monthly, quarterly, and annual basis. You can also use this template to project your financial position for a specified time in the future. Once you complete the balance sheet, you can compare and analyze your assets, liabilities, and equity on a quarter-over-quarter or year-over-year basis.

Download Monthly/Quarterly Balance Sheet Template - Excel

Yearly Balance Sheet Template

Use this balance sheet template to compare your company’s short and long-term assets, liabilities, and equity year-over-year. This template also provides calculations for common financial ratios with built-in formulas, so you can use it to evaluate account balances annually.

Download Yearly Balance Sheet Template - Excel

For more downloadable resources for a wide range of organizations, visit “ Free Balance Sheet Templates .”

Sales Forecast Templates for Business Plan

Sales projections are a fundamental part of a business plan, and should support all other components of your plan, including your market analysis, product offerings, and marketing plan . Use these sales forecast templates to estimate future sales, and ensure the numbers align with the sales numbers provided in your income statement.

Basic Sales Forecast Sample Template

Use this basic forecast template to project the sales of a specific product. Gather historical and industry sales data to generate monthly and yearly estimates of the number of units sold and the price per unit. Then, the pre-built formulas will calculate percentages automatically. You’ll also find details about which months provide the highest sales percentage, and the percentage change in sales month-over-month. 

Download Basic Sales Forecast Sample Template

12-Month Sales Forecast Template for Multiple Products

Use this sales forecast template to project the future sales of a business across multiple products or services over the course of a year. Enter your estimated monthly sales, and the built-in formulas will calculate annual totals. There is also space to record and track year-over-year sales, so you can pinpoint sales trends.

Download 12-Month Sales Forecasting Template for Multiple Products

3-Year Sales Forecast Template for Multiple Products

Use this sales forecast template to estimate the monthly and yearly sales for multiple products over a three-year period. Enter the monthly units sold, unit costs, and unit price. Once you enter those values, built-in formulas will automatically calculate revenue, margin per unit, and gross profit. This template also provides bar charts and line graphs to visually display sales and gross profit year over year.

Download 3-Year Sales Forecast Template - Excel

For a wider selection of resources to project your sales, visit “ Free Sales Forecasting Templates .”

Break-Even Analysis Template for Business Plan

A break-even analysis will help you ascertain the point at which a business, product, or service will become profitable. This analysis uses a calculation to pinpoint the number of service or unit sales you need to make to cover costs and make a profit.

Break-Even Analysis Template

Use this break-even analysis template to calculate the number of sales needed to become profitable. Enter the product's selling price at the top of the template, and then add the fixed and variable costs. Once you enter those values, the built-in formulas will calculate the total variable cost, the contribution margin, and break-even units and sales values.

Download Break-Even Analysis Template

For additional resources, visit, “ Free Financial Planning Templates .”

Business Budget Templates for Business Plan

These business budget templates will help you track costs (e.g., fixed and variable) and expenses (e.g., one-time and recurring) associated with starting and running a business. Having a detailed budget enables you to make sound strategic decisions, and should align with the expense values listed on your income statement.

Startup Budget Template

Use this startup budget template to track estimated and actual costs and expenses for various business categories, including administrative, marketing, labor, and other office costs. There is also room to provide funding estimates from investors, banks, and other sources to get a detailed view of the resources you need to start and operate your business.

Download Startup Budget Template

Small Business Budget Template

This business budget template is ideal for small businesses that want to record estimated revenue and expenditures on a monthly and yearly basis. This customizable template comes with a tab to list income, expenses, and a cash flow recording to track cash transactions and balances.

Download Small Business Budget Template

Professional Business Budget Template

Established organizations will appreciate this customizable business budget template, which  contains a separate tab to track projected business expenses, actual business expenses, variances, and an expense analysis. Once you enter projected and actual expenses, the built-in formulas will automatically calculate expense variances and populate the included visual charts. 

‌ Download Professional Business Budget Template

For additional resources to plan and track your business costs and expenses, visit “ Free Business Budget Templates for Any Company .”

Other Financial Templates for Business Plan

In this section, you’ll find additional financial templates that you may want to include as part of your larger business plan.

Startup Funding Requirements Template

This simple startup funding requirements template is useful for startups and small businesses that require funding to get business off the ground. The numbers generated in this template should align with those in your financial projections, and should detail the allocation of acquired capital to various startup expenses.

Download Startup Funding Requirements Template - Excel

Personnel Plan Template

Use this customizable personnel plan template to map out the current and future staff needed to get — and keep — the business running. This information belongs in the personnel section of a business plan, and details the job title, amount of pay, and hiring timeline for each position. This template calculates the monthly and yearly expenses associated with each role using built-in formulas. Additionally, you can add an organizational chart to provide a visual overview of the company’s structure. 

Download Personnel Plan Template - Excel

Elements of the Financial Section of a Business Plan

Whether your organization is a startup, a small business, or an enterprise, the financial plan is the cornerstone of any business plan. The financial section should demonstrate the feasibility and profitability of your idea and should support all other aspects of the business plan. 

Below, you’ll find a quick overview of the components of a solid financial plan.

• Financial Overview: This section provides a brief summary of the financial section, and includes key takeaways of the financial statements. If you prefer, you can also add a brief description of each statement in the respective statement’s section.
• Key Assumptions: This component details the basis for your financial projections, including tax and interest rates, economic climate, and other critical, underlying factors.
• Break-Even Analysis: This calculation helps establish the selling price of a product or service, and determines when a product or service should become profitable.
• Pro Forma Income Statement: Also known as a profit and loss statement, this section details the sales, cost of sales, profitability, and other vital financial information to stakeholders.
• Pro Forma Cash Flow Statement: This area outlines the projected cash inflows and outflows the business expects to generate from operating, financing, and investing activities during a specific timeframe.
• Pro Forma Balance Sheet: This document conveys how your business plans to manage assets, including receivables and inventory.
• Key Financial Indicators and Ratios: In this section, highlight key financial indicators and ratios extracted from financial statements that bankers, analysts, and investors can use to evaluate the financial health and position of your business.

Need help putting together the rest of your business plan? Check out our free simple business plan templates to get started. You can learn how to write a successful simple business plan  here . 

Visit this  free non-profit business plan template roundup  or download a  fill-in-the-blank business plan template  to make things easy. If you are looking for a business plan template by file type, visit our pages dedicated specifically to  Microsoft Excel ,  Microsoft Word , and  Adobe PDF  business plan templates. Read our articles offering  startup business plan templates  or  free 30-60-90-day business plan templates  to find more tailored options.

Discover a Better Way to Manage Business Plan Financials and Finance Operations

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

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

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

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

How to create a financial forecast for a new business

Table of Contents

What are financial forecasts?

Why are financial forecasts important, measuring success , attracting investors, how can i create a financial forecast for my new business, creating forecasts by researching competitors , creating forecasts by researching your target market.

Running a business requires you to plan ahead frequently. If you don’t and there are unexpected expenses or losses in your future, your business may end up suffering. In order to prevent these kinds of setbacks, business owners create financial forecasts.

This article will provide you with a few ideas on how to make financial forecasts for your business. We’ll cover a few topics, including:

• How can Countingup help me create financial forecasts?

Financial forecasts are basically a prediction of what will happen to your business finances in the future. Most established businesses create them using historical data: the financial events of the previous month provide a rough outline of what to expect, then they adjust the new forecast to account for any events specific to the upcoming month.

This article will focus on creating a financial forecast as a new business, which means you may not have historical financial records available. Fortunately, there are other methods of creating a financial forecast for new businesses.

An important point to remember is the difference between a forecast and a budget . In business, a budget is a document that shows how you would like your company finances to look in the long term. Most companies make them annually, and they cover every aspect of the company’s finances. They should also act more as a goal or an ideal, rather than an actual prediction.

Forecasts, on the other hand, more accurately reflect what’s happening with your business. They cover a shorter period of time and focus on a particular part of your accounts, like sales or cash flow . While a budget can guide the overall direction of your business, you can use forecasts to make more specific and urgent decisions. 

Financial forecasts are vital for a business to measure its success . Although a forecast should be realistic rather than show the perfect financial future for your business, selling much less and spending much more than your forecast indicated means something is going wrong within your company. Always compare your financial forecasts with your actual financial data to ensure your business is improving rather than struggling.

Having a few different high-quality financial forecasts as part of your business plan is an excellent way to attract investors to your business . Accurate forecasts indicate to potential investors that you have a good idea of what the future holds for your company, which will make them more confident when investing.

Of course, people are only likely to invest in your company if the forecasts also show that you’ll be successful, but showing the positive impact their investment could have might persuade them to put money into your business idea.

Researching your competitors is a key part of writing your business plan , but this research is also very valuable for creating forecasts. For example, if your research can dig up competitors’ sales figures or expenses, it will provide a good outline for how your sales and expenses might look, so you can use this as a starting point for making forecasts.

This method is particularly useful if your competitors are registered as limited companies , as these businesses must make their accounts publicly available. Simply find your competition on the government website Companies House , and you can examine their financial data in detail.

Please note that if your competitors are mostly sole traders, this method will be far more difficult to use, as their accounts will not be publicly available. 

Another key subject for research when you’re starting your business is your target market . A target market is a group that a particular product has the potential to be popular with, so most businesses focus a lot of marketing on attracting their target market. 

With enough research, you can find out how many people in your local area are part of your target market and how much of your product your target market is likely to buy. Once you have this information, you can start making all sorts of financial forecasts.

For example, you can create a sales forecast if you know how large your target market is, as this will give you an idea of how many people will be interested in buying your product. Then, using your sales forecast, you can start checking how much the amount of inventory you’ll need will cost. Once you have this price, you can also create an expense forecast. 

Both these methods are very helpful to new businesses that have no historical financial data. Remember that forecasts based on historical data can be much more accurate, though, so incorporate that data into your forecasts after a couple of months. 

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

Related Resources

What insurance does a self-employed hairdresser need.

As a self-employed hairdresser, you’re open to risks in your everyday work. Whether

What are assets and liabilities in a business?

Anyone going into business needs to be familiar with assets and liabilities. They

Personal car for business use: How does it work?

Access to a car is a must for most businesses, meaning that travel

Advantages and disadvantages of using personal savings in business

Have you got a new business idea? And are you considering using your

How to pay Corporation Tax

Corporation Tax is the main tax your limited company has to pay every

How long do CHAPS & BACS payments take?

If you are making transfers frequently between banks in the UK, you have

11 common costs of running a business

When running a business, the various costs can quickly add up. If you

How to buy a vehicle through a limited company

Buying a vehicle through a limited company works similarly to how you may

What is a sales strategy? (with example)

When you run a small business, it’s important to consider how you’ll optimise

Preparing business packages for distribution

You may think shipping your product is as easy as popping it in

How to use cloud services for a business

The development of cloud computing is a game changer for businesses big and

How do EU imports and exports work?

In January 2022, the UK introduced new EU imports and exports regulations. If

Original text

Financial projections use existing or estimated financial data to forecast your business’s future income and expenses. They often include different scenarios to see how changes to one aspect of your finances (such as higher sales or lower operating expenses) might affect your profitability.

If you need to create financial projections for a startup or existing business, this free, downloadable template includes all the necessary tools.

What Are Financial Projections Used for?

Financial projections are an essential business planning tool for several reasons.

• If you’re starting a business, financial projections help you plan your startup budget, assess when you expect the business to become profitable, and set benchmarks for achieving financial goals.
• If you’re already in business, creating financial projections each year can help you set goals and stay on track.
• When seeking outside financing, startups and existing businesses need financial projections to convince lenders and investors of the business’s growth potential.

What’s Included in Financial Projections?

This financial projections template pulls together several different financial documents, including:

• Startup expenses
• Payroll costs
• Sales forecast
• Operating expenses for the first 3 years of business
• Cash flow statements for the first 3 years of business
• Income statements for the first 3 years of business
• Balance sheet
• Break-even analysis
• Financial ratios
• Cost of goods sold (COGS), and
• Amortization and depreciation for your business.

You can use this template to create the documents from scratch or pull in information from those you’ve already made. The template also includes diagnostic tools to test the numbers in your financial projections and ensure they are within reasonable ranges.

These areas are closely related, so as you work on your financial projections, you’ll find that changes to one element affect the others. You may want to include a best-case and worst-case scenario for all possibilities. Make sure you know the assumptions behind your financial projections and can explain them to others.

Startup business owners often wonder how to create financial projections for a business that doesn’t exist yet. Financial forecasts are continually educated guesses. To make yours as accurate as possible, do your homework and get help. Use the information you unearthed in researching your business plans, such as statistics from industry associations, data from government sources, and financials from similar businesses. An accountant with experience in your industry can help fine-tune your financial projections. So can business advisors such as SCORE mentors.

Once you complete your financial projections, don’t put them away and forget about them. Compare your projections to your financial statements regularly to see how well your business meets your expectations. If your projections turn out to be too optimistic or too pessimistic, make the necessary adjustments to make them more accurate.

*NOTE: The cells with formulas in this workbook are locked. If changes are needed, the unlock code is "1234." Please use caution when unlocking the spreadsheets. If you want to change a formula, we strongly recommend saving a copy of this spreadsheet under a different name before doing so. 

We recommend downloading the  Financial Projections Template Guide in English  or  Espanol .

Do you need help creating your financial projections? Take SCORE’s online course on-demand on financial projections or connect with a SCORE mentor  online or in your community today.

Simple Steps for Starting Your Business: Financial Projections In this online module, you'll learn the importance of financial planning, how to build your financial model, how to understand financial statements and more.

Business Planning & Financial Statements Template Gallery Download SCORE’s templates to help you plan for a new business startup or grow your existing business.

Why Projected Financial Statements Are Essential to the Future Success of Startups Financial statements are vital to the success of any company but particularly start-ups. SCORE mentor Sarah Hadjhamou shares why they are a big part of growing your start-up.

Copyright © 2024 SCORE Association, SCORE.org

Funded, in part, through a Cooperative Agreement with the U.S. Small Business Administration. All opinions, and/or recommendations expressed herein are those of the author(s) and do not necessarily reflect the views of the SBA.

• Sample Plans
• WHY UPMETRICS?

Upmetrics AI Assistant: Simplifying Business Planning through AI-Powered Insights. Learn How

• 400+ Sample Business Plans

Customers Success Stories

Business Plan Course

Strategic Canvas Templates

E-books, Guides & More

Business consultants

Entrepreneurs and Small Business

Accelerators and Incubators

Educators & Business Schools

Students & Scholars

AI Business Plan Generator

Financial Forecasting

AI Assistance

Ai pitch deck generator

Stratrgic Planning

See How Upmetrics Works  →

Small Business Tools

Entrepreneurs & Small Business

Accelerators & Incubators

Business Consultants & Advisors

Strategic Planning

How to Prepare a Financial Plan for Startup Business (w/ example)

Free Financial Statements Template

Ajay Jagtap

• December 7, 2023

13 Min Read

If someone were to ask you about your business financials, could you give them a detailed answer?

Let’s say they ask—how do you allocate your operating expenses? What is your cash flow situation like? What is your exit strategy? And a series of similar other questions.

Instead of mumbling what to answer or shooting in the dark, as a founder, you must prepare yourself to answer this line of questioning—and creating a financial plan for your startup is the best way to do it.

A business plan’s financial plan section is no easy task—we get that.

But, you know what—this in-depth guide and financial plan example can make forecasting as simple as counting on your fingertips.

Ready to get started? Let’s begin by discussing startup financial planning.

What is Startup Financial Planning?

Startup financial planning, in simple terms, is a process of planning the financial aspects of a new business. It’s an integral part of a business plan and comprises its three major components: balance sheet, income statement, and cash-flow statement.

Apart from these statements, your financial section may also include revenue and sales forecasts, assets & liabilities, break-even analysis , and more. Your first financial plan may not be very detailed, but you can tweak and update it as your company grows.

Key Takeaways

• Realistic assumptions, thorough research, and a clear understanding of the market are the key to reliable financial projections.
• Cash flow projection, balance sheet, and income statement are three major components of a financial plan.
• Preparing a financial plan is easier and faster when you use a financial planning tool.
• Exploring “what-if” scenarios is an ideal method to understand the potential risks and opportunities involved in the business operations.

Why is Financial Planning Important to Your Startup?

Poor financial planning is one of the biggest reasons why most startups fail. In fact, a recent CNBC study reported that running out of cash was the reason behind 44% of startup failures in 2022.

A well-prepared financial plan provides a clear financial direction for your business, helps you set realistic financial objectives, create accurate forecasts, and shows your business is committed to its financial objectives.

It’s a key element of your business plan for winning potential investors. In fact, YC considered recent financial statements and projections to be critical elements of their Series A due diligence checklist .

Your financial plan demonstrates how your business manages expenses and generates revenue and helps them understand where your business stands today and in 5 years.

Makes sense why financial planning is important to your startup, doesn’t it? Let’s cut to the chase and discuss the key components of a startup’s financial plan.

Say goodbye to old-school excel sheets & templates

Make accurate financial plan faster with AI

Plans starting from $7/month

Key Components of a Startup Financial Plan

Whether creating a financial plan from scratch for a business venture or just modifying it for an existing one, here are the key components to consider including in your startup’s financial planning process.

Income Statement

An Income statement , also known as a profit-and-loss statement(P&L), shows your company’s income and expenditures. It also demonstrates how your business experienced any profit or loss over a given time.

Consider it as a snapshot of your business that shows the feasibility of your business idea. An income statement can be generated considering three scenarios: worst, expected, and best.

Your income or P&L statement must list the following:

• Cost of goods or cost of sale
• Gross margin
• Operating expenses
• Revenue streams
• EBITDA (Earnings before interest, tax, depreciation , & amortization )

Established businesses can prepare annual income statements, whereas new businesses and startups should consider preparing monthly statements.

Cash flow Statement

A cash flow statement is one of the most critical financial statements for startups that summarize your business’s cash in-and-out flows over a given time.

This section provides details on the cash position of your business and its ability to meet monetary commitments on a timely basis.

Your cash flow projection consists of the following three components:

✅ Cash revenue projection: Here, you must enter each month’s estimated or expected sales figures.

✅ Cash disbursements: List expenditures that you expect to pay in cash for each month over one year.

✅ Cash flow reconciliation: Cash flow reconciliation is a process used to ensure the accuracy of cash flow projections. The adjusted amount is the cash flow balance carried over to the next month.

Furthermore, a company’s cash flow projections can be crucial while assessing liquidity, its ability to generate positive cash flows and pay off debts, and invest in growth initiatives.

Balance Sheet

Your balance sheet is a financial statement that reports your company’s assets, liabilities, and shareholder equity at a given time.

Consider it as a snapshot of what your business owns and owes, as well as the amount invested by the shareholders.

This statement consists of three parts: assets , liabilities, and the balance calculated by the difference between the first two. The final numbers on this sheet reflect the business owner’s equity or value.

Balance sheets follow the following accounting equation with assets on one side and liabilities plus Owner’s equity on the other:

Here is what’s the core purpose of having a balance-sheet:

• Indicates the capital need of the business
• It helps to identify the allocation of resources
• It calculates the requirement of seed money you put up, and
• How much finance is required?

Since it helps investors understand the condition of your business on a given date, it’s a financial statement you can’t miss out on.

Break-even Analysis

Break-even analysis is a startup or small business accounting practice used to determine when a company, product, or service will become profitable.

For instance, a break-even analysis could help you understand how many candles you need to sell to cover your warehousing and manufacturing costs and start making profits.

Remember, anything you sell beyond the break-even point will result in profit.

You must be aware of your fixed and variable costs to accurately determine your startup’s break-even point.

• Fixed costs: fixed expenses that stay the same no matter what.
• Variable costs: expenses that fluctuate over time depending on production or sales.

A break-even point helps you smartly price your goods or services, cover fixed costs, catch missing expenses, and set sales targets while helping investors gain confidence in your business. No brainer—why it’s a key component of your startup’s financial plan.

Having covered all the key elements of a financial plan, let’s discuss how you can create a financial plan for your startup.

How to Create a Financial Section of a Startup Business Plan?

1. determine your financial needs.

You can’t start financial planning without understanding your financial requirements, can you? Get your notepad or simply open a notion doc; it’s time for some critical thinking.

Start by assessing your current situation by—calculating your income, expenses , assets, and liabilities, what the startup costs are, how much you have against them, and how much financing you need.

Assessing your current financial situation and health will help determine how much capital you need for your startup and help plan fundraising activities and outreach.

Furthermore, determining financial needs helps prioritize operational activities and expenses, effectively allocate resources, and increase the viability and sustainability of a business in the long run.

Having learned to determine financial needs, let’s head straight to setting financial goals.

2. Define Your Financial Goals

Setting realistic financial goals is fundamental in preparing an effective financial plan. So, it would help to outline your long-term strategies and goals at the beginning of your financial planning process.

Let’s understand it this way—if you are a SaaS startup pursuing VC financing rounds, you may ask investors about what matters to them the most and prepare your financial plan accordingly.

However, a coffee shop owner seeking a business loan may need to create a plan that appeals to banks, not investors. At the same time, an internal financial plan designed to offer financial direction and resource allocation may not be the same as previous examples, seeing its different use case.

Feeling overwhelmed? Just define your financial goals—you’ll be fine.

You can start by identifying your business KPIs (key performance indicators); it would be an ideal starting point.

3. Choose the Right Financial Planning Tool

Let’s face it—preparing a financial plan using Excel is no joke. One would only use this method if they had all the time in the world.

Having the right financial planning software will simplify and speed up the process and guide you through creating accurate financial forecasts.

Many financial planning software and tools claim to be the ideal solution, but it’s you who will identify and choose a tool that is best for your financial planning needs.

Create a Financial Plan with Upmetrics in no time

Enter your Financial Assumptions, and we’ll calculate your monthly/quarterly and yearly financial projections.

Start Forecasting

4. Make Assumptions Before Projecting Financials

Once you have a financial planning tool, you can move forward to the next step— making financial assumptions for your plan based on your company’s current performance and past financial records.

You’re just making predictions about your company’s financial future, so there’s no need to overthink or complicate the process.

You can gather your business’ historical financial data, market trends, and other relevant documents to help create a base for accurate financial projections.

After you have developed rough assumptions and a good understanding of your business finances, you can move forward to the next step—projecting financials.

5. Prepare Realistic Financial Projections

It’s a no-brainer—financial forecasting is the most critical yet challenging aspect of financial planning. However, it’s effortless if you’re using a financial planning software.

Upmetrics’ forecasting feature can help you project financials for up to 7 years. However, new startups usually consider planning for the next five years. Although it can be contradictory considering your financial goals and investor specifications.

Following are the two key aspects of your financial projections:

Revenue Projections

In simple terms, revenue projections help investors determine how much revenue your business plans to generate in years to come.

It generally involves conducting market research, determining pricing strategy , and cash flow analysis—which we’ve already discussed in the previous steps.

The following are the key components of an accurate revenue projection report:

• Market analysis
• Sales forecast
• Pricing strategy
• Growth assumptions
• Seasonal variations

This is a critical section for pre-revenue startups, so ensure your projections accurately align with your startup’s financial model and revenue goals.

Expense Projections

Both revenue and expense projections are correlated to each other. As revenue forecasts projected revenue assumptions, expense projections will estimate expenses associated with operating your business.

Accurately estimating your expenses will help in effective cash flow analysis and proper resource allocation.

These are the most common costs to consider while projecting expenses:

• Fixed costs
• Variable costs
• Employee costs or payroll expenses
• Operational expenses
• Marketing and advertising expenses
• Emergency fund

Remember, realistic assumptions, thorough research, and a clear understanding of your market are the key to reliable financial projections.

6. Consider “What if” Scenarios

After you project your financials, it’s time to test your assumptions with what-if analysis, also known as sensitivity analysis.

Using what-if analysis with different scenarios while projecting your financials will increase transparency and help investors better understand your startup’s future with its best, expected, and worst-case scenarios.

Exploring “what-if” scenarios is the best way to better understand the potential risks and opportunities involved in business operations. This proactive exercise will help you make strategic decisions and necessary adjustments to your financial plan.

7. Build a Visual Report

If you’ve closely followed the steps leading to this, you know how to research for financial projections, create a financial plan, and test assumptions using “what-if” scenarios.

Now, we’ll prepare visual reports to present your numbers in a visually appealing and easily digestible format.

Don’t worry—it’s no extra effort. You’ve already made a visual report while creating your financial plan and forecasting financials.

Check the dashboard to see the visual presentation of your projections and reports, and use the necessary financial data, diagrams, and graphs in the final draft of your financial plan.

Here’s what Upmetrics’ dashboard looks like:

8. Monitor and Adjust Your Financial Plan

Even though it’s not a primary step in creating a good financial plan, it’s quite essential to regularly monitor and adjust your financial plan to ensure the assumptions you made are still relevant, and you are heading in the right direction.

There are multiple ways to monitor your financial plan.

For instance, you can compare your assumptions with actual results to ensure accurate projections based on metrics like new customers acquired and acquisition costs, net profit, and gross margin.

Consider making necessary adjustments if your assumptions are not resonating with actual numbers.

Also, keep an eye on whether the changes you’ve identified are having the desired effect by monitoring their implementation.

And that was the last step in our financial planning guide. However, it’s not the end. Have a look at this financial plan example.

Startup Financial Plan Example

Having learned about financial planning, let’s quickly discuss a coffee shop startup financial plan example prepared using Upmetrics.

Important Assumptions

• The sales forecast is conservative and assumes a 5% increase in Year 2 and a 10% in Year 3.
• The analysis accounts for economic seasonality – wherein some months revenues peak (such as holidays ) and wanes in slower months.
• The analysis assumes the owner will not withdraw any salary till the 3rd year; at any time it is assumed that the owner’s withdrawal is available at his discretion.
• Sales are cash basis – nonaccrual accounting
• Moderate ramp- up in staff over the 5 years forecast
• Barista salary in the forecast is $36,000 in 2023.
• In general, most cafes have an 85% gross profit margin
• In general, most cafes have a 3% net profit margin

Projected Balance Sheet

Projected Cash-Flow Statement

Projected Profit & Loss Statement

Break Even Analysis

Start Preparing Your Financial Plan

We covered everything about financial planning in this guide, didn’t we? Although it doesn’t fulfill our objective to the fullest—we want you to finish your financial plan.

Sounds like a tough job? We have an easy way out for you—Upmetrics’ financial forecasting feature. Simply enter your financial assumptions, and let it do the rest.

So what are you waiting for? Try Upmetrics and create your financial plan in a snap.

Build your Business Plan Faster

with step-by-step Guidance & AI Assistance.

Frequently Asked Questions

How often should i update my financial projections.

Well, there is no particular rule about it. However, reviewing and updating your financial plan once a year is considered an ideal practice as it ensures that the financial aspirations you started and the projections you made are still relevant.

How do I estimate startup costs accurately?

You can estimate your startup costs by identifying and factoring various one-time, recurring, and hidden expenses. However, using a financial forecasting tool like Upmetrics will ensure accurate costs while speeding up the process.

What financial ratios should startups pay attention to?

Here’s a list of financial ratios every startup owner should keep an eye on:

• Net profit margin
• Current ratio
• Quick ratio
• Working capital
• Return on equity
• Debt-to-equity ratio
• Return on assets
• Debt-to-asset ratio

What are the 3 different scenarios in scenario analysis?

As discussed earlier, Scenario analysis is the process of ascertaining and analyzing possible events that can occur in the future. Startups or businesses often consider analyzing these three scenarios:

• base-case (expected) scenario
• Worst-case scenario
• best case scenario.

About the Author

Ajay is a SaaS writer and personal finance blogger who has been active in the space for over three years, writing about startups, business planning, budgeting, credit cards, and other topics related to personal finance. If not writing, he’s probably having a power nap. Read more

Reach Your Goals with Accurate Planning

No Risk – Cancel at Any Time – 15 Day Money Back Guarantee

Popular Templates

• 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

• Metrics Track, analyze, improve - effortlessly.
• Forecast+ Plan for the future, easily.
• Recover Get help with failing charges.
• Cancellation Insights Learn why your customers cancel.
• Segmentation Comparative customer insights.
• Augmentation Make your metrics more insightful.
• Benchmarks How does your company compare?
• Analytics API Extend and integrate Baremetrics.
• Email Reports Scheduled or instant updates.
• Slack Tools The best tool just got better.
• Plans & Pricing
• Founder Chats
• Accelerator
• Wall of Love
• Help Center
• (725) 217-4827

• Cancellation Insights
• Segmentation
• Augmentation
• Analytics API
• Email Reports
• Slack Tools
• 1-855-948-6210

5 Financial Forecasting Models and Examples of Use Cases

Jerusha Songate on May 04, 2021

Table of Contents

More baremetrics articles.

Financial forecasting models are used to predict financial outcomes within a specified area of your business, like recurring revenue or payroll. These models then feed into the overall  financial model  for your SaaS business.

Adopting this approach provides you with invaluable insights into your subscription-based business, helping you calculate costs, improve budgeting, and allocate resources. 

In this article, we’ll have a closer look at five different forecasting methods and present examples of use cases.

Try Baremetrics for free to learn more about how your company could benefit from financial modeling.

What Is Financial Forecasting?

Financial forecasting is trying to predict financial outcomes for an organization. Having access to a prognosis helps decision-makers create meaningful strategies and make critical decisions about corporate development.

One of the most coveted numbers that most businesses want to predict is, of course, revenue. But financial forecasting can concern any business area, such as payroll, fixed costs, variable costs, income statements, balance sheets, and capital expenditures.

Many businesses try to create forecasts using Excel but often find that to create thorough financial analysis, financial planning, and long-term budgeting, they need something more advanced. 

Read more: How to Build a Financial Model

Here are five financial forecasting models to help you drive business growth:

1. Top-Down Financial Forecasting Models

This model can come in handy when you want to evaluate a new opportunity and you have no historical data to base your predictions on.

A top-down forecasting model can use the size of a new market as a point of departure and then make a forecast by estimating how much market share your business will be able to grab.

A top-down approach is primarily helpful in the initial phase when you want to evaluate new growth opportunities. 

Read more: The Best Financial Modeling Software for SaaS in 2021

2. Bottom-Up Financial Forecasting Models

If you have access to historical sales data or financial statements, it makes sense to go about your forecasting from the bottom and up. Then you use your existing sales numbers and cash flow statements as the input for calculating future scenarios.

This method will usually be more accurate and more detailed since you are working with actual numbers, so you reduce the assumptions. 

Interested in how your business can benefit from a modern tool for financial modeling? Try Baremetrics for free !

3. Delphi Forecasting Models

The Delphi method is a model where you get your forecast from a group of experts, leveraging a facilitator and continuously collaboratively iterating on hypothesis and analysis to reach a consensus opinion.

A series of questionnaires form the basis of this process, where every questionnaire builds on the previous iteration. This is an efficient way to make sure the entire group gets access to all information.

4. Correlation-Based Forecasting Models

Another way to look at financial forecasting is to identify correlating variables and track how they follow each other. This is a widespread financial forecasting model.

This way of predicting financial outcomes can help decision-makers understand make forecasts based on the relationships between prices and costs, supply and demand, and other factors that affect each other.

5. Statistical Forecasting Models

Statistical models (also called quantitative forecasting models) create relationships between the findings of other disciplines. This approach often uses Gaussian distribution analysis to fit financial inputs and attempts into a classic standard distribution curve.

This can help you figure out how your operation compares to other similar businesses, and you can use this method for benchmarking., growth rate, profitability, and decision-making. 

Read more: The New Era of SaaS Forecasting

Power Laws in Financial Forecasting

Power laws represent a complex and challenging analytic model that is sometimes used in financial forecasting models. They are mathematical functions describing proportional movements between assets.

Power laws are prevalent in the stock market and corporate finance, where they are popular because of their ability to highlight and break down specific momentum trends quickly.

The knowledge derived from using the Power laws approach can be an excellent guide for resource allocation, capital purchases, marketing, and other types of similar internal investments.

Interested in learning more about how you can grow your SaaS company’s revenue?

Read our article: How To Improve Revenue Growth

How Baremetrics Can Help!

Financial forecasting models are an attempt to look into the financial future of a business and estimate what that future will hold. There is never 100% accuracy in the results, unlike working with a financial analyst.

However, financial forecasts are an essential tool in budgeting and growth planning and when making financial decisions.

Baremetrics optimizes forecasting with a broad range of  real-time metrics for churn, MRR , cost of acquisition , business valuation, and other key performance indicators that pertain to financial performance.

The result? SaaS and subscription-based companies like yours make more efficient business decisions and create profitable growth strategies. Investing in this forecasting software is a great way to maximize the impact that resource allocations have on your company’s bottom line. 

Building a comprehensive, growth-focused financial model takes some work and effort to do. But it’s an investment that is worthwhile since the benefits of reliable financial data predictions are critical to growing your business.

Try Baremetrics for free to learn more about how your company could benefit from solid financial modeling.

Baremetrics' financial forecasting application helps make accurate predictions through features such as data integration, historical data analysis, scenario modeling, intelligent algorithms, and real-time updates. It provides clear visualizations of forecasted outcomes. For more information visit:  https://baremetrics.com/features/forecasting  

Financial forecasting software provides several benefits for businesses, including fine-tuning business plans, generating budget templates, tracking historical budgets, comparing projections with actual figures, consolidating budgets across departments, planning for different scenarios, and monitoring budgeting process performance.

Learn about financial forecasting software for SaaS businesses.

• How can financial forecasting tool aid in budget planning and decision-making processes? A financial forecasting tool aids budget planning and decision-making by providing accurate projections, enabling scenario analysis, facilitating resource allocation, monitoring performance, supporting collaboration, and assisting in long-term planning.
• What are the key features to look for when selecting financial forecasting software? When selecting financial forecasting software, key features to look for include: Accurate financial projections Flexible scenario modeling Integration with financial data sources Historical data analysis Collaborative forecasting Real-time tracking and reporting Integration with budgeting and planning Scalability and customization. By considering these key features, you can select financial forecasting software that meets your business requirements and empowers you to make informed financial decisions.
• Can you recommend any software for financial forecasting that integrates with accounting systems? Baremetrics is an essential tool for SaaS financial forecasting software. Baremetrics offers seamless integration with QuickBooks Online and Xero, allowing for the synchronization of financial data between the software and these accounting platforms. This integration ensures accurate and up-to-date financial forecasting and analysis .

Jerusha Songate

Jerusha has a strong interest in SaaS and finding new business opportunities. She writes for Baremetrics as part of her passion for business journalism.

• Control Center
• People Insights
• Smart Dashboards
• Trial Insights
• FirstOfficer
• Stripe Analytics & Dunning
• Affiliate Partners
• Build vs Buy
• Terms of Use

Financial Assumptions and Your Business Plan

Written by Dave Lavinsky

Financial assumptions are an integral part of a well-written business plan. You can’t accurately forecast the future without them. Invest the time to write solid assumptions so you have a good foundation for your financial forecast.

Download our Ultimate Business Plan Template here

What are Financial Assumptions?

Financial assumptions are the guidelines you give your business plan to follow. They can range from financial forecasts about costs, revenue, return on investment, and operating and startup expenses. Basically, financial assumptions serve as a forecast of what your business will do in the future. You need to include them so that anyone reading your plan will have some idea of how accurate its projections may be.

Of course, your financial assumptions should accurately reflect the information you’ve given in your business plan and they should be reasonably accurate. You need to keep this in mind when you make them because if you make outlandish claims, it will make people less likely to believe any part of your business plan including other financial projections that may be accurate.

That’s why you always want to err on the side of caution when it comes to financial assumptions for your business plan. The more conservative your assumptions are the more likely you’ll be able to hit them, and the less likely you’ll be off by so much that people will ignore everything in your plan.

Why are Financial Assumptions Important?

Many investors skip straight to the financial section of your business plan. It is critical that your assumptions and projections in this section be realistic. Plans that show penetration, operating margin, and revenues per employee figures that are poorly reasoned; internally inconsistent, or simply unrealistic greatly damage the credibility of the entire business plan. In contrast, sober, well-reasoned financial assumptions and projections communicate operational maturity and credibility.

For instance, if the company is categorized as a networking infrastructure firm, and the business plan projects 80% operating margins, investors will raise a red flag. This is because investors can readily access the operating margins of publicly-traded networking infrastructure firms and find that none have operating margins this high.

As much as possible, the financial assumptions should be based on actual results from your or other firms. As the example above indicates, it is fairly easy to look at a public company’s operating margins and use these margins to approximate your own. Likewise, the business plan should base revenue growth on other firms. 

Many firms find this impossible, since they believe they have a breakthrough product in their market, and no other company compares. In such a case, base revenue growth on companies in other industries that have had breakthrough products. If you expect to grow even faster than they did (maybe because of new technologies that those firms weren’t able to employ), you can include more aggressive assumptions in your business plan as long as you explain them in the text.

The financial assumptions can either enhance or significantly harm your business plan’s chances of assisting you in the capital-raising process. By doing the research to develop realistic assumptions, based on actual results of your or other companies, the financials can bolster your firm’s chances of winning investors. As importantly, the more realistic financials will also provide a better roadmap for your company’s success.

    Finish Your Business Plan Today!

Financial assumptions vs projections.

Financial Assumptions – Estimates of future financial results that are based on historical data, an understanding of the business, and a company’s operational strategy.

Financial Projections – Estimates of future financial results that are calculated from the assumptions factored into the financial model.

The assumptions are your best guesses of what the future holds; the financial projections are numerical versions of those assumptions. 

Key Assumptions By Financial Statement

Below you will find a list of the key business assumptions by the financial statement:

Income Statement

The income statement assumptions should include revenue, cost of goods sold, operating expenses, and depreciation/amortization, as well as any other line items that will impact the income statement.

When you are projecting future operating expenses, you should project these figures based on historical information and then adjust them as necessary with the intent to optimize and/or minimize them.

Balance Sheet

The balance sheet assumptions should include assets, liabilities, and owner’s equity, as well as any other line items that will impact the balance sheet. One of the most common mistakes is not including all cash inflows and outflows.

Cash Flow Statement

Cash flow assumptions should be made, but they do not impact the balance sheet or income statement until actually received or paid. You can include the cumulative cash flow assumption on the financial model to be sure it is included with each year’s projections. 

The cumulative cash flow assumption is useful for showing your investors and potential investors how you will spend the money raised. This line item indicates how much of the initial investment will be spent each year, which allows you to control your spending over time.

Notes to Financial Statements

The notes to financial statements should explain assumptions made by management regarding accounting policies, carrying value of long-lived assets, goodwill impairment testing, contingencies, and income taxes. It is important not only to list these items within the notes but also to provide a brief explanation.

What are the Assumptions Needed in Preparing a Financial Model?

In our article on “ How to Create Financial Projections for Your Business Plan ,” we list the 25+ most common assumptions to include in your financial model. Below are a few of them:

For EACH key product or service you offer:

• What is the number of units you expect to sell each month?
• What is your expected monthly sales growth rate?

For EACH subscription/membership you offer:

• What is the monthly/quarterly/annual price of your membership?
• How many members do you have now or how many members do you expect to gain in the first month/quarter/year?

Cost Assumptions

• What is your monthly salary? What is the annual growth rate in your salary?
• What is your monthly salary for the rest of your team? What is the expected annual growth rate in your team’s salaries?
• What is your initial monthly marketing expense? What is the expected annual growth rate in your marketing expense?

Assumptions related to Capital Expenditures, Funding, Tax and Balance Sheet Items

• How much money do you need for capital expenditures in your first year  (to buy computers, desks, equipment, space build-out, etc.)
• How much other funding do you need right now?
• What is the number of years in which your debt (loan) must be paid back

Properly Preparing Your Financial Assumptions

So how do you prepare your financial assumptions? It’s recommended that you use a spreadsheet program like Microsoft Excel. You’ll need to create separate columns for each line item and then fill in the cells with the example information described below.

Part 1 – Current Financials

Year to date (YTD) units sold and units forecast for next year. This is the same as YTD revenue, but you divide by the number of days in the period to get an average daily amount. If your plan includes a pro forma financial section, your financial assumptions will be projections that are consistent with the pro forma numbers.

Part 2 – Financial Assumptions

Estimated sales forecasts for next year by product or service line, along with the associated margin. List all major items in this section, not just products. For instance, you might include “Professional Services” as a separate item, with revenue and margin information.

List the number of employees needed to support this level of business, including yourself or key managers, along with your cost assumptions for compensation, equipment leasing (if applicable), professional services (accounting/legal/consultants), and other line items.

Part 3 – Projected Cash Flow Statement and Balance Sheet

List all key assumptions like: sources and uses of cash, capital expenditures, Planned and Unplanned D&A (depreciation & amortization), changes in operating assets and liabilities, along with those for investing activities. For example, you might list the assumptions as follows:

• Increases in accounts receivable from customers based on assumed sales levels
• Decreases in inventory due to increased sales
• Increases in accounts payable due to higher expenses for the year
• Decrease in unearned revenue as evidenced by billings received compared with those projected (if there is no change, enter 0)
• Increase/decrease in other current assets due to changes in business conditions
• Increase/decrease in other current liabilities due to changes in business conditions
• Increases in long term debt (if necessary)
• Cash acquired from financing activities (interest expense, dividends paid, etc.)

You make many of these assumptions based on your own experience. It is also helpful to look at the numbers for public companies and use those as a benchmark.

Part 4 – Future Financials

This section is for more aggressive financial projections that can be part of your plan, but which you cannot necessarily prove at the present time. This could include:

• A projection of earnings per share (EPS) using the assumptions above and additional information such as new products, new customer acquisition, expansion into new markets
• New product lines or services to be added in the second year. List the projected amount of revenue and margin associated with these items
• A change in your gross margins due to a specific initiative you are planning, such as moving from a high volume/low margin business to a low volume/high margin business

Part 5 – Calculations

Calculate all critical financial numbers like:

• Cash flow from operating activities (CFO)
• Operating income or loss (EBITDA)  (earnings before interest, taxes, depreciation, and amortization)
• EBITDA margin (gross profits divided by revenue less cost of goods sold)
• Adjusted EBITDA (CFO plus other cash changes like capital expenditure, deferred taxes, non-cash stock compensation, and other items)
• Net income or loss before tax  (EBT)
• Cash from financing activities (increase/decrease in debt and equity)

Part 6 – Sensitivity Analysis

If your assumptions are reasonably accurate, you will have a column for “base case” and a column for “worst case.”  If you have a lot of variables with different possible outcomes, just list the potential range in one cell.

Calculate both EBITDA margins and EPS ranges at each level.

Part 7 – Section Highlights

Just list the two or three key points you want to make. If it is hard to distill them down, you need to go back and work on Part 3 until it makes sense.

Part 8 – Financial Summary

Include all the key numbers from your assumptions, section highlights, and calculations. In one place, you can add up CFO, EPS at different levels, and EBITDA margins under both base case and worst-case scenarios to give a complete range for each assumption.

The key to a successful business plan is being able to clearly communicate your financial assumptions. Be sure to include your assumptions in the narrative of your plan so you can clearly explain why you are making them. If you are using the business plan for financing or other purposes, it may also be helpful to include a separate “financials” section so people unfamiliar with your industry can quickly find and understand key information.

How to Finish Your Business Plan in 1 Day!

Don’t you wish there was a faster, easier way to finish your business plan and financial projections?

With Growthink’s Ultimate Business Plan Template you can finish your plan in just 8 hours or less!

It includes a full financial model. It lists all the key financial assumptions and you simply need to plug in answers to the assumptions and your complete financial projections (income statement, balance sheet, cash flow statement, charts and graphs) are automatically generated!

Click here to see how Growthink’s professional business plan consulting services can create your business plan for you.

OR, Let Us Develop Your Plan For You

Since 1999, Growthink has developed business plans for thousands of companies who have gone on to achieve tremendous success.

Click here to see how our professional business plan writers can create your business plan for you.

If you just need a financial model for your business plan, learn more about our financial modeling services .  

Other Resources for Writing Your Business Plan

• How to Write an Executive Summary
• How to Expertly Write the Company Description in Your Business Plan
• How to Write the Market Analysis Section of a Business Plan
• The Customer Analysis Section of Your Business Plan
• Completing the Competitive Analysis Section of Your Business Plan
• How to Write the Management Team Section of a Business Plan + Examples
• How to Create Financial Projections for Your Business Plan
• Everything You Need to Know about the Business Plan Appendix
• Business Plan Conclusion: Summary & Recap

Other Helpful Business Plan Articles & Templates