Dcf

Preflight

Run canonical pre-flight per contracts/preflight.md.

Include the X-Agentii-Trace header on every tool call per contracts/x-agentii-trace-header.md — carry the _run_id from your first tool result and name yourself (and your parent, if you were spawned).

Triggers

• analyze dcf model
• run dcf model analysis
• produce dcf model report
• dcf model breakdown
• dcf model deep dive
• build a dcf model
• assess dcf model
• quantify dcf model
• compare dcf model across peers
• review dcf model for
• generate dcf model on
• dcf model for investment decision

Defaults

Methodology

Retrieval Scope

This skill performs unstructured document search at scale across SEC filings and earnings call transcripts (10-K, 10-Q, 8-K). The three-layer agent-use-ready retrieval protocol (Document Discovery → Page Map → Deep Read) applies to all unstructured document search at scale.

Retrieval Strategy

See contracts/retrieval.md for the canonical decision tree; skill-specific retrieval detail is in references/methodology.md.

Temporal Scope

Default: 12 fiscal quarters (max 20). Financial modeling: trailing 12 quarters (3 fiscal years) for long-range projection inputs.

Tool Allowlist

See frontmatter allowed_tools.

Protocol

Step-by-step execution detail is in references/methodology.md.

Deliverable Chain

Inputs → Build → Validate → Output → Next

1. Inputs: resolved ticker + search_xbrl_facts (Income Statement, Balance Sheet, Cash Flow) + get_company_financials + get_realtime_quote for current price.
2. Build: write a self-contained Python script using openpyxl that creates the DCF workbook (projections, WACC, terminal value, sensitivity tables) per ## Output Structure. Execute via Bash: python3 script.py. Verify the .xlsx exists. If import openpyxl fails, fall back to .md summary with data_availability: degraded (see contracts/office-tooling.md).
3. Validate: run LibreOffice recalc; audit hardcoded_count == 0 for tagged cells per ## Validation Gates; verify projection horizon ≥ 5 years, terminal growth < risk-free proxy.
4. Output: write the artifact path per ## Output File. (Optional) render an executive-summary .pptx via Bash+python-pptx; convert .xlsx → PDF via LibreOffice.
5. Next: append to agentii.md; hand off to a downstream pitch/review skill if requested.

Validation Gates

1. projection horizon: ≥ 5 years (10 years for secular-trends analysis). If failed: If < 5 years: refuse delivery, report actual horizon.
2. terminal growth rate: < risk-free rate proxy (current 10Y UST). If failed: If terminal_g ≥ rf: flag in assumptions section, note conservatism violation.
3. WACC components: WACC = (E/V × Ke) + (D/V × Kd × (1-T) with all components cited to source data. For risk-free rate selection, ERP triangulation, beta de-levering/re-levering, industry betas, and cost of debt estimation, consult references/cost-of-capital-methodology.md. If failed: If components uncited: refuse delivery, list missing citations.
4. hardcoded_count: == 0 for all cells tagged projection|margin|discount_factor|pv|sensitivity per xlsx_audit output. If failed: If hardcoded_count > 0: per the hardcode gate, refuse delivery. Bounce back to analytical-subagent ONCE with audit report.
5. **calculation arc cross-validation **: cross-statement balancing verified against gold.xbrl_calculations weights — the DCF free-cash-flow projection and income statement structure MUST align with the filer's reported concept hierarchy. Call get_statement_structure(accession_number) (resolve the accession_number first). Flag discrepancies ≥1% as audit findings. If failed: If material discrepancy (≥1%): flag in audit findings, refuse delivery for discrepancies ≥5%. Tool-diversity is also tracked here: distinct MCP tools used MUST be ≥ min_tool_diversity (5); below that, flag as depth-insufficient in Coverage Gaps (a quality signal, not a delivery blocker).

Tool Fallbacks

Per-tool failure modes and fallback actions are tabulated in references/tool-fallbacks.md.