Leveraged Buyout Model Example: A Quick Guide (leveraged buyout model example)

At its heart, a leveraged buyout (LBO) is a strategy for acquiring a company using a significant amount of borrowed money. The core idea is simple: use the target company's own cash flow to service and pay down that debt over the holding period.

An LBO model, usually built in Excel, is the financial tool that maps out this entire lifecycle. It starts with the acquisition, projects the company's performance and debt repayment over several years, and ends with the eventual sale (or "exit"), ultimately calculating the private equity firm's return on investment.

So, How Does an LBO Actually Work?

Before diving into the spreadsheet, you have to get the strategy right. An LBO is all about using other people's money—the lenders'—to amplify your own returns. The leverage is what makes the math so compelling for a private equity (PE) firm.

Think about it like buying a house to rent out. You might put down 20% of your own cash (your equity) and take out a mortgage for the other 80% (the debt). The rent you collect from tenants then covers your mortgage payments. Fast forward a few years: you've paid down some of the loan, the property value has hopefully appreciated, and your initial 20% investment has generated a much larger return. An LBO is just this concept applied to a multi-million or multi-billion dollar company.

What Makes a Company a Good LBO Target?

Not just any company can handle the immense pressure of an LBO. PE firms are incredibly selective, hunting for specific traits that signal a business can thrive under a heavy debt load. These are the very same characteristics that will drive the key assumptions in your model.

Here’s what they look for:

• Steady, Predictable Cash Flows: This is the big one. The business absolutely must be a reliable cash machine, capable of meeting its debt payments without fail, even if the economy takes a downturn.
• A Rock-Solid Management Team: You need a proven leadership team at the helm, one that can find efficiencies and execute a growth plan after the deal closes.
• Minimal Capital Expenditures: Companies that don't need constant, expensive investments in new equipment or facilities are ideal. This frees up more cash to pay down debt instead of buying new machinery.
• Untapped Potential: PE firms are looking for a clear path to make the business better. This could mean cutting unnecessary costs, streamlining operations, or expanding into new markets to juice the company's earnings.

Confirming these qualities requires a ton of upfront work, particularly a deep dive known as commercial due diligence. It's an exhaustive process that happens long before any ink dries on a contract.

The north star for most PE deals is an Internal Rate of Return (IRR) of 20% or more and a Multiple on Invested Capital (MoIC) of at least 2.5x. Your LBO model is built to answer one question: can this deal hit those numbers?

Before we get into building the model, it's helpful to understand how all the pieces fit together. The table below breaks down the main sections you'll be creating.

Key Components Of An LBO Model

Model Component	Purpose & Key Metrics
Transaction Assumptions	Defines the entry price, financing structure (debt/equity mix), and fees. Key Metrics: Entry Multiple, Debt/EBITDA.
Sources & Uses	A table that balances where the money is coming from (sources) and where it's going (uses). Must always balance to zero.
Pro Forma Financials	Projects the company's Income Statement, Balance Sheet, and Cash Flow Statement over the holding period (typically 5-7 years).
Debt & Interest Schedule	The engine of the model. It tracks debt balances, interest payments, and how excess cash flow is used to pay down debt principal.
Exit & Returns Analysis	Calculates the company's sale value at exit and determines the PE firm's profit. Key Metrics: IRR, MoIC.
Sensitivity Analysis	Creates tables to show how returns change based on different entry multiples, exit multiples, and leverage levels.

Each of these components builds on the last, flowing from the initial purchase assumptions all the way through to the final returns calculation. Getting each section right is critical for a credible and accurate analysis.

Laying the Groundwork: Structuring Your Model & Transaction Assumptions

Alright, let's get our hands dirty. This is where the abstract concepts of a leveraged buyout start taking shape in Excel. The very first thing you’ll do when building a practical LBO model is create a dedicated "Assumptions" tab.

Think of this sheet as the central nervous system for your entire analysis. Every key input that drives the model—from the purchase price to the interest rates on debt—will live here. A clean, well-organized assumptions tab is non-negotiable. It not only makes your logic easy to follow but also lets you run sensitivity analysis later without having to hunt through a maze of formulas.

