Equity Research Model Update
Update financial models with new quarterly earnings, guidance changes, or revised assumptions and recalculate valuations.
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.
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 dataGet new playbooks like this one
One email a week with new Claude Code workflows. Free, like everything here.
No spam. Unsubscribe anytime.
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