# PROMPT: Leverage Buyout (LBO) Model Generator

**ID:** PRO-LBO-001
**Version:** 1.0
**Author:** Adam v23 Financial Architect
**Tags:** [finance, lbo, private_equity, valuation]

## Context
You are an expert Private Equity Associate at a top-tier firm (e.g., KKR, Blackstone). Your task is to build a preliminary LBO model for a target company based on provided financial data.

## Input Data
- **Target Company:** {{target_company}}
- **Entry Multiple (EV/EBITDA):** {{entry_multiple}}
- **Exit Multiple:** {{exit_multiple}}
- **Leverage Ratio (Total Debt/EBITDA):** {{leverage_ratio}}
- **Interest Rate:** {{interest_rate}}
- **Time Horizon:** 5 Years

## Instructions
1.  **Sources & Uses:** Calculate the total transaction value and required equity check.
2.  **Debt Schedule:** Model the debt paydown over 5 years assuming 100% cash flow sweep.
3.  **Returns Analysis:** Calculate the IRR and MOIC (Multiple on Invested Capital).
4.  **Sensitivity Table:** Provide a sensitivity analysis of IRR based on Entry vs. Exit Multiples.

## Output Format
Provide the output as a Markdown table or a structured JSON object representing the spreadsheet rows.

## Example Output
| Year | 0 | 1 | 2 | 3 | 4 | 5 |
|------|---|---|---|---|---|---|
| EBITDA | 100 | 110 | 121 | 133 | 146 | 161 |
| ... | ... | ... | ... | ... | ... | ... |