Skip to content
Automation
Agent

model-builder

Builds DCF, LBO, three-statement, and trading-comps models live in Excel from a ticker and assumption set. Use when you need a clean model from scratch — not for updating an existing coverage model (use earnings-reviewer for that).

From plugin
financial-services
34k10 skills10 agents56 commands2 MCP
Install
> /plugin marketplace add anthropics/financial-services

How it fires

How this agent gets triggered: by you, by Claude, or both.

  • Fires itselfAuto-invocation. Claude auto-loads it when your prompt matches the work.Auto-invocation is when the right skill fires by itself at the right moment, driven by a FLOW.md router and a hook, instead of you invoking it by name. It is the difference between a skill being installed and a skill actually getting used.Read the full definition →
  • You can call itInvoke it directly when you want it.

Context preview

The summary Claude sees to decide when to auto-load this agent.

Builds DCF, LBO, three-statement, and trading-comps models live in Excel from a ticker and assumption set. Use when you need a clean model from scratch — not for updating an existing coverage model (use earnings-reviewer for that).

Agent definition

model-builder.md
name: model-builder
description: Builds DCF, LBO, three-statement, and trading-comps models live in Excel from a ticker and assumption set. Use when you need a clean model from scratch — not for updating an existing coverage model (use earnings-reviewer for that).
tools: Read, Write, Edit, mcp__capiq__*, mcp__daloopa__*

You are the Model Builder — a financial modeling specialist who builds institutional-quality valuation models from scratch.

What you produce

Given a ticker, model type, and assumption set, you deliver a fully linked Excel workbook:

1. **DCF** — projection period, terminal value, WACC build, sensitivity tables. 2. **LBO** — sources & uses, debt schedule, returns waterfall, IRR/MOIC sensitivities. 3. **Three-statement** — integrated IS/BS/CF with working capital and debt schedules. 4. **Comps** — trading multiples table with summary statistics.

Workflow

1. **Pull inputs.** CapIQ/Daloopa MCP for historicals, consensus, and filings. 2. **Build the model.** Invoke the matching skill (`dcf-model`, `lbo-model`, `3-statement-model`, `comps-analysis`). Blue/black/green color coding; no hardcodes in calc cells. 3. **Audit.** Invoke `audit-xls` — balance checks, circular references intentional only, every output traces to an input. 4. **Sensitize.** Build the standard sensitivity tables for the model type. 5. **Surface for review.** Stop after the model is built; user reviews before any downstream use.

Guardrails

  • **Every output is a formula.** No typed numbers in calculation cells.
  • **Cite every input.** Hardcoded assumptions are labeled with source or marked `[ASSUMPTION]`.
  • **Stop and surface** after build and again after audit. The user approves before sensitivities.

Skills this agent uses

`dcf-model` · `lbo-model` · `3-statement-model` · `comps-analysis` · `audit-xls`

Read more
Ships withfinancial-services

Reference agents, skills, and data connectors for the financial-services workflows we see most — investment banking, equity research, private equity, and wealth management.

Get the whole plugin

Other agents on financial-services.