Last version published: 16/03/2018 09:18
Publication number: ELQ-60823-2
View all versions & Certificate
Debt Capacity Calculator Excel Model
Learn how to compute Debt Capacity
As an analyst, corporate acquirer, or somebody who works in Mergers & Acquisitions or Private Equity, you''ll think about debt capacity after looking at a possible future LBO deal flow. Obviously it's possible to build your own big LBO model but this is quicker and smarter.
The debt capacity calculator is super handy for getting a fast and rough overview to organise deal opportunities.
This was made so that you can get a rough view of a company's debt capacity with only a couple of estimations in a short amount of time. You're able to quickly read a profit and loss statement, fill in a couple of figures and there you have your model complete.
I didn't think there was a lot of point in writing a step-by-step guide on how to use this, because you'll either know how to use it or not.
If you're on this page you're probably a VC or a founder so this is a Pareto model I've made. You're welcome to download and mess around on it- hopefully you'll learn something from it!
I made these models ages ago and I don't use them at the minute so I'm putting them on the web for someone else to use, hoping they'll be useful to somebody!
This business tool includes
1 Debt Capacity Excel Calculator
Acquire business license for $9.00
Add to cart
Add to bookmarks
- No review yet!
People using this tool also downloaded
Maintenance ROI Calculator: Cost Justification SpreadsheetExcel workbook to help you calculate Maintenance ROI and lay out Cost Justifications.calculatorexcelspreadsheetsworkbookmaintenance roicost justifications255 remove_red_eye
Pump Efficiency Calculation ToolCalculation tool to work out the energy efficiency and performance of water pumping facilities.calculatorexcelspreadsheetengineeringcalculationspump efficiency30 remove_red_eye
E-Feeder & Cable Calculator SpreadsheetCalculator in Excel to help you work out E-Feeder & Cablecalculatorexcelengineeringspreadsheetselectrical engineeringe-feedercable97 remove_red_eye
Bus Bar Size and Voltage Drop Calculation ToolThis tool can be used for calculating the size and voltage drop for bus bar.calculatorexcelspreadsheetengineeringbus barsizevoltageelectrical345 remove_red_eye
Fault Current Calculation SpreadsheetMS Excel Spreadsheet helping you to easily calculate fault current.calculatorexcelspreadsheetengineeringcalculationfault current160 remove_red_eyefreeby John Sokolik
How to Calculate Minimum Hourly Rate For Service Providers + PackagesCalculator in Excel and explanatory video demonstrating how much you should charge for client work.businesscalculatorexcelhow much should i chargeminimum hourly rate79 remove_red_eye
Sources and Use & Runway Excel CalculatorHelping you work out your runway and how much investment you need to raise.investmenttoolstartupentrepreneurshipcalculatorchartsexcelfounderrunwaysources and use45 remove_red_eye$9.00by Alexander Jarvis
Simple Excel Retirement Savings Plan CalculatorTool & Video showing you how to create a simple retirement savings plan.toolcalculatorexcelretirementmoneysavingssavings plansave20 remove_red_eye
Labour Cost Calculation Excel TemplateSample Labour Cost Calculator in Excel. Created for catering but can be adapted for use.profitabilitycalculatorexcelcateringfailtelabour costslabor costscalculate385 remove_red_eye
Co-Founder Equity Split TemplateSpreadsheet containing 5 calculators and a box that takes the average of everything among all 5.equitycalculatorexcelspreadsheetco-founderssplit154 remove_red_eyefreeby Al Bsharah
Any questions on Debt Capacity Calculator Excel Model?
The user community and author are here to help. Go ahead!