HomeLibraryServicesCase studiesBlogAbout
consultance.ai
Book a discovery call →

Services

  • AI consulting
  • AI implementation
  • AI agents
  • Workflow automation
  • RAG systems
  • Voice AI
  • Custom AI development
  • All services

Library

  • AI build library
  • Finance AI automation
  • AiToEarn content agent
  • Fincept Terminal
  • ERPNext
  • SEO + GEO Claude skill
  • Claude for Legal
  • Free Claude Code proxy

Resources

  • Case studies
  • Blog
  • Industries
  • Locations
  • Guide: AI for property management
  • Guide: AI for marketing agencies
  • Guide: AI agents vs Zapier
  • AI glossary
  • vs traditional consulting

Company

  • About
  • Book a call
  • Contact
  • Privacy
  • Terms

© 2026 consultance.ai · AI, implemented.

audit → build → deploy

← Libraryconsultance.ai
Book a build call
Finance and data

Explain a Fed Rate Move to Your Board

For CFOs and treasurers who get the "what does the Fed move do to us" email: turn a rate decision and CPI print into a sourced board paragraph, with the cost on your floating debt.

Free — runs in your own ClaudeEasy setup · 5 steps13 ready-to-run prompts
Set it up free — takes 3 minutes ↓Or have us wire it in →
watch first

How to run these prompts

A short walkthrough of the exact mechanic: where the prompts go, what to answer when the first one asks, and what a good first output looks like. Same for every pack in the library.

Step 1 · setup
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. 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. 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. 3

    Open Claude in a new tab

    Free account, no card, 30 seconds. This tab stays open so you can come back.

    Open claude.ai ↗
  4. 4

    Paste, send, and answer one question

    Claude reads this page, asks which computer you are on, then guides you step by step until it works. If anything errors, tell Claude what you see, and it fixes it with you.

▸Prefer the full prompt instead of the link? (optional)
Click to copy
I am comfortable copy-pasting and following instructions, but I am not a developer.
- 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/macro-board-question#the-vault . If you cannot open links, tell me and I will paste the page in, do not guess the prompts.

I want to set up the Fed rate move board brief pack. It pulls public rate and inflation data from FRED (the free economic database run by the Federal Reserve Bank of St. Louis), ties each figure to the official Fed or BLS release, and works out what the move does to my own floating debt, hedges and covenants, then drafts the one paragraph my board asked for. Walk me through it one step at a time and wait for my answer before moving on. Define every term once. I may not be a developer.

## Step one, ask me this first, nothing else
"Do you want to start with no install at all (download a few CSV files from FRED and upload them), connect the free FRED data tool to the Claude desktop app so Claude can pull any series itself, or run it in Claude Code because you have a folder of loan documents or want it monthly?"

Wait for my answer. Then pick the path, tell me which one and why. If I am unsure, start me on Path A: it works today, on any plan, and I can add the data tool later.

## Path A, no install (Claude app plus CSV downloads). Not a Terminal install.
1. Open claude.ai or the Claude desktop app. In the left sidebar click Projects, then + New Project. Name it Rate Brief. If Claude Opus 5.5 is not in my model picker, tell me my plan does not include it.
2. Privacy first. My documents go only to my own Claude account, never to the author of this pack. Before I load a credit agreement, use a Team or Enterprise plan, or on a personal plan turn off "Help Improve our AI models" under Settings, Privacy.
3. Download the public data. Each link downloads a CSV file straight from FRED:
   - Inflation, headline, core and gasoline: https://fred.stlouisfed.org/graph/fredgraph.csv?id=CPIAUCSL,CPILFESL,CUUR0000SETB01,CUSR0000SETB01
   - Policy range: https://fred.stlouisfed.org/graph/fredgraph.csv?id=DFEDTARU,DFEDTARL
   - Daily rates: https://fred.stlouisfed.org/graph/fredgraph.csv?id=EFFR,SOFR,DGS2,DGS10
   If a link hands me a .zip instead of a .csv, unzip it and upload the CSV files inside.
4. Gather my own files: the debt schedule, the credit agreement (at least the definitions, interest and financial covenant sections), the latest lender rate-set notices, and any swap or cap confirms. Add them and the CSVs to the Project with the + button in Project knowledge.
5. Pick Claude Opus 5.5 in the model picker. Paste prompt 01 from the page into a new chat in the Project and answer its questions (pick public data path B, CSV downloads). Then paste prompt 02, the calibration run, and check for eleven MATCH lines before my own figures.

Do NOT tell me any of this is "not possible" in the app. A few CSVs and a credit agreement is exactly what a Project handles. If I paste a file path or folder name instead of a file, tell me that is a Claude Code job and switch to Path C.

## The free FRED API key (Paths B and C need it, Path A does not)
An API key is a password-like code that lets a program pull FRED data for me. It is free.
1. Go to https://fredaccount.stlouisfed.org/apikeys . FRED says you cannot request or view API keys without first logging in to a fredaccount user account, so log in, or create the account first.
2. Request an API key. The key is a 32 character string of lower case letters and numbers. Copy it somewhere private. Never paste it into a chat, a shared document or a public place.

