Tutorial 03: Document Analysis for Legal Professionals

I've uploaded a software license agreement. I represent the LICENSEE
(the company purchasing the software).

Please provide a comprehensive review:

## SECTION 1: EXECUTIVE SUMMARY
- Contract type and parties
- Key commercial terms (price, term, renewal)
- Overall risk assessment (1-10 scale)
- Top 3 concerns requiring immediate attention

## SECTION 2: CLAUSE-BY-CLAUSE ANALYSIS
For each major clause category:
1. License Grant & Scope
2. Fees & Payment
3. Term & Termination
4. Warranties
5. Limitation of Liability
6. Indemnification
7. IP Rights
8. Confidentiality
9. Data Rights & Security
10. Miscellaneous (Governing Law, Assignment, etc.)

Provide:
- Summary of current language
- Risk level: RED (High) | YELLOW (Medium) | GREEN (Low)
- Specific concerns
- Suggested modifications

## SECTION 3: NEGOTIATION PRIORITIES
Rank the top 5 issues to negotiate, with reasoning and suggested
approach for each.

## SECTION 4: QUESTIONS FOR THE BUSINESS
List questions I should ask our business team before finalizing
the negotiation strategy.

I'm uploading two versions of an NDA:
1. Our original version (clean)
2. Counterparty's redlined version

Please analyze the changes:

## CHANGE LOG
Create a table with columns:
| Section | Our Language (Summary) | Their Change | Impact | Recommendation |

## RISK ASSESSMENT
For changes that increase our risk:
- Explain the practical impact
- Assess severity (HIGH/MEDIUM/LOW)
- Suggest counter-proposal or acceptance rationale

## STRATEGIC ANALYSIS
- What does their pattern of changes tell us about their concerns?
- Which changes are likely non-negotiable for them?
- Where do we have leverage to push back?

## RECOMMENDED RESPONSE
Draft a summary email I could send to the counterparty accepting
some changes, rejecting others, and proposing alternatives.

I'm uploading three vendor agreements for similar cloud services.
Help me compare them for my client (the customer).

Create a comparison matrix covering:

## COMMERCIAL TERMS
| Term | Vendor A | Vendor B | Vendor C | Best for Customer |
|------|----------|----------|----------|-------------------|
| Annual Cost | | | | |
| Term Length | | | | |
| Termination Rights | | | | |
| Price Increases | | | | |
| Payment Terms | | | | |

## RISK TERMS
| Risk Area | Vendor A | Vendor B | Vendor C | Least Risky |
|-----------|----------|----------|----------|-------------|
| Liability Cap | | | | |
| Indemnification | | | | |
| Data Rights | | | | |
| Security Commitments | | | | |
| Insurance | | | | |

## SERVICE TERMS
| Feature | Vendor A | Vendor B | Vendor C | Best |
|---------|----------|----------|----------|------|
| SLA/Uptime | | | | |
| Support Level | | | | |
| Implementation | | | | |
| Training | | | | |

## RECOMMENDATION
Based purely on the contract terms (not product features), rank
the vendors and explain your recommendation.

I've uploaded a Share Purchase Agreement. Please provide an M&A
due diligence focused analysis:

## EXECUTIVE SUMMARY - M&A OVERVIEW
- Transaction structure (asset vs. equity purchase)
- Purchase price and payment terms
- Closing conditions and anticipated timeline
- Overall deal risk assessment

## PURCHASE PRICE ANALYSIS
- Base purchase price
- Adjustments mechanism (earn-outs, escrow, holdbacks)
- Calculation methodology for adjustments
- Working capital targets (if any)
- Transaction costs allocation
- Tax gross-ups (if any)

## REPRESENTATIONS AND WARRANTIES
For Seller, create a table:
| Category | Warranty | Qualification | Knowledge Qualifier? | Materiality Threshold |
|----------|----------|----------------|---------------------|----------------------|

Categories to analyze:
- Organization and authority
- Financial statements accuracy
- Contracts and agreements
- Compliance with laws
- Litigation and disputes
- Environmental
- Employees and benefits
- Intellectual property
- Tax matters

## WARRANTIES ANALYSIS
- Which warranties have materiality baskets (de minimis thresholds)?
- Which have caps on liability?
- Which survive longest post-closing?
- Which are most likely to be breached?
- What indemnification obligations flow from breach?

## CLOSING CONDITIONS
- List all conditions to closing (for both parties)
- Identify conditions favoring buyer vs. seller
- Assess whether conditions are reasonable
- Which conditions have hard long-stop dates?

