무료GitHub에 공개

merger-model

Model how an acquisition changes the buyer’s earnings per share. Compare purchase prices, cash and stock payment mixes, and synergy assumptions, then produce an Excel workbook and a one-page summary of the deal’s financial effects.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

원문원문 설명 보기

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. Triggers on "merger model", "accretion dilution", "M&A model", "pro forma EPS", "merger consequences", or "deal impact analysis".

anthropics/financial-services

설치 방법 보기

이럴 때 유용합니다

Estimating how an acquisition changes earnings per share
Comparing cash and stock payment mixes
Testing purchase premiums and synergy assumptions
Preparing an Excel model and a deal summary

포함된 파일(1)

SKILL.md3.5 KB

SKILL.md(원문)

설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.

Merger Model

Workflow

Step 1: Gather Inputs

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:

Offer price per share (or premium to current)
Consideration mix: % cash vs. % stock
New debt raised to fund cash portion
Expected synergies (revenue and cost) and phase-in timeline
Transaction fees and financing costs
Expected close date

Step 2: Purchase Price Analysis

Item	Value
Offer price per share
Premium to current
Equity value
Plus: net debt assumed
Enterprise value
EV / EBITDA implied
P/E implied

Step 3: Sources & Uses

Sources	$	Uses	$
New debt		Equity purchase price
Cash on hand		Refinance target debt
New equity issued		Transaction fees
		Financing fees
Total		Total

Step 4: Pro Forma EPS (Accretion / Dilution)

Calculate year-by-year (Year 1-3):

	Standalone	Pro Forma	Accretion/(Dilution)
Acquirer net income
Target net income
Synergies (after tax)
Foregone interest on cash (after tax)
New debt interest (after tax)
Intangible amortization (after tax)
Pro forma net income
Pro forma shares
Pro forma EPS
Accretion / (Dilution) %

Step 5: Sensitivity Analysis

Accretion/Dilution vs. Synergies and Offer Premium:

	$0M syn	$25M syn	$50M syn	$75M syn	$100M syn
15% premium
20% premium
25% premium
30% premium

Accretion/Dilution vs. Cash/Stock Mix:

	100% cash	75/25	50/50	25/75	100% stock
Year 1
Year 2

Step 6: Breakeven Synergies

Calculate the minimum synergies needed for the deal to be EPS-neutral in Year 1.

Step 7: Output

Excel workbook with:
- Assumptions tab
- Sources & uses
- Pro forma income statement
- Accretion/dilution summary
- Sensitivity tables
- Breakeven analysis
One-page merger consequences summary for pitch book

Important Notes

Always show both GAAP and adjusted (cash) EPS where relevant
Stock deals: use acquirer's current price for exchange ratio, note dilution from new shares
Include purchase price allocation — goodwill and intangible amortization matter for GAAP EPS
Synergy phase-in is critical — Year 1 is often only 25-50% of run-rate synergies
Don't forget foregone interest income on cash used and new interest expense on debt raised
Tax rate on synergies and interest adjustments should match the acquirer's marginal rate

리뷰

아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.

로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.

아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.

같은 저장소의 스킬

3-statement-model

무료

Complete an existing financial model template by entering historical data and forecast assumptions, then linking the income statement, balance sheet, and cash flow statement with formulas. Check statement balances, cash consistency, and scenario behavior as each section is completed.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

Complete a partially filled financial model
Link forecasts across three financial statements
Check balance sheet and cash flow consistency

anthropics/financial-services4만2026년 9월 22일 업데이트

accrual-schedule

무료

Prepare a period-end accrual schedule for expenses incurred but not yet fully recorded. Apply company policy, subtract amounts already booked, cite supporting records, and draft journal entries for controller approval, including reversal notes where required.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

Preparing an accrual schedule for month-end close
Calculating audit fee, bonus, or utilities accruals
Drafting journal entries with supporting references

anthropics/financial-services4만2026년 9월 22일 업데이트

ai-readiness

무료

Review quarterly updates and financials across portfolio companies to identify practical AI opportunities. Rank them by estimated profit impact, speed, and feasibility, then outline first steps and approaches that other companies can reuse.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

Quarterly reviews of AI opportunities across portfolio companies
Prioritizing companies for AI investment and operational support
Finding ways to reuse successful AI projects across companies

anthropics/financial-services4만2026년 9월 22일 업데이트

audit-xls

무료

Check spreadsheet formulas for errors, broken references, inconsistent calculations, and unit mismatches. Review a selected range, one sheet, or an entire financial model, then receive findings ranked by severity with suggested fixes.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

Checking formulas in a selected range
Investigating a balance sheet that does not balance
Reviewing a financial model before client delivery

anthropics/financial-services4만2026년 9월 22일 업데이트

bond-futures-basis

무료

Analyze price differences between bond futures and cash bonds, identify the cheapest bond to deliver, and compare implied financing rates with market rates. Present valuation tables and historical context to assess potential basis trades.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

Comparing bond futures with cash bond prices
Identifying the cheapest bond to deliver
Comparing implied financing rates with market rates

anthropics/financial-services4만2026년 9월 22일 업데이트

bond-relative-value

무료

Assess whether bonds are expensive, cheap, or fairly priced by comparing yields with government rates and credit risk benchmarks. Combine spread breakdowns, historical context, and interest rate scenarios into tables and a recommendation.

한국어 요약은 준비 중입니다. 영어 요약을 표시하고 있습니다.

Comparing the relative value of candidate bonds
Separating credit risk from other yield differences
Estimating gains and losses under interest rate shifts

anthropics/financial-services4만2026년 9월 22일 업데이트

anthropics의 스킬 모두 보기

이 스킬의 문제 신고

설치

명령으로 설치

npx skills add https://github.com/anthropics/financial-services --skill merger-model

터미널에 붙여 넣고 실행합니다(Node.js 필요). Claude Code, Codex 등 설치할 에이전트를 고를 수 있습니다.

에이전트에게 부탁하기

다음 Agent Skill을 설치해 주세요.
https://github.com/anthropics/financial-services/tree/main/plugins/vertical-plugins/investment-banking/skills/merger-model

먼저 SKILL.md와 첨부 파일의 내용을 확인해 수상한 처리(외부 전송, 인증 정보 읽기 등)가 없는지 확인한 뒤 Claude Code는 ~/.claude/skills/merger-model/, Codex는 ~/.agents/skills/merger-model/ 에 배치해 주세요.

이 문장을 그대로 Claude Code나 Codex에 보내면 내용을 확인한 뒤 설치해 줍니다.

GitHub에서 소스 보기

저장소: anthropics/financial-services
스타: 40,304
포크: 5,653
카테고리: 비즈니스
라이선스: Apache-2.0
원문 언어: 영어
최종 업데이트: 2026년 9월 22일

스킬은 에이전트를 위한 지시와 스크립트의 묶음입니다. cccskills는 내용의 안전성을 보증하지 않습니다. 설치하기 전에 내용을 확인하세요.