model-deals

Plugin model-deals in kael-odin/zcode-plugins-zh. Commands read from the repo's manifest — 9 days ago.

Skills (6)

• accretion-dilution

  Build an accretion/dilution (merger consequences) model in Excel for a specific acquisition — standalone earnings for acquirer and target, consideration mix of cash/stock/debt, exchange ratio, financing cost, phased synergies, pro-forma EPS against standalone, and the breakeven synergy and breakeven

• capital-raise

  Model a primary issuance in Excel — 定增 (private placement), 配股 (rights issue), IPO, or 可转债 (convertible bond). Sizes the raise, sets out the pricing basis and discount against a stated reference price, allocates use of proceeds, and models pre- and post-money ownership, EPS dilution, and the effect

• deal-comps

  Assemble a precedent-transaction set by hand for a specific deal — identify candidate transactions from stock events and announcement search, extract the announced terms from the announcements themselves, and compute transaction multiples (EV/EBITDA, EV/Revenue, P/E) and 控制权溢价 against a stated pre-a

• report-render

  Build paginated research deliverables (PDF, or DOCX where the reader edits the file) with correct CJK rendering, density-sized charts, clickable [n] citations, and a mandatory render-and-inspect gate. Use when a report, industry primer, earnings update, diligence report, working paper, memo, or any

• sources-uses

  Build a sources and uses schedule with the pro-forma capital structure in Excel for a specific transaction — purchase-price build, the equity-value to enterprise-value bridge, refinanced debt, fees and expenses, funding from cash on hand, new debt, new equity and rollover, and pro-forma leverage and

• xlsx-author

  Produce a professional .xlsx workbook on disk with openpyxl — formula construction rules, colour conventions, and the mandatory recalc/error-check step before delivery. Use for any tabular deliverable that belongs in a file — valuation models, comps spreads, screen shortlists, batch risk tables, hol

Slash commands (4)

• /model-deals:accretion

  Build an accretion/dilution model for an acquisition (pro-forma EPS, breakeven synergy and exchange ratio)

• /model-deals:capital-raise

  Model a primary issuance (定增/配股/IPO/可转债) — sizing, pricing, use of proceeds, dilution

• /model-deals:deal-comps

  Assemble a precedent-transaction set by hand — announced terms, transaction multiples, control premium

• /model-deals:sources-uses

  Build a sources and uses schedule with the pro-forma capital structure for a transaction

Subagents (1)

• model-deals

  Structures and models actual transactions — accretion/dilution and pro-forma EPS for an acquirer, sources and uses with the pro-forma capital structure, hand-assembled precedent-transaction comps with control premia, and capital-raise sizing and dilution for 定增/配股/IPO/可转债. Use when a banker, corp-de