Earnout Model in Excel: M&A Contingent Consideration (2026)

July 26, 2026 · VeloraAI Team
Financial Modeling Formulas Excel

Roughly 28% of earnouts end in a dispute or litigation, and the 2026 SRS Acquiom Deal Terms Study puts the median non-life-sciences earnout period at just 24 months — down from over 36 months a decade ago. The reason both numbers exist is the same: earnouts are the most negotiated, most ambiguous, and most mismodeled component of a modern M&A deal. An earnout model in Excel that only calculates the payout but skips the tiered thresholds, the ASC 805 remeasurement, and the probability-weighted valuation is exactly the model that turns a bridged valuation gap into a courtroom.

This is the 2026 playbook for building one that survives. You'll get the payout formulas that handle cliffs, sliders, and catch-ups; the balance-sheet accounting that keeps your merger model tied out; and a Monte Carlo layer that gives corporate development teams a defensible fair value for the contingent consideration liability at close.

What Is an Earnout in an M&A Deal?

An earnout is a contingent payment made by the buyer to the seller after closing, triggered when the acquired business hits pre-agreed performance targets over a defined period. Legally and under US GAAP, it is called contingent consideration and it sits on the buyer's balance sheet as a liability (or occasionally equity) from day one — remeasured to fair value every reporting period until it settles.

Earnouts bridge a valuation gap. When the seller believes the business will grow 40% next year and the buyer underwrites 15%, the two sides split the difference: fixed cash at close for the buyer's case, plus an earnout that pays out only if the seller's case materializes. It shifts risk from the buyer's checkbook to the seller's operating execution.

Why earnouts are back in 2026

The 2024–2026 M&A environment has been rough on valuations. Public multiples compressed, private valuations lagged, and sellers who anchored on 2021 comps refused to accept 2026 clearing prices. Bankers responded with more composite deals — cash at close, rollover equity, seller notes, and larger contingent components. A well-structured earnout is often the only mechanism keeping a deal on the road.

ℹ️ Note: Under ASC 805, contingent consideration is measured at fair value on the acquisition date. Subsequent changes in fair value flow through the income statement (for liability-classified earnouts) — not through goodwill. This is the single biggest source of surprise EPS volatility in acquisitive companies.

How Do You Structure an Earnout?

The seven levers every earnout agreement pulls are: total headline price, cash at close, earnout ceiling, earnout period, performance metric, measurement methodology, and the payout formula itself. A clean earnout model in Excel treats each of these as a named input so the deal team can flex terms in negotiation without breaking the schedule.

The most consequential lever is the metric. Get it wrong and you spend the earnout period arguing over accounting policy rather than integrating the business.

Metric Favors Manipulability Best for
Revenue Seller Hardest to manipulate High-growth, pre-profit targets
Gross profit Neutral Moderate Product businesses with stable margins
EBITDA Buyer Buyer controls opex post-close Mature, cash-generative targets
Net income Buyer Buyer controls tax, interest, D&A Rarely used — too many levers
Non-financial KPIs Depends Depends on measurability Regulatory approvals, product launches, customer retention

Sellers push for revenue because the buyer cannot suppress it by loading corporate overhead into the target's P&L. Buyers push for EBITDA because it forces the seller to keep running the business efficiently, not just buy market share. Gross profit is the compromise that shows up in roughly a third of middle-market deals.

graph TD
    A[Valuation Gap Identified] --> B{Gap Size vs Headline}
    B -->|"< 15%"| C[Fixed Price + Small Escrow]
    B -->|"15% – 40%"| D[Earnout Recommended]
    B -->|"> 40%"| E[Rethink Deal / Rollover Equity]
    D --> F{Target Growth Profile}
    F -->|High Growth Pre-Profit| G[Revenue Earnout - 24 to 36 months]
    F -->|Mature Cash Generative| H[EBITDA Earnout - 12 to 24 months]
    F -->|Regulatory / Milestone| I[Non-Financial Trigger]
    G --> J[Tiered Payout with Catch-Up]
    H --> K[Cliff or Sliding Scale]
    I --> L[Binary Payment on Trigger]

Building the Earnout Payout Formula in Excel

Every earnout payout formula is a variation of the same shape: compare actual performance to a threshold, apply a payout rate, and cap the result at a ceiling. The three archetypes are the cliff, the sliding scale, and the tiered payout with catch-up.

Cliff earnout (binary)

The simplest structure. Hit the target, get the full payout. Miss it by a dollar, get nothing.

=IF(Actual_EBITDA >= Target_EBITDA, Max_Earnout, 0)

Cliffs are cheap to draft but expensive to litigate — a single dollar of shortfall wipes out the entire payment, which is exactly the setup that drives disputes over accounting adjustments.

Sliding scale earnout (linear)

Payout scales linearly between a floor and a ceiling. This is the workhorse structure in middle-market deals.

=MIN(Max_Earnout, MAX(0, (Actual - Floor) / (Ceiling - Floor) * Max_Earnout))

If floor EBITDA is $8M, ceiling is $12M, and max earnout is $10M, then actual EBITDA of $10M pays 50% × $10M = $5M. The MIN/MAX wrap enforces the ceiling and floor without extra IF logic.

Tiered earnout with catch-up

Real deals stack tiers. Below Tier 1 pays nothing. Between Tier 1 and Tier 2 pays a percentage. Above Tier 2, the seller catches up to a headline number and may receive a super-earnout above stretch.

=IFS(
    Actual < Tier1_Floor, 0,
    Actual < Tier2_Target, (Actual - Tier1_Floor) / (Tier2_Target - Tier1_Floor) * Tier2_Payout,
    Actual < Tier3_Stretch, Tier2_Payout + (Actual - Tier2_Target) / (Tier3_Stretch - Tier2_Target) * (Tier3_Payout - Tier2_Payout),
    TRUE, Tier3_Payout
)

Wrap the whole IFS in a LET to name each tier for readability. Every argument the negotiators haggled over becomes a labeled variable, and the formula reads like the term sheet.

=LET(
    a, Actual_EBITDA,
    f, Tier1_Floor,
    t, Tier2_Target,
    s, Tier3_Stretch,
    p2, Tier2_Payout,
    p3, Tier3_Payout,
    IFS(
        a < f, 0,
        a < t, (a - f) / (t - f) * p2,
        a < s, p2 + (a - t) / (s - t) * (p3 - p2),
        TRUE, p3
    )
)

💡 Pro Tip: Build the earnout schedule with named inputs (Tier1_Floor, Tier2_Target, etc.) rather than hard-coded numbers. When the LOI changes at 11pm the night before signing — and it will — you flex one input, not fifty cell references.

How Do You Value an Earnout for ASC 805?

Contingent consideration is measured at fair value on the acquisition date and remeasured every reporting period. For simple cliff earnouts with independent triggers, a probability-weighted expected value is acceptable. For anything with tiers, correlated metrics, or path dependency, Monte Carlo simulation is the defensible standard used by valuation firms and Big Four audit teams.

The core insight: an earnout is a contingent claim on the target's future performance. It behaves like an option, and valuing it with a single point estimate systematically understates the liability when payoffs are non-linear.

Deterministic (probability-weighted) valuation

Build a scenario matrix, assign probabilities, calculate the payout in each case, and take the expected value discounted to today.

Scenario Probability Year 2 EBITDA Payout ($M) Weighted
Downside 25% $6.0M $0.0 $0.0
Base 40% $9.0M $2.5 $1.0
Upside 25% $11.5M $8.75 $2.19
Blue sky 10% $14.0M $10.0 $1.0
Expected value $4.19M

Discount that expected value back to the acquisition date using a risk-adjusted rate. Under ASC 820, the appropriate rate reflects both counterparty credit risk (the buyer's cost of debt) and any additional performance risk not captured in the scenario probabilities.

=SUMPRODUCT(Probability_Range, Payout_Range) / (1 + Discount_Rate)^Years_To_Payment

Monte Carlo simulation for tiered earnouts

When the payout formula has kinks — tiers, caps, catch-ups — the expected value of the function is not equal to the function of the expected value. You need to simulate the underlying metric thousands of times and average the payouts across draws.

The Excel setup:

  1. Model the growth rate of the underlying metric (EBITDA, revenue) as a random draw from a distribution — typically log-normal with mean and volatility calibrated to industry peers.
  2. Apply the earnout payout formula to each simulated ending value.
  3. Discount each simulated payout to the acquisition date.
  4. Average across all trials to get the fair value at close.
' Excel 365 dynamic array version, 10,000 trials
=LET(
    n, 10000,
    mu, 0.12,       ' expected growth rate
    sigma, 0.25,    ' volatility
    T, 2,           ' years to measurement
    r, 0.06,        ' discount rate
    e0, 8000000,    ' current EBITDA
    z, NORM.S.INV(RANDARRAY(n)),
    eT, e0 * EXP((mu - 0.5*sigma^2)*T + sigma*SQRT(T)*z),
    payout, MAP(eT, LAMBDA(x, MAX(0, MIN(10000000, (x - 8000000) / 4000000 * 10000000)))),
    AVERAGE(payout) / (1 + r)^T
)

Rerun with F9 to see the standard error tighten as you scale trials from 1,000 to 10,000 to 100,000. Above ~10,000 trials the point estimate is stable to within a few tenths of a percent.

⚠️ Warning: Never use RAND() inside a live financial model without freezing the seed or copying values. Every workbook recalc reshuffles your 10,000 draws, and the fair value at close moves by 1–3% each time. Auditors and buy-side committees will flag this in minutes.

graph LR
    A[Acquisition Date] --> B[Estimate Volatility from Peers]
    B --> C[Simulate 10,000 EBITDA Paths]
    C --> D[Apply Payout Formula to Each Path]
    D --> E[Discount Each Payout]
    E --> F[Average = Day 1 Fair Value]
    F --> G[Record CC Liability on B/S]
    G --> H[Remeasure Each Quarter]
    H --> I[Delta Flows to P&L]

Modeling the Contingent Consideration Liability on the Balance Sheet

The Day 1 fair value from your Monte Carlo becomes the opening Contingent Consideration liability. From there, three mechanical entries drive the schedule:

  1. Accretion of the discount. Because the liability was recorded at present value, it accretes back up to face over time as the payment date approaches. Interest expense hits the P&L each period equal to beginning liability × discount rate.
  2. Remeasurement. Every quarter, re-run the fair-value estimate with updated expectations. The change flows through P&L (usually in "Change in Fair Value of Contingent Consideration," an operating line item — check your client's policy).
  3. Settlement. When the earnout period ends, the final payout is calculated per the agreement. Any difference between the accrued liability and the actual payment hits the P&L as a final gain or loss.

The remeasurement roll-forward

Beginning Liability            $4,190,000
(+) Accretion of Discount        $251,400   -> Interest Expense
(+/-) Change in Fair Value      ($780,000)  -> Operating Income (gain)
(-) Cash Paid                          $0
Ending Liability               $3,661,400

Example: In Q3, target EBITDA guidance is lowered from $9.0M to $8.4M for the measurement year. Rerunning the Monte Carlo with the new mean drops the fair value from $4.19M to $3.41M. That $780K reduction is a Q3 P&L gain — one of the reasons acquisitive companies show volatile "core" earnings and why some analysts back out these mark-to-market swings when calculating adjusted EPS.

Integrating the Earnout Into the Merger Model

An earnout changes three things in your merger accretion/dilution model that a naive template will miss:

  • Sources & uses. The purchase price is Cash at Close + Day-1 fair value of CC, not the headline price. Goodwill is calculated on total consideration.
  • Interest expense. Accretion of the CC discount is interest expense that reduces EPS — model it separately from acquisition debt interest.
  • Non-GAAP adjustments. Most buyers strip the change in fair value out of adjusted EPS. Show both GAAP and adjusted paths so the deal team can present either.

Accretion/dilution impact

For a public acquirer, an earnout is generally more accretive than paying the full headline price in cash on Day 1, because the fair value is discounted and the payout is contingent. But a large earnout can still be dilutive if:

  • The target underperforms mildly and the seller earns a partial payout that was not fully accrued.
  • Accretion expense on a large CC liability outpaces incremental earnings from the target.
  • Post-close remeasurement gains reverse the flattering initial fair-value discount.

Model both the expected case and a sensitivity around the earnout probability distribution. A DATA TABLE across two axes (Year 1 EBITDA growth × terminal margin) gives the deal team the picture the audit committee will ask for.

Common Earnout Modeling Mistakes

Five errors show up in almost every draft merger model that hits my desk:

  1. Point-estimate valuation of a tiered payout. Using the "base case" EBITDA times the base-case payout rate underprices the CC liability by 20–40% because it ignores the convexity introduced by the tier structure.
  2. Excluding the earnout from headline goodwill. Goodwill is calculated on total consideration transferred, including Day-1 fair value of CC. A missing CC entry inflates the bargain purchase test.
  3. Recording remeasurement in equity instead of P&L. Only equity-classified contingent consideration (rare — typically stock-settled with a fixed share count) skips the income statement. Cash-settled or share-settled variable earnouts run through P&L. Every quarter. Forever.
  4. Ignoring post-close operating restrictions. The purchase agreement usually includes covenants preventing the buyer from starving the target of resources. A model that assumes cost-cutting synergies inside the earnout period may violate the agreement and trigger a claim.
  5. Missing the tax deductibility timing. Earnout payments are typically deductible when paid, not when accrued. The book-tax difference creates a deferred tax asset at acquisition that unwinds as the earnout is paid — easy to miss on the closing balance sheet.

⚠️ Warning: If the seller is retained as an employee and the earnout is contingent on continued employment, the payment may be compensation expense rather than contingent consideration — hitting the P&L over the service period rather than goodwill on Day 1. The distinction is worth tens of millions in EBITDA reporting for large deals and is a top-five PCAOB comment area.

Case Study: A $250M Middle-Market Deal

Assume a strategic acquirer buys a specialty distribution business for a headline $250M:

  • $175M cash at close
  • $75M earnout ceiling, 24-month period, EBITDA-based
  • Tier structure: 50% payout at $18M EBITDA (Year 2), 100% at $22M, ratable in between
  • Current EBITDA: $15M, base-case growth: 15% p.a., peer-implied volatility: 22%

Running the Monte Carlo with 10,000 trials:

Output Value
Expected Year 2 EBITDA $19.8M
Point-estimate payout (base case) $67.5M
Monte Carlo mean payout $58.2M
Discounted fair value at close (6.5% rate) $51.4M
Total consideration for goodwill $226.4M
Prob. of zero payout 12%
Prob. of full $75M payout 34%

The Monte Carlo fair value is ~24% lower than the naive point estimate because 12% of paths pay nothing and 34% of paths hit the ceiling with EBITDA well above $22M — the upside is capped, but the downside is not. Recording the CC liability at the point estimate would overstate Day-1 goodwill by ~$16M and understate first-year P&L accretion by roughly the same amount over the earnout life.

Automating the Earnout Model with AI

Every step in this workflow — pulling peer volatilities, drafting tier formulas, generating the Monte Carlo, running remeasurement roll-forwards, and producing the disclosure schedule for the 10-Q — is a task modern AI Excel tools handle in minutes. VeloraAI was built for exactly this: prompt the add-in with "value this earnout using Monte Carlo with 10,000 trials and log-normal EBITDA," and it drops the working model directly into your sheet with named inputs and auditable formulas, so the analyst spends their time on negotiation terms rather than formula debugging.

Frequently Asked Questions

What is the difference between an earnout and contingent consideration?

They describe the same economic arrangement from two perspectives. "Earnout" is the commercial and legal term used in the purchase agreement — a future payment tied to performance. "Contingent consideration" is the accounting term under ASC 805 and IFRS 3 that governs how the buyer records and measures the liability on the balance sheet from acquisition through settlement.

How long should an M&A earnout period be?

The 2026 SRS Acquiom study puts the median non-life-sciences earnout at 24 months, with almost no deals exceeding four years. Life sciences deals with regulatory milestones commonly run five to seven years. Shorter periods reduce integration friction and the buyer's ability to influence outcomes, but they may not give enough time for the seller's growth thesis to prove out.

Is an earnout payment tax-deductible for the buyer?

Generally yes, but the timing depends on the structure. Most cash earnouts are treated as additional purchase price for tax purposes and are deductible when paid — creating a deferred tax asset at acquisition that unwinds as payments settle. Earnouts contingent on the seller's continued employment may be reclassified as compensation expense, which changes both the tax and book treatment. Always coordinate with tax counsel before closing.

What happens if the buyer manipulates results to avoid an earnout payment?

The purchase agreement typically includes operating covenants — obligations to run the business consistent with past practice, to fund working capital, and to avoid actions designed to suppress the earnout metric. Breach exposes the buyer to a claim for the full contingent amount plus damages. This is why roughly 28% of earnouts end in dispute: buyers integrate aggressively, sellers cry foul, and the covenant language decides who wins.

Should sellers use Monte Carlo to value their side of the earnout?

Yes — and preferably before signing. Sellers who accept a "headline $75M earnout" without simulating the payoff distribution routinely discover the true expected value is 30–50% lower. Running the same Monte Carlo your buyer's valuation firm will run gives you a defensible view of what the earnout is actually worth, which is the number that should be negotiated, not the ceiling.

Earnouts are the most negotiated line item in modern M&A because they carry the most information. A well-built earnout model in Excel forces both sides to be explicit about the growth assumptions, the risk, and the accounting consequences before any documents get signed — which is exactly why the strongest deal teams build the model before they finish the term sheet, not after.