Excel LBO Modeler

excel-lbo-modeler

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'.

Dicklesworthstone/pi_agent_rust·0installs1.8Kstars

SKILL.md

Full skill instructions

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

Install skill

Copy and run in your terminal

npx -y skills add https://github.com/Dicklesworthstone/pi_agent_rust --skill excel-lbo-modeler

View on GitHub

tests/ext_conformance/artifacts/plugins-community/plugins/business-tools/excel-analyst-pro/skills/excel-lbo-modeler/SKILL.md

deepgram-hello-world
Create a minimal working Deepgram transcription example. Use when starting a new Deepgram integration, testing your setup, or learning basic Deepgram API patterns. Trigger with phrases like "deepgram hello world", "deepgram example", "deepgram quick start", "simple transcription", "transcribe aud...
0 installs
interactive-shell
Cheat sheet + workflow for launching interactive coding-agent CLIs (Claude Code, Gemini CLI, Codex CLI, Cursor CLI, and pi itself) via the interactive_shell overlay or headless dispatch. Use for TUI agents and long-running processes that need supervision, fire-and-forget delegation, or headless b...
0 installs
documenso-prod-checklist
Execute Documenso production deployment checklist and rollback procedures. Use when deploying Documenso integrations to production, preparing for launch, or implementing go-live procedures. Trigger with phrases like "documenso production", "deploy documenso", "documenso go-live", "documenso launc...
0 installs
interactive-portfolio
Expert in building portfolios that actually land jobs and clients - not just showing work, but creating memorable experiences. Covers developer portfolios, designer portfolios, creative portfolios, and portfolios that convert visitors into opportunities. Use when: portfolio, personal website, sho...
0 installs