跳到正文
cccskills
免费在 GitHub 公开

model-update

Update financial models after earnings, new company guidance, or changes in assumptions. Revise forecasts, recalculate valuation and price targets, and summarize significant changes with their reasons and implications for the investment view.

中文简介正在准备中。当前显示英语简介。

原文查看原文说明

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".

查看安装方法

适用场景

  • Updating a financial model after quarterly earnings
  • Revising forecasts after changes in company guidance
  • Reflecting interest rate and currency changes in valuation
  • Documenting estimate revisions and price target changes

包含的文件(1)

  • SKILL.md3.3 KB

SKILL.md(原文)

安装前可以查看交给 AI 代理的指令内容。

Model 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 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

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.)

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

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

评价

还没有评价。欢迎分享你的使用感受。

评论

无需登录即可发表。欢迎分享使用感受、提问,或说明在哪些环境下无法运行。

还没有评论。来写第一条吧。

提交后会立即公开。请勿填写邮箱、电话等个人信息。URL 最多 2 个。

0 / 1000 字

此表单受 reCAPTCHA 保护,适用 Google 的隐私权政策和服务条款。

同一仓库的技能

Complete an existing financial model template by entering historical data and forecast assumptions, then linking the income statement, balance sheet, and cash flow statement with formulas. Check statement balances, cash consistency, and scenario behavior as each section is completed.

中文简介正在准备中。当前显示英语简介。

  • Complete a partially filled financial model
  • Link forecasts across three financial statements
  • Check balance sheet and cash flow consistency
anthropics/financial-services4万2026年9月22日 更新

Prepare a period-end accrual schedule for expenses incurred but not yet fully recorded. Apply company policy, subtract amounts already booked, cite supporting records, and draft journal entries for controller approval, including reversal notes where required.

中文简介正在准备中。当前显示英语简介。

  • Preparing an accrual schedule for month-end close
  • Calculating audit fee, bonus, or utilities accruals
  • Drafting journal entries with supporting references
anthropics/financial-services4万2026年9月22日 更新

Review quarterly updates and financials across portfolio companies to identify practical AI opportunities. Rank them by estimated profit impact, speed, and feasibility, then outline first steps and approaches that other companies can reuse.

中文简介正在准备中。当前显示英语简介。

  • Quarterly reviews of AI opportunities across portfolio companies
  • Prioritizing companies for AI investment and operational support
  • Finding ways to reuse successful AI projects across companies
anthropics/financial-services4万2026年9月22日 更新

audit-xls

免费

Check spreadsheet formulas for errors, broken references, inconsistent calculations, and unit mismatches. Review a selected range, one sheet, or an entire financial model, then receive findings ranked by severity with suggested fixes.

中文简介正在准备中。当前显示英语简介。

  • Checking formulas in a selected range
  • Investigating a balance sheet that does not balance
  • Reviewing a financial model before client delivery
anthropics/financial-services4万2026年9月22日 更新

Analyze price differences between bond futures and cash bonds, identify the cheapest bond to deliver, and compare implied financing rates with market rates. Present valuation tables and historical context to assess potential basis trades.

中文简介正在准备中。当前显示英语简介。

  • Comparing bond futures with cash bond prices
  • Identifying the cheapest bond to deliver
  • Comparing implied financing rates with market rates
anthropics/financial-services4万2026年9月22日 更新

Assess whether bonds are expensive, cheap, or fairly priced by comparing yields with government rates and credit risk benchmarks. Combine spread breakdowns, historical context, and interest rate scenarios into tables and a recommendation.

中文简介正在准备中。当前显示英语简介。

  • Comparing the relative value of candidate bonds
  • Separating credit risk from other yield differences
  • Estimating gains and losses under interest rate shifts
anthropics/financial-services4万2026年9月22日 更新

查看 anthropics 的全部技能

报告此技能的问题