It’s easy to assume that if your business is healthy today, it’ll be healthy tomorrow. But while optimism is important, so is understanding where your business stands financially–both now and in the future.
Monitoring your cash flow and knowing how to run periodic cash flow projections can help prevent future money troubles. If you’re new to cash flow projections, this guide will walk through what you need to know. Keep reading or use these links to jump to a specific part of the guide:
Cash flow projections predict the amount of money entering and leaving your small business. As the name suggests, this method uses cash flow to anticipate future business performance. And cash flow is the net amount of cash and “cash equivalents” that transfers in and out of your business.
This transfer occurs through accounts payable and accounts receivable. Accounts payable is money out, while accounts receivable is money in.
Cash is the lifeblood of a business. Businesses require cash flow to operate, and in the long term, negative cash flow can lead to a variety of issues for a business.
Most businesses face cash flow problems at some point. A survey by QuickBooks found that 60% of small business owners reported that cash flow has been a problem. But if your business experiences negative cash flow, it may be easier to manage if you’ve had time to plan in advance. That’s where cash flow projections can help.
Many business owners mistakenly gauge their business’s health by looking at their business value in assets, intellectual property, and so on. But while these are important for attracting investors or selling your business, they won’t help you predict future business performance. They’re also not factored into cash flow calculations.
Running regular cash flow projections is important because it can help you steer your business toward the future. Rather than making critical plans based on present circumstances, cash flow projections use historical data to help you make a plan for the future, which can be more accurate. The right tools can help you generate accurate cash flow forecasts without requiring manual calculations or spreadsheets to create projections.
Essentially, cash flow projections and cash flow forecasts are the same thing. Both are methods for projecting the business’s financial future. Small business owners can use the terms interchangeably.
Small business owners should take the time to understand their cash flow. Not just to build a solid cash flow projection, but so they can recognise areas of opportunity and potential shortfalls. Follow these steps to perform a month-by-month, year-long cash flow projection. Or use them as a jumping-off point for further talks with your bookkeeper, regarding cash flow projections.
The first step to creating an accurate cash flow projection is to estimate your sales. Start by looking at last year’s numbers using your financial statements. These can help you predict the amount of cash that may come into your business each month next year. You’ll find your business’s credit and cash sales on your monthly income statements. But while the past is the best indicator of the future, you’ll also want to consider some changes.
For instance, if a competitor is moving into your territory, you may want to decrease your sales forecasts. But if you’re adding a new product or service to your offerings, you might expect a slight bump in cash inflow, at least in the short-term.
If you own a new business and don’t yet have a sales history, you will have to use industry research to create a reasonable sales forecast. Be sure to estimate sales for each month, not just the year.
If you operate a business that does mostly cash sales or takes instant payment from customers, you may skip this step.
This step is for business owners who extend credit lines to their customers, send invoices, or take multiple customer payments for a single sale. The idea is to estimate when you will actually receive cash from your sales. To do that, you’ll want to calculate your days sales outstanding (DSO).
The DSO formula first divides your monthly accounts receivable by your total sales. Then it multiplies that number by the number of days in the month. The DSO formula follows:
(Monthly accounts receivable ÷ total sales) x days in the month = DSO
The DSO will tell you the average number of days it takes to receive payment from customers. So if you offer something like 30-day payment terms to your clients, the DSO will tell you how long it actually takes, on average, to receive payment. Then you can incorporate that number into your estimates.
Next, you’ll need to estimate both your fixed and variable expenses monthly. Your fixed expenses (rent, employee salaries, insurance, etc.) don’t change.
Variable expenses tend to fluctuate with your sales. For example, your shipping costs vary because they depend on how many products you sell and ship. Your packaging, raw materials, commissions, and labour costs may also go up and down with your sales volume.
Just as you did for sales, you will need to estimate your fixed and variable expenses for each month of the next year. If you have someone like an accountant in charge of your accounts payable, they’re a great resource here. They can help you go through your sales records and estimate what your next year could look like.
If you don’t have someone who can help you with this process, you can tackle it yourself. Start a spreadsheet with columns for fixed costs and variable costs, and tally them up. Your variable costs will likely be a little trickier since you’ll have to break down many pieces. These pieces include things like material costs, labour costs, product costs, etc. If you’ve calculated your breakeven point, you can pull most of this information from there as well.
Now that you’ve calculated all the numbers you need, it’s time to put them together. Here’s how to run your current month’s projected cash flow.
Begin with the cash balance from last month’s operations, then add this month’s projected receipts, accounting for your DSO. Next, subtract your projected expenses. The formula follows:
(Last month’s cash balance + current month’s projected receipts) – projected expenses = current month’s projected cash flow
Once that’s done, you can calculate your projected cash flow for next month or the next 12 months. To do this, carry the balance from this month’s projected cash flow to the next month, and repeat the steps above. Do this for the next 12 months.
If you find yourself feeling overwhelmed, it may help to use accounting software to automate the process of generating cash flow projections. Some experts also recommend that business owners create a best-case and worst-case scenario to get the most realistic cash flow projection. Your actual cash flow will likely be somewhere in the middle.
Once you know how to create a cash flow projection, you’ll find plenty of benefits to measure future performance this way.
For many small business owners, cash on hand doesn’t last long. Bills and unexpected emergencies can drain your business’s cash balance and derail your business growth. That’s why it’s critical to know when to pivot and when to stay the course.
A cash flow analysis can help you determine any consistent causes of negative cash flow. And, hopefully, show you when, historically, you have enough cash in your bank account to invest or spend. From there, a cash flow projection can help you understand and predict future cash inflow and cash outflow.
QuickBooks found that nearly three in five small business owners (59%) report that they have made a poor business decision due to concerns about insufficient cash flow. Cash flow projections don’t just increase your understanding. They also help you act with confidence.
Knowing how your business will perform in the coming months, based on actual cash flow data, can enable you to make informed decisions. You can say with confidence if now is a good time to invest in a new opportunity or put money aside. For instance, you may find that, right now, you’re in a period of negative cash flow. But if the coming month looks positive, there’s less need to postpone investments.
Budgets help you stay on course, but cash flow projections show you and others where your business is going. Outsiders—even insiders sometimes—need to know your business’s financial health is sound. Cash flow statements and cash flow forecasts can work together to help them understand your business’s current and future performance.
Accurate financial statements and cash flow forecasts may help you secure a business loan when you’re ready to grow your business. A solid cash flow projection may help you gain future investors or win a new business contract. It could also make your company more attractive to buyers.
While cash flow projections can’t always predict events, they can help you prepare for the worst. For instance, let’s say you know when your business is most cash flow positive. That’s a great time to put aside some extra savings in an emergency fund. Then, if there’s a hiccup, you have a cushion to prevent negative cash flow.
Another example is unpaid invoices. A cash flow projection might tell you there’s a time when those outstanding payments tend to stack up. If you know that problem is likely to occur, you may prevent it with additional communications or early payment incentives.
Cash flow projections are fairly straightforward but incredibly useful. It can be a bit sobering to see your actual cash flow, but this information can only help you make better decisions and grow your business responsibly.
Make cash flow forecasting a part of your business routine, and forecast at least once a year to stay on top of any changes. You can be more in tune with your business and confident in where you’re going.
While every care has been taken to ensure the accuracy of the information presented as at 01 May 2023, Intuit is not providing you with professional advice and we recommend you obtain your own professional advice. Intuit is not liable for your use of the information presented.
TAKE A NO-COMMITMENT TEST DRIVE
Our customers save an average of 9 hours per week with QuickBooks invoicing*
By entering your email, you are agree to our Terms and acknowledge our Privacy Statement.
Intuit helps put more money in consumers’ and small businesses’ pockets, saving them time by eliminating work, and ensuring they have confidence in every financial decision they make.
3x WeMoney Award Winner
