LBO-модель с расчётом IRR и MOIC в Excel
★ 7.1 · financial-analysis
lbo-model is a Claude Code skill that builds leveraged buyout workbooks in .xlsx format, calculating IRR and MOIC via the openpyxl library. It is template-driven: if an LBO_Model.xlsx file is attached, that file serves as the starting point; otherwise Claude proposes a standard layout covering Sources & Uses, Operating Model, Debt Schedule, and Returns Analysis. Every calculation is written as an Excel formula string rather than a hardcoded Python result, keeping the model fully dynamic and responsive to input changes. The skill works section by section, verifying each part with the user before moving forward — catching errors in Sources & Uses before they cascade into the returns analysis. It targets private equity analysts and investment banking teams who need a professional, deal-ready LBO model.
- #excel
- #lbo
- #private-equity
- #financial-modeling
- #openpyxl
- #irr
- #moic