Does it create sensitivity tables?

Yes, it automatically generates sensitivity analyses for IRR and MoM, comparing variables like Exit Multiple vs. Hold Period and Entry Multiple vs. Exit Multiple.

What inputs are required to build a model?

You typically need the target company's current EBITDA, an entry valuation multiple, expected revenue growth, and EBITDA margin assumptions. The skill provides defaults for fees and interest rates if not specified.

Can it handle complex debt structures?

Yes, it models multi-tranche financing including Revolvers, Term Loan A, Term Loan B, and Subordinated Debt, each with specific amortization and interest rate logic.

Is the generated Excel file editable?

Absolutely. The skill produces a standard .xlsx file with live formulas and industry-standard formatting, allowing you to further customize the model manually.

Does it check for deal feasibility?

The skill includes error handling for over-leveraged structures and negative cash flow scenarios, providing warnings if the proposed deal violates typical market standards or covenants.

Excel LBO Modeler

Name: Excel LBO Modeler
Author: jeremylongshore

byjeremylongshore

•

883

•

Productivity & Workflow

Builds comprehensive, industry-standard leveraged buyout (LBO) models in Excel for private equity analysis and deal screening.

The Excel LBO Modeler is a specialized financial tool designed to automate the creation of complex private equity transaction models. It generates a professional 6-sheet Excel workbook that includes Sources and Uses, 5-year operating projections, debt paydown waterfalls for multiple tranches (Revolver, Term Loans, Subordinated Debt), and comprehensive IRR/MoM return analysis. Perfect for investment associates and analysts, this skill accelerates deal screening by taking high-level assumptions and producing an audit-ready model complete with sensitivity tables and covenant checks, ensuring all calculations follow industry-standard financial practices.

Key Features

01883 GitHub stars

02Generates a complete 6-sheet professional Excel LBO structure

03Creates dynamic sensitivity tables for exit multiples and hold periods

04Automates debt paydown waterfalls and interest expense calculations

05Calculates IRR and Money-on-Money (MoM) exit returns

06Includes automated debt covenant compliance and leverage tracking

Use Cases

01Rapidly screening potential acquisition targets during the sourcing phase

02Generating first-draft LBO models for investment committee presentations

03Running scenario analyses to find required exit conditions for specific IRR hurdles

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills excel-lbo-modeler

For use in Claude.ai and ChatGPT

Download Skill