Funding strategy

Build a Cash Flow Forecast Before You Borrow

Chart displayed on a laptop screen
Photo via Unsplash
Quick answer

A cash flow forecast lists the cash you expect to receive and pay out each month. Adding a proposed loan payment to it shows whether the business can carry the debt. Twelve months on a single spreadsheet is enough for most small businesses.

Profit is not cash

A business can show a profit and still run out of money. Customers pay late, inventory has to be bought ahead of sales and loan principal does not appear on a profit and loss statement at all. Lenders know this, which is why they focus on cash flow. You should too.

Build it in five steps

  • List the next twelve months across the top of a spreadsheet
  • Enter the cash you expect to collect each month, based on when customers actually pay
  • Enter every cash expense in the month it will be paid
  • Subtract outflows from inflows for a monthly net figure
  • Carry the running balance forward from month to month

Start with your current bank balance. Use real history where you have it. If you are new, use conservative estimates and write down the assumption behind each one.

Book a free consultationExplore SBA loans

Add the loan

Put the loan proceeds in the month you would receive them and the payment in every month after. Add the spending the loan pays for and the extra revenue you expect it to produce, with a realistic delay. Now look at the running balance. If it stays comfortably positive, the plan holds. If it dips below zero in any month, you have found a problem before a lender did.

Test it

Run three versions. In the expected case, things go as planned. In the slow case, revenue is 25 percent lower and arrives two months later. In the bad case, a major customer leaves or a large expense appears. A loan that survives the slow case is a reasonable risk. This is the same reasoning behind good debt vs bad debt.

What lenders do with it

Underwriters calculate debt service coverage, which is cash available for debt divided by total debt payments. Many want about 1.25 or more. Your forecast lets you see that ratio in advance and adjust the request. The method is explained in how underwriters evaluate a business.

Use it to size the request

The forecast answers how much to borrow better than any rule of thumb. It also shows when you need the money, which may be later than you think. Borrowing in stages can save interest.

Watch for daily payment products

Products repaid by daily or weekly debits behave differently from monthly loans. Model them on their real schedule. Their effect on cash is often larger than expected, as described in merchant cash advances explained.

Keep it current

Update the forecast monthly with actual results. Bring it to any funding conversation. Our guide on how to prepare for a funding consultation lists what else to have ready.

A three month example

A wholesale bakery starts April with 20,000 dollars in the bank. It expects to collect 60,000 dollars in April, 52,000 dollars in May and 70,000 dollars in June. Cash going out is 58,000 dollars in April, 64,000 dollars in May and 61,000 dollars in June, because a large flour order and an insurance premium both land in May.

  • April. Opens at 20,000 dollars, ends at 22,000 dollars.
  • May. Opens at 22,000 dollars, ends at 10,000 dollars.
  • June. Opens at 10,000 dollars, ends at 19,000 dollars.

The business is profitable across the quarter, yet May leaves very little room. If one large customer pays two weeks late, the account could run short. Now add a proposed loan payment of 3,500 dollars a month. May would end at 3,000 dollars after two payments, which is too thin. The forecast tells the owner to borrow less, stretch the term or arrange a line to cover the dip.

Tools that are enough

A spreadsheet with one column per month is all it takes. List cash in at the top, cash out below and the running balance at the bottom. Most accounting software can also produce a cash flow projection from your existing records. The tool matters far less than the habit of updating it.

Mistakes that make a forecast useless

  • Recording sales when invoiced instead of when the cash arrives
  • Leaving out annual and quarterly bills such as insurance and taxes
  • Forgetting the owner’s pay
  • Assuming every customer pays on time
  • Building one optimistic case and no slow case

Share it with your lender

An owner who brings a forecast to a lender stands out. It shows the request was sized on purpose, and it answers most underwriting questions before they are asked. What the underwriter does with it is explained in how underwriters evaluate a business.

Funding Funding Funding reviews cash flow with clients as part of its SBA loan processing and other services.

Frequently asked questions

What is a cash flow forecast?

It is a month by month estimate of the cash a business expects to receive and pay out, showing the running bank balance over time.

How far ahead should I forecast cash flow?

Twelve months is a practical horizon for most small businesses. Update it each month with actual results.

Official resources

This article is general information and is not legal, tax or financial advice. Funding Funding Funding is a consulting company and not a lender. All funding is subject to lender approval.

Related funding guides

Laptop, coffee and phone on a work table

Not sure where you fit?

Tell Michael about your business on a free call and he will show you which of the four services applies.

Book a free consultation