Skill Tracer
Skills › Financial Services › initiating-coverage

initiating-coverage

skill · 783 lines · Apache-2.0 · plugins/vertical-plugins/equity-research/skills/initiating-coverage/SKILL.md

The facts

Its description

Create institutional-quality equity research initiation reports through a 5-task workflow. Tasks must be executed individually with verified prerequisites - (1) company research, (2) financial modeling, (3) valuation analysis, (4) chart generation, (5) final report assembly. Each task produces specific deliverables (markdown docs, Excel models, charts, or DOCX reports). Tasks 3-5 have dependencies on earlier tasks.

The description the agent reads to decide when to use it.

From its settingsline 3

When it starts

The agent picks this skill when someone asks for a first-time institutional equity research initiation report on a company, or asks to run one of its five numbered tasks by name. The description presents it as a 5-task workflow (research, modeling, valuation, charts, report assembly) whose tasks must be requested and verified one at a time.

Things a person might say (the model's guesses)

  • “Create a coverage initiation report for Tesla”
  • “Use initiating-coverage, Task 1 for Tesla”
  • “Write an initiation report for Nvidia”

A model's summary of when it is used.

A model's reading

What leads to it

Other skills that hand off to this one, call it, require it or offer it instead, as a model read them.

A model's reading

Names skills outside this collection

Skills the text names that are not in this collection, as a model read them.

A model's reading

Licence

Apache-2.0, from LICENSE

The terms its author shares it under, which let it be shown here.

From the repositorylicence text
Other files in this skill (8) Close

The text

Open on GitHub
1---
2name: initiating-coverage
3description: Create institutional-quality equity research initiation reports through a 5-task workflow. Tasks must be executed individually with verified prerequisites - (1) company research, (2) financial modeling, (3) valuation analysis, (4) chart generation, (5) final report assembly. Each task produces specific deliverables (markdown docs, Excel models, charts, or DOCX reports). Tasks 3-5 have dependencies on earlier tasks.
4---
5
6# Initiating Coverage
7
8Create institutional-quality equity research initiation reports through a structured 5-task workflow. Each task must be executed separately with verified inputs.
9

Initiating Coverage

Create institutional-quality equity research initiation reports through a structured 5-task workflow. Each task must be executed separately with verified inputs.

Raw lines 1 to 9
10## Overview
12This 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.
14**Default Font**: Times New Roman throughout all documents (unless user specifies otherwise).
16---

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).


Raw lines 10 to 17
18## ⚠️ CRITICAL: One Task at a Time
20**THIS SKILL OPERATES IN SINGLE-TASK MODE ONLY.**

⚠️ CRITICAL: One Task at a Time

THIS SKILL OPERATES IN SINGLE-TASK MODE ONLY.

Raw lines 18 to 21
22### If User Requests Full Pipeline
24When user requests:
25- "Create a coverage initiation report for [Company]"
26- "Write an initiation report for [Company]"
27- "Do the entire equity research process for [Company]"
28- "Complete all 5 tasks for [Company]"
29- Any request that implies running multiple tasks or the entire workflow
31**REQUIRED RESPONSE:**
331. **Ask which specific task to perform:**
34 ```
35 I can help you create an equity research initiation report for [Company].
36 This involves 5 separate tasks that need to be completed individually:
38 1. Company Research - Research business, management, industry
39 2. Financial Modeling - Build projection model
40 3. Valuation Analysis - DCF and comparable companies
41 4. Chart Generation - Create 25-35 charts
42 5. Report Assembly - Compile final report
44 Which task would you like to start with?
45 ```
472. **When user explicitly requests all tasks together:**
48 ```
49 I understand you'd like to complete the entire initiation report pipeline.
50 Currently, this skill supports executing one task at a time, which allows
51 for better quality control and review at each stage.
53 We're working on a seamless end-to-end workflow that will make this process
54 more automated, but for now, we'll need to complete each task separately.
56 Would you like to start with Task 1 (Company Research)?
57 ```
593. **Never automatically assume which task to start** - always ask user to confirm.
614. **Never execute multiple tasks in sequence** - complete one task, deliver outputs, then wait for next user request.

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? ```

  1. 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)? ```

  1. Never automatically assume which task to start - always ask user to confirm.
  1. Never execute multiple tasks in sequence - complete one task, deliver outputs, then wait for next user request.
