How Do You Build a Cash Flow Forecast for a Business Acquisition?

What the forecast has to prove, and to whom

An acquisition cash flow forecast has two audiences with two different questions, and it fails if it only answers one. The lender wants to see that cash available for debt service clears the loan payments with a margin, month after month, not just on an annual average. You need to see something the lender never asks about: whether the business can pay the loan, replace its equipment, absorb a soft quarter and still pay you enough to live on.

That dictates the shape. A lender-grade forecast runs monthly for at least the first twelve months and usually twenty-four, then quarterly or annually out to year three. It links, or at least reconciles, to a projected income statement and balance sheet, because cash flow invented without the other two statements always hides an error somewhere. And it sits on a written assumptions page: where every number came from, so a credit analyst can challenge the inputs instead of dismissing the output.

Know who will actually read it. A bank credit analyst reads the debt service line and the assumptions page. BDC reads the transition plan behind the revenue, and a seller weighing a vendor take-back reads whether their own payments look safe. You will read it every month for two years, which is the strongest argument for building it honestly.

Get the sequence right and the work compounds. The same model answers the affordability question before the offer, becomes the centrepiece of the financing package, and after closing turns into the budget your lender reporting is measured against. Built once, used three times.

Step one: start from the opening balance sheet the deal creates

Every acquisition forecast starts at day one, and day one is defined by the transaction structure, so the opening balance sheet comes first. It records what you actually own and owe the morning after closing: the assets at the prices allocated to them, the acquisition debt on its real terms, the cash you injected, and the working capital that did or did not come with the deal.

This is where the choice between an asset purchase and a share purchase stops being a lawyer conversation and starts driving numbers. In an asset deal you typically start with no receivables and no payables, which means the forecast must fund an entire collection cycle from cash before customer money arrives. In a share deal the working capital comes along, but so do the existing liabilities and the tax attributes, and the price adjustment against the working capital peg lands in your opening position. Deal costs, financing fees and any HST timing on closing belong here too, because they are real cash out before the first sale.

Practically, the opening balance sheet lists: cash after the down payment and closing costs leave; inventory, equipment and other assets at their allocated purchase prices; whatever receivables and prepaids came with the deal; the term loan, vendor take-back and assumed leases at their opening balances; and your equity as the residual. Financing fees and the registration fee on a government-backed loan belong here too, because they are cash out before the business earns anything.

Buyers usually negotiate structure with lawyers first and hand the accountant the result. Building even a rough opening balance sheet for each candidate structure while the deal is still fluid shows you, in cash terms, what each version costs to live with. It is the cheapest structural advice you will ever get.

A forecast that skips the opening balance sheet and just projects revenue forward is a profit forecast wearing a costume. The first-year cash crunch it needs to warn you about lives almost entirely in that opening position.

Step two: build revenue and costs from evidence, not hope

Revenue in an acquisition forecast should be traceable to the seller history, adjusted only for things you can name. Get twenty-four to thirty-six months of monthly figures, not annual totals, because the seasonality pattern is the single most useful thing in them: a landscaping business and a tax practice can have identical annual revenue and completely different survival math in February.

Then adjust with reasons attached:

• Split revenue by dependability. Contracted and recurring revenue carries forward; repeat-but-uncommitted customers get a retention assumption; one-off project work gets rebuilt from the pipeline, not extrapolated.
• Apply a transition haircut. Some customers buy from the seller personally. Year one should assume a portion of that revenue takes time to re-earn, and the size of that haircut is a judgement your due diligence findings should inform directly.
• Reprice what changes under you. New rent if the lease was related-party, market wages where family worked cheap, your own salary at a real number.
• Keep margins honest. Direct costs move with your revenue assumption, and supplier terms the seller earned over twenty years may not be yours in month one.

Cross-check the revenue build against physical capacity before you fall in love with it. A forecast that needs more billable hours than the crew can work, more covers than the dining room seats or more jobs than the trucks can reach is wrong no matter how defensible each assumption looked on its own. Capacity math takes an hour and catches more bad forecasts than any spreadsheet technique we know.

Be deliberate about price. Sellers often leave prices untouched for years before a sale, which can mean genuine room, but a buyer modelling an immediate increase is stacking a second change on top of an ownership change. If a price move is in the plan, phase it, and show the customer churn assumption beside it so a lender can see it was paid for honestly.

Involve the seller in the assumptions where the deal allows it. Nobody knows the rhythm of the business better, and a seller carrying a take-back has every reason to be honest about which customers wobble in a transition. The questions they dodge are findings in themselves.

