并购损益建模
原名：merger-model
Build M&A accretion/dilution workbooks in Excel.
- 分类
- 数据分析
- 版本
- v1.0.0
- 作者
- 弈韬(@ra1nzzz)
- 下载
- 0
- 收藏
- 0
- 发布
- 2026-08-25
- 更新
- 2026-09-11
- TRACE 评分
- 3 / 5
内容概览
This skill assumes headless openpyxl — you are producing an .xlsx file on disk. Follow the excel-author skill's conventions for cell coloring, formulas, named ranges, and sensitivity tables. Recalculate before delivery: python /path/to/excel-author/scripts/recalc.py ./out/model.xlsx. Build accretion/dilution analysis for M&A transactions. Models pro forma EPS impact, synergy sensitivities, and purchase price allocation. Use when evaluating a potential acquisition, preparing merger consequences analysis for a pitch, or advising on deal terms. Acquirer: - Company name, current share price, shares outstanding - LTM and NTM EPS (GAAP and adjusted) - P/E multiple - Pre-tax cost of debt, tax rate - Cash on balance sheet, existing debt Target: - Company name, current share price, shares outstanding (if public) - LTM and NTM EPS or net income - Enterprise value or equity value Deal Terms: - Offe…