TL;DR: a debt capacity excel model I made which will calculate how much debt a company can take on depending on your top line projections
If you a corporate acquirer, or working in Private Equity / M&A, you will look at potential LBO (leveraged buyout) deal flow and wonder about debt capacity as a matter of course. Sure, you can (and eventually will) build a large, standard LBO model (You’re probably an analyst right, and it’s your job to churn these out?), but do you want to miss Friday night doing triage, or do you want to be smarter?
Wouldn’t it be cool to pull out a filing and a broker note during a meeting, type in 10 cells and magically come out with an initial impression if a deal might work?
It’s very useful to have some models to hand to triage deal opportunities and get a quick and dirty view. Meet the debt capacity calculator.
I built this for fun as a way to quickly get a sense of the debt capacity of a company with only a few assumptions. You can rapidly read a P&L, insert a couple of actuals and forecast assumptions and boom- behold a beautiful model with the numbers you need.
When I built it I was going through a phase of wanting to pimp out excel (I clearly hadn’t discovered coding). There’s a whole lot of bells and whistled built in, particularly around formatting. Yes, they’re totally pointless at the end of the day, but it’s really cool and so pretty!
I’m not going to write a ‘how to use’ guide on this. You either know what it’s for, the inputs and variables etc, or not.
If you’re reading my blog, it’s more likely that you are a VC or a founder. So here’s an example of a Pareto model. Download, have a play and see what learnings you can pick up to make some cool models. Geek on!
I have a bunch of models I made for fun years ago I’m not using presently and hope they will be beneficial to others, so I’m putting them out.
Preview of the debt capacity calculator
Usage notes on the debt capacity calculator
To use it you need to have the usual Excel add-ins:
- Analysis TookPal
- Solver Add-in
Also, when prompted you need to allow macros.