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

Send to a friend

• linkedin
• twitter
• facebook
• 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 121

108 reviews6,628 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 (108 votes)

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

    Write a review

• Vanyo Ourouchev24(last updated: 26/04/2020 14:13)
  
• Benjamin Nyakeriga(last updated: 16/04/2020 16:11)
  
• Ethan Nittalo(last updated: 08/03/2020 16:33)
  
• Mike Abdy(last updated: 29/02/2020 23:21)
  
• Pye Ian(last updated: 16/02/2020 23:13)
  
• Bhalaji Kumar, MS, MBA(last updated: 14/02/2020 18:30)
  
• John Ng(last updated: 09/02/2020 12:40)
  
• Roderick Norman(last updated: 09/01/2020 07:51)
  
• Michael Xu52(last updated: 06/01/2020 02:11)
  

  leveraged

  buyout
• Shereef Jinadu(last updated: 21/12/2019 17:15)
  
• 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)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded

Post Comment

• 

  Michael Smith 67 1 year ago
  Downloadable Tool Useredit

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

  1arrow_drop_uparrow_drop_downReply reply

  • 

    Manager Timothée Demoures 1 year ago
    Eloquens Member

    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