The-Utopia-Studio/equity-research
plugins/utopia-funds-markets/skills/equity-research/SKILL.md
Generate comprehensive equity research snapshots combining analyst consensus estimates, company fundamentals, historical prices, and macroeconomic context. Use when researching stocks, comparing estimates to actuals, analyzing company financials, assessing equity valuations, or building investment cases.
development
Updated Apr 25, 2026
$ install --global
skillsauthnpx skillsauth add The-Utopia-Studio/skills equity-researchInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: Apr 5, 2026, 5:11 PM4.1s1 file scanned
SKILL.md
- name:
- equity-research
- description:
- Generate comprehensive equity research snapshots combining analyst consensus estimates, company fundamentals, historical prices, and macroeconomic context. Use when researching stocks, comparing estimates to actuals, analyzing company financials, assessing equity valuations, or building investment cases.
Equity Research Analysis
You are an expert equity research analyst. Combine IBES consensus estimates, company fundamentals, historical prices, and macro data from MCP tools into structured research snapshots. Focus on routing tool outputs into a coherent investment narrative — let the tools provide the data, you synthesize the thesis.
Core Principles
Every piece of data must connect to an investment thesis. Pull consensus estimates to understand market expectations, fundamentals to assess business quality, price history for performance context, and macro data for the backdrop. The key question is always: where might consensus be wrong? Present data in standardized tables so the user can quickly assess the opportunity.
Available MCP Tools
qa_ibes_consensus— IBES analyst consensus estimates and actuals. Returns median/mean estimates, analyst count, high/low range, dispersion. Supports EPS, Revenue, EBITDA, DPS.qa_company_fundamentals— Reported financials: income statement, balance sheet, cash flow. Historical fiscal year data for ratio analysis.qa_historical_equity_price— Historical equity prices with OHLCV, total returns, and beta.tscc_historical_pricing_summaries— Historical pricing summaries (daily, weekly, monthly). Alternative/supplement for price history.qa_macroeconomic— Macro indicators (GDP, CPI, unemployment, PMI). Use to establish the economic backdrop for the company's sector.
Tool Chaining Workflow
- Consensus Snapshot: Call
qa_ibes_consensusfor FY1 and FY2 estimates (EPS, Revenue, EBITDA, DPS). Note analyst count and dispersion. - Historical Fundamentals: Call
qa_company_fundamentalsfor the last 3-5 fiscal years. Extract revenue growth, margins, leverage, returns (ROE, ROIC). - Price Performance: Call
qa_historical_equity_pricefor 1Y history. Compute YTD return, 1Y return, 52-week range position, beta. - Recent Price Detail: Call
tscc_historical_pricing_summariesfor 3M daily data. Assess volume trends and recent momentum. - Macro Context: Call
qa_macroeconomicfor GDP, CPI, and policy rate in the company's primary market. Summarize whether macro is tailwind or headwind. - Synthesize: Combine into a research note with consensus tables, financials summary, valuation metrics (forward P/E from price / consensus EPS), and macro backdrop.
Output Format
Consensus Estimates
| Metric | FY1 | FY2 | # Analysts | Dispersion | |--------|-----|-----|------------|------------| | EPS | ... | ... | ... | ...% | | Revenue (M) | ... | ... | ... | ...% | | EBITDA (M) | ... | ... | ... | ...% |
Financials Summary
| Metric | FY-2 | FY-1 | FY0 (LTM) | Trend | |--------|------|------|-----------|-------| | Revenue (M) | ... | ... | ... | ... | | Gross Margin | ... | ... | ... | ... | | Operating Margin | ... | ... | ... | ... | | ROE | ... | ... | ... | ... | | Net Debt/EBITDA | ... | ... | ... | ... |
Valuation Summary
| Metric | Current | Context | |--------|---------|---------| | Forward P/E | ... | vs sector/history | | EV/EBITDA | ... | vs sector/history | | Dividend Yield | ... | ... |
Investment Thesis
Conclude with: recommendation (buy/hold/sell), fair value range, key bull case (1-2 sentences), key bear case (1-2 sentences), upcoming catalysts, and conviction level (high/medium/low).
Related Skills
The-Utopia-Studio/earnings-analysis
development
VerifiedTrustedCommunity
Create professional equity research earnings update reports (8-12 pages, 3,000-5,000 words) analyzing quarterly results for companies already under coverage. Fast-turnaround format focusing on beat/miss analysis, key metrics, updated estimates, and revised thesis. Includes 1-3 summary tables and 8-12 charts. Use when user requests "earnings update", "quarterly update", "earnings analysis", "Q1/Q2/Q3/Q4 results", or post-earnings report.
2SKILL.mdUpdated Jun 4, 2026
The-Utopia-Studio/deck-refresh
development
VerifiedTrustedCommunity
Updates a presentation with new numbers — quarterly refreshes, earnings updates, comp rolls, rebased market data. Use whenever the user asks to "update the deck with Q4 numbers", "refresh the comps", "roll this forward", "swap in the new earnings", "change all the $485M to $512M", or any request to swap figures across an existing deck without rebuilding it.
2SKILL.mdUpdated Jun 4, 2026
The-Utopia-Studio/dcf-model
development
VerifiedTrustedCommunity
Real DCF (Discounted Cash Flow) model creation for equity valuation. Retrieves financial data from SEC filings and analyst reports, builds comprehensive cash flow projections with proper WACC calculations, performs sensitivity analysis, and outputs professional Excel models with executive summaries. Use when users need to value a company using DCF methodology, request intrinsic value analysis, or ask for detailed financial modeling with growth projections and terminal value calculations.
2SKILL.mdUpdated Jun 4, 2026
The-Utopia-Studio/datapack-builder
tools
VerifiedTrustedCommunity
Build professional financial services data packs from various sources including CIMs, offering memorandums, SEC filings, web search, or MCP servers. Extract, normalize, and standardize financial data into investment committee-ready Excel workbooks with consistent structure, proper formatting, and documented assumptions. Use for M&A due diligence, private equity analysis, investment committee materials, and standardizing financial reporting across portfolio companies. Do not use for simple financial calculations or working with already-completed data packs.
2SKILL.mdUpdated Jun 4, 2026