Kumu / Finance & Securities / Stage 1

Stage 1 — Executive Memo

Weight: 17% of project Deliverable: 300–400 word 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

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)

FamilyOne-line mechanicsProCon
Forward / futuresContract today to sell EUR at a locked rate on the settlement dateComplete certainty — budget is safeGive up all upside if EUR strengthens; counterparty/margin mechanics
Money-market hedgeBorrow EUR today, convert at spot, invest the USD — a do-it-yourself forward built from interest ratesSame certainty as a forward; useful when forwards are unavailable or mispricedUses borrowing capacity; more moving parts
Options (put floor)Buy the right — not the obligation — to sell EUR at a strikeFloor under proceeds plus upside participationPremium 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:

  1. Stage 2 — Model specification: the workbook designed on paper — named ranges, tabs, formula logic, validation checks
  2. Stage 3 — AI-assisted build + audit: an AI generates the workbook from your spec; you audit and fix its output
  3. Stage 4 — Live market data: real, sourced, timestamped prices replace the placeholders
  4. 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
StageDeliverableWhere it goes
1Hedge-framing memodocs/decisions/YYYY-MM-DD-{lastname}-{scenario-slug}-hedge-framing.md
2Model specificationdocs/specs/YYYY-MM-DD-{lastname}-{scenario-slug}-spec.md
3Built workbook + build auditmodels/builds/YYYY-MM-DD-{lastname}-{scenario-slug}-model.xlsx · analysis/YYYY-MM-DD-{lastname}-build-audit.md
4Market-data memodata/YYYY-MM-DD-{lastname}-market-data.md
5Validation + recommendationanalysis/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

Rubric

CriterionWeightStrong work looks like
Exposure framing25%Currency, amount, timing, and business consequence stated precisely
Hedge families & trade-offs25%All three families with honest pros/cons, not boilerplate
Next steps25%Correctly frames the Stage 2–5 arc as a plan the CFO can approve
Professionalism25%Executive tone, template used, correct location and filename, committed

Check yourself