Leveraged Buyout

Model Overview

• AI account grouped 1 page Financial Statement
• 2 year historical and 5 year forecast

• Auto calculated Pro-forma balance sheet after Sources and Uses

• Auto calculated forecast IRR

Overall Structure of Leveraged Buyout Model

• Most pages from are displayed in the same structure, from left to right are: Account name → Actual financials → Forecasted Financials

• Some financials are hidden by default, click “+” on the top to reveal.

• Input/adjustable cells are displayed in Blue Font with a Blue Background.

Main Features

Transaction Assumptions - Starting Point

• Input key terms and conditions assumptions in the Blue Cells, changes will be reflected in the Pro-forma Balance Sheet and Operating Model.

• Model Check
• Conduct sanity check by ensuring all key areas of the model are “PASS”. Move on to Operating model to make adjustment for Failed items.

Operating Model

• This is a comprehensive detail monthly financial breakdown, include 2-year historical and 5-year forecast data. Main sections include:
• AI account grouped 1 page Financial Statement



• Working Capital Schedule and CAPEX and D&A Schedule



• Debt Schedule, Debt Covenants, and Returns

• Forecast assumption adjustment
• The model has some preset forecast assumptions. If you want to change them, select a different forecast method from the drop-down, and don’t forget to update the corresponding figure in column D.

Model Summary

• Assumption Summary
• Automated summary of all assumptions made in the model.

• Annual Summary
• Annual summary of financials, key metrics, and returns for the whole timeline.

• Next 12-months Summary
• Summary of financials, key metrics, and returns for the next 12-months.