Course contents
Advanced · Course 6: Foreign Exchange, Guarantees and Financial Risk · Lesson 4 of 4

Building a complete financial risk sheet for a new export order

Level: AdvancedTime: 55 minutesOrder used: A (the T-shirt)Tool: Financial risk sheet
For a merchandiser or owner assembling one complete risk view of a new order, export or domestic, before it is confirmed. Lessons 6.1 to 6.3 are the prerequisite. Rates and fees here are illustrative examples.
Export caseOrder A, Northline Apparel, FOB USD 3.20 per piece, 15,000 pieces
Domestic caseCedar & Co., same T-shirt shape, local currency throughout
FactoryDelta Garments (garment factory)
FX row (export)Illustrative adverse move, 30 to 28.50 local-currency-units per USD
FX row (domestic)None; both sides already use local currency
Guarantee rowIllustrative fee, sized to what each order needs
02Opening

This page teaches how to bring currency exposure and guarantee cost together into one complete financial risk sheet for a new order, for anyone approving an order before it is confirmed

Lessons 6.1 to 6.3 taught two separate risks a new order can carry: foreign exchange risk, where the order's sale currency differs from the factory's own cost currency, and guarantee cost, the fee a factory pays to hold a bank's promise open for a buyer. A complete financial risk sheet puts both risks, where each applies, on one page before an order is confirmed, so nothing is discovered only after the fact. Some rows apply only to a foreign-currency order; a purely domestic order, like Delta Garments' own sale to Cedar & Co., correctly shows an empty FX row, not a missing one. This lesson mainly teaches the decision flow: assembling a complete risk view before an order is approved, not after.

03Before you start

What you need, and what this lesson does not cover

You need: lesson 6.1's FX exposure calculation, lesson 6.2's exposure-reduction methods, and lesson 6.3's guarantee fee calculation, all built on illustrative figures.

By the end of this lesson you can:

  • list the rows a complete financial risk sheet needs for any new order;
  • correctly leave an FX row empty on a purely domestic order, rather than forcing a currency calculation where none applies;
  • fill in a guarantee row for an order that needs one, and leave it empty for one that does not;
  • total a risk sheet's own rows without mixing currencies into one meaningless figure;
  • use a completed risk sheet to decide whether a new order needs a hedge, a guarantee, or neither before it is confirmed.

Not covered here: any lesson beyond this course; Track 15, Course 4 (working capital) is a related but separate risk view.

04Key terms

Words you will meet in this lesson

TermMeaning
Financial risk sheetA single document listing every financial risk a new order carries, currency exposure and guarantee cost among them, with each row filled in only where it applies.
Foreign exchange (FX) riskThe risk that a currency move between two dates changes what a fixed foreign-currency price is worth in the factory's own local currency.
Bank guaranteeA bank's promise to pay the buyer up to a fixed amount if the factory fails to meet its own contract obligation.
Applicable rowA row on a risk sheet that genuinely applies to the order being assessed, filled in with a real or illustrative figure.
Not applicable rowA row on a risk sheet correctly left empty because the risk it covers does not exist on this particular order.
Illustrative exchange rateA clearly labelled example rate used to teach a calculation, never a real current market rate for any real currency pair.
05Teaching
The rule

A complete financial risk sheet lists every risk row a new order could carry, fills in the ones that apply, and correctly leaves the rest empty rather than forcing a number where none belongs

Every new order should be checked against the same set of risk rows before it is confirmed: an FX exposure row, filled in only if the sale currency differs from the factory's own cost currency; a guarantee row, filled in only if either side has asked for one; and a payment-method risk row, cross-referenced to Track 15, Course 1. An order that needs none of these still passes through the same checklist, simply leaving every row empty, which is itself useful information: the order carries none of these risks.

A complete risk sheet: FX row (if currencies differ) + guarantee row (if requested) + payment-method reference (always noted)
FX exposure rowFilled in only if saleand cost currencies differ.Guarantee rowFilled in only if eitherside requests a guarantee.Payment-method rowAlways noted, referencingTrack 15, Course 1.
Every order passes through the same three rows. Which rows end up with a figure in them, rather than left empty, depends entirely on that order's own facts.
What you meet in real life

The same risk-sheet checklist applies to every order, but which rows end up filled in depends entirely on the order's own currency, size and business model