Raw lines 22 to 62
63### Task Execution Rules
65- ✅ Execute exactly ONE task per user request
66- ✅ Always verify prerequisites before starting a task
67- ✅ Deliver task outputs and confirm completion
68- ✅ Wait for user to explicitly request the next task
69- ❌ Never chain multiple tasks together automatically
70- ❌ Never assume user wants to proceed to next task
71- ❌ Never execute Tasks 3-5 without verifying required inputs exist

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
Raw lines 63 to 72
73### ⚠️ Deliverables Policy: NO SHORTCUTS
75**DELIVER ONLY THE SPECIFIED OUTPUTS. DO NOT CREATE EXTRA DOCUMENTS.**
77Each task specifies exact deliverables. Do NOT create:
78- ❌ "Completion summaries"
79- ❌ "Executive summaries"
80- ❌ "Quick reference guides"
81- ❌ "Next steps documents"
82- ❌ "Task completion reports"
83- ❌ Any other "helpful" documentation not explicitly specified
85**Why**: These extras waste context and are not part of the professional workflow.
87**What TO deliver**:
88- ✅ Task 1: Research document (.md) — **NOTHING ELSE**
89- ✅ Task 2: Financial model (.xlsx) — **NOTHING ELSE**
90- ✅ Task 3: Valuation analysis (.md) + Excel tabs added to Task 2 file — **NOTHING ELSE**
91- ✅ Task 4: Charts zip file (.zip) — **NOTHING ELSE**
92- ✅ Task 5: Final report (.docx) — **NOTHING ELSE**
94**If a deliverable is not listed above, DO NOT CREATE IT.**
96---

⚠️ 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.


Raw lines 73 to 97
98## Task Selection
100Select which task to execute:
102| Task | Name | Prerequisites | Output |
103|------|------|--------------|--------|
104| **1** | Company Research | Company name/ticker | 6-8K word document |
105| **2** | Financial Modeling | 10-K or financials access | Excel model (6 tabs) |
106| **3** | Valuation Analysis | Financial model (Task 2) | Valuation + price target |
107| **4** | Chart Generation | Tasks 1, 2, 3 + external data | 25-35 PNG/JPG charts |
108| **5** | Report Assembly | ALL previous tasks (1-4) | 30-50 page DOCX report |
110---

Task Selection

Select which task to execute:

TaskNamePrerequisitesOutput
1Company ResearchCompany name/ticker6-8K word document
2Financial Modeling10-K or financials accessExcel model (6 tabs)
3Valuation AnalysisFinancial model (Task 2)Valuation + price target
4Chart GenerationTasks 1, 2, 3 + external data25-35 PNG/JPG charts
5Report AssemblyALL previous tasks (1-4)30-50 page DOCX report

Raw lines 98 to 111
112## How to Use This Skill

How to Use This Skill

Raw lines 112 to 113
114### User Request Patterns and Responses
116**Pattern 1: User specifies a specific task**
117```
118User: "Use initiating-coverage, Task 1 for Tesla"
119Response: ✅ Execute Task 1 immediately
120```
122**Pattern 2: User asks for "initiation report" or "full pipeline"**
123```
124User: "Create a coverage initiation report for Tesla"
125Response: ❌ DO NOT start any task automatically
126 ✅ Ask which task to start with (see template above)
127```
129**Pattern 3: User wants to do "all tasks" or "entire workflow"**
130```
131User: "I want to complete all 5 tasks for Tesla"
132Response: ❌ DO NOT chain tasks together
133 ✅ Explain one-at-a-time limitation (see template above)
134 ✅ Ask if they want to start with Task 1
135```

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
Raw lines 114 to 136
137### Correct Usage Examples
139**Executing a single task:**
140```
141"Use initiating-coverage skill, Task 1 for Tesla"
142"Do Task 2 of initiating-coverage for Tesla"
143"Run Task 3 for Tesla using the initiating-coverage skill"
144```
146**Completing full report (requires 5 separate requests):**
147```
148Request 1: "Do Task 1 for Tesla" → Complete → Deliver outputs
149Request 2: "Do Task 2 for Tesla" → Complete → Deliver outputs
150Request 3: "Do Task 3 for Tesla" → Complete → Deliver outputs
151Request 4: "Do Task 4 for Tesla" → Complete → Deliver outputs
152Request 5: "Do Task 5 for Tesla" → Complete → Deliver outputs
153```

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
Raw lines 137 to 154
155### Task Execution Order
157For a complete initiation report, tasks must be executed in separate user requests following this order:
159```
160Request 1: Task 1 - Company Research (independent)
161 ↓ [User reviews outputs and requests next task]
162Request 2: Task 2 - Financial Modeling (independent)
163 ↓ [User reviews outputs and requests next task]
164Request 3: Task 3 - Valuation Analysis (requires Task 2 output)
165 ↓ [User reviews outputs and requests next task]
166Request 4: Task 4 - Chart Generation (requires Tasks 2 & 3 outputs)
167 ↓ [User reviews outputs and requests next task]
168Request 5: Task 5 - Report Assembly (requires ALL previous task outputs)
169```
171**Note**: Tasks 1 and 2 can be run in any order. Tasks 3-5 have strict dependencies and must verify inputs before proceeding.
173---

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.


