This is the value of the bond, but it does not include the accrued interest you would pay. The ACCRINT function will calculate accrued interest, as shown below. Issue date First interest date Settlement (today) Maturity Coupon rate Going rate, Redemption (par value) Frequency (for semiannual) Basis (360 or 365 day year) 1/1/2018 6/30/2018 3/25/2018 12/31/2027 10.00% 13.00% 100 2 0 Accrued interest = or Suppose the bond's price is $1,150. You can also calculate the yield using the YIELD function, as shown below. Curent price Settlement (today) Maturity Coupon rate Redemption (par value) Frequency (for semiannual) Basis (360 or 365 day year) $ 1,150.00 1/1/2018 12/31/2027 10.00% 100 2 0 Yield