# FX Hedging and Portfolio Model

Identify and hedge currency exposures across your operating footprint using forwards, options, and natural hedges to stabilize earnings and cash flow. Built for treasurers managing real FX risk, not a one-currency simplification.

- Canonical: https://finamodel.com/templates/fx-portfolio-model
- Excel download: https://finamodel.com/templates/fx-portfolio.xlsx
- Category: Capital Markets
- Model type: Portfolio
- Difficulty: Intermediate
- Audiences: Investors & analysts, CFOs & FP&A, Treasurers, CFOs, Risk managers, Corporate finance teams
- Tags: currency-risk, hedging, forwards, treasury, multi-currency

## Overview

This portfolio model values and stress-tests a leveraged FX trading book across six currency pairs, forecasting annual returns from carry income, spot price appreciation, and roll yield to compute IRR and equity multiples. Position each pair, apply interest rate differentials (positive carry on USD/JPY, USD/MXN; negative carry on EUR/USD), and model spot price moves declining toward baseline by Year 5 (mean reversion).

The workbook consolidates three income streams: carry (IR differential × notional per pair), spot P&L (directional exchange rate moves treated as fully realised cash), and roll yield (income from rolling forward contracts capturing forward premium decay). Financing cost deducted on leverage: at 3× leverage with 6.8% borrowing rate, financing consumes ~13.6% of equity annually. Management fee 1.5%, performance fee 15% above HWM. Output: equity cash flows array (distributions to LPs + terminal equity), Project IRR and MOIC.

Used by macro hedge funds, family offices deploying capital in systematic FX strategies, and infrastructure funds hedging currency exposures on global assets. Critical mechanics: HWM roll-forward (no performance fee charged in years when NAV is underwater), spot P&L treated as cash (not as unrealised gains on the balance sheet), and independent per-year spot return assumptions reflecting mean-reversion profile. Benchmarks: Deutsche Bank FX Carry Index 4–8% p.a., spot volatility ±15–25% in active years.

## What's included

- Transaction exposure by currency: AR, AP, capex, and dividends
- Translation exposure for consolidated reporting and WACC impact
- Economic exposure from future cash flows in foreign currencies
- Forward contract pricing and P&L impact by currency pair
- Earnings sensitivity and cash flow volatility metrics
- Transaction exposure by currency (AR, AP, capex, dividends)
- Translation exposure for consolidated reporting (WACC impact)
- Forward contract pricing and P&L impact
- Hedging ratio and cost-benefit analysis by currency pair

## FX Portfolio Model: How the Template Projects Multi-Currency Returns

This fx portfolio model template projects returns for a multi-currency FX book over a five-year horizon, covering carry, spot P&L, and roll yield across six pairs. It also models management and performance fees, operating costs, and investor outcomes such as IRR and equity multiple.

The public download is a values-only preview.

### Operating Drivers Behind the Currency Book

The model organises the FX book around six currency pairs, each with an assigned weight that sums to one. A leverage multiple scales base capital into total notional, which is then split across pairs.

- For each pair, the model captures three return drivers: carry from interest rate differentials, spot P&L from directional exchange rate moves, and roll yield from forward points. Carry can be negative for pairs held for spot diversification.

- Spot returns are set year by year, allowing emerging market pairs to show higher initial returns that decay toward developed market levels. Roll yield is held flat annually.

### Calculation Flow Through the Model

Revenue builds from pair-level calculations. Carry equals pair notional times interest rate differential.

- Spot P&L equals pair notional times the year-specific spot return. Roll yield equals pair notional times a per-pair roll yield rate.

- These streams aggregate into total gross revenue on the income statement. From there, the model deducts financing cost, management fee, performance fee, operating expenses, depreciation, and tax to reach net income.

- Net income feeds the equity roll-forward and the cash flow statement. Management fee is based on opening equity, while performance fee applies only to gains above a rolling high-water mark.

The Returns sheet uses base capital, annual distributions, and terminal equity to calculate IRR and equity multiple.

Calculation summary:

```text
Carry = pair notional × interest rate differential
Spot P&L = pair notional × the year-specific spot return
Roll yield = pair notional × a per-pair roll yield rate
```

### Outputs for Investors and Managers

The model produces an income statement, balance sheet, cash flow statement, and a Returns sheet. The Returns sheet shows IRR, equity multiple, and MOIC from the investor perspective.

- The balance sheet tracks cash, margin deposits, PP&E, contributed capital, and retained earnings, with an equity roll-forward that reconciles net income, distributions, and contributions. The income statement presents gross revenue, financing cost, management and performance fees, operating expenses, depreciation, and tax.

- A Checks sheet validates balance sheet integrity, equity positivity, cash buffer, pair weights, high-water mark behaviour, margin utilisation, and performance fee logic in loss years.

### Practical Use of the Template

This template suits portfolio managers, family offices, or corporate treasuries evaluating a leveraged FX book across multiple pairs. Users can adjust assumptions such as pair weights, leverage, interest rate differentials, spot return paths, roll yield rates, fee rates, operating expenses, and tax.

- The model then recalculates revenue, expenses, net income, equity, cash, and investor returns. It is particularly useful for testing how changing leverage affects financing costs and margin utilisation, or how different spot return assumptions influence performance fees through the high-water mark mechanism.

- The values-only preview shows the structure and outputs but does not include live formulas.

## Multi-currency cash flow consolidation

Combine revenues, costs, and capex across operating units in different currencies and convert to reporting currency under various FX scenarios.

## Hedging strategy comparison

Model natural hedges, forwards, options, and currency swaps side by side to compare total cost and earnings protection across currency pairs.

## Sensitivity and stress testing

Run scenarios for 10%, 20%, and 50% moves in key currency pairs to quantify profitability and liquidity impact on the business.

## Multi-currency cash flow consolidation

Combine revenues, costs, and capex across operating units in different currencies and convert to reporting currency under various FX scenarios.

## Hedging strategy comparison

Model natural hedges, forwards, options, and currency swaps side by side to compare total cost and earnings protection across currency pairs.

## Sensitivity and stress testing

Run scenarios for 10%, 20%, and 50% moves in key currency pairs to quantify profitability and liquidity impact on the business.

## Features

- **Multi-currency cash flow consolidation:** Combine revenues, costs, and capex across operating units in different currencies and convert to reporting currency under different FX scenarios.
- **Hedging strategy comparison:** Model natural hedges (offsets between inflows and outflows), forwards, options, and currency swaps to compare total cost and earnings protection.
- **Sensitivity and stress testing:** Run scenarios for 10%, 20%, and 50% moves in key currency pairs to test profitability and liquidity impact.

## Use cases

- **Treasury hedging decision:** Determine which currency pairs to hedge, what proportion, and whether to use forwards or options based on earnings volatility and cost.
- **Cross-border M&A impact:** Model FX exposure from an acquisition target's revenue and cost base, and design a hedging approach post-close.
- **Earnings guidance and analyst relations:** Quantify the impact of currency moves on revenue, gross margin, and EPS to set realistic guidance ranges.

## Frequently asked questions

### What is an FX hedging model?

A model that identifies currency exposures by type, sizes hedging instruments, and quantifies the earnings and cash flow impact of FX movements and hedging costs.

### What is the difference between transaction and translation exposure?

Transaction exposure is cash flows in foreign currencies such as AR and AP that create actual conversion risk. Translation exposure is non-cash balance sheet items that affect consolidated earnings without a cash movement.

### How should I price a forward contract?

Use interest rate parity: forward rate equals spot rate multiplied by domestic rate divided by foreign rate. Add the bank spread of 20-50 pips to get the quoted price.

### When should I use options instead of forwards?

Use options when the exposure is uncertain such as a contingent bid or project award. You pay a premium upfront but keep the right not to exercise if the exposure does not materialize.

### Who uses FX portfolio models?

Corporate treasurers, CFOs, risk managers, and multinational finance teams use them to design hedging programs, set earnings guidance, and manage cross-border M&A risk.

## Related templates

- [Commodities Trading Model](https://finamodel.com/templates/commodities-trading-model)
- [Bond Trading Model](https://finamodel.com/templates/bond-trading-model)
- [Macroeconomic Scenario Model](https://finamodel.com/templates/macro-scenario-model)