Browse By

Tag Archives: interest rate

No Thumbnail

Interest Rate Models: Steps for building Black, Derman and Toy (BDT) model in Excel: Define Calculation Cells: Construct State Price Lattices

In this post we continue with the definition of the calculation cells of the Black-Derman-Toy (BDT) model in EXCEL. Three state prices lattices are constructed. Define Calculation Cells b. Construct State Price Lattices The BDT model assumes that the short-term interest rates are log-normally distributed