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

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

61 reviews3,626 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

• 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)
  
• Michael Stevens454(last updated: 14/11/2018 11:58)
  
• Christopher Holden(last updated: 13/11/2018 23:19)
  
• SS SS(last updated: 13/11/2018 16:06)
  
• Sam Bull(last updated: 12/11/2018 11:41)
  
• Kevin Samuel(last updated: 12/11/2018 04:13)
  
• Suren Melikyan(last updated: 09/11/2018 10:07)
  
• Brett Liu(last updated: 27/10/2018 20:46)
  
• Dennis Maxfield(last updated: 25/10/2018 20:06)
  
• Luthfi Septiandy(last updated: 23/10/2018 01:06)
  
• Tubagus Naufal(last updated: 20/10/2018 08:11)
  
• francés(last updated: 02/10/2018 14:13)
  

People using this tool also downloaded

Post Comment

• 

  Michael Smith 67 4 days 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 14 hours 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