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.
Permissions
Files
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.
Create institutional-quality equity research initiation reports through a structured 5-task workflow. Each task must be executed separately with verified inputs.
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.
Version history
Default Font: Times New Roman throughout all documents (unless user specifies otherwise).
THIS SKILL OPERATES IN SINGLE-TASK MODE ONLY.
When user requests:
REQUIRED RESPONSE:
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?
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)?
Never automatically assume which task to start - always ask user to confirm.
Never execute multiple tasks in sequence - complete one task, deliver outputs, then wait for next user request.
DELIVER ONLY THE SPECIFIED OUTPUTS. DO NOT CREATE EXTRA DOCUMENTS.
Each task specifies exact deliverables. Do NOT create:
Why: These extras waste context and are not part of the professional workflow.
What TO deliver:
If a deliverable is not listed above, DO NOT CREATE IT.
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 |
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
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
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.
Purpose: Research company's business, management, competitive position, industry, and risks.
Prerequisites: ✅ None (fully independent)
Process:
Output: Company Research Document (6,000-8,000 words)
File name: [Company]_Research_Document_[Date].md
⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.
⚠️ DO NOT TAKE SHORTCUTS:
Verification before proceeding: None required for this task.
Purpose: Extract historical financials and build comprehensive Excel financial model with projections and scenarios.
Prerequisites: ⚠️ Verify before starting
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:
Output: Excel Financial Model (.xlsx)
File name: [Company]_Financial_Model_[Date].xlsx
⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.
⚠️ DO NOT TAKE SHORTCUTS:
Verification before proceeding to Task 3:
Purpose: Perform comprehensive valuation using DCF, comparables, and precedent transactions.
Prerequisites: ⚠️ Verify before starting
⚠️ 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:
Output: Valuation Analysis (4-6 pages + Excel tabs)
Files:
[Company]_Valuation_Analysis_[Date].md (written analysis document)[Company]_Financial_Model_[Date].xlsx (from Task 2)
⚠️ DELIVER ONLY: 1 markdown file + 4 tabs added to existing Excel. NO completion summaries, no extra documents.
⚠️ DO NOT TAKE SHORTCUTS:
Verification before proceeding to Task 4:
Purpose: Generate 25-35 professional financial charts for the report.
Prerequisites: ⚠️ Verify before starting
⚠️ 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:
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:
Output: 25-35 Professional Chart Files (PNG/JPG, 300 DPI) packaged in zip
4 MANDATORY Charts (must be present) ⭐:
25 REQUIRED Charts (specific list):
10 OPTIONAL Charts (for 26-35 range):
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:
Verification before proceeding to Task 5:
Purpose: Write and assemble the comprehensive final DOCX report.
Prerequisites: ⚠️ Verify before starting
⚠️ 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:
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:
Key Principles:
🔥 CRITICAL: GO ALL OUT ON THIS TASK
THIS IS THE FINAL DELIVERABLE. DO NOT TAKE SHORTCUTS.
NEVER:
This is publication-ready institutional research. Spare no effort, tokens, or detail.
Output: Comprehensive Equity Research Report (.docx)
Specifications:
Structure:
File name: [Company]_Initiation_Report_[Date].docx
⚠️ DELIVER ONLY THIS 1 DOCX FILE. NO executive summaries, no "highlights" documents, no extra files.
Final Verification:
Each task has strict prerequisites. Running a task without required inputs will:
Always verify inputs before starting a 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)
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
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?"
Detailed instructions for each task are in separate reference files to keep this skill lean:
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.
All outputs meet institutional standards from leading investment banks (JPMorgan, Goldman Sachs, Morgan Stanley):
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]"
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
This skill does NOT support running all tasks automatically in sequence. Each task must be explicitly requested and verified.
Why: This ensures:
A successful initiation report workflow should:
Output quality: Institutional (JPMorgan/Goldman/Morgan Stanley level) Use case: First-time comprehensive coverage of a company
In these kits
More from @prof-little-bear
Works with
Claude, Codex, Cursor & more