LBO model - Leveraged Buyout Analysis
Originally published: 19/09/2016 15:26
Last version published: 21/09/2018 13:35
Publication number: ELQ-22893-12
View all versions & Certificate

LBO model - Leveraged Buyout Analysis

A step by step LBO model tutorial. It is easy to use and we provide support if needed. Have fun modeling!

Please download this easy to use step by step LBO model tutorial and make assumptions for your specific business.

What is a leveraged buyout (LBO)? It is the acquirement of a company, using a large amount of borrowed money (be it either bonds or loans), that then provides the funds needed to pay for the price of the company.

The buyer goes through financial information and conducts an analysis in order to find the implied valuation range given a particular target in a potential LBO sale, that ultimately depends on receiving acceptable returns.

This LBO model template is all you need, it saves time (don't reinvent the wheel...), and it works! It includes a detailed step-by-step description and is made in 4-steps.


- Cover
- Input
- LBO Model
- Case Selector
- Credit Statistics
- Notes

If any questions? Ask us via Private Message here: or the discussion feed below, and we will do our best to help.

Of course, feel free to leave a review and a rating if you have appreciated the LBO model!

- The Business Valuation Team

You can also visit our website

You'll also find a few other models and tutorials we have put together on our Eloquens Channel here:

This Best Practice includes
1 LBO Excel Model, 1 Online Methodology

Acquire business license for $9.00

Add to cart

Add to bookmarks


Further information

This LBO model can be used by CFOs, Students, Teachers, Business controllers, M&A analysts, Private Equity analysts etc. The model is easy to use, has a hiqh flexibility and gets the job done.


keyboard_arrow_downShow all

People using this Best Practice also downloaded


Discussion feed for LBO Model - Leveraged Buyout Analysis

The user community and author are here to help. Go ahead!

  • Jeet Parekh
    Getting Circular reference. Is it correct or some mistake in the model?
    1arrow_drop_uparrow_drop_downReply reply
    • Patrik Johansson
      Dear Jeet many thanks for question. You have to activate "iterative calculation" in ordet to get the LBO model to work properly. If this is not done, and if the model would not use it, you could not do a proper LBO model. So it is really not an error, it is needed. Please let me know if you have more questions.
      1arrow_drop_uparrow_drop_downReply reply
    • City Big 61
      when I try to download the .xls file nothing happens. thoughts? thanks,
      1arrow_drop_uparrow_drop_downReply reply
      • Manager Timothée Demoures
        Hi City Big 61,

        Thank you for your technical question and the issue raised on downloading the file. The Eloquens Support Team will be contacting you by email shortly so that we can understand what may have happened in your specific case.

        Best regards,
        The Eloquens Team
        1arrow_drop_uparrow_drop_downReply reply
        • Manager Timothée Demoures
          * (Issue Solved) *

          FYI download is not possible via the "Microsoft Edge" Browser for now (March 2017), using Internet Explorer is the best alternative :)

          The Eloquens Team
          2arrow_drop_uparrow_drop_downReply reply
      • Anthony Paget628
        I don't know what I am doing wrong (as I surely must), but I cannot reconcile the Free Cash Flow Available for Debt with the arithmetic of EBITDA less the estimated Expenses (Depreciation, Interest Expenses, Taxes, Capex & Increase/Decrease in NWC).

        IN 2018, EBITDA of 3,1 minus Expenses of 1.7 (0.2 + 0,5 + 0,7 + 0,2 + 0,1) should result in a Free Cash Flow Available for debt of 1,4 rather than 1,1.

        Where have I gone wrong?
        1arrow_drop_uparrow_drop_downReply reply
        • Patrik Johansson
          hi and thanks for reaching out, can you please send me the excel to my email and I can check? contact(@)
          arrow_drop_uparrow_drop_downReply reply
        • susie0219
          i still cant download the excel..
          1arrow_drop_uparrow_drop_downReply reply

          4.7 / 5 (331 votes)

          please wait...