How to Build a Fully Integrated LBO Model from Scratch (Advanced Walkthrough)

A pizza shop and a $2bn buyout are both financed in the same way, really: a small deposit, a large loan; and the hope that the business will make enough to service that loan. The difference is scale. When you're talking billions no-one is in any doubt. Someone's built a model that tracks every dollar of debt from the day the deal closes until the day the business is sold.

That's the LBO model and that's how a PE firm works out whether a deal can carry its debt and still deliver the return that their investors are expecting. 
This walkthrough is going to build one from the ground up, looking at the formulas and, more importantly at the logic that connects the price you pay on day one to the return you achieve at exit.

What Is An LBO Model?

A leveraged buyout is an acquisition financed predominantly by debt. The buyer (typically a PE firm) pays the full purchase price at closing, they just fund a large portion of that price with debt which ends up on the acquired company's balance sheet rather than the PE firm's. The company's own cash flow then pays the interest and repays the debt over time.

Think of it as buying a rental property. You put down 30% and take a mortgage for the balance. You don't pay the mortgage out of your own salary. The tenants' rent does. In an LBO, the acquired company is the tenant. Its cash flow pays the interest and eats into the principal. The PE firm's equity is the property. It grows in the background.

How does the loan get paid off? Simply put, one’s income finances the loan over time. The same applies to this model, but the “income” refers to the company’s future earnings.

Think of it as buying a rental property. You put down 30% and take a mortgage for the balance. You don't pay the mortgage out of your own salary. The tenants' rent does. In an LBO, the acquired company is the tenant. Its cash flow pays the interest and eats into the principal. The PE firm's equity is the property. It grows in the background.

The “leverage” is what amplifies the return. Say a firm buys a company for $150 million, funding it with $60 million of equity and $90 million of debt. Over five years, the company uses its cash flow to repay $50 million of that debt, then sells for $180 million. After paying off the remaining $40 million, the firm walks away with $140 million, or 2.3x its money (roughly an 18% annual return). 

Had the firm paid all $150 million in cash, it would have ended with about $230 million (the $180 million sale plus the $50 million in cash the business generated), which is just 1.5x, or about 9% a year. Same company, same sale price. The debt made the difference. (To keep the math simple, this ignores interest and taxes.)

An LBO is a multifaceted process, so financial professionals model it to analyze a deal. One option is the “Quick & Dirty” Model. It is the simplest way to depict an LBO. It estimates the PE returns without using a full balance sheet. 

Although easy to build, this model relies on superficial data and rough assumptions. Not every LBO model includes every detail. Not all LBO models cover every detail. A basic LBO, often called a "paper LBO" in interviews, gives a rough estimate of returns using just a few numbers: purchase price, debt, EBITDA growth, and an exit multiple. 

This method is fast, but it leaves out important factors that matter in real deals, like changes in working capital, capital spending, required debt payments, and making sure the balance sheet adds up each year.

A complete LBO model includes these missing details. It links four main parts so that every assumption changes cash, debt, and ultimately, the returns:

• The income statement
• The balance sheet
• The cash flow statement
• Debt schedules

Together, these pieces reveal whether buying a company with debt makes sense. This is why these models are crucial to PE firms. Without one, a firm has no reliable way to know if a deal will pay off or collapse under its own debt.

Steps To build A Fully Integrated LBO Model From Scratch

Knowing how to build a fully integrated LBO model is not only essential for PE firms. If you're recruiting for private equity, expect to build some version of this in a timed modeling test. Investment banking interviews lean more on walking through an LBO out loud or solving a paper LBO, but the logic underneath is identical. 

Step 1: Determine The Company’s Purchase Price

Calculating the company’s purchase price is the foundation of any LBO model. It drives how much debt a firm can raise, how much equity it needs, and whether the deal hits target returns.

The purchase price of the target company is often the company’s enterprise value at entry. This is based on a multiple of the target’s last twelve months (LTM) EBITDA (net income). Firms base this multiple on comparable companies, industry benchmarks, and the company’s own growth prospects. 

Multiply this multiple by the target’s EBITDA to get the company’s entry enterprise value.

Entry valuation = EBITDA x entry multiple

Step 2: Build The Sources And Uses Schedule

Once the purchase price is set, the firm decides how to finance it. A sources and uses schedule answers that. It shows where the money comes from and where it goes. This schedule is, essentially, the deal’s “budget.”

One key rule: sources must always equal uses. This ensures the firm uses every source of funding to its fullest potential.

Uses Table

Analysts usually build the “uses” side of the schedule first, in table form. This section captures all cash paid at close and any non-cash items that substitute for cash at close.

Uses table key takeaways:

