Guides/Private Equity

From Financial Model to Investment Recommendation

A model produces numbers. A recommendation says what to do with them, and shows what would have to be true for it to be wrong.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: has read and written investment committee papers.Updated 14 November 202612 min read

Most analysts can build a model that balances. Far fewer can say, in two sentences, what it means for a decision. The gap is not technical. It is the difference between reporting what a model outputs and arguing for an action, with the evidence arranged so that an investment committee can test the argument in the time it has.

Start from a hypothesis, and from what would break it

The weaker way to work is to build the model, run it, and see what it says. The result is a set of outputs in search of a story, and the story tends to follow whichever number looks best. The stronger way is to write the hypothesis first: a sentence that, if true, makes the deal attractive. For example, that a testing and inspection business bought at 9.0x EBITDA can earn at least 2.0x its equity in five years from contracted growth and debt repayment, without relying on a higher exit price.

Then write what would falsify it. If the exit multiple is below some level, if one customer leaves, or if cash conversion is weaker than assumed, the hypothesis fails. Those conditions tell you which assumptions to test hardest and which pages of the paper to spend on them. A model built to test a hypothesis has a shape. A model built to see what happens has only a size.

Situation, complication, question, answer

The structure that opens most good papers is four moves. The situation is what the committee already accepts. The complication is what has changed or what makes a decision necessary. The question is the decision that follows. The answer is the recommendation, stated before any evidence.

For an invented buyout of Brightwater Laboratories, a UK testing and inspection group, it reads as follows. Situation: the fund is investing the £1.2bn vehicle and has no exposure to regulated testing. Complication: the founders have instructed an auction, and first-round bids are due in three weeks. Question: should the fund bid, and at what price? Answer: yes, up to an enterprise value of £360m, which is 9.0x EBITDA of £40m.

The discipline is in the order. The reader should know the answer by the end of the first paragraph and spend the rest of the paper deciding whether to believe it.

The pyramid: answer first, three arguments, evidence beneath

Barbara Minto set out the pyramid principle for business writing. The answer sits at the top, supported by a small number of arguments that together make the case, and each argument rests on evidence. The arguments should be mutually exclusive and together sufficient, which is the same test described in the guide on MECE splits.

For a buyout the arguments can follow the arithmetic of returns. Equity gains come from the price paid, the earnings growth and the debt repaid. Those are three independent reasons and they happen to be the three terms of the identity, so the pyramid and the model share a skeleton.

A fully written example

The recommendation: invest £180m of equity to acquire 100% of Brightwater Laboratories at £360m enterprise value, for a base case money multiple of 2.4x and an IRR of 19% over five years.

Argument one, written as an action title: "Entry at 9.0x EBITDA is about 12% below the 10.2x median of five comparable transactions". The evidence is the precedent table: 1 - 9.0 / 10.2 = 11.8%. The price is the one input the fund controls fully before signing.

Argument two: "EBITDA grows from £40m to £58m, 7.7% a year, with most of it already contracted". The evidence is a bridge of the £18m increase: £7m from contractual price escalators, £8m from four new laboratory sites and £3m from procurement savings. 7 + 8 + 3 = 18, and (58 / 40)^(1/5) - 1 is 7.7%.

Argument three: "Cash generation repays £90m of the £180m debt, taking leverage from 4.5x to 1.6x". The evidence is the debt schedule: £180m / £40m = 4.5x at entry, and £90m / £58m = 1.55x at exit, which rounds to 1.6x.

The returns follow. Exit enterprise value at an unchanged 9.0x is 9.0 x £58m = £522m. Less net debt of £90m, equity is £432m, which is 2.4x the £180m invested. A 2.4x multiple over five years is an IRR of 2.4^(1/5) - 1 = 19.1%. As a rule of thumb, 2.5x over five years is about 20%, and 2.0x is 14.9%.