## INDEMNIFICATION STRUCTURE
- Indemnification basket (minimum losses before claims)
- Cap on indemnification
- Survival period for different warranties
- Escrow or holdback mechanism
- Cap exceptions (never subject to cap)

## DUE DILIGENCE REQUIREMENTS
- What must be delivered at closing?
- SPA exhibits and schedules checklist
- Key documentation to verify before closing
- Representations relating to items that should be checked

## RISK ASSESSMENT
- RED (High) items requiring resolution
- YELLOW (Medium) items requiring negotiation
- GREEN (Acceptable) items
- Critical gaps or missing provisions

## CLOSING READINESS
- Items buyer must verify before closing
- Items seller must prepare for closing
- Likely sources of closing disputes

I've uploaded a commercial lease. Please extract and summarize
all critical lease terms:

## LEASE PARTIES & DATES
- Landlord (Full legal name, entity type):
- Tenant (Full legal name, entity type):
- Execution Date:
- Effective Date:
- Property Address & Unit:

## LEASE TERM
- Initial Term: ___ years from ___ to ___
- Renewal Option 1: ___ years at what rent increase?
- Renewal Option 2: ___ years at what rent increase?
- Auto-renewal? YES / NO
- Notice required for renewal (months in advance):

## RENT SCHEDULE
| Lease Year | Annual Base Rent | Monthly Rent | Escalation |
|------------|------------------|--------------|------------|
| Year 1-2   |                  |              |            |
| Year 3-5   |                  |              |            |
| Year 6+    |                  |              |            |

- Escalation mechanism (fixed %, CPI, market rate reset):
- Free rent period?
- Abatement for improvements?

## OPERATING EXPENSES & NNN
- Base year operating expenses:
- Tenant's share of increases:
- CAM charges included (HVAC, security, etc.):
- Tax and insurance charges:
- Exclusions from operating expenses:

## TENANT OBLIGATIONS
- Permitted uses:
- Prohibited uses:
- Maintenance obligations (landlord vs. tenant):
- Repair obligations:
- Alterations - permitted without consent? With consent?
- Signage rights:
- Parking included? Exclusive? Shared?
- Insurance requirements:

## LANDLORD OBLIGATIONS
- Structural repairs:
- HVAC/utilities maintenance:
- Building code compliance:
- Access guarantees:

## DEFAULT & REMEDIES
- Late rent payment grace period:
- Default triggers:
- Cure periods:
- Remedies available to landlord:
- Re-entry/eviction procedures:

## TERMINATION PROVISIONS
- Early termination allowed? Under what conditions?
- Termination fee if applicable:
- Break option terms (if any):
- Lease renewal decline process:

## CRITICAL DATES (Next 5 Years)
| Date | Event | Action Required |
|------|-------|-----------------|

## RISKS & CONCERNS
- RED (Unfavorable) terms
- YELLOW (Ambiguous) provisions
- GREEN (Favorable) terms
- Missing provisions to negotiate

## ABSTRACTION FOR PORTFOLIO TRACKING
[Provide in format suitable for Excel/Lease Management Software]

I've uploaded an MSA and attached SLA. Please analyze from both
a legal and operational compliance perspective:

## AGREEMENT OVERVIEW
- Service provider (vendor):
- Services covered:
- Start date and term:
- Parties' roles and responsibilities:
- Overall risk assessment (1-10):

## SERVICE LEVEL AGREEMENT ANALYSIS
Extract and assess the SLA terms:

| Metric | Target Level | Measurement Period | Failure Consequence |
|--------|--------------|-------------------|-------------------|
| Uptime | 99.9%? | Monthly? | Credits? |
| Response Time | ? | ? | ? |
| Resolution Time | ? | ? | ? |
| Other metrics | | | |

- How are SLA metrics measured?
- Who reports on SLA compliance?
- What triggers SLA credits (if applicable)?
- Are credits cumulative or capped?
- Remedies if SLA breached (beyond credits):

## VENDOR OBLIGATIONS - CRITICAL ITEMS
- Primary services to be delivered:
- Specific deliverables (with timing):
- Performance standards:
- Quality requirements:
- Escalation procedures for issues:
- Staffing/resources committed:

## CLIENT OBLIGATIONS
- Payment obligations:
- Data provision/access requirements:
- Cooperation requirements:
- Compliance requirements imposed on client:
- Audit rights granted to vendor:

## COMPLIANCE & SECURITY
- Compliance certifications required (SOC 2, ISO, etc.):
- Security standards (encryption, access control, etc.):
- Data protection obligations:
- Audit rights (Client audit rights over Vendor):
- Compliance verification process:
- Frequency of security assessments:

## DATA & CONFIDENTIALITY
- Data ownership (whose data is it?):
- Data location restrictions (geographic):
- Subprocessors/subcontractors allowed?
- Data access restrictions:
- Data return/destruction at termination:
- Confidentiality obligations:
- Standard vs. specific for sensitive data:

## LIABILITY & INDEMNIFICATION
- Liability cap (if any):
- Exclusions from liability cap:
- Indemnification obligations (each party):
- Insurance requirements:
- Cyber liability insurance required?

## TERM & TERMINATION
- Initial term:
- Renewal terms:
- Termination for cause (grounds):
- Notice period for termination:
- Termination for convenience allowed?
- Wind-down period required:
- Data handling post-termination:

## COMPLIANCE VERIFICATION
For operational teams, identify:
- What must we monitor/document for compliance?
- What vendor documentation must we collect/retain?
- Audit schedule (when do we verify SLA performance)?
- Who owns compliance reporting (legal, operations, vendor mgmt)?

## RISK ASSESSMENT
- RED (High) compliance risks
- YELLOW (Medium) compliance risks
- GREEN (Acceptable/Managed)
- Gaps in vendor accountability
- Gaps in compliance verification process

## NEGOTIATION PRIORITIES
- Top 3 terms to modify
- Industry-standard language to propose
- Specific metrics to tighten SLA

I've uploaded a complaint filed against my client. Please provide
a rapid assessment:

## CASE OVERVIEW
- Court and jurisdiction
- Parties and their roles (plaintiff, defendants, etc.)
- Filing date and case number
- Judge assigned (if shown)

## CLAIMS ANALYSIS
For each cause of action:

| Count | Claim Type | Elements Alleged | Key Allegations | Strength |
|-------|-----------|------------------|-----------------|----------|
| 1 | | | | |
| 2 | | | | |

For each claim:
- What must plaintiff prove?
- Specific factual allegations supporting claim
- Damages sought (and type)
- Initial viability assessment (Strong/Moderate/Weak)

## RELIEF SOUGHT
- Compensatory damages (amount claimed):
- Punitive damages requested:
- Injunctive relief (what conduct to stop/require):
- Attorney's fees demand:
- Pre-judgment interest:
- Any unusual remedies:

## CRITICAL DATES & DEADLINES
Based on the court and jurisdiction:
- Estimated answer deadline:
- Motion to dismiss deadline (if applicable):
- Other preliminary deadlines to research:
- Statute of limitations analysis (claim viable?):

## INITIAL DEFENSE ASSESSMENT
- Potential defenses (preliminary list):
- Jurisdictional or procedural challenges:
- Factual disputes apparent from complaint:
- Strength assessment per claim:
- Alternative theories that defeat claim:

## FACTUAL ALLEGATIONS SUMMARY
Organize into narrative by alleged events:
- What allegedly happened:
- When (timeline of events):
- Where (location/jurisdiction):
- Who was involved (individuals, companies):
- Relationships between parties:

## CLIENT COMMUNICATION REQUIREMENTS
- Immediate actions (next 48 hours):
- Information needed from client:
- Documents to preserve/collect:
- People to interview:

## PRELIMINARY COST/TIMELINE ESTIMATE
- Estimated litigation cost (ballpark):
- Expected timeline to resolution:
- Likelihood of summary judgment dismissal:
- Settlement assessment (early/late):

I've uploaded discovery materials, pleadings, and correspondence
from an ongoing litigation. Please create a matter summary:

## MATTER OVERVIEW
- Case name and number:
- Court and judge:
- Parties (plaintiffs, defendants, third parties):
- Case status (phase of litigation):
- Key dates/milestones passed:
- Upcoming critical dates:

## FACTUAL NARRATIVE
Create a chronological summary:
- Background and context:
- Key events leading to dispute:
- Incident/transaction at issue:
- Post-incident events and claims:
- Current status:

## LEGAL CLAIMS & DEFENSES
- Plaintiff's claims (summary):
- Our defenses (summary):
- Counterclaims (if any):
- Third-party claims (if any):

## KEY INDIVIDUALS & ROLES
| Name | Organization | Role | Key Involvement |
|------|--------------|------|-----------------|