Everything in this step should trace back to the diligence file: the same bank statements, HST filings and customer lists examined in financial due diligence before buying a business are the evidence base for the forecast. If diligence has not been done yet, the forecast tells you exactly what to go verify.

Step three: layer in the schedules first drafts always miss

The difference between a spreadsheet of hopeful revenue and a forecast a bank will fund is a handful of supporting schedules, each feeding the monthly cash line. These are the ones that matter and where they usually go wrong:

The debt schedule deserves particular care because it is what the lender checks first. Every layer of the acquisition financing belongs in it on its actual terms: the term loan with its amortization, the vendor take-back with its start date and any interest-only window, equipment leases assumed with the business, and the operating line with its cost. Debt service is the one set of numbers in the whole model with no uncertainty in it, so getting it wrong reads as carelessness.

The tax schedules reward the same discipline. A new corporation may face no instalments in its first year and then meet them in year two, so the model should show that step up. HST filing frequency is a choice with cash consequences: monthly filing returns input credits faster during the heavy-spending early months, while quarterly filing means less administration once things settle. Payroll remittance timing is fixed by CRA, and missing it in the model usually predicts missing it in life, where the penalties are immediate.

Step four: model the working capital swing that hits in the first six months

The most dangerous months in an acquisition are usually the first six, and the danger is timing, not profit. A profitable month can be a terrible cash month. You pay wages weekly and suppliers on thirty days, while your customers pay on sixty, so every dollar of revenue growth consumes cash before it returns any. In an asset deal this arrives with force, because the seller kept the receivables: you are funding payroll and inventory for weeks before the first collections land.

Model it explicitly. Give receivables a realistic collection lag taken from the seller aging report, not from the payment terms printed on the invoice. Give inventory a real reorder pattern, including the deposits a new owner may be asked for while supplier trust is rebuilt.

The arithmetic is unforgiving. If customers pay in sixty days, the business funds roughly two months of wages, rent and materials before the first post-closing dollar arrives, entirely from opening cash and the line of credit. Growth makes this heavier, not lighter, because every additional month of sales creates another month of receivables to carry. This is why profitable acquisitions still run out of cash, and why the working capital schedule deserves the same attention as the revenue build.

Then find the lowest point the cash line touches in the first year, because that trough, not the annual total, is what sizes your operating line and your cash reserve. A buyer who arranges the line of credit after discovering the trough in month four pays for the lesson twice: once in stress and once in pricing.

If the business is seasonal, run the model so the closing date lands in the right part of the cycle. Closing just before the slow season means carrying the trough on day-one cash; closing into the busy season lets the business fund its own first months. Few levers in the whole deal are as cheap to pull as the calendar.

Stress it, then keep it alive after closing

A forecast is finished when it has been broken on purpose and survived. Rerun it with revenue down a tenth, with collections a few weeks slower, with the transition from the seller taking a year, with the largest customer gone. What you are looking for is simple: does the cash line stay above zero and does coverage stay above the covenant in the versions of the future that commonly happen. These are the facts that swing the forecast hardest, so they deserve the stress:

• Opening working capital. Whether the deal delivered receivables and inventory or left you funding both.
• Revenue retention through transition. The single assumption most likely to be wrong, in either direction.
• Gross margin under your cost structure. New rent, market wages and your supplier pricing rather than the seller pricing.
• Collection days. Taken from the aging report, not the contract terms.
• Amortization and rate on the debt stack. The one lever that changes every month of the model at once.
• Your own draw. The number buyers shrink to make the model work, and the first assumption to fail in real life.

Two habits keep the finished model useful. First, measure covenant headroom rather than just the covenant: knowing how much bad news a year can absorb before the coverage test fails is worth more than knowing you currently pass. Second, when cash gets genuinely tight, drop from the monthly model to a rolling 13-week cash forecast, which trades elegance for the only thing that matters in a crunch, the date and size of every payment. Owners who switch early rarely face the conversation owners who switch late are forced into.

Then keep the model alive. After closing, your lender reporting will compare actual statements against these projections, and the variance conversation goes far better when you have been running it monthly yourself. The forecast becomes the budget, the budget becomes the covenant math, and the covenant math is what your banking relationship rests on. How the whole financing stack gets assembled around these numbers is its own decision, covered in how to finance a business acquisition.

We build these models for buyers as an Ontario CPA firm that prepares business financing packages and projections lenders actually rely on, and for owners who want the model maintained after closing, that is exactly what our Fractional CFO work is. A free 15-minute discovery call is the starting point.