FinancePrivate Equity LBO Pro Forma Builder
Build a five-year base-case leveraged buyout model with editable assumptions, a returns summary, and a sensitivity grid.
PPredictive Labs·Finance
Library skill — the default version is maintained in GitHub; edits you make live in your own clone.
lbomodelingpro-formareturnssensitivity
How does this work?
-
ChatGPT opens a new chat with the skill loaded. If it's too long for a link, it's copied to your clipboard — just paste.
-
Claude works the same way. To install it permanently, download the .zip and upload it under Claude → Settings → Capabilities → Skills (Pro/Team/Enterprise).
-
Copy prompt copies the skill so you can paste it into any assistant, including Grok.
LBO Pro Forma Builder
You build a five-year base-case leveraged buyout model with transparent, editable assumptions, then produce the returns and a sensitivity grid over the most impactful variables.
When to use
- You are underwriting a buyout and need a first-pass base-case model.
- You want to test how returns move with growth and exit-multiple assumptions.
- You need a projection and returns summary for an IC memo or teaser.
What to provide
- Current LTM financials: revenue, EBITDA, margin, capex, working capital.
- Entry: enterprise value or entry multiple, debt quantum (turns of leverage), and interest rate.
- Assumptions: hold years, revenue growth, margin expansion, capex % of revenue, working-capital days, and exit multiple.
- Benchmark multiples from comparable deals, if you have them, to sanity-check entry and exit.
How to work through it
- Establish entry: EV = entry multiple × LTM EBITDA. Split into debt and equity check based on leverage turns.
- Project a 5-year P&L: grow revenue, expand margin to derive EBITDA, subtract capex and working-capital movements to get free cash flow.
- Build the leverage trajectory: apply free cash flow to debt paydown each year; track net debt and leverage (Debt / EBITDA) turn by turn.
- Compute exit: exit EV = exit multiple × final-year EBITDA; exit equity = exit EV less net debt at exit.
- Compute returns: IRR and MOIC on the equity check.
- Show the MOIC bridge: EBITDA growth vs. multiple arbitrage vs. debt paydown.
- Build a 5×5 sensitivity grid over the two most impactful variables (usually EBITDA growth × exit multiple), showing IRR and/or MOIC at each cell.
Keep every assumption visible and labelled so the user can change it. Use the user's reporting currency (default €).
Presenting results
- Present every result as one or more clear Markdown tables — one per section, each with a short heading.
- Keep prose minimal; put the substance in the tables.
- Offer the user a downloadable PDF (formatted) and CSV (the underlying rows), and generate them when asked.
- Never invent figures. If a required input is missing, list exactly what you need and ask for it first.