Agent skill

Merger Model

by Luciole-Studio in Luciole-Studio/Misaka-Agent

Build M&A accretion/dilution workbooks in Excel. An agent skill from Luciole-Studio/Misaka-Agent.

Apache-2.0Auto-check passedDocuments & Office

Install Merger Model

skills CLI
$ npx skills add Luciole-Studio/Misaka-Agent --skill merger-model -a claude-code

Project install by default; add -g for ~/.claude/skills/.

GitHub CLI
$ gh skill install Luciole-Studio/Misaka-Agent merger-model --agent claude-code

Project scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).

Manual copy
$ git clone --depth 1 https://github.com/Luciole-Studio/Misaka-Agent.git skills-src && mkdir -p .claude/skills && cp -r skills-src/misaka/core/skills/assets/optional/finance/merger-model .claude/skills/merger-model && rm -rf skills-src

Use ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.

Claude Code skills documentation · loads skills from .claude/skills/

Facts

Skill name
merger-model
GitHub stars
158
Used in
2 other repos
Token cost
~1.3k tokens
SKILL.md length
584 words
Files
1
Skills in repo
77
Repo updated
First seen
Licence
Apache-2.0

At a glance

Build M&A accretion/dilution workbooks in Excel. An agent skill from Luciole-Studio/Misaka-Agent.

  • Works in 7 steps: Gather Inputs → Purchase Price Analysis → Sources & Uses → …
  • Tasks that involve Excel spreadsheets
  • SKILL.md covers Environment, Workflow, Important Notes and Data sources — MCP first, web…, plus 1 more section
  • Calls python; reaches sec.gov

What it does

Merger Model is an agent skill from Luciole-Studio/Misaka-Agent. Build M&A accretion/dilution workbooks in Excel.

Its SKILL.md is about 1.3k tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.

It sits in Documents & Office, covering Excel spreadsheets. It works with Microsoft Excel. The repository describes itself as: A multi-agent research system for the humanities and social sciences. The licence is Apache-2.0.

When your agent uses it

  • Tasks that involve Excel spreadsheets

Example prompts

  • “/merger-model”

Requirements

  • Python 3

Workflow steps

7 steps, taken from the step headings in SKILL.md.

  1. Gather Inputs
  2. Purchase Price Analysis
  3. Sources & Uses
  4. Pro Forma EPS (Accretion / Dilution)
  5. Sensitivity Analysis
  6. Breakeven Synergies
  7. Output

What it can do on your machine

Read from SKILL.md and the folder at commit 3bcf7a3. It shows what the files ask for, not the result of running them.

  • Tool permissions

    Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.

    From allowed-tools in the SKILL.md frontmatter.

  • Runs code

    Shell commands in SKILL.md call:

    • python

    From the folder's file list and the shell code blocks in SKILL.md.

  • Network

    Hosts in commands or code, which the agent is likely to contact:

    • sec.gov

    Also links to:

    • github.com

    From URLs in SKILL.md, links to its own repository left out.

  • Credentials

    Names no API keys, tokens, secrets or passwords.

    From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

Context cost

Merger Model loads about 1.3k tokens when it runs. Until then it costs about 15 tokens; SKILL.md has 584 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it
~15
When it runs · the whole SKILL.md, loaded when a task matches
~1.3k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Auto-check passed

The automated check found no risky patterns in SKILL.md.

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.

SKILL.md

The full file from Luciole-Studio/Misaka-Agent at commit 3bcf7a3, republished under its Apache-2.0 licence (© Luciole-Studio). 584 words, ~1,322 tokens.