Figuring Out the Purchase Price

The first order of business on your assumptions tab is to define the entry valuation. For our target company, let's call it ‘StableCo,’ a hypothetical mid-sized manufacturing firm, we need to land on its Enterprise Value (EV). In the LBO world, this is almost always calculated as a multiple of the company's Last Twelve Months (LTM) EBITDA.

Let's say StableCo pulled in $100 million in LTM EBITDA. After looking at what similar companies have sold for (precedent transactions) and what they're trading at in the public markets (comparable company analysis), we feel a 10.0x entry multiple is fair.

• LTM EBITDA: $100 million
• Entry Multiple: 10.0x
• Enterprise Value (EV): $100M * 10.0 = $1,000 million

But that’s not the price we pay for the stock. From the EV, we have to calculate the Purchase Equity Value. To get there, you simply subtract StableCo’s existing net debt. If StableCo is carrying $200 million in debt and has $50 million in cash on its balance sheet, its net debt is $150 million.

• Enterprise Value: $1,000 million
• Less: Net Debt: ($150 million)
• Purchase Equity Value: $850 million

That $850 million is the check the private equity sponsor has to write to acquire all of StableCo's shares. This number is the cornerstone of our next step: building the sources and uses table.

Building The Sources and Uses Table

The sources and uses table is a simple but critical part of any LBO model. It’s a mini-schedule that lays out exactly where every dollar for the deal is coming from (Sources) and where every dollar is going (Uses). The key rule? Both sides have to balance perfectly. It’s your first sanity check to make sure the math holds up.

You'll almost always build the "Uses" side first, because it tells you the total amount of capital you need to get the deal done.

Uses of Funds	Amount	Explanation
Purchase Equity Value	$850M	This is the price to acquire all of StableCo's shares.
Refinance Existing Debt	$200M	We have to pay off StableCo's old lenders as part of the deal.
Transaction Fees	$30M	Covers banking, legal, and advisory fees. A good rule of thumb is 2-3% of EV.
Total Uses	$1,080M	The total capital needed to close the deal.

Now that we know the magic number is $1,080 million, we can figure out how to pay for it on the "Sources" side. This is where we layer in the different types of debt and, finally, determine how much cash the sponsor needs to contribute. The capital structure you can achieve is heavily dependent on the financing markets at the time. For example, knowing that global LBO volume hit a record $397.5 billion in 2025, with average leverage reaching 5.5x EBITDA and top-tier assets commanding 12x EBITDA multiples financed with 65% debt, gives you real-world context. You can explore more about these LBO market trends to ground your assumptions in reality.

With that in mind, let's assemble the financing for our StableCo deal.

Pro Tip: In pretty much every LBO model, the sponsor's equity check is the "plug." You figure out how much debt you can raise first, and whatever is left over to make the sources and uses table balance is the cash the PE firm has to pony up.

Let's assume the debt markets are feeling generous and lenders are willing to provide a total debt package of 6.0x LTM EBITDA.

Sources of Funds	Amount	Explanation
Term Loan B	$400M	This is senior secured debt, representing 4.0x EBITDA.
Senior Unsecured Notes	$200M	A riskier, more expensive layer of debt, representing 2.0x EBITDA.
Total New Debt	$600M	Total leverage of 6.0x EBITDA ($600M / $100M).
Sponsor Equity	$480M	(The Plug: $1,080M Uses - $600M Debt)
Total Sources	$1,080M	Balances perfectly with our Total Uses.

This final $480 million is the sponsor's skin in the game. It's the initial cash investment and will be the denominator we use to calculate their return, or Multiple on Invested Capital (MoIC), when they eventually sell the company. With these foundational pieces locked in, we're ready to start forecasting the company's future.

Now that we’ve pinned down the transaction assumptions, it’s time to roll up our sleeves and project the company's financial future. This is where we build the core engine of our LBO model—a fully integrated three-statement model for our target, StableCo. The whole point is to map out how the business will perform over a typical five-year hold period. This forecast will tell us exactly how much cash is available to start paying down that mountain of acquisition debt.

