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

0•

数据科学与机器学习

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.

主要功能

01Real-time debt covenant monitoring for leverage and coverage ratios

02Automated debt schedules with mandatory amortization and cash flow sweeps

03Full 6-sheet Excel model generation following PE industry standards

04Dynamic IRR and Money-on-Money (MoM) sensitivity tables

05Customizable operating models with growth and margin expansion logic

060 GitHub stars

使用场景

01Performing rapid deal screening for potential private equity acquisitions

02Generating base-case LBO models for investment committee presentations

03Analyzing dividend recapitalization scenarios and refinancing impacts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla excel-lbo-modeler

For use in Claude.ai and ChatGPT

主要功能

01Real-time debt covenant monitoring for leverage and coverage ratios

02Automated debt schedules with mandatory amortization and cash flow sweeps

03Full 6-sheet Excel model generation following PE industry standards

04Dynamic IRR and Money-on-Money (MoM) sensitivity tables

05Customizable operating models with growth and margin expansion logic

060 GitHub stars

使用场景

01Performing rapid deal screening for potential private equity acquisitions

02Generating base-case LBO models for investment committee presentations

03Analyzing dividend recapitalization scenarios and refinancing impacts

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla excel-lbo-modeler

For use in Claude.ai and ChatGPT