Skip to content
cccskills
Official · ClaudeFreePublished on GitHub

deal-tracker

Track multiple M&A, financing, or restructuring deals in an Excel workbook. Organize stages, milestones, deadlines, and assigned tasks, flag delays and risks, and prepare a weekly review covering developments and upcoming work.

OriginalShow the original description

Track multiple live deals with milestones, deadlines, action items, and status updates. Maintains a deal pipeline view and surfaces upcoming deadlines and overdue items. Use when managing a book of business, tracking process milestones, or preparing for weekly deal reviews. Triggers on "deal tracker", "deal status", "where are we on", "process update", "deal pipeline", or "weekly deal review".

See how to install

Good for

  • Reviewing progress across multiple active deals
  • Tracking bid deadlines and expected closing dates
  • Managing assigned tasks and overdue items across deals
  • Preparing summaries for weekly deal review meetings

Files included (1)

  • SKILL.md3.2 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

Deal Tracker

Workflow

Step 1: Deal Setup

For each deal, capture:

  • Deal name / code name: Project [Name]
  • Client: Seller or buyer name
  • Deal type: Sell-side, buy-side, financing, restructuring
  • Role: Lead advisor, co-advisor, fairness opinion
  • Deal size: Expected enterprise value
  • Stage: Pre-mandate → Engaged → Marketing → IOI → Diligence → Final bids → Signing → Close
  • Team: MD, VP, Associate, Analyst assigned
  • Key dates: Engagement date, CIM distribution, IOI deadline, management meetings, final bid deadline, target close

Step 2: Milestone Tracking

Track key milestones per deal:

MilestoneTarget DateActual DateStatusNotes
Engagement letter signed
CIM / teaser drafted
Buyer list approved
Teaser distributed
NDA execution
CIM distributed
IOI deadline
IOIs received / reviewed
Shortlist selected
Management meetings
Data room opened
Final bid deadline
Bids received / reviewed
Exclusivity granted
Confirmatory diligence
Purchase agreement signed
Regulatory approval
Close

Status: On Track / At Risk / Delayed / Complete

Step 3: Action Items

Maintain a running action item list across all deals:

ActionDealOwnerDue DatePriorityStatus
P0/P1/P2Open/Done/Blocked

Step 4: Weekly Deal Review

Generate a summary for weekly team meetings:

For each active deal:

  1. One-line status update
  2. Key developments this week
  3. Upcoming milestones (next 2 weeks)
  4. Blockers or risks
  5. Action items for next week

Pipeline summary:

  • Total active deals by stage
  • Deals at risk (missed milestones, stalled processes)
  • New mandates / pitches in pipeline
  • Expected closings this quarter

Step 5: Output

  • Excel workbook with:
    • Pipeline overview (all deals, one row each)
    • Per-deal milestone tracker tabs
    • Action item master list
    • Weekly review summary
  • Optional: Markdown summary for email/Slack distribution

Important Notes

  • Update the tracker weekly at minimum — stale trackers are worse than no tracker
  • Flag deals where milestones are slipping — early warning prevents surprises
  • Action items without owners and due dates don't get done — be specific
  • The pipeline view should show deal stage, size, and likelihood — useful for revenue forecasting
  • Keep notes on buyer/investor feedback — patterns in feedback inform strategy adjustments
  • Archive closed/dead deals separately — keep the active view clean

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

3-statement-model

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

accrual-schedule

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

ai-readiness

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

audit-xls

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

bond-futures-basis

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

bond-relative-value

Official · ClaudeFreeSummary

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-services40.7KUpdated Sep 22, 2026

See all skills by anthropics

Report a problem with this skill