• Purchase price is the largest use, but rarely the only one. Fees and refinancing can add a meaningful amount on top.
• Refinancing existing debt is standard because most loan agreements include change-of-control clauses that let lenders demand repayment when the company is sold.
• Transaction expenses cover the bankers, lawyers, and accountants who diligence, negotiate, and close the deal. They're paid in cash at closing, so they need funding like everything else.
• Financing fees compensate the banks that arrange and underwrite the new debt, typically quoted as a percentage of the amount raised.
• Cash to balance sheet leaves the company enough liquidity to run day to day after closing.

Sources Table

Next is the “sources” side of the schedule. This section depicts the funds for the “uses” table. Sources must cover every dollar of use, after accounting for external costs.

Sources table key takeaways:

• Revolving credit facility serves as a corporate “credit card” for the target company. It is pre-approved by a bank. This borrowed cash is used for temporary shortfalls of working capital. This could be lagging accounts receivable, inventory spikes, and more.
• Term loans A and B represent senior debt. Senior debt is the highest-ranking loan in an LBO’s capital structure. “Senior” means these loans hold first claim on cash flows and assets if the company defaults. Because these loans take priority, they are the least risky types of debt. Therefore, they carry the lowest interest rates.
  • Term loans A and B usually have the same rank. They share the same collateral and claim in bankruptcy. The main difference is how they are repaid. Term loan A is usually held by commercial banks and is paid back quickly over a shorter period. Term loan B is sold to institutional investors like CLOs, pays down only about 1% each year, and most of the principal is paid at maturity. Because lenders wait longer to get their money back, term loan B has a higher interest rate.
  • Commercial banks fund term loan A.
  • Institutional investors fund term loan B.
• Subordinated or mezzanine debt is the debt in the “mezzanine” level of the capital structure. It ranks below senior debt but above common equity in priority. Because it ranks below senior debt, it gets paid out after senior debt. This makes this type of debt riskier. It carries a higher interest rate as a result.
  • Provided by private credit/debt funds, institutional investors, and more
• Sponsor equity accounts for a smaller portion of the LBO since most of it is funded by debt.
  • Paid out last, so the riskiest layer of capital
• Rollover equity is so called because sellers “roll over” a portion of their sale proceeds into equity for the company.
• Target cash reduces the amount of sponsor equity required for an LBO.

Once this schedule is complete, it is crucial to ensure total uses = total sources. This guarantees that each source of funding is being utilized to its fullest potential. It also sets the debt and equity figures that will be carried through the rest of the model.

Step 3: Compose Pro Forma Financial Statements

With the transaction structure set, it is time to forecast the target’s financial performance. To do this, build and link pro forma financial statements: the cash flow statement, income statement, and closing balance sheet. 

The closing balance sheet is different from a regular balance sheet. This statement captures the target’s assets, liabilities, and shareholders’ equity once the deal closes.

Pro forma' means 'as if.' Pro forma statements show the company as though the deal had already closed, with its new debt, new equity, and fees reflected.

Analysts project these statements across the holding period. This is the time a PE firm “holds” the company before selling it. This period is usually five years.

The key metrics here are EBITDA and revenue growth. EBITDA growth signals more operating cash flow to pay down debt. Revenue growth shows whether the business is expanding or contracting.

Want to dive deeper into building these statements and seeing how they connect? Check out the Accounting Foundations Course by Wall Street Oasis.

Step 4: Debt And Interest Schedule

The debt and interest schedule is the backbone of the LBO model. It models every layer of debt and interest payments associated with the LBO. This schedule forecasts outstanding debt and interest expense due each year.

Before building the schedule, it helps to understand what a debt agreement involves. When a company raises debt, the borrower and the lender sign a legal agreement.

The borrowers receive capital. In exchange, the lenders receive:

1. Interest
2. Mandatory amortization (primarily for senior lenders)
3. Principal repayments on the loan’s date of maturity. 

This ties back to the concept of senior debt mentioned earlier. If a company goes bankrupt, its senior lenders are repaid first.

Start the schedule by listing all the lenders and their terms, ranked by seniority. Using the sources table above, the revolver first, then the term loans, then any senior notes and finally the subordinated or mezzanine debt.

Once seniority is set, build each debt tranche, or piece, using the same few steps. 

Steps To Build A Debt And Interest Schedule:

1. Opening balance. The debt outstanding at the start of the period. In year one this is the amount from your sources table.
2. Revolver draws and repayments. If cash after the mandatory payments would fall below your minimum cash balance, the revolver will cover the gap. When you have plenty of cash, the revolver is repaid first. In Excel, this is typically a MIN/MAX formula based on cash available.
3. Mandatory amortization. Scheduled principal payments as stipulated in the credit agreement (typically a fixed % of the original balance, around 1% per annum on a TLB and a lot more on a TLA).
4. Optional prepayments (cash sweep). Any excess cash after the mandatory payments and the minimum cash is applied to prepay debt, typically the term loans on a seniority basis. Many credit agreements will sweep a fixed percentage of the excess cash flow (e.g., 50%) and reduce that percentage as leverage falls. Bonds and mezzanine debt are generally not swept, as prepayment of those would trigger call premiums.
5. Closing balance. Opening balance + draws − mandatory amortization − optional prepayments.
6. Interest expense. Rate x balance. Floating rate loans are priced as a benchmark (e.g., SOFR) plus a spread. The average of the opening and closing balance is more accurate but creates a circular reference (interest affects cash, cash affects repayment, repayment affects interest). Using the opening balance avoids the circular reference and is the approach you'll see most often in timed modeling tests. Either approach is acceptable so long as you're consistent. Don't forget the commitment fee on any undrawn revolver, and for PIK debt you add the interest to the principal rather than paying it in cash.

Repeat this process for every debt tranche, starting with the most senior (the revolver) and ending with the most junior (subordinated or mezzanine debt). Since each tranche has its own rate and repayment terms, model them as separate rows. Combine them into a total debt and interest expense for the period.

Once built, interest expense goes on the income statement, the repayments and draws go in the financing section of the cash flow statement, and the closing balances go on the balance sheet. Amortization of the capitalized financing fees is a non-cash expense, so you add it back in cash from operations.

That completes the schedule. It gives you a period-by-period view of debt paydown and equity creation. This is one of the main ways PE firms generate returns and increase equity value in an LBO.

This completed schedule helps determine how much money the PE firm walks away with at exit.

Step 5: Exit Analysis

Now, time for one of the most exciting steps in the model: determining how much money a PE firm generated from an LBO. This step answers the question that was plaguing the firm for the holding period: “Was it all worth it?”

The exit is where the model pays off. You're estimating what the company will sell for at the end of the holding period and how much of that sale price is left for the equity holders once the debt is cleared.

Exit analysis answers that question. It estimates the company’s worth when it is finally sold. Unlike the debt and interest schedule, which tracks for the holding period, this step focuses entirely on the deal’s end.

Steps To Complete The Analysis:

1. Pick the exit year (usually three to seven years after closing).
2. Just pull the EBITDA for that year out of the operating model.
3. Multiply that by the exit multiple to get the exit enterprise value.
4. Subtract net debt at exit (i.e., debt at exit minus cash) and any exit transaction costs.
5. Subtract the in-the-money value of the management option pool: (exit share price minus strike price) multiplied by the number of options. Management will only exercise if the exit price is above the strike price, and when they do, their gain is taken directly out of the proceeds of the other shareholders.
6. What's left is exit equity value, which is split between the sponsor and any rollover holders on a basis of ownership.

Back to our example. Suppose EBITDA grows 6% a year from $50m to around $66.9m in year 5. At the same 10.0x multiple, that gives an exit enterprise value of roughly $669m. With a debt schedule of $150m of net debt at exit and management options worth $10m, exit equity value is about $509m.

Step 6: Returns Analysis

Returns analysis converts an exit price into the firm’s actual profit. Two metrics define an LBO’s success: internal rate of return (IRR) and multiple of money (MoM), also called cash-on-cash.

IRR represents the yearly return on equity invested. This is the annual growth rate needed to turn the initial investment into the final equity value. The steps to calculate IRR are:

1. Divide the exit equity value by the sponsor’s initial investment.
2. Take that number to the nth root, where “n” represents how long the holding period was.
3. Subtract 1, and you now have the IRR of the LBO.

A higher IRR is generally favored. That means capital returned faster, which lets firms reinvest sooner into new deals.

The MoM represents how many times an initial investment was multiplied. It is derived similarly to IRR. To find it:

1. Take the equity value at exit.
2. Divide the equity value by what the sponsor originally invested.

Many funds will underwrite deals to a 20% IRR. Over a five-year hold, that's roughly 2.5x your money. A 2.0x outcome over the same period would be about 15%. The targets will vary from fund to fund, strategy to strategy, and interest rate environment to interest rate environment, so treat those as rules of thumb rather than pass/fail lines.

MoM = Exit equity value/original investment
IRR = (MoM)^(1/n) - 1

This shortcut will only work where the sponsor puts in the money once and takes it out once. If there's a dividend recap or an additional equity injection at some point in between then you need to use Excel's IRR or XIRR function on the full stream of cash flows.

Multiple of money (MoM) or MOIC is the simplest metric of all: exit equity value divided by equity invested. For example, if the exit value is $509m and the initial investment is $248m, the MoM is approximately 2.05x.

