In Excel: Create four $(4)2-$variable "What if$"$ analyses of bonds: clean bond price, dirty bond price, Macaulay duration, and modified duration. Highlight the rows in the "What if$"$ table where the yield to maturity equals the coupon rate of the bond $($where the price of the bond equals the par, or face, value of the bond.$)$

Write a brief explanation of what the "What if$"$ tables explains to us about the particular bond analyzed.