skill.detail
Back to David Okafor's profileContract review, risk scoring, and negotiation support for SaaS vendor agreements, merger due diligence, and MSAs. Use when reviewing vendor contracts with UCC checklists, scoring clause risks via likelihood-impact matrices, assessing indemnification exposure in mergers, or negotiating MSA terms via decision trees. Key capabilities include 50-point bucketed checklists, Excel risk matrices with auto-sorting, redline prioritization, and reset protocols for uncategorizable clauses. Not for employment contract drafting, IP litigation strategy, or regulatory compliance filings.
Drop this file into your favorite AI tool so it thinks like you every time.
Process 40-60 page vendor agreements for mid-sized SaaS providers in under 4 hours to prioritize redlines and route for approval, because early risk flagging prevents downstream disputes.
Extract clauses using clause-extraction AI on the full document.
Apply 50-point UCC checklist (5 points per bucket, based on UCC Article 2 for licenses and common law for services).
Calculate flag density per bucket and aggregate flags.
Score risks using likelihood-impact matrix (see Decision Rules).
Redline prioritized issues in Word Track Changes, applying Hard Constraints.
Generate client summary and route via DocuSign.
Excel Template for Vendor Review (Produce this structure on request):
Tabs:
- Raw Input: Columns - Clause Text, Bucket (dropdown: 10 options), Flag (Y/N), Density Calc (=COUNTIF(BucketRange,"Remedies")/50)
- Checklist Matrix: Rows 1-50 points, Columns A-J buckets; Conditional Formatting (Red: Non-Compliant)
- Risk Scoring: Likelihood (1-5), Impact (1-5x fees), Score (=Likelihood*Impact), Priority (Low/Med/High)
- Sorted Mediums: SORTBY(Score Descending, Impact Delta, Precedence); VLOOKUP top 3 to Client Summary
- Client Summary: Top Issues (VLOOKUP), Email Draft, DocuSign Links
- Override Log: Mismatch Description, Multiplier (1.2 default), Rationale
Quantify reps/warranties exposure during due diligence to recommend mitigations like R&W insurance, because unquantified risks lead to post-close surprises.
Map reps/warranties to basket thresholds and survival periods.
Stress-test with case law (e.g., Akorn v. Fresenius benchmarks).
Run Monte Carlo simulation in Excel (tied to deal value).
Structure negotiations using decision tree for termination, governing law, and dispute resolution to lock in favorable terms, because flowchart prevents concessions on core protections.
Extract MSA clauses via AI.
Apply decision tree (see Decision Rules for branches).
Redline and route per vendor workflow steps 5-6.
Use these conditional thresholds to classify, sort, and greenlight risks, because numeric criteria enable consistent prioritization across deals.
| Condition | Action | Threshold/Details | Reason |
|---|---|---|---|
| Flag density per bucket | Auto-high alert pre-scoring | >20% (e.g., >2/10 points in remedies) | Clusters signal vendor overreach; prevents masking via averages |
| Risk score calculation | Score = Likelihood x Impact | Likelihood: 1=20%,2=40%,3=60%,4=80%,5=100% (Gartner SLA benchmarks)<br>Impact: 1x=<$100K annual fees, 3x=$500K-$1M, 5x=> $2M | Quantifies probability-weighted exposure for cross-clause comparison |
| Risk classification | Block advance/mandatory redline | Score ≥16 | High scores (>80% likelihood x major impact) exceed risk tolerance |
| Medium branch sorting (10-15 scores) | Sort descending: Score > Impact Delta > IMPACT Formula > Bucket Precedence | Delta = Pre-mitigation - Post-redline<br>IMPACT = Delta * (Feasibility%/100)<br>Precedence: IP > Data Sec > Payment | Ensures highest residual exposure drives client emails; avoids low-feasibility distractions |
| Post-redline for mediums | Greenlight to routing | Score <10 | Confirms mitigations (e.g., carve-outs) reduce to tolerable levels |
| Merger gaps | Recommend R&W insurance | >10% of purchase price | Threshold matches market standards for insurance viability |
| Bucket mismatch | Flag yellow; apply override | Manual precedence + 1.2 multiplier on delta | Adjusts for hybrids without inflating unrelated buckets |
Example: In IP bucket, sort $1.2M unilateral license delta (80% feasibility) over $300K audit right (95% feasibility) using IMPACT formula, because residual gap prioritizes deal-breakers.
Enforce these never/always rules to avoid disputes and scope creep, because violations expose clients to uncapped losses or procedural traps.
Avoid these errors in sorting and bucketing to prevent misprioritization, because flawed deltas lead to over-focusing on low-impact items.
Example: Re-run sorting when template catches junior ranking $300K audit > $800K IP gap, because forced re-run enforces delta priority.
Produce these tools to standardize outputs, because templated automation scales reviews without quality loss.
Always output deliverables in the Excel template structure above, because locked formulas prevent manual overrides.
Detect these signals to invoke overrides or resets, because standard buckets fail on hybrids or novelties.
Example: For biotech gene-editing + unratified Hague clauses, invoke reset to add "Frontier Law" bucket, because it avoids $2M litigation via isolated Rider.
For detailed examples, walkthroughs, and edge cases, consult 'references/REFERENCE.md'.