IRR turns that multiple into an annual rate. With a single investment and a single exit, IRR is simply MoM^(1/n) − 1, where n is the number of years held. In this case, that's 2.05^(1/5) − 1, or about 15.5%.

While both metrics measure the same return, MoM ignores time. It shows how many times the investment multiplied by exit. On the other hand, IRR accounts for annualization. It converts that same return to an annual rate. This is why a 2.0x+ MoM over three years is much more impressive than that same MoM over seven years.

Step 7: Sensitivity Analysis, Charts, And Graphs

Once IRR and MoM are calculated, it seems we have answered the question of whether the deal worked. However, deals rarely play out exactly as modeled. That is why the final step is testing assumptions with a sensitivity analysis.

Sensitivity analysis is about looking at how the return moves when you change one or two inputs at a time. It's related to scenario analysis (where you change a number of assumptions at once to tell a coherent story, e.g. a recession scenario) but the two are not the same.

Sensitivity analysis tests how a final result shifts when one assumption changes. It is a way of challenging a model’s inputs against its outputs. It is sometimes called a what-if or simulation analysis.

The analysis usually tests how IRR changes with different variables. It is often built as a two-variable data table. The exit EV/EBITDA multiple and the exit EBITDA are the key inputs. Sometimes firms assess entry multiples against exit multiples as well. 

Each cell in the table shows the resulting IRR for that specific combination. This allows you to see a full range of outcomes rather than a single base-case IRR. From there, charts and graphs depict these outcomes in ways that go beyond tables.

A sensitivity analysis is important for an LBO model. A model that shows only one scenario can give a false sense of precision. Sensitivity analysis forces the model to reflect real-world uncertainty. It is not one “guaranteed” IRR.

Common LBO Modeling Mistakes

Modeling an LBO takes practice. While practicing, it is crucial to watch out for making these mistakes:

1. Forgetting the cash sweep: excess cash goes to repay debt in true LBOs. Models that omit optional debt paydown may throw off their entire return profile.
2. Incorrect interest calculation: average balances are more accurate but create a circularity; opening balances avoid the circularity but are less accurate. You pick one and apply it to every tranche and you note it in your assumptions.
3. Broken circularity: interest expense shapes net income. Net income shapes available cash. Available cash shapes how much debt gets repaid. That repayment resets interest expense back again. This becomes a loop. If handled incorrectly, the model may break or spit out nonsense results.
   1. Turn on iterative calculation and build a circuit breaker (a toggle cell which sets interest to zero so that you can reset the model if it starts to fill with errors).
4. Unbalanced balance sheet: this is the biggest red flag in modeling. If assets do not equal the sum of liabilities and shareholders’ equity, something is wrong. It is usually a bad link from the cash flow statement or an error in the debt schedule.
5. Double counting debt in the sources and uses: if you use enterprise value as the purchase price and also have "refinance existing debt," then you're double counting those same dollars.
6. Paying down debt with EBITDA rather than free cash flow: EBITDA doesn't take into account interest, taxes, capital expenditure, or working capital, so it overstates the rate at which debt is being paid down.
7. Hard-coded plugs (i.e., typing a number in to force the balance sheet to balance) mask the actual error and will break the next time an input changes.

Conclusion

The first build is slow. By the third you'll know where the circular reference is and why your balance sheet is off by precisely the financing fees. The mechanics are the same whether you're doing an interview test or a live deal, and once you've got them down you'll see what the model is actually telling you. Debt turns a good outcome into a good outcome and a bad outcome into a very bad one.

Returns in an LBO come from three levers: growing EBITDA, selling at a higher multiple, and paying down debt. In the 80s and 90s, debt paydown did the majority of the work. 

Today, with debt more expensive and equity checks larger, the best deals are driven almost entirely by revenue and margin growth, with deleveraging providing a very steady and predictable return on top. 

A good model will show you the contribution of each lever, and a good investor will know which of those levers they can actually control.

Whether it is your first model for an interview or fiftieth for a real deal, the mechanics stay the same. Master them, and you will understand how PE firms make money. You will also learn how leverage cuts both ways, amplifying wins and losses alike.

Want hands-on practice? The Wall Street Oasis Master LBO Modeling from Elite Pros course walks you through building a full LBO model.

Preparing for an interview? The PE Interview Questions and Answers article by Wall Street Oasis has you covered. It includes a free LBO modeling exercise to sharpen your skills.

Free Resources

To continue learning and advancing your career, check out these additional helpful WSO resources:

• Accretion Dilution Model
• Debt Schedule
• Financial Model Formatting
• How To Build A Merger Model
• Independent Variable