sample cash flow projection for business plan

• Cash Flow Projection – The Comple...

Cash Flow Projection – The Complete Guide

Table of Content

Key takeaways.

• Cash flow projection is a vital tool for financial decision-making, providing a clear view of future cash movements.
• Cash flow is crucial for business survival and includes managing cash effectively and providing a financial planning roadmap.
• Automation in cash flow management is a game-changer. It enhances accuracy, efficiency, and scalability in projecting cash flows, helping businesses avoid common pitfalls.

Introduction

Cash flow is the lifeblood of any business. Yet, many companies constantly face the looming threat of cash shortages, often leading to their downfall. Despite its paramount importance, cash flow management can be overwhelming, leaving businesses uncertain about their financial stability.

But fear not, there’s a straightforward solution to this common problem – cash flow projection. By mastering the art of cash flow projection, you can gain better control over your finances and steer your business away from potential financial crises. Cash flow projections offer a proactive approach to managing cash flow, enabling you to anticipate challenges and make informed decisions to safeguard the future of your business.

If you’re unsure how to accurately perform cash flow projections or if you’re new to the concept altogether, this article will explain everything you need to know about cash flow projections – to help you confidently navigate the financial landscape of your business.

What Is Cash Flow?

To grasp the concept of cash flow projections, we must first understand the essence of cash flow itself. Cash flow is all about the movement of money flowing in and out of business. It reflects the company’s financial health and liquidity, capturing the inflows and outflows of cash over a specific timeframe.

To truly grasp your business’s financial landscape, you must understand the stages of cash flow: operating, investing, and financing activities, and how to analyze and make sense of it.

Read more to uncover a step-by-step guide on how to perform a cash flow analysis (template + examples) and methods to assess key items in cash flow statements.

What Is Cash Flow Projection?

Cash flow projection is the process of estimating and predicting future cash inflows and outflows within a defined period—usually monthly, quarterly, or annually.

Think of cash flow projection (also referred to as a cash flow forecast) as a financial crystal ball that allows you to peek into the future of your business’s cash movements. It involves mapping out the expected cash inflows (receivables) from sales, investments, and financing activities and the anticipated cash outflows (payables) for expenses, investments, and debt repayments.

It provides invaluable foresight into your business’s anticipated cash position, helping you plan for potential shortfalls, identify surplus funds, and make informed financial decisions.

Why Are Cash Flow Projections Important for Your Business?

Managing cash flow is a critical aspect of running a successful business. It can be the determining factor between flourishing and filing for Chapter 11 (aka bankruptcy ).

In fact, studies reveal that 30% of business failures stem from running out of money. To avoid such a fate, by understanding and predicting the inflow and outflow of cash, businesses can make informed decisions, plan effectively, and steer clear of potential financial disasters.

Cash Flow Projection vs. Cash Flow Forecast

Having control over your cash flow is the key to a successful business. By understanding the differences between cash flow statements and projections, small business owners can use these tools more effectively to manage their finances and plan for the future. 

Discover the power of HighRadius cash flow forecasting software ,designed to precisely capture and analyze diverse scenarios , seamlessly integrating them into your cash forecasts. By visualizing the impact of these scenarios on your cash flows in real time, you gain a comprehensive understanding of potential outcomes and can proactively respond to changing circumstances.

Here’s how AI takes variance analysis to the next level and helps you generate accurate cash flow forecasts with low variance. It automates the collection of data on past cash flows, including bank statements, accounts receivable, accounts payable, and other financial transactions, and integrates with most financial systems. This data is analyzed to detect patterns and trends that can be used to anticipate future cash flows. Based on this historical analysis and regression analysis of complex cash flow categories such as A/R and A/P, AI selects an algorithm that can provide an accurate cash forecast.

Step-by-Step Guide to Creating a Cash Flow Projection

Step 1: choose the type of projection model.

• Determine the appropriate projection model based on your business needs and planning horizon.
• Consider the following factors when choosing a projection model:
• Short-term Projections: Covering a period of 3-12 months, these projections are suitable for immediate planning and monitoring.
• Long-term Projections: Extending beyond 12 months, these projections provide insights for strategic decision-making and future planning.
• Combination Approach: Use a combination of short-term and long-term projections to address both immediate and long-range goals.

Step 2: Gather historical data and sales information

• Want to determine where you’re going? Take a look at where you’ve already been. Collect relevant historical financial data, including cash inflows and outflows from previous periods.
• Analyze sales information, considering seasonality, customer payment patterns, and market trends.

Pro Tip: Finance teams often utilize accounting software to ingest a range of historical and transactional data. Read on to discover the business use cases of implementing a treasury management solution for optimal cash flow management .

Step 3: Project cash inflows

• Estimate cash inflows based on sales forecasts, considering factors such as payment terms and collection periods.
• Utilize historical data and market insights to refine your projections.

Step 4: Estimate cash outflows

• Identify and categorize various cash outflows components, such as operating expenses, loan repayments, supplier payments, and taxes.
• Use historical data and expense forecasts to estimate the timing and amount of cash outflows.

Pro Tip: By referencing the cash flow statement, you can identify the sources of cash inflows and outflows. Learn more about analyzing projected cash flow statement .

Step 5: Calculate opening and closing balances

• Calculate the opening balance for each period, which represents the cash available at the beginning of the period.
• Opening Balance = Previous Closing Balance
• Calculate the closing balance by considering the opening balance, cash inflows, and cash outflows for the period.
• Closing Balance = Opening Balance + Cash Inflows – Cash Outflows

Step 6: Account for timing and payment terms

• Consider the timing of cash inflows and outflows to create a realistic cash flow timeline.
• Account for payment terms with customers and suppliers to align projections with cash movements.

Step 7: Calculate net cash flow

• Calculate the net cash flow for each period, which represents the difference between cash inflows and cash outflows.
• Net Cash Flow = Cash Inflows – Cash Outflows

Pro Tip: Calculating the net cash flow for each period is vital for your business as it gives you a clear picture of your future cash position. Think of it as your future cash flow calculation.

Step 8: Build contingency plans

• Incorporate contingency plans to mitigate unexpected events impacting cash flow, such as economic downturns or late payments.
• Create buffers in your projections to handle unforeseen circumstances.

Step 9: Implement rolling forecasts

• Embrace a rolling forecast approach, where you regularly update and refine your cash flow projections based on actual performance and changing circumstances.
• Rolling forecasts provide a dynamic view of your cash flow, allowing for adjustments and increased accuracy.

Cash Flow Projection Example

Let’s take a sneak peek into the cash flow projection of Pizza Planet, a hypothetical firm. In March, they begin with an opening balance of $50,000. This snapshot will show us how their finances evolved during the next 4 months.

Here are 5 key takeaways from the above cash flow projection analysis for Pizza Planet:

Upsurge in Cash Flow from Receivables Collection (April):

• Successful efforts in collecting outstanding customer payments result in a significant increase in cash flow.
• Indicates effective accounts receivable management and timely collection processes.

