Skill

excel-lbo-modeler

Builds LBO models in Excel with debt schedules, IRR/MOIC calculations, projections, and sensitivities for private equity transactions.

automation

developer-tools

From excel-analyst-pro

Install

Run in your terminal

npx claudepluginhub nickloveinvesting/nick-love-plugins --plugin excel-analyst-pro

Tool Access

This skill is limited to using the following tools:

ReadWriteEditGrepGlobBash(cmd:*)

Supporting Assets

View in Repository

assets/README.md

references/README.md

references/lbo-formulas.md

scripts/README.md

Skill Content

Similar Skills

ui-ux-pro-max

Provides UI/UX resources: 50+ styles, color palettes, font pairings, guidelines, charts for web/mobile across React, Next.js, Vue, Svelte, Tailwind, React Native, Flutter. Aids planning, building, reviewing interfaces.

ui-ux-pro-max

57.6k

context7-mcp

Fetches up-to-date documentation from Context7 for libraries and frameworks like React, Next.js, Prisma. Use for setup questions, API references, and code examples.

context7-plugin

51.4k

market-sizing-analysis

2 files

Calculates TAM/SAM/SOM using top-down, bottom-up, and value theory methodologies for market sizing, revenue estimation, and startup validation.

startup-business-analyst

32.9k

Stats

Parent Repo Stars0

Parent Repo Forks0

Last CommitMar 20, 2026

Actions

View Source View Plugin View on GitHub View README

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.md for debt schedule templates