Dividend Recap: LBO Tutorial With Excel Examples (2024)

Dividend Recap Definition: In a Dividend Recapitalization (“Dividend Recap”), a private equity firm has a portfolio company issue additional Debt to fund a Dividend issuance that boosts the PE firm’s internal rate of return (IRR) on the deal.

A Dividend Recap is similar to a commercial real estate loan refinancing in the property sector: it’s a way to use additional Debt to amplify the returns in a deal.

If a company performs well, a Dividend Recap can boost the PE firm’s IRR anywhere from “modestly” to “substantially.”

But if a company performs poorly, or the deal is likely to produce a negative IRR, a Dividend Recap will make the results even worse.

Dividend Recap: LBO Tutorial With Excel Examples (1)

Core Financial Modeling

Learn accounting, 3-statement modeling, valuation/DCF analysis, M&A and merger models, and LBOs and leveraged buyout models with 10+ global case studies.

Learn more

The Dividend Recap Rationale and a Simple Example

There are two types of Dividend Recaps in leveraged buyouts: unleveraged and leveraged.

In an Unleveraged Dividend Recap, a private equity-owned portfolio company issues a Dividend to the PE firm during the holding period without issuing additional Debt.

The portfolio company might do this if it generates significant Free Cash Flow and has low Debt principal repayments.

There isn’t much to say about this type of Dividend Recap because it’s simple to build into models.

The more interesting variation is the Leveraged Dividend Recap, in which the portfolio company issues additional Debt to fund the Dividend.

If the company performs well, this mechanism can boost the IRR because of the time value of money.

For example, consider the scenario shown below, in which the PE firm acquires a company, operates it, and sells it in Year 5:

Dividend Recap: LBO Tutorial With Excel Examples (2)

This result is “OK,” but the PE firm could get better results by tweaking its strategy.

We know the company repays significant Debt because the Debt balance decreases from $600 to $240 by the end.

That Debt repayment provides a benefit because it reduces the company’s Interest Expense in the holding period and increases the Exit Equity Proceeds in Year 5.

BUT if the company could distribute its cash flows to the PE firm, or the company could issue more Debt and distribute the proceeds to the PE firm, the benefit could be even greater.

For example, here’s what it looks like if the company repays no Debt and issues 100% of its available cash flow to the PE firm:

Dividend Recap: LBO Tutorial With Excel Examples (3)

The IRR increases by ~3%, but this scenario is not realistic because the lenders in almost all leveraged buyouts require some Debt principal repayment.

They want to see that the company is generating healthy cash flows and using them to repay some Debt over time.

Waiting until the exit for any repayment creates too much risk, especially if the deal underperforms.

So, a more realistic option is to assume the normal Debt principal repayments in the holding period and additional Debt issuances to fund Dividend distributions to the PE firm.

This option is the Leveraged Dividend Recap described above.

Here’s what happens if the company issues $126 million of extra Debt in Year 3, approximately 1x the Year 3 EBITDA, and distributes the proceeds to the PE firm (we ignore fees in this simplified model):

Dividend Recap: LBO Tutorial With Excel Examples (4)

The final Debt balance in Year 5 is higher than in the first scenario, but the PE firm also receives a cash distribution earlier in the holding period.

Since money in Year 3 is worth more than money in Year 5, the internal rate of return increases, even though the money-on-money multiple stays the same.

Remember that leverage is a double-edged sword: it doesn’t “boost returns” but amplifies returns.

If a deal performs poorly, more leverage will make it perform even worse, and if it performs well, more leverage will make it even better.

A Leveraged Dividend Recap is a form of additional leverage, so the same principles apply here.

For example, consider a scenario in which this company’s EBITDA declines by nearly 20% from Year 1 through Year 5, resulting in a negative IRR:

Dividend Recap: LBO Tutorial With Excel Examples (5)

If the PE firm executed a Dividend Recap for 1x EBITDA in Year 3, it would make the deal results even worse:

Dividend Recap: LBO Tutorial With Excel Examples (6)

The Dividend Recap in a Full LBO Model

Implementing a Leveraged Dividend Recap in an LBO model takes a moderate amount of work, but it’s not that difficult if you have a properly constructed model with a robust Debt Schedule.

First, you need to include the additional Debt issuances and add this new funding to the company’s “Cash Flow Available Before Revolver” or “Cash Flow Available for Debt Repayment”:

Dividend Recap: LBO Tutorial With Excel Examples (7)

Often, you assume additional Term Loans to fund this Dividend because Term Loans have mandatory and optional principal repayments, meaning that the Term Loan balance tends to decrease over time.

