A modifiable private equity returns template with an isolated and built out section to highlight the returns to a private equity investor looking to acquire a target firm. This excel template model can be fully adjusted to suit your financial analysis needs. All historical numbers and forecast assumptions can be replaced to analyze any leveraged buyout transaction. An LBO transaction is an acquisition transaction where the acquirer borrows a substantial amount of money to purchase another company. By committing as little of their own capital as possible, private equity firms aim to achieve a high return from this transaction. However, while this is a method to increase equity returns, the high degree of financial leverage associated with an LBO greatly increases the risk of the transaction. It is important to be able to properly evaluate the return that a private equity firm will achieve with an LBO transaction. This private equity returns template is perfect for discerning the returns acquired as a result of a complex LBO transaction. This private equity returns template includes:
  • DCF analysis returning NPV and IRR
  • Levered IRR analysis by investor type
  • Sensitivity analysis
Supplemental materials included in this private equity returns template are:
  • 3 statement and operating model
  • operating scenarios
  • transaction assumptions
  • Debt and interest schedule
This private equity returns template can also assess the effects on the valuation of an LBO transaction based on the debt structure of the LBO. Use the debt schedule to input different terms, fees, and interests rates for different tranches of debt. The debt structure for an LBO may include any of 3 types of debt:
  1. Bank debt – the least expensive form of financing instrument with lower interest rates. Unfortunately, banks have many lending restrictions which may restrict a firm.
  2. High Yield Debt/Subordinated Debt – usually unsecured debt, which carries higher interest rates than bank debt. During liquidation, bank debt is also paid off before high yield debt.
  3. Mezzanine Debt – often funded by hedge funds and private equity investors, with a higher interest rate than the other forms of debt.
You can also learn how to construct an LBO financial model step-by-step with CFI's Leveraged Buyout Modeling Course!  
Reviews Add a review
No reviews yet

More From Victor Ho

Browse our top rated business templates. See All
Opportunity Cost Template
This opportunity cost template is a fun tool you can use to calculate the opportunity cost of purchase. This tool…
Purchase Order Template Word Preview Purchase Order Template (Word)
This purchase order template (word) is a document that you can use to request a purchase from a vendor. Use…
Purchase Order Template Excel Preview Purchase Order Template (Excel)
This purchase order template (excel) is a document that you can use to request a purchase from a vendor. Use…
Personal Budget Template
This personal budget template is a basic tracker for your daily, monthly, and yearly personal finances! Use this budget if…
Advanced Personal Budget Template Preview Advanced Personal Budget Template
This advanced personal budget template includes everything you need to keep track of your daily, monthly, and yearly personal finances!…
Advanced WACC Analysis Template Preview Advanced WACC Analysis Template
This advanced WACC analysis template is a comprehensive analysis used to calculate the weighted average cost of capital for a…
See All