Excel convergence hacks for TARF pricing models. Convergence between closed form and simulation model prices is enhanced with variance reduction procedures. It encourages model extension to complex products. For our TARF pricing model in its original form convergence is a challenge. We will try and
The case for participating forwards This week we took a deep look at a number of common structured products and their hedge effectiveness. One product stood out in terms of its performance – the unconventional participating forward contract. Traditionally when we look at hedging structures
USD JPY FX options convention. For business school students taking the treasury product exam or preparing for a trading desk interview, the USD JPY pair is particularly troublesome. Here is a list of common errors and challenges side by side with four simple examples for
TARF Hedge effectiveness model. This is our second post in the TARF hedge effectiveness series and in the treasury candidates assessment series case. To catch up with the case please see the original TARF case study that defines the client requirement as well as available
Vanilla options TARF and participating forwards. A case study. There are some common questions that repeatedly get posed in my treasury products class about the variations available within exotic derivative instruments. Are these exotic contracts really needed? Who really benefits from selling these exotic products?
Understanding CMO, CDO and CDS The third part of the Big Short Case Study that traces the origin of the mortgaged backed CMO CDO CDS product sets referenced in the book and the film. The terms stand for Collateralize Mortgage Obligation (CMO), Collateralize Debt Obligation (CDO) and
Deriving zero rates and forward rates using the bootstrapping process is a standard first step for many valuation, pricing and risk models. Interest rate and cross currency swaps & interest rate options pricing & VaR models, revolving credit facilities & term B loans valuation models,
Hedging portfolio Vega and Gamma using solver. Lesson Five For our portfolio model we need an objective function that allows us to minimize the cumulative Greek gap across maturity buckets with respect to Vega and Gamma between the short positions and the proposed hedge portfolio.
Option Greeks. Option Hedging using Excel. Since a spot, forward or future position is linear in its pay off it has no second order derivative. Options on the other hand are non-linear (asymmetric payoffs). While we can get away with hedging Delta with a linear
Building Local Volatility Surfaces in Excel – Lesson Five So far in our volatility surface tutorial over the last few days we have covered: Volatility Surface Lesson One – Building Volatility surfaces in Excel. Beginners Guide Volatility Surface Lesson Two – Volatility surface deep out of the money options