QUESTION 5: Bond Valuation with Spot Rates A bond, with a face value of $100 and a coupon rate of 2%, is set to mature in 5 years. The prevailing spot rates are as follows: r_1 = 0.07 r_2 = 0.075 r_3 = 0.078 r_4 = 0.082 r_5 = 0.09 You are tasked with: 1. Deriving the forward rates for periods 1-2, 2-3, 3-4, and 4-5. 2. Calculating the bond's present value. 3. Commenting on whether the bond would likely trade at a premium or a discount. For each part, please elucidate using Excel, ensuring to show formulae, and also provide an algebraic solution detailing the relevant financial mathematics.