We'll kick things off with the income statement. This means making some educated guesses on revenue growth, cost of goods sold (COGS), and operating expenses. For a mature manufacturing business like StableCo, a modest annual revenue growth of 4% feels reasonable, with gross margins holding steady at 35%. These aren't just numbers you pull out of thin air; they should be grounded in the company's past performance, what's happening in the industry, and any real operational improvements the private equity sponsor believes they can make.

From there, it's all about connecting the dots. The net income from your P&L feeds directly into the cash flow statement and also hits retained earnings on the balance sheet. You’ll also model changes in working capital—things like inventory and accounts receivable—on the balance sheet, which will in turn drive a big part of your cash flow from operations. If you want a deeper dive into making these statements talk to each other, our guide on how to build financial models is a great resource.

Crafting The All-Important Debt Schedule

The debt schedule is, without a doubt, the most intricate—and critical—piece of any LBO model. It's the mechanism that tracks every dollar of cash flow used to service and pay down the debt taken on for the buyout. If you get this wrong, the entire analysis falls apart. Precision is everything here.

You start by pulling in each piece of debt from your Sources & Uses table. In StableCo's case, that’s the $400M Term Loan B and the $200M Senior Unsecured Notes. Each one of these will have its own specific rules for interest, repayments, and prepayments.

• Beginning Balance: Simply the debt outstanding at the start of the period.
• Mandatory Repayment: This is the scheduled principal payment you must make. It's often a small percentage, like 1% annually for a Term Loan B.
• Optional Prepayment: This is where you use any extra cash flow to pay down debt faster than required.
• Ending Balance: The debt left over after all payments are made.

A fundamental part of building an LBO model is a detailed cash flow analysis, because that future cash generation is what determines your ability to repay debt and, ultimately, what kind of return investors will see. This analysis is the direct input for how you model optional prepayments.

Key Takeaway: The debt schedule isn't just an accounting exercise. It’s the engine that shows how deleveraging—a primary way LBOs make money—builds equity value for the sponsor over the life of the investment.

The Cash Flow Waterfall Logic

To handle optional prepayments correctly, you have to build what's called a "cash flow waterfall." Think of it as a pecking order for your cash. This logical sequence dictates how every dollar generated by the business gets spent, making sure all your bills are paid before you do anything discretionary, like paying down debt early.

The typical waterfall hierarchy looks something like this:

1. Cash Flow from Operations: Start with the cash your core business generates.
2. Less: Capital Expenditures: Subtract the cash needed to maintain and grow the company's assets.
3. = Cash Available for Debt Service: This is the total cash you have to work with.
4. Less: Mandatory Debt Amortization: First, make the required principal payments on all term loans.
5. = Cash Available for Optional Prepayment: Whatever is left over can be used to pay down debt ahead of schedule.

This structure keeps your model grounded in reality. For StableCo, any cash left after making its mandatory 1% term loan repayment would likely be used to pay down the most expensive debt first, a common requirement baked into credit agreements.

This simple flow chart gives you a bird's-eye view of the deal structure. It shows how the Purchase Price dictates the Sources and Uses of funds, which in turn determines the Sponsor Equity check needed to get the deal done.

Avoiding The Dreaded Circular Reference

One of the classic traps you can fall into when building a debt schedule is the circular reference. It happens because your interest expense (on the income statement) depends on the average debt balance, but that debt balance (on the balance sheet) depends on the cash flow you generate... which is affected by the interest expense in the first place. It's a real chicken-and-egg problem.

You have a couple of ways to deal with this:

• Iterative Calculations: The quick-and-dirty fix is to go into Excel's settings and turn on iterative calculations. This tells Excel to keep running the calculation loop until the numbers stop changing. It's fast, but it can make your model buggy and a nightmare to audit.
• Circularity Switch: The more professional way is to build a toggle, or a "circ breaker." This switch lets you temporarily calculate interest based on the beginning-of-period debt balance, which breaks the loop. Once the model is balanced and stable, you can flip the switch back to calculate interest on the average balance for better accuracy.

