Optimal Hedging Calculation Excel Model
Originally published: 19/04/2018 15:07
Publication number: ELQ-93790-1
View all versions & Certificate
certified

Optimal Hedging Calculation Excel Model

The Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge.

Description
The Optimal Hedging Strategy model automatically calculates the optimal percentage of exposure to hedge and the resulting net economic savings. The template utilizes a risk aversion factor to determine the percentage of exposure to not to hedge, potentially saving considerable hedging costs.

The result gives the optimal proportion of exposure to hedge given all of the parameters specified. The net savings represent a pre-hedge capital reserve released (or redeployed) determined by the freed-up capital by the reduced volatility and size of reserves held. The optimal hedging strategy is derived via economic value added (EVA) after deducting the hedging cost and benchmarking the net savings against the risk exposure.

This Best Practice includes
1 Excel template for Excel 97 or higher

Business Spreadsheets offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Calculate the optimal amount of exposure to hedge

Global hedging decisions

Complex derivative products


4.2 / 5 (14 votes)

please wait...