SLIDE 7 Well, get back to my student time
A „homework“ I got as I applied to WestLB (now: RestLB) as a junior quant:
Market Data Bond 1 Bond 2 Bond 3 Bond 4 Bond 5 Bond 6 Bond 7 Bond 8 Bond 9 Bond 10 Bond 11 Maturity in y 1,7 2,1 3 3,8 4,6 5,6 6,5 7,2 8 9 5,4 Coupon (annual) 4 5 4 5 4 5 4 5 4 5 4 Principal 100 100 100 100 100 100 100 100 100 100 100 Present Value 104,2 110 103 105 100 103 96 103 92 98 ???
Zero rate from 0 to 1 year is assumed constant and equal to 0,02 Question: What is the present value of bond 11 using a bootstrapping algorithm? The maturities m(i) of bonds 1 to 10 may be assumed to be increasing and chosen so that m(i+1)-m(i)<=1 Please use annually compounded rates. Both Excel-based and VBA-based solutions are accepted.
Dude, why don‘t you accept QuantLib?!