Jst-Well-Dan/excel-lbo-modeler
business-analyst/excel-lbo-modeler/SKILL.md
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'.
$ install --global
skillsauthnpx skillsauth add Jst-Well-Dan/Skill-Box excel-lbo-modelerInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 24, 2026, 8:39 PM1.8s1 file scanned
SKILL.md
- name:
- excel-lbo-modeler
- description:
- |
- allowed-tools:
- Read, Write, Edit, Grep, Glob, Bash(cmd:*)
- version:
- 1.0.0
- author:
- Jeremy Longshore <[email protected]>
- license:
- MIT
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
{baseDir}/references/lbo-formulas.mdfor debt schedule templates
Related Skills
Jst-Well-Dan/video-frames
tools
VerifiedTrustedCommunity
Extract frames or short clips from videos using ffmpeg.
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/theme-factory
tools
VerifiedTrustedCommunity
Toolkit for styling artifacts with a theme. These artifacts can be slides, docs, reportings, HTML landing pages, etc. There are 10 pre-set themes with colors/fonts that you can apply to any artifact that has been creating, or can generate a new theme on-the-fly.
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/slack-gif-creator
tools
VerifiedTrustedCommunity
Toolkit for creating animated GIFs optimized for Slack, with validators for size constraints and composable animation primitives. This skill applies when users request animated GIFs or emoji animations for Slack from descriptions like "make me a GIF for Slack of X doing Y".
7SKILL.mdUpdated Apr 6, 2026
Jst-Well-Dan/remotion-best-practices
development
VerifiedTrustedCommunity
Best practices for Remotion - Video creation in React
7SKILL.mdUpdated Apr 6, 2026