Latest posts by Alexander Jarvis (see all)
- CAP TABLE #14: The preference shares sheets – From Series A to I – of the cap table - November 16, 2017
- CAP TABLE #13: The convertible notes and warrants sheet of the cap table - November 16, 2017
- CAP TABLE #12: The Common sheet of the cap table - November 16, 2017
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
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.
Download the debt capacity calculator
Click on the picture on the right to get it ->