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.
name lbo-model description 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. TEMPLATE REQUIREMENT This skill uses templates for LBO models. Always check for an attached template file first. Before starting any LBO model: If a template file is attached/provided : Use that template's structure exactly - copy it and populate with the user's data If no template is attached : Ask the user: "Do you have a specific LBO template you'd like me to use? If not, I can use the standard template which includes Sources & Uses, Operating Model, Debt Schedule, and Returns Analysis." If using the standard template : Copy examples/LBO_Model.xlsx as your starting point and populate it with the user's assumptions IMPORTANT : When a file like LBO_Model.xlsx is attached, you MUST use it as your template - do not build from scratch. Even if the template seems complex or has more features than needed, copy it and adapt it to the user's requirements. Never decide to "build from scratch" when a template is provided. CRITICAL INSTRUCTIONS FOR CLAUDE - READ FIRST Environment: Office JS vs Python If running inside Excel (Office Add-in / Office JS environment): Use Office JS ( Excel.run(async (context) => {...}) ) directly — do NOT use Python/openpyxl Write formulas via range.formulas = [["=B5B6" ), then run recalc.py before delivery The rest of this skill is written with openpyxl examples, but the same principles apply to Office JS — just translate the API calls. Core Principles Every calculation must be an Excel formula