What Lenders Look for in a Cash Flow Forecast

Whether you’re applying for a term loan, an overdraft, invoice finance or a government-backed loan, the lender will ask for a cash flow forecast. They read it differently from you: you want to see if the plan works, they want to see what happens if it doesn’t. Understanding what they look for helps you prepare a forecast that answers their questions before they ask.

1. Can the business repay from its own cash?

The central question. Lenders want to see loan payments covered by cash generated from trading, not by the loan itself, new investment or optimistic future sales. Many use a coverage measure such as the debt service coverage ratio, cash available for debt payments divided by those payments, and look for a comfortable margin above 1.

Show it clearly: a line for loan payments, and a summary of trading cash compared with total debt payments for each year.

2. Are the assumptions realistic?

Lenders compare your assumptions with:

• Your history: sales, margins and costs from past accounts and bank statements
• Your capacity: can you actually deliver the forecast sales with your staff, premises and equipment?
• Your industry: typical margins, payment terms and growth rates
• Your evidence: contracts, orders, pipeline, letters of intent

Put the key assumptions on one page with their source. “Sales grow 40 percent” invites scepticism; “sales grow 40 percent because a signed contract adds $15,000 a month from April” invites a nod.

3. Is everything included?

Missing costs are one of the most common reasons lenders adjust or reject forecasts. Check for:

• Owner pay or drawings
• Taxes: sales tax or VAT, payroll taxes, income or corporation tax
• Loan payments on existing debt as well as the new loan
• Annual and quarterly costs: insurance, licences, software, audits
• Capital spending: equipment, vehicles, replacements
• Working capital: stock and the delay in customer payments

4. What’s the lowest cash point?

Lenders go straight to the lowest closing balance. If it’s close to zero, there’s no room for anything to go wrong. Show a buffer, and if the forecast dips below it, explain how the facility you’re requesting covers it and when it will be repaid.

5. What happens in a downside case?

Lenders care about the downside more than the upside. Include a version with lower sales, slower customer payments or higher costs, and show either that repayments are still covered, or what you would do. See scenario planning.

6. Does it match your history?

A forecast that suddenly shows margins, sales growth or payment times far better than your past accounts needs explaining. Consistency builds trust; unexplained improvements erode it.

7. Do your forecasts come true?

If you’ve forecast before, show how actual results compared. A business that forecasts within 10 percent and explains its variances is far more credible than one with a perfect-looking spreadsheet and no track record. See variance analysis.

8. Does the owner understand it?

Expect questions on any line. If you can explain how you arrived at each number, what would change it and what you’d do if it went wrong, the forecast becomes far more convincing.

What a strong forecast looks like

A strong forecast is usually unremarkable to read: numbers close to recent history, growth explained by specific contracts or capacity, a lowest balance with a sensible buffer, a downside case that still covers repayments, and an owner who can explain every line. Lenders see plenty of ambitious forecasts; a believable one stands out.

Red flags

• A “hockey stick” sales curve with no evidence
• No owner pay
• No tax payments, or VAT and sales tax treated as income
• The loan shown without repayments
• Only one scenario
• Round numbers everywhere (“$10,000 a month forever”)
• Figures that don’t match the business plan or accounts
• A forecast the owner can’t explain
• Existing loans, leases or credit card debt missing from the payments

Different lenders, different emphasis

• Banks and term lenders focus on repayment capacity over the full term and on security.
• Overdraft and credit line providers focus on the timing of peaks and troughs and on how quickly the facility clears.
• Invoice finance providers focus on your customers, how reliably they pay, and your receivables.
• Government-backed loan programs, such as SBA loans in the US, follow the lender’s underwriting with program rules on top. See the SBA projection guide.
• Asset finance providers focus on the asset and whether its use generates the cash for payments.

Working capital: the line lenders check twice

Growing businesses often need more cash tied up in stock and unpaid invoices as they grow. Lenders know this, and they check whether your forecast accounts for it. If sales grow 30 percent and customers pay in 45 days, the money owed to you grows too, and that cash isn’t in the bank. If you hold stock, more sales usually means more stock bought in advance. A forecast that shows sales growing but the cash cycle unchanged will be questioned. Show receipts on realistic payment timing and stock purchases ahead of sales, and the working capital need appears on its own.

A lender-ready checklist

1. 12 months monthly (and 13 weeks weekly if cash is tight), plus annual years two and three if required
2. The loan in, and every repayment out
3. Owner pay, taxes, existing debt and annual costs included
4. An assumptions page with sources
5. A downside case with your response
6. Repayment coverage shown for each year
7. Recent actual figures, or past forecasts against actual results
8. A one-page summary
9. Consistent figures across every document
10. Dated, with the date of the last update

For presentation tips and the questions to prepare for, see how to present a cash flow forecast to your bank.

Templates

The free 12-month template covers the basics. Premium industry templates add a linked weekly view, a 3-year outlook, scenarios, an actuals tab and a variance report, which together cover most of this checklist.