Debt capacity calculator
Excel model tool to quickly check how much debt can be used in an LBO
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 are 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 whistles 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.
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.
i would like to check how it works before leaving a proper comment…