I’m having a bit of trouble how to calibrate a binomial interest rate tree. I know that iH = iL[e^2σ]. But how do you get the lowest number (iL)? All the book says is it uses Excel Solver to calculate it but it doesn’t teach you how to do it manually. Can you calculate it from the par yields given?
Pg 358 Ex 8
A three-year floating-rate bond pays annual coupons of one-year Libor (set in arrears) and is floored at 3.00%. The Libor swap curve for one-year, two-year and three-year par yields are 2.5%, 3.0% and 3.5%, respectively, and interest rate volatility is 10%. The value of the floored floater is closest to:
A 100.000
B 100.488
C 103.000