Back to ResearchValuation

How to Build an Acquisition Model: DCF, Returns Analysis, and the Numbers That Actually Matter

Mayfaire Row Research Division·

Mayfaire Row Research Division

MOIC Sensitivity: Impact of 1-Unit Change in Each Assumption (Illustrative $5M Deal)

Illustrative sensitivity analysis for a $5M enterprise value acquisition. Exit multiple is the single highest-leverage assumption in ETA returns — more so than revenue growth or entry price.

Source: Mayfaire Row Research Division analysis. For informational purposes only.

Every ETA acquisition needs a financial model that is good enough to make real decisions — not a marketing document that supports a predetermined conclusion. The best models are simple enough to update in 20 minutes when a new assumption changes, and specific enough to catch the risks that kill deals. Here is how to build one and which outputs actually matter.

The Architecture of an ETA Acquisition Model

A decision-quality ETA model has four linked modules. First, the income statement: three years of historical financials, a QoE-adjusted trailing twelve months (TTM) as your base, and a three-to-five year operating forecast. Second, the debt schedule: all sources of acquisition debt (SBA loan, seller note, mezzanine if applicable) with amortization, interest rates, and standby periods modeled explicitly. Third, the DSCR check: annual cash available for debt service divided by total debt service, confirming the deal clears the 1.25x minimum at your conservative case — not just the base case. Fourth, the returns waterfall: equity invested, exit proceeds, and the distribution to each stakeholder class.

Building the Operating Forecast

The operating forecast starts with revenue. For most ETA businesses, revenue should be projected using one of three approaches: contract-based (sum of existing contracts, contracted renewal, and new business assumptions), customer cohort-based (track retention and expansion rates by customer vintage), or trend-based (apply a defensible growth rate to historical revenue). Do not assume the business will suddenly grow faster than its historical rate without a specific, documented driver (a new product, a geographic expansion, a pricing change).

EBITDA margin should be modeled as a function of the cost structure, not as a percentage pulled from the ceiling. Build a cost structure from first principles: cost of goods sold, labor (salary and benefits, including your replacement salary), rent and facilities, insurance, technology, marketing, and a management overhead reserve. Separately model maintenance capex (the annual spend required to keep existing equipment and systems operational). The difference between EBITDA and free cash flow is capex and changes in working capital — both of which matter enormously for DSCR and for your ability to pay yourself.

The Assumptions That Drive Returns Most

Sensitivity analysis on a typical $5M enterprise value deal shows the following MOIC sensitivity to a one-unit change in each key variable: exit multiple has the highest leverage (a 0.5x improvement in exit multiple adds approximately 1.1x to MOIC), followed by entry multiple (0.5x reduction in entry multiple adds 0.8x MOIC), EBITDA margin (one percentage point improvement adds 0.6x), revenue growth (one percentage point adds 0.4x), and leverage (one additional turn of debt/EBITDA adds 0.5x). The clear implication: your exit multiple assumption is more consequential than any operational assumption in the model.

This is not an invitation to assume a high exit multiple. It is a reminder to be rigorous about what exit multiple is realistic, what drives it (revenue growth, EBITDA margin improvement, business quality), and what risks could compress it (market deterioration, single customer loss, rising interest rates).

Modeling the Debt Schedule

Model every tranche of debt explicitly. Your SBA 7(a) loan: current 25-year term for real estate purchases, 10-year term for business-only acquisitions, fully amortizing, at a rate tied to prime or SOFR plus a spread (typically prime + 2.75–3.00% for most borrowers). Your seller note: principal amount, rate (typically 5–8%), term, standby period (24 months if SBA requires it), then amortization through maturity.

Build a monthly debt schedule for at least the first three years — SBA lenders will ask for it, and it will reveal cash flow problems that an annual model obscures. Many ETA businesses have seasonal revenue patterns that create months where debt service exceeds cash flow even when the annual DSCR is adequate. Monthly modeling catches these and lets you plan for them with a revolving credit facility or cash reserve.

The Returns Waterfall

Model equity returns explicitly for each stakeholder class. In a traditional search fund: investor preferred equity (with the 1.5x–2.0x preferred return and the share of carry), searcher promoted equity (25%), and any management equity pool. Show the total enterprise value at exit, deduct net debt at exit, allocate proceeds through the waterfall in priority order, and show each class's MOIC and IRR.

For self-funded deals, the waterfall is simpler — but model it. Show your equity invested, the exit proceeds attributable to your stake, and the time-weighted IRR. Then stress-test it: what happens to your IRR if the exit multiple is 0.5x lower than projected? What if revenue is flat for three years before the exit? A model that only shows the base case is a sales document. A model that shows the base, downside, and upside cases is an investment framework.

What Investors Actually Look At

ETA investors read models quickly and look for three things first. Can the business service its debt? The DSCR calculation is the first thing every investor checks. Is the exit assumption reasonable? If you are using a 6x exit multiple on a business that comps trade at 4x, you have lost credibility before the conversation starts. And is the model internally consistent? Revenue growth that implies operational leverage not supported by the cost structure, or margins that improve without a documented driver, signal a model built to support a conclusion rather than inform a decision.

Mayfaire Row Research Division

The Mayfaire Row Research Division produces institutional-grade analysis on ETA, search fund investing, small business acquisition, and the markets self-funded searchers operate in. Our research draws on direct deal experience, financial modeling, and SQL analytics across hundreds of evaluated transactions.

We back searchers who do the work.

Submit your deal and find out what it looks like to have a full-cycle partner on your cap table. We respond within 5 business days.