excel-lbo-modeler

Builds comprehensive LBO models for private equity transactions using industry-standard structures and formulas.

• Creates 6-sheet LBO models for buyouts
• Includes transaction, financing, and returns analysis
• Follows standard debt and covenant structures
• Calculates IRR, MoM, and sensitivity tables

• 6-sheet structure with standard tabs
• Includes sources & uses, debt schedule, returns analysis
• Automatically applies industry-standard multiples
• Builds sensitivity tables for IRR and MoM
• Uses standard debt covenants (leverage/coverage)
• Calculates IRR from cash flows and exit value
• Defaults to 2-3% transaction fees and 8-12x entry multiple
• Must ensure exit multiple ≥ entry multiple

1. 1.Ask user for EBITDA, growth, multiple, and hold period
2. 2.Structure financing with 2-3x EBITDA debt tranches
3. 3.Project 5-year EBITDA and cash flows
4. 4.Calculate debt amortization and interest
5. 5.Determine exit value and equity at exit
6. 6.Run sensitivity tables for IRR and MoM