initiating-coverage · diff
git:20260826.8da358a to git:20260915.b214b52
84 added, 711 removed. Audit A to A.
---
name: initiating-coverage
- description: "Full equity research initiation: company research, financial model, valuation, charts, 30-50 page report"
- license: "Derived from anthropics/financial-services-plugins (Apache-2.0). Modified for langalpha."
+ description: "First-time coverage of a company, or a refresh of coverage already published, run one task per request by default: company research, financial model, valuation, charts, then a 30 to 50 page report with a model. Triggers on initiation report, initiate coverage, initiating coverage, full equity research report, refresh the initiation."
---
# Initiating Coverage
- Create institutional-quality equity research initiation reports through a structured 5-task workflow. Each task must be executed separately with verified inputs.
-
- ## Overview
-
- This skill produces comprehensive first-time coverage reports following institutional standards (JPMorgan, Goldman Sachs, Morgan Stanley format). Tasks are executed individually, each verifying prerequisites before proceeding.
-
- **Default Font**: Times New Roman throughout all documents (unless user specifies otherwise).
-
- ---
-
- ## ⚠️ CRITICAL: One Task at a Time
-
- **THIS SKILL OPERATES IN SINGLE-TASK MODE ONLY.**
-
- ### If User Requests Full Pipeline
-
- When user requests:
- - "Create a coverage initiation report for [Company]"
- - "Write an initiation report for [Company]"
- - "Do the entire equity research process for [Company]"
- - "Complete all 5 tasks for [Company]"
- - Any request that implies running multiple tasks or the entire workflow
-
- **REQUIRED RESPONSE:**
-
- 1. **Ask which specific task to perform:**
- ```
- I can help you create an equity research initiation report for [Company].
- This involves 5 separate tasks that need to be completed individually:
-
- 1. Company Research - Research business, management, industry
- 2. Financial Modeling - Build projection model
- 3. Valuation Analysis - DCF and comparable companies
- 4. Chart Generation - Create 25-35 charts
- 5. Report Assembly - Compile final report
-
- Which task would you like to start with?
- ```
-
- 2. **When user explicitly requests all tasks together:**
- ```
- I understand you'd like to complete the entire initiation report pipeline.
- Currently, this skill supports executing one task at a time, which allows
- for better quality control and review at each stage.
-
- We're working on a seamless end-to-end workflow that will make this process
- more automated, but for now, we'll need to complete each task separately.
-
- Would you like to start with Task 1 (Company Research)?
- ```
-
- 3. **Never automatically assume which task to start** - always ask user to confirm.
-
- 4. **Never execute multiple tasks in sequence** - complete one task, deliver outputs, then wait for next user request.
-
- ### Task Execution Rules
-
- - ✅ Execute exactly ONE task per user request
- - ✅ Always verify prerequisites before starting a task
- - ✅ Deliver task outputs and confirm completion
- - ✅ Wait for user to explicitly request the next task
- - ❌ Never chain multiple tasks together automatically
- - ❌ Never assume user wants to proceed to next task
- - ❌ Never execute Tasks 3-5 without verifying required inputs exist
-
- ### ⚠️ Deliverables Policy: NO SHORTCUTS
-
- **DELIVER ONLY THE SPECIFIED OUTPUTS. DO NOT CREATE EXTRA DOCUMENTS.**
-
- Each task specifies exact deliverables. Do NOT create:
- - ❌ "Completion summaries"
- - ❌ "Executive summaries"
- - ❌ "Quick reference guides"
- - ❌ "Next steps documents"
- - ❌ "Task completion reports"
- - ❌ Any other "helpful" documentation not explicitly specified
-
- **Why**: These extras waste context and are not part of the professional workflow.
-
- **What TO deliver**:
- - ✅ Task 1: Research document (.md) — **NOTHING ELSE**
- - ✅ Task 2: Financial model (.xlsx) — **NOTHING ELSE**
- - ✅ Task 3: Valuation analysis (.md) + Excel tabs added to Task 2 file — **NOTHING ELSE**
- - ✅ Task 4: Charts zip file (.zip) — **NOTHING ELSE**
- - ✅ Task 5: Final report (.docx) — **NOTHING ELSE**
-
- **If a deliverable is not listed above, DO NOT CREATE IT.**
-
- ---
-
- ## Task Selection
-
- Select which task to execute:
-
- | Task | Name | Prerequisites | Output |
- |------|------|--------------|--------|
- | **1** | Company Research | Company name/ticker | 6-8K word document |
- | **2** | Financial Modeling | 10-K or financials access | Excel model (6 tabs) |
- | **3** | Valuation Analysis | Financial model (Task 2) | Valuation + price target |
- | **4** | Chart Generation | Tasks 1, 2, 3 + external data | 25-35 PNG/JPG charts |
- | **5** | Report Assembly | ALL previous tasks (1-4) | 30-50 page DOCX report |
-
- ---
-
- ## How to Use This Skill
-
- ### User Request Patterns and Responses
-
- **Pattern 1: User specifies a specific task**
- ```
- User: "Use initiating-coverage, Task 1 for Tesla"
- Response: ✅ Execute Task 1 immediately
- ```
-
- **Pattern 2: User asks for "initiation report" or "full pipeline"**
- ```
- User: "Create a coverage initiation report for Tesla"
- Response: ❌ DO NOT start any task automatically
- ✅ Ask which task to start with (see template above)
- ```
-
- **Pattern 3: User wants to do "all tasks" or "entire workflow"**
- ```
- User: "I want to complete all 5 tasks for Tesla"
- Response: ❌ DO NOT chain tasks together
- ✅ Explain one-at-a-time limitation (see template above)
- ✅ Ask if they want to start with Task 1
- ```
-
- ### Correct Usage Examples
-
- **Executing a single task:**
- ```
- "Use initiating-coverage skill, Task 1 for Tesla"
- "Do Task 2 of initiating-coverage for Tesla"
- "Run Task 3 for Tesla using the initiating-coverage skill"
- ```
-
- **Completing full report (requires 5 separate requests):**
- ```
- Request 1: "Do Task 1 for Tesla" → Complete → Deliver outputs
- Request 2: "Do Task 2 for Tesla" → Complete → Deliver outputs
- Request 3: "Do Task 3 for Tesla" → Complete → Deliver outputs
- Request 4: "Do Task 4 for Tesla" → Complete → Deliver outputs
- Request 5: "Do Task 5 for Tesla" → Complete → Deliver outputs
- ```
-
- ### Task Execution Order
-
- For a complete initiation report, tasks must be executed in separate user requests following this order:
-
- ```
- Request 1: Task 1 - Company Research (independent)
- ↓ [User reviews outputs and requests next task]
- Request 2: Task 2 - Financial Modeling (independent)
- ↓ [User reviews outputs and requests next task]
- Request 3: Task 3 - Valuation Analysis (requires Task 2 output)
- ↓ [User reviews outputs and requests next task]
- Request 4: Task 4 - Chart Generation (requires Tasks 2 & 3 outputs)
- ↓ [User reviews outputs and requests next task]
- Request 5: Task 5 - Report Assembly (requires ALL previous task outputs)
- ```
-
- **Note**: Tasks 1 and 2 can be run in any order. Tasks 3-5 have strict dependencies and must verify inputs before proceeding.
-
- ---
-
- ## Task 1: Company Research
-
- **Purpose**: Research company's business, management, competitive position, industry, and risks.
-
- **Prerequisites**: ✅ None (fully independent)
- - Company name or ticker symbol
-
- **Process**:
- 1. Verify company name/ticker provided
- 2. Load detailed instructions from references/task1-company-research.md
- 3. Execute qualitative research workflow
- 4. Deliver research document
-
- **Output**: Company Research Document (6,000-8,000 words)
- - Company overview & history
- - Management bios (300-400 words × 3-4 execs)
- - Products & services analysis
- - Industry overview
- - Competitive analysis (5-10 competitors)
- - TAM sizing
- - Risk assessment (8-12 risks)
-
- **File name**: `[Company]_Research_Document_[Date].md`
-
- **⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.**
-
- **⚠️ DO NOT TAKE SHORTCUTS:**
- - ✅ Write full 6,000-8,000 words (not summaries)
- - ✅ Complete 300-400 word bios for ALL 3-4 executives
- - ✅ Analyze ALL 5-10 competitors thoroughly
- - ✅ Cover all 8-12 risks across 4 categories
- - ❌ Do not abbreviate sections to save time
- - ❌ Do not skip any required sections
-
- **Verification before proceeding**: None required for this task.
-
- ---
-
- ## Task 2: Financial Modeling
-
- **Purpose**: Extract historical financials and build comprehensive Excel financial model with projections and scenarios.
-
- **Prerequisites**: ⚠️ Verify before starting
- - **Required**: Access to company financial data
- - For public companies: Latest 10-K from SEC EDGAR
- - For private companies: Financial statements or available estimates
- - OR: Pre-extracted historical financials provided by user
- - **Optional**: Company research (Task 1) for business context
-
- **Input Verification**:
- ```
- BEFORE STARTING - Select approach:
-
- Option A: Extract financials (most common)
- - [ ] Have access to 10-K or financial statements?
- - [ ] Ready to extract 3-5 years of data?
-
- Option B: User provided pre-extracted financials
- - [ ] Historical financials file received?
- - [ ] Contains income statement, cash flow, balance sheet (3-5 years)?
-
- Optional:
- - [ ] Company research (Task 1) complete for context?
- ```
-
- **Process**:
- 1. Verify access to financial data
- 2. Load detailed instructions from references/task2-financial-modeling.md
- 3. **Step 1**: Extract historical financials (if needed)
- 4. **Step 2+**: Build projection model with 6 essential tabs
- 5. Deliver Excel model
-
- **Output**: Excel Financial Model (.xlsx)
- - 6 essential tabs:
- 1. **Revenue Model** - Product breakdown (20-30 rows) + Geography breakdown (15-20 rows)
- 2. **Income Statement** - Full P&L with 40-50 line items, historical (3-5 years) + projected (5 years)
- 3. **Cash Flow Statement** - Operating/Investing/Financing activities, historical + projected
- 4. **Balance Sheet** - Assets/Liabilities/Equity, historical + projected
- 5. **Scenarios** - Bull/Base/Bear comparison table
- 6. **DCF Inputs** - Prepared for Task 3 valuation
-
- **File name**: `[Company]_Financial_Model_[Date].xlsx`
-
- **⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.**
-
- **⚠️ DO NOT TAKE SHORTCUTS:**
- - ✅ If extracting financials: Extract ALL line items from 3 financial statements (3-5 years)
- - ✅ Build ALL 6 projection tabs completely with full detail
- - ✅ Create detailed revenue model with 20-30 product rows AND 15-20 geography rows
- - ✅ Build complete income statement with 40-50 line items (not abbreviated)
- - ✅ Include full cash flow statement and balance sheet with all line items
- - ✅ Complete ALL three scenarios (Bull/Base/Bear) with different parameters
- - ❌ Do not create simplified/abbreviated versions
- - ❌ Do not skip any of the 6 essential tabs
- - ❌ Do not skip historical financials extraction if needed
-
- **Verification before proceeding to Task 3**:
- - [ ] Historical financials extracted (if needed) or provided
- - [ ] Excel file created and can be opened
- - [ ] Model has all 6 essential tabs (Revenue Model, Income Statement, Cash Flow, Balance Sheet, Scenarios, DCF Inputs)
- - [ ] Historical data (3-5 years) incorporated
- - [ ] Projections complete (5 years forward)
- - [ ] Scenarios complete (Bull/Base/Bear)
-
- ---
-
- ## Task 3: Valuation Analysis
-
- **Purpose**: Perform comprehensive valuation using DCF, comparables, and precedent transactions.
-
- **Prerequisites**: ⚠️ Verify before starting
- - **Required**: Financial model from Task 2
- - Projected income statements
- - Projected cash flows
- - Revenue and EBITDA forecasts
- - DCF inputs (unlevered FCF)
-
- **⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASK 2 IS COMPLETE**
-
- This task requires the financial model from Task 2. Starting without it will result in incomplete work.
-
- **IF TASK 2 IS NOT COMPLETE**: Stop immediately and inform the user that Task 2 (Financial Modeling) must be completed first. Do not attempt to proceed or create placeholder valuations.
-
- **Input Verification**:
- ```
- BEFORE STARTING:
- - [ ] Task 2 complete? (Financial model exists)
- - [ ] Model file path/location known?
- - [ ] Can access projected financials from model?
-
- Required from model:
- - [ ] Projected FCF (5 years)
- - [ ] Revenue projections
- - [ ] EBITDA projections
- - [ ] Terminal year metrics
- ```
-
- **Process**:
- 1. Verify financial model is accessible
- 2. Load detailed instructions from references/task3-valuation.md
- 3. Execute valuation workflow
- 4. Deliver valuation analysis
-
- **Output**: Valuation Analysis (4-6 pages + Excel tabs)
- - DCF analysis with sensitivity tables
- - Comparable companies (5-10 peers with statistical summary)
- - Precedent transactions (if applicable)
- - Valuation football field
- - **Price target**: $XX.XX
- - **Recommendation**: BUY/HOLD/SELL
- - **Upside**: XX%
- - Key catalysts (3-5)
-
- **Files**:
- - `[Company]_Valuation_Analysis_[Date].md` (written analysis document)
- - Excel tabs added to `[Company]_Financial_Model_[Date].xlsx` (from Task 2)
- - DCF tab with calculations
- - Sensitivity analysis tab
- - Comparable companies tab
- - Valuation summary tab
-
- **⚠️ DELIVER ONLY: 1 markdown file + 4 tabs added to existing Excel. NO completion summaries, no extra documents.**
-
- **⚠️ DO NOT TAKE SHORTCUTS:**
- - ✅ Complete full DCF analysis with sensitivity matrix (not simplified)
- - ✅ Analyze ALL 5-10 comparable companies with full data
- - ✅ Include statistical summary in comps table (max/75th/median/25th/min)
- - ✅ Create complete sensitivity analysis tab with multiple WACC and terminal growth scenarios
- - ✅ Write full 4-6 pages of valuation analysis (not abbreviated)
- - ✅ Research and justify price target with specific methodology
- - ❌ Do not skip comparable company analysis
- - ❌ Do not create simplified DCF without sensitivity
-
- **Verification before proceeding to Task 4**:
- - [ ] Price target determined
- - [ ] Valuation uses multiple methods (DCF + Comps minimum)
- - [ ] DCF sensitivity table complete
- - [ ] Comparable companies table includes statistical summary
-
- ---
-
- ## Task 4: Chart Generation
-
- **Purpose**: Generate 25-35 professional financial charts for the report.
-
- **Prerequisites**: ⚠️ Verify before starting
- - **Required**: Company research from Task 1
- - Company history and milestones (for timeline charts)
- - Management team and org structure (for org charts)
- - Product portfolio (for product charts)
- - Customer segmentation (for customer charts)
- - Competitive landscape (for competitive charts)
- - TAM analysis (for market size charts)
- - **Required**: Financial model from Task 2 (with Task 3 valuation tabs added)
- - Revenue by product/geography data (Task 2 tabs)
- - Margin trends (Task 2 tabs)
- - Scenario comparison data (Task 2 tabs)
- - DCF sensitivity table (Task 3 tab in same Excel file)
- - Comparable companies data (Task 3 tab in same Excel file)
- - Valuation ranges (Task 3 tab in same Excel file)
- - **Required**: External market data
- - Historical stock price data (Yahoo Finance, Bloomberg, etc.)
- - Historical valuation multiples (for historical trend charts)
-
- **⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASKS 1, 2, AND 3 ARE COMPLETE**
-
- This task requires outputs from all three previous tasks. Starting without them will result in incomplete charts.
-
- **IF ANY OF TASKS 1, 2, OR 3 ARE NOT COMPLETE**: Stop immediately and inform the user which tasks need to be completed first. The specific requirements are:
- - Task 1: Company research document (for 9 charts)
- - Task 2: Financial model with all 6 tabs (for 8 charts)
- - Task 3: Valuation tabs added to the model (for 6 charts)
- - External data access (for 2 charts)
+ A first-time coverage report: the argument for or against owning a company, built from original research, a full model and a defended valuation. Five tasks, one per request by default, each verifying its inputs before it starts. The deliverables are a 30 to 50 page DOCX and an XLSX model, with typography set by `.agents/skills/docx/SKILL.md`.
- Do not attempt to create placeholder charts or skip charts due to missing data.
+ Evidence labels, source tiers, staleness, the readiness posture and the intake limits: `.agents/skills/research-conventions/SKILL.md`, read before the first deliverable.
- **Input Verification**:
- ```
- BEFORE STARTING:
- - [ ] Task 1 complete? (Company research exists)
- - [ ] Task 2 complete? (Financial model exists)
- - [ ] Task 3 complete? (Valuation analysis exists)
- - [ ] Can access external market data sources?
+ ## One task per request
- Required from Task 1:
- - [ ] Company history and milestones (for charts 05, 06)
- - [ ] Management team structure (for chart 07)
- - [ ] Product portfolio details (for chart 08)
- - [ ] Customer segmentation data (for chart 09)
- - [ ] Competitive landscape analysis (for charts 16, 17, 18)
- - [ ] TAM sizing and market data (for chart 15)
+ This skill runs one task per request by default: execute the task, deliver its file, and stop, so the user can review before the next.
- Required from Task 2:
- - [ ] Revenue by product (historical + projected) - for chart 03 ⭐
- - [ ] Revenue by geography (historical + projected) - for chart 04 ⭐
- - [ ] Income statement with margins (for charts 02, 10, 11)
- - [ ] Cash flow statement (for chart 12)
- - [ ] Scenario comparison data (for chart 14)
+ That stop is an intake exception and yields under `.agents/skills/research-conventions/references/intake.md`. When the user asked for the whole pipeline in one request ("do all five tasks", "run the whole initiation") or this skill is running as an input to another workflow, run the tasks in order without stopping between them, naming at each handoff the task just finished.
- Required from Task 3:
- - [ ] DCF sensitivity matrix - for chart 28 ⭐
- - [ ] DCF components (for chart 29)
- - [ ] Comparable companies data (for charts 30, 31)
- - [ ] Valuation ranges - for chart 32 ⭐
+ When the request names no task and does not ask for the whole run ("write an initiation report for X"), reply with the task list and ask which one to begin, in roughly this shape:
- Required from External Sources:
- - [ ] Historical stock price data (for chart 01)
- - [ ] Historical valuation multiples (for chart 34)
```
-
- **Process**:
- 1. Verify model and valuation outputs are accessible
- 2. Load detailed instructions from references/task4-chart-generation.md
- 3. Execute chart generation workflow
- 4. Package all charts into a zip file
- 5. Deliver zip file
-
- **Output**: 25-35 Professional Chart Files (PNG/JPG, 300 DPI) packaged in zip
-
- **4 MANDATORY Charts** (must be present) ⭐:
- - chart_03: Revenue by product (stacked area)
- - chart_04: Revenue by geography (stacked bar)
- - chart_28: DCF sensitivity (2-way heatmap)
- - chart_32: Valuation football field (horizontal bars)
-
- **25 REQUIRED Charts** (specific list):
- - Investment Summary: chart_01
- - Financial Performance: charts 02, 03⭐, 04⭐, 10, 11, 12, 14
- - Company 101: charts 05, 06, 07, 08, 09, 15, 16
- - Competitive/Market: charts 17, 18
- - Scenario Analysis: chart 13
- - Valuation: charts 28⭐, 29, 30, 31, 32⭐, 33, 34
-
- **10 OPTIONAL Charts** (for 26-35 range):
- - charts 19-27, 35 (customer acquisition, unit economics, product roadmap, etc.)
-
- **IMPORTANT**: Task 5 embeds ALL charts created (25-35) for visual density (1 chart per 200-300 words).
-
- **File naming**: `chart_01_description.png`, `chart_02_description.png`, etc.
-
- **Deliverable**: `[Company]_Charts_[Date].zip` containing all 25-35 chart files + chart_index.txt
-
- **⚠️ DELIVER ONLY THIS 1 ZIP FILE. NO completion summaries, no separate chart lists, no extra documents.**
-
- **⚠️ DO NOT TAKE SHORTCUTS:**
- - ✅ Create ALL 25 required charts minimum (specific list provided in task4-chart-generation.md)
- - ✅ Include ALL 4 mandatory charts:
- - chart_03: Revenue by product (stacked area) ⭐
- - chart_04: Revenue by geography (stacked bar) ⭐
- - chart_28: DCF sensitivity (heatmap) ⭐
- - chart_32: Valuation football field ⭐
- - ✅ Optional: Add 1-10 more charts to reach 26-35 total for greater visual density
- - ✅ Generate professional-quality charts at 300 DPI (not low-res placeholders)
- - ✅ Create unique, well-formatted charts for each visualization
- - ✅ Package all charts in zip file with chart index
- - ❌ Do not create only 10-15 charts (minimum is 25)
- - ❌ Do not skip any of the 4 mandatory charts
- - ❌ Do not use low-quality/placeholder images
-
- **Verification before proceeding to Task 5**:
- - [ ] Minimum 25 chart files created (required)
- - [ ] All 4 mandatory charts present:
- - [ ] chart_03: Revenue by product ⭐
- - [ ] chart_04: Revenue by geography ⭐
- - [ ] chart_28: DCF sensitivity ⭐
- - [ ] chart_32: Valuation football field ⭐
- - [ ] All charts open and display correctly
- - [ ] Charts saved at 300 DPI (print quality)
- - [ ] Chart index created listing all files with categories
- - [ ] All charts packaged in zip file
- - [ ] File naming follows convention: chart_##_description.png
-
- ---
-
- ## Task 5: Report Assembly
-
- **Purpose**: Write and assemble the comprehensive final DOCX report.
-
- **Prerequisites**: ⚠️ Verify before starting
- - **Required**: Company research from Task 1
- - All 6-8K words of content
- - Management bios
- - Competitive analysis
- - Risk assessment
- - **Required**: Financial model from Task 2
- - Excel workbook
- - All projections and scenarios
- - **Required**: Valuation analysis from Task 3
- - Price target and recommendation
- - DCF, comps, precedent transactions
- - All valuation data
- - **Required**: Chart files from Task 4
- - Zip file containing all 25-35 PNG/JPG files
- - Chart index included in zip
-
- **⚠️ CRITICAL: DO NOT START THIS TASK UNLESS ALL TASKS 1-4 ARE COMPLETE**
-
- This is the final assembly task. It cannot be completed without all previous work products.
-
- **IF ANY OF TASKS 1, 2, 3, OR 4 ARE NOT COMPLETE**: Stop immediately and inform the user which tasks need to be completed first. The specific requirements are:
- - Task 1: Company research document (6-8K words)
- - Task 2: Financial model with all 6 tabs
- - Task 3: Valuation analysis with price target and recommendation
- - Task 4: Charts zip file with 25-35 charts
+ An initiation for [Company] runs as five tasks, one per request:
- Do not attempt to create placeholder content, substitute missing sections, or assemble an incomplete report. The report requires ALL inputs to be publication-ready.
+ 1. Company research 4. Chart generation
+ 2. Financial modelling 5. Report assembly
+ 3. Valuation analysis
- **Input Verification**:
+ Each one delivers its file and stops, so you can review before the next.
+ Which would you like to start with?
```
- BEFORE STARTING - ALL TASKS MUST BE COMPLETE:
- Task 1 Verification:
- - [ ] Company research document exists? (6-8K words)
- - [ ] Management bios complete? (300-400 words × 3-4 execs)
- - [ ] Competitive analysis complete? (5-10 competitors)
- - [ ] Risk assessment complete? (8-12 risks)
-
- Task 2 Verification:
- - [ ] Financial model exists and can be opened?
- - [ ] Model has projections (5 years)?
- - [ ] Scenarios exist (Bull/Base/Bear)?
-
- Task 3 Verification:
- - [ ] Valuation analysis complete?
- - [ ] Price target determined?
- - [ ] Recommendation set? (BUY/HOLD/SELL)
- - [ ] DCF and comps complete?
+ Either way, never assume a task the user did not ask for, and never start a task whose prerequisites are unverified.
- Task 4 Verification:
- - [ ] Chart zip file exists?
- - [ ] Can extract/access all 25-35 chart files from zip?
- - [ ] All 4 mandatory charts present?
- - [ ] Revenue by product (stacked area)
- - [ ] Revenue by geography (stacked bar)
- - [ ] DCF sensitivity (heatmap)
- - [ ] Valuation football field
- - [ ] Chart files accessible and can be opened?
+ ## Task map
- IF ANY VERIFICATION FAILS: Stop and complete missing task first.
- ```
+ | Task | Prerequisites | Deliverable |
+ |---|---|---|
+ | 1 Company research | company name or ticker | `[Company]_Research_Document_[Date].md`, 6,000 to 8,000 words |
+ | 2 Financial modelling | financial statements or 10-K access | `[Company]_Financial_Model_[Date].xlsx`, the manifest's Task 2 sheets |
+ | 3 Valuation analysis | Task 2 | `[Company]_Valuation_Analysis_[Date].md` plus the manifest's Task 3 sheets, added to the Task 2 workbook |
+ | 4 Chart generation | Tasks 1, 2, 3 | `[Company]_Charts_[Date].zip`, 25 to 35 charts at 300 DPI |
+ | 5 Report assembly | Tasks 1, 2, 3, 4 | `[Company]_Initiation_Report_[Date].docx` |
- **Process**:
- 1. **CRITICAL**: Verify ALL prerequisites before starting
- 2. Load detailed instructions from references/task5-report-assembly.md
- 3. Execute report assembly workflow using Claude's built-in skills:
- - **Use DOCX skill** to create and manipulate the Word document
- - **Use XLSX skill** to read Excel data from Task 2/3
- - **Use Read tool** to read Task 1 and Task 3 markdown files
- - Read Task 1 .md file → Convert to Word formatting → Insert charts inline
- - Read Task 2 .xlsx file → Extract tables → Write quantitative analysis
- - Read Task 3 .md file + Excel tabs → Copy/adapt valuation analysis
- - Insert Task 4 .png chart files throughout using DOCX skill
- - Create text-dense report with charts interspersed every 200-300 words
- 4. Save and deliver final DOCX report
+ Tasks 1 and 2 are independent of each other and can run in either order. Tasks 3, 4 and 5 have hard dependencies: verify the named inputs exist and can be opened, and when one is missing, stop and say which task supplies it rather than building a placeholder.
- **Key Principles**:
- - Use Claude's DOCX and XLSX skills (NOT Python libraries)
- - Use actual file operations (read .md/.xlsx/.png files, write .docx file)
- - Good equity research reports are text-dense with lots of illustrating images (60-80% page coverage, 1+ chart per page)
+ ## Workbook manifest
- **🔥 CRITICAL: GO ALL OUT ON THIS TASK**
+ Tasks 2 and 3 build one file, `[Company]_Financial_Model_[Date].xlsx`. Its sheets, in this order, are enumerated here and pointed at from everywhere else:
- **THIS IS THE FINAL DELIVERABLE. DO NOT TAKE SHORTCUTS.**
+ `Cover`, `Revenue Model`, `Income Statement`, `Cash Flow Statement`, `Balance Sheet`, `Scenarios`, `DCF Inputs`, `DCF`, `Sensitivity Analysis`, `Comparable Companies`, `Precedent Transactions` (optional), `Valuation Summary`, `Checks`.
- - ✅ **Use full token budget** - This is the culmination of all previous work
- - ✅ **Write every section completely** - Do not summarize or abbreviate
- - ✅ **Hit ALL minimum requirements** - 30+ pages, 10,000+ words, 25+ charts, 12+ tables
- - ✅ **Be thorough on projection assumptions** - 2,000-3,000 words with product-by-product detail
- - ✅ **Be comprehensive on scenarios** - 1,500-2,000 words with specific Bull/Base/Bear parameters
- - ✅ **Insert ALL charts from Task 4** - Not just a few, ALL 25-35 charts throughout
- - ✅ **Create ALL tables from Task 2/3** - Extract every financial table, don't skip any
- - ✅ **Use Task 1 content verbatim** - Copy/paste full Company 101 sections (6-8K words)
- - ✅ **Professional quality only** - This must be indistinguishable from JPMorgan/Goldman Sachs research
+ Task 2 builds `Cover`, the six core operating tabs `Revenue Model` through `DCF Inputs`, and `Checks`. Task 3 adds the four valuation tabs `DCF`, `Sensitivity Analysis`, `Comparable Companies` and `Valuation Summary`, adds `Precedent Transactions` where the deal set supports one, and extends `Cover` and `Checks` to cover them. Twelve sheets, thirteen with `Precedent Transactions`. What `Cover` and `Checks` each hold, and why the file opens on one and closes on the other, are in `.agents/skills/xlsx/SKILL.md`.
- **NEVER:**
- - ❌ "This section would include..." - WRITE THE ACTUAL SECTION
- - ❌ "Charts would be inserted here..." - INSERT THE ACTUAL CHARTS
- - ❌ "See financial model for details..." - EXTRACT AND INCLUDE THE DETAILS
- - ❌ Skip sections due to length - Every section MUST be complete
- - ❌ Abbreviate for token conservation - Use whatever tokens are needed
+ ## Standing rules
- **This is publication-ready institutional research. Spare no effort, tokens, or detail.**
+ These bind every task.
- **Output**: Comprehensive Equity Research Report (.docx)
+ **Deliver one file per task, plus the delivery message Task 5 specifies, and no additional files.** No standalone executive summary, no quick-reference guide, no next-steps document. Extras cost context and are not part of the workflow.
- **Specifications**:
- - **Length**: 30-50 pages (MINIMUM 30)
- - **Word count**: 10,000-15,000 words (MINIMUM 10,000)
- - **Charts**: 25-35 embedded images
- - **Tables**: 12-20 comprehensive tables
- - **Format**: Professional DOCX with clickable hyperlinks
+ **Never overwrite the user's own file.** When the user supplied a model or a draft, produce a versioned copy or an additive companion, and mark what changed.
- **Structure**:
- - Page 1: Investment Summary (INITIATING COVERAGE format)
- - Pages 2-5: Investment thesis & risks
- - Pages 6-17: Company 101
- - Pages 18-30: Financial analysis & projections
- - Pages 31-40: Valuation analysis
- - Pages 41-50: Appendices
+ **The minimums are floors, not targets.** Word counts, chart counts and table counts below are the point at which a section stops being a stub. They are met by analysis, never by padding, and `assets/quality-checklist.md` says where the words go and what to cut.
- **File name**: `[Company]_Initiation_Report_[Date].docx`
+ **Every material claim carries its evidence label and its source.** Labels, source tiers, the conflict protocol and the staleness thresholds live in `.agents/skills/research-conventions/references/evidence.md`. Keep a source register as you work, one row per source: id, name, type, publication date, access date, period covered, location inside the document, tier, and whether it is stale. The register becomes the report's data-sources page, so building it during research costs nothing and rebuilding it at the end costs a day.
- **⚠️ DELIVER ONLY THIS 1 DOCX FILE. NO executive summaries, no "highlights" documents, no extra files.**
+ **Evidence confidence and underwriting status are two different fields.** High confidence in the numbers does not mean the position can be underwritten: the numbers can be excellent and the capital structure, the valuation or the disclosure still leave ownership unsupportable. Both appear on the report cover, and neither substitutes for the other.
- **Final Verification**:
- - [ ] Report is 30-50 pages
- - [ ] Word count is 10,000-15,000
- - [ ] 25-35 charts embedded
- - [ ] 12-20 tables included
- - [ ] All citations are clickable hyperlinks
- - [ ] Numbers match financial model exactly
+ ## Step 0: Classify the initiation
- ---
+ Before Task 1, name the mode. It decides which content is required, how long each section runs and what tone the argument takes: a buy-side deep dive is short on boilerplate and long on falsifiability, a long-only initiation centres durability and capital allocation, a sector launch maps the battlefield before naming winners.
- ## Input Verification Protocol
+ The eight modes, what each one requires and what each one cuts: `references/report-modes.md`. Read it once at Step 0 and carry the mode through every later task.
- ### Why Input Verification Matters
+ **Complete when** the mode is written down in one line with the reader it serves, and every later task's content list has been checked against it.
- Each task has strict prerequisites. Running a task without required inputs will:
- - Waste time with incomplete work
- - Produce low-quality outputs
- - Require rework
+ ## Task 1: Company research
- **Always verify inputs before starting a task.**
+ Business, management, competitive position, industry, TAM and risks. Detailed workflow in `references/task1-company-research.md`; the shape a thesis pillar, a debate and a risk row must take is in `references/argument-standards.md`.
- ### Verification Checklist by Task
+ **Thin context.** When the company is too thinly covered to research properly (a recent listing, a foreign private issuer with sparse English disclosure, a carve-out with no standalone history), do not fill the gap with plausible detail. Deliver a skeleton instead: the research agenda, the model architecture the company would need, the specific source requests that would unblock it, and the thesis hypotheses to be tested. Say plainly that it is a skeleton and what would upgrade it.
- **Task 1**: ✅ No verification needed (independent)
+ **Complete when** the document runs 6,000 to 8,000 words and carries: the company overview and history; 300 to 400 word bios for each of 3 to 4 executives; products and services; the industry; 5 to 10 competitors analysed rather than listed; TAM with its build; 8 to 12 risks across the four categories; and three to five thesis pillars each with the four parts required by `references/argument-standards.md`.
- **Task 2**: Check historical financials available
+ **A skeleton completes instead** when it carries all four items named in the thin-context paragraph above, says on its first page that it is a skeleton and what would upgrade it, and contains no invented detail. The word count, the bios and the competitor and risk counts do not apply to it.
- **Task 3**: Check financial model exists and is accessible
+ ## Task 2: Financial modelling
- **Task 4**: Check both model (Task 2) AND valuation (Task 3) exist
+ Extract the historicals, then build the projection model. Detailed workflow in `references/task2-financial-modeling.md`. Workbook construction rules, live formulas and the Checks sheet belong to `.agents/skills/xlsx/SKILL.md`.
- **Task 5**: Check ALL previous tasks complete (1, 2, 3, 4)
+ **Before starting**, confirm one of: access to the 10-K or the statements; or historical financials the user supplied covering income statement, cash flow and balance sheet for 3 to 5 years.
- ### What to Do if Verification Fails
+ **Complete when** the workbook opens and holds every Task 2 sheet of the workbook manifest, with 3 to 5 years of history and 5 years of projections; the revenue model carries 20 to 30 product rows and 15 to 20 geography rows; the income statement carries 40 to 50 line items; and all three scenarios differ in their parameters rather than in their labels.
- ```
- IF prerequisites are missing:
- 1. Stop the current task
- 2. Identify which prerequisite task(s) need to be completed
- 3. Execute the missing task(s) first
- 4. Return to current task once prerequisites are met
- ```
+ ## Task 3: Valuation analysis
- ### Example Verification Dialogue
+ DCF, comparables and, where the market supports it, precedent transactions. Workflow in `references/task3-valuation.md`; method selection with its mandatory caveats, the financed-growth gate, the revenue-multiple demotion rule, the EPS-basis rule and the target-price bridge are in `references/valuation-methodologies.md`.
- ```
- User: "Use initiating-coverage, Task 5 for Tesla"
+ **Prerequisite gate.** Task 2 must be complete and its workbook openable. Without it, stop and say so: a valuation built on placeholder projections is worse than no valuation, because it looks finished.
- Claude: "Starting Task 5: Report Assembly for Tesla
+ **Market-data completion.** Before any conclusion, actively retrieve and timestamp: current price (`get_daily_prices` or the ambient feed), market cap, fully diluted share count, the enterprise-value bridge inputs (gross debt, capitalised leases, preferred, minority interest, cash), and the available consensus context (`get_company_overview`). Anything that cannot be retrieved is labelled with the specific conclusion it blocks, not left blank.
- VERIFICATION - Checking prerequisites:
- - Task 1 (Company research)... ❌ NOT FOUND
- - Task 2 (Financial model)... ❌ NOT FOUND
- - Task 3 (Valuation)... ❌ NOT FOUND
- - Task 4 (Charts)... ❌ NOT FOUND
+ **Preliminary and watchlist posture.** When the valuation or the capital stack cannot be established, the honest output is a preliminary or watchlist initiation: label the document as such, list the evidence required before ownership can be underwritten, and publish no target price. An invented target is the single most damaging thing this skill can produce, because every downstream reader treats it as underwritten.
- ⚠️ VERIFICATION FAILED
+ **Complete when** the price target exists as a range with a point inside it and carries every element of the target-price bridge; at least two methods contribute, each with its mandatory caveat stated; the DCF sensitivity matrix and the comps table with its statistical summary (max, 75th, median, 25th, min) are built; the financed-growth gate has either passed or forced the preliminary posture; and the written analysis runs 4 to 6 pages.
- Task 5 requires ALL previous tasks to be complete.
+ **A preliminary or watchlist initiation completes instead** when the document carries that label, holds no target price anywhere, lists as a numbered set the evidence required before ownership can be underwritten with the conclusion each missing input blocks, and states the caveat on whatever valuation work the available inputs did support.
- To proceed:
- 1. Complete Task 1: Company Research
- 2. Complete Task 2: Financial Modeling
- 3. Complete Task 3: Valuation Analysis
- 4. Complete Task 4: Chart Generation
- 5. Then return to Task 5
+ ## Task 4: Chart generation
- Would you like to start with Task 1 first?"
- ```
+ 25 to 35 charts at 300 DPI. Workflow and per-chart specifications in `references/task4-chart-generation.md`.
- ---
+ **Prerequisite gate.** Tasks 1, 2 and 3 all complete: Task 1 supplies 9 charts, Task 2 supplies 8, Task 3 supplies 6, and market data supplies 2. Market data comes from `get_stock_data` on the price-data MCP server for the price history (the direct `get_daily_prices` tool summarises any window past fourteen trading days) and `get_financial_ratios` for the multiple bands, each with its retrieval date recorded for the source line.
- ## Task Reference Files
+ **Complete when** at least 25 charts exist as real image files, the four mandatory charts are among them (chart_03 revenue by product as stacked area, chart_04 revenue by geography as stacked bar, chart_28 DCF sensitivity as a two-way heat map, chart_32 valuation football field as horizontal bars), every file follows `chart_NN_description.png`, and the zip contains them plus `chart_index.txt`.
- Detailed instructions for each task are in separate reference files to keep this skill lean:
+ ## Task 5: Report assembly
- - **references/task1-company-research.md** - Company research workflow
- - **references/task2-financial-modeling.md** - Financial modeling workflow
- - **references/task3-valuation.md** - Valuation methodology
- - Also see: references/valuation-methodologies.md for DCF/comps deep dive
- - **references/task4-chart-generation.md** - Chart generation workflow
- - **references/task5-report-assembly.md** - Report writing workflow
- - Also see: assets/report-template.md for report structure
- - Also see: assets/quality-checklist.md for quality checks
+ Write and assemble the DOCX. Workflow in `references/task5-report-assembly.md`, page-by-page structure in `assets/report-template.md`, and the delivery gate in `assets/quality-checklist.md`. Build through `.agents/skills/docx/SKILL.md` and read the model through `.agents/skills/xlsx/SKILL.md`.
- **When to load reference files**: Load ONLY the reference file associated with the specific task being performed. These files are very large - do not load multiple reference files at once. Read the appropriate task reference file at the start of the task for detailed step-by-step instructions.
+ **Prerequisite gate.** All four prior deliverables exist and open. Verify each one before writing a word, and when one is missing, name it and stop.
- ---
+ This is the task where effort shows. Write every section in full: 2,000 to 3,000 words on projection assumptions, 1,500 to 2,000 on scenarios, and the Task 1 research carried across rather than re-summarised. "This section would cover..." and "see the model for detail" are both failures. Embed every chart from Task 4, not a selection. Where `references/task5-report-assembly.md` calls for carrying a Task 1 section across near-verbatim and the mode in `references/report-modes.md` cuts that section, the mode's cut list wins.
- ## Quality Standards
+ **The cover carries five fields**: rating or posture, price target or the preliminary label, evidence confidence, underwriting status, and the initiation mode from Step 0.
- All outputs meet institutional standards from leading investment banks (JPMorgan, Goldman Sachs, Morgan Stanley):
+ **One rating ladder.** The report prints one rating, `Buy`, `Hold` or `Sell`, beside the action verb from `.agents/skills/research-conventions/references/judgment.md`.
- - **Comprehensive**: Meet all minimum requirements
- - **Detailed**: Specific data and examples, not generic statements
- - **Quantified**: Lead with numbers and metrics
- - **Cited**: Proper sources with clickable hyperlinks
- - **Professional**: Institutional-quality formatting
- - **Accurate**: All numbers verified and cross-checked
+ **Convert the argument into falsifiable claims** before delivery: two to five claims, each with evidence, implication, test metric, falsifier and time to knowable, per `.agents/skills/research-conventions/references/judgment.md`. Fewer than two means the report holds no view.
- ---
+ **Section titles state the finding, not the topic.** "Contract structure caps downside through 2029" beats "Contract overview". A heading that could sit above any company's section is a heading that says nothing.
- ## Important Notes
+ **Complete when** the report is 30 to 50 pages and 10,000 to 15,000 words with 25 to 35 embedded charts and 12 to 20 tables; every number matches the model exactly; every citation is a working hyperlink; the cover carries all five fields; and `assets/quality-checklist.md` passes end to end.
- ### Task Independence
+ Deliver with a short message naming the mode, the thesis pillars, the open debates, the valuation method and target, the catalysts, the disconfirming signals and the open questions, so the next skill inherits the argument rather than re-deriving it.
- - **Task 1** can run anytime (no dependencies)
- - **Task 2** can run anytime (just needs historical data)
- - **Tasks 1 & 2** can run in parallel
- - **Task 3** requires Task 2
- - **Task 4** requires Tasks 2 & 3
- - **Task 5** requires Tasks 1, 2, 3, & 4
+ ## Reference files
- ### Session Management
+ Load only the file for the task in front of you; they are large.
- **Same session**: Outputs automatically available to subsequent tasks
+ - Running a task: `references/task1-company-research.md`, `references/task2-financial-modeling.md`, `references/task3-valuation.md`, `references/task4-chart-generation.md`, `references/task5-report-assembly.md`.
+ - Classifying the initiation at Step 0, or checking what a mode requires: `references/report-modes.md`.
+ - Writing a thesis pillar, a key-debates row, a risk row or a catalyst group, in Task 1 or Task 5: `references/argument-standards.md`.
+ - Choosing a valuation method, valuing a capital-intensive or financed-growth business, or building the target-price bridge, in Task 3: `references/valuation-methodologies.md`.
+ - Page-by-page report layout in Task 5: `assets/report-template.md`.
+ - Before delivering Task 5: `assets/quality-checklist.md`.
- **Different sessions**: Reference previous task outputs explicitly
- ```
- "Use Task 3 with the model from yesterday at [path]"
- "Use Task 5 with the research document at [path]"
- ```
+ ## Working across sessions
- ### File Organization
+ Outputs from earlier tasks in the same session are available directly. Across sessions, the request names the path: "Task 3 with the model at [path]". Keep the five deliverables in one folder per company so a later task can find them:
- Recommended structure during workflow:
```
- ProjectFolder/
- ├── Task1_Research/
- │ └── [Company]_Research_Document.md
- ├── Task2_Model/
- │ └── [Company]_Financial_Model.xlsx
- ├── Task3_Valuation/
- │ └── [Company]_Valuation_Analysis.pdf
- ├── Task4_Charts/
- │ ├── chart_01.png
- │ └── ... (25-35 files)
- └── Task5_Report/
- └── [Company]_Initiation_Report.docx
+ [Company]/
+ Task1_Research/ [Company]_Research_Document.md
+ Task2_Model/ [Company]_Financial_Model.xlsx
+ Task3_Valuation/ [Company]_Valuation_Analysis.md
+ Task4_Charts/ chart_01..chart_35.png, chart_index.txt
+ Task5_Report/ [Company]_Initiation_Report.docx
```
-
- ### No End-to-End Execution
-
- This skill does **NOT** support running all tasks automatically in sequence. Each task must be explicitly requested and verified.
-
- **Why**: This ensures:
- - Quality control at each stage
- - Ability to review outputs before proceeding
- - Flexibility to pause/resume workflow
- - Clear verification of prerequisites
-
- ---
-
- ## Success Criteria
-
- A successful initiation report workflow should:
- 1. Complete all 5 tasks in order
- 2. Pass all input verifications
- 3. Meet all quality standards
- 4. Produce all required deliverables
- 5. Numbers cross-check between outputs
- 6. Final report is publication-ready
-
- **Output quality**: Institutional (JPMorgan/Goldman/Morgan Stanley level)
- **Use case**: First-time comprehensive coverage of a company