LBO Valuation: The Power of Middle-School Math to Reverse a Model

Why It Matters

It lets private‑equity analysts instantly gauge the maximum price they can pay for a target to meet a desired IRR, accelerating deal screening while flagging the need for more complex tools when cash‑flow structures are intricate.

Key Takeaways

• Add IRR and exit year inputs to drive LBO model
• Use algebraic formula to compute required investor equity
• Link required equity, debt, fees to calculate purchase enterprise value
• Handle circular references by fixing transaction fees or using VBA
• Method works for single exit; complex cash flows need goal seek

Summary

The video walks viewers through converting a traditional LBO model into a flexible pricing tool by making the targeted IRR and exit year primary inputs. Instead of relying on Goal Seek, the instructor derives a simple algebraic expression that backs out the purchase price needed to achieve a specified return.

Key steps include adding input rows for IRR and exit year, using XLOOKUP to pull exit equity proceeds, and applying the formula: required investor equity = exit proceeds / (1+IRR)^years. From there, the model adds new debt, subtracts fees and minimum cash to compute the required purchase enterprise value and the corresponding EBITDA multiple.

The presenter validates the approach with examples: a 25% IRR over five years yields a 7.8× purchase multiple, while a 35% IRR over four years produces roughly a 7.1× multiple, both matching the target returns within a fraction of a percent. He also highlights circular‑reference issues when fees depend on purchase price and suggests hard‑coding fees or using VBA/Goal Seek as work‑arounds.

The technique offers a quick way to price a deal when only a single entry and exit cash flow exist, but it breaks down with dividend recaps, add‑ons, or other interim cash movements, where more sophisticated iterative methods become necessary.

Original Description

Learn more: https://breakingintowallstreet.com/private-equity-modeling/?utm_medium=yt&utm_source=yt&utm_campaign=yt39

You'll learn how to set up Excel formulas to value a company via a leveraged buyout model in this lesson, and why Goal Seek is not necessary to do this.

Files & Resources:

https://breakingintowallstreet.com/kb/leveraged-buyouts-and-lbo-models/lbo-valuation/

Table of Contents:

0:00 Introduction

1:28 Model Modifications

3:39 Required Investor Equity

6:44 Required Purchase Multiple

9:26 Model Drivers and Circular References

11:56 Footnotes and Fine Print

13:11 Recap and Summary