Investing initiate

Initiate coverage on the company specified by the user: $ARGUMENTS

Before starting, read

../data-access.md

../design-system.md

This is the capstone skill that produces both a research note and an Excel model from a single comprehensive data gathering pass.

Strategy

Rather than running

/research-note

/build-model

Phase 1 — Company Setup

Look up the company by ticker using

discover_companies

• company_id

• latest_calendar_quarter

  — anchor for all period calculations (see

  ../data-access.md

  Section 1.5)

• latest_fiscal_quarter

• Firm name for report attribution (default: "Daloopa") — see

  ../data-access.md

  Section 4.5

Get market data (see ../data-access.md Section 2):

• Current price, market cap, shares outstanding, beta
• Trading multiples (P/E, EV/EBITDA, P/S, P/B)
• Risk-free rate (for DCF)

Phase 2 — Comprehensive Data Gathering

Follow the

/build-model

latest_calendar_quarter

• Full Income Statement (Revenue through EPS, including D&A for EBITDA calc)
• Full Balance Sheet (Cash through Equity)
• Full Cash Flow Statement (OCF, CapEx, FCF, Dividends, Buybacks)
• Segment revenue and operating income breakdowns
• Geographic revenue breakdown
• All company-specific operating KPIs
• All guidance series and corresponding actuals
• Share count, buyback amounts

Phase 3 — Peer Analysis

Identify 5-8 comparable companies. Get peer trading multiples (see ../data-access.md Section 2). If consensus forward estimates are available (../data-access.md Section 3), include NTM estimates. Pull peer fundamentals from Daloopa where available (revenue growth, margins).

Phase 4 — Projections

If a projection engine is available (see ../data-access.md Section 5), use it. Otherwise project manually. Write historical data to

reports/.tmp/{TICKER}_initiate_input.json

Phase 5 — DCF Valuation

• Calculate WACC (CAPM)
• Project 5-year FCFs
• Terminal value
• Implied share price
• Sensitivity table (WACC × terminal growth)

Phase 6 — Qualitative Research

Search SEC filings comprehensively:

• Risk factors, growth drivers, competitive dynamics
• Management outlook and guidance language
• Capital allocation strategy
• Company-specific strategic topics Extract business description, risks (ranked), investment thesis, catalysts.

Phase 7 — What You Need to Believe

Build falsifiable bull/bear beliefs (follows /research-note methodology):

• 4-6 numbered bull beliefs with evidence and Daloopa citations — each testable in 6 months
• 4-6 numbered bear beliefs with evidence and Daloopa citations — each testable in 6 months
• Valuation math for each side: forward multiple × earnings estimate = price target
• Risk/reward asymmetry assessment (bull upside % vs bear downside %)

Phase 8 — Synthesis & Charts

Write the executive summary, variant perception, and key findings.

If chart generation is available (see ../data-access.md Section 5), generate charts:

1. Revenue time-series
2. Margin time-series
3. Segment pie
4. Scenario bar (bull/base/bear)
5. DCF sensitivity heatmap

Skip any charts that fail; note which were generated.

Phase 9 — Render Both Outputs

Research Note (.docx):

1. Build the research note context with all gathered data, charts, narrative sections
2. Write to

   reports/.tmp/{TICKER}_context.json

3. Run:

   python infra/docx_renderer.py --template templates/research_note.docx --context reports/.tmp/{TICKER}_context.json --output reports/{TICKER}_research_note.docx

Excel Model (.xlsx):

1. Build the model context with all financial data, projections, DCF, comps
2. Write to

   reports/.tmp/{TICKER}_model_context.json

3. Run:

   python infra/excel_builder.py --context reports/.tmp/{TICKER}_model_context.json --output reports/{TICKER}_model.xlsx

Output

Tell the user:

• Research note saved to:

  reports/{TICKER}_research_note.docx

• Excel model saved to:

  reports/{TICKER}_model.xlsx

• Context files saved to:

  reports/.tmp/

  (for future updates)
• 3-4 sentence executive summary
• Key valuation range (DCF implied price + comps range)
• Top 3 findings
• Remind user that yellow cells in the Excel model's Projections tab are editable inputs

All financial figures must use Daloopa citation format: $X.XX million