Cash Flow Calculator
Type the cash you have and the money coming in and going out each month to see when cash gets tight.
Any currency: type its 3-letter code, e.g. USD, NGN, KES, ZAR.
A minus sign for an overdraft.
Amounts in USD.
Cash runs out in month 6.
| Month | Cash in | Cash out | Cash at the end |
|---|---|---|---|
| 1 | 120,000.00 | 130,000.00 | 40,000.00 |
| 2 | 120,000.00 | 130,000.00 | 30,000.00 |
| 3 | 120,000.00 | 130,000.00 | 20,000.00 |
| 4 | 120,000.00 | 130,000.00 | 10,000.00 |
| 5 | 120,000.00 | 130,000.00 | 0.00 |
| 6 | 120,000.00 | 130,000.00 | -10,000.00 |
Net cash flow for the period: -60,000.00.
- Formula: cash at the end of a month = cash at the start + cash in − cash out; the next month starts with that amount.
- Cash flow is not profit: a sale on credit is profit when you make it but cash only when the customer pays. Count money when it actually comes in or goes out.
Results are estimates to help you plan.
A guide to cash flow
What the calculator is for
A business can make a profit on paper and still run out of cash. This calculator follows your cash month by month for up to a year, so you can see the tightest month in advance and act before it arrives.
How to use it: an example
A business has KES 50,000 in the bank. Each month KES 120,000 comes in and KES 130,000 goes out. Cash falls by KES 10,000 a month: 40,000, 30,000, 20,000, 10,000, then exactly 0 at the end of month 5, and −10,000 in month 6.Cash runs out in month 6, and over the 6 months the business is KES 60,000 down.
Month by month
Real months are rarely the same. Choose "Month by month" to type each month's cash in and out. For example, starting with KES 20,000, a month with KES 100,000 in and 80,000 out leaves 40,000; a slow month with 50,000 in and 90,000 out leaves exactly 0; a busy month with 150,000 in and 70,000 out leaves 80,000. Cash never falls below 0, but month 2 is the one to plan for.
Starting overdrawn
If you start with an overdraft, type the opening balance with a minus sign. The calculator then tells you when you would be back to 0 or more. Starting at −5,000 with 10,000 in and 8,000 out each month, you are back above 0 in month 3.
Building a cash forecast
- Start from the cash you actually have today: bank accounts, M-Pesa and cash in the till, less any overdraft.
- List the money you expect in each month: cash sales, customers paying invoices, loans or capital coming in. Be realistic about when customers really pay, not when the invoice is due.
- List the money going out: stock, rent, salaries, statutory deductions, loan instalments, tax, transport, power and anything paid once a year, such as licences and insurance, in the month it is paid.
- Look at the lowest month first: that is the one to plan for.
- Each month, replace the forecast with what really happened and add a new month at the end.
Seasonal businesses
Many businesses have busy and quiet months: farming around harvests, shops around school terms and holidays, tourism around the high season. Use "Month by month" so the quiet months are not hidden in an average. A year that ends with more cash can still have a month in the middle when cash runs out.
Cash flow is not profit
- A sale on credit is profit when you make it, but cash only when the customer pays.
- Stock you buy uses cash now, but only becomes a cost when you sell it.
- A loan brings in cash but is not income; repaying it uses cash but only the interest is a cost.
So count money when it actually comes in or goes out of the bank, the till or M-Pesa.
What to do about a tight month
- Ask customers to pay sooner, or take a deposit on large orders.
- Agree longer terms with suppliers, or spread a big purchase.
- Hold back spending that can wait until after the tight month.
- If you need to borrow, compare the full cost first with the Loan Comparison Calculator.
What is not included
Anything you do not type in; the calculator does not know about tax payments, loan instalments or seasonal sales unless you include them. Results are estimates to help you plan.
Questions
Should I include money I put in myself?
Yes, as cash in, in the month you put it in; and any money you take out, as cash out.
Why only 12 months?
The further ahead you plan, the less certain the figures; update the plan each month as real figures come in.
Does "runs out" include ending a month at exactly 0?
No. It is the first month that ends below 0.