Yes.
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
testimonials
It’s Recommended
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:
- 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.
- 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.
- 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.
- 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!
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”.
Fill in your name and email in the submission form and it will be emailed to you.
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)
Yes. You can book a consulting call here:
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.
No.
You can share a link to this page, which would be much appreciated!
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!
Investment Banking Presentations
Learn moreAccretion Dilution Tool
Learn moreComplex 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 moreExcel 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 moreSimple 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 moreDebt Capacity Calculator Tool
Learn moreConvertible Note Calculator Tool
Learn moreFundraise Process Manager Tool
Learn morePost Money SAFE Calculator Tool
Learn moreRunway Calculator Tool
Learn moreComments (4)
-
-
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
-
does this model work with a Mac well?
Also – is interest charged as a average outstanding per year or charged at beginning balance?
thanks