For any professional-grade LBO model, building in a circularity switch is a non-negotiable best practice. It shows you know what you’re doing. With our projections and debt schedule now built, we have a clear picture of how StableCo’s balance sheet will deleverage over time, setting us up perfectly for the final step: figuring out the exit and the all-important investor returns.

Modeling The Exit And Calculating Investor Returns

Alright, we’ve projected the company’s performance and meticulously modeled how the debt gets paid down. Now we get to the fun part—the whole reason we built this thing. We need to answer the big question: "What's the return?" This is the payoff, where we model the sale of the company (the "exit") and calculate the two metrics that every private equity investor lives and breathes.

The entire analysis boils down to figuring out what the company is worth at the end of the holding period, which is typically five years down the road. Just like we used an EBITDA multiple to value StableCo at the beginning, we'll use one to value it at the end.

Determining The Exit Enterprise Value

The exit valuation is one of the most critical assumptions in the entire model. For our leveraged buyout model example, let's say our hard work paid off and StableCo’s EBITDA grew from $100 million to a projected $150 million by the end of Year 5.

Now, what multiple do we apply? A common, and frankly conservative, approach is to assume the exit multiple is the same as the entry multiple. This is often called a "multiple-neutral" scenario. It’s a good sanity check because it forces the return to be driven by operational improvements (EBITDA growth) and debt paydown, not just wishful thinking about a frothier market.

So, if we bought the company for 10.0x LTM EBITDA, we'll assume we can sell it for 10.0x Year 5 EBITDA.

• Year 5 Projected EBITDA: $150 million
• Exit Multiple: 10.0x
• Exit Enterprise Value (EV): $150M * 10.0 = $1,500 million

This $1.5 billion is the theoretical price tag for the business. But the private equity sponsor doesn’t just pocket all of that. Before anyone celebrates, the lenders need to be paid back what they're still owed. This is where that debt schedule we built earlier becomes indispensable.

From Enterprise Value To Sponsor Proceeds

To figure out what’s actually left for the equity holders, we have to subtract the company's net debt at the moment of sale. Your debt schedule gives you the exact remaining debt balance in Year 5 after all those years of principal repayments.

Let’s assume that after diligently using free cash flow to pay down debt, StableCo’s total debt has dropped from the initial $600 million to just $250 million.

1. Start with the Exit Enterprise Value: $1,500 million
2. Subtract the Remaining Debt: ($250 million)
3. Add back the Exit Cash Balance: $20 million (this comes from your balance sheet forecast)
4. This gives you the Final Equity Value: $1,270 million

That $1.27 billion is the total pot of cash available to all equity holders when the company is sold. It’s the number that will drive our final return calculations. If you want to dive deeper into the mechanics of valuation, our guide on mergers and acquisitions valuation is a great resource.

Calculating The Key Return Metrics

With our initial sponsor equity check and the final proceeds figured out, we can finally calculate the two headline metrics in private equity.

• Multiple on Invested Capital (MoIC): This one is straightforward. It answers the simple question, "How many times did I get my money back?" You just divide the final equity value by the initial sponsor equity you put in.

  • MoIC = $1,270M / $480M = 2.65x

• Internal Rate of Return (IRR): This is the more sophisticated, time-sensitive metric. It calculates the annualized rate of return on the investment, meaning it cares not just about how much money you made, but also how long it took. In Excel, the =XIRR() function is your best friend here. You just need to map out the cash flows (a negative value for the initial investment, a positive one for the final proceeds) and their corresponding dates.

A "good" deal in the private equity world generally aims for an IRR north of 20% and a MoIC of at least 2.5x. Our StableCo deal, with its 2.65x MoIC and a corresponding 21.5% IRR over five years, would definitely be considered a win.

These final numbers are extremely sensitive to your assumptions, especially the exit multiple and EBITDA growth. The real world is rarely so clean. Think about the historic 2007 TXU Energy LBO, the largest of its time. Sponsors invested $8 billion dreaming of 25%+ IRRs, but an unforeseen collapse in natural gas prices drove the company straight into bankruptcy, wiping out every dollar of their equity. It’s a stark reminder that modeling returns is just the first step; understanding how fragile they are is the real challenge.

Pressure-Testing Your Model and Avoiding Common Pitfalls

