Failed Tribune LBO - Financial Excel Model
Originally published: 26/04/2018 13:53
Publication number: ELQ-60867-1
View all versions & Certificate

Failed Tribune LBO - Financial Excel Model

A comprehensive, detailed example of a failed LBO model.

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.

This Best Practice includes
1 Excel Spreadsheet

Prof. Ed Bodmer offers you this Best Practice for free!

download for free

Add to bookmarks




More Best Practices from Prof. Ed Bodmer

See all

Any questions on Failed Tribune LBO - Financial Excel Model?

The user community and author are here to help. Go ahead!

4.8 / 5 (5 votes)

please wait...