please use excel with as much detial as possible

38. Suppose that you purchase a bond that matures in five years and pays a 13.76 percent coupon rate. The bond is priced to yield 10 percent. (LG 3-6) a. Show that the duration is equal to four years. b. Show that if interest rates rise to percent next year and your investment horizon is four years from today., you will sill lam a 10 percent yield on your investment