Financial Modeling Workflow

Financial Modeling Workflow

This skill provides a structured workflow for building financial models using the financial-modeler agent.

Workflow Overview

The financial modeling workflow follows 6 phases:

---

Phase 1: Scoping

MANDATORY: Define model purpose before building

Questions to Answer

Model Type Selection

Blocker Check

If ANY of these are unclear, STOP and ask:

• Model purpose
• Model type
• Key assumptions (WACC, growth, multiples)
• Scenario requirements

---

Phase 2: Architecture

MANDATORY: Design structure before building

Architecture Principles

Standard Model Structure

---

Phase 3: Assumptions

MANDATORY: Document ALL assumptions with sources

Required Assumption Categories

Assumption Documentation Standard

Blocker: WACC Components

MUST get user input on:

• Risk-free rate source
• Equity risk premium source
• Beta source and adjustment
• Capital structure assumption

---

Phase 4: Build

Dispatch to specialist with full context

Agent Dispatch

Task tool:
  subagent_type: "ring:financial-modeler"
  model: "opus"
  prompt: |
    Build financial model per these specifications:

    **Purpose**: [decision supported]
    **Model Type**: [DCF/​LBO/​M&A/​Operating]

    **Architecture**:
    [From Phase 2]

    **Assumptions**:
    [From Phase 3]

    **Historical Data**:
    [Attach historical financials]

    **Required Output**:
    - Model structure per architecture
    - All assumptions in input section
    - Sensitivity analysis
    - Scenario analysis (base/​upside/​downside)
    - Error checks

Required Output Elements

---

Phase 5: Validation

MANDATORY: Test model before delivery

Validation Tests

Sensitivity Testing

Anti-Rationalization

---

Phase 6: Documentation

MANDATORY: Document for future users

Documentation Checklist

Output Format

See shared-patterns/​execution-report.md for base metrics.

Modeling-Specific Metrics:

• model_tabs: N
• assumptions_documented: N
• scenarios: N
• sensitivity_tests: N
• validation_tests: N passed

---

Pressure Resistance

See shared-patterns/​pressure-resistance.md for universal pressures.

Modeling-Specific Pressures

---

Anti-Rationalization Table

See shared-patterns/​anti-rationalization.md for universal anti-rationalizations.

Modeling-Specific Anti-Rationalizations

---

Execution Report

Upon completion, report:

Quality Indicators