## Path B, the Claude desktop app with the FRED data tool
The data tool is a small program (an MCP server, a connector that lets Claude call a data source) that runs on my own computer and lets Claude pull any of FRED's series when I ask in plain English.
1. It needs Node.js 18 or newer (the program that runs it). Check in Terminal (Mac) or PowerShell (Windows): `node --version` . If it says "command not found" or a number below 18, install the LTS version from https://nodejs.org and open a new terminal.
2. Install the tool, one command: `npm install -g fred-mcp-server` . Check it: `npm ls -g fred-mcp-server` should show fred-mcp-server@1.2.0 or newer. If the Mac says "permission denied", tell me and I will walk you through fixing npm's folder permissions rather than using sudo.
3. Find the file Claude will start. Important: in version 1.2.0 the plain `fred-mcp-server` command starts and exits silently without serving anything (a known upstream bug, fixed in the source but not yet published), so we point Claude at the file directly.
   - Mac: `echo "$(npm root -g)/fred-mcp-server/build/index.js"`
   - Windows PowerShell: `echo "$(npm root -g)\fred-mcp-server\build\index.js"`
   Copy the full path it prints. That is my INDEX_PATH.
4. Open the Claude desktop app. Click the Claude menu in the system menu bar (not the settings inside the Claude window) and select "Settings...". In the Settings window open the "Developer" tab in the left sidebar and click "Edit Config". That opens claude_desktop_config.json (on Mac ~/Library/Application Support/Claude/claude_desktop_config.json, on Windows %APPDATA%\Claude\claude_desktop_config.json).
5. Paste this, replacing the two placeholders, and save. On Windows write the path with forward slashes (C:/Users/me/AppData/Roaming/npm/node_modules/fred-mcp-server/build/index.js) or double backslashes. If the file already has an "mcpServers" block, add the "fred-mcp" entry inside it instead of pasting a second block:
```json
{
  "mcpServers": {
    "fred-mcp": {
      "command": "node",
      "args": ["INDEX_PATH"],
      "env": {
        "FRED_API_KEY": "your_actual_api_key_here"
      }
    }
  }
}
```
6. Completely quit Claude Desktop and restart it. Then click the "Add files, connectors, and more /" indicator in the bottom left of the message box, move to "Connectors" and click "Manage connectors". I should see fred-mcp.
7. Test it: ask "Pull CPILFESL for the last 13 months with units pc1". Claude should call a tool named fred_get_series. Then make the Project as in Path A steps 1, 2, 4 and 5 (pick public data path A, the data tool).
Debug, in order:
- fred-mcp missing or "failed": check the JSON for a missing comma or brace.
- Claude cannot find node: replace "node" with the full path from `which node` (Mac) or `where node` (Windows).
- The server starts and quits with no error: the config still says "command": "fred-mcp-server", or INDEX_PATH runs through a shortcut folder. Use the node form above; on Mac get the real folder with `cd "$(npm root -g)" && pwd -P` and rebuild INDEX_PATH from it.
- Manual test in a terminal: `FRED_API_KEY=your_key node INDEX_PATH` should sit waiting with no prompt (press Ctrl+C to stop). If it returns straight to the prompt, it is the silent exit above.

## Path C, Claude Code (a folder of loan documents, several entities, or every month)
Claude Code runs on my own machine and reads my files off disk. It needs a Pro, Max, Team, Enterprise or Console plan.
1. Install it, one command, then wait for it to finish:
   - Mac or Linux, in Terminal: `curl -fsSL https://claude.ai/install.sh | bash`
   - Windows, in PowerShell: `irm https://claude.ai/install.ps1 | iex`
   Success looks like `claude --version` printing a version number.
2. Install the FRED tool as in Path B steps 1 and 2, then connect it to Claude Code for every project with one command, replacing YOUR_KEY:
   - Mac or Linux: `claude mcp add --env FRED_API_KEY=YOUR_KEY --transport stdio --scope user fred -- node "$(npm root -g)/fred-mcp-server/build/index.js"`
   - Windows PowerShell: `claude mcp add --env FRED_API_KEY=YOUR_KEY --transport stdio --scope user fred -- node "$(npm root -g)\fred-mcp-server\build\index.js"`
3. Check it: `claude mcp list` should show `fred: ... - ✔ Connected`. Inside a Claude Code session, type `/mcp` to see it in the panel. "✘ Failed to connect" usually means the command points at `fred-mcp-server` instead of `node` plus the file path: remove it with `claude mcp remove fred --scope user` and add it again with the line above.
4. Put my documents in a folder, open a terminal in that folder and type `claude`. Paste prompt 01, then prompt 02. For the monthly refresh, prompt 13 writes the project, installs pinned pandas, requests and pytest, writes the tests first and makes next month one command. It reads my key from the FRED_API_KEY environment variable, never from a file.

## First session drill, whichever path
1. Prompt 01: give the board's question word for word.
2. Prompt 02: eleven MATCH lines, with the term loan and the October 2025 figure reading OPEN. That proves the pack refuses rather than guesses.
3. Prompts 03 to 06 on my own documents. Good output: an exposure table with a source for every cell, and a cost bridge a controller can re-derive by hand.
4. Prompt 10 then 11. Before I trust it: pick one figure in the paragraph and check it against the Fed statement or the BLS release myself.
5. If this becomes monthly, Path C and prompt 13.

The FRED data tool is free and is used under its own license (AGPL-3.0). It is not affiliated with the Federal Reserve. The pack works without it on Path A.
Step 2 · run it on your data

Step 1 set it up. These 13 prompts do the work.

the vault

The 13 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 13 prompts, numbered, in order · nothing left out.
Click to copy
<role>Treasury and FP&A colleague who has written the "what does the Fed move do to us" note many times. Neutral and plain: the board gets what happened, what it does to this company, and what is not yet known. You never forecast rates.</role>

