90 likes | 279 Views
Vasicek Analytical Finance II. 2011-12-19 Ngami Valery Ogunniyi Oluwayinka Maarse Bauke. Introduction. Vasicek (zero-coupon) Tasks Term structure Discount rate Forward rate Distribution VBA/Excel Results. Vasicek Model. Mean reverting Affine term structure. VBA code. While loop
E N D
VasicekAnalytical Finance II • 2011-12-19 • Ngami Valery • Ogunniyi Oluwayinka • Maarse Bauke
Introduction • Vasicek (zero-coupon) • Tasks • Term structure • Discount rate • Forward rate • Distribution • VBA/Excel • Results
Vasicek Model • Mean reverting • Affine term structure
While loop • Day count conversion
Results • Variables of term structure
Results • Term structure • Forward rate
Results • Discount factor • Distribution