BDT interest rate model – Limitations with EXCEL’s Solver Functionality and Workaround

A key element in the construction of the Black Derman Toy interest rate model is the setting up and running of EXCEL’s Solver function. The Solver functionality links various parts of the model together, the inputs- initial zero curve rates and their volatilities, the calculation cells – price lattices and short rate tree, and the [...]


Using US Treasuries to calibrate the Black Derman Toy (BDT) Model

The Black Derman Toy (BDT) model is a one-factor, no-arbitrage interest rate model. One-factor in that the entire term structure of interest rates can be inferred with reference to the process underlying the short rates derived. No-arbitrage in that the term structure derived is exactly consistent with the current term structure- the zero curve yield [...]


Practice Test Exam Question and Solution – Bootstrapping Zero and Forward Curves Case Study

Practice Test Exam Question Solution for Pricing Interest Rate Swaps – MBA course Derivatives I & II
Here is abbreviated partial solved solution to the practice exam question posed earlier. The practice exam question was used in Derivatives Pricing course taught to MBA students earlier in August 2012. The solution is presented in two parts. The [...]


Cox-Ingersoll-Ross (CIR) interest rate model – Parameter calibration, Short rates simulation and modeling of longer term interest rates – An example

The Cox-Ingersoll-Ross (CIR) interest rate model is a one-factor, equilibrium interest rate model. One factor in that it models the short – term interest rate and equilibrium in that it uses assumptions about various economic variables (e.g. mean reversion) to derive a process for determining this rate.
We have already provided a detailed theoretical overview in [...]


Addendum: How to conduct a Principal Component Analysis in EXCEL

Addendum: How to conduct a Principal Component Analysis in EXCEL
There are a couple of problems that the user may face after running the Solver function in EXCEL for the Principal Component Analysis of treasury yield rates.
1.       Dummy Values for the Eigenvector matrix
The seed values that are put in the eigenvector matrix have an impact on [...]


Monte Carlo Simulation: Convergence and Variance reduction techniques for option pricing models

Monte Carlo simulation techniques are a useful tool in finance for pricing options especially when there are a large number of sources of uncertainty (in modeling terms: state variables) involved. Unlike Black Scholes formula for which closed formed solutions usually do not exist when there are three or more state variables or numerical methods like [...]


Finance Training Courses: ICAAP: Win a seat at the ICAAP Treasury Risk Workshop, Langkawi at your price!

Purchase a copy of the “Risk Frameworks and Applications – 2nd Edition” and avail a novel opportunity to win via an auction a discounted seat at Alchemy’s upcoming workshop on ICAAP and Treasury Risk being held in tropical Langkawi, Malaysia on the 28th of March 2011.


The ICAAP (Internal Capital Adequacy), Stress Testing and Credit Risk Road Map

The ICAAP (Internal Capital Adequacy Assessment) Roadmap post reviews the core topics in a crash course format for Internal Capital Adequacy Assessment.


Interest Rate Modelling Posts Index

INTEREST RATE MODELLING

Interest Rate Modelling: Introduction
Interest Rate Forecasting: Using CIR (Cox Ingersoll Ross) Model: Introduction
Interest Rate Forecasting: Using CIR (Cox Ingersoll Ross) Model: Estimating Parameters & Calibrating the CIR Model
Interest Rate Forecasting: Using CIR (Cox Ingersoll Ross) Model: Simulating the term structure of interest rates
Interest Rate Models: Black, Derman and Toy [...]


Interest Rate Models: Steps for building Black, Derman and Toy (BDT) model in Excel: How to utilize the results of a BDT interest rate model: Pricing Options

In this post we will consider how the Black-Derman-Toy (BDT) short rate binomial tree will be used to price options on bonds.
Pricing Options
The BDT model may also be used to price put or call options on bonds. For the purpose of calculating these prices it is important to generate the entire short interest rate tree [...]