Failed Tribune LBO - Financial Excel Model

Description
This is a comprehensive, detailed example of a failed LBO model from the company Tribune.

This tool includes the following tabs:

- Sources and Uses
- Operating Assumptions
- Projections
- Total Debt Graph
- Debt Balance Graph
- Assumption Graph
- Scenario
- Forecast
- Operating Analysis
- Historic Stock Price
- Stock Prices
- Income Statement
- Balance Sheet
- Cash Flow
- Pro Forma Capitalisation
- Industry

The Tribune LBO model that was made just before the financial crisis of 2008 demonstrates real (and absurd) assumptions and transaction structuring. Advisors to the transaction assumed that EBITDA would continue to increase, despite the danger of losing advertising revenues from newspaper sales. This model shows the actual EBITDA compared to the forecasts made in the transaction. It can also be used to evaluate pricing of different debt issues and break-even analysis.