Initiating Coverage
Build a comprehensive initiating coverage note with investment thesis, valuation, risk factors, and price target.
What this skill does
Produce institutional-quality equity research reports complete with investment thesis, valuation analysis, and price targets. The final report includes financial models and professional charts ready for stakeholder presentation. Use this tool when preparing formal investment recommendations or conducting deep-dive analysis on public companies.
name: initiating-coverage description: Create institutional-quality equity research initiation reports through a 5-task workflow. Tasks must be executed individually with verified prerequisites - (1) company research, (2) financial modeling, (3) valuation analysis, (4) chart generation, (5) final report assembly. Each task produces specific deliverables (markdown docs, Excel models, charts, or DOCX reports). Tasks 3-5 have dependencies on earlier tasks.
Initiating Coverage
Create institutional-quality equity research initiation reports through a structured 5-task workflow. Each task must be executed separately with verified inputs.
Overview
This skill produces comprehensive first-time coverage reports following institutional standards (JPMorgan, Goldman Sachs, Morgan Stanley format). Tasks are executed individually, each verifying prerequisites before proceeding.
Default Font: Times New Roman throughout all documents (unless user specifies otherwise).
⚠️ CRITICAL: One Task at a Time
THIS SKILL OPERATES IN SINGLE-TASK MODE ONLY.
If User Requests Full Pipeline
When user requests:
- “Create a coverage initiation report for [Company]”
- “Write an initiation report for [Company]”
- “Do the entire equity research process for [Company]”
- “Complete all 5 tasks for [Company]”
- Any request that implies running multiple tasks or the entire workflow
REQUIRED RESPONSE:
-
Ask which specific task to perform:
I can help you create an equity research initiation report for [Company]. This involves 5 separate tasks that need to be completed individually: 1. Company Research - Research business, management, industry 2. Financial Modeling - Build projection model 3. Valuation Analysis - DCF and comparable companies 4. Chart Generation - Create 25-35 charts 5. Report Assembly - Compile final report Which task would you like to start with? -
When user explicitly requests all tasks together:
I understand you'd like to complete the entire initiation report pipeline. Currently, this skill supports executing one task at a time, which allows for better quality control and review at each stage. We're working on a seamless end-to-end workflow that will make this process more automated, but for now, we'll need to complete each task separately. Would you like to start with Task 1 (Company Research)? -
Never automatically assume which task to start - always ask user to confirm.
-
Never execute multiple tasks in sequence - complete one task, deliver outputs, then wait for next user request.
Task Execution Rules
- ✅ Execute exactly ONE task per user request
- ✅ Always verify prerequisites before starting a task
- ✅ Deliver task outputs and confirm completion
- ✅ Wait for user to explicitly request the next task
- ❌ Never chain multiple tasks together automatically
- ❌ Never assume user wants to proceed to next task
- ❌ Never execute Tasks 3-5 without verifying required inputs exist
⚠️ Deliverables Policy: NO SHORTCUTS
DELIVER ONLY THE SPECIFIED OUTPUTS. DO NOT CREATE EXTRA DOCUMENTS.
Each task specifies exact deliverables. Do NOT create:
- ❌ “Completion summaries”
- ❌ “Executive summaries”
- ❌ “Quick reference guides”
- ❌ “Next steps documents”
- ❌ “Task completion reports”
- ❌ Any other “helpful” documentation not explicitly specified
Why: These extras waste context and are not part of the professional workflow.
What TO deliver:
- ✅ Task 1: Research document (.md) — NOTHING ELSE
- ✅ Task 2: Financial model (.xlsx) — NOTHING ELSE
- ✅ Task 3: Valuation analysis (.md) + Excel tabs added to Task 2 file — NOTHING ELSE
- ✅ Task 4: Charts zip file (.zip) — NOTHING ELSE
- ✅ Task 5: Final report (.docx) — NOTHING ELSE
If a deliverable is not listed above, DO NOT CREATE IT.
Task Selection
Select which task to execute:
| Task | Name | Prerequisites | Output |
|---|---|---|---|
| 1 | Company Research | Company name/ticker | 6-8K word document |
| 2 | Financial Modeling | 10-K or financials access | Excel model (6 tabs) |
| 3 | Valuation Analysis | Financial model (Task 2) | Valuation + price target |
| 4 | Chart Generation | Tasks 1, 2, 3 + external data | 25-35 PNG/JPG charts |
| 5 | Report Assembly | ALL previous tasks (1-4) | 30-50 page DOCX report |
How to Use This Skill
User Request Patterns and Responses
Pattern 1: User specifies a specific task
User: "Use initiating-coverage, Task 1 for Tesla"
Response: ✅ Execute Task 1 immediately
Pattern 2: User asks for “initiation report” or “full pipeline”
User: "Create a coverage initiation report for Tesla"
Response: ❌ DO NOT start any task automatically
✅ Ask which task to start with (see template above)
Pattern 3: User wants to do “all tasks” or “entire workflow”
User: "I want to complete all 5 tasks for Tesla"
Response: ❌ DO NOT chain tasks together
✅ Explain one-at-a-time limitation (see template above)
✅ Ask if they want to start with Task 1
Correct Usage Examples
Executing a single task:
"Use initiating-coverage skill, Task 1 for Tesla"
"Do Task 2 of initiating-coverage for Tesla"
"Run Task 3 for Tesla using the initiating-coverage skill"
Completing full report (requires 5 separate requests):
Request 1: "Do Task 1 for Tesla" → Complete → Deliver outputs
Request 2: "Do Task 2 for Tesla" → Complete → Deliver outputs
Request 3: "Do Task 3 for Tesla" → Complete → Deliver outputs
Request 4: "Do Task 4 for Tesla" → Complete → Deliver outputs
Request 5: "Do Task 5 for Tesla" → Complete → Deliver outputs
Task Execution Order
For a complete initiation report, tasks must be executed in separate user requests following this order:
Request 1: Task 1 - Company Research (independent)
↓ [User reviews outputs and requests next task]
Request 2: Task 2 - Financial Modeling (independent)
↓ [User reviews outputs and requests next task]
Request 3: Task 3 - Valuation Analysis (requires Task 2 output)
↓ [User reviews outputs and requests next task]
Request 4: Task 4 - Chart Generation (requires Tasks 2 & 3 outputs)
↓ [User reviews outputs and requests next task]
Request 5: Task 5 - Report Assembly (requires ALL previous task outputs)
Note: Tasks 1 and 2 can be run in any order. Tasks 3-5 have strict dependencies and must verify inputs before proceeding.
Task 1: Company Research
Purpose: Research company’s business, management, competitive position, industry, and risks.
Prerequisites: ✅ None (fully independent)
- Company name or ticker symbol
Process:
- Verify company name/ticker provided
- Load detailed instructions from references/task1-company-research.md
- Execute qualitative research workflow
- Deliver research document
Output: Company Research Document (6,000-8,000 words)
- Company overview & history
- Management bios (300-400 words × 3-4 execs)
- Products & services analysis
- Industry overview
- Competitive analysis (5-10 competitors)
- TAM sizing
- Risk assessment (8-12 risks)
File name: [Company]_Research_Document_[Date].md
⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.
⚠️ DO NOT TAKE SHORTCUTS:
- ✅ Write full 6,000-8,000 words (not summaries)
- ✅ Complete 300-400 word bios for ALL 3-4 executives
- ✅ Analyze ALL 5-10 competitors thoroughly
- ✅ Cover all 8-12 risks across 4 categories
- ❌ Do not abbreviate sections to save time
- ❌ Do not skip any required sections
Verification before proceeding: None required for this task.
Task 2: Financial Modeling
Purpose: Extract historical financials and build comprehensive Excel financial model with projections and scenarios.
Prerequisites: ⚠️ Verify before starting
- Required: Access to company financial data
- For public companies: Latest 10-K from SEC EDGAR
- For private companies: Financial statements or available estimates
- OR: Pre-extracted historical financials provided by user
- Optional: Company research (Task 1) for business context
Input Verification:
BEFORE STARTING - Select approach:
Option A: Extract financials (most common)
- [ ] Have access to 10-K or financial statements?
- [ ] Ready to extract 3-5 years of data?
Option B: User provided pre-extracted financials
- [ ] Historical financials file received?
- [ ] Contains income statement, cash flow, balance sheet (3-5 years)?
Optional:
- [ ] Company research (Task 1) complete for context?
Process:
- Verify access to financial data
- Load detailed instructions from references/task2-financial-modeling.md
- Step 1: Extract historical financials (if needed)
- Step 2+: Build projection model with 6 essential tabs
- Deliver Excel model
Output: Excel Financial Model (.xlsx)
- 6 essential tabs:
- Revenue Model - Product breakdown (20-30 rows) + Geography breakdown (15-20 rows)
- Income Statement - Full P&L with 40-50 line items, historical (3-5 years) + projected (5 years)
- Cash Flow Statement - Operating/Investing/Financing activities, historical + projected
- Balance Sheet - Assets/Liabilities/Equity, historical + projected
- Scenarios - Bull/Base/Bear comparison table
- DCF Inputs - Prepared for Task 3 valuation
File name: [Company]_Financial_Model_[Date].xlsx
⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.
⚠️ DO NOT TAKE SHORTCUTS:
- ✅ If extracting financials: Extract ALL line items from 3 financial statements (3-5 years)
- ✅ Build ALL 6 projection tabs completely with full detail
- ✅ Create detailed revenue model with 20-30 product rows AND 15-20 geography rows
- ✅ Build complete income statement with 40-50 line items (not abbreviated)
- ✅ Include full cash flow statement and balance sheet with all line items
- ✅ Complete ALL three scenarios (Bull/Base/Bear) with different parameters
- ❌ Do not create simplified/abbreviated versions
- ❌ Do not skip any of the 6 essential tabs
- ❌ Do not skip historical financials extraction if needed
Verification before proceeding to Task 3:
- Historical financials extracted (if needed) or provided
- Excel file created and can be opened
- Model has all 6 essential tabs (Revenue Model, Income Statement, Cash Flow, Balance Sheet, Scenarios, DCF Inputs)
- Historical data (3-5 years) incorporated
- Projections complete (5 years forward)
- Scenarios complete (Bull/Base/Bear)
Task 3: Valuation Analysis
Purpose: Perform comprehensive valuation using DCF, comparables, and precedent transactions.
Prerequisites: ⚠️ Verify before starting
- Required: Financial model from Task 2
- Projected income statements
- Projected cash flows
- Revenue and EBITDA forecasts
- DCF inputs (unlevered FCF)
⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASK 2 IS COMPLETE
This task requires the financial model from Task 2. Starting without it will result in incomplete work.
IF TASK 2 IS NOT COMPLETE: Stop immediately and inform the user that Task 2 (Financial Modeling) must be completed first. Do not attempt to proceed or create placeholder valuations.
Input Verification:
BEFORE STARTING:
- [ ] Task 2 complete? (Financial model exists)
- [ ] Model file path/location known?
- [ ] Can access projected financials from model?
Required from model:
- [ ] Projected FCF (5 years)
- [ ] Revenue projections
- [ ] EBITDA projections
- [ ] Terminal year metrics
Process:
- Verify financial model is accessible
- Load detailed instructions from references/task3-valuation.md
- Execute valuation workflow
- Deliver valuation analysis
Output: Valuation Analysis (4-6 pages + Excel tabs)
- DCF analysis with sensitivity tables
- Comparable companies (5-10 peers with statistical summary)
- Precedent transactions (if applicable)
- Valuation football field
- Price target: $XX.XX
- Recommendation: BUY/HOLD/SELL
- Upside: XX%
- Key catalysts (3-5)
Files:
[Company]_Valuation_Analysis_[Date].md(written analysis document)- Excel tabs added to
[Company]_Financial_Model_[Date].xlsx(from Task 2)- DCF tab with calculations
- Sensitivity analysis tab
- Comparable companies tab
- Valuation summary tab
⚠️ DELIVER ONLY: 1 markdown file + 4 tabs added to existing Excel. NO completion summaries, no extra documents.
⚠️ DO NOT TAKE SHORTCUTS:
- ✅ Complete full DCF analysis with sensitivity matrix (not simplified)
- ✅ Analyze ALL 5-10 comparable companies with full data
- ✅ Include statistical summary in comps table (max/75th/median/25th/min)
- ✅ Create complete sensitivity analysis tab with multiple WACC and terminal growth scenarios
- ✅ Write full 4-6 pages of valuation analysis (not abbreviated)
- ✅ Research and justify price target with specific methodology
- ❌ Do not skip comparable company analysis
- ❌ Do not create simplified DCF without sensitivity
Verification before proceeding to Task 4:
- Price target determined
- Valuation uses multiple methods (DCF + Comps minimum)
- DCF sensitivity table complete
- Comparable companies table includes statistical summary
Task 4: Chart Generation
Purpose: Generate 25-35 professional financial charts for the report.
Prerequisites: ⚠️ Verify before starting
- Required: Company research from Task 1
- Company history and milestones (for timeline charts)
- Management team and org structure (for org charts)
- Product portfolio (for product charts)
- Customer segmentation (for customer charts)
- Competitive landscape (for competitive charts)
- TAM analysis (for market size charts)
- Required: Financial model from Task 2 (with Task 3 valuation tabs added)
- Revenue by product/geography data (Task 2 tabs)
- Margin trends (Task 2 tabs)
- Scenario comparison data (Task 2 tabs)
- DCF sensitivity table (Task 3 tab in same Excel file)
- Comparable companies data (Task 3 tab in same Excel file)
- Valuation ranges (Task 3 tab in same Excel file)
- Required: External market data
- Historical stock price data (Yahoo Finance, Bloomberg, etc.)
- Historical valuation multiples (for historical trend charts)
⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASKS 1, 2, AND 3 ARE COMPLETE
This task requires outputs from all three previous tasks. Starting without them will result in incomplete charts.
IF ANY OF TASKS 1, 2, OR 3 ARE NOT COMPLETE: Stop immediately and inform the user which tasks need to be completed first. The specific requirements are:
- Task 1: Company research document (for 9 charts)
- Task 2: Financial model with all 6 tabs (for 8 charts)
- Task 3: Valuation tabs added to the model (for 6 charts)
- External data access (for 2 charts)
Do not attempt to create placeholder charts or skip charts due to missing data.
Input Verification:
BEFORE STARTING:
- [ ] Task 1 complete? (Company research exists)
- [ ] Task 2 complete? (Financial model exists)
- [ ] Task 3 complete? (Valuation analysis exists)
- [ ] Can access external market data sources?
Required from Task 1:
- [ ] Company history and milestones (for charts 05, 06)
- [ ] Management team structure (for chart 07)
- [ ] Product portfolio details (for chart 08)
- [ ] Customer segmentation data (for chart 09)
- [ ] Competitive landscape analysis (for charts 16, 17, 18)
- [ ] TAM sizing and market data (for chart 15)
Required from Task 2:
- [ ] Revenue by product (historical + projected) - for chart 03 ⭐
- [ ] Revenue by geography (historical + projected) - for chart 04 ⭐
- [ ] Income statement with margins (for charts 02, 10, 11)
- [ ] Cash flow statement (for chart 12)
- [ ] Scenario comparison data (for chart 14)
Required from Task 3:
- [ ] DCF sensitivity matrix - for chart 28 ⭐
- [ ] DCF components (for chart 29)
- [ ] Comparable companies data (for charts 30, 31)
- [ ] Valuation ranges - for chart 32 ⭐
Required from External Sources:
- [ ] Historical stock price data (for chart 01)
- [ ] Historical valuation multiples (for chart 34)
Process:
- Verify model and valuation outputs are accessible
- Load detailed instructions from references/task4-chart-generation.md
- Execute chart generation workflow
- Package all charts into a zip file
- Deliver zip file
Output: 25-35 Professional Chart Files (PNG/JPG, 300 DPI) packaged in zip
4 MANDATORY Charts (must be present) ⭐:
- chart_03: Revenue by product (stacked area)
- chart_04: Revenue by geography (stacked bar)
- chart_28: DCF sensitivity (2-way heatmap)
- chart_32: Valuation football field (horizontal bars)
25 REQUIRED Charts (specific list):
- Investment Summary: chart_01
- Financial Performance: charts 02, 03⭐, 04⭐, 10, 11, 12, 14
- Company 101: charts 05, 06, 07, 08, 09, 15, 16
- Competitive/Market: charts 17, 18
- Scenario Analysis: chart 13
- Valuation: charts 28⭐, 29, 30, 31, 32⭐, 33, 34
10 OPTIONAL Charts (for 26-35 range):
- charts 19-27, 35 (customer acquisition, unit economics, product roadmap, etc.)
IMPORTANT: Task 5 embeds ALL charts created (25-35) for visual density (1 chart per 200-300 words).
File naming: chart_01_description.png, chart_02_description.png, etc.
Deliverable: [Company]_Charts_[Date].zip containing all 25-35 chart files + chart_index.txt
⚠️ DELIVER ONLY THIS 1 ZIP FILE. NO completion summaries, no separate chart lists, no extra documents.
⚠️ DO NOT TAKE SHORTCUTS:
- ✅ Create ALL 25 required charts minimum (specific list provided in task4-chart-generation.md)
- ✅ Include ALL 4 mandatory charts:
- chart_03: Revenue by product (stacked area) ⭐
- chart_04: Revenue by geography (stacked bar) ⭐
- chart_28: DCF sensitivity (heatmap) ⭐
- chart_32: Valuation football field ⭐
- ✅ Optional: Add 1-10 more charts to reach 26-35 total for greater visual density
- ✅ Generate professional-quality charts at 300 DPI (not low-res placeholders)
- ✅ Create unique, well-formatted charts for each visualization
- ✅ Package all charts in zip file with chart index
- ❌ Do not create only 10-15 charts (minimum is 25)
- ❌ Do not skip any of the 4 mandatory charts
- ❌ Do not use low-quality/placeholder images
Verification before proceeding to Task 5:
- Minimum 25 chart files created (required)
- All 4 mandatory charts present:
- chart_03: Revenue by product ⭐
- chart_04: Revenue by geography ⭐
- chart_28: DCF sensitivity ⭐
- chart_32: Valuation football field ⭐
- All charts open and display correctly
- Charts saved at 300 DPI (print quality)
- Chart index created listing all files with categories
- All charts packaged in zip file
- File naming follows convention: chart_##_description.png
Task 5: Report Assembly
Purpose: Write and assemble the comprehensive final DOCX report.
Prerequisites: ⚠️ Verify before starting
- Required: Company research from Task 1
- All 6-8K words of content
- Management bios
- Competitive analysis
- Risk assessment
- Required: Financial model from Task 2
- Excel workbook
- All projections and scenarios
- Required: Valuation analysis from Task 3
- Price target and recommendation
- DCF, comps, precedent transactions
- All valuation data
- Required: Chart files from Task 4
- Zip file containing all 25-35 PNG/JPG files
- Chart index included in zip
⚠️ CRITICAL: DO NOT START THIS TASK UNLESS ALL TASKS 1-4 ARE COMPLETE
This is the final assembly task. It cannot be completed without all previous work products.
IF ANY OF TASKS 1, 2, 3, OR 4 ARE NOT COMPLETE: Stop immediately and inform the user which tasks need to be completed first. The specific requirements are:
- Task 1: Company research document (6-8K words)
- Task 2: Financial model with all 6 tabs
- Task 3: Valuation analysis with price target and recommendation
- Task 4: Charts zip file with 25-35 charts
Do not attempt to create placeholder content, substitute missing sections, or assemble an incomplete report. The report requires ALL inputs to be publication-ready.
Input Verification:
BEFORE STARTING - ALL TASKS MUST BE COMPLETE:
Task 1 Verification:
- [ ] Company research document exists? (6-8K words)
- [ ] Management bios complete? (300-400 words × 3-4 execs)
- [ ] Competitive analysis complete? (5-10 competitors)
- [ ] Risk assessment complete? (8-12 risks)
Task 2 Verification:
- [ ] Financial model exists and can be opened?
- [ ] Model has projections (5 years)?
- [ ] Scenarios exist (Bull/Base/Bear)?
Task 3 Verification:
- [ ] Valuation analysis complete?
- [ ] Price target determined?
- [ ] Recommendation set? (BUY/HOLD/SELL)
- [ ] DCF and comps complete?
Task 4 Verification:
- [ ] Chart zip file exists?
- [ ] Can extract/access all 25-35 chart files from zip?
- [ ] All 4 mandatory charts present?
- [ ] Revenue by product (stacked area)
- [ ] Revenue by geography (stacked bar)
- [ ] DCF sensitivity (heatmap)
- [ ] Valuation football field
- [ ] Chart files accessible and can be opened?
IF ANY VERIFICATION FAILS: Stop and complete missing task first.
Process:
- CRITICAL: Verify ALL prerequisites before starting
- Load detailed instructions from references/task5-report-assembly.md
- Execute report assembly workflow using Claude’s built-in skills:
- Use DOCX skill to create and manipulate the Word document
- Use XLSX skill to read Excel data from Task 2/3
- Use Read tool to read Task 1 and Task 3 markdown files
- Read Task 1 .md file → Convert to Word formatting → Insert charts inline
- Read Task 2 .xlsx file → Extract tables → Write quantitative analysis
- Read Task 3 .md file + Excel tabs → Copy/adapt valuation analysis
- Insert Task 4 .png chart files throughout using DOCX skill
- Create text-dense report with charts interspersed every 200-300 words
- Save and deliver final DOCX report
Key Principles:
- Use Claude’s DOCX and XLSX skills (NOT Python libraries)
- Use actual file operations (read .md/.xlsx/.png files, write .docx file)
- Good equity research reports are text-dense with lots of illustrating images (60-80% page coverage, 1+ chart per page)
🔥 CRITICAL: GO ALL OUT ON THIS TASK
THIS IS THE FINAL DELIVERABLE. DO NOT TAKE SHORTCUTS.
- ✅ Use full token budget - This is the culmination of all previous work
- ✅ Write every section completely - Do not summarize or abbreviate
- ✅ Hit ALL minimum requirements - 30+ pages, 10,000+ words, 25+ charts, 12+ tables
- ✅ Be thorough on projection assumptions - 2,000-3,000 words with product-by-product detail
- ✅ Be comprehensive on scenarios - 1,500-2,000 words with specific Bull/Base/Bear parameters
- ✅ Insert ALL charts from Task 4 - Not just a few, ALL 25-35 charts throughout
- ✅ Create ALL tables from Task 2/3 - Extract every financial table, don’t skip any
- ✅ Use Task 1 content verbatim - Copy/paste full Company 101 sections (6-8K words)
- ✅ Professional quality only - This must be indistinguishable from JPMorgan/Goldman Sachs research
NEVER:
- ❌ “This section would include…” - WRITE THE ACTUAL SECTION
- ❌ “Charts would be inserted here…” - INSERT THE ACTUAL CHARTS
- ❌ “See financial model for details…” - EXTRACT AND INCLUDE THE DETAILS
- ❌ Skip sections due to length - Every section MUST be complete
- ❌ Abbreviate for token conservation - Use whatever tokens are needed
This is publication-ready institutional research. Spare no effort, tokens, or detail.
Output: Comprehensive Equity Research Report (.docx)
Specifications:
- Length: 30-50 pages (MINIMUM 30)
- Word count: 10,000-15,000 words (MINIMUM 10,000)
- Charts: 25-35 embedded images
- Tables: 12-20 comprehensive tables
- Format: Professional DOCX with clickable hyperlinks
Structure:
- Page 1: Investment Summary (INITIATING COVERAGE format)
- Pages 2-5: Investment thesis & risks
- Pages 6-17: Company 101
- Pages 18-30: Financial analysis & projections
- Pages 31-40: Valuation analysis
- Pages 41-50: Appendices
File name: [Company]_Initiation_Report_[Date].docx
⚠️ DELIVER ONLY THIS 1 DOCX FILE. NO executive summaries, no “highlights” documents, no extra files.
Final Verification:
- Report is 30-50 pages
- Word count is 10,000-15,000
- 25-35 charts embedded
- 12-20 tables included
- All citations are clickable hyperlinks
- Numbers match financial model exactly
Input Verification Protocol
Why Input Verification Matters
Each task has strict prerequisites. Running a task without required inputs will:
- Waste time with incomplete work
- Produce low-quality outputs
- Require rework
Always verify inputs before starting a task.
Verification Checklist by Task
Task 1: ✅ No verification needed (independent)
Task 2: Check historical financials available
Task 3: Check financial model exists and is accessible
Task 4: Check both model (Task 2) AND valuation (Task 3) exist
Task 5: Check ALL previous tasks complete (1, 2, 3, 4)
What to Do if Verification Fails
IF prerequisites are missing:
1. Stop the current task
2. Identify which prerequisite task(s) need to be completed
3. Execute the missing task(s) first
4. Return to current task once prerequisites are met
Example Verification Dialogue
User: "Use initiating-coverage, Task 5 for Tesla"
Claude: "Starting Task 5: Report Assembly for Tesla
VERIFICATION - Checking prerequisites:
- Task 1 (Company research)... ❌ NOT FOUND
- Task 2 (Financial model)... ❌ NOT FOUND
- Task 3 (Valuation)... ❌ NOT FOUND
- Task 4 (Charts)... ❌ NOT FOUND
⚠️ VERIFICATION FAILED
Task 5 requires ALL previous tasks to be complete.
To proceed:
1. Complete Task 1: Company Research
2. Complete Task 2: Financial Modeling
3. Complete Task 3: Valuation Analysis
4. Complete Task 4: Chart Generation
5. Then return to Task 5
Would you like to start with Task 1 first?"
Task Reference Files
Detailed instructions for each task are in separate reference files to keep this skill lean:
- references/task1-company-research.md - Company research workflow
- references/task2-financial-modeling.md - Financial modeling workflow
- references/task3-valuation.md - Valuation methodology
- Also see: references/valuation-methodologies.md for DCF/comps deep dive
- references/task4-chart-generation.md - Chart generation workflow
- references/task5-report-assembly.md - Report writing workflow
- Also see: assets/report-template.md for report structure
- Also see: assets/quality-checklist.md for quality checks
When to load reference files: Load ONLY the reference file associated with the specific task being performed. These files are very large - do not load multiple reference files at once. Read the appropriate task reference file at the start of the task for detailed step-by-step instructions.
Quality Standards
All outputs meet institutional standards from leading investment banks (JPMorgan, Goldman Sachs, Morgan Stanley):
- Comprehensive: Meet all minimum requirements
- Detailed: Specific data and examples, not generic statements
- Quantified: Lead with numbers and metrics
- Cited: Proper sources with clickable hyperlinks
- Professional: Institutional-quality formatting
- Accurate: All numbers verified and cross-checked
Important Notes
Task Independence
- Task 1 can run anytime (no dependencies)
- Task 2 can run anytime (just needs historical data)
- Tasks 1 & 2 can run in parallel
- Task 3 requires Task 2
- Task 4 requires Tasks 2 & 3
- Task 5 requires Tasks 1, 2, 3, & 4
Session Management
Same session: Outputs automatically available to subsequent tasks
Different sessions: Reference previous task outputs explicitly
"Use Task 3 with the model from yesterday at [path]"
"Use Task 5 with the research document at [path]"
File Organization
Recommended structure during workflow:
ProjectFolder/
├── Task1_Research/
│ └── [Company]_Research_Document.md
├── Task2_Model/
│ └── [Company]_Financial_Model.xlsx
├── Task3_Valuation/
│ └── [Company]_Valuation_Analysis.pdf
├── Task4_Charts/
│ ├── chart_01.png
│ └── ... (25-35 files)
└── Task5_Report/
└── [Company]_Initiation_Report.docx
No End-to-End Execution
This skill does NOT support running all tasks automatically in sequence. Each task must be explicitly requested and verified.
Why: This ensures:
- Quality control at each stage
- Ability to review outputs before proceeding
- Flexibility to pause/resume workflow
- Clear verification of prerequisites
Success Criteria
A successful initiation report workflow should:
- Complete all 5 tasks in order
- Pass all input verifications
- Meet all quality standards
- Produce all required deliverables
- Numbers cross-check between outputs
- Final report is publication-ready
Output quality: Institutional (JPMorgan/Goldman/Morgan Stanley level) Use case: First-time comprehensive coverage of a company
Quality Control Checklist for Initiation Reports
Before delivering an initiation report, verify all items below are complete.
Critical Minimums - Reports Must Meet These
CRITICAL DO NOT DELIVER IF:
- ❌ DOCX report fewer than 30 pages → INCOMPLETE
- ❌ Fewer than 25 embedded charts → INCOMPLETE
- ❌ Fewer than 12 comprehensive tables → INCOMPLETE
- ❌ Fewer than 10,000 words → INCOMPLETE
- ❌ No XLS financial model → MISSING DELIVERABLE
- ❌ Charts are text descriptions, not actual PNG/JPG files → MAJOR FAILURE
Deliverables Checklist
- DOCX report file created
- XLS financial model file created
- Both files named properly:
[Company]_Initiation_Report_[Date].docxand[Company]_Financial_Model_[Date].xlsx
DOCX Report - Length & Content
Length Verification:
- Report is 30-50 pages (count pages in final document)
- Word count is 10,000-15,000 words
- If under 30 pages: STOP and add more content
Visual Elements:
- 25-35 charts embedded (count them: _____ charts)
- All charts are actual PNG/JPG image files (NOT text descriptions)
- 12-20 comprehensive tables included (count them: _____ tables)
- Charts and tables interspersed throughout, not grouped at end
Chart Requirements:
- Revenue by product chart: Stacked Area format ✓
- Revenue by geography chart: Stacked Bar format ✓
- DCF sensitivity: 2-way Heat Map with color coding ✓
- Valuation football field: Horizontal bar chart ✓
- All other charts are actual image files ✓
Table Requirements:
- Full Income Statement (40-50 rows) with 5 years historical + 5 years projected
- Full Cash Flow Statement (30-40 rows)
- Full Balance Sheet (35-45 rows)
- Revenue by product table (20-30 rows)
- Revenue by geography table (15-20 rows)
- Revenue by channel table (10-15 rows)
- Comparable companies table with statistical summary (max/75th/median/25th/min)
- DCF calculation table (30-40 rows)
- WACC calculation table (8-10 rows)
- Two sensitivity tables
- 2-3 additional financial/competitive tables
DOCX Report - Structure
Page 1 Requirements:
- "INITIATING COVERAGE" header present (NOT "Company Update")
- Thesis-focused title (NOT event-driven like "Strong Q4 Results")
- Rating box with rating, price, target price, 52-week range, market cap, EV
- 3-4 paragraph-length bullets with ■ character and bold headers
- Financial & valuation metrics table with 2-3 years historical, 2 years projected
- Table shows "A" suffix for actuals, "E" suffix for estimates
- Source lines on all visuals
Content Sections:
- Table of Contents (Page 2)
- Investment Thesis & Risks (3-5 pages)
- Company Overview (6-12 pages) including:
- Company description
- History and milestones
- Management bios (300-400 words EACH for 3-4 executives)
- Products/services detail
- Competitive landscape
- Financial Analysis & Projections (10-15 pages)
- Valuation Analysis (8-12 pages)
- Assumptions section (2,000-3,000 words documenting ALL projection assumptions)
- Scenario Analysis (1,500-2,000 words with Bull/Base/Bear parameters)
- Appendices including Data Sources & References page
DOCX Report - Formatting
Figure & Table Formatting:
- Every figure has caption above: "Figure X - [Company] [Descriptive Title]"
- Every figure has source line below: "Source: [Specific sources with dates]"
- Sequential figure numbering (Figure 1, 2, 3... no gaps)
- Every table has header row with shading
- Every table has source line at bottom
- All years use "A" for actual, "E" for estimate notation
Professional Formatting:
- Consistent fonts throughout (Calibri, Arial, or similar)
- Headers and footers with page numbers
- Dense layout: 60-80% page coverage, minimal white space
- Every page has both text AND visuals (charts or tables)
- Professional business report template used
Citations & Sources ⭐⭐⭐ CRITICAL
Source Attribution:
- Every figure has specific source with document name and date
- Every table has specific source with document reference
- Key statistics throughout text have footnotes with sources
- NOT just generic "Company data" - must be specific
Hyperlinks: ⭐⭐⭐ MANDATORY
- ALL URLs are CLICKABLE HYPERLINKS (not plain text)
- SEC filings hyperlinked to EDGAR viewer
- Earnings transcripts hyperlinked (Seeking Alpha or company IR)
- Press releases hyperlinked to company IR page
- Presentations hyperlinked to PDF URLs
- Industry reports hyperlinked (if publicly available)
- Subscription data (Bloomberg, FactSet) noted as "(subscription required)"
- No raw URLs displayed anywhere - all formatted as hyperlinks
- Test 3-5 sample hyperlinks to ensure they work (Ctrl+Click)
Reference Page:
- "Data Sources & References" page at end of report
- Lists ALL sources used in report
- Sources organized by category (SEC Filings, Earnings Transcripts, etc.)
- Every source has date
- Every source has clickable hyperlink (where applicable)
XLS Financial Model - Structure
File Structure:
- 15+ tabs in Excel workbook
- Tabs include: Executive Summary, Assumptions, Historical Financials, Revenue Model, Operating Expenses, Income Statement, Balance Sheet, Cash Flow, Supporting Schedules, DCF Valuation, Comps Analysis, Precedent Transactions, Scenarios, Sensitivity Analysis, Charts
Formatting:
- Blue text for hardcoded inputs
- Black text for formulas
- Green text for links to other sheets
- Professional formatting with borders and shading
- Clear section headers and labels
Model Functionality:
- All numbers flow (change assumption → entire model updates)
- DCF links to assumptions and projections
- No circular references or errors
- All important cells/ranges are named
- Sensitivity tables work dynamically
XLS Financial Model - Content
Projections:
- 3-5 years historical data
- 5 years forward projections (FY+1 through FY+5)
- Revenue broken down by product, geography, channel
- Full P&L with 40-50 line items
- Full cash flow with 30-40 line items
- Full balance sheet with 35-45 line items
Valuation:
- Complete DCF model with all calculations shown
- WACC calculation with all components
- Terminal value calculation
- Comparable companies analysis (5-10 companies)
- Precedent transactions analysis (5-10 deals)
- Scenario analysis (Bull/Base/Bear)
- Two sensitivity tables
Cross-File Consistency
CRITICAL: Numbers must match EXACTLY between DOCX and XLS
- Revenue numbers match across both files
- EPS numbers match across both files
- Margin percentages match across both files
- Valuation numbers match across both files
- Price target matches across both files
- All projected years match across both files
Verification Method: Spot check 10-15 key numbers between DOCX report and XLS model.
Content Quality
Investment Thesis:
- 3-5 clear thesis pillars
- Each pillar supported with specific data and quantification
- Financial impact quantified for each pillar
- Catalysts identified with timelines
Analysis Depth:
- Comprehensive business model analysis
- Detailed competitive assessment
- 3-5 year financial trends analyzed
- 8-12 risks identified and quantified
- Management team analyzed (300-400 words per executive)
Assumptions:
- 2,000-3,000 words documenting ALL assumptions
- Revenue growth assumptions by category/geography
- Margin assumptions with bridge showing drivers
- Working capital assumptions
- CapEx assumptions
- Each assumption has specific quantification
Scenarios:
- 1,500-2,000 words on scenario analysis
- Bull case with specific parameters and catalysts
- Base case with detailed rationale
- Bear case with specific triggers
- Probability assessments for each scenario
Writing Quality
Style:
- Lead with numbers ("Revenue grew 15% to $1.2B" not "Strong revenue")
- Use "vs." not "versus"
- Be direct and concise
- Professional institutional tone throughout
- No informal language
Accuracy:
- No typos in ticker symbol
- No typos in company name
- All dates accurate
- All calculations verified
- Charts match text descriptions
- All numbers properly formatted ($ signs, % signs, commas)
Pre-Delivery Final Check
Run through this quick final review:
- Deliverables: Both DOCX and XLS files created ✓
- Length: DOCX is 30-50 pages ✓
- Charts: 25-35 actual PNG/JPG files embedded ✓
- Tables: 12-20 comprehensive tables included ✓
- Words: 10,000-15,000 words ✓
- Hyperlinks: Test 3-5 hyperlinks - all work ✓
- Cross-check: Spot check 10 numbers match between DOCX and XLS ✓
- Page 1: "INITIATING COVERAGE" header present ✓
If ANY item fails, DO NOT DELIVER. Go back and fix.
Actual Count Verification
Before delivery, fill in actual counts:
DOCX Report:
- Page count: _____ pages (MUST BE 30-50)
- Chart count: _____ charts (MUST BE 25-35)
- Table count: _____ tables (MUST BE 12-20)
- Word count: _____ words (MUST BE 10,000-15,000)
XLS Model:
- Tab count: _____ tabs (SHOULD BE 15+)
- Model years: _____ historical + _____ projected
If any count is below minimum, STOP and add content before delivery.
Equity Research Initiation Report Template
This template provides the structure for creating a comprehensive equity research initiation report. Use this as a guide when constructing the final report document.
NOTE: The actual report MUST be created using the DOCX skill. DO NOT generate markdown content.
CRITICAL REQUIREMENTS:
- Generate 20-30+ chart images using Python (matplotlib/plotly) BEFORE creating the Word document
- Use DOCX skill: Create professional report with proper styles, headers/footers, and formatting
- Embed actual chart images: Insert the generated PNG/JPG chart files into the Word document at appropriate locations
- NO MARKDOWN: Do not generate markdown content. Use DOCX skill to create a .docx file.
CRITICAL FORMATTING GUIDANCE:
- MAXIMUM DENSITY: Every page should be packed with information. Intersperse text, charts, and tables throughout.
- NO ORPHANED SECTIONS: Never have a section header alone or a single chart on its own page.
- 20-30+ ACTUAL CHART IMAGES: Generate charts as image files, then embed within text sections using DOCX skill.
PAGE 1: INVESTMENT UPDATE (MOST IMPORTANT PAGE)
CRITICAL: Page 1 is NOT a traditional executive summary. It is an Investment Update with a specific institutional format used by professional equity research firms.
IMPORTANT STRUCTURAL NOTES:
- This is an "Investment Update" or "Company Update" page, not "Executive Summary"
- Uses a rating box in top left corner
- Features stock price performance chart (Figure 1) prominently
- Contains 3-4 detailed bullet points with ■ character
- Each bullet has bold topic header followed by 3-5 sentence explanation
- Bottom section has financial and valuation metrics table
- All charts must have figure numbers (Figure 1, Figure 2, etc.) with source lines
Layout Structure
TOP LEFT - RATING BOX:
Rating: [OUTPERFORM / NEUTRAL / UNDERWEIGHT / etc.]
Price ([Date]): $[XX.XX]
Target Price: $[XX.XX]
52-Week Range: $[XX.XX] - $[XX.XX]
Market Cap: $[XX.X]B
Enterprise Value: $[XX.X]BTOP LEFT - RESEARCH ANALYSTS:
[Name], [Credentials (Ph.D., CFA, M.D., etc.)]
[Email] | [Phone]
[Name 2], [Credentials]
[Email] | [Phone]TOP RIGHT - STOCK PRICE PERFORMANCE:
Figure 1 - [Company Name] Stock Price Performance
[Line chart showing stock price over 12-24 months with benchmark comparison]
Source: Company data, [Firm Name] estimates.MAIN CONTENT - GRAY HEADER BAR:
[OUTPERFORM / NEUTRAL / etc.] RECOMMENDATION / COMPANY UPDATEMAIN CONTENT - DETAILED BULLETS (3-4 bullets):
Use ■ character for bullets. Each bullet follows this format:
■ **[Bold Topic Header capturing main point].** Regular text explanation providing 3-5 sentences of detail with specific numbers, comparisons, and analysis. Lead with numbers and quantification where possible. Use "vs." not "versus". Be specific and concrete.
■ **[Second Topic Header].** [3-5 sentences of detailed explanation...]
■ **[Third Topic Header].** [3-5 sentences of detailed explanation...]
■ **[Fourth Topic Header - Optional].** [3-5 sentences of detailed explanation...]EXAMPLE BULLET FORMAT:
■ **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.BOTTOM SECTION - FINANCIAL AND VALUATION METRICS TABLE:
[Year-3]A [Year-2]A [Year-1]A [Year]E [Year+1]E
Revenue ($M) [X] [X] [X] [X] [X]
Revenue Growth (%) X.X% X.X% X.X% X.X% X.X%
Gross Margin (%) X.X% X.X% X.X% X.X% X.X%
EBITDA ($M) [X] [X] [X] [X] [X]
EBITDA Margin (%) X.X% X.X% X.X% X.X% X.X%
EPS ($) X.XX X.XX X.XX X.XX X.XX
P/E (x) XX.Xx XX.Xx XX.Xx XX.Xx XX.Xx
EV/Revenue (x) X.Xx X.Xx X.Xx X.Xx X.Xx
EV/EBITDA (x) XX.Xx XX.Xx XX.Xx XX.Xx XX.Xx
Note: Use "A" suffix for actual/historical years, "E" suffix for estimated/projected years
Source: Company data, [Firm Name] estimates.FIGURE NUMBERING AND FORMATTING STANDARDS
CRITICAL: All charts, graphs, and tables must follow strict figure numbering conventions used in professional equity research.
Figure Numbering Format
Every chart/table must have:
- Sequential numbering: Figure 1, Figure 2, Figure 3, etc. (continue sequentially throughout entire report)
- Descriptive title: "Figure X - [Company] [Specific Metric] [Type of Chart/Analysis]"
- Source line (always at bottom): "Source: Company data, [Firm Name] estimates."
Examples:
- Figure 1 - [Company] Stock Price Performance
- Figure 2 - [Company] Historical and Projected Revenue Mix by Product
- Figure 3 - [Company] Revenue by Geographic Region
- Figure 4 - [Product Name] Revenue and Price per Patient per Year
- Figure 5 - [Company] Gross Margin Evolution
- Figure 6 - DCF Sensitivity Analysis ($/share)
- Figure 7 - Valuation Football Field
Caption Format
Figure X - [Descriptive Title]
[Chart/Table/Graph content]
Source: Company data, [Firm Name] estimates.For tables with multiple data sources:
Figure X - [Descriptive Title]
[Table content]
Source: Company filings, FactSet, [Firm Name] estimates.Placement Guidelines
- Figures should be numbered in order of appearance in the report
- First figure (Figure 1) is typically the stock price chart or revenue growth trajectory on Page 1
- Each figure must have its caption directly below the visual
- Source line should be in smaller font, italicized, at the very bottom of the figure
PAGE 2: TABLE OF CONTENTS
Executive Summary....................................................1
Investment Thesis & Risks..........................................3
Company Overview.......................................................6
Business Description & History................................6
Management & Ownership..........................................8
Products & Technology...........................................9
Customers & Go-to-Market......................................11
Growth Outlook & Drivers...........................................13
Financial Analysis & Performance.................................16
Historical Performance........................................16
Financial Projections.........................................19
Industry Overview & Competitive Landscape.....................21
Market Size & TAM..............................................21
Competitive Analysis..........................................23
Industry Trends................................................25
Valuation Analysis..................................................27
Appendices & Disclosures...........................................31PAGES 3-5: INVESTMENT THESIS & RISKS
LAYOUT PRINCIPLE: Intersperse text with 2-3 charts in this section. Each page should have both text AND graphics. Never have pages with text only or charts only.
Investment Thesis
[Thesis Pillar 1]: [Title - e.g., "Large and Growing TAM"]
[Opening sentence with key statistic]
[Paragraph 1: Market opportunity quantification]
- Current market size
- Growth drivers
- Company's positioning
[Paragraph 2: Why company will capture share]
- Competitive advantages
- Go-to-market strategy
- Early traction/proof points
[Paragraph 3: Financial impact]
- Revenue opportunity
- Margin profile
- Timeline
[EMBED CHART: TAM Growth Chart] - Stacked area chart showing market size evolution and company's opportunity
[Thesis Pillar 2]: [Title - e.g., "Differentiated Technology/Product"]
[Similar structure - 3 paragraphs covering the opportunity, competitive positioning, and financial impact]
[EMBED CHART: Competitive Positioning Matrix] - 2×2 chart showing company vs. competitors on key dimensions
[Thesis Pillar 3]: [Title - e.g., "Strong Execution and Management"]
[Similar structure]
[Add 2-3 more pillars as needed]
[EMBED CHART: Margin Expansion Pathway] - Waterfall or line chart showing path to margin improvement
Investment Risks
Company-Specific Risks
[Risk 1]: [Title - e.g., "Customer Concentration"] [Description of risk, quantification if possible, mitigating factors. 2-3 sentences.]
[Risk 2]: [Title - e.g., "Execution Risk on Product Roadmap"] [Description. 2-3 sentences.]
[Risk 3-5]: [Additional company-specific risks] [Continue with 3-5 total company risks]
Industry/Market Risks
[Risk 1]: [Title - e.g., "Regulatory Uncertainty"] [Description. 2-3 sentences.]
[Risk 2]: [Title - e.g., "Intense Competition"] [Description. 2-3 sentences.]
[Risk 3-4]: [Additional industry/market risks] [Continue with 2-4 total industry risks]
PAGES 8-19: COMPANY 101
Company Description (1 page)
Overview [3-4 paragraphs describing:
- What the company does (in plain English)
- How it makes money
- Who its customers are
- Geographic presence
- Scale/size metrics]
Business Model Diagram/Visual [Insert visual showing how the company creates value]
Company History (2-3 pages)
The Early Days: [Founding Story Title]
[Paragraph on founding: who, when, why, initial vision]
Timeline of Key Milestones
[Year]: [Founding event, initial funding]
[Year]: [Product launch, key milestone]
[Year]: [Major partnership, funding round]
[Year]: [Geographic expansion, new product]
[Year]: [Recent achievement][Major Turning Point or Pivot] [If applicable, describe any major strategic shifts]
[Company Name] Today: [Current State Title] [Paragraphs describing current position, recent developments, current strategy]
Management & Ownership (2 pages)
Key Executives
For each executive:
[Name] - [Title]
[Bio paragraph including:
- Current role and responsibilities
- Prior experience and track record
- Key accomplishments at company
- Education/credentials]Corporate Structure & Governance
- Entity type (C-Corp, PBC, etc.)
- Board composition
- Special governance features
- [Include governance diagram if applicable]
Ownership Structure [if disclosed]
- Major shareholders and ownership %
- Strategic investors
- Employee ownership
- Insider ownership trends
Core Technology/Products (2-3 pages)
Technology Overview [Description of core technology/platform]
Product Portfolio
For each major product:
[Product Name]
Description:
[What it does, key features]
Target Customers:
[Who uses it, use cases]
Pricing Model:
[How it's priced, typical contract values]
Competitive Positioning:
[How it compares to alternatives]
Traction:
[Customers, revenue, growth metrics]Product Roadmap [Future products/features in development]
Customers & Distribution (2-3 pages)
Customer Base
- Total customers: [number]
- Customer segments (Enterprise, Mid-Market, SMB)
- Geographic breakdown
- Customer case studies/testimonials
Go-to-Market Strategy
- Sales channels (direct, partner, etc.)
- Sales cycle and CAC
- Key partnerships for distribution
- Marketing strategy
Customer Economics
- LTV/CAC ratio
- Net retention rate
- Churn rates
- Expansion rates
PAGES 20-22: GROWTH OUTLOOK
Growth Framework Overview
Short-term Growth Drivers (1-2 years)
- [Driver 1]
- [Driver 2]
- [Driver 3]
Medium-term Growth Drivers (3-5 years)
- [Driver 1]
- [Driver 2]
Detailed Growth Driver Analysis
[Growth Driver 1]: [Title]
Current State: [Baseline metrics, current performance]
Opportunity: [Market size, company positioning, growth potential]
Timeline & Milestones:
- Near-term (1-2 years): [Expected progress]
- Medium-term (3-5 years): [Expected progress]
Risks & Challenges: [What could prevent realization of this opportunity]
[Repeat for each major growth driver]
Financial Projections
Revenue Build-up [Visual showing how revenue grows from current to projected]
Scenario Analysis [Table or chart showing Bear/Base/Bull case projections]
PAGES 21-24: FINANCIAL ANALYSIS & PERFORMANCE
LAYOUT PRINCIPLE: This section should be VERY DENSE with 5-7 charts interspersed with financial tables. Each page should have multiple elements (table + 1-2 charts).
Historical Financial Analysis
Income Statement Highlights (3-5 Year History)
2021 2022 2023 2024 LTM
Revenue ($M) [X] [X] [X] [X] [X]
Growth % - X% X% X% X%
Gross Profit ($M) [X] [X] [X] [X] [X]
Margin % X% X% X% X% X%
EBITDA ($M) [X] [X] [X] [X] [X]
Margin % X% X% X% X% X%
Net Income ($M) [X] [X] [X] [X] [X]
Margin % X% X% X% X% X%
FCF ($M) [X] [X] [X] [X] [X][CHART 1: Revenue Growth Trajectory] Line chart showing historical revenue with annotations for key milestones. Include growth % labels on chart.
[CHART 2: REVENUE BY PRODUCT/SEGMENT] ⭐ CRITICAL Stacked area chart showing revenue composition by product line or business segment over time. This shows mix shift and which products are driving growth.
Example segments:
- Product A Revenue
- Product B Revenue
- Product C Revenue
- Services Revenue[CHART 3: REVENUE BY GEOGRAPHY] ⭐ CRITICAL Stacked bar chart showing revenue breakdown by geographic region over time.
Example regions:
- North America
- Europe
- Asia-Pacific
- Rest of WorldFinancial Performance Analysis
[CHART 4: Gross Margin Evolution] Line chart with annotations explaining margin drivers (scale, pricing, mix, etc.)
[CHART 5: Operating Margin Progression] Waterfall chart showing path from gross margin to operating margin, or line chart showing EBITDA margin trend
[CHART 6: Free Cash Flow Generation] Bar + line combo chart: Bars = FCF, Line = FCF margin %
[CHART 7: Key Operating Metrics Dashboard] Multi-panel chart showing 3-4 key metrics:
- Customer count or user growth
- ARPU (Average Revenue Per User) or ACV (Annual Contract Value)
- Customer cohort retention or net revenue retention
- LTV/CAC or magic number or other unit economic metric
Forward Projections (3-5 Years)
Projected Financial Model
2025E 2026E 2027E 2028E 2029E
Revenue ($M) [X] [X] [X] [X] [X]
Growth % X% X% X% X% X%
Gross Profit ($M) [X] [X] [X] [X] [X]
Margin % X% X% X% X% X%
EBITDA ($M) [X] [X] [X] [X] [X]
Margin % X% X% X% X% X%
FCF ($M) [X] [X] [X] [X] [X]
FCF Margin % X% X% X% X% X%Key Assumptions
- Revenue growth drivers and assumptions
- Margin progression assumptions
- CapEx as % of revenue
- Working capital assumptions
Charts:
- Revenue bridge showing growth drivers
- Margin waterfall showing path to profitability/margin expansion
- Free cash flow trajectory
Fundraising & Valuation [For Private Companies]
Fundraising History
Round Date Amount Valuation Lead Investor(s)
Seed [Date] $XM $XM [Investor]
Series A [Date] $XM $XM [Investor]
Series B [Date] $XM $XM [Investor]
[etc.]Valuation Evolution Chart [Visual showing valuation progression over time]
Current Valuation Metrics
- Latest valuation: $XXbn
- Implied valuation multiple: XX.Xx
- Comparison to public peers
PAGES 26-31: INDUSTRY OVERVIEW
Industry Definition & Market Size
Industry Overview [2-3 paragraphs on:
- Industry definition and scope
- Current market size
- Historical growth rates
- Key trends and drivers]
Market Size Chart [Visual showing market growth from historical through projected]
Competitive Landscape
Competitive Positioning Matrix [2x2 chart showing company vs. competitors on key dimensions]
Competitive Comparison Table
Metric [Company] Comp A Comp B Comp C Comp D
Revenue ($B) [X] [X] [X] [X] [X]
Growth % X% X% X% X% X%
Market Share X% X% X% X% X%
Gross Margin X% X% X% X% X%
Key Differentiator [X] [X] [X] [X] [X]Competitive Analysis Narrative [2-3 paragraphs analyzing:
- Competitive strengths and weaknesses
- Market positioning
- Share gains/losses
- Competitive moats]
Total Addressable Market
TAM Calculation
Current TAM (2025): $XXbn
Projected TAM (2030): $XXbn
CAGR: XX%
Segmentation:
- [Segment A]: $XXbn
- [Segment B]: $XXbn
- [Segment C]: $XXbnTAM Growth Chart [Visual showing TAM expansion over time by segment]
Company's Market Opportunity
Total TAM (2030): $XXbn
Serviceable TAM: $XXbn
Company's Realistic Share: XX%
Implied Revenue Potential: $XXbnIndustry Dynamics
Porter's Five Forces Analysis
- Threat of new entrants: [High/Medium/Low] - [Explanation]
- Bargaining power of suppliers: [High/Medium/Low] - [Explanation]
- Bargaining power of buyers: [High/Medium/Low] - [Explanation]
- Threat of substitutes: [High/Medium/Low] - [Explanation]
- Industry rivalry: [High/Medium/Low] - [Explanation]
Key Industry Trends
- [Trend 1]: [Description and impact]
- [Trend 2]: [Description and impact]
- [Trend 3]: [Description and impact]
PAGES 32-34: VALUATION ANALYSIS
Valuation Methodology Summary
Valuation Method Weight Implied Value Weighted Value
DCF Analysis 50% $XX - $YY $ZZ
Trading Comparables 30% $XX - $YY $ZZ
Precedent Transactions 20% $XX - $YY $ZZ
──── ───────────── ─────────
Weighted Average Price Target $AA - $BB $CCDCF Analysis
Key Assumptions
Revenue Growth (2025-2029): XX% CAGR
Terminal Growth Rate: X.X%
WACC: X.X%
Terminal Year EBITDA Margin: XX%Figure X - DCF Sensitivity Analysis ($/share)
CRITICAL FORMAT: DCF sensitivity must be shown as a 2-way heat map table with color coding.
Terminal Growth Rate
WACC 2.0% 2.5% 3.0% 3.5% 4.0%
8.0% $52 $55 $58 $62 $66
9.0% $48 $51 $54 $57 $61
10.0% $45 $47 $50 $53 $56
11.0% $42 $44 $47 $49 $52
12.0% $39 $41 $44 $46 $49
Color coding: Green (higher values) → Yellow (mid) → Red (lower values)
Source: [Firm Name] estimates.Scenario Analysis
Scenario Enterprise Value Equity Value Price/Share
Bear Case $XXbn $XXbn $XX
Base Case $XXbn $XXbn $XX
Bull Case $XXbn $XXbn $XXTrading Comparables
Figure X - Comparable Companies Analysis
CRITICAL FORMAT: Comp table must have two-part structure with statistical summary.
Part 1: Individual Company Data
Company Ticker Market EV/Rev EV/Rev EV/EBITDA EV/EBITDA Rev EBITDA
Cap($B) 2024E 2025E 2024E 2025E Growth Margin
Peer A PERA XX.X X.Xx X.Xx XX.X XX.X XX% XX%
Peer B PERB XX.X X.Xx X.Xx XX.X XX.X XX% XX%
Peer C PERC XX.X X.Xx X.Xx XX.X XX.X XX% XX%
Peer D PERD XX.X X.Xx X.Xx XX.X XX.X XX% XX%
[Company] COMP XX.X X.Xx X.Xx XX.X XX.X XX% XX%Part 2: Statistical Summary
Max XX.X X.Xx X.Xx XX.X XX.X XX% XX%
75th Percentile XX.X X.Xx X.Xx XX.X XX.X XX% XX%
Median XX.X X.Xx X.Xx XX.X XX.X XX% XX%
25th Percentile XX.X X.Xx X.Xx XX.X XX.X XX% XX%
Min XX.X X.Xx X.Xx XX.X XX.X XX% XX%
Source: FactSet, company filings, [Firm Name] estimates.Implied Valuation [Calculation showing application of peer multiples to company's metrics]
Precedent Transactions [If Applicable]
Figure X - Precedent Transaction Analysis
Date Target Acquirer Deal EV/Rev EV/EBITDA Premium
Value($B)
[MM/YYYY] [Company A] [Buyer A] X.X X.Xx XX.X XX%
[MM/YYYY] [Company B] [Buyer B] X.X X.Xx XX.X XX%
[MM/YYYY] [Company C] [Buyer C] X.X X.Xx XX.X XX%
────────────────────────────────────────────────────────────────────
Median X.Xx XX.X XX%
Source: Capital IQ, company filings, [Firm Name] estimates.Control Premium Analysis [Discussion of typical premiums in the industry]
Valuation Summary
Figure X - Valuation Football Field
CRITICAL FORMAT: Football field must be a horizontal bar chart showing all valuation methods.
Valuation Method Low End ────── Range ────── High End
DCF Analysis $42 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $58
Trading Comps (NTM) $45 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $55
Precedent Trans. $48 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $60
↑
Current Price: $50
────────────────────────────────────────────────────────────────
Valuation Range: $42 $60
Color coding: Each method should have distinct color bar
Add vertical line showing current stock price
Source: [Firm Name] estimates.Price Target & Recommendation
Current Price: $XX.XX ([Date])
Price Target: $YY.YY
Upside/Downside: ZZ%
Recommendation: BUY / HOLD / SELL
Time Horizon: 12 months
Catalysts:
• [Near-term catalyst with timeframe]
• [Medium-term catalyst with timeframe]
• [Long-term catalyst with timeframe]PAGES 35+: APPENDICES & DISCLOSURES
Appendix A: Detailed Financial Model
[Reference to Excel model]
Appendix B: Management Bios
[Extended bios if not included in main text]
Appendix C: Product Detail
[Additional product information if needed]
Appendix D: Industry Data Sources
[List of sources used for industry analysis]
Required Disclosures
- Analyst certification
- Important disclosures
- Company-specific disclosures
- Legal entity disclosures
- Other regulatory disclosures
GRAPHICS & CHARTS TO INCLUDE
TARGET: 20-30+ charts throughout the report
CRITICAL PRINCIPLE: Charts should be embedded within text sections, NOT grouped on separate pages. Every page (except TOC) should have at least one chart or table.
Page 1 - Executive Summary (3 charts)
- Revenue/ARR growth trajectory (line chart, historical + projected)
- Key metrics dashboard (multi-panel chart)
- Market positioning or margin progression
Pages 3-5 - Investment Thesis & Risks (3 charts)
- TAM growth and opportunity (stacked area chart)
- Competitive positioning matrix (2×2 with bubbles)
- Margin expansion pathway (waterfall or line)
Pages 6-17 - Company 101 (6-8 charts)
- Business model diagram (flow chart)
- Company timeline (horizontal timeline)
- Funding history (bar chart with valuation line)
- Organization chart
- Product portfolio matrix
- Customer segmentation (pie or tree map)
- Geographic revenue breakdown
- Customer cohort retention
Pages 18-20 - Growth Outlook (4 charts)
- Revenue bridge showing drivers (waterfall)
- Market share evolution (line chart)
- Product roadmap (timeline)
- Geographic expansion (map with timeline)
Pages 21-24 - Financials (7 charts) ⭐ CRITICAL SECTION
- Revenue growth trajectory (line with annotations)
- Revenue by product/segment (stacked area) ⭐ MUST HAVE
- Revenue by geography (stacked bar) ⭐ MUST HAVE
- Gross margin evolution (line chart)
- Operating margin progression (waterfall or line)
- Free cash flow trajectory (bar + line combo)
- Key operating metrics dashboard (multi-panel)
- Scenario comparison (grouped bar: Bear/Base/Bull)
Pages 25-30 - Industry Overview (6 charts)
- Market size evolution (area chart with CAGR)
- Competitive landscape map (2×2)
- Market share pie chart
- Market share evolution over time (line chart)
- TAM segmentation
- Industry trend charts
Pages 31-34 - Valuation (5 charts)
- DCF sensitivity analysis (heat map)
- DCF waterfall (PV of cash flows → equity value)
- Trading comps scatter plot (growth vs. multiple)
- Peer valuation multiples (grouped bar)
- Valuation football field (range chart)
- Price target scenarios (bar with upside/downside)
Chart Style Guidelines:
- Consistent color scheme throughout (pick 3-5 brand colors)
- Professional fonts (Arial, Calibri, or similar)
- Clear labels and legends on every chart
- Source citations at bottom of each chart
- High information density - use chart space efficiently
- Mix of chart types for visual interest
- Annotations to highlight key insights
- Embedded in text - never standalone pages
- Sparklines in tables where appropriate
NOTES ON USING THIS TEMPLATE
PAGE 1 IS CRITICAL: The executive summary on page 1 must contain ALL key information - fast facts, financial snapshot, 3 charts, valuation summary, thesis, and risks. This is the most important page.
MAXIMUM DENSITY: Professional equity research is EXTREMELY information-dense. Every page should be packed with interspersed text, charts, and tables. Aim for 60-80% page coverage with minimal white space.
NO ORPHANED SECTIONS: Never have a section header alone, or a single chart/table on its own page. Always combine elements. Example: DON'T put "Financial Snapshot" on page 6 by itself - integrate it with surrounding content.
20-30+ CHARTS: Include extensive graphics throughout, with specific emphasis on:
- Revenue by product/segment (stacked area chart)
- Revenue by geography (stacked bar chart)
- Financial performance trends (multiple charts)
- Charts should be embedded within text, not grouped separately
Use DOC Skill: This outline should be converted to a professional Word document using the DOC skill, with proper formatting, styles, headers/footers, and page numbers
Intersplice Content: Text paragraphs should have charts embedded inline. Each page should have 2-4 distinct elements (tables, charts, text blocks).
Consistent Formatting: Use consistent styles for headers, body text, tables, and charts throughout. Pick a color scheme and stick to it.
References: Include citations and sources for all data points
Proofread: Always proofread for accuracy, especially financial data and calculations
Executive Summary Last: While it appears on page 1, write this section last after completing the full analysis
Balance: Present both positive and negative aspects objectively
Specific > Generic: Use specific data and examples rather than generic statements
Task 1: Company Research - Detailed Workflow
This document provides step-by-step instructions for executing Task 1 (Company Research) of the initiating-coverage skill.
Task Overview
Purpose: Research company's business, management, competitive position, industry, and risks.
Prerequisites: ✅ None (fully independent)
- Company name or ticker symbol only
Output: Company Research Document (6,000-8,000 words)
Data Sources to Gather
Primary Sources (Company)
SEC Filings (for public companies):
- Latest 10-K: Business description, risk factors, MD&A, financials
- Recent 10-Qs: Quarterly updates
- DEF 14A (Proxy): Executive compensation, board composition
- 8-Ks: Material events, acquisitions, management changes
Company Website & IR:
- Investor presentations
- Earnings transcripts (last 2-3 quarters)
- Press releases
- Product documentation
For Private Companies:
- Company website and blog
- Press releases and media coverage
- LinkedIn for management bios
- Crunchbase or PitchBook for funding history
Secondary Sources (Industry/Competitive)
- Competitor websites and SEC filings
- Industry research reports (Gartner, Forrester, IDC, etc.)
- News articles and trade publications
- Market research reports
- LinkedIn profiles for key executives
Key Information to Extract
Key Information:
- Company founding date, headquarters, employee count
- Revenue size and growth trajectory (if available)
- Product portfolio and pricing
- Customer segments and case studies
- Management backgrounds and track records
- Competitive landscape and market share
- Industry trends and growth drivers
- Regulatory considerations
- High-level financial metrics (from 10-K prose, not detailed extraction)
Step-by-Step Research Workflow
Step 1: Initial Data Collection
Start with company website
- Read About/Company pages
- Review product pages
- Identify customer case studies
- Note key metrics mentioned (employees, customers, etc.)
Gather SEC filings (if public)
- Download latest 10-K from SEC EDGAR
- Download most recent 10-Q
- Download latest DEF 14A (proxy statement)
- Note filing dates
Read earnings materials
- Latest earnings transcript
- Most recent investor presentation
- Press releases from last 12 months
Document basic facts
- Founding date and story
- Headquarters location
- Employee count
- Products/services
- Key customers
Step 2: Business Model Analysis
Map revenue streams
- What does the company sell?
- How is it priced? (subscription, transaction, license, etc.)
- Who pays?
- What are typical deal sizes?
Understand customer segments
- Enterprise vs. SMB vs. consumer
- Industries served
- Geographic distribution
- Customer concentration (top 10 customers)
Document go-to-market
- Direct sales vs. channel partners
- Sales cycle length
- Customer acquisition strategy
- Distribution model
Identify unit economics
- LTV/CAC if available
- Gross margins
- Net revenue retention
- Payback periods
Step 3: Management Research
For each of 3-4 key executives:
Identify key leaders
- CEO (always required)
- CFO (always required)
- COO, CTO, or other C-suite (2 additional)
Research each executive
- Find LinkedIn profile
- Review DEF 14A for background
- Search for press interviews
- Note tenure at company
Write 300-400 word bio including:
- Current role and responsibilities
- Prior roles and companies (last 2-3 positions)
- Key accomplishments and track record
- Education and credentials
- Years of experience in industry
- Time at current company
Assess governance
- Board composition and independence
- Key board members and their backgrounds
- Insider ownership percentage
- Executive compensation structure
Step 4: Competitive Intelligence
Identify 5-10 competitors
- Direct competitors (same products/markets)
- Indirect competitors (substitute solutions)
- Emerging competitors (disruptors)
- Check 10-K for company's own list of competitors
Research each competitor
- Visit competitor website
- Review their SEC filings (if public)
- Note key products and positioning
- Identify differentiators
- Estimate market share (if data available)
Create competitive framework
- Map on key dimensions (price, features, scale, etc.)
- Identify company's competitive advantages
- Note competitive vulnerabilities
- Assess switching costs and network effects
Document competitive insights
- Who are the market leaders?
- Where does this company rank?
- What are unique differentiators?
- What are competitive threats?
Step 5: Industry Analysis
Define the industry
- Industry classification (NAICS/SIC)
- Scope and boundaries
- Related/adjacent industries
Size the market
- Total addressable market (TAM)
- Serviceable addressable market (SAM)
- Serviceable obtainable market (SOM)
- Current penetration rate
Research growth drivers
- Historical market growth rate
- Projected growth rate (next 3-5 years)
- Key trends accelerating/decelerating growth
- Technology changes impacting industry
Understand industry structure
- Fragmented vs. consolidated
- Barriers to entry
- Supplier/buyer power
- Threat of substitutes
- Regulatory environment
Step 6: Risk Assessment
Identify 8-12 risks across four categories. For each risk, write 50-100 words.
Company-Specific Risks (4-6 risks):
- Execution risk (can management deliver?)
- Customer concentration (top customers)
- Key person dependency
- Product/technology obsolescence
- Geographic concentration
- Integration risk (if recent M&A)
Industry/Market Risks (3-4 risks):
- Competitive intensity
- Regulatory changes
- Technology disruption
- Market saturation
Financial Risks (2-3 risks):
- Profitability timeline
- Funding requirements
- Debt levels and covenants
- Cash burn rate (if unprofitable)
Macroeconomic Risks (2-3 risks):
- Economic sensitivity (cyclical vs. defensive)
- Interest rate sensitivity
- Foreign exchange exposure
- Geopolitical factors
For each risk:
- Describe the risk clearly
- Quantify impact if possible
- Note likelihood/severity
- Identify mitigating factors
Step 7: Synthesis and Writing
Write document following this structure:
Company Overview (800-1,200 words)
- What does the company do? (plain English)
- How do they make money? (business model)
- Where do they operate? (geographic presence)
- How large are they? (revenue, employees, customers)
- Key metrics and scale indicators
Company History (800-1,200 words)
- Founding story (who, when, why, where)
- Timeline of major milestones
- Strategic pivots or transformations
- Key acquisitions
- Recent developments (last 1-2 years)
Management Team (1,000-1,400 words)
- 300-400 word bio for each of 3-4 executives
- Board composition and governance
- Insider ownership
- Management track record assessment
Products & Services (700-1,000 words)
- Detailed product portfolio
- Key features and capabilities
- Product differentiation
- Target customers and use cases
- Pricing models and typical deal sizes
Customers & Go-to-Market (500-700 words)
- Customer segments and profiles
- Distribution channels
- Sales strategy and cycle
- Key partnerships
- Customer case studies
Industry Overview (800-1,200 words)
- Industry definition and scope
- Market size and structure
- Growth rates (historical and projected)
- Key trends and drivers
- Regulatory environment
- Industry dynamics
Competitive Landscape (700-1,000 words)
- Analysis of 5-10 key competitors
- Market positioning framework
- Company's competitive advantages
- Competitive vulnerabilities
- Market share analysis
Market Opportunity (500-700 words)
- TAM sizing and methodology
- Market growth projections
- Company's serviceable market
- Market share opportunity
- Penetration strategy
Risk Assessment (600-900 words)
- Company-specific risks (4-6)
- Industry/market risks (3-4)
- Financial risks (2-3)
- Macroeconomic risks (2-3)
- Each risk: 50-100 word description
Data Sources Section
- List all sources used
- Include dates and URLs
- Organize by source type
Quality Standards
Content Depth
- Each section must meet minimum word count targets
- Analysis should be substantive, not just descriptive
- Use specific examples and quantitative data
- Cite sources throughout
- Maintain objectivity and balance
Management Bios
- 300-400 words per executive for 3-4 key executives
- Must include: current role, prior experience, key accomplishments, education
- Provide enough detail to assess track record and capabilities
Competitive Analysis
- Must analyze 5-10 specific competitors
- Include both direct and indirect competitors
- Assess relative positioning on key dimensions
- Identify company's competitive advantages and vulnerabilities
- Use specific data and examples
Risk Assessment
- Must identify 8-12 distinct risks across all four categories
- Each risk needs 50-100 word description
- Quantify impact where possible
- Note mitigating factors
- Cover all four risk categories
Writing Quality
- Professional, analytical tone
- Lead with key insights
- Use concrete examples and data
- Avoid generic statements
- Proper citations throughout
Output Format
COMPANY RESEARCH REPORT: [Company Name]
Date: [Date]
Analyst: [Your name if applicable]
TABLE OF CONTENTS
1. Company Overview
2. Company History
3. Management Team
4. Products & Services
5. Customers & Go-to-Market
6. Industry Overview
7. Competitive Landscape
8. Market Opportunity (TAM)
9. Risk Assessment
======================================
1. COMPANY OVERVIEW (800-1,200 words)
[Content]
2. COMPANY HISTORY (800-1,200 words)
[Content]
3. MANAGEMENT TEAM (1,000-1,400 words)
[Name], [Title]
[300-400 word bio]
[Repeat for 3-4 key executives]
[Governance section]
4. PRODUCTS & SERVICES (700-1,000 words)
[Content]
5. CUSTOMERS & GO-TO-MARKET (500-700 words)
[Content]
6. INDUSTRY OVERVIEW (800-1,200 words)
[Content]
7. COMPETITIVE LANDSCAPE (700-1,000 words)
[Content]
8. MARKET OPPORTUNITY (500-700 words)
[Content]
9. RISK ASSESSMENT (600-900 words)
Company-Specific Risks:
[4-6 risks with descriptions]
Industry/Market Risks:
[3-4 risks with descriptions]
Financial Risks:
[2-3 risks with descriptions]
Macroeconomic Risks:
[2-3 risks with descriptions]
======================================
DATA SOURCES
[List all sources with dates and URLs]Success Criteria
A successful Task 1 completion should deliver:
- Meet 6,000-8,000 word target (verify word count)
- Include all 9 required sections with target word counts
- Provide substantive analysis, not just description
- Use specific examples and quantitative data
- Cite all sources properly
- Enable reader to understand:
- What the company does and how it makes money
- Quality and track record of management team
- Company's competitive position
- Market opportunity size
- Key risks to consider
File Naming Convention
Save the output as:
[Company]_Research_Document_[Date].md
Example: Tesla_Research_Document_2024-10-27.md
Next Steps
After completing Task 1, the research document will be used:
- As standalone company analysis
- As input for Task 2 (Financial Modeling) - provides business context for projections
- As input for Task 4 (Chart Generation) - provides data for company/competitive charts
- As foundation for Task 5 (Report Assembly) - Company 101 sections copied verbatim
Task 2: Financial Modeling - Detailed Workflow
This document provides step-by-step instructions for executing Task 2 (Financial Modeling) of the initiating-coverage skill.
Task Overview
Purpose: Extract historical financials and build comprehensive Excel financial model with projections and scenarios.
Prerequisites: ⚠️ Verify before starting
- Required: Access to company financial data
- For public companies: Latest 10-K and recent 10-Qs from SEC EDGAR
- For private companies: Financial statements or estimates from available sources
- OR: Pre-extracted historical financials provided by user
- Optional: Company research (Task 1) for business context
Output: Excel Financial Model (.xlsx) with 6 essential tabs:
- Revenue Model
- Income Statement
- Cash Flow Statement
- Balance Sheet
- Scenarios
- DCF Inputs
Input Verification
BEFORE STARTING - CHECK:
Option A: Extract financials directly (most common)
- Have access to 10-K filings (public company)?
- OR have access to financial statements (private company)?
- Ready to create Excel file for historical extraction?
Option B: User has pre-extracted financials
- Historical financials file provided? (.xlsx or other format)
- Contains 3-5 years of income statement, cash flow, balance sheet?
- Data is clean and ready to use?
Optional Context:
- Company research (Task 1) complete for business understanding?
IF VERIFICATION FAILS: Stop and obtain access to financial statements (10-K or equivalent) before proceeding.
Model Structure and Formatting
Color Coding (Industry Standard)
- Blue text: Hardcoded inputs (user can change)
- Black text: Formulas and calculations
- Green text: Links to other sheets
- Red text: Errors or flags (should be resolved)
Formatting Standards
- Professional borders and shading
- Clear section headers
- Grouped rows for collapsibility
- Named ranges for key inputs/outputs
- No hardcoded numbers in formulas (except constants like 12 months)
- Clear units ($ thousands, $ millions, etc.)
Formula Best Practices
- All numbers should flow from assumptions
- Change an assumption → entire model updates
- No circular references
- Use named ranges for key cells
- Keep formulas simple and auditable
- Add comments for complex calculations
Step-by-Step Modeling Workflow
Step 1: Extract Historical Financials
If historical financials are already extracted, skip to Step 2.
For Public Companies:
Download 10-K Filing
- Go to SEC EDGAR (https://www.sec.gov/edgar/searchedgar/companysearch.html)
- Search for company name or ticker
- Download latest 10-K (annual report)
- Navigate to Item 8: Financial Statements and Supplementary Data
Create Historical Financials Excel File
- File name:
[Company]_Historical_Financials_[Date].xlsx - This file will be the foundation for the model
- File name:
Extract Income Statement (3-5 years)
- Create Sheet 1: "Historical Income Statement"
- Extract ALL line items for 3-5 years:
- Revenue (total and by segment if disclosed)
- Cost of revenue / COGS
- Gross profit
- Operating expenses (R&D, Sales & Marketing, G&A broken out)
- EBITDA (calculate if not disclosed: EBIT + D&A)
- EBIT / Operating income
- Interest expense/income
- Other income/expense
- Pre-tax income
- Income tax and tax rate
- Net income
- EPS (basic and diluted)
- Shares outstanding (basic and diluted)
Extract Cash Flow Statement (3-5 years)
- Create Sheet 2: "Historical Cash Flow"
- Extract ALL line items:
- Operating activities (starting from net income)
- Depreciation & amortization
- Stock-based compensation
- Changes in working capital (receivables, inventory, payables)
- Cash from operations
- Investing activities (CapEx, acquisitions)
- Financing activities (debt issuance/repayment, equity, dividends)
- Net change in cash
- Beginning and ending cash
Extract Balance Sheet (3-5 years)
- Create Sheet 3: "Historical Balance Sheet"
- Extract ALL line items:
- Current assets (cash, receivables, inventory, other)
- Non-current assets (PP&E, intangibles, goodwill)
- Total assets
- Current liabilities (payables, accrued expenses, current debt)
- Non-current liabilities (long-term debt, deferred taxes)
- Total liabilities
- Shareholders' equity (common stock, retained earnings)
- Total liabilities + equity
Calculate Historical Metrics
- Create Sheet 4: "Historical Metrics"
- Calculate from statements:
- Revenue growth % (YoY)
- Gross margin %
- EBITDA margin %
- Operating margin %
- Net margin %
- Free cash flow (CFO - CapEx)
- FCF margin %
- ROIC (approximate: NOPAT / Invested Capital)
- Debt/Equity ratio
- Current ratio (Current Assets / Current Liabilities)
Document Sources and Notes
- Create Sheet 5: "Notes"
- Document:
- 10-K filing date and fiscal year end
- Any one-time items or adjustments noted
- Non-GAAP vs GAAP differences
- Segment breakdown (if revenue split by product/geography)
- Data quality notes and limitations
For Private Companies:
Gather Available Data
- Financial statements (if available)
- Press releases with revenue figures
- Funding announcements
- Industry estimates or comparable company data
Create Simplified Historical File
- Estimated revenue (if available)
- Estimated margins (from comparables if needed)
- Key ratios and metrics
- Document all assumptions and sources
Verification:
- All 3 financial statements extracted (3-5 years)
- Numbers reconcile across statements (net income ties)
- Key metrics calculated correctly
- Excel file saved and can be opened
- Data sources documented (10-K dates, page numbers)
Foundation for projection model is now complete. Proceed to Step 2.
- Capital expenditures
- Working capital items
- Debt and interest expense
- Share count (basic and diluted)
Organize historical data for entry
- Prepare 3-5 years of actuals
- Will be entered directly into Income Statement, Cash Flow Statement, and Balance Sheet tabs
- Historical years in columns, projected years following
Calculate historical trends
- Revenue CAGR
- Margin progression
- OpEx leverage
- Working capital patterns
- CapEx as % of revenue
- These trends will inform projection assumptions
Note: Assumptions will be documented directly in each tab as blue text inputs, not in a separate tab.
Step 2: Model Revenue
CRITICAL: This is the most important and detailed part of the model.
A. Revenue by Product/Category (20-30 rows)
Create detailed table:
2021A 2022A 2023A 2024A 2025E 2026E 2027E 2028E 2029E
Product Category A
Sub-product A1 XX XX XX XX XX XX XX XX XX
Sub-product A2 XX XX XX XX XX XX XX XX XX
Sub-product A3 XX XX XX XX XX XX XX XX XX
Category A Total XX XX XX XX XX XX XX XX XX
% of Total Rev X% X% X% X% X% X% X% X% X%
YoY Growth % - X% X% X% X% X% X% X% X%
Product Category B
[Similar structure]
[Continue for all product categories]
Services Revenue XX XX XX XX XX XX XX XX XX
Other Revenue XX XX XX XX XX XX XX XX XX
TOTAL REVENUE XX XX XX XX XX XX XX XX XX
Total Revenue Growth % - X% X% X% X% X% X% X% X%Key Requirements:
- Show absolute revenue ($M) for each category
- Calculate % of total revenue for each category
- Show YoY growth % for each category
- Must have granular sub-categories (not just 3-5 top-level categories)
- Show mix shift over time
- Link all projections to Assumptions tab
B. Revenue by Geography (15-20 rows)
Create detailed table:
2021A 2022A 2023A 2024A 2025E 2026E 2027E 2028E 2029E
North America
United States XX XX XX XX XX XX XX XX XX
Canada XX XX XX XX XX XX XX XX XX
Mexico XX XX XX XX XX XX XX XX XX
NA Total XX XX XX XX XX XX XX XX XX
% of Total X% X% X% X% X% X% X% X% X%
YoY Growth % - X% X% X% X% X% X% X% X%
Europe
UK XX XX XX XX XX XX XX XX XX
Germany XX XX XX XX XX XX XX XX XX
France XX XX XX XX XX XX XX XX XX
Other Europe XX XX XX XX XX XX XX XX XX
Europe Total XX XX XX XX XX XX XX XX XX
% of Total X% X% X% X% X% X% X% X% X%
YoY Growth % - X% X% X% X% X% X% X% X%
Asia-Pacific
[Similar structure]
Rest of World
[Similar structure]
TOTAL REVENUE XX XX XX XX XX XX XX XX XXVerification:
- Revenue by product total = Revenue by geography total = Total revenue
- All percentages sum to 100%
- Growth rates calculated correctly
C. Revenue by Channel (if applicable)
2021A 2022A 2023A 2024A 2025E 2026E 2027E 2028E 2029E
Direct Sales XX XX XX XX XX XX XX XX XX
E-commerce/Online XX XX XX XX XX XX XX XX XX
Wholesale/Partner XX XX XX XX XX XX XX XX XX
Retail Stores
Company-owned stores XX XX XX XX XX XX XX XX XX
Store count XX XX XX XX XX XX XX XX XX
Sales per store XX XX XX XX XX XX XX XX XX
Other Channels XX XX XX XX XX XX XX XX XX
TOTAL REVENUE XX XX XX XX XX XX XX XX XXStep 3: Model Operating Expenses
A. Cost of Revenue
Break down COGS components
- Product costs (materials, manufacturing)
- Shipping and logistics
- Service delivery costs
- Other direct costs
Link to revenue
- Calculate COGS as % of revenue
- Model gross margin by year
- Link to Assumptions tab
B. R&D Expenses
Research & Development 2021A 2022A 2023A 2024A 2025E 2026E 2027E 2028E 2029E
R&D Headcount XX XX XX XX XX XX XX XX XX
R&D Comp per head XX XX XX XX XX XX XX XX XX
R&D Personnel Costs XX XX XX XX XX XX XX XX XX
R&D Other Costs XX XX XX XX XX XX XX XX XX
Total R&D XX XX XX XX XX XX XX XX XX
% of Revenue X% X% X% X% X% X% X% X% X%C. Sales & Marketing Expenses
Sales & Marketing 2021A 2022A 2023A 2024A 2025E 2026E 2027E 2028E 2029E
S&M Headcount XX XX XX XX XX XX XX XX XX
S&M Comp per head XX XX XX XX XX XX XX XX XX
S&M Personnel Costs XX XX XX XX XX XX XX XX XX
Marketing Spend XX XX XX XX XX XX XX XX XX
S&M Other Costs XX XX XX XX XX XX XX XX XX
Total S&M XX XX XX XX XX XX XX XX XX
% of Revenue X% X% X% X% X% X% X% X% X%D. General & Administrative
G&A 2021A 2022A 2023A 2024A 2025E 2026E 2027E 2028E 2029E
G&A Headcount XX XX XX XX XX XX XX XX XX
G&A Comp per head XX XX XX XX XX XX XX XX XX
G&A Personnel Costs XX XX XX XX XX XX XX XX XX
G&A Other Costs XX XX XX XX XX XX XX XX XX
Total G&A XX XX XX XX XX XX XX XX XX
% of Revenue X% X% X% X% X% X% X% X% X%E. Depreciation & Amortization
- Link to CapEx schedule
- Apply depreciation rates from Assumptions
- Calculate annual D&A
Step 4: Build Income Statement
Create full P&L with 40-50 line items:
INCOME STATEMENT 2021A 2022A 2023A 2024A 2025E 2026E 2027E 2028E 2029E
REVENUE
[Link to Revenue Model tab]
Total Revenue XX XX XX XX XX XX XX XX XX
YoY Growth % - X% X% X% X% X% X% X% X%
COST OF REVENUE
[Link to COGS breakdown]
Total COGS XX XX XX XX XX XX XX XX XX
GROSS PROFIT XX XX XX XX XX XX XX XX XX
Gross Margin % X% X% X% X% X% X% X% X% X%
OPERATING EXPENSES
Total R&D XX XX XX XX XX XX XX XX XX
% of Revenue X% X% X% X% X% X% X% X% X%
Total S&M XX XX XX XX XX XX XX XX XX
% of Revenue X% X% X% X% X% X% X% X% X%
Total G&A XX XX XX XX XX XX XX XX XX
% of Revenue X% X% X% X% X% X% X% X% X%
Depreciation & Amort. XX XX XX XX XX XX XX XX XX
Total Operating Exp. XX XX XX XX XX XX XX XX XX
% of Revenue X% X% X% X% X% X% X% X% X%
EBITDA XX XX XX XX XX XX XX XX XX
EBITDA Margin % X% X% X% X% X% X% X% X% X%
EBIT XX XX XX XX XX XX XX XX XX
EBIT Margin % X% X% X% X% X% X% X% X% X%
Interest expense (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Interest income XX XX XX XX XX XX XX XX XX
Other income/(expense) XX XX XX XX XX XX XX XX XX
Pre-tax income XX XX XX XX XX XX XX XX XX
Income tax (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Tax rate % X% X% X% X% X% X% X% X% X%
NET INCOME XX XX XX XX XX XX XX XX XX
Net Margin % X% X% X% X% X% X% X% X% X%
SHARES OUTSTANDING
Basic shares (M) XX XX XX XX XX XX XX XX XX
Diluted shares (M) XX XX XX XX XX XX XX XX XX
EARNINGS PER SHARE
Basic EPS $X.XX $X.XX $X.XX $X.XX $X.XX $X.XX $X.XX $X.XX $X.XX
Diluted EPS $X.XX $X.XX $X.XX $X.XX $X.XX $X.XX $X.XX $X.XX $X.XXStep 5: Build Cash Flow Statement
CASH FLOW STATEMENT 2021A 2022A 2023A 2024A 2025E 2026E 2027E 2028E 2029E
OPERATING ACTIVITIES
Net Income XX XX XX XX XX XX XX XX XX
Adjustments:
Depreciation & Amort. XX XX XX XX XX XX XX XX XX
Stock-based comp XX XX XX XX XX XX XX XX XX
Other non-cash XX XX XX XX XX XX XX XX XX
Changes in WC:
Accounts Receivable (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Inventory (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Accounts Payable XX XX XX XX XX XX XX XX XX
Other working capital (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Cash from Operations XX XX XX XX XX XX XX XX XX
INVESTING ACTIVITIES
Capital Expenditures (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Acquisitions (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Other investing XX XX XX XX XX XX XX XX XX
Cash from Investing (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
FREE CASH FLOW XX XX XX XX XX XX XX XX XX
FCF Margin % X% X% X% X% X% X% X% X% X%
FINANCING ACTIVITIES
Debt issuance XX XX XX XX XX XX XX XX XX
Debt repayment (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Equity issuance XX XX XX XX XX XX XX XX XX
Dividends paid (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Other financing XX XX XX XX XX XX XX XX XX
Cash from Financing XX XX XX XX XX XX XX XX XX
NET CHANGE IN CASH XX XX XX XX XX XX XX XX XX
Beginning Cash XX XX XX XX XX XX XX XX XX
Ending Cash XX XX XX XX XX XX XX XX XXStep 6: Build Balance Sheet
Create full balance sheet with 35-45 line items:
BALANCE SHEET 2021A 2022A 2023A 2024A 2025E 2026E 2027E 2028E 2029E
ASSETS
Current Assets:
Cash & Equivalents XX XX XX XX XX XX XX XX XX
Accounts Receivable XX XX XX XX XX XX XX XX XX
Inventory XX XX XX XX XX XX XX XX XX
Prepaid expenses XX XX XX XX XX XX XX XX XX
Other current assets XX XX XX XX XX XX XX XX XX
Total Current Assets XX XX XX XX XX XX XX XX XX
Non-Current Assets:
PP&E, gross XX XX XX XX XX XX XX XX XX
Accumulated Depr. (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
PP&E, net XX XX XX XX XX XX XX XX XX
Intangible assets XX XX XX XX XX XX XX XX XX
Goodwill XX XX XX XX XX XX XX XX XX
Other non-current XX XX XX XX XX XX XX XX XX
Total Non-Current XX XX XX XX XX XX XX XX XX
TOTAL ASSETS XX XX XX XX XX XX XX XX XX
LIABILITIES
Current Liabilities:
Accounts Payable XX XX XX XX XX XX XX XX XX
Accrued expenses XX XX XX XX XX XX XX XX XX
Deferred revenue XX XX XX XX XX XX XX XX XX
Current debt XX XX XX XX XX XX XX XX XX
Other current liab. XX XX XX XX XX XX XX XX XX
Total Current Liab. XX XX XX XX XX XX XX XX XX
Non-Current Liabilities:
Long-term debt XX XX XX XX XX XX XX XX XX
Deferred taxes XX XX XX XX XX XX XX XX XX
Other non-current XX XX XX XX XX XX XX XX XX
Total Non-Current Liab. XX XX XX XX XX XX XX XX XX
TOTAL LIABILITIES XX XX XX XX XX XX XX XX XX
EQUITY
Common stock XX XX XX XX XX XX XX XX XX
Additional paid-in XX XX XX XX XX XX XX XX XX
Retained earnings XX XX XX XX XX XX XX XX XX
Treasury stock (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX) (XX)
Other equity XX XX XX XX XX XX XX XX XX
TOTAL EQUITY XX XX XX XX XX XX XX XX XX
TOTAL LIAB + EQUITY XX XX XX XX XX XX XX XX XX
BALANCE CHECK OK OK OK OK OK OK OK OK OKBalance Check Formula:
- Total Assets must equal Total Liabilities + Equity for each year
- Flag any imbalances in red
Step 7: Build DCF Inputs Tab
Prepare inputs for valuation (Task 3):
DCF INPUTS 2025E 2026E 2027E 2028E 2029E
EBIT XX XX XX XX XX
Tax Rate X% X% X% X% X%
NOPAT XX XX XX XX XX
Add: D&A XX XX XX XX XX
Less: CapEx (XX) (XX) (XX) (XX) (XX)
Less: Chg in NWC (XX) (XX) (XX) (XX) (XX)
UNLEVERED FCF XX XX XX XX XX
Terminal Year Metrics:
2029E Revenue $X,XXX
2029E EBITDA $XXX
2029E EBIT $XXX
2029E Unlevered FCF $XXXStep 8: Build Scenarios Tab
Create three scenarios with different assumptions:
Scenario Assumptions Table
Assumption Bull Base Bear
Revenue CAGR (2025-2029) XX% XX% XX%
Gross Margin 2029E XX% XX% XX%
EBITDA Margin 2029E XX% XX% XX%
CapEx as % of Revenue X% X% X%
[Add other key assumptions]Scenario Output Table
Metric Bull Base Bear
2029E Revenue ($M) $X,XXX $X,XXX $X,XXX
2029E EBITDA ($M) $XXX $XXX $XXX
2029E EBITDA Margin XX% XX% XX%
2029E Net Income ($M) $XXX $XXX $XXX
2029E EPS $X.XX $X.XX $X.XX
2029E FCF ($M) $XXX $XXX $XXX
2029E FCF Margin XX% XX% XX%
Cumulative FCF 2025-2029 ($M) $XXX $XXX $XXXDocument scenario rationale:
- Bull case: [Describe optimistic but achievable assumptions]
- Base case: [Describe most likely scenario]
- Bear case: [Describe downside risks and triggers]
Step 9: Quality Check
Verify model integrity:
- Test all formulas (spot check calculations)
- Change assumption → verify model updates correctly
- Test scenario switching
- Verify color coding (blue/black/green)
- Check balance sheet balances for all years
- Verify no circular references (Excel will flag)
- Check for hardcoded numbers in projections
- Verify all cross-sheet links work
- Test that revenue totals tie across all tabs
- Review formatting and presentation
Quality Standards
Model Integrity
- All formulas link properly across sheets
- No hardcoded numbers in projections (except in Assumptions tab)
- No circular references
- Balance sheet balances for all years
- Scenario switching works properly
Completeness
- All 6 essential tabs: Revenue Model, Income Statement, Cash Flow Statement, Balance Sheet, Scenarios, DCF Inputs
- 40-50 line items in Income Statement
- 20-30 rows in Revenue Model (product breakdown)
- 15-20 rows in Revenue Model (geography breakdown)
- Full cash flow and balance sheet with all line items
- Bull/Base/Bear scenarios complete
Professional Formatting
- Consistent color coding (blue/black/green)
- Clear headers and labels
- Proper borders and shading
- Named ranges for key cells
- Grouped rows for collapsibility
- Units clearly labeled ($ thousands vs. $ millions)
Documentation
- Assumptions documented with rationale (blue text cells with comments)
- Data sources noted in cell comments or notes section within tabs
- Complex calculations explained with comments
- Methodology described
File Naming Convention
Save the financial model as:
[Company]_Financial_Model_[Date].xlsx
Example: Tesla_Financial_Model_2024-10-27.xlsx
Success Criteria
A successful financial model should:
- Have all 6 essential tabs (Revenue Model, Income Statement, Cash Flow Statement, Balance Sheet, Scenarios, DCF Inputs)
- Be fully dynamic (change assumption → model updates)
- Have no hardcoded numbers in projections
- Include detailed revenue breakdowns (20-30 rows by product, 15-20 rows by geography)
- Contain 40-50 line items in Income Statement
- Include Bull/Base/Bear scenarios
- Be professionally formatted with color coding
- Balance properly (balance sheet, cash flows)
- Be auditable and easy to follow
- Support valuation analysis with proper FCF calculations
Common Model Types - Special Considerations
High-Growth Tech/SaaS
- Focus on ARR growth and net retention
- Model by product line and geography
- Heavy R&D and S&M spend
- Path to profitability timeline
- Unit economics (LTV/CAC)
E-commerce/Retail
- Revenue by product category and channel
- Store count and comp store growth (if applicable)
- Inventory turns and working capital
- Fulfillment costs
- Customer acquisition
Manufacturing/Industrial
- Production capacity utilization
- Raw material costs and pricing
- Gross margin bridge (volume/price/mix/cost)
- CapEx heavy models
- Working capital cycles
Next Steps
After completing Task 2, the financial model will be used for:
- Task 3 (Valuation): DCF inputs, projected financials
- Task 4 (Charts): Data for revenue trends, margin charts, scenario comparisons
- Task 5 (Report Assembly): Financial data for report tables and analysis
Task 3: Valuation Analysis - Detailed Workflow
This document provides step-by-step instructions for executing Task 3 (Valuation Analysis) of the initiating-coverage skill.
Task Overview
Purpose: Perform comprehensive valuation using DCF, comparables, and precedent transactions.
Prerequisites: ⚠️ Verify before starting
- Required: Financial model from Task 2
- Projected income statements
- Projected cash flows
- Revenue and EBITDA forecasts
- DCF inputs (unlevered FCF)
⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASK 2 IS COMPLETE
This task requires the financial model from Task 2. Starting without it will result in incomplete work.
IF TASK 2 IS NOT COMPLETE: Stop immediately and inform the user that Task 2 (Financial Modeling) must be completed first. Do not attempt to proceed or create placeholder valuations.
Output: Valuation Analysis (4-6 pages + Excel tabs)
- DCF analysis with sensitivity tables
- Comparable companies analysis
- Precedent transactions (if applicable)
- Valuation football field
- Price target and recommendation
Input Verification
BEFORE STARTING - CHECK:
- Task 2 complete? (Financial model exists)
- Model file path/location known?
- Can access projected financials from model?
Required from model:
- Projected FCF (5 years)
- Revenue projections
- EBITDA projections
- Terminal year metrics
- Balance sheet data (debt, cash, shares)
IF VERIFICATION FAILS: Stop and complete Task 2 (Financial Modeling) before proceeding.
Detailed Methodology Reference
For deep dive on valuation methodologies, formulas, and theory, see: valuation-methodologies.md
This workflow document focuses on execution steps. Reference the methodology file for:
- DCF theory and formulas
- WACC calculation details
- Terminal value methods
- Comparable companies theory
- Precedent transactions theory
Step-by-Step Valuation Workflow
Step 1: Extract Data from Financial Model
From Task 2's financial model, extract:
Projected Financials (5 years)
- Revenue by year (2025E-2029E)
- EBITDA by year
- EBIT by year
- Tax rate
- D&A by year
- CapEx by year
- Change in NWC by year
Unlevered Free Cash Flow
Extract from DCF Inputs tab in financial model: 2025E 2026E 2027E 2028E 2029E EBIT $XXX $XXX $XXX $XXX $XXX × (1 - Tax Rate) = NOPAT $XXX $XXX $XXX $XXX $XXX + D&A $XXX $XXX $XXX $XXX $XXX - CapEx ($XX) ($XX) ($XX) ($XX) ($XX) - Chg in NWC ($XX) ($XX) ($XX) ($XX) ($XX) = Unlevered FCF $XXX $XXX $XXX $XXX $XXXBalance Sheet Data (current)
- Total debt
- Cash & equivalents
- Net debt (Debt - Cash)
- Diluted shares outstanding
Scenario Data
- Bull case revenue CAGR and terminal margin
- Base case revenue CAGR and terminal margin
- Bear case revenue CAGR and terminal margin
Step 2: Build DCF Analysis
A. Calculate WACC
1. Determine Risk-Free Rate
- Use 10-year Treasury yield (check current rate)
- Example: 4.0-4.5% as of late 2024
2. Determine Cost of Equity (CAPM)
Cost of Equity = Risk-Free Rate + Beta × Equity Risk Premium
Inputs:
- Risk-Free Rate: [Current 10-year Treasury, e.g., 4.2%]
- Beta: [Company beta from Bloomberg/FactSet or peer average]
- Equity Risk Premium: 5-6% (historical average)
Example:
Cost of Equity = 4.2% + 1.3 × 5.5% = 11.35%3. Determine Cost of Debt
Cost of Debt = Current borrowing rate or implied yield on bonds
For private companies:
Cost of Debt = Risk-Free Rate + Credit Spread (based on rating)
Example:
Cost of Debt (pre-tax) = 6.5%
Cost of Debt (after-tax) = 6.5% × (1 - 25% tax rate) = 4.875%4. Determine Capital Structure
Use market values (not book values):
Market Value of Equity (E) = Share Price × Shares Outstanding
Market Value of Debt (D) = Total Debt (use book value if bonds not traded)
Total Value (V) = E + D
Weight of Equity = E / V
Weight of Debt = D / V
Example:
E = $5,000M (90.9%)
D = $500M (9.1%)
V = $5,500M (100%)5. Calculate WACC
WACC = (E/V × Cost of Equity) + (D/V × Cost of Debt × (1 - Tax Rate))
Example:
WACC = (90.9% × 11.35%) + (9.1% × 6.5% × (1 - 25%))
WACC = 10.32% + 0.44% = 10.76%
Round to: 10.8% for base caseB. Calculate Terminal Value
Method 1: Perpetuity Growth (Preferred)
Terminal Value = FCF(2029) × (1 + g) / (WACC - g)
Where:
- FCF(2029) = Final year unlevered FCF from model
- g = Perpetual growth rate (typically 2.0-3.0%)
- Should not exceed long-term GDP growth
- Use 2.5% as base case
Example:
FCF(2029) = $500M
g = 2.5%
WACC = 10.8%
Terminal Value = $500M × (1.025) / (0.108 - 0.025)
Terminal Value = $512.5M / 0.083 = $6,175MMethod 2: Exit Multiple (Alternative)
Terminal Value = EBITDA(2029) × Exit Multiple
Where:
- Exit Multiple = Current peer trading median (e.g., 12-15x EBITDA)
Example:
EBITDA(2029) = $800M
Exit Multiple = 13x
Terminal Value = $800M × 13x = $10,400MChoose one method or average both.
C. Discount Cash Flows to Present Value
PV of Projected FCF = Σ [FCFt / (1 + WACC)^t] for t = 1 to 5
Example:
Year FCF Discount PV of FCF
($M) Factor ($M)
2025 $250 1/(1.108)^1 = 0.9026 $226
2026 $320 1/(1.108)^2 = 0.8147 $261
2027 $390 1/(1.108)^3 = 0.7353 $287
2028 $450 1/(1.108)^4 = 0.6636 $299
2029 $500 1/(1.108)^5 = 0.5988 $299
Total PV: $1,372M
PV of Terminal Value = Terminal Value / (1 + WACC)^5
PV of Terminal Value = $6,175M / (1.108)^5 = $6,175M × 0.5988 = $3,697M
Enterprise Value = $1,372M + $3,697M = $5,069MD. Calculate Equity Value and Price Per Share
Enterprise Value $5,069M
- Net Debt (Debt - Cash) ($450M)
+ Non-operating Assets $0M
- Minority Interest $0M
- Preferred Stock $0M
= Equity Value $4,619M
Diluted Shares Outstanding 100M
Price Per Share = $4,619M / 100M = $46.19
Current Stock Price: $42.00
Implied Upside: 10.0%E. DCF Sensitivity Analysis CRITICAL
Table 1: WACC vs. Terminal Growth Rate
Create 2-way sensitivity table:
Price Per Share ($) Terminal Growth Rate
WACC 1.5% 2.0% 2.5% 3.0% 3.5%
9.0% $52 $55 $59 $63 $68
9.5% $48 $51 $54 $58 $62
10.0% $45 $48 $51 $54 $57
10.5% $42 $45 $47 $50 $53
11.0% $40 $42 $44 $47 $50
11.5% $38 $40 $42 $44 $47
12.0% $36 $38 $40 $42 $44
Base Case: WACC = 10.8%, g = 2.5% → $46
Format as heatmap: Green (high values) → Yellow → Red (low values)Table 2: Revenue CAGR vs. Terminal EBITDA Margin
Price Per Share ($) Terminal EBITDA Margin (2029E)
Revenue CAGR 28% 30% 32% 34% 36%
15% $38 $42 $46 $50 $54
20% $42 $46 $51 $56 $61
25% $46 $51 $56 $62 $68
30% $51 $56 $62 $68 $75
35% $56 $62 $68 $75 $83
Base Case: Rev CAGR = 25%, EBITDA Margin = 32% → $56Step 3: Comparable Companies Analysis
A. Select Comparable Companies
Selection Criteria:
- Same industry/sector (primary requirement)
- Similar business model
- Comparable size (market cap, revenue)
- Similar growth profile
- Similar geographies
Identify 5-10 peer companies:
- [Peer 1] - Direct competitor
- [Peer 2] - Direct competitor
- [Peer 3] - Adjacent player
- [Peer 4] - Similar business model
- [Peer 5] - Regional competitor
- [Add 3-5 more]
Document rationale for each peer selected.
B. Gather Peer Financial Data
For each comparable, gather:
- Current stock price
- Shares outstanding (diluted)
- Market capitalization
- Total debt and cash (for EV calculation)
- Enterprise value
- LTM (Last Twelve Months) financials:
- Revenue
- EBITDA
- EBIT
- Net Income
- NTM (Next Twelve Months) consensus estimates
- Revenue growth rate
- EBITDA margin
Data sources:
- FactSet, CapitalIQ, Bloomberg (preferred)
- Company 10-Ks/10-Qs for actuals
- Consensus estimates from Yahoo Finance, Seeking Alpha (if pro tools unavailable)
C. Calculate Valuation Multiples
For each peer, calculate:
EV/Revenue (LTM) = Enterprise Value / LTM Revenue
EV/Revenue (NTM) = Enterprise Value / NTM Revenue (est.)
EV/EBITDA (LTM) = Enterprise Value / LTM EBITDA
EV/EBITDA (NTM) = Enterprise Value / NTM EBITDA (est.)
P/E (NTM) = Market Cap / NTM Net Income (est.)D. Create Comparable Companies Table (MANDATORY FORMAT)
COMPARABLE COMPANIES ANALYSIS
Company Ticker Mkt Cap EV/Rev EV/Rev EV/EBITDA EV/EBITDA P/E Rev EBITDA
($B) LTM NTM LTM NTM NTM Growth Margin
Peer A PRA 45.2 3.5x 3.2x 15.2x 13.8x 25x 18% 23%
Peer B PRB 32.8 3.2x 2.9x 14.1x 12.5x 22x 15% 23%
Peer C PRC 28.5 2.8x 2.6x 12.8x 11.2x 20x 12% 22%
Peer D PRD 52.1 4.1x 3.7x 17.5x 15.2x 29x 22% 23%
Peer E PRE 38.9 3.6x 3.3x 15.8x 14.1x 25x 17% 23%
Peer F PRF 41.2 3.7x 3.4x 16.1x 13.9x 26x 19% 23%
Peer G PRG 35.5 3.3x 3.0x 14.5x 12.8x 23x 16% 22%
[Target] TRGT 38.0 3.4x 3.1x 14.8x 13.0x 24x 17% 23%
STATISTICAL SUMMARY
Maximum 52.1 4.1x 3.7x 17.5x 15.2x 29x 22% 23%
75th Percentile 45.2 3.7x 3.4x 16.1x 14.1x 26x 19% 23%
Median 38.9 3.5x 3.2x 15.2x 13.8x 25x 17% 23%
25th Percentile 32.8 3.2x 2.9x 14.1x 12.5x 22x 15% 22%
Minimum 28.5 2.8x 2.6x 12.8x 11.2x 20x 12% 22%
Note: Market data as of [Date]. LTM = Last Twelve Months. NTM = Next Twelve Months.
Source: FactSet, company filings, [Analyst] estimates.CRITICAL: The statistical summary (max/75th/median/25th/min) is MANDATORY.
E. Apply Multiples to Target Company
Choose primary multiple (typically EV/EBITDA for mature companies):
Target Company NTM EBITDA = $550M (from financial model)
Apply Median Peer Multiple:
Peer Median EV/EBITDA (NTM) = 13.8x
Implied EV = $550M × 13.8x = $7,590M
Apply 25th Percentile (Conservative):
25th Percentile EV/EBITDA (NTM) = 12.5x
Implied EV = $550M × 12.5x = $6,875M
Apply 75th Percentile (Optimistic):
75th Percentile EV/EBITDA (NTM) = 14.1x
Implied EV = $550M × 14.1x = $7,755M
Valuation Range (Comps): $6,875M - $7,755M
Midpoint: $7,315M
Convert to Equity Value:
Implied EV (Median) $7,590M
- Net Debt ($450M)
= Implied Equity Value $7,140M
Shares Outstanding 100M
Implied Price/Share $71.40Justify Premium/Discount:
- Target is growing 17% vs. peer median 17% → In-line
- Target EBITDA margin 23% vs. peer median 23% → In-line
- Target market position → [Justify premium/discount]
- Conclusion: Apply median multiple (no adjustment)
Step 4: Precedent Transactions (Optional)
Note: Only if M&A is relevant for this sector/company.
A. Identify Relevant Transactions
Search for 5-10 M&A deals:
- Same industry, last 3-5 years
- Similar size (0.5x to 2x target's size)
- Announced and closed deals
Example:
PRECEDENT TRANSACTIONS ANALYSIS
Date Target Acquirer Deal EV/Rev EV/EBITDA Premium Rationale
Value($B) LTM LTM
Q1 2024 Comp A Strategic $5.2B 4.2x 16.5x 35% Consolidation
Q3 2023 Comp B PE Firm $3.8B 3.8x 14.2x 28% Platform
Q4 2023 Comp C Strategic $4.5B 4.0x 15.8x 32% Geographic
Q2 2023 Comp D Strategic $6.1B 4.5x 17.2x 38% Strategic fit
Q1 2023 Comp E PE Firm $3.2B 3.5x 13.5x 25% Carve-out
Median 4.0x 15.8x 32%
Source: CapitalIQ, company filings, press releases.B. Apply to Target Company
Target Company LTM EBITDA = $500M
Precedent Median EV/EBITDA (LTM) = 15.8x
Implied EV (Precedent) = $500M × 15.8x = $7,900M
Note: Precedent multiples typically 10-20% higher than trading comps
due to control premium and synergies.Step 5: Valuation Reconciliation
A. Create Valuation Summary Table
VALUATION SUMMARY
Method Low Base High Weight Weighted Value
DCF Analysis $42 $46 $51 50% $23.00
Trading Comps (NTM) $64 $71 $78 40% $28.40
Precedent Trans. $70 $79 $88 10% $7.90
-------
Weighted Average Target 100% $59.30
Rounded Price Target: $59.00
Current Price (as of [Date]): $42.00
Upside to Target: 40% ($59.00 / $42.00 - 1)B. Determine Weighting Rationale
Typical Weighting:
- DCF: 40-60% (higher when forecasts reliable)
- Trading Comps: 25-40% (reflects market sentiment)
- Precedent Trans: 10-25% (lower unless M&A likely)
For this example:
- DCF 50%: High confidence in projections
- Comps 40%: Robust peer set
- Precedent 10%: M&A unlikely near-term
C. Create Valuation Football Field Chart
VALUATION FOOTBALL FIELD
Method Low ◄────────── Range ──────────► High
DCF Analysis $42 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $51
Trading Comps (NTM) $64 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $78
Precedent Trans. $70 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $88
↑
Current: $42
─────────────────────────────────────────────────────────
Valuation Range $42 $88
Price Target: $59 (weighted average)
Color code:
- DCF: Blue
- Trading Comps: Green
- Precedent Trans: Orange
- Vertical line at current price: Red dashed
- Vertical line at target: Black solidD. Scenario-Based Valuations
VALUATION BY SCENARIO
Scenario Probability Revenue EBITDA DCF Comps Weighted
CAGR Margin Value Multiple Avg
Bear Case 20% 18% 28% $38 11.5x $42
Base Case 60% 25% 32% $46 13.8x $59
Bull Case 20% 32% 36% $58 16.0x $82
Expected Value (probability-weighted): $59Step 6: Final Price Target & Recommendation
═══════════════════════════════════════════════════════════
INVESTMENT RECOMMENDATION
═══════════════════════════════════════════════════════════
Current Price: $42.00 (as of [Date])
Price Target: $59.00 (12-month)
Upside/(Downside): +40.5%
Rating: BUY / OUTPERFORM
Valuation Methodology: Based on weighted average of DCF (50%),
trading comparables (40%), and precedent
transactions (10%).
Time Horizon: 12 months
───────────────────────────────────────────────────────────
KEY INVESTMENT CATALYSTS
───────────────────────────────────────────────────────────
1. New Product Launch (Q2 2025)
- Expected to drive 15-20% revenue acceleration
- Already seeing strong pre-orders
2. Margin Expansion (FY2025-2026)
- Operating leverage from scale
- Path to 35% EBITDA margin (from current 28%)
3. Market Share Gains (Ongoing)
- Taking share from legacy competitors
- Net Promoter Score improvement
4. International Expansion (H2 2025)
- Entry into European markets
- Potential $200M incremental revenue opportunity
5. Potential M&A Target (12-18 months)
- Strategic fit for larger players
- Precedent transactions suggest 30-40% premium
───────────────────────────────────────────────────────────
KEY RISKS TO PRICE TARGET
───────────────────────────────────────────────────────────
Downside Risks:
1. Competitive Pressure (High probability, -15% impact)
- New entrant launched competing product
- Could pressure pricing and market share
2. Execution Risk (Medium probability, -10% impact)
- New product launch delays or underperformance
- Management turnover
3. Macro Slowdown (Medium probability, -20% impact)
- Economic recession would impact customer spending
- Operating leverage would reverse
4. Regulatory Risk (Low probability, -25% impact)
- Potential new regulations in key market
- Would increase compliance costs
Upside Risks:
1. M&A Bid (Low probability, +35% impact)
- Strategic acquirer pays control premium
2. Beat-and-Raise (Medium probability, +10% impact)
- Consistent outperformance vs. estimates
═══════════════════════════════════════════════════════════Quality Standards
DCF Quality Checks
- WACC properly calculated with documented components
- Terminal value reasonable (< 70% of total enterprise value)
- Sensitivity analysis covers realistic ranges (±200-300bps for WACC, ±100bps for terminal growth)
- Unlevered FCF properly calculated from EBIT
- Enterprise to equity value bridge correct
- Share count is diluted shares, not basic
Comparables Quality Checks
- 5-10 comparable companies selected
- Peer selection defensible (document why each peer was chosen)
- Statistical summary included (max/75th/median/25th/min) - MANDATORY
- Multiple selection appropriate (EV/EBITDA for mature, EV/Revenue for high-growth)
- Premium/discount justified with specific factors
- Data sourced properly with dates noted
Overall Valuation Quality Checks
- At least 2 valuation methods used (DCF + Comps minimum)
- Weighting explained and appropriate
- Valuation range provided (low/base/high), not just point estimate
- Scenarios analyzed (Bull/Base/Bear)
- Sanity checks performed (see below)
- All assumptions documented with rationale
Sanity Checks
Always perform these validation checks:
Historical Multiple Check
- Is implied multiple in line with company's historical trading range?
- If not, explain why
Peer Comparison
- Is premium/discount vs. peers justified by fundamentals?
- Check: growth, margins, market position
Implied Growth Check
- What growth is market pricing in at current price?
- Is that reasonable given company trajectory?
Market Cap Reasonableness
- Does total market cap make sense given company size and peers?
- Would company be too large/small relative to industry?
Terminal Value Check
- Is terminal value < 60-70% of total enterprise value?
- If > 70%, projections may not be long enough
WACC Reasonableness
- Is WACC 8-14% range for typical companies?
- Tech/high-growth: 10-14%
- Mature/stable: 7-10%
Implied Returns Check
- What IRR from current price to target over 12 months?
- Is that consistent with recommendation rating?
Output Files
Create the following deliverables:
1. Valuation Analysis Document
File: [Company]_Valuation_Analysis_[Date].md (written analysis)
Contents (4-6 pages):
- Executive summary with price target
- DCF analysis (1 page) with sensitivity table
- Comparable companies analysis (1 page) with statistical summary
- Precedent transactions (0.5 page) if applicable
- Valuation summary and football field (0.5 page)
- Investment recommendation (1 page)
- Key catalysts and risks (1 page)
2. Excel Valuation Tabs
Add to Task 2's financial model file: [Company]_Financial_Model_[Date].xlsx
IMPORTANT: Do NOT create a separate Excel file. Add these tabs to the existing financial model from Task 2. This keeps all quantitative data in one place.
Tabs to add:
- DCF tab with full calculations
- Sensitivity analysis tab
- Comps tab with peer data
- Precedent transactions tab (if applicable)
- Valuation summary tab
Success Criteria
A successful valuation analysis should:
- Use at least 2 methods (DCF + Comps minimum)
- Include comprehensive DCF sensitivity analysis (2-way tables)
- Include statistical summary in comps (max/75th/median/25th/min)
- Provide valuation range (low/base/high), not point estimate
- Document all key assumptions with clear rationale
- Perform sanity checks
- Arrive at defensible price target
- Provide clear buy/hold/sell recommendation
- Identify 3-5 key catalysts
- Identify 3-5 key risks
- Be auditable and transparent
Next Steps
After completing Task 3, the valuation analysis will be used for:
- Task 4 (Charts): Create DCF sensitivity heatmaps, valuation football field, scenario comparison charts
- Task 5 (Report Assembly): Integrate valuation analysis into final report
The price target and recommendation are the foundation of the final investment recommendation in the equity research report.
Task 4: Chart Generation - Detailed Workflow
This document provides step-by-step instructions for executing Task 4 (Chart Generation) of the initiating-coverage skill.
Task Overview
Purpose: Generate 25-35 professional financial charts for the report.
Prerequisites: ⚠️ Verify before starting
- Required: Company research from Task 1
- Company history, milestones (for timeline charts)
- Management team, org structure (for org charts)
- Product portfolio (for product charts)
- Customer segmentation (for customer charts)
- Competitive landscape (for competitive positioning charts)
- TAM analysis (for market size charts)
- Required: Financial model from Task 2
- Revenue by product/geography data
- Margin trends
- Scenario comparison data
- Required: Valuation analysis from Task 3
- DCF sensitivity table
- Comparable companies data
- Valuation ranges
- Required: External market data
- Historical stock price data (Yahoo Finance, Bloomberg)
- Historical valuation multiples (optional for chart 34)
⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASKS 1, 2, AND 3 ARE COMPLETE
This task requires outputs from all three previous tasks. Starting without them will result in incomplete charts.
IF ANY OF TASKS 1, 2, OR 3 ARE NOT COMPLETE: Stop immediately and inform the user which tasks need to be completed first. The specific requirements are:
- Task 1: Company research document (for 9 charts)
- Task 2: Financial model with all 6 tabs (for 8 charts)
- Task 3: Valuation tabs added to the model (for 6 charts)
- External data access (for 2 charts)
Do not attempt to create placeholder charts or skip charts due to missing data.
Output: 25-35 Professional Chart Files (PNG/JPG, 300 DPI)
Input Verification
BEFORE STARTING - CHECK ALL PREREQUISITES:
Task 1 Verification (Company Research)
- Task 1 complete? (Company research document exists)
- Company history and milestones documented? (for charts 05, 06)
- Management team and org structure described? (for chart 07)
- Product portfolio detailed? (for chart 08)
- Customer segmentation analyzed? (for chart 09)
- Competitive landscape mapped? (for charts 16, 17, 18)
- TAM sizing completed? (for chart 15)
Task 2 Verification (Financial Model)
- Task 2 complete? (Financial model Excel file exists)
- Revenue by product breakdown available? (for chart 03 ⭐)
- Revenue by geography breakdown available? (for chart 04 ⭐)
- Historical + projected financials complete? (for charts 02, 10, 11, 12)
- Scenario analysis (Bull/Base/Bear) complete? (for chart 14)
- Operating metrics available? (for chart 13)
Task 3 Verification (Valuation)
- Task 3 complete? (Valuation tabs added to model)
- DCF sensitivity matrix exists? (for chart 28 ⭐)
- DCF calculation details available? (for chart 29)
- Comparable companies data collected? (for charts 30, 31)
- Valuation ranges calculated? (for chart 32 ⭐)
External Data Verification
- Can access historical stock price data? (Yahoo Finance, Bloomberg for chart 01)
- Can access historical valuation data? (Optional, for chart 34)
IF ANY VERIFICATION FAILS:
- Missing Task 1? → Complete Task 1 (Company Research) first
- Missing Task 2? → Complete Task 2 (Financial Modeling) first
- Missing Task 3? → Complete Task 3 (Valuation Analysis) first
- Missing external data? → Gather from Yahoo Finance, Bloomberg, or similar sources
Chart Requirements: 25 Required + 10 Optional
IMPORTANT: Task 5 (Report Assembly) will embed ALL charts created throughout the report. The report requires dense visual content (1 chart every 200-300 words), so create comprehensive chart coverage.
4 MANDATORY Charts (Non-Negotiable) ⭐
These 4 charts are critical visualizations that MUST be present:
- chart_03: Revenue by Product/Segment - Stacked Area Chart ⭐
- chart_04: Revenue by Geography - Stacked Bar Chart ⭐
- chart_28: DCF Sensitivity Analysis - 2-Way Heatmap ⭐
- chart_32: Valuation Football Field - Horizontal Bar Chart ⭐
25 REQUIRED Charts (Complete Set)
Create all 25 of these charts. Each has a specific purpose in Task 5:
Investment Summary Section (1 chart):
- chart_01: Stock Price Performance (12-24 months)
Financial Performance Section (6 charts):
- chart_02: Revenue Growth Trajectory
- chart_03: Revenue by Product - Stacked Area ⭐ MANDATORY
- chart_04: Revenue by Geography - Stacked Bar ⭐ MANDATORY
- chart_10: Gross Margin Evolution
- chart_11: EBITDA Margin Progression
- chart_12: Free Cash Flow Trend
Company 101 Section (7 charts):
- chart_05: Company Overview/Timeline
- chart_06: Key Milestones Timeline
- chart_07: Organizational Structure
- chart_08: Product Portfolio Overview
- chart_09: Customer Segmentation
- chart_15: Market Size Evolution (TAM)
- chart_16: Competitive Positioning Matrix
Competitive & Market Section (2 charts):
- chart_17: Market Share Breakdown
- chart_18: Competitive Benchmarking
Scenario Analysis Section (2 charts):
- chart_13: Operating Metrics Dashboard
- chart_14: Scenario Comparison (Bull/Base/Bear)
Valuation Section (7 charts):
- chart_28: DCF Sensitivity Heatmap ⭐ MANDATORY
- chart_29: DCF Valuation Waterfall
- chart_30: Trading Comps Scatter Plot
- chart_31: Peer Multiples Comparison
- chart_32: Valuation Football Field ⭐ MANDATORY
- chart_33: Price Target Scenarios
- chart_34: Historical Valuation Multiples
Total: 25 Required Charts
10 OPTIONAL Charts (For 30-35 Range)
Add these for greater visual density and storytelling (reach 26-35 total):
- chart_19: Customer Acquisition Trends
- chart_20: Unit Economics Evolution
- chart_21: Product Roadmap Timeline
- chart_22: Geographic Expansion Map
- chart_23: R&D Investment Trends
- chart_24: Sales & Marketing Efficiency
- chart_25: Working Capital Trends
- chart_26: Debt Maturity Schedule
- chart_27: Ownership Structure
- chart_35: Analyst Price Target Distribution
Total Range: 25-35 Charts (25 required + 0-10 optional)
Data Source Mapping for Required Charts
Understanding where each chart's data comes from:
From Task 1 (Company Research) - 9 charts
- chart_05: Company Overview → Task 1: Company Overview section
- chart_06: Key Milestones → Task 1: Company History section
- chart_07: Org Structure → Task 1: Management Team section
- chart_08: Product Portfolio → Task 1: Products & Services section
- chart_09: Customer Segmentation → Task 1: Customers & Go-to-Market section
- chart_15: Market Size Evolution → Task 1: Market Opportunity (TAM) section
- chart_16: Competitive Positioning → Task 1: Competitive Landscape section
- chart_17: Market Share → Task 1: Competitive Landscape section
- chart_18: Competitive Benchmarking → Task 1: Competitive Landscape section
From Task 2 (Financial Model) - 8 charts
- chart_02: Revenue Growth → Income Statement tab (Revenue row)
- chart_03: Revenue by Product ⭐ → Revenue Model tab (Product breakdown)
- chart_04: Revenue by Geography ⭐ → Revenue Model tab (Geography breakdown)
- chart_10: Gross Margin → Income Statement tab (Gross Profit / Revenue)
- chart_11: EBITDA Margin → Income Statement tab (EBITDA / Revenue)
- chart_12: Free Cash Flow → Cash Flow Statement tab (CFO - CapEx)
- chart_13: Operating Metrics → Multiple tabs (Income Statement, Cash Flow)
- chart_14: Scenario Comparison → Scenarios tab (Bull/Base/Bear)
From Task 3 (Valuation) - 6 charts
- chart_28: DCF Sensitivity ⭐ → Sensitivity Analysis tab
- chart_29: DCF Waterfall → DCF tab (Enterprise Value components)
- chart_30: Trading Comps Scatter → Comparable Companies tab
- chart_31: Peer Multiples → Comparable Companies tab
- chart_32: Valuation Football Field ⭐ → Valuation Summary tab
- chart_33: Price Target Scenarios → Valuation Summary tab (or calculate from scenarios)
From External Sources - 2 charts
- chart_01: Stock Price Performance → Yahoo Finance, Bloomberg, Alpha Vantage
- chart_34: Historical Valuation Multiples → Yahoo Finance, Bloomberg (historical P/E, EV/EBITDA)
IMPORTANT: Require ALL three tasks (1, 2, 3) complete PLUS external data access to create all 25 required charts.
Step-by-Step Chart Generation Workflow
Step 1: Set Up Environment
Install required libraries:
pip install matplotlib seaborn pandas numpy plotlyCreate Python script header:
import matplotlib.pyplot as plt
import seaborn as sns
import pandas as pd
import numpy as np
from matplotlib.patches import Rectangle
import warnings
warnings.filterwarnings('ignore')
# Set global style
plt.style.use('seaborn-v0_8-darkgrid')
sns.set_palette("husl")
# Global settings
DPI = 300
FIGURE_WIDTH = 10
FIGURE_HEIGHT = 6
TITLE_FONT_SIZE = 14
AXIS_FONT_SIZE = 12
LABEL_FONT_SIZE = 10Step 2: Extract Data from Model and Valuation
A. Extract Revenue Data
# Revenue by Product (from Task 2 model)
years = [2020, 2021, 2022, 2023, 2024, 2025, 2026, 2027, 2028, 2029]
# Extract from Excel or define manually from model
product_a = [100, 120, 145, 175, 210, 252, 302, 363, 435, 522]
product_b = [80, 95, 115, 138, 165, 198, 238, 285, 342, 411]
product_c = [50, 62, 78, 98, 122, 153, 191, 239, 299, 374]
product_d = [30, 38, 48, 61, 77, 97, 122, 153, 191, 239]
# Revenue by Geography
north_america = [150, 180, 220, 265, 320, 384, 461, 553, 664, 797]
europe = [80, 95, 115, 140, 170, 204, 245, 294, 353, 423]
asia_pacific = [40, 50, 63, 80, 101, 127, 159, 199, 249, 311]
rest_of_world = [20, 25, 32, 40, 51, 64, 80, 100, 125, 156]B. Extract Margin Data
# Margin evolution
gross_margin = [58.0, 59.2, 60.5, 61.8, 63.0, 64.5, 66.0, 67.0, 67.5, 68.0]
ebitda_margin = [12.0, 15.5, 18.8, 22.0, 25.0, 28.0, 30.5, 32.0, 33.0, 34.0]
fcf_margin = [8.0, 11.0, 14.5, 18.0, 21.0, 24.0, 26.5, 28.0, 29.0, 30.0]C. Extract DCF Sensitivity Data
# DCF Sensitivity (from Task 3 valuation)
wacc_values = [7.0, 8.0, 9.0, 10.0, 11.0, 12.0]
terminal_growth = [1.5, 2.0, 2.5, 3.0, 3.5]
# Price per share matrix (rows = WACC, columns = terminal growth)
dcf_sensitivity = np.array([
[66, 71, 76, 82, 89],
[58, 62, 67, 72, 78],
[52, 55, 59, 63, 68],
[47, 50, 53, 56, 60],
[42, 45, 48, 51, 54],
[39, 41, 44, 46, 49]
])D. Extract Valuation Ranges
# Valuation Football Field (from Task 3)
valuation_methods = ['DCF Analysis', 'Trading Comps\n(NTM)', 'Precedent\nTransactions']
valuation_low = [48, 45, 52]
valuation_high = [62, 57, 66]
current_price = 50
target_price = 55Step 3: Create Mandatory Charts
Chart 1: Revenue by Product - Stacked Area ⭐ MANDATORY
def create_revenue_by_product_chart():
"""Create revenue by product stacked area chart"""
fig, ax = plt.subplots(figsize=(10, 6))
# Create stacked area chart
ax.stackplot(years, product_a, product_b, product_c, product_d,
labels=['Product A', 'Product B', 'Product C', 'Product D'],
colors=['#1f77b4', '#ff7f0e', '#2ca02c', '#d62728'],
alpha=0.8)
# Formatting
ax.set_xlabel('Year', fontsize=12, fontweight='bold')
ax.set_ylabel('Revenue ($M)', fontsize=12, fontweight='bold')
ax.set_title('Figure 3 - Revenue by Product/Segment (2020-2029E)',
fontsize=14, fontweight='bold', pad=20)
# Legend
ax.legend(loc='upper left', frameon=False, fontsize=10)
# Grid
ax.grid(axis='y', alpha=0.3, linestyle='--')
ax.set_axisbelow(True)
# Remove top and right spines
ax.spines['top'].set_visible(False)
ax.spines['right'].set_visible(False)
# Add vertical line to separate historical from projected
ax.axvline(x=2024, color='gray', linestyle='--', linewidth=1, alpha=0.5)
ax.text(2024.2, ax.get_ylim()[1]*0.95, 'Projected →',
fontsize=9, color='gray', ha='left')
# Source line
fig.text(0.12, 0.02, 'Source: Company data, [Firm] estimates',
fontsize=9, style='italic', color='gray')
# Save
plt.tight_layout()
plt.savefig('chart_03_revenue_by_product_stacked_area.png',
dpi=300, bbox_inches='tight', facecolor='white')
plt.close()
print("✓ Created: chart_03_revenue_by_product_stacked_area.png")
create_revenue_by_product_chart()Chart 2: Revenue by Geography - Stacked Bar ⭐ MANDATORY
def create_revenue_by_geography_chart():
"""Create revenue by geography stacked bar chart"""
years_labels = ['2020', '2021', '2022', '2023', '2024',
'2025E', '2026E', '2027E', '2028E', '2029E']
fig, ax = plt.subplots(figsize=(10, 6))
# Create stacked bar chart
width = 0.6
x = np.arange(len(years_labels))
p1 = ax.bar(x, north_america, width, label='North America', color='#1f77b4')
p2 = ax.bar(x, europe, width, bottom=north_america,
label='Europe', color='#ff7f0e')
p3 = ax.bar(x, asia_pacific, width,
bottom=np.array(north_america) + np.array(europe),
label='Asia-Pacific', color='#2ca02c')
p4 = ax.bar(x, rest_of_world, width,
bottom=np.array(north_america) + np.array(europe) + np.array(asia_pacific),
label='Rest of World', color='#d62728')
# Formatting
ax.set_xlabel('Year', fontsize=12, fontweight='bold')
ax.set_ylabel('Revenue ($M)', fontsize=12, fontweight='bold')
ax.set_title('Figure 4 - Revenue by Geography (2020-2029E)',
fontsize=14, fontweight='bold', pad=20)
ax.set_xticks(x)
ax.set_xticklabels(years_labels, rotation=45, ha='right')
# Legend
ax.legend(loc='upper left', frameon=False, fontsize=10)
# Grid
ax.grid(axis='y', alpha=0.3, linestyle='--')
ax.set_axisbelow(True)
# Remove top and right spines
ax.spines['top'].set_visible(False)
ax.spines['right'].set_visible(False)
# Source line
fig.text(0.12, 0.02, 'Source: Company data, [Firm] estimates',
fontsize=9, style='italic', color='gray')
# Save
plt.tight_layout()
plt.savefig('chart_04_revenue_by_geography_stacked_bar.png',
dpi=300, bbox_inches='tight', facecolor='white')
plt.close()
print("✓ Created: chart_04_revenue_by_geography_stacked_bar.png")
create_revenue_by_geography_chart()Chart 3: DCF Sensitivity - Heatmap ⭐ MANDATORY
def create_dcf_sensitivity_heatmap():
"""Create DCF sensitivity analysis heatmap"""
# Create DataFrame
df = pd.DataFrame(dcf_sensitivity,
index=[f'{w}%' for w in wacc_values],
columns=[f'{g}%' for g in terminal_growth])
fig, ax = plt.subplots(figsize=(8, 6))
# Create heatmap
sns.heatmap(df, annot=True, fmt='d', cmap='RdYlGn',
cbar_kws={'label': 'Price per Share ($)'},
linewidths=0.5, linecolor='white',
ax=ax, vmin=35, vmax=95)
# Formatting
ax.set_xlabel('Terminal Growth Rate', fontsize=12, fontweight='bold')
ax.set_ylabel('WACC', fontsize=12, fontweight='bold')
ax.set_title('Figure 28 - DCF Sensitivity Analysis ($/share)',
fontsize=14, fontweight='bold', pad=20)
# Rotate y-axis labels
plt.yticks(rotation=0)
# Source line
fig.text(0.12, 0.02, 'Source: [Firm] estimates',
fontsize=9, style='italic', color='gray')
# Save
plt.tight_layout()
plt.savefig('chart_28_dcf_sensitivity_heatmap.png',
dpi=300, bbox_inches='tight', facecolor='white')
plt.close()
print("✓ Created: chart_28_dcf_sensitivity_heatmap.png")
create_dcf_sensitivity_heatmap()Chart 4: Valuation Football Field ⭐ MANDATORY
def create_valuation_football_field():
"""Create valuation football field chart"""
fig, ax = plt.subplots(figsize=(10, 5))
# Create horizontal bars
y_positions = np.arange(len(valuation_methods))
colors = ['#1f77b4', '#ff7f0e', '#2ca02c']
for i, (method, low, high, color) in enumerate(
zip(valuation_methods, valuation_low, valuation_high, colors)):
ax.barh(i, high - low, left=low, height=0.6,
color=color, alpha=0.7, label=method)
# Add value labels at ends
ax.text(low - 1, i, f'${low}', va='center', ha='right', fontsize=10)
ax.text(high + 1, i, f'${high}', va='center', ha='left', fontsize=10)
# Add current price line
ax.axvline(x=current_price, color='red', linestyle='--', linewidth=2,
label=f'Current: ${current_price}', alpha=0.7)
# Add target price line
ax.axvline(x=target_price, color='black', linestyle='-', linewidth=2,
label=f'Target: ${target_price}')
# Formatting
ax.set_yticks(y_positions)
ax.set_yticklabels(valuation_methods, fontsize=11)
ax.set_xlabel('Price Per Share ($)', fontsize=12, fontweight='bold')
ax.set_title('Figure 32 - Valuation Football Field',
fontsize=14, fontweight='bold', pad=20)
# Set x-axis limits
ax.set_xlim(40, 70)
# Remove spines
ax.spines['top'].set_visible(False)
ax.spines['right'].set_visible(False)
ax.spines['left'].set_visible(False)
# Grid
ax.grid(axis='x', alpha=0.3, linestyle='--')
ax.set_axisbelow(True)
# Legend
ax.legend(loc='upper right', frameon=False, fontsize=9)
# Source line
fig.text(0.12, 0.02, 'Source: [Firm] estimates',
fontsize=9, style='italic', color='gray')
# Save
plt.tight_layout()
plt.savefig('chart_32_valuation_football_field.png',
dpi=300, bbox_inches='tight', facecolor='white')
plt.close()
print("✓ Created: chart_32_valuation_football_field.png")
create_valuation_football_field()Step 4: Create Remaining Required Charts (Charts 1-34)
Complete the 25 REQUIRED charts by creating all remaining charts from the required list. Each chart has a specific purpose in Task 5.
Investment Summary (1 chart)
# chart_01: Stock Price Performance (12-24 months)
# - Line chart showing stock price over time vs. market index
# - Used on Page 1 of final reportFinancial Performance (5 additional charts beyond chart_03 and chart_04)
# chart_02: Revenue Growth Trajectory
# chart_10: Gross Margin Evolution
# chart_11: EBITDA Margin Progression
# chart_12: Free Cash Flow Trend
# chart_14: Scenario Comparison (Bull/Base/Bear)Company 101 Section (7 charts)
# chart_05: Company Overview/Timeline
# chart_06: Key Milestones Timeline
# chart_07: Organizational Structure
# chart_08: Product Portfolio Overview
# chart_09: Customer Segmentation
# chart_15: Market Size Evolution (TAM)
# chart_16: Competitive Positioning MatrixCompetitive & Market (2 charts)
# chart_17: Market Share Breakdown
# chart_18: Competitive BenchmarkingScenario Analysis (1 chart)
# chart_13: Operating Metrics DashboardValuation Section (6 additional charts beyond chart_28 and chart_32)
# chart_29: DCF Valuation Waterfall
# chart_30: Trading Comps Scatter Plot
# chart_31: Peer Multiples Comparison
# chart_33: Price Target Scenarios
# chart_34: Historical Valuation MultiplesUse consistent formatting across all charts:
- 300 DPI resolution
- Professional color scheme
- Clear labels, legends, and titles
- Figure numbers (e.g., "Figure 5 - Company Timeline")
- Source citations at bottom
Step 4B: Create Optional Charts (For 26-35 Total)
Optional: Add 1-10 additional charts from this list for greater visual density:
# chart_19: Customer Acquisition Trends
# chart_20: Unit Economics Evolution
# chart_21: Product Roadmap Timeline
# chart_22: Geographic Expansion Map
# chart_23: R&D Investment Trends
# chart_24: Sales & Marketing Efficiency
# chart_25: Working Capital Trends
# chart_26: Debt Maturity Schedule
# chart_27: Ownership Structure
# chart_35: Analyst Price Target DistributionThese optional charts provide additional visual storytelling and help achieve the "1 chart per 200-300 words" density target in Task 5.
Step 5: Create Chart Index
Create a text file documenting all charts:
def create_chart_index():
"""Create index of all charts"""
# 25 REQUIRED CHARTS
required_charts = [
"chart_01_stock_price_performance.png - Stock Price Performance (12-24M)",
"chart_02_revenue_growth_trajectory.png - Revenue Growth Trajectory",
"chart_03_revenue_by_product_stacked_area.png - Revenue by Product [MANDATORY]",
"chart_04_revenue_by_geography_stacked_bar.png - Revenue by Geography [MANDATORY]",
"chart_05_company_overview.png - Company Overview/Timeline",
"chart_06_key_milestones_timeline.png - Key Milestones Timeline",
"chart_07_organizational_structure.png - Organizational Structure",
"chart_08_product_portfolio.png - Product Portfolio Overview",
"chart_09_customer_segmentation.png - Customer Segmentation",
"chart_10_gross_margin_evolution.png - Gross Margin Evolution",
"chart_11_ebitda_margin_progression.png - EBITDA Margin Progression",
"chart_12_free_cash_flow_trend.png - Free Cash Flow Trend",
"chart_13_operating_metrics_dashboard.png - Operating Metrics Dashboard",
"chart_14_scenario_comparison.png - Scenario Comparison (Bull/Base/Bear)",
"chart_15_market_size_evolution.png - Market Size Evolution (TAM)",
"chart_16_competitive_positioning.png - Competitive Positioning Matrix",
"chart_17_market_share.png - Market Share Breakdown",
"chart_18_competitive_benchmarking.png - Competitive Benchmarking",
"chart_28_dcf_sensitivity_heatmap.png - DCF Sensitivity Heatmap [MANDATORY]",
"chart_29_dcf_waterfall.png - DCF Valuation Waterfall",
"chart_30_trading_comps_scatter.png - Trading Comps Scatter Plot",
"chart_31_peer_multiples_comparison.png - Peer Multiples Comparison",
"chart_32_valuation_football_field.png - Valuation Football Field [MANDATORY]",
"chart_33_price_target_scenarios.png - Price Target Scenarios",
"chart_34_historical_valuation_multiples.png - Historical Valuation Multiples",
]
# 10 OPTIONAL CHARTS (for 26-35 range)
optional_charts = [
"chart_19_customer_acquisition_trends.png - Customer Acquisition Trends [OPTIONAL]",
"chart_20_unit_economics_evolution.png - Unit Economics Evolution [OPTIONAL]",
"chart_21_product_roadmap_timeline.png - Product Roadmap Timeline [OPTIONAL]",
"chart_22_geographic_expansion_map.png - Geographic Expansion Map [OPTIONAL]",
"chart_23_rd_investment_trends.png - R&D Investment Trends [OPTIONAL]",
"chart_24_sales_marketing_efficiency.png - Sales & Marketing Efficiency [OPTIONAL]",
"chart_25_working_capital_trends.png - Working Capital Trends [OPTIONAL]",
"chart_26_debt_maturity_schedule.png - Debt Maturity Schedule [OPTIONAL]",
"chart_27_ownership_structure.png - Ownership Structure [OPTIONAL]",
"chart_35_analyst_price_targets.png - Analyst Price Target Distribution [OPTIONAL]",
]
with open('chart_index.txt', 'w') as f:
f.write("CHART INDEX FOR [COMPANY] EQUITY RESEARCH REPORT\n")
f.write("=" * 60 + "\n\n")
f.write("4 MANDATORY CHARTS (Must be present):\n")
f.write("- chart_03: Revenue by Product (Stacked Area) ⭐\n")
f.write("- chart_04: Revenue by Geography (Stacked Bar) ⭐\n")
f.write("- chart_28: DCF Sensitivity (Heatmap) ⭐\n")
f.write("- chart_32: Valuation Football Field ⭐\n\n")
f.write("25 REQUIRED CHARTS:\n")
for chart in required_charts:
f.write(f" {chart}\n")
f.write("\n10 OPTIONAL CHARTS (for 26-35 total):\n")
for chart in optional_charts:
f.write(f" {chart}\n")
f.write("\n" + "=" * 60 + "\n")
f.write("NOTE: Task 5 will embed ALL charts created (25-35) throughout\n")
f.write("the report for visual density (1 chart every 200-300 words).\n")
print("✓ Created: chart_index.txt")
create_chart_index()Step 6: Quality Check
Run verification checks:
import os
def verify_charts():
"""Verify all charts were created successfully"""
mandatory_charts = [
'chart_03_revenue_by_product_stacked_area.png',
'chart_04_revenue_by_geography_stacked_bar.png',
'chart_28_dcf_sensitivity_heatmap.png',
'chart_32_valuation_football_field.png'
]
print("\n" + "="*60)
print("CHART GENERATION VERIFICATION")
print("="*60)
# Check mandatory charts
print("\n1. MANDATORY CHARTS:")
all_mandatory_present = True
for chart in mandatory_charts:
if os.path.exists(chart):
size = os.path.getsize(chart) / 1024 # KB
print(f" ✓ {chart} ({size:.1f} KB)")
else:
print(f" ✗ MISSING: {chart}")
all_mandatory_present = False
# Count total charts
chart_files = [f for f in os.listdir('.') if f.startswith('chart_') and f.endswith('.png')]
print(f"\n2. TOTAL CHARTS: {len(chart_files)}")
print(f" Target: 25-35 charts")
print(f" Status: {'✓ PASS' if 25 <= len(chart_files) <= 35 else '⚠ WARNING'}")
# Check file sizes (should be > 50KB for 300 DPI)
print("\n3. FILE SIZE CHECK:")
small_files = []
for chart in chart_files[:5]: # Sample first 5
size = os.path.getsize(chart) / 1024
if size < 50:
small_files.append(chart)
print(f" {chart}: {size:.1f} KB")
if small_files:
print(f" ⚠ WARNING: {len(small_files)} files may be low resolution")
else:
print(f" ✓ All sampled files have adequate size")
# Final verdict
print("\n" + "="*60)
if all_mandatory_present and 25 <= len(chart_files) <= 35:
print("✓ VERIFICATION PASSED - Ready for Task 5")
else:
print("✗ VERIFICATION FAILED - Review missing charts")
print("="*60 + "\n")
verify_charts()Quality Standards
Visual Quality
- High resolution (300 DPI minimum)
- Professional color scheme (consistent across all charts)
- Clear, legible text (no fonts smaller than 9pt)
- Proper aspect ratio (no distortion)
- No pixelation or artifacts
Data Accuracy
- Data matches source (financial model and valuation)
- Proper units and labels ($ millions, percentages, etc.)
- Appropriate scale and range
- Consistent time periods across charts
- Verified calculations
Formatting Quality
- Consistent styling across all charts
- Proper figure numbering (sequential)
- Clear titles and captions
- Source citations on every chart
- Professional appearance
Completeness
- All 4 mandatory charts created
- 25-35 total charts
- Proper file naming (chart_01, chart_02, etc.)
- Chart index created
- Ready for embedding in Word
Chart Types Reference
When to Use Each Chart Type
Line Charts: Time series trends (revenue, margins, stock price)
Stacked Area: Revenue by product ⭐, market size composition
Stacked Bar: Revenue by geography ⭐, quarterly breakdowns
Heatmap: DCF sensitivity ⭐, correlation matrices
Horizontal Bar: Valuation football field ⭐, peer rankings
Waterfall: Revenue bridges, margin analysis, DCF build-up
Scatter/Bubble: Growth vs. valuation, competitive positioning
2×2 Matrix: Competitive positioning, product portfolio
File Naming Convention
Always use this format:
chart_[NUMBER]_[DESCRIPTION].png
Examples:
chart_01_stock_price_performance.png
chart_03_revenue_by_product_stacked_area.png
chart_28_dcf_sensitivity_heatmap.pngNumber charts sequentially based on their position in the report, not creation order.
Common Chart Generation Issues
Issue 1: Low Resolution
Problem: Chart looks pixelated
Solution: Ensure dpi=300 in plt.savefig()
Issue 2: Text Cutoff
Problem: Labels or titles cut off at edges
Solution: Use bbox_inches='tight' in plt.savefig()
Issue 3: Poor Colors
Problem: Colors don't look professional Solution: Use established palettes like Tableau10 or define custom corporate colors
Issue 4: Overlapping Labels
Problem: Axis labels overlap
Solution: Rotate labels (e.g., rotation=45) or reduce font size
Issue 5: White Space
Problem: Too much white space around chart
Solution: Use plt.tight_layout() before saving
Success Criteria
A successful chart package should:
- Include all 4 mandatory charts (verified) ⭐
- chart_03: Revenue by Product
- chart_04: Revenue by Geography
- chart_28: DCF Sensitivity
- chart_32: Valuation Football Field
- Create 25 required charts minimum (verified)
- Optional: 1-10 additional charts for 26-35 total
- Have consistent professional styling across all charts
- Be high resolution (300 DPI) for print quality
- Have clear labels, legends, and titles on every chart
- Include proper figure numbers and source citations
- Be ready for immediate embedding in Word
- Cover all key financial metrics and analyses
- Tell a visual story complementing the written analysis
- Be accurate and auditable to source data (model/valuation)
- All charts packaged in zip file with chart index
Remember: Task 5 will embed ALL charts created (25-35) throughout the report for visual density.
Output Files
After completing Task 4, deliverables include:
25 REQUIRED Chart Files (Minimum):
- chart_01_stock_price_performance.png
- chart_02_revenue_growth_trajectory.png
- chart_03_revenue_by_product_stacked_area.png ⭐ MANDATORY
- chart_04_revenue_by_geography_stacked_bar.png ⭐ MANDATORY
- chart_05_company_overview.png
- chart_06_key_milestones_timeline.png
- chart_07_organizational_structure.png
- chart_08_product_portfolio.png
- chart_09_customer_segmentation.png
- chart_10_gross_margin_evolution.png
- chart_11_ebitda_margin_progression.png
- chart_12_free_cash_flow_trend.png
- chart_13_operating_metrics_dashboard.png
- chart_14_scenario_comparison.png
- chart_15_market_size_evolution.png
- chart_16_competitive_positioning.png
- chart_17_market_share.png
- chart_18_competitive_benchmarking.png 19-27. Reserved for optional charts if created
- chart_28_dcf_sensitivity_heatmap.png ⭐ MANDATORY
- chart_29_dcf_waterfall.png
- chart_30_trading_comps_scatter.png
- chart_31_peer_multiples_comparison.png
- chart_32_valuation_football_field.png ⭐ MANDATORY
- chart_33_price_target_scenarios.png
- chart_34_historical_valuation_multiples.png
- Reserved for optional chart if created
10 OPTIONAL Chart Files (For 26-35 Total):
- chart_19 through chart_27, chart_35 (if created)
Chart Index (1 text file):
- chart_index.txt (listing all charts with descriptions and categories)
All chart files must be:
- 300 DPI resolution (print quality)
- 6-10 inches wide (standard Word embedding size)
- White background (professional appearance)
- PNG format (lossless quality)
- Ready for immediate Word embedding
Final Step: Package All Charts
Create a zip file containing all chart files and the chart index:
[Company]_Charts_[Date].zip
├── chart_01_stock_price_performance.png
├── chart_02_revenue_growth_trajectory.png
├── chart_03_revenue_by_product_stacked_area.png ⭐
├── chart_04_revenue_by_geography_stacked_bar.png ⭐
├── chart_05_company_overview.png
├── ... (all 25-35 chart files)
├── chart_28_dcf_sensitivity_heatmap.png ⭐
├── chart_32_valuation_football_field.png ⭐
├── chart_34_historical_valuation_multiples.png
└── chart_index.txtExample: Tesla_Charts_2024-10-28.zip
Why this matters: Task 5 will embed ALL charts created (25-35) throughout the report. The report requires visual density (1 chart per 200-300 words), so all charts serve a purpose—either for specific analytical sections or for visual storytelling and page density.
- Verify all 25-35 charts are present
- Extract charts for Task 5 (Report Assembly)
Next Steps
After completing Task 4, the zip file will be used for:
- Task 5 (Report Assembly): Extract charts and embed all into the final DOCX report at appropriate locations throughout the document
The 4 mandatory charts are critical for the valuation and financial analysis sections of the report.
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.
Input Verification (CRITICAL)
BEFORE STARTING - ALL TASKS MUST BE COMPLETE:
Task 1 Verification:
- Company research document exists? (6-8K words)
- Management bios complete? (300-400 words × 3-4 execs)
- Competitive analysis complete? (5-10 competitors)
- Risk assessment complete? (8-12 risks)
Task 2 Verification:
- Financial model exists and can be opened?
- Model has projections (5 years)?
- Scenarios exist (Bull/Base/Bear)?
- Revenue by product table complete (20-30 rows)?
- Revenue by geography table complete (15-20 rows)?
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?
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.
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 shareBase 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 shareScenario 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
- Read:
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
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.txtOpen 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.
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:
- Open
[Company]_Financial_Model_[Date].xlsx - Read from
Income Statementtab - 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 Statementtab - 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 Modeltab - 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 Modeltab - 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 Companiestab (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)
- Use Read tool:
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 Statementtab to extract historical data - Read
Revenue Modeltab 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) ⭐ MANDATORYCreate 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) ⭐ MANDATORYCreate 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)
- Insert chart:
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
- Use Read tool:
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) ⭐ MANDATORYCreate 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
Insert chart:
task4_charts/chart_32_valuation_football_field.png(6.5 inches wide) ⭐ MANDATORYCreate 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
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 sectionsResult: 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].xlsxand 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.pngfiles
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"
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)
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.
Valuation Methodologies for Equity Research
This reference document provides comprehensive guidance on the three primary valuation methodologies used in equity research: Discounted Cash Flow (DCF), Trading Comparables, and Precedent Transactions.
Table of Contents
- Discounted Cash Flow (DCF) Analysis
- Trading Comparables Analysis
- Precedent Transactions Analysis
- Valuation Reconciliation
Discounted Cash Flow (DCF) Analysis
Overview
DCF analysis values a company based on the present value of its projected future cash flows. This is considered the most theoretically sound valuation method as it's based on fundamental value creation.
Step-by-Step DCF Process
1. Historical Financial Analysis
- Collect 3-5 years of historical financials
- Calculate historical FCF = EBIT(1-Tax Rate) + D&A - CapEx - Change in NWC
- Analyze historical growth rates and margins
- Identify trends and cyclicality
2. Build Revenue Projections (5-10 years)
Approaches:
- Top-down: Start with market size (TAM) → Market share → Revenue
- Bottom-up: Units sold × Price per unit
- Hybrid: Combine multiple drivers
Key Considerations:
- Management guidance and historical growth
- Industry growth rates and market trends
- Competitive dynamics and market share evolution
- Product pipeline and new market opportunities
- Macroeconomic factors
3. Project Operating Expenses
- COGS: As % of revenue (analyze historical margins)
- SG&A: Often semi-fixed; model as % of revenue with scale effects
- R&D: Critical for tech/pharma; model as % of revenue
- D&A: Based on CapEx assumptions
Calculate EBIT = Revenue - COGS - Operating Expenses
4. Calculate Unlevered Free Cash Flow
EBIT
× (1 - Tax Rate)
= NOPAT (Net Operating Profit After Tax)
+ Depreciation & Amortization
- Capital Expenditures
- Increase in Net Working Capital
= Unlevered Free Cash Flow (UFCF)CapEx Assumptions:
- Maintenance CapEx: Required to maintain current operations (typically 2-4% of revenue)
- Growth CapEx: Required for expansion
- Consider industry benchmarks and company guidance
Net Working Capital:
- NWC = (Accounts Receivable + Inventory) - Accounts Payable
- Model as % of revenue or days (DSO, DIO, DPO)
- An increase in NWC is a use of cash
5. Determine Terminal Value
Method A: Perpetuity Growth Method
Terminal Value = FCF(final year) × (1 + g) / (WACC - g)- g = perpetual growth rate (typically 2-3%, not exceeding GDP growth)
- Use when company has reached stable, mature growth
Method B: Exit Multiple Method
Terminal Value = EBITDA(final year) × Exit Multiple- Exit multiple based on current trading comps
- More appropriate for cyclical businesses
6. Calculate Weighted Average Cost of Capital (WACC)
WACC = (E/V × Cost of Equity) + (D/V × Cost of Debt × (1 - Tax Rate))Cost of Equity (using CAPM):
Cost of Equity = Risk-Free Rate + Beta × Equity Risk Premium- Risk-Free Rate: 10-year Treasury yield
- Beta: Regression of stock returns vs. market (or use comparable beta)
- Equity Risk Premium: Historical average ~5-6%
Cost of Debt:
Cost of Debt = Risk-Free Rate + Credit Spread- Use company's current borrowing rate or implied from bonds
- Adjust for credit rating if no bonds outstanding
Capital Structure:
- E/V = Market value of equity / Total value
- D/V = Market value of debt / Total value
- Use target capital structure, not current (if significantly different)
7. Discount Cash Flows to Present Value
PV = Σ [FCFt / (1 + WACC)^t] + [Terminal Value / (1 + WACC)^n]8. Calculate Enterprise Value and Equity Value
Enterprise Value = PV of Projected FCF + PV of Terminal Value
Less: Net Debt (Total Debt - Cash)
Plus: Non-operating Assets
Less: Minority Interest
Less: Preferred Stock
= Equity Value
Price Per Share = Equity Value / Diluted Shares OutstandingDCF Sensitivity Analysis
Always perform sensitivity analysis on key variables:
- Two-way sensitivity table: WACC vs. Terminal Growth Rate
- Revenue growth scenarios: Base / Bull / Bear cases
- Margin assumptions: Operating leverage scenarios
- Terminal multiple sensitivity: If using exit multiple method
Example Sensitivity Table:
Terminal Growth Rate
WACC 2.0% 2.5% 3.0%
8.0% $45 $48 $52
9.0% $40 $43 $46
10.0% $36 $39 $41Common DCF Pitfalls to Avoid
- Double-counting growth: Don't project high growth without corresponding investment (CapEx, NWC)
- Unrealistic terminal growth: Should not exceed long-term GDP growth
- Ignoring cyclicality: Normalize earnings for cyclical businesses
- Wrong cash flow definition: Use unlevered FCF, not net income
- Inconsistent assumptions: Match discount rate to cash flows (unlevered FCF → WACC)
Trading Comparables Analysis
Overview
Trading comps values a company based on how similar companies are valued in the public markets. This reflects current market sentiment and relative valuation.
Step-by-Step Comps Process
1. Select Comparable Companies
Selection Criteria:
- Same industry/sector (primary criterion)
- Similar business model and revenue streams
- Comparable size (market cap, revenue)
- Similar growth profile and margins
- Similar end markets and geographies
Typical Universe:
- Start with 8-15 companies
- Remove companies with unique circumstances
- Final set of 5-10 companies
2. Gather Financial Information
Required Data:
- Current stock price and shares outstanding
- Latest fiscal year financial statements
- Next-year (NTM) estimates from consensus
- Historical growth rates
Calculate Market Metrics:
- Market Cap = Share Price × Shares Outstanding
- Enterprise Value = Market Cap + Debt + Minority Interest + Preferred - Cash
- Net Debt = Total Debt - Cash & Equivalents
3. Calculate Valuation Multiples
Enterprise Value Multiples:
- EV/Revenue: Good for early-stage/high-growth companies
- EV/EBITDA: Most common; good for capital-intensive businesses
- EV/EBIT: Useful when D&A varies significantly
Equity Value Multiples:
- P/E (Price/Earnings): Most widely used
- P/B (Price/Book): Good for financial institutions
- P/S (Price/Sales): For unprofitable companies
Calculate for:
- Last Twelve Months (LTM) - historical
- Next Twelve Months (NTM) - forward-looking (preferred)
4. Analyze and Select Multiples
Create Comparable Company Table:
| Company | Market Cap | EV/Revenue | EV/EBITDA | EV/EBIT | P/E (NTM) | Revenue Growth | EBITDA Margin |
|---|---|---|---|---|---|---|---|
| Comp A | $10B | 3.5x | 12.0x | 18.0x | 22.0x | 15% | 28% |
| Comp B | $8B | 3.0x | 10.5x | 16.0x | 19.0x | 12% | 27% |
| ... | ... | ... | ... | ... | ... | ... | ... |
| Median | - | 3.2x | 11.0x | 17.0x | 20.5x | 13% | 27.5% |
Adjustments:
- Remove outliers (typically >2 standard deviations)
- Consider using median instead of mean (less affected by outliers)
- Weight multiples if some comps are more comparable
- Adjust for differences in growth, margins, risk
5. Apply Multiples to Target Company
Example Calculation:
Target Company NTM EBITDA = $500M
Selected EV/EBITDA Multiple = 11.0x
Implied Enterprise Value = $500M × 11.0x = $5,500M
Less: Net Debt = $1,000M
Equity Value = $4,500M
Shares Outstanding = 100M
Implied Price Per Share = $45.006. Select Appropriate Multiple
Choose based on:
- EV/Revenue: High-growth, unprofitable companies (tech, biotech pre-profit)
- EV/EBITDA: Most common; capital-intensive industries (manufacturing, telecom)
- P/E: Profitable companies with stable cap structure (consumer, retail)
- Sector-specific: P/B for banks, EV/Production for oil & gas, EV/Subscriber for media
Premium/Discount Analysis
Apply premiums or discounts based on:
- Growth premium: Higher growth → higher multiple
- Profitability: Higher margins → higher multiple
- Size: Larger companies typically trade at premium (liquidity)
- Market position: Market leaders → premium
- Geographic: Developed vs. emerging markets
Precedent Transactions Analysis
Overview
Precedent transactions values a company based on prices paid for similar companies in M&A transactions. This reflects control premiums and strategic value.
Step-by-Step Process
1. Identify Relevant Transactions
Selection Criteria:
- Same or similar industry
- Similar size (within 0.5x to 2x target's size)
- Similar business characteristics
- Recent transactions (last 3-5 years preferred)
- Announced and closed deals (avoid withdrawn deals)
Typical Universe:
- 5-10 transactions minimum
- Focus on recent deals (weight more recent higher)
2. Gather Transaction Details
Required Information:
- Transaction date (announcement and close)
- Acquisition price and structure (cash, stock, mixed)
- Target's financials at time of transaction
- Strategic rationale and synergies
- Control premium paid
Sources:
- SEC filings (S-4, 8-K, proxy statements)
- Press releases and investor presentations
- M&A databases (CapIQ, FactSet, Bloomberg)
3. Calculate Transaction Multiples
Same multiples as trading comps, but based on transaction value:
Transaction Value = Equity Purchase Price + Assumed Debt - Cash Acquired
EV/Revenue (LTM) = Transaction Value / Target's LTM Revenue
EV/EBITDA (LTM) = Transaction Value / Target's LTM EBITDA
EV/EBIT (LTM) = Transaction Value / Target's LTM EBITCalculate Control Premium:
Control Premium = (Offer Price - Unaffected Price) / Unaffected Price- Unaffected Price = Target's stock price 1-2 days before announcement
- Typical range: 20-40%
4. Analyze Precedent Transactions
Create Precedent Transactions Table:
| Date | Target | Acquirer | Deal Value | EV/Revenue | EV/EBITDA | Premium | Rationale |
|---|---|---|---|---|---|---|---|
| Q1'24 | CompX | BuyerA | $5.0B | 4.0x | 14.0x | 35% | Market consolidation |
| Q3'23 | CompY | BuyerB | $3.5B | 3.5x | 12.5x | 28% | Strategic fit |
| Median | - | - | - | 3.8x | 13.0x | 31% | - |
5. Apply to Target Company
Important Considerations:
- Precedent multiples typically higher than trading comps (include control premium)
- Adjust for differences in transaction rationale
- Consider market conditions at time of transactions vs. current
- Weight recent transactions more heavily
Example Calculation:
Target Company LTM EBITDA = $450M
Selected EV/EBITDA Multiple = 13.0x (precedent)
vs Trading Comps Multiple = 11.0x
Implied EV (Precedent) = $450M × 13.0x = $5,850M
Implied EV (Trading) = $450M × 11.0x = $4,950M
Implied Control Premium = $5,850M / $4,950M - 1 = 18%Adjustments to Transaction Multiples
Consider adjusting for:
- Market conditions: Bull vs. bear market (M&A activity levels)
- Deal structure: Strategic vs. financial buyer
- Synergies: Transactions with high synergies command premiums
- Competitive dynamics: Single vs. multiple bidders
- Time value: Older transactions less relevant
Valuation Reconciliation
Creating a Valuation Bridge
Present all three methods in a single framework:
Example Valuation Summary:
| Method | Enterprise Value | Equity Value | Price/Share | Weight | Implied Value |
|---|---|---|---|---|---|
| DCF Analysis | $5,200M | $4,200M | $42.00 | 50% | $21.00 |
| Trading Comps | $5,500M | $4,500M | $45.00 | 30% | $13.50 |
| Precedent Trans. | $5,850M | $4,850M | $48.50 | 20% | $9.70 |
| Weighted Avg | - | - | $44.20 | - | $44.20 |
Weighting the Methods
Typical Weighting:
- DCF: 40-60% (fundamental value, but assumes accuracy of projections)
- Trading Comps: 25-40% (reflects current market sentiment)
- Precedent Trans.: 15-25% (less relevant unless M&A likely)
Adjust weights based on:
- Confidence in forecasts: Higher confidence → higher DCF weight
- Market conditions: Bull/bear market affects comps reliability
- M&A likelihood: Higher if company in play or industry consolidating
- Company maturity: Mature companies → higher weight on comps; growth → higher DCF weight
Valuation Range
Always present a valuation range, not a point estimate:
Approach:
- Base Case: Most likely scenario
- Bull Case: Optimistic assumptions (revenue growth, margins)
- Bear Case: Conservative assumptions
Example:
Bear Case: $38 - $40
Base Case: $42 - $46
Bull Case: $48 - $52
Recommendation: BUY with target price of $45 (midpoint of base case)Sanity Checks
Cross-check valuation with:
- Historical multiples: Is current valuation in line with history?
- Peer comparison: Justified premium/discount vs. peers?
- Implied growth: What growth is market pricing in?
- Implied returns: IRR from current price to target price
- Market cap analysis: Does total market cap make sense?
Conclusion
Using all three valuation methods provides a robust framework for determining fair value:
- DCF provides intrinsic value based on fundamentals
- Trading Comps reflects current market valuation
- Precedent Transactions indicates M&A value and control premium
The key is to understand the assumptions driving each method and to present a well-reasoned valuation range that considers multiple scenarios and methodologies.
Install this Skill
Skills give your AI agent a consistent, structured approach to this task — better output than a one-off prompt.
npx skills add anthropics/financial-services-plugins --skill equity-research Official Anthropic skill. Need a walkthrough? See the install guide →
Works with
No terminal needed — Claude.ai works by pasting the skill into custom instructions.
Details
- Category
- Equity Research
- License
- Apache 2.0
- Author
- @anthropics
- Source
- GitHub →
- Source file
-
show path
equity-research/skills/initiating-coverage/SKILL.md