{"kind":"Skill","metadata":{"namespace":"community","name":"initiating-coverage","version":"0.1.0"},"spec":{"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.","files":{"SKILL.md":"---\nname: initiating-coverage\ndescription: 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.\n---\n\n# Initiating Coverage\n\nCreate institutional-quality equity research initiation reports through a structured 5-task workflow. Each task must be executed separately with verified inputs.\n\n## Overview\n\nThis 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.\n\n**Default Font**: Times New Roman throughout all documents (unless user specifies otherwise).\n\n---\n\n## ⚠️ CRITICAL: One Task at a Time\n\n**THIS SKILL OPERATES IN SINGLE-TASK MODE ONLY.**\n\n### If User Requests Full Pipeline\n\nWhen user requests:\n- \"Create a coverage initiation report for [Company]\"\n- \"Write an initiation report for [Company]\"\n- \"Do the entire equity research process for [Company]\"\n- \"Complete all 5 tasks for [Company]\"\n- Any request that implies running multiple tasks or the entire workflow\n\n**REQUIRED RESPONSE:**\n\n1. **Ask which specific task to perform:**\n   ```\n   I can help you create an equity research initiation report for [Company].\n   This involves 5 separate tasks that need to be completed individually:\n\n   1. Company Research - Research business, management, industry\n   2. Financial Modeling - Build projection model\n   3. Valuation Analysis - DCF and comparable companies\n   4. Chart Generation - Create 25-35 charts\n   5. Report Assembly - Compile final report\n\n   Which task would you like to start with?\n   ```\n\n2. **When user explicitly requests all tasks together:**\n   ```\n   I understand you'd like to complete the entire initiation report pipeline.\n   Currently, this skill supports executing one task at a time, which allows\n   for better quality control and review at each stage.\n\n   We're working on a seamless end-to-end workflow that will make this process\n   more automated, but for now, we'll need to complete each task separately.\n\n   Would you like to start with Task 1 (Company Research)?\n   ```\n\n3. **Never automatically assume which task to start** - always ask user to confirm.\n\n4. **Never execute multiple tasks in sequence** - complete one task, deliver outputs, then wait for next user request.\n\n### Task Execution Rules\n\n- ✅ Execute exactly ONE task per user request\n- ✅ Always verify prerequisites before starting a task\n- ✅ Deliver task outputs and confirm completion\n- ✅ Wait for user to explicitly request the next task\n- ❌ Never chain multiple tasks together automatically\n- ❌ Never assume user wants to proceed to next task\n- ❌ Never execute Tasks 3-5 without verifying required inputs exist\n\n### ⚠️ Deliverables Policy: NO SHORTCUTS\n\n**DELIVER ONLY THE SPECIFIED OUTPUTS. DO NOT CREATE EXTRA DOCUMENTS.**\n\nEach task specifies exact deliverables. Do NOT create:\n- ❌ \"Completion summaries\"\n- ❌ \"Executive summaries\"\n- ❌ \"Quick reference guides\"\n- ❌ \"Next steps documents\"\n- ❌ \"Task completion reports\"\n- ❌ Any other \"helpful\" documentation not explicitly specified\n\n**Why**: These extras waste context and are not part of the professional workflow.\n\n**What TO deliver**:\n- ✅ Task 1: Research document (.md) — **NOTHING ELSE**\n- ✅ Task 2: Financial model (.xlsx) — **NOTHING ELSE**\n- ✅ Task 3: Valuation analysis (.md) + Excel tabs added to Task 2 file — **NOTHING ELSE**\n- ✅ Task 4: Charts zip file (.zip) — **NOTHING ELSE**\n- ✅ Task 5: Final report (.docx) — **NOTHING ELSE**\n\n**If a deliverable is not listed above, DO NOT CREATE IT.**\n\n---\n\n## Task Selection\n\nSelect which task to execute:\n\n| Task | Name | Prerequisites | Output |\n|------|------|--------------|--------|\n| **1** | Company Research | Company name/ticker | 6-8K word document |\n| **2** | Financial Modeling | 10-K or financials access | Excel model (6 tabs) |\n| **3** | Valuation Analysis | Financial model (Task 2) | Valuation + price target |\n| **4** | Chart Generation | Tasks 1, 2, 3 + external data | 25-35 PNG/JPG charts |\n| **5** | Report Assembly | ALL previous tasks (1-4) | 30-50 page DOCX report |\n\n---\n\n## How to Use This Skill\n\n### User Request Patterns and Responses\n\n**Pattern 1: User specifies a specific task**\n```\nUser: \"Use initiating-coverage, Task 1 for Tesla\"\nResponse: ✅ Execute Task 1 immediately\n```\n\n**Pattern 2: User asks for \"initiation report\" or \"full pipeline\"**\n```\nUser: \"Create a coverage initiation report for Tesla\"\nResponse: ❌ DO NOT start any task automatically\n         ✅ Ask which task to start with (see template above)\n```\n\n**Pattern 3: User wants to do \"all tasks\" or \"entire workflow\"**\n```\nUser: \"I want to complete all 5 tasks for Tesla\"\nResponse: ❌ DO NOT chain tasks together\n         ✅ Explain one-at-a-time limitation (see template above)\n         ✅ Ask if they want to start with Task 1\n```\n\n### Correct Usage Examples\n\n**Executing a single task:**\n```\n\"Use initiating-coverage skill, Task 1 for Tesla\"\n\"Do Task 2 of initiating-coverage for Tesla\"\n\"Run Task 3 for Tesla using the initiating-coverage skill\"\n```\n\n**Completing full report (requires 5 separate requests):**\n```\nRequest 1: \"Do Task 1 for Tesla\" → Complete → Deliver outputs\nRequest 2: \"Do Task 2 for Tesla\" → Complete → Deliver outputs\nRequest 3: \"Do Task 3 for Tesla\" → Complete → Deliver outputs\nRequest 4: \"Do Task 4 for Tesla\" → Complete → Deliver outputs\nRequest 5: \"Do Task 5 for Tesla\" → Complete → Deliver outputs\n```\n\n### Task Execution Order\n\nFor a complete initiation report, tasks must be executed in separate user requests following this order:\n\n```\nRequest 1: Task 1 - Company Research (independent)\n           ↓ [User reviews outputs and requests next task]\nRequest 2: Task 2 - Financial Modeling (independent)\n           ↓ [User reviews outputs and requests next task]\nRequest 3: Task 3 - Valuation Analysis (requires Task 2 output)\n           ↓ [User reviews outputs and requests next task]\nRequest 4: Task 4 - Chart Generation (requires Tasks 2 \u0026 3 outputs)\n           ↓ [User reviews outputs and requests next task]\nRequest 5: Task 5 - Report Assembly (requires ALL previous task outputs)\n```\n\n**Note**: Tasks 1 and 2 can be run in any order. Tasks 3-5 have strict dependencies and must verify inputs before proceeding.\n\n---\n\n## Task 1: Company Research\n\n**Purpose**: Research company's business, management, competitive position, industry, and risks.\n\n**Prerequisites**: ✅ None (fully independent)\n- Company name or ticker symbol\n\n**Process**:\n1. Verify company name/ticker provided\n2. Load detailed instructions from references/task1-company-research.md\n3. Execute qualitative research workflow\n4. Deliver research document\n\n**Output**: Company Research Document (6,000-8,000 words)\n- Company overview \u0026 history\n- Management bios (300-400 words × 3-4 execs)\n- Products \u0026 services analysis\n- Industry overview\n- Competitive analysis (5-10 competitors)\n- TAM sizing\n- Risk assessment (8-12 risks)\n\n**File name**: `[Company]_Research_Document_[Date].md`\n\n**⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.**\n\n**⚠️ DO NOT TAKE SHORTCUTS:**\n- ✅ Write full 6,000-8,000 words (not summaries)\n- ✅ Complete 300-400 word bios for ALL 3-4 executives\n- ✅ Analyze ALL 5-10 competitors thoroughly\n- ✅ Cover all 8-12 risks across 4 categories\n- ❌ Do not abbreviate sections to save time\n- ❌ Do not skip any required sections\n\n**Verification before proceeding**: None required for this task.\n\n---\n\n## Task 2: Financial Modeling\n\n**Purpose**: Extract historical financials and build comprehensive Excel financial model with projections and scenarios.\n\n**Prerequisites**: ⚠️ Verify before starting\n- **Required**: Access to company financial data\n  - For public companies: Latest 10-K from SEC EDGAR\n  - For private companies: Financial statements or available estimates\n  - OR: Pre-extracted historical financials provided by user\n- **Optional**: Company research (Task 1) for business context\n\n**Input Verification**:\n```\nBEFORE STARTING - Select approach:\n\nOption A: Extract financials (most common)\n- [ ] Have access to 10-K or financial statements?\n- [ ] Ready to extract 3-5 years of data?\n\nOption B: User provided pre-extracted financials\n- [ ] Historical financials file received?\n- [ ] Contains income statement, cash flow, balance sheet (3-5 years)?\n\nOptional:\n- [ ] Company research (Task 1) complete for context?\n```\n\n**Process**:\n1. Verify access to financial data\n2. Load detailed instructions from references/task2-financial-modeling.md\n3. **Step 1**: Extract historical financials (if needed)\n4. **Step 2+**: Build projection model with 6 essential tabs\n5. Deliver Excel model\n\n**Output**: Excel Financial Model (.xlsx)\n- 6 essential tabs:\n  1. **Revenue Model** - Product breakdown (20-30 rows) + Geography breakdown (15-20 rows)\n  2. **Income Statement** - Full P\u0026L with 40-50 line items, historical (3-5 years) + projected (5 years)\n  3. **Cash Flow Statement** - Operating/Investing/Financing activities, historical + projected\n  4. **Balance Sheet** - Assets/Liabilities/Equity, historical + projected\n  5. **Scenarios** - Bull/Base/Bear comparison table\n  6. **DCF Inputs** - Prepared for Task 3 valuation\n\n**File name**: `[Company]_Financial_Model_[Date].xlsx`\n\n**⚠️ DELIVER ONLY THIS 1 FILE. NO completion summaries, no extra documents.**\n\n**⚠️ DO NOT TAKE SHORTCUTS:**\n- ✅ If extracting financials: Extract ALL line items from 3 financial statements (3-5 years)\n- ✅ Build ALL 6 projection tabs completely with full detail\n- ✅ Create detailed revenue model with 20-30 product rows AND 15-20 geography rows\n- ✅ Build complete income statement with 40-50 line items (not abbreviated)\n- ✅ Include full cash flow statement and balance sheet with all line items\n- ✅ Complete ALL three scenarios (Bull/Base/Bear) with different parameters\n- ❌ Do not create simplified/abbreviated versions\n- ❌ Do not skip any of the 6 essential tabs\n- ❌ Do not skip historical financials extraction if needed\n\n**Verification before proceeding to Task 3**:\n- [ ] Historical financials extracted (if needed) or provided\n- [ ] Excel file created and can be opened\n- [ ] Model has all 6 essential tabs (Revenue Model, Income Statement, Cash Flow, Balance Sheet, Scenarios, DCF Inputs)\n- [ ] Historical data (3-5 years) incorporated\n- [ ] Projections complete (5 years forward)\n- [ ] Scenarios complete (Bull/Base/Bear)\n\n---\n\n## Task 3: Valuation Analysis\n\n**Purpose**: Perform comprehensive valuation using DCF, comparables, and precedent transactions.\n\n**Prerequisites**: ⚠️ Verify before starting\n- **Required**: Financial model from Task 2\n  - Projected income statements\n  - Projected cash flows\n  - Revenue and EBITDA forecasts\n  - DCF inputs (unlevered FCF)\n\n**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASK 2 IS COMPLETE**\n\nThis task requires the financial model from Task 2. Starting without it will result in incomplete work.\n\n**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.\n\n**Input Verification**:\n```\nBEFORE STARTING:\n- [ ] Task 2 complete? (Financial model exists)\n- [ ] Model file path/location known?\n- [ ] Can access projected financials from model?\n\nRequired from model:\n- [ ] Projected FCF (5 years)\n- [ ] Revenue projections\n- [ ] EBITDA projections\n- [ ] Terminal year metrics\n```\n\n**Process**:\n1. Verify financial model is accessible\n2. Load detailed instructions from references/task3-valuation.md\n3. Execute valuation workflow\n4. Deliver valuation analysis\n\n**Output**: Valuation Analysis (4-6 pages + Excel tabs)\n- DCF analysis with sensitivity tables\n- Comparable companies (5-10 peers with statistical summary)\n- Precedent transactions (if applicable)\n- Valuation football field\n- **Price target**: $XX.XX\n- **Recommendation**: BUY/HOLD/SELL\n- **Upside**: XX%\n- Key catalysts (3-5)\n\n**Files**:\n- `[Company]_Valuation_Analysis_[Date].md` (written analysis document)\n- Excel tabs added to `[Company]_Financial_Model_[Date].xlsx` (from Task 2)\n  - DCF tab with calculations\n  - Sensitivity analysis tab\n  - Comparable companies tab\n  - Valuation summary tab\n\n**⚠️ DELIVER ONLY: 1 markdown file + 4 tabs added to existing Excel. NO completion summaries, no extra documents.**\n\n**⚠️ DO NOT TAKE SHORTCUTS:**\n- ✅ Complete full DCF analysis with sensitivity matrix (not simplified)\n- ✅ Analyze ALL 5-10 comparable companies with full data\n- ✅ Include statistical summary in comps table (max/75th/median/25th/min)\n- ✅ Create complete sensitivity analysis tab with multiple WACC and terminal growth scenarios\n- ✅ Write full 4-6 pages of valuation analysis (not abbreviated)\n- ✅ Research and justify price target with specific methodology\n- ❌ Do not skip comparable company analysis\n- ❌ Do not create simplified DCF without sensitivity\n\n**Verification before proceeding to Task 4**:\n- [ ] Price target determined\n- [ ] Valuation uses multiple methods (DCF + Comps minimum)\n- [ ] DCF sensitivity table complete\n- [ ] Comparable companies table includes statistical summary\n\n---\n\n## Task 4: Chart Generation\n\n**Purpose**: Generate 25-35 professional financial charts for the report.\n\n**Prerequisites**: ⚠️ Verify before starting\n- **Required**: Company research from Task 1\n  - Company history and milestones (for timeline charts)\n  - Management team and org structure (for org charts)\n  - Product portfolio (for product charts)\n  - Customer segmentation (for customer charts)\n  - Competitive landscape (for competitive charts)\n  - TAM analysis (for market size charts)\n- **Required**: Financial model from Task 2 (with Task 3 valuation tabs added)\n  - Revenue by product/geography data (Task 2 tabs)\n  - Margin trends (Task 2 tabs)\n  - Scenario comparison data (Task 2 tabs)\n  - DCF sensitivity table (Task 3 tab in same Excel file)\n  - Comparable companies data (Task 3 tab in same Excel file)\n  - Valuation ranges (Task 3 tab in same Excel file)\n- **Required**: External market data\n  - Historical stock price data (Yahoo Finance, Bloomberg, etc.)\n  - Historical valuation multiples (for historical trend charts)\n\n**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASKS 1, 2, AND 3 ARE COMPLETE**\n\nThis task requires outputs from all three previous tasks. Starting without them will result in incomplete charts.\n\n**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:\n- Task 1: Company research document (for 9 charts)\n- Task 2: Financial model with all 6 tabs (for 8 charts)\n- Task 3: Valuation tabs added to the model (for 6 charts)\n- External data access (for 2 charts)\n\nDo not attempt to create placeholder charts or skip charts due to missing data.\n\n**Input Verification**:\n```\nBEFORE STARTING:\n- [ ] Task 1 complete? (Company research exists)\n- [ ] Task 2 complete? (Financial model exists)\n- [ ] Task 3 complete? (Valuation analysis exists)\n- [ ] Can access external market data sources?\n\nRequired from Task 1:\n- [ ] Company history and milestones (for charts 05, 06)\n- [ ] Management team structure (for chart 07)\n- [ ] Product portfolio details (for chart 08)\n- [ ] Customer segmentation data (for chart 09)\n- [ ] Competitive landscape analysis (for charts 16, 17, 18)\n- [ ] TAM sizing and market data (for chart 15)\n\nRequired from Task 2:\n- [ ] Revenue by product (historical + projected) - for chart 03 ⭐\n- [ ] Revenue by geography (historical + projected) - for chart 04 ⭐\n- [ ] Income statement with margins (for charts 02, 10, 11)\n- [ ] Cash flow statement (for chart 12)\n- [ ] Scenario comparison data (for chart 14)\n\nRequired from Task 3:\n- [ ] DCF sensitivity matrix - for chart 28 ⭐\n- [ ] DCF components (for chart 29)\n- [ ] Comparable companies data (for charts 30, 31)\n- [ ] Valuation ranges - for chart 32 ⭐\n\nRequired from External Sources:\n- [ ] Historical stock price data (for chart 01)\n- [ ] Historical valuation multiples (for chart 34)\n```\n\n**Process**:\n1. Verify model and valuation outputs are accessible\n2. Load detailed instructions from references/task4-chart-generation.md\n3. Execute chart generation workflow\n4. Package all charts into a zip file\n5. Deliver zip file\n\n**Output**: 25-35 Professional Chart Files (PNG/JPG, 300 DPI) packaged in zip\n\n**4 MANDATORY Charts** (must be present) ⭐:\n- chart_03: Revenue by product (stacked area)\n- chart_04: Revenue by geography (stacked bar)\n- chart_28: DCF sensitivity (2-way heatmap)\n- chart_32: Valuation football field (horizontal bars)\n\n**25 REQUIRED Charts** (specific list):\n- Investment Summary: chart_01\n- Financial Performance: charts 02, 03⭐, 04⭐, 10, 11, 12, 14\n- Company 101: charts 05, 06, 07, 08, 09, 15, 16\n- Competitive/Market: charts 17, 18\n- Scenario Analysis: chart 13\n- Valuation: charts 28⭐, 29, 30, 31, 32⭐, 33, 34\n\n**10 OPTIONAL Charts** (for 26-35 range):\n- charts 19-27, 35 (customer acquisition, unit economics, product roadmap, etc.)\n\n**IMPORTANT**: Task 5 embeds ALL charts created (25-35) for visual density (1 chart per 200-300 words).\n\n**File naming**: `chart_01_description.png`, `chart_02_description.png`, etc.\n\n**Deliverable**: `[Company]_Charts_[Date].zip` containing all 25-35 chart files + chart_index.txt\n\n**⚠️ DELIVER ONLY THIS 1 ZIP FILE. NO completion summaries, no separate chart lists, no extra documents.**\n\n**⚠️ DO NOT TAKE SHORTCUTS:**\n- ✅ Create ALL 25 required charts minimum (specific list provided in task4-chart-generation.md)\n- ✅ Include ALL 4 mandatory charts:\n  - chart_03: Revenue by product (stacked area) ⭐\n  - chart_04: Revenue by geography (stacked bar) ⭐\n  - chart_28: DCF sensitivity (heatmap) ⭐\n  - chart_32: Valuation football field ⭐\n- ✅ Optional: Add 1-10 more charts to reach 26-35 total for greater visual density\n- ✅ Generate professional-quality charts at 300 DPI (not low-res placeholders)\n- ✅ Create unique, well-formatted charts for each visualization\n- ✅ Package all charts in zip file with chart index\n- ❌ Do not create only 10-15 charts (minimum is 25)\n- ❌ Do not skip any of the 4 mandatory charts\n- ❌ Do not use low-quality/placeholder images\n\n**Verification before proceeding to Task 5**:\n- [ ] Minimum 25 chart files created (required)\n- [ ] All 4 mandatory charts present:\n  - [ ] chart_03: Revenue by product ⭐\n  - [ ] chart_04: Revenue by geography ⭐\n  - [ ] chart_28: DCF sensitivity ⭐\n  - [ ] chart_32: Valuation football field ⭐\n- [ ] All charts open and display correctly\n- [ ] Charts saved at 300 DPI (print quality)\n- [ ] Chart index created listing all files with categories\n- [ ] All charts packaged in zip file\n- [ ] File naming follows convention: chart_##_description.png\n\n---\n\n## Task 5: Report Assembly\n\n**Purpose**: Write and assemble the comprehensive final DOCX report.\n\n**Prerequisites**: ⚠️ Verify before starting\n- **Required**: Company research from Task 1\n  - All 6-8K words of content\n  - Management bios\n  - Competitive analysis\n  - Risk assessment\n- **Required**: Financial model from Task 2\n  - Excel workbook\n  - All projections and scenarios\n- **Required**: Valuation analysis from Task 3\n  - Price target and recommendation\n  - DCF, comps, precedent transactions\n  - All valuation data\n- **Required**: Chart files from Task 4\n  - Zip file containing all 25-35 PNG/JPG files\n  - Chart index included in zip\n\n**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS ALL TASKS 1-4 ARE COMPLETE**\n\nThis is the final assembly task. It cannot be completed without all previous work products.\n\n**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:\n- Task 1: Company research document (6-8K words)\n- Task 2: Financial model with all 6 tabs\n- Task 3: Valuation analysis with price target and recommendation\n- Task 4: Charts zip file with 25-35 charts\n\nDo not attempt to create placeholder content, substitute missing sections, or assemble an incomplete report. The report requires ALL inputs to be publication-ready.\n\n**Input Verification**:\n```\nBEFORE STARTING - ALL TASKS MUST BE COMPLETE:\n\nTask 1 Verification:\n- [ ] Company research document exists? (6-8K words)\n- [ ] Management bios complete? (300-400 words × 3-4 execs)\n- [ ] Competitive analysis complete? (5-10 competitors)\n- [ ] Risk assessment complete? (8-12 risks)\n\nTask 2 Verification:\n- [ ] Financial model exists and can be opened?\n- [ ] Model has projections (5 years)?\n- [ ] Scenarios exist (Bull/Base/Bear)?\n\nTask 3 Verification:\n- [ ] Valuation analysis complete?\n- [ ] Price target determined?\n- [ ] Recommendation set? (BUY/HOLD/SELL)\n- [ ] DCF and comps complete?\n\nTask 4 Verification:\n- [ ] Chart zip file exists?\n- [ ] Can extract/access all 25-35 chart files from zip?\n- [ ] All 4 mandatory charts present?\n  - [ ] Revenue by product (stacked area)\n  - [ ] Revenue by geography (stacked bar)\n  - [ ] DCF sensitivity (heatmap)\n  - [ ] Valuation football field\n- [ ] Chart files accessible and can be opened?\n\nIF ANY VERIFICATION FAILS: Stop and complete missing task first.\n```\n\n**Process**:\n1. **CRITICAL**: Verify ALL prerequisites before starting\n2. Load detailed instructions from references/task5-report-assembly.md\n3. Execute report assembly workflow using Claude's built-in skills:\n   - **Use DOCX skill** to create and manipulate the Word document\n   - **Use XLSX skill** to read Excel data from Task 2/3\n   - **Use Read tool** to read Task 1 and Task 3 markdown files\n   - Read Task 1 .md file → Convert to Word formatting → Insert charts inline\n   - Read Task 2 .xlsx file → Extract tables → Write quantitative analysis\n   - Read Task 3 .md file + Excel tabs → Copy/adapt valuation analysis\n   - Insert Task 4 .png chart files throughout using DOCX skill\n   - Create text-dense report with charts interspersed every 200-300 words\n4. Save and deliver final DOCX report\n\n**Key Principles**:\n- Use Claude's DOCX and XLSX skills (NOT Python libraries)\n- Use actual file operations (read .md/.xlsx/.png files, write .docx file)\n- Good equity research reports are text-dense with lots of illustrating images (60-80% page coverage, 1+ chart per page)\n\n**🔥 CRITICAL: GO ALL OUT ON THIS TASK**\n\n**THIS IS THE FINAL DELIVERABLE. DO NOT TAKE SHORTCUTS.**\n\n- ✅ **Use full token budget** - This is the culmination of all previous work\n- ✅ **Write every section completely** - Do not summarize or abbreviate\n- ✅ **Hit ALL minimum requirements** - 30+ pages, 10,000+ words, 25+ charts, 12+ tables\n- ✅ **Be thorough on projection assumptions** - 2,000-3,000 words with product-by-product detail\n- ✅ **Be comprehensive on scenarios** - 1,500-2,000 words with specific Bull/Base/Bear parameters\n- ✅ **Insert ALL charts from Task 4** - Not just a few, ALL 25-35 charts throughout\n- ✅ **Create ALL tables from Task 2/3** - Extract every financial table, don't skip any\n- ✅ **Use Task 1 content verbatim** - Copy/paste full Company 101 sections (6-8K words)\n- ✅ **Professional quality only** - This must be indistinguishable from JPMorgan/Goldman Sachs research\n\n**NEVER:**\n- ❌ \"This section would include...\" - WRITE THE ACTUAL SECTION\n- ❌ \"Charts would be inserted here...\" - INSERT THE ACTUAL CHARTS\n- ❌ \"See financial model for details...\" - EXTRACT AND INCLUDE THE DETAILS\n- ❌ Skip sections due to length - Every section MUST be complete\n- ❌ Abbreviate for token conservation - Use whatever tokens are needed\n\n**This is publication-ready institutional research. Spare no effort, tokens, or detail.**\n\n**Output**: Comprehensive Equity Research Report (.docx)\n\n**Specifications**:\n- **Length**: 30-50 pages (MINIMUM 30)\n- **Word count**: 10,000-15,000 words (MINIMUM 10,000)\n- **Charts**: 25-35 embedded images\n- **Tables**: 12-20 comprehensive tables\n- **Format**: Professional DOCX with clickable hyperlinks\n\n**Structure**:\n- Page 1: Investment Summary (INITIATING COVERAGE format)\n- Pages 2-5: Investment thesis \u0026 risks\n- Pages 6-17: Company 101\n- Pages 18-30: Financial analysis \u0026 projections\n- Pages 31-40: Valuation analysis\n- Pages 41-50: Appendices\n\n**File name**: `[Company]_Initiation_Report_[Date].docx`\n\n**⚠️ DELIVER ONLY THIS 1 DOCX FILE. NO executive summaries, no \"highlights\" documents, no extra files.**\n\n**Final Verification**:\n- [ ] Report is 30-50 pages\n- [ ] Word count is 10,000-15,000\n- [ ] 25-35 charts embedded\n- [ ] 12-20 tables included\n- [ ] All citations are clickable hyperlinks\n- [ ] Numbers match financial model exactly\n\n---\n\n## Input Verification Protocol\n\n### Why Input Verification Matters\n\nEach task has strict prerequisites. Running a task without required inputs will:\n- Waste time with incomplete work\n- Produce low-quality outputs\n- Require rework\n\n**Always verify inputs before starting a task.**\n\n### Verification Checklist by Task\n\n**Task 1**: ✅ No verification needed (independent)\n\n**Task 2**: Check historical financials available\n\n**Task 3**: Check financial model exists and is accessible\n\n**Task 4**: Check both model (Task 2) AND valuation (Task 3) exist\n\n**Task 5**: Check ALL previous tasks complete (1, 2, 3, 4)\n\n### What to Do if Verification Fails\n\n```\nIF prerequisites are missing:\n1. Stop the current task\n2. Identify which prerequisite task(s) need to be completed\n3. Execute the missing task(s) first\n4. Return to current task once prerequisites are met\n```\n\n### Example Verification Dialogue\n\n```\nUser: \"Use initiating-coverage, Task 5 for Tesla\"\n\nClaude: \"Starting Task 5: Report Assembly for Tesla\n\nVERIFICATION - Checking prerequisites:\n- Task 1 (Company research)... ❌ NOT FOUND\n- Task 2 (Financial model)... ❌ NOT FOUND\n- Task 3 (Valuation)... ❌ NOT FOUND\n- Task 4 (Charts)... ❌ NOT FOUND\n\n⚠️ VERIFICATION FAILED\n\nTask 5 requires ALL previous tasks to be complete.\n\nTo proceed:\n1. Complete Task 1: Company Research\n2. Complete Task 2: Financial Modeling\n3. Complete Task 3: Valuation Analysis\n4. Complete Task 4: Chart Generation\n5. Then return to Task 5\n\nWould you like to start with Task 1 first?\"\n```\n\n---\n\n## Task Reference Files\n\nDetailed instructions for each task are in separate reference files to keep this skill lean:\n\n- **references/task1-company-research.md** - Company research workflow\n- **references/task2-financial-modeling.md** - Financial modeling workflow\n- **references/task3-valuation.md** - Valuation methodology\n  - Also see: references/valuation-methodologies.md for DCF/comps deep dive\n- **references/task4-chart-generation.md** - Chart generation workflow\n- **references/task5-report-assembly.md** - Report writing workflow\n  - Also see: assets/report-template.md for report structure\n  - Also see: assets/quality-checklist.md for quality checks\n\n**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.\n\n---\n\n## Quality Standards\n\nAll outputs meet institutional standards from leading investment banks (JPMorgan, Goldman Sachs, Morgan Stanley):\n\n- **Comprehensive**: Meet all minimum requirements\n- **Detailed**: Specific data and examples, not generic statements\n- **Quantified**: Lead with numbers and metrics\n- **Cited**: Proper sources with clickable hyperlinks\n- **Professional**: Institutional-quality formatting\n- **Accurate**: All numbers verified and cross-checked\n\n---\n\n## Important Notes\n\n### Task Independence\n\n- **Task 1** can run anytime (no dependencies)\n- **Task 2** can run anytime (just needs historical data)\n- **Tasks 1 \u0026 2** can run in parallel\n- **Task 3** requires Task 2\n- **Task 4** requires Tasks 2 \u0026 3\n- **Task 5** requires Tasks 1, 2, 3, \u0026 4\n\n### Session Management\n\n**Same session**: Outputs automatically available to subsequent tasks\n\n**Different sessions**: Reference previous task outputs explicitly\n```\n\"Use Task 3 with the model from yesterday at [path]\"\n\"Use Task 5 with the research document at [path]\"\n```\n\n### File Organization\n\nRecommended structure during workflow:\n```\nProjectFolder/\n├── Task1_Research/\n│   └── [Company]_Research_Document.md\n├── Task2_Model/\n│   └── [Company]_Financial_Model.xlsx\n├── Task3_Valuation/\n│   └── [Company]_Valuation_Analysis.pdf\n├── Task4_Charts/\n│   ├── chart_01.png\n│   └── ... (25-35 files)\n└── Task5_Report/\n    └── [Company]_Initiation_Report.docx\n```\n\n### No End-to-End Execution\n\nThis skill does **NOT** support running all tasks automatically in sequence. Each task must be explicitly requested and verified.\n\n**Why**: This ensures:\n- Quality control at each stage\n- Ability to review outputs before proceeding\n- Flexibility to pause/resume workflow\n- Clear verification of prerequisites\n\n---\n\n## Success Criteria\n\nA successful initiation report workflow should:\n1. Complete all 5 tasks in order\n2. Pass all input verifications\n3. Meet all quality standards\n4. Produce all required deliverables\n5. Numbers cross-check between outputs\n6. Final report is publication-ready\n\n**Output quality**: Institutional (JPMorgan/Goldman/Morgan Stanley level)\n**Use case**: First-time comprehensive coverage of a company\n","assets/quality-checklist.md":"# Quality Control Checklist for Initiation Reports\n\nBefore delivering an initiation report, verify all items below are complete.\n\n## Critical Minimums - Reports Must Meet These\n\n**CRITICAL DO NOT DELIVER IF:**\n- ❌ DOCX report fewer than 30 pages → INCOMPLETE\n- ❌ Fewer than 25 embedded charts → INCOMPLETE\n- ❌ Fewer than 12 comprehensive tables → INCOMPLETE\n- ❌ Fewer than 10,000 words → INCOMPLETE\n- ❌ No XLS financial model → MISSING DELIVERABLE\n- ❌ Charts are text descriptions, not actual PNG/JPG files → MAJOR FAILURE\n\n## Deliverables Checklist\n\n- [ ] DOCX report file created\n- [ ] XLS financial model file created\n- [ ] Both files named properly: `[Company]_Initiation_Report_[Date].docx` and `[Company]_Financial_Model_[Date].xlsx`\n\n## DOCX Report - Length \u0026 Content\n\n**Length Verification:**\n- [ ] Report is 30-50 pages (count pages in final document)\n- [ ] Word count is 10,000-15,000 words\n- [ ] If under 30 pages: STOP and add more content\n\n**Visual Elements:**\n- [ ] 25-35 charts embedded (count them: _____ charts)\n- [ ] All charts are actual PNG/JPG image files (NOT text descriptions)\n- [ ] 12-20 comprehensive tables included (count them: _____ tables)\n- [ ] Charts and tables interspersed throughout, not grouped at end\n\n**Chart Requirements:**\n- [ ] Revenue by product chart: Stacked Area format ✓\n- [ ] Revenue by geography chart: Stacked Bar format ✓\n- [ ] DCF sensitivity: 2-way Heat Map with color coding ✓\n- [ ] Valuation football field: Horizontal bar chart ✓\n- [ ] All other charts are actual image files ✓\n\n**Table Requirements:**\n- [ ] Full Income Statement (40-50 rows) with 5 years historical + 5 years projected\n- [ ] Full Cash Flow Statement (30-40 rows)\n- [ ] Full Balance Sheet (35-45 rows)\n- [ ] Revenue by product table (20-30 rows)\n- [ ] Revenue by geography table (15-20 rows)\n- [ ] Revenue by channel table (10-15 rows)\n- [ ] Comparable companies table with statistical summary (max/75th/median/25th/min)\n- [ ] DCF calculation table (30-40 rows)\n- [ ] WACC calculation table (8-10 rows)\n- [ ] Two sensitivity tables\n- [ ] 2-3 additional financial/competitive tables\n\n## DOCX Report - Structure\n\n**Page 1 Requirements:**\n- [ ] \"INITIATING COVERAGE\" header present (NOT \"Company Update\")\n- [ ] Thesis-focused title (NOT event-driven like \"Strong Q4 Results\")\n- [ ] Rating box with rating, price, target price, 52-week range, market cap, EV\n- [ ] 3-4 paragraph-length bullets with ■ character and bold headers\n- [ ] Financial \u0026 valuation metrics table with 2-3 years historical, 2 years projected\n- [ ] Table shows \"A\" suffix for actuals, \"E\" suffix for estimates\n- [ ] Source lines on all visuals\n\n**Content Sections:**\n- [ ] Table of Contents (Page 2)\n- [ ] Investment Thesis \u0026 Risks (3-5 pages)\n- [ ] Company Overview (6-12 pages) including:\n  - [ ] Company description\n  - [ ] History and milestones\n  - [ ] Management bios (300-400 words EACH for 3-4 executives)\n  - [ ] Products/services detail\n  - [ ] Competitive landscape\n- [ ] Financial Analysis \u0026 Projections (10-15 pages)\n- [ ] Valuation Analysis (8-12 pages)\n- [ ] Assumptions section (2,000-3,000 words documenting ALL projection assumptions)\n- [ ] Scenario Analysis (1,500-2,000 words with Bull/Base/Bear parameters)\n- [ ] Appendices including Data Sources \u0026 References page\n\n## DOCX Report - Formatting\n\n**Figure \u0026 Table Formatting:**\n- [ ] Every figure has caption above: \"Figure X - [Company] [Descriptive Title]\"\n- [ ] Every figure has source line below: \"Source: [Specific sources with dates]\"\n- [ ] Sequential figure numbering (Figure 1, 2, 3... no gaps)\n- [ ] Every table has header row with shading\n- [ ] Every table has source line at bottom\n- [ ] All years use \"A\" for actual, \"E\" for estimate notation\n\n**Professional Formatting:**\n- [ ] Consistent fonts throughout (Calibri, Arial, or similar)\n- [ ] Headers and footers with page numbers\n- [ ] Dense layout: 60-80% page coverage, minimal white space\n- [ ] Every page has both text AND visuals (charts or tables)\n- [ ] Professional business report template used\n\n## Citations \u0026 Sources ⭐⭐⭐ CRITICAL\n\n**Source Attribution:**\n- [ ] Every figure has specific source with document name and date\n- [ ] Every table has specific source with document reference\n- [ ] Key statistics throughout text have footnotes with sources\n- [ ] NOT just generic \"Company data\" - must be specific\n\n**Hyperlinks:** ⭐⭐⭐ MANDATORY\n- [ ] ALL URLs are CLICKABLE HYPERLINKS (not plain text)\n- [ ] SEC filings hyperlinked to EDGAR viewer\n- [ ] Earnings transcripts hyperlinked (Seeking Alpha or company IR)\n- [ ] Press releases hyperlinked to company IR page\n- [ ] Presentations hyperlinked to PDF URLs\n- [ ] Industry reports hyperlinked (if publicly available)\n- [ ] Subscription data (Bloomberg, FactSet) noted as \"(subscription required)\"\n- [ ] No raw URLs displayed anywhere - all formatted as hyperlinks\n- [ ] Test 3-5 sample hyperlinks to ensure they work (Ctrl+Click)\n\n**Reference Page:**\n- [ ] \"Data Sources \u0026 References\" page at end of report\n- [ ] Lists ALL sources used in report\n- [ ] Sources organized by category (SEC Filings, Earnings Transcripts, etc.)\n- [ ] Every source has date\n- [ ] Every source has clickable hyperlink (where applicable)\n\n## XLS Financial Model - Structure\n\n**File Structure:**\n- [ ] 15+ tabs in Excel workbook\n- [ ] 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\n\n**Formatting:**\n- [ ] Blue text for hardcoded inputs\n- [ ] Black text for formulas\n- [ ] Green text for links to other sheets\n- [ ] Professional formatting with borders and shading\n- [ ] Clear section headers and labels\n\n**Model Functionality:**\n- [ ] All numbers flow (change assumption → entire model updates)\n- [ ] DCF links to assumptions and projections\n- [ ] No circular references or errors\n- [ ] All important cells/ranges are named\n- [ ] Sensitivity tables work dynamically\n\n## XLS Financial Model - Content\n\n**Projections:**\n- [ ] 3-5 years historical data\n- [ ] 5 years forward projections (FY+1 through FY+5)\n- [ ] Revenue broken down by product, geography, channel\n- [ ] Full P\u0026L with 40-50 line items\n- [ ] Full cash flow with 30-40 line items\n- [ ] Full balance sheet with 35-45 line items\n\n**Valuation:**\n- [ ] Complete DCF model with all calculations shown\n- [ ] WACC calculation with all components\n- [ ] Terminal value calculation\n- [ ] Comparable companies analysis (5-10 companies)\n- [ ] Precedent transactions analysis (5-10 deals)\n- [ ] Scenario analysis (Bull/Base/Bear)\n- [ ] Two sensitivity tables\n\n## Cross-File Consistency\n\n**CRITICAL**: Numbers must match EXACTLY between DOCX and XLS\n\n- [ ] Revenue numbers match across both files\n- [ ] EPS numbers match across both files\n- [ ] Margin percentages match across both files\n- [ ] Valuation numbers match across both files\n- [ ] Price target matches across both files\n- [ ] All projected years match across both files\n\n**Verification Method**: Spot check 10-15 key numbers between DOCX report and XLS model.\n\n## Content Quality\n\n**Investment Thesis:**\n- [ ] 3-5 clear thesis pillars\n- [ ] Each pillar supported with specific data and quantification\n- [ ] Financial impact quantified for each pillar\n- [ ] Catalysts identified with timelines\n\n**Analysis Depth:**\n- [ ] Comprehensive business model analysis\n- [ ] Detailed competitive assessment\n- [ ] 3-5 year financial trends analyzed\n- [ ] 8-12 risks identified and quantified\n- [ ] Management team analyzed (300-400 words per executive)\n\n**Assumptions:**\n- [ ] 2,000-3,000 words documenting ALL assumptions\n- [ ] Revenue growth assumptions by category/geography\n- [ ] Margin assumptions with bridge showing drivers\n- [ ] Working capital assumptions\n- [ ] CapEx assumptions\n- [ ] Each assumption has specific quantification\n\n**Scenarios:**\n- [ ] 1,500-2,000 words on scenario analysis\n- [ ] Bull case with specific parameters and catalysts\n- [ ] Base case with detailed rationale\n- [ ] Bear case with specific triggers\n- [ ] Probability assessments for each scenario\n\n## Writing Quality\n\n**Style:**\n- [ ] Lead with numbers (\"Revenue grew 15% to $1.2B\" not \"Strong revenue\")\n- [ ] Use \"vs.\" not \"versus\"\n- [ ] Be direct and concise\n- [ ] Professional institutional tone throughout\n- [ ] No informal language\n\n**Accuracy:**\n- [ ] No typos in ticker symbol\n- [ ] No typos in company name\n- [ ] All dates accurate\n- [ ] All calculations verified\n- [ ] Charts match text descriptions\n- [ ] All numbers properly formatted ($ signs, % signs, commas)\n\n## Pre-Delivery Final Check\n\nRun through this quick final review:\n\n1. **Deliverables**: Both DOCX and XLS files created ✓\n2. **Length**: DOCX is 30-50 pages ✓\n3. **Charts**: 25-35 actual PNG/JPG files embedded ✓\n4. **Tables**: 12-20 comprehensive tables included ✓\n5. **Words**: 10,000-15,000 words ✓\n6. **Hyperlinks**: Test 3-5 hyperlinks - all work ✓\n7. **Cross-check**: Spot check 10 numbers match between DOCX and XLS ✓\n8. **Page 1**: \"INITIATING COVERAGE\" header present ✓\n\nIf ANY item fails, DO NOT DELIVER. Go back and fix.\n\n## Actual Count Verification\n\n**Before delivery, fill in actual counts:**\n\nDOCX Report:\n- Page count: _____ pages (MUST BE 30-50)\n- Chart count: _____ charts (MUST BE 25-35)\n- Table count: _____ tables (MUST BE 12-20)\n- Word count: _____ words (MUST BE 10,000-15,000)\n\nXLS Model:\n- Tab count: _____ tabs (SHOULD BE 15+)\n- Model years: _____ historical + _____ projected\n\nIf any count is below minimum, STOP and add content before delivery.\n","assets/report-template.md":"# Equity Research Initiation Report Template\n\nThis template provides the structure for creating a comprehensive equity research initiation report. Use this as a guide when constructing the final report document.\n\n**NOTE:** The actual report MUST be created using the DOCX skill. DO NOT generate markdown content.\n\n**CRITICAL REQUIREMENTS:**\n1. **Generate 20-30+ chart images** using Python (matplotlib/plotly) BEFORE creating the Word document\n2. **Use DOCX skill**: Create professional report with proper styles, headers/footers, and formatting\n3. **Embed actual chart images**: Insert the generated PNG/JPG chart files into the Word document at appropriate locations\n4. **NO MARKDOWN**: Do not generate markdown content. Use DOCX skill to create a .docx file.\n\n**CRITICAL FORMATTING GUIDANCE:**\n- **MAXIMUM DENSITY**: Every page should be packed with information. Intersperse text, charts, and tables throughout.\n- **NO ORPHANED SECTIONS**: Never have a section header alone or a single chart on its own page.\n- **20-30+ ACTUAL CHART IMAGES**: Generate charts as image files, then embed within text sections using DOCX skill.\n\n---\n\n## PAGE 1: INVESTMENT UPDATE (MOST IMPORTANT PAGE)\n\n**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.\n\n**IMPORTANT STRUCTURAL NOTES:**\n- This is an \"Investment Update\" or \"Company Update\" page, not \"Executive Summary\"\n- Uses a rating box in top left corner\n- Features stock price performance chart (Figure 1) prominently\n- Contains 3-4 detailed bullet points with ■ character\n- Each bullet has **bold topic header** followed by 3-5 sentence explanation\n- Bottom section has financial and valuation metrics table\n- All charts must have figure numbers (Figure 1, Figure 2, etc.) with source lines\n\n### Layout Structure\n\n**TOP LEFT - RATING BOX:**\n```\nRating:             [OUTPERFORM / NEUTRAL / UNDERWEIGHT / etc.]\nPrice ([Date]):     $[XX.XX]\nTarget Price:       $[XX.XX]\n52-Week Range:      $[XX.XX] - $[XX.XX]\nMarket Cap:         $[XX.X]B\nEnterprise Value:   $[XX.X]B\n```\n\n**TOP LEFT - RESEARCH ANALYSTS:**\n```\n[Name], [Credentials (Ph.D., CFA, M.D., etc.)]\n[Email] | [Phone]\n\n[Name 2], [Credentials]\n[Email] | [Phone]\n```\n\n**TOP RIGHT - STOCK PRICE PERFORMANCE:**\n```\nFigure 1 - [Company Name] Stock Price Performance\n[Line chart showing stock price over 12-24 months with benchmark comparison]\nSource: Company data, [Firm Name] estimates.\n```\n\n**MAIN CONTENT - GRAY HEADER BAR:**\n```\n[OUTPERFORM / NEUTRAL / etc.] RECOMMENDATION / COMPANY UPDATE\n```\n\n**MAIN CONTENT - DETAILED BULLETS (3-4 bullets):**\n\nUse ■ character for bullets. Each bullet follows this format:\n```\n■ **[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.\n\n■ **[Second Topic Header].** [3-5 sentences of detailed explanation...]\n\n■ **[Third Topic Header].** [3-5 sentences of detailed explanation...]\n\n■ **[Fourth Topic Header - Optional].** [3-5 sentences of detailed explanation...]\n```\n\n**EXAMPLE BULLET FORMAT:**\n```\n■ **Vertical SaaS leadership and regulatory moat should enable $50bn+ TAM by 2030.**\nDeep domain expertise in healthcare IT, strong customer retention (95%+ net revenue retention),\nand cross-sell capabilities have driven Acme Health's market expansion. With the healthcare IT\nmarket expected to reach $50bn+ by 2030, Acme Health is well-positioned to capture share given\nits regulatory moat and high switching costs. Management has indicated that 70% of current\nrevenue comes from enterprise hospital systems, suggesting strong product-market fit.\n```\n\n**BOTTOM SECTION - FINANCIAL AND VALUATION METRICS TABLE:**\n```\n                            [Year-3]A   [Year-2]A   [Year-1]A   [Year]E    [Year+1]E\nRevenue ($M)                [X]         [X]         [X]         [X]        [X]\nRevenue Growth (%)          X.X%        X.X%        X.X%        X.X%       X.X%\nGross Margin (%)           X.X%        X.X%        X.X%        X.X%       X.X%\nEBITDA ($M)                [X]         [X]         [X]         [X]        [X]\nEBITDA Margin (%)          X.X%        X.X%        X.X%        X.X%       X.X%\nEPS ($)                    X.XX        X.XX        X.XX        X.XX       X.XX\nP/E (x)                    XX.Xx       XX.Xx       XX.Xx       XX.Xx      XX.Xx\nEV/Revenue (x)             X.Xx        X.Xx        X.Xx        X.Xx       X.Xx\nEV/EBITDA (x)              XX.Xx       XX.Xx       XX.Xx       XX.Xx      XX.Xx\n\nNote: Use \"A\" suffix for actual/historical years, \"E\" suffix for estimated/projected years\nSource: Company data, [Firm Name] estimates.\n```\n\n---\n\n## FIGURE NUMBERING AND FORMATTING STANDARDS\n\n**CRITICAL**: All charts, graphs, and tables must follow strict figure numbering conventions used in professional equity research.\n\n### Figure Numbering Format\n\n**Every chart/table must have:**\n1. **Sequential numbering**: Figure 1, Figure 2, Figure 3, etc. (continue sequentially throughout entire report)\n2. **Descriptive title**: \"Figure X - [Company] [Specific Metric] [Type of Chart/Analysis]\"\n3. **Source line** (always at bottom): \"Source: Company data, [Firm Name] estimates.\"\n\n**Examples:**\n- Figure 1 - [Company] Stock Price Performance\n- Figure 2 - [Company] Historical and Projected Revenue Mix by Product\n- Figure 3 - [Company] Revenue by Geographic Region\n- Figure 4 - [Product Name] Revenue and Price per Patient per Year\n- Figure 5 - [Company] Gross Margin Evolution\n- Figure 6 - DCF Sensitivity Analysis ($/share)\n- Figure 7 - Valuation Football Field\n\n### Caption Format\n\n```\nFigure X - [Descriptive Title]\n[Chart/Table/Graph content]\nSource: Company data, [Firm Name] estimates.\n```\n\nFor tables with multiple data sources:\n```\nFigure X - [Descriptive Title]\n[Table content]\nSource: Company filings, FactSet, [Firm Name] estimates.\n```\n\n### Placement Guidelines\n\n- Figures should be numbered in order of appearance in the report\n- First figure (Figure 1) is typically the stock price chart or revenue growth trajectory on Page 1\n- Each figure must have its caption directly below the visual\n- Source line should be in smaller font, italicized, at the very bottom of the figure\n\n---\n\n## PAGE 2: TABLE OF CONTENTS\n\n```\nExecutive Summary....................................................1\nInvestment Thesis \u0026 Risks..........................................3\nCompany Overview.......................................................6\n  Business Description \u0026 History................................6\n  Management \u0026 Ownership..........................................8\n  Products \u0026 Technology...........................................9\n  Customers \u0026 Go-to-Market......................................11\nGrowth Outlook \u0026 Drivers...........................................13\nFinancial Analysis \u0026 Performance.................................16\n  Historical Performance........................................16\n  Financial Projections.........................................19\nIndustry Overview \u0026 Competitive Landscape.....................21\n  Market Size \u0026 TAM..............................................21\n  Competitive Analysis..........................................23\n  Industry Trends................................................25\nValuation Analysis..................................................27\nAppendices \u0026 Disclosures...........................................31\n```\n\n---\n\n## PAGES 3-5: INVESTMENT THESIS \u0026 RISKS\n\n**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.\n\n### Investment Thesis\n\n**[Thesis Pillar 1]: [Title - e.g., \"Large and Growing TAM\"]**\n\n[Opening sentence with key statistic]\n\n[Paragraph 1: Market opportunity quantification]\n- Current market size\n- Growth drivers\n- Company's positioning\n\n[Paragraph 2: Why company will capture share]\n- Competitive advantages\n- Go-to-market strategy\n- Early traction/proof points\n\n[Paragraph 3: Financial impact]\n- Revenue opportunity\n- Margin profile\n- Timeline\n\n**[EMBED CHART: TAM Growth Chart]** - Stacked area chart showing market size evolution and company's opportunity\n\n**[Thesis Pillar 2]: [Title - e.g., \"Differentiated Technology/Product\"]**\n\n[Similar structure - 3 paragraphs covering the opportunity, competitive positioning, and financial impact]\n\n**[EMBED CHART: Competitive Positioning Matrix]** - 2×2 chart showing company vs. competitors on key dimensions\n\n**[Thesis Pillar 3]: [Title - e.g., \"Strong Execution and Management\"]**\n\n[Similar structure]\n\n**[Add 2-3 more pillars as needed]**\n\n**[EMBED CHART: Margin Expansion Pathway]** - Waterfall or line chart showing path to margin improvement\n\n### Investment Risks\n\n**Company-Specific Risks**\n\n**[Risk 1]: [Title - e.g., \"Customer Concentration\"]**\n[Description of risk, quantification if possible, mitigating factors. 2-3 sentences.]\n\n**[Risk 2]: [Title - e.g., \"Execution Risk on Product Roadmap\"]**\n[Description. 2-3 sentences.]\n\n**[Risk 3-5]: [Additional company-specific risks]**\n[Continue with 3-5 total company risks]\n\n**Industry/Market Risks**\n\n**[Risk 1]: [Title - e.g., \"Regulatory Uncertainty\"]**\n[Description. 2-3 sentences.]\n\n**[Risk 2]: [Title - e.g., \"Intense Competition\"]**\n[Description. 2-3 sentences.]\n\n**[Risk 3-4]: [Additional industry/market risks]**\n[Continue with 2-4 total industry risks]\n\n---\n\n## PAGES 8-19: COMPANY 101\n\n### Company Description (1 page)\n\n**Overview**\n[3-4 paragraphs describing:\n- What the company does (in plain English)\n- How it makes money\n- Who its customers are\n- Geographic presence\n- Scale/size metrics]\n\n**Business Model Diagram/Visual**\n[Insert visual showing how the company creates value]\n\n### Company History (2-3 pages)\n\n**The Early Days: [Founding Story Title]**\n\n[Paragraph on founding: who, when, why, initial vision]\n\n**Timeline of Key Milestones**\n\n```\n[Year]: [Founding event, initial funding]\n[Year]: [Product launch, key milestone]\n[Year]: [Major partnership, funding round]\n[Year]: [Geographic expansion, new product]\n[Year]: [Recent achievement]\n```\n\n**[Major Turning Point or Pivot]**\n[If applicable, describe any major strategic shifts]\n\n**[Company Name] Today: [Current State Title]**\n[Paragraphs describing current position, recent developments, current strategy]\n\n### Management \u0026 Ownership (2 pages)\n\n**Key Executives**\n\nFor each executive:\n```\n[Name] - [Title]\n[Bio paragraph including:\n- Current role and responsibilities\n- Prior experience and track record\n- Key accomplishments at company\n- Education/credentials]\n```\n\n**Corporate Structure \u0026 Governance**\n- Entity type (C-Corp, PBC, etc.)\n- Board composition\n- Special governance features\n- [Include governance diagram if applicable]\n\n**Ownership Structure** [if disclosed]\n- Major shareholders and ownership %\n- Strategic investors\n- Employee ownership\n- Insider ownership trends\n\n### Core Technology/Products (2-3 pages)\n\n**Technology Overview**\n[Description of core technology/platform]\n\n**Product Portfolio**\n\nFor each major product:\n```\n[Product Name]\n\nDescription:\n[What it does, key features]\n\nTarget Customers:\n[Who uses it, use cases]\n\nPricing Model:\n[How it's priced, typical contract values]\n\nCompetitive Positioning:\n[How it compares to alternatives]\n\nTraction:\n[Customers, revenue, growth metrics]\n```\n\n**Product Roadmap**\n[Future products/features in development]\n\n### Customers \u0026 Distribution (2-3 pages)\n\n**Customer Base**\n- Total customers: [number]\n- Customer segments (Enterprise, Mid-Market, SMB)\n- Geographic breakdown\n- Customer case studies/testimonials\n\n**Go-to-Market Strategy**\n- Sales channels (direct, partner, etc.)\n- Sales cycle and CAC\n- Key partnerships for distribution\n- Marketing strategy\n\n**Customer Economics**\n- LTV/CAC ratio\n- Net retention rate\n- Churn rates\n- Expansion rates\n\n---\n\n## PAGES 20-22: GROWTH OUTLOOK\n\n### Growth Framework Overview\n\n**Short-term Growth Drivers (1-2 years)**\n1. [Driver 1]\n2. [Driver 2]\n3. [Driver 3]\n\n**Medium-term Growth Drivers (3-5 years)**\n1. [Driver 1]\n2. [Driver 2]\n\n### Detailed Growth Driver Analysis\n\n**[Growth Driver 1]: [Title]**\n\n*Current State:*\n[Baseline metrics, current performance]\n\n*Opportunity:*\n[Market size, company positioning, growth potential]\n\n*Timeline \u0026 Milestones:*\n- Near-term (1-2 years): [Expected progress]\n- Medium-term (3-5 years): [Expected progress]\n\n*Risks \u0026 Challenges:*\n[What could prevent realization of this opportunity]\n\n**[Repeat for each major growth driver]**\n\n### Financial Projections\n\n**Revenue Build-up**\n[Visual showing how revenue grows from current to projected]\n\n**Scenario Analysis**\n[Table or chart showing Bear/Base/Bull case projections]\n\n---\n\n## PAGES 21-24: FINANCIAL ANALYSIS \u0026 PERFORMANCE\n\n**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).\n\n### Historical Financial Analysis\n\n**Income Statement Highlights (3-5 Year History)**\n```\n                    2021    2022    2023    2024    LTM\nRevenue ($M)        [X]     [X]     [X]     [X]     [X]\n  Growth %          -       X%      X%      X%      X%\nGross Profit ($M)   [X]     [X]     [X]     [X]     [X]\n  Margin %          X%      X%      X%      X%      X%\nEBITDA ($M)         [X]     [X]     [X]     [X]     [X]\n  Margin %          X%      X%      X%      X%      X%\nNet Income ($M)     [X]     [X]     [X]     [X]     [X]\n  Margin %          X%      X%      X%      X%      X%\nFCF ($M)            [X]     [X]     [X]     [X]     [X]\n```\n\n**[CHART 1: Revenue Growth Trajectory]**\nLine chart showing historical revenue with annotations for key milestones. Include growth % labels on chart.\n\n**[CHART 2: REVENUE BY PRODUCT/SEGMENT]** ⭐ CRITICAL\nStacked area chart showing revenue composition by product line or business segment over time. This shows mix shift and which products are driving growth.\n```\nExample segments:\n- Product A Revenue\n- Product B Revenue\n- Product C Revenue\n- Services Revenue\n```\n\n**[CHART 3: REVENUE BY GEOGRAPHY]** ⭐ CRITICAL\nStacked bar chart showing revenue breakdown by geographic region over time.\n```\nExample regions:\n- North America\n- Europe\n- Asia-Pacific\n- Rest of World\n```\n\n### Financial Performance Analysis\n\n**[CHART 4: Gross Margin Evolution]**\nLine chart with annotations explaining margin drivers (scale, pricing, mix, etc.)\n\n**[CHART 5: Operating Margin Progression]**\nWaterfall chart showing path from gross margin to operating margin, or line chart showing EBITDA margin trend\n\n**[CHART 6: Free Cash Flow Generation]**\nBar + line combo chart: Bars = FCF, Line = FCF margin %\n\n**[CHART 7: Key Operating Metrics Dashboard]**\nMulti-panel chart showing 3-4 key metrics:\n- Customer count or user growth\n- ARPU (Average Revenue Per User) or ACV (Annual Contract Value)\n- Customer cohort retention or net revenue retention\n- LTV/CAC or magic number or other unit economic metric\n\n### Forward Projections (3-5 Years)\n\n**Projected Financial Model**\n```\n                    2025E   2026E   2027E   2028E   2029E\nRevenue ($M)        [X]     [X]     [X]     [X]     [X]\n  Growth %          X%      X%      X%      X%      X%\nGross Profit ($M)   [X]     [X]     [X]     [X]     [X]\n  Margin %          X%      X%      X%      X%      X%\nEBITDA ($M)         [X]     [X]     [X]     [X]     [X]\n  Margin %          X%      X%      X%      X%      X%\nFCF ($M)            [X]     [X]     [X]     [X]     [X]\n  FCF Margin %      X%      X%      X%      X%      X%\n```\n\n**Key Assumptions**\n- Revenue growth drivers and assumptions\n- Margin progression assumptions\n- CapEx as % of revenue\n- Working capital assumptions\n\n**Charts:**\n- Revenue bridge showing growth drivers\n- Margin waterfall showing path to profitability/margin expansion\n- Free cash flow trajectory\n\n### Fundraising \u0026 Valuation [For Private Companies]\n\n**Fundraising History**\n```\nRound    Date      Amount    Valuation    Lead Investor(s)\nSeed     [Date]    $XM       $XM          [Investor]\nSeries A [Date]    $XM       $XM          [Investor]\nSeries B [Date]    $XM       $XM          [Investor]\n[etc.]\n```\n\n**Valuation Evolution Chart**\n[Visual showing valuation progression over time]\n\n**Current Valuation Metrics**\n- Latest valuation: $XXbn\n- Implied valuation multiple: XX.Xx\n- Comparison to public peers\n\n---\n\n## PAGES 26-31: INDUSTRY OVERVIEW\n\n### Industry Definition \u0026 Market Size\n\n**Industry Overview**\n[2-3 paragraphs on:\n- Industry definition and scope\n- Current market size\n- Historical growth rates\n- Key trends and drivers]\n\n**Market Size Chart**\n[Visual showing market growth from historical through projected]\n\n### Competitive Landscape\n\n**Competitive Positioning Matrix**\n[2x2 chart showing company vs. competitors on key dimensions]\n\n**Competitive Comparison Table**\n```\nMetric              [Company]  Comp A   Comp B   Comp C   Comp D\nRevenue ($B)        [X]        [X]      [X]      [X]      [X]\nGrowth %            X%         X%       X%       X%       X%\nMarket Share        X%         X%       X%       X%       X%\nGross Margin        X%         X%       X%       X%       X%\nKey Differentiator  [X]        [X]      [X]      [X]      [X]\n```\n\n**Competitive Analysis Narrative**\n[2-3 paragraphs analyzing:\n- Competitive strengths and weaknesses\n- Market positioning\n- Share gains/losses\n- Competitive moats]\n\n### Total Addressable Market\n\n**TAM Calculation**\n```\nCurrent TAM (2025):              $XXbn\nProjected TAM (2030):            $XXbn\nCAGR:                            XX%\n\nSegmentation:\n- [Segment A]:                   $XXbn\n- [Segment B]:                   $XXbn\n- [Segment C]:                   $XXbn\n```\n\n**TAM Growth Chart**\n[Visual showing TAM expansion over time by segment]\n\n**Company's Market Opportunity**\n```\nTotal TAM (2030):                $XXbn\nServiceable TAM:                 $XXbn\nCompany's Realistic Share:       XX%\nImplied Revenue Potential:       $XXbn\n```\n\n### Industry Dynamics\n\n**Porter's Five Forces Analysis**\n- Threat of new entrants: [High/Medium/Low] - [Explanation]\n- Bargaining power of suppliers: [High/Medium/Low] - [Explanation]\n- Bargaining power of buyers: [High/Medium/Low] - [Explanation]\n- Threat of substitutes: [High/Medium/Low] - [Explanation]\n- Industry rivalry: [High/Medium/Low] - [Explanation]\n\n**Key Industry Trends**\n1. [Trend 1]: [Description and impact]\n2. [Trend 2]: [Description and impact]\n3. [Trend 3]: [Description and impact]\n\n---\n\n## PAGES 32-34: VALUATION ANALYSIS\n\n### Valuation Methodology Summary\n\n```\nValuation Method            Weight    Implied Value    Weighted Value\nDCF Analysis                50%       $XX - $YY        $ZZ\nTrading Comparables         30%       $XX - $YY        $ZZ\nPrecedent Transactions      20%       $XX - $YY        $ZZ\n                           ────       ─────────────    ─────────\nWeighted Average Price Target         $AA - $BB        $CC\n```\n\n### DCF Analysis\n\n**Key Assumptions**\n```\nRevenue Growth (2025-2029):         XX% CAGR\nTerminal Growth Rate:               X.X%\nWACC:                               X.X%\nTerminal Year EBITDA Margin:        XX%\n```\n\n**Figure X - DCF Sensitivity Analysis ($/share)**\n\nCRITICAL FORMAT: DCF sensitivity must be shown as a 2-way heat map table with color coding.\n\n```\n                        Terminal Growth Rate\nWACC        2.0%      2.5%      3.0%      3.5%      4.0%\n8.0%        $52       $55       $58       $62       $66\n9.0%        $48       $51       $54       $57       $61\n10.0%       $45       $47       $50       $53       $56\n11.0%       $42       $44       $47       $49       $52\n12.0%       $39       $41       $44       $46       $49\n\nColor coding: Green (higher values) → Yellow (mid) → Red (lower values)\nSource: [Firm Name] estimates.\n```\n\n**Scenario Analysis**\n```\nScenario      Enterprise Value    Equity Value    Price/Share\nBear Case     $XXbn              $XXbn           $XX\nBase Case     $XXbn              $XXbn           $XX\nBull Case     $XXbn              $XXbn           $XX\n```\n\n### Trading Comparables\n\n**Figure X - Comparable Companies Analysis**\n\nCRITICAL FORMAT: Comp table must have two-part structure with statistical summary.\n\n**Part 1: Individual Company Data**\n```\nCompany         Ticker   Market   EV/Rev   EV/Rev   EV/EBITDA  EV/EBITDA  Rev     EBITDA\n                         Cap($B)  2024E    2025E    2024E      2025E      Growth  Margin\nPeer A          PERA     XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\nPeer B          PERB     XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\nPeer C          PERC     XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\nPeer D          PERD     XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\n[Company]       COMP     XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\n```\n\n**Part 2: Statistical Summary**\n```\nMax                      XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\n75th Percentile          XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\nMedian                   XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\n25th Percentile          XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\nMin                      XX.X     X.Xx     X.Xx     XX.X       XX.X       XX%     XX%\n\nSource: FactSet, company filings, [Firm Name] estimates.\n```\n\n**Implied Valuation**\n[Calculation showing application of peer multiples to company's metrics]\n\n### Precedent Transactions [If Applicable]\n\n**Figure X - Precedent Transaction Analysis**\n```\nDate        Target       Acquirer      Deal      EV/Rev   EV/EBITDA  Premium\n                                      Value($B)\n[MM/YYYY]   [Company A]  [Buyer A]    X.X       X.Xx     XX.X       XX%\n[MM/YYYY]   [Company B]  [Buyer B]    X.X       X.Xx     XX.X       XX%\n[MM/YYYY]   [Company C]  [Buyer C]    X.X       X.Xx     XX.X       XX%\n────────────────────────────────────────────────────────────────────\nMedian                                          X.Xx     XX.X       XX%\n\nSource: Capital IQ, company filings, [Firm Name] estimates.\n```\n\n**Control Premium Analysis**\n[Discussion of typical premiums in the industry]\n\n### Valuation Summary\n\n**Figure X - Valuation Football Field**\n\nCRITICAL FORMAT: Football field must be a horizontal bar chart showing all valuation methods.\n\n```\nValuation Method                Low End ────── Range ────── High End\n\nDCF Analysis                    $42 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $58\n\nTrading Comps (NTM)             $45 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $55\n\nPrecedent Trans.                $48 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $60\n                                                      ↑\n                                            Current Price: $50\n────────────────────────────────────────────────────────────────\nValuation Range:                $42                        $60\n\nColor coding: Each method should have distinct color bar\nAdd vertical line showing current stock price\nSource: [Firm Name] estimates.\n```\n\n**Price Target \u0026 Recommendation**\n```\nCurrent Price:              $XX.XX ([Date])\nPrice Target:               $YY.YY\nUpside/Downside:            ZZ%\n\nRecommendation:             BUY / HOLD / SELL\nTime Horizon:               12 months\n\nCatalysts:\n• [Near-term catalyst with timeframe]\n• [Medium-term catalyst with timeframe]\n• [Long-term catalyst with timeframe]\n```\n\n---\n\n## PAGES 35+: APPENDICES \u0026 DISCLOSURES\n\n### Appendix A: Detailed Financial Model\n[Reference to Excel model]\n\n### Appendix B: Management Bios\n[Extended bios if not included in main text]\n\n### Appendix C: Product Detail\n[Additional product information if needed]\n\n### Appendix D: Industry Data Sources\n[List of sources used for industry analysis]\n\n### Required Disclosures\n- Analyst certification\n- Important disclosures\n- Company-specific disclosures\n- Legal entity disclosures\n- Other regulatory disclosures\n\n---\n\n## GRAPHICS \u0026 CHARTS TO INCLUDE\n\n**TARGET: 20-30+ charts throughout the report**\n\n**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.\n\n### Page 1 - Executive Summary (3 charts)\n1. Revenue/ARR growth trajectory (line chart, historical + projected)\n2. Key metrics dashboard (multi-panel chart)\n3. Market positioning or margin progression\n\n### Pages 3-5 - Investment Thesis \u0026 Risks (3 charts)\n4. TAM growth and opportunity (stacked area chart)\n5. Competitive positioning matrix (2×2 with bubbles)\n6. Margin expansion pathway (waterfall or line)\n\n### Pages 6-17 - Company 101 (6-8 charts)\n7. Business model diagram (flow chart)\n8. Company timeline (horizontal timeline)\n9. Funding history (bar chart with valuation line)\n10. Organization chart\n11. Product portfolio matrix\n12. Customer segmentation (pie or tree map)\n13. Geographic revenue breakdown\n14. Customer cohort retention\n\n### Pages 18-20 - Growth Outlook (4 charts)\n15. Revenue bridge showing drivers (waterfall)\n16. Market share evolution (line chart)\n17. Product roadmap (timeline)\n18. Geographic expansion (map with timeline)\n\n### Pages 21-24 - Financials (7 charts) ⭐ CRITICAL SECTION\n19. Revenue growth trajectory (line with annotations)\n20. **Revenue by product/segment** (stacked area) ⭐ MUST HAVE\n21. **Revenue by geography** (stacked bar) ⭐ MUST HAVE\n22. Gross margin evolution (line chart)\n23. Operating margin progression (waterfall or line)\n24. Free cash flow trajectory (bar + line combo)\n25. Key operating metrics dashboard (multi-panel)\n26. Scenario comparison (grouped bar: Bear/Base/Bull)\n\n### Pages 25-30 - Industry Overview (6 charts)\n27. Market size evolution (area chart with CAGR)\n28. Competitive landscape map (2×2)\n29. Market share pie chart\n30. Market share evolution over time (line chart)\n31. TAM segmentation\n32. Industry trend charts\n\n### Pages 31-34 - Valuation (5 charts)\n33. DCF sensitivity analysis (heat map)\n34. DCF waterfall (PV of cash flows → equity value)\n35. Trading comps scatter plot (growth vs. multiple)\n36. Peer valuation multiples (grouped bar)\n37. Valuation football field (range chart)\n38. Price target scenarios (bar with upside/downside)\n\n**Chart Style Guidelines:**\n- **Consistent color scheme** throughout (pick 3-5 brand colors)\n- **Professional fonts** (Arial, Calibri, or similar)\n- **Clear labels and legends** on every chart\n- **Source citations** at bottom of each chart\n- **High information density** - use chart space efficiently\n- **Mix of chart types** for visual interest\n- **Annotations** to highlight key insights\n- **Embedded in text** - never standalone pages\n- **Sparklines in tables** where appropriate\n\n---\n\n## NOTES ON USING THIS TEMPLATE\n\n1. **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.\n\n2. **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.\n\n3. **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.\n\n4. **20-30+ CHARTS:** Include extensive graphics throughout, with specific emphasis on:\n   - **Revenue by product/segment** (stacked area chart)\n   - **Revenue by geography** (stacked bar chart)\n   - **Financial performance trends** (multiple charts)\n   - Charts should be embedded within text, not grouped separately\n\n5. **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\n\n6. **Intersplice Content:** Text paragraphs should have charts embedded inline. Each page should have 2-4 distinct elements (tables, charts, text blocks).\n\n7. **Consistent Formatting:** Use consistent styles for headers, body text, tables, and charts throughout. Pick a color scheme and stick to it.\n\n8. **References:** Include citations and sources for all data points\n\n9. **Proofread:** Always proofread for accuracy, especially financial data and calculations\n\n10. **Executive Summary Last:** While it appears on page 1, write this section last after completing the full analysis\n\n11. **Balance:** Present both positive and negative aspects objectively\n\n12. **Specific \u003e Generic:** Use specific data and examples rather than generic statements\n","references/task1-company-research.md":"# Task 1: Company Research - Detailed Workflow\n\nThis document provides step-by-step instructions for executing Task 1 (Company Research) of the initiating-coverage skill.\n\n## Task Overview\n\n**Purpose**: Research company's business, management, competitive position, industry, and risks.\n\n**Prerequisites**: ✅ None (fully independent)\n- Company name or ticker symbol only\n\n**Output**: Company Research Document (6,000-8,000 words)\n\n---\n\n## Data Sources to Gather\n\n### Primary Sources (Company)\n- **SEC Filings (for public companies):**\n  - Latest 10-K: Business description, risk factors, MD\u0026A, financials\n  - Recent 10-Qs: Quarterly updates\n  - DEF 14A (Proxy): Executive compensation, board composition\n  - 8-Ks: Material events, acquisitions, management changes\n\n- **Company Website \u0026 IR:**\n  - Investor presentations\n  - Earnings transcripts (last 2-3 quarters)\n  - Press releases\n  - Product documentation\n\n- **For Private Companies:**\n  - Company website and blog\n  - Press releases and media coverage\n  - LinkedIn for management bios\n  - Crunchbase or PitchBook for funding history\n\n### Secondary Sources (Industry/Competitive)\n- Competitor websites and SEC filings\n- Industry research reports (Gartner, Forrester, IDC, etc.)\n- News articles and trade publications\n- Market research reports\n- LinkedIn profiles for key executives\n\n### Key Information to Extract\n\n**Key Information:**\n- Company founding date, headquarters, employee count\n- Revenue size and growth trajectory (if available)\n- Product portfolio and pricing\n- Customer segments and case studies\n- Management backgrounds and track records\n- Competitive landscape and market share\n- Industry trends and growth drivers\n- Regulatory considerations\n- High-level financial metrics (from 10-K prose, not detailed extraction)\n\n---\n\n## Step-by-Step Research Workflow\n\n### Step 1: Initial Data Collection\n\n1. **Start with company website**\n   - Read About/Company pages\n   - Review product pages\n   - Identify customer case studies\n   - Note key metrics mentioned (employees, customers, etc.)\n\n2. **Gather SEC filings (if public)**\n   - Download latest 10-K from SEC EDGAR\n   - Download most recent 10-Q\n   - Download latest DEF 14A (proxy statement)\n   - Note filing dates\n\n3. **Read earnings materials**\n   - Latest earnings transcript\n   - Most recent investor presentation\n   - Press releases from last 12 months\n\n4. **Document basic facts**\n   - Founding date and story\n   - Headquarters location\n   - Employee count\n   - Products/services\n   - Key customers\n\n### Step 2: Business Model Analysis\n\n1. **Map revenue streams**\n   - What does the company sell?\n   - How is it priced? (subscription, transaction, license, etc.)\n   - Who pays?\n   - What are typical deal sizes?\n\n2. **Understand customer segments**\n   - Enterprise vs. SMB vs. consumer\n   - Industries served\n   - Geographic distribution\n   - Customer concentration (top 10 customers)\n\n3. **Document go-to-market**\n   - Direct sales vs. channel partners\n   - Sales cycle length\n   - Customer acquisition strategy\n   - Distribution model\n\n4. **Identify unit economics**\n   - LTV/CAC if available\n   - Gross margins\n   - Net revenue retention\n   - Payback periods\n\n### Step 3: Management Research\n\n**For each of 3-4 key executives:**\n\n1. **Identify key leaders**\n   - CEO (always required)\n   - CFO (always required)\n   - COO, CTO, or other C-suite (2 additional)\n\n2. **Research each executive**\n   - Find LinkedIn profile\n   - Review DEF 14A for background\n   - Search for press interviews\n   - Note tenure at company\n\n3. **Write 300-400 word bio including:**\n   - Current role and responsibilities\n   - Prior roles and companies (last 2-3 positions)\n   - Key accomplishments and track record\n   - Education and credentials\n   - Years of experience in industry\n   - Time at current company\n\n4. **Assess governance**\n   - Board composition and independence\n   - Key board members and their backgrounds\n   - Insider ownership percentage\n   - Executive compensation structure\n\n### Step 4: Competitive Intelligence\n\n1. **Identify 5-10 competitors**\n   - Direct competitors (same products/markets)\n   - Indirect competitors (substitute solutions)\n   - Emerging competitors (disruptors)\n   - Check 10-K for company's own list of competitors\n\n2. **Research each competitor**\n   - Visit competitor website\n   - Review their SEC filings (if public)\n   - Note key products and positioning\n   - Identify differentiators\n   - Estimate market share (if data available)\n\n3. **Create competitive framework**\n   - Map on key dimensions (price, features, scale, etc.)\n   - Identify company's competitive advantages\n   - Note competitive vulnerabilities\n   - Assess switching costs and network effects\n\n4. **Document competitive insights**\n   - Who are the market leaders?\n   - Where does this company rank?\n   - What are unique differentiators?\n   - What are competitive threats?\n\n### Step 5: Industry Analysis\n\n1. **Define the industry**\n   - Industry classification (NAICS/SIC)\n   - Scope and boundaries\n   - Related/adjacent industries\n\n2. **Size the market**\n   - Total addressable market (TAM)\n   - Serviceable addressable market (SAM)\n   - Serviceable obtainable market (SOM)\n   - Current penetration rate\n\n3. **Research growth drivers**\n   - Historical market growth rate\n   - Projected growth rate (next 3-5 years)\n   - Key trends accelerating/decelerating growth\n   - Technology changes impacting industry\n\n4. **Understand industry structure**\n   - Fragmented vs. consolidated\n   - Barriers to entry\n   - Supplier/buyer power\n   - Threat of substitutes\n   - Regulatory environment\n\n### Step 6: Risk Assessment\n\nIdentify 8-12 risks across four categories. For each risk, write 50-100 words.\n\n**Company-Specific Risks (4-6 risks):**\n- Execution risk (can management deliver?)\n- Customer concentration (top customers)\n- Key person dependency\n- Product/technology obsolescence\n- Geographic concentration\n- Integration risk (if recent M\u0026A)\n\n**Industry/Market Risks (3-4 risks):**\n- Competitive intensity\n- Regulatory changes\n- Technology disruption\n- Market saturation\n\n**Financial Risks (2-3 risks):**\n- Profitability timeline\n- Funding requirements\n- Debt levels and covenants\n- Cash burn rate (if unprofitable)\n\n**Macroeconomic Risks (2-3 risks):**\n- Economic sensitivity (cyclical vs. defensive)\n- Interest rate sensitivity\n- Foreign exchange exposure\n- Geopolitical factors\n\n**For each risk:**\n- Describe the risk clearly\n- Quantify impact if possible\n- Note likelihood/severity\n- Identify mitigating factors\n\n### Step 7: Synthesis and Writing\n\n**Write document following this structure:**\n\n1. **Company Overview** (800-1,200 words)\n   - What does the company do? (plain English)\n   - How do they make money? (business model)\n   - Where do they operate? (geographic presence)\n   - How large are they? (revenue, employees, customers)\n   - Key metrics and scale indicators\n\n2. **Company History** (800-1,200 words)\n   - Founding story (who, when, why, where)\n   - Timeline of major milestones\n   - Strategic pivots or transformations\n   - Key acquisitions\n   - Recent developments (last 1-2 years)\n\n3. **Management Team** (1,000-1,400 words)\n   - 300-400 word bio for each of 3-4 executives\n   - Board composition and governance\n   - Insider ownership\n   - Management track record assessment\n\n4. **Products \u0026 Services** (700-1,000 words)\n   - Detailed product portfolio\n   - Key features and capabilities\n   - Product differentiation\n   - Target customers and use cases\n   - Pricing models and typical deal sizes\n\n5. **Customers \u0026 Go-to-Market** (500-700 words)\n   - Customer segments and profiles\n   - Distribution channels\n   - Sales strategy and cycle\n   - Key partnerships\n   - Customer case studies\n\n6. **Industry Overview** (800-1,200 words)\n   - Industry definition and scope\n   - Market size and structure\n   - Growth rates (historical and projected)\n   - Key trends and drivers\n   - Regulatory environment\n   - Industry dynamics\n\n7. **Competitive Landscape** (700-1,000 words)\n   - Analysis of 5-10 key competitors\n   - Market positioning framework\n   - Company's competitive advantages\n   - Competitive vulnerabilities\n   - Market share analysis\n\n8. **Market Opportunity** (500-700 words)\n   - TAM sizing and methodology\n   - Market growth projections\n   - Company's serviceable market\n   - Market share opportunity\n   - Penetration strategy\n\n9. **Risk Assessment** (600-900 words)\n   - Company-specific risks (4-6)\n   - Industry/market risks (3-4)\n   - Financial risks (2-3)\n   - Macroeconomic risks (2-3)\n   - Each risk: 50-100 word description\n\n**Data Sources Section**\n- List all sources used\n- Include dates and URLs\n- Organize by source type\n\n---\n\n## Quality Standards\n\n### Content Depth\n- Each section must meet minimum word count targets\n- Analysis should be substantive, not just descriptive\n- Use specific examples and quantitative data\n- Cite sources throughout\n- Maintain objectivity and balance\n\n### Management Bios\n- 300-400 words per executive for 3-4 key executives\n- Must include: current role, prior experience, key accomplishments, education\n- Provide enough detail to assess track record and capabilities\n\n### Competitive Analysis\n- Must analyze 5-10 specific competitors\n- Include both direct and indirect competitors\n- Assess relative positioning on key dimensions\n- Identify company's competitive advantages and vulnerabilities\n- Use specific data and examples\n\n### Risk Assessment\n- Must identify 8-12 distinct risks across all four categories\n- Each risk needs 50-100 word description\n- Quantify impact where possible\n- Note mitigating factors\n- Cover all four risk categories\n\n### Writing Quality\n- Professional, analytical tone\n- Lead with key insights\n- Use concrete examples and data\n- Avoid generic statements\n- Proper citations throughout\n\n---\n\n## Output Format\n\n```\nCOMPANY RESEARCH REPORT: [Company Name]\nDate: [Date]\nAnalyst: [Your name if applicable]\n\nTABLE OF CONTENTS\n1. Company Overview\n2. Company History\n3. Management Team\n4. Products \u0026 Services\n5. Customers \u0026 Go-to-Market\n6. Industry Overview\n7. Competitive Landscape\n8. Market Opportunity (TAM)\n9. Risk Assessment\n\n======================================\n\n1. COMPANY OVERVIEW (800-1,200 words)\n\n[Content]\n\n2. COMPANY HISTORY (800-1,200 words)\n\n[Content]\n\n3. MANAGEMENT TEAM (1,000-1,400 words)\n\n[Name], [Title]\n[300-400 word bio]\n\n[Repeat for 3-4 key executives]\n\n[Governance section]\n\n4. PRODUCTS \u0026 SERVICES (700-1,000 words)\n\n[Content]\n\n5. CUSTOMERS \u0026 GO-TO-MARKET (500-700 words)\n\n[Content]\n\n6. INDUSTRY OVERVIEW (800-1,200 words)\n\n[Content]\n\n7. COMPETITIVE LANDSCAPE (700-1,000 words)\n\n[Content]\n\n8. MARKET OPPORTUNITY (500-700 words)\n\n[Content]\n\n9. RISK ASSESSMENT (600-900 words)\n\nCompany-Specific Risks:\n[4-6 risks with descriptions]\n\nIndustry/Market Risks:\n[3-4 risks with descriptions]\n\nFinancial Risks:\n[2-3 risks with descriptions]\n\nMacroeconomic Risks:\n[2-3 risks with descriptions]\n\n======================================\n\nDATA SOURCES\n[List all sources with dates and URLs]\n```\n\n---\n\n## Success Criteria\n\nA successful Task 1 completion should deliver:\n\n1. Meet 6,000-8,000 word target (verify word count)\n2. Include all 9 required sections with target word counts\n3. Provide substantive analysis, not just description\n4. Use specific examples and quantitative data\n5. Cite all sources properly\n6. Enable reader to understand:\n   - What the company does and how it makes money\n   - Quality and track record of management team\n   - Company's competitive position\n   - Market opportunity size\n   - Key risks to consider\n\n---\n\n## File Naming Convention\n\nSave the output as:\n\n`[Company]_Research_Document_[Date].md`\n\nExample: `Tesla_Research_Document_2024-10-27.md`\n\n---\n\n## Next Steps\n\nAfter completing Task 1, the research document will be used:\n\n- As standalone company analysis\n- As input for Task 2 (Financial Modeling) - provides business context for projections\n- As input for Task 4 (Chart Generation) - provides data for company/competitive charts\n- As foundation for Task 5 (Report Assembly) - Company 101 sections copied verbatim\n","references/task2-financial-modeling.md":"# Task 2: Financial Modeling - Detailed Workflow\n\nThis document provides step-by-step instructions for executing Task 2 (Financial Modeling) of the initiating-coverage skill.\n\n## Task Overview\n\n**Purpose**: Extract historical financials and build comprehensive Excel financial model with projections and scenarios.\n\n**Prerequisites**: ⚠️ Verify before starting\n- **Required**: Access to company financial data\n  - For public companies: Latest 10-K and recent 10-Qs from SEC EDGAR\n  - For private companies: Financial statements or estimates from available sources\n  - OR: Pre-extracted historical financials provided by user\n- **Optional**: Company research (Task 1) for business context\n\n**Output**: Excel Financial Model (.xlsx) with 6 essential tabs:\n1. Revenue Model\n2. Income Statement\n3. Cash Flow Statement\n4. Balance Sheet\n5. Scenarios\n6. DCF Inputs\n\n---\n\n## Input Verification\n\n**BEFORE STARTING - CHECK:**\n\n**Option A: Extract financials directly (most common)**\n- [ ] Have access to 10-K filings (public company)?\n- [ ] OR have access to financial statements (private company)?\n- [ ] Ready to create Excel file for historical extraction?\n\n**Option B: User has pre-extracted financials**\n- [ ] Historical financials file provided? (.xlsx or other format)\n- [ ] Contains 3-5 years of income statement, cash flow, balance sheet?\n- [ ] Data is clean and ready to use?\n\n**Optional Context:**\n- [ ] Company research (Task 1) complete for business understanding?\n\n**IF VERIFICATION FAILS**: Stop and obtain access to financial statements (10-K or equivalent) before proceeding.\n\n---\n\n## Model Structure and Formatting\n\n### Color Coding (Industry Standard)\n- **Blue text**: Hardcoded inputs (user can change)\n- **Black text**: Formulas and calculations\n- **Green text**: Links to other sheets\n- **Red text**: Errors or flags (should be resolved)\n\n### Formatting Standards\n- Professional borders and shading\n- Clear section headers\n- Grouped rows for collapsibility\n- Named ranges for key inputs/outputs\n- No hardcoded numbers in formulas (except constants like 12 months)\n- Clear units ($ thousands, $ millions, etc.)\n\n### Formula Best Practices\n- All numbers should flow from assumptions\n- Change an assumption → entire model updates\n- No circular references\n- Use named ranges for key cells\n- Keep formulas simple and auditable\n- Add comments for complex calculations\n\n---\n\n## Step-by-Step Modeling Workflow\n\n### Step 1: Extract Historical Financials\n\n**If historical financials are already extracted, skip to Step 2.**\n\n**For Public Companies:**\n\n1. **Download 10-K Filing**\n   - Go to SEC EDGAR (https://www.sec.gov/edgar/searchedgar/companysearch.html)\n   - Search for company name or ticker\n   - Download latest 10-K (annual report)\n   - Navigate to Item 8: Financial Statements and Supplementary Data\n\n2. **Create Historical Financials Excel File**\n   - File name: `[Company]_Historical_Financials_[Date].xlsx`\n   - This file will be the foundation for the model\n\n3. **Extract Income Statement (3-5 years)**\n   - Create Sheet 1: \"Historical Income Statement\"\n   - Extract ALL line items for 3-5 years:\n     - Revenue (total and by segment if disclosed)\n     - Cost of revenue / COGS\n     - Gross profit\n     - Operating expenses (R\u0026D, Sales \u0026 Marketing, G\u0026A broken out)\n     - EBITDA (calculate if not disclosed: EBIT + D\u0026A)\n     - EBIT / Operating income\n     - Interest expense/income\n     - Other income/expense\n     - Pre-tax income\n     - Income tax and tax rate\n     - Net income\n     - EPS (basic and diluted)\n     - Shares outstanding (basic and diluted)\n\n4. **Extract Cash Flow Statement (3-5 years)**\n   - Create Sheet 2: \"Historical Cash Flow\"\n   - Extract ALL line items:\n     - Operating activities (starting from net income)\n     - Depreciation \u0026 amortization\n     - Stock-based compensation\n     - Changes in working capital (receivables, inventory, payables)\n     - Cash from operations\n     - Investing activities (CapEx, acquisitions)\n     - Financing activities (debt issuance/repayment, equity, dividends)\n     - Net change in cash\n     - Beginning and ending cash\n\n5. **Extract Balance Sheet (3-5 years)**\n   - Create Sheet 3: \"Historical Balance Sheet\"\n   - Extract ALL line items:\n     - Current assets (cash, receivables, inventory, other)\n     - Non-current assets (PP\u0026E, intangibles, goodwill)\n     - Total assets\n     - Current liabilities (payables, accrued expenses, current debt)\n     - Non-current liabilities (long-term debt, deferred taxes)\n     - Total liabilities\n     - Shareholders' equity (common stock, retained earnings)\n     - Total liabilities + equity\n\n6. **Calculate Historical Metrics**\n   - Create Sheet 4: \"Historical Metrics\"\n   - Calculate from statements:\n     - Revenue growth % (YoY)\n     - Gross margin %\n     - EBITDA margin %\n     - Operating margin %\n     - Net margin %\n     - Free cash flow (CFO - CapEx)\n     - FCF margin %\n     - ROIC (approximate: NOPAT / Invested Capital)\n     - Debt/Equity ratio\n     - Current ratio (Current Assets / Current Liabilities)\n\n7. **Document Sources and Notes**\n   - Create Sheet 5: \"Notes\"\n   - Document:\n     - 10-K filing date and fiscal year end\n     - Any one-time items or adjustments noted\n     - Non-GAAP vs GAAP differences\n     - Segment breakdown (if revenue split by product/geography)\n     - Data quality notes and limitations\n\n**For Private Companies:**\n\n1. **Gather Available Data**\n   - Financial statements (if available)\n   - Press releases with revenue figures\n   - Funding announcements\n   - Industry estimates or comparable company data\n\n2. **Create Simplified Historical File**\n   - Estimated revenue (if available)\n   - Estimated margins (from comparables if needed)\n   - Key ratios and metrics\n   - Document all assumptions and sources\n\n**Verification:**\n- [ ] All 3 financial statements extracted (3-5 years)\n- [ ] Numbers reconcile across statements (net income ties)\n- [ ] Key metrics calculated correctly\n- [ ] Excel file saved and can be opened\n- [ ] Data sources documented (10-K dates, page numbers)\n\n**Foundation for projection model is now complete. Proceed to Step 2.**\n   - Capital expenditures\n   - Working capital items\n   - Debt and interest expense\n   - Share count (basic and diluted)\n\n3. **Organize historical data for entry**\n   - Prepare 3-5 years of actuals\n   - Will be entered directly into Income Statement, Cash Flow Statement, and Balance Sheet tabs\n   - Historical years in columns, projected years following\n\n4. **Calculate historical trends**\n   - Revenue CAGR\n   - Margin progression\n   - OpEx leverage\n   - Working capital patterns\n   - CapEx as % of revenue\n   - These trends will inform projection assumptions\n\n**Note**: Assumptions will be documented directly in each tab as blue text inputs, not in a separate tab.\n\n### Step 2: Model Revenue\n\n**CRITICAL: This is the most important and detailed part of the model.**\n\n#### A. Revenue by Product/Category (20-30 rows)\n\nCreate detailed table:\n```\n                        2021A   2022A   2023A   2024A   2025E   2026E   2027E   2028E   2029E\nProduct Category A\n  Sub-product A1        XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Sub-product A2        XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Sub-product A3        XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Category A Total      XX      XX      XX      XX      XX      XX      XX      XX      XX\n  % of Total Rev        X%      X%      X%      X%      X%      X%      X%      X%      X%\n  YoY Growth %          -       X%      X%      X%      X%      X%      X%      X%      X%\n\nProduct Category B\n  [Similar structure]\n\n[Continue for all product categories]\n\nServices Revenue        XX      XX      XX      XX      XX      XX      XX      XX      XX\nOther Revenue           XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nTOTAL REVENUE           XX      XX      XX      XX      XX      XX      XX      XX      XX\nTotal Revenue Growth %  -       X%      X%      X%      X%      X%      X%      X%      X%\n```\n\n**Key Requirements:**\n- Show absolute revenue ($M) for each category\n- Calculate % of total revenue for each category\n- Show YoY growth % for each category\n- Must have granular sub-categories (not just 3-5 top-level categories)\n- Show mix shift over time\n- Link all projections to Assumptions tab\n\n#### B. Revenue by Geography (15-20 rows)\n\nCreate detailed table:\n```\n                        2021A   2022A   2023A   2024A   2025E   2026E   2027E   2028E   2029E\nNorth America\n  United States         XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Canada                XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Mexico                XX      XX      XX      XX      XX      XX      XX      XX      XX\n  NA Total              XX      XX      XX      XX      XX      XX      XX      XX      XX\n  % of Total            X%      X%      X%      X%      X%      X%      X%      X%      X%\n  YoY Growth %          -       X%      X%      X%      X%      X%      X%      X%      X%\n\nEurope\n  UK                    XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Germany               XX      XX      XX      XX      XX      XX      XX      XX      XX\n  France                XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Other Europe          XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Europe Total          XX      XX      XX      XX      XX      XX      XX      XX      XX\n  % of Total            X%      X%      X%      X%      X%      X%      X%      X%      X%\n  YoY Growth %          -       X%      X%      X%      X%      X%      X%      X%      X%\n\nAsia-Pacific\n  [Similar structure]\n\nRest of World\n  [Similar structure]\n\nTOTAL REVENUE           XX      XX      XX      XX      XX      XX      XX      XX      XX\n```\n\n**Verification:**\n- Revenue by product total = Revenue by geography total = Total revenue\n- All percentages sum to 100%\n- Growth rates calculated correctly\n\n#### C. Revenue by Channel (if applicable)\n\n```\n                        2021A   2022A   2023A   2024A   2025E   2026E   2027E   2028E   2029E\nDirect Sales            XX      XX      XX      XX      XX      XX      XX      XX      XX\nE-commerce/Online       XX      XX      XX      XX      XX      XX      XX      XX      XX\nWholesale/Partner       XX      XX      XX      XX      XX      XX      XX      XX      XX\nRetail Stores\n  Company-owned stores  XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Store count           XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Sales per store       XX      XX      XX      XX      XX      XX      XX      XX      XX\nOther Channels          XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nTOTAL REVENUE           XX      XX      XX      XX      XX      XX      XX      XX      XX\n```\n\n### Step 3: Model Operating Expenses\n\n#### A. Cost of Revenue\n1. **Break down COGS components**\n   - Product costs (materials, manufacturing)\n   - Shipping and logistics\n   - Service delivery costs\n   - Other direct costs\n\n2. **Link to revenue**\n   - Calculate COGS as % of revenue\n   - Model gross margin by year\n   - Link to Assumptions tab\n\n#### B. R\u0026D Expenses\n```\nResearch \u0026 Development  2021A   2022A   2023A   2024A   2025E   2026E   2027E   2028E   2029E\nR\u0026D Headcount           XX      XX      XX      XX      XX      XX      XX      XX      XX\nR\u0026D Comp per head       XX      XX      XX      XX      XX      XX      XX      XX      XX\nR\u0026D Personnel Costs     XX      XX      XX      XX      XX      XX      XX      XX      XX\nR\u0026D Other Costs         XX      XX      XX      XX      XX      XX      XX      XX      XX\nTotal R\u0026D               XX      XX      XX      XX      XX      XX      XX      XX      XX\n% of Revenue            X%      X%      X%      X%      X%      X%      X%      X%      X%\n```\n\n#### C. Sales \u0026 Marketing Expenses\n```\nSales \u0026 Marketing       2021A   2022A   2023A   2024A   2025E   2026E   2027E   2028E   2029E\nS\u0026M Headcount           XX      XX      XX      XX      XX      XX      XX      XX      XX\nS\u0026M Comp per head       XX      XX      XX      XX      XX      XX      XX      XX      XX\nS\u0026M Personnel Costs     XX      XX      XX      XX      XX      XX      XX      XX      XX\nMarketing Spend         XX      XX      XX      XX      XX      XX      XX      XX      XX\nS\u0026M Other Costs         XX      XX      XX      XX      XX      XX      XX      XX      XX\nTotal S\u0026M               XX      XX      XX      XX      XX      XX      XX      XX      XX\n% of Revenue            X%      X%      X%      X%      X%      X%      X%      X%      X%\n```\n\n#### D. General \u0026 Administrative\n```\nG\u0026A                     2021A   2022A   2023A   2024A   2025E   2026E   2027E   2028E   2029E\nG\u0026A Headcount           XX      XX      XX      XX      XX      XX      XX      XX      XX\nG\u0026A Comp per head       XX      XX      XX      XX      XX      XX      XX      XX      XX\nG\u0026A Personnel Costs     XX      XX      XX      XX      XX      XX      XX      XX      XX\nG\u0026A Other Costs         XX      XX      XX      XX      XX      XX      XX      XX      XX\nTotal G\u0026A               XX      XX      XX      XX      XX      XX      XX      XX      XX\n% of Revenue            X%      X%      X%      X%      X%      X%      X%      X%      X%\n```\n\n#### E. Depreciation \u0026 Amortization\n- Link to CapEx schedule\n- Apply depreciation rates from Assumptions\n- Calculate annual D\u0026A\n\n### Step 4: Build Income Statement\n\n**Create full P\u0026L with 40-50 line items:**\n\n```\nINCOME STATEMENT        2021A   2022A   2023A   2024A   2025E   2026E   2027E   2028E   2029E\n\nREVENUE\n[Link to Revenue Model tab]\nTotal Revenue           XX      XX      XX      XX      XX      XX      XX      XX      XX\n  YoY Growth %          -       X%      X%      X%      X%      X%      X%      X%      X%\n\nCOST OF REVENUE\n[Link to COGS breakdown]\nTotal COGS              XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nGROSS PROFIT            XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Gross Margin %        X%      X%      X%      X%      X%      X%      X%      X%      X%\n\nOPERATING EXPENSES\nTotal R\u0026D               XX      XX      XX      XX      XX      XX      XX      XX      XX\n  % of Revenue          X%      X%      X%      X%      X%      X%      X%      X%      X%\nTotal S\u0026M               XX      XX      XX      XX      XX      XX      XX      XX      XX\n  % of Revenue          X%      X%      X%      X%      X%      X%      X%      X%      X%\nTotal G\u0026A               XX      XX      XX      XX      XX      XX      XX      XX      XX\n  % of Revenue          X%      X%      X%      X%      X%      X%      X%      X%      X%\nDepreciation \u0026 Amort.   XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nTotal Operating Exp.    XX      XX      XX      XX      XX      XX      XX      XX      XX\n  % of Revenue          X%      X%      X%      X%      X%      X%      X%      X%      X%\n\nEBITDA                  XX      XX      XX      XX      XX      XX      XX      XX      XX\n  EBITDA Margin %       X%      X%      X%      X%      X%      X%      X%      X%      X%\n\nEBIT                    XX      XX      XX      XX      XX      XX      XX      XX      XX\n  EBIT Margin %         X%      X%      X%      X%      X%      X%      X%      X%      X%\n\nInterest expense        (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\nInterest income         XX      XX      XX      XX      XX      XX      XX      XX      XX\nOther income/(expense)  XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nPre-tax income          XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nIncome tax              (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\n  Tax rate %            X%      X%      X%      X%      X%      X%      X%      X%      X%\n\nNET INCOME              XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Net Margin %          X%      X%      X%      X%      X%      X%      X%      X%      X%\n\nSHARES OUTSTANDING\nBasic shares (M)        XX      XX      XX      XX      XX      XX      XX      XX      XX\nDiluted shares (M)      XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nEARNINGS PER SHARE\nBasic EPS               $X.XX   $X.XX   $X.XX   $X.XX   $X.XX   $X.XX   $X.XX   $X.XX   $X.XX\nDiluted EPS             $X.XX   $X.XX   $X.XX   $X.XX   $X.XX   $X.XX   $X.XX   $X.XX   $X.XX\n```\n\n### Step 5: Build Cash Flow Statement\n\n```\nCASH FLOW STATEMENT     2021A   2022A   2023A   2024A   2025E   2026E   2027E   2028E   2029E\n\nOPERATING ACTIVITIES\nNet Income              XX      XX      XX      XX      XX      XX      XX      XX      XX\nAdjustments:\n  Depreciation \u0026 Amort. XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Stock-based comp      XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Other non-cash        XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nChanges in WC:\n  Accounts Receivable   (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\n  Inventory             (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\n  Accounts Payable      XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Other working capital (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\n\nCash from Operations    XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nINVESTING ACTIVITIES\nCapital Expenditures    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\nAcquisitions            (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\nOther investing         XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nCash from Investing     (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\n\nFREE CASH FLOW          XX      XX      XX      XX      XX      XX      XX      XX      XX\n  FCF Margin %          X%      X%      X%      X%      X%      X%      X%      X%      X%\n\nFINANCING ACTIVITIES\nDebt issuance           XX      XX      XX      XX      XX      XX      XX      XX      XX\nDebt repayment          (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\nEquity issuance         XX      XX      XX      XX      XX      XX      XX      XX      XX\nDividends paid          (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\nOther financing         XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nCash from Financing     XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nNET CHANGE IN CASH      XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nBeginning Cash          XX      XX      XX      XX      XX      XX      XX      XX      XX\nEnding Cash             XX      XX      XX      XX      XX      XX      XX      XX      XX\n```\n\n### Step 6: Build Balance Sheet\n\nCreate full balance sheet with 35-45 line items:\n\n```\nBALANCE SHEET           2021A   2022A   2023A   2024A   2025E   2026E   2027E   2028E   2029E\n\nASSETS\nCurrent Assets:\n  Cash \u0026 Equivalents    XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Accounts Receivable   XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Inventory             XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Prepaid expenses      XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Other current assets  XX      XX      XX      XX      XX      XX      XX      XX      XX\nTotal Current Assets    XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nNon-Current Assets:\n  PP\u0026E, gross           XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Accumulated Depr.     (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\n  PP\u0026E, net             XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Intangible assets     XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Goodwill              XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Other non-current     XX      XX      XX      XX      XX      XX      XX      XX      XX\nTotal Non-Current       XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nTOTAL ASSETS            XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nLIABILITIES\nCurrent Liabilities:\n  Accounts Payable      XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Accrued expenses      XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Deferred revenue      XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Current debt          XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Other current liab.   XX      XX      XX      XX      XX      XX      XX      XX      XX\nTotal Current Liab.     XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nNon-Current Liabilities:\n  Long-term debt        XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Deferred taxes        XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Other non-current     XX      XX      XX      XX      XX      XX      XX      XX      XX\nTotal Non-Current Liab. XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nTOTAL LIABILITIES       XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nEQUITY\n  Common stock          XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Additional paid-in    XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Retained earnings     XX      XX      XX      XX      XX      XX      XX      XX      XX\n  Treasury stock        (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)    (XX)\n  Other equity          XX      XX      XX      XX      XX      XX      XX      XX      XX\nTOTAL EQUITY            XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nTOTAL LIAB + EQUITY     XX      XX      XX      XX      XX      XX      XX      XX      XX\n\nBALANCE CHECK           OK      OK      OK      OK      OK      OK      OK      OK      OK\n```\n\n**Balance Check Formula:**\n- Total Assets must equal Total Liabilities + Equity for each year\n- Flag any imbalances in red\n\n### Step 7: Build DCF Inputs Tab\n\nPrepare inputs for valuation (Task 3):\n\n```\nDCF INPUTS              2025E   2026E   2027E   2028E   2029E\n\nEBIT                    XX      XX      XX      XX      XX\nTax Rate                X%      X%      X%      X%      X%\nNOPAT                   XX      XX      XX      XX      XX\n\nAdd: D\u0026A                XX      XX      XX      XX      XX\nLess: CapEx             (XX)    (XX)    (XX)    (XX)    (XX)\nLess: Chg in NWC        (XX)    (XX)    (XX)    (XX)    (XX)\n\nUNLEVERED FCF           XX      XX      XX      XX      XX\n\nTerminal Year Metrics:\n  2029E Revenue         $X,XXX\n  2029E EBITDA          $XXX\n  2029E EBIT            $XXX\n  2029E Unlevered FCF   $XXX\n```\n\n### Step 8: Build Scenarios Tab\n\nCreate three scenarios with different assumptions:\n\n#### Scenario Assumptions Table\n```\nAssumption                      Bull        Base        Bear\nRevenue CAGR (2025-2029)        XX%         XX%         XX%\nGross Margin 2029E              XX%         XX%         XX%\nEBITDA Margin 2029E             XX%         XX%         XX%\nCapEx as % of Revenue           X%          X%          X%\n[Add other key assumptions]\n```\n\n#### Scenario Output Table\n```\nMetric                          Bull        Base        Bear\n2029E Revenue ($M)              $X,XXX      $X,XXX      $X,XXX\n2029E EBITDA ($M)               $XXX        $XXX        $XXX\n2029E EBITDA Margin             XX%         XX%         XX%\n2029E Net Income ($M)           $XXX        $XXX        $XXX\n2029E EPS                       $X.XX       $X.XX       $X.XX\n2029E FCF ($M)                  $XXX        $XXX        $XXX\n2029E FCF Margin                XX%         XX%         XX%\n\nCumulative FCF 2025-2029 ($M)   $XXX        $XXX        $XXX\n```\n\n**Document scenario rationale:**\n- Bull case: [Describe optimistic but achievable assumptions]\n- Base case: [Describe most likely scenario]\n- Bear case: [Describe downside risks and triggers]\n\n### Step 9: Quality Check\n\n**Verify model integrity:**\n1. [ ] Test all formulas (spot check calculations)\n2. [ ] Change assumption → verify model updates correctly\n3. [ ] Test scenario switching\n4. [ ] Verify color coding (blue/black/green)\n5. [ ] Check balance sheet balances for all years\n6. [ ] Verify no circular references (Excel will flag)\n7. [ ] Check for hardcoded numbers in projections\n8. [ ] Verify all cross-sheet links work\n9. [ ] Test that revenue totals tie across all tabs\n10. [ ] Review formatting and presentation\n\n---\n\n## Quality Standards\n\n### Model Integrity\n- All formulas link properly across sheets\n- No hardcoded numbers in projections (except in Assumptions tab)\n- No circular references\n- Balance sheet balances for all years\n- Scenario switching works properly\n\n### Completeness\n- All 6 essential tabs: Revenue Model, Income Statement, Cash Flow Statement, Balance Sheet, Scenarios, DCF Inputs\n- 40-50 line items in Income Statement\n- 20-30 rows in Revenue Model (product breakdown)\n- 15-20 rows in Revenue Model (geography breakdown)\n- Full cash flow and balance sheet with all line items\n- Bull/Base/Bear scenarios complete\n\n### Professional Formatting\n- Consistent color coding (blue/black/green)\n- Clear headers and labels\n- Proper borders and shading\n- Named ranges for key cells\n- Grouped rows for collapsibility\n- Units clearly labeled ($ thousands vs. $ millions)\n\n### Documentation\n- Assumptions documented with rationale (blue text cells with comments)\n- Data sources noted in cell comments or notes section within tabs\n- Complex calculations explained with comments\n- Methodology described\n\n---\n\n## File Naming Convention\n\nSave the financial model as:\n`[Company]_Financial_Model_[Date].xlsx`\n\nExample: `Tesla_Financial_Model_2024-10-27.xlsx`\n\n---\n\n## Success Criteria\n\nA successful financial model should:\n1. Have all 6 essential tabs (Revenue Model, Income Statement, Cash Flow Statement, Balance Sheet, Scenarios, DCF Inputs)\n2. Be fully dynamic (change assumption → model updates)\n3. Have no hardcoded numbers in projections\n4. Include detailed revenue breakdowns (20-30 rows by product, 15-20 rows by geography)\n5. Contain 40-50 line items in Income Statement\n6. Include Bull/Base/Bear scenarios\n7. Be professionally formatted with color coding\n8. Balance properly (balance sheet, cash flows)\n9. Be auditable and easy to follow\n10. Support valuation analysis with proper FCF calculations\n\n---\n\n## Common Model Types - Special Considerations\n\n### High-Growth Tech/SaaS\n- Focus on ARR growth and net retention\n- Model by product line and geography\n- Heavy R\u0026D and S\u0026M spend\n- Path to profitability timeline\n- Unit economics (LTV/CAC)\n\n### E-commerce/Retail\n- Revenue by product category and channel\n- Store count and comp store growth (if applicable)\n- Inventory turns and working capital\n- Fulfillment costs\n- Customer acquisition\n\n### Manufacturing/Industrial\n- Production capacity utilization\n- Raw material costs and pricing\n- Gross margin bridge (volume/price/mix/cost)\n- CapEx heavy models\n- Working capital cycles\n\n---\n\n## Next Steps\n\nAfter completing Task 2, the financial model will be used for:\n- **Task 3 (Valuation)**: DCF inputs, projected financials\n- **Task 4 (Charts)**: Data for revenue trends, margin charts, scenario comparisons\n- **Task 5 (Report Assembly)**: Financial data for report tables and analysis\n","references/task3-valuation.md":"# Task 3: Valuation Analysis - Detailed Workflow\n\nThis document provides step-by-step instructions for executing Task 3 (Valuation Analysis) of the initiating-coverage skill.\n\n## Task Overview\n\n**Purpose**: Perform comprehensive valuation using DCF, comparables, and precedent transactions.\n\n**Prerequisites**: ⚠️ Verify before starting\n- **Required**: Financial model from Task 2\n  - Projected income statements\n  - Projected cash flows\n  - Revenue and EBITDA forecasts\n  - DCF inputs (unlevered FCF)\n\n**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASK 2 IS COMPLETE**\n\nThis task requires the financial model from Task 2. Starting without it will result in incomplete work.\n\n**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.\n\n**Output**: Valuation Analysis (4-6 pages + Excel tabs)\n- DCF analysis with sensitivity tables\n- Comparable companies analysis\n- Precedent transactions (if applicable)\n- Valuation football field\n- Price target and recommendation\n\n---\n\n## Input Verification\n\n**BEFORE STARTING - CHECK:**\n- [ ] Task 2 complete? (Financial model exists)\n- [ ] Model file path/location known?\n- [ ] Can access projected financials from model?\n\n**Required from model:**\n- [ ] Projected FCF (5 years)\n- [ ] Revenue projections\n- [ ] EBITDA projections\n- [ ] Terminal year metrics\n- [ ] Balance sheet data (debt, cash, shares)\n\n**IF VERIFICATION FAILS**: Stop and complete Task 2 (Financial Modeling) before proceeding.\n\n---\n\n## Detailed Methodology Reference\n\nFor deep dive on valuation methodologies, formulas, and theory, see:\n**[valuation-methodologies.md](valuation-methodologies.md)**\n\nThis workflow document focuses on execution steps. Reference the methodology file for:\n- DCF theory and formulas\n- WACC calculation details\n- Terminal value methods\n- Comparable companies theory\n- Precedent transactions theory\n\n---\n\n## Step-by-Step Valuation Workflow\n\n### Step 1: Extract Data from Financial Model\n\n**From Task 2's financial model, extract:**\n\n1. **Projected Financials (5 years)**\n   - Revenue by year (2025E-2029E)\n   - EBITDA by year\n   - EBIT by year\n   - Tax rate\n   - D\u0026A by year\n   - CapEx by year\n   - Change in NWC by year\n\n2. **Unlevered Free Cash Flow**\n   ```\n   Extract from DCF Inputs tab in financial model:\n\n                   2025E   2026E   2027E   2028E   2029E\n   EBIT            $XXX    $XXX    $XXX    $XXX    $XXX\n   × (1 - Tax Rate)\n   = NOPAT         $XXX    $XXX    $XXX    $XXX    $XXX\n   + D\u0026A           $XXX    $XXX    $XXX    $XXX    $XXX\n   - CapEx         ($XX)   ($XX)   ($XX)   ($XX)   ($XX)\n   - Chg in NWC    ($XX)   ($XX)   ($XX)   ($XX)   ($XX)\n   = Unlevered FCF $XXX    $XXX    $XXX    $XXX    $XXX\n   ```\n\n3. **Balance Sheet Data (current)**\n   - Total debt\n   - Cash \u0026 equivalents\n   - Net debt (Debt - Cash)\n   - Diluted shares outstanding\n\n4. **Scenario Data**\n   - Bull case revenue CAGR and terminal margin\n   - Base case revenue CAGR and terminal margin\n   - Bear case revenue CAGR and terminal margin\n\n### Step 2: Build DCF Analysis\n\n#### A. Calculate WACC\n\n**1. Determine Risk-Free Rate**\n   - Use 10-year Treasury yield (check current rate)\n   - Example: 4.0-4.5% as of late 2024\n\n**2. Determine Cost of Equity (CAPM)**\n   ```\n   Cost of Equity = Risk-Free Rate + Beta × Equity Risk Premium\n\n   Inputs:\n   - Risk-Free Rate: [Current 10-year Treasury, e.g., 4.2%]\n   - Beta: [Company beta from Bloomberg/FactSet or peer average]\n   - Equity Risk Premium: 5-6% (historical average)\n\n   Example:\n   Cost of Equity = 4.2% + 1.3 × 5.5% = 11.35%\n   ```\n\n**3. Determine Cost of Debt**\n   ```\n   Cost of Debt = Current borrowing rate or implied yield on bonds\n\n   For private companies:\n   Cost of Debt = Risk-Free Rate + Credit Spread (based on rating)\n\n   Example:\n   Cost of Debt (pre-tax) = 6.5%\n   Cost of Debt (after-tax) = 6.5% × (1 - 25% tax rate) = 4.875%\n   ```\n\n**4. Determine Capital Structure**\n   ```\n   Use market values (not book values):\n\n   Market Value of Equity (E) = Share Price × Shares Outstanding\n   Market Value of Debt (D) = Total Debt (use book value if bonds not traded)\n   Total Value (V) = E + D\n\n   Weight of Equity = E / V\n   Weight of Debt = D / V\n\n   Example:\n   E = $5,000M (90.9%)\n   D = $500M (9.1%)\n   V = $5,500M (100%)\n   ```\n\n**5. Calculate WACC**\n   ```\n   WACC = (E/V × Cost of Equity) + (D/V × Cost of Debt × (1 - Tax Rate))\n\n   Example:\n   WACC = (90.9% × 11.35%) + (9.1% × 6.5% × (1 - 25%))\n   WACC = 10.32% + 0.44% = 10.76%\n\n   Round to: 10.8% for base case\n   ```\n\n#### B. Calculate Terminal Value\n\n**Method 1: Perpetuity Growth (Preferred)**\n```\nTerminal Value = FCF(2029) × (1 + g) / (WACC - g)\n\nWhere:\n- FCF(2029) = Final year unlevered FCF from model\n- g = Perpetual growth rate (typically 2.0-3.0%)\n  - Should not exceed long-term GDP growth\n  - Use 2.5% as base case\n\nExample:\nFCF(2029) = $500M\ng = 2.5%\nWACC = 10.8%\n\nTerminal Value = $500M × (1.025) / (0.108 - 0.025)\nTerminal Value = $512.5M / 0.083 = $6,175M\n```\n\n**Method 2: Exit Multiple (Alternative)**\n```\nTerminal Value = EBITDA(2029) × Exit Multiple\n\nWhere:\n- Exit Multiple = Current peer trading median (e.g., 12-15x EBITDA)\n\nExample:\nEBITDA(2029) = $800M\nExit Multiple = 13x\n\nTerminal Value = $800M × 13x = $10,400M\n```\n\n**Choose one method or average both.**\n\n#### C. Discount Cash Flows to Present Value\n\n```\nPV of Projected FCF = Σ [FCFt / (1 + WACC)^t] for t = 1 to 5\n\nExample:\nYear    FCF      Discount    PV of FCF\n        ($M)     Factor      ($M)\n2025    $250     1/(1.108)^1 = 0.9026    $226\n2026    $320     1/(1.108)^2 = 0.8147    $261\n2027    $390     1/(1.108)^3 = 0.7353    $287\n2028    $450     1/(1.108)^4 = 0.6636    $299\n2029    $500     1/(1.108)^5 = 0.5988    $299\n                              Total PV:  $1,372M\n\nPV of Terminal Value = Terminal Value / (1 + WACC)^5\nPV of Terminal Value = $6,175M / (1.108)^5 = $6,175M × 0.5988 = $3,697M\n\nEnterprise Value = $1,372M + $3,697M = $5,069M\n```\n\n#### D. Calculate Equity Value and Price Per Share\n\n```\nEnterprise Value                 $5,069M\n- Net Debt (Debt - Cash)         ($450M)\n+ Non-operating Assets           $0M\n- Minority Interest              $0M\n- Preferred Stock                $0M\n= Equity Value                   $4,619M\n\nDiluted Shares Outstanding       100M\n\nPrice Per Share = $4,619M / 100M = $46.19\n\nCurrent Stock Price: $42.00\nImplied Upside: 10.0%\n```\n\n#### E. DCF Sensitivity Analysis **CRITICAL**\n\n**Table 1: WACC vs. Terminal Growth Rate**\n\nCreate 2-way sensitivity table:\n```\nPrice Per Share ($)     Terminal Growth Rate\nWACC        1.5%    2.0%    2.5%    3.0%    3.5%\n9.0%        $52     $55     $59     $63     $68\n9.5%        $48     $51     $54     $58     $62\n10.0%       $45     $48     $51     $54     $57\n10.5%       $42     $45     $47     $50     $53\n11.0%       $40     $42     $44     $47     $50\n11.5%       $38     $40     $42     $44     $47\n12.0%       $36     $38     $40     $42     $44\n\nBase Case: WACC = 10.8%, g = 2.5% → $46\nFormat as heatmap: Green (high values) → Yellow → Red (low values)\n```\n\n**Table 2: Revenue CAGR vs. Terminal EBITDA Margin**\n```\nPrice Per Share ($)     Terminal EBITDA Margin (2029E)\nRevenue CAGR    28%     30%     32%     34%     36%\n15%             $38     $42     $46     $50     $54\n20%             $42     $46     $51     $56     $61\n25%             $46     $51     $56     $62     $68\n30%             $51     $56     $62     $68     $75\n35%             $56     $62     $68     $75     $83\n\nBase Case: Rev CAGR = 25%, EBITDA Margin = 32% → $56\n```\n\n### Step 3: Comparable Companies Analysis\n\n#### A. Select Comparable Companies\n\n**Selection Criteria:**\n- Same industry/sector (primary requirement)\n- Similar business model\n- Comparable size (market cap, revenue)\n- Similar growth profile\n- Similar geographies\n\n**Identify 5-10 peer companies:**\n1. [Peer 1] - Direct competitor\n2. [Peer 2] - Direct competitor\n3. [Peer 3] - Adjacent player\n4. [Peer 4] - Similar business model\n5. [Peer 5] - Regional competitor\n6. [Add 3-5 more]\n\n**Document rationale for each peer selected.**\n\n#### B. Gather Peer Financial Data\n\n**For each comparable, gather:**\n- Current stock price\n- Shares outstanding (diluted)\n- Market capitalization\n- Total debt and cash (for EV calculation)\n- Enterprise value\n- LTM (Last Twelve Months) financials:\n  - Revenue\n  - EBITDA\n  - EBIT\n  - Net Income\n- NTM (Next Twelve Months) consensus estimates\n- Revenue growth rate\n- EBITDA margin\n\n**Data sources:**\n- FactSet, CapitalIQ, Bloomberg (preferred)\n- Company 10-Ks/10-Qs for actuals\n- Consensus estimates from Yahoo Finance, Seeking Alpha (if pro tools unavailable)\n\n#### C. Calculate Valuation Multiples\n\n**For each peer, calculate:**\n```\nEV/Revenue (LTM) = Enterprise Value / LTM Revenue\nEV/Revenue (NTM) = Enterprise Value / NTM Revenue (est.)\nEV/EBITDA (LTM) = Enterprise Value / LTM EBITDA\nEV/EBITDA (NTM) = Enterprise Value / NTM EBITDA (est.)\nP/E (NTM) = Market Cap / NTM Net Income (est.)\n```\n\n#### D. Create Comparable Companies Table (MANDATORY FORMAT)\n\n```\nCOMPARABLE COMPANIES ANALYSIS\n\nCompany      Ticker  Mkt Cap  EV/Rev  EV/Rev  EV/EBITDA  EV/EBITDA  P/E   Rev     EBITDA\n                     ($B)     LTM     NTM     LTM        NTM        NTM   Growth  Margin\nPeer A       PRA     45.2     3.5x    3.2x    15.2x      13.8x      25x   18%     23%\nPeer B       PRB     32.8     3.2x    2.9x    14.1x      12.5x      22x   15%     23%\nPeer C       PRC     28.5     2.8x    2.6x    12.8x      11.2x      20x   12%     22%\nPeer D       PRD     52.1     4.1x    3.7x    17.5x      15.2x      29x   22%     23%\nPeer E       PRE     38.9     3.6x    3.3x    15.8x      14.1x      25x   17%     23%\nPeer F       PRF     41.2     3.7x    3.4x    16.1x      13.9x      26x   19%     23%\nPeer G       PRG     35.5     3.3x    3.0x    14.5x      12.8x      23x   16%     22%\n\n[Target]     TRGT    38.0     3.4x    3.1x    14.8x      13.0x      24x   17%     23%\n\nSTATISTICAL SUMMARY\nMaximum              52.1     4.1x    3.7x    17.5x      15.2x      29x   22%     23%\n75th Percentile      45.2     3.7x    3.4x    16.1x      14.1x      26x   19%     23%\nMedian               38.9     3.5x    3.2x    15.2x      13.8x      25x   17%     23%\n25th Percentile      32.8     3.2x    2.9x    14.1x      12.5x      22x   15%     22%\nMinimum              28.5     2.8x    2.6x    12.8x      11.2x      20x   12%     22%\n\nNote: Market data as of [Date]. LTM = Last Twelve Months. NTM = Next Twelve Months.\nSource: FactSet, company filings, [Analyst] estimates.\n```\n\n**CRITICAL**: The statistical summary (max/75th/median/25th/min) is MANDATORY.\n\n#### E. Apply Multiples to Target Company\n\n**Choose primary multiple (typically EV/EBITDA for mature companies):**\n\n```\nTarget Company NTM EBITDA = $550M (from financial model)\n\nApply Median Peer Multiple:\nPeer Median EV/EBITDA (NTM) = 13.8x\nImplied EV = $550M × 13.8x = $7,590M\n\nApply 25th Percentile (Conservative):\n25th Percentile EV/EBITDA (NTM) = 12.5x\nImplied EV = $550M × 12.5x = $6,875M\n\nApply 75th Percentile (Optimistic):\n75th Percentile EV/EBITDA (NTM) = 14.1x\nImplied EV = $550M × 14.1x = $7,755M\n\nValuation Range (Comps): $6,875M - $7,755M\nMidpoint: $7,315M\n\nConvert to Equity Value:\nImplied EV (Median)        $7,590M\n- Net Debt                 ($450M)\n= Implied Equity Value     $7,140M\n\nShares Outstanding         100M\nImplied Price/Share        $71.40\n```\n\n**Justify Premium/Discount:**\n- Target is growing 17% vs. peer median 17% → In-line\n- Target EBITDA margin 23% vs. peer median 23% → In-line\n- Target market position → [Justify premium/discount]\n- **Conclusion**: Apply median multiple (no adjustment)\n\n### Step 4: Precedent Transactions (Optional)\n\n**Note**: Only if M\u0026A is relevant for this sector/company.\n\n#### A. Identify Relevant Transactions\n\n**Search for 5-10 M\u0026A deals:**\n- Same industry, last 3-5 years\n- Similar size (0.5x to 2x target's size)\n- Announced and closed deals\n\n**Example:**\n```\nPRECEDENT TRANSACTIONS ANALYSIS\n\nDate     Target        Acquirer      Deal     EV/Rev  EV/EBITDA  Premium  Rationale\n                                    Value($B)  LTM     LTM\nQ1 2024  Comp A       Strategic      $5.2B    4.2x    16.5x      35%      Consolidation\nQ3 2023  Comp B       PE Firm        $3.8B    3.8x    14.2x      28%      Platform\nQ4 2023  Comp C       Strategic      $4.5B    4.0x    15.8x      32%      Geographic\nQ2 2023  Comp D       Strategic      $6.1B    4.5x    17.2x      38%      Strategic fit\nQ1 2023  Comp E       PE Firm        $3.2B    3.5x    13.5x      25%      Carve-out\n\nMedian                                        4.0x    15.8x      32%\n\nSource: CapitalIQ, company filings, press releases.\n```\n\n#### B. Apply to Target Company\n\n```\nTarget Company LTM EBITDA = $500M\nPrecedent Median EV/EBITDA (LTM) = 15.8x\n\nImplied EV (Precedent) = $500M × 15.8x = $7,900M\n\nNote: Precedent multiples typically 10-20% higher than trading comps\ndue to control premium and synergies.\n```\n\n### Step 5: Valuation Reconciliation\n\n#### A. Create Valuation Summary Table\n\n```\nVALUATION SUMMARY\n\nMethod                  Low     Base    High    Weight  Weighted Value\nDCF Analysis            $42     $46     $51     50%     $23.00\nTrading Comps (NTM)     $64     $71     $78     40%     $28.40\nPrecedent Trans.        $70     $79     $88     10%     $7.90\n                                                        -------\nWeighted Average Target                         100%    $59.30\n\nRounded Price Target: $59.00\n\nCurrent Price (as of [Date]):    $42.00\nUpside to Target:                40% ($59.00 / $42.00 - 1)\n```\n\n#### B. Determine Weighting Rationale\n\n**Typical Weighting:**\n- DCF: 40-60% (higher when forecasts reliable)\n- Trading Comps: 25-40% (reflects market sentiment)\n- Precedent Trans: 10-25% (lower unless M\u0026A likely)\n\n**For this example:**\n- DCF 50%: High confidence in projections\n- Comps 40%: Robust peer set\n- Precedent 10%: M\u0026A unlikely near-term\n\n#### C. Create Valuation Football Field Chart\n\n```\nVALUATION FOOTBALL FIELD\n\nMethod                  Low ◄────────── Range ──────────► High\n\nDCF Analysis            $42 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $51\n\nTrading Comps (NTM)     $64 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $78\n\nPrecedent Trans.        $70 ▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓ $88\n                                          ↑\n                                    Current: $42\n─────────────────────────────────────────────────────────\nValuation Range         $42                          $88\nPrice Target: $59 (weighted average)\n\nColor code:\n- DCF: Blue\n- Trading Comps: Green\n- Precedent Trans: Orange\n- Vertical line at current price: Red dashed\n- Vertical line at target: Black solid\n```\n\n#### D. Scenario-Based Valuations\n\n```\nVALUATION BY SCENARIO\n\nScenario    Probability  Revenue  EBITDA    DCF      Comps    Weighted\n                        CAGR     Margin    Value    Multiple  Avg\nBear Case   20%         18%      28%       $38      11.5x     $42\nBase Case   60%         25%      32%       $46      13.8x     $59\nBull Case   20%         32%      36%       $58      16.0x     $82\n\nExpected Value (probability-weighted): $59\n```\n\n### Step 6: Final Price Target \u0026 Recommendation\n\n```\n═══════════════════════════════════════════════════════════\nINVESTMENT RECOMMENDATION\n═══════════════════════════════════════════════════════════\n\nCurrent Price:          $42.00 (as of [Date])\nPrice Target:           $59.00 (12-month)\nUpside/(Downside):      +40.5%\n\nRating:                 BUY / OUTPERFORM\n\nValuation Methodology:  Based on weighted average of DCF (50%),\n                       trading comparables (40%), and precedent\n                       transactions (10%).\n\nTime Horizon:          12 months\n\n───────────────────────────────────────────────────────────\nKEY INVESTMENT CATALYSTS\n───────────────────────────────────────────────────────────\n\n1. New Product Launch (Q2 2025)\n   - Expected to drive 15-20% revenue acceleration\n   - Already seeing strong pre-orders\n\n2. Margin Expansion (FY2025-2026)\n   - Operating leverage from scale\n   - Path to 35% EBITDA margin (from current 28%)\n\n3. Market Share Gains (Ongoing)\n   - Taking share from legacy competitors\n   - Net Promoter Score improvement\n\n4. International Expansion (H2 2025)\n   - Entry into European markets\n   - Potential $200M incremental revenue opportunity\n\n5. Potential M\u0026A Target (12-18 months)\n   - Strategic fit for larger players\n   - Precedent transactions suggest 30-40% premium\n\n───────────────────────────────────────────────────────────\nKEY RISKS TO PRICE TARGET\n───────────────────────────────────────────────────────────\n\nDownside Risks:\n1. Competitive Pressure (High probability, -15% impact)\n   - New entrant launched competing product\n   - Could pressure pricing and market share\n\n2. Execution Risk (Medium probability, -10% impact)\n   - New product launch delays or underperformance\n   - Management turnover\n\n3. Macro Slowdown (Medium probability, -20% impact)\n   - Economic recession would impact customer spending\n   - Operating leverage would reverse\n\n4. Regulatory Risk (Low probability, -25% impact)\n   - Potential new regulations in key market\n   - Would increase compliance costs\n\nUpside Risks:\n1. M\u0026A Bid (Low probability, +35% impact)\n   - Strategic acquirer pays control premium\n\n2. Beat-and-Raise (Medium probability, +10% impact)\n   - Consistent outperformance vs. estimates\n\n═══════════════════════════════════════════════════════════\n```\n\n---\n\n## Quality Standards\n\n### DCF Quality Checks\n- [ ] WACC properly calculated with documented components\n- [ ] Terminal value reasonable (\u003c 70% of total enterprise value)\n- [ ] Sensitivity analysis covers realistic ranges (±200-300bps for WACC, ±100bps for terminal growth)\n- [ ] Unlevered FCF properly calculated from EBIT\n- [ ] Enterprise to equity value bridge correct\n- [ ] Share count is diluted shares, not basic\n\n### Comparables Quality Checks\n- [ ] 5-10 comparable companies selected\n- [ ] Peer selection defensible (document why each peer was chosen)\n- [ ] Statistical summary included (max/75th/median/25th/min) - MANDATORY\n- [ ] Multiple selection appropriate (EV/EBITDA for mature, EV/Revenue for high-growth)\n- [ ] Premium/discount justified with specific factors\n- [ ] Data sourced properly with dates noted\n\n### Overall Valuation Quality Checks\n- [ ] At least 2 valuation methods used (DCF + Comps minimum)\n- [ ] Weighting explained and appropriate\n- [ ] Valuation range provided (low/base/high), not just point estimate\n- [ ] Scenarios analyzed (Bull/Base/Bear)\n- [ ] Sanity checks performed (see below)\n- [ ] All assumptions documented with rationale\n\n---\n\n## Sanity Checks\n\n**Always perform these validation checks:**\n\n1. **Historical Multiple Check**\n   - Is implied multiple in line with company's historical trading range?\n   - If not, explain why\n\n2. **Peer Comparison**\n   - Is premium/discount vs. peers justified by fundamentals?\n   - Check: growth, margins, market position\n\n3. **Implied Growth Check**\n   - What growth is market pricing in at current price?\n   - Is that reasonable given company trajectory?\n\n4. **Market Cap Reasonableness**\n   - Does total market cap make sense given company size and peers?\n   - Would company be too large/small relative to industry?\n\n5. **Terminal Value Check**\n   - Is terminal value \u003c 60-70% of total enterprise value?\n   - If \u003e 70%, projections may not be long enough\n\n6. **WACC Reasonableness**\n   - Is WACC 8-14% range for typical companies?\n   - Tech/high-growth: 10-14%\n   - Mature/stable: 7-10%\n\n7. **Implied Returns Check**\n   - What IRR from current price to target over 12 months?\n   - Is that consistent with recommendation rating?\n\n---\n\n## Output Files\n\nCreate the following deliverables:\n\n### 1. Valuation Analysis Document\n**File**: `[Company]_Valuation_Analysis_[Date].md` (written analysis)\n\n**Contents** (4-6 pages):\n- Executive summary with price target\n- DCF analysis (1 page) with sensitivity table\n- Comparable companies analysis (1 page) with statistical summary\n- Precedent transactions (0.5 page) if applicable\n- Valuation summary and football field (0.5 page)\n- Investment recommendation (1 page)\n- Key catalysts and risks (1 page)\n\n### 2. Excel Valuation Tabs\n**Add to Task 2's financial model file:** `[Company]_Financial_Model_[Date].xlsx`\n\n**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.\n\n**Tabs to add:**\n- DCF tab with full calculations\n- Sensitivity analysis tab\n- Comps tab with peer data\n- Precedent transactions tab (if applicable)\n- Valuation summary tab\n\n---\n\n## Success Criteria\n\nA successful valuation analysis should:\n1. Use at least 2 methods (DCF + Comps minimum)\n2. Include comprehensive DCF sensitivity analysis (2-way tables)\n3. Include statistical summary in comps (max/75th/median/25th/min)\n4. Provide valuation range (low/base/high), not point estimate\n5. Document all key assumptions with clear rationale\n6. Perform sanity checks\n7. Arrive at defensible price target\n8. Provide clear buy/hold/sell recommendation\n9. Identify 3-5 key catalysts\n10. Identify 3-5 key risks\n11. Be auditable and transparent\n\n---\n\n## Next Steps\n\nAfter completing Task 3, the valuation analysis will be used for:\n- **Task 4 (Charts)**: Create DCF sensitivity heatmaps, valuation football field, scenario comparison charts\n- **Task 5 (Report Assembly)**: Integrate valuation analysis into final report\n\nThe price target and recommendation are the foundation of the final investment recommendation in the equity research report.\n","references/task4-chart-generation.md":"# Task 4: Chart Generation - Detailed Workflow\n\nThis document provides step-by-step instructions for executing Task 4 (Chart Generation) of the initiating-coverage skill.\n\n## Task Overview\n\n**Purpose**: Generate 25-35 professional financial charts for the report.\n\n**Prerequisites**: ⚠️ Verify before starting\n- **Required**: Company research from Task 1\n  - Company history, milestones (for timeline charts)\n  - Management team, org structure (for org charts)\n  - Product portfolio (for product charts)\n  - Customer segmentation (for customer charts)\n  - Competitive landscape (for competitive positioning charts)\n  - TAM analysis (for market size charts)\n- **Required**: Financial model from Task 2\n  - Revenue by product/geography data\n  - Margin trends\n  - Scenario comparison data\n- **Required**: Valuation analysis from Task 3\n  - DCF sensitivity table\n  - Comparable companies data\n  - Valuation ranges\n- **Required**: External market data\n  - Historical stock price data (Yahoo Finance, Bloomberg)\n  - Historical valuation multiples (optional for chart 34)\n\n**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS TASKS 1, 2, AND 3 ARE COMPLETE**\n\nThis task requires outputs from all three previous tasks. Starting without them will result in incomplete charts.\n\n**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:\n- Task 1: Company research document (for 9 charts)\n- Task 2: Financial model with all 6 tabs (for 8 charts)\n- Task 3: Valuation tabs added to the model (for 6 charts)\n- External data access (for 2 charts)\n\nDo not attempt to create placeholder charts or skip charts due to missing data.\n\n**Output**: 25-35 Professional Chart Files (PNG/JPG, 300 DPI)\n\n---\n\n## Input Verification\n\n**BEFORE STARTING - CHECK ALL PREREQUISITES:**\n\n### Task 1 Verification (Company Research)\n- [ ] Task 1 complete? (Company research document exists)\n- [ ] Company history and milestones documented? (for charts 05, 06)\n- [ ] Management team and org structure described? (for chart 07)\n- [ ] Product portfolio detailed? (for chart 08)\n- [ ] Customer segmentation analyzed? (for chart 09)\n- [ ] Competitive landscape mapped? (for charts 16, 17, 18)\n- [ ] TAM sizing completed? (for chart 15)\n\n### Task 2 Verification (Financial Model)\n- [ ] Task 2 complete? (Financial model Excel file exists)\n- [ ] Revenue by product breakdown available? (for chart 03 ⭐)\n- [ ] Revenue by geography breakdown available? (for chart 04 ⭐)\n- [ ] Historical + projected financials complete? (for charts 02, 10, 11, 12)\n- [ ] Scenario analysis (Bull/Base/Bear) complete? (for chart 14)\n- [ ] Operating metrics available? (for chart 13)\n\n### Task 3 Verification (Valuation)\n- [ ] Task 3 complete? (Valuation tabs added to model)\n- [ ] DCF sensitivity matrix exists? (for chart 28 ⭐)\n- [ ] DCF calculation details available? (for chart 29)\n- [ ] Comparable companies data collected? (for charts 30, 31)\n- [ ] Valuation ranges calculated? (for chart 32 ⭐)\n\n### External Data Verification\n- [ ] Can access historical stock price data? (Yahoo Finance, Bloomberg for chart 01)\n- [ ] Can access historical valuation data? (Optional, for chart 34)\n\n**IF ANY VERIFICATION FAILS**:\n- Missing Task 1? → Complete Task 1 (Company Research) first\n- Missing Task 2? → Complete Task 2 (Financial Modeling) first\n- Missing Task 3? → Complete Task 3 (Valuation Analysis) first\n- Missing external data? → Gather from Yahoo Finance, Bloomberg, or similar sources\n\n---\n\n## Chart Requirements: 25 Required + 10 Optional\n\n**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.\n\n### 4 MANDATORY Charts (Non-Negotiable) ⭐\n\nThese 4 charts are critical visualizations that MUST be present:\n\n1. **chart_03**: Revenue by Product/Segment - Stacked Area Chart ⭐\n2. **chart_04**: Revenue by Geography - Stacked Bar Chart ⭐\n3. **chart_28**: DCF Sensitivity Analysis - 2-Way Heatmap ⭐\n4. **chart_32**: Valuation Football Field - Horizontal Bar Chart ⭐\n\n### 25 REQUIRED Charts (Complete Set)\n\nCreate all 25 of these charts. Each has a specific purpose in Task 5:\n\n**Investment Summary Section (1 chart):**\n- chart_01: Stock Price Performance (12-24 months)\n\n**Financial Performance Section (6 charts):**\n- chart_02: Revenue Growth Trajectory\n- chart_03: Revenue by Product - Stacked Area ⭐ MANDATORY\n- chart_04: Revenue by Geography - Stacked Bar ⭐ MANDATORY\n- chart_10: Gross Margin Evolution\n- chart_11: EBITDA Margin Progression\n- chart_12: Free Cash Flow Trend\n\n**Company 101 Section (7 charts):**\n- chart_05: Company Overview/Timeline\n- chart_06: Key Milestones Timeline\n- chart_07: Organizational Structure\n- chart_08: Product Portfolio Overview\n- chart_09: Customer Segmentation\n- chart_15: Market Size Evolution (TAM)\n- chart_16: Competitive Positioning Matrix\n\n**Competitive \u0026 Market Section (2 charts):**\n- chart_17: Market Share Breakdown\n- chart_18: Competitive Benchmarking\n\n**Scenario Analysis Section (2 charts):**\n- chart_13: Operating Metrics Dashboard\n- chart_14: Scenario Comparison (Bull/Base/Bear)\n\n**Valuation Section (7 charts):**\n- chart_28: DCF Sensitivity Heatmap ⭐ MANDATORY\n- chart_29: DCF Valuation Waterfall\n- chart_30: Trading Comps Scatter Plot\n- chart_31: Peer Multiples Comparison\n- chart_32: Valuation Football Field ⭐ MANDATORY\n- chart_33: Price Target Scenarios\n- chart_34: Historical Valuation Multiples\n\n**Total: 25 Required Charts**\n\n### 10 OPTIONAL Charts (For 30-35 Range)\n\nAdd these for greater visual density and storytelling (reach 26-35 total):\n\n- chart_19: Customer Acquisition Trends\n- chart_20: Unit Economics Evolution\n- chart_21: Product Roadmap Timeline\n- chart_22: Geographic Expansion Map\n- chart_23: R\u0026D Investment Trends\n- chart_24: Sales \u0026 Marketing Efficiency\n- chart_25: Working Capital Trends\n- chart_26: Debt Maturity Schedule\n- chart_27: Ownership Structure\n- chart_35: Analyst Price Target Distribution\n\n**Total Range: 25-35 Charts (25 required + 0-10 optional)**\n\n---\n\n## Data Source Mapping for Required Charts\n\nUnderstanding where each chart's data comes from:\n\n### From Task 1 (Company Research) - 9 charts\n- chart_05: Company Overview → Task 1: Company Overview section\n- chart_06: Key Milestones → Task 1: Company History section\n- chart_07: Org Structure → Task 1: Management Team section\n- chart_08: Product Portfolio → Task 1: Products \u0026 Services section\n- chart_09: Customer Segmentation → Task 1: Customers \u0026 Go-to-Market section\n- chart_15: Market Size Evolution → Task 1: Market Opportunity (TAM) section\n- chart_16: Competitive Positioning → Task 1: Competitive Landscape section\n- chart_17: Market Share → Task 1: Competitive Landscape section\n- chart_18: Competitive Benchmarking → Task 1: Competitive Landscape section\n\n### From Task 2 (Financial Model) - 8 charts\n- chart_02: Revenue Growth → Income Statement tab (Revenue row)\n- chart_03: Revenue by Product ⭐ → Revenue Model tab (Product breakdown)\n- chart_04: Revenue by Geography ⭐ → Revenue Model tab (Geography breakdown)\n- chart_10: Gross Margin → Income Statement tab (Gross Profit / Revenue)\n- chart_11: EBITDA Margin → Income Statement tab (EBITDA / Revenue)\n- chart_12: Free Cash Flow → Cash Flow Statement tab (CFO - CapEx)\n- chart_13: Operating Metrics → Multiple tabs (Income Statement, Cash Flow)\n- chart_14: Scenario Comparison → Scenarios tab (Bull/Base/Bear)\n\n### From Task 3 (Valuation) - 6 charts\n- chart_28: DCF Sensitivity ⭐ → Sensitivity Analysis tab\n- chart_29: DCF Waterfall → DCF tab (Enterprise Value components)\n- chart_30: Trading Comps Scatter → Comparable Companies tab\n- chart_31: Peer Multiples → Comparable Companies tab\n- chart_32: Valuation Football Field ⭐ → Valuation Summary tab\n- chart_33: Price Target Scenarios → Valuation Summary tab (or calculate from scenarios)\n\n### From External Sources - 2 charts\n- chart_01: Stock Price Performance → Yahoo Finance, Bloomberg, Alpha Vantage\n- chart_34: Historical Valuation Multiples → Yahoo Finance, Bloomberg (historical P/E, EV/EBITDA)\n\n**IMPORTANT**: Require ALL three tasks (1, 2, 3) complete PLUS external data access to create all 25 required charts.\n\n---\n\n## Step-by-Step Chart Generation Workflow\n\n### Step 1: Set Up Environment\n\n**Install required libraries:**\n```bash\npip install matplotlib seaborn pandas numpy plotly\n```\n\n**Create Python script header:**\n```python\nimport matplotlib.pyplot as plt\nimport seaborn as sns\nimport pandas as pd\nimport numpy as np\nfrom matplotlib.patches import Rectangle\nimport warnings\nwarnings.filterwarnings('ignore')\n\n# Set global style\nplt.style.use('seaborn-v0_8-darkgrid')\nsns.set_palette(\"husl\")\n\n# Global settings\nDPI = 300\nFIGURE_WIDTH = 10\nFIGURE_HEIGHT = 6\nTITLE_FONT_SIZE = 14\nAXIS_FONT_SIZE = 12\nLABEL_FONT_SIZE = 10\n```\n\n### Step 2: Extract Data from Model and Valuation\n\n#### A. Extract Revenue Data\n```python\n# Revenue by Product (from Task 2 model)\nyears = [2020, 2021, 2022, 2023, 2024, 2025, 2026, 2027, 2028, 2029]\n\n# Extract from Excel or define manually from model\nproduct_a = [100, 120, 145, 175, 210, 252, 302, 363, 435, 522]\nproduct_b = [80, 95, 115, 138, 165, 198, 238, 285, 342, 411]\nproduct_c = [50, 62, 78, 98, 122, 153, 191, 239, 299, 374]\nproduct_d = [30, 38, 48, 61, 77, 97, 122, 153, 191, 239]\n\n# Revenue by Geography\nnorth_america = [150, 180, 220, 265, 320, 384, 461, 553, 664, 797]\neurope = [80, 95, 115, 140, 170, 204, 245, 294, 353, 423]\nasia_pacific = [40, 50, 63, 80, 101, 127, 159, 199, 249, 311]\nrest_of_world = [20, 25, 32, 40, 51, 64, 80, 100, 125, 156]\n```\n\n#### B. Extract Margin Data\n```python\n# Margin evolution\ngross_margin = [58.0, 59.2, 60.5, 61.8, 63.0, 64.5, 66.0, 67.0, 67.5, 68.0]\nebitda_margin = [12.0, 15.5, 18.8, 22.0, 25.0, 28.0, 30.5, 32.0, 33.0, 34.0]\nfcf_margin = [8.0, 11.0, 14.5, 18.0, 21.0, 24.0, 26.5, 28.0, 29.0, 30.0]\n```\n\n#### C. Extract DCF Sensitivity Data\n```python\n# DCF Sensitivity (from Task 3 valuation)\nwacc_values = [7.0, 8.0, 9.0, 10.0, 11.0, 12.0]\nterminal_growth = [1.5, 2.0, 2.5, 3.0, 3.5]\n\n# Price per share matrix (rows = WACC, columns = terminal growth)\ndcf_sensitivity = np.array([\n    [66, 71, 76, 82, 89],\n    [58, 62, 67, 72, 78],\n    [52, 55, 59, 63, 68],\n    [47, 50, 53, 56, 60],\n    [42, 45, 48, 51, 54],\n    [39, 41, 44, 46, 49]\n])\n```\n\n#### D. Extract Valuation Ranges\n```python\n# Valuation Football Field (from Task 3)\nvaluation_methods = ['DCF Analysis', 'Trading Comps\\n(NTM)', 'Precedent\\nTransactions']\nvaluation_low = [48, 45, 52]\nvaluation_high = [62, 57, 66]\ncurrent_price = 50\ntarget_price = 55\n```\n\n### Step 3: Create Mandatory Charts\n\n#### Chart 1: Revenue by Product - Stacked Area ⭐ MANDATORY\n\n```python\ndef create_revenue_by_product_chart():\n    \"\"\"Create revenue by product stacked area chart\"\"\"\n\n    fig, ax = plt.subplots(figsize=(10, 6))\n\n    # Create stacked area chart\n    ax.stackplot(years, product_a, product_b, product_c, product_d,\n                 labels=['Product A', 'Product B', 'Product C', 'Product D'],\n                 colors=['#1f77b4', '#ff7f0e', '#2ca02c', '#d62728'],\n                 alpha=0.8)\n\n    # Formatting\n    ax.set_xlabel('Year', fontsize=12, fontweight='bold')\n    ax.set_ylabel('Revenue ($M)', fontsize=12, fontweight='bold')\n    ax.set_title('Figure 3 - Revenue by Product/Segment (2020-2029E)',\n                 fontsize=14, fontweight='bold', pad=20)\n\n    # Legend\n    ax.legend(loc='upper left', frameon=False, fontsize=10)\n\n    # Grid\n    ax.grid(axis='y', alpha=0.3, linestyle='--')\n    ax.set_axisbelow(True)\n\n    # Remove top and right spines\n    ax.spines['top'].set_visible(False)\n    ax.spines['right'].set_visible(False)\n\n    # Add vertical line to separate historical from projected\n    ax.axvline(x=2024, color='gray', linestyle='--', linewidth=1, alpha=0.5)\n    ax.text(2024.2, ax.get_ylim()[1]*0.95, 'Projected →',\n            fontsize=9, color='gray', ha='left')\n\n    # Source line\n    fig.text(0.12, 0.02, 'Source: Company data, [Firm] estimates',\n             fontsize=9, style='italic', color='gray')\n\n    # Save\n    plt.tight_layout()\n    plt.savefig('chart_03_revenue_by_product_stacked_area.png',\n                dpi=300, bbox_inches='tight', facecolor='white')\n    plt.close()\n    print(\"✓ Created: chart_03_revenue_by_product_stacked_area.png\")\n\ncreate_revenue_by_product_chart()\n```\n\n#### Chart 2: Revenue by Geography - Stacked Bar ⭐ MANDATORY\n\n```python\ndef create_revenue_by_geography_chart():\n    \"\"\"Create revenue by geography stacked bar chart\"\"\"\n\n    years_labels = ['2020', '2021', '2022', '2023', '2024',\n                    '2025E', '2026E', '2027E', '2028E', '2029E']\n\n    fig, ax = plt.subplots(figsize=(10, 6))\n\n    # Create stacked bar chart\n    width = 0.6\n    x = np.arange(len(years_labels))\n\n    p1 = ax.bar(x, north_america, width, label='North America', color='#1f77b4')\n    p2 = ax.bar(x, europe, width, bottom=north_america,\n                label='Europe', color='#ff7f0e')\n    p3 = ax.bar(x, asia_pacific, width,\n                bottom=np.array(north_america) + np.array(europe),\n                label='Asia-Pacific', color='#2ca02c')\n    p4 = ax.bar(x, rest_of_world, width,\n                bottom=np.array(north_america) + np.array(europe) + np.array(asia_pacific),\n                label='Rest of World', color='#d62728')\n\n    # Formatting\n    ax.set_xlabel('Year', fontsize=12, fontweight='bold')\n    ax.set_ylabel('Revenue ($M)', fontsize=12, fontweight='bold')\n    ax.set_title('Figure 4 - Revenue by Geography (2020-2029E)',\n                 fontsize=14, fontweight='bold', pad=20)\n    ax.set_xticks(x)\n    ax.set_xticklabels(years_labels, rotation=45, ha='right')\n\n    # Legend\n    ax.legend(loc='upper left', frameon=False, fontsize=10)\n\n    # Grid\n    ax.grid(axis='y', alpha=0.3, linestyle='--')\n    ax.set_axisbelow(True)\n\n    # Remove top and right spines\n    ax.spines['top'].set_visible(False)\n    ax.spines['right'].set_visible(False)\n\n    # Source line\n    fig.text(0.12, 0.02, 'Source: Company data, [Firm] estimates',\n             fontsize=9, style='italic', color='gray')\n\n    # Save\n    plt.tight_layout()\n    plt.savefig('chart_04_revenue_by_geography_stacked_bar.png',\n                dpi=300, bbox_inches='tight', facecolor='white')\n    plt.close()\n    print(\"✓ Created: chart_04_revenue_by_geography_stacked_bar.png\")\n\ncreate_revenue_by_geography_chart()\n```\n\n#### Chart 3: DCF Sensitivity - Heatmap ⭐ MANDATORY\n\n```python\ndef create_dcf_sensitivity_heatmap():\n    \"\"\"Create DCF sensitivity analysis heatmap\"\"\"\n\n    # Create DataFrame\n    df = pd.DataFrame(dcf_sensitivity,\n                      index=[f'{w}%' for w in wacc_values],\n                      columns=[f'{g}%' for g in terminal_growth])\n\n    fig, ax = plt.subplots(figsize=(8, 6))\n\n    # Create heatmap\n    sns.heatmap(df, annot=True, fmt='d', cmap='RdYlGn',\n                cbar_kws={'label': 'Price per Share ($)'},\n                linewidths=0.5, linecolor='white',\n                ax=ax, vmin=35, vmax=95)\n\n    # Formatting\n    ax.set_xlabel('Terminal Growth Rate', fontsize=12, fontweight='bold')\n    ax.set_ylabel('WACC', fontsize=12, fontweight='bold')\n    ax.set_title('Figure 28 - DCF Sensitivity Analysis ($/share)',\n                 fontsize=14, fontweight='bold', pad=20)\n\n    # Rotate y-axis labels\n    plt.yticks(rotation=0)\n\n    # Source line\n    fig.text(0.12, 0.02, 'Source: [Firm] estimates',\n             fontsize=9, style='italic', color='gray')\n\n    # Save\n    plt.tight_layout()\n    plt.savefig('chart_28_dcf_sensitivity_heatmap.png',\n                dpi=300, bbox_inches='tight', facecolor='white')\n    plt.close()\n    print(\"✓ Created: chart_28_dcf_sensitivity_heatmap.png\")\n\ncreate_dcf_sensitivity_heatmap()\n```\n\n#### Chart 4: Valuation Football Field ⭐ MANDATORY\n\n```python\ndef create_valuation_football_field():\n    \"\"\"Create valuation football field chart\"\"\"\n\n    fig, ax = plt.subplots(figsize=(10, 5))\n\n    # Create horizontal bars\n    y_positions = np.arange(len(valuation_methods))\n    colors = ['#1f77b4', '#ff7f0e', '#2ca02c']\n\n    for i, (method, low, high, color) in enumerate(\n            zip(valuation_methods, valuation_low, valuation_high, colors)):\n        ax.barh(i, high - low, left=low, height=0.6,\n                color=color, alpha=0.7, label=method)\n\n        # Add value labels at ends\n        ax.text(low - 1, i, f'${low}', va='center', ha='right', fontsize=10)\n        ax.text(high + 1, i, f'${high}', va='center', ha='left', fontsize=10)\n\n    # Add current price line\n    ax.axvline(x=current_price, color='red', linestyle='--', linewidth=2,\n               label=f'Current: ${current_price}', alpha=0.7)\n\n    # Add target price line\n    ax.axvline(x=target_price, color='black', linestyle='-', linewidth=2,\n               label=f'Target: ${target_price}')\n\n    # Formatting\n    ax.set_yticks(y_positions)\n    ax.set_yticklabels(valuation_methods, fontsize=11)\n    ax.set_xlabel('Price Per Share ($)', fontsize=12, fontweight='bold')\n    ax.set_title('Figure 32 - Valuation Football Field',\n                 fontsize=14, fontweight='bold', pad=20)\n\n    # Set x-axis limits\n    ax.set_xlim(40, 70)\n\n    # Remove spines\n    ax.spines['top'].set_visible(False)\n    ax.spines['right'].set_visible(False)\n    ax.spines['left'].set_visible(False)\n\n    # Grid\n    ax.grid(axis='x', alpha=0.3, linestyle='--')\n    ax.set_axisbelow(True)\n\n    # Legend\n    ax.legend(loc='upper right', frameon=False, fontsize=9)\n\n    # Source line\n    fig.text(0.12, 0.02, 'Source: [Firm] estimates',\n             fontsize=9, style='italic', color='gray')\n\n    # Save\n    plt.tight_layout()\n    plt.savefig('chart_32_valuation_football_field.png',\n                dpi=300, bbox_inches='tight', facecolor='white')\n    plt.close()\n    print(\"✓ Created: chart_32_valuation_football_field.png\")\n\ncreate_valuation_football_field()\n```\n\n### Step 4: Create Remaining Required Charts (Charts 1-34)\n\n**Complete the 25 REQUIRED charts** by creating all remaining charts from the required list. Each chart has a specific purpose in Task 5.\n\n#### Investment Summary (1 chart)\n```python\n# chart_01: Stock Price Performance (12-24 months)\n# - Line chart showing stock price over time vs. market index\n# - Used on Page 1 of final report\n```\n\n#### Financial Performance (5 additional charts beyond chart_03 and chart_04)\n```python\n# chart_02: Revenue Growth Trajectory\n# chart_10: Gross Margin Evolution\n# chart_11: EBITDA Margin Progression\n# chart_12: Free Cash Flow Trend\n# chart_14: Scenario Comparison (Bull/Base/Bear)\n```\n\n#### Company 101 Section (7 charts)\n```python\n# chart_05: Company Overview/Timeline\n# chart_06: Key Milestones Timeline\n# chart_07: Organizational Structure\n# chart_08: Product Portfolio Overview\n# chart_09: Customer Segmentation\n# chart_15: Market Size Evolution (TAM)\n# chart_16: Competitive Positioning Matrix\n```\n\n#### Competitive \u0026 Market (2 charts)\n```python\n# chart_17: Market Share Breakdown\n# chart_18: Competitive Benchmarking\n```\n\n#### Scenario Analysis (1 chart)\n```python\n# chart_13: Operating Metrics Dashboard\n```\n\n#### Valuation Section (6 additional charts beyond chart_28 and chart_32)\n```python\n# chart_29: DCF Valuation Waterfall\n# chart_30: Trading Comps Scatter Plot\n# chart_31: Peer Multiples Comparison\n# chart_33: Price Target Scenarios\n# chart_34: Historical Valuation Multiples\n```\n\n**Use consistent formatting across all charts:**\n- 300 DPI resolution\n- Professional color scheme\n- Clear labels, legends, and titles\n- Figure numbers (e.g., \"Figure 5 - Company Timeline\")\n- Source citations at bottom\n\n### Step 4B: Create Optional Charts (For 26-35 Total)\n\n**Optional**: Add 1-10 additional charts from this list for greater visual density:\n\n```python\n# chart_19: Customer Acquisition Trends\n# chart_20: Unit Economics Evolution\n# chart_21: Product Roadmap Timeline\n# chart_22: Geographic Expansion Map\n# chart_23: R\u0026D Investment Trends\n# chart_24: Sales \u0026 Marketing Efficiency\n# chart_25: Working Capital Trends\n# chart_26: Debt Maturity Schedule\n# chart_27: Ownership Structure\n# chart_35: Analyst Price Target Distribution\n```\n\nThese optional charts provide additional visual storytelling and help achieve the \"1 chart per 200-300 words\" density target in Task 5.\n\n### Step 5: Create Chart Index\n\nCreate a text file documenting all charts:\n\n```python\ndef create_chart_index():\n    \"\"\"Create index of all charts\"\"\"\n\n    # 25 REQUIRED CHARTS\n    required_charts = [\n        \"chart_01_stock_price_performance.png - Stock Price Performance (12-24M)\",\n        \"chart_02_revenue_growth_trajectory.png - Revenue Growth Trajectory\",\n        \"chart_03_revenue_by_product_stacked_area.png - Revenue by Product [MANDATORY]\",\n        \"chart_04_revenue_by_geography_stacked_bar.png - Revenue by Geography [MANDATORY]\",\n        \"chart_05_company_overview.png - Company Overview/Timeline\",\n        \"chart_06_key_milestones_timeline.png - Key Milestones Timeline\",\n        \"chart_07_organizational_structure.png - Organizational Structure\",\n        \"chart_08_product_portfolio.png - Product Portfolio Overview\",\n        \"chart_09_customer_segmentation.png - Customer Segmentation\",\n        \"chart_10_gross_margin_evolution.png - Gross Margin Evolution\",\n        \"chart_11_ebitda_margin_progression.png - EBITDA Margin Progression\",\n        \"chart_12_free_cash_flow_trend.png - Free Cash Flow Trend\",\n        \"chart_13_operating_metrics_dashboard.png - Operating Metrics Dashboard\",\n        \"chart_14_scenario_comparison.png - Scenario Comparison (Bull/Base/Bear)\",\n        \"chart_15_market_size_evolution.png - Market Size Evolution (TAM)\",\n        \"chart_16_competitive_positioning.png - Competitive Positioning Matrix\",\n        \"chart_17_market_share.png - Market Share Breakdown\",\n        \"chart_18_competitive_benchmarking.png - Competitive Benchmarking\",\n        \"chart_28_dcf_sensitivity_heatmap.png - DCF Sensitivity Heatmap [MANDATORY]\",\n        \"chart_29_dcf_waterfall.png - DCF Valuation Waterfall\",\n        \"chart_30_trading_comps_scatter.png - Trading Comps Scatter Plot\",\n        \"chart_31_peer_multiples_comparison.png - Peer Multiples Comparison\",\n        \"chart_32_valuation_football_field.png - Valuation Football Field [MANDATORY]\",\n        \"chart_33_price_target_scenarios.png - Price Target Scenarios\",\n        \"chart_34_historical_valuation_multiples.png - Historical Valuation Multiples\",\n    ]\n\n    # 10 OPTIONAL CHARTS (for 26-35 range)\n    optional_charts = [\n        \"chart_19_customer_acquisition_trends.png - Customer Acquisition Trends [OPTIONAL]\",\n        \"chart_20_unit_economics_evolution.png - Unit Economics Evolution [OPTIONAL]\",\n        \"chart_21_product_roadmap_timeline.png - Product Roadmap Timeline [OPTIONAL]\",\n        \"chart_22_geographic_expansion_map.png - Geographic Expansion Map [OPTIONAL]\",\n        \"chart_23_rd_investment_trends.png - R\u0026D Investment Trends [OPTIONAL]\",\n        \"chart_24_sales_marketing_efficiency.png - Sales \u0026 Marketing Efficiency [OPTIONAL]\",\n        \"chart_25_working_capital_trends.png - Working Capital Trends [OPTIONAL]\",\n        \"chart_26_debt_maturity_schedule.png - Debt Maturity Schedule [OPTIONAL]\",\n        \"chart_27_ownership_structure.png - Ownership Structure [OPTIONAL]\",\n        \"chart_35_analyst_price_targets.png - Analyst Price Target Distribution [OPTIONAL]\",\n    ]\n\n    with open('chart_index.txt', 'w') as f:\n        f.write(\"CHART INDEX FOR [COMPANY] EQUITY RESEARCH REPORT\\n\")\n        f.write(\"=\" * 60 + \"\\n\\n\")\n\n        f.write(\"4 MANDATORY CHARTS (Must be present):\\n\")\n        f.write(\"- chart_03: Revenue by Product (Stacked Area) ⭐\\n\")\n        f.write(\"- chart_04: Revenue by Geography (Stacked Bar) ⭐\\n\")\n        f.write(\"- chart_28: DCF Sensitivity (Heatmap) ⭐\\n\")\n        f.write(\"- chart_32: Valuation Football Field ⭐\\n\\n\")\n\n        f.write(\"25 REQUIRED CHARTS:\\n\")\n        for chart in required_charts:\n            f.write(f\"  {chart}\\n\")\n\n        f.write(\"\\n10 OPTIONAL CHARTS (for 26-35 total):\\n\")\n        for chart in optional_charts:\n            f.write(f\"  {chart}\\n\")\n\n        f.write(\"\\n\" + \"=\" * 60 + \"\\n\")\n        f.write(\"NOTE: Task 5 will embed ALL charts created (25-35) throughout\\n\")\n        f.write(\"the report for visual density (1 chart every 200-300 words).\\n\")\n\n    print(\"✓ Created: chart_index.txt\")\n\ncreate_chart_index()\n```\n\n### Step 6: Quality Check\n\n**Run verification checks:**\n\n```python\nimport os\n\ndef verify_charts():\n    \"\"\"Verify all charts were created successfully\"\"\"\n\n    mandatory_charts = [\n        'chart_03_revenue_by_product_stacked_area.png',\n        'chart_04_revenue_by_geography_stacked_bar.png',\n        'chart_28_dcf_sensitivity_heatmap.png',\n        'chart_32_valuation_football_field.png'\n    ]\n\n    print(\"\\n\" + \"=\"*60)\n    print(\"CHART GENERATION VERIFICATION\")\n    print(\"=\"*60)\n\n    # Check mandatory charts\n    print(\"\\n1. MANDATORY CHARTS:\")\n    all_mandatory_present = True\n    for chart in mandatory_charts:\n        if os.path.exists(chart):\n            size = os.path.getsize(chart) / 1024  # KB\n            print(f\"   ✓ {chart} ({size:.1f} KB)\")\n        else:\n            print(f\"   ✗ MISSING: {chart}\")\n            all_mandatory_present = False\n\n    # Count total charts\n    chart_files = [f for f in os.listdir('.') if f.startswith('chart_') and f.endswith('.png')]\n    print(f\"\\n2. TOTAL CHARTS: {len(chart_files)}\")\n    print(f\"   Target: 25-35 charts\")\n    print(f\"   Status: {'✓ PASS' if 25 \u003c= len(chart_files) \u003c= 35 else '⚠ WARNING'}\")\n\n    # Check file sizes (should be \u003e 50KB for 300 DPI)\n    print(\"\\n3. FILE SIZE CHECK:\")\n    small_files = []\n    for chart in chart_files[:5]:  # Sample first 5\n        size = os.path.getsize(chart) / 1024\n        if size \u003c 50:\n            small_files.append(chart)\n        print(f\"   {chart}: {size:.1f} KB\")\n\n    if small_files:\n        print(f\"   ⚠ WARNING: {len(small_files)} files may be low resolution\")\n    else:\n        print(f\"   ✓ All sampled files have adequate size\")\n\n    # Final verdict\n    print(\"\\n\" + \"=\"*60)\n    if all_mandatory_present and 25 \u003c= len(chart_files) \u003c= 35:\n        print(\"✓ VERIFICATION PASSED - Ready for Task 5\")\n    else:\n        print(\"✗ VERIFICATION FAILED - Review missing charts\")\n    print(\"=\"*60 + \"\\n\")\n\nverify_charts()\n```\n\n---\n\n## Quality Standards\n\n### Visual Quality\n- [ ] High resolution (300 DPI minimum)\n- [ ] Professional color scheme (consistent across all charts)\n- [ ] Clear, legible text (no fonts smaller than 9pt)\n- [ ] Proper aspect ratio (no distortion)\n- [ ] No pixelation or artifacts\n\n### Data Accuracy\n- [ ] Data matches source (financial model and valuation)\n- [ ] Proper units and labels ($ millions, percentages, etc.)\n- [ ] Appropriate scale and range\n- [ ] Consistent time periods across charts\n- [ ] Verified calculations\n\n### Formatting Quality\n- [ ] Consistent styling across all charts\n- [ ] Proper figure numbering (sequential)\n- [ ] Clear titles and captions\n- [ ] Source citations on every chart\n- [ ] Professional appearance\n\n### Completeness\n- [ ] All 4 mandatory charts created\n- [ ] 25-35 total charts\n- [ ] Proper file naming (chart_01, chart_02, etc.)\n- [ ] Chart index created\n- [ ] Ready for embedding in Word\n\n---\n\n## Chart Types Reference\n\n### When to Use Each Chart Type\n\n**Line Charts**: Time series trends (revenue, margins, stock price)\n\n**Stacked Area**: Revenue by product ⭐, market size composition\n\n**Stacked Bar**: Revenue by geography ⭐, quarterly breakdowns\n\n**Heatmap**: DCF sensitivity ⭐, correlation matrices\n\n**Horizontal Bar**: Valuation football field ⭐, peer rankings\n\n**Waterfall**: Revenue bridges, margin analysis, DCF build-up\n\n**Scatter/Bubble**: Growth vs. valuation, competitive positioning\n\n**2×2 Matrix**: Competitive positioning, product portfolio\n\n---\n\n## File Naming Convention\n\n**Always use this format:**\n```\nchart_[NUMBER]_[DESCRIPTION].png\n\nExamples:\nchart_01_stock_price_performance.png\nchart_03_revenue_by_product_stacked_area.png\nchart_28_dcf_sensitivity_heatmap.png\n```\n\n**Number charts sequentially** based on their position in the report, not creation order.\n\n---\n\n## Common Chart Generation Issues\n\n### Issue 1: Low Resolution\n**Problem**: Chart looks pixelated\n**Solution**: Ensure `dpi=300` in `plt.savefig()`\n\n### Issue 2: Text Cutoff\n**Problem**: Labels or titles cut off at edges\n**Solution**: Use `bbox_inches='tight'` in `plt.savefig()`\n\n### Issue 3: Poor Colors\n**Problem**: Colors don't look professional\n**Solution**: Use established palettes like Tableau10 or define custom corporate colors\n\n### Issue 4: Overlapping Labels\n**Problem**: Axis labels overlap\n**Solution**: Rotate labels (e.g., `rotation=45`) or reduce font size\n\n### Issue 5: White Space\n**Problem**: Too much white space around chart\n**Solution**: Use `plt.tight_layout()` before saving\n\n---\n\n## Success Criteria\n\nA successful chart package should:\n1. **Include all 4 mandatory charts** (verified) ⭐\n   - chart_03: Revenue by Product\n   - chart_04: Revenue by Geography\n   - chart_28: DCF Sensitivity\n   - chart_32: Valuation Football Field\n2. **Create 25 required charts minimum** (verified)\n3. **Optional: 1-10 additional charts** for 26-35 total\n4. Have consistent professional styling across all charts\n5. Be high resolution (300 DPI) for print quality\n6. Have clear labels, legends, and titles on every chart\n7. Include proper figure numbers and source citations\n8. Be ready for immediate embedding in Word\n9. Cover all key financial metrics and analyses\n10. Tell a visual story complementing the written analysis\n11. Be accurate and auditable to source data (model/valuation)\n12. All charts packaged in zip file with chart index\n\n**Remember**: Task 5 will embed ALL charts created (25-35) throughout the report for visual density.\n\n---\n\n## Output Files\n\nAfter completing Task 4, deliverables include:\n\n**25 REQUIRED Chart Files (Minimum):**\n1. chart_01_stock_price_performance.png\n2. chart_02_revenue_growth_trajectory.png\n3. chart_03_revenue_by_product_stacked_area.png ⭐ MANDATORY\n4. chart_04_revenue_by_geography_stacked_bar.png ⭐ MANDATORY\n5. chart_05_company_overview.png\n6. chart_06_key_milestones_timeline.png\n7. chart_07_organizational_structure.png\n8. chart_08_product_portfolio.png\n9. chart_09_customer_segmentation.png\n10. chart_10_gross_margin_evolution.png\n11. chart_11_ebitda_margin_progression.png\n12. chart_12_free_cash_flow_trend.png\n13. chart_13_operating_metrics_dashboard.png\n14. chart_14_scenario_comparison.png\n15. chart_15_market_size_evolution.png\n16. chart_16_competitive_positioning.png\n17. chart_17_market_share.png\n18. chart_18_competitive_benchmarking.png\n19-27. *Reserved for optional charts if created*\n28. chart_28_dcf_sensitivity_heatmap.png ⭐ MANDATORY\n29. chart_29_dcf_waterfall.png\n30. chart_30_trading_comps_scatter.png\n31. chart_31_peer_multiples_comparison.png\n32. chart_32_valuation_football_field.png ⭐ MANDATORY\n33. chart_33_price_target_scenarios.png\n34. chart_34_historical_valuation_multiples.png\n35. *Reserved for optional chart if created*\n\n**10 OPTIONAL Chart Files (For 26-35 Total):**\n- chart_19 through chart_27, chart_35 (if created)\n\n**Chart Index** (1 text file):\n- chart_index.txt (listing all charts with descriptions and categories)\n\n**All chart files must be:**\n- 300 DPI resolution (print quality)\n- 6-10 inches wide (standard Word embedding size)\n- White background (professional appearance)\n- PNG format (lossless quality)\n- Ready for immediate Word embedding\n\n**Final Step: Package All Charts**\n\nCreate a zip file containing all chart files and the chart index:\n\n```\n[Company]_Charts_[Date].zip\n├── chart_01_stock_price_performance.png\n├── chart_02_revenue_growth_trajectory.png\n├── chart_03_revenue_by_product_stacked_area.png ⭐\n├── chart_04_revenue_by_geography_stacked_bar.png ⭐\n├── chart_05_company_overview.png\n├── ... (all 25-35 chart files)\n├── chart_28_dcf_sensitivity_heatmap.png ⭐\n├── chart_32_valuation_football_field.png ⭐\n├── chart_34_historical_valuation_multiples.png\n└── chart_index.txt\n```\n\n**Example**: `Tesla_Charts_2024-10-28.zip`\n\n**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.\n- Verify all 25-35 charts are present\n- Extract charts for Task 5 (Report Assembly)\n\n---\n\n## Next Steps\n\nAfter completing Task 4, the zip file will be used for:\n- **Task 5 (Report Assembly)**: Extract charts and embed all into the final DOCX report at appropriate locations throughout the document\n\nThe 4 mandatory charts are critical for the valuation and financial analysis sections of the report.\n","references/task5-report-assembly.md":"# Task 5: Report Assembly - Detailed Workflow\n\nThis document provides step-by-step instructions for executing Task 5 (Report Assembly) of the initiating-coverage skill.\n\n## Task Overview\n\n**Purpose**: Write and assemble the comprehensive final DOCX report.\n\n**Prerequisites**: ⚠️ Verify before starting - ALL PREVIOUS TASKS REQUIRED\n- **Required**: Company research from Task 1\n- **Required**: Financial model from Task 2\n- **Required**: Valuation analysis from Task 3\n- **Required**: Chart files from Task 4\n\n**⚠️ CRITICAL: DO NOT START THIS TASK UNLESS ALL TASKS 1-4 ARE COMPLETE**\n\nThis is the final assembly task. It cannot be completed without all previous work products.\n\n**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:\n- Task 1: Company research document (6-8K words)\n- Task 2: Financial model with all 6 tabs\n- Task 3: Valuation analysis with price target and recommendation\n- Task 4: Charts zip file with 25-35 charts\n\nDo not attempt to create placeholder content, substitute missing sections, or assemble an incomplete report. The report requires ALL inputs to be publication-ready.\n\n**Output**: Comprehensive Equity Research Report (.docx)\n- Length: 30-50 pages (MINIMUM 30)\n- Word count: 10,000-15,000 words (MINIMUM 10,000)\n- Charts: 25-35 embedded images\n- Tables: 12-20 comprehensive tables\n\n---\n\n## 🔥 CRITICAL INSTRUCTION: SPARE NO TOKENS OR EFFORT\n\n**THIS IS THE FINAL DELIVERABLE. GO ALL OUT. NO SHORTCUTS. NO ABBREVIATIONS.**\n\nAfter completing 4 previous tasks, this final task assembles everything into publication-ready institutional research. **This must be PERFECT.**\n\n### Absolute Requirements\n\n**DO:**\n- ✅ **Use ENTIRE token budget if needed** - This is what it's for\n- ✅ **Write EVERY section in FULL** - Not summaries, not placeholders, FULL CONTENT\n- ✅ **Include ALL 25-35 charts** - Embed every single chart from Task 4 throughout the document\n- ✅ **Create ALL 12-20 tables** - Extract every financial table from Excel, don't skip any\n- ✅ **Copy ALL 6-8K words from Task 1** - Use Company 101 content verbatim (40-50% of report)\n- ✅ **Write 2,000-3,000 words on Projection Assumptions** - Product-by-product, region-by-region detail\n- ✅ **Write 1,500-2,000 words on Scenario Analysis** - Specific Bull/Base/Bear parameters\n- ✅ **Achieve 10,000-15,000 total words** - This is a MINIMUM, not a suggestion\n- ✅ **Produce 30-50 pages minimum** - Text-dense with charts every 200-300 words\n- ✅ **Professional institutional quality** - Indistinguishable from JPMorgan/Goldman Sachs\n\n**NEVER:**\n- ❌ \"This section would include...\" - WRITE THE ACTUAL SECTION\n- ❌ \"Charts would be inserted here...\" - INSERT THE ACTUAL CHARTS\n- ❌ \"See financial model for details...\" - EXTRACT AND WRITE THE DETAILS\n- ❌ \"For brevity, we'll summarize...\" - NO SUMMARIZING, WRITE IN FULL\n- ❌ Skip sections to conserve tokens - USE WHATEVER TOKENS ARE NEEDED\n- ❌ Create abbreviated versions - EVERY SECTION MUST BE COMPLETE\n- ❌ Reference external files instead of including content - INCLUDE EVERYTHING\n\n### Quality Standard\n\n**This report will be read by institutional investors making million-dollar decisions.**\n\nIt must be:\n- **Complete**: Every section written in full with no placeholders\n- **Comprehensive**: All data extracted and included, all charts embedded\n- **Professional**: Proper formatting, citations, tables, charts throughout\n- **Thorough**: Deep analysis with specific numbers, detailed assumptions, complete scenarios\n- **Dense**: 60-80% page coverage with text and visuals on every page\n\n**Creating the final work product of a 6-10 hour equity research process. Make it count.**\n\n---\n\n## Input Verification (CRITICAL)\n\n**BEFORE STARTING - ALL TASKS MUST BE COMPLETE:**\n\n### Task 1 Verification:\n- [ ] Company research document exists? (6-8K words)\n- [ ] Management bios complete? (300-400 words × 3-4 execs)\n- [ ] Competitive analysis complete? (5-10 competitors)\n- [ ] Risk assessment complete? (8-12 risks)\n\n### Task 2 Verification:\n- [ ] Financial model exists and can be opened?\n- [ ] Model has projections (5 years)?\n- [ ] Scenarios exist (Bull/Base/Bear)?\n- [ ] Revenue by product table complete (20-30 rows)?\n- [ ] Revenue by geography table complete (15-20 rows)?\n\n### Task 3 Verification:\n- [ ] Valuation analysis complete?\n- [ ] Price target determined?\n- [ ] Recommendation set? (BUY/HOLD/SELL)\n- [ ] DCF analysis complete with sensitivity table?\n- [ ] Comparable companies analysis complete with statistical summary?\n\n### Task 4 Verification:\n- [ ] 25-35 chart files exist?\n- [ ] All 4 mandatory charts present?\n  - [ ] Revenue by product (stacked area)\n  - [ ] Revenue by geography (stacked bar)\n  - [ ] DCF sensitivity (heatmap)\n  - [ ] Valuation football field\n- [ ] Chart files accessible and can be opened?\n- [ ] Chart index created?\n\n**IF ANY VERIFICATION FAILS**: Stop and complete missing task first.\n\n---\n\n## Report Specifications\n\n### Length Requirements\n- **Pages**: 30-50 (MINIMUM 30 pages)\n- **Word Count**: 10,000-15,000 words (MINIMUM 10,000 words)\n- **Charts**: 25-35 embedded PNG/JPG images\n- **Tables**: 12-20 comprehensive financial tables\n- **Density**: 60-80% page coverage\n\n### Critical Sections with Word Counts\n\n| Section | Minimum | Target | Critical? |\n|---------|---------|--------|-----------|\n| Investment Summary (Page 1) | 500 | 700 | |\n| Investment Thesis | 800 | 1,200 | |\n| Risk Factors | 600 | 900 | |\n| Company Description | 800 | 1,200 | |\n| Management Bios | 1,000 | 1,400 | |\n| Products \u0026 Services | 700 | 1,000 | |\n| **Projection Assumptions** | **2,000** | **3,000** | ⭐ YES |\n| **Scenario Analysis** | **1,500** | **2,000** | ⭐ YES |\n| Financial Analysis | 1,200 | 1,800 | |\n| Valuation Methodology | 800 | 1,200 | |\n\n**Total: 10,000-15,000 words**\n\n---\n\n## Report Structure\n\n### Page 1: Investment Summary (CRITICAL PAGE)\n\n**This is the most important page. Must have:**\n\n1. **\"INITIATING COVERAGE\" header** (NOT \"Company Update\")\n2. **Thesis-focused title** (e.g., \"AI Platform Leader Positioned for 40% CAGR\")\n3. **Rating box** with:\n   - Rating (BUY/OUTPERFORM/HOLD/UNDERPERFORM/SELL)\n   - Current price\n   - Target price\n   - 52-week range\n   - Market cap\n   - Enterprise value\n4. **Research analyst information** with credentials\n5. **Stock price performance chart** (Figure 1)\n6. **3-4 detailed investment bullets** with ■ character\n   - Each bullet has **bold topic header** + 3-5 sentences\n   - Lead with key numbers\n7. **Financial summary table** (2-3 years historical + 2-3 years projected)\n   - Years noted as \"A\" for actual, \"E\" for estimate\n\n**Bullet Format Example:**\n```\n■ **Vertical SaaS leadership and regulatory moat should enable $50bn+ TAM by 2030.**\nDeep domain expertise in healthcare IT, strong customer retention (95%+ net revenue retention),\nand cross-sell capabilities have driven Acme Health's market expansion. With the healthcare IT\nmarket expected to reach $50bn+ by 2030, Acme Health is well-positioned to capture share given\nits regulatory moat and high switching costs. Management has indicated that 70% of current\nrevenue comes from enterprise hospital systems, suggesting strong product-market fit.\n```\n\n### Pages 2-5: Investment Thesis \u0026 Risks\n\n**Investment Thesis (800-1,200 words)**\n- 3-5 key thesis pillars\n- Each pillar: 200-300 words\n- Lead with key statistic\n- Quantify financial impact\n- Include timeline\n\n**Risk Assessment (600-900 words)**\n- 8-12 identified risks\n- Organized by category:\n  - Company-specific risks (4-6)\n  - Industry/market risks (3-4)\n  - Financial risks (2-3)\n  - Macroeconomic risks (2-3)\n- Each risk: 50-100 word description\n\n### Pages 6-17: Company 101\n\n**Company Description (800-1,200 words)**\n- What the company does (plain English)\n- Business model and monetization\n- Geographic presence\n- Scale metrics\n\n**Company History (800-1,200 words)**\n- Founding story\n- Timeline of major milestones\n- Strategic pivots\n- Recent developments\n\n**Management Team (1,000-1,400 words)**\n- 300-400 word bio for each of 3-4 key executives\n- Include: role, background, accomplishments, education\n- Governance structure\n\n**Products \u0026 Services (700-1,000 words)**\n- Detailed product portfolio\n- Features and differentiation\n- Target customers\n- Pricing models\n\n**Customers \u0026 Go-to-Market (500-700 words)**\n- Customer segments\n- Distribution channels\n- Sales strategy\n- Key partnerships\n\n**Industry Overview (800-1,200 words)**\n- Industry definition and scope\n- Market size and growth\n- Key trends\n- Regulatory environment\n\n**Competitive Landscape (700-1,000 words)**\n- 5-10 key competitors\n- Market positioning\n- Competitive advantages\n- Market share analysis\n\n**TAM Analysis (500-700 words)**\n- Total addressable market sizing\n- Market growth projections\n- Company's serviceable market\n\n### Pages 18-30: Financial Analysis\n\n**Historical Financial Analysis (1,200-1,800 words)**\n- Revenue trends and drivers\n- Margin evolution\n- Cash flow analysis\n- Key metrics trajectory\n- Historical context\n\n**Projection Assumptions (2,000-3,000 words)** ⭐ CRITICAL\n\n**MUST be extremely detailed. Structure:**\n\n**A. Revenue by Product Assumptions (1,000-1,500 words)**\n\nFor EACH major product category:\n```\n[Product Category A] Revenue Assumptions\n\nWe project [Product A] revenue to grow from $XXM in 2024A to $XXM in 2029E,\nrepresenting a XX% CAGR. This growth is driven by:\n\n1. [Driver 1 with specific quantification]\n   - Specific metric: from XX to XX\n   - Timeline: achieving YY by 2026E\n   - Basis: [source or rationale]\n\n2. [Driver 2 with specific quantification]\n3. [Driver 3 with specific quantification]\n[... 8-12 detailed points total for this product ...]\n\nSpecific assumptions by year:\n- 2025E: XX% growth driven by [specific factors]\n- 2026E: XX% growth as [specific factors]\n- 2027-2029E: XX% CAGR as [longer-term factors]\n\nKey risks to these assumptions include [specific risks].\n```\n\n**Repeat for EACH major product category.**\n\n**B. Geographic Revenue Assumptions (500-800 words)**\n\nFor EACH major region:\n```\n[Region] Revenue Assumptions\n\nWe project [Region] revenue to grow XX% CAGR from 2024-2029E, reaching $XXM, driven by:\n\n1. [Market dynamic with quantification]\n2. [Distribution expansion with specifics]\n3. [Competitive positioning]\n[... 6-8 detailed points total for this region ...]\n```\n\n**Repeat for EACH major geographic region.**\n\n**C. Other Key Assumptions (500-700 words)**\n- Gross margin evolution (with specific drivers and bridge)\n- Operating expense assumptions (R\u0026D, S\u0026M, G\u0026A as % of revenue)\n- Working capital assumptions (DSO, DIO, DPO with specific days)\n- CapEx as % of sales (with justification)\n- Tax rate assumptions\n\n**Scenario Analysis (1,500-2,000 words)** ⭐ CRITICAL\n\n**MUST have specific parameters for each scenario. Structure:**\n\n**Bull Case (500-700 words)**\n```\nBull Case: [Title describing key optimistic scenario]\n\nProbability: XX%\n\nKey Assumptions:\n- Revenue CAGR (2024-2029E): XX% (vs. XX% base case)\n- 2029E Revenue: $X,XXXm (vs. $X,XXXm base)\n- 2029E EBITDA Margin: XX% (vs. XX% base)\n- Key product growth: XX% CAGR (vs. XX% base)\n- Geographic expansion: [specific milestones and timeline]\n- Market share: XX% by 2029E (vs. XX% base)\n\nCatalysts Required for Bull Case:\n1. [Specific catalyst] - Expected timing: [date/quarter]\n2. [Specific catalyst] - Expected timing: [date/quarter]\n3. [Specific catalyst] - Expected timing: [date/quarter]\n\nDetailed Rationale:\n[200-300 words explaining what needs to happen for bull case to materialize.\nBe specific about product launches, market conditions, competitive dynamics, etc.]\n\nValuation Implications:\n- DCF Value: $XX per share (XX% upside from current)\n- Trading Comps: XX.Xx EV/EBITDA implies $XX per share\n- Bull Case Target: $XX per share\n```\n\n**Base Case (300-500 words)**\n```\nBase Case: [Title describing most likely scenario]\n\nProbability: XX%\n\nKey Assumptions:\n[Similar structure to Bull Case with base assumptions]\n\nRationale:\n[Explain why this is most likely scenario]\n\nValuation:\n- DCF Value: $XX per share\n- Trading Comps: $XX per share\n- Base Case Target: $XX per share (weighted average)\n```\n\n**Bear Case (500-700 words)**\n```\nBear Case: [Title describing downside scenario]\n\nProbability: XX%\n\nKey Assumptions:\n[Similar structure with downside parameters]\n\nDownside Triggers:\n1. [Specific risk event] - Likelihood: [%]\n2. [Specific risk event] - Likelihood: [%]\n3. [Specific risk event] - Likelihood: [%]\n\nRationale:\n[200-300 words on what would cause bear case]\n\nValuation Implications:\n- DCF Value: $XX per share (XX% downside from current)\n- Trading Comps: $XX per share\n- Bear Case Target: $XX per share\n```\n\n**Scenario Comparison (200-300 words)**\n- Comprehensive comparison table with key metrics\n- Analysis of probability-weighted outcomes\n- Risk/reward assessment\n- Path dependency discussion\n\n**Growth Drivers (800-1,200 words)**\n- 3-5 key growth drivers\n- Each quantified with specific opportunity size\n- Timeline and milestones\n- Supporting data from model\n\n### Pages 31-40: Valuation Analysis\n\n**Valuation Methodology (800-1,200 words)**\n\n**DCF Analysis (300-400 words)**\n- Methodology explanation\n- Key assumptions:\n  - WACC: X.X% (calculation breakdown)\n  - Terminal growth: X.X% (rationale)\n  - Terminal margin: XX% (justification)\n- Sensitivity analysis discussion\n- DCF value: $XX per share\n\n**Comparable Companies (300-400 words)**\n- Peer selection rationale (why these 5-10 companies)\n- Statistical summary (max/75th/median/25th/min)\n- Multiple selection (why EV/EBITDA vs. EV/Revenue vs. P/E)\n- Premium/discount justification (why target deserves premium/discount)\n- Comparable companies value: $XX per share\n\n**Precedent Transactions (200-300 words, if applicable)**\n- Transaction relevance\n- Control premium analysis\n- Precedent transactions value: $XX per share\n\n**Valuation Reconciliation (200-300 words)**\n- Weighting rationale (e.g., DCF 50%, Comps 40%, Precedent 10%)\n- Weighted average calculation\n- Valuation range (low/base/high)\n- Final price target: $XX\n\n**Price Target \u0026 Recommendation (300-500 words)**\n- Final recommendation (BUY/OUTPERFORM/HOLD/UNDERPERFORM/SELL)\n- Price target: $XX (XX% upside from current $XX)\n- Time horizon: 12 months\n- Key catalysts (3-5 with specific timeframes)\n- Key risks to price target (3-5 with impact quantification)\n\n### Pages 41-50: Appendices\n\n**Data Sources \u0026 References**\n- All sources listed with dates\n- Organized by category:\n  - SEC Filings (with EDGAR links)\n  - Earnings Calls (with transcript links)\n  - Company Materials\n  - Industry Reports\n  - News Articles\n- **ALL URLs must be clickable hyperlinks**\n\n**Detailed Financial Model Assumptions**\n- Comprehensive assumptions detail\n- Calculation methodologies\n- Data sources for historical figures\n\n**Additional Supporting Tables**\n- Extended financial projections\n- Detailed comparable companies data\n- Sensitivity analyses\n\n---\n\n## Report Assembly Philosophy\n\n**CRITICAL PRINCIPLE 1**: A good equity research report is **text-dense with lots of illustrating images**.\n\n**Target density**: 60-80% page coverage\n- Every page should have BOTH text AND visuals\n- Charts should be interspersed throughout text, not grouped\n- Average 1 chart per page minimum (30-50 pages = 25-35+ charts)\n- Tables should break up large text blocks\n\n**CRITICAL PRINCIPLE 2**: Use Claude's DOCX and XLSX skills to programmatically create the report.\n\n**REQUIRED TOOLS** (Claude has built-in skills for these):\n- **DOCX skill** - To create and manipulate Word documents\n  - Read Task 1 .md file → Convert to Word formatting\n  - Insert images from Task 4 chart files\n  - Create tables\n  - Format text, headers, footers, page numbers\n  - Add hyperlinks\n- **XLSX skill** - To read data from Excel files\n  - Extract tables from Task 2 financial model\n  - Read Task 3 valuation tabs\n  - Pull historical financials from Task 1\n- **Direct file operations** - Work with actual files\n  - Read: `[Company]_Research_Document_[Date].md`\n  - Read: `[Company]_Financial_Model_[Date].xlsx`\n  - Read: `chart_01.png`, `chart_02.png`, etc.\n  - Write: `[Company]_Initiation_Report_[Date].docx`\n\n**DO NOT**: Manually copy/paste or describe what should be done\n**DO**: Use Claude's DOCX and XLSX skills to open files, extract data, and create the DOCX report\n\n**Content Reuse Strategy**:\n- **Task 1 content (40-50% of report)**: Read .md file → Convert to Word format → Add charts\n- **Task 2/3 data (30-40% of report)**: Read .xlsx file → Extract tables → Write interpretation\n- **Original writing (10-20% of report)**: Investment thesis, projection assumptions, scenario analysis\n\n**This approach**:\n- Maximizes efficiency (no rewriting 6-8K words that are already good)\n- Maintains quality (Task 1 content is substantive, professional analysis)\n- Focuses effort on value-add (quantitative interpretation and investment thesis)\n- Uses actual files programmatically (not manual work)\n\n---\n\n## Step-by-Step Report Assembly Workflow\n\n### Step 1: Organize All Inputs and Verify Files\n\n**Verify all input files exist:**\n\nUse Claude's file operations to check:\n- `[Company]_Research_Document_[Date].md` (Task 1)\n- `[Company]_Historical_Financials_[Date].xlsx` (Task 1)\n- `[Company]_Financial_Model_[Date].xlsx` (Task 2 with Task 3 tabs)\n- `[Company]_Valuation_Analysis_[Date].md` (Task 3)\n- `[Company]_Charts_[Date].zip` (Task 4) - **Extract this first**\n\n**Step 1a: Extract Charts from Zip File**\n\nBefore proceeding, extract all chart files from the Task 4 zip:\n- Locate `[Company]_Charts_[Date].zip`\n- Extract all contents to a working directory (e.g., `task4_charts/`)\n- Verify 25-35 PNG files were extracted\n- Verify chart_index.txt is present\n\n**Expected folder structure after extraction:**\n```\n[Company]_Report_Working/\n├── [Company]_Research_Document_[Date].md\n├── [Company]_Historical_Financials_[Date].xlsx\n├── [Company]_Financial_Model_[Date].xlsx (includes Task 3 valuation tabs)\n│   ├── [Task 2 tabs: Revenue Model, Income Statement, Scenarios, etc.]\n│   └── [Task 3 tabs: DCF, Sensitivity, Comps, Valuation Summary]\n├── [Company]_Valuation_Analysis_[Date].md\n├── [Company]_Charts_[Date].zip\n├── task4_charts/ (extracted from zip)\n│   ├── chart_01_stock_price.png\n│   ├── chart_02_revenue_growth.png\n│   ├── chart_03_revenue_by_product.png ⭐\n│   ├── chart_04_revenue_by_geography.png ⭐\n│   ├── ... (21-31 more charts)\n│   ├── chart_28_dcf_sensitivity.png ⭐\n│   ├── chart_32_valuation_football_field.png ⭐\n│   └── chart_index.txt\n└── sources_and_urls.txt\n```\n\n**Open and inspect files using Claude skills:**\n\n1. **Read Task 1 markdown file** - Use Read tool to view content\n2. **Open Task 2/3 Excel file** - Use XLSX skill to inspect tabs:\n   - Verify required tabs exist: Revenue Model, Income Statement, Scenarios, DCF, Sensitivity Analysis, Comparable Companies\n3. **Read Task 3 markdown file** - Use Read tool to view valuation analysis\n4. **Check chart files** - Verify all 25-35 PNG files present\n\n**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.\n\n### Step 2: Extract Tables from Excel Using XLSX Skill\n\n**Use Claude's XLSX skill to extract data from Excel files:**\n\n#### Table 1: Page 1 Summary Financials\n\nUse XLSX skill to:\n1. Open `[Company]_Financial_Model_[Date].xlsx`\n2. Read from `Income Statement` tab\n3. Extract key rows: Revenue, Gross Profit, EBITDA, Net Income, EPS, FCF\n4. Extract years: 2022A, 2023A, 2024A, 2025E, 2026E, 2027E\n5. Create summary table with growth rates and margins\n\n#### Table 2: Full Income Statement (40-50 line items)\n\nUse XLSX skill to:\n1. Open `[Company]_Financial_Model_[Date].xlsx`\n2. Read entire `Income Statement` tab\n3. Extract all line items (40-50 rows)\n4. Extract columns for historical (2020A-2024A) + projected years (2025E-2029E)\n5. Include all margins and growth rates\n\n#### Table 3: Revenue by Product (20-30 rows)\n\nUse XLSX skill to:\n1. Open `[Company]_Financial_Model_[Date].xlsx`\n2. Read from `Revenue Model` tab\n3. Navigate to product section (typically starts ~row 5)\n4. Extract 20-30 rows showing each product category\n5. Include columns: Product name, historical years, projected years, % of Total, YoY Growth\n\n#### Table 4: Revenue by Geography (15-20 rows)\n\nUse XLSX skill to:\n1. Open `[Company]_Financial_Model_[Date].xlsx`\n2. Read from `Revenue Model` tab\n3. Navigate to geography section (typically starts ~row 40)\n4. Extract 15-20 rows showing each geographic region\n5. Include columns: Region, historical years, projected years, % of Total, YoY Growth\n\n#### Table 5: Comparable Companies\n**Extract from:** Task 3 valuation tabs in Task 2's financial model (`Comparable Companies` tab)\n\nUse XLSX skill to:\n1. Open `[Company]_Financial_Model_[Date].xlsx`\n2. Read from `Comparable Companies` tab (added by Task 3)\n3. Extract full table with company names as row headers\n4. **CRITICAL**: Verify statistical summary rows are present at bottom:\n   - Maximum\n   - 75th Percentile\n   - Median\n   - 25th Percentile\n   - Minimum\n5. If statistical summary is missing, report ERROR\n\n**Expected format:**\n```\nCompany      Ticker  Mkt Cap  EV/Rev  EV/Rev  EV/EBITDA  EV/EBITDA  P/E   Rev     EBITDA\n                     ($B)     LTM     NTM     LTM        NTM        NTM   Growth  Margin\n[5-10 peers plus target, then statistical summary]\n```\n\n#### Additional Tables (7-15 more)\n**Extract from Task 2 financial model (with Task 3 tabs):**\n\nUse XLSX skill to extract these tables:\n\n**DCF Assumptions Table** (Task 3 `DCF` tab)\n- Open `[Company]_Financial_Model_[Date].xlsx`\n- Read from DCF tab\n- Extract columns A-C (Assumption, Value, Source)\n- Extract first 20 rows\n\n**DCF Sensitivity Matrix** (Task 3 `Sensitivity Analysis` tab)\n- Read from Sensitivity Analysis tab\n- Extract full sensitivity matrix\n- WACC values as row headers\n- Terminal growth rates as column headers\n\n**Scenario Comparison Table** (Task 2 `Scenarios` tab)\n- Read from Scenarios tab\n- Extract full scenario table\n- Metrics as row headers (Revenue, EBITDA, Margins, etc.)\n- Columns: Bull, Base, Bear\n\n**Other supporting tables to extract:**\n- Cash flow statement\n- Balance sheet highlights\n- Key metrics dashboard\n- Margin bridge\n- Working capital schedule\n- TAM sizing table\n- Market share table\n\n**Create all 12-20 tables with proper formatting.**\n\n### Step 3: Write Quantitative Sections\n\nThese sections interpret the financial model.\n\n**Write in this order:**\n\n#### A. Financial Analysis (1,200-1,800 words)\n- Analyze historical performance from model\n- Discuss trends in revenue, margins, cash flow\n- Reference specific charts and tables\n- Lead with numbers\n\n#### B. Projection Assumptions (2,000-3,000 words) ⭐ CRITICAL\n- Follow detailed structure from Report Structure section above\n- Must be product-by-product (8-12 points per product)\n- Must be region-by-region (6-8 points per region)\n- Must include margin, opex, capex, working capital assumptions\n- **This section separates amateur from professional analysis**\n\n#### C. Scenario Analysis (1,500-2,000 words) ⭐ CRITICAL\n- Follow detailed structure from Report Structure section above\n- Bull case: specific parameters, catalysts, probability, valuation\n- Base case: most likely scenario with rationale\n- Bear case: downside triggers and parameters\n- Comparison table and analysis\n- **Must have specific quantified parameters for each scenario**\n\n#### D. Growth Drivers (800-1,200 words)\n- 3-5 key drivers with quantified opportunities\n- Timeline and milestones\n- Evidence from model\n\n#### E. Valuation Methodology (800-1,200 words)\n- DCF explanation with assumptions\n- Comparables rationale\n- Precedent transactions (if applicable)\n- Reconciliation and weighting\n- Price target derivation\n\n### Step 4: Write Synthesis Sections\n\n**Write in this order:**\n\n#### A. Investment Thesis (800-1,200 words)\n- 3-5 key pillars\n- Each pillar: 200-300 words\n- Lead with key statistic\n- Quantify financial impact\n- Include timeline\n\n#### B. Risk Assessment (600-900 words)\n- Pull from Task 1 research document\n- Organize into 4 categories\n- 8-12 risks total\n- Each risk: 50-100 words\n\n#### C. Price Target \u0026 Recommendation (300-500 words)\n- Final recommendation\n- Price target with upside %\n- Key catalysts with timeframes\n- Key risks to target\n\n#### D. Investment Summary (500-700 words) - WRITE LAST\n- Page 1 content\n- 3-4 detailed bullets with bold headers\n- Complete synthesis of all findings\n- **Write this section LAST after full analysis complete**\n\n### Step 5: Integrate Company Content from Task 1\n\n**CRITICAL INSTRUCTION**: Use Task 1 research document almost verbatim. DO NOT rewrite.\n\n**The company research from Task 1 (6-8K words) is already professional, substantive analysis. Objective:**\n1. **Reformat for Word** - Convert markdown to DOCX formatting\n2. **Insert charts inline** - Add relevant charts from Task 4 throughout the text\n3. **Minor style adjustments** - Ensure consistent formatting with rest of report\n\n**Extract these sections from Task 1 research document:**\n- Company description (800-1,200 words) → **Use verbatim, insert company overview charts**\n- Company history (800-1,200 words) → **Use verbatim, insert timeline chart**\n- Management bios (1,000-1,400 words) → **Use verbatim, insert org chart if available**\n- Products \u0026 services (700-1,000 words) → **Use verbatim, insert product portfolio charts**\n- Customers \u0026 GTM (500-700 words) → **Use verbatim, insert customer segmentation charts**\n- Industry overview (800-1,200 words) → **Use verbatim, insert market size evolution charts**\n- Competitive landscape (700-1,000 words) → **Use verbatim, insert competitive positioning charts**\n- TAM analysis (500-700 words) → **Use verbatim, insert TAM sizing charts**\n- Risk assessment (600-900 words) → **Use verbatim, format as Investment Thesis \u0026 Risks section**\n\n**Chart Integration Strategy:**\n- Every 200-300 words of text → Insert 1 chart\n- Company 101 section (pages 6-17) should have 8-12 charts interspersed\n- Place charts immediately after the paragraph that discusses the topic\n- **Result**: Dense, visually rich pages (60-80% coverage)\n\n### Step 6: Assemble DOCX Report\n\n**CRITICAL**: Create actual DOCX file, NOT markdown.\n\n**Assembly Order (Most Efficient):**\n\n#### Phase A: Create Structure \u0026 Add Page 1\n1. Create DOCX document\n2. Set up professional styling (fonts, headers, footers)\n3. Create Page 1 - Investment Summary (write this LAST after all analysis complete)\n4. Add Table of Contents placeholder\n\n#### Phase B: Copy Task 1 Content + Insert Charts\n**This is 40-50% of the report - mostly copy/paste + chart insertion**\n\nUse Claude's DOCX skill to:\n\n1. **Initialize new DOCX document**\n   - Create new Word document\n   - Set professional styling (fonts, margins)\n\n2. **Read Task 1 markdown file**\n   - Use Read tool: `[Company]_Research_Document_[Date].md`\n   - Identify sections by markdown headers (## Section Title)\n\n3. **Extract and convert each section from Task 1 to Word format:**\n\n**SECTION 1: Investment Thesis \u0026 Risks**\n- Add heading: 'Investment Thesis \u0026 Risks' (level 1)\n- Extract 'Risk Assessment' section from Task 1 markdown\n- Convert markdown formatting to Word formatting (remove ##, **, etc.)\n- Add paragraphs to Word document (split by blank lines)\n- Add new 'Investment Thesis' heading (level 2)\n- Write new investment thesis content (800-1,200 words based on all analysis)\n\n**SECTION 2: Company 101 (Pages 6-17)**\nCopy each section from Task 1 verbatim with formatting conversion:\n\n- **Company Overview**\n  - Add heading: 'Company Overview' (level 1)\n  - Extract 'Company Overview' section from Task 1\n  - Convert to Word paragraphs\n  - Insert chart: `task4_charts/chart_05_company_overview.png` (6 inches wide)\n\n- **Company History**\n  - Add heading: 'Company History' (level 1)\n  - Extract 'Company History' section from Task 1\n  - Convert to Word paragraphs\n  - Insert chart: `task4_charts/chart_06_company_timeline.png` (6 inches wide)\n\n- **Management Team**\n  - Add heading: 'Management Team' (level 1)\n  - Extract 'Management Team' section from Task 1\n  - Convert to Word paragraphs\n  - Insert chart: `task4_charts/chart_07_org_structure.png` (5 inches wide)\n\n- **Products \u0026 Services**\n  - Add heading: 'Products \u0026 Services' (level 1)\n  - Extract 'Products \u0026 Services' section from Task 1\n  - Add first paragraph\n  - Insert chart: `task4_charts/chart_08_product_portfolio.png` (6 inches wide)\n  - Add remaining paragraphs\n\n- **Customers \u0026 Go-to-Market**\n  - Add heading: 'Customers \u0026 Go-to-Market' (level 1)\n  - Extract section from Task 1\n  - Convert to Word paragraphs\n  - Insert chart: `task4_charts/chart_09_customer_segments.png` (6 inches wide)\n\n- **Industry Overview**\n  - Add heading: 'Industry Overview' (level 1)\n  - Extract section from Task 1\n  - Add first paragraph\n  - Insert chart: `task4_charts/chart_10_market_size_evolution.png` (6 inches wide)\n  - Add remaining paragraphs\n  - Insert chart: `task4_charts/chart_11_industry_trends.png` (6 inches wide)\n\n- **Competitive Landscape**\n  - Add heading: 'Competitive Landscape' (level 1)\n  - Extract section from Task 1\n  - Add first paragraph\n  - Insert chart: `task4_charts/chart_16_competitive_positioning.png` (6 inches wide)\n  - Add remaining paragraphs\n  - Insert chart: `task4_charts/chart_17_market_share.png` (5 inches wide)\n\n- **Market Opportunity**\n  - Add heading: 'Market Opportunity' (level 1)\n  - Extract 'Market Opportunity' section from Task 1\n  - Convert to Word paragraphs\n  - Insert chart: `task4_charts/chart_15_TAM_sizing.png` (6 inches wide)\n\n**Result after Phase B**: Pages 6-17 complete (~12 pages, 6-8K words, 8-12 charts embedded)\n\n**Key Point**: Use DOCX skill to READ from Task 1's .md file and INSERT actual image files. No manual copy/paste required.\n\n#### Phase C: Add Financial Analysis with Data from Task 2\n**This requires NEW WRITING interpreting quantitative data**\n\nUse Claude's DOCX and XLSX skills to:\n\n**SECTION 3: Financial Analysis (Pages 18-30)**\n\n1. **Add section heading: 'Financial Analysis' (level 1)**\n\n2. **Historical Financial Analysis (1,200-1,800 words) - NEW WRITING**\n   - Add heading: 'Historical Performance' (level 2)\n   - Use XLSX skill to open `[Company]_Financial_Model_[Date].xlsx`\n   - Read `Income Statement` tab to extract historical data\n   - Read `Revenue Model` tab to extract revenue trends\n   - Calculate key metrics (e.g., Revenue CAGR from 2020-2024)\n   - Write analytical paragraphs interpreting the trends (1,200-1,800 words)\n   - Lead with specific numbers: \"Revenue grew from $XXM in 2020 to $XXM in 2024, representing a XX% CAGR. This growth was driven by...\"\n   - Insert chart: `task4_charts/chart_02_revenue_growth_trajectory.png` (6 inches wide)\n\n3. **Create Table: Full Income Statement**\n   - Add heading: 'Historical Income Statement' (level 3)\n   - Use XLSX skill to extract entire Income Statement tab (40-50 rows)\n   - Create Word table with all columns (historical years 2020A-2024A + projected 2025E-2029E)\n   - Include all line items: Revenue, COGS, Gross Profit, Operating Expenses, EBITDA, Net Income, etc.\n\n4. **Add mandatory charts and tables for Revenue breakdown:**\n   - Insert chart: `task4_charts/chart_03_revenue_by_product.png` (6.5 inches wide) ⭐ MANDATORY\n   - **Create Table: Revenue by Product (20-30 rows)**\n     - Use XLSX skill to extract from Revenue Model tab (product section, typically rows 5-35)\n     - Create Word table showing each product category with historical and projected years\n     - Include columns: Product name, historical years, projected years, % of Total, YoY Growth\n\n   - Insert chart: `task4_charts/chart_04_revenue_by_geography.png` (6.5 inches wide) ⭐ MANDATORY\n   - **Create Table: Revenue by Geography (15-20 rows)**\n     - Use XLSX skill to extract from Revenue Model tab (geography section, typically rows 40-60)\n     - Create Word table showing each geographic region with historical and projected years\n\n5. **Add additional financial charts:**\n   - Insert chart: `task4_charts/chart_10_gross_margin_evolution.png` (6 inches wide)\n   - Insert chart: `task4_charts/chart_11_ebitda_margin_progression.png` (6 inches wide)\n   - Insert chart: `task4_charts/chart_12_free_cash_flow_trend.png` (6 inches wide)\n\n6. **Projection Assumptions (2,000-3,000 words) ⭐ CRITICAL - NEW WRITING**\n   - Add heading: 'Projection Assumptions' (level 2)\n   - Use XLSX skill to read Scenarios tab to inform assumptions\n   - Use XLSX skill to read Revenue Model tab for specific product/geography projections\n   - Add heading: 'Revenue Assumptions by Product' (level 3)\n   - Write detailed product-by-product assumptions (8-12 points per major product)\n   - Write detailed region-by-region assumptions (6-8 points per major region)\n   - Include margin, opex, capex, working capital assumptions\n   - **Total: 2,000-3,000 words of specific, quantified assumptions**\n\n7. **Scenario Analysis (1,500-2,000 words) ⭐ CRITICAL - NEW WRITING**\n   - Add heading: 'Scenario Analysis' (level 2)\n   - Use XLSX skill to extract scenario data from Scenarios tab\n   - Extract Bull/Base/Bear parameters for key metrics (2029E Revenue, EBITDA Margin, etc.)\n   - Write Bull Case (500-700 words): specific parameters, catalysts, probability, valuation\n   - Write Base Case (300-500 words): most likely scenario with rationale\n   - Write Bear Case (500-700 words): downside triggers, parameters, probability, valuation\n   - Write Scenario Comparison (200-300 words)\n   - Insert chart: `task4_charts/chart_14_scenario_comparison.png` (6 inches wide)\n   - **Create Table: Scenario Comparison**\n     - Use XLSX skill to extract from Scenarios tab\n     - Create Word table with Bull/Base/Bear columns and key metrics as rows\n\n8. **Growth Drivers (800-1,200 words) - NEW WRITING**\n   - Add heading: 'Key Growth Drivers' (level 2)\n   - Write 3-5 key drivers with specific quantified opportunities\n   - Include timelines and milestones\n   - Reference specific data from financial model\n\n**Result after Phase C**: Pages 18-30 complete (~13 pages, 5-7K words, 7-8 charts, 6-8 tables)\n\n**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.\n\n#### Phase D: Add Valuation Analysis from Task 3\n**Mix of copying Task 3 analysis + inserting data from Excel**\n\nUse Claude's DOCX and XLSX skills to:\n\n**SECTION 4: Valuation Analysis (Pages 31-40)**\n\n1. **Add section heading: 'Valuation Analysis' (level 1)**\n\n2. **Read Task 3 markdown file**\n   - Use Read tool: `[Company]_Valuation_Analysis_[Date].md`\n   - Identify sections by markdown headers: DCF Analysis, Comparable Companies, Price Target\n\n3. **DCF Analysis section**\n   - Add heading: 'DCF Analysis' (level 2)\n   - Extract 'DCF Analysis' section from Task 3 markdown\n   - Convert markdown to Word paragraphs\n   - Insert chart: `task4_charts/chart_28_dcf_sensitivity_heatmap.png` (6 inches wide) ⭐ MANDATORY\n\n   - **Create Table: DCF Key Assumptions**\n     - Add heading: 'DCF Key Assumptions' (level 3)\n     - Use XLSX skill to open `[Company]_Financial_Model_[Date].xlsx`\n     - Read DCF tab (columns A-C, first 20 rows: Assumption, Value, Source)\n     - Create Word table from extracted data\n\n   - **Create Table: DCF Sensitivity Matrix**\n     - Use XLSX skill to read Sensitivity Analysis tab\n     - Extract full sensitivity matrix (WACC values as rows, terminal growth as columns)\n     - Create Word table showing valuation at different parameter combinations\n\n   - Insert chart: `task4_charts/chart_29_dcf_waterfall.png` (6 inches wide)\n\n4. **Comparable Companies section**\n   - Add heading: 'Comparable Companies Analysis' (level 2)\n   - Extract 'Comparable Companies' section from Task 3 markdown\n   - Convert markdown to Word paragraphs\n\n   - **Create Table: Comparable Companies ⭐ CRITICAL**\n     - Add heading: 'Comparable Companies' (level 3)\n     - Use XLSX skill to read Comparable Companies tab\n     - Extract full table including:\n       - 5-10 peer companies plus target company\n       - Statistical summary rows (Maximum, 75th Percentile, Median, 25th Percentile, Minimum)\n     - Create Word table with all columns: Ticker, Market Cap, EV/Revenue (LTM \u0026 NTM), EV/EBITDA (LTM \u0026 NTM), P/E (NTM), Revenue Growth, EBITDA Margin\n     - **Verify statistical summary is included in table**\n\n   - Insert chart: `task4_charts/chart_31_peer_multiples_comparison.png` (6 inches wide)\n\n5. **Valuation Summary**\n   - Insert chart: `task4_charts/chart_32_valuation_football_field.png` (6.5 inches wide) ⭐ MANDATORY\n\n   - **Create Table: Valuation Summary**\n     - Use XLSX skill to read Valuation Summary tab\n     - Extract valuation methods (DCF, Comps, Precedent Transactions if applicable)\n     - Create Word table showing: Method, Low Case, Base Case, High Case, Weight, Weighted Value\n\n6. **Price Target \u0026 Recommendation**\n   - Add heading: 'Price Target and Recommendation' (level 2)\n   - Extract 'Price Target' section from Task 3 markdown\n   - Convert markdown to Word paragraphs\n   - Should include: Final recommendation (BUY/HOLD/SELL), price target with % upside, key catalysts, key risks\n\n**Result after Phase D**: Pages 31-40 complete (~10 pages, 3-4K words, 5-6 charts, 4-5 tables)\n\n**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.\n\n#### Phase E: Add Appendices \u0026 Finalize\n\nUse Claude's DOCX skill to:\n\n**SECTION 5: Appendices (Pages 41-50)**\n\n1. **Data Sources \u0026 References**\n   - Add heading: 'Data Sources \u0026 References' (level 1)\n   - List all sources used throughout the report\n   - Organize by category:\n     - SEC Filings (10-K, 10-Q, DEF 14A, 8-K with EDGAR links)\n     - Earnings Calls (with transcript links)\n     - Company Materials (investor presentations, press releases)\n     - Industry Reports (Gartner, Forrester, etc.)\n     - News Articles\n   - **CRITICAL**: All URLs must be clickable hyperlinks (not plain text)\n   - Include dates for all sources\n\n2. **Additional Tables**\n   - Add heading: 'Additional Tables' (level 1)\n   - Add extended financial projections\n   - Add detailed assumptions tables\n   - Add any supporting tables that didn't fit in main sections\n\n#### Phase F: Write Page 1 Investment Summary\n**NOW write Page 1 - after all analysis complete**\n- INITIATING COVERAGE header\n- Rating box\n- 3-4 detailed bullets synthesizing entire report\n- Financial summary table\n- Stock price chart\n\n#### Phase G: Add Table of Contents \u0026 Page Numbers\n- Auto-generate TOC\n- Add page numbers to all pages\n\n**Key formatting requirements:**\n- Professional fonts (Calibri, Arial, or similar)\n- Proper headers and footers with page numbers\n- Section breaks between major sections\n- Embed all 25-35 charts inline throughout text\n- Insert all 12-20 tables inline with text\n- **All URLs as clickable hyperlinks** (NOT plain text)\n- **60-80% page density** - Every page has text AND visuals\n\n**Visual Density Strategy:**\n```\nGood page layout example:\n┌─────────────────────────────┐\n│ Section Header              │\n│ Text paragraph (200 words)  │\n│ [Chart embedded]            │\n│ Text paragraph (200 words)  │\n│ [Table embedded]            │\n│ Text paragraph (200 words)  │\n│ [Chart embedded]            │\n└─────────────────────────────┘\n\nBAD - Avoid:\n- Full page with only one chart\n- Multiple pages of pure text\n- Charts grouped at end of sections\n```\n\n**Result**: 30-50 page report that is text-dense with illustrating images throughout\n\n---\n\n## File Operations Summary\n\n**Throughout the entire assembly process, use Claude's DOCX and XLSX skills with actual file operations:**\n\n**Reading Input Files:**\n- ✓ Use Read tool: `[Company]_Research_Document_[Date].md` - Read Task 1 research\n- ✓ Use XLSX skill: Open `[Company]_Financial_Model_[Date].xlsx` and read tabs - Extract tables from Task 2/3\n- ✓ Use Read tool: `[Company]_Valuation_Analysis_[Date].md` - Read Task 3 analysis\n- ✓ Use DOCX skill: Insert images from `task4_charts/chart_XX.png` files\n\n**Writing Output File:**\n- ✓ Use DOCX skill: Create new Word document\n- ✓ Use DOCX skill: Add paragraphs (text from input .md files)\n- ✓ Use DOCX skill: Create tables (data from Excel files read via XLSX skill)\n- ✓ Use DOCX skill: Insert images (chart .png files)\n- ✓ Use DOCX skill: Save final file as `[Company]_Initiation_Report_[Date].docx`\n\n**Do NOT manually copy/paste. Use Claude's built-in skills to:**\n1. Read from .md files (Task 1, Task 3) using Read tool\n2. Read from .xlsx files (Task 2 with Task 3 tabs) using XLSX skill\n3. Read from .png files (Task 4) as image files\n4. Write to .docx file (Task 5 output) using DOCX skill\n\nThis approach is efficient, reproducible, and ensures all data flows correctly from source files to final report.\n\n### Step 7: Quality Check\n\n**Run comprehensive verification:**\n\n```\n═══════════════════════════════════════════════════════════\nREPORT QUALITY CHECKLIST\n═══════════════════════════════════════════════════════════\n\nLENGTH REQUIREMENTS:\n- [ ] Report is 30-50 pages (count: ____ pages)\n- [ ] Word count is 10,000-15,000 (count: ____ words)\n- [ ] 25-35 charts embedded (count: ____ charts)\n- [ ] 12-20 tables included (count: ____ tables)\n\nPAGE 1 FORMAT:\n- [ ] \"INITIATING COVERAGE\" header present\n- [ ] Thesis-focused title (not generic)\n- [ ] Rating box complete with all elements\n- [ ] Stock price chart (Figure 1) embedded\n- [ ] 3-4 detailed bullets with ■ character\n- [ ] Each bullet has **bold header** + 3-5 sentences\n- [ ] Financial summary table included\n- [ ] Years noted as \"A\" (actual) and \"E\" (estimate)\n\nSECTION WORD COUNTS:\n- [ ] Investment Thesis: 800-1,200 words ✓\n- [ ] Risk Assessment: 600-900 words ✓\n- [ ] Company Description: 800-1,200 words ✓\n- [ ] Management Bios: 1,000-1,400 words (300-400 per exec for 3-4 execs) ✓\n- [ ] Products \u0026 Services: 700-1,000 words ✓\n- [ ] Financial Analysis: 1,200-1,800 words ✓\n- [ ] **Projection Assumptions: 2,000-3,000 words ✓** ⭐ CRITICAL\n- [ ] **Scenario Analysis: 1,500-2,000 words ✓** ⭐ CRITICAL\n- [ ] Growth Drivers: 800-1,200 words ✓\n- [ ] Valuation Methodology: 800-1,200 words ✓\n\nMANDATORY CHARTS (4 TOTAL):\n- [ ] Revenue by Product (stacked area) embedded ⭐\n- [ ] Revenue by Geography (stacked bar) embedded ⭐\n- [ ] DCF Sensitivity (heatmap) embedded ⭐\n- [ ] Valuation Football Field embedded ⭐\n\nMANDATORY TABLES:\n- [ ] Page 1 financial summary table\n- [ ] Full income statement (40-50 line items)\n- [ ] Revenue by product table (20-30 rows)\n- [ ] Revenue by geography table (15-20 rows)\n- [ ] Comparable companies table with statistical summary ⭐\n- [ ] DCF assumptions table\n- [ ] Scenario comparison table\n- [ ] Additional 5-13 tables\n\nCITATIONS \u0026 HYPERLINKS:\n- [ ] All figures have source lines\n- [ ] All tables have source lines\n- [ ] All URLs are clickable hyperlinks (NOT plain text)\n- [ ] Test 5-10 random hyperlinks to verify they work\n- [ ] Data Sources \u0026 References page included\n- [ ] All sources have dates\n\nDATA ACCURACY:\n- [ ] All numbers match financial model exactly\n- [ ] Revenue figures consistent across all tables/text\n- [ ] Price target matches valuation analysis\n- [ ] All growth rates calculated correctly\n- [ ] All percentages sum to 100% where applicable\n\nCONTENT REUSE (CRITICAL):\n- [ ] Task 1 content used almost verbatim (not rewritten)\n- [ ] Company 101 sections (pages 6-17) copied from Task 1 with only formatting changes\n- [ ] Writing effort focused on quantitative sections (financial analysis, projections, scenarios)\n\nVISUAL DENSITY (CRITICAL):\n- [ ] Every page has BOTH text AND visuals (not pure text pages)\n- [ ] Charts interspersed throughout (not grouped at end)\n- [ ] Average 1+ chart per page (30-50 pages = 25-35+ charts)\n- [ ] Charts appear every 200-300 words of text\n- [ ] 60-80% page density achieved across entire report\n\nFORMATTING:\n- [ ] No markdown syntax visible (no #, ##, **, etc.)\n- [ ] Professional fonts throughout\n- [ ] Headers and footers present\n- [ ] Page numbers present\n- [ ] Section breaks appropriate\n- [ ] Charts embedded (not just file paths)\n- [ ] Tables formatted professionally\n\nWRITING QUALITY:\n- [ ] Lead with numbers (not generic statements)\n- [ ] Use \"vs.\" not \"versus\"\n- [ ] Quantify everything\n- [ ] Professional tone throughout\n- [ ] No typos or grammatical errors\n- [ ] Specific examples (not vague statements)\n\n═══════════════════════════════════════════════════════════\nFINAL VERIFICATION\n═══════════════════════════════════════════════════════════\n\nIF ALL ITEMS CHECKED: ✓ READY FOR DELIVERY\n\nIF ANY ITEMS UNCHECKED: ✗ FIX BEFORE DELIVERY\n\n═══════════════════════════════════════════════════════════\n```\n\n**IF ANY ITEM FAILS, DO NOT DELIVER. Fix before proceeding.**\n\n---\n\n## Writing Style Guidelines\n\n### Lead with Numbers (CRITICAL)\n\n✓ **CORRECT**: \"Revenue increased 150% YoY to $250M in Q4 2024, driven by...\"\n✗ **INCORRECT**: \"The company saw strong revenue growth this quarter...\"\n\n✓ **CORRECT**: \"EBITDA margin expanded 500bps to 30% vs. 25% in FY2023\"\n✗ **INCORRECT**: \"EBITDA margin expanded versus the prior year\"\n\n✓ **CORRECT**: \"Market share increased 3 percentage points to 18% vs. 15% in 2023\"\n✗ **INCORRECT**: \"Market share increased compared to last year\"\n\n✓ **CORRECT**: \"Management expects 40-50% revenue growth in FY2025E\"\n✗ **INCORRECT**: \"Management expects strong revenue growth\"\n\n### Professional Writing Standards\n\n- **Front-load**: Most important information first\n- **Data-driven**: Lead with numbers and metrics\n- **Specific**: Concrete examples, not generic statements\n- **Objective**: Present facts, acknowledge risks\n- **Confident**: State views clearly with supporting evidence\n- **Active voice**: \"We estimate revenue will reach $500M\"\n- **Precise**: Avoid \"might\", \"could\", \"possibly\"\n\n### Number Formatting\n\n**Consistency:**\n- Billions: $X.XB (e.g., \"$2.5B\")\n- Millions: $XXXM (e.g., \"$250M\")\n- Always specify: YoY, QoQ, CAGR\n- Basis points for small margin changes: \"500bps\"\n- Year format: \"2024A\" (actual), \"2025E\" (estimate)\n\n### Use \"vs.\" not \"versus\"\n✓ **CORRECT**: \"Gross margin of 65% vs. 60% in prior year\"\n✗ **INCORRECT**: \"Gross margin of 65% versus 60%\"\n\n---\n\n## Common Pitfalls to Avoid\n\n**⚠️ MOST COMMON MISTAKE: TAKING SHORTCUTS DUE TO LENGTH**\n\nMany 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.\n\n1. **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).\n2. **Sparse pages**: Every page must have BOTH text AND visuals. Target 60-80% page density. Insert charts every 200-300 words.\n3. **Grouping charts at end**: Charts must be interspersed throughout text, not grouped. Place chart immediately after paragraph discussing that topic.\n4. **Writing in markdown**: Use DOCX format, NOT markdown\n5. **Skipping Page 1 format**: Must follow exact institutional format\n6. **Generic bullets**: Page 1 bullets need bold headers + specific data\n7. **Short sections**: Must meet minimum word counts\n8. **Thin assumptions**: Projection Assumptions MUST be 2,000-3,000 words with product-by-product and region-by-region detail\n9. **Vague scenarios**: Must have specific parameters for Bull/Base/Bear\n10. **Plain text URLs**: All citations must be clickable hyperlinks\n11. **Missing statistical summary**: Comps table must have max/75th/median/25th/min\n12. **Charts not embedded**: All 25-35 charts must be IN document, not just referenced\n13. **Numbers don't match model**: Verify all figures against source\n14. **Skipping verification**: Quality check is NOT optional\n\n---\n\n## Success Criteria\n\nA successful equity research report should:\n\n1. **Meet all length requirements**\n   - 30-50 pages (MINIMUM 30)\n   - 10,000-15,000 words (MINIMUM 10,000)\n   - 25-35 charts embedded\n   - 12-20 tables included\n\n2. **Have properly formatted Page 1**\n   - \"INITIATING COVERAGE\" header\n   - Rating box, analyst info, chart, bullets, table\n\n3. **Meet all section word count minimums**\n   - Especially Projection Assumptions (2,000-3,000) ⭐\n   - And Scenario Analysis (1,500-2,000) ⭐\n\n4. **Include all 4 mandatory charts**\n   - Revenue by product (stacked area) ⭐\n   - Revenue by geography (stacked bar) ⭐\n   - DCF sensitivity (heatmap) ⭐\n   - Valuation football field ⭐\n\n5. **Have management bios**\n   - 300-400 words each for 3-4 key executives\n\n6. **Include comprehensive comps table**\n   - With statistical summary (max/75th/median/25th/min)\n\n7. **Have all citations as clickable hyperlinks**\n   - Test multiple links to verify they work\n\n8. **Be professionally formatted**\n   - 60-80% page density\n   - No markdown syntax visible\n   - Charts and tables embedded properly\n\n9. **Have numbers matching model exactly**\n   - Verify all figures against Excel model\n\n10. **Enable informed investment decision**\n    - Client should understand company, valuation, risks\n    - Should be indistinguishable from JPM/GS/MS research\n\n---\n\n## Output Files\n\n**Primary Deliverable:**\n`[Company]_Initiation_Report_[Date].docx`\n\n**Example**: `Tesla_Initiation_Report_2024-10-27.docx`\n\n**Supporting Deliverable:**\n`[Company]_Financial_Model_[Date].xlsx` (from Task 2)\n\n**Both files should be packaged together for final delivery.**\n\n---\n\n## Final Note\n\nThis is the culmination of all equity research work from Tasks 1-4. The output should be:\n- **Comprehensive**: 30-50 pages covering all aspects\n- **Professional**: Indistinguishable from major investment bank research\n- **Actionable**: Enables reader to make informed investment decision\n- **Publication-ready**: Can be delivered directly to clients\n\n**Standard**: JPMorgan, Goldman Sachs, Morgan Stanley institutional equity research.\n\n**Quality bar**: Client-ready initiation report suitable for publication.\n\n---\n\n## 🔥 FINAL REMINDER: NO SHORTCUTS, NO COMPROMISES\n\n**Use whatever tokens are needed to deliver a complete, professional report.**\n\nThis is not a draft. This is not a summary. This is not an outline. This is the **FINAL PUBLICATION-READY REPORT**.\n\n- Write every section in full (10,000-15,000 words minimum)\n- Embed every chart (all 25-35 charts throughout)\n- Extract and include every table (12-20 tables minimum)\n- Copy all Company 101 content from Task 1 verbatim (6-8K words)\n- Write detailed projection assumptions (2,000-3,000 words)\n- Write comprehensive scenario analysis (1,500-2,000 words)\n- Achieve 30-50 pages minimum with 60-80% page density\n\n**If running low on tokens, that's expected and acceptable for this task. Keep going.**\n\nThis represents the complete professional work product. Deliver institutional-quality research worthy of a $1M+ investment decision.\n","references/valuation-methodologies.md":"# Valuation Methodologies for Equity Research\n\nThis reference document provides comprehensive guidance on the three primary valuation methodologies used in equity research: Discounted Cash Flow (DCF), Trading Comparables, and Precedent Transactions.\n\n## Table of Contents\n\n1. [Discounted Cash Flow (DCF) Analysis](#discounted-cash-flow-dcf-analysis)\n2. [Trading Comparables Analysis](#trading-comparables-analysis)\n3. [Precedent Transactions Analysis](#precedent-transactions-analysis)\n4. [Valuation Reconciliation](#valuation-reconciliation)\n\n---\n\n## Discounted Cash Flow (DCF) Analysis\n\n### Overview\n\nDCF 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.\n\n### Step-by-Step DCF Process\n\n#### 1. Historical Financial Analysis\n- Collect 3-5 years of historical financials\n- Calculate historical FCF = EBIT(1-Tax Rate) + D\u0026A - CapEx - Change in NWC\n- Analyze historical growth rates and margins\n- Identify trends and cyclicality\n\n#### 2. Build Revenue Projections (5-10 years)\n**Approaches:**\n- **Top-down**: Start with market size (TAM) → Market share → Revenue\n- **Bottom-up**: Units sold × Price per unit\n- **Hybrid**: Combine multiple drivers\n\n**Key Considerations:**\n- Management guidance and historical growth\n- Industry growth rates and market trends\n- Competitive dynamics and market share evolution\n- Product pipeline and new market opportunities\n- Macroeconomic factors\n\n#### 3. Project Operating Expenses\n- **COGS**: As % of revenue (analyze historical margins)\n- **SG\u0026A**: Often semi-fixed; model as % of revenue with scale effects\n- **R\u0026D**: Critical for tech/pharma; model as % of revenue\n- **D\u0026A**: Based on CapEx assumptions\n\n**Calculate EBIT** = Revenue - COGS - Operating Expenses\n\n#### 4. Calculate Unlevered Free Cash Flow\n```\nEBIT\n× (1 - Tax Rate)\n= NOPAT (Net Operating Profit After Tax)\n+ Depreciation \u0026 Amortization\n- Capital Expenditures\n- Increase in Net Working Capital\n= Unlevered Free Cash Flow (UFCF)\n```\n\n**CapEx Assumptions:**\n- Maintenance CapEx: Required to maintain current operations (typically 2-4% of revenue)\n- Growth CapEx: Required for expansion\n- Consider industry benchmarks and company guidance\n\n**Net Working Capital:**\n- NWC = (Accounts Receivable + Inventory) - Accounts Payable\n- Model as % of revenue or days (DSO, DIO, DPO)\n- An increase in NWC is a use of cash\n\n#### 5. Determine Terminal Value\n\n**Method A: Perpetuity Growth Method**\n```\nTerminal Value = FCF(final year) × (1 + g) / (WACC - g)\n```\n- g = perpetual growth rate (typically 2-3%, not exceeding GDP growth)\n- Use when company has reached stable, mature growth\n\n**Method B: Exit Multiple Method**\n```\nTerminal Value = EBITDA(final year) × Exit Multiple\n```\n- Exit multiple based on current trading comps\n- More appropriate for cyclical businesses\n\n#### 6. Calculate Weighted Average Cost of Capital (WACC)\n\n```\nWACC = (E/V × Cost of Equity) + (D/V × Cost of Debt × (1 - Tax Rate))\n```\n\n**Cost of Equity (using CAPM):**\n```\nCost of Equity = Risk-Free Rate + Beta × Equity Risk Premium\n```\n- Risk-Free Rate: 10-year Treasury yield\n- Beta: Regression of stock returns vs. market (or use comparable beta)\n- Equity Risk Premium: Historical average ~5-6%\n\n**Cost of Debt:**\n```\nCost of Debt = Risk-Free Rate + Credit Spread\n```\n- Use company's current borrowing rate or implied from bonds\n- Adjust for credit rating if no bonds outstanding\n\n**Capital Structure:**\n- E/V = Market value of equity / Total value\n- D/V = Market value of debt / Total value\n- Use target capital structure, not current (if significantly different)\n\n#### 7. Discount Cash Flows to Present Value\n\n```\nPV = Σ [FCFt / (1 + WACC)^t] + [Terminal Value / (1 + WACC)^n]\n```\n\n#### 8. Calculate Enterprise Value and Equity Value\n\n```\nEnterprise Value = PV of Projected FCF + PV of Terminal Value\nLess: Net Debt (Total Debt - Cash)\nPlus: Non-operating Assets\nLess: Minority Interest\nLess: Preferred Stock\n= Equity Value\n\nPrice Per Share = Equity Value / Diluted Shares Outstanding\n```\n\n### DCF Sensitivity Analysis\n\nAlways perform sensitivity analysis on key variables:\n\n1. **Two-way sensitivity table**: WACC vs. Terminal Growth Rate\n2. **Revenue growth scenarios**: Base / Bull / Bear cases\n3. **Margin assumptions**: Operating leverage scenarios\n4. **Terminal multiple sensitivity**: If using exit multiple method\n\n**Example Sensitivity Table:**\n```\n           Terminal Growth Rate\nWACC      2.0%    2.5%    3.0%\n8.0%      $45     $48     $52\n9.0%      $40     $43     $46\n10.0%     $36     $39     $41\n```\n\n### Common DCF Pitfalls to Avoid\n\n1. **Double-counting growth**: Don't project high growth without corresponding investment (CapEx, NWC)\n2. **Unrealistic terminal growth**: Should not exceed long-term GDP growth\n3. **Ignoring cyclicality**: Normalize earnings for cyclical businesses\n4. **Wrong cash flow definition**: Use unlevered FCF, not net income\n5. **Inconsistent assumptions**: Match discount rate to cash flows (unlevered FCF → WACC)\n\n---\n\n## Trading Comparables Analysis\n\n### Overview\n\nTrading comps values a company based on how similar companies are valued in the public markets. This reflects current market sentiment and relative valuation.\n\n### Step-by-Step Comps Process\n\n#### 1. Select Comparable Companies\n\n**Selection Criteria:**\n- Same industry/sector (primary criterion)\n- Similar business model and revenue streams\n- Comparable size (market cap, revenue)\n- Similar growth profile and margins\n- Similar end markets and geographies\n\n**Typical Universe:**\n- Start with 8-15 companies\n- Remove companies with unique circumstances\n- Final set of 5-10 companies\n\n#### 2. Gather Financial Information\n\n**Required Data:**\n- Current stock price and shares outstanding\n- Latest fiscal year financial statements\n- Next-year (NTM) estimates from consensus\n- Historical growth rates\n\n**Calculate Market Metrics:**\n- Market Cap = Share Price × Shares Outstanding\n- Enterprise Value = Market Cap + Debt + Minority Interest + Preferred - Cash\n- Net Debt = Total Debt - Cash \u0026 Equivalents\n\n#### 3. Calculate Valuation Multiples\n\n**Enterprise Value Multiples:**\n- **EV/Revenue**: Good for early-stage/high-growth companies\n- **EV/EBITDA**: Most common; good for capital-intensive businesses\n- **EV/EBIT**: Useful when D\u0026A varies significantly\n\n**Equity Value Multiples:**\n- **P/E (Price/Earnings)**: Most widely used\n- **P/B (Price/Book)**: Good for financial institutions\n- **P/S (Price/Sales)**: For unprofitable companies\n\n**Calculate for:**\n- Last Twelve Months (LTM) - historical\n- Next Twelve Months (NTM) - forward-looking (preferred)\n\n#### 4. Analyze and Select Multiples\n\n**Create Comparable Company Table:**\n\n| Company | Market Cap | EV/Revenue | EV/EBITDA | EV/EBIT | P/E (NTM) | Revenue Growth | EBITDA Margin |\n|---------|-----------|------------|-----------|---------|-----------|----------------|---------------|\n| Comp A  | $10B      | 3.5x       | 12.0x     | 18.0x   | 22.0x     | 15%            | 28%           |\n| Comp B  | $8B       | 3.0x       | 10.5x     | 16.0x   | 19.0x     | 12%            | 27%           |\n| ...     | ...       | ...        | ...       | ...     | ...       | ...            | ...           |\n| Median  | -         | **3.2x**   | **11.0x** | **17.0x** | **20.5x** | 13%            | 27.5%         |\n\n**Adjustments:**\n- Remove outliers (typically \u003e2 standard deviations)\n- Consider using median instead of mean (less affected by outliers)\n- Weight multiples if some comps are more comparable\n- Adjust for differences in growth, margins, risk\n\n#### 5. Apply Multiples to Target Company\n\n**Example Calculation:**\n```\nTarget Company NTM EBITDA = $500M\nSelected EV/EBITDA Multiple = 11.0x\nImplied Enterprise Value = $500M × 11.0x = $5,500M\n\nLess: Net Debt = $1,000M\nEquity Value = $4,500M\n\nShares Outstanding = 100M\nImplied Price Per Share = $45.00\n```\n\n#### 6. Select Appropriate Multiple\n\n**Choose based on:**\n- **EV/Revenue**: High-growth, unprofitable companies (tech, biotech pre-profit)\n- **EV/EBITDA**: Most common; capital-intensive industries (manufacturing, telecom)\n- **P/E**: Profitable companies with stable cap structure (consumer, retail)\n- **Sector-specific**: P/B for banks, EV/Production for oil \u0026 gas, EV/Subscriber for media\n\n### Premium/Discount Analysis\n\nApply premiums or discounts based on:\n- **Growth premium**: Higher growth → higher multiple\n- **Profitability**: Higher margins → higher multiple\n- **Size**: Larger companies typically trade at premium (liquidity)\n- **Market position**: Market leaders → premium\n- **Geographic**: Developed vs. emerging markets\n\n---\n\n## Precedent Transactions Analysis\n\n### Overview\n\nPrecedent transactions values a company based on prices paid for similar companies in M\u0026A transactions. This reflects control premiums and strategic value.\n\n### Step-by-Step Process\n\n#### 1. Identify Relevant Transactions\n\n**Selection Criteria:**\n- Same or similar industry\n- Similar size (within 0.5x to 2x target's size)\n- Similar business characteristics\n- Recent transactions (last 3-5 years preferred)\n- Announced and closed deals (avoid withdrawn deals)\n\n**Typical Universe:**\n- 5-10 transactions minimum\n- Focus on recent deals (weight more recent higher)\n\n#### 2. Gather Transaction Details\n\n**Required Information:**\n- Transaction date (announcement and close)\n- Acquisition price and structure (cash, stock, mixed)\n- Target's financials at time of transaction\n- Strategic rationale and synergies\n- Control premium paid\n\n**Sources:**\n- SEC filings (S-4, 8-K, proxy statements)\n- Press releases and investor presentations\n- M\u0026A databases (CapIQ, FactSet, Bloomberg)\n\n#### 3. Calculate Transaction Multiples\n\n**Same multiples as trading comps, but based on transaction value:**\n\n```\nTransaction Value = Equity Purchase Price + Assumed Debt - Cash Acquired\n\nEV/Revenue (LTM) = Transaction Value / Target's LTM Revenue\nEV/EBITDA (LTM) = Transaction Value / Target's LTM EBITDA\nEV/EBIT (LTM) = Transaction Value / Target's LTM EBIT\n```\n\n**Calculate Control Premium:**\n```\nControl Premium = (Offer Price - Unaffected Price) / Unaffected Price\n```\n- Unaffected Price = Target's stock price 1-2 days before announcement\n- Typical range: 20-40%\n\n#### 4. Analyze Precedent Transactions\n\n**Create Precedent Transactions Table:**\n\n| Date | Target | Acquirer | Deal Value | EV/Revenue | EV/EBITDA | Premium | Rationale |\n|------|--------|----------|------------|------------|-----------|---------|-----------|\n| Q1'24 | CompX | BuyerA | $5.0B | 4.0x | 14.0x | 35% | Market consolidation |\n| Q3'23 | CompY | BuyerB | $3.5B | 3.5x | 12.5x | 28% | Strategic fit |\n| Median | - | - | - | **3.8x** | **13.0x** | **31%** | - |\n\n#### 5. Apply to Target Company\n\n**Important Considerations:**\n- Precedent multiples typically higher than trading comps (include control premium)\n- Adjust for differences in transaction rationale\n- Consider market conditions at time of transactions vs. current\n- Weight recent transactions more heavily\n\n**Example Calculation:**\n```\nTarget Company LTM EBITDA = $450M\nSelected EV/EBITDA Multiple = 13.0x (precedent)\nvs Trading Comps Multiple = 11.0x\n\nImplied EV (Precedent) = $450M × 13.0x = $5,850M\nImplied EV (Trading) = $450M × 11.0x = $4,950M\n\nImplied Control Premium = $5,850M / $4,950M - 1 = 18%\n```\n\n### Adjustments to Transaction Multiples\n\n**Consider adjusting for:**\n- **Market conditions**: Bull vs. bear market (M\u0026A activity levels)\n- **Deal structure**: Strategic vs. financial buyer\n- **Synergies**: Transactions with high synergies command premiums\n- **Competitive dynamics**: Single vs. multiple bidders\n- **Time value**: Older transactions less relevant\n\n---\n\n## Valuation Reconciliation\n\n### Creating a Valuation Bridge\n\nPresent all three methods in a single framework:\n\n**Example Valuation Summary:**\n\n| Method | Enterprise Value | Equity Value | Price/Share | Weight | Implied Value |\n|--------|------------------|--------------|-------------|--------|---------------|\n| DCF Analysis | $5,200M | $4,200M | $42.00 | 50% | $21.00 |\n| Trading Comps | $5,500M | $4,500M | $45.00 | 30% | $13.50 |\n| Precedent Trans. | $5,850M | $4,850M | $48.50 | 20% | $9.70 |\n| **Weighted Avg** | - | - | **$44.20** | - | **$44.20** |\n\n### Weighting the Methods\n\n**Typical Weighting:**\n- **DCF**: 40-60% (fundamental value, but assumes accuracy of projections)\n- **Trading Comps**: 25-40% (reflects current market sentiment)\n- **Precedent Trans.**: 15-25% (less relevant unless M\u0026A likely)\n\n**Adjust weights based on:**\n- **Confidence in forecasts**: Higher confidence → higher DCF weight\n- **Market conditions**: Bull/bear market affects comps reliability\n- **M\u0026A likelihood**: Higher if company in play or industry consolidating\n- **Company maturity**: Mature companies → higher weight on comps; growth → higher DCF weight\n\n### Valuation Range\n\nAlways present a valuation range, not a point estimate:\n\n**Approach:**\n- **Base Case**: Most likely scenario\n- **Bull Case**: Optimistic assumptions (revenue growth, margins)\n- **Bear Case**: Conservative assumptions\n\n**Example:**\n```\nBear Case: $38 - $40\nBase Case: $42 - $46\nBull Case: $48 - $52\n\nRecommendation: BUY with target price of $45 (midpoint of base case)\n```\n\n### Sanity Checks\n\n**Cross-check valuation with:**\n1. **Historical multiples**: Is current valuation in line with history?\n2. **Peer comparison**: Justified premium/discount vs. peers?\n3. **Implied growth**: What growth is market pricing in?\n4. **Implied returns**: IRR from current price to target price\n5. **Market cap analysis**: Does total market cap make sense?\n\n---\n\n## Conclusion\n\nUsing all three valuation methods provides a robust framework for determining fair value:\n\n- **DCF** provides intrinsic value based on fundamentals\n- **Trading Comps** reflects current market valuation\n- **Precedent Transactions** indicates M\u0026A value and control premium\n\nThe key is to understand the assumptions driving each method and to present a well-reasoned valuation range that considers multiple scenarios and methodologies.\n"},"import":{"commit_sha":"9affc6e683bbaf66361058117027cf5a50bf1861","imported_at":"2026-05-18T20:09:40Z","license_text":"\n                                 Apache License\n                           Version 2.0, January 2004\n                        http://www.apache.org/licenses/\n\n   TERMS AND CONDITIONS FOR USE, REPRODUCTION, AND DISTRIBUTION\n\n   1. Definitions.\n\n      \"License\" shall mean the terms and conditions for use, reproduction,\n      and distribution as defined by Sections 1 through 9 of this document.\n\n      \"Licensor\" shall mean the copyright owner or entity authorized by\n      the copyright owner that is granting the License.\n\n      \"Legal Entity\" shall mean the union of the acting entity and all\n      other entities that control, are controlled by, or are under common\n      control with that entity. For the purposes of this definition,\n      \"control\" means (i) the power, direct or indirect, to cause the\n      direction or management of such entity, whether by contract or\n      otherwise, or (ii) ownership of fifty percent (50%) or more of the\n      outstanding shares, or (iii) beneficial ownership of such entity.\n\n      \"You\" (or \"Your\") shall mean an individual or Legal Entity\n      exercising permissions granted by this License.\n\n      \"Source\" form shall mean the preferred form for making modifications,\n      including but not limited to software source code, documentation\n      source, and configuration files.\n\n      \"Object\" form shall mean any form resulting from mechanical\n      transformation or translation of a Source form, including but\n      not limited to compiled object code, generated documentation,\n      and conversions to other media types.\n\n      \"Work\" shall mean the work of authorship, whether in Source or\n      Object form, made available under the License, as indicated by a\n      copyright notice that is included in or attached to the work\n      (an example is provided in the Appendix below).\n\n      \"Derivative Works\" shall mean any work, whether in Source or Object\n      form, that is based on (or derived from) the Work and for which the\n      editorial revisions, annotations, elaborations, or other modifications\n      represent, as a whole, an original work of authorship. For the purposes\n      of this License, Derivative Works shall not include works that remain\n      separable from, or merely link (or bind by name) to the interfaces of,\n      the Work and Derivative Works thereof.\n\n      \"Contribution\" shall mean any work of authorship, including\n      the original version of the Work and any modifications or additions\n      to that Work or Derivative Works thereof, that is intentionally\n      submitted to Licensor for inclusion in the Work by the copyright owner\n      or by an individual or Legal Entity authorized to submit on behalf of\n      the copyright owner. For the purposes of this definition, \"submitted\"\n      means any form of electronic, verbal, or written communication sent\n      to the Licensor or its representatives, including but not limited to\n      communication on electronic mailing lists, source code control systems,\n      and issue tracking systems that are managed by, or on behalf of, the\n      Licensor for the purpose of discussing and improving the Work, but\n      excluding communication that is conspicuously marked or otherwise\n      designated in writing by the copyright owner as \"Not a Contribution.\"\n\n      \"Contributor\" shall mean Licensor and any individual or Legal Entity\n      on behalf of whom a Contribution has been received by Licensor and\n      subsequently incorporated within the Work.\n\n   2. Grant of Copyright License. Subject to the terms and conditions of\n      this License, each Contributor hereby grants to You a perpetual,\n      worldwide, non-exclusive, no-charge, royalty-free, irrevocable\n      copyright license to reproduce, prepare Derivative Works of,\n      publicly display, publicly perform, sublicense, and distribute the\n      Work and such Derivative Works in Source or Object form.\n\n   3. Grant of Patent License. Subject to the terms and conditions of\n      this License, each Contributor hereby grants to You a perpetual,\n      worldwide, non-exclusive, no-charge, royalty-free, irrevocable\n      (except as stated in this section) patent license to make, have made,\n      use, offer to sell, sell, import, and otherwise transfer the Work,\n      where such license applies only to those patent claims licensable\n      by such Contributor that are necessarily infringed by their\n      Contribution(s) alone or by combination of their Contribution(s)\n      with the Work to which such Contribution(s) was submitted. If You\n      institute patent litigation against any entity (including a\n      cross-claim or counterclaim in a lawsuit) alleging that the Work\n      or a Contribution incorporated within the Work constitutes direct\n      or contributory patent infringement, then any patent licenses\n      granted to You under this License for that Work shall terminate\n      as of the date such litigation is filed.\n\n   4. Redistribution. You may reproduce and distribute copies of the\n      Work or Derivative Works thereof in any medium, with or without\n      modifications, and in Source or Object form, provided that You\n      meet the following conditions:\n\n      (a) You must give any other recipients of the Work or\n          Derivative Works a copy of this License; and\n\n      (b) You must cause any modified files to carry prominent notices\n          stating that You changed the files; and\n\n      (c) You must retain, in the Source form of any Derivative Works\n          that You distribute, all copyright, patent, trademark, and\n          attribution notices from the Source form of the Work,\n          excluding those notices that do not pertain to any part of\n          the Derivative Works; and\n\n      (d) If the Work includes a \"NOTICE\" text file as part of its\n          distribution, then any Derivative Works that You distribute must\n          include a readable copy of the attribution notices contained\n          within such NOTICE file, excluding those notices that do not\n          pertain to any part of the Derivative Works, in at least one\n          of the following places: within a NOTICE text file distributed\n          as part of the Derivative Works; within the Source form or\n          documentation, if provided along with the Derivative Works; or,\n          within a display generated by the Derivative Works, if and\n          wherever such third-party notices normally appear. The contents\n          of the NOTICE file are for informational purposes only and\n          do not modify the License. You may add Your own attribution\n          notices within Derivative Works that You distribute, alongside\n          or as an addendum to the NOTICE text from the Work, provided\n          that such additional attribution notices cannot be construed\n          as modifying the License.\n\n      You may add Your own copyright statement to Your modifications and\n      may provide additional or different license terms and conditions\n      for use, reproduction, or distribution of Your modifications, or\n      for any such Derivative Works as a whole, provided Your use,\n      reproduction, and distribution of the Work otherwise complies with\n      the conditions stated in this License.\n\n   5. Submission of Contributions. Unless You explicitly state otherwise,\n      any Contribution intentionally submitted for inclusion in the Work\n      by You to the Licensor shall be under the terms and conditions of\n      this License, without any additional terms or conditions.\n      Notwithstanding the above, nothing herein shall supersede or modify\n      the terms of any separate license agreement you may have executed\n      with Licensor regarding such Contributions.\n\n   6. Trademarks. This License does not grant permission to use the trade\n      names, trademarks, service marks, or product names of the Licensor,\n      except as required for reasonable and customary use in describing the\n      origin of the Work and reproducing the content of the NOTICE file.\n\n   7. Disclaimer of Warranty. Unless required by applicable law or\n      agreed to in writing, Licensor provides the Work (and each\n      Contributor provides its Contributions) on an \"AS IS\" BASIS,\n      WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or\n      implied, including, without limitation, any warranties or conditions\n      of TITLE, NON-INFRINGEMENT, MERCHANTABILITY, or FITNESS FOR A\n      PARTICULAR PURPOSE. You are solely responsible for determining the\n      appropriateness of using or redistributing the Work and assume any\n      risks associated with Your exercise of permissions under this License.\n\n   8. Limitation of Liability. In no event and under no legal theory,\n      whether in tort (including negligence), contract, or otherwise,\n      unless required by applicable law (such as deliberate and grossly\n      negligent acts) or agreed to in writing, shall any Contributor be\n      liable to You for damages, including any direct, indirect, special,\n      incidental, or consequential damages of any character arising as a\n      result of this License or out of the use or inability to use the\n      Work (including but not limited to damages for loss of goodwill,\n      work stoppage, computer failure or malfunction, or any and all\n      other commercial damages or losses), even if such Contributor\n      has been advised of the possibility of such damages.\n\n   9. Accepting Warranty or Additional Liability. While redistributing\n      the Work or Derivative Works thereof, You may choose to offer,\n      and charge a fee for, acceptance of support, warranty, indemnity,\n      or other liability obligations and/or rights consistent with this\n      License. However, in accepting such obligations, You may act only\n      on Your own behalf and on Your sole responsibility, not on behalf\n      of any other Contributor, and only if You agree to indemnify,\n      defend, and hold each Contributor harmless for any liability\n      incurred by, or claims asserted against, such Contributor by reason\n      of your accepting any such warranty or additional liability.\n\n   END OF TERMS AND CONDITIONS\n\n   APPENDIX: How to apply the Apache License to your work.\n\n      To apply the Apache License to your work, attach the following\n      boilerplate notice, with the fields enclosed by brackets \"[]\"\n      replaced with your own identifying information. (Don't include\n      the brackets!)  The text should be enclosed in the appropriate\n      comment syntax for the file format. We also recommend that a\n      file or class name and description of purpose be included on the\n      same \"printed page\" as the copyright notice for easier\n      identification within third-party archives.\n\n   Copyright [yyyy] [name of copyright owner]\n\n   Licensed under the Apache License, Version 2.0 (the \"License\");\n   you may not use this file except in compliance with the License.\n   You may obtain a copy of the License at\n\n       http://www.apache.org/licenses/LICENSE-2.0\n\n   Unless required by applicable law or agreed to in writing, software\n   distributed under the License is distributed on an \"AS IS\" BASIS,\n   WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n   See the License for the specific language governing permissions and\n   limitations under the License.\n","owner":"anthropics","repo":"anthropics/financial-services","source_url":"https://github.com/anthropics/financial-services/tree/9affc6e683bbaf66361058117027cf5a50bf1861/plugins/vertical-plugins/equity-research/skills/initiating-coverage"}},"content_hash":[11,130,21,196,20,43,82,152,45,173,52,216,116,162,41,62,141,3,3,232,62,31,114,241,62,48,137,176,209,243,186,202],"trust_level":"unsigned","yanked":false}