GLOBAL FINANCE CENTER

SCENARIO PLANNER

Make the assumptions.
See the arithmetic.

A transparent demonstration for borrowing costs and overseas payments. Change the inputs, inspect the formulas and download your own brief.

Illustrative planning only. All rates and amounts below are editable sample assumptions. No market data is fetched. This is not a loan quote, forecast or investment recommendation.

01 / YOUR ASSUMPTIONS

A positive FX change increases the home-currency cost of the foreign payment. Use different currencies.

02 / SCENARIO RESULTS

Your working brief

Calculations stay in this browser. The download includes inputs, formulas and limitations.

Every result has a formula.

Borrowing cost

Base annual interest = principal × base rate ÷ 100.

Scenario interest = principal × (base rate + rate shock) ÷ 100.

Annual difference = principal × rate shock ÷ 100.

Constant principal, simple annual interest. No amortisation, compounding, day-count convention, fees, caps, floors or tax. Negative scenario rates are rejected.

Foreign payment

Base home cost = foreign amount × home-per-foreign FX rate.

Scenario rate = base FX rate × (1 + FX change ÷ 100).

Cost difference = scenario home cost − base home cost.

One payment at an assumed rate. No spread, fees, forwards, hedges, collateral or tax. This is an independent cost sensitivity, not a combined cash-flow forecast.