Examples
Examples
Try the starting example
- Open signed positions: ID, currency label, foreign amount, payment date
- A,EUR,100,2026-11-01 B,EUR,200,2026-11-15 C,USD,100,2026-11-01
- Rate scenarios: scenario name, currency label, home units per foreign unit
- Base,EUR,1 Base,USD,1 High,EUR,1.2 High,USD,1
- Net foreign amounts by currency
- EUR: 300.00; USD: 100.00
- Home-currency total by supplied scenario
- Base: 400.00; High: 460.00
- Home-currency amounts by scenario/payment date
- Base/2026-11-01: 200.00; Base/2026-11-15: 200.00; High/2026-11-01: 220.00; High/2026-11-15: 240.00
- Largest scenario total
- 460
- Smallest scenario total
- 400
- Scenario-total spread
- 60
Try another scenario
- Open signed positions: ID, currency label, foreign amount, payment date
- A,EUR,100,2026-11-01 B,EUR,100,2026-11-15 C,USD,100,2026-11-01
- Rate scenarios: scenario name, currency label, home units per foreign unit
- Base,EUR,1 Base,USD,1 High,EUR,1.2 High,USD,1
- Net foreign amounts by currency
- EUR: 200.00; USD: 100.00
- Home-currency total by supplied scenario
- Base: 300.00; High: 340.00
- Home-currency amounts by scenario/payment date
- Base/2026-11-01: 200.00; Base/2026-11-15: 100.00; High/2026-11-01: 220.00; High/2026-11-15: 120.00
- Largest scenario total
- 340
- Smallest scenario total
- 300
- Scenario-total spread
- 40
Calculation method
Calculation method
Net foreign amounts by currency
Sum signed positions within each exact currency label; credits/offsets must be supplied as negative positions.
Home-currency total by supplied scenario
Convert each position at its scenario/currency factor, round that position to home cents and sum.
Home-currency amounts by scenario/payment date
Group converted cent positions by supplied payment date after conversion.
Largest scenario total
Maximum scenario total, retaining signed net outlay.
Smallest scenario total
Minimum scenario total.
Scenario-total spread
Largest−smallest scenario total; no probability is assigned to scenarios.
Symbols and units
- a
- Open signed positions: ID, currency label, foreign amount, payment date
- b
- Rate scenarios: scenario name, currency label, home units per foreign unit
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A signed cash-position sensitivity table in one home currency with explicit two-decimal input amounts and supplied factors. It does not fetch rates, forecast exchange markets, recommend hedges or execute transactions.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Background reading; this does not imply endorsement or independent review of SumFizz.