Free Excel templates

A free earnout scenario calculator in Excel

Three periods on a straight line, all or nothing or tiers, a milestone, a cumulative catch-up and a global cap applied in payment date order, five weighted scenarios, the expected payment, the present value and the net cash to the sellers after an escrow retention.

A buyer pays $96,000,000 at closing and up to $24,000,000 more over three years if the business delivers. At closing, five scenarios weighted by their probabilities put the expected earnout at $13,890,030 and its present value at $11,786,551, against a maximum exposure of $24,000,000. The calculator rebuilds that view on one sheet, ready for your own terms.

Get the calculator

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

Earnout_Scenario_Calculator.xlsx (15 KB)

You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.

The book behind this calculator

This calculator is a simplified version of the companion workbook of The Earnout Handbook, which follows one earnout from the term sheet to the release of the escrow: the calculation schedule and its bridge, three statements, a dispute decided by an independent accountant, set-off and escrow, the founders' share as compensation, and the valuation remeasured each year.

Paperback PDF edition, $19.99

What is in the file

One sheet in six blocks. Inputs are blue; everything else is a formula, and the last block counts the checks that fail.

1. Terms of each period
For three periods: the metric, the shape (straight line, all or nothing, or tiers), threshold, target, maximum, three tier levels and the tranche, and whether the catch-up tops the period up.
2. Milestone, catch-up, cap, retention and rate
The milestone payment and its deadline, the cumulative threshold, target and maximum, the global cap, the escrow retention and the discount rate.
3. Scenarios
Up to five scenarios with their probability, the metric of each period, the period 3 level used in the catch-up, the milestone month and the payment days.
4. Payments by scenario
Each formula payment, then each payment after the cap, applied in payment date order, the total and the present value at closing.
5 and 6. Results and net cash
Expected payment, present value, maximum exposure, and for the scenario you choose, gross, retention and net cash to the sellers.

What the worked case returns

MeasureValue
Management base, total$22,541,818
Acquirer case, total$12,783,333
Low case, total$4,000,000
High case, total (cut by the cap)$24,000,000
Dispute case, total$11,383,333
Expected payment, five scenarios weighted$13,890,030
Present value at 9 percent$11,786,551
Maximum exposure$24,000,000
Acquirer case, period 1: gross / net of the 10 percent retention$4,053,333 / $3,648,000
Acquirer case, retention released at the end$1,278,333

How to use it on your own deal

  1. Read your own calculation schedule: the metric of each period, its shape, the catch-up and how the cap is applied.
  2. Enter the terms of each period, the milestone, the catch-up, the global cap, the retention and your discount rate.
  3. Write each scenario as a path of the metric, period by period, with a probability you can defend; the five must add up to 100 percent.
  4. Read the expected payment and the present value, then change one term at a time to see what it is worth before you negotiate it.

Questions people ask

What does the earnout calculator do?

It turns your earnout terms into payments: a straight line, all or nothing or tiers for each of three periods, a milestone, a cumulative catch-up and a global cap, run on up to five weighted scenarios, with the expected payment, the present value and the net cash after an escrow retention.

Does it apply the global cap in order?

Yes. The cap is applied to the running total in payment date order, as in the book's case, so the payment that falls last is the one reduced; a milestone paid before a period's payment day comes first.

How do I use it on my own deal?

Read your own calculation schedule first, then replace the blue inputs: the terms of each period, the milestone, the catch-up, the cap, the retention and the rate, then the metric of each period in each scenario and its probability.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbook of The Earnout Handbook goes further: the bridge from reported EBITDA, the dispute and its award, the escrow ledger, the founders' share, the roll-forward of the fair value and the acceleration projection.

See the book and its free files →

Related reading