please do in excel

a. Calculate the accrued interest of a T-note that pays a coupon of 6.65 percent of its face value of $20,000. The last coupon was paid 102 days before the settlement and coupons are paid semiannually (180 days).

b. Suppose that you have a bond that offers a coupon rate of 10% paid semiannually. The face value of the bond is $1000 and it matures in 4 years. Its current yield to maturity is 8% and market price is $1,066.24. What is the duration or weighted average time to