please show work by using Excel

this has to be solved eith Excel

14) 10% annual coupon bond with a par value of $1,000 and 15 years to maturity is quoted at S1,220.68. Last coupon was paid 120 days ago and days between coupons is 365 days. a) What is the accrued interest due seller? b) What is the accrued price? 15) 10% annual coupon bond with a par value of $1,000 and a maturity date of 8/15/2032 is quoted at $1,220.68. a. What is the accrued interest due seller on 5/20/2017? b. What is the accrued price on 5/20/17? 14) 10% annual coupon bond with a par value of $1,000 and 15 years to maturity is quoted at S1,220.68. Last coupon was paid 120 days ago and days between coupons is 365 days. a) What is the accrued interest due seller? b) What is the accrued price? 15) 10% annual coupon bond with a par value of $1,000 and a maturity date of 8/15/2032 is quoted at $1,220.68. a. What is the accrued interest due seller on 5/20/2017? b. What is the accrued price on 5/20/17