I would like to understand how to solve this in Excel. Hardware Inc. bonds are selling in the market for $960.45. These bonds carry a 9 percent coupon paid semiannually, and have 15 years remaining to maturity. What is the capital gain yield assuming that the interest rates will remain constant over the year?