<objective>One defensible paragraph that answers the board's question: macro figures tied to the official release, company figures from the human's own documents, arithmetic a controller can re-derive in five minutes.</objective>

<privacy>Nothing in this pack is hosted by its author. Your documents go only to your own Claude account, never to us. Before loading a credit agreement or anything confidential, use a Team or Enterprise plan, or a personal plan with model training turned off in Settings, Privacy.</privacy>

<surface>
First, in one short paragraph, say whether the human is in the right place.
- One company, a few facilities, a credit agreement and a debt schedule they can upload: Claude app, a private Project. Chat is correct here.
- A folder of facility agreements, rate-set notices and hedge confirms, several entities, or the same brief every month: Claude Code pointed at the folder (prompt 13 builds the monthly refresh).
MODEL: Claude Opus 5.5 for every prompt. Claude Sonnet 5 only for a first read of a very large set of credit documents. Never switch model inside a prompt.
DATA: public series come from FRED in one of three ways the human picks in onboarding. Company figures come only from the human's files.
WHOLE-PACK STOPS: the human pastes a file path or folder listing instead of content (that is a Claude Code job: name it and stop); the credit documents arrive truncated or larger than you can hold (say which are missing, refuse to compute from part of them); the same brief is needed across many entities by hand (Claude Code). Advise, do not apologise, do not continue past a whole-pack stop.
ITEM STOPS never end the run: a missing drawn balance, floor, reset date, hedge term or series value. Name the document that holds it, ask once, mark every figure that depends on it OPEN, finish the rest.
</surface>

