lbo-modellisted

This skill should be used when completing LBO (Leveraged Buyout) model templates in Excel for private equity transactions, deal materials, or investment committee presentations. The skill fills in formulas, validates calculations, and ensures professional formatting standards that adapt to any template structure.
Borjani1577/claude-office-skills · ★ 0 · Data & Documents · score 62

Install: claude install-skill Borjani1577/claude-office-skills

# LBO Model Builder ## Preflight: Dependency Check Before starting, verify required libraries and tools are installed and install any that are missing. ```bash python3 -c "import openpyxl" 2>/dev/null || python3 -m pip install openpyxl command -v soffice >/dev/null 2>&1 || command -v libreoffice >/dev/null 2>&1 || ls /Applications/LibreOffice.app/Contents/MacOS/soffice >/dev/null 2>&1 || echo "WARNING: LibreOffice not found. Install: brew install --cask libreoffice (macOS) or apt install libreoffice (Linux). Required for scripts/recalc.py." ``` **Important**: Do not skip this step — `scripts/recalc.py` is required to verify IRR/MOIC, cash sweep mechanics, and sensitivity base-case. ## Scripts - `scripts/recalc.py` — Force formula recalculation via headless LibreOffice. Run after building: `python scripts/recalc.py <model.xlsx>` ## Reference Template A starter LBO template is bundled at `lbo-model.xlsx` in this skill directory. If the user does not attach their own template, reuse the bundled file structure (do not copy cell values, only the layout/section conventions). ## TEMPLATE REQUIREMENT - If template attached → use that template's structure exactly - If no template → ask user, or use standard examples/LBO_Model.xlsx - NEVER build from scratch when template is provided ## CRITICAL INSTRUCTIONS - READ FIRST ### Environment: Office JS vs Python - Office JS: range.formulas = [["=B5*B6"]], no recalc needed - Python/openpyxl: ws["D20"] = "=B5*B6", run recalc.py bef