Where the £252m of equity gain comes from
SourceCalculation£mShare of gain
EBITDA growth(58 - 40) x 9.0x16264%
Multiple change(9.0x - 9.0x) x 5800%
Debt repaid180 - 909036%
Total gain432 - 180252100%

Action titles: a conclusion and a number

A title that names a topic, such as "Entry valuation", makes the reader do the work. An action title states the conclusion and carries the number that proves it: "Entry at 9.0x is about 12% below comparable deals". A committee member who reads only the titles in sequence should be able to follow the whole argument.

Test each title by asking whether it could be false. "Growth outlook" cannot be false, so it says nothing. "EBITDA grows 7.7% a year, mostly from contracted sources" can be checked against the page beneath it, and that exposure is why a reader trusts it. Keep titles to two lines, put the number early, and make the title and the chart agree to the last decimal.

Evidence and assertion

In an investment paper, evidence means a model output shown with the assumption that produced it and the sensitivity of the output to that assumption. Assertion is a claim with no number or a number with no derivation.

"The business has strong pricing power" is an assertion. "Price escalators are written into contracts covering 70% of revenue, adding £7m of EBITDA by year five, and the case still returns 2.05x if none are collected" (exit EBITDA of £51m x 9.0x = £459m, less £90m of net debt, is £369m on £180m) is evidence: an output, its source and its sensitivity. In the second form, the reader can challenge the assumption directly rather than the adjective.

Sensitivity and downside

Show the two variables that move the answer most and that nobody can know in advance. For a buyout those are usually exit EBITDA and the exit multiple, because together they set exit value. The grid below holds net debt at £90m. In practice weaker EBITDA also pays down less debt, so the lower-left cells are slightly flattering, and the paper should say so.

Money multiple by exit EBITDA and exit multiple (net debt £90m, equity £180m)
Exit EBITDA7.0x8.0x9.0x
£46m1.29x1.54x1.80x
£52m1.52x1.81x2.10x
£58m1.76x2.08x2.40x

The breakeven framing

A grid shows the surface. A breakeven sentence gives the committee a threshold to carry into the room. If the fund requires at least 2.0x, equity at exit must be £360m. With net debt of £90m, enterprise value must be £450m, and at EBITDA of £58m that is a multiple of 7.76x. The case therefore holds unless the exit multiple falls below about 7.8x, which is 1.2 turns under the entry multiple.

The same method gives the point at which capital is lost. Equity of £180m plus net debt of £90m is £270m, and at £58m of EBITDA that is a multiple of 4.66x. On the base operating case, the fund loses money only if the business is sold at about half the price it was bought for. That is a strong statement, and it is only available because the threshold was calculated and not asserted.

The downside as loss of capital

A downside case that reads "IRR falls to 8%" understates what a committee fears. State it as money. Suppose Brightwater loses its largest customer, EBITDA falls to £32m, little debt is repaid so net debt stays at £150m, and the exit multiple is 6.5x. Enterprise value is 6.5 x £32m = £208m. Less £150m of net debt leaves equity of £58m, which is 0.32x the £180m invested. That is a loss of £122m, or 68% of the capital.

Then state what the structure does about it. Leverage of £150m on £32m is 4.7x, and if the covenant is 5.0x there is little headroom. Naming the number tells the committee the risk is understood, and it invites the discussion about whether to bid with less debt, which is the conversation the paper exists to enable.

How an investment committee reads

Committee members read in a predictable order. They start with the first page, which must contain the recommendation, the price, the equity cheque and the headline returns. They go next to the returns table and the sensitivity grid, and they read the risks last but most closely, looking for the one the paper omitted.

The questions follow from that order. What do we have to believe to get the base case? What happens to our money if we are wrong about the one thing we are least sure of? How much of the return comes from the multiple, as opposed to earnings and debt? Who else is bidding and why would we win? A paper that has already answered the first three on its first three pages has done most of the work.

