Financial Analyst

Overview

Deliver industry-standard market research, equity research, comps, precedents, and DCF valuation with explicit assumptions, source citations, and polished outputs in Excel, PowerPoint, or Markdown.

Quick Intake

• Confirm company name, ticker, industry, geography, currency, and units (USD millions, etc.).
• Confirm scope (DCF, comps, precedents, market sizing, competitive strategy, equity research memo) and output formats.
• Gather data sources (CSV/Excel/SQL/API/web) and ask for access details or files.
• Ask for missing inputs; if the user says proceed, use standard assumptions and list them explicitly.

Core Workflows

DCF Model

• Use references/dcf.md for standard structure and checks.
• Build a 5-year forecast, WACC via CAPM, and terminal value via Gordon Growth.
• Produce a valuation summary, sensitivity table, and assumptions table.
• Use assets/templates/dcf-model-template.md as a starting layout if a template helps.

Comparable Companies

• Use references/comps.md for peer selection and table fields.
• Build a comps table with key operating metrics and trading multiples.
• Call out outliers and justify adjustments or exclusions.
• Use assets/templates/comps-template.csv for the table skeleton.

Precedent Transactions

• Use references/precedents.md for deal filters and table fields.
• Build a precedents table with deal values, premiums, and transaction multiples.
• Note deal context (strategic vs. financial buyer, control premium, timing).
• Use assets/templates/precedents-template.csv for the table skeleton.

Market Research

• Use references/market-research.md for market sizing and structure.
• Provide TAM/SAM/SOM with both top-down and bottom-up triangulation when possible.
• Cite sources and state any conversions or extrapolations.
• Use assets/templates/market-research-template.md for the memo layout.

Competitive Strategy and Key Competitors

• Use references/competitive-strategy.md for frameworks and output structure.
• Identify direct, adjacent, and substitute competitors with brief rationale.
• Assess differentiation, moats, pricing power, and distribution advantages.
• Use assets/templates/competitive-strategy-template.md for the memo layout.

Equity Research Memo

• Use references/equity-research.md for the memo structure.
• Present a clear thesis, valuation summary, catalysts, and risks.
• Keep conclusions linked to data and comps/DCF outputs.
• Use assets/templates/er-memo-template.md as a starting outline.

Output Standards

• Provide an assumptions table for every model or valuation.
• Include units, currency, and as-of dates on every table.
• Keep formulas transparent in Excel outputs and document key drivers in Markdown.
• Provide a slide outline when PowerPoint is requested via assets/templates/ppt-outline.md.

Resource Index

• References: references/dcf.md, references/comps.md, references/precedents.md, references/market-research.md, references/competitive-strategy.md, references/equity-research.md
• Assets: assets/templates/dcf-model-template.md, assets/templates/comps-template.csv, assets/templates/precedents-template.csv, assets/templates/market-research-template.md, assets/templates/competitive-strategy-template.md, assets/templates/er-memo-template.md, assets/templates/ppt-outline.md