excel-lbo-modeler — Claude Code skill: LBO models in Excel with IRR
excel-lbo-modeler — a skill that builds leveraged buyout models in Excel: deal structure, debt schedules, IRR and MOIC. Use it when you need a quick read on PE returns for a transaction.
MIT 2 installs ★ 2,935 updated 2026-11-01
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a claude-codeWhat excel-lbo-modeler does
The skill walks through an LBO model step by step. It starts with the transaction structure, purchase price and debt/equity split, then builds a repayment schedule for each debt tranche — senior, mezzanine, whatever the deal uses. After that come operating projections with debt service and the cash flow available for paydown.
You get a complete model with sources & uses, debt schedules and sponsor returns. IRR and MOIC are calculated across exit multiples and holding periods, with sensitivity tables for entry/exit multiples and leverage. A file references/lbo-formulas.md holds debt schedule templates.
You need target company financials, debt term sheet parameters and entry/exit multiple assumptions before starting. Circular references from a cash sweep tied to interest require iterative calculation enabled in Excel, otherwise the model will not solve. The skill is built for Claude Code, though it also installs into Codex, Cursor, Copilot, Gemini CLI and OpenCode.
What it helps with
- build an LBO model with sources & uses
- schedule amortization for each debt tranche
- calculate IRR and MOIC across exit scenarios
- generate sensitivity tables for leverage and multiples
- model a bolt-on acquisition with synergies
Example prompts for the agent
- Build an LBO model for a company with $100M EBITDA at an 8x entry multiple
- Add a mezzanine tranche and build its amortization schedule
- Calculate IRR and MOIC for exits at 7x–10x after five years
How to install excel-lbo-modeler
1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a claude-code2Manually: put the files in place
~/.claude/skills/excel-lbo-modeler/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/excel-lbo-modeler/
1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a codex2Manually: put the files in place
.agents/skills/excel-lbo-modeler/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a cursor2Manually: put the files in place
.cursor/skills/excel-lbo-modeler/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install jeremylongshore/tons-of-skills-marketplace skills/.curated/excel-lbo-modeler2Manually: put the files in place
.github/skills/excel-lbo-modeler/SKILL.md1Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a gemini-cli2Platform CLI
gemini skills install https://github.com/jeremylongshore/tons-of-skills-marketplace --path skills/.curated/excel-lbo-modelerManually: put the files in place
.devin/skills/excel-lbo-modeler/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about excel-lbo-modeler
How do I install excel-lbo-modeler in Claude Code?
Run npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a claude-code, then open ~/.claude/skills/excel-lbo-modeler/SKILL.md.
What does excel-lbo-modeler do?
It builds an LBO model in Excel: transaction structure, debt repayment schedules, cash flow for debt paydown, and IRR/MOIC at different exit multiples.
What do I need before using the skill?
Target company financial data, debt term sheet parameters and entry/exit multiple assumptions. Excel or a compatible spreadsheet editor.
Source text
SKILL.md · MIT
--- name: excel-lbo-modeler description: 'Build leveraged buyout (LBO) models in Excel with debt schedules and IRR analysis. Use when structuring LBO transactions or analyzing PE returns. Trigger with phrases like ''excel lbo'', ''build lbo model'', ''calculate pe returns''. ' allowed-tools: Read, Write, Edit, Grep, Glob, Bash(cmd:*) version: 1.22.0 author: Jeremy Longshore <[email protected]> license: MIT tags: - business - excel-lbo compatibility: Designed for Claude Code --- # 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 1. Set up transaction structure (purchase price, debt/equity split) 2. Build debt schedules for each tranche (senior, mezzanine, etc.) 3. Create operating projections with debt service 4. Calculate cash flow available for debt paydown 5. 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](https://macabacus.com/) - [WSO PE Interview Prep](https://www.wallstreetoasis.com/) - [`references/lbo-formulas.md`](references/lbo-formulas.md) for debt schedule templates
© Jeremy Longshore · MIT · jeremylongshore/tons-of-skills-marketplace