Please calculate using excel.

6. 9.32 a) Use the adjacent tree to price a 4-year multi-step up callable bond. The 7.01 bond pays a coupon of 4.5% for Year 1, 5.5% for Year 2 and 6.5% for Year 5.43 7.76 3. The bond is callable at $99 from Year 1 onwards. 3.45 5.74 4.45 6.21 b) What is the value of the option 4.7 5.03