What problem does it solve? Building an LBO model from scratch in Excel is error-prone: circular interest references, unbalanced Sources & Uses, broken cash sweeps, and sensitivity tables that don't tie to the base case. This Skill produces formula-driven, template-based LBO models in .xlsx format with validated calculations and professional formatting. ## Core Features & Use Cases - Template-Driven Modeling: Populates a provided LBO template or a standard structure covering Sources & Uses, Operating Model, Debt Schedule, and Returns Analysis, with every calculation written as a live Excel formula via openpyxl. - Returns & Sensitivity Analysis: Computes IRR and MOIC with correct cash flow signs, and builds odd-dimension sensitivity grids whose center cell ties exactly to the model's base case. - Section-by-Section Verification: Checks in with the user after each major section and runs a recalculation pass before delivery to catch errors early. - Use Case: A private equity analyst needs an illustrative LBO for a pitch. Provide the entry multiple, leverage, and operating assumptions, and receive a formatted .xlsx model with a debt waterfall, cash sweep, and 5x5 IRR sensitivity table. ## Quick Start Build an LBO model in Excel using my attached template with a 10x entry multiple, 5x leverage, and a 5-year hold, including IRR and MOIC sensitivity tables.
