Skill Tracer
Skills › Financial Services › initiating-coverage › task5-report-assembly.md

task5-report-assembly.md

1340 lines · plugins/vertical-plugins/equity-research/skills/initiating-coverage/references/task5-report-assembly.md at 6056506

Open on GitHub
1# Task 5: Report Assembly - Detailed Workflow
2
3This document provides step-by-step instructions for executing Task 5 (Report Assembly) of the initiating-coverage skill.
4

Task 5: Report Assembly - Detailed Workflow

This document provides step-by-step instructions for executing Task 5 (Report Assembly) of the initiating-coverage skill.

Raw lines 1 to 4
5## Task Overview
6
7**Purpose**: Write and assemble the comprehensive final DOCX report.
8
9**Prerequisites**: ⚠️ Verify before starting - ALL PREVIOUS TASKS REQUIRED
10- **Required**: Company research from Task 1
11- **Required**: Financial model from Task 2
12- **Required**: Valuation analysis from Task 3
13- **Required**: Chart files from Task 4
15**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS ALL TASKS 1-4 ARE COMPLETE**
17This is the final assembly task. It cannot be completed without all previous work products.
19**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:
20- Task 1: Company research document (6-8K words)
21- Task 2: Financial model with all 6 tabs
22- Task 3: Valuation analysis with price target and recommendation
23- Task 4: Charts zip file with 25-35 charts
25Do not attempt to create placeholder content, substitute missing sections, or assemble an incomplete report. The report requires ALL inputs to be publication-ready.
27**Output**: Comprehensive Equity Research Report (.docx)
28- Length: 30-50 pages (MINIMUM 30)
29- Word count: 10,000-15,000 words (MINIMUM 10,000)
30- Charts: 25-35 embedded images
31- Tables: 12-20 comprehensive tables
33---

Task Overview

Purpose: Write and assemble the comprehensive final DOCX report.

Prerequisites: ⚠️ Verify before starting - ALL PREVIOUS TASKS REQUIRED

  • Required: Company research from Task 1
  • Required: Financial model from Task 2
  • Required: Valuation analysis from Task 3
  • Required: Chart files from Task 4

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

Output: Comprehensive Equity Research Report (.docx)

  • 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

Raw lines 5 to 34
35## 🔥 CRITICAL INSTRUCTION: SPARE NO TOKENS OR EFFORT
37**THIS IS THE FINAL DELIVERABLE. GO ALL OUT. NO SHORTCUTS. NO ABBREVIATIONS.**
39After completing 4 previous tasks, this final task assembles everything into publication-ready institutional research. **This must be PERFECT.**

🔥 CRITICAL INSTRUCTION: SPARE NO TOKENS OR EFFORT

THIS IS THE FINAL DELIVERABLE. GO ALL OUT. NO SHORTCUTS. NO ABBREVIATIONS.

After completing 4 previous tasks, this final task assembles everything into publication-ready institutional research. This must be PERFECT.

Raw lines 35 to 40
41### Absolute Requirements
43**DO:**
44- ✅ **Use ENTIRE token budget if needed** - This is what it's for
45- ✅ **Write EVERY section in FULL** - Not summaries, not placeholders, FULL CONTENT
46- ✅ **Include ALL 25-35 charts** - Embed every single chart from Task 4 throughout the document
47- ✅ **Create ALL 12-20 tables** - Extract every financial table from Excel, don't skip any
48- ✅ **Copy ALL 6-8K words from Task 1** - Use Company 101 content verbatim (40-50% of report)
49- ✅ **Write 2,000-3,000 words on Projection Assumptions** - Product-by-product, region-by-region detail
50- ✅ **Write 1,500-2,000 words on Scenario Analysis** - Specific Bull/Base/Bear parameters
51- ✅ **Achieve 10,000-15,000 total words** - This is a MINIMUM, not a suggestion
52- ✅ **Produce 30-50 pages minimum** - Text-dense with charts every 200-300 words
53- ✅ **Professional institutional quality** - Indistinguishable from JPMorgan/Goldman Sachs
55**NEVER:**
56- ❌ "This section would include..." - WRITE THE ACTUAL SECTION
57- ❌ "Charts would be inserted here..." - INSERT THE ACTUAL CHARTS
58- ❌ "See financial model for details..." - EXTRACT AND WRITE THE DETAILS
59- ❌ "For brevity, we'll summarize..." - NO SUMMARIZING, WRITE IN FULL
60- ❌ Skip sections to conserve tokens - USE WHATEVER TOKENS ARE NEEDED
61- ❌ Create abbreviated versions - EVERY SECTION MUST BE COMPLETE
62- ❌ Reference external files instead of including content - INCLUDE EVERYTHING

Absolute Requirements

DO:

  • ✅ Use ENTIRE token budget if needed - This is what it's for
  • ✅ Write EVERY section in FULL - Not summaries, not placeholders, FULL CONTENT
  • ✅ Include ALL 25-35 charts - Embed every single chart from Task 4 throughout the document
  • ✅ Create ALL 12-20 tables - Extract every financial table from Excel, don't skip any
  • ✅ Copy ALL 6-8K words from Task 1 - Use Company 101 content verbatim (40-50% of report)
  • ✅ Write 2,000-3,000 words on Projection Assumptions - Product-by-product, region-by-region detail
  • ✅ Write 1,500-2,000 words on Scenario Analysis - Specific Bull/Base/Bear parameters
  • ✅ Achieve 10,000-15,000 total words - This is a MINIMUM, not a suggestion
  • ✅ Produce 30-50 pages minimum - Text-dense with charts every 200-300 words
  • ✅ Professional institutional quality - Indistinguishable from JPMorgan/Goldman Sachs

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 WRITE THE DETAILS
  • ❌ "For brevity, we'll summarize..." - NO SUMMARIZING, WRITE IN FULL
  • ❌ Skip sections to conserve tokens - USE WHATEVER TOKENS ARE NEEDED
  • ❌ Create abbreviated versions - EVERY SECTION MUST BE COMPLETE
  • ❌ Reference external files instead of including content - INCLUDE EVERYTHING
Raw lines 41 to 63
64### Quality Standard
66**This report will be read by institutional investors making million-dollar decisions.**
68It must be:
69- **Complete**: Every section written in full with no placeholders
70- **Comprehensive**: All data extracted and included, all charts embedded
71- **Professional**: Proper formatting, citations, tables, charts throughout
72- **Thorough**: Deep analysis with specific numbers, detailed assumptions, complete scenarios
73- **Dense**: 60-80% page coverage with text and visuals on every page
75**Creating the final work product of a 6-10 hour equity research process. Make it count.**
77---

Quality Standard

This report will be read by institutional investors making million-dollar decisions.

It must be:

  • Complete: Every section written in full with no placeholders
  • Comprehensive: All data extracted and included, all charts embedded
  • Professional: Proper formatting, citations, tables, charts throughout
  • Thorough: Deep analysis with specific numbers, detailed assumptions, complete scenarios
  • Dense: 60-80% page coverage with text and visuals on every page

Creating the final work product of a 6-10 hour equity research process. Make it count.


Raw lines 64 to 78
79## Input Verification (CRITICAL)
81**BEFORE STARTING - ALL TASKS MUST BE COMPLETE:**

Input Verification (CRITICAL)

BEFORE STARTING - ALL TASKS MUST BE COMPLETE:

Raw lines 79 to 82
83### Task 1 Verification:
84- [ ] Company research document exists? (6-8K words)
85- [ ] Management bios complete? (300-400 words × 3-4 execs)
86- [ ] Competitive analysis complete? (5-10 competitors)
87- [ ] Risk assessment complete? (8-12 risks)

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)
Raw lines 83 to 88
89### Task 2 Verification:
90- [ ] Financial model exists and can be opened?
91- [ ] Model has projections (5 years)?
92- [ ] Scenarios exist (Bull/Base/Bear)?
93- [ ] Revenue by product table complete (20-30 rows)?
94- [ ] Revenue by geography table complete (15-20 rows)?

Task 2 Verification:

  • [ ] Financial model exists and can be opened?
  • [ ] Model has projections (5 years)?
  • [ ] Scenarios exist (Bull/Base/Bear)?
  • [ ] Revenue by product table complete (20-30 rows)?
  • [ ] Revenue by geography table complete (15-20 rows)?
Raw lines 89 to 95
96### Task 3 Verification:
97- [ ] Valuation analysis complete?
98- [ ] Price target determined?
99- [ ] Recommendation set? (BUY/HOLD/SELL)
100- [ ] DCF analysis complete with sensitivity table?
101- [ ] Comparable companies analysis complete with statistical summary?

Task 3 Verification:

  • [ ] Valuation analysis complete?
  • [ ] Price target determined?
  • [ ] Recommendation set? (BUY/HOLD/SELL)
  • [ ] DCF analysis complete with sensitivity table?
  • [ ] Comparable companies analysis complete with statistical summary?
Raw lines 96 to 102
103### Task 4 Verification:
104- [ ] 25-35 chart files exist?
105- [ ] All 4 mandatory charts present?
106 - [ ] Revenue by product (stacked area)
107 - [ ] Revenue by geography (stacked bar)
108 - [ ] DCF sensitivity (heatmap)
109 - [ ] Valuation football field
110- [ ] Chart files accessible and can be opened?
111- [ ] Chart index created?
113**IF ANY VERIFICATION FAILS**: Stop and complete missing task first.
115---

Task 4 Verification:

  • [ ] 25-35 chart files exist?
  • [ ] 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?
  • [ ] Chart index created?

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


Raw lines 103 to 116
117## Report Specifications

Report Specifications

Raw lines 117 to 118
119### Length Requirements
120- **Pages**: 30-50 (MINIMUM 30 pages)
121- **Word Count**: 10,000-15,000 words (MINIMUM 10,000 words)
122- **Charts**: 25-35 embedded PNG/JPG images
123- **Tables**: 12-20 comprehensive financial tables
124- **Density**: 60-80% page coverage

Length Requirements

  • Pages: 30-50 (MINIMUM 30 pages)
  • Word Count: 10,000-15,000 words (MINIMUM 10,000 words)
  • Charts: 25-35 embedded PNG/JPG images
  • Tables: 12-20 comprehensive financial tables
  • Density: 60-80% page coverage
Raw lines 119 to 125
126### Critical Sections with Word Counts
128| Section | Minimum | Target | Critical? |
129|---------|---------|--------|-----------|
130| Investment Summary (Page 1) | 500 | 700 | |
131| Investment Thesis | 800 | 1,200 | |
132| Risk Factors | 600 | 900 | |
133| Company Description | 800 | 1,200 | |
134| Management Bios | 1,000 | 1,400 | |
135| Products & Services | 700 | 1,000 | |
136| **Projection Assumptions** | **2,000** | **3,000** | ⭐ YES |
137| **Scenario Analysis** | **1,500** | **2,000** | ⭐ YES |
138| Financial Analysis | 1,200 | 1,800 | |
139| Valuation Methodology | 800 | 1,200 | |
141**Total: 10,000-15,000 words**
143---

Critical Sections with Word Counts

SectionMinimumTargetCritical?
Investment Summary (Page 1)500700
Investment Thesis8001,200
Risk Factors600900
Company Description8001,200
Management Bios1,0001,400
Products & Services7001,000
Projection Assumptions2,0003,000⭐ YES
Scenario Analysis1,5002,000⭐ YES
Financial Analysis1,2001,800
Valuation Methodology8001,200

Total: 10,000-15,000 words


Raw lines 126 to 144
145## Report Structure

Report Structure

Raw lines 145 to 146
147### Page 1: Investment Summary (CRITICAL PAGE)
149**This is the most important page. Must have:**
1511. **"INITIATING COVERAGE" header** (NOT "Company Update")
1522. **Thesis-focused title** (e.g., "AI Platform Leader Positioned for 40% CAGR")
1533. **Rating box** with:
154 - Rating (BUY/OUTPERFORM/HOLD/UNDERPERFORM/SELL)
155 - Current price
156 - Target price
157 - 52-week range
158 - Market cap
159 - Enterprise value
1604. **Research analyst information** with credentials
1615. **Stock price performance chart** (Figure 1)
1626. **3-4 detailed investment bullets** with ■ character
163 - Each bullet has **bold topic header** + 3-5 sentences
164 - Lead with key numbers
1657. **Financial summary table** (2-3 years historical + 2-3 years projected)
166 - Years noted as "A" for actual, "E" for estimate
168**Bullet Format Example:**
169```
170■ **Vertical SaaS leadership and regulatory moat should enable $50bn+ TAM by 2030.**
171Deep domain expertise in healthcare IT, strong customer retention (95%+ net revenue retention),
172and cross-sell capabilities have driven Acme Health's market expansion. With the healthcare IT
173market expected to reach $50bn+ by 2030, Acme Health is well-positioned to capture share given
174its regulatory moat and high switching costs. Management has indicated that 70% of current
175revenue comes from enterprise hospital systems, suggesting strong product-market fit.
176```

Page 1: Investment Summary (CRITICAL PAGE)

This is the most important page. Must have:

  1. "INITIATING COVERAGE" header (NOT "Company Update")
  2. Thesis-focused title (e.g., "AI Platform Leader Positioned for 40% CAGR")
  3. Rating box with:
  4. Rating (BUY/OUTPERFORM/HOLD/UNDERPERFORM/SELL)
  5. Current price
  6. Target price
  7. 52-week range
  8. Market cap
  9. Enterprise value
  10. Research analyst information with credentials
  11. Stock price performance chart (Figure 1)
  12. 3-4 detailed investment bullets with ■ character
  13. Each bullet has bold topic header + 3-5 sentences
  14. Lead with key numbers
  15. Financial summary table (2-3 years historical + 2-3 years projected)
  16. Years noted as "A" for actual, "E" for estimate

Bullet Format Example:

■ **Vertical SaaS leadership and regulatory moat should enable $50bn+ TAM by 2030.**
Deep domain expertise in healthcare IT, strong customer retention (95%+ net revenue retention),
and cross-sell capabilities have driven Acme Health's market expansion. With the healthcare IT
market expected to reach $50bn+ by 2030, Acme Health is well-positioned to capture share given
its regulatory moat and high switching costs. Management has indicated that 70% of current
revenue comes from enterprise hospital systems, suggesting strong product-market fit.
Raw lines 147 to 177
178### Pages 2-5: Investment Thesis & Risks
180**Investment Thesis (800-1,200 words)**
181- 3-5 key thesis pillars
182- Each pillar: 200-300 words
183- Lead with key statistic
184- Quantify financial impact
185- Include timeline
187**Risk Assessment (600-900 words)**
188- 8-12 identified risks
189- Organized by category:
190 - Company-specific risks (4-6)
191 - Industry/market risks (3-4)
192 - Financial risks (2-3)
193 - Macroeconomic risks (2-3)
194- Each risk: 50-100 word description

Pages 2-5: Investment Thesis & Risks

Investment Thesis (800-1,200 words)

  • 3-5 key thesis pillars
  • Each pillar: 200-300 words
  • Lead with key statistic
  • Quantify financial impact
  • Include timeline

Risk Assessment (600-900 words)

  • 8-12 identified risks
  • Organized by category:
  • Company-specific risks (4-6)
  • Industry/market risks (3-4)
  • Financial risks (2-3)
  • Macroeconomic risks (2-3)
  • Each risk: 50-100 word description
Raw lines 178 to 195
196### Pages 6-17: Company 101
198**Company Description (800-1,200 words)**
199- What the company does (plain English)
200- Business model and monetization
201- Geographic presence
202- Scale metrics
204**Company History (800-1,200 words)**
205- Founding story
206- Timeline of major milestones
207- Strategic pivots
208- Recent developments
210**Management Team (1,000-1,400 words)**
211- 300-400 word bio for each of 3-4 key executives
212- Include: role, background, accomplishments, education
213- Governance structure
215**Products & Services (700-1,000 words)**
216- Detailed product portfolio
217- Features and differentiation
218- Target customers
219- Pricing models
221**Customers & Go-to-Market (500-700 words)**
222- Customer segments
223- Distribution channels
224- Sales strategy
225- Key partnerships
227**Industry Overview (800-1,200 words)**
228- Industry definition and scope
229- Market size and growth
230- Key trends
231- Regulatory environment
233**Competitive Landscape (700-1,000 words)**
234- 5-10 key competitors
235- Market positioning
236- Competitive advantages
237- Market share analysis
239**TAM Analysis (500-700 words)**
240- Total addressable market sizing
241- Market growth projections
242- Company's serviceable market

Pages 6-17: Company 101

Company Description (800-1,200 words)

  • What the company does (plain English)
  • Business model and monetization
  • Geographic presence
  • Scale metrics

Company History (800-1,200 words)

  • Founding story
  • Timeline of major milestones
  • Strategic pivots
  • Recent developments

Management Team (1,000-1,400 words)

  • 300-400 word bio for each of 3-4 key executives
  • Include: role, background, accomplishments, education
  • Governance structure

Products & Services (700-1,000 words)

  • Detailed product portfolio
  • Features and differentiation
  • Target customers
  • Pricing models

Customers & Go-to-Market (500-700 words)

  • Customer segments
  • Distribution channels
  • Sales strategy
  • Key partnerships

Industry Overview (800-1,200 words)

  • Industry definition and scope
  • Market size and growth
  • Key trends
  • Regulatory environment

Competitive Landscape (700-1,000 words)

  • 5-10 key competitors
  • Market positioning
  • Competitive advantages
  • Market share analysis

TAM Analysis (500-700 words)

  • Total addressable market sizing
  • Market growth projections
  • Company's serviceable market
Raw lines 196 to 243
244### Pages 18-30: Financial Analysis
246**Historical Financial Analysis (1,200-1,800 words)**
247- Revenue trends and drivers
248- Margin evolution
249- Cash flow analysis
250- Key metrics trajectory
251- Historical context
253**Projection Assumptions (2,000-3,000 words)** ⭐ CRITICAL
255**MUST be extremely detailed. Structure:**
257**A. Revenue by Product Assumptions (1,000-1,500 words)**
259For EACH major product category:
260```
261[Product Category A] Revenue Assumptions
263We project [Product A] revenue to grow from $XXM in 2024A to $XXM in 2029E,
264representing a XX% CAGR. This growth is driven by:
2661. [Driver 1 with specific quantification]
267 - Specific metric: from XX to XX
268 - Timeline: achieving YY by 2026E
269 - Basis: [source or rationale]
2712. [Driver 2 with specific quantification]
2723. [Driver 3 with specific quantification]
273[... 8-12 detailed points total for this product ...]
275Specific assumptions by year:
276- 2025E: XX% growth driven by [specific factors]
277- 2026E: XX% growth as [specific factors]
278- 2027-2029E: XX% CAGR as [longer-term factors]
280Key risks to these assumptions include [specific risks].
281```
283**Repeat for EACH major product category.**
285**B. Geographic Revenue Assumptions (500-800 words)**
287For EACH major region:
288```
289[Region] Revenue Assumptions
291We project [Region] revenue to grow XX% CAGR from 2024-2029E, reaching $XXM, driven by:
2931. [Market dynamic with quantification]
2942. [Distribution expansion with specifics]
2953. [Competitive positioning]
296[... 6-8 detailed points total for this region ...]
297```
299**Repeat for EACH major geographic region.**
301**C. Other Key Assumptions (500-700 words)**
302- Gross margin evolution (with specific drivers and bridge)
303- Operating expense assumptions (R&D, S&M, G&A as % of revenue)
304- Working capital assumptions (DSO, DIO, DPO with specific days)
305- CapEx as % of sales (with justification)
306- Tax rate assumptions
308**Scenario Analysis (1,500-2,000 words)** ⭐ CRITICAL
310**MUST have specific parameters for each scenario. Structure:**
312**Bull Case (500-700 words)**
313```
314Bull Case: [Title describing key optimistic scenario]
316Probability: XX%
318Key Assumptions:
319- Revenue CAGR (2024-2029E): XX% (vs. XX% base case)
320- 2029E Revenue: $X,XXXm (vs. $X,XXXm base)
321- 2029E EBITDA Margin: XX% (vs. XX% base)
322- Key product growth: XX% CAGR (vs. XX% base)
323- Geographic expansion: [specific milestones and timeline]
324- Market share: XX% by 2029E (vs. XX% base)
326Catalysts Required for Bull Case:
3271. [Specific catalyst] - Expected timing: [date/quarter]
3282. [Specific catalyst] - Expected timing: [date/quarter]
3293. [Specific catalyst] - Expected timing: [date/quarter]
331Detailed Rationale:
332[200-300 words explaining what needs to happen for bull case to materialize.
333Be specific about product launches, market conditions, competitive dynamics, etc.]
335Valuation Implications:
336- DCF Value: $XX per share (XX% upside from current)
337- Trading Comps: XX.Xx EV/EBITDA implies $XX per share
338- Bull Case Target: $XX per share
339```
341**Base Case (300-500 words)**
342```
343Base Case: [Title describing most likely scenario]
345Probability: XX%
347Key Assumptions:
348[Similar structure to Bull Case with base assumptions]
350Rationale:
351[Explain why this is most likely scenario]
353Valuation:
354- DCF Value: $XX per share
355- Trading Comps: $XX per share
356- Base Case Target: $XX per share (weighted average)
357```
359**Bear Case (500-700 words)**
360```
361Bear Case: [Title describing downside scenario]
363Probability: XX%
365Key Assumptions:
366[Similar structure with downside parameters]
368Downside Triggers:
3691. [Specific risk event] - Likelihood: [%]
3702. [Specific risk event] - Likelihood: [%]
3713. [Specific risk event] - Likelihood: [%]
373Rationale:
374[200-300 words on what would cause bear case]
376Valuation Implications:
377- DCF Value: $XX per share (XX% downside from current)
378- Trading Comps: $XX per share
379- Bear Case Target: $XX per share
380```
382**Scenario Comparison (200-300 words)**
383- Comprehensive comparison table with key metrics
384- Analysis of probability-weighted outcomes
385- Risk/reward assessment
386- Path dependency discussion
388**Growth Drivers (800-1,200 words)**
389- 3-5 key growth drivers
390- Each quantified with specific opportunity size
391- Timeline and milestones
392- Supporting data from model

Pages 18-30: Financial Analysis

Historical Financial Analysis (1,200-1,800 words)

  • Revenue trends and drivers
  • Margin evolution
  • Cash flow analysis
  • Key metrics trajectory
  • Historical context

Projection Assumptions (2,000-3,000 words) ⭐ CRITICAL

MUST be extremely detailed. Structure:

A. Revenue by Product Assumptions (1,000-1,500 words)

For EACH major product category:

[Product Category A] Revenue Assumptions

We project [Product A] revenue to grow from $XXM in 2024A to $XXM in 2029E,
representing a XX% CAGR. This growth is driven by:

1. [Driver 1 with specific quantification]
   - Specific metric: from XX to XX
   - Timeline: achieving YY by 2026E
   - Basis: [source or rationale]

2. [Driver 2 with specific quantification]
3. [Driver 3 with specific quantification]
[... 8-12 detailed points total for this product ...]

Specific assumptions by year:
- 2025E: XX% growth driven by [specific factors]
- 2026E: XX% growth as [specific factors]
- 2027-2029E: XX% CAGR as [longer-term factors]

Key risks to these assumptions include [specific risks].

Repeat for EACH major product category.

B. Geographic Revenue Assumptions (500-800 words)

For EACH major region:

[Region] Revenue Assumptions

We project [Region] revenue to grow XX% CAGR from 2024-2029E, reaching $XXM, driven by:

1. [Market dynamic with quantification]
2. [Distribution expansion with specifics]
3. [Competitive positioning]
[... 6-8 detailed points total for this region ...]

Repeat for EACH major geographic region.

C. Other Key Assumptions (500-700 words)

  • Gross margin evolution (with specific drivers and bridge)
  • Operating expense assumptions (R&D, S&M, G&A as % of revenue)
  • Working capital assumptions (DSO, DIO, DPO with specific days)
  • CapEx as % of sales (with justification)
  • Tax rate assumptions

Scenario Analysis (1,500-2,000 words) ⭐ CRITICAL

MUST have specific parameters for each scenario. Structure:

Bull Case (500-700 words)

Bull Case: [Title describing key optimistic scenario]

Probability: XX%

Key Assumptions:
- Revenue CAGR (2024-2029E): XX% (vs. XX% base case)
- 2029E Revenue: $X,XXXm (vs. $X,XXXm base)
- 2029E EBITDA Margin: XX% (vs. XX% base)
- Key product growth: XX% CAGR (vs. XX% base)
- Geographic expansion: [specific milestones and timeline]
- Market share: XX% by 2029E (vs. XX% base)

Catalysts Required for Bull Case:
1. [Specific catalyst] - Expected timing: [date/quarter]
2. [Specific catalyst] - Expected timing: [date/quarter]
3. [Specific catalyst] - Expected timing: [date/quarter]

Detailed Rationale:
[200-300 words explaining what needs to happen for bull case to materialize.
Be specific about product launches, market conditions, competitive dynamics, etc.]

Valuation Implications:
- DCF Value: $XX per share (XX% upside from current)
- Trading Comps: XX.Xx EV/EBITDA implies $XX per share
- Bull Case Target: $XX per share

Base Case (300-500 words)

Base Case: [Title describing most likely scenario]

Probability: XX%

Key Assumptions:
[Similar structure to Bull Case with base assumptions]

Rationale:
[Explain why this is most likely scenario]

Valuation:
- DCF Value: $XX per share
- Trading Comps: $XX per share
- Base Case Target: $XX per share (weighted average)

Bear Case (500-700 words)

Bear Case: [Title describing downside scenario]

Probability: XX%

Key Assumptions:
[Similar structure with downside parameters]

Downside Triggers:
1. [Specific risk event] - Likelihood: [%]
2. [Specific risk event] - Likelihood: [%]
3. [Specific risk event] - Likelihood: [%]

Rationale:
[200-300 words on what would cause bear case]

Valuation Implications:
- DCF Value: $XX per share (XX% downside from current)
- Trading Comps: $XX per share
- Bear Case Target: $XX per share

Scenario Comparison (200-300 words)

  • Comprehensive comparison table with key metrics
  • Analysis of probability-weighted outcomes
  • Risk/reward assessment
  • Path dependency discussion

Growth Drivers (800-1,200 words)

  • 3-5 key growth drivers
  • Each quantified with specific opportunity size
  • Timeline and milestones
  • Supporting data from model
Raw lines 244 to 393
394### Pages 31-40: Valuation Analysis
396**Valuation Methodology (800-1,200 words)**
398**DCF Analysis (300-400 words)**
399- Methodology explanation
400- Key assumptions:
401 - WACC: X.X% (calculation breakdown)
402 - Terminal growth: X.X% (rationale)
403 - Terminal margin: XX% (justification)
404- Sensitivity analysis discussion
405- DCF value: $XX per share
407**Comparable Companies (300-400 words)**
408- Peer selection rationale (why these 5-10 companies)
409- Statistical summary (max/75th/median/25th/min)
410- Multiple selection (why EV/EBITDA vs. EV/Revenue vs. P/E)
411- Premium/discount justification (why target deserves premium/discount)
412- Comparable companies value: $XX per share
414**Precedent Transactions (200-300 words, if applicable)**
415- Transaction relevance
416- Control premium analysis
417- Precedent transactions value: $XX per share
419**Valuation Reconciliation (200-300 words)**
420- Weighting rationale (e.g., DCF 50%, Comps 40%, Precedent 10%)
421- Weighted average calculation
422- Valuation range (low/base/high)
423- Final price target: $XX
425**Price Target & Recommendation (300-500 words)**
426- Final recommendation (BUY/OUTPERFORM/HOLD/UNDERPERFORM/SELL)
427- Price target: $XX (XX% upside from current $XX)
428- Time horizon: 12 months
429- Key catalysts (3-5 with specific timeframes)
430- Key risks to price target (3-5 with impact quantification)

Pages 31-40: Valuation Analysis

Valuation Methodology (800-1,200 words)

DCF Analysis (300-400 words)

  • Methodology explanation
  • Key assumptions:
  • WACC: X.X% (calculation breakdown)
  • Terminal growth: X.X% (rationale)
  • Terminal margin: XX% (justification)
  • Sensitivity analysis discussion
  • DCF value: $XX per share

Comparable Companies (300-400 words)

  • Peer selection rationale (why these 5-10 companies)
  • Statistical summary (max/75th/median/25th/min)
  • Multiple selection (why EV/EBITDA vs. EV/Revenue vs. P/E)
  • Premium/discount justification (why target deserves premium/discount)
  • Comparable companies value: $XX per share

Precedent Transactions (200-300 words, if applicable)

  • Transaction relevance
  • Control premium analysis
  • Precedent transactions value: $XX per share

Valuation Reconciliation (200-300 words)

  • Weighting rationale (e.g., DCF 50%, Comps 40%, Precedent 10%)
  • Weighted average calculation
  • Valuation range (low/base/high)
  • Final price target: $XX

Price Target & Recommendation (300-500 words)

  • Final recommendation (BUY/OUTPERFORM/HOLD/UNDERPERFORM/SELL)
  • Price target: $XX (XX% upside from current $XX)
  • Time horizon: 12 months
  • Key catalysts (3-5 with specific timeframes)
  • Key risks to price target (3-5 with impact quantification)
Raw lines 394 to 431
432### Pages 41-50: Appendices
434**Data Sources & References**
435- All sources listed with dates
436- Organized by category:
437 - SEC Filings (with EDGAR links)
438 - Earnings Calls (with transcript links)
439 - Company Materials
440 - Industry Reports
441 - News Articles
442- **ALL URLs must be clickable hyperlinks**
444**Detailed Financial Model Assumptions**
445- Comprehensive assumptions detail
446- Calculation methodologies
447- Data sources for historical figures
449**Additional Supporting Tables**
450- Extended financial projections
451- Detailed comparable companies data
452- Sensitivity analyses
454---

Pages 41-50: Appendices

Data Sources & References

  • All sources listed with dates
  • Organized by category:
  • SEC Filings (with EDGAR links)
  • Earnings Calls (with transcript links)
  • Company Materials
  • Industry Reports
  • News Articles
  • ALL URLs must be clickable hyperlinks

Detailed Financial Model Assumptions

  • Comprehensive assumptions detail
  • Calculation methodologies
  • Data sources for historical figures

Additional Supporting Tables

  • Extended financial projections
  • Detailed comparable companies data
  • Sensitivity analyses

Raw lines 432 to 455
456## Report Assembly Philosophy
458**CRITICAL PRINCIPLE 1**: A good equity research report is **text-dense with lots of illustrating images**.
460**Target density**: 60-80% page coverage
461- Every page should have BOTH text AND visuals
462- Charts should be interspersed throughout text, not grouped
463- Average 1 chart per page minimum (30-50 pages = 25-35+ charts)
464- Tables should break up large text blocks
466**CRITICAL PRINCIPLE 2**: Use Claude's DOCX and XLSX skills to programmatically create the report.
468**REQUIRED TOOLS** (Claude has built-in skills for these):
469- **DOCX skill** - To create and manipulate Word documents
470 - Read Task 1 .md file → Convert to Word formatting
471 - Insert images from Task 4 chart files
472 - Create tables
473 - Format text, headers, footers, page numbers
474 - Add hyperlinks
475- **XLSX skill** - To read data from Excel files
476 - Extract tables from Task 2 financial model
477 - Read Task 3 valuation tabs
478 - Pull historical financials from Task 1
479- **Direct file operations** - Work with actual files
480 - Read: `[Company]_Research_Document_[Date].md`
481 - Read: `[Company]_Financial_Model_[Date].xlsx`
482 - Read: `chart_01.png`, `chart_02.png`, etc.
483 - Write: `[Company]_Initiation_Report_[Date].docx`
485**DO NOT**: Manually copy/paste or describe what should be done
486**DO**: Use Claude's DOCX and XLSX skills to open files, extract data, and create the DOCX report
488**Content Reuse Strategy**:
489- **Task 1 content (40-50% of report)**: Read .md file → Convert to Word format → Add charts
490- **Task 2/3 data (30-40% of report)**: Read .xlsx file → Extract tables → Write interpretation
491- **Original writing (10-20% of report)**: Investment thesis, projection assumptions, scenario analysis
493**This approach**:
494- Maximizes efficiency (no rewriting 6-8K words that are already good)
495- Maintains quality (Task 1 content is substantive, professional analysis)
496- Focuses effort on value-add (quantitative interpretation and investment thesis)
497- Uses actual files programmatically (not manual work)
499---

Report Assembly Philosophy

CRITICAL PRINCIPLE 1: A good equity research report is text-dense with lots of illustrating images.

Target density: 60-80% page coverage

  • Every page should have BOTH text AND visuals
  • Charts should be interspersed throughout text, not grouped
  • Average 1 chart per page minimum (30-50 pages = 25-35+ charts)
  • Tables should break up large text blocks

CRITICAL PRINCIPLE 2: Use Claude's DOCX and XLSX skills to programmatically create the report.

REQUIRED TOOLS (Claude has built-in skills for these):

  • DOCX skill - To create and manipulate Word documents
  • Read Task 1 .md file → Convert to Word formatting
  • Insert images from Task 4 chart files
  • Create tables
  • Format text, headers, footers, page numbers
  • Add hyperlinks
  • XLSX skill - To read data from Excel files
  • Extract tables from Task 2 financial model
  • Read Task 3 valuation tabs
  • Pull historical financials from Task 1
  • Direct file operations - Work with actual files
  • Read: [Company]_Research_Document_[Date].md
  • Read: [Company]_Financial_Model_[Date].xlsx
  • Read: chart_01.png, chart_02.png, etc.
  • Write: [Company]_Initiation_Report_[Date].docx

DO NOT: Manually copy/paste or describe what should be done DO: Use Claude's DOCX and XLSX skills to open files, extract data, and create the DOCX report

Content Reuse Strategy:

  • Task 1 content (40-50% of report): Read .md file → Convert to Word format → Add charts
  • Task 2/3 data (30-40% of report): Read .xlsx file → Extract tables → Write interpretation
  • Original writing (10-20% of report): Investment thesis, projection assumptions, scenario analysis

This approach:

  • Maximizes efficiency (no rewriting 6-8K words that are already good)
  • Maintains quality (Task 1 content is substantive, professional analysis)
  • Focuses effort on value-add (quantitative interpretation and investment thesis)
  • Uses actual files programmatically (not manual work)

Raw lines 456 to 500
501## Step-by-Step Report Assembly Workflow

Step-by-Step Report Assembly Workflow

Raw lines 501 to 502
503### Step 1: Organize All Inputs and Verify Files
505**Verify all input files exist:**
507Use Claude's file operations to check:
508- `[Company]_Research_Document_[Date].md` (Task 1)
509- `[Company]_Historical_Financials_[Date].xlsx` (Task 1)
510- `[Company]_Financial_Model_[Date].xlsx` (Task 2 with Task 3 tabs)
511- `[Company]_Valuation_Analysis_[Date].md` (Task 3)
512- `[Company]_Charts_[Date].zip` (Task 4) - **Extract this first**
514**Step 1a: Extract Charts from Zip File**
516Before proceeding, extract all chart files from the Task 4 zip:
517- Locate `[Company]_Charts_[Date].zip`
518- Extract all contents to a working directory (e.g., `task4_charts/`)
519- Verify 25-35 PNG files were extracted
520- Verify chart_index.txt is present
522**Expected folder structure after extraction:**
523```
524[Company]_Report_Working/
525├── [Company]_Research_Document_[Date].md
526├── [Company]_Historical_Financials_[Date].xlsx
527├── [Company]_Financial_Model_[Date].xlsx (includes Task 3 valuation tabs)
528│ ├── [Task 2 tabs: Revenue Model, Income Statement, Scenarios, etc.]
529│ └── [Task 3 tabs: DCF, Sensitivity, Comps, Valuation Summary]
530├── [Company]_Valuation_Analysis_[Date].md
531├── [Company]_Charts_[Date].zip
532├── task4_charts/ (extracted from zip)
533│ ├── chart_01_stock_price.png
534│ ├── chart_02_revenue_growth.png
535│ ├── chart_03_revenue_by_product.png ⭐
536│ ├── chart_04_revenue_by_geography.png ⭐
537│ ├── ... (21-31 more charts)
538│ ├── chart_28_dcf_sensitivity.png ⭐
539│ ├── chart_32_valuation_football_field.png ⭐
540│ └── chart_index.txt
541└── sources_and_urls.txt
542```
544**Open and inspect files using Claude skills:**
5461. **Read Task 1 markdown file** - Use Read tool to view content
5472. **Open Task 2/3 Excel file** - Use XLSX skill to inspect tabs:
548 - Verify required tabs exist: Revenue Model, Income Statement, Scenarios, DCF, Sensitivity Analysis, Comparable Companies
5493. **Read Task 3 markdown file** - Use Read tool to view valuation analysis
5504. **Check chart files** - Verify all 25-35 PNG files present
552**Note**: Task 2's financial model file now contains both the original modeling tabs (from Task 2) AND the valuation tabs (added by Task 3). This single Excel file contains all quantitative data needed for report assembly.

Step 1: Organize All Inputs and Verify Files

Verify all input files exist:

Use Claude's file operations to check:

  • [Company]_Research_Document_[Date].md (Task 1)
  • [Company]_Historical_Financials_[Date].xlsx (Task 1)
  • [Company]_Financial_Model_[Date].xlsx (Task 2 with Task 3 tabs)
  • [Company]_Valuation_Analysis_[Date].md (Task 3)
  • [Company]_Charts_[Date].zip (Task 4) - Extract this first

Step 1a: Extract Charts from Zip File

Before proceeding, extract all chart files from the Task 4 zip:

  • Locate [Company]_Charts_[Date].zip
  • Extract all contents to a working directory (e.g., task4_charts/)
  • Verify 25-35 PNG files were extracted
  • Verify chart_index.txt is present

Expected folder structure after extraction:

[Company]_Report_Working/
├── [Company]_Research_Document_[Date].md
├── [Company]_Historical_Financials_[Date].xlsx
├── [Company]_Financial_Model_[Date].xlsx (includes Task 3 valuation tabs)
│   ├── [Task 2 tabs: Revenue Model, Income Statement, Scenarios, etc.]
│   └── [Task 3 tabs: DCF, Sensitivity, Comps, Valuation Summary]
├── [Company]_Valuation_Analysis_[Date].md
├── [Company]_Charts_[Date].zip
├── task4_charts/ (extracted from zip)
│   ├── chart_01_stock_price.png
│   ├── chart_02_revenue_growth.png
│   ├── chart_03_revenue_by_product.png ⭐
│   ├── chart_04_revenue_by_geography.png ⭐
│   ├── ... (21-31 more charts)
│   ├── chart_28_dcf_sensitivity.png ⭐
│   ├── chart_32_valuation_football_field.png ⭐
│   └── chart_index.txt
└── sources_and_urls.txt

Open and inspect files using Claude skills:

  1. Read Task 1 markdown file - Use Read tool to view content
  2. Open Task 2/3 Excel file - Use XLSX skill to inspect tabs:
  3. Verify required tabs exist: Revenue Model, Income Statement, Scenarios, DCF, Sensitivity Analysis, Comparable Companies
  4. Read Task 3 markdown file - Use Read tool to view valuation analysis
  5. Check chart files - Verify all 25-35 PNG files present

Note: Task 2's financial model file now contains both the original modeling tabs (from Task 2) AND the valuation tabs (added by Task 3). This single Excel file contains all quantitative data needed for report assembly.

Raw lines 503 to 553
554### Step 2: Extract Tables from Excel Using XLSX Skill
556**Use Claude's XLSX skill to extract data from Excel files:**
558#### Table 1: Page 1 Summary Financials
560Use XLSX skill to:
5611. Open `[Company]_Financial_Model_[Date].xlsx`
5622. Read from `Income Statement` tab
5633. Extract key rows: Revenue, Gross Profit, EBITDA, Net Income, EPS, FCF
5644. Extract years: 2022A, 2023A, 2024A, 2025E, 2026E, 2027E
5655. Create summary table with growth rates and margins
567#### Table 2: Full Income Statement (40-50 line items)
569Use XLSX skill to:
5701. Open `[Company]_Financial_Model_[Date].xlsx`
5712. Read entire `Income Statement` tab
5723. Extract all line items (40-50 rows)
5734. Extract columns for historical (2020A-2024A) + projected years (2025E-2029E)
5745. Include all margins and growth rates
576#### Table 3: Revenue by Product (20-30 rows)
578Use XLSX skill to:
5791. Open `[Company]_Financial_Model_[Date].xlsx`
5802. Read from `Revenue Model` tab
5813. Navigate to product section (typically starts ~row 5)
5824. Extract 20-30 rows showing each product category
5835. Include columns: Product name, historical years, projected years, % of Total, YoY Growth
585#### Table 4: Revenue by Geography (15-20 rows)
587Use XLSX skill to:
5881. Open `[Company]_Financial_Model_[Date].xlsx`
5892. Read from `Revenue Model` tab
5903. Navigate to geography section (typically starts ~row 40)
5914. Extract 15-20 rows showing each geographic region
5925. Include columns: Region, historical years, projected years, % of Total, YoY Growth
594#### Table 5: Comparable Companies
595**Extract from:** Task 3 valuation tabs in Task 2's financial model (`Comparable Companies` tab)
597Use XLSX skill to:
5981. Open `[Company]_Financial_Model_[Date].xlsx`
5992. Read from `Comparable Companies` tab (added by Task 3)
6003. Extract full table with company names as row headers
6014. **CRITICAL**: Verify statistical summary rows are present at bottom:
602 - Maximum
603 - 75th Percentile
604 - Median
605 - 25th Percentile
606 - Minimum
6075. If statistical summary is missing, report ERROR
609**Expected format:**
610```
611Company Ticker Mkt Cap EV/Rev EV/Rev EV/EBITDA EV/EBITDA P/E Rev EBITDA
612 ($B) LTM NTM LTM NTM NTM Growth Margin
613[5-10 peers plus target, then statistical summary]
614```
616#### Additional Tables (7-15 more)
617**Extract from Task 2 financial model (with Task 3 tabs):**
619Use XLSX skill to extract these tables:
621**DCF Assumptions Table** (Task 3 `DCF` tab)
622- Open `[Company]_Financial_Model_[Date].xlsx`
623- Read from DCF tab
624- Extract columns A-C (Assumption, Value, Source)
625- Extract first 20 rows
627**DCF Sensitivity Matrix** (Task 3 `Sensitivity Analysis` tab)
628- Read from Sensitivity Analysis tab
629- Extract full sensitivity matrix
630- WACC values as row headers
631- Terminal growth rates as column headers
633**Scenario Comparison Table** (Task 2 `Scenarios` tab)
634- Read from Scenarios tab
635- Extract full scenario table
636- Metrics as row headers (Revenue, EBITDA, Margins, etc.)
637- Columns: Bull, Base, Bear
639**Other supporting tables to extract:**
640- Cash flow statement
641- Balance sheet highlights
642- Key metrics dashboard
643- Margin bridge
644- Working capital schedule
645- TAM sizing table
646- Market share table
648**Create all 12-20 tables with proper formatting.**

Step 2: Extract Tables from Excel Using XLSX Skill

Use Claude's XLSX skill to extract data from Excel files:

Table 1: Page 1 Summary Financials

Use XLSX skill to:

  1. Open [Company]_Financial_Model_[Date].xlsx
  2. Read from Income Statement tab
  3. Extract key rows: Revenue, Gross Profit, EBITDA, Net Income, EPS, FCF
  4. Extract years: 2022A, 2023A, 2024A, 2025E, 2026E, 2027E
  5. Create summary table with growth rates and margins

Table 2: Full Income Statement (40-50 line items)

Use XLSX skill to:

  1. Open [Company]_Financial_Model_[Date].xlsx
  2. Read entire Income Statement tab
  3. Extract all line items (40-50 rows)
  4. Extract columns for historical (2020A-2024A) + projected years (2025E-2029E)
  5. Include all margins and growth rates

Table 3: Revenue by Product (20-30 rows)

Use XLSX skill to:

  1. Open [Company]_Financial_Model_[Date].xlsx
  2. Read from Revenue Model tab
  3. Navigate to product section (typically starts ~row 5)
  4. Extract 20-30 rows showing each product category
  5. Include columns: Product name, historical years, projected years, % of Total, YoY Growth

Table 4: Revenue by Geography (15-20 rows)

Use XLSX skill to:

  1. Open [Company]_Financial_Model_[Date].xlsx
  2. Read from Revenue Model tab
  3. Navigate to geography section (typically starts ~row 40)
  4. Extract 15-20 rows showing each geographic region
  5. Include columns: Region, historical years, projected years, % of Total, YoY Growth

Table 5: Comparable Companies

Extract from: Task 3 valuation tabs in Task 2's financial model (Comparable Companies tab)

Use XLSX skill to:

  1. Open [Company]_Financial_Model_[Date].xlsx
  2. Read from Comparable Companies tab (added by Task 3)
  3. Extract full table with company names as row headers
  4. CRITICAL: Verify statistical summary rows are present at bottom:
  5. Maximum
  6. 75th Percentile
  7. Median
  8. 25th Percentile
  9. Minimum
  10. If statistical summary is missing, report ERROR

Expected format:

Company      Ticker  Mkt Cap  EV/Rev  EV/Rev  EV/EBITDA  EV/EBITDA  P/E   Rev     EBITDA
                     ($B)     LTM     NTM     LTM        NTM        NTM   Growth  Margin
[5-10 peers plus target, then statistical summary]

Additional Tables (7-15 more)

Extract from Task 2 financial model (with Task 3 tabs):

Use XLSX skill to extract these tables:

DCF Assumptions Table (Task 3 DCF tab)

  • Open [Company]_Financial_Model_[Date].xlsx
  • Read from DCF tab
  • Extract columns A-C (Assumption, Value, Source)
  • Extract first 20 rows

DCF Sensitivity Matrix (Task 3 Sensitivity Analysis tab)

  • Read from Sensitivity Analysis tab
  • Extract full sensitivity matrix
  • WACC values as row headers
  • Terminal growth rates as column headers

Scenario Comparison Table (Task 2 Scenarios tab)

  • Read from Scenarios tab
  • Extract full scenario table
  • Metrics as row headers (Revenue, EBITDA, Margins, etc.)
  • Columns: Bull, Base, Bear

Other supporting tables to extract:

  • Cash flow statement
  • Balance sheet highlights
  • Key metrics dashboard
  • Margin bridge
  • Working capital schedule
  • TAM sizing table
  • Market share table

Create all 12-20 tables with proper formatting.

Raw lines 554 to 649
650### Step 3: Write Quantitative Sections
652These sections interpret the financial model.
654**Write in this order:**
656#### A. Financial Analysis (1,200-1,800 words)
657- Analyze historical performance from model
658- Discuss trends in revenue, margins, cash flow
659- Reference specific charts and tables
660- Lead with numbers
662#### B. Projection Assumptions (2,000-3,000 words) ⭐ CRITICAL
663- Follow detailed structure from Report Structure section above
664- Must be product-by-product (8-12 points per product)
665- Must be region-by-region (6-8 points per region)
666- Must include margin, opex, capex, working capital assumptions
667- **This section separates amateur from professional analysis**
669#### C. Scenario Analysis (1,500-2,000 words) ⭐ CRITICAL
670- Follow detailed structure from Report Structure section above
671- Bull case: specific parameters, catalysts, probability, valuation
672- Base case: most likely scenario with rationale
673- Bear case: downside triggers and parameters
674- Comparison table and analysis
675- **Must have specific quantified parameters for each scenario**
677#### D. Growth Drivers (800-1,200 words)
678- 3-5 key drivers with quantified opportunities
679- Timeline and milestones
680- Evidence from model
682#### E. Valuation Methodology (800-1,200 words)
683- DCF explanation with assumptions
684- Comparables rationale
685- Precedent transactions (if applicable)
686- Reconciliation and weighting
687- Price target derivation

Step 3: Write Quantitative Sections

These sections interpret the financial model.

Write in this order:

A. Financial Analysis (1,200-1,800 words)

  • Analyze historical performance from model
  • Discuss trends in revenue, margins, cash flow
  • Reference specific charts and tables
  • Lead with numbers

B. Projection Assumptions (2,000-3,000 words) ⭐ CRITICAL

  • Follow detailed structure from Report Structure section above
  • Must be product-by-product (8-12 points per product)
  • Must be region-by-region (6-8 points per region)
  • Must include margin, opex, capex, working capital assumptions
  • This section separates amateur from professional analysis

C. Scenario Analysis (1,500-2,000 words) ⭐ CRITICAL

  • Follow detailed structure from Report Structure section above
  • Bull case: specific parameters, catalysts, probability, valuation
  • Base case: most likely scenario with rationale
  • Bear case: downside triggers and parameters
  • Comparison table and analysis
  • Must have specific quantified parameters for each scenario

D. Growth Drivers (800-1,200 words)

  • 3-5 key drivers with quantified opportunities
  • Timeline and milestones
  • Evidence from model

E. Valuation Methodology (800-1,200 words)

  • DCF explanation with assumptions
  • Comparables rationale
  • Precedent transactions (if applicable)
  • Reconciliation and weighting
  • Price target derivation
Raw lines 650 to 688
689### Step 4: Write Synthesis Sections
691**Write in this order:**
693#### A. Investment Thesis (800-1,200 words)
694- 3-5 key pillars
695- Each pillar: 200-300 words
696- Lead with key statistic
697- Quantify financial impact
698- Include timeline
700#### B. Risk Assessment (600-900 words)
701- Pull from Task 1 research document
702- Organize into 4 categories
703- 8-12 risks total
704- Each risk: 50-100 words
706#### C. Price Target & Recommendation (300-500 words)
707- Final recommendation
708- Price target with upside %
709- Key catalysts with timeframes
710- Key risks to target
712#### D. Investment Summary (500-700 words) - WRITE LAST
713- Page 1 content
714- 3-4 detailed bullets with bold headers
715- Complete synthesis of all findings
716- **Write this section LAST after full analysis complete**

Step 4: Write Synthesis Sections

Write in this order:

A. Investment Thesis (800-1,200 words)

  • 3-5 key pillars
  • Each pillar: 200-300 words
  • Lead with key statistic
  • Quantify financial impact
  • Include timeline

B. Risk Assessment (600-900 words)

  • Pull from Task 1 research document
  • Organize into 4 categories
  • 8-12 risks total
  • Each risk: 50-100 words

C. Price Target & Recommendation (300-500 words)

  • Final recommendation
  • Price target with upside %
  • Key catalysts with timeframes
  • Key risks to target

D. Investment Summary (500-700 words) - WRITE LAST

  • Page 1 content
  • 3-4 detailed bullets with bold headers
  • Complete synthesis of all findings
  • Write this section LAST after full analysis complete
Raw lines 689 to 717
718### Step 5: Integrate Company Content from Task 1
720**CRITICAL INSTRUCTION**: Use Task 1 research document almost verbatim. DO NOT rewrite.
722**The company research from Task 1 (6-8K words) is already professional, substantive analysis. Objective:**
7231. **Reformat for Word** - Convert markdown to DOCX formatting
7242. **Insert charts inline** - Add relevant charts from Task 4 throughout the text
7253. **Minor style adjustments** - Ensure consistent formatting with rest of report
727**Extract these sections from Task 1 research document:**
728- Company description (800-1,200 words) → **Use verbatim, insert company overview charts**
729- Company history (800-1,200 words) → **Use verbatim, insert timeline chart**
730- Management bios (1,000-1,400 words) → **Use verbatim, insert org chart if available**
731- Products & services (700-1,000 words) → **Use verbatim, insert product portfolio charts**
732- Customers & GTM (500-700 words) → **Use verbatim, insert customer segmentation charts**
733- Industry overview (800-1,200 words) → **Use verbatim, insert market size evolution charts**
734- Competitive landscape (700-1,000 words) → **Use verbatim, insert competitive positioning charts**
735- TAM analysis (500-700 words) → **Use verbatim, insert TAM sizing charts**
736- Risk assessment (600-900 words) → **Use verbatim, format as Investment Thesis & Risks section**
738**Chart Integration Strategy:**
739- Every 200-300 words of text → Insert 1 chart
740- Company 101 section (pages 6-17) should have 8-12 charts interspersed
741- Place charts immediately after the paragraph that discusses the topic
742- **Result**: Dense, visually rich pages (60-80% coverage)

Step 5: Integrate Company Content from Task 1

CRITICAL INSTRUCTION: Use Task 1 research document almost verbatim. DO NOT rewrite.

The company research from Task 1 (6-8K words) is already professional, substantive analysis. Objective:

  1. Reformat for Word - Convert markdown to DOCX formatting
  2. Insert charts inline - Add relevant charts from Task 4 throughout the text
  3. Minor style adjustments - Ensure consistent formatting with rest of report

Extract these sections from Task 1 research document:

  • Company description (800-1,200 words) → Use verbatim, insert company overview charts
  • Company history (800-1,200 words) → Use verbatim, insert timeline chart
  • Management bios (1,000-1,400 words) → Use verbatim, insert org chart if available
  • Products & services (700-1,000 words) → Use verbatim, insert product portfolio charts
  • Customers & GTM (500-700 words) → Use verbatim, insert customer segmentation charts
  • Industry overview (800-1,200 words) → Use verbatim, insert market size evolution charts
  • Competitive landscape (700-1,000 words) → Use verbatim, insert competitive positioning charts
  • TAM analysis (500-700 words) → Use verbatim, insert TAM sizing charts
  • Risk assessment (600-900 words) → Use verbatim, format as Investment Thesis & Risks section

Chart Integration Strategy:

  • Every 200-300 words of text → Insert 1 chart
  • Company 101 section (pages 6-17) should have 8-12 charts interspersed
  • Place charts immediately after the paragraph that discusses the topic
  • Result: Dense, visually rich pages (60-80% coverage)
Raw lines 718 to 743
744### Step 6: Assemble DOCX Report
746**CRITICAL**: Create actual DOCX file, NOT markdown.
748**Assembly Order (Most Efficient):**
750#### Phase A: Create Structure & Add Page 1
7511. Create DOCX document
7522. Set up professional styling (fonts, headers, footers)
7533. Create Page 1 - Investment Summary (write this LAST after all analysis complete)
7544. Add Table of Contents placeholder
756#### Phase B: Copy Task 1 Content + Insert Charts
757**This is 40-50% of the report - mostly copy/paste + chart insertion**
759Use Claude's DOCX skill to:
7611. **Initialize new DOCX document**
762 - Create new Word document
763 - Set professional styling (fonts, margins)
7652. **Read Task 1 markdown file**
766 - Use Read tool: `[Company]_Research_Document_[Date].md`
767 - Identify sections by markdown headers (## Section Title)
7693. **Extract and convert each section from Task 1 to Word format:**
771**SECTION 1: Investment Thesis & Risks**
772- Add heading: 'Investment Thesis & Risks' (level 1)
773- Extract 'Risk Assessment' section from Task 1 markdown
774- Convert markdown formatting to Word formatting (remove ##, **, etc.)
775- Add paragraphs to Word document (split by blank lines)
776- Add new 'Investment Thesis' heading (level 2)
777- Write new investment thesis content (800-1,200 words based on all analysis)
779**SECTION 2: Company 101 (Pages 6-17)**
780Copy each section from Task 1 verbatim with formatting conversion:
782- **Company Overview**
783 - Add heading: 'Company Overview' (level 1)
784 - Extract 'Company Overview' section from Task 1
785 - Convert to Word paragraphs
786 - Insert chart: `task4_charts/chart_05_company_overview.png` (6 inches wide)
788- **Company History**
789 - Add heading: 'Company History' (level 1)
790 - Extract 'Company History' section from Task 1
791 - Convert to Word paragraphs
792 - Insert chart: `task4_charts/chart_06_company_timeline.png` (6 inches wide)
794- **Management Team**
795 - Add heading: 'Management Team' (level 1)
796 - Extract 'Management Team' section from Task 1
797 - Convert to Word paragraphs
798 - Insert chart: `task4_charts/chart_07_org_structure.png` (5 inches wide)
800- **Products & Services**
801 - Add heading: 'Products & Services' (level 1)
802 - Extract 'Products & Services' section from Task 1
803 - Add first paragraph
804 - Insert chart: `task4_charts/chart_08_product_portfolio.png` (6 inches wide)
805 - Add remaining paragraphs
807- **Customers & Go-to-Market**
808 - Add heading: 'Customers & Go-to-Market' (level 1)
809 - Extract section from Task 1
810 - Convert to Word paragraphs
811 - Insert chart: `task4_charts/chart_09_customer_segments.png` (6 inches wide)
813- **Industry Overview**
814 - Add heading: 'Industry Overview' (level 1)
815 - Extract section from Task 1
816 - Add first paragraph
817 - Insert chart: `task4_charts/chart_10_market_size_evolution.png` (6 inches wide)
818 - Add remaining paragraphs
819 - Insert chart: `task4_charts/chart_11_industry_trends.png` (6 inches wide)
821- **Competitive Landscape**
822 - Add heading: 'Competitive Landscape' (level 1)
823 - Extract section from Task 1
824 - Add first paragraph
825 - Insert chart: `task4_charts/chart_16_competitive_positioning.png` (6 inches wide)
826 - Add remaining paragraphs
827 - Insert chart: `task4_charts/chart_17_market_share.png` (5 inches wide)
829- **Market Opportunity**
830 - Add heading: 'Market Opportunity' (level 1)
831 - Extract 'Market Opportunity' section from Task 1
832 - Convert to Word paragraphs
833 - Insert chart: `task4_charts/chart_15_TAM_sizing.png` (6 inches wide)
835**Result after Phase B**: Pages 6-17 complete (~12 pages, 6-8K words, 8-12 charts embedded)
837**Key Point**: Use DOCX skill to READ from Task 1's .md file and INSERT actual image files. No manual copy/paste required.
839#### Phase C: Add Financial Analysis with Data from Task 2
840**This requires NEW WRITING interpreting quantitative data**
842Use Claude's DOCX and XLSX skills to:
844**SECTION 3: Financial Analysis (Pages 18-30)**
8461. **Add section heading: 'Financial Analysis' (level 1)**
8482. **Historical Financial Analysis (1,200-1,800 words) - NEW WRITING**
849 - Add heading: 'Historical Performance' (level 2)
850 - Use XLSX skill to open `[Company]_Financial_Model_[Date].xlsx`
851 - Read `Income Statement` tab to extract historical data
852 - Read `Revenue Model` tab to extract revenue trends
853 - Calculate key metrics (e.g., Revenue CAGR from 2020-2024)
854 - Write analytical paragraphs interpreting the trends (1,200-1,800 words)
855 - Lead with specific numbers: "Revenue grew from $XXM in 2020 to $XXM in 2024, representing a XX% CAGR. This growth was driven by..."
856 - Insert chart: `task4_charts/chart_02_revenue_growth_trajectory.png` (6 inches wide)
8583. **Create Table: Full Income Statement**
859 - Add heading: 'Historical Income Statement' (level 3)
860 - Use XLSX skill to extract entire Income Statement tab (40-50 rows)
861 - Create Word table with all columns (historical years 2020A-2024A + projected 2025E-2029E)
862 - Include all line items: Revenue, COGS, Gross Profit, Operating Expenses, EBITDA, Net Income, etc.
8644. **Add mandatory charts and tables for Revenue breakdown:**
865 - Insert chart: `task4_charts/chart_03_revenue_by_product.png` (6.5 inches wide) ⭐ MANDATORY
866 - **Create Table: Revenue by Product (20-30 rows)**
867 - Use XLSX skill to extract from Revenue Model tab (product section, typically rows 5-35)
868 - Create Word table showing each product category with historical and projected years
869 - Include columns: Product name, historical years, projected years, % of Total, YoY Growth
871 - Insert chart: `task4_charts/chart_04_revenue_by_geography.png` (6.5 inches wide) ⭐ MANDATORY
872 - **Create Table: Revenue by Geography (15-20 rows)**
873 - Use XLSX skill to extract from Revenue Model tab (geography section, typically rows 40-60)
874 - Create Word table showing each geographic region with historical and projected years
8765. **Add additional financial charts:**
877 - Insert chart: `task4_charts/chart_10_gross_margin_evolution.png` (6 inches wide)
878 - Insert chart: `task4_charts/chart_11_ebitda_margin_progression.png` (6 inches wide)
879 - Insert chart: `task4_charts/chart_12_free_cash_flow_trend.png` (6 inches wide)
8816. **Projection Assumptions (2,000-3,000 words) ⭐ CRITICAL - NEW WRITING**
882 - Add heading: 'Projection Assumptions' (level 2)
883 - Use XLSX skill to read Scenarios tab to inform assumptions
884 - Use XLSX skill to read Revenue Model tab for specific product/geography projections
885 - Add heading: 'Revenue Assumptions by Product' (level 3)
886 - Write detailed product-by-product assumptions (8-12 points per major product)
887 - Write detailed region-by-region assumptions (6-8 points per major region)
888 - Include margin, opex, capex, working capital assumptions
889 - **Total: 2,000-3,000 words of specific, quantified assumptions**
8917. **Scenario Analysis (1,500-2,000 words) ⭐ CRITICAL - NEW WRITING**
892 - Add heading: 'Scenario Analysis' (level 2)
893 - Use XLSX skill to extract scenario data from Scenarios tab
894 - Extract Bull/Base/Bear parameters for key metrics (2029E Revenue, EBITDA Margin, etc.)
895 - Write Bull Case (500-700 words): specific parameters, catalysts, probability, valuation
896 - Write Base Case (300-500 words): most likely scenario with rationale
897 - Write Bear Case (500-700 words): downside triggers, parameters, probability, valuation
898 - Write Scenario Comparison (200-300 words)
899 - Insert chart: `task4_charts/chart_14_scenario_comparison.png` (6 inches wide)
900 - **Create Table: Scenario Comparison**
901 - Use XLSX skill to extract from Scenarios tab
902 - Create Word table with Bull/Base/Bear columns and key metrics as rows
9048. **Growth Drivers (800-1,200 words) - NEW WRITING**
905 - Add heading: 'Key Growth Drivers' (level 2)
906 - Write 3-5 key drivers with specific quantified opportunities
907 - Include timelines and milestones
908 - Reference specific data from financial model
910**Result after Phase C**: Pages 18-30 complete (~13 pages, 5-7K words, 7-8 charts, 6-8 tables)
912**Key Point**: Use XLSX skill to READ data from Task 2's Excel file, use the data to inform NEW analytical writing, and use DOCX skill to create Word tables from Excel data.
914#### Phase D: Add Valuation Analysis from Task 3
915**Mix of copying Task 3 analysis + inserting data from Excel**
917Use Claude's DOCX and XLSX skills to:
919**SECTION 4: Valuation Analysis (Pages 31-40)**
9211. **Add section heading: 'Valuation Analysis' (level 1)**
9232. **Read Task 3 markdown file**
924 - Use Read tool: `[Company]_Valuation_Analysis_[Date].md`
925 - Identify sections by markdown headers: DCF Analysis, Comparable Companies, Price Target
9273. **DCF Analysis section**
928 - Add heading: 'DCF Analysis' (level 2)
929 - Extract 'DCF Analysis' section from Task 3 markdown
930 - Convert markdown to Word paragraphs
931 - Insert chart: `task4_charts/chart_28_dcf_sensitivity_heatmap.png` (6 inches wide) ⭐ MANDATORY
933 - **Create Table: DCF Key Assumptions**
934 - Add heading: 'DCF Key Assumptions' (level 3)
935 - Use XLSX skill to open `[Company]_Financial_Model_[Date].xlsx`
936 - Read DCF tab (columns A-C, first 20 rows: Assumption, Value, Source)
937 - Create Word table from extracted data
939 - **Create Table: DCF Sensitivity Matrix**
940 - Use XLSX skill to read Sensitivity Analysis tab
941 - Extract full sensitivity matrix (WACC values as rows, terminal growth as columns)
942 - Create Word table showing valuation at different parameter combinations
944 - Insert chart: `task4_charts/chart_29_dcf_waterfall.png` (6 inches wide)
9464. **Comparable Companies section**
947 - Add heading: 'Comparable Companies Analysis' (level 2)
948 - Extract 'Comparable Companies' section from Task 3 markdown
949 - Convert markdown to Word paragraphs
951 - **Create Table: Comparable Companies ⭐ CRITICAL**
952 - Add heading: 'Comparable Companies' (level 3)
953 - Use XLSX skill to read Comparable Companies tab
954 - Extract full table including:
955 - 5-10 peer companies plus target company
956 - Statistical summary rows (Maximum, 75th Percentile, Median, 25th Percentile, Minimum)
957 - Create Word table with all columns: Ticker, Market Cap, EV/Revenue (LTM & NTM), EV/EBITDA (LTM & NTM), P/E (NTM), Revenue Growth, EBITDA Margin
958 - **Verify statistical summary is included in table**
960 - Insert chart: `task4_charts/chart_31_peer_multiples_comparison.png` (6 inches wide)
9625. **Valuation Summary**
963 - Insert chart: `task4_charts/chart_32_valuation_football_field.png` (6.5 inches wide) ⭐ MANDATORY
965 - **Create Table: Valuation Summary**
966 - Use XLSX skill to read Valuation Summary tab
967 - Extract valuation methods (DCF, Comps, Precedent Transactions if applicable)
968 - Create Word table showing: Method, Low Case, Base Case, High Case, Weight, Weighted Value
9706. **Price Target & Recommendation**
971 - Add heading: 'Price Target and Recommendation' (level 2)
972 - Extract 'Price Target' section from Task 3 markdown
973 - Convert markdown to Word paragraphs
974 - Should include: Final recommendation (BUY/HOLD/SELL), price target with % upside, key catalysts, key risks
976**Result after Phase D**: Pages 31-40 complete (~10 pages, 3-4K words, 5-6 charts, 4-5 tables)
978**Key Point**: Use Read tool for Task 3's .md file to get written analysis, and use XLSX skill to READ from Task 3's Excel tabs (which were added to Task 2's model file) to create quantitative tables.
980#### Phase E: Add Appendices & Finalize
982Use Claude's DOCX skill to:
984**SECTION 5: Appendices (Pages 41-50)**
9861. **Data Sources & References**
987 - Add heading: 'Data Sources & References' (level 1)
988 - List all sources used throughout the report
989 - Organize by category:
990 - SEC Filings (10-K, 10-Q, DEF 14A, 8-K with EDGAR links)
991 - Earnings Calls (with transcript links)
992 - Company Materials (investor presentations, press releases)
993 - Industry Reports (Gartner, Forrester, etc.)
994 - News Articles
995 - **CRITICAL**: All URLs must be clickable hyperlinks (not plain text)
996 - Include dates for all sources
9982. **Additional Tables**
999 - Add heading: 'Additional Tables' (level 1)
1000 - Add extended financial projections
1001 - Add detailed assumptions tables
1002 - Add any supporting tables that didn't fit in main sections
1004#### Phase F: Write Page 1 Investment Summary
1005**NOW write Page 1 - after all analysis complete**
1006- INITIATING COVERAGE header
1007- Rating box
1008- 3-4 detailed bullets synthesizing entire report
1009- Financial summary table
1010- Stock price chart
1012#### Phase G: Add Table of Contents & Page Numbers
1013- Auto-generate TOC
1014- Add page numbers to all pages
1016**Key formatting requirements:**
1017- Professional fonts (Calibri, Arial, or similar)
1018- Proper headers and footers with page numbers
1019- Section breaks between major sections
1020- Embed all 25-35 charts inline throughout text
1021- Insert all 12-20 tables inline with text
1022- **All URLs as clickable hyperlinks** (NOT plain text)
1023- **60-80% page density** - Every page has text AND visuals
1025**Visual Density Strategy:**
1026```
1027Good page layout example:
1028┌─────────────────────────────┐
1029│ Section Header │
1030│ Text paragraph (200 words) │
1031│ [Chart embedded] │
1032│ Text paragraph (200 words) │
1033│ [Table embedded] │
1034│ Text paragraph (200 words) │
1035│ [Chart embedded] │
1036└─────────────────────────────┘
1038BAD - Avoid:
1039- Full page with only one chart
1040- Multiple pages of pure text
1041- Charts grouped at end of sections
1042```
1044**Result**: 30-50 page report that is text-dense with illustrating images throughout
1046---

Step 6: Assemble DOCX Report

CRITICAL: Create actual DOCX file, NOT markdown.

Assembly Order (Most Efficient):

Phase A: Create Structure & Add Page 1

  1. Create DOCX document
  2. Set up professional styling (fonts, headers, footers)
  3. Create Page 1 - Investment Summary (write this LAST after all analysis complete)
  4. Add Table of Contents placeholder

Phase B: Copy Task 1 Content + Insert Charts

This is 40-50% of the report - mostly copy/paste + chart insertion

Use Claude's DOCX skill to:

  1. Initialize new DOCX document
  2. Create new Word document
  3. Set professional styling (fonts, margins)
  1. Read Task 1 markdown file
  2. Use Read tool: [Company]_Research_Document_[Date].md
  3. Identify sections by markdown headers (## Section Title)
  1. Extract and convert each section from Task 1 to Word format:

SECTION 1: Investment Thesis & Risks

  • Add heading: 'Investment Thesis & Risks' (level 1)
  • Extract 'Risk Assessment' section from Task 1 markdown
  • Convert markdown formatting to Word formatting (remove ##, **, etc.)
  • Add paragraphs to Word document (split by blank lines)
  • Add new 'Investment Thesis' heading (level 2)
  • Write new investment thesis content (800-1,200 words based on all analysis)

SECTION 2: Company 101 (Pages 6-17) Copy each section from Task 1 verbatim with formatting conversion:

  • Company Overview
  • Add heading: 'Company Overview' (level 1)
  • Extract 'Company Overview' section from Task 1
  • Convert to Word paragraphs
  • Insert chart: task4_charts/chart_05_company_overview.png (6 inches wide)
  • Company History
  • Add heading: 'Company History' (level 1)
  • Extract 'Company History' section from Task 1
  • Convert to Word paragraphs
  • Insert chart: task4_charts/chart_06_company_timeline.png (6 inches wide)
  • Management Team
  • Add heading: 'Management Team' (level 1)
  • Extract 'Management Team' section from Task 1
  • Convert to Word paragraphs
  • Insert chart: task4_charts/chart_07_org_structure.png (5 inches wide)
  • Products & Services
  • Add heading: 'Products & Services' (level 1)
  • Extract 'Products & Services' section from Task 1
  • Add first paragraph
  • Insert chart: task4_charts/chart_08_product_portfolio.png (6 inches wide)
  • Add remaining paragraphs
  • Customers & Go-to-Market
  • Add heading: 'Customers & Go-to-Market' (level 1)
  • Extract section from Task 1
  • Convert to Word paragraphs
  • Insert chart: task4_charts/chart_09_customer_segments.png (6 inches wide)
  • Industry Overview
  • Add heading: 'Industry Overview' (level 1)
  • Extract section from Task 1
  • Add first paragraph
  • Insert chart: task4_charts/chart_10_market_size_evolution.png (6 inches wide)
  • Add remaining paragraphs
  • Insert chart: task4_charts/chart_11_industry_trends.png (6 inches wide)
  • Competitive Landscape
  • Add heading: 'Competitive Landscape' (level 1)
  • Extract section from Task 1
  • Add first paragraph
  • Insert chart: task4_charts/chart_16_competitive_positioning.png (6 inches wide)
  • Add remaining paragraphs
  • Insert chart: task4_charts/chart_17_market_share.png (5 inches wide)
  • Market Opportunity
  • Add heading: 'Market Opportunity' (level 1)
  • Extract 'Market Opportunity' section from Task 1
  • Convert to Word paragraphs
  • Insert chart: task4_charts/chart_15_TAM_sizing.png (6 inches wide)

Result after Phase B: Pages 6-17 complete (~12 pages, 6-8K words, 8-12 charts embedded)

Key Point: Use DOCX skill to READ from Task 1's .md file and INSERT actual image files. No manual copy/paste required.

Phase C: Add Financial Analysis with Data from Task 2

This requires NEW WRITING interpreting quantitative data

Use Claude's DOCX and XLSX skills to:

SECTION 3: Financial Analysis (Pages 18-30)

  1. Add section heading: 'Financial Analysis' (level 1)
  1. Historical Financial Analysis (1,200-1,800 words) - NEW WRITING
  2. Add heading: 'Historical Performance' (level 2)
  3. Use XLSX skill to open [Company]_Financial_Model_[Date].xlsx
  4. Read Income Statement tab to extract historical data
  5. Read Revenue Model tab to extract revenue trends
  6. Calculate key metrics (e.g., Revenue CAGR from 2020-2024)
  7. Write analytical paragraphs interpreting the trends (1,200-1,800 words)
  8. Lead with specific numbers: "Revenue grew from $XXM in 2020 to $XXM in 2024, representing a XX% CAGR. This growth was driven by..."
  9. Insert chart: task4_charts/chart_02_revenue_growth_trajectory.png (6 inches wide)
  1. Create Table: Full Income Statement
  2. Add heading: 'Historical Income Statement' (level 3)
  3. Use XLSX skill to extract entire Income Statement tab (40-50 rows)
  4. Create Word table with all columns (historical years 2020A-2024A + projected 2025E-2029E)
  5. Include all line items: Revenue, COGS, Gross Profit, Operating Expenses, EBITDA, Net Income, etc.
  1. Add mandatory charts and tables for Revenue breakdown:
  2. Insert chart: task4_charts/chart_03_revenue_by_product.png (6.5 inches wide) ⭐ MANDATORY
  3. Create Table: Revenue by Product (20-30 rows)
  4. Use XLSX skill to extract from Revenue Model tab (product section, typically rows 5-35)
  5. Create Word table showing each product category with historical and projected years
  6. Include columns: Product name, historical years, projected years, % of Total, YoY Growth
  • Insert chart: task4_charts/chart_04_revenue_by_geography.png (6.5 inches wide) ⭐ MANDATORY
  • Create Table: Revenue by Geography (15-20 rows)
  • Use XLSX skill to extract from Revenue Model tab (geography section, typically rows 40-60)
  • Create Word table showing each geographic region with historical and projected years
  1. Add additional financial charts:
  2. Insert chart: task4_charts/chart_10_gross_margin_evolution.png (6 inches wide)
  3. Insert chart: task4_charts/chart_11_ebitda_margin_progression.png (6 inches wide)
  4. Insert chart: task4_charts/chart_12_free_cash_flow_trend.png (6 inches wide)
  1. Projection Assumptions (2,000-3,000 words) ⭐ CRITICAL - NEW WRITING
  2. Add heading: 'Projection Assumptions' (level 2)
  3. Use XLSX skill to read Scenarios tab to inform assumptions
  4. Use XLSX skill to read Revenue Model tab for specific product/geography projections
  5. Add heading: 'Revenue Assumptions by Product' (level 3)
  6. Write detailed product-by-product assumptions (8-12 points per major product)
  7. Write detailed region-by-region assumptions (6-8 points per major region)
  8. Include margin, opex, capex, working capital assumptions
  9. Total: 2,000-3,000 words of specific, quantified assumptions
  1. Scenario Analysis (1,500-2,000 words) ⭐ CRITICAL - NEW WRITING
  2. Add heading: 'Scenario Analysis' (level 2)
  3. Use XLSX skill to extract scenario data from Scenarios tab
  4. Extract Bull/Base/Bear parameters for key metrics (2029E Revenue, EBITDA Margin, etc.)
  5. Write Bull Case (500-700 words): specific parameters, catalysts, probability, valuation
  6. Write Base Case (300-500 words): most likely scenario with rationale
  7. Write Bear Case (500-700 words): downside triggers, parameters, probability, valuation
  8. Write Scenario Comparison (200-300 words)
  9. Insert chart: task4_charts/chart_14_scenario_comparison.png (6 inches wide)
  10. Create Table: Scenario Comparison
  11. Use XLSX skill to extract from Scenarios tab
  12. Create Word table with Bull/Base/Bear columns and key metrics as rows
  1. Growth Drivers (800-1,200 words) - NEW WRITING
  2. Add heading: 'Key Growth Drivers' (level 2)
  3. Write 3-5 key drivers with specific quantified opportunities
  4. Include timelines and milestones
  5. Reference specific data from financial model

Result after Phase C: Pages 18-30 complete (~13 pages, 5-7K words, 7-8 charts, 6-8 tables)

Key Point: Use XLSX skill to READ data from Task 2's Excel file, use the data to inform NEW analytical writing, and use DOCX skill to create Word tables from Excel data.

Phase D: Add Valuation Analysis from Task 3

Mix of copying Task 3 analysis + inserting data from Excel

Use Claude's DOCX and XLSX skills to:

SECTION 4: Valuation Analysis (Pages 31-40)

  1. Add section heading: 'Valuation Analysis' (level 1)
  1. Read Task 3 markdown file
  2. Use Read tool: [Company]_Valuation_Analysis_[Date].md
  3. Identify sections by markdown headers: DCF Analysis, Comparable Companies, Price Target
  1. DCF Analysis section
  2. Add heading: 'DCF Analysis' (level 2)
  3. Extract 'DCF Analysis' section from Task 3 markdown
  4. Convert markdown to Word paragraphs
  5. Insert chart: task4_charts/chart_28_dcf_sensitivity_heatmap.png (6 inches wide) ⭐ MANDATORY
  • Create Table: DCF Key Assumptions
  • Add heading: 'DCF Key Assumptions' (level 3)
  • Use XLSX skill to open [Company]_Financial_Model_[Date].xlsx
  • Read DCF tab (columns A-C, first 20 rows: Assumption, Value, Source)
  • Create Word table from extracted data
  • Create Table: DCF Sensitivity Matrix
  • Use XLSX skill to read Sensitivity Analysis tab
  • Extract full sensitivity matrix (WACC values as rows, terminal growth as columns)
  • Create Word table showing valuation at different parameter combinations
  • Insert chart: task4_charts/chart_29_dcf_waterfall.png (6 inches wide)
  1. Comparable Companies section
  2. Add heading: 'Comparable Companies Analysis' (level 2)
  3. Extract 'Comparable Companies' section from Task 3 markdown
  4. Convert markdown to Word paragraphs
  • Create Table: Comparable Companies ⭐ CRITICAL
  • Add heading: 'Comparable Companies' (level 3)
  • Use XLSX skill to read Comparable Companies tab
  • Extract full table including:
  • 5-10 peer companies plus target company
  • Statistical summary rows (Maximum, 75th Percentile, Median, 25th Percentile, Minimum)
  • Create Word table with all columns: Ticker, Market Cap, EV/Revenue (LTM & NTM), EV/EBITDA (LTM & NTM), P/E (NTM), Revenue Growth, EBITDA Margin
  • Verify statistical summary is included in table
  • Insert chart: task4_charts/chart_31_peer_multiples_comparison.png (6 inches wide)
  1. Valuation Summary
  2. Insert chart: task4_charts/chart_32_valuation_football_field.png (6.5 inches wide) ⭐ MANDATORY
  • Create Table: Valuation Summary
  • Use XLSX skill to read Valuation Summary tab
  • Extract valuation methods (DCF, Comps, Precedent Transactions if applicable)
  • Create Word table showing: Method, Low Case, Base Case, High Case, Weight, Weighted Value
  1. Price Target & Recommendation
  2. Add heading: 'Price Target and Recommendation' (level 2)
  3. Extract 'Price Target' section from Task 3 markdown
  4. Convert markdown to Word paragraphs
  5. Should include: Final recommendation (BUY/HOLD/SELL), price target with % upside, key catalysts, key risks

Result after Phase D: Pages 31-40 complete (~10 pages, 3-4K words, 5-6 charts, 4-5 tables)

Key Point: Use Read tool for Task 3's .md file to get written analysis, and use XLSX skill to READ from Task 3's Excel tabs (which were added to Task 2's model file) to create quantitative tables.

Phase E: Add Appendices & Finalize

Use Claude's DOCX skill to:

SECTION 5: Appendices (Pages 41-50)

  1. Data Sources & References
  2. Add heading: 'Data Sources & References' (level 1)
  3. List all sources used throughout the report
  4. Organize by category:
  5. SEC Filings (10-K, 10-Q, DEF 14A, 8-K with EDGAR links)
  6. Earnings Calls (with transcript links)
  7. Company Materials (investor presentations, press releases)
  8. Industry Reports (Gartner, Forrester, etc.)
  9. News Articles
  10. CRITICAL: All URLs must be clickable hyperlinks (not plain text)
  11. Include dates for all sources
  1. Additional Tables
  2. Add heading: 'Additional Tables' (level 1)
  3. Add extended financial projections
  4. Add detailed assumptions tables
  5. Add any supporting tables that didn't fit in main sections

Phase F: Write Page 1 Investment Summary

NOW write Page 1 - after all analysis complete

  • INITIATING COVERAGE header
  • Rating box
  • 3-4 detailed bullets synthesizing entire report
  • Financial summary table
  • Stock price chart

Phase G: Add Table of Contents & Page Numbers

  • Auto-generate TOC
  • Add page numbers to all pages

Key formatting requirements:

  • Professional fonts (Calibri, Arial, or similar)
  • Proper headers and footers with page numbers
  • Section breaks between major sections
  • Embed all 25-35 charts inline throughout text
  • Insert all 12-20 tables inline with text
  • All URLs as clickable hyperlinks (NOT plain text)
  • 60-80% page density - Every page has text AND visuals

Visual Density Strategy:

Good page layout example:
┌─────────────────────────────┐
│ Section Header              │
│ Text paragraph (200 words)  │
│ [Chart embedded]            │
│ Text paragraph (200 words)  │
│ [Table embedded]            │
│ Text paragraph (200 words)  │
│ [Chart embedded]            │
└─────────────────────────────┘

BAD - Avoid:
- Full page with only one chart
- Multiple pages of pure text
- Charts grouped at end of sections

Result: 30-50 page report that is text-dense with illustrating images throughout


Raw lines 744 to 1047
1048## File Operations Summary
1050**Throughout the entire assembly process, use Claude's DOCX and XLSX skills with actual file operations:**
1052**Reading Input Files:**
1053- ✓ Use Read tool: `[Company]_Research_Document_[Date].md` - Read Task 1 research
1054- ✓ Use XLSX skill: Open `[Company]_Financial_Model_[Date].xlsx` and read tabs - Extract tables from Task 2/3
1055- ✓ Use Read tool: `[Company]_Valuation_Analysis_[Date].md` - Read Task 3 analysis
1056- ✓ Use DOCX skill: Insert images from `task4_charts/chart_XX.png` files
1058**Writing Output File:**
1059- ✓ Use DOCX skill: Create new Word document
1060- ✓ Use DOCX skill: Add paragraphs (text from input .md files)
1061- ✓ Use DOCX skill: Create tables (data from Excel files read via XLSX skill)
1062- ✓ Use DOCX skill: Insert images (chart .png files)
1063- ✓ Use DOCX skill: Save final file as `[Company]_Initiation_Report_[Date].docx`
1065**Do NOT manually copy/paste. Use Claude's built-in skills to:**
10661. Read from .md files (Task 1, Task 3) using Read tool
10672. Read from .xlsx files (Task 2 with Task 3 tabs) using XLSX skill
10683. Read from .png files (Task 4) as image files
10694. Write to .docx file (Task 5 output) using DOCX skill
1071This approach is efficient, reproducible, and ensures all data flows correctly from source files to final report.

File Operations Summary

Throughout the entire assembly process, use Claude's DOCX and XLSX skills with actual file operations:

Reading Input Files:

  • ✓ Use Read tool: [Company]_Research_Document_[Date].md - Read Task 1 research
  • ✓ Use XLSX skill: Open [Company]_Financial_Model_[Date].xlsx and read tabs - Extract tables from Task 2/3
  • ✓ Use Read tool: [Company]_Valuation_Analysis_[Date].md - Read Task 3 analysis
  • ✓ Use DOCX skill: Insert images from task4_charts/chart_XX.png files

Writing Output File:

  • ✓ Use DOCX skill: Create new Word document
  • ✓ Use DOCX skill: Add paragraphs (text from input .md files)
  • ✓ Use DOCX skill: Create tables (data from Excel files read via XLSX skill)
  • ✓ Use DOCX skill: Insert images (chart .png files)
  • ✓ Use DOCX skill: Save final file as [Company]_Initiation_Report_[Date].docx

Do NOT manually copy/paste. Use Claude's built-in skills to:

  1. Read from .md files (Task 1, Task 3) using Read tool
  2. Read from .xlsx files (Task 2 with Task 3 tabs) using XLSX skill
  3. Read from .png files (Task 4) as image files
  4. Write to .docx file (Task 5 output) using DOCX skill

This approach is efficient, reproducible, and ensures all data flows correctly from source files to final report.

Raw lines 1048 to 1072
1073### Step 7: Quality Check
1075**Run comprehensive verification:**
1077```
1078═══════════════════════════════════════════════════════════
1079REPORT QUALITY CHECKLIST
1080═══════════════════════════════════════════════════════════
1082LENGTH REQUIREMENTS:
1083- [ ] Report is 30-50 pages (count: ____ pages)
1084- [ ] Word count is 10,000-15,000 (count: ____ words)
1085- [ ] 25-35 charts embedded (count: ____ charts)
1086- [ ] 12-20 tables included (count: ____ tables)
1088PAGE 1 FORMAT:
1089- [ ] "INITIATING COVERAGE" header present
1090- [ ] Thesis-focused title (not generic)
1091- [ ] Rating box complete with all elements
1092- [ ] Stock price chart (Figure 1) embedded
1093- [ ] 3-4 detailed bullets with ■ character
1094- [ ] Each bullet has **bold header** + 3-5 sentences
1095- [ ] Financial summary table included
1096- [ ] Years noted as "A" (actual) and "E" (estimate)
1098SECTION WORD COUNTS:
1099- [ ] Investment Thesis: 800-1,200 words ✓
1100- [ ] Risk Assessment: 600-900 words ✓
1101- [ ] Company Description: 800-1,200 words ✓
1102- [ ] Management Bios: 1,000-1,400 words (300-400 per exec for 3-4 execs) ✓
1103- [ ] Products & Services: 700-1,000 words ✓
1104- [ ] Financial Analysis: 1,200-1,800 words ✓
1105- [ ] **Projection Assumptions: 2,000-3,000 words ✓** ⭐ CRITICAL
1106- [ ] **Scenario Analysis: 1,500-2,000 words ✓** ⭐ CRITICAL
1107- [ ] Growth Drivers: 800-1,200 words ✓
1108- [ ] Valuation Methodology: 800-1,200 words ✓
1110MANDATORY CHARTS (4 TOTAL):
1111- [ ] Revenue by Product (stacked area) embedded ⭐
1112- [ ] Revenue by Geography (stacked bar) embedded ⭐
1113- [ ] DCF Sensitivity (heatmap) embedded ⭐
1114- [ ] Valuation Football Field embedded ⭐
1116MANDATORY TABLES:
1117- [ ] Page 1 financial summary table
1118- [ ] Full income statement (40-50 line items)
1119- [ ] Revenue by product table (20-30 rows)
1120- [ ] Revenue by geography table (15-20 rows)
1121- [ ] Comparable companies table with statistical summary ⭐
1122- [ ] DCF assumptions table
1123- [ ] Scenario comparison table
1124- [ ] Additional 5-13 tables
1126CITATIONS & HYPERLINKS:
1127- [ ] All figures have source lines
1128- [ ] All tables have source lines
1129- [ ] All URLs are clickable hyperlinks (NOT plain text)
1130- [ ] Test 5-10 random hyperlinks to verify they work
1131- [ ] Data Sources & References page included
1132- [ ] All sources have dates
1134DATA ACCURACY:
1135- [ ] All numbers match financial model exactly
1136- [ ] Revenue figures consistent across all tables/text
1137- [ ] Price target matches valuation analysis
1138- [ ] All growth rates calculated correctly
1139- [ ] All percentages sum to 100% where applicable
1141CONTENT REUSE (CRITICAL):
1142- [ ] Task 1 content used almost verbatim (not rewritten)
1143- [ ] Company 101 sections (pages 6-17) copied from Task 1 with only formatting changes
1144- [ ] Writing effort focused on quantitative sections (financial analysis, projections, scenarios)
1146VISUAL DENSITY (CRITICAL):
1147- [ ] Every page has BOTH text AND visuals (not pure text pages)
1148- [ ] Charts interspersed throughout (not grouped at end)
1149- [ ] Average 1+ chart per page (30-50 pages = 25-35+ charts)
1150- [ ] Charts appear every 200-300 words of text
1151- [ ] 60-80% page density achieved across entire report
1153FORMATTING:
1154- [ ] No markdown syntax visible (no #, ##, **, etc.)
1155- [ ] Professional fonts throughout
1156- [ ] Headers and footers present
1157- [ ] Page numbers present
1158- [ ] Section breaks appropriate
1159- [ ] Charts embedded (not just file paths)
1160- [ ] Tables formatted professionally
1162WRITING QUALITY:
1163- [ ] Lead with numbers (not generic statements)
1164- [ ] Use "vs." not "versus"
1165- [ ] Quantify everything
1166- [ ] Professional tone throughout
1167- [ ] No typos or grammatical errors
1168- [ ] Specific examples (not vague statements)
1170═══════════════════════════════════════════════════════════
1171FINAL VERIFICATION
1172═══════════════════════════════════════════════════════════
1174IF ALL ITEMS CHECKED: ✓ READY FOR DELIVERY
1176IF ANY ITEMS UNCHECKED: ✗ FIX BEFORE DELIVERY
1178═══════════════════════════════════════════════════════════
1179```
1181**IF ANY ITEM FAILS, DO NOT DELIVER. Fix before proceeding.**
1183---

Step 7: Quality Check

Run comprehensive verification:

═══════════════════════════════════════════════════════════
REPORT QUALITY CHECKLIST
═══════════════════════════════════════════════════════════

LENGTH REQUIREMENTS:
- [ ] Report is 30-50 pages (count: ____ pages)
- [ ] Word count is 10,000-15,000 (count: ____ words)
- [ ] 25-35 charts embedded (count: ____ charts)
- [ ] 12-20 tables included (count: ____ tables)

PAGE 1 FORMAT:
- [ ] "INITIATING COVERAGE" header present
- [ ] Thesis-focused title (not generic)
- [ ] Rating box complete with all elements
- [ ] Stock price chart (Figure 1) embedded
- [ ] 3-4 detailed bullets with ■ character
- [ ] Each bullet has **bold header** + 3-5 sentences
- [ ] Financial summary table included
- [ ] Years noted as "A" (actual) and "E" (estimate)

SECTION WORD COUNTS:
- [ ] Investment Thesis: 800-1,200 words ✓
- [ ] Risk Assessment: 600-900 words ✓
- [ ] Company Description: 800-1,200 words ✓
- [ ] Management Bios: 1,000-1,400 words (300-400 per exec for 3-4 execs) ✓
- [ ] Products & Services: 700-1,000 words ✓
- [ ] Financial Analysis: 1,200-1,800 words ✓
- [ ] **Projection Assumptions: 2,000-3,000 words ✓** ⭐ CRITICAL
- [ ] **Scenario Analysis: 1,500-2,000 words ✓** ⭐ CRITICAL
- [ ] Growth Drivers: 800-1,200 words ✓
- [ ] Valuation Methodology: 800-1,200 words ✓

MANDATORY CHARTS (4 TOTAL):
- [ ] Revenue by Product (stacked area) embedded ⭐
- [ ] Revenue by Geography (stacked bar) embedded ⭐
- [ ] DCF Sensitivity (heatmap) embedded ⭐
- [ ] Valuation Football Field embedded ⭐

MANDATORY TABLES:
- [ ] Page 1 financial summary table
- [ ] Full income statement (40-50 line items)
- [ ] Revenue by product table (20-30 rows)
- [ ] Revenue by geography table (15-20 rows)
- [ ] Comparable companies table with statistical summary ⭐
- [ ] DCF assumptions table
- [ ] Scenario comparison table
- [ ] Additional 5-13 tables

CITATIONS & HYPERLINKS:
- [ ] All figures have source lines
- [ ] All tables have source lines
- [ ] All URLs are clickable hyperlinks (NOT plain text)
- [ ] Test 5-10 random hyperlinks to verify they work
- [ ] Data Sources & References page included
- [ ] All sources have dates

DATA ACCURACY:
- [ ] All numbers match financial model exactly
- [ ] Revenue figures consistent across all tables/text
- [ ] Price target matches valuation analysis
- [ ] All growth rates calculated correctly
- [ ] All percentages sum to 100% where applicable

CONTENT REUSE (CRITICAL):
- [ ] Task 1 content used almost verbatim (not rewritten)
- [ ] Company 101 sections (pages 6-17) copied from Task 1 with only formatting changes
- [ ] Writing effort focused on quantitative sections (financial analysis, projections, scenarios)

VISUAL DENSITY (CRITICAL):
- [ ] Every page has BOTH text AND visuals (not pure text pages)
- [ ] Charts interspersed throughout (not grouped at end)
- [ ] Average 1+ chart per page (30-50 pages = 25-35+ charts)
- [ ] Charts appear every 200-300 words of text
- [ ] 60-80% page density achieved across entire report

FORMATTING:
- [ ] No markdown syntax visible (no #, ##, **, etc.)
- [ ] Professional fonts throughout
- [ ] Headers and footers present
- [ ] Page numbers present
- [ ] Section breaks appropriate
- [ ] Charts embedded (not just file paths)
- [ ] Tables formatted professionally

WRITING QUALITY:
- [ ] Lead with numbers (not generic statements)
- [ ] Use "vs." not "versus"
- [ ] Quantify everything
- [ ] Professional tone throughout
- [ ] No typos or grammatical errors
- [ ] Specific examples (not vague statements)

═══════════════════════════════════════════════════════════
FINAL VERIFICATION
═══════════════════════════════════════════════════════════

IF ALL ITEMS CHECKED: ✓ READY FOR DELIVERY

IF ANY ITEMS UNCHECKED: ✗ FIX BEFORE DELIVERY

═══════════════════════════════════════════════════════════

IF ANY ITEM FAILS, DO NOT DELIVER. Fix before proceeding.


Raw lines 1073 to 1184
1185## Writing Style Guidelines

Writing Style Guidelines

Raw lines 1185 to 1186
1187### Lead with Numbers (CRITICAL)
1189✓ **CORRECT**: "Revenue increased 150% YoY to $250M in Q4 2024, driven by..."
1190✗ **INCORRECT**: "The company saw strong revenue growth this quarter..."
1192✓ **CORRECT**: "EBITDA margin expanded 500bps to 30% vs. 25% in FY2023"
1193✗ **INCORRECT**: "EBITDA margin expanded versus the prior year"
1195✓ **CORRECT**: "Market share increased 3 percentage points to 18% vs. 15% in 2023"
1196✗ **INCORRECT**: "Market share increased compared to last year"
1198✓ **CORRECT**: "Management expects 40-50% revenue growth in FY2025E"
1199✗ **INCORRECT**: "Management expects strong revenue growth"

Lead with Numbers (CRITICAL)

✓ CORRECT: "Revenue increased 150% YoY to $250M in Q4 2024, driven by..." ✗ INCORRECT: "The company saw strong revenue growth this quarter..."

✓ CORRECT: "EBITDA margin expanded 500bps to 30% vs. 25% in FY2023" ✗ INCORRECT: "EBITDA margin expanded versus the prior year"

✓ CORRECT: "Market share increased 3 percentage points to 18% vs. 15% in 2023" ✗ INCORRECT: "Market share increased compared to last year"

✓ CORRECT: "Management expects 40-50% revenue growth in FY2025E" ✗ INCORRECT: "Management expects strong revenue growth"

Raw lines 1187 to 1200
1201### Professional Writing Standards
1203- **Front-load**: Most important information first
1204- **Data-driven**: Lead with numbers and metrics
1205- **Specific**: Concrete examples, not generic statements
1206- **Objective**: Present facts, acknowledge risks
1207- **Confident**: State views clearly with supporting evidence
1208- **Active voice**: "We estimate revenue will reach $500M"
1209- **Precise**: Avoid "might", "could", "possibly"

Professional Writing Standards

  • Front-load: Most important information first
  • Data-driven: Lead with numbers and metrics
  • Specific: Concrete examples, not generic statements
  • Objective: Present facts, acknowledge risks
  • Confident: State views clearly with supporting evidence
  • Active voice: "We estimate revenue will reach $500M"
  • Precise: Avoid "might", "could", "possibly"
Raw lines 1201 to 1210
1211### Number Formatting
1213**Consistency:**
1214- Billions: $X.XB (e.g., "$2.5B")
1215- Millions: $XXXM (e.g., "$250M")
1216- Always specify: YoY, QoQ, CAGR
1217- Basis points for small margin changes: "500bps"
1218- Year format: "2024A" (actual), "2025E" (estimate)

Number Formatting

Consistency:

  • Billions: $X.XB (e.g., "$2.5B")
  • Millions: $XXXM (e.g., "$250M")
  • Always specify: YoY, QoQ, CAGR
  • Basis points for small margin changes: "500bps"
  • Year format: "2024A" (actual), "2025E" (estimate)
Raw lines 1211 to 1219
1220### Use "vs." not "versus"
1221✓ **CORRECT**: "Gross margin of 65% vs. 60% in prior year"
1222✗ **INCORRECT**: "Gross margin of 65% versus 60%"
1224---

Use "vs." not "versus"

✓ CORRECT: "Gross margin of 65% vs. 60% in prior year" ✗ INCORRECT: "Gross margin of 65% versus 60%"


Raw lines 1220 to 1225
1226## Common Pitfalls to Avoid
1228**⚠️ MOST COMMON MISTAKE: TAKING SHORTCUTS DUE TO LENGTH**
1230Many reports fail because they use placeholders like "details would be included here" or "see model for data" instead of actually writing/extracting the content. **DO NOT DO THIS.** Write every section in full. Extract every table. Embed every chart. Use whatever tokens are needed.
12321. **Rewriting Task 1 content**: DO NOT rewrite the 6-8K words from Task 1. Use almost verbatim - just reformat and add charts. Focus writing effort on quantitative sections (projections, scenarios, valuation).
12332. **Sparse pages**: Every page must have BOTH text AND visuals. Target 60-80% page density. Insert charts every 200-300 words.
12343. **Grouping charts at end**: Charts must be interspersed throughout text, not grouped. Place chart immediately after paragraph discussing that topic.
12354. **Writing in markdown**: Use DOCX format, NOT markdown
12365. **Skipping Page 1 format**: Must follow exact institutional format
12376. **Generic bullets**: Page 1 bullets need bold headers + specific data
12387. **Short sections**: Must meet minimum word counts
12398. **Thin assumptions**: Projection Assumptions MUST be 2,000-3,000 words with product-by-product and region-by-region detail
12409. **Vague scenarios**: Must have specific parameters for Bull/Base/Bear
124110. **Plain text URLs**: All citations must be clickable hyperlinks
124211. **Missing statistical summary**: Comps table must have max/75th/median/25th/min
124312. **Charts not embedded**: All 25-35 charts must be IN document, not just referenced
124413. **Numbers don't match model**: Verify all figures against source
124514. **Skipping verification**: Quality check is NOT optional
1247---

Common Pitfalls to Avoid

⚠️ MOST COMMON MISTAKE: TAKING SHORTCUTS DUE TO LENGTH

Many reports fail because they use placeholders like "details would be included here" or "see model for data" instead of actually writing/extracting the content. DO NOT DO THIS. Write every section in full. Extract every table. Embed every chart. Use whatever tokens are needed.

  1. Rewriting Task 1 content: DO NOT rewrite the 6-8K words from Task 1. Use almost verbatim - just reformat and add charts. Focus writing effort on quantitative sections (projections, scenarios, valuation).
  2. Sparse pages: Every page must have BOTH text AND visuals. Target 60-80% page density. Insert charts every 200-300 words.
  3. Grouping charts at end: Charts must be interspersed throughout text, not grouped. Place chart immediately after paragraph discussing that topic.
  4. Writing in markdown: Use DOCX format, NOT markdown
  5. Skipping Page 1 format: Must follow exact institutional format
  6. Generic bullets: Page 1 bullets need bold headers + specific data
  7. Short sections: Must meet minimum word counts
  8. Thin assumptions: Projection Assumptions MUST be 2,000-3,000 words with product-by-product and region-by-region detail
  9. Vague scenarios: Must have specific parameters for Bull/Base/Bear
  10. Plain text URLs: All citations must be clickable hyperlinks
  11. Missing statistical summary: Comps table must have max/75th/median/25th/min
  12. Charts not embedded: All 25-35 charts must be IN document, not just referenced
  13. Numbers don't match model: Verify all figures against source
  14. Skipping verification: Quality check is NOT optional

Raw lines 1226 to 1248
1249## Success Criteria
1251A successful equity research report should:
12531. **Meet all length requirements**
1254 - 30-50 pages (MINIMUM 30)
1255 - 10,000-15,000 words (MINIMUM 10,000)
1256 - 25-35 charts embedded
1257 - 12-20 tables included
12592. **Have properly formatted Page 1**
1260 - "INITIATING COVERAGE" header
1261 - Rating box, analyst info, chart, bullets, table
12633. **Meet all section word count minimums**
1264 - Especially Projection Assumptions (2,000-3,000) ⭐
1265 - And Scenario Analysis (1,500-2,000) ⭐
12674. **Include all 4 mandatory charts**
1268 - Revenue by product (stacked area) ⭐
1269 - Revenue by geography (stacked bar) ⭐
1270 - DCF sensitivity (heatmap) ⭐
1271 - Valuation football field ⭐
12735. **Have management bios**
1274 - 300-400 words each for 3-4 key executives
12766. **Include comprehensive comps table**
1277 - With statistical summary (max/75th/median/25th/min)
12797. **Have all citations as clickable hyperlinks**
1280 - Test multiple links to verify they work
12828. **Be professionally formatted**
1283 - 60-80% page density
1284 - No markdown syntax visible
1285 - Charts and tables embedded properly
12879. **Have numbers matching model exactly**
1288 - Verify all figures against Excel model
129010. **Enable informed investment decision**
1291 - Client should understand company, valuation, risks
1292 - Should be indistinguishable from JPM/GS/MS research
1294---

Success Criteria

A successful equity research report should:

  1. Meet all length requirements
  2. 30-50 pages (MINIMUM 30)
  3. 10,000-15,000 words (MINIMUM 10,000)
  4. 25-35 charts embedded
  5. 12-20 tables included
  1. Have properly formatted Page 1
  2. "INITIATING COVERAGE" header
  3. Rating box, analyst info, chart, bullets, table
  1. Meet all section word count minimums
  2. Especially Projection Assumptions (2,000-3,000) ⭐
  3. And Scenario Analysis (1,500-2,000) ⭐
  1. Include all 4 mandatory charts
  2. Revenue by product (stacked area) ⭐
  3. Revenue by geography (stacked bar) ⭐
  4. DCF sensitivity (heatmap) ⭐
  5. Valuation football field ⭐
  1. Have management bios
  2. 300-400 words each for 3-4 key executives
  1. Include comprehensive comps table
  2. With statistical summary (max/75th/median/25th/min)
  1. Have all citations as clickable hyperlinks
  2. Test multiple links to verify they work
  1. Be professionally formatted
  2. 60-80% page density
  3. No markdown syntax visible
  4. Charts and tables embedded properly
  1. Have numbers matching model exactly
  2. Verify all figures against Excel model
  1. Enable informed investment decision
  2. Client should understand company, valuation, risks
  3. Should be indistinguishable from JPM/GS/MS research

Raw lines 1249 to 1295
1296## Output Files
1298**Primary Deliverable:**
1299`[Company]_Initiation_Report_[Date].docx`
1301**Example**: `Tesla_Initiation_Report_2024-10-27.docx`
1303**Supporting Deliverable:**
1304`[Company]_Financial_Model_[Date].xlsx` (from Task 2)
1306**Both files should be packaged together for final delivery.**
1308---

Output Files

Primary Deliverable: [Company]_Initiation_Report_[Date].docx

Example: Tesla_Initiation_Report_2024-10-27.docx

Supporting Deliverable: [Company]_Financial_Model_[Date].xlsx (from Task 2)

Both files should be packaged together for final delivery.


Raw lines 1296 to 1309
1310## Final Note
1312This is the culmination of all equity research work from Tasks 1-4. The output should be:
1313- **Comprehensive**: 30-50 pages covering all aspects
1314- **Professional**: Indistinguishable from major investment bank research
1315- **Actionable**: Enables reader to make informed investment decision
1316- **Publication-ready**: Can be delivered directly to clients
1318**Standard**: JPMorgan, Goldman Sachs, Morgan Stanley institutional equity research.
1320**Quality bar**: Client-ready initiation report suitable for publication.
1322---

Final Note

This is the culmination of all equity research work from Tasks 1-4. The output should be:

  • Comprehensive: 30-50 pages covering all aspects
  • Professional: Indistinguishable from major investment bank research
  • Actionable: Enables reader to make informed investment decision
  • Publication-ready: Can be delivered directly to clients

Standard: JPMorgan, Goldman Sachs, Morgan Stanley institutional equity research.

Quality bar: Client-ready initiation report suitable for publication.


Raw lines 1310 to 1323
1324## 🔥 FINAL REMINDER: NO SHORTCUTS, NO COMPROMISES
1326**Use whatever tokens are needed to deliver a complete, professional report.**
1328This is not a draft. This is not a summary. This is not an outline. This is the **FINAL PUBLICATION-READY REPORT**.
1330- Write every section in full (10,000-15,000 words minimum)
1331- Embed every chart (all 25-35 charts throughout)
1332- Extract and include every table (12-20 tables minimum)
1333- Copy all Company 101 content from Task 1 verbatim (6-8K words)
1334- Write detailed projection assumptions (2,000-3,000 words)
1335- Write comprehensive scenario analysis (1,500-2,000 words)
1336- Achieve 30-50 pages minimum with 60-80% page density
1338**If running low on tokens, that's expected and acceptable for this task. Keep going.**
1340This represents the complete professional work product. Deliver institutional-quality research worthy of a $1M+ investment decision.

🔥 FINAL REMINDER: NO SHORTCUTS, NO COMPROMISES

Use whatever tokens are needed to deliver a complete, professional report.

This is not a draft. This is not a summary. This is not an outline. This is the FINAL PUBLICATION-READY REPORT.

  • Write every section in full (10,000-15,000 words minimum)
  • Embed every chart (all 25-35 charts throughout)
  • Extract and include every table (12-20 tables minimum)
  • Copy all Company 101 content from Task 1 verbatim (6-8K words)
  • Write detailed projection assumptions (2,000-3,000 words)
  • Write comprehensive scenario analysis (1,500-2,000 words)
  • Achieve 30-50 pages minimum with 60-80% page density

If running low on tokens, that's expected and acceptable for this task. Keep going.

This represents the complete professional work product. Deliver institutional-quality research worthy of a $1M+ investment decision.

Raw lines 1324 to 1340