excel-lbo-modeler

Creates leveraged buyout models with debt structuring, amortization schedules, and sponsor returns analysis for private equity transactions.

| Negative cash flow | Debt service exceeds EBITDA | Reduce leverage or restructure debt terms | | IRR #NUM! | No valid solution | Check exit value exceeds equity contribution | | Circular reference | Cash sweep tied to interest | Enable iterative calculation |

Example: Mid-Market LBO Request: "Build an LBO model for a $100M EBITDA company at 8x entry" Result: 60% senior / 40% equity structure, 5-year model, IRR analysis at 7x-10x exits

使用債務時間表和 IRR 分析在 Excel 中建立槓桿收購 (LBO) 模型。 在建構 LBO 交易或分析 PE 回報時使用。 使用“excel lbo”、“build lbo model”、“calculate pe returns”等短語觸發。 來源：jst-well-dan/skill-box。