What can differThe shapes you will meetWhy it matters to you
Export order, foreign currency, no guarantee neededA small, quick reorder of Order A's own shape, paid promptly, may carry FX exposure worth noting but no guarantee request from either side.The FX row is filled in; the guarantee row is correctly left empty, not filled with a zero disguised as a real figure.
Export order, foreign currency, guarantee neededOrder B (the jeans), paid partly by letter of credit, can carry both an FX row and a guarantee row together, as lesson 6.3 already showed for a related case.Both rows are filled in independently; one risk's presence does not imply the other's.
Domestic order, no foreign currency, guarantee neededCedar & Co.'s own large forecast order, entirely in local currency, still carried a guarantee row in lesson 6.3.The FX row is correctly left empty; the guarantee row is filled in on its own, unrelated reasoning.
Domestic order, no foreign currency, no guarantee neededDelta Garments' own routine, smaller domestic sales to Cedar & Co. under the standing 60-day open account carry neither row.A risk sheet with every row empty is not an unfinished sheet; it correctly reports an order with neither risk.
The case we follow

Mona builds one financial risk sheet comparing Order A's own export risk rows against a same-shape domestic order sold to Cedar & Co.

Before quoting a new batch of Order A's own T-shirt shape, Mona builds a financial risk sheet twice: once for an export version sold to Northline Apparel in USD, and once for a domestic version of the same T-shirt shape sold to Cedar & Co. in local currency. The export version carries a filled FX row, since the sale currency (USD) differs from Delta Garments' own cost currency; the domestic version carries an empty FX row, since both sides already use the same local currency throughout. Neither version, in this case, needs a guarantee, since neither buyer has asked for one on this particular batch.

The worked number

Placing the export and domestic versions side by side shows exactly one risk sheet row differing between them, with every other row identical

Export version FX row: illustrative shortfall of 4.80 local-currency-units per piece, from lesson 6.1's own worked adverse move
Domestic version FX row: 0, not applicable, since Cedar & Co. pays in the same local currency Delta Garments already uses
Export version (Northline Apparel)Domestic version (Cedar & Co.)FX row filled in:4.80 local-currency-unitsper piece exposure.FX row correctly empty:same currency both sides,no exchange rate at all.
An empty row is a real answer, not a gap. The domestic version's own empty FX row correctly reports that this particular risk does not exist on this particular order.
The method

Build a complete financial risk sheet for any new order in five steps

  1. List the standard risk rows: FX exposure, guarantee cost, and a payment-method reference.
  2. Check the sale currency against the factory's own cost currency, and fill in the FX row only where they differ.
  3. Check whether either side has asked for a bank guarantee, and fill in the guarantee row only where one is requested.
  4. Leave every non-applicable row genuinely empty, not filled with a zero disguised as a calculated figure.
  5. Review the completed sheet before the order is confirmed, so any real exposure is known in advance, not discovered later.
The trap

A common mistake is treating an empty row on a risk sheet as an unfinished sheet, and filling it with an invented figure to make it look complete

A financial risk sheet with a genuinely empty FX row, for a purely domestic order, or a genuinely empty guarantee row, for an order neither side asked to guarantee, is a complete and correct sheet, not an unfinished one. A reader used to seeing every row filled in on other sheets can wrongly assume an empty row means the preparer forgot something, and may invent a figure, an assumed exchange rate on a domestic order, or a guarantee fee nobody requested, just to fill the space. This invented figure is worse than an honest blank, since it reports a risk that does not actually exist on the order, and can lead a later reader to recommend a hedge, or price in a fee, for a risk the order was never actually carrying in the first place. A reviewer checking a completed sheet should ask, of every empty row, whether it is empty because the risk genuinely does not apply, or empty because nobody has checked yet; only the first reason is an acceptable, finished state for that row.

06In plain words

Before Delta Garments confirms a new order, it is worth checking the same short list of financial risks every time: does the sale currency differ from the factory's own cost currency, and does either side want a bank guarantee. An export order paid in a foreign currency gets its currency row filled in; a domestic order paid in the same currency the factory already uses correctly leaves that row empty. A guarantee row is filled in only if someone has actually asked for a guarantee, export or domestic, and left empty otherwise. Putting both checks on one sheet before the order is confirmed means nothing is discovered for the first time only once payment or delivery is already underway.

07Quick check
  • A complete financial risk sheet checks the same short list of risks on every order, export or domestic.
  • An FX row is filled in only where the sale currency differs from the factory's own cost currency.
  • A guarantee row is filled in only where a guarantee has actually been requested by either side.
  • A genuinely empty row is a correct answer, not a sign the sheet is unfinished.
  • Never invent a figure, an assumed rate or an unrequested fee, to fill an empty row.
  • Review the completed sheet before the order is confirmed, not after payment is already underway.
08Workplace scenario

A new merchandiser at Delta Garments adds an exchange-rate row to Cedar & Co.'s domestic risk sheet, assuming every sheet needs one

