Last version published: 02/02/2018 14:49
Publication number: ELQ-57262-6
View all versions & Certificate
Merger & LBO Model Valuation Excel
This LBO model in excel analyzes the value of equity and the firm in a leveraged buyout operation.
Prof. Aswath Damodaran offers you this Best Practice for free!
download for free
Add to bookmarks
This LBO model will enable you to make a decision on wether your merger & Leveraged Buyout (LBO) has to be accepted, from the equity and other investors point of view by giving the following output data:
- Present Value (PV) of Cash Flows (CF) vs Initial Investment for Equity Investors and All Investors
- Cashflow to Equity Investors (Average Free Cash Flow to Equity (FCFE), Maximum FCFE, Minimum FCFE, Standard Deviation of FCFE
- Leverage (Debt/Equity Ratio before LBO, Debt/Equity after LBO, Debt/Equity Ratio in year 5, Debt/Equity Ratio in year 10)
- Beta (Beta before LBO, Beta after LBO, Beta in year 10)
4.8 / 5 (148 votes)
Write a review
People using this Best Practice also downloaded
Value of Control in a Firm - Excel ModelThis Excel model analyzes the value of control in a firm.1,457add_shopping_cart
Merger Synergy Valuation Excel ModelThis Excel Model estimates the value of synergy in a merger.2,815add_shopping_cart
Free Cash Flow for the Firm (FCFF) Valuation Excel ModelAn Excel Model to value firms with operating income that is either positive or can be normalized to be positive.1,734add_shopping_cart
Discounted Cash Flow (DCF) Excel ModelThis DCF Excel Model provides a rough guide to which discounted cash flow model may be best suited to your firm.1,764add_shopping_cart
Dividend Discount ModelA complete dividend discount model that can do stable growth, 2-stage or 3-stage valuation.3,346add_shopping_cart
FCFF (Free Cash Flow for the Firm) Excel Model with exposure to country riskAn Excel FCFF Model allowing the user to enter a measure of company exposure to country risk when making a valuation664add_shopping_cart
FCFE (Free Cash Flow to Equity) Valuation ModelA complete FCFE valuation model that allows you to capital R&D and deal with options in the context of a valuation model1,944add_shopping_cart
High Growth Firms Valuation ModelValue tough-to-value firms, with negative earnings, high growth in revenues and few comparables548add_shopping_cart
Simple FCFF Model (Free Cash Flow for the Firm)A complete FCFF model that allows for changing margins and has default assumptions built in450add_shopping_cart
Valuation of PremiumsA model to value the premium you should pay for growth in either an intrinsic valuation or a relative valuation.207add_shopping_cart
Black-Scholes converted for Binomial TreeConverts the standard deviation input in the Black-Scholes model to up and down movements in the binomial tree.2,941add_shopping_cart
Dividend Adjusted Model to value Long Term OptionsA dividend-adjusted model for valuing long term options.330add_shopping_cart
Any questions on Merger & LBO Model Valuation Excel?
The user community and author are here to help. Go ahead!