agentsclimarketplace

Excel lbo modeler

Skill ComeOnOliver/skillshub/skills/jeremylongshore/claude-code-plugins-plus-skills/excel-lbo-modeler

🧠 The right skill, one API call. AI agent skills registry with token-efficient skill resolution. 5,000+ skills from 500+ top repos.

Install
npx -y skills add ComeOnOliver/skillshub --skill excel-lbo-modeler

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

What its author says it does

Copied from the file, not written here

Build leveraged buyout (LBO) models in Excel with debt schedules and IRR analysis. Use when structuring LBO transactions or analyzing PE returns. Trigger with phrases like 'excel lbo', 'build lbo model', 'calculate pe returns'.

The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.

SKILL.md

2.2 KB, as published. Nobody here has run it

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

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.