Can I customize the operating assumptions?

Yes, you can provide specific revenue growth, EBITDA margin targets, CapEx requirements, and working capital assumptions for a 5-year projection period.

Is the output compatible with professional standards?

The model follows industry-standard formatting for investment banking and private equity, including clear Sources & Uses and professional audit trails.

What debt structures does this skill support?

It supports standard PE financing including Revolvers, Term Loan A (amortizing), Term Loan B (bullet), and Subordinated/Mezzanine debt with custom interest rates.

Does it include sensitivity tables?

Yes, it automatically generates tables for IRR and MoM multiples based on varying exit multiples, hold periods, and operational performance.

Excel LBO Modeler

Name: Excel LBO Modeler
Author: jeremylongshore

byjeremylongshore

•

883

•

分析と監視

Builds comprehensive 6-sheet leveraged buyout (LBO) models in Excel for professional private equity analysis and deal screening.

The Excel LBO Modeler skill automates the creation of complex, industry-standard financial models for private equity transactions. It generates a complete 6-sheet workbook featuring transaction summaries, sources and uses of funds, five-year operating projections, and detailed debt paydown waterfalls for multiple tranches. It is particularly useful for analysts and investors needing to quickly calculate IRR and Money-on-Money multiples, perform sensitivity analysis on exit scenarios, and ensure financing structures remain within debt covenant limits.

主な機能

01883 GitHub stars

02Dynamic cash flow waterfalls with mandatory amortization and excess cash sweeps

03Automated IRR and MoM returns analysis with multi-variable sensitivity tables

04Automated generation of 6-sheet professional Excel workbooks

05Multi-tranche debt schedules with revolvers, term loans, and subordinated debt

06Integrated debt covenant monitoring for leverage and coverage ratios

ユースケース

01Structuring and testing various financing layers for leveraged buyouts

02Rapid deal screening and initial investment committee financial modeling

03Running sensitivity analyses on growth, margin expansion, and exit multiples

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