consultance.ai
Finance and data

The LBO Model Pack

A PE associate burns a week building the LBO on every name that crosses the desk, and most never get bid. This builds the model in an afternoon, on your own deal, in your own Claude, with a live returns calculator behind it. 8 prompts build the sources and uses, the debt schedule and cash flow, the MOIC and IRR with a return bridge, the IRR sensitivity grid, and the covenant stress test, then a hard self-check re-derives MOIC and IRR a second way before you trust the number. Move entry, exit, and leverage in the calculator and watch the return break.

🔥 optional · live interactive tool

Open the live LBO Returns Calculator

Browser-based. No signup. Drop in your numbers and see the trade in real time. Opens in a new tab so the prompts stay where you left them.

Rent it forever, or own it once.

A PE associate burns a week building the LBO on every name that crosses the desk, and most never get bid

Step 1

Paste this setup prompt — Claude installs it for you

Easy mode · paste this into Claude

Claude installs it for you, step by step.

Never used Claude before? It is free to start. Open it in a new tab, copy the prompt, paste it in. It asks one question, then walks you through everything.

  1. Step 1
    Open claude.ai ↗

    Sign up free. No card. Takes 30 seconds.

  2. Step 2

    One click. Lands on your clipboard.

  3. Step 3
    Paste + send

    Claude asks what you need + guides you the rest of the way.

Open claude.ai ↗
Tune the prompt for your level (optional)
Preview the prompt (you do not need to read it)
I want to set this up properly so Claude builds a real LBO model on my deal, not a one-off chat. Walk me through it step by step, do not skip anything. Treat me like a PE associate, deal lead, banker, or searcher who has built models in Excel but has never set up a Claude Project. Define every term once.

This is NOT a Terminal or coding install. There is nothing to compile. It is a private Claude Project where the deal lives so every prompt builds on the same model.

## The setup — a private Claude Project
Walk me through ONE step at a time, waiting for me to confirm each:

1. **What I need.** A Claude account on a paid plan so I can pin the better model. Pin **Opus 4.8**. Nothing to install. If I want the model written straight into a spreadsheet, install the Claude add-in for Microsoft Excel, but that is optional.
2. **Make the workspace.** In Claude, create a new **Project** named for the target. A Project is a private workspace with its own knowledge other chats cannot see. My deal stays in my own tenant; consultance never sees it.
3. **Try the calculator first.** Open the live LBO Returns Calculator on the library page. Move entry multiple, exit multiple, and leverage and watch the IRR, the MOIC, the sensitivity grid, and the covenant headroom move. That is the model the prompts build on my real numbers.
4. **Load the deal.** Drop the CIM and the financials into the Project knowledge, or have the P&L, balance sheet, and cash flow ready to paste.
5. **Run the vault.** Run prompt 01, pick the deal type and where my data lives, and give the inputs (EBITDA, entry multiple, leverage, debt rate, growth, exit multiple, hold). Then run 02 to 08 in order: sources and uses, debt schedule and cash flow, returns, the IRR sensitivity grid, the covenant stress, the self-check, and the one-page summary.
6. **Gate it.** Treat prompt 07 (the self-check) as a hard stop. A **GATE: FAILED** means a number does not tie; fix it before the summary. This is a first-pass model, not investment advice. I am still the investment committee.

## Rules for walking me through this
- One step at a time. Define every term once: Project, knowledge, sources and uses, entry multiple, leverage, debt schedule, cash sweep, mandatory amortization, MOIC, IRR, exit multiple, sensitivity grid, DSCR, covenant, EBITDA haircut, review gate.
- Do NOT tell me a step is "not possible." If I cannot find the Project button, it is in the left sidebar of claude.ai.
- Never smooth a number to hit a target return. If an input is missing, label it ASSUMPTION, do not invent it.
- This builds the model and reads the return. It does not replace full diligence or the IC sign-off. Not investment advice.

First message: ask me "What deal is this: a platform buyout, a bolt-on, a carve-out, or a take-private? And do you have the EBITDA, entry multiple, and leverage ready, or should we start from the calculator's base case?" Then start step 1.
Step 2

Step 1 installed it. Now run these 8 prompts on your own data.

the vault

The 8 prompts

Tap a prompt to jump to it. Hit copy. Replace the tokens. Paste into Claude Opus 4.7.

where it breaks

Before you connect live data

  • • Run dummy data first. Real client data is not a test bed.
  • • API keys never go in a public repo. Use env vars and a secrets manager.
  • • Add logging, access control, monitoring, and a rollback path before launch.
  • • Read the license. Forking a repo without checking is how lawsuits start.
license note

Credit the original author

Prompt set authored by consultance.ai. KKR and Blackstone are referenced as the standard the pack matches, no affiliation implied. Your deal stays in your own Claude tenant; we never see it. This is a first-pass model and decision support, not investment advice; a named human owns the bid and the model never smooths a number to hit a target return.

the newsletter

AI news worth opening.

The AI tools, launches, and shifts that actually matter, in plain English. New library drops the moment they land.

100% freeNo paywall, everUnsubscribe anytime

Want this running in your business, not just your laptop? We build it and hand you the keys.