Raw lines 155 to 174
175## Task 1: Company Research
177**Purpose**: Research company's business, management, competitive position, industry, and risks.
179**Prerequisites**: ✅ None (fully independent)
180- Company name or ticker symbol
182**Process**:
1831. Verify company name/ticker provided
1842. Load detailed instructions from references/task1-company-research.md
1853. Execute qualitative research workflow
1864. Deliver research document
188**Output**: Company Research Document (6,000-8,000 words)
189- Company overview & history
190- Management bios (300-400 words × 3-4 execs)
191- Products & services analysis
192- Industry overview
193- Competitive analysis (5-10 competitors)
194- TAM sizing
195- Risk assessment (8-12 risks)
197**File name**: `[Company]_Research_Document_[Date].md`
199**⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.**
201**⚠️ DO NOT TAKE SHORTCUTS:**
202- ✅ Write full 6,000-8,000 words (not summaries)
203- ✅ Complete 300-400 word bios for ALL 3-4 executives
204- ✅ Analyze ALL 5-10 competitors thoroughly
205- ✅ Cover all 8-12 risks across 4 categories
206- ❌ Do not abbreviate sections to save time
207- ❌ Do not skip any required sections
209**Verification before proceeding**: None required for this task.
211---

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.


Raw lines 175 to 212
213## Task 2: Financial Modeling
215**Purpose**: Extract historical financials and build comprehensive Excel financial model with projections and scenarios.
217**Prerequisites**: ⚠️ Verify before starting
218- **Required**: Access to company financial data
219 - For public companies: Latest 10-K from SEC EDGAR
220 - For private companies: Financial statements or available estimates
221 - OR: Pre-extracted historical financials provided by user
222- **Optional**: Company research (Task 1) for business context
224**Input Verification**:
225```
226BEFORE STARTING - Select approach:
228Option A: Extract financials (most common)
229- [ ] Have access to 10-K or financial statements?
230- [ ] Ready to extract 3-5 years of data?
232Option B: User provided pre-extracted financials
233- [ ] Historical financials file received?
234- [ ] Contains income statement, cash flow, balance sheet (3-5 years)?
236Optional:
237- [ ] Company research (Task 1) complete for context?
238```
240**Process**:
2411. Verify access to financial data
2422. Load detailed instructions from references/task2-financial-modeling.md
2433. **Step 1**: Extract historical financials (if needed)
2444. **Step 2+**: Build projection model with 6 essential tabs
2455. Deliver Excel model
247**Output**: Excel Financial Model (.xlsx)
248- 6 essential tabs:
249 1. **Revenue Model** - Product breakdown (20-30 rows) + Geography breakdown (15-20 rows)
250 2. **Income Statement** - Full P&L with 40-50 line items, historical (3-5 years) + projected (5 years)
251 3. **Cash Flow Statement** - Operating/Investing/Financing activities, historical + projected
252 4. **Balance Sheet** - Assets/Liabilities/Equity, historical + projected
253 5. **Scenarios** - Bull/Base/Bear comparison table
254 6. **DCF Inputs** - Prepared for Task 3 valuation
256**File name**: `[Company]_Financial_Model_[Date].xlsx`
258**⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.**
260**⚠️ DO NOT TAKE SHORTCUTS:**
261- ✅ If extracting financials: Extract ALL line items from 3 financial statements (3-5 years)
262- ✅ Build ALL 6 projection tabs completely with full detail
263- ✅ Create detailed revenue model with 20-30 product rows AND 15-20 geography rows
264- ✅ Build complete income statement with 40-50 line items (not abbreviated)
265- ✅ Include full cash flow statement and balance sheet with all line items
266- ✅ Complete ALL three scenarios (Bull/Base/Bear) with different parameters
267- ❌ Do not create simplified/abbreviated versions
268- ❌ Do not skip any of the 6 essential tabs
269- ❌ Do not skip historical financials extraction if needed
271**Verification before proceeding to Task 3**:
272- [ ] Historical financials extracted (if needed) or provided
273- [ ] Excel file created and can be opened
274- [ ] Model has all 6 essential tabs (Revenue Model, Income Statement, Cash Flow, Balance Sheet, Scenarios, DCF Inputs)
275- [ ] Historical data (3-5 years) incorporated
276- [ ] Projections complete (5 years forward)
277- [ ] Scenarios complete (Bull/Base/Bear)
279---

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:
  • Revenue Model - Product breakdown (20-30 rows) + Geography breakdown (15-20 rows)
  • Income Statement - Full P&L with 40-50 line items, historical (3-5 years) + projected (5 years)
  • Cash Flow Statement - Operating/Investing/Financing activities, historical + projected
  • Balance Sheet - Assets/Liabilities/Equity, historical + projected
  • Scenarios - Bull/Base/Bear comparison table
  • 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)

