Calculation guide
Enter all foreign costs in one foreign currency and the rate as home currency per foreign unit. Home-currency costs stay fixed. A positive shock makes foreign spending more expensive.
Inputs
Total costs in foreign currency units
Example entry 10000.
Home currency per foreign unit
Example entry 1.2. Allowed range 1e-06 to 1000000.0.
Home-currency costs
Example entry 1000 (in the selected currency).
Exchange rate change
Example entry 10 %. Allowed range -99.99 to 1000.0.
Worked example
| Input | Value |
|---|---|
| Total costs in foreign currency units | 10,000 |
| Home currency per foreign unit | 1.2 |
| Home-currency costs | 1,000 |
| Exchange rate change | 10% |
| Result | Value |
|---|---|
| Budget after exchange-rate change | 14,200 |
| Original budget | 13,000 |
| Change in cost | 1,200 |
Calculation steps
Budget after exchange-rate change = (((Total costs in foreign currency units × Home currency per foreign unit) × (1 + (Exchange rate change ÷ 100))) + Home-currency costs)
(((10,000 × 1.2) × (1 + (10 ÷ 100))) + 1,000) = 14,200
Original budget = ((Total costs in foreign currency units × Home currency per foreign unit) + Home-currency costs)
((10,000 × 1.2) + 1,000) = 13,000
Change in cost = (Budget after exchange-rate change − Original budget)
(14,200 − 13,000) = 1,200
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Total costs in foreign currency units | 10,000 | 11,000 | Budget after exchange-rate change | 14,200 | 15,520 |
| Home currency per foreign unit | 1.2 | 2.2 | Budget after exchange-rate change | 14,200 | 25,200 |
| Home-currency costs | 1,000 | 1,100 | Budget after exchange-rate change | 14,200 | 14,300 |
| Exchange rate change | 10% | 11% | Budget after exchange-rate change | 14,200 | 14,320 |
