Small Business Cashflow Forecast Calculator

This calculator forecasts your small business cash flow month by month, so you can see whether you will stay solvent, when cash dips to its lowest, and if and when you might run out, the single most important thing for any small business to know. Profit and cash are not the same thing, and many profitable-looking businesses fail simply because they run out of cash at the wrong moment. A forecast answers the question every owner and lender asks: will there be enough money in the bank to keep going? This tool keeps the model simple and clear. You enter your starting cash, your current monthly revenue, your monthly expenses, an expected monthly revenue growth rate, and the number of months to project. The calculator then steps through each month, growing revenue, subtracting expenses, and tracking the running cash balance, and reports your ending cash at the end of the period, the lowest point your balance reaches along the way, and the month, if any, your cash goes negative. That lowest point matters as much as the end figure, because a business that ends the year healthy can still hit a cash crisis in a lean month in between. Use it to plan, to size an overdraft or working capital buffer, to time a hire or a big purchase, or to support a funding conversation with the bank. A negative balance is a warning to cut costs, raise prices, chase debtors faster, or secure finance before the gap arrives. This is a simplified forecast that assumes steady growth and even expenses; for tax, GST timing and seasonal swings, build a detailed forecast with your accountant.

$
$
$
%
$18,860
cash at end of the period
Lowest cash point$13,460
Goes negativeStays positive
Net this month-$2,000

A simplified forecast with steady growth and even expenses. Ignores GST timing, tax and seasonality. Build a full forecast with your accountant.

How it works

The forecast starts with your opening cash, then for each month it grows revenue by your growth rate, subtracts your monthly expenses, and adds the result to the running balance. It reports the ending cash, the lowest the balance reaches during the period, and the first month the balance turns negative, if any.

Worked example

Starting with $20,000, revenue of $12,000 growing 3 percent a month, and expenses of $14,000, the business loses $2,000 in month one and dips for several months while revenue catches up. Revenue passes expenses around month six, and the balance recovers, ending the year near $18,860 with a lowest point around $13,460. If the start cash were lower, it could go negative mid-year.

Related calculators

If you've found a bug, or would like to contact us, or learn more about James Graham and Calculate.co.nz.

Calculate.co.nz is partnered with Interest.co.nz for New Zealand's highest quality calculators and financial analysis.

All calculators and tools are provided for educational and indicative purposes only and do not constitute financial advice.

Calculate.co.nz is proudly part of the Realtor.co.nz group, New Zealand's leading property transaction literacy platform, helping Kiwis understand the home buying and selling process from start to finish. Whether you're a first home buyer navigating your first property purchase, an investor evaluating your next acquisition, or a homeowner planning to sell, Realtor.co.nz provides clear, independent, and trustworthy guidance on every step of the New Zealand property transaction journey.

Calculate.co.nz is also partnered with Health Based Building and Premium Homes to promote informed choices that lead to better long-term outcomes for Kiwi households.

Calculate.co.nz is hosted in Auckland via SiteHost new Zealand.

All content on this website, including calculators, tools, source code, and design, is protected under the Copyright Act 1994 (New Zealand). No part of this site may be reproduced, copied, distributed, stored, or used in any form without prior written permission from the owner.

© 2019 to 2026 Calculate.co.nz. All rights reserved.