Raw lines 213 to 280
281## Task 3: Valuation Analysis
283**Purpose**: Perform comprehensive valuation using DCF, comparables, and precedent transactions.
285**Prerequisites**: ⚠️ Verify before starting
286- **Required**: Financial model from Task 2
287 - Projected income statements
288 - Projected cash flows
289 - Revenue and EBITDA forecasts
290 - DCF inputs (unlevered FCF)
292**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASK 2 IS COMPLETE**
294This task requires the financial model from Task 2. Starting without it will result in incomplete work.
296**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.
298**Input Verification**:
299```
300BEFORE STARTING:
301- [ ] Task 2 complete? (Financial model exists)
302- [ ] Model file path/location known?
303- [ ] Can access projected financials from model?
305Required from model:
306- [ ] Projected FCF (5 years)
307- [ ] Revenue projections
308- [ ] EBITDA projections
309- [ ] Terminal year metrics
310```
312**Process**:
3131. Verify financial model is accessible
3142. Load detailed instructions from references/task3-valuation.md
3153. Execute valuation workflow
3164. Deliver valuation analysis
318**Output**: Valuation Analysis (4-6 pages + Excel tabs)
319- DCF analysis with sensitivity tables
320- Comparable companies (5-10 peers with statistical summary)
321- Precedent transactions (if applicable)
322- Valuation football field
323- **Price target**: $XX.XX
324- **Recommendation**: BUY/HOLD/SELL
325- **Upside**: XX%
326- Key catalysts (3-5)
328**Files**:
329- `[Company]_Valuation_Analysis_[Date].md` (written analysis document)
330- Excel tabs added to `[Company]_Financial_Model_[Date].xlsx` (from Task 2)
331 - DCF tab with calculations
332 - Sensitivity analysis tab
333 - Comparable companies tab
334 - Valuation summary tab
336**⚠️ DELIVER ONLY: 1 markdown file + 4 tabs added to existing Excel. NO completion summaries, no extra documents.**
338**⚠️ DO NOT TAKE SHORTCUTS:**
339- ✅ Complete full DCF analysis with sensitivity matrix (not simplified)
340- ✅ Analyze ALL 5-10 comparable companies with full data
341- ✅ Include statistical summary in comps table (max/75th/median/25th/min)
342- ✅ Create complete sensitivity analysis tab with multiple WACC and terminal growth scenarios
343- ✅ Write full 4-6 pages of valuation analysis (not abbreviated)
344- ✅ Research and justify price target with specific methodology
345- ❌ Do not skip comparable company analysis
346- ❌ Do not create simplified DCF without sensitivity
348**Verification before proceeding to Task 4**:
349- [ ] Price target determined
350- [ ] Valuation uses multiple methods (DCF + Comps minimum)
351- [ ] DCF sensitivity table complete
352- [ ] Comparable companies table includes statistical summary
354---

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

Raw lines 281 to 355
356## Task 4: Chart Generation
358**Purpose**: Generate 25-35 professional financial charts for the report.
360**Prerequisites**: ⚠️ Verify before starting
361- **Required**: Company research from Task 1
362 - Company history and milestones (for timeline charts)
363 - Management team and org structure (for org charts)
364 - Product portfolio (for product charts)
365 - Customer segmentation (for customer charts)
366 - Competitive landscape (for competitive charts)
367 - TAM analysis (for market size charts)
368- **Required**: Financial model from Task 2 (with Task 3 valuation tabs added)
369 - Revenue by product/geography data (Task 2 tabs)
370 - Margin trends (Task 2 tabs)
371 - Scenario comparison data (Task 2 tabs)
372 - DCF sensitivity table (Task 3 tab in same Excel file)
373 - Comparable companies data (Task 3 tab in same Excel file)
374 - Valuation ranges (Task 3 tab in same Excel file)
375- **Required**: External market data
376 - Historical stock price data (Yahoo Finance, Bloomberg, etc.)
377 - Historical valuation multiples (for historical trend charts)
379**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASKS 1, 2, AND 3 ARE COMPLETE**
381This task requires outputs from all three previous tasks. Starting without them will result in incomplete charts.
383**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:
384- Task 1: Company research document (for 9 charts)
385- Task 2: Financial model with all 6 tabs (for 8 charts)
386- Task 3: Valuation tabs added to the model (for 6 charts)
387- External data access (for 2 charts)
389Do not attempt to create placeholder charts or skip charts due to missing data.
391**Input Verification**:
392```
393BEFORE STARTING:
394- [ ] Task 1 complete? (Company research exists)
395- [ ] Task 2 complete? (Financial model exists)
396- [ ] Task 3 complete? (Valuation analysis exists)
397- [ ] Can access external market data sources?
399Required from Task 1:
400- [ ] Company history and milestones (for charts 05, 06)
401- [ ] Management team structure (for chart 07)
402- [ ] Product portfolio details (for chart 08)
403- [ ] Customer segmentation data (for chart 09)
404- [ ] Competitive landscape analysis (for charts 16, 17, 18)
405- [ ] TAM sizing and market data (for chart 15)
407Required from Task 2:
408- [ ] Revenue by product (historical + projected) - for chart 03 ⭐
409- [ ] Revenue by geography (historical + projected) - for chart 04 ⭐
410- [ ] Income statement with margins (for charts 02, 10, 11)
411- [ ] Cash flow statement (for chart 12)
412- [ ] Scenario comparison data (for chart 14)
414Required from Task 3:
415- [ ] DCF sensitivity matrix - for chart 28 ⭐
416- [ ] DCF components (for chart 29)
417- [ ] Comparable companies data (for charts 30, 31)
418- [ ] Valuation ranges - for chart 32 ⭐
420Required from External Sources:
421- [ ] Historical stock price data (for chart 01)
422- [ ] Historical valuation multiples (for chart 34)
423```
425**Process**:
4261. Verify model and valuation outputs are accessible
4272. Load detailed instructions from references/task4-chart-generation.md
4283. Execute chart generation workflow
4294. Package all charts into a zip file
4305. Deliver zip file
432**Output**: 25-35 Professional Chart Files (PNG/JPG, 300 DPI) packaged in zip
434**4 MANDATORY Charts** (must be present) ⭐:
435- chart_03: Revenue by product (stacked area)
436- chart_04: Revenue by geography (stacked bar)
437- chart_28: DCF sensitivity (2-way heatmap)
438- chart_32: Valuation football field (horizontal bars)
440**25 REQUIRED Charts** (specific list):
441- Investment Summary: chart_01
442- Financial Performance: charts 02, 03⭐, 04⭐, 10, 11, 12, 14
443- Company 101: charts 05, 06, 07, 08, 09, 15, 16
444- Competitive/Market: charts 17, 18
445- Scenario Analysis: chart 13
446- Valuation: charts 28⭐, 29, 30, 31, 32⭐, 33, 34
448**10 OPTIONAL Charts** (for 26-35 range):
449- charts 19-27, 35 (customer acquisition, unit economics, product roadmap, etc.)
451**IMPORTANT**: Task 5 embeds ALL charts created (25-35) for visual density (1 chart per 200-300 words).
453**File naming**: `chart_01_description.png`, `chart_02_description.png`, etc.
455**Deliverable**: `[Company]_Charts_[Date].zip` containing all 25-35 chart files + chart_index.txt
457**⚠️ DELIVER ONLY THIS 1 ZIP FILE. NO completion summaries, no separate chart lists, no extra documents.**
459**⚠️ DO NOT TAKE SHORTCUTS:**
460- ✅ Create ALL 25 required charts minimum (specific list provided in task4-chart-generation.md)
461- ✅ Include ALL 4 mandatory charts:
462 - chart_03: Revenue by product (stacked area) ⭐
463 - chart_04: Revenue by geography (stacked bar) ⭐
464 - chart_28: DCF sensitivity (heatmap) ⭐
465 - chart_32: Valuation football field ⭐
466- ✅ Optional: Add 1-10 more charts to reach 26-35 total for greater visual density
467- ✅ Generate professional-quality charts at 300 DPI (not low-res placeholders)
468- ✅ Create unique, well-formatted charts for each visualization
469- ✅ Package all charts in zip file with chart index
470- ❌ Do not create only 10-15 charts (minimum is 25)
471- ❌ Do not skip any of the 4 mandatory charts
472- ❌ Do not use low-quality/placeholder images
474**Verification before proceeding to Task 5**:
475- [ ] Minimum 25 chart files created (required)
476- [ ] All 4 mandatory charts present:
477 - [ ] chart_03: Revenue by product ⭐
478 - [ ] chart_04: Revenue by geography ⭐
479 - [ ] chart_28: DCF sensitivity ⭐
480 - [ ] chart_32: Valuation football field ⭐
481- [ ] All charts open and display correctly
482- [ ] Charts saved at 300 DPI (print quality)
483- [ ] Chart index created listing all files with categories
484- [ ] All charts packaged in zip file
485- [ ] File naming follows convention: chart_##_description.png
487---

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)

Do not attempt to create placeholder charts or skip charts due to missing data.

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?

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)

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)

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 ⭐

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

Raw lines 356 to 488
489## Task 5: Report Assembly
491**Purpose**: Write and assemble the comprehensive final DOCX report.
493**Prerequisites**: ⚠️ Verify before starting
494- **Required**: Company research from Task 1
495 - All 6-8K words of content
496 - Management bios
497 - Competitive analysis
498 - Risk assessment
499- **Required**: Financial model from Task 2
500 - Excel workbook
501 - All projections and scenarios
502- **Required**: Valuation analysis from Task 3
503 - Price target and recommendation
504 - DCF, comps, precedent transactions
505 - All valuation data
506- **Required**: Chart files from Task 4
507 - Zip file containing all 25-35 PNG/JPG files
508 - Chart index included in zip
510**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS ALL TASKS 1-4 ARE COMPLETE**
512This is the final assembly task. It cannot be completed without all previous work products.
514**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:
515- Task 1: Company research document (6-8K words)
516- Task 2: Financial model with all 6 tabs
517- Task 3: Valuation analysis with price target and recommendation
518- Task 4: Charts zip file with 25-35 charts
520Do not attempt to create placeholder content, substitute missing sections, or assemble an incomplete report. The report requires ALL inputs to be publication-ready.
522**Input Verification**:
523```
524BEFORE STARTING - ALL TASKS MUST BE COMPLETE:
526Task 1 Verification:
527- [ ] Company research document exists? (6-8K words)
528- [ ] Management bios complete? (300-400 words × 3-4 execs)
529- [ ] Competitive analysis complete? (5-10 competitors)
530- [ ] Risk assessment complete? (8-12 risks)
532Task 2 Verification:
533- [ ] Financial model exists and can be opened?
534- [ ] Model has projections (5 years)?
535- [ ] Scenarios exist (Bull/Base/Bear)?
537Task 3 Verification:
538- [ ] Valuation analysis complete?
539- [ ] Price target determined?
540- [ ] Recommendation set? (BUY/HOLD/SELL)
541- [ ] DCF and comps complete?
543Task 4 Verification:
544- [ ] Chart zip file exists?
545- [ ] Can extract/access all 25-35 chart files from zip?
546- [ ] All 4 mandatory charts present?
547 - [ ] Revenue by product (stacked area)
548 - [ ] Revenue by geography (stacked bar)
549 - [ ] DCF sensitivity (heatmap)
550 - [ ] Valuation football field
551- [ ] Chart files accessible and can be opened?
553IF ANY VERIFICATION FAILS: Stop and complete missing task first.
554```
556**Process**:
5571. **CRITICAL**: Verify ALL prerequisites before starting
5582. Load detailed instructions from references/task5-report-assembly.md
5593. Execute report assembly workflow using Claude's built-in skills:
560 - **Use DOCX skill** to create and manipulate the Word document
561 - **Use XLSX skill** to read Excel data from Task 2/3
562 - **Use Read tool** to read Task 1 and Task 3 markdown files
563 - Read Task 1 .md file → Convert to Word formatting → Insert charts inline
564 - Read Task 2 .xlsx file → Extract tables → Write quantitative analysis
565 - Read Task 3 .md file + Excel tabs → Copy/adapt valuation analysis
566 - Insert Task 4 .png chart files throughout using DOCX skill
567 - Create text-dense report with charts interspersed every 200-300 words
5684. Save and deliver final DOCX report
570**Key Principles**:
571- Use Claude's DOCX and XLSX skills (NOT Python libraries)
572- Use actual file operations (read .md/.xlsx/.png files, write .docx file)
573- Good equity research reports are text-dense with lots of illustrating images (60-80% page coverage, 1+ chart per page)
575**🔥 CRITICAL: GO ALL OUT ON THIS TASK**
577**THIS IS THE FINAL DELIVERABLE. DO NOT TAKE SHORTCUTS.**
579- ✅ **Use full token budget** - This is the culmination of all previous work
580- ✅ **Write every section completely** - Do not summarize or abbreviate
581- ✅ **Hit ALL minimum requirements** - 30+ pages, 10,000+ words, 25+ charts, 12+ tables
582- ✅ **Be thorough on projection assumptions** - 2,000-3,000 words with product-by-product detail
583- ✅ **Be comprehensive on scenarios** - 1,500-2,000 words with specific Bull/Base/Bear parameters
584- ✅ **Insert ALL charts from Task 4** - Not just a few, ALL 25-35 charts throughout
585- ✅ **Create ALL tables from Task 2/3** - Extract every financial table, don't skip any
586- ✅ **Use Task 1 content verbatim** - Copy/paste full Company 101 sections (6-8K words)
587- ✅ **Professional quality only** - This must be indistinguishable from JPMorgan/Goldman Sachs research
589**NEVER:**
590- ❌ "This section would include..." - WRITE THE ACTUAL SECTION
591- ❌ "Charts would be inserted here..." - INSERT THE ACTUAL CHARTS
592- ❌ "See financial model for details..." - EXTRACT AND INCLUDE THE DETAILS
593- ❌ Skip sections due to length - Every section MUST be complete
594- ❌ Abbreviate for token conservation - Use whatever tokens are needed
596**This is publication-ready institutional research. Spare no effort, tokens, or detail.**
598**Output**: Comprehensive Equity Research Report (.docx)
600**Specifications**:
601- **Length**: 30-50 pages (MINIMUM 30)
602- **Word count**: 10,000-15,000 words (MINIMUM 10,000)
603- **Charts**: 25-35 embedded images
604- **Tables**: 12-20 comprehensive tables
605- **Format**: Professional DOCX with clickable hyperlinks
607**Structure**:
608- Page 1: Investment Summary (INITIATING COVERAGE format)
609- Pages 2-5: Investment thesis & risks
610- Pages 6-17: Company 101
611- Pages 18-30: Financial analysis & projections
612- Pages 31-40: Valuation analysis
613- Pages 41-50: Appendices
615**File name**: `[Company]_Initiation_Report_[Date].docx`
617**⚠️ DELIVER ONLY THIS 1 DOCX FILE. NO executive summaries, no "highlights" documents, no extra files.**
619**Final Verification**:
620- [ ] Report is 30-50 pages
621- [ ] Word count is 10,000-15,000
622- [ ] 25-35 charts embedded
623- [ ] 12-20 tables included
624- [ ] All citations are clickable hyperlinks
625- [ ] Numbers match financial model exactly
627---

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

Do not attempt to create placeholder content, substitute missing sections, or assemble an incomplete report. The report requires ALL inputs to be publication-ready.

Input Verification:

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?

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?

IF ANY VERIFICATION FAILS: Stop and complete missing task first.

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:
  4. Use DOCX skill to create and manipulate the Word document
  5. Use XLSX skill to read Excel data from Task 2/3
  6. Use Read tool to read Task 1 and Task 3 markdown files
  7. Read Task 1 .md file → Convert to Word formatting → Insert charts inline
  8. Read Task 2 .xlsx file → Extract tables → Write quantitative analysis
  9. Read Task 3 .md file + Excel tabs → Copy/adapt valuation analysis
  10. Insert Task 4 .png chart files throughout using DOCX skill
  11. Create text-dense report with charts interspersed every 200-300 words
  12. Save and deliver final DOCX report

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)

🔥 CRITICAL: GO ALL OUT ON THIS TASK

THIS IS THE FINAL DELIVERABLE. DO NOT TAKE SHORTCUTS.

  • ✅ 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

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

This is publication-ready institutional research. Spare no effort, tokens, or detail.

Output: Comprehensive Equity Research Report (.docx)

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

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

File name: [Company]_Initiation_Report_[Date].docx

⚠️ DELIVER ONLY THIS 1 DOCX FILE. NO executive summaries, no "highlights" documents, no extra files.

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

Raw lines 489 to 628
629## Input Verification Protocol

Input Verification Protocol

Raw lines 629 to 630
631### Why Input Verification Matters
633Each task has strict prerequisites. Running a task without required inputs will:
634- Waste time with incomplete work
635- Produce low-quality outputs
636- Require rework
638**Always verify inputs before starting a task.**

Why Input Verification Matters

Each task has strict prerequisites. Running a task without required inputs will:

  • Waste time with incomplete work
  • Produce low-quality outputs
  • Require rework

Always verify inputs before starting a task.

Raw lines 631 to 639
640### Verification Checklist by Task
642**Task 1**: ✅ No verification needed (independent)
644**Task 2**: Check historical financials available
646**Task 3**: Check financial model exists and is accessible
648**Task 4**: Check both model (Task 2) AND valuation (Task 3) exist
650**Task 5**: Check ALL previous tasks complete (1, 2, 3, 4)

Verification Checklist by Task

Task 1: ✅ No verification needed (independent)

Task 2: Check historical financials available

Task 3: Check financial model exists and is accessible

Task 4: Check both model (Task 2) AND valuation (Task 3) exist

Task 5: Check ALL previous tasks complete (1, 2, 3, 4)

Raw lines 640 to 651
652### What to Do if Verification Fails
654```
655IF prerequisites are missing:
6561. Stop the current task
6572. Identify which prerequisite task(s) need to be completed
6583. Execute the missing task(s) first
6594. Return to current task once prerequisites are met
660```

What to Do if Verification Fails

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
Raw lines 652 to 661
662### Example Verification Dialogue
664```
665User: "Use initiating-coverage, Task 5 for Tesla"
667Claude: "Starting Task 5: Report Assembly for Tesla
669VERIFICATION - Checking prerequisites:
670- Task 1 (Company research)... ❌ NOT FOUND
671- Task 2 (Financial model)... ❌ NOT FOUND
672- Task 3 (Valuation)... ❌ NOT FOUND
673- Task 4 (Charts)... ❌ NOT FOUND
675⚠️ VERIFICATION FAILED
677Task 5 requires ALL previous tasks to be complete.
679To proceed:
6801. Complete Task 1: Company Research
6812. Complete Task 2: Financial Modeling
6823. Complete Task 3: Valuation Analysis
6834. Complete Task 4: Chart Generation
6845. Then return to Task 5
686Would you like to start with Task 1 first?"
687```
689---

Example Verification Dialogue

User: "Use initiating-coverage, Task 5 for Tesla"

Claude: "Starting Task 5: Report Assembly for Tesla

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

⚠️ VERIFICATION FAILED

Task 5 requires ALL previous tasks to be complete.

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

Would you like to start with Task 1 first?"

Raw lines 662 to 690
691## Task Reference Files
693Detailed instructions for each task are in separate reference files to keep this skill lean:
695- **references/task1-company-research.md** - Company research workflow
696- **references/task2-financial-modeling.md** - Financial modeling workflow
697- **references/task3-valuation.md** - Valuation methodology
698 - Also see: references/valuation-methodologies.md for DCF/comps deep dive
699- **references/task4-chart-generation.md** - Chart generation workflow
700- **references/task5-report-assembly.md** - Report writing workflow
701 - Also see: assets/report-template.md for report structure
702 - Also see: assets/quality-checklist.md for quality checks
704**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.
706---

Task Reference Files

Detailed instructions for each task are in separate reference files to keep this skill lean:

  • 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

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.


Raw lines 691 to 707
708## Quality Standards
710All outputs meet institutional standards from leading investment banks (JPMorgan, Goldman Sachs, Morgan Stanley):
712- **Comprehensive**: Meet all minimum requirements
713- **Detailed**: Specific data and examples, not generic statements
714- **Quantified**: Lead with numbers and metrics
715- **Cited**: Proper sources with clickable hyperlinks
716- **Professional**: Institutional-quality formatting
717- **Accurate**: All numbers verified and cross-checked
719---

Quality Standards

All outputs meet institutional standards from leading investment banks (JPMorgan, Goldman Sachs, Morgan Stanley):

  • 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

Raw lines 708 to 720
721## Important Notes

Important Notes

Raw lines 721 to 722
723### Task Independence
725- **Task 1** can run anytime (no dependencies)
726- **Task 2** can run anytime (just needs historical data)
727- **Tasks 1 & 2** can run in parallel
728- **Task 3** requires Task 2
729- **Task 4** requires Tasks 2 & 3
730- **Task 5** requires Tasks 1, 2, 3, & 4

Task Independence

  • 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
Raw lines 723 to 731
732### Session Management
734**Same session**: Outputs automatically available to subsequent tasks
736**Different sessions**: Reference previous task outputs explicitly
737```
738"Use Task 3 with the model from yesterday at [path]"
739"Use Task 5 with the research document at [path]"
740```

Session Management

Same session: Outputs automatically available to subsequent tasks

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]"
Raw lines 732 to 741
742### File Organization
744Recommended structure during workflow:
745```
746ProjectFolder/
747├── Task1_Research/
748│ └── [Company]_Research_Document.md
749├── Task2_Model/
750│ └── [Company]_Financial_Model.xlsx
751├── Task3_Valuation/
752│ └── [Company]_Valuation_Analysis.pdf
753├── Task4_Charts/
754│ ├── chart_01.png
755│ └── ... (25-35 files)
756└── Task5_Report/
757 └── [Company]_Initiation_Report.docx
758```

File Organization

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
Raw lines 742 to 759
760### No End-to-End Execution
762This skill does **NOT** support running all tasks automatically in sequence. Each task must be explicitly requested and verified.
764**Why**: This ensures:
765- Quality control at each stage
766- Ability to review outputs before proceeding
767- Flexibility to pause/resume workflow
768- Clear verification of prerequisites
770---

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

Raw lines 760 to 771
772## Success Criteria
774A successful initiation report workflow should:
7751. Complete all 5 tasks in order
7762. Pass all input verifications
7773. Meet all quality standards
7784. Produce all required deliverables
7795. Numbers cross-check between outputs
7806. Final report is publication-ready
782**Output quality**: Institutional (JPMorgan/Goldman/Morgan Stanley level)
783**Use case**: First-time comprehensive coverage of a company

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

Raw lines 772 to 783

From anthropics/financial-services at 6056506, 2026-10-28. Skills read by DeepSeek V4.1 Flash on 2026-11-04. Summary and techniques by Claude Opus 5.5 on 2026-11-06.