So, you’ve built your LBO model. That’s a huge step, but the work isn’t done. Frankly, a spreadsheet can be made to say anything you want. A seasoned investor, however, will poke, prod, and pressure-test your numbers until they either stand firm or completely fall apart. This is where you graduate from being a model-builder to an analyst who can actually defend a deal.

The best way to do this is with sensitivity analysis. Using Excel's data tables, you can see exactly how your key return metrics—the IRR and MoIC—swing when you tweak your most important assumptions. It’s all about moving beyond a single, often optimistic, "base case" and understanding the full range of potential outcomes.

Building Your First Sensitivity Table

Your first stop should always be sensitizing returns against the two most impactful—and uncertain—variables: the entry and exit multiples. This table directly answers the gut-check question, "What happens to our return if we have to pay more upfront or sell for less when we exit?"

Let's look at our StableCo leveraged buyout model example. Our base case assumed a 10.0x entry and a 10.0x exit multiple, which got us to a 21.5% IRR. A good sensitivity table would frame that central case with a range of other possibilities, something like this:

	Exit Multiple: 8.0x	Exit Multiple: 9.0x	Exit Multiple: 10.0x	Exit Multiple: 11.0x
Entry Multiple: 9.0x	19.8%	23.1%	26.2%	29.1%
Entry Multiple: 10.0x	15.5%	18.6%	21.5%	24.3%
Entry Multiple: 11.0x	11.7%	14.7%	17.5%	20.2%

This simple table tells a powerful story. It immediately shows just how fragile returns can be. If market conditions turn south and we can only get an 8.0x multiple on exit, our great deal suddenly looks pretty mediocre. This is exactly the kind of critical insight an investment committee needs to see.

But don't stop with multiples. You should test other key drivers, too:

• Leverage Levels: What’s the damage to returns if lenders only offer 5.0x debt instead of the 6.0x we assumed?
• EBITDA Growth: How much does our IRR drop if the company only grows at 2% annually instead of our projected 4%?
• Interest Rates: What’s the impact if our floating-rate debt costs jump by 200 basis points?

A Quick Tip: Your model isn’t really finished until you have these sensitivity tables built out. They are a non-negotiable part of any private equity interview case study and every real-world investment memo.

Side-Stepping the Most Common Modeling Blunders

Of course, a sophisticated sensitivity analysis is pointless if the underlying model is broken. I've seen countless analysts—both new and experienced—get tripped up by a few common yet costly errors. Avoiding these is the key to building a credible financial story.

Just look at the iconic RJR Nabisco LBO. KKR saddled the company with over $18 billion in debt. But when a recession hit in 1990-1991, interest rates spiked, and annual debt service ballooned to a crippling $2.5 billion. Cash flows were absolutely crushed. In the end, KKR managed to eke out a modest 5-7% IRR, a far cry from typical PE home runs. It’s a powerful lesson in why you must stress-test your model against macro shocks—even a great company can buckle under too much debt in a bad economy.

With that cautionary tale in mind, be on high alert for these classic pitfalls:

1. Ignoring the Cash Sweep: This is a rookie mistake. Forgetting to link your excess cash flow to pay down the revolver or the most expensive term debt first will throw off your entire returns profile. Your cash flow waterfall has to be airtight.
2. Incorrect Interest Calculation: Always calculate interest on the average debt balance for the period, not the beginning or end balance. Getting this wrong can materially misstate your pre-tax income and the cash available to service debt.
3. The Unbalanced Balance Sheet: This is the cardinal sin of financial modeling. If Assets don't equal Liabilities + Equity, you have a fundamental logic error somewhere. It's almost always a broken link from the cash flow statement or a faulty debt schedule.
4. Unrealistic Operating Assumptions: Plugging in "hockey-stick" growth projections without a clear, defensible story for how that growth will actually happen is a massive red flag. Every assumption needs to be grounded in commercial reality.

Before finalizing any LBO model, a robust due diligence private equity process is essential to kick the tires on the target company's financials and operations. This rigorous investigation is what validates your assumptions and stress-tests them against real-world risks, ensuring your model is more than just a mathematical exercise.

