Home
cd ../playbooks
Finance & AccountingIntermediate

LBO Model Builder for Private Equity

Build leveraged buyout models in Excel with Sources & Uses, operating projections, debt schedules, returns analysis (IRR/MOIC), and sensitivity tables following investment banking standards.

5 minutes
By anthropicSource
#LBO#leveraged buyout#private equity#financial modeling#IRR#MOIC#debt schedule

Building an LBO model requires getting the debt waterfall, cash sweeps, and returns calculations exactly right — one wrong cell reference in the interest calculation creates a circular reference that silently breaks the entire model.

Who it's for: private equity analysts, investment banking analysts, leveraged finance professionals, corporate development teams, M&A advisors

Example

"Build an LBO model for a $500M acquisition at 6x EBITDA with 60% leverage" → Professional Excel workbook with Sources & Uses, 5-year operating model, debt schedule with waterfall paydown, IRR/MOIC returns analysis, and 5x5 sensitivity tables on entry multiple and leverage

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add fa-lbo-model
## TEMPLATE REQUIREMENT

**This skill uses templates for LBO models. Always check for an attached template file first.**

Before starting any LBO model:
1. **If a template file is attached/provided**: Use that template's structure exactly - copy it and populate with the user's data
2. **If no template is attached**: Ask the user: *"Do you have a specific LBO template you'd like me to use? If not, I can use the standard template which includes Sources & Uses, Operating Model, Debt Schedule, and Returns Analysis."*
3. **If using the standard template**: Copy `examples/LBO_Model.xlsx` as your starting point and populate it with the user's assumptions

**IMPORTANT**: When a file like `LBO_Model.xlsx` is attached, you MUST use it as your template - do not build from scratch. Even if the template seems complex or has more features than needed, copy it and adapt it to the user's requirements. Never decide to "build from scratch" when a template is provided.

---

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Builds investment banking-quality LBO (Leveraged Buyout) models in Excel by filling templates with correct formulas, proper formatting, and validated calculations. Covers Sources & Uses, operating model projections, multi-tranche debt schedules with cash sweep logic, returns analysis (IRR and MOIC), and sensitivity tables.


Quick Start

Step 1: Create a Project Folder

Create a folder for your LBO model and place the downloaded template inside as CLAUDE.md.

Step 2: Download the Template

Click Download above, then move the file into your project folder as CLAUDE.md.

Step 3: Start Working

"Build an LBO model for a $500M acquisition at 6x EBITDA entry multiple"
"Create an LBO with 3 debt tranches — senior secured, mezzanine, and sub debt"
"LBO analysis for a take-private — assume 60/40 debt-equity split with 5-year hold"

Model Structure

The LBO model is built section by section with user verification at each checkpoint:

  1. Sources & Uses — Transaction sizing, debt and equity split, fees
  2. Operating Model — Revenue projections, margins, EBITDA buildup
  3. Debt Schedule — Multi-tranche with mandatory amortization and cash sweep
  4. Returns Analysis — IRR and MOIC calculations with proper cash flow signs
  5. Sensitivity Tables — 5x5 or 7x7 grids varying entry multiple, exit multiple, and leverage

Formula Color Conventions

Color Meaning
Blue (0000FF) Hardcoded inputs
Black (000000) Formulas with calculations
Purple (800080) Links to cells on the same tab
Green (008000) Links to cells on different tabs

Common Pitfalls to Avoid

  • Circular references in interest: Use beginning-of-period balance for interest calculations, not ending balance
  • Negative debt balances: Use MAX/MIN functions to prevent paying down more debt than exists
  • IRR sign errors: Investment cash flows must be negative, proceeds must be positive
  • Sensitivity tables showing identical values: Ensure formulas use mixed references ($A5 for row input, B$4 for column input)
  • Sources not equaling Uses: One item must be the "plug" (balancing figure) calculated as the difference

Tips & Best Practices

  • Work section by section — complete one section, verify with the user, then proceed to the next
  • Sensitivity tables use odd dimensions (5x5 or 7x7) so there is a true center cell representing the base case
  • The center cell of every sensitivity table must match the model's actual output — this is the proof the table is wired correctly
  • Every calculation must be an Excel formula — never compute values externally and hardcode results
  • Follow the template's sign convention consistently throughout the entire model

$Related Playbooks

Finance & Accounting

PowerPoint Template Skill Creator

Turn a branded PowerPoint template into a reusable skill that can generate on-brand presentations programmatically, with precise placeholder mapping and layout documentation.

5 minutes
Beginner
Finance & Accounting

Expense Report Generator

Organize business expenses into categorized reports for reimbursement, accounting, and tax preparation.

10 minutes
Intermediate
Finance & Accounting

Expense Tracker & Categorizer

Automate expense tracking, receipt processing, approval workflows, and reimbursement management

10 minutes
Advanced
Finance & Accounting

Personal Finance Manager — AI Budget Tracker from Bank Statements

Import bank statements (CSV or PDF) and get instant spending breakdowns, budget analysis using the 50/30/20 rule, savings recommendations, and interactive charts. All data stays local on your machine.

10 minutes
Beginner
Finance & Accounting

Financial Statement Generator

Generate P&L, balance sheet, and cash flow statements from financial data

10 minutes
Advanced
Finance & Accounting

Grow Sustainably (Without VC)

Evaluate every business decision — spending, hiring, fundraising, scaling — through the lens of profitability and infinite runway. The anti-burnout, anti-blitzscaling operating manual.

5 minutes
Intermediate
Finance & Accounting

Journal Entry Preparer

Prepare journal entries with proper debits, credits, and supporting documentation

10 minutes
Intermediate
Finance & Accounting

Invoice Processing Automation

Automate invoice generation, sending, tracking, and payment reconciliation across accounting platforms

10 minutes
Advanced
Finance & Accounting

Professional Invoice Generator

Create professional invoices with proper formatting for freelancers and small businesses. Supports multiple currencies and tax calculations.

10 minutes
Advanced
Finance & Accounting

Invoice Organizer & Tracker

Organize, categorize, and track invoices and receipts

10 minutes
Intermediate
Finance & Accounting

Invoice Template Designer

Generate professional PDF invoices from templates

10 minutes
Intermediate
Finance & Accounting

Invoice & Tax Document Organizer

Automatically sort, rename, and organize invoices, receipts, and tax documents with consistent naming for easy tax preparation.

5 minutes
Beginner

Browse all Finance & Accounting playbooks →