Skill Tracer
Skills › Financial Services › model-update

model-update

skill · 95 lines · Apache-2.0 · plugins/vertical-plugins/equity-research/skills/model-update/SKILL.md

The facts

Its description

Update financial models with new data — quarterly earnings, management guidance, macro changes, or revised assumptions. Adjusts estimates, recalculates valuation, and flags material changes. Use after earnings, guidance updates, or when assumptions need refreshing. Triggers on "update model", "plug earnings", "refresh estimates", "update numbers for [company]", "new guidance", or "revise estimates".

The description the agent reads to decide when to use it.

From its settingsline 3

When it starts

The agent picks this when someone wants an existing financial model or estimate set refreshed after new information — quarterly earnings, new guidance, macro moves, or changed assumptions — and wants the valuation and price target recalculated. The description frames it as a follow-on task, so it fires on requests to plug in actuals or revise forward numbers rather than to build a model from scratch.

Things a person might say (the model's guesses)

  • “Plug Q3 earnings into my model for Costco and update the price target.”
  • “The company just cut guidance — refresh my estimates and tell me whether the rating changes.”
  • “Rates and FX moved a lot this quarter; update the numbers in my model and flag anything material.”

A model's summary of when it is used.

A model's reading

What leads to it

Other skills that hand off to this one, call it, require it or offer it instead, as a model read them.

A model's reading

Licence

Apache-2.0, from LICENSE

The terms its author shares it under, which let it be shown here.

From the repositorylicence text

The text

Open on GitHub
1---
2name: model-update
3description: Update financial models with new data — quarterly earnings, management guidance, macro changes, or revised assumptions. Adjusts estimates, recalculates valuation, and flags material changes. Use after earnings, guidance updates, or when assumptions need refreshing. Triggers on "update model", "plug earnings", "refresh estimates", "update numbers for [company]", "new guidance", or "revise estimates".
4---
5
6# Model Update
7

Model Update

Raw lines 1 to 7
8## Workflow
9
10### Step 1: Identify What Changed
12Determine the update trigger:
13- **Earnings release**: New quarterly actuals to plug in
14- **Guidance change**: Company updated forward outlook
15- **Estimate revision**: Analyst changing assumptions based on new data
16- **Macro update**: Interest rates, FX, commodity prices changed
17- **Event-driven**: M&A, restructuring, new product, management change

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
  • Macro update: Interest rates, FX, commodity prices changed
  • Event-driven: M&A, restructuring, new product, management change
Raw lines 10 to 18
19### Step 2: Plug New Data
21#### After Earnings
22Update the model with reported actuals:
24| Line Item | Prior Estimate | Actual | Delta | Notes |
25|-----------|---------------|--------|-------|-------|
26| Revenue | | | | |
27| Gross Margin | | | | |
28| Operating Expenses | | | | |
29| EBITDA | | | | |
30| EPS | | | | |
31| [Key metric 1] | | | | |
32| [Key metric 2] | | | | |
34**Segment Detail** (if applicable):
35- Update each segment's revenue and margin
36- Note any segment mix shifts
38**Balance Sheet / Cash Flow Updates**:
39- Cash and debt balances
40- Share count (buybacks, dilution)
41- Capex actual vs. estimate
42- Working capital changes

Step 2: Plug New Data

After Earnings

Update the model with reported actuals:

Line ItemPrior EstimateActualDeltaNotes
Revenue
Gross Margin
Operating Expenses
EBITDA
EPS
[Key metric 1]
[Key metric 2]

Segment Detail (if applicable):

  • Update each segment's revenue and margin
  • Note any segment mix shifts

Balance Sheet / Cash Flow Updates:

  • Cash and debt balances
  • Share count (buybacks, dilution)
  • Capex actual vs. estimate
  • Working capital changes
Raw lines 19 to 43
44### Step 3: Revise Forward Estimates
46Based on the new data, adjust forward estimates:
48| | Old FY Est | New FY Est | Change | Old Next FY | New Next FY | Change |
49|---|-----------|-----------|--------|------------|------------|--------|
50| Revenue | | | | | | |
51| EBITDA | | | | | | |
52| EPS | | | | | | |
54**Key Assumption Changes:**
55- What assumptions are you changing and why?
56- Revenue growth rate: old → new (reason)
57- Margin assumption: old → new (reason)
58- Any new items (restructuring charges, one-time gains, etc.)

Step 3: Revise Forward Estimates

Based on the new data, adjust forward estimates:

Old FY EstNew FY EstChangeOld Next FYNew Next FYChange
Revenue
EBITDA
EPS

Key Assumption Changes:

  • What assumptions are you changing and why?
  • Revenue growth rate: old → new (reason)
  • Margin assumption: old → new (reason)
  • Any new items (restructuring charges, one-time gains, etc.)
Raw lines 44 to 59
60### Step 4: Valuation Impact
62Recalculate valuation with updated estimates:
64| Valuation Method | Prior | Updated | Change |
65|-----------------|-------|---------|--------|
66| DCF fair value | | | |
67| P/E (NTM EPS × target multiple) | | | |
68| EV/EBITDA (NTM EBITDA × target multiple) | | | |
69| **Price Target** | | | |

Step 4: Valuation Impact

Recalculate valuation with updated estimates:

Valuation MethodPriorUpdatedChange
DCF fair value
P/E (NTM EPS × target multiple)
EV/EBITDA (NTM EBITDA × target multiple)
Price Target
Raw lines 60 to 70
71### Step 5: Summary & Action
73**Estimate Change Summary:**
74- One paragraph: what changed, why, and what it means for the stock
75- Is this a thesis-changing event or noise?
77**Rating / Price Target:**
78- Maintain or change rating?
79- New price target (if changed) with methodology
80- Upside/downside to current price

Step 5: Summary & Action

Estimate Change Summary:

  • One paragraph: what changed, why, and what it means for the stock
  • Is this a thesis-changing event or noise?

Rating / Price Target:

  • Maintain or change rating?
  • New price target (if changed) with methodology
  • Upside/downside to current price
Raw lines 71 to 81
82### Step 6: Output
84- Updated Excel model (if user provides the existing model)
85- Estimate change summary (markdown or Word)
86- Updated price target derivation

Step 6: Output

  • Updated Excel model (if user provides the existing model)
  • Estimate change summary (markdown or Word)
  • Updated price target derivation
Raw lines 82 to 87
88## Important Notes
90- Always reconcile your estimates to the company's reported figures before projecting forward
91- Note any non-recurring items and whether your estimates are GAAP or adjusted
92- Track your estimate revision history — it shows your analytical progression
93- If the quarter was noisy, separate signal from noise in your estimate changes
94- Check consensus after updating — how do your revised estimates compare to the Street?
95- Share count matters — dilution from stock comp, converts, or buybacks can materially affect EPS

Important Notes

  • Always reconcile your estimates to the company's reported figures before projecting forward
  • Note any non-recurring items and whether your estimates are GAAP or adjusted
  • Track your estimate revision history — it shows your analytical progression
  • If the quarter was noisy, separate signal from noise in your estimate changes
  • Check consensus after updating — how do your revised estimates compare to the Street?
  • Share count matters — dilution from stock comp, converts, or buybacks can materially affect EPS
Raw lines 88 to 95

From anthropics/financial-services at 6056506, 2026-10-28. Skills read by DeepSeek V4.1 Flash on 2026-11-04. Summary and techniques by Claude Opus 5.5 on 2026-11-06.