12-Month Cash Flow Forecast

This cash flow forecast shows whether your business will have enough cash over the next year. Enter your opening cash, monthly sales and growth, how quickly customers pay, how much you spend on stock and when you pay suppliers, your fixed costs and loan repayments, and add one-off items like equipment purchases. It produces a 12-month table of receipts, payments and closing cash, highlights the lowest point and any months in the red, and exports to CSV. It runs in your browser.

Example: sales 50,000 a month, 50/40/10 collections

MonthReceiptsPaymentsClosing
150,00047,00013,000
250,00047,00016,000
3 (capex 20,000)50,00067,000−1,000
450,00047,0002,000

When to use it

  1. Plan for a seasonal cash squeeze.
  2. Show a bank how a loan will be repaid.
  3. Decide when you can afford new equipment.
  4. See the cash effect of giving customers longer credit.
  5. Build a simple startup budget.

How to Use

  1. Enter opening cash, sales and growth.
  2. Set the collection pattern and supplier terms.
  3. Enter fixed costs and loan repayments.
  4. Add one-off items and read the 12-month table.

Features

  1. 12-month projection
  2. Collection pattern
  3. Supplier payment timing
  4. One-off items by month
  5. Lowest balance and shortfalls
  6. CSV export
  7. 100% client-side

FAQs

What is a cash flow forecast?

A month-by-month projection of cash coming in and going out, showing the balance at each month end.

Why does profit differ from cash?

Customers pay later than you sell, suppliers are paid later than you buy, and loans and equipment use cash without being expenses.

What collection pattern should I use?

Look at how your customers actually pay: for example 50% in the month, 40% the next and 10% after.

What if the balance goes negative?

Plan an overdraft, delay spending, speed up collections or arrange finance before that month.

Is anything uploaded?

No. Everything runs in your browser.

Technical Details

Sales grow by a monthly rate. Receipts follow a collection pattern — a share collected in the month of sale, the next month and the month after (months before the start use the first month's level) — plus any other receipts. Payments are purchases as a share of sales (paid the same or the next month), fixed costs, loan repayments, equipment and other one-off payments. Closing cash = opening + receipts − payments, carried forward month by month; the lowest balance and any negative months are flagged. One-off items by month can be added from a CSV.

Finance & Tax Tools

Finance & Tax Tools

  • Withholding Tax Calculator (Pakistan)
  • Rental Yield and Cap Rate Calculator
  • Rent vs Buy Calculator
  • Property Transfer Cost Calculator
  • Tip Pool Calculator
  • Wedding Budget Planner
  • Mortgage Calculator
  • SIP & Inflation Calculator