Free Business Acquisition Financial Model Template

Buying a business is one of the largest financial decisions you will make, and the difference between a great acquisition and a money pit comes down to the quality of your financial model. This free acquisition financial model template walks you through every number you need to validate before signing a purchase agreement. It covers purchase economics, revenue projections, expense assumptions, cash flow forecasting, payback analysis, and scenario modeling — the same framework used by private equity firms and search funds to evaluate deals. Use the acquisition valuation calculator alongside this template to stress-test your purchase price against industry multiples.

The Purchase Economics section captures the full cost of acquiring the business, not just the headline price. Most buyers underestimate closing costs — legal fees, due diligence costs, broker commissions, and working capital adjustments typically add 5-15% on top of the purchase price. If the deal involves seller financing or an earnout, model the payment schedule carefully: seller-financed deals reduce upfront cash requirements but create monthly debt service obligations that directly reduce your post-acquisition cash flow. Include any required working capital deposits, inventory purchases, or security deposits that tie up cash on day one.

Revenue Projections require a clear-eyed assessment of what happens to the business after the current owner leaves. For most small businesses, 10-30% of revenue is at risk during an ownership transition due to customer relationships tied to the founder, key employee departures, and general market uncertainty. Build your base case with a conservative revenue retention assumption, not the seller's optimistic projection. Our guide on how to value a business explains how to discount revenue projections based on customer concentration, contract length, and switching costs.

The Expense Assumptions section is where most acquisition models go wrong. Sellers present financials with owner add-backs — personal expenses run through the business — that inflate apparent profitability. Your model needs to replace those add-backs with your actual planned costs: your salary, new hires you will need, tools you plan to add or remove, and any operational changes. Be honest about transition costs in the first 6-12 months including consulting fees to the previous owner, temporary overlap staffing, and system migration expenses. Use the profitability calculator to test how different expense scenarios affect your margins.

Cash Flow Projection is the heart of the model. Build a month-by-month forecast for at least 24 months post-close, starting with revenue minus expenses to get operating cash flow, then subtracting debt service (loan payments, seller financing), capital expenditures, and working capital changes. Pay attention to seasonality — many small businesses have significant revenue fluctuations that the annual P&L smooths over. A business that looks profitable on an annual basis can have three or four months where cash flow is negative, which requires reserves. The cash flow forecast calculator helps you model these monthly dynamics interactively.

Payback Analysis answers the fundamental question: how long until the acquisition pays for itself? Calculate the cumulative operating cash flow month by month until it equals the total purchase price (including closing costs and working capital). For a healthy small business acquisition, the payback period should be 3-5 years. Anything under 3 years suggests you are getting a bargain or your projections are too optimistic. Anything over 5 years means you are paying a premium that requires sustained growth to justify. Compare your payback period against the benchmarks in our buying a small business financial checklist.

Scenario Modeling protects you from the most dangerous mistake in acquisitions: building a model that only works if everything goes right. Create three scenarios — best case, expected case, and worst case — by varying revenue retention, growth rate, and expense assumptions. Your worst case should assume 20-30% revenue decline in year one, key employee departures, and unexpected capital expenditures. If the worst case still produces a payback period under 7 years and does not require additional capital injection, the deal has a reasonable margin of safety. If the worst case leads to running out of cash, you either need to renegotiate the price or walk away. Our financial due diligence checklist covers the specific items to verify before committing to any scenario.