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".
Copy the install command and let the AI configure it · recommended for beginners
Please install the "model-update" skill from askskill: 1. Download https://raw.githubusercontent.com/anthropics/financial-services/main/plugins/agent-plugins/earnings-reviewer/skills/model-update/SKILL.md 2. Save it as ~/.claude/skills/model-update/SKILL.md 3. Reload skills and tell me it's ready
Determine the update trigger:
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):
Balance Sheet / Cash Flow Updates:
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:
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 |
Estimate Change Summary:
Rating / Price Target:
Build M&A accretion dilution models with pro forma EPS and sensitivity analysis.
Create professional equity research earnings update reports (8-12 pages, 3,000-5,000 words) analyzing quarterly results for companies already under coverage. Fast-turnaround format focusing on beat/miss analysis, key metrics, updated estimates, and revised thesis. Includes 1-3 summary tables and 8-12 charts. Use when user requests "earnings update", "quarterly update", "earnings analysis", "Q1/Q2/Q3/Q4 results", or post-earnings report.
Build pre-earnings analysis with estimate models, scenario frameworks, and key metrics to watch. Use before a company reports quarterly earnings to prepare positioning notes, set up bull/bear scenarios, and identify what will move the stock. Triggers on "earnings preview", "what to watch for [company] earnings", "pre-earnings", "earnings setup", or "preview Q[X] for [company]".
Root-cause a reconciliation break to its source transaction or posting — follow the audit trail from the break row back to the originating entry on each side and state what differs and why. Use after gl-recon has classified a break.
Audit a spreadsheet for formula accuracy, errors, and common mistakes. Scopes to a selected range, a single sheet, or the entire model (including financial-model integrity checks like BS balance, cash tie-out, and logic sanity). Triggers on "audit this sheet", "check my formulas", "find formula errors", "QA this spreadsheet", "sanity check this", "debug model", "model check", "model won't balance", "something's off in my model", "model review".
Prepare for due diligence meetings — management presentations, expert network calls, customer references, and advisor sessions. Generates targeted question lists, benchmarks to reference, and red flags to probe. Use before any diligence meeting or call. Triggers on "prep for management meeting", "diligence call prep", "expert call questions", "customer reference questions", or "meeting prep for [company]".