How to Present a Cash Flow Forecast to Your Bank

When you ask a bank for a loan, overdraft or credit line, the cash flow forecast is often the most important document you provide. Your accounts show where the business has been; the forecast shows whether it can repay. A clear, honest forecast, one you can explain line by line, makes the conversation shorter and the answer more likely to be yes.

What the bank is trying to find out

1. Can the business repay from its own cash flow? Not from the loan itself, and not from hoped-for sales.
2. What happens if things go worse than planned? Banks care more about the downside than the upside.
3. Does the owner understand the numbers?
4. Are the assumptions realistic compared with the business’s history and similar businesses?
5. Why is the money needed now, and what will it be used for?

Your forecast should answer all five.

What to include

1. A 12-month monthly forecast

Receipts, payments, net cash flow and closing balance for each month. Show the loan or facility as cash in when you expect to receive it, and every repayment and interest payment as cash out.

2. A short-term weekly view (if cash is tight)

A 13-week forecast shows you understand timing within the month, which is especially important for overdraft requests.

3. An assumptions page

A one-page table explaining the key numbers: sales volumes and prices, customer payment timing, staff costs, major purchases, and where each assumption comes from.

4. Recent actual figures

Three to twelve months of actual cash flow alongside the forecast, or at least a comparison of what you forecast last time with what happened. Banks trust forecasts from people with a track record of forecasting.

5. A downside case

A second version with lower sales (typically 15 to 25 percent), slower customer payments or higher costs, showing that repayments are still covered, or what you would do if they weren’t.

6. A summary

One page with the amount requested, what it’s for, the lowest cash balance with and without the facility, and how repayments are covered.

Showing repayment cover

Banks often look at how comfortably cash flow covers loan repayments. A simple way to show it:

Lenders use their own formulas and thresholds, which vary by bank and loan type, but showing that trading cash comfortably exceeds repayments, including in your downside case, is always persuasive.

Worked example: an overdraft request

A contractor asks for a $40,000 overdraft. The forecast shows:

• closing balances between $15,000 and $60,000 most months
• a low point of −$22,000 in March, when two large jobs need materials and payroll before progress payments arrive
• a downside case, with one client paying 30 days later, where the low point is −$34,000
• the overdraft cleared by June in both cases

That tells the bank exactly why the facility is needed, how much, when it will be used and how it will be repaid. It’s a far stronger request than “we’d like an overdraft for flexibility”.

Presentation tips

• Keep it readable. Group lines sensibly, label them plainly and show totals.
• Round numbers to the nearest hundred or thousand.
• Be consistent. The same figures should appear in the forecast, the summary and any business plan.
• Explain the lows. Point out the tightest months yourself before the bank finds them.
• Date it and say when it was last updated.
• Bring it to life. A chart of the monthly closing balance, with and without the facility, is often the most useful single page.

Before you send it

Check the forecast the way a lender will: change the opening balance and make sure every month moves, look for any month with a negative balance you haven’t explained, confirm the loan and every repayment are included, and compare the first months with your recent bank statements. Fix anything that doesn’t add up before the meeting, not during it.

Questions to prepare for

• How did you arrive at next year’s sales?
• How quickly do your customers really pay, and who are the largest?
• What happens if your biggest customer leaves or pays late?
• Why do you need the money now, rather than three months ago?
• What’s your fallback if sales are 20 percent lower?
• How much are you, the owner, putting in or leaving in the business?

If you can answer each of these from your forecast, you’re well prepared.

Common mistakes

• Leaving out repayments, or showing the loan with no cost.
• Optimistic sales with no link to history or capacity.
• No owner pay, which makes the business look more profitable than it is.
• Ignoring tax and quarterly or annual bills.
• Only one scenario.
• Numbers you can’t explain. If an adviser prepared the forecast, make sure you understand every line.

Loans, overdrafts and credit lines

The forecast should match the type of funding you ask for. A term loan for equipment or expansion is repaid in fixed installments, so show every repayment for the full term and that trading cash covers them. An overdraft or revolving credit line covers timing gaps, so show when it will be used, how deep it goes and when it will be cleared; banks are wary of facilities that never come back to zero. Invoice finance advances cash against unpaid invoices, so show the advances and the fees alongside your normal collections.

After the meeting

Keep the forecast up to date. Many facilities come with regular reporting; sending the bank a monthly or quarterly update showing actual against forecast builds trust and makes the next request easier.

Templates for bank forecasts

The free 12-month template is a good base for a simple request. Premium templates add a 13-week view linked to the 12-month forecast, a 3-year outlook, best and worst case scenarios, an actuals tab and a variance report, which together cover almost everything a bank asks for. See also what lenders look for, the business plan guide and how to improve forecast accuracy.