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

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 113

98 reviews5,905 views|2 comments|Bookmark download for free

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 Best Practice includes
1 Excel Model

John P. Burns offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

• • 
    4.7 / 5 (98 votes)

    • 76%
    • 18%
    • 5%
    • -
    • 1%
  • Rate this Downloadable Tool
    

    Write a review

• Mirza(last updated: 25/11/2019 06:54)
  
• Tyler West(last updated: 29/10/2019 13:18)
  
• hardik gori(last updated: 20/10/2019 08:41)
  
• Agung Santoso(last updated: 08/10/2019 07:59)
  
• Rin Ichise(last updated: 21/09/2019 09:34)
  
• Sharmila Santharasagaran(last updated: 17/09/2019 05:00)
  
• Spotify Riga(last updated: 15/09/2019 09:58)
  
• Peter Clarke(last updated: 13/09/2019 14:50)
  
• 建工 周(last updated: 06/09/2019 08:21)
  
• Ali Syahbana N. Siregar(last updated: 06/09/2019 06:37)
  
• 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)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded

Post Comment

• 

  Michael Smith 67 9 months ago
  Downloadable Tool Useredit

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

  1arrow_drop_uparrow_drop_downReply reply

  • 

    Eloquens Team 9 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