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

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 104

88 reviews5,096 views|2 comments|Bookmark

financevaluationleveraged buyoutdcfwacclbotemplatelbo analysislbo model

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

• Nadica Micoska(last updated: 15/08/2019 17:03)
  
• Alexandros Piperakis(last updated: 13/08/2019 08:22)
  
• Frances Jian(last updated: 09/08/2019 09:35)
  
• Haben Mehari(last updated: 31/07/2019 07:12)
  
• Ricardo Mantovani Assis(last updated: 26/07/2019 11:53)
  

  Excellent model

  Excellent model
• Anshu Arya(last updated: 22/07/2019 19:19)
  
• NAM NGUYEN TAN(last updated: 05/07/2019 04:13)
  
• Carlos Catanho(last updated: 27/06/2019 15:13)
  
• seungjong Kim(last updated: 26/06/2019 08:49)
  
• David Ciantar(last updated: 25/06/2019 23:27)
  
• Alok kumar16(last updated: 24/06/2019 17:08)
  
• Mphaso(last updated: 18/06/2019 11:55)
  
• Thomas Juma(last updated: 11/06/2019 09:01)
  
• Ravi Goel(last updated: 01/06/2019 07:37)
  
• Abdullah Halludba(last updated: 11/05/2019 19:58)
  
• Yves-Samuel ASSOUMOU(last updated: 06/05/2019 16:31)
  
• 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)
  

People using this tool also downloaded

Post Comment

• 

  Michael Smith 67 6 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 5 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