Skip to main content

​
What is Model Maintenance?

A financial model is a spreadsheet that projects a company’s future revenue, expenses, earnings, and cash flow based on a set of assumptions. Equity research analysts build these models when they initiate coverage, then maintain them every quarter as new data comes in — actual earnings results, updated management guidance, changed macro conditions, or new competitive dynamics. Model maintenance matters because your financial model is the foundation for your price target and investment recommendation. If your model is stale (using old assumptions that no longer reflect reality), your price target is meaningless and your investment advice is unreliable. After every earnings release or material event, the model needs to be refreshed.
Model updates are not just about plugging in new numbers. The real value is in understanding why actuals differed from your estimates. Did you underestimate pricing power? Overestimate volume growth? Miss a margin headwind? This analysis is what improves your forecasting accuracy over time.

​
Command Syntax

/model-update [company ticker]
If a ticker is not provided, the command asks: “Which model would you like to update and what changed?”

​
What Triggers a Model Update

Earnings Release

Plug in new quarterly actuals for every line item, segment detail, balance sheet, and cash flow changes.

Guidance Change

Company updated its forward outlook — revise revenue, margin, and EPS estimates to reflect new guidance.

Estimate Revision

Analyst changing assumptions based on new data points, channel checks, or macro changes.

Event-Driven

M&A announcement, restructuring, new product launch, or management change requiring assumption updates.

​
What It Produces

  • Updated Excel model (if the user provides the existing model file)
  • Estimate change summary (markdown or Word) showing old vs. new estimates
  • Updated price target derivation with methodology

​
How to Customize

  • To match your firm’s model template structure, edit the model-update skill file
  • To connect to your existing Excel models stored in a shared drive, configure file access in .mcp.json