12-Month Cash Flow Forecast

Project your business cash position month by month. Enter opening balance, revenue growth, costs and one-time expenses. Negative months highlighted in red automatically.

12-Month View Negative Month Alert Visual Chart NGN Default
Base Assumptions
Monthly Revenue Input
One-Time Costs (Optional)

Add one-time expenses like equipment purchase, office setup, etc. Enter the month number (1–12) and amount.

12-Month Summary
Closing Cash Balance by Month
Month-by-Month Forecast
Row M1M2M3M4M5M6 M7M8M9M10M11M12
FAQ
What is a cash flow forecast?

A cash flow forecast projects when money comes in and goes out over a future period. Unlike a profit & loss statement, it tracks actual cash — including the timing of receipts and payments. It's the most important financial tool for small businesses because you can be profitable on paper but still run out of cash if timing is poor.

What does a negative closing balance mean?

A negative closing balance (highlighted in red) means you would run out of cash in that month. This requires action: secure a short-term loan, delay expenses, speed up collections, or raise emergency working capital. African businesses often use informal credit (rotating savings with Ajo/Chama, family loans) to bridge short-term cash gaps.

What tax rate should I use in Nigeria?

Companies Income Tax (CIT) in Nigeria: Small companies (turnover <₦25M/year): 0%. Medium companies (₦25M–₦100M): 20%. Large companies (>₦100M): 30%. For VAT purposes: standard VAT rate is 7.5%. This tool uses the rate you enter as a % of gross profit for simplicity.

Disclaimer: This forecast is based on the assumptions you enter. Actual results will differ due to market conditions, payment collection timing, unplanned expenses, and economic factors. Use this as a planning tool alongside your actual bookkeeping records.