What debt structures does the LBO modeler support?

It supports complex capital structures including Revolvers, Term Loan A, Term Loan B, and Subordinated/Mezzanine debt with customizable interest rates and amortization periods.

Is the generated Excel file industry-standard?

The model follows standard investment banking and private equity formatting, including Sources & Uses, detailed Debt Schedules, and Cash Flow Waterfalls.

Does the skill include sensitivity analysis?

Yes, it automatically generates dynamic sensitivity tables for IRR and MoM multiples against variables like exit multiples, hold periods, and EBITDA growth.

Does the model check for financial covenants?

Yes, it includes a dedicated sheet for tracking leverage and coverage covenants, such as Total Debt/EBITDA and EBITDA/Interest Expense, to ensure deal viability.

Can I customize the operating assumptions?

Absolutely. You can specify revenue growth, EBITDA margins, CapEx, Net Working Capital (NWC) requirements, and tax rates for a comprehensive 5-year projection.

Excel LBO Modeler

Name: Excel LBO Modeler
Author: BbgnsurfTech

byBbgnsurfTech

•

数据科学与机器学习

Builds professional-grade Leveraged Buyout (LBO) models in Excel for private equity analysis and transaction screening.

The Excel LBO Modeler is a specialized tool for finance professionals and analysts to automate the creation of complex 6-sheet financial models. It handles the entire transaction lifecycle from gathering inputs and structuring multi-tranche debt financing to projecting 5-year operating models and calculating IRR/MoM returns with built-in sensitivity tables. By following industry-standard private equity practices, this skill ensures accuracy in debt paydown waterfalls, covenant compliance, and return attribution, making it ideal for quick deal screening or initial investment committee preparation.

主要功能

01Dynamic 5-year operating projections and cash flow analysis

02Automated debt covenant tracking and leverage checks

03Integrated IRR, MoM, and sensitivity table calculations

04Multi-tranche debt structuring with waterfall paydown logic

05Automated 6-sheet Excel LBO model generation

063 GitHub stars

使用场景

01Quick screening and returns analysis for potential acquisition targets

02Analyzing the impact of dividend recaps or capital structure changes on IRR

03Building initial LBO models for investment committee presentations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection excel-lbo-modeler

For use in Claude.ai and ChatGPT

Download Skill