Home
cd ../playbooks
Equity ResearchIntermediate

Equity Research Model Update

Update financial models with new quarterly earnings, guidance changes, or revised assumptions and recalculate valuations.

5 minutes
By anthropicSource
#equity research#financial modeling#estimate revision#model update

After every earnings release, your model needs updating — plugging in actuals, revising forward estimates, and recalculating price targets is tedious but critical work that determines whether your recommendation still holds.

Who it's for: equity research analysts, financial analysts, portfolio managers, buy-side analysts, sell-side associates

Example

"Update my Nike model with Q3 earnings" → Updated model with actuals vs. estimates comparison, revised forward estimates with old-vs-new table, recalculated price target, and summary of whether the thesis changed

CLAUDE.md Template

New here? 3-minute setup guide → | Already set up? Copy the template below.

Or install from your terminal:
npx ccplaybooks add er-model-update
# Model Update

Update financial models with new data — quarterly earnings, management guidance, macro changes, or revised assumptions. Adjusts estimates, recalculates valuation, and flags material changes.

## Workflow

### Step 1: Identify What Changed

Determine the update trigger:
- **Earnings release**: New quarterly actuals to plug in
- **Guidance change**: Company updated forward outlook
- **Estimate revision**: Analyst changing assumptions based on new data

Get new playbooks like this one

One email a week with new Claude Code workflows. Free, like everything here.

No spam. Unsubscribe anytime.

README.md

What This Does

Updates financial models with new data — quarterly earnings actuals, management guidance, macro changes, or revised assumptions. Plugs in reported figures, adjusts forward estimates, recalculates valuation, and flags whether changes are thesis-altering or noise.


Quick Start

Step 1: Create a Project Folder

Place your existing financial model and the downloaded template in the same folder.

Step 2: Download the Template

Click Download above, then move the file into your project folder as CLAUDE.md.

Step 3: Start Working

"Update my model with Tesla Q3 earnings"
"Plug in Apple's new guidance numbers"
"Revise estimates for Microsoft after the Azure growth data"
"Refresh my macro assumptions for rate-sensitive names"

Connect a Live Data Source (Optional)

The template reconciles and rolls your model forward. It still needs the reported actuals to plug in.

Option A: live data through MCP. Connect Claude Code to Fiscal.ai and Claude pulls standardized financials, ratios, filings and earnings call transcripts itself. Every plan starts with a 7-day free trial that includes the MCP connection:

claude mcp add --transport http fiscal https://api.fiscal.ai/mcp

The Fiscal.ai MCP earnings note walkthrough covers the setup and a full worked example.

Option B: free. Pull US company data from yfinance with the Financial Data Collector playbook, or paste the figures from the press release and filings yourself.

The Fiscal.ai link is an affiliate link: we may earn a commission if you subscribe, at no extra cost to you.

Update Triggers

  • Earnings release: New quarterly actuals to plug in
  • Guidance change: Company updated forward outlook
  • Estimate revision: Changing assumptions based on new data
  • Macro update: Interest rates, FX, commodity prices changed
  • Event-driven: M&A, restructuring, new product, management change

Best Practices

  • Always reconcile estimates to reported figures before projecting forward
  • Note whether estimates are GAAP or adjusted and flag non-recurring items
  • Track your estimate revision history — it shows analytical progression
  • Separate signal from noise when quarters are messy
  • Check consensus after updating to see how your revised estimates compare to the Street

$Related Playbooks

Equity Research

Equity Research Morning Note

Draft concise morning meeting notes summarizing overnight developments, trade ideas, and key events for coverage stocks.

5 minutes
Beginner
Equity Research

Equity Research Sector Overview

Create comprehensive industry landscape reports covering market dynamics, competitive positioning, key players, valuation context, and thematic trends.

5 minutes
Intermediate
Equity Research

Equity Research Thesis Tracker

Maintain and update investment theses for portfolio positions with scorecard tracking, catalyst calendars, and conviction monitoring.

5 minutes
Beginner
Equity Research

Fundamental Stock Analysis Framework

A rigorous, sector-relative, multi-factor equity analysis process for Indian (NSE/BSE) and US/global listed companies — document-first sourcing that never invents a number, a recency gate that catches superseded data, forensic and IPO modes, and an adversarial challenge pass before delivery.

15 minutes
Advanced
Equity Research

Investment Research LLM Wiki

Co-create a personal investment-research wiki (Karpathy's LLM Wiki pattern) where your own analysis framework becomes a living CLAUDE.md — by interviewing you, not handing you a template.

20 minutes
Intermediate
Equity Research

Equity Research Catalyst Calendar

Build and maintain a calendar of upcoming catalysts across your coverage universe including earnings dates, conferences, product launches, and macro events.

5 minutes
Beginner
Equity Research

Equity Research Earnings Update Report

Create professional 8-12 page earnings update reports analyzing quarterly results with beat/miss analysis, updated estimates, and revised thesis.

5 minutes
Advanced
Equity Research

Equity Research Earnings Preview

Build pre-earnings analysis with estimate models, bull/bear scenarios, key metrics to watch, and trading setup notes.

5 minutes
Intermediate
Equity Research

Equity Research Idea Generation

Systematic stock screening and investment idea sourcing combining quantitative screens, thematic research, and pattern recognition.

5 minutes
Intermediate
Equity Research

Equity Research Initiating Coverage Report

Create institutional-quality 30-50 page equity research initiation reports through a structured 5-task workflow with company research, financial modeling, valuation, charts, and report assembly.

10 minutes
Advanced

Browse all Equity Research playbooks →