For example, if the company starts with a 3x Term Loan / EBITDA ratio and it repays some of the balance and reaches 2x by Year 3, it may issue Term Loans for another 1x EBITDA.

Yes, its Debt load increases, but it’s not a problem because it’s simply returning to the initial level.

Once you have this set up, you can modify the Mandatory Repayment schedule to include the additional issuance(s) for the Dividend Recap:

Dividend Recap: LBO Tutorial With Excel Examples (8)

The Optional Repayment or “Cash Flow Sweep” formula should not need to change if you’ve set it up properly, i.e., it deducts Mandatory Repayments in the period.

Similarly, you shouldn’t need to change anything in the Interest Calculations as long as they’re based on thechanging Debt balances over time.

On the Cash Flow Statement or “mini-Cash Flow Statement,” you can support the Leveraged Dividend Recap by deducting the Dividend Issuances, net of issuance fees, and adding the proceeds received:

Dividend Recap: LBO Tutorial With Excel Examples (9)

Finally, on the Income Statement, you should technically change the Amortization of Financing Fees to reflect the additional fees on this Term Loan issuance:

Dividend Recap: LBO Tutorial With Excel Examples (10)

But this Amortization line item is small, non-cash, and only makes a tiny impact on the company’s taxes, so we ignore the change here.

If the company had substantial Dividend Recaps in each year of the model, it would be more important to reflect the higher Amortization number.

You can see the impact of this Dividend Recap directly on the Balance Sheet: a higher Debt balance and lower Common Shareholders’ Equity when it takes place:

Dividend Recap: LBO Tutorial With Excel Examples (11)

The Dividend Recap in the Returns Calculation of an LBO Model

There is one final step: you must reflect these Dividends in the returns calculations.

The Excel file and video tutorial here skip this step because they’re excerpts from a 20-part case study in which we calculate the returns in a later segment.

Here’s the finished product:

Dividend Recap: LBO Tutorial With Excel Examples (12)

As a result of this Leveraged Dividend Recap, the PE firm receives some of the proceeds earlier in the holding period, but it must also repay a higher Debt balance upon exit.

Here’s how the Dividend Recap in this model affects the results:

Dividend Recap: LBO Tutorial With Excel Examples (13)

The Dividend Recap boosts the IRR by less than 1% because it’s very low relative to the purchase and exit multiples and the initial amount of Debt.

Dividend Recaps can make “borderline” deals look a bit better (e.g., if the baseline IRR is 18%, a Recap might boost it to 20% or 21%), but they’re usually not enough to turn a “no” investment recommendation into a “yes.”

For example, if the deal produces a 10% or 15% IRR in the Base Case vs. a 20% target, a single Dividend Recap will not make the deal acceptable.

Dividend Recaps tend to make the biggest difference for high-growth companies and high FCF margin companies.

In the first case, the company’s EBITDA and FCF grow substantially, resulting in substantial Debt paydown and the ability to issue more Debt over time.

In the second case, the company’s EBITDA and FCF do not necessarily grow, but since the company can repay Debt quickly, it can easily issue more during the holding period.

You’ll see this strategy frequently in emerging and frontier markets, where many companies are growing quickly but cannot issue much Debt initially (e.g., 2-3x Debt / EBITDA rather than 5-6x).

In these deals, multiple Dividend Recaps in the holding period can make a substantial difference in the financial results.

This tutorial is a small taste of the knowledge you’ll gain in our paid courses. Breaking Into Wall Street uses real-life modeling tests and interview case studies to prepare you for investment banking and private equity interviews – and a leg up once you win your offer and start working. Find out more about our advanced training by via the button below:

Sign Up To Core Financial Modeling

Dividend Recap: LBO Tutorial With Excel Examples (14)

About Brian DeChesare

Brian DeChesare is the Founder of Mergers & Inquisitions and Breaking Into Wall Street. In his spare time, he enjoys lifting weights, running, traveling, obsessively watching TV shows, and defeating Sauron.

Dividend Recap: LBO Tutorial With Excel Examples (2024)
Top Articles
Latest Posts
Article information

Author: Kerri Lueilwitz

Last Updated:

Views: 5933

Rating: 4.7 / 5 (67 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Kerri Lueilwitz

Birthday: 1992-10-31

Address: Suite 878 3699 Chantelle Roads, Colebury, NC 68599

Phone: +6111989609516

Job: Chief Farming Manager

Hobby: Mycology, Stone skipping, Dowsing, Whittling, Taxidermy, Sand art, Roller skating

Introduction: My name is Kerri Lueilwitz, I am a courageous, gentle, quaint, thankful, outstanding, brave, vast person who loves writing and wants to share my knowledge and understanding with you.