Free calculator · No signup
Cash Flow Forecast Calculator
Enter your cash today, expected sales and costs, and how long customers take to pay. See your bank balance month by month and spot a shortfall before it happens.
Your numbers
Money you can spend now. Leave out promised money you have not received.
What you expect to invoice or sell in the first month. Enter 0 if you will not sell yet.
If customers pay invoices later, the cash arrives after the sale.
Everything that leaves the bank in a month: rent, salaries, your own pay, stock, software, ads, loan repayments.
Your cash flow forecast
Cash at the end of month 12
$9,121
Cash stays above zero, but falls to $9,121 in month 12. That leaves little room for a late payment or a surprise cost.
- Lowest cash balance
- $9,121 (month 12)
- Cash first goes below zero
- Not in this period
- First month cash in covers costs
- Not in this period
- Total cash in
- $89,830
- Total cash out
- $120,709
| Month | Cash in | Cash out | Closing cash |
|---|---|---|---|
| 1 | $0.00 | $9,000 | $31,000 |
| 2 | $6,000 | $9,180 | $27,820 |
| 3 | $6,360 | $9,364 | $24,816 |
| 4 | $6,742 | $9,551 | $22,007 |
| 5 | $7,146 | $9,742 | $19,411 |
| 6 | $7,575 | $9,937 | $17,049 |
| 7 | $8,029 | $10,135 | $14,943 |
| 8 | $8,511 | $10,338 | $13,116 |
| 9 | $9,022 | $10,545 | $11,593 |
| 10 | $9,563 | $10,756 | $10,400 |
| 11 | $10,137 | $10,971 | $9,566 |
| 12 | $10,745 | $11,190 | $9,121 |
Short answer
A cash flow forecast estimates how much cash will be in your bank at the end of each future month. Each month you start with the previous month's closing cash, add the money you expect to receive and subtract the money you expect to pay out. The month with the lowest balance tells you how much cushion you really have.
Updated · Team Fonda
How to use the cash flow forecast calculator
- Cash in the bank today: money you can spend now. Leave out investment or loans you have been promised but not received.
- Sales in month 1 and monthly sales growth: what you expect to sell in the first month, and how fast that grows. The sales forecast calculator can help you build this number from leads and conversion.
- When customers pay you: choose the same month if customers pay by card or upfront, or a delay of one to three months if they pay on invoice.
- Costs paid in month 1 and monthly cost growth: everything that leaves your account in a month, including your own pay, stock, loan repayments and taxes you pay monthly.
- Forecast period: 6 to 24 months.
The result shows your cash at the end of the period, your lowest balance and the month it happens, the first month cash goes below zero if it does, the first month cash coming in covers cash going out, and a month-by-month table. Months where the balance is negative are shown in red.
The cash flow forecast formula
Formula
Closing cash = opening cash + cash in - cash out. Sales in month m = month 1 sales x (1 + sales growth)^(m - 1). Cash in for month m = sales from (m - payment delay). Cash out in month m = month 1 costs x (1 + cost growth)^(m - 1).
This is the direct method, the one most small businesses use for a short-term forecast: you list cash actually arriving and leaving, month by month. Each month's closing cash becomes the next month's opening cash. The payment delay is what separates a cash flow forecast from a profit forecast. With a one-month delay, a sale you make in March only reaches your bank in April. The calculator assumes you start with no unpaid invoices, so with a delay nothing comes in during the first month or months.
If your cash in and costs stay flat and customers pay in the same month, this gives the same answer as the startup runway calculator. The forecast adds growth and payment timing, which is where most real shortfalls come from.
A worked example
Say you start a small agency with $40,000 in the bank. You expect to invoice $6,000 in month 1 and grow sales by 6% a month. Clients pay one month after you invoice. Your costs are $9,000 a month and rise 2% a month as you add tools and help.
Month-by-month results for the example
Scroll sideways to see the whole table.
| Month | Cash in | Cash out | Closing cash |
|---|---|---|---|
| 1 | $0.00 | $9,000 | $31,000 |
| 2 | $6,000 | $9,180 | $27,820 |
| 3 | $6,360 | $9,364 | $24,816 |
| 6 | $7,575 | $9,937 | $17,049 |
| 9 | $9,022 | $10,545 | $11,593 |
| 12 | $10,745 | $11,190 | $9,121 |
Selected months from the calculator's 12-month table. Over the 12 months, $89,830 comes in and $120,709 goes out.
Cash never goes below zero, but the balance falls to $9,121 by month 12 and cash in has still not caught up with costs. The calculator flags this as tight: one late client or an unexpected bill would bite hard. Extend the forecast to 18 months and you see the turn: cash in first covers costs in month 14, the lowest balance is $9,097 in month 13, and you end month 18 with $16,566.
Now change only the payment terms. If clients paid the same month, the 12-month closing cash would be $20,511. If they took two months, it would be -$1,624: the business runs out of cash in month 12 even though nothing else changed. That is why many profitable-looking businesses still run short.
What to do if the forecast shows a shortfall
- Get paid sooner. Ask for deposits, shorter payment terms, upfront annual plans or card payment instead of invoices. In the example, moving clients from two months to one is worth more than $10,000 by month 12.
- Delay costs that do not drive sales. Hires, equipment and long contracts can often wait until cash in covers cash out.
- Arrange funding before you need it. A loan or investment takes time, and it is easier to ask while the bank balance is still healthy. The month the forecast goes negative is your deadline, not your start date.
- Recheck your sales assumptions. If the forecast only works with fast growth, test that growth is real before spending against it. How to validate a startup idea covers ways to do that cheaply.
When you are ready to write the forecast into a plan, the Launch phase of Fonda's journey includes a 10-chapter business plan with sources, and the Scale phase covers key metrics and raising money. It is free to start.
What the calculator leaves out
Sales and costs grow at a steady rate here. Real months are lumpier: seasonal sales, quarterly or yearly bills, tax payments, one-off equipment purchases, loan or investment money arriving, and customers who never pay. The model also assumes every customer pays on the same delay. For decisions that matter, copy the numbers into a spreadsheet and adjust the months you know will be different. Taxes and payment rules vary by country, so ask an accountant which payments to include and when they fall due.
If you want a quick view of how fast you are spending rather than a full forecast, the burn rate calculator is simpler, and the break-even calculator shows how many sales cover your monthly costs.
Frequently asked questions
What is the difference between a cash flow forecast and a profit and loss forecast?
A profit and loss forecast records sales and costs when they are earned or incurred. A cash flow forecast records them when money actually moves. A business can show a profit on paper and still run out of cash if customers pay late or if it buys stock before selling it.
How far ahead should a cash flow forecast go?
Twelve months is a common horizon for planning and for lenders, with the next few months in the most detail. If you are raising money or the forecast shows a dip near the end of the period, extend it so you can see whether and when the balance recovers.
Should I include my own salary?
Yes, if you plan to pay yourself. Leaving it out makes the business look healthier than it is, and you will find out the hard way when you need to draw money. If you are not paying yourself yet, note that the forecast depends on that.
What does a negative closing balance mean?
It means that at the end of that month you would owe more than you have, so you need extra cash before then: from savings, a loan, investment, faster customer payments or lower costs. The size of the lowest balance tells you roughly how much.
Is this calculator free?
Yes. It runs in your browser, needs no signup and does not store your numbers.
Related tools and guides
Add this calculator to your website
Free to use on any site. Paste this code where you want the calculator to appear, and keep the credit link.
<iframe src="https://fonda.co/embed/cash-flow-forecast-calculator" title="Cash Flow Forecast Calculator" width="100%" height="720" style="border:0;max-width:960px" loading="lazy"></iframe>
<p style="font-size:13px"><a href="https://fonda.co/tools/cash-flow-forecast-calculator">Cash Flow Forecast Calculator</a> by Fonda</p>