Articles

How much does one write-off cost a programme of nine co-investments?

A co-investment programme is a small number of deals, so a single failure is a large share of the whole. The multiple of the programme is arithmetic; the damage to the IRR depends on when the failure falls.

Nine co-investments of $10 million each cost $90 million. If every deal returns 2.2 times in five years, the programme returns 2.20x. If one deal is written off, the programme returns 176 on 90, or 1.96x, and the IRR falls from 17.1% to 14.4%. One loss removes 20.4% of the profit. The programme only falls below 1.0x with five write-offs out of nine.

A fund of funds that co-invests alongside its managers holds a handful of deals, not hundreds. That makes the contribution of a single loss easy to see, and easy to understate when each deal is quoted on its own multiple. This article computes the effect for the co-investment sleeve in the book, which has three deals a year from 2024 to 2026 and one write-off.

The assumptions

ItemValue
Size of each deal$10 million
Deals a year, 2024 to 20263
Gross exit multiple of performing deals2.2x
Holding period5 years
Failed deal (2025): mark after one year / final value50% / 0% of cost
The sleeve is gross of any fee or carry on the co-investments. Cash flows are annual, with calls in the year of investment and distributions five years later.

Step 1: the programme without a failure

Every deal is the same size, so the programme multiple is the deal multiple:

Programme multiple = distributions ÷ called capital. In Excel: =SUM(distributions)/SUM(calls).

9 deals × $10 million = $90 million called. At 2.2x, distributions are 90 × 2.2 = $198 million, a multiple of 2.20x and a profit of $108 million. Each deal’s IRR is 2.21/5 − 1 = 17.08%.

Step 2: the programme with one write-off

One of the three 2025 deals fails. Its $10 million is called and nothing comes back, so only eight deals distribute:

8 × $10 million × 2.2 = $176 million, against $90 million called. The programme multiple is 176 ÷ 90 = 1.96x, and the profit is $86 million, down 20.4% from $108 million. The multiple falls by 0.244x: one deal in nine is 11.1 per cent of the capital, and 11.1 per cent of 2.2 is 0.244.

Step 3: the IRR

The IRR depends on the timing. Calls are $30 million in each of 2024, 2025 and 2026, and the 2.2x distributions come five years after each call:

$ million20242025202620272028202920302031
No write-off−30−30−3000666666
One 2025 write-off−30−30−3000664466
Net cash flows by year. In the second row the 2030 distribution is $44 million: two of the three 2025 deals at $10 million × 2.2.

In Excel: =IRR(B2:I2). The first row gives 17.08% and the second 14.37%, a fall of 2.71 points. With no failure every cohort earns the single-deal IRR of 17.08%, so the programme earns the same. The write-off takes 2.71 points off it.

Step 4: how many failures it takes

With nine deals and the same 2.2x on the survivors, the multiple depends only on the count:

Multiple = (deals − failures) × size × 2.2 ÷ called capital.

Write-offsPerforming dealsDistributions ($m)MultipleProfit ($m)
091982.20x108
181761.96x86
271541.71x64
361321.47x42
451101.22x20
54880.98x-2
$90 million called. Break-even needs 4.09 performing deals, so the fifth write-off is the first to take the programme below 1.0x.

What if the failed deal came back with something?

The common mistakes

Takeaway

The programme multiple is arithmetic: 176 divided by 90 is 1.96x with one write-off, against 2.20x without. The IRR falls from 17.1% to 14.4%. Before sizing a co-investment programme, count the deals, decide how many write-offs it can carry, and compute the multiple the survivors must return. For the full sleeve and its place in the fund of funds, see The Fund of Funds Investor.

Reproducing it in the workbook

The inputs are in Fund_of_Funds_Model.xlsx: rows 37 to 41 of the Inputs sheet hold the deal size, the three deals a year, the 2.2x multiple and the failed deal’s mark. The Co-Investments sheet builds the sleeve for the nine deals with one write-off and computes the sleeve multiple (distributed over called) and the IRR. The table of write-offs and the no-failure case are not in the workbook; they use the same formulas.

Questions readers ask

How much does one write-off cost a co-investment programme?

With nine deals of $10 million at 2.2x, one write-off cuts the multiple from 2.20x to 1.96x and removes 20.4% of the profit.

How many write-offs does it take to lose money?

Five out of nine. Four write-offs still return 1.22x; five return 0.98x.

How much does one write-off cost in IRR?

2.71 points here: the programme IRR falls from 17.08%, which is the IRR of a single deal at 2.2x over five years, to 14.37%.

The workbooks behind this article

Every figure above is built from the inputs in the free companion files for The Fund of Funds Investor, which also hold the primary fund programme, secondaries, a subscription facility and the Fund IV fee model. No account and no email address.

Open the companion files →

Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: private equity and private markets → · All 1908 articles →