From excel-analyst-pro
Builds leveraged buyout (LBO) models in Excel with debt schedules, amortization, IRR, and MOIC analysis for private equity transactions and returns evaluation.
How this skill is triggered — by the user, by Claude, or both
Slash command
/excel-analyst-pro:excel-lbo-modelerThis skill is limited to the following tools:
The summary Claude sees in its skill listing — used to decide when to auto-load this skill
Creates leveraged buyout models with debt structuring, amortization schedules, and sponsor returns analysis for private equity transactions.
Creates leveraged buyout models with debt structuring, amortization schedules, and sponsor returns analysis for private equity transactions.
| 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 |
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
${CLAUDE_SKILL_DIR}/references/lbo-formulas.md for debt schedule templatesnpx claudepluginhub jeremylongshore/claude-code-plugins-plus-skillsCompletes LBO Excel model templates for private equity deals by filling formulas, validating calculations, and applying adaptive professional formatting.
Builds IRR/MOIC sensitivity tables for PE deal evaluation, modeling returns across entry multiple, leverage, exit multiple, growth, and hold period scenarios. Useful for sizing deals and stress-testing assumptions.
Builds DCF valuation models in Excel with assumptions sheet, 5-year FCF projections, WACC, terminal value via Gordon Growth, sensitivity tables. Outputs enterprise/equity value.