Model a buyout financed with debt
valuation_lboAn LBO: sources and uses, each debt tranche's interest, amortization and cash sweep year by year, the cash left, the exit value and equity, MOIC and IRR, and an IRR grid for entry by exit multiple. Interest is on each opening balance; tax is on EBITDA less depreciation and interest. Free.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"years": "<years>",
"tax_rate": "<tax_rate>"
},
"name": "valuation_lbo"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| debt | No | ||
| fees | No | ||
| years | Yes | ||
| currency | No | Shown with the figures, e.g. EUR. Nothing is converted. | |
| tax_rate | Yes | Tax on profit. A decimal: 0.09 is 9%. | |
| sensitivity | No | ||
| entry_ebitda | No | ||
| exit_multiple | No | The entry multiple when left out. | |
| entry_multiple | No | ||
| entry_enterprise_value | No | Instead of entry_ebitda x entry_multiple. |