Black Derman Toy (BDT) Interest Rate Model – Topic Guide

Interest Rate Models are used to value various financial instruments. The models are defined by state variables and their processes. The values taken by the state variables represent the position or state of the item being model. The processes determine how the state variables change over time and may depend on the evolution of a single factor or multiple factors. The Black-Derman-Toy interest rate model is an example of the former.

Buy Now

The Black-Derman-Toy term structure model was developed by Fischer Black, Emmanuel Derman and William Toy in 1990. It is an example of a No-Arbitrage model. It assumes that all security prices and rates depend on only one single factor- the short rate.


Topics covered:

    1. An overview of the basic features of a Black-Derman-Toy (BDT) one factor interest rate model as well as some of the simplifying assumptions made in its construction.
    2. A step-by-step methodology demonstrating how the Black-Derman-Toy (BDT) one factor interest rate model may be built in EXCEL. This includes:
      • A definition of the input , output and calculation cells
      • Linking all the pieces together with the Solver Function of the EXCEL worksheet and running the Solver Function to get the results, i.e. median rates and their time varying volatilities (sigmas).
    3. The construction of a short rate binomial tree from the median rates and volatilities determined.
    4. Illustrate, using an EXCEL worksheet, how the rates from this tree will be used to price bonds and options.


EXCEL files

The pre-packaged course deal also includes the following 2 EXCEL files that demonstrate the following concepts:

    1. How to build a BDT interest rate model in excel
    2. How to utilize the results of the model to price bonds and options

back to top


Random Testimonial

  • ~ Corporate Training Testimonials

    "A most amazing training - hands down the best, most useful, and most relevant I had during my tenure. Simply put, I loved it and will continue to build on the models. 

    Financial Modeling Course Participant
    FGB Training Academy, 
    First Gulf Bank, Abu Dhabi, UAE


    I have attended a number of training courses conducted by Alchemy technologies. Broadly, the areas covered have been Financial Risk Management aspects, Basel II implementation in Pakistan, as well as product knowledge for relatively new products in the our market for instance Financial Derivatives. As trainers, Mr. Jawwad Farid and his team bring in a wealth of conceptual knowledge entwined with their own professional experiences, adapting and honing it to our local market needs. The training courses are very informative and are delivered in a witty and energetic manner. The learning needs of the participants are kept in focus, and they are kept involved by interactive discussions and queries. Personally, I have always left these sessions with a much better understanding and grasp over the subjects delivered, which has helped me professionally.”

    Senior Manager & Team Leader
    Treasury Middle Office
    Habib Bank Limited


    “Jawwad Farid has admirably led the training piece on the Treasury side covering Treasury risk, Treausury products, Derivatives (basic & Advanced), Fixed income securities (Basic & Advanced) and ALM training modules. Jawwad in our opinion is an “Outstanding Senior Trainer” who has deep subject matter knowledge and an uncanny ability to keep the participants engaged in the training process. So far our clients have expressed maximum level of satisfaction in Jawwad’s capability to deliver high value training programs, that have tangibly enhanced their staff’s skill sets.

    Based on our direct more than satisfactory experience, Jawwad’s otherwise exceptional track record on the training side with over 90 technical skill building courses in South Asia, Middle Eastern and Far Easterm markets, we have no hesitation in strongly recommending Jawwad Farid for the training that for participants based out of Malaysia or the adjoining Far Eastern Markets.”

    Mohammad Nasr Ullah
    Principal Consultant
    Consultnomics, FZE


    I have loved each and every workshop from Alchemy. The workshops are extremely helpful in removing queries about Derivatives Pricing, Basel & Regulatory issues. I feel attending the workshops have added value to my knowledge and expertise. Moreover, the instructor is extremely knowledgeable on the subject area and ensures that each candidate returns with similar knowledge and expertise.

    Senior Vice President
    Allied Bank"

  • Read more testimonials »