Chapters Model with Leveraged Buyout LBO Analysis
Originally published: 06/10/2016 11:42
Last version published: 30/03/2017 09:49
Publication number: ELQ-31171-3
View all versions & Certificate

Chapters Model with Leveraged Buyout LBO Analysis

A full financial model to understand the mechanics of an organisation using Valuation, LBO, & Financial Reports

This model lacks synergies from the LBO, however it includes projections, debt schedules, working capital schedules, depreciation schedules as well as a model for leverage buyouts and valuation.

Many comments do exist explaining major assumptions on how the numbers have been derived. I encourage you to play along with those numbers so that you can understand the relationships in the model work for valuation purposes.


While the numbers look "good" (valuations are in the 20's and IDG:Indigo is trading at around $19) the information within the model has no warranty as a strictly academic exercise only. t would be risky (as well as foolish and reckless) to trade on this information (beyond the standard business risk).

I am not accountable if the user decides to use the model for trading or other investment decisions. Do consult a qualified financial adviser before you make any investment decisions.

Information for this model is based on the 2009 Chapters / Indigo Annual Report.

Do note that:

The spreadsheet contains circular references in order to calculate exact insterest expense itiretively (using real cash gains from reduced interest expense to further reduce interest expense). This can be done in Excel if you wish to allow circular references, by changing your settings.

- Joshua Wong,, 2009

This Best Practice includes
1 Excel Model, FY_09_Indigo_Annual_Report

Joshua Wong offers you this Best Practice for free!

download for free

Add to bookmarks


4.7 / 5 (23 votes)

please wait...