Build leveraged buyout (LBO) models in Excel with debt schedules and IRR analysis.

MITAuto-check passedDocuments & Office

Install Excel Lbo Modeler

skills CLI
$ npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install jeremylongshore/tons-of-skills-marketplace excel-lbo-modeler --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/jeremylongshore/tons-of-skills-marketplace.git skills-src && mkdir -p .claude/skills && cp -r skills-src/skills/.curated/excel-lbo-modeler .claude/skills/excel-lbo-modeler && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
excel-lbo-modeler
GitHub stars
2.8k
Token cost
~556 tokens
SKILL.md length
208 words
Files
5 (incl. scripts, references, assets)
Skills in repo
3,342
Repo updated
First seen
Licence
MIT

At a glance

Build leveraged buyout (LBO) models in Excel with debt schedules and IRR analysis.

  • Works in 5 steps: Set up transaction structure (purchase… → Build debt schedules for each tranche… → Create operating projections with debt… → …
  • Structuring LBO transactions
  • SKILL.md covers Overview, Prerequisites, Instructions and Output, plus 3 more sections
  • Analyzing PE returns

What it does

Excel Lbo Modeler is an agent skill from jeremylongshore/tons-of-skills-marketplace. 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'.

Its SKILL.md is about 560 tokens, which your agent loads only when the skill is triggered. The skill folder holds 7 other files, including scripts, reference files and assets (for example `assets/README.md`, `references/README.md` and `references/lbo-formulas.md`). Compatibility notes: Designed for Claude Code

It sits in Documents & Office, covering Excel spreadsheets. It works with Microsoft Excel. The repository describes itself as: Model-agnostic agent-skills platform with a harness-free canonical layer, verified adapters, and the ccpi package manager. Explore at tonsofskills.com. The licence is MIT.

When your agent uses it

  • Structuring LBO transactions
  • Analyzing PE returns
  • With phrases like excel lbo
  • Build lbo model

Example prompts

  • “excel lbo”
  • “build lbo model”
  • “calculate pe returns”
  • “/excel-lbo-modeler”

Requirements

  • Compatibility (from SKILL.md): Designed for Claude Code
  • Pre-approved tools (allowed-tools): Read, Write, Edit, Grep, Glob, Bash(cmd:*)

Workflow steps

5 steps, taken from the first numbered list in SKILL.md.

  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

What it can do on your machine

Read from SKILL.md and the folder at commit cfae287. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves these tools, so the agent can use them without asking each time:

    • Read
    • Write
    • Edit
    • Grep
    • Glob
    • Bash(cmd:*)

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Ships 1 file in scripts/, which the agent can run.

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Links to these hosts (documentation or services it may open):

    • macabacus.com
    • wallstreetoasis.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

  • Compatibility

    Designed for Claude Code

    From compatibility in the SKILL.md frontmatter.

Context cost

Excel Lbo Modeler loads about 556 tokens when it runs, and up to ~900 if it reads all its reference files. Until then it costs about 61 tokens; SKILL.md has 208 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~61
When it runs · the whole SKILL.md, loaded when a task matches
~556
With references · SKILL.md plus every file in references/, read only if the agent opens them
~900

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from jeremylongshore/tons-of-skills-marketplace at commit cfae287, republished under its MIT licence (© jeremylongshore). 208 words, ~556 tokens.

Download SKILL.mdSave it as .claude/skills/excel-lbo-modeler/SKILL.md (or your agent's skills folder). This skill also uses 4 other files; get the full folder from GitHub.
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:*)
compatibility
Designed for Claude Code
version
1.21.0
author
Jeremy Longshore <jeremy@intentsolutions.io>
license
MIT
tags
business, excel-lbo

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

ErrorCauseSolution
Negative cash flowDebt service exceeds EBITDAReduce leverage or restructure debt terms
IRR #NUM!No valid solutionCheck exit value exceeds equity contribution
Circular referenceCash sweep tied to interestEnable 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

© jeremylongshore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 4 other files (scripts, references, assets) in skills/.curated/excel-lbo-modeler of jeremylongshore/tons-of-skills-marketplace.

  • SKILL.md
  • assets/README.md
  • references/README.md
  • references/lbo-formulas.md
  • scripts/README.md

Open the folder on GitHubat commit cfae287

Compare with similar skills

Excel Lbo Modeler next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Excel Lbo Modeler compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Excel Lbo Modeler this skilljeremylongshore/tons-of-skills-marketplace2.8k—~556Automated safety check: PassMIT
MarkitdownImCa0/just-laws78114 repos~3.2kAutomated safety check: NotesMIT
Data Table Managern8n-io/n8n207k—~2.3kAutomated safety check: PassCustom licence
Docx4jplutext/docx4j2.4k—~2.5kAutomated safety check: PassNone
Instrument Data To Allotropeaws-samples/amazon-bedrock-agents-healthcare-lifesciences2742 repos~2.7kAutomated safety check: PassApache-2.0
Cyber Pptcrazyykhllc-bit/CyberPPT1.8k—~10kAutomated safety check: PassMIT

Similar skills

  • Markitdown

    ImCa0/just-laws

    Convert files and office documents to Markdown. An agent skill from ImCa0/just-laws.

    781 GitHub starsUsed in 14 repos~3.2k tokens
    Documents & OfficeAuto-check: notes
  • Official

    Load before calling data-tables or parse-file. An agent skill from n8n-io/n8n.

    207k GitHub stars~2.3k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Docx4j

    plutext/docx4j

    A skill your agent uses when writing Java code that creates, reads or edits Word (.docx), PowerPoint (.pptx) or Excel (.xlsx) files with docx4j — including generating documents, editing existing…

    2.4k GitHub stars~2.5k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Instrument Data To Allotrope

    aws-samples/amazon-bedrock-agents-healthcare-lifesciences

    Official

    Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV.

    274 GitHub starsUsed in 2 repos~2.7k tokens
    Documents & OfficeAuto-check passed
  • Cyber Ppt

    crazyykhllc-bit/CyberPPT

    当用户需要把 DOCX、PDF、TXT、XLSX、研究报告、业务材料或原始数据转成高密度、可编辑、咨询风格 PPTX 时使用;也适用于需要 SCR 论证、视觉风格探索、详细图表和渲染质检的 PPT。

    1.8k GitHub stars~10k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check passed
  • PDF

    zai-org/ZCode

    Professional PDF toolkit covering four production workflows: reports, creative visuals, academic LaTeX, and existing PDF processing.

    7.7k GitHub stars~18k tokensUpdated yesterday
    Documents & OfficeAuto-check: notes

More from jeremylongshore/tons-of-skills-marketplace

All 3,342 skills in this repo
  • Performing Security Code Review

    jeremylongshore/tons-of-skills-marketplace

    Execute this skill enables AI assistant to conduct a security-focused code review using the security-agent plugin.

    2.8k GitHub starsUsed in 2 repos~1.3k tokens
    Auto-check: notes
  • Adapting Transfer Learning Models

    jeremylongshore/tons-of-skills-marketplace

    Build this skill automates the adaptation of pre-trained machine learning models using transfer learning techniques.

    2.8k GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Agent Context Loader

    jeremylongshore/tons-of-skills-marketplace

    Execute proactive auto-loading: automatically detects and loads agents.md files.

    2.8k GitHub stars~1.1k tokensUpdated today
    Auto-check passed
  • Aggregating Performance Metrics

    jeremylongshore/tons-of-skills-marketplace

    Aggregate and centralize performance metrics from applications, systems, databases, caches, and services.

    2.8k GitHub stars~1.2k tokensUpdated today
    Auto-check passed
  • Analyzing Capacity Planning

    jeremylongshore/tons-of-skills-marketplace

    Execute this skill enables AI assistant to analyze capacity requirements and plan for future growth.

    2.8k GitHub stars~947 tokensUpdated today
    Auto-check passed
  • Analyzing Database Indexes

    jeremylongshore/tons-of-skills-marketplace

    Process use when you need to work with database indexing. An agent skill from jeremylongshore/tons-of-skills-marketplace.

    2.8k GitHub stars~2k tokensUpdated today
    Auto-check passed

Works with

Questions about Excel Lbo Modeler

What does Excel Lbo Modeler do?

Build leveraged buyout (LBO) models in Excel with debt schedules and IRR analysis. Excel Lbo Modeler is an agent skill from jeremylongshore/tons-of-skills-marketplace. Build leveraged buyout (LBO) models in Excel with debt schedules and IRR analysis.

When should I use Excel Lbo Modeler?

Excel Lbo Modeler fits situations like: structuring LBO transactions; analyzing PE returns; with phrases like excel lbo; build lbo model.

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`. Or copy the skill folder (skills/.curated/excel-lbo-modeler in jeremylongshore/tons-of-skills-marketplace) into .claude/skills/excel-lbo-modeler in your project. Claude Code loads it when a task matches its description.

How do I install Excel Lbo Modeler in Codex?

Run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a codex`. Or copy the skill folder (skills/.curated/excel-lbo-modeler in jeremylongshore/tons-of-skills-marketplace) into .agents/skills/excel-lbo-modeler in your project. Codex loads it when a task matches its description.

Can I use Excel Lbo Modeler in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add jeremylongshore/tons-of-skills-marketplace --skill excel-lbo-modeler -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/excel-lbo-modeler, .gemini/skills/excel-lbo-modeler, .github/skills/excel-lbo-modeler and .opencode/skills/excel-lbo-modeler in your project.

What does Excel Lbo Modeler need to run?

SKILL.md names no scripts, command-line tools or credentials: Excel Lbo Modeler is instructions for the agent only. Its frontmatter pre-approves these tools: Read, Write, Edit, Grep, Glob, Bash(cmd:*). Compatibility (from SKILL.md): Designed for Claude Code.

Does Excel Lbo Modeler access the network?

SKILL.md names 2 domains. As links in the text: macabacus.com and wallstreetoasis.com. This is read from the text; nothing was executed.

Is Excel Lbo Modeler safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. The check reads SKILL.md only: the scripts in the folder are not scanned, so read them before running anything.

What licence does Excel Lbo Modeler use?

Excel Lbo Modeler is published under the MIT licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Excel Lbo Modeler use?

About 556 tokens (SKILL.md is roughly 2.2k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full. Its references folder adds about 344 tokens, read only when the agent opens those files.

What are the alternatives to Excel Lbo Modeler?

Skills that share tags, products or a category with Excel Lbo Modeler: Markitdown (ImCa0/just-laws, 781 stars), Data Table Manager (n8n-io/n8n, 207k stars), Docx4j (plutext/docx4j, 2.4k stars) and Instrument Data To Allotrope (aws-samples/amazon-bedrock-agents-healthcare-lifesciences, 274 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Excel Lbo Modeler?

jeremylongshore (a GitHub user) maintains it in jeremylongshore/tons-of-skills-marketplace, which has 2,827 GitHub stars. The repository holds 3,342 skills in this directory. The repository was last updated on October 10, 2026.

Source: jeremylongshore/tons-of-skills-marketplace on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.