From excel-analyst-pro
Builds LBO models in Excel with debt schedules, IRR/MOIC calculations, projections, and sensitivities for private equity transactions.
npx claudepluginhub jeremylongshore/claude-code-plugins-plus-skillsThis skill is limited to using the following tools:
Creates leveraged buyout models with debt structuring, amortization schedules, and sponsor returns analysis for private equity transactions.
Completes LBO model Excel templates by inserting formulas, validating calculations, and applying professional formatting for private equity deals and presentations.
Builds IRR/MOIC sensitivity tables for PE deals, modeling returns across entry/exit multiples, leverage, growth, hold periods; includes base cases, scenarios, waterfalls, and Excel outputs.
Builds DCF valuation models in Excel with FCF projections, WACC, terminal value, enterprise/equity value, and sensitivity analysis on key assumptions.
Share bugs, ideas, or general feedback.
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 templates