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

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 ProfessionalFollow 94

72 reviews4,134 views|2 comments|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

• Pham Sang(last updated: 19/04/2019 13:44)
  
• Zaheer U Din(last updated: 19/04/2019 06:05)
  
• Chinedum Uguru, MBA(last updated: 17/04/2019 05:04)
  
• Stephen Romanoff(last updated: 16/04/2019 22:11)
  
• VAIBHAV SINHA(last updated: 09/04/2019 08:26)
  
• Rohit Chopra998(last updated: 03/04/2019 12:27)
  
• Juan Hinojosa Cortina(last updated: 02/04/2019 17:01)
  
• 상철 한(last updated: 28/03/2019 03:20)
  
• Dan Fordyce(last updated: 07/03/2019 21:30)
  
• detroit2nyc(last updated: 05/03/2019 12:17)
  
• Gabriel Mungai(last updated: 26/02/2019 09:47)
  
• H.Hakan ÇETİN(last updated: 16/02/2019 16:09)
  
• Michael Smith 67(last updated: 15/02/2019 14:26)
  
• Amir Ganic(last updated: 07/02/2019 22:48)
  
• Michelle Clement(last updated: 24/01/2019 18:45)
  
• Steve Cobb - CPA, CVA, CMAP, CBI(last updated: 21/01/2019 19:55)
  
• Arco de Jonge(last updated: 20/01/2019 11:02)
  
• Leo Mooren RA(last updated: 18/01/2019 16:02)
  
• André Da Mata(last updated: 14/01/2019 10:12)
  
• Vu Pham(last updated: 08/01/2019 14:08)
  
• Jeff Nixon(last updated: 06/01/2019 16:30)
  
• Ahmad Ahmadabadi(last updated: 05/01/2019 06:17)
  
• Sean Spitzer(last updated: 31/12/2018 17:37)
  
• NC(last updated: 29/12/2018 21:10)
  
• Nox Mlalazi CA(SA), CFA level 3(last updated: 24/12/2018 13:29)
  
• Chet Lo(last updated: 22/12/2018 07:41)
  
• Châu Lê(last updated: 02/12/2018 10:57)
  
• Alena Panasenko(last updated: 19/11/2018 13:27)
  
• jayblue(last updated: 19/11/2018 08:41)
  
• Jim Aldrich(last updated: 15/11/2018 14:40)
  

People using this tool also downloaded

Post Comment

• 

  Michael Smith 67 2 months ago
  Tool Useredit

  Is there an instruction file on the best way to fill out the data?

  1arrow_drop_uparrow_drop_downReply reply

  • 

    Eloquens Team 2 months ago
    Eloquens Authorschool

    Hi Michael,
    
    Thanks for your question. According to our research, it does not seem like John P. Burns provided an instruction file to how best fill in and use his model. On the other hand, you can try to reach out to him via private message here: https://www.eloquens.com/channel/john-p-burns
    
    Hope this helps!
    Best,
    The Eloquens Team

    arrow_drop_uparrow_drop_downReply reply