Model an acquisition from start to finish—target financials, debt structure, earnouts, combined projections, covenant testing, and equity returns. Supports single deals and multi-deal evaluation configs.
From the main navigation, select M&A. You'll work through the tabs roughly in order:
| Tab | Purpose |
|---|---|
Deal Manager | Create and manage deals |
Deal Setup | Configure deal terms, earnout, seller notes |
Target Financials | Enter the target company's financial data |
Financing | Structure acquisition debt |
Sources & Uses | Verify the close-day cash waterfall balances |
Earnout Config | Detailed earnout schedule |
Deal Summary | The results—projections, covenants, valuation |
Covenant & Valuation | Configure covenant step-downs and exit multiples |
Scenarios | Create performance scenarios (Base/Upside/Downside) |
Business Profile | Combined entity revenue mix analysis |
Deal ID (short identifier, e.g., "meridian") and Deal Name.Debt Structure: Unitranche (single blended loan, simpler) or Traditional (senior term loan + sub debt + revolver, potentially cheaper blended rate).The system automatically seeds 7 years of target financial placeholders (2 historical + close year + 4 projection years), default debt instruments based on your structure choice, and a Base Case scenario.
Close date matters. A mid-year close (e.g., July) means the target only contributes 6 months of revenue and EBITDA in the close year. The system prorates everything automatically, but covenant metrics for a partial year are annualized—so a strong 6-month result may look different when annualized.
On the Deal Setup tab:
| Field | What to Enter |
|---|---|
Purchase Price | Total cash to seller at close |
Transaction Expenses | Legal, advisory, diligence costs (typically 2–3% of deal value) |
TTM EBITDA Override | If the seller provides trailing 12-month EBITDA, enter here—used for transaction multiples |
Tax Rate | Combined federal/state rate as a decimal (e.g., 0.25 = 25%) |
| Field | What It Means |
|---|---|
Existing Seller Note (Assumed) | Debt from the target that you're assuming at close |
New Seller Note | Financing provided by the seller as part of the deal |
Target Equity Rollover | Target shareholders reinvest this amount in the combined entity (reduces cash needed at close) |
If the deal includes an earnout, enter the total earnout pool and define up to 5 measurement periods. For each period:
| Field | What It Means |
|---|---|
Measurement Year | The fiscal year when target GP is measured |
Payment Year | When the earnout is actually paid (typically ~7 months after the measurement year ends) |
Base Amount | Maximum earnout available for this period |
GP Threshold | Minimum gross profit before any earnout is earned (the floor) |
GP Target | GP at which 100% of the base is earned (the goal) |
Carryover % | Percentage of unearned earnout that rolls to the next period (e.g., 75%) |
How the earnout calculates:
If Target GP < Threshold: Payment = $0
If Target GP ≥ Target: Payment = Base Amount (100%)
If in between: Payment = Base × (GP − Threshold) / (Target − Threshold)
Example: $1M base, $8M threshold, $10M target
Target GP = $7M → $0 (below threshold)
Target GP = $9M → $1M × ($9M−$8M) / ($10M−$8M) = $500K (50%)
Target GP = $10M → $1M (100%)
Carryover preserves deal dynamics. If only 50% is earned in Period 1 and carryover is 75%, then 75% of the unearned $500K ($375K) rolls to Period 2's available base—a rough Year 1 doesn't kill the entire earnout.
On the Target Financials tab, enter 7 years of data:
| Row | Input? | What to Enter |
|---|---|---|
| Revenue | Yes | Annual revenue in dollars |
| Gross Margin % | Yes | As a decimal (0.35 = 35%) |
| Indirect Expenses | Yes | Operating costs not in COGS (SG&A, R&D, etc.) |
| Adjustments | Yes | EBITDA add-backs (non-recurring items, owner salary normalization) |
| Depreciation | Yes | Annual D&A |
| Gross Profit / EBITDA / Adj. EBITDA | Auto | Calculated from your inputs |
Use audited financials or quality of earnings numbers for historical years. For projection years, use management projections adjusted for your diligence findings.
Common add-backs include owner compensation above market, one-time legal costs, non-recurring project losses, and above-market rent in a related-party lease arrangement. Only add back items that genuinely won't recur under your ownership.
On the Financing tab, configure the debt instruments that fund the acquisition. The tab first shows your existing debt at close (read-only)—the acquisition lender must provide enough to retire this AND fund the purchase price.
| Field | What to Enter |
|---|---|
Type | Unitranche, Senior, Sub Debt, Revolver, or Seller Note |
Principal | Loan amount (disabled if marked as Plug) |
Interest Rate | Annual cash interest rate (e.g., 0.085 = 8.5%) |
PIK Rate | Payment-in-kind rate for sub debt (accrues to balance, no cash required) |
Term | Amortization period in years |
Facility Cap | Revolver only: maximum borrowing limit |
For each instrument, enter a mandatory amortization schedule—the percentage of original principal required each year. Typical for GovCon acquisitions:
Year 1: 2% Year 2: 5% Year 3: 10% Year 4: 10% Year 5: 100% (balloon)
The Plug instrument: Mark exactly one instrument as the Plug. Its principal auto-sizes to make Sources = Uses. If your total uses are $25M and other sources total $18M, the plug is sized to $7M. This mirrors how real deals work.
Switch to Sources & Uses and click Recompute Sources & Uses.
Uses: Cash to Seller, Retire existing bank debt (always retired at close), Transaction Expenses, and any notes flagged for retirement.
Sources: Seller Notes, Target Equity Rollover, each debt instrument's principal, and the plug instrument (auto-sized).
The system confirms Sources = Uses with a green checkmark. Below the waterfall, transaction multiples are shown:
| Multiple | Calculation |
|---|---|
| Cash Multiple | Purchase Price / Target Adj. EBITDA |
| Total Proceeds Multiple | (Purchase Price + Max Earnout) / Target Adj. EBITDA |
GovCon cash multiples typically range 4–8x depending on size, growth, and contract quality. If your multiple is above 7x, scrutinize the target's growth projections carefully.
The Deal Summary tab is the results dashboard—where all the modeling comes together.
| Metric | What It Tells You |
|---|---|
| Combined EBITDA | Your EBITDA + target EBITDA (prorated for partial close year) |
| Sr Bank Leverage | Senior bank debt / Combined EBITDA—the metric your lender watches most |
| FCCR | (EBITDA − Taxes) / Fixed Charges—can you service all obligations? |
| Total Debt | Everything: term loans + revolver + sub debt + seller notes |
| Equity Value | Enterprise value minus all debt |
The most important table for understanding deal viability:
Combined Adj. EBITDA $12,500K
Less: Cash Interest ($2,100K)
Less: Taxes ($1,800K)
Less: CapEx ($250K)
Less: NWC Change ($150K)
──────────────────────────────────────
FCF BEFORE DEBT SERVICE $8,200K ← Can you pay your debts?
Less: Mandatory Amortization ($1,500K)
Less: Earnout Payment ($750K)
──────────────────────────────────────
FCF AFTER DEBT SERVICE $5,950K ← What's left for the equity
If FCF After Debt Service is negative, the model automatically draws on the revolver to survive. Persistent revolver draws year-over-year are a red flag—the deal isn't generating enough cash.
Year-by-year covenant testing for Senior Bank Leverage and FCCR. The leverage arc tells the story: in a healthy deal, leverage starts high (4–5x at close) and drops steadily. By Year 5 it should be 2–3x. If leverage stays flat or increases, the target isn't growing as expected.
Combined Adj. EBITDA (Year 5) $18,500K
× Exit Multiple 7.0x
= Enterprise Value $129,500K
Less: All Debt ($18,700K)
────────────────────────────────────────────
Equity Value $110,800K
Cash MOIC: 3.2x (Equity Value / Purchase Price)
Total MOIC: 2.8x (Equity Value / (Purchase Price + Earnout))
GovCon PE targets typically look for 2.5–3.5x Cash MOIC over 5 years. Cash MOIC is the primary return metric—how many times you get your cash investment back.
On the Covenant & Valuation tab, set per-year covenant thresholds:
| Field | Typical Pattern | What It Means |
|---|---|---|
| Max Leverage | 5.5x → 5.0x → 4.5x → 4.0x | Gets tighter over time as synergies are realized |
| Min FCCR | 1.10x → 1.15x → 1.20x | Coverage requirement increases as integration stabilizes |
| Exit Multiple | 5.0x → 6.0x → 7.0x → 8.0x | Higher multiples at higher scale |
On the Scenarios tab, create performance variants:
| Scenario | Example Inputs | What It Models |
|---|---|---|
| Upside | Target Revenue +10%, Target Margin +200 bps, Earnout 100% | Target outperforms; cross-sell lifts acquirer |
| Downside / Credit Case | Target Revenue −10%, Target Margin −150 bps, Earnout 0% | Target loses key contract; integration drag; misses earnout |
The credit case is what your lender cares about most. If the deal services its debt and passes covenants in the downside scenario, it's financeable. If the downside breaks covenants, the lender will require more equity, tighter terms, or a lower purchase price.
If you're evaluating multiple acquisitions simultaneously, create an Evaluation Config: select 2+ deals, set a synchronized close date, configure combined debt instruments, and set combined covenant thresholds.
| Aspect | Single Deal | Multi-Deal (Eval Config) |
|---|---|---|
| Financing | Per-deal instruments | Shared instruments across all deals |
| Covenants | Per-deal thresholds | Unified thresholds for combined entity |
| Scenarios | Per-deal adjustments | Each deal picks its own scenario independently |
| Revenue | Acquirer + 1 target | Acquirer + all targets combined |
The evaluation config is a lens, not a mutation. It doesn't change any individual deal's data. It creates a combined projection view that shows what happens if you do all selected deals together.
You can mix scenarios across deals—Meridian on Upside and Axiom on Credit Case—to answer: "If Meridian outperforms but Axiom underperforms, do we still pass covenants?" Quick presets let you run All Base, All Upside, or All Downside with one click.
Leverage = Total Funded Debt / Adj. EBITDA
In GovCon, 4–6x is typical for platform acquisitions; 3–4x for tuck-ins. The leverage arc should decline from ~5x at close to ~2.5x by Year 5 through debt amortization and EBITDA growth.
FCCR = (EBITDA − Taxes) / (Interest + Mandatory Amort + Earnout + CapEx)
For every dollar of fixed obligations, how many dollars of cash flow do you generate? 1.2x minimum is standard—below that, you can't reliably service your debt.
Payment-in-kind interest accrues and adds to the loan balance instead of requiring cash payment. This preserves cash flow in early years, but the balance grows. At maturity, you owe more than you borrowed.
The Operator's View
My boss once told me that M&A deals get done when both the buyer and the seller are equally unhappy. If either side is significantly more unhappy than the other, one of two things happened: the deal blew up, or someone got screwed. That framing has stuck with me through every transaction I’ve been involved in since.
Every M&A deal has a qualitative and a quantitative dimension. The quantitative side is the model—purchase price, structure, debt capacity, returns. The qualitative side is everything else: the capabilities, the customers, the culture, the strategic rationale. The goal is to get enough comfort with the numbers that you can let the qualitative upside actually breathe. Because getting a deal done is grueling. There will be days and hours that test your conviction. You need the strategic logic to carry you through when the process tries to grind you down.
A few things I’ve learned the hard way:
Always model three cases—credit, base, and upside. Then haircut the credit case harder than feels reasonable, and do the same with base. It will feel egregious. Do it anyway. I’ve closed deals that were ultimately very successful where years one and two were defined by completely unforeseen external events. Give the deal breathing room. Getting into a cash bind in year one and having to cut costs, reduce indirects, and salvage what’s left is how you torpedo what could have been a transformational outcome.
Structure earnouts around what genuinely worries you. An earnout tied to something arbitrary or indefensible is an easy way to kill a deal—and it should be, because you’ll never be able to explain it with a straight face. The easiest conversations are the truthful ones. If there’s a real risk, you’ll be able to articulate exactly why you structured the deal the way you did. If you can’t, that’s a signal the structure is wrong.
Common Questions