2. (10) Suppose a bond is purchased with a settlement date of June 30 and the next coupon payment is on September 30. The par amount purchased on the bond $100,000, and its annual coupon rate is 6% paid semiannually. a. What is the accrued interest using the 30/360 day count convention? b. What is the accrued interest using the actual/actual day count convention?

Show in excel with formulas