Model Update
OfficialFreeEfficiently refresh financial models with updated data.
Free · Opens the source repo
What Model Update does
The Model Update skill is designed for finance professionals who need to keep their financial models current with the latest data. This skill streamlines the process of updating models after key events such as earnings releases, guidance changes, or macroeconomic shifts. By following a structured workflow, users can ensure that their financial estimates reflect the most accurate and relevant information available.
The workflow begins by identifying the trigger for the update, which could be a new earnings report, a change in management guidance, or a revision of macroeconomic assumptions. Once the trigger is established, users can input the new data into the model, including revenue figures, gross margins, and other key metrics. The skill provides a clear framework for documenting prior estimates, actual results, and any significant changes, allowing for a thorough analysis of the impact on the overall financial outlook.
After updating the model with actual results, users can revise forward estimates based on the new data. The skill emphasizes the importance of adjusting key assumptions, such as revenue growth rates and margin expectations, and provides a systematic way to recalculate valuation metrics like discounted cash flow (DCF) and price-to-earnings (P/E) ratios. This ensures that users have a comprehensive understanding of how the updates affect the company's valuation and price targets.
Finally, the skill generates an output that includes an updated Excel model and a summary of the changes made, aiding users in communicating their findings effectively. This skill is particularly useful for analysts and finance professionals who require a reliable method to maintain the accuracy of their financial models in a fast-paced environment.
When to use it
Use this skill after earnings releases, guidance updates, or when significant assumptions need to be revised.
When not to use it
This skill may not be suitable for initial model creation or for users without a foundational understanding of financial modeling.
What you can build with it
Updating After Earnings Release
Use this skill to quickly input actual earnings data into your financial model after a quarterly earnings report.
Revising Estimates Post-Guidance Change
Employ the skill to adjust your financial forecasts based on new guidance provided by the company.
Incorporating Macro Changes
Utilize this skill to revise your financial models in response to significant macroeconomic shifts that impact your assumptions.
How to install Model Update
View source1. Install with the skills CLI
npx skills add anthropics/financial-services/model-update --agent claude-code2. Or install it manually
Download the skill folder and drop it into ~/.claude/skills/ for all projects, or .claude/skills/ to scope it to one repo. Restart Claude Code so it picks up the new skill.
Anthropic's agentic coding CLI, and the reference implementation of Agent Skills. Drop a skill folder into ~/.claude/skills and Claude Code loads it automatically whenever a task matches the skill's description. Claude Code docs
Inside SKILL.md
Written by anthropicsModel Update
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
- Macro update: Interest rates, FX, commodity prices changed
- Event-driven: M&A, restructuring, new product, management change
Step 2: Plug New Data
After Earnings
Update the model with reported actuals:
| Line Item | Prior Estimate | Actual | Delta | Notes |
|---|---|---|---|---|
| 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
Step 3: Revise Forward Estimates
Based on the new data, adjust forward estimates:
| Old FY Est | New FY Est | Change | Old Next FY | New Next FY | Change | |
|---|---|---|---|---|---|---|
| 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.)
Step 4: Valuation Impact
Recalculate valuation with updated estimates:
| Valuation Method | Prior | Updated | Change |
|---|---|---|---|
| DCF fair value | |||
| P/E (NTM EPS × target multiple) | |||
| EV/EBITDA (NTM EBITDA × target multiple) | |||
| Price Target |
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
Step 6: Output
- Updated Excel model (if user provides the existing model)
- Estimate change summary (markdown or Word)
- Updated price target derivation
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
Frequently asked questions about Model Update
Similar skills
Initiating Coverage
Create institutional-quality equity research reports.
Financial Tear Sheet Generator
Create professional company profiles with live data.
Pitch Deck Population
Effortlessly fill pitch deck templates with data.
Tax Season Organizer
Streamline your tax prep for accountants.
Month End Prep
Streamline your month-end close process with ease.
Funding Digest
Summarize funding rounds in a single slide.