- Home
- Skills
- Finance & Accounting
- Lbo Finance Model
Works with the AI Agents you already use
Lbo Finance Model
Use to build a leveraged buyout model in Excel: sources and uses, debt schedules, cash sweeps, exit multiple math, IRR/MoM and sensitivity tables. Walks entry t
Free
Lbo Finance Model
Example session with this skill installed
Build an LBO model for a company with 100M EBITDA, 10x entry multiple, 150M existing debt, and 5% management rollover. Include a 5-year forecast and sensitivity table for IRR.
- Read your context and instructions
- Compiled the lbo finance model
Model structure generated.
- Sources & Uses: Balanced at 1,020M (Equity: 420M, Debt: 600M).
- Debt: TLA (5-year amort), TLB (bullet), Senior Notes.
- Returns: IRR 18.4%, MoM 2.3x.
- Sensitivity: Data table mapping 8x-12x entry/exit multiples created.
Check 'Error Cell' for balance verification.
Connects securely to your tools. The creator never sees your data.
About this skill
The problem
Building an LBO model from scratch is prone to manual errors in debt scheduling and circular references. Financial analysts often struggle to keep Sources and Uses in balance while maintaining clean cash sweeps across multiple debt tranches.
What it does
- Generates structured Sources and Uses tables with built-in error checking for balance.
- Constructs detailed debt schedules including Revolvers, Term Loan A/B, and Senior Notes.
- Calculates annual operating cash flows, mandatory amortization, and optional cash sweeps.
- Computes exit valuation, Net Debt, IRR, and MoM return metrics.
- Creates sensitivity data tables to stress test IRR against varying entry and exit multiples.
Frameworks & tools
Microsoft Excel, Google Sheets.
Why this beats prompting it yourself
Generic prompts often skip critical accounting nuances like management rollover, transaction fees, or proper cash sweep logic. This skill follows a rigorous private equity workflow that ensures your debt balances and return schedules remain logically sound and ready for deal screening.
Use cases
- Preparing a private equity case study under time constraints.
- Screening a potential buyout target to determine the maximum entry price.
- Modeling debt capacity and repayment profiles for a leveraged transaction.
Known limitations
Does not handle complex distressed restructuring waterfalls or consolidated accounting for subsidiaries. Public trading comparables must be calculated separately.
Does not support complex distressed creditor waterfalls or accounting-grade consolidation. Requires separate calculation for trading comps.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
5 uses
Times used to date
Free forever
No account required to browse
Trust & safety
Security scan
Security scan passed 3 months ago
- Free with an Agensi account
Permissions
No special permissions declared or detected