A new merchandiser, building a financial risk sheet for Cedar & Co.'s next domestic order, notices the export version of the same sheet, for Order A, has a filled FX row, and adds an assumed exchange rate to Cedar & Co.'s own sheet too, reasoning that every risk sheet should look complete.

Here is the row the merchandiser is questioning:

Cedar & Co. financial risk sheet, FX row. Sale currency: local currency. Cost currency: local currency (same). Merchandiser's addition: an assumed illustrative exchange rate of 30, "to match the other sheet."

Should an exchange-rate figure be added to Cedar & Co.'s domestic risk sheet? Decide before opening the answer.

Show decision

No, the row should stay empty, and the assumed rate should be removed. Two facts decide this together.

First, Cedar & Co.'s sale currency and Delta Garments' own cost currency are the same. There is no exchange rate standing between the two, since no conversion ever happens on this domestic order; there is nothing for an exchange rate to describe.

Second, an assumed rate on a domestic order is not a neutral placeholder; it reports a risk that does not exist. Anyone later reading the sheet would reasonably conclude Cedar & Co.'s order carries currency exposure, and might even recommend a forward contract for a domestic sale that has nothing to hedge.

The merchandiser's instinct toward consistency across sheets is reasonable, but consistency here means applying the same checklist, not forcing the same filled-in rows regardless of whether they actually apply.

09What it costs

An invented FX row on a purely domestic order risks a real decision, a hedge or a fee, being taken against a risk that was never actually there

Framed qualitatively, an assumed exchange-rate row on Cedar & Co.'s domestic order could lead a reader to recommend a forward contract, and its own small bank fee, to hedge a currency exposure the order never actually carried.

An unnecessary forward contract fee at an illustrative 0.3% of an assumed 1,500,000 local-currency amount: 0.003 x 1,500,000 = 4,500 local-currency-units spent protecting against a risk that does not exist

An invented row can cost real money, an unnecessary fee, on a risk that a correct, empty row would have shown never existed.

10Working template

Financial risk sheet: use the "Risk summary" sheet to bring an order's own applicable rows together on one page

Open the Financial risk sheet workbook linked below. Its "Risk summary" sheet lists an FX exposure row, a guarantee fee row and a payment-method reference row, and sums the rows that apply. Fill in the yellow "Your order" column only for the rows genuinely applicable to your own new order, leaving the rest empty, then review the total before the order is confirmed.

[Download the Financial risk sheet](../../templates/T15-C06-financial-risk-sheet.xlsx)

Download the Financial risk sheet (Excel)

11Check yourself

1. A domestic order between Delta Garments and Cedar & Co. is priced and paid entirely in local currency. What should its financial risk sheet's FX row show?

2. A new order is priced in USD, and the buyer has also requested a performance guarantee. What should its financial risk sheet show?

3. A new order is priced in USD at 8,000 pieces x USD 2.50, confirmed at an illustrative rate of 25, converted later at an illustrative adverse rate of 24. What FX-row figure belongs on its risk sheet?

12Glossary
ENARFRTRMeaning
Financial risk sheetكشف المخاطر الماليةFiche de risque financierFinansal risk tablosuA single document listing every financial risk a new order carries, currency exposure and guarantee cost among them, with each row filled in only where it applies.
Foreign exchange (FX) riskمخاطر الصرف الأجنبي (FX)Risque de change (FX)Kur riski (FX)The risk that a currency move between two dates changes what a fixed foreign-currency price is worth in the factory's own local currency.
Bank guaranteeخطاب ضمان بنكيGarantie bancaireBanka teminat mektubuA bank's promise to pay the buyer up to a fixed amount if the factory fails to meet its own contract obligation.
Applicable rowبند منطبقLigne applicableGeçerli satırA row on a risk sheet that genuinely applies to the order being assessed, filled in with a real or illustrative figure.
Not applicable rowبند غير منطبقLigne non applicableGeçerli olmayan satırA row on a risk sheet correctly left empty because the risk it covers does not exist on this particular order.
Illustrative exchange rateسعر صرف افتراضيTaux de change illustratifGösterge niteliğinde döviz kuruA clearly labelled example rate used to teach a calculation, never a real current market rate for any real currency pair.
13Next

Course 6 complete

You have now built a complete financial risk sheet covering currency exposure and guarantee cost for both an export order and a domestic order. This is the final lesson of Track 15, Course 6. Back to the course map

14Ladder

RecognizeList the standard rows a complete financial risk sheet checks on any new order.
ConnectSee why a genuinely empty row is a correct answer, not an unfinished sheet.
CompareTell an export order's own filled FX row from a domestic order's correctly empty one.
DecideJudge, from a completed risk sheet, whether a new order needs a hedge, a guarantee, or neither.