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
Path A
Set it up yourself
The setup prompt and 8 task prompts are below — free. The cost is your time, and the risk of wiring it wrong on live data.
Jump to the prompts ↓Path B
We wire it into your business
We would deliver a private modeling workspace: the prompts loaded into your Claude tenant, the calculator wired to your fund's assumptions and hurdle, the Excel add-in building the model in your workbook, and the self-check wired as a real pre-IC control so no unchecked return reaches committee. Done with you, then handed over so you own it.
Book a build call →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.
- Step 1Open claude.ai ↗
Sign up free. No card. Takes 30 seconds.
- Step 2
One click. Lands on your clipboard.
- Step 3Paste + send
Claude asks what you need + guides you the rest of the way.
▸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.
More like this
Other builds worth a weekend
Finance and data
Setup guide →Fincept Terminal
Kill your Bloomberg envy with a free download. Live stocks, bonds, crypto, and 37 AI agents that pick like Buffett, Munger, and Lynch.
Finance and data
Setup guide →Finance Reporting Pack — Claude vs the BI stack
AI now builds financial reporting that rivals JPMorgan analysts, packaged as 12 prompts your finance team runs on its own data. Board P&L packs, 3-statement models, variance commentary, KPI scorecards, cash forecasts, and consolidations, for the price of a Claude seat instead of Power BI plus Tableau plus a BI hire. Plus a live Reporting Stack Spend Calculator.
Finance and data
Setup guide →Firefly CFO Trust Ladder
No CFO trusts AI with company books on day one. Firefly III plus Claude is the trust ladder. Personal books first. Real reps. Then the company.