LBO Financial Model Template (Detailed)

Description
A comprehensive LBO (Leveraged buyout) financial model to analyse investor returns (IRR and Investment Multiple) over a period of 5 year time period as a sample case.

1. A working quarterly (each year's column can be opened to view the quarters, as shown in images) LBO model to calculate purchase price, IRR and multiple for an investment into entertainment industry (sample case).
2. In-depth financial projections based on multiple macro factors as well as company related factors.
3. Projected financial statements. The same template can be used for any other industry/company.
4. Debt Schedule for LBO related payouts as well as scheduling for short term financing needs as per yearly cash deficit.
5. A detailed summary sheet for changing inputs as per requirements and quick results on returns along with trend analysis of key financials.

It can be used as a template by any mid-size private equity firm to quickly analyse acquisitions in terms of arriving a purchase price and IRR calculations. The model is clean, simple and easily customizable. It provides both annual as well as quarterly numbers.

Please let me know if you need specific modifications in the model or want the same for any other industry. I can also provide presentation templates for these models. You may reach me at on my channel here: https://www.eloquens.com/channel/anuj-verma