What problem does it solve? Building a leveraged buyout model in Excel requires dozens of interlinked formulas across Sources & Uses, operating projections, debt schedules, and returns analysis, and a single wrong cell reference breaks the entire model. This Skill produces dynamic, formula-driven LBO workbooks from templates with validated calculations and professional formatting. ## Core Features & Use Cases - Template-Driven Modeling: Populates a provided LBO template or the standard template with Excel formulas, never hardcoded values, so the model updates when assumptions change. - Full LBO Structure: Covers Sources & Uses, operating model, debt schedule with cash sweep waterfalls, returns analysis (IRR/MOIC), and odd-dimension sensitivity tables with a verified base-case center cell. - Banking Formatting Standards: Applies font color conventions (blue inputs, black formulas, purple same-tab links, green cross-tab links) and a restrained blue/grey fill palette. - Use Case: An analyst receives a CIM for a target company and needs an LBO model. Provide the template and assumptions, and the Skill builds each section with checkpoint verification, then recalculates the workbook before delivery. ## Quick Start Build an LBO model in Excel using my attached template with a 10x entry multiple, 60% debt financing, and a 5-year hold, showing IRR and MOIC with a 5x5 sensitivity table.
