Last version published: 10/07/2018 20:17
Publication number: ELQ-99789-4
View all versions & Certificate
Generic LBO (Leveraged Buyout) Excel Model Template
General LBO model with return calculations and integrated financial statements
Acquire business license for $49.50
Add to cart
Add to bookmarks
To model IRR returns and valuation for a leveraged buy-out (LBO) transaction using a mix of senior debt, deferred consideration and equity
The user has some basic understanding of LBOs
The user has enough understanding of the business to enter sales, costs, working capital, capex and transaction assumptions
The user has a decent understanding of accounting
The transaction needs the option of using senior debt and/or deferred income (but doesn't have to)
Model can be used just for modelling a valuation and cash flows without using the transaction assumptions
When junior debt other than deferred income is required
When there are more than three sales divisions
If the user requires more than one type of depreciation rate for assets
When the user wishes to model intangibles other than goodwill (arising on transaction)
If the user requires more than one type of working capital assumptions for each of debtors, creditors and stock
Whilst the tax calculations can be tailored and updated corporation tax is automatically paid 9 months and 1 day after the previous year end (based on UK tax)
- No review yet!
People using this tool also downloaded
Generic forecast financial Excel Model TemplateGeneric forecasting model including valuation calculations24 remove_red_eye$29.00by ModellingGuy
Personal budget Excel ModelPersonal budget tool for tracking spending, setting budgets and analysing spending habits13 remove_red_eye
Basic CRM system Excel ModelSimple CRM system for tracking your team/sales contacts and leadsNew!
WACC (Weighted Average Cost of Capital) Excel CalculatorWACC calculation template to help the user think about all of the components of their WACC calculation11 remove_red_eye
Free UK stamp duty land tax calculator Excel ModelThis flexible tool calculates UK stamp duty land tax charged on the purchase of your home or on second properties.New!
Any questions on Generic LBO (Leveraged Buyout) Excel Model Template?
The user community and author are here to help. Go ahead!