Buffer Cash Addition (May and June):

• The company proactively adds buffer cash to prepare for potential financial disruptions.
• Demonstrates a prudent approach to financial planning and readiness for unexpected challenges.

Spike in Cash Outflow from Loan Payment (May):

• A noticeable cash outflow increase is attributed to the repayment of borrowed funds.
• Suggests a commitment to honoring loan obligations and maintaining a healthy financial standing.

Manageable Negative Net Cash Flow (May and June):

• A negative net cash flow during these months is offset by positive net cash flow in other months.
• Indicates the ability to handle short-term cash fluctuations and maintain overall financial stability.

Consistent Closing Balance Growth:

• The closing balance exhibits a consistent and upward trend over the projection period.
• Reflects effective cash flow management, where inflows cover outflows and support the growth of the closing cash position.

How to Calculate Projected Cash Flow?

To calculate projected cash flow, start by estimating incoming cash from sources like sales, investments, and financing. Then, deduct anticipated cash outflows such as operating expenses, loan payments, taxes, and capital expenditures. The resulting net cash flow clearly shows how much cash the business expects to generate or use within the forecasted period. 

Calculating projected cash flow is a crucial process for businesses to anticipate their future financial health and make informed decisions. This process involves forecasting expected cash inflows and outflows over a specific period using historical data, sales forecasts, expense projections, and other relevant information. Regularly updating and reviewing projected cash flow helps businesses identify potential cash shortages or surpluses, allowing for proactive cash management strategies and financial planning. 

Benjamin Franklin once said, ‘Beware of little expenses; a small leak will sink a great ship.’ This underscores the importance of managing and understanding cash flow in business. 

Download this cash flow calculator to effortlessly track your company’s operating cash flow, net cash flow (in/out), projected cash flow, and closing balance.

6 Common Pitfalls to Avoid When Creating Cash Flow Projections

At HighRadius, we recently turned our research engine toward cash flow forecasting to shed light on the sources of projection failures. One of our significant findings was that most companies opt for unrealistic projections models that don’t mirror the actual workings of your finance force.

Cash flow projections are only as strong as the numbers behind them. No one can be completely certain months in advance if literal or figurative storm clouds are waiting for them on the horizon. Defining a realistic cash flow projection for your company is crucial to achieving more accurate results. Don’t let optimism cloud your key assumptions. Stick to the most likely numbers for your projections.

A 5% variance is acceptable, but exceeding this threshold warrants a closer look at your key assumptions. Identify any logical flaws that may compromise accuracy. Take note of these pitfall insights we’ve gathered from finance executives who have shared their experiences:

• Avoid overly generous sales forecasts that can undermine projection accuracy.
• Maintain a realistic approach to sales projections to ensure reliable cash flow projections.
• Reflect the payment behavior of your customers accurately in projections, especially if they tend to pay on the last possible day despite a 30-day payment schedule.
• Adjust the projection cycle to align with the actual payment patterns.
• Factor in annual and quarterly bills on the payables side of your projections.
• Consider potential changes in tax rates if your business is expected to reach a new tax level.
• Account for seasonal fluctuations and cyclical trends specific to your industry.
• Analyze historical data to identify patterns and adjust projections accordingly to reflect these variations.
• Incorporate contingencies in your projections to prepare for unforeseen circumstances such as economic downturns, natural disasters, or changes in market conditions.
• Build buffers to mitigate the impact of unexpected events on your cash flow.

• Failing to create multiple scenarios can leave you unprepared for different business outcomes.
• Develop projections for best-case, worst-case, and moderate scenarios to assess the impact of various circumstances on cash flow.

By addressing these pitfalls and adopting best practices shared by finance executives, you can create more reliable and effective cash flow projections for your business. Stay proactive and keep your projections aligned with the realities of your industry and market conditions.

How Automation Helps in Projecting Cash Flow?

Building a cash flow projection chart is just the first step; the real power lies in the insights it can provide. Cash flow projection is crucial, but let’s face it – the traditional process is resource-consuming and hampers productivity. Finance teams have no choice but to abandon it and let it gather dust for the remainder of a month.

However, there’s a solution: a cash flow projection automation tool. 

Professionals in Controlling or Treasury understand this need for automation, but it requires an investment of time and money. Building a compelling business case is straightforward, especially for companies prioritizing cash reporting, forecasting, and leveraging the output for day-to-day cash management and investment planning.

Consider the following 3 business use cases shared by finance executives, highlighting the benefits that outweigh the initial investment:

Scalability and adaptability:

Forecasting cash flow in spreadsheets is manageable in the early stages, but as your business grows, it becomes challenging and resource-intensive. Manual cash flow management struggles to keep up with the increasing transactions and customer portfolios.

Many businesses rely on one-off solutions that only temporarily patch up cash flow processes without considering the implications for the future. Your business needs an automation tool that can effortlessly scale with your business, accommodating evolving needs.

Moreover, such dependable partners often offer customization options, allowing you to tailor the cash flow projections to your specific business requirements and adapt to changing market dynamics.

Time savings:

Consider a simple example of the time and effort involved in compiling a 13-week cash flow projection for stakeholders every week. The process typically includes

• Capture cash flow data from banking and accounting platforms and classify transactions.
• Create short-term forecasts using payables and receivables data.
• Model budget and other business plans for medium-term forecasts.
• Collect data from various business units, subsidiaries, and inventory levels.
• Consolidate the data into a single cash flow projection.
• Perform variance and sensitivity analysis.
• Compile reporting with commentary.

This process alone can consume many hours each week. Let’s assume it takes six hours for a single resource and another six hours for other contributors, totaling 12 hours per week or 624 hours per year. Whether you are an enterprise or an SMB, learn how a 13-week cash flow projection template can help you keep your business on track and achieve your financial goals.

Imagine the added time spent on data conversations, information requests, and follow-ups. Cash reporting can quickly become an ongoing, never-ending process.

By implementing a cash flow projection automation tool, you can say goodbye to tedious manual tasks such as logging in, downloading data, manipulating spreadsheets, and compiling reports. Automating these processes saves your team countless hours, allowing them to focus on strategic initiatives and high-value activities.

Accuracy and efficiency:

When it comes to cash flow monitoring and projection, accuracy is paramount for effective risk management. However, manual data handling introduces the risk of human error, which can have significant financial implications for businesses. These challenges may include:

• Inaccurate financial decision-making
• Cash flow uncertainty
• Increased financial risks
• Impaired stakeholder confidence
• Wasted resources and time
• Compliance and reporting challenges
• Inconsistent data processing

Automating cash flow projections mitigates these risks by ensuring accurate and reliable results. An automation tool’s consistent data processing, real-time integration, error detection, and data validation capabilities instill greater accuracy, reliability, and confidence in the projected cash flow figures.

For example, Harris, a leading national mechanical contractor, transformed their cash flow management by adopting an automation tool. They achieved up to 85% accuracy across forecasts for 900+ projects and gained multiple 360-view projection horizons, from 1-Day to 6-Months, updated daily. This improvement in accuracy allowed the team to focus on higher-value tasks, driving better outcomes.

Cash Flow Projections with HighRadius

Managing cash flow projections today requires a host of tools to track data, usage, and historic revenue trends as seen above. Teams rely on spreadsheets, data warehouses, business intelligence tools, and analysts to compile and report the data.

HighRadius has consistently provided its customers with powerful AI and forecasting tools to support real-time visibility, historical tracking, and predictive insights so your teams can reap the benefits of automated cash flow management.

When your forecast is off, you can miss opportunities to invest in growth or undermine your credibility and investor confidence. An accurate forecast means predictable growth and increased shareholder confidence. 

Cash Flow Projection FAQs

1) how do you prepare a projected cash flow statement.

Steps to prepare a projected cash flow statement :

• Analyze historical cash flows.
• Estimate future sales and collections from customers.
• Forecast expected payments to suppliers and vendors.
• Consider changes in operating, investing, and financing activities.
• Compile all these estimates into a projected cash flow statement for the desired period.

2) What is projected cash flow budget?

A projected cash flow budget is a financial statement that estimates the amount of cash your business is expected to receive and pay out over a specific time period. This information can be helpful in determining whether your business has enough cash flow to maintain its regular operations during the given period. It can also provide valuable insight into how to allocate your budget effectively.

3) What is a 3-year projected cash flow statement?

A 3-year projected cash flow statement forecasts cash inflows and outflows for the next three years. It helps businesses assess their expected cash position and plan for future financial needs and opportunities.

4) What is projected cash flow and fund flow statement?

Projected cash flow statement forecasts cash inflows and outflows over a period, aiding in budgeting and planning. Fund flow statement tracks the movement of funds between sources and uses, analyzing financial position. Both provide insights into a company’s liquidity and financial health.

5) What are the 4 key uses for a cash flow forecast?

• Evaluate cash availability for operational expenses and investments.
• Identify potential cash flow gaps or surpluses.
• Support financial planning, budgeting, and decision-making.
• Assist in securing financing or negotiating favorable terms with stakeholders.

6) What is the cash flow projection ratio?

The term cash flow projection ratio is not a commonly used financial ratio. However, various ratios like operating cash flow ratio, cash flow margin, and cash flow coverage ratio are used to assess a company’s cash flow generation and management capabilities.

7) What is the formula for projected cash flow?

The projected cash flow formula is Projected Cash Flow = Projected Cash Inflows – Projected Cash Outflows . It calculates the anticipated net cash flow by subtracting projected expenses from projected revenues, considering all sources of inflows and outflows.

8) What are the advantages of cash flow projection?

Cash flow projection helps businesses:

• Anticipate future financial needs
• Manage cash shortages effectively
• Make informed decisions
• Ensure stability and growth
• Provide a roadmap for financial planning
• Stay proactive in managing finances

Related Resources

How to Improve Cash Flow: Top 12 Strategies

Moving Beyond Spreadsheets for Cash Forecasting

A Strategic Approach to Make Cash Forecasting Foolproof and Fit for the Future

Streamline your order-to-cash operations with highradius.

Automate invoicing, collections, deduction, and credit risk management with our AI-powered AR suite and experience enhanced cash flow and lower DSO & bad debt

Please fill in the details below

Get the hottest Accounts Receivable stories

Delivered straight to your inbox.

• Order To Cash
• Collections Management
• Cash Application Management
• Deductions Management
• Credit Management
• Electronic Invoicing
• B2B Payments
• Payment Gateway
• Surcharge Management
• Interchange Fee Optimizer
• Payment Gateway For SAP
• Record To Report
• Financial Close Management
• Account Reconciliation
• Anomaly Management
• Accounts Payable Automation
• Treasury & Risk
• Cash Management
• Cash Forecasting
• Treasury Payments
• Learn & Transform
• Whitepapers
• Courses & Certifications
• Why Choose Us
• Data Sheets
• Case Studies
• Analyst Reports
• Integration Capabilities
• Partner Ecosystem
• Speed to Value
• Company Overview
• Leadership Team
• Upcoming Events
• Schedule a Demo
• Privacy Policy

HighRadius Corporation 2107 CityWest Blvd, Suite 1100, Houston, TX 77042

We have seen financial services costs decline by $2.5M while the volume, quality, and productivity increase.

Colleen Zdrojewski

Trusted By 800+ Global Businesses

How to Create a Cash Flow Forecast

10 min. read

Updated May 3, 2024

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, and purchasing assets (new equipment, for example) reduces your cash but does not reduce your profitability. Because of this, your business can spend money and still be 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 three 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.

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. These will show up in the following sections.

2. Loan Payments

When you make 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 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

5 Min. Read

9 Common Mistakes with Business Financial Projections

6 Min. Read

How to Forecast Sales for a Subscription Business

4 Min. Read

How to Create an Expense Budget

3 Min. Read

What Is a Break-Even Analysis?

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

Sign up for our newsletter for product updates, new blog posts, and the chance to be featured in our Small Business Spotlight!

How to create a cash flow projection (and why you should)

For small business owners, managing cash flow (the money going into and out of your business) can be the difference between a thriving, successful company and filing for chapter 11 (aka bankruptcy).

In fact, one study showed that 30% of businesses fail because the owner runs out of money, and 60% of small business owners don’t feel knowledgeable about accounting or finance .

Understanding and predicting the flow of money in and out of your business, however, can help entrepreneurs make smarter decisions, plan ahead, and ultimately avoid an unnecessary cash flow crisis.

After all, knowing whether the next month will see a financial feast or famine can help you make better decisions about spending, saving, and investing in your business today.

One way to do this (without hiring a psychic)? Cash flow projection.

What is cash flow projection?

Cash flow projection is a breakdown of the money that is expected to come in and out of your business. This includes calculating your income and all of your expenses, which will give your business a clear idea on how much cash you'll be left with over a specific period of time.

If, for example, your cash flow projection suggests you’re going to have higher than normal costs and lower than normal earnings, it might not be the best time to buy that new piece of equipment.

On the other hand, if your cash flow projection suggests a surplus , it might be the right time to invest in the business.

Cash flow projections: The basics

In order to properly create a cash flow forecast, there are two concepts you should be aware of: accounts receivable (cash in) and accounts payable (cash out)

• Accounts Receivable: refers to the money the business is expecting to collect, such as customer payments and deposits, but it also includes government grants , rebates, and even bank loans and lines of credit .
• Accounts Payable: refers to the exact opposite—that is, anything the business will need to spend money on. That includes payroll , taxes, payments to suppliers and vendors, rent, overhead, inventory, as well as the owner’s compensation.

A cash flow projection (also referred to as a cash flow forecast) is essentially a breakdown of expected receivables versus payables. It ultimately provides an overview of how much cash the business is expected to have on hand at the end of each month .

Cash flow projections typically take less than an hour to produce but can go a long way in helping entrepreneurs identify and prepare for a potential shortfall, and make smarter choices when running their business.

*While subscribed to Wave’s Pro Plan, get 2.9% + $0 (Visa, Mastercard, Discover) and 3.4% + $0 (Amex) per transaction for unlimited transactions during the offer period. After the offer ends: over 10 transactions per month at 2.9% + $0.60 (Visa, Mastercard, Discover) and 3.4% + $0.60 (Amex) per transaction. Discover processing is only available to US customers. See full terms and conditions.

See Terms of Service for more information.

Send invoices, get paid, track expenses, pay your team, and balance your books with our financial management software.

How to calculate your cash flow projection

Calculating your cash flow projection can seem intimidating at first, but once you start pulling together the necessary information, it isn’t so scary. Let’s walk through the first steps together.

1. Gather your documents

This includes data about your business’s income and expenses.

2. Find your opening balance

Your opening balance is the balance in your bank at the start of a period. (So, if you’ve just started your business, this is zero.)

Your closing balance is the amount in your bank at the end of the period.

So the opening balance in one month should equal the closing balance at the end of the previous month. But more on this later.

3. Receivables (money received/cash in) for next period

This is an estimate of your anticipated sales (such as invoices you expect to be paid, or payments made on credit), revenue, grants , or loans and investments.

4. Payables (money spent/cash out) for next period

Again, this is an estimate. You should consider things like materials, rent, taxes, utilities, insurance, bills, marketing, payroll, and any one-time or seasonal expenses.

“Seasonality can have a material effect on the cash flow of your business,” Andy Bailey, CEO of Petra Coach, wrote in an article for Forbes . “A good cash flow forecast will anticipate when cash outlays and cash receipts are higher or lower so you can better manage the working capital needs of the company.”

5. Calculate cash flow

Now, let’s bring it all together using this cash flow formula : Cash Flow = Estimated Cash In – Estimated Cash Out

6. Add cash flow to opening balance

Now, you’ll want to add your cash flow to your opening balance, which will provide you with your closing balance.

Put it all together: How a cash flow projections look on paper

In practical terms, a cash flow projection chart includes 12 months laid out across the top of a graph, and a column on the left-hand side with a list of both payables and receivables.

Here are all the categories you’ll need for your cash flow projection:

• Opening balance/operating cash
• Money received (cash sales, payments, loans, investments, etc.
• Money spent (expenses, materials, marketing, payroll and taxes, bills, loans, etc.)
• Totals for money received and money spent, respectively
• Total cash flow for the period
• Closing balance

This column typically begins with “operating cash”/opening balance or unused earnings from the previous month. For example, if your cash flow projection for January suggests a surplus of $5,000, your operating cash for February is also $5,000.

Below operating cash, list all expected accounts receivable sources—such as sales, loans, or grants—leaving a space at the bottom to add them all up.

Next, list all potential payable items—such as payroll, overhead, taxes, and inventory—with another space to add their total below.

Once you have your numbers prepared, simply subtract the total funds that are likely to be spent from the cash that is likely to be received to arrive at the month’s cash flow projection.

Once you’ve calculated your monthly cash flow, take the final number and list it at the top of the next month’s column under operating cash, and repeat the process until you’ve got a forecast for the next 12 months.

After the end of each month, be sure to update the projection accordingly, and add another month to the projection.

If you’re a Wave customer and you prefer to use a ready-made chart to help you create your projection, you can pull your financial data from the Reports section of Wave and feed it into this cash flow forecast template .

Be realistic with your cash flow forecast

Cash flow projections are only as strong as the numbers behind them, so it’s important to be as realistic as possible when putting yours together.

For example, being overly generous in your sales estimates can compromise the accuracy of the projection.

Furthermore, if you provide customers with a 30-day payment schedule and a majority pay on the last possible day, make sure that cycle is accurately reflected in your projection.

On the payables side of the equation, try to anticipate annual and quarterly bills and plan for an increased tax rate if the business is likely to reach a new tax level.

Those who pay their staff on a bi-weekly basis also need to keep an eye out for months with three payroll cycles, which typically occurs twice each year.

“Monthly or quarterly forecasts generally are more useful for stable, established businesses,” Bailey also wrote . “Weekly projections will be essential for companies scaling up or going through significant changes, such as a restructuring or merger/acquisition.”

“We like to encourage business owners—especially those who are starting out—to create a 13-week forecast for cash,” William Lieberman, the Managing Partner of The CEO’s Right Hand, told Forbes . “Each week, update the forecast based on what happened the previous week and extend the forecast window by one more week. In this way, you can keep a close watch on exactly what’s coming in and going out so you can be more proactive in addressing potential cash crunches.”

Those who want to be extra cautious with their projections can even include an “other expenses” category that designates a certain percentage of revenues for unanticipated costs. Putting aside some extra cash as a buffer is especially useful for those building their first projections, just in case they accidentally leave something out.

What now: Use your cash flow forecast to make data-driven decisions

Building the cash flow projection chart itself is an important exercise, but it’s only as useful as the insights you take away from it. Instead of hiding it away for the remainder of the month, consult your cash flow projection when making important financial decisions about your business.

If, for example, you anticipate a deficit in the months ahead, consider ways to cut your costs , increase sales, or save surpluses to help make up the difference. If you notice that payments often come in late, consider introducing a late penalty for bills past due.

You can also consult your cash flow projection to determine the best time to invest in new equipment, hire new staff, revise your pricing and payment terms, or when to offer promotions and discounts.

Have clients that regularly procrastinate on payments? Check out these tactics to get your clients to pay you faster .

Improving the accuracy of cash flow projections over time

Once you’re in the habit of creating cash flow projections, it becomes easier to improve their accuracy over time.

Comparing projections to actual results can help you improve the accuracy of your cash flow projections, and help identify longer-term patterns and cycles. Seasonal changes in revenue, patterns that contribute to late payments, and opportunities to cut costs will all become more apparent with each new cash flow projection.

While all these benefits won’t come all at once, entrepreneurs can use their cash flow projection to become better operators and better decision makers with each passing month.

Related Posts

Made for small business owners, not accountants.

The information and tips shared on this blog are meant to be used as learning and personal development tools as you launch, run and grow your business. While a good place to start, these articles should not take the place of personalized advice from professionals. As our lawyers would say: “All content on Wave’s blog is intended for informational purposes only. It should not be considered legal or financial advice.” Additionally, Wave is the legal copyright holder of all materials on the blog, and others cannot re-use or publish it without our written consent.

Creating a cash flow projection

In less than an hour a month, you can identify potential cash shortfalls — and surpluses — in your business’s future.

Even businesses with healthy growth and strong sales run the risk of owing more than they can pay in a given month. Fortunately, spending less than an hour each month on a cash flow projection can help you identify potential cash shortfalls in the months ahead.

Before you create a cash flow projection for your business, it’s important to identify your key assumptions about how cash flows in and out of your business each month.

Identifying some key assumptions

For your cash flow projection, make assumptions in two key areas:

• Receivables: These assumptions should outline how quickly you receive payment from your customers. For example, if most of your customers pay you within 30 days, a key assumption could be: 90% of sales will be collected the month after the sale.
• Payables: These assumptions should outline when your payments are due. For example, if your vendors require payment within 2 weeks of delivery, a key assumption could be: Payables are due within 14 days of purchase.

Drafting your cash flow projection

With these realistic assumptions in hand, you can begin drafting your cash flow projection. To get started, create 12 columns across the top of a spreadsheet, representing the next 12 months. Then, in another column on the left-hand side, list the following cash flow categories and enter the appropriate amount in each column for each month (see descriptions below):

• Operating cash, beginning: The amount of money you’ll have at the beginning of each month.
• Sources of cash: All money coming in each month (receivable collections or direct sales, loans, etc.).
• Total sources of cash: Add the amounts in the “Operating cash, beginning” row to the amount in the “Sources of cash” for each month.
• Uses of cash: List every likely expense your business may incur, such as payroll, accounts payable to vendors, rent and loan payments, etc.
• Total uses of cash: Tally all your expenses so you can see exactly what will be going out the door each month.
• Excess (deficit) of cash: This is the number that counts. If you see positive numbers across the board, congratulations! You may have some extra dollars to invest back into your business. If you see a negative number for one of the months, don’t panic: You have time and options to prepare your business.

Sample cash flow projections

Here is an example of a cash flow projection that has been abbreviated to 4 months for the sake of simplicity:

XYZ Company, LLC Internal Cash Flow Projections August to November

Operating cash, beginning

Sources of cash, uses of cash.

*The company is projecting negative cash in November. What can you do today to prevent the negative cash flow?

Key assumptions :

• 75% of sales will be collected the month after the sale.
• 25% of sales will be collected the 2nd month after the sale.
• Payables are due in 25 days.
• 60% of eligible receivables can be used for the revolving line of credit.

Strategies to improve accuracy

As the months pass and you compare your monthly cash flow statements to your projections for each month, the numbers should match up. A 5% variance one way or the other can be okay, but if it starts being more than 5%, you should revisit your key assumptions to check for flaws in your logic. Even if your actual numbers come in higher than your projections, you should take a close look at your assumptions, because higher returns in the short term could lead to shortfalls later on. Keep in mind that lenders often use your cash flow and liquidity ratio to assess a company’s financial health.

To make sure your projection stays accurate throughout the year, be sure to consider these variable expenses.

• Months with three payrolls
• Months when insurance premiums are due
• Increased estimated taxes due to increased sales

Continue to refine your projection

To keep your cash flow projections on track, create a rolling 12-month plan that you update at the end of each month. If you add a new month to the end every time a month is completed, you’ll always have a long-term grasp of your business’s financial health.

However, don’t try to project more than 12 months into the future. It can be time consuming and variables can change. Prime rates could go up, for example.

Once you’ve gotten into the habit of using a cash flow projection, it should give you added control over your cash flow and a clearer picture of your company’s financial health. For additional support, make an appointment to talk to a banker.

You might also like

A business owner’s guide to balance sheets

Preparing balance sheets can help attract investors by providing a clear picture of your financials.

5 ways to improve your liquidity ratio

Find out how lenders and investors use this metric to assess a company's financial health.

We’re here to help

Products & services

tailored to your business needs

Talk with a banker

Additional resources.

Solutions for Women Entrepreneurs

Resources tailored to the needs of women-led businesses, designed to help you succeed.

Diverse Business Resources

Discover tools, resources, and guidance to help you achieve your goals.

Additional Resources

Planning, Startups, Stories

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

No matter what your business planning objectives, cash flow is still the most vital resource in the business, and managing cash is the single most important business function. Without cash, you go under. So I always assume cash flow is included in every kind of real business plan. And it is the most important component of standard business plan financials. This is another of my series on standard business plan financials .

(Important: If you’re using LivePlan, life gets a lot easier for you. Please read LivePlan Cash Flow instead of this post. )

The Projected Cash Flow is what links the other two of the three essential projections, the Projected Profit and Loss and Projected Balance Sheet, together. The cash flow completes the system. It reconciles the Profit and Loss with the Balance.

Experts can be annoying. There are several ways to do a cash flow plan. Sometimes it seems like as soon as you use one method, somebody who is supposed to know tells you you’ve done it wrong. Often that means that expert doesn’t know enough to realize there is more than one way to do it.  I’m doing direct cash flow for this post. I may do indirect in a later post.

Direct Cash Flow

So here is a direct cash flow plan. You can see the potential complications and the need for linking up the numbers from the other statements. Your estimated receipts from accounts receivable must have a logical relationship to sales and the balance of accounts receivable. Likewise, your payments of accounts payable have to relate to the balances of payables and the costs and expenses that created the payables. Vital as this is to business survival, it is not nearly as intuitive as the sales forecast, personnel plan, or income statement. The mathematics and the financial projections are more complex.

Here’s a sample Projected Cash Flow for a bicycle shop, so you can see how that works:

Estimating Receipts from Receivables

The first two rows of Garrett’s cash flow projection depend on detailed estimates of money coming in as his customers on account pay their invoices. To estimate that, he lays out his guess based on the assumption that only 10% of his sales are on credit (on account), and that his customers pay their invoices in about one month on average. That estimate looks like this:

In this case, the sales on credit are 10% of the estimated total sales in the Sales Forecast, $26,630. That’s the result of Garrett’s assumption, based on the nature of his business. And the money involved comes in one month later. This worksheet projects the Accounts Receivable value in Garrett’s Projected Balance Sheet, as well as the Received from AR value in the Projected Cash Flow. The receivables analysis depends on information in the Profit and Loss Projection, plus an assumption about Sales on Credit, and another on waiting time before payment. And it affects the Projected Balance and the Projected Cash Flow, as shown in this next illustration:

Estimating the Impact of Inventory

Inventory presents another set of important cash-related assumptions. I explained earlier that in the case of inventory, proper accounting practices require special details. The cost of inventory that shows up in the Projected Profit and Loss is related to timing of sales. The actual cash flow implications of inventory depend on when new inventory is purchased, as shown here:

As with Accounts Receivable in the previous illustration, the inventory analysis depends on information from the Sales Forecast, and it sends information to both the Projected Balance Sheet (Ending Inventory) and the Projected Cash Flow (Inventory Purchase).

Estimating the Impact of Payables

Most businesses wait a month or so before they pay invoices for goods and services received from other businesses. That means we can save on our cash flow by holding back some money and paying it later. With proper accrual accounting, that money is recorded on the Balance Sheet as Accounts Payable. Estimating Accounts Payable takes a careful combination of calculations and assumptions. First we have to collect the full amount of payments. Then we account for payments made immediately, not held in Accounts Payable. After that, we estimate how long, on average, we hold payments. That analysis is shown below:

In this case, it is assumed that the store will pay its bills about a month after it receives them.

Cash Flow is About Management

Reminder: you should know how to project cash flow using competent 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 vs. actual analysis so you can catch changes in time to manage them. The illustration here shows projected profits for the bicycle store compared to the projected cash flow, using the projections presented in this chapter:

Leave a Reply Cancel reply

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

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

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

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

No thanks, I prefer writing 40-page documents.

Discover the world’s #1 plan building software

Cash Flow Forecasting: A How-To Guide (With Templates)

Janet Berry-Johnson, CPA

Reviewed by

May 30, 2023

This article is Tax Professional approved

Most small business owners just want their accounting done so they can focus on doing what they love. But tracking and forecasting cash flow—despite the time and effort required—is essential for starting, operating, and expanding a business.

I am the text that will be copied.

In 2018, CB Insights analyzed 101 failed startups and found that running out of cash was the second most common cause of failure, impacting 29% of businesses.

To avoid that fate, you need a cash flow forecast to help you estimate how much your cash outflows and inflows will affect your business.

What is a cash flow forecast?

A cash flow forecast (also known as a cash flow projection) is like a budget, but rather than estimating revenues and expenses, it estimates cash coming in and going out based on past business performance.

It’s not uncommon for a business to experience a cash shortage, even when sales are good. This usually happens when customers are allowed to pay after the product or service is delivered. In cases like these, a business owner must plan how they will cover costs before receiving the payment.

For example, say Hana Enterprises ships $50,000 worth of security products to customers in January, along with invoices that are due in 30 days. The company will have $50,000 of revenues for the month but won’t receive any cash until February. On paper, the business looks healthy, but all of its sales are tied up in the accounts receivable. Unless Hana Enterprises has plenty of cash on hand at the beginning of the month, they will have trouble covering their expenditures until they start receiving cash from clients.

With a cash flow forecast, you ignore sales on credit, accounts payable, and accrued expenses, instead focusing on the revenue you actually expect to collect and the expenses you actually expect to pay during a given period. You can also use the information provided on past cash flow statements to estimate your expenses for the period you’re forecasting for.

( If you just want to dive into cash flow forecasting, check out our free cash flow forecast template . )

The benefits of cash forecasting

Cash forecasting may sound like something boring that accountants do in big companies. Not so! It’s absolutely essential for every single business. Here’s why:

• It helps you identify potential problems. Cash forecasting can help you predict the months in which you’re likely to experience a cash deficit and make necessary changes, like changing your pricing or adjusting your business plan.
• It decreases the impact of cash shortages. When you can predict months in which you might experience a cash shortage, you can take steps to plan for them. You might save more in months where you have a surplus, step up your receivables collection efforts, or establish a line of credit with your bank to guarantee enough working capital to last the period.
• It keeps suppliers and employees happy. Late payments and missing paychecks damage your reputation with suppliers and employees. When you can predict how much money you’ll have on hand in any given month, you can confirm that you’ll be able to meet your payroll obligations and pay suppliers by the due date.

Free cash flow forecast template

To make this a lot easier, we’ve created a business cash flow forecast template for Excel you can start using right now.

Access Template

The template has three essential pieces:

• Beginning cash balance. This is the actual cash you expect to have on hand at the beginning of the month. It should include bank accounts, PayPal, Venmo, anything you use that’s currently holding just business funds. This information can be found on your balance sheet .
• Sources of cash. These are all of your cash inflows each month. It can include cash sales, receivables collections, repayments from money you’ve loaned out, etc.
• Uses of cash. This is every expense your business may incur, including payroll, payments to vendors, utilities, rent, loan payments, etc.

Here’s an example of a completed cash flow projection for a three month period:

Hana Enterprises, Inc.

Cash Flow Projection

January to March 2022

As you can see from the example above, Hana Enterprises expects to have a cash shortage in March. This results from a negative net cash flow (when more cash goes out than comes in). Knowing that information ahead of time, the company can take steps to prevent the shortage from occurring.

Hana Enterprises has several options to avoid this shortage in March. They might secure a line of credit from the bank, purchase fewer computers in February, negotiate longer payment terms from vendors, contact late-paying customers to speed up the collection of receivables, or take other cost-cutting measures to reduce their overhead expenses.

When you’re ready to get started, download your copy of the cash flow forecasting sheet here .

How Bench can help

Use Bench’s simple, intuitive platform to get all the information you need to project your cash flow. Each month, your transactions are automatically imported into our platform then categorized and reviewed by your personal bookkeeper. Bench helps you stay on top of your business’s top expenses so you can make informed budgeting decisions on the fly. Explore our platform with a free tour today .

Tips for improving your cash flow spreadsheet

Keep in mind: a cash flow forecast isn’t something you create once a year and never look at again. It’s a living, breathing business tool you should review and update on a monthly basis.

Though projections are helpful, they can’t perfectly predict the future. As the months pass, you should expect to see that your projections aren’t quite matching up with your actual results. That means it’s time to re-run your forecast to take into account these differences.

To improve the accuracy of your cash flow worksheet, consider the following:

• Account for extra pay periods. If you pay employees bi-weekly, make sure your projection takes into account any months with three payrolls.
• Remember annual payments. If certain insurance policies, subscriptions, or other expenses are paid annually rather than monthly, be sure to include them in your spreadsheet.
• Remember estimated tax payments. For most calendar-year businesses, estimated tax payments are due on April 15th, June 15th, September 15th, and January 15th.
• Don’t forget about savings. Try to allocate a portion of any cash surpluses to save for lean months.
• Identify seasonal fluctuations. If you’re expecting a period of time with lower sales, make sure your forecast reflects this so you can have enough cash on hand to ramp up when business picks up again.
• Don’t forecast too far out. Creating a rolling 12-month cash flow forecast that you update at the end of each month can help you identify issues before your business faces financial troubles, but don’t try to forecast more than 12 months out. The longer the reporting period you want to forecast, the more likely you’ll end up spending a lot of time creating a cash flow projection that doesn’t provide any useful information.

Your cash flow forecast is key to good cash flow management . Try to account for all cash sources and uses in your projection and maintain an emergency fund or backup plan to ensure you don’t get sidelined by slow-paying customers or unexpected expenses. When you do, this simple but valuable tool can help you keep an eye on cash and ensure you don’t compromise growth or put your business in jeopardy.

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.

Cash Flow Projection Template for Business Plan

Identify historical financial data of the business.

• 1 Balance sheet
• 2 Income statement
• 3 Cash flow statement

Analyze past financial performance

• 1 Identify revenue trends
• 2 Identify expense trends
• 3 Assess profitability
• 4 Evaluate liquidity
• 5 Identify financial risks

Forecast future income

Forecast future expenses, calculate expected cash inflow, calculate expected cash outflow, prepare an initial cash flow statement, adjust variables based on economic conditions and business goals, approval: finance manager for preliminary cash flow statement.

• Prepare an initial cash flow statement Will be submitted

Revise the cash flow statement based on Finance Manager's feedback

Calculate final cash inflow and outflow, draw the final cash flow projection, incorporate the cash flow projection into the business plan, approval: senior management for final cash flow projection.

• Incorporate the cash flow projection into the business plan Will be submitted

Incorporate any Senior Management feedback into final projection

Finalise the cash flow projection template for the business plan, prepare a comprehensive report on the entire process, take control of your workflows today., more templates like this.

Cash Flow Projection Business Plan Template

What is a Cash Flow Projection Business Plan?

A cash flow projection business plan is a planning tool used to project future cash flows and identify potential financial risks. It is used to assess the financial health of a business and helps to inform decision-making and budgeting. The plan provides an overview of the anticipated cash flows of the business over a given period, allowing owners to plan ahead and adjust their strategies accordingly.

What's included in this Cash Flow Projection Business Plan template?

• 3 focus areas
• 6 objectives

Each focus area has its own objectives, projects, and KPIs to ensure that the strategy is comprehensive and effective.

Who is the Cash Flow Projection Business Plan template for?

This cash flow projection business plan template is designed for entrepreneurs, business owners, and financial professionals. It can help them to plan and project cash flows for their businesses, identify potential financial risks, and create a roadmap for the business’s financial future. This template can be used to create a comprehensive and effective plan.

1. Define clear examples of your focus areas

Focus areas are the broad topics that define the goals of a strategic plan. Examples of focus areas for a cash flow projection business plan could include: Project Cash Flow; Increase Revenue; Optimize Expenses.

2. Think about the objectives that could fall under that focus area

Objectives are the specific goals that you hope to achieve within each focus area. Examples of objectives for the focus area Project Cash Flow could include: Develop a business plan to project cash flows; Create a cash flow projection plan.

3. Set measurable targets (KPIs) to tackle the objective

KPIs are measurable targets that can be used to track progress towards a specific objective. Examples of KPIs for the objective Develop a business plan to project cash flows could include: Analyze industry-related cash flow projection methods.

4. Implement related projects to achieve the KPIs

Projects are the specific actions that must be taken in order to achieve a KPI. Examples of projects for the KPI Analyze industry-related cash flow projection methods could include: Research cash flow projection methods.

5. Utilize Cascade Strategy Execution Platform to see faster results from your strategy

The Cascade Strategy Execution Platform is a powerful tool that enables businesses to create, track, and report on their strategic objectives and goals. With Cascade, leaders and teams can easily create, track, and report on their strategic objectives and goals, as well as quickly adjust their strategy as needed. Cascade also provides real-time updates and data, allowing them to make informed decisions in order to achieve their desired goals.

Cash flow projection example

Follow this example of a cash flow projection to create your own. A cash flow projection will help you see when your business will be flush with cash, and when it won’t.

Example cash flow projection

A cash flow projection allows you to predict incomings and outgoings to estimate how much money you’ll have in the future.

Reading the results

Here's where you subtract costs from your available cash to see how much money you'll have in the bank at the end of each period.

Tips for filling out a cash flow projection

Owner’s contribution is any personal money you put into the business. Owner’s drawings are any amounts you took out for personal use. Only fill out the ‘Money from loans’ row if newly borrowed money hits your account during the period. Don’t put existing loans in there.

Some costs can go in multiple places. Car insurance could go under insurance or vehicles, for instance. Don’t sweat on the decision too much. Just stay consistent once you’ve made a call.

Want to borrow this template?

If you like the format of the cash flow forecast in this example – we can send it to you as a template.

Forecast faster

You don’t have to fiddle about with spreadsheets. Online accounting makes forecasting a lot simpler.

Check it out

How to read a cash flow projection

The numbers to watch.

• Net cash flow – shows whether you’ll be putting money in the bank, or scrambling to meet costs.
• Closing balance – a negative amount suggests you may need to delay expenditures if you can, or sort out some kind of finance.

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

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.

• Cashflow management

User-friendly 3-year cash flow projection template for hassle-free forecasting

A cash flow projection is a crucial tool for businesses to forecast their future financial health. With a 3-year cash flow projection template , a financial forecast can be made that estimates the anticipated inflows and outflows of cash for a business over a three-year period.

Estimating the inflows and outflows of cash over a 3-year timeline provides insights into the expected cash position of the company and helps in assessing its financial health and sustainability. Businesses can make informed decisions, plan for growth, and identify potential cash shortages based on such financial forecasts.

What is a cash flow spreadsheet?

A cash flow spreadsheet, also called a cash flow statement projection, uses software like Excel or Google Sheets to track and analyse cash inflows and outflows.

The spreadsheet has columns for periods (e.g., months) and rows for cash flow categories. This tool allows input of actual and projected numbers, providing a visual representation of trends and aiding cash flow monitoring. It helps identify shortages/surpluses and informs financial decisions. Formulas automate calculations, generating summaries, charts, and graphs. Crucial for financial planning, budgeting, and forecasting, this spreadsheet streamlines the analysis and interpretation of cash flow data.

What is a projected 3-year cash flow?

A projected 3-year cash flow is a financial statement that outlines the anticipated cash inflows and outflows for a business over a specific three-year timeframe. It takes into account factors such as sales revenue, expenses, investments, loan repayments, and other sources. It uses cash to determine the net cash position at the end of each period.

Using a 3-year cash flow projection template, a projection is made, which serves as a tool for businesses to plan and make informed financial decisions.

Purpose of a projected 3-year cash flow for businesses

The primary purpose of a projected 3-year cash flow is to provide a forward-looking view of a company's cash position. Estimating future cash flows helps businesses to :

Forecast financial health: A projected cash flow allows businesses to assess their financial health and solvency by identifying potential cash shortfalls or surpluses in advance.

Plan for growth: The forecasting helps in evaluating the financial feasibility of growth strategies, such as expanding operations, entering new markets, or investing in new products or services.

Identify financing needs: It enables businesses to determine if additional financings, such as loans or equity investments, will be required to cover anticipated cash deficits or support growth initiatives.

Make informed decisions: With a clear understanding of future cash flows, businesses can make informed decisions about expenditures, pricing strategies, cost management, and investment opportunities.

How to do yearly cash flow projection?

To create a yearly cash flow projection, follow these steps:

• Set up spreadsheet: Organise categories, ensure systematic data entry and calculations.
• Identify and estimate cash inflows: Consider sales revenue, receivables, interest income, etc.
• Identify and estimate cash outflows: Categorise and estimate expenses like rent, payroll, and loans.
• Calculate net cash flow: Subtract total outflows from inflows for surplus/deficit.
• Calculate opening and closing balances: Consider the previous period's closing balance, and add net cash flow.
• Review and adjust: Compare projection to actual data, and update for accuracy.
• Monitor and update: Stay informed of changes in revenue, expenses, and market conditions.
• Analyse and make decisions: Compare projections to goals, assess financial health, and make informed choices for cost management, investments, and strategies.

By forecasting future cash flows, businesses can proactively address potential financial challenges, plan for growth, and make informed decisions.

How to do triennial cash flow projections?

The process of creating a yearly cash flow projection is similar to that of a three-year cash flow projection. To create a projected 3-year cash flow, businesses gather historical financial data and use it as a basis for estimating future cash flows.

By analysing past trends and considering factors such as market conditions, sales forecasts, expense projections, and capital expenditure plans, businesses can build a comprehensive and realistic cash flow projection.

Step 1: Gather historical data

To begin, collect your company's historical financial statements, including balance sheets, income statements, and c ash flow statements for the past three years. This data will serve as a foundation for building your cash flow forecast.

Step 2: Identify cash inflows

List all potential sources of cash inflows , such as sales revenue, loans, investments, and other income streams. Analyse your historical data to determine the average amounts and timing of these inflows. Consider factors like seasonality, market trends, and any upcoming changes in your business operations that may affect cash inflows.

Step 3: Estimate cash outflows

Next, identify and categorise your expected cash outflows. This includes costs such as employee salaries, rent, utilities, raw materials, marketing expenses, loan repayments, and taxes. Again, refer to your historical financial data and account for any anticipated changes in costs, such as upcoming investments or cost-saving measures.

Step 4: Calculate net cash flow

By deducting the total cash outflows from the total cash inflows, you can calculate your net cash flow for each period. A cash flow positive indicates a surplus, while a negative value indicates a cash deficit. Be realistic and conservative in your estimations to ensure accuracy in your projection.

Step 5: Consider cash reserves and financing options

Assess your current cash reserves and determine if they are sufficient to cover any projected cash deficits .

Explore financing options such as bank loans, lines of credit, or equity investments to bridge the gap, if any. Incorporate these additional funds into your projection, including the associated costs and repayment terms.

Step 6: Review and refine

Regularly review and refine your cash flow projection as new information becomes available or circumstances change. Update your projection at least on a quarterly basis, comparing the actual results with your projections to identify any discrepancies or adjustments required.

What is a cash flow statement template?

A cash flow statement template is a tool used to present a business's cash inflows & outflows over a specific period. The template provides a structured format to organise and analyse cash flow information, allowing businesses and individuals to assess their liquidity, financial health, and cash management capabilities. It helps track the movement of cash throughout different activities, such as operating, investing, and financing activities.

A typical cash flow statement template consists of the following:

Opening Cash Balance: It represents the cash balance at the beginning of the period.

Cash Inflows: These include the sources of cash during the period, such as cash received from sales, interest income, dividends, or any other cash receipts.

Cash Outflows: These accounts for the cash payments made during the period, including expenses, purchases of assets, interest payments, taxes, and other operating costs.

Operating Activities: It summarises the cash flows related to the core operations of the business, such as revenue incurred from sales, payments made to suppliers, salaries & wages, and other operating expenses.

Investing Activities: It captures cash flows from investing activities, such as purchases or sales of property, plant, and equipment, investments in other businesses, or proceeds from the sale of investments.

Financing Activities: It records cash flows from financing activities, including proceeds from loans, issuance of stock, repayment of debt, or payment of dividends.

Net Cash Flow: It calculates the net increase or decrease in cash during the period by deducting the total cash outflows from the total cash inflows.

Closing Cash Balance: It shows the cash balance at the end of the period, which is calculated by adding the net cash flow to the opening cash balance.

Free 3-year Cash flow projection template for easy use

Benefits of using a 3-year cash flow projection template.

The benefits of using a 3-year cash flow projection template are:

• Gain a comprehensive understanding of how future projects affect your business's financial performance.
• Anticipate and plan for any potential cash shortfalls, allowing you to effectively strategise and manage your resources.
• Proactively adjust and adapt to changes by utilising the insights from the 3-year projections.
• Utilise the projections to outline and formulate growth and expansion strategies.
• Perform variance analysis to compare and assess the variance between budgeted and actual cash flows.
• Enhance your chances of securing bank loans and external financing by presenting a solid cash flow and forecast and demonstrating a strong repayment capacity.
• Conduct accurate analysis of detailed scenarios, enabling you to make informed decisions.
• Evaluate the impact of cost-saving measures on future cash flows and overall business valuations.

Creating a 3-year cash flow projection is an essential financial planning exercise for businesses. It is a valuable financial planning tool that helps businesses anticipate and manage their cash position.

By analysing historical data, estimating cash inflows and outflows, and considering potential financing options, you can gain valuable insights into your company's financial future.

Regularly updating and revising the projection based on actual results and changing circumstances allows businesses to stay on top of their financial situation and ensure long-term sustainability.

A 3-year cash flow forecast is crucial for long-term cash planning. How can you manage your cash flow better? Agicap is a cash management software that allows you to manage your business effectively. Try it out for free!

Subscribe to our newsletter

You may also like.

201 Borough High Street London SE1 1JA

• Manage your cash flow
• Cash flow monitoring
• Cash flow forecast
• Consolidation
• Custom dashboards
• Debt management
• Late payment reminders
• Supplier Invoice Management
• £1M - £10M revenue
• Restaurants
• Terms of Use
• General Terms of Service
• Privacy Policy
• Legal Notice
• We're hiring

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

Cash flow projection template for business plan

Most business plans consist of a text part which elaborates on the nature of the business, the stakeholders, customers, competitors, products and so forth and a financial part which is based on the cash flow projections for your business plan.

While Microsoft Excel is the prefect solution for the financial part of the business plan, it really is not the best solution for the text part. Text based solutions like Microsoft Word just provides better text alignment and formatting options to be able to create a business plan which looks really professional.

There are a lot of business plan software solutions on the market, some of which can be purchased at reasonably affordable prices but for most people, creating a business plan is not something that you would do frequently and also mostly when setting up a business when cash flow is limited and you may prefer to not spend too much on once-off use software.

In terms of the text part of the business plan, you may just want to use Microsoft Word and just link the financial part to a cash flow projection template. You should be able to search online to get the main points that you need to write about in the text part but for most people, the cash flow projection part will not be that simple especially if you need to compile financial projections for a bank in order to obtain a business loan.

Need Annual Financial Statements?

We do not sell any Word templates as this is not our area of expertise but when it comes to creating financial forecasts, we probably provide some of the most comprehensive cash flow projection templates for business plans.

The premise of the design of all our cash flow projection templates is that the user enters some basic user assumption values and sets monthly income and expense values and we then compile comprehensive, automated (as far as possible) cash flow projections based on these values which includes an income statement, cash flow statement and balance sheet.

This is the type of financial reports that banks want and we also provide various options in terms of forecast periods so that you will be able to provide weekly, monthly or annual cash flow projections. Our most popular cash flow template is our cash flow - business plan forecast template which includes 12 monthly periods and 5 annual periods.

All our template prices are affordable, once-off prices and you will have full access to all formulas which means that you can edit our existing template and add additional calculations if you need to. You can also use the templates for multiple businesses by simply saving the file under a new file name each time that you need to create a new business plan.