Potential Future Exposure (PFE) is a simple way to measure the riskiness of a derivatives portfolio, given some statistical assumptions about the distribution of future prices of the derivative portfolio’s underlying assets. These assumptions are wrong, but not so wrong that the PFE will not provide some valuable information. The PFE uses the model of the underlying asset price process that the Black-Scholes option formula uses, and therefore shares the same assumptions, so the PFE can illustrate some of its limitations.
The PFE is easy to model in Excel. We start with the asset price process,
ST = Ste(r – 1/2σ^2)(T-t) +/- σZ(T-t)^2
which is described here and here. For this example I have taken the WTI Crude Oil Cal13 prices as the underlying, meaning we have a portfolio of derivatives: futures, forwards, options, or a mixture of all of them with WTI as the underlying.
The r for each month will be the LIBOR rate of corresponding term, the sigma will be the implied volatility taken from the option on each contract month, and the Z will be a confidence level that we set. Here we use 95%, or 1.65 (standard deviations). In Excel, use NORMSINV(.95) to get 1.65. If our assumptions were correct, which they aren’t, 95% of the time the portfolio’s worst loss would be inside the interval we create.
Apply the above formula to each contract month, adding the second term (with the Z factor) to get the upper interval and subtracting to get the lower, and using each month’s specific r, sigma, and time to expiration for each monthly contract (T-t), and we get this result:
It is a simple matter to get an exposure in dollar terms. We take the portfolio’s exposure in barrels, net the longs and shorts for each month, and multiply each month’s underlying by each month’s corresponding price on the lower curve (since we would be losing if the underlying went down). If the portfolio has options, treat them as being delta barrels long or short. This works since the option delta is calculated using the same r, sigma, S, and (T-t) as our underlying process uses here.
Note that the upper bound is farther away from the current forward curve than the lower bound. This is due to the lognormal distribution of asset prices. The downside is floored at zero and the upside is infinite.