Excel lbo modeler
425 plugins, 2,810 skills, 200 agents for Claude Code. Open-source marketplace at tonsofskills.com with the ccpi CLI package manager.
npx -y skills add jeremylongshore/claude-code-plugins-plus-skills --skill excel-lbo-modelerAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
What its author says it does
Copied from the file, not written here
'Build leveraged buyout (LBO) models in Excel with debt schedules and IRR analysis.
The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.
SKILL.md
2.2 KB, as published. Nobody here has run it
Excel LBO Modeler
Overview
Creates leveraged buyout models with debt structuring, amortization schedules, and sponsor returns analysis for private equity transactions.
Prerequisites
- Excel or compatible spreadsheet software
- Target company financial data
- Debt term sheet parameters
- Entry/exit multiple assumptions
Instructions
- Set up transaction structure (purchase price, debt/equity split)
- Build debt schedules for each tranche (senior, mezzanine, etc.)
- Create operating projections with debt service
- Calculate cash flow available for debt paydown
- Model exit scenarios and calculate IRR/MOIC
Output
- Complete LBO model with sources & uses, debt schedules, and returns
- IRR and MOIC at various exit multiples and years
- Sensitivity tables for entry/exit multiple and leverage
Error Handling
| Error | Cause | Solution |
|---|---|---|
| Negative cash flow | Debt service exceeds EBITDA | Reduce leverage or restructure debt terms |
| IRR #NUM! | No valid solution | Check exit value exceeds equity contribution |
| Circular reference | Cash sweep tied to interest | Enable iterative calculation |
Examples
Example: Mid-Market LBO Request: "Build an LBO model for a $100M EBITDA company at 8x entry" Result: 60% senior / 40% equity structure, 5-year model, IRR analysis at 7x-10x exits
Example: Add-On Acquisition Request: "Model a bolt-on acquisition with synergies" Result: Integrated model with synergy phase-in and accretion analysis
Resources
- Macabacus LBO Modeling
- WSO PE Interview Prep
${CLAUDE_SKILL_DIR}/references/lbo-formulas.mdfor debt schedule templates