BusinessPlanHub

Free calculator

Cash flow calculator

A cash flow forecast is a month-by-month record of money coming in and going out. It shows when your bank balance falls, which profit alone does not. The lowest balance in the forecast is the figure that decides how much cash you need before you start.

Your numbers

The figures below are an example. Replace them with yours.

Your cash over twelve months

Why can a profitable business run out of cash?

A profitable business runs out of cash when money leaves its account before the matching money arrives. Profit books a sale the day you make it. Your bank balance only moves when the customer pays. Three delays open the gap: customers who pay late, stock you buy before you sell it, and suppliers you pay on delivery.

The example in the calculator shows it. Sales start at $8,000 and grow 8% a month, to about $18,650 by month 12. Over the year the business makes a profit of $37,090. Yet it ends the year with $1,225 less cash than it started with, and in month 3 its balance sits $7,085 below zero.

Where the profit went in the example (figures rounded)
ItemEffect on cash
Profit over 12 months+$37,090
Still owed to you by customers−$21,555
Stock bought and not yet sold−$16,761
Owed to suppliers$0
Change in cash−$1,225

None of that is a loss. The customers will pay and the stock will sell. The trouble is the timing, and in month 3 the business has no money to pay its rent.

Which change helps cash the most?

In this example, the three payment terms together do the most, and they cost nothing in sales. Each row below changes one term from the starting example and leaves the rest alone.

Effect of each change on the lowest balance and year-end cash
ChangeLowest balanceCash at month 12
The example as it stands−$7,085 (month 3)$8,775
Customers pay in 30 days, not 60−$1,964 (month 2)$19,137
Suppliers paid after 30 days, not on delivery−$2,732 (month 2)$17,477
One month of stock, not two−$2,732 (month 2)$17,477
All three together$5,800 (month 2)$35,898

The second and third rows match because paying a supplier a month later and buying a month later move cash by the same amount. They are different jobs in practice. One is a negotiation and the other is a stocking decision.

How much cash do you need before you launch?

You need at least the amount that lifts your lowest balance to zero, plus a cushion. The calculator shows that amount as “extra cash you would need”. In the example it is $7,085 on top of the $10,000 already in the bank.

If you are going to a lender or an investor, we would look at that lowest month first and the year-end figure second. A forecast that ends the year with $8,775 in the bank reads well until the reader finds month 3. Show the dip yourself, and show what covers it.

What does the calculator leave out?

The model counts sales, cost of sales, a fixed monthly running cost, payment terms, stock and your starting cash. It treats every month as 30 days and assumes costs and growth hold steady for the year. It leaves out tax, interest, loan repayments, owner pay, one-off buys such as equipment, and seasonal swings.

You can fold some of that in. Put owner pay and loan repayments into running costs. For a seasonal business, run the calculator twice, once for the busy months and once for the quiet ones, and read the worse result as the one that counts.

When do you need a full cash flow forecast instead?

You need one when the simple version stops describing the business. Several products with different margins, a loan with its own schedule, a big purchase in month five, or sales that jump with the seasons are all signs. A full forecast also carries a profit and loss and a balance sheet, and all three have to agree.

The financial projections guide explains what goes into that forecast and how a lender reads it. The break-even calculator tells you the sales level you need first, which is a good number to have before you set the growth rate here.

This tool is a planning aid. It is not legal, tax, accounting or investment advice. Your inputs stay in your browser and are not sent or stored. Last reviewed .

Frequently asked questions

What is cash flow?

Cash flow is the money moving in and out of your bank account over a period, and its balance at the end of each month is what decides whether you can pay your bills. A business can be profitable on paper and still have a negative cash balance, because profit counts a sale when you make it and cash counts it when the money arrives.

Does profit equal cash?

No. Profit is sales minus costs in the month they happen. Cash only moves when customers pay and when you pay suppliers. The gap between the two is money owed to you, stock you have bought but not sold, and bills you have not paid yet. The calculator shows that gap in the results.

What does negative cash flow mean?

In a single month it means more money left your account than came in. That is normal for a business that is growing or has just bought stock, and it is fine while your balance stays above zero. The problem is a balance that reaches zero, and the calculator shows the lowest balance in the year so you can see how close you get.

How much cash should a business keep?

At the least, a balance above zero in every month of the forecast. Beyond that it depends on how predictable your sales are. The forecast gives you the lowest point. The cushion on top of it is your decision, and a business with steady repeat customers can carry less than one with a seasonal peak.

How many months does a cash flow forecast need to cover?

This calculator covers 12 months. A forecast for a lender or an investor often runs longer, so check what the lender or investor you are approaching asks for before you build it.

Does this include loans, tax or my own pay?

No. It models sales, cost of sales, fixed running costs, customer payment terms, supplier terms and stock. Loan repayments, tax, owner pay and one-off purchases such as equipment are left out. Add owner pay and loan repayments to your monthly running costs to get a closer picture.

More free tools and guides