## CRITICAL DOCUMENTS
- Contracts at issue:
- Communications showing knowledge/intent:
- Evidence supporting our position:
- Evidence hurting our position:
- Missing documents to pursue in discovery:

## DISCOVERY STATUS
- Discovery phase (initial/ongoing/complete):
- What we've produced:
- What we've received:
- Outstanding requests:
- Likely problem areas in discovery:

## MOTION PRACTICE & PROCEDURAL STATUS
- Pending motions:
- Recent court rulings:
- Upcoming deadlines:

## CURRENT ASSESSMENT
- Likelihood of summary judgment success:
- Trial risk assessment:
- Settlement value estimate:
- Next steps:

I've uploaded 5 service agreements from different vendors offering
similar services. Please perform a comparative analysis:

## COMPARISON FRAMEWORK
Create a master comparison table for each key provision:

### INDEMNIFICATION CLAUSE COMPARISON
| Vendor | Scope of Indemnity | Cap Amount | Cap Exceptions | Survival Period |
|--------|-------------------|-----------|-----------------|-----------------|
| A | IP infringement | $X | None | 5 years |
| B | | | | |

For each vendor, identify:
- Differences in scope (what's covered?)
- Differences in caps (limits on exposure)
- Differences in exceptions to caps
- Differences in survival periods
- Most restrictive vs. most permissive
- Industry standard language

### LIABILITY LIMITATION COMPARISON
| Vendor | Direct Damages Cap | Consequential Damages | Excluded Damages | Exclusions to Cap |
|--------|-------------------|---------------------|------------------|------------------|

### DATA PROTECTION OBLIGATION COMPARISON
| Vendor | Encryption | Access Controls | Audit Rights | Data Residency |
|--------|-----------|-----------------|--------------|-----------------|

### SLA & PERFORMANCE COMPARISON
| Vendor | Uptime Target | Response Time | Resolution Time | Remedy Type |
|--------|---------------|---------------|-----------------|-------------|

## PATTERN ANALYSIS
- Where do vendors cluster (standard market terms)?
- Where does one vendor differ significantly?
- Which differences are likely non-negotiable vs. negotiable?
- What's the "most protective" language across all vendors?

## RISK RANKING
Rank vendors for overall contract favorability to Client:
1. [Vendor] - Reasoning
2. [Vendor] - Reasoning
3. [Vendor] - Reasoning
...

## RECOMMENDED LANGUAGE
For each key clause category, recommend the "best" language
(synthesized from multiple vendors or from industry standards):

**INDEMNIFICATION LANGUAGE TO PROPOSE**:
- Scope recommendation
- Cap recommendation
- Survival recommendation

[Repeat for other key clauses]

## NEGOTIATION STRATEGY
- Which vendor has most favorable base language?
- Where to request movement from each vendor
- What's reasonable to concede
- Walk-away positions

I've uploaded 3 contract versions. Compare their "CONFIDENTIALITY"
clause (usually near end of contract).

| Aspect | Version A | Version B | Version C | Best for Client |
|--------|-----------|-----------|-----------|-----------------|
| Scope | | | | |
| Duration | | | | |
| Exceptions | | | | |
| Return/Destruction | | | | |
| Injunctive Relief | | | | |

Then provide the optimal language we should propose.

I've uploaded [3-5] vendor contracts from our portfolio.
Extract key contract data and output in CSV format that I can
import into Excel:

CONTRACT_ID,VENDOR_NAME,CONTRACT_TYPE,EFFECTIVE_DATE,EXPIRATION_DATE,
TERM_YEARS,AUTO_RENEW,RENEWAL_NOTICE_DAYS,ANNUAL_VALUE,PAYMENT_TERMS,
LIABILITY_CAP,INDEMNIFICATION_SCOPE,SURVIVAL_PERIOD,GOVERNING_LAW,
TERMINATION_FOR_CAUSE,TERMINATION_FOR_CONVENIENCE,EARLY_TERMINATION_FEE,
AUDIT_RIGHTS,DATA_SECURITY_REQUIRED,INSURANCE_REQUIRED,CRITICAL_RISKS,
RENEWAL_DATE_CALENDAR,LAST_REVIEWED_DATE,NOTES

For each contract, complete the row.
Use standard formats:
- Dates: YYYY-MM-DD
- Currency: USD (or specify)
- Yes/No for binary fields
- Leave blank if not applicable/not found
- Notes: Any critical issues or unusual terms

Then provide the data in copy-paste CSV format I can import.

I've uploaded 5 commercial leases. Extract to Excel tracking sheet:

PROPERTY,UNIT,LEASE_ID,LANDLORD,TENANT,EFFECTIVE_DATE,LEASE_EXPIRATION,
INITIAL_TERM_YEARS,RENEWAL_OPTION_1,RENEWAL_NOTICE_DEADLINE,RENEWAL_DATE_1,
BASE_YEAR,ANNUAL_BASE_RENT_YEAR_1,ESCALATION_PCT,CAM_INCLUDED,
NNN_OPERATING_SHARE,PARKING_INCLUDED,USE_RESTRICTIONS,SIGNAGE_RIGHTS,
LEASE_MGMT_NOTES

Output in CSV format for Excel import.

I've uploaded 20 documents from our due diligence package.
Create an index in CSV format for tracking:

DOC_ID,DOCUMENT_NAME,DOCUMENT_TYPE,DATE,FROM_PARTY,TO_PARTY,
SUBJECT_MATTER,PAGE_COUNT,PRIVILEGE_ASSERTION,RESPONSIVE_TO_RFP,
KEY_FINDINGS,CRITICAL_ISSUES,RELEVANCE_SCORE,NEXT_STEPS

Document types: Contract, Email, Internal Memo, Financial Statement,
Correspondence, Regulatory Filing, Board Minutes, Other

Relevance Score: 1-10 (10 = most important to deal analysis)

Output in CSV for Excel.

Output the extracted data as JSON, which I can import into Excel
using Power Query or other tools.

Output as Markdown table, which I can copy directly into Excel.

I'm going to share multiple documents from discovery. For each
document, provide a one-line categorization:

Format: [Doc #] | [Type] | [Date] | [Key Parties] | [Relevance: High/Medium/Low/None] | [Privilege Flag: Y/N]

Types to use:
- EMAIL
- CONTRACT
- INTERNAL_MEMO
- EXTERNAL_CORRESPONDENCE
- FINANCIAL_RECORD
- PERSONNEL_FILE
- MEETING_NOTES
- REPORT
- OTHER

For document [#], which you categorized as HIGH relevance:

1. Full summary (2-3 paragraphs)
2. Key individuals mentioned (with roles if apparent)
3. Dates and timeline of events discussed
4. Specific quotes that may be useful (with page reference)
5. Connection to other documents reviewed
6. Recommended follow-up actions

Based on all documents reviewed in this session:

1. Timeline of key events
2. Cast of characters (who knew what, when)
3. Patterns in communication (who CC'd whom)
4. Gaps in the document production
5. Areas requiring additional discovery
6. Preliminary narrative emerging from documents

I'm uploading 10 contracts from the same vendor.
Extract into a table format:

| Doc | Effective Date | Counterparty | Annual Value | Term | Auto-Renew? | Liability Cap | Key Risk |
|-----|----------------|--------------|--------------|------|-------------|---------------|----------|

Then identify any outliers or inconsistencies across the portfolio.

Extract the following data points from this agreement:

**PARTIES**
- Party A (Full legal name):
- Party A Address:
- Party B (Full legal name):
- Party B Address:

**DATES**
- Effective Date:
- Execution Date:
- Initial Term:
- Renewal Terms:
- Notice Period for Termination:

**FINANCIAL**
- Total Contract Value:
- Payment Terms:
- Price Adjustment Mechanism:
- Late Payment Penalties:

**KEY OBLIGATIONS**
- Party A's Primary Obligations:
- Party B's Primary Obligations:
- Specific Deliverables:
- Milestones:

**RISK TERMS**
- Liability Cap:
- Indemnification Obligations:
- Insurance Requirements:
- Warranty Period:

**GOVERNANCE**
- Governing Law:
- Dispute Resolution:
- Venue:
- Notice Addresses:

Output in JSON format for easy database import.

From this document, extract:

**WHAT HAPPENED**
- Events described:
- Sequence (chronological):
- Location:

**WHO WAS INVOLVED**
- People mentioned (name, role, organization):
- Witnesses to events:
- Decision-makers:

**WHEN**
- Specific dates mentioned:
- Time periods referenced:
- Deadlines or milestones:

**EVIDENCE**
- Documents referenced:
- Communications described:
- Physical evidence mentioned:

**ADMISSIONS/STATEMENTS**
- Statements against interest:
- Acknowledgments:
- Promises made:

Include exact quotes with location reference where applicable.