> ## Documentation Index
> Fetch the complete documentation index at: https://financecontext.com/llms.txt
> Use this file to discover all available pages before exploring further.
# deal-tracker
> Track multiple live deals with milestones, action items, and weekly deal review summaries across an entire deal pipeline
## What is Deal Lifecycle Management?
**Deal lifecycle management** is the process of tracking every active M\&A engagement from initial mandate through closing. An investment banking team may have 5-15 active deals at any time, each at a different stage -- from early-stage pitching to CIM distribution to final bid negotiation to regulatory approval. Without structured tracking, critical milestones slip, action items are forgotten, and deals lose momentum.
A deal tracker serves as the central nervous system of a deal team. It maintains a **pipeline view** showing all active engagements at a glance, a **milestone tracker** for each deal with 18 standard milestones (from engagement letter to closing), an **action item list** with owners and due dates, and **weekly deal review summaries** that keep senior bankers informed and teams accountable.
At most investment banks, the **weekly deal review meeting** (typically Monday morning) is one of the most important recurring meetings. The deal tracker provides the foundation for this meeting -- each deal is reviewed, status is updated, blockers are identified, and action items are assigned.
## Why It Matters
* **Risk management**: A deal where milestones are slipping is a deal at risk. The tracker provides early warning so the team can intervene
* **Accountability**: Action items without owners and due dates do not get done. The tracker makes assignments explicit
* **Team coordination**: Multiple people work on every deal. The tracker ensures everyone knows current status
* **Revenue forecasting**: The pipeline view shows deal stage, expected size, and probability -- essential for revenue planning
* **Institutional memory**: When team members rotate (common in banking), the tracker preserves context
## Key Concepts
| Term | Definition |
| ----------------- | ------------------------------------------------------------------------------------------------ |
| **Pipeline View** | A summary of all active deals showing stage, size, probability, and next milestone |
| **Milestone** | A key step in the deal process (e.g., CIM distributed, IOIs received, exclusivity granted) |
| **Action Item** | A specific task with an owner, due date, and priority level |
| **Deal Stage** | Where the deal sits: Pre-mandate, Engaged, Marketing, IOI, Diligence, Final Bids, Signing, Close |
| **Code Name** | Project name used for confidentiality (e.g., "Project Phoenix") |
| **At Risk** | A deal where milestones are slipping or progress has stalled |
## Worked Example: Weekly Deal Review for a 6-Deal Pipeline
### Pipeline Overview
```
WEEKLY DEAL REVIEW -- March 17, 2025
Investment Banking Group -- Industrials
PIPELINE SUMMARY:
Active Deals: 6
Expected Closings This Quarter: 2
Deals At Risk: 1
New Pitches: 2
DEAL PIPELINE:
| # | Code Name | Client | Type | Size ($M) | Stage | Prob | Status |
|---|-----------|------------|-----------|-----------|-------------|------|-----------|
| 1 | Phoenix | AcmeCo | Sell-side | $200-250 | Final Bids | 85% | On Track |
| 2 | Atlas | Atlas Chem | Sell-side | $180-220 | Marketing | 60% | On Track |
| 3 | Titan | BuyerCorp | Buy-side | $150-200 | Diligence | 70% | AT RISK |
| 4 | Mercury | TechStart | Sell-side | $50-75 | IOI | 55% | On Track |
| 5 | Neptune | OceanCo | Financing | $100 | Pre-mandate | 30% | On Track |
| 6 | Orion | StarFirm | Sell-side | $80-120 | Engaged | 50% | On Track |
Expected Revenue This Quarter: ~$8.5M (from Phoenix + Titan closings)
```
### Per-Deal Status Updates
```
PROJECT PHOENIX (Sell-side, $200-250M)
Stage: Final Bids | Status: On Track | Close Target: March 31
This Week:
- Received 3 final bids on Friday. Range: $195M-$245M
- Highest bidder: Strategic Buyer A at $245M (12.2x EBITDA)
- Next highest: PE Firm B at $220M with management rollover
- Third: PE Firm C at $195M (eliminated)
Next Steps:
- Mon 3/17: Present bids to client board
- Tue 3/18: Client selects preferred bidder
- Wed 3/19: Grant exclusivity (target: 45 days)
- Week of 3/24: Begin confirmatory diligence
Action Items:
[P0] Prepare bid comparison analysis -- John (Due: Mon AM)
[P0] Schedule board presentation call -- Sarah (Due: Mon 10AM)
[P1] Draft exclusivity agreement -- Legal (Due: Wed)
[P1] Set up confirmatory diligence data room -- Analyst (Due: Fri)
Risk: None currently. Process running smoothly.
---
PROJECT TITAN (Buy-side, $150-200M)
Stage: Diligence | Status: AT RISK | Close Target: April 15
This Week:
- Diligence Phase 2 delayed. Target company's CFO is
unavailable until April 1 (family medical issue).
- Environmental assessment report delayed 2 weeks (soil
testing requires additional samples at 2 facilities).
- Our client (BuyerCorp) board meeting moved from April 10
to April 20, pushing target close date.
Impact:
- Original close: April 15 → Revised: May 15 (+30 days)
- Financing commitment expires May 1 → Need extension
- Risk: Seller may lose patience and re-open process
Next Steps:
- Mon 3/17: Call seller's advisor to discuss revised timeline
- Tue 3/18: Request financing commitment extension from bank
- Wed 3/19: Identify alternative CFO contacts for interim
diligence questions
Action Items:
[P0] Negotiate timeline extension with seller -- MD (Due: Mon)
[P0] Request financing extension letter -- VP (Due: Tue)
[P1] Prepare revised diligence schedule -- Associate (Due: Wed)
[P1] Complete environmental scope revision -- Consultant (Due: Fri)
[P2] Update board presentation for April 20 -- Analyst (Due: 3/28)
Risk: HIGH. Multiple timeline slippages create momentum risk.
Seller's advisor may recommend re-opening the process to other
bidders. Our MD needs to manage the relationship closely.
```
### Action Item Master List
```
OPEN ACTION ITEMS -- All Deals (Sorted by Priority, Then Due Date)
| Priority | Action | Deal | Owner | Due | Status |
|----------|-------------------------------------|---------|----------|---------|---------|
| P0 | Present bids to Phoenix board | Phoenix | MD Smith | 3/17 AM | OPEN |
| P0 | Negotiate Titan timeline extension | Titan | MD Smith | 3/17 | OPEN |
| P0 | Request financing extension | Titan | VP Jones | 3/18 | OPEN |
| P0 | Phoenix bid comparison analysis | Phoenix | John | 3/17 AM | OPEN |
| P1 | Atlas CIM final draft to client | Atlas | Sarah | 3/19 | OPEN |
| P1 | Phoenix exclusivity agreement | Phoenix | Legal | 3/19 | OPEN |
| P1 | Mercury IOI review committee | Mercury | VP Lee | 3/21 | OPEN |
| P1 | Titan revised diligence schedule | Titan | Assoc. | 3/19 | OPEN |
| P2 | Neptune pitch deck draft | Neptune | Analyst | 3/24 | OPEN |
| P2 | Orion buyer list draft | Orion | Analyst | 3/21 | OPEN |
| P2 | Titan board deck update | Titan | Analyst | 3/28 | OPEN |
COMPLETED THIS WEEK:
| ✓ | Phoenix final bid letter distributed | Phoenix | VP Jones | 3/10 | DONE |
| ✓ | Atlas buyer list approved by client | Atlas | MD Smith | 3/12 | DONE |
| ✓ | Mercury NDA executed (4 of 6 buyers) | Mercury | Assoc. | 3/14 | DONE |
```
## Full Skill Workflow (From SKILL.md)
### Phase 1: Deal Setup
For each new deal, capture:
| Field | Content |
| --------------------- | --------------------------------------------------------------------- |
| Deal name / code name | Project \[Name] |
| Client | Seller or buyer name |
| Deal type | Sell-side, buy-side, financing, restructuring |
| Bank's role | Lead advisor, co-advisor, fairness opinion |
| Expected deal size | Enterprise value range |
| Current stage | Pre-mandate through Close |
| Team members | MD, VP, Associate, Analyst assigned |
| Key dates | Engagement, CIM, IOI deadline, mgmt meetings, final bid, target close |
| Probability of close | 0-100% (updated weekly) |
### Phase 2: Milestone Tracking
Track 18 standard milestones per deal:
| # | Milestone | Target Date | Actual Date | Status | Notes |
| -- | ------------------------- | ----------- | ----------- | ------ | ----- |
| 1 | Engagement letter signed | | | | |
| 2 | CIM/teaser drafted | | | | |
| 3 | Buyer list approved | | | | |
| 4 | Teaser distributed | | | | |
| 5 | NDA execution | | | | |
| 6 | CIM distributed | | | | |
| 7 | IOI deadline | | | | |
| 8 | IOIs received/reviewed | | | | |
| 9 | Shortlist selected | | | | |
| 10 | Management meetings | | | | |
| 11 | Data room opened | | | | |
| 12 | Final bid deadline | | | | |
| 13 | Bids received/reviewed | | | | |
| 14 | Exclusivity granted | | | | |
| 15 | Confirmatory diligence | | | | |
| 16 | Purchase agreement signed | | | | |
| 17 | Regulatory approval | | | | |
| 18 | Close | | | | |
**Status definitions:** On Track / At Risk / Delayed / Complete
### Phase 3: Action Item Management
Each action item requires:
| Field | Content |
| -------- | --------------------------------------------- |
| Action | Specific, measurable task |
| Deal | Which deal |
| Owner | Named individual |
| Due Date | Specific date |
| Priority | P0 (do today), P1 (this week), P2 (next week) |
| Status | Open / Done / Blocked |
### Phase 4: Weekly Deal Review
For each active deal, produce:
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
* Revenue forecast
### Phase 5: Deliver Output
* Excel workbook with: pipeline overview, per-deal milestone tabs, action item master list, weekly review summary
* Optional: markdown summary for email/Slack distribution
## Common Mistakes (and How to Avoid Them)
**What goes wrong:** "We need to finalize the CIM" appears on the action item list but no one is assigned. A week later, the CIM is still not finalized. Everyone assumed someone else was doing it.
**How to avoid it:** Every action item must have a named owner. "Sarah finalizes the CIM by Wednesday" is an action item. "We need to finalize the CIM" is a wish.
**What goes wrong:** The IOI deadline was March 1, but only 2 of 6 expected IOIs have been received. The tracker still shows "On Track" because the analyst has not updated it. The MD is blindsided at the deal review.
**How to avoid it:** Update milestone status in real-time. If a milestone is at risk of slipping, change the status to "At Risk" immediately. Raising a flag 2 weeks before a deadline is helpful. Raising it the day after is useless.
**What goes wrong:** The tracker was last updated 3 weeks ago. Half the action items are completed but still show "Open." Two deals have changed stages. The tracker is unreliable, so people stop using it.
**How to avoid it:** Update the tracker weekly at minimum. The Friday afternoon or Monday morning update should be a recurring calendar item. A stale tracker is worse than no tracker because it provides false information.
**What goes wrong:** Action items are tagged P0, P1, P2, P3, P4, and P5. No one can remember what P3 means vs. P4. Everything is effectively treated as the same priority.
**How to avoid it:** Use three priority levels: P0 (do today -- deadline is imminent), P1 (this week -- important), P2 (next week -- plan ahead). Three levels are enough to triage. More creates confusion.
**What goes wrong:** During the process, 3 of 6 buyers raise the same concern about customer concentration. This pattern is not documented. The deal team misses an opportunity to address the concern proactively in the data room.
**How to avoid it:** Add a "Buyer Feedback" section to each deal's tracker. Log common questions, concerns, and themes. If multiple buyers raise the same issue, it needs to be addressed in the process.
**What goes wrong:** Every deal in the pipeline shows 70%+ probability. This makes revenue forecasting useless -- the actual close rate is 40%. Senior management over-hires and over-invests based on the inflated forecast.
**How to avoid it:** Apply realistic probability estimates. Pre-mandate: 20-30%. Engaged: 40-50%. Marketing: 50-60%. IOI: 55-65%. Final Bids: 70-85%. Exclusivity: 85-95%. Update probabilities honestly based on process health, not optimism.
**What goes wrong:** The pipeline view shows 15 deals, but 5 of them have been dead for 3 months. The active pipeline looks larger and healthier than it actually is.
**How to avoid it:** Archive dead and closed deals to a separate tab immediately when they are terminated. The active view should only show live engagements. Maintain the archive for historical reference.
**What goes wrong:** The deal review meeting starts, and the analyst scrambles to pull up deal status in real-time. Updates are incomplete. The meeting runs over time. Senior bankers leave without clear action items.
**How to avoid it:** Prepare the weekly deal review summary before the meeting. The summary should be a one-page document that the MD can read in 5 minutes. Each deal gets a 3-4 line update plus action items.
**What goes wrong:** The firm needs to forecast quarterly revenue, but the deal tracker does not include expected fee amounts or close probabilities. Revenue planning is done separately, creating disconnects.
**How to avoid it:** Include estimated fees and close probability for each deal. Revenue forecast = Sum of (Expected Fee x Close Probability) for each deal. Update quarterly.
**What goes wrong:** "VP Jones to call the seller's advisor" is logged as an action item with no due date. Three weeks later, it is still open. Without a deadline, there is no accountability.
**How to avoid it:** Every action item must have a specific due date. "VP Jones to call the seller's advisor by Monday 3/17" creates accountability. If the date needs to change, update it explicitly rather than leaving it open-ended.
## Daily Workflow Scenarios
### Scenario 1: Monday Morning Deal Review Preparation
**6:30-7:30 AM Monday:** Before the 8:00 AM deal review meeting.
1. Review each active deal's milestone tracker. Update any status changes from the weekend.
2. Check action item list. Mark completed items as Done. Flag overdue items.
3. Write a 3-4 line summary for each deal (status, key development, next step, risk).
4. Compile the pipeline overview with updated probabilities.
5. Print or share the one-page summary for the meeting.
### Scenario 2: New Mandate Setup
**Context:** The team just signed a new engagement letter. Set up the deal in the tracker.
**Action plan (1 hour):**
1. Create the deal entry: code name, client, deal type, size, team.
2. Set milestone targets based on the process timeline (work backward from target close date).
3. Create initial action items (first 2 weeks of activity).
4. Assign a probability based on deal stage.
5. Add to the pipeline overview.
### Scenario 3: Escalating an At-Risk Deal
**Context:** Project Titan has missed 2 milestones and the buyer is getting impatient. The deal needs MD-level attention.
**Action plan:**
1. Update the tracker status to "AT RISK" with red highlighting.
2. Document the specific issues (timeline slippage, financing concern, etc.).
3. Create P0 action items for the MD with same-day or next-day deadlines.
4. In the weekly review, present Titan first (most urgent) and recommend specific interventions.
5. Track daily until the deal is back on track.
## Practice Exercise
**Exercise: Build a Deal Tracker for a 4-Deal Pipeline**
You are an associate managing the deal tracker for your Industrials group. Set up tracking for:
**Deal 1 -- Project Eagle:** Sell-side, \$300M industrial distribution company. Engagement signed 2 weeks ago. CIM being drafted.
**Deal 2 -- Project Falcon:** Sell-side, \$80M aerospace component maker. CIM distributed last week. IOI deadline in 3 weeks.
**Deal 3 -- Project Hawk:** Buy-side advisory. Your client is bidding on a \$500M target. Submitted IOI last week, waiting to hear if shortlisted.
**Deal 4 -- Project Dove:** Pre-mandate pitch. Meeting with potential client this Thursday to pitch a sell-side engagement.
**Task 1:** Create the pipeline overview table with all required fields.
**Task 2:** For Deal 2 (Project Falcon), build the milestone tracker showing all 18 milestones with target dates.
**Task 3:** Create the action item list for the next 2 weeks across all 4 deals (at least 3 items per deal).
**Task 4:** Write the weekly deal review summary for Monday morning.
**Task 5:** Estimate the probability of close and expected revenue for each deal.
## How to Add to Your Local Context
```bash theme={null}
claude plugin install investment-banking@financial-services-plugins
```
```json theme={null}
{
"mcpServers": {
"deal-system": {
"command": "deal-crm-mcp",
"args": ["--database", "your-deal-system"]
}
}
}
```
## Best Practices
* **Flag slipping milestones early**: 2 weeks before is helpful; the day after is useless
* **Action items must have owners AND due dates**: "Someone should draft the letter" is not an action item
* **Keep the pipeline view clean**: Archive dead deals; active view shows only live engagements
* **Track buyer/investor feedback**: Patterns inform strategy adjustments
* **Use the tracker to prepare for meetings**: Senior bankers should walk in fully briefed
* **Update weekly at minimum**: A stale tracker is worse than no tracker
* **Revenue forecasting**: Assign honest probabilities; update them based on process health
## Dependencies
**Required:**
* XLSX skill for Excel workbook creation
**Optional:**
* Deal management CRM for automated tracking
* Calendar integration for milestone reminders
* Slack/Teams integration for action item notifications