Kumu / Finance & Securities / Stage 1
Stage 1 — Executive Memo
docs/decisions/YYYY-MM-DD-{lastname}-{scenario-slug}-hedge-framing.md
One page to your CFO: here's our exposure, here's why it can hurt us, here are the three families of tools, and here's the analysis I'm going to build. Executive-friendly, no jargon-dumping.
What you'll learn
- How to translate a market risk into business language a decision-maker acts on
- The three hedge families and the one-line trade-off of each
- How to scope a multi-stage analysis before building it
Understanding the exposure
Your scenario firm expects a foreign-currency payment — say EUR 4,500,000 in one year. The business risk in one sentence: the euro amount is fixed, but the dollar amount isn't.
If EURUSD = 1.10 at settlement → 4,500,000 × 1.10 = $4,950,000
If EURUSD = 1.00 at settlement → 4,500,000 × 1.00 = $4,500,000
gap: $450,000 ← a real budget hole
A 9% currency move — well within a normal year for EURUSD — swings proceeds by nearly half a million dollars. That's the story your memo opens with: currency, amount, timing, and what an adverse move does to USD cash flow.
The three hedge families (memo-sized)
| Family | One-line mechanics | Pro | Con |
|---|---|---|---|
| Forward / futures | Contract today to sell EUR at a locked rate on the settlement date | Complete certainty — budget is safe | Give up all upside if EUR strengthens; counterparty/margin mechanics |
| Money-market hedge | Borrow EUR today, convert at spot, invest the USD — a do-it-yourself forward built from interest rates | Same certainty as a forward; useful when forwards are unavailable or mispriced | Uses borrowing capacity; more moving parts |
| Options (put floor) | Buy the right — not the obligation — to sell EUR at a strike | Floor under proceeds plus upside participation | Premium paid up front, hedge or not |
Insurance framing wins with executives
Forwards are like selling the house forward at a fixed price; options are like fire insurance — you pay a premium and hope to waste it. CFOs think in these terms; a memo that does too reads as judgment, not homework.
Before you write about these alternatives, spend twenty minutes in the FX Hedging Lab watching a forward, a money-market hedge, and an option priced side by side. Seeing the payoffs compute makes the memo's trade-offs concrete instead of abstract.
The "next steps" section — your project roadmap
Close the memo by previewing the machine you're about to build:
- Stage 2 — Model specification: the workbook designed on paper — named ranges, tabs, formula logic, validation checks
- Stage 3 — AI-assisted build + audit: an AI generates the workbook from your spec; you audit and fix its output
- Stage 4 — Live market data: real, sourced, timestamped prices replace the placeholders
- Stage 5 — Validation & recommendation: independent LLM run, hand verification, and the final call
This paragraph matters: it tells the CFO a process is coming, not a gut call.
Set up this project's folders
Stage 0 stood up your portfolio repo. This project adds two folders to that skeleton, and
every stage from here commits into one of them. Build them now, each with a one-line
README.md inside — Git does not track an empty folder, so the README is what makes
the folder exist — and no later stage stalls on housekeeping.
firstname-lastname/
docs/
decisions/ the framing memo, and the final recommendation
specs/ add this — the model specification
models/ add this whole branch
builds/ the workbook you generate, then audit
data/ market data, with source and timestamp
analysis/ the build audit, and the validation work
| Stage | Deliverable | Where it goes |
|---|---|---|
| 1 | Hedge-framing memo | docs/decisions/YYYY-MM-DD-{lastname}-{scenario-slug}-hedge-framing.md |
| 2 | Model specification | docs/specs/YYYY-MM-DD-{lastname}-{scenario-slug}-spec.md |
| 3 | Built workbook + build audit | models/builds/YYYY-MM-DD-{lastname}-{scenario-slug}-model.xlsx · analysis/YYYY-MM-DD-{lastname}-build-audit.md |
| 4 | Market-data memo | data/YYYY-MM-DD-{lastname}-market-data.md |
| 5 | Validation + recommendation | analysis/YYYY-MM-DD-{lastname}-{scenario-slug}-validation.md · docs/decisions/YYYY-MM-DD-{lastname}-{scenario-slug}-hedge-recommendation.md |
Every graded file carries the same prefix — YYYY-MM-DD-{lastname}-{scenario-slug},
a real date, your last name, your scenario slug. Note the split: the repo is named for
you; individual files carry the date and scenario, so a folder full of them
stays legible. Each stage page restates its own path, so you never have to come back here — this
is the whole map in one place.
Submission checklist
- Used the
template-decision-memo.mdas the starting structure - Exposure stated precisely: currency, amount, settlement timing
- The risk quantified in USD terms (what an adverse move costs)
- All three hedge families covered with a pro and con each
- Next-steps roadmap previews Stages 2–5
- Filename follows the convention:
YYYY-MM-DD-{lastname}-{scenario-slug}-hedge-framing.md - 300–400 words, executive tone, one page
- Committed to
docs/decisions/and visible on GitHub - Project folders created with a stub
README.mdin each
Rubric
| Criterion | Weight | Strong work looks like |
|---|---|---|
| Exposure framing | 25% | Currency, amount, timing, and business consequence stated precisely |
| Hedge families & trade-offs | 25% | All three families with honest pros/cons, not boilerplate |
| Next steps | 25% | Correctly frames the Stage 2–5 arc as a plan the CFO can approve |
| Professionalism | 25% | Executive tone, template used, correct location and filename, committed |