<onboarding>
Ask one block at a time and wait.
1. THE QUESTION, verbatim, and who asked (board, audit chair, lender, CEO). Deadline.
2. THE EVENT: (A) a Fed rate decision (B) an inflation print (C) both. Date of the event.
3. PUBLIC DATA PATH: (A) FRED data tool connected in Claude (https://github.com/stefanoamorelli/fred-mcp-server, installed with npm and started as node plus the path to build/index.js, per the guided setup); (B) CSV downloads from fred.stlouisfed.org uploaded here; (C) paste the values from the release pages; (D) Claude Code with the refresh script from prompt 13; (E) a mix.
4. COMPANY DATA: (A) upload to the Project: debt schedule, credit agreement or its interest and definitions sections, latest rate-set notices, hedge confirms, cost mix; (B) paste; (C) the Claude for Excel add-in, if the debt schedule lives in a workbook you keep open (Pro, Max, Team or Enterprise plans); (D) a folder, so Claude Code; (E) a mix.
5. TOKENS: {{COMPANY}} {{FISCAL_YEAR_END}} {{AS_OF_DATE}} {{AUDIENCE}} {{DAY_COUNT}} (default actual/360 for SOFR loans, read the agreement) {{COVENANTS}} (names and levels as defined in the agreement) {{SCENARIOS}} (moves the human wants shown, for example plus 25 and minus 25 basis points; optional). {{MATERIALITY}} (default 5 percent of a cost figure). {{PROJECT_DIR}} (only for prompt 13).
6. MODE: (A) CONVERSATION, default: run only what the question needs (a cost question: 03, 05, 06, 10, 11; an inflation question: 03, 04, 08, 10, 11). (B) FULL BRIEF: 02, then 03 to 12 in order.
Output bar, confirm it: every figure sourced, every assumption labelled, OPEN where a document is missing.
</onboarding>

<series_map>
Use these FRED series IDs unless the human names others. Always record the units transform, SA or NSA, the observation date and the pull date.
Policy: DFEDTARU and DFEDTARL (target range bounds, daily), EFFR (effective fed funds, daily), FEDFUNDS (monthly average).
Loan benchmarks: SOFR (daily). CME Term SOFR is licensed and is not taken from FRED: its value comes from the lender's rate-set notice.
Treasuries: DGS2, DGS10 (daily, percent).
Inflation: CPIAUCSL (CPI all items, SA index), CPILFESL (core CPI, SA index), CPIAUCNS (all items, NSA index), CUUR0000SETB01 and CUSR0000SETB01 (gasoline, NSA and SA index), PCEPI and PCEPILFE (PCE and core PCE, the measures the Fed targets). Not sure of an ID: search by plain English name through the data tool, or on fred.stlouisfed.org, and confirm the title and units before using it.
Transforms: pc1 = percent change from a year ago, pch = percent change from the prior period, lin = the level. When a tool is not connected, compute from index levels and show the division.
</series_map>

<evidence_tiers>
TIER 1: the Federal Reserve statement, the BLS release text, the credit agreement, a lender rate-set notice, a hedge confirm, the audited debt note.
TIER 2: a FRED series value, the company debt schedule, the treasury system export.
TIER 3: an old board deck, a bank's market note, a news article, a figure in an email. It generates a question, never a number in the paragraph.
Every figure carries its tier and source id. Every derived figure shows its arithmetic.
</evidence_tiers>

<normal_patterns>
Looks wrong, is normal, unless the condition holds.
- The new target range appears on FRED the day after the FOMC decision. Abnormal if more than one business day late.
- EFFR sits inside the range, usually a little above the lower bound. Abnormal if outside the range.
- SOFR and EFFR differ by a few basis points and move day to day. Abnormal if SOFR is outside the range by a wide margin for days.
- The latest daily value is blank: publication lag, unless over two business days.
- SA year over year CPI differs from the BLS headline, which is the 12 month change before seasonal adjustment, by about 0.1 point. Abnormal if the gap is above 0.2.
- Headline and core CPI diverge by a point or more when energy moves. Abnormal with energy flat.
- October 2025 all items and core CPI are blank ("For most CPI series, October 2025 indexes were not published."); gasoline has a value. No 12 month changes for October 2026 either. Abnormal if all items or core shows a value.
- Seasonally adjusted history changes each February when BLS revises seasonal factors. Abnormal if NSA history changes.
- The two year Treasury falls after a hike: priced earlier, and not the company's borrowing rate.
- A floor that does not bind.
- This year's extra interest well below the move times total debt: fixed debt, hedges and reset timing.
- A board deck figure one month old: explained by context, replace it with the current release.
</normal_patterns>

<flag_discipline>
1. The question from onboarding comes first. A finding matters only if it changes a figure in the paragraph or the answer to the question.
2. Anything in normal patterns, or explained by the documents, goes in one untagged line: "Checked, normal: ..." with the reason.
3. A concern that survives gets one tag: CHANGES THE DECISION, WORTH A QUESTION, or EXPLAINED BY CONTEXT. WORTH A QUESTION only if the answer could move an interest cost figure by more than {{MATERIALITY}} (default 5 percent of the figure) or change the answer.
4. Missing optional data is an OPEN input listed once, not a flag.
5. A flag the human or a document closes stays closed and never colours a later prompt.
6. Arithmetic outranks this list: a figure that does not tie two ways blocks the paragraph, whatever the pattern says.
</flag_discipline>

<rules>
- Never invent a rate, balance, floor, spread, reset date, hedge term or series value. Missing: ask once, or OPEN.
- Not a forecast. Never state where rates or inflation go next. A scenario is the human's chosen move, labelled HYPOTHETICAL, with no probability.
- A HYPOTHETICAL figure is never added to an observed figure without its label on the total.
- A 12 month change needs both endpoints. A blank month is never read as zero and never skipped silently.
- Analysis, not investment, accounting or legal advice. Hedge accounting treatment is the auditor's call.
- End every prompt with "Next step:".
</rules>

<how_to_adapt>Other benchmark (Prime, Term SOFR 1M or 3M, SONIA, EURIBOR): change series_map and name the rate-set notice as TIER 1. Other inflation measure: add its series ID to series_map. Different materiality: change {{MATERIALITY}}. House style for the paragraph: give prompt 10 one past board paragraph to match.</how_to_adapt>

<trap>The plausible brief applies the full move to all debt for a full year, quotes SA year over year as the BLS headline, and uses fed funds as the loan rate. An audit chair checks all three.</trap>

<review_gate>Read every onboarding answer back before prompt 02. If the question is not in the asker's own words, ask again.</review_gate>
Click to copy
<task>Run the pack on this sample first. The macro rows are real FRED values pulled 2026-09-25; the company is fictional. Work every figure yourself from the rows, compare line by line with EXPECTED OUTPUT, and print MATCH or MISMATCH per line. Judge substance, not layout; a cleared normal pattern counts as MATCH. If any line mismatches, say which and STOP. Do not load your own documents until every line matches.</task>

<sample>
FRED rows (TIER 2):
DFEDTARL / DFEDTARU: 2026-09-16 3.50 / 3.75; 2026-09-17 3.75 / 4.00.
EFFR: 2026-09-16 3.63; 2026-09-17 3.88. SOFR: 2026-09-16 3.62; 2026-09-17 3.85.
DGS2: 2026-09-16 4.74; 2026-09-17 4.67.
CPIAUCSL (SA index): 2025-08 323.291; 2025-10 blank; 2026-07 332.813; 2026-08 334.131.
CPILFESL (SA index): 2025-08 329.700; 2025-10 blank; 2026-07 336.789; 2026-08 337.765.
Release text (TIER 1): Fed statement 2026-09-16 "raise the target range for the federal funds rate by 1/4 percentage point to 3-3/4 to 4 percent". BLS 2026-09-11 "Over the last 12 months, the all items index increased 3.4 percent before seasonal adjustment." "The all items less food and energy index rose 2.4 percent over the year, following a 2.5-percent increase over the 12 months ending July."
Company Q (fictional). Fiscal year ends 2026-12-31. Day count actual/360; days counted from the reset date to 2026-12-31 inclusive.
Revolver: 40,000,000 drawn, daily simple SOFR plus 2.00 percent, SOFR floor 0 percent, resets daily, no lookback in this sample.
Term loan: 60,000,000, 3 month CME Term SOFR plus 2.25 percent, floor 0.50 percent, next rate set 2026-10-15. No rate-set notice provided.
Swap: 30,000,000 notional against the term loan, company pays fixed 3.10 percent, receives 3 month Term SOFR, matures 2028-06-30.
Old board deck (TIER 3): "Core inflation 2.5 percent."
Board question: "What does the hike do to our interest cost this year, and what was core inflation over the 12 months to October 2025?"
</sample>

<expected_output>
E1 POLICY: range 3.50 to 3.75 becomes 3.75 to 4.00, ties to the statement. Shows on FRED from 2026-09-17: Checked, normal (effective the day after the decision).
E2 BENCHMARKS: EFFR 3.63 to 3.88, plus 25 bp, inside the range: Checked, normal. SOFR 3.62 to 3.85, plus 23 bp. The loan rate is SOFR, not EFFR.
E3 HEADLINE CPI: 334.131 / 323.291 minus 1 = 3.353 percent SA year over year. BLS headline 3.4 percent is NSA; gap about 0.05 point: Checked, normal. The paragraph quotes 3.4 percent with the release as source.
E4 CORE CPI: 337.765 / 329.700 minus 1 = 2.446 percent, rounds to 2.4, ties to the release. Month: 337.765 / 336.789 minus 1 = 0.290 percent.
E5 OLD DECK: "2.5 percent" is July's 12 month core rate from the same release: EXPLAINED BY CONTEXT, replace with 2.4. Raising it as an error is a MISMATCH.
E6 REVOLVER: floor 0 does not bind: Checked, normal. 40,000,000 x 0.0023 x 106 / 360 = 27,088.89 this fiscal year at the 2026-09-17 SOFR held flat (observed level, not a forecast). Full 12 months: 40,000,000 x 0.0023 x 365 / 360 = 93,277.78.
E7 TERM LOAN: Term SOFR comes from the rate-set notice, which is missing: the post-reset rate is OPEN. Net floating = 60,000,000 minus 30,000,000 swapped = 30,000,000. If the human asks for an illustration: 30,000,000 x 0.0025 x 78 / 360 = 16,250.00, labelled HYPOTHETICAL. Using the SOFR or EFFR move as the term loan's new rate without the label is a MISMATCH.
E8 SWAP: the swapped 30,000,000 is fixed at 3.10 plus the 2.25 margin; the hike does not change its cost: Checked.
E9 TWO YEAR TREASURY: fell from 4.74 to 4.67 the day after a hike: Checked, normal, and not a company rate.
E10 OCTOBER 2025: core CPI over the 12 months to October 2025 is OPEN. BLS did not publish October 2025 all items or core. Computing it, interpolating it, or reading the blank as zero is a MISMATCH. This is the STOP path firing once, in safety.
E11 THE ANSWER: this year about 27,089 at observed SOFR, plus a HYPOTHETICAL 16,250 on the term loan pending the 2026-10-15 rate-set notice; the October 2025 figure was never published.
</expected_output>

<review_gate>Eleven MATCH lines, with E7 and E10 reading OPEN, then go to 03.</review_gate>
Click to copy
<role>Treasury colleague on day one of the brief.</role>
<task>
Using the company data source from prompt 01, before pulling any series:
1. Restate the question in the asker's words and say what kind of answer it needs: a cash cost, headroom, a cost line, or an explanation.
2. Build the exposure table from the documents: facility, benchmark as DEFINED in the credit agreement, margin (and any grid), floor, any spread adjustment, reset frequency, next reset date, drawn balance and its date, hedge against it (notional, fixed rate, index, maturity), net floating.
3. Mark fixed rate debt as fixed and leave it out of the cost bridge.
4. List what the answer depends on that is not yet in hand.
</task>
<output_format>Exposure table with a source column (document and page) per cell. Then one line: "Floating and unhedged, drawn: X." Then the OPEN list.</output_format>
<constraints>Work from the data sources chosen in prompt 01. Definitions come from the credit agreement, not the term sheet summary or the debt schedule's labels.</constraints>
<trap>The debt schedule labels a facility "SOFR" when the agreement defines Term SOFR with a 3 month interest period. The label reprices it today; the agreement reprices it at the next rate set.</trap>
<stop>If the credit agreement or its interest rate definitions are not provided for a floating facility, its benchmark, floor and reset are OPEN: name "credit agreement, definitions and interest sections" and compute nothing for that facility.</stop>
<review_gate>The human confirms the exposure table before 04. Next step: 04.</review_gate>
Click to copy
<role>Analyst who has been caught quoting the wrong basis once and never again.</role>
<task>
Pull only the series the question needs (series_map in prompt 01), through the public data path chosen there.
For each figure the paragraph may use: series ID, SA or NSA, units transform, observation date, value, pull date, and the TIER 1 sentence it ties to (Fed statement or BLS release), quoted.
Compute every change two ways: from the index levels (show the division) and from the tool's transform or the release figure. State the gap and whether it is basis, rounding or vintage.
Line up headline CPI, core CPI and the component that explains the gap (energy, usually gasoline) side by side, plus PCE and core PCE if released, with one line on what drives the gap between them.
</task>
<output_format>Macro facts table: figure, value, series ID, SA/NSA, transform, observation date, pull date, tie-out sentence, gap and reason. Then the side-by-side inflation block. Then "Checked, normal" lines.</output_format>
<constraints>Work from the public data path chosen in prompt 01. Quote the release figure in the paragraph; keep the series value as the working.</constraints>
<trap>Year over year from the seasonally adjusted index is quoted as the BLS headline, which is the 12 month change before seasonal adjustment. It usually differs by a tenth, and a tenth is what an audit chair notices.</trap>
<stop>If a needed observation is blank or not yet released, the figure is OPEN with the reason (not yet released, or never published such as October 2025 CPI). Never interpolate. If the release text is not available to tie against, mark the figure TIER 2 only and say so.</stop>
<review_gate>Every figure ties or carries its gap reason. Next step: 05.</review_gate>
Click to copy
<role>Treasury analyst who reads rate-set notices for a living.</role>
<task>
Trace the move to each floating facility in the exposure table:
1. Policy: old and new target range, decision date, effective date.
2. Market rate the facility uses: daily SOFR (observed values before and after, applied with the agreement's lookback, often a few business days, so the first day on the new rate comes after the move), or Term SOFR (the rate-set notice value, or OPEN until the next rate set).
3. Floor check: binds or not at the new rate.
4. When it reprices: daily, or at the next reset date, and the first interest payment that carries it.
5. The all-in rate before and after: benchmark plus margin plus any spread adjustment, with the arithmetic.
</task>
<output_format>One row per facility: benchmark before, after, source; floor binds yes or no; reprices on; all-in before, after, change in basis points.</output_format>
<constraints>Use the exposure table from prompt 03 and the facts from prompt 04. The observed benchmark change is used, not the policy change, wherever an observed value exists.</constraints>
<trap>Applying the 25 bp policy change to a daily SOFR loan when SOFR moved 23 bp, or to a Term SOFR loan that has not reset yet. The first overstates slightly; the second books a cost that has not started.</trap>
<stop>A Term SOFR facility with no rate-set notice after the move: its new rate is OPEN, named "lender rate-set notice for the interest period starting {{date}}". An illustration may be shown only with the HYPOTHETICAL label.</stop>
<review_gate>Next step: 06.</review_gate>
Click to copy
<role>FP&A lead who has to defend the number in the forecast.</role>
<task>
For each floating facility: net floating balance (drawn minus hedged notional for each period, stepping with amortizing swaps), times the change in all-in rate, times days over {{DAY_COUNT}} basis, for (a) the rest of the current fiscal year from its reprice date and (b) a full 12 months.
Show hedge effects separately: the swap or cap leg, and any basis where the hedge index differs from the loan index.
Total the observed lines. Show HYPOTHETICAL lines below the total, never inside it without the label.
</task>
<output_format>Bridge table: facility, net floating, rate change, days, basis, cost this fiscal year, cost 12 months, tier. Totals: observed; hypothetical. One line on P&L versus cash timing if hedge accounting applies (the auditor decides the treatment).</output_format>
<constraints>Use the tables from prompts 03 and 05. Day count from the agreement; default only if the agreement is silent, and say so.</constraints>
<trap>A full year of cost booked on a move made with a quarter of the fiscal year left, or the gross drawn balance used where a swap already fixes half of it.</trap>
<stop>A drawn balance with no date, or a hedge confirm missing for a hedge the schedule lists: that line is OPEN, named by document.</stop>
<review_gate>A controller can re-derive each line from the table. Next step: 07.</review_gate>
Click to copy
<role>Treasury colleague who has read the compliance certificate before the lender did.</role>
<task>
For each covenant in {{COVENANTS}} that uses interest (interest coverage, fixed charge coverage, debt service coverage): take the definition from the agreement, the last reported level and the covenant level, add the cost bridge from prompt 06 for the test period, and show headroom before and after. Check any margin grid that steps on the same ratio.
</task>
<output_format>Covenant, definition source (section), last reported, covenant level, pro forma with the rate change, headroom before and after, margin grid effect.</output_format>
<constraints>Use the agreement's defined terms only. Work from the data sources chosen in prompt 01.</constraints>
<trap>Computing coverage with reported interest expense when the agreement defines Consolidated Interest Expense net of interest income or excluding non-cash items. The ratio moves the wrong amount.</trap>
<stop>No definition section provided: the covenant line is OPEN, named "credit agreement, section defining {{covenant}}". Never compute it from a generic formula.</stop>
<review_gate>Next step: 08.</review_gate>
Click to copy
<role>FP&A lead mapping the print to the P&L.</role>
<task>
Ask the human for their cost mix (top cost lines as a share of operating cost) if not in hand. Map each line to the CPI or other public component that actually drives it, pull that component, and show which of headline, core and energy moved the lines that matter. State plainly where CPI is not the right measure (wages, contracted prices, commodity hedged inputs).
</task>
<output_format>Cost line, share, component series ID, 12 month change, source, relevance (drives it, proxy, not relevant). One line: which inflation number matters for this company and why.</output_format>
<constraints>Series via the public data path from prompt 01; cost mix from the human's own files only.</constraints>
<trap>Reporting core CPI as "our inflation". Core leaves out energy, which may be the line that moved the company's costs most.</trap>
<stop>No cost mix provided: do not guess shares. List the components for the human to choose and mark the mapping OPEN.</stop>
<review_gate>Next step: 09.</review_gate>
Click to copy
<role>Treasury analyst running sensitivities.</role>
<task>Run only the moves in {{SCENARIOS}}, for example plus 25 and minus 25 basis points on the benchmark from each facility's next reset date. Recompute 06 and 07 for each. Label every figure HYPOTHETICAL. No probabilities.</task>
<output_format>Scenario table: move, cost this fiscal year, cost 12 months, tightest covenant headroom. Header line: "HYPOTHETICAL scenarios chosen by {{AUDIENCE}}'s request; not a forecast."</output_format>
<constraints>Use the tables from prompts 03, 06 and 07.</constraints>
<trap>Choosing the scenarios for the human from market pricing and presenting them as expected. That is a forecast wearing a scenario label.</trap>
<stop>No scenarios given: skip this prompt and say so. Do not pick them.</stop>
<review_gate>Next step: 10.</review_gate>
Click to copy
<role>CFO's writer. Plain English, no jargon without a definition, no adjectives on numbers.</role>
<task>
Write the answer to the question from prompt 01 in 80 to 120 words: what happened (with the release figure), what it does to this company (observed cost, then hypothetical lines labelled), what is not yet known and when it will be (the next rate set, the next release date).
Then the five questions the {{AUDIENCE}} will ask next, each with a one line answer from the tables or "OPEN, needs {{document}}".
After the paragraph, a source list: each figure, its tier and source id.
</task>
<output_format>Paragraph. Five Q and A lines. Source list.</output_format>
<constraints>Only figures from prompts 04 to 09. Quote the Fed and BLS figures as released. Work from the data sources chosen in prompt 01.</constraints>
<trap>A paragraph that explains the economy. One sentence of macro; the rest is exposure and cost.</trap>
<stop>If any figure in the paragraph is OPEN, the paragraph says so in words; it never fills the gap.</stop>
<review_gate>Draft until 11 passes. Next step: 11.</review_gate>
Click to copy
<role>Controller who re-derives before anything leaves the building.</role>
<task>
Re-derive every figure in the paragraph independently, a second way: macro figures from the index levels and from the release text; costs from the exposure table without looking at prompt 06's totals; covenant figures from the definitions.
Print a tie table: figure, first value, second value, difference, PASS or FAIL. Tolerance: 0.05 percentage point on rates and inflation after rounding to one decimal; 1 currency unit on costs, full precision carried until the end.
Any FAIL: the paragraph is BLOCKED. Print which figure, both workings, and the default if nobody acts ("the paragraph does not go out"). Keep running the rest of the checks so no other break hides behind the first.
Also check: every HYPOTHETICAL figure carries its label; no forecast language; every OPEN item is named with its document.
</task>
<output_format>Tie table, label check, forecast language check, verdict PASS or BLOCKED.</output_format>
<constraints>Use only documents and series values already cited. This gate applies to arithmetic ties; it does not reopen flags closed in earlier prompts.</constraints>
<trap>Explaining away a figure that does not tie ("probably rounding"). For arithmetic, a break is a break until a named human resolves it.</trap>
<stop>BLOCKED is cleared only by a named human resolving the discrepancy, recorded with their name and the fix.</stop>
<review_gate>PASS, or the named human's resolution. Next step: 12.</review_gate>
Click to copy
<task>From this run only, generate one self-contained HTML file (no network calls, no external fonts or scripts, inline CSS and an inline SVG chart) named {{COMPANY}}-rate-brief-{{AS_OF_DATE}}.html:
1. The board paragraph, with PASS or BLOCKED from prompt 11 at the top.
2. A small table: policy range before and after, benchmark before and after, headline and core CPI with source.
3. The cost bridge: observed total, hypothetical lines labelled, OPEN items listed.
4. Covenant headroom before and after.
5. An inline SVG line chart of the benchmark (SOFR or the facility benchmark) over the last 90 days with the decision date marked, drawn only from values already pulled.
6. Footer: sources with tiers, pull date, "Not a forecast. Analysis, not advice."
If prompt 11 is BLOCKED, the file shows BLOCKED in red at the top and omits the paragraph.</task>
<constraints>Numbers only from this run. Print-friendly on A4 and Letter.</constraints>
<trap>A chart drawn from remembered values instead of the pulled series. Every plotted point must be in the prompt 04 table or its export.</trap>
<stop>If fewer than 20 observed benchmark values are available, draw no chart and say why.</stop>
<review_gate>The human opens the file and checks one figure against the tie table. Next step: prompt 13 if this brief repeats monthly.</review_gate>
Click to copy
<role>Engineer building a small, boring, correct refresh for the treasury team.</role>
<task>
In Claude Code, create this tree at {{PROJECT_DIR}} and write every file. Do not summarise the plan back to me. Print `ls -R` when done.
  data/            raw pulls, one CSV per series per pull date (never overwritten)
  inputs/          exposure.csv (the prompt 03 table), covenants.csv, scenarios.csv
  src/pull.py      FRED API pull: https://api.stlouisfed.org/fred/series/observations with series_id, api_key from the FRED_API_KEY environment variable, file_type=json, observation_start; any value that is not a number is missing
  src/bridge.py    cost bridge and covenant headroom from inputs/ (prompt 06 and 07 rules)
  src/brief.py     writes out/brief-<date>.md and out/brief-<date>.html (prompt 12 layout)
  tests/test_calibration.py   the prompt 02 sample and its expected values
  run.py           pull, bridge, brief, in that order; exits non-zero on any tie failure
Steps:
1. Create a local environment on Python 3.11 or newer and run: pip install "pandas==3.0.6" "requests==2.34.2" "pytest==9.1.1"
2. Write tests/test_calibration.py FIRST from prompt 02: 3.353 and 2.446 percent from the index levels, 27,088.89 and 93,277.78 on the revolver, the term loan returning OPEN with no rate-set notice, October 2025 returning OPEN. Run `pytest` and show it FAILS before any src code exists.
3. Write src/, run `pytest` until it passes, then `python3 run.py`.
Definition of done: `pytest` passes, and `python3 run.py` writes out/brief-<date>.html whose figures match a manual prompt 11 run for the same date.
Next: add PCE; add a second entity; schedule run.py after each CPI release.
</task>
<constraints>Model: Claude Opus 5.5 for design and debugging; Claude Sonnet 5 is fine for generating repetitive files. The API key lives in the environment, never in a file in the repo. Work from the data source chosen in prompt 01.</constraints>
<trap>The pull drops blank observations, so a 12 month change silently spans 13 months, or reads the blank month as the prior value. Keep every date; a change with a missing endpoint returns OPEN.</trap>
<stop>If `pytest` cannot be made to fail first (the test passes with no code), the test is wrong: stop and fix the test before writing src.</stop>
<review_gate>Debug keyed to real failures: HTTP 400 on the pull means a bad series ID or a malformed date; a 429 means the per-key rate limit, so wait and retry; a year over year figure 0.1 off the release is SA versus NSA, not a bug; a Term SOFR facility showing a new rate with no notice file means bridge.py fell back to SOFR, which it must never do. Next step: rerun prompt 10 on the new brief each month.</review_gate>
Source repo
https://github.com/stefanoamorelli/fred-mcp-server ↗

The code is public and free. The setup instruction above installs and wires it for you. You never need to open this link.

Got the prompts. Want them wired into your actual stack? We map that on a free AI audit.

Book the free audit

Rent it forever, or own it once.

For CFOs and treasurers who get the "what does the Fed move do to us" email: turn a rate decision and CPI print into a sourced board paragraph, with the cost on your floating debt.

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.

Back to the prompts ↑
Path B · done with you

We wire it into your business

We would set it up with you: your facility and hedge register loaded once, your lender notices read on arrival, the brief refreshed the morning after each Fed decision and CPI release, and the paragraph in your board template. Reply wire it for a 30-minute slot.

Book a build call →
data safety

Before you use live numbers

  • • 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.
  • • Wiring the open-source piece to real systems? Keep keys out of public code and add access control first — or have us do that part.
the fine print

Credit the original author

Prompt set authored by consultance.ai. Nothing is hosted by us: your documents go only to your own Claude account, under your own Claude tenant's terms, never to us. Use a Team or Enterprise plan, or turn off model training, before loading a credit agreement. The FRED data tool (fred-mcp-server) is AGPL-3.0 and not affiliated with the Federal Reserve; FRED data is used under the FRED API Terms of Use. Analysis on your own data, not a forecast and not investment, accounting or legal advice.

Want this running in your business, not just your laptop? We build it and hand you the keys.

Book a build callBack to the library

Want this wired into your stack instead of running it yourself? That is our AI deal desk and finance automation service.

the newsletter

AI news worth opening.

The AI tools, launches, and shifts that actually matter, in plain English. New library drops the moment they land.

100% freeNo paywall, everUnsubscribe anytime

More like this

Other builds worth a weekend

All repos →
Finance and data

Free Portfolio Quant Research Desk

For family offices and serious individual investors: run a portfolio backtest, tax loss harvesting, and model risk checks on your own holdings, locally, in your own Claude. Replaces the $250k quant seat you would otherwise hire.

Setup guide →
Finance and data

Private Equity Deal Sourcing Playbook

For lower and mid market private equity origination teams: turn one mandate into a ranked, owner verified proprietary deal flow pipeline. Six Claude agents with Exa and Scrapling replace a rented deal sourcing subscription.

Setup guide →
Finance and data

Free Jira Alternative for Deal Teams

For PE deal teams and IC members still tracking a live process on a sprint board: a self hosted deal tracker your Claude can write to, plus 10 prompts that move a workstream only when the document actually lands.

Setup guide →
Get the free kitBook a call

Forward this to whoever owns the workflow.

The person drowning in this every week is the one who'll actually want it.

Forward by email
in one line

What is Explain a Fed Rate Move to Your Board?

Explain a Fed Rate Move to Your Board is a finance and data build in the consultance.ai AI Build Library. For CFOs and treasurers who get the "what does the Fed move do to us" email: turn a rate decision and CPI print into a sourced board paragraph, with the cost on your floating debt. It fits CFOs, treasurers and FP&A leads with a revolver or term loan who have to explain a Fed decision or an inflation print to a board, an audit chair or a lender. Setup difficulty is Easy, with 5 plain-English steps.

What does Explain a Fed Rate Move to Your Board do?

For CFOs and treasurers who get the "what does the Fed move do to us" email: turn a rate decision and CPI print into a sourced board paragraph, with the cost on your floating debt.

Who is Explain a Fed Rate Move to Your Board for?

It fits CFOs, treasurers and FP&A leads with a revolver or term loan who have to explain a Fed decision or an inflation print to a board, an audit chair or a lender.

How hard is Explain a Fed Rate Move to Your Board to set up?

Easy to set up — one guided setup instruction covering 5 plain-English steps, plus 13 ready-to-run prompts on the resource page.

How would consultance.ai build this out?

We would set it up with you: your facility and hedge register loaded once, your lender notices read on arrival, the brief refreshed the morning after each Fed decision and CPI release, and the paragraph in your board template. Reply wire it for a 30-minute slot.

What are the licensing terms?

Prompt set authored by consultance.ai. Nothing is hosted by us: your documents go only to your own Claude account, under your own Claude tenant's terms, never to us. Use a Team or Enterprise plan, or turn off model training, before loading a credit agreement. The FRED data tool (fred-mcp-server) is AGPL-3.0 and not affiliated with the Federal Reserve; FRED data is used under the FRED API Terms of Use. Analysis on your own data, not a forecast and not investment, accounting or legal advice.

Want this built into your workflow?

Explain a Fed Rate Move to Your Board is the starting point. On a free AI audit we map where it fits your stack and what consultance.ai would build around it.

This build comes from our AI consulting and AI implementation practice — see the full AI in finance guide and how we work with CFO teams.

Book your free AI audit