Your Best Metrics for Monitoring and Forecasting Cash Flow
June 16, 2021 |
The C2FO Team
In operating a business, cash is always king. Here are the most important financial statements and metrics in tracking and managing your company’s cash flow.
In C2FO’s 2021 Working Capital Survey of more than 6,700 small to mid-sized businesses worldwide, 37% of respondents reported that late payments from their customers had increased over the course of 2020. And 28% said that at least a quarter of their customers had extended payment terms in the past year.
Of course, late payment and extended terms often lead to cash flow problems, which are the biggest obstacles to business sustainability and growth.
Fortunately, there are ways your business can anticipate and adapt to changes in the amount of cash flowing in and out of your organization. The following tools can help you monitor and forecast cash flow so you can maintain a healthy supply of working capital.
Operating cash flow statement
Your cash flow statement includes cash flow related to operations, cash flow related to assets and cash flow related to investments. Of the three, the most important metric for monitoring cash flow is the operating cash flow statement.
Your overall cash flow may be positive, but if that cash comes from your investment activities or from taking out business loans rather than from your core business activities, your business may not be sustainable.
The operating cash flow statement focuses on the cash involved in operating your business.
You can determine the operating cash flow ratio this way:
Essentially, the operating cash flow ratio shows you whether you are making enough money from operations to pay your bills. A business’s operating cash flow ratio should be 1.0 at a minimum.
The balance sheet
Your company’s balance sheet is a financial snapshot of its assets, liabilities and shareholder’s equity at a given moment in time. Organized in sections, the balance sheet lists your:
Assets (current and long-term)
Liabilities (short-term and long-term)
Shareholders’ equity (common stock, retained earnings and current income)
Items should be listed in the order of liquidity. In other words, cash should be listed first in current assets, followed by assets that can quickly be converted to cash.
The balance sheet contains the following measurement formula:
Metrics to measure cash flow
Using data from your financial statements, you should make a practice of monitoring the following metrics regularly:
Debt-to-equity ratio: This metric calculates liabilities divided by total equity. The debt-to-equity ratio helps measure your company’s vulnerability to market changes or economic downturns. Your liabilities should never be greater than your equity.
Days Sales Outstanding (DSO): On average, how many days does it take to collect on your receivables? The shorter your DSO is, the better the effect on your cash flow. You can shorten by getting your customers to pay you faster.
Days Inventory Outstanding (DIO): On average, how fast does your inventory turn over? The shorter your DIO is, the more positive impact it has on working capital. When inventory is selling rapidly, you aren’t spending money storing and maintaining it.
Days Payables Outstanding (DPO): On average, how long do you wait to pay your vendors and suppliers? The longer your DPO is, the better it is for your cash flow. Ideally, your DSO should be shorter than your DPO. This means you’ll have enough money on hand to pay your bills.
The cash flow forecast
A cash flow forecast helps you plan for the month, quarter or year ahead, ensuring you always have enough working capital on hand to meet your needs.
To create a cash flow forecast, you’ll need your sales projections and historical accounting data. Your accounting software should be able to pull historical data and create a cash flow forecast.
Start with at least 12 months of historical data. The more data you have, the more accurate your cash flow forecast will be.
Looking back over your financial statements for one, two or even three years will help you identify how seasonality affects your cash flow.
However, don’t assume the next 12 months will unfold exactly as the last 12 months did. For instance, what happens if the local economy weakens and your customers start paying you in 45 days instead of 30 days?
Once you’ve got a cash flow forecast in hand, compare it to your actual cash flow statement as time goes by. That way, you can get a jump on any trends that affect your working capital needs.
Pay particular attention to your biggest customers, since a small change in their business could have big ramifications for yours.
For more about the impact of cash flow forecasts during the tumultuous era of COVID-19, read our article about how forecasting cash flow can reduce uncertainty for your business.
Making it easy
Most accounting software today makes it easy to create cash flow forecasts and financial statements, as well as calculate key metrics.
If accounting isn’t your strong suit, have your accountant go over these numbers with you at least once a month.
Monitoring the metrics above will give you an overview of where your business is headed so you can steer it in the right direction.