Leveraged Buyout Tool

Free

Free LBO model in Excel.

Based on the 2010  KKR approach to Perpetual Asset Management for $1.73bn.

High quality quick and dirty template to apply yourself.

It’s not a small model for normal people though.

  • Excel model
  • Based on real data
  • Free
  • PE quality
Free
766 happy users
Star Star Star Star
highly rated

testimonials

It’s Recommended

Javed Hussain

AVP Investments at 3to1 Capital
Rating Rating Rating Rating Rating

Your models are like a university to me. I have a prepare a few simple LBO/merger models but after looking at your simple LBO model; I felt like deleting them all. the details in your simple models are even more detailed.

Ahmed

VP of Strategy
Rating Rating Rating Rating Rating

Sir- you are a gent. Keep learning new things from you and enjoyed (can i say?) playing with your excel and learning.

Simone

PE- Healthcare
Rating Rating Rating Rating Rating

You said the model was small to you, but it's a lot for me. It's very cool you share so much. Not going to say thanks as you know

What

What is a Leveraged Buyout Tool?

An LBO model is a detailed financial tool used to assess the feasibility and potential profitability of buying a company using a mix of borrowed money (debt) and the  investor’s own funds (equity). It helps in evaluating factors like cash flow generation, debt structure, investment returns, valuation, exit strategies, and risks. The model allows investors to make informed decisions by simulating various scenarios and testing different assumptions, enabling them to plan, negotiate, and manage the process of a leveraged buyout effectively.

You may have heard about LBOs; where a massive amount of debt is used to buy a company. Sometimes it works great and the Private Equity firms make out like bandits, but other times things go pear-shaped.

What’s an LBO? Well, in nerd speak, an LBO is a financial transaction in which a company is purchased with a combination of equity and debt, such that the company’s cash flow is the collateral used to secure and repay the borrowed money.

Imagine you want to buy a toy store, but you don’t have all the money you need. An LBO is a way to buy that store using a mix of your own money (equity) and borrowed money (debt). Here’s how it works:

  1. Buyout: You find a toy store that you want to own. Instead of using only your savings, you also borrow a big part of the money you need to buy it.
  2. Using Debt: The borrowed money is like a loan. You promise to pay it back over time, usually with interest. This borrowed money is often used to cover a significant portion of the purchase price.
  3. Less of Your Money: Because you’re using borrowed money, you don’t need to put all your savings into buying the store. You invest a smaller amount of your own money, which is called equity.
  4. Hope for Profit: The idea is that the toy store will make enough money over time to pay back the borrowed money (debt) and also make a profit for you

Details

Images of the Excel LBO

Here are a few images to have a little gander at for your viewing pleasure.

Why I put out this template for free

In 2010, KKR made a go of acquiring Perpetual Asset Management for $1.73bn.

For fun to evaluate the deal I made a model to have a look.

It was on my drive not helping anyone, so I shared with you.

LBO models can get large, so this is a quality model you use for the initial validation of an opportunity.

Access

Get the Simple LBO Tool For Free

It is automatically emailed to you

 

who

Who Needs a Leveraged Buyout Tool?

Everyone in startup-related land needs to know about this topic. So whether you are a founder, investor or advisor, why not have a little play with this!

Investors

  • Valuation assessment: LBO models help estimate the potential value of a company if taken private. This provides a “floor” for the stock price, as private equity firms may step in if the price drops too low
  • Identifying takeover targets: LBO models can highlight companies that are attractive for buyouts. Investors can use this information to spot potential acquisition targets before they’re announced
  • Understanding market dynamics: LBO models offer insights into how private equity firms value companies. This knowledge can inform investment decisions and help predict market movement
  • Risk assessment: By modelling potential LBO scenarios, investors can evaluate the risk of a company being taken privateThis helps in portfolio management and risk mitigation strategies

Bankers

  • Deal structuring: LBO models are crucial for determining the optimal mix of debt and equity. They help in assessing different capital structures and their impact on returns
  • Valuation and pricing: The model helps determine a fair purchase price for the target company. It allows for scenario analysis to understand how different factors affect valuation
  • Due diligence: LBO models require detailed financial analysis, aiding in the due diligence process. They help identify key value drivers and potential areas of concern
  • Negotiation support: The model provides data-driven insights to support negotiations with sellers and lenders
    It helps in justifying offer prices and deal terms
  • Return analysis: LBO models project potential returns for equity investors under various scenarios. This is crucial for attracting investors and securing financing
  • Debt sizing and structuring: The model helps determine how much debt the company can support. It aids in designing the optimal debt structure (senior, subordinated, mezzanine, etc.)
  •  

    Operational improvement planning: LBO models incorporate assumptions about operational improvements. This helps in developing post-acquisition value creation strategies

  • Exit strategy analysis: The model projects potential exit scenarios and their impact on returns. This is crucial for planning the investment horizon and exit strategies

features

What Can the Model Do?

These are some of the features in the model.

Out of the Box LBO

It works

  • Fully operating model
  • Assumptions
  • Income statement
  • Balance sheet adjustments
  • Cash flow statement
  • Dent and amortisation schedule
  • Equity returns
  • DCF

Broad Assumptions

Flexibility in the model

  • Set 7 different debt structures
  • Financing fees
  • D&A assumptions
  • Key financing assumptions
  • Warrants etc

FAQs

Check the FAQs if you are having issues. Don’t message me if “I can’t download the file”.

Is this free?

Yes.

How do I download?

Fill in your name and email in the submission form and it will be emailed to you.

I didn't receive the email?

My (automated) system works. You’ve made a basic mistake.

  • Check you input your email accurately
  • Check your spam folder (Whitelist me if you found the email in spam)
Can I get consulting to use the file?

Yes. You can book a consulting call here:

Book a consulting call

I have feedback to improve

I’d love feedback from you!

You can reach out to me through the contact page

Contact

How do I open the file?

When you press download in an email from me, it normally saves to your Downloads folder.

So go there first to find the file.

I normally have to ZIP the file so it will work with SaaS automation systems.

So get WinZip, WinRAR, or use whatever Mac/PC offers these days. Unzip the file (Right click and press “uncompress” etc). If you don’t know how to do this, then use Google.

Once you uncompress, the ZIP file will remain, and you will see a new file (sort the download folder by date modified if confused).

I assure you that everything I provide works, so if you can’t access it, it’s a ‘you’ problem.

Can I sell / share your tools?

No.

You can share a link to this page, which would be much appreciated!

Can I share your tools on social media?

Please share the link to this page. It would be super-appreciated, but only if you like it!

If you don’t like it, then leave a comment or shoot me an email first so I can take your feedback on board first and see if I can improve!

Reading

Looking For Some Recommended Reading?

Here are some blogs you can check out related to this topic:

LBO Slides

Real examples of Investment Banking LBO slides

Read

Regression Analysis Slides

Real examples of Investment Banking Regression Analysis slides

Read

Other tools

Other Related Tools

You’re busy, so there are other great tools that I’ve made that might be of use to you. Here are some you can check out if you would like.

Investment Banking Presentations

Learn more

Accretion Dilution Tool

Learn more

Complex Charts

It's easy to make a pie chart but there are advanced charts used by consultants and bankers that are a pain to make. If you had templates you could just get your work done. The file frees you to create 9 of the most complex charts with no skill required! There are 121 sheets (Variations) to make this fool proof.

Learn more

Excel Productivity Addin

Excel plugin designed to support my financial models. Easily change the currency from $ to appear as the currency you need. Save a new version of your file (and auto rename the file v1/2/3/4), And other nerdy things which will save you hours!

Learn more

Simple pitch deck template

Simple pitch deck template with 115 slides for early stage startup founders. PowerPoint and KeyNote versions. Easy to edit and update.

Learn more

Debt Capacity Calculator Tool

Learn more

Convertible Note Calculator Tool

Learn more

Fundraise Process Manager Tool

Learn more

Post Money SAFE Calculator Tool

Learn more

Runway Calculator Tool

Learn more
social section alexander jarvis

Socials

Be Social With Me

If you want to ‘follow’ me, have another platform to discuss, or just make me feel more popular than I am, then add me.

You can always defend me when I inevitably get cancelled for being honest, lol.

 

Comments (4)

  • does this model work with a Mac well?

    Also – is interest charged as a average outstanding per year or charged at beginning balance?

    thanks

    • Hey Jordan –

      Why don’t you just check… It’s free…

      All Excel basically works in Mac too. Mac just sucks for Excel… Well if you are a banker type who does shortcuts.

      This model is for boshing out something an hour or so before a meeting. After that you do a big LBO model (Which I have but haven’t shared).

  • Hey Alex!
    I usually make models for startups and this LBO isn’t simple at all for me even though here are like 20 cells to punch in but its amazing. Thanks for throwing it away for us freefolks.

    I really want to spend money on a detailed version of LBO/Merger Model. Please do list them on your website.

    I have spent atleast a day on each one of your models.
    I’m a fan to be honest.

    • Hussain- Thanks.
      I’m discussing making more banker models with some people, or making myself etc.
      I appreciate the feedback from you!
      Do let me know what you’d like to have and I’d love to know why so I understand your needs?
      LBO/MM etc can get really large and complicated, so knowing your need helps!
      Alex

Leave a Reply

Your email address will not be published. Required fields are marked *

Leave a Reply

    Join Our Newsletter

    Get new posts delivered to your inbox
    0