Investment Banking & M&A Structuring
M&A Contingent Earnout Sliding-Scale vs Cliff Formula
Calculate Linear Sliding-Scale Earnout Payout E_max * MIN(1, MAX(0, (R_act - R_min) / (R_max - R_min))), Binary All-or-Nothing Cliff Payout, Present-Value Total Consideration, and Marginal Revenue Slope.
Eliminate post-merger cliff litigation and audit marginal earnout moral hazard!
Bridging a valuation gap between buyer and seller with a Binary All-or-Nothing Earnout Cliff (paying E_max if Year-1 Revenue R_act >= R_max, else $0) invites post-close channel-stuffing and litigation when R_act lands $100k shy of R_max! Replacing the cliff with a Linear Sliding-Scale Earnout Band [R_min, R_max] pays Payout_Slide = E_max * MIN(1, MAX(0, (R_act - R_min) / (R_max - R_min))). Yet dealmakers must also inspect the Marginal Earnout Slope inside the band, Slope = E_max / (R_max - R_min): whenever Slope exceeds the target’s Gross Margin %, a seller retaining operational control has an incentive to buy unprofitable revenue ($1.00 of negative-margin sales to trigger $1.50 of earnout!) unless paired with a minimum gross-margin or EBITDA floor!
Verify on Upfront_Cash C_up = $80.00M (B2), Max_Earnout E_max = $30.00M (B3), Earnout_Floor R_min = $50.00M (B4), Earnout_Stretch_Cap R_max = $70.00M (B5), Actual_Year1_Revenue R_act = $62.00M (B6), and Seller_Discount_Rate r_disc = 0.10 (10.0%, B7): (1) Sliding-Scale Payout is 30.00 * ((62 - 50) / (70 - 50)) = 30.00 * 0.60 = $18.00M (vs $0.00M under a Binary Cliff at $70M!); (2) Present-Value Total Deal Consideration is 80.00 + 18.00 / 1.10 = $96.36M; and (3) Marginal Earnout Slope inside [$50M, $70M] is 30 / 20 = 1.5000 ($1.50 earnout per $1.00 revenue)! Test R_act = $45M (< $50M floor -> $0.00M) and R_act = $75M (> $70M cap -> capped at $30.00M)!
| M&A Earnout Metric ($80M Upfront + $30M Earnout on [$50M, $70M], R_act=$62M) | Formula | Verified Output |
|---|---|---|
| Sliding-Scale Earnout Payout ($M) | E_max * MIN(1, MAX(0, (R_act - R_min)/(R_max - R_min))) | $18.00M (60.0% Achievement) |
| Binary Cliff Payout @ R_max ($M) | IF(R_act >= R_max, E_max, 0) | $0.00M (-$18.00M Cliff Drop) |
| PV Total Deal Consideration ($M) | C_up + Payout_Slide / (1 + r_disc) | $96.36M (@ 10% Discount) |
| Marginal Revenue Earnout Slope | E_max / (R_max - R_min) | 1.5000x ($1.50 per $1 Rev) |
Clamped Linear Sliding-Scale Earnout Payout Formula
Validate C_up >= 0, E_max > 0, 0 <= R_min < R_max, R_act >= 0, and r_disc > -1!
=LET(c_up, B2, e_mx, B3, r_mn, B4, r_mx, B5, r_ac, B6, rt_d, B7, IF(OR(c_up < 0, e_mx <= 0, r_mn < 0, r_mx <= r_mn, r_ac < 0, rt_d <= -1), "Invalid Earnout Terms", ROUND(e_mx * MIN(1, MAX(0, (r_ac - r_mn) / (r_mx - r_mn))), 2)))Discounted Total Consideration & Marginal Slope Audit Formula
Use unrounded sliding-scale payout inside C_up + Payout / (1 + r_disc) to evaluate Year-0 deal value accurately!
=IF(ISTEXT(E2), E2, ROUND(B2 + (B3 * MIN(1, MAX(0, (B6 - B4) / (B5 - B4)))) / (1 + B7), 2))Try the example
Use the original values or change them to test your understanding.