For equity analysts and PMs who lose three nights a print week to the copy paste between the filing and the model: 12 Claude prompts that roll the quarter, reset the run rate, reconcile guidance against your estimates, and redraft the note before the open, on your own model in your own Claude.
Free — runs in your own ClaudeMedium setup · 4 steps12 ready-to-run prompts
Three minutes, four steps, nothing to install by hand
Claude sets it up for you. You just paste.
Never used Claude? It is free and takes 30 seconds to open. Copy the instruction below, paste it into Claude, and it reads this page and walks you through everything, one question at a time.
1
Tell Claude how to talk to you
One tap. It changes how much Claude explains, and how slowly it goes. You can change it any time.
2
Copy your setup instruction
A short instruction plus a link to this page lands on your clipboard. First copy asks for your email once. That unlocks every button across the whole library.
3
Open Claude in a new tab
Free account, no card, 30 seconds. This tab stays open so you can come back.
Claude reads this page, asks one question about your work, then guides you step by step until your first output is right. If anything looks wrong, tell Claude what you see, and it fixes it with you.
▸Prefer the full prompt instead of the link? (optional)
I am comfortable copy-pasting and following instructions, but I am not a developer.
There is nothing to install for this one and no commands to type: it all happens inside Claude. If any instruction below implies a Terminal, translate it into the equivalent click path for me instead.
- Plain English. Define jargon the first time it appears.
- One step at a time, then wait for me to confirm before the next one.
- Tell me what success looks like at each step, and diagnose any error before moving on.
Follow the instructions below with those rules applied.
If you can browse the web, open and read this page in full first, it has the complete guide and every prompt you will run (the vault is under the-vault anchor): https://consultance.ai/library/earnings-update-kit#the-vault . If you cannot open links, tell me and I will paste the page in, do not guess the prompts.
I want to INSTALL the real setup so Claude runs a post-earnings model update on my actual model and the actual print, not just a chat demo. Walk me through it step by step, do not skip the install. Treat me like a covering analyst, a PM, or a finance lead who has never built a Claude Project or installed an Office add-in, and define every term once.
One honest thing up front: this Kit is about 60% of the build. It reads the print and the transcript you load, rolls your model, and cites every number. The last 40%, wiring live data into the model, enforcing who on the desk sees what, keeping an audit trail your compliance team accepts, and running it across a full multi-name coverage list at production scale, is the proper integration, and that is the part consultance wires into production. You can run the whole update by hand tonight with what is below; the wiring is a call, not a prompt.
This is NOT a Terminal or coding install. There is nothing to compile. It is two paths: a private Claude Project for the print and the model (recommended) and an optional Excel add-in so the roll happens in your real workbook.
## Path 1 (RECOMMENDED) — a private Claude Project for the earnings update
This is where the press release, the 8-K or 10-Q, the earnings deck, the transcript, and your model live so every prompt reads from one governed place.
Walk me through ONE step at a time, waiting for me to confirm each:
1. **What I need.** A Claude account. Pin **Claude Opus 5**. Nothing to install for this path. (Opus 5 is the model name, the current frontier for this work; pin it in the model picker.)
2. **Create the update workspace.** In Claude, create a new **Project** named for the name and the quarter (for example "ACME Q3"). A Project is a private workspace with its own knowledge that other chats cannot see. Your model, your estimates, and your notes stay in your own tenant.
3. **Load the print.** The night the print lands, drop the press release, the 8-K or 10-Q, the earnings deck, and the call transcript into the Project knowledge, along with your prior model if you have it. Public prints, releases, and transcripts only, nothing you are not allowed to hold.
4. **Run the vault.** Run prompt 01, pick the kind of print, the name and quarter, your prior estimates, and your data source (A) upload (or (D) connector if you pull from FactSet, Capital IQ, or Bloomberg under your own access). Then run 02 to 12 in order: read the print, roll the quarter, reset the run rate, reconcile guidance, flag the movers, the reconciliation gate, the CFO call read, the note, the estimate log, the scenarios, and the review-meeting hardening.
5. **Gate it.** Run prompt 07 before the note ships. A reconciliation MISMATCH (a segment table that does not sum, a headline that does not tie, a guidance number quoted wrong) is a number to fix, not a footnote.
6. A named human analyst signs the note. This is a working tool, not investment advice.
## Path 2 (OPTIONAL) — Claude for Excel add-in so the roll happens in your workbook
If I want the quarter to roll into my real model and the full-year to re-tie in live formulas:
1. In Excel (Microsoft 365 desktop or web): **Home** or **Insert** tab, **Add-ins** or **Get Add-ins**, search **"Claude"**, **Add**. Tell me where the button is in my version.
2. Sign in to the docked Claude side panel.
3. In vault prompt 01 choose data source (C) Excel add-in. For prompt 03 (roll the quarter) and prompt 04 (reset the run rate) say "do this in my workbook as real formulas," so the full-year re-ties live and the prompt 07 tie-out runs on live cells.
4. Pin **Claude Opus 5** for the read, the reconciliation, the call, and the note.
## First session after setup — the drill
Once I am set up, do not leave me at a blank prompt. Walk me through the highest-value run:
- **The input:** the press release and the transcript for the name I just got the print on, loaded into the Project, plus my prior estimates for the quarter.
- **First prompt to run:** prompt 01 (the router), then prompt 02 (read the print), then prompt 03 (roll the quarter).
- **What good output looks like:** a print table where every reported figure cites its source and sits next to my prior estimate, a run-rate walk that shows reported to clean to forward, and guidance quoted verbatim next to my own numbers.
- **The check before I trust it:** run prompt 07 (reconciliation self-check). If the headline figures do not tie to the raw release, or a segment table does not sum, or a guidance number is quoted wrong, fix it before the note ships. Status must read RECONCILED.
## Rules for walking me through this
- One step at a time. Define every term once: Project, knowledge, 8-K, 10-Q, run rate, add-back, adjusted vs GAAP, guidance reconciliation, `<review_gate>`, `{{TOKEN}}`.
- Do NOT tell me a step is "not possible." If the Excel add-in is missing, check Excel for Microsoft 365, try Excel on the web, or AppSource. For the Project path there is nothing to install.
- Public prints only. Never paste material non-public information or anything I am not allowed to hold into a public Claude window. Use a Project with your tenant controls.
- A named human analyst signs the note. Claude reads the print and ties the numbers; a person owns the call. Not investment advice.
- The official FactSet, Capital IQ, and Bloomberg docs are a bonus path if I want to wire a live data pull later, never required to run the vault by hand.
First message: ask me "Path 1 (Claude Project for the print and the model, recommended) and do you also want Path 2 (Excel add-in so the roll happens in your workbook)? And which name and quarter are you updating, and is it a clean beat or miss, a messy print, guidance-only, or a name you do not model yet?" Then start step 1.
Step 2 · run it on your data
Step 1 set it up. These 12 prompts do the work.
the vault
The 12 prompts
Grab the whole pack as one file, or tap any prompt below to copy it on its own. Placeholders that look like {{THIS}} get swapped for your own numbers — and if you ran Step 1, Claude fills them in for you.
One .md file · all 12 prompts, numbered, in order · nothing left out.
<role>You are a covering desk in one: a sell-side equity-research analyst who reads the print the second it lands, a buy-side PM who only cares what changed the thesis, and a numbers-discipline lead who ties every figure back to the release. You run a post-earnings model update the way a covering analyst does: read the print, roll the quarter, reconcile guidance against the estimate, and redraft the note before the open.</role>
<onboarding>
Before any analysis, set up the update. Ask me to confirm each block. Offer the options. Do not assume.
1. THE PRINT — what did you just get?
(A) A clean beat or miss on a name you cover, model already built
(B) A messy print (one-offs, restatement, segment reshuffle, changed reporting)
(C) A guidance-only or pre-announcement, no full financials yet
(D) A name you do not model yet and need to stand up a first-pass model fast
2. THE NAME AND THE QUARTER
Ticker or name: {{TICKER}}
Quarter and fiscal period: {{QUARTER}}
Your prior estimates for the quarter (revenue, EPS, the two or three lines you gate the thesis on): {{PRIOR_ESTIMATES}}
The one question this update has to answer for your PM or IC: {{CORE_QUESTION}}
3. WHERE DO THE MODEL AND THE DATA LIVE? Pick all that apply. This decides how the next prompts run.
(A) I will upload the model and the filings (the press release, the 10-Q or 8-K, the earnings deck, the transcript) into this Claude project's knowledge.
(B) I will paste the raw numbers and the transcript passages into the prompt.
(C) I have the Claude add-in for Microsoft Excel and want the roll to happen in my actual workbook.
(D) I pull from a governed data source (FactSet, Capital IQ, Bloomberg, an internal model server) under my own access.
(E) A mix of the above.
4. OUTPUT BAR — confirm: every reported figure is tied to the release or filing and page it came from, every estimate and every rolled-forward number is labeled with its method, guidance is quoted exactly not paraphrased, a number I cannot source is a gap I flag not a number I invent, and the reconciliation gate (prompt 07) must pass RECONCILED before the note ships.
</onboarding>
<rules>
- Reported figures from the release, filing, or transcript only. Never fabricate a revenue, an EPS, or a guidance number. If it is not in the print or my input, ask or label ESTIMATE / DISCLOSURE GAP with the method.
- Match every later prompt to the data source I chose in step 3.
- Quote guidance verbatim. Paraphrased guidance is how a desk gets the range wrong.
- Cite every reported figure back to its source. An uncited number does not ship.
- Always end with "Next step:" and the next prompt to run.
</rules>
Confirm my blocks back to me, then wait for prompt 02.
<role>Covering equity-research analyst reading the release and the 8-K the minute they hit the wire.</role>
<task>
Using the data source from prompt 01:
1. Pull the headline line items for {{TICKER}} {{QUARTER}}: revenue, gross margin, operating margin, EPS (GAAP and adjusted, kept separate), and the two or three segment or KPI lines that carry this name's thesis.
2. Tie each figure to the exact line in the release or filing it came from.
3. Separate reported from adjusted, and list every add-back management used to bridge the two. Adjusted numbers hide the story as often as they tell it.
4. Note anything that changed the shape of the print: a restatement, a segment reclassification, a changed reporting convention, a one-off gain or charge.
</task>
<output_format>A PRINT SUMMARY TABLE: line item, reported, your prior estimate, source citation, adjusted-vs-GAAP flag. Then a short list of anything that changed the shape of the print.</output_format>
<constraints>Use the data source from prompt 01. Reported figures only, each cited. Flag every add-back. Do not net a one-off into the run rate yet, that is prompt 04.</constraints>
<review_gate>Show the print table and the shape-changers before touching the model.</review_gate>
Then "Next step:".
<role>Analyst rolling the actual quarter into a live model without breaking the historicals.</role>
<task>
For the print read in prompt 02:
1. Drop the reported quarter into the model as actuals, replacing your estimate for {{QUARTER}}. Keep the prior estimate visible in a variance column, never overwrite it.
2. Re-tie the full-year: with the reported quarter locked, show what the remaining quarters now have to do to hit the prior full-year number.
3. Flag any historical line the print forces you to restate (a prior-period revision, a reclassified segment) and show the before and after.
4. State the two or three model inputs this print changes most (unit growth, price, a margin driver) and by how much.
</task>
<output_format>A ROLL SUMMARY: the quarter dropped in as actuals, a variance column vs your prior estimate, the re-tied full-year, and the restated historicals if any.</output_format>
<constraints>Use the data source from prompt 01. Preserve the prior estimate as a variance column. If Excel add-in mode, do the roll as real formulas in the workbook so the full-year re-ties live.</constraints>
<review_gate>Confirm the historicals still tie and the prior estimate is preserved in a variance column before resetting the run rate.</review_gate>
Then "Next step:".
<role>Analyst resetting the forward run rate now that the quarter is in.</role>
<task>
With the quarter rolled in prompt 03:
1. Strip the one-offs out of the reported quarter to get the clean run-rate base: back out non-recurring gains, one-time charges, and any pull-forward or push-out management called out on the release.
2. Reset the forward run rate off the clean base, not the headline. Show the walk from reported to clean to forward.
3. Adjust the go-forward growth and margin path for what the print actually revealed, not what you assumed going in.
4. State the new run-rate revenue and margin and the one assumption they hang on.
</task>
<output_format>A RUN-RATE WALK: reported quarter, one-offs stripped, clean base, forward run rate, and the single load-bearing assumption.</output_format>
<constraints>Use the data source from prompt 01. Every one-off you strip must be one management named or the filing disclosed, not one you invented to make the run rate cleaner. Label each.</constraints>
<review_gate>Show the reported-to-clean-to-forward walk. A run rate reset off the headline instead of the clean base is the classic earnings-night error, name it if you see it.</review_gate>
Then "Next step:".
<role>Analyst putting management's new guidance next to your own numbers line by line.</role>
<task>
Using the data source from prompt 01:
1. Pull the new guidance verbatim: revenue, margin, EPS, and any segment or KPI guide. Quote it exactly, with the range and the assumptions management attached.
2. Lay it line by line against your reset run rate from prompt 04. Where does management sit above, below, or on your number?
3. For every gap, state whether the delta is a real disagreement (you and management see the business differently) or a convention difference (tax rate, share count, an accounting treatment).
4. Flag the one or two guidance lines where you are far enough from management that the thesis turns on who is right.
</task>
<output_format>A GUIDANCE RECONCILIATION TABLE: guidance line (quoted), your number, delta, disagreement-vs-convention flag, thesis-relevance flag.</output_format>
<constraints>Use the data source from prompt 01. Guidance quoted verbatim, never paraphrased. A paraphrased guide is a misquoted guide. Cite the release or transcript line for each guidance figure.</constraints>
<review_gate>Confirm every guidance figure is quoted verbatim with its source before flagging disagreements.</review_gate>
Then "Next step:".
<role>PM cutting through the print to the two numbers that actually decide the position.</role>
<task>
From everything in prompts 02 to 05:
1. Rank the movers: which two or three numbers in this print actually change the thesis, not the ten that changed but do not matter.
2. For each mover, state the old view, the new view, and the size of the swing in the terms your PM or IC thinks in (target, rating, position size).
3. Separate signal from noise: name the two or three headline surprises that are actually noise (one-off, optics, a beat driven by a lower tax rate) so they do not hijack the note.
4. State whether the thesis holds, tightens, or breaks on this print, in one line.
</task>
<output_format>A THESIS MOVERS block: the two or three real movers with old view, new view, swing; then the surprises-that-are-noise list; then the one-line thesis verdict.</output_format>
<constraints>Use the data source from prompt 01. A mover must trace to a number reconciled in prompts 02 to 05. Do not promote a number to a mover on narrative alone.</constraints>
<review_gate>Name the movers and the noise before writing a word of the note.</review_gate>
Then "Next step:".
<role>The numbers-discipline lead who re-derives the update a second way and hard-stops on any mismatch.</role>
<task>
Re-derive the update independently, from the raw print, not from the rolled model:
1. Recompute the headline figures (revenue, margin, EPS) straight from the release and check them against what the rolled model in prompt 03 shows. They must match to the dollar or the cent.
2. Re-sum the segments and confirm they tie to the reported total. A segment table that does not sum is a modeling error, not a rounding note.
3. Re-check the guidance reconciliation: confirm every guidance figure quoted in prompt 05 matches the release or transcript exactly.
4. Confirm every one-off stripped in prompt 04 was actually disclosed, and that no reported number was quietly changed in the roll.
5. Return a single status: RECONCILED (everything ties) or MISMATCH (with the exact line that breaks).
</task>
<output_format>A RECONCILIATION REPORT: each check, PASS or FAIL, the two figures compared where relevant. End with the single status word: RECONCILED or MISMATCH.</output_format>
<constraints>Use the data source from prompt 01. Re-derive from the raw print, do not trust the rolled model as your source, that defeats the check. Any FAIL makes the overall status MISMATCH. The note does not ship on MISMATCH.</constraints>
<review_gate>This is the hard gate. If the status is MISMATCH, stop, name the broken line, and fix it before prompt 08. Do not let a note pass this gate on a FAIL.</review_gate>
Then "Next step:".
<role>Analyst mining the earnings call for the sentence that moves the forward view.</role>
<task>
Using the transcript from prompt 01:
1. Find the one or two things management said on the call that change the outlook beyond what the release already showed: a demand comment, a pricing signal, a margin-path change, a capital-allocation shift, a walk-back.
2. Quote the exact sentence, with the speaker and the section (prepared remarks vs Q&A). A signal from an unscripted Q&A answer carries differently than one from the scripted deck.
3. Separate the durable signal from the reassurance boilerplate. Flag any place management dodged an analyst's direct question, the dodge is often the tell.
4. State how each quote changes the forward view, if at all.
</task>
<output_format>A CALL SIGNAL block: the one or two outlook-moving quotes (verbatim, with speaker and section), the dodge list, and the forward-view impact of each.</output_format>
<constraints>Use the data source from prompt 01. Quote verbatim from the transcript, with speaker attribution. Do not summarize a quote into a paraphrase, the exact words are the signal.</constraints>
<review_gate>Confirm each quote is verbatim and attributed before you let it change the note.</review_gate>
Then "Next step:".
<role>Covering analyst writing the post-print note the desk reads before the market opens.</role>
<task>
Pull prompts 02 to 08 into the note in your house format:
1. Lead with the verdict: beat or miss, thesis holds or turns, rating and target action, in the first three lines. The PM reads three lines, then decides whether to read the rest.
2. Walk the print: the movers from prompt 06, the run-rate reset from prompt 04, the guidance reconciliation from prompt 05, the call signal from prompt 08.
3. State what you changed in the model and why, and what you are still waiting on (the 10-Q detail, the next data point).
4. Close with the forward setup: the next catalyst, the level the thesis breaks at, and the one thing you are watching.
</task>
<output_format>THE NOTE in your house format: verdict headline, the walk, the model changes, the forward setup. Tight enough to read before the open.</output_format>
<constraints>Use the data source from prompt 01. Every number in the note traces to a prompt-02-to-08 output that passed the prompt-07 gate. No number in the note that is not RECONCILED. A named human analyst signs before it reaches a PM, an IC, or a client.</constraints>
<review_gate>Confirm the note carries only RECONCILED numbers and that the verdict is in the first three lines before it goes out.</review_gate>
Then "Next step:".
<role>Analyst keeping the coverage book and the estimate history clean after the update.</role>
<task>
Now that the note is out:
1. Log the estimate change: prior estimate, new estimate, the delta, and the one-line reason, for revenue, EPS, and the two or three thesis lines. An estimate change with no reason is a number nobody can defend later.
2. Update the coverage summary line for {{TICKER}}: rating, target, the new key numbers, the date of this update.
3. Note what to carry into next quarter: the guidance line to test, the KPI to watch, the assumption that is now on the clock.
4. Flag any downstream model that consumes this name (a sum-of-the-parts, a portfolio roll-up, a screen) that now needs re-running.
</task>
<output_format>An ESTIMATE CHANGE LOG (prior, new, delta, reason per line) and an updated coverage summary line, plus the carry-forward watch list.</output_format>
<constraints>Use the data source from prompt 01. Every estimate change gets a reason. Reference the note from prompt 09 as the source of record.</constraints>
<review_gate>Confirm every changed estimate has a logged reason before closing the update.</review_gate>
Then "Next step:".
<role>Analyst pre-building the scenarios the PM asks for the second they read the verdict.</role>
<task>
Off the reset run rate from prompt 04:
1. Build the two scenarios that matter for {{TICKER}} after this print: the bull case (the guidance line management sandbagged actually lands high) and the bear case (the disagreement in prompt 05 goes management's way, not yours).
2. For each, show the swing in EPS, target, and the one driver that carries the case.
3. State the probability you would put on each, honestly, and what data point between now and next print would move that probability.
4. Give the PM the position-sizing read: does the risk-reward after this print argue for adding, trimming, or holding.
</task>
<output_format>A TWO-SCENARIO block: bull and bear, each with EPS and target swing, the load-bearing driver, your probability, and the position read.</output_format>
<constraints>Use the data source from prompt 01. Both scenarios anchor to the reconciled run rate, not a fresh set of numbers. Label every scenario input as an assumption with its method.</constraints>
<review_gate>Confirm both scenarios trace to the reset run rate before the position read.</review_gate>
Then "Next step:".
<role>The skeptic across the table: the PM, the IC member, the director of research who signs the rating.</role>
<task>
Stress the update before you defend it live:
1. Generate the ten hardest questions a sharp reader asks after this print (Is that beat real or a tax-rate beat? Why did you keep the target when guidance came down? Is that margin durable or a one-off? What breaks your thesis?).
2. Answer each from the reconciled numbers in the update, or mark it a known gap with the honest bound.
3. Flag the two places the update is weakest and what one filing detail or data point would firm them up.
4. Produce the short defensibility note: the sources, the estimates and their method, the reconciliation status, and the named human sign-off line.
</task>
<output_format>A DEFENSE PACK: the ten questions with sourced answers, the two weak spots, and the defensibility note with the sign-off line.</output_format>
<constraints>Use the data source from prompt 01. Answer from the update's own reconciled numbers. A weak spot named honestly beats a confident bluff, mark the gaps.</constraints>
<review_gate>List every remaining gap in its own block. The update goes to the meeting with the gaps disclosed, never hidden.</review_gate>
Then "Next step:".
Got the prompts. Want them wired into your actual stack? We map that on a free AI audit.
For equity analysts and PMs who lose three nights a print week to the copy paste between the filing and the model: 12 Claude prompts that roll the quarter, reset the run rate, reconcile guidance against your estimates, and redraft the note before the open, on your own model in your own Claude.
Path A · free
You just did it
The setup rail and every prompt above are free and stay free. The cost is your time, and the risk of wiring it wrong on live data.
• Run last quarter's numbers first. Live data is not a test bed.
• Nothing here uploads to us. It runs in your own Claude account, on your own machine.
• A named human reviews and signs every output before it reaches a board, lender, or client.
• Mask account numbers and names to the minimum the task needs.
the fine print
Straight answers on ownership
Prompt set and build authored by consultance.ai. FactSet, Capital IQ, and Bloomberg are referenced as the incumbent tooling this runs alongside, no affiliation implied. The Kit reads public prints, releases, and transcripts only; your model, estimates, and notes stay in your own Claude tenant and we never see them. This is not investment advice; a named human analyst signs every note before it reaches a PM, an IC, or a client.
Want this running in your business, not just your laptop? We build it and hand you the keys.
Post Earnings Model Update Kit is a finance and data build in the consultance.ai AI Build Library. For equity analysts and PMs who lose three nights a print week to the copy paste between the filing and the model: 12 Claude prompts that roll the quarter, reset the run rate, reconcile guidance against your estimates, and redraft the note before the open, on your own model in your own Claude. It fits Equity research analysts, buy side PMs and associates, family office and PE public markets teams, and finance leaders who cover names through earnings season and want the post print model update done in one morning instead of three all nighters, without the work ever leaving their tenant. Setup difficulty is Medium, with 4 plain-English steps.
What does Post Earnings Model Update Kit do?
For equity analysts and PMs who lose three nights a print week to the copy paste between the filing and the model: 12 Claude prompts that roll the quarter, reset the run rate, reconcile guidance against your estimates, and redraft the note before the open, on your own model in your own Claude.
Who is Post Earnings Model Update Kit for?
It fits Equity research analysts, buy side PMs and associates, family office and PE public markets teams, and finance leaders who cover names through earnings season and want the post print model update done in one morning instead of three all nighters, without the work ever leaving their tenant.
How hard is Post Earnings Model Update Kit to set up?
Medium to set up — one guided setup instruction covering 4 plain-English steps, plus 12 ready-to-run prompts on the resource page.
How would consultance.ai build this out?
The Kit is about 60% of the build, a reconciled, sourced, defensible first draft you can run by hand tonight. We wire the last 40% into production: a live data feed that pulls the release, the filing, and the transcript the second they hit the wire and drops the numbers into the model, role based access so only the right analyst sees the right name, an audit trail your compliance team accepts under FINRA 2241 and SEC 17a-4, and the queue to run it across a full multi name coverage list at earnings season scale. Done with you, then handed over so you own it.
What are the licensing terms?
Prompt set and build authored by consultance.ai. FactSet, Capital IQ, and Bloomberg are referenced as the incumbent tooling this runs alongside, no affiliation implied. The Kit reads public prints, releases, and transcripts only; your model, estimates, and notes stay in your own Claude tenant and we never see them. This is not investment advice; a named human analyst signs every note before it reaches a PM, an IC, or a client.
Want this built into your workflow?
Post Earnings Model Update Kit is the starting point. On a free AI audit we map where it fits your stack and what consultance.ai would build around it.