Stats
Actions
Tags
From excel-analyst-pro
Builds LBO models in Excel with debt schedules, IRR/MOIC calculations, projections, and sensitivities for private equity transactions.
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 nickloveinvesting/nick-love-plugins --plugin excel-analyst-proBuilds leveraged buyout (LBO) models in Excel with debt schedules, amortization, IRR, and MOIC analysis for private equity transactions and returns evaluation.
Completes 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.