How to build a cash-flow forecast for a lender

A practical method for building the monthly cash-flow forecast that banks, leasing companies and guarantors ask for, with the lines most often forgotten.

  • By LGA.lv editorial team
  • Published
  • 3 min read
The former Riga Stock Exchange building in the Old Town
Photo: Nenea hartia, CC BY-SA 4.0

Profit is an opinion; cash is a fact. Lenders know that companies rarely fail because they are unprofitable on paper. They fail because they cannot pay a bill on the day it is due. That is why a cash-flow forecast is the document a credit officer spends most time on.

The basic structure

A forecast tracks money in and money out, month by month:

Line What goes in it
Opening cash Bank balance at the start of the month
Receipts Customer payments (when they pay, not when you invoice), VAT refunds, grants, other income
Operating payments Suppliers, salaries, payroll taxes, rent, utilities, transport, marketing
Tax payments VAT, corporate income tax on distributions, other taxes
Investment Equipment, premises, IT
Financing New loans received, loan repayments, interest, lease payments, dividends
Closing cash Opening cash + receipts − payments

The closing cash of one month is the opening cash of the next. If it ever goes negative, the business needs more finance in that month, or a different plan.

Building it step by step

  1. Start from sales by month, based on realistic volumes and prices. Use seasonality from past years.
  2. Convert sales into receipts using actual payment terms. If customers pay in 45 days on average, March sales arrive mostly in April and May.
  3. Model purchases and stock. Materials are usually bought before sales happen.
  4. Add payroll including employer social contributions, and remember holiday pay months.
  5. Add fixed costs month by month.
  6. Add VAT: you collect it on sales and pay it on purchases, and settle the difference with the State Revenue Service. For a growing business this timing matters.
  7. Add the investment in the months it is paid, including any advance payments to suppliers.
  8. Add financing: the new loan when it is drawn, repayments from the agreed date, interest on the outstanding balance, leasing, and any planned dividends.

Lines that are most often forgotten

  • VAT on the investment itself, paid before it is reclaimed
  • Advance payments demanded by equipment suppliers
  • Stock build-up before a sales season
  • Annual insurance premiums, licence fees and audit costs
  • Repayments of existing loans and leases
  • Owner withdrawals and dividends
  • Corporate income tax on distributed profit

Testing the forecast

Lenders will run their own stress tests, so run them first:

  • Sales 15–20% lower than the base case
  • Customers paying 30 days later than expected
  • Project delay: new capacity starting three to six months late
  • Interest rate two percentage points higher, for variable-rate loans

For each scenario check the lowest cash balance and the DSCR. If the business survives the pessimistic case, say so in the plan. If it does not, you need a buffer: a larger own contribution, a working-capital line, a grace period on the loan, or a smaller project.

Presenting it

Keep the forecast in a spreadsheet with assumptions on a separate sheet, clearly labelled. Credit officers trust a model they can change. Include a short note explaining the main assumptions and where they come from: past figures, signed contracts, supplier quotes.

If you have never built one, the loan calculator gives you the repayment and interest lines to plug in.

Questions people ask

What is the difference between profit and cash flow?

Profit records income when you invoice and costs when you incur them. Cash flow records money when it actually arrives or leaves. A profitable company can run out of cash if customers pay late, stock builds up or loan repayments are large.

How far ahead should the forecast go?

Monthly for the first 12 months, then annually for the rest of the loan term. Lenders mainly test the first two years in detail.

Sources

  1. State Revenue Service (VID), tax payment deadlines
  2. European Banking Authority, Guidelines on loan origination and monitoring