mcpField
E
excel-lbo-modeler

excel-lbo-modeler

github.com/jst-well-danData & databases1042 installsUpdated 31w ago
Repository

About excel-lbo-modeler

An Excel-oriented skill for building leveraged buyout models for private equity transactions. It covers debt schedules, operating projections, exit scenarios, and sponsor return analysis.

Key features

  1. 01Transaction sources and uses
  2. 02Debt tranches and amortization schedules
  3. 03Operating projections and debt service
  4. 04IRR and MOIC analysis
  5. 05Sensitivity tables for assumptions

Use cases

  1. 01Modeling a private equity buyout
  2. 02Assessing returns across exit multiples and years
  3. 03Evaluating leverage and entry or exit assumptions

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/jst-well-dan/skill-box --skill excel-lbo-modeler

After installing, type/excel-lbo-modelerin Claude Code to confirm it loaded.

Bundled files

References and scripts installed along with SKILL.md.

assets/
README.md
references/
lbo-formulas.md
README.md
scripts/
README.md

Details

From the project README

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

  1. Set up transaction structure (purchase price, debt/equity split)
  2. Build debt schedules for each tranche (senior, mezzanine, etc.)
  3. Create operating projections with debt service
  4. Calculate cash flow available for debt paydown
  5. 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

ErrorCauseSolution
Negative cash flowDebt service exceeds EBITDAReduce leverage or restructure debt terms
IRR #NUM!No valid solutionCheck exit value exceeds equity contribution
Circular referenceCash sweep tied to interestEnable 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

Comments

Markdown supported