Download SKILL.mdSave it as .claude/skills/merger-model/SKILL.md (or your agent's skills folder).
name
merger-model
description
Build M&A accretion/dilution workbooks in Excel.
version
1.0.0
author
Anthropic (adapted by Nous Research)
license
Apache-2.0
platforms
linux, macos, windows

Environment

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.

Merger Model

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.

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
ItemValue
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 debtEquity purchase price
Cash on handRefinance target debt
New equity issuedTransaction fees
Financing fees
TotalTotal
Step 4: Pro Forma EPS (Accretion / Dilution)

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

StandalonePro FormaAccretion/(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% cash75/2550/5025/75100% 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
Show full SKILL.md (227 more words)Show less

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

Data sources — MCP first, web fallback

Many passages below say "use the S&P Kensho MCP / Daloopa MCP / FactSet MCP". Those are commercial financial-data MCPs from the original Cowork plugin context. In Hermes:

  • If you have any structured financial-data MCP configured (Hermes supports MCP — see native-mcp skill), prefer it for point-in-time comps, precedent transactions, and filings.
  • Otherwise, fall back to:
    • web_search / web_extract against SEC EDGAR (https://www.sec.gov/cgi-bin/browse-edgar) for US filings
    • Company IR pages for press releases, earnings decks
    • browser_navigate for interactive data portals
    • User-provided data (explicitly ask when the context doesn't have it)
  • Never fabricate. If a multiple, precedent, or filing number can't be sourced, flag the cell as [UNSOURCED] and surface it to the user.

Attribution

This skill is adapted from Anthropic's Claude for Financial Services plugin suite (Apache-2.0). The Office-JS / Cowork live-Excel paths have been removed; this version targets headless openpyxl via the excel-author skill's conventions. Original: https://github.com/anthropics/financial-services

© Luciole-Studio, Apache-2.0. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

Just SKILL.md in misaka/core/skills/assets/optional/finance/merger-model of Luciole-Studio/Misaka-Agent.

Open the folder on GitHubat commit 3bcf7a3

Used in 2 other repositories

We found 2 copies of this SKILL.md (exact, near-identical or edited) in other folders, from 2 other GitHub owners. This page covers the copy in Luciole-Studio/Misaka-Agent, which our catalogue first saw on October 7, 2026.

Compare with similar skills

Merger Model next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.

Merger Model compared with similar skills
SkillStarsUsed inTokensAuto-checkLicenceRepo updated
Merger Model this skillLuciole-Studio/Misaka-Agent1582 repos~1.3kAutomated safety check: PassApache-2.0
MarkitdownImCa0/just-laws78214 repos~3.2kAutomated safety check: NotesMIT
Data Table Managern8n-io/n8n207k—~2.3kAutomated safety check: PassCustom licence
Docx4jplutext/docx4j2.4k—~2.5kAutomated safety check: PassNone
Instrument Data To Allotropeaws-samples/amazon-bedrock-agents-healthcare-lifesciences2742 repos~2.7kAutomated safety check: PassApache-2.0
Cyber Pptcrazyykhllc-bit/CyberPPT1.8k—~10kAutomated safety check: PassMIT

Similar skills

  • Markitdown

    ImCa0/just-laws

    Convert files and office documents to Markdown. An agent skill from ImCa0/just-laws.

    782 GitHub starsUsed in 14 repos~3.2k tokens
    Documents & OfficeAuto-check: notes
  • Official

    Load before calling data-tables or parse-file. An agent skill from n8n-io/n8n.

    207k GitHub stars~2.3k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Docx4j

    plutext/docx4j

    A skill your agent uses when writing Java code that creates, reads or edits Word (.docx), PowerPoint (.pptx) or Excel (.xlsx) files with docx4j — including generating documents, editing existing…

    2.4k GitHub stars~2.5k tokensUpdated today
    Documents & OfficeAuto-check passed
  • Instrument Data To Allotrope

    aws-samples/amazon-bedrock-agents-healthcare-lifesciences

    Official

    Convert laboratory instrument output files (PDF, CSV, Excel, TXT) to Allotrope Simple Model (ASM) JSON format or flattened 2D CSV.

    274 GitHub starsUsed in 2 repos~2.7k tokens
    Documents & OfficeAuto-check passed
  • Cyber Ppt

    crazyykhllc-bit/CyberPPT

    当用户需要把 DOCX、PDF、TXT、XLSX、研究报告、业务材料或原始数据转成高密度、可编辑、咨询风格 PPTX 时使用;也适用于需要 SCR 论证、视觉风格探索、详细图表和渲染质检的 PPT。

    1.8k GitHub stars~10k tokensUpdated 2 mo ago
    Documents & OfficeAuto-check passed
  • Jev SEO

    AgriciDaniel/jev-seo

    Full live SEO audit of any website from its homepage URL, powered by Jev (TypeSafe's System One model).

    539 GitHub stars~2.5k tokensUpdated 17 days ago
    Documents & OfficeAuto-check: notes

More from Luciole-Studio/Misaka-Agent

All 77 skills in this repo
  • Kanban Video Orchestrator

    Luciole-Studio/Misaka-Agent

    Plan and run multi-agent video production pipelines. An agent skill from Luciole-Studio/Misaka-Agent.

    158 GitHub starsUsed in 2 repos~2.4k tokens
    Auto-check: notes
  • Ast Grep

    Luciole-Studio/Misaka-Agent

    AST-aware structural code search and rewrite via ast-grep. An agent skill from Luciole-Studio/Misaka-Agent.

    158 GitHub starsUsed in 1 repo~3.2k tokens
    Auto-check passed
  • Drug Discovery

    Luciole-Studio/Misaka-Agent

    Drug discovery: ChEMBL search, drug-likeness, interactions. An agent skill from Luciole-Studio/Misaka-Agent.

    158 GitHub starsUsed in 1 repo~2.2k tokens
    Auto-check passed
  • Fitness Nutrition

    Luciole-Studio/Misaka-Agent

    Workout planning, macros, and body metrics via wger/USDA. An agent skill from Luciole-Studio/Misaka-Agent.

    158 GitHub starsUsed in 1 repo~2.4k tokens
    Auto-check passed
  • Hyperframes

    Luciole-Studio/Misaka-Agent

    Render MP4/WebM videos from HTML compositions. An agent skill from Luciole-Studio/Misaka-Agent.

    158 GitHub starsUsed in 1 repo~3.9k tokens
    Auto-check passed
  • Osint Investigation

    Luciole-Studio/Misaka-Agent

    Follow the money via public records and sanctions data. An agent skill from Luciole-Studio/Misaka-Agent.

    158 GitHub starsUsed in 1 repo~2.9k tokens
    Auto-check passed

Works with

Questions about Merger Model

What does Merger Model do?

Build M&A accretion/dilution workbooks in Excel. An agent skill from Luciole-Studio/Misaka-Agent. Merger Model is an agent skill from Luciole-Studio/Misaka-Agent. Build M&A accretion/dilution workbooks in Excel.

When should I use Merger Model?

Merger Model fits situations like: tasks that involve Excel spreadsheets.

How do I install Merger Model in Claude Code?

Run `npx skills add Luciole-Studio/Misaka-Agent --skill merger-model -a claude-code`. Or copy the skill folder (misaka/core/skills/assets/optional/finance/merger-model in Luciole-Studio/Misaka-Agent) into .claude/skills/merger-model in your project. Claude Code loads it when a task matches its description.

How do I install Merger Model in Codex?

Run `npx skills add Luciole-Studio/Misaka-Agent --skill merger-model -a codex`. Or copy the skill folder (misaka/core/skills/assets/optional/finance/merger-model in Luciole-Studio/Misaka-Agent) into .agents/skills/merger-model in your project. Codex loads it when a task matches its description.

Can I use Merger Model in Cursor, Gemini CLI or GitHub Copilot?

Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add Luciole-Studio/Misaka-Agent --skill merger-model -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/merger-model, .gemini/skills/merger-model, .github/skills/merger-model and .opencode/skills/merger-model in your project.

What does Merger Model need to run?

Going by SKILL.md and its folder, Merger Model needs the command-line tools its instructions call (python). Our summary lists: Python 3.

Does Merger Model access the network?

SKILL.md names 2 domains. In commands or code: sec.gov; the agent is likely to contact it when it follows the instructions. As links in the text: github.com. This is read from the text; nothing was executed.

Is Merger Model safe to install?

Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.

What licence does Merger Model use?

Merger Model is published under the Apache-2.0 licence (declared in SKILL.md). It allows redistribution, so the full SKILL.md is shown on this page.

How many tokens does Merger Model use?

About 1.3k tokens (SKILL.md is roughly 5.3k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.

What are the alternatives to Merger Model?

Skills that share tags, products or a category with Merger Model: Markitdown (ImCa0/just-laws, 782 stars), Data Table Manager (n8n-io/n8n, 207k stars), Docx4j (plutext/docx4j, 2.4k stars) and Instrument Data To Allotrope (aws-samples/amazon-bedrock-agents-healthcare-lifesciences, 274 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.

Who maintains Merger Model?

Luciole-Studio (a GitHub organization) maintains it in Luciole-Studio/Misaka-Agent, which has 158 GitHub stars. The repository holds 77 skills in this directory. The repository was last updated on October 8, 2026.

Source: Luciole-Studio/Misaka-Agent on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.