Tackling Common LBO Interview Questions

You've built the model, you've run the sensitivities, but are you ready for the curveball questions? In any high-stakes interview, a PE associate isn't just checking if you can plug numbers into Excel. They want to know if you truly understand the why behind the mechanics.

Getting these conceptual questions right is what separates a good candidate from a great one. It shows you think like an investor, not just a model-builder. Let's break down some of the most common—and trickiest—questions you're likely to face.

What Is The 'Tax Shield' In An LBO and Why Does It Matter?

At its core, the tax shield is one of the biggest reasons leverage is so powerful in a buyout. Think of it this way: the interest a company pays on its debt is tax-deductible. In an LBO, you're loading the company up with a ton of debt, which means it will have very large interest payments, especially in the early years.

Those large interest payments "shield" a big chunk of the company's earnings from taxes. This means the company pays less in actual cash taxes. That extra cash doesn't just disappear; it goes directly toward paying down debt principal faster. Accelerating this debt paydown is a direct path to increasing the sponsor's equity value, which juices both the IRR and MoIC.

How Do You Handle Circular References When Calculating Interest?

Ah, the classic circular reference. Every analyst runs into this. It's that frustrating loop where interest expense depends on the average debt balance for the year, but the ending debt balance depends on how much cash is left after paying interest. It’s a real chicken-and-egg problem in Excel.

You’ve got two main ways to solve this:

• The Quick Fix: For a timed case study or a quick-and-dirty model, just enable iterative calculations in Excel's settings. This tells Excel to just keep running the loop a bunch of times until the numbers stop changing. It works, but it's not very elegant.
• The Pro-Level Fix: A much better, more robust approach is to build a 'circularity switch' into your model. This is a manual toggle (usually just a cell you can change from 0 to 1) that breaks the circularity. When the switch is "on," it tells the interest calculation to use the beginning debt balance instead of the average, which stops the loop.

Building a circularity switch is a best practice, period. While the iterative calculation method gets the job done, a manual switch shows you understand model integrity and the importance of being able to audit your work without errors. It's a small detail that signals a high level of modeling maturity.

What Are The Main Ways a PE Firm Makes Money In An LBO?

When a PE firm looks at a deal, they see three potential ways to create value. A really solid investment will rely heavily on the first two, with the third being a nice-to-have bonus.

1. Deleveraging: This is the bread and butter of most LBOs and the most reliable return driver. The concept is simple: use the company's own cash flow to pay down the mountain of debt used to buy it. Every dollar of debt paid off with the company's cash effectively increases the sponsor's ownership stake.
2. EBITDA Growth: This is where the operational magic happens. It's about making the business fundamentally better than it was before. This could mean growing revenue, expanding margins through cost-cutting, or making smart add-on acquisitions. A bigger, more profitable business is a more valuable business.
3. Multiple Expansion: This is the riskiest driver. It simply means selling the company for a higher EBITDA multiple than you paid for it (e.g., buying at 8x EBITDA and selling at 10x EBITDA). While great when it happens, it’s largely dependent on the state of the M&A and capital markets when you exit, which is completely out of your control.

Why Do You Model a Revolver Differently From Term Loans?

It's crucial to understand that not all debt is the same. A revolver and a term loan serve very different purposes.

A revolver, or a revolving credit facility, is basically a corporate credit card. It's a short-term liquidity tool. The company only draws on it when it's short on cash for day-to-day needs (like managing working capital swings) and has to pay it back the moment it has a cash surplus.

Term loans, on the other hand, are the workhorses of the acquisition financing. This is the big slug of debt that's fully funded when the deal closes. It's paid down on a set schedule over many years, with both required payments (amortization) and optional prepayments when there's extra cash. Modeling this distinction correctly is fundamental to getting the cash flow waterfall right.

---

Ready to master the case interview? Soreno provides an AI-powered mock interview platform that acts as your personal MBB-trained coach. Get instant, rubric-based feedback on structure, numeracy, communication, and more, with unlimited reps to build confidence for your private equity or consulting interviews. Start your 7-day free trial at https://soreno.ai.