• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• google+
• code

Originally published: 10/10/2016 12:19
Last version published: 09/05/2017 15:53
Publication number: ELQ-91430-3
View all versions & Certificate

Leveraged Buyout LBO Model Template

A full Leveraged Buyout LBO model template for a project to understand its different components and work with your own.

by John P. Burns
Information Technology and Services Consultant and Professional

32 reviews3,583 views|Start the discussion!|Bookmark

dcffinancelbolbo analysislbo modelleveraged buyouttemplatevaluationwacc

Description
This LBO model in excel contains the following sections:

- Transaction Structure
- Balance Sheet
- Income Statement
- Cash Flow
- Debt Repayment
- Book Depreciation
- Tax Depreciation
- Ratio Analysis
- Working Capital & Balance Sheet Assumptions
- Income Statement Assumptions and Historical Performance
- Performance Assumptions
- Asset Sales
- Capital Structure
- Income Tax Calculation
- Free Cash Flow Summary
- Discounted Cash Flow (DCF) Analysis
- Estimated Weighted Average Cost of Capital Calculation (WACC)
- Returns Calculation

=> John P. Burns

This business tool includes
1 Excel Model

John P. Burns offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

• francés(last updated: 02/10/2018 14:13)
  
• YG Park(last updated: 22/09/2018 16:05)
  
• Sandip Modha(last updated: 19/09/2018 20:41)
  
• Zohair Siddiqui ACMA-CGMA, CFA(last updated: 18/09/2018 20:33)
  
• Luciano Giraudy(last updated: 12/09/2018 16:27)
  
• Jason Rusli(last updated: 11/09/2018 08:28)
  
• JoshT(last updated: 10/09/2018 09:18)
  
• David Lee919(last updated: 09/09/2018 17:56)
  
• Paul Sibley(last updated: 04/09/2018 19:44)
  
• Alli Adetunji(last updated: 02/09/2018 23:27)
  
• Viral Bakhada(last updated: 01/09/2018 06:42)
  
• George Vitogiannis(last updated: 23/08/2018 09:41)
  
• Luis Barbarulo(last updated: 20/08/2018 00:00)
  
• Lewis Hook(last updated: 02/08/2018 12:28)
  
• Muskan Joon(last updated: 11/07/2018 17:25)
  
• Amine(last updated: 04/07/2018 14:12)
  
• Nick Kardaras(last updated: 02/07/2018 09:07)
  

  Excellent

  Very good analysis
• Paya Danesh(last updated: 10/06/2018 09:15)
  
• Jing Zhang(last updated: 30/05/2018 11:27)
  
• Victor Nekrassov(last updated: 20/05/2018 17:41)
  
• D.Fat(last updated: 16/05/2018 16:25)
  
• iowaab(last updated: 14/05/2018 18:15)
  
• Wen Kui(last updated: 07/05/2018 14:48)
  
• Gerald Strever(last updated: 05/05/2018 07:11)
  
• 雅韵 刘(last updated: 26/04/2018 08:23)
  
• Daniel Jensen787(last updated: 25/04/2018 20:22)
  
• Long Lê(last updated: 01/04/2018 10:28)
  
• Mohammed Halaseh(last updated: 12/03/2018 12:53)
  
• Middle Market(last updated: 23/02/2018 15:30)
  
• viral patel(last updated: 19/12/2017 16:32)
  

People using this tool also downloaded