Common mistakes

  • Leading with the model. The committee wants the decision and the reasons. How the model was constructed belongs in an appendix.
  • Presenting one return figure. A single IRR with no range reads as a forecast, and nobody trusts a forecast.
  • Hiding a multiple-driven return. If the base case needs an exit multiple above entry, say so. Here, none of the £252m gain depends on the multiple.
  • Showing sensitivities that cannot move. Varying the tax rate by a point shows effort and no insight.
  • Titles that name topics. If the page headings joined together do not make an argument, the paper has no argument.
  • A downside that is only a lower IRR. Express it in pounds of capital at risk.

An exercise, with the answer

A fund can buy a business with EBITDA of £15m at 8.0x. It will use £60m of debt and £60m of equity. In four years, EBITDA is £21m, the exit multiple is 8.0x and net debt is £40m. Write the recommendation sentence, three action titles and the breakeven multiple for a 2.0x return.

The answer. Entry enterprise value is 8.0 x £15m = £120m. Exit enterprise value is 8.0 x £21m = £168m. Less £40m of net debt, equity is £128m, which is 2.13x the £60m invested. Over four years that is an IRR of 2.1333^(1/4) - 1 = 20.9%. The gain of £68m splits into £48m from EBITDA growth (£6m x 8.0x) and £20m from debt repaid, with nothing from the multiple.

Recommendation: "Invest £60m of equity in a £120m acquisition at 8.0x EBITDA, for a base case of 2.1x and a 21% IRR over four years." Titles: "EBITDA grows 8.8% a year to £21m with no multiple expansion", "Debt falls from 4.0x to 1.9x EBITDA as £20m is repaid", and "The case reaches 2.0x unless the exit multiple falls below 7.6x". For the last one, a 2.0x return needs £120m of equity, so enterprise value of £160m, and £160m / £21m = 7.62x.

Next

Work the model behind the paper

The LBO model in the Models library is a workbook with sources and uses, a debt schedule, returns and sensitivities, every formula live. Change the exit multiple and watch the money multiple move.

What the download contains. The worked leveraged buyout model is an Excel file: 8 sheets (Cover, Assumptions, Sources & Uses, Operating Model, Debt, Returns, Sensitivity, Checks), 379 live formulas and every check reading zero, so a changed input moves the whole model. The starter workbook is the same file with the debt schedule left blank for you to build.

Every starter workbook downloads with a free L3VLUP account. A worked model downloads with L3VLUP Plus (one each billing month, kept for good) or L3VLUP Pro (every model).

Get told when the Private Equity programmes open

Preparation pays when it lands before the window does. Leave your email and we will tell you the day the programmes you care about open, so this is done in the first fortnight rather than the last.

One email when applications open, plus a short weekly round-up in season. Free, and you can leave at any point.

Frequently asked questions

How do you turn a financial model into an investment recommendation?

Begin with a hypothesis and the conditions that would falsify it, then state the answer first. Support it with three or four independent arguments, each with a model output, its assumption and its sensitivity beneath. Close with the downside expressed as capital at risk.

What is the pyramid principle?

A method set out by Barbara Minto for structuring business writing. The answer comes first, supported by a few arguments that together justify it, with evidence beneath each. The arguments should be mutually exclusive and sufficient as a set.

What is an action title?

A slide or section title that states a conclusion and the number that supports it, such as "Entry at 9.0x is about 12% below comparable deals". Read in sequence, the action titles of a paper should tell the whole argument.

Which sensitivities should an investment paper show?

The two variables that move the result most and that cannot be known in advance, usually exit multiple and exit EBITDA in a buyout. Add a breakeven statement giving the threshold at which the required return is lost, and a downside shown as loss of capital.

How does a 2.5x money multiple relate to IRR?

Over five years, 2.5x is an IRR of about 20%, since 2.5 to the power of one fifth is 1.201. A 2.0x multiple over the same period is about 14.9%, and 3.0x is about 24.6%. The shorter the hold, the higher the IRR for the same multiple.

Questions about this guide

Discussions open here soon.

All discussions