How to Create a Cash Flow Analysis That Unveils Opportunities

Getting your cash flow analysis right will allow you to see pinch points where you may have less cash coming in than going out and moments of opportunity for growth.

Here we take a look at what a cash flow analysis (also sometimes called a cash flow forecast or cash flow statement) is, why they’re important and how to go about producing one for your small business.

Alike a business plan, cash flow statements are a key document to have, update and refer to as you create and run your business. They’re also a fundamental part of your accounting records.

The importance of cash flow

Poor cash flow accounts for the failure of over two thirds of UK businesses. Without assessing cash flow, it’s difficult to predict how much money you have for payroll, inventory, customer retention strategies and, ultimately, long-term growth. But identifying the source and financial significance of your cash flow problems isn’t as simple as checking through your sales records.

A cash flow analysis is a recognised method to secure this control, providing an holistic view of your business’s financial wellbeing. If you’ve recently started a business, adopting cash flow analysis into your routine will help you get off on the right foot, acting as a preemptive safeguard for years to come.

What is a cash flow analysis?

It shows what cash is flowing in and what is flowing out. It may also be referred to as a cash flow statement or cash flow forecast.

A cash flow analysis divides the accounting concept of cash flow into three sections:

  • Cash flow from operating activities (CFO).
    This section explores the revenue-generating activities of a business, i.e. how much yours has generated from core business operations like sales. Normally, it takes the form of quarterly and annual reports. The ideal “cash flow from operating activities” would be at least enough income to cover all of your outgoings. This takes the form of at least a 1:1 ratio — operational incomings matching (or, even better, exceeding) outgoings.

  • Cash flow from investing activities (CFI).
    This section within your cash flow statement reports on the influence of investment gains or losses. These investments are known as “fixed” or “capital” assets, which are not expected to be consumed or converted into cash within the financial year. Examples of assets include new premises, company car or laptop. These assets are owned, not hired.

  • Cash flow from financing activities (CFF).
    This section within your cash flow statement looks at external capital-raising activities, including issuing stock to shareholders, buying stock back, making payments on a business loan or distributing dividends.

There are a number of ways to create a cash flow statement, including building your own templates, downloading one or using accounting software like Xero and Zoho Books.

A retail POS system that grows with your business.

We’re with you from Square one to whatever’s next.

Why is a Cash Flow Analysis Important For Your Business?

Not having enough money in (cash flow) can mean you can’t pay employees, suppliers or creditors you owe money to.

Even a short-term cash flow problem can be a major issue causing you to lose staff, damage relationships or even lose your business. In recent research 60% of small businesses said cash flow is a problem.

Creating a strong cashflow analysis also allows you to make the most of opportunities. If you know when you’ll have more cash in your hand you can plan when best to further invest in your business to allow it to grow.
Improving cash flow can be the key to creating a sustainable, long-lasting business.

Without assessing cash flow, it’s difficult to predict how much money you have for payroll, stock, customer retention strategies and, ultimately, long-term growth.

Identifying the source and financial significance of your cash flow problems isn’t as simple as checking through your sales records.

A cash flow analysis is a recognised method to secure this control, providing a holistic view of your business’s financial wellbeing. If you’ve recently started a business, adopting cash flow analysis into your routine will help you get off on the right foot, acting as a pre-emptive safeguard for years to come.

Calculating cash flow

A cash flow analysis begins with an examination of all the parts of your business that affect cash flow, such as:

  • Accounts receivable (money owed to you)
  • Accounts payable (money you owe)
  • Inventory
  • Credit terms (the set time window for customers to pay for purchases and the interest charged to them)
  • Cash acquired through the sale of assets
  • Payments for the purchase of assets
  • Business loans
  • Finance from outside investment

The basic means of calculating your cash flow is to compare your total unpaid outgoings to your total receivable income at the end of the month. When the former exceeds the latter, you spend more than you own. And whilst making a loss is part and parcel of running a small business, long-term this pattern will lead to cash flow problems.

To calculate your cash flow with a cash flow template, follow these steps:

  1. Enter your company’s total cash balance at the beginning of a full or half year, a year quarter or a single month.
  2. Enter your cash incomings and outgoings for the cash flow statement sections:
    1. Operating activities
    2. Investing activities
    3. Financing activities
  3. Add or subtract these incomings and outgoings from the original total cash balance.
  4. The final total — the increase or decrease left from the total cash balance — represents your net cash flow, i.e. your “bottom line”.

Analysing your cash flow statement

The more you run cash flow analyses, the more data you uncover and the deeper the understanding of your cash flow health gets. The basic calculation above is just one way of understanding your cash flow. Other calculations include:

  • Free cash flow.
    Free cash flow refers to the funds you have available after paying capital and operational expenses. To calculate free cash flow, use one of these three formulas:
    • Sales revenues – operating costs and taxes – required investments in operating capital
    • Net operating profit after taxes (NOPAT) – net investment in operating capital
    • Net cash flow from operations – capital expenditures
  • Operating cash flow to liabilities ratio.
    This ratio shows whether your current liabilities are covered by your cash flow, helping you gauge your company’s liquidity.

    The formula to use is: cash flow from operations ÷ current liabilities

  • Operating cash flow to sales ratio.
    This ratio is expressed as a percentage. It compares your operating cash flow with net sales to get an idea of your company’s ability to turn sales into cash. If your business is healthy, you should see your company’s sales grow in parallel to your operating cash flow.

    The formula to use is: operating cash flow  ÷ net sales (revenue)

  • Cash flow trends.
    The ratios above help you track your business’s health and measure your cash flow management. Once you have 12 months’ worth of financial data, you can analyse your month-over-month cash flow more accurately and design changes that help your business succeed.

The frequency with which you need to carry out a cash flow analysis depends on your industry and the size and condition of your business. If you started up recently, regular checkups will pave the way for good health down the line. Whereas if you’ve been established for a number of years, the added complexities of your size may warrant spreading out your analyses. The main thing is that you always have a practical and in-depth understanding of your business’s financial status.

Indirect and Direct Method – Cash Flow

A cash flow statement may use the direct method or indirect method of reporting figures.

The indirect method is more popular and generally less complex. It makes use of your balance sheet and profit and loss statements for cash flow analysis.

The direct method is seen as a more accurate way of measuring cash flow and especially good for longer term business strategy but may not be suited to businesses with a higher number of transactions.

Professional accounting services providers can help you further understand the options and what will work best for your business.

Improve your business cash flow with Square Instant Transfers

When you are looking for ways to improve cash flow for your small business, speeding up the card payment transfers process is one thing to consider.

Square Transfers allow you to get paid as fast as you want. Fast transfers are standard, with cash from the card payments you take from customers arriving in your account as soon as the next working day fee-free. If you need the money in your account within 20 minutes that’s also possible – for a 1% fee.

This article is intended to offer helpful guidance and does not constitute qualified financial advice. Please consult an accountant or financial advisor if you have any questions.

Related Articles

5 Ways Successful Businesses Save Money
Planning Your Business Finances: Essential Components of a Financial Analysis
4 Things You Miss Out On By Not Taking Cards