How to prepare a cash flow forecast for a business loan application

This guide is for owners and finance managers who have been asked for a cash flow forecast as part of a loan application and want to produce one a lender will trust. A cash flow forecast for a business loan is usually a month-by-month projection covering at least the next 12 months, showing opening cash, money expected in, money going out (including the new loan's drawdown and repayments, tax and VAT) and the closing balance each month, supported by written assumptions and a "what if" scenario. Smart Funding Solutions is a broker, not a lender. We arrange cash flow and working capital finance and other business funding from around £10,000 to £500,000+, with larger facilities available in suitable cases, and we regularly help clients sharpen forecasts before they reach a credit team.

01Why lenders ask for a cash flow forecast

Lenders ask for a forecast because historic accounts show what a business has done, while a forecast shows whether it can meet repayments in the months ahead. It answers questions accounts cannot: when cash is tightest, whether the loan solves the problem it is meant to solve, and whether the owners understand their own numbers.

A forecast matters most when the business is growing quickly, has had a weaker year, is borrowing for a new contract or project, or is relatively new. For established businesses borrowing modest amounts, some lenders rely mainly on accounts and bank statements; the forecast then supports the application rather than carrying it. Where a full business plan is needed, the forecast is the numerical core of it.

02What to include in a cash flow forecast for a business loan

A lender-ready cash flow forecast has a small number of essential lines, each based on when cash actually moves rather than when a sale or cost is recorded. The table sets out the lines most lenders expect.

Line	What goes in it	Common mistake
Opening balance	Cash in the bank at the start of each month (the previous month's closing balance)	Starting from a figure that does not match the bank statement
Receipts from sales	Cash received from customers, including VAT, timed by payment terms	Showing cash in the month of invoice rather than the month paid
Other receipts	Loan drawdown, asset sale proceeds, owner investment, grants	Mixing the new loan into sales receipts
Supplier and stock payments	Purchases timed by supplier terms	Assuming suppliers will extend terms without agreement
Wages and PAYE	Net pay, plus PAYE and National Insurance paid to HMRC the following month	Forgetting employer costs and pension contributions
Overheads	Rent, utilities, insurance, software, professional fees	Leaving out annual or quarterly bills
VAT	Net VAT payable or reclaimable in the month it is paid	Ignoring quarterly VAT payments
Corporation tax	Payments in the month they fall due	Omitting tax on an improving profit
Finance repayments	Existing loans, leases, and the proposed new loan	Showing the new loan coming in but not going out
Capital spending	Equipment, vehicles, fit-out	Double-counting items that are also asset financed
Owner drawings or dividends	Cash taken by owners	Leaving drawings out to flatter the figures
Closing balance	Opening balance plus receipts minus payments	Closing balances that never dip, which looks unrealistic

03How to build the forecast step by step

The most reliable way to build a forecast is to start from your actual bank position and recent trading, then project forward line by line using stated assumptions. These steps work for most small and medium-sized businesses.

1. Pull the last 12 months of actuals. Use bank statements and management accounts to see real monthly receipts and payments. This is your baseline and shows seasonality.
2. Set the forecast period. Twelve months is the minimum most lenders want; for longer loans or larger projects, add a further one or two years quarterly or annually.
3. Forecast sales, then convert to cash. Project invoiced sales by month, then move each month's sales into the month customers typically pay. If customers pay on 60-day terms in practice, January's sales appear as cash in March.
4. Forecast costs on the same basis. Time supplier payments by actual terms, wages by pay date, and quarterly and annual bills in the right month.
5. Add tax properly. Include VAT quarters, monthly PAYE and corporation tax dates. Tax is the line lenders most often find missing.
6. Add the new loan. Show the drawdown when you expect it and the repayments from the first due date. Use a realistic estimate; our business loan calculator helps.
7. Write the assumptions down. A one-page note explaining each key number is as important as the spreadsheet.
8. Run a downside scenario. Rework the forecast with lower sales or slower payment to show the loan still works.
9. Reconcile. Check the opening balance matches the bank, and that forecast profit, cash and the balance sheet broadly tie together.

A lender-ready cash flow forecast has a small number of essential lines, each based on when cash actually moves rather than when a sale or cost is recorded.

04The assumptions lenders test hardest

Lenders spend most of their time on the assumptions behind the numbers, not the arithmetic. A forecast with modest, evidenced assumptions is far more persuasive than an ambitious one with no support.

• Sales growth. Growth well above recent history needs a reason: a signed contract, a new site already open, an order book. Lenders often haircut growth they cannot verify.
• Customer payment times. Use the debtor days you actually achieve, not your stated terms. If customers pay late now, assume they will keep doing so.
• Margins. A forecast gross margin noticeably higher than the accounts show will be questioned. Explain price rises or cost savings.
• Staffing. Growth usually needs people. If sales double but the wage bill is flat, expect questions.
• Timing of the loan's benefit. If the loan funds equipment or expansion, show a realistic ramp-up period before extra income arrives.
• One-off items. Flag any unusual receipt or payment so a lender does not mistake it for ongoing trading.

05Sensitivity testing: showing the loan still works

Sensitivity testing shows a lender what happens to cash if things go worse than planned, and a forecast that survives a reasonable downside is much easier to fund. You do not need a complex model; one or two clear scenarios alongside the base case are usually enough.

Useful scenarios include sales 10% to 20% below the base case, your largest customer paying a month later, and a key cost rising. Show the lowest closing balance in each scenario and explain what you would do if it happened: delay discretionary spending, reduce drawings, use an existing facility.

Illustration only. A hypothetical joinery business forecasts monthly sales of £100,000, with customers paying after 60 days. It wants a £120,000 loan in month one for a CNC machine, repaid at £3,500 a month. In the base case, the lowest closing balance is £25,000 in month three, before extra output starts to be paid for. In the downside case, with sales 15% lower from month four, the lowest balance falls to £8,000 in month seven but never goes overdrawn. The lender can see the repayment is covered even on weaker trading, and the business can show it would hold back a planned van purchase if the downside appeared.

£50,000A transaction we arrangedHistoric loss. Improving numbers. £50K secured for dental growth.Several lenders focused on the previous year's numbers. We focused on what had changed.

06A simple forecast layout

A clear layout matters because a credit analyst may spend only a short time on your forecast. Months run across the top, cash lines down the side, with totals and the closing balance easy to find. The extract below is an illustration of the first quarter.

Illustration only (£)	Month 1	Month 2	Month 3
Opening balance	40,000	30,000	35,000
Customer receipts	90,000	100,000	95,000
Loan drawdown	50,000	0	0
Supplier payments	(40,000)	(45,000)	(45,000)
Wages and PAYE	(35,000)	(35,000)	(35,000)
Overheads	(10,000)	(10,000)	(10,000)
VAT and tax	0	0	(20,000)
Equipment purchase	(60,000)	0	0
Loan repayments	(5,000)	(5,000)	(5,000)
Closing balance	30,000	35,000	15,000

Notice the VAT payment in month three pulling the balance down: this is exactly the kind of dip a lender expects to see and wants to know you have planned for. If dips like this are regular and deep, a revolving facility, VAT loan or invoice finance may suit better than, or alongside, a term loan.

07Common mistakes that undermine a forecast

Most weak forecasts fail for the same handful of reasons, all of which are easy to fix before you submit. Check your forecast against this list.

• Profit and loss figures presented as cash flow, with no adjustment for payment timing.
• VAT, PAYE or corporation tax missing or in the wrong months.
• The loan shown as income with no repayments.
• Round, identical figures every month with no seasonality, when the bank statements show clear peaks and troughs.
• Owner drawings left out.
• No written assumptions, or assumptions that contradict the accounts.
• An opening balance that does not match the latest bank statement.
• A closing balance that rises steadily from month one, which suggests the loan may not be needed or that costs are understated.

08Where the forecast fits in the application

The forecast is one document in a pack that typically includes accounts, management accounts, bank statements and details of the loan's purpose. Our guide to documents needed for a business loan application lists the full set. Lenders use the forecast alongside affordability ratios such as the debt service cover ratio, so make sure the profit implied by your forecast is consistent with the cover you claim.

Keep the forecast updated. If an application takes a few weeks and trading moves, an updated version with actuals replacing forecasts for completed months shows a lender you are in control of the numbers.

09How Smart Funding Solutions can help