• 
• 
• 
• 
• 
• 
• 
• 
• 
• 

Send to a friend

• linkedin
• twitter
• facebook
• code

Originally published: 28/06/2016 14:43
Last version published: 30/03/2017 09:41
Publication number: ELQ-65533-2
View all versions & Certificate

Leveraged Buyout LBO Model - DCF

A comprehensive LBO model in excel of business acquisition

by Amit Tandon
Excel & VBA, Promoter - ExcelAnytime.comFollow 172

43 reviews3,505 views|2 comments|Bookmark download for free

acquisitionbusinessfinanceleveraged buyoutirrcash flowsdcfcapmlbo analysislbo model

Description

The LBO model is with DCF Analysis, IRR, WACC, CAPM, Ratio Analysis, 10-Year Projections of Financial Statements, Cash Flows, ....

A leveraged buyout (LBO) is an acquisition of a company or a segment of a company funded mostly with debt. A financial buyer (e.g. private equity fund) invests a small amount of equity (relative to the total purchase price) and uses leverage (debt or other non-equity sources of financing) to fund the remainder of the consideration paid to the seller.

Note: You are welcome to report any errors or any suggestion for improvement. I will earnestly consider all your valuable inputs.

This Best Practice includes
1 Excel Model File

Amit Tandon offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews

• • 
    4.7 / 5 (43 votes)

    • 77%
    • 19%
    • 2%
    • 2%
    • -
  • Rate this Downloadable Tool
    

    Write a review

• Vanyo Ourouchev24(last updated: 01/07/2020 06:23)
  
• Vasile Popovici the Excel guru(last updated: 21/06/2020 21:30)
  

  Nice dashboard

  I enjoy working with this dashboard.
• Benjamin Nyakeriga(last updated: 16/04/2020 16:09)
  
• vikram j(last updated: 22/02/2020 18:42)
  
• Oluwatobi Emmanuel(last updated: 11/02/2020 19:06)
  
• 沛 刘(last updated: 06/12/2019 12:02)
  
• Jill Sinclair(last updated: 04/12/2019 15:00)
  
• Som Halder(last updated: 20/10/2019 20:21)
  
• Agung Santoso(last updated: 08/10/2019 07:55)
  
• Wei ZHANG777(last updated: 27/08/2019 22:18)
  
• Tram Phan(last updated: 08/04/2019 13:13)
  
• Norbert Labeja MBA,CFE, ACCA(last updated: 27/03/2019 10:04)
  
• VICTORIA933(last updated: 17/03/2019 10:20)
  

  Excellent

  Good and thorough recap!
• Anas Laghezali(last updated: 01/03/2019 10:54)
  
• Yashraj Pandey(last updated: 23/02/2019 18:06)
  
• Kim Jichang(last updated: 15/02/2019 02:03)
  
• Khaya Maloney(last updated: 02/02/2019 12:51)
  
• Paula Hembrey(last updated: 31/01/2019 19:36)
  
• Ahmed El-Saba, Ph.D(last updated: 15/01/2019 06:50)
  
• Sumit Barua, CFA (ICFAI), PMP(last updated: 08/01/2019 16:34)
  
• Nurul Hai(last updated: 01/01/2019 17:53)
  
• Calvin Chen(last updated: 22/11/2018 08:17)
  
• Suren Melikyan(last updated: 09/11/2018 10:07)
  
• Ing Fernando Hidalgo(last updated: 08/11/2018 22:54)
  
• Brett Liu(last updated: 27/10/2018 20:47)
  
• Amit Kumar671(last updated: 01/10/2018 08:12)
  
• Jayruc1(last updated: 21/09/2018 09:22)
  
• WILLY CAMPOS(last updated: 07/09/2018 17:19)
  
• Eiad Al Saba(last updated: 06/09/2018 07:07)
  
• Mahesh Tajane(last updated: 02/09/2018 13:32)
  

keyboard_arrow_downShow all

People using this Best Practice also downloaded

Post Comment

• 

  VICTORIA933 1 year ago
  Downloadable Tool Useredit

  What is the rationale of having cash minimum? How does this affect the model?

  arrow_drop_uparrow_drop_downReply reply
• 

  VICTORIA933 1 year ago
  Downloadable Tool Useredit

  Can you explain to me the goodwill / bargain purchase calculations from Cell C43 - Cell C53 in the 'Input' tab?

  arrow_drop_uparrow_drop_downReply reply