Calculate M&A accretion and dilution with pro forma income statements.
npx skills add https://github.com/icyzh/hermes-web --skill merger-model-icyzh
Please help me install this Agent Skill. Skill: merger-model Source: https://github.com/icyzh/hermes-web/tree/main/optional-skills/finance/merger-model Command: npx skills add https://github.com/icyzh/hermes-web --skill merger-model-icyzh
This skill solves the complexity of modeling M&A transactions by automating the calculation of pro forma EPS, synergy sensitivities, and purchase price allocation, ensuring financial accuracy in deal analysis.
Use the merger-model skill to build a pro forma analysis for the proposed acquisition of TargetCorp using the provided financial inputs.
High-intent search queries and answers about installing and using this skill.
You build an accretion dilution model by calculating pro forma EPS over a three-year horizon through modeling pro forma income statements and purchase price allocations. This skill automates the calculation and generates structured Excel workbooks with assumptions, sources and uses, and sensitivity tables.
Accretion dilution analysis in M&A transactions measures the impact of an acquisition on the acquiring company's pro forma earnings per share (EPS). A deal is accretive if EPS increases and dilutive if EPS decreases, determined here by modeling pro forma income statements and purchase price allocations.
Yes, you can test synergy sensitivity and deal structure variations by generating sensitivity tables. This skill evaluates deal outcomes against varying synergy levels, offer premiums, and cash/stock consideration mixes to determine if the proposed transaction is accretive or dilutive.
Yes, this merger model skill requires the openpyxl library to generate structured Excel workbooks. It uses this headless dependency to output financial analysis outputs including assumptions, sources and uses tables, and sensitivity matrices.
The best way to calculate purchase price allocation is to model the pro forma income statements and evaluate the sources and uses of funds. This skill automates the purchase price allocation calculation to ensure financial accuracy in deal analysis and pitch book preparation.
Using a dedicated skill for M&A financial modeling ensures financial accuracy in deal analysis by automating complex calculations like pro forma EPS, synergy sensitivities, and purchase price allocation, avoiding manual formula errors while preparing structured workbooks for pitch books.
LerianStudioAutomate construction and validation of DCF, LBO, merger, and operating financial models.
projectedanxConstruct accretion and dilution models for M&A transactions with pro-forma P&L and synergy sensitivity analysis.
executiveusaCalculate merger accretion/dilution and pro forma EPS impact for M&A deals.
NITISH-gitbitAutomate leveraged buyout model creation in Excel with openpyxl.
