Task 5: Report
Assembly - Detailed Workflow
This document provides step-by-step instructions for executing Task 5
(Report Assembly) of the initiating-coverage skill.
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
🔥 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.
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
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.
BEFORE STARTING - ALL TASKS MUST BE COMPLETE:
Task 1 Verification:
Task 2 Verification:
Task 3 Verification:
Task 4 Verification:
IF ANY VERIFICATION FAILS: Stop and complete missing
task first.
Report Specifications
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
Critical Sections with Word
Counts
| Section |
Minimum |
Target |
Critical? |
| Investment Summary (Page 1) |
500 |
700 |
|
| Investment Thesis |
800 |
1,200 |
|
| Risk Factors |
600 |
900 |
|
| Company Description |
800 |
1,200 |
|
| Management Bios |
1,000 |
1,400 |
|
| Products & Services |
700 |
1,000 |
|
| Projection Assumptions |
2,000 |
3,000 |
⭐ YES |
| Scenario Analysis |
1,500 |
2,000 |
⭐ YES |
| Financial Analysis |
1,200 |
1,800 |
|
| Valuation Methodology |
800 |
1,200 |
|
Total: 10,000-15,000 words
Report Structure
Page 1: Investment
Summary (CRITICAL PAGE)
This is the most important page. Must have:
- "INITIATING COVERAGE" header (NOT "Company
Update")
- Thesis-focused title (e.g., "AI Platform Leader
Positioned for 40% CAGR")
- Rating box with:
- Rating (BUY/OUTPERFORM/HOLD/UNDERPERFORM/SELL)
- Current price
- Target price
- 52-week range
- Market cap
- Enterprise value
- Research analyst information with credentials
- Stock price performance chart (Figure 1)
- 3-4 detailed investment bullets with ■ character
- Each bullet has bold topic header + 3-5
sentences
- Lead with key numbers
- Financial summary table (2-3 years historical + 2-3
years projected)
- 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.
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
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
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
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)
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
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)
Step-by-Step Report
Assembly Workflow
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:
- Read Task 1 markdown file - Use Read tool to view
content
- Open Task 2/3 Excel file - Use XLSX skill to
inspect tabs:
- Verify required tabs exist: Revenue Model, Income Statement,
Scenarios, DCF, Sensitivity Analysis, Comparable Companies
- Read Task 3 markdown file - Use Read tool to view
valuation analysis
- 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.
Use Claude's XLSX skill to extract data from Excel
files:
Table 1: Page 1 Summary
Financials
Use XLSX skill to:
- Open
[Company]_Financial_Model_[Date].xlsx
- Read from
Income Statement tab
- Extract key rows: Revenue, Gross Profit, EBITDA, Net Income, EPS,
FCF
- Extract years: 2022A, 2023A, 2024A, 2025E, 2026E, 2027E
- Create summary table with growth rates and margins
Table 2: Full
Income Statement (40-50 line items)
Use XLSX skill to:
- Open
[Company]_Financial_Model_[Date].xlsx
- Read entire
Income Statement tab
- Extract all line items (40-50 rows)
- Extract columns for historical (2020A-2024A) + projected years
(2025E-2029E)
- Include all margins and growth rates
Table 3: Revenue by
Product (20-30 rows)
Use XLSX skill to:
- Open
[Company]_Financial_Model_[Date].xlsx
- Read from
Revenue Model tab
- Navigate to product section (typically starts ~row 5)
- Extract 20-30 rows showing each product category
- Include columns: Product name, historical years, projected years, %
of Total, YoY Growth
Table 4: Revenue by
Geography (15-20 rows)
Use XLSX skill to:
- Open
[Company]_Financial_Model_[Date].xlsx
- Read from
Revenue Model tab
- Navigate to geography section (typically starts ~row 40)
- Extract 15-20 rows showing each geographic region
- 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:
- Open
[Company]_Financial_Model_[Date].xlsx
- Read from
Comparable Companies tab (added by Task
3)
- Extract full table with company names as row headers
- CRITICAL: Verify statistical summary rows are
present at bottom:
- Maximum
- 75th Percentile
- Median
- 25th Percentile
- Minimum
- 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.
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
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
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:
- Reformat for Word - Convert markdown to DOCX
formatting
- Insert charts inline - Add relevant charts from
Task 4 throughout the text
- 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)
Step 6: Assemble DOCX Report
CRITICAL: Create actual DOCX file, NOT markdown.
Assembly Order (Most Efficient):
Phase A: Create Structure
& Add Page 1
- Create DOCX document
- Set up professional styling (fonts, headers, footers)
- Create Page 1 - Investment Summary (write this LAST after all
analysis complete)
- 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:
Initialize new DOCX document
- Create new Word document
- Set professional styling (fonts, margins)
Read Task 1 markdown file
- Use Read tool:
[Company]_Research_Document_[Date].md
- Identify sections by markdown headers (## Section Title)
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)
Add section heading: 'Financial Analysis' (level
1)
Historical Financial Analysis (1,200-1,800 words) - NEW
WRITING
- Add heading: 'Historical Performance' (level 2)
- Use XLSX skill to open
[Company]_Financial_Model_[Date].xlsx
- Read
Income Statement tab to extract historical
data
- Read
Revenue Model tab to extract revenue trends
- Calculate key metrics (e.g., Revenue CAGR from 2020-2024)
- Write analytical paragraphs interpreting the trends (1,200-1,800
words)
- Lead with specific numbers: "Revenue grew from $XXM in 2020 to $XXM
in 2024, representing a XX% CAGR. This growth was driven by..."
- Insert chart:
task4_charts/chart_02_revenue_growth_trajectory.png (6
inches wide)
Create Table: Full Income Statement
- Add heading: 'Historical Income Statement' (level 3)
- Use XLSX skill to extract entire Income Statement tab (40-50
rows)
- Create Word table with all columns (historical years 2020A-2024A +
projected 2025E-2029E)
- Include all line items: Revenue, COGS, Gross Profit, Operating
Expenses, EBITDA, Net Income, etc.
Add mandatory charts and tables for Revenue
breakdown:
Insert chart:
task4_charts/chart_03_revenue_by_product.png (6.5 inches
wide) ⭐ MANDATORY
Create Table: Revenue by Product (20-30
rows)
- Use XLSX skill to extract from Revenue Model tab (product section,
typically rows 5-35)
- Create Word table showing each product category with historical and
projected years
- 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
Add additional financial charts:
- Insert chart:
task4_charts/chart_10_gross_margin_evolution.png (6 inches
wide)
- Insert chart:
task4_charts/chart_11_ebitda_margin_progression.png (6
inches wide)
- Insert chart:
task4_charts/chart_12_free_cash_flow_trend.png (6 inches
wide)
Projection Assumptions (2,000-3,000 words) ⭐ CRITICAL -
NEW WRITING
- Add heading: 'Projection Assumptions' (level 2)
- Use XLSX skill to read Scenarios tab to inform assumptions
- Use XLSX skill to read Revenue Model tab for specific
product/geography projections
- Add heading: 'Revenue Assumptions by Product' (level 3)
- Write detailed product-by-product assumptions (8-12 points per major
product)
- Write detailed region-by-region assumptions (6-8 points per major
region)
- Include margin, opex, capex, working capital assumptions
- Total: 2,000-3,000 words of specific, quantified
assumptions
Scenario Analysis (1,500-2,000 words) ⭐ CRITICAL - NEW
WRITING
- Add heading: 'Scenario Analysis' (level 2)
- Use XLSX skill to extract scenario data from Scenarios tab
- Extract Bull/Base/Bear parameters for key metrics (2029E Revenue,
EBITDA Margin, etc.)
- Write Bull Case (500-700 words): specific parameters, catalysts,
probability, valuation
- Write Base Case (300-500 words): most likely scenario with
rationale
- Write Bear Case (500-700 words): downside triggers, parameters,
probability, valuation
- Write Scenario Comparison (200-300 words)
- Insert chart:
task4_charts/chart_14_scenario_comparison.png (6 inches
wide)
- Create Table: Scenario Comparison
- Use XLSX skill to extract from Scenarios tab
- Create Word table with Bull/Base/Bear columns and key metrics as
rows
Growth Drivers (800-1,200 words) - NEW
WRITING
- Add heading: 'Key Growth Drivers' (level 2)
- Write 3-5 key drivers with specific quantified opportunities
- Include timelines and milestones
- 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)
Add section heading: 'Valuation Analysis' (level
1)
Read Task 3 markdown file
- Use Read tool:
[Company]_Valuation_Analysis_[Date].md
- Identify sections by markdown headers: DCF Analysis, Comparable
Companies, Price Target
DCF Analysis section
Add heading: 'DCF Analysis' (level 2)
Extract 'DCF Analysis' section from Task 3 markdown
Convert markdown to Word paragraphs
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)
Comparable Companies section
Add heading: 'Comparable Companies Analysis' (level 2)
Extract 'Comparable Companies' section from Task 3
markdown
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)
Valuation Summary
Price Target & Recommendation
- Add heading: 'Price Target and Recommendation' (level 2)
- Extract 'Price Target' section from Task 3 markdown
- Convert markdown to Word paragraphs
- 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)
Data Sources & References
- Add heading: 'Data Sources & References' (level 1)
- List all sources used throughout the report
- Organize by category:
- SEC Filings (10-K, 10-Q, DEF 14A, 8-K with EDGAR links)
- Earnings Calls (with transcript links)
- Company Materials (investor presentations, press releases)
- Industry Reports (Gartner, Forrester, etc.)
- News Articles
- CRITICAL: All URLs must be clickable hyperlinks
(not plain text)
- Include dates for all sources
Additional Tables
- Add heading: 'Additional Tables' (level 1)
- Add extended financial projections
- Add detailed assumptions tables
- 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
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:
- Read from .md files (Task 1, Task 3) using Read tool
- Read from .xlsx files (Task 2 with Task 3 tabs) using XLSX
skill
- Read from .png files (Task 4) as image files
- 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.
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.
Writing Style Guidelines
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"
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"
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)
Use "vs." not "versus"
✓ CORRECT: "Gross margin of 65% vs. 60% in prior
year" ✗ INCORRECT: "Gross margin of 65% versus 60%"
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.
- 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).
- Sparse pages: Every page must have BOTH text AND
visuals. Target 60-80% page density. Insert charts every 200-300
words.
- Grouping charts at end: Charts must be interspersed
throughout text, not grouped. Place chart immediately after paragraph
discussing that topic.
- Writing in markdown: Use DOCX format, NOT
markdown
- Skipping Page 1 format: Must follow exact
institutional format
- Generic bullets: Page 1 bullets need bold headers +
specific data
- Short sections: Must meet minimum word counts
- Thin assumptions: Projection Assumptions MUST be
2,000-3,000 words with product-by-product and region-by-region
detail
- Vague scenarios: Must have specific parameters for
Bull/Base/Bear
- Plain text URLs: All citations must be clickable
hyperlinks
- Missing statistical summary: Comps table must have
max/75th/median/25th/min
- Charts not embedded: All 25-35 charts must be IN
document, not just referenced
- Numbers don't match model: Verify all figures
against source
- Skipping verification: Quality check is NOT
optional
Success Criteria
A successful equity research report should:
Meet all length requirements
- 30-50 pages (MINIMUM 30)
- 10,000-15,000 words (MINIMUM 10,000)
- 25-35 charts embedded
- 12-20 tables included
Have properly formatted Page 1
- "INITIATING COVERAGE" header
- Rating box, analyst info, chart, bullets, table
Meet all section word count minimums
- Especially Projection Assumptions (2,000-3,000) ⭐
- And Scenario Analysis (1,500-2,000) ⭐
Include all 4 mandatory charts
- Revenue by product (stacked area) ⭐
- Revenue by geography (stacked bar) ⭐
- DCF sensitivity (heatmap) ⭐
- Valuation football field ⭐
Have management bios
- 300-400 words each for 3-4 key executives
Include comprehensive comps table
- With statistical summary (max/75th/median/25th/min)
Have all citations as clickable hyperlinks
- Test multiple links to verify they work
Be professionally formatted
- 60-80% page density
- No markdown syntax visible
- Charts and tables embedded properly
Have numbers matching model exactly
- Verify all figures against Excel model
Enable informed investment decision
- Client should understand company, valuation, risks
- Should be indistinguishable from JPM/GS/MS research
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.
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.
🔥 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.