Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a claude-code
Open on GitHub

What 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-code

2Manually: put the files in place

~/.claude/skills/excel-lbo-modeler/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/excel-lbo-modeler/

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

Similar skills

All skills for Finance and business →

From the same set139

The whole set →
brand-strategy Build or review a seven-part brand strategy with an AI coding assistant. Use it for a brand brief, positioning work, or messaging revisions. CX Codex +1 2installs seo-meta-generator An auto-activating skill for frontend work. It kicks in when a prompt mentions seo, seo generator, or seo meta generator, and walks through SEO metadata generation. CX Codex +1 2installs openrouter-pricing-basics openrouter-pricing-basics calculates OpenRouter token costs, tracks credit balances, and compares model rates. Helpful when estimating LLM spend or picking cheaper providers. CX Codex +1 2installs scanning-for-xss-vulnerabilities scanning-for-xss-vulnerabilities scans application code for reflected, stored, and DOM-based XSS. Use it when reviewing input handling or checking a web app before release. CX Codex +1 2installs excel-formula-generator excel-formula-generator generates spreadsheet formulas and configurations for business automation tasks. Activates on requests mentioning Excel operations and formula design. CX Codex +1 2installs juicebox-cost-tuning The juicebox-cost-tuning skill helps control Juicebox spending by cutting redundant searches and profile enrichment, then checking changes against a quota baseline. CX Codex +1 1installs twinmind-cost-tuning twinmind-cost-tuning picks a TwinMind tier and tracks where meeting minutes go. Handy when transcription costs climb and you need a clear picture. CX Codex +1 1installs openevidence-cost-tuning openevidence-cost-tuning evaluates OpenEvidence adoption and workflow burden in healthcare without inventing pricing, quotas, or telemetry. Helps prepare renewal briefs. CX Codex +1 1installs

Project sponsors

Companies that keep this analytics open