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

Failed Tribune LBO - Financial Excel Model

A comprehensive, detailed example of a failed LBO 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.

This business tool includes
1 Excel Spreadsheet

Prof. Ed Bodmer offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Prof. Ed Bodmer

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Failed Tribune LBO - Financial Excel Model?

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

please wait...