A free co-investment follow-on and reserve model in Excel
One co-investment through a down round, followed on and not, under plain pro rata dilution and under a pay-to-play clause; then a ten-deal programme and the follow-on reserve that maximises its multiple.
A 10 million co-investment holds 2.5% of a company. A rescue round at a 200 pre-money asks 2.5 million to keep the stake. Under plain dilution, following on returns 2.33x on the marginal dollar; under pay-to-play, 5.00x, and not following on falls to 0.50x.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
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 model
This model goes with The Co-Investment Practitioner, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
7 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
The Inputs
Every figure in the file, in one place
The Round
The markdown, the pro rata, and why dilution is value-neutral on the day
Plain Dilution
One deal, followed and not followed, and the break-even that matters
Pay-to-Play
The same deal under a punitive clause
The Programme
Ten deals, no reserve, both document regimes
Sizing the Reserve
The expectation over the binomial, and the optimum
Checks
Every figure in the appendix, recomputed here
What the worked case returns
Measure
Value
Ownership at entry
2.50%
Ownership if you do not follow on
1.67%
Pro rata cheque (millions)
2.5
Plain dilution: multiple if you follow on
1.40x
Plain dilution: multiple if you do not
1.17x
Plain dilution: marginal multiple
2.33x
Plain dilution: break-even exit equity
600
Pay-to-play: multiple if you do not
0.50x
Pay-to-play: marginal multiple
5.00x
Pay-to-play: break-even exit equity
250
Programme multiple, no reserve, plain
1.67x
Programme multiple, no reserve, pay-to-play
1.40x
A pay-to-play clause makes every single follow-on look obvious while it costs a programme with no reserve -0.27 turns of multiple. The right reserve depends on the document, so the first diligence question is whether the shareholders' agreement has such a clause.
How to use it on your own case
Enter the cheque, entry equity value, round terms and exit assumptions on The Inputs.
Read the ownership and the value before and after the round on The Round.
Compare following on and not under plain dilution, then under pay-to-play.
Set the probability of a follow-on and the reserve policy, and read the optimum on Sizing the Reserve.
Questions people ask about it
What is a follow-on reserve?
Capital set aside to take up a co-investor's pro rata share of later rounds in the companies already in the portfolio.
Is dilution a loss in itself?
Not at a fairly priced round: a holder who does not follow on owns less of a larger company and holds the same value on the day. The loss came from the markdown before the round.
What does a pay-to-play clause change?
It penalises holders who do not take up their share, for example by cutting their units. Not following on then destroys value, so the reserve needed is larger.
Is this template 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 workbooks of The Co-Investment Practitioner go further: the full companion set, blank models and the worked cases of the book.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.