Please use the MS Excel (with formula) to solve the problems,otherwise it will not be acceptable

Exercise I [25 marks] A band has a face value of $100. pays an annual ccupan cf 4% and maTures in 5 years. 1. Value The band if The yield Ta maTuriTy is m. 2. CalcuIaTe The band's duraTian. 3. Use duraiian Ta eslimaTe The change in band price for a 5D basis painT rise in yield. Exercise 2 [15 marks] A band has a face value of $100 and a semiannual caupan af 6.25%. Caupans are paid annually on lTh April and 15111 Oc'raber. l. WhaT is The value of The accrued inTeresT an 19111 June? 2. WhaT is The band price if The clean value is $99.50