Yes.
Debt Capacity Calculator Tool
Free
A debt capacity Excel model I made will calculate how much debt a company can take on depending on your top-line projections.
- Excel model
- LBO Analysis
- Senior/Subordinated Debt
- VBA Enabled
What
What is a Debt Capacity Calculator Tool?
A debt capacity calculator for an investment banking acquisition is a specialized financial tool used to assess the amount of debt that can be safely taken on to finance an acquisition.
It helps investment bankers, along with their clients (buyers or acquiring companies), understand the optimal debt level they can utilize while maintaining a stable financial position after the acquisition is completed.
who
Who Needs a Debt Capacity Calculator?
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!
Details
What Does the Tool Look Like?
Here are a few images to have a little gander at for your viewing pleasure.
Need
Why Do You Need a Debt Capacity Calculator?
-
1
Quick Analysis
- This is a simple tool
- Quickly do an analysis before spending more time
-
2
Debt Levels
- See how much senior and subordinated debt a firm can take
- Set interest rates and proportional contribution
- Set whether there is a cash sweep
- Senior debt amortisation
-
3
Simple Assumptions
- P&L to cash flow with basic assumptions
- Two approaches with 1/ constant, and 2/ growth assumptions
- Hit a big button to run the VBA analysis
features
What Can the Model Do?
These are some of the features in the model.
Input Assumptions
The model is simple
- Input debt
- Set P&L
- Other basic assumptions
Do Analysis
See the results
- 2 model approaches
- Hit a button and VBA does the analysis
- 2 large outcomes
Need
Why Is My Tool Worth Getting
-
1
I Make Cool Things (and am capable)
- There is a lot of blah around by people who aren’t terribly good at Excel/PowerPoint etc
- You’ll see the attention to detail and actual thought put into what I gift you (so you aren’t wasting your time)
-
2
My Free Tools Are Better Than What Some Charge For
- I only made tools because I couldn’t find anything I would use myself
- Even if you don’t ‘actually need the tool’, the point is to teach you concepts you can apply
-
3
I Don’t Have a Hardcore Marketing Funnel
- I make tools to actually help founders
- You aren’t going to be hounded with emails to get you to buy things
- Whilst I do sell some stuff, seeing the quality I give for free is way better marketing than using fancy words to convince you
video time
Watch a Video On the Tool
There is no video yet.
read more
Read the Full Blog
This is a pretty page I have made so downloading tools is cleaner and simpler for you. I’ve moved blog details to blog(s). If you would like to read more, click on!
Investment Banking Presentations
Learn moreProfessional Cap Table Model
The most detailed Excel model to to track financing rounds that you can buy on the internet so you know who owns what of your company. The tool is also great for lawyers to manage clients as it has the functionality to track all the complex changes you need to make and be auditable.
Learn moreEnterprise SaaS Financial Model
You're a complex enterprise SaaS startup with a long and complex sales process with multiple fee streams which is impossible to model! You might have enterprise, consumer and SME customers (Don't need to do all 3 but they are coded). You've tried to find a template and nothing exists, and for good reason (who would spend the time to make a template like this?).
Learn moreEcommerce Financial Model
For ecommerce startups that sell physical goods such as fashion, food, supplements. Ship from your own warehouse. This was originally based on a fast fashion ecommerce startup I invested in. It's not a marketplace model.
Learn moreAccretion Dilution Tool
Learn moreBefore and After Financial Model Tool
Learn moreBoard Meeting Presentation Template
Learn moreCap Table Tool
Learn moreChart Rebase Tool
Learn moreConvertible Note Calculator Tool
Learn moreAccess
Get the Debt Capacity Calculator Tool For Free
Fill in your details and it will be emailed to you.
I’m not sketchy, so here is everything you need to know just in case!
- It is automatically emailed to you!
- I’ll send you some emails about startup/investing after
- You can unsubscribe whenever you want
- Your data is never sold! I’m not organised to even do that lol
- You agree to all T&C legal stuff (to cover my ass)
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!
Reading
Looking For Some Recommended Reading?
Here are some blogs you can check out related to this topic:
Comments (2)
-
-
Hi –
This is built on WordPress, but I custom-built everything from scratch.
I highly recommend just starting and writing before you get fancy. Blogging is a commitment so you want to see you commit first. It’s so easy to be distracted with tech, but it’s an excuse to not write!
Don’t be fancy, just start writing every day!
Use WordPress and buy a theme for about $59. Use shared hosting as it’s the cheapest. I wrote this a long time ago to explain how to start… https://www.alexanderjarvis.com/complete-startup-guide-to-start-a-blog-and-begin-content-marketing/
Alexander
Hi would yοu mind sharing whiⅽh blog platform you’re working
with? I’m going to start my own blog soоn but I’m having a difficult
time selecting between BlogEngine/Wordpress/Β2evolution ɑnd Drupal.
The reason I ask іs because your layout seems different
then most blogs and I’m looking for something unique.
P.S Sorry for being off-tоpic but Ι had to ask!