Is the output compatible with standard Excel versions?

Yes, it generates standard .xlsx workbooks with professional formatting, color-coding for inputs vs. formulas, and transparent audit trails.

Does this skill handle complex debt structures?

Yes, it supports standard LBO capital stacks including Revolvers, Term Loan A, Term Loan B, and Subordinated/Mezzanine debt with specific interest rates and amortization periods.

Can I run sensitivity analysis on deal multiples?

Absolutely. The skill automatically builds sensitivity tables comparing variables like Exit Multiple vs. Hold Period and EBITDA Growth vs. Exit Multiple to show return variations.

What components are included in the generated Excel model?

The model includes a Transaction Summary, Sources & Uses, 5-Year Operating Model, Debt Schedule with waterfall logic, Returns Analysis (IRR/MoM), and Debt Covenant checks.

Excel LBO Modeler

Name: Excel LBO Modeler
Author: intent-solutions-io

byintent-solutions-io

データサイエンスとML

Builds professional-grade private equity leveraged buyout (LBO) models in Excel with automated debt schedules and return analysis.

概要

The Excel LBO Modeler is a specialized Claude Code skill designed for investment bankers and private equity analysts to automate the creation of complex financial models. It generates a comprehensive six-sheet Excel workbook that includes sources and uses of funds, five-year operating projections, detailed debt paydown waterfalls, and IRR/MoM return calculations. By adhering to industry-standard practices, this skill ensures that all calculations—from debt covenant compliance to sensitivity analysis—are audit-ready and suitable for initial deal screening or investment committee preparation.

主な機能

Real-time debt covenant monitoring for leverage and coverage ratios
Automated debt schedules with mandatory amortization and cash flow sweeps
Full 6-sheet Excel model generation following PE industry standards
Dynamic IRR and Money-on-Money (MoM) sensitivity tables
Customizable operating models with growth and margin expansion logic
0 GitHub stars

ユースケース

Performing rapid deal screening for potential private equity acquisitions
Generating base-case LBO models for investment committee presentations
Analyzing dividend recapitalization scenarios and refinancing impacts

概要

主な機能

Real-time debt covenant monitoring for leverage and coverage ratios
Automated debt schedules with mandatory amortization and cash flow sweeps
Full 6-sheet Excel model generation following PE industry standards
Dynamic IRR and Money-on-Money (MoM) sensitivity tables
Customizable operating models with growth and margin expansion logic
0 GitHub stars

ユースケース

Performing rapid deal screening for potential private equity acquisitions
Generating base-case LBO models for investment committee presentations
Analyzing dividend recapitalization scenarios and refinancing impacts