Find the current yield spreads for the various bond ratings

Your firm has a credit rating of A. You notice that the credit spread for five-year maturity A debt is 85 basis points (0.85%). Your firm’s five-year debt has semi-annual coupons and a coupon rate of 6%. You see that new five-year Government of Canada bonds are being issued with a YTM of 2.0%. What should the price of your outstanding five-year bonds be?

Find the current yield spreads for the various bond ratings. Unfortunately, the current spreads are available only for a fee, so you will use old ones. Go to Bonds Online and click on “Today’s Market.” Next, click on “US Corporate Bond Spreads.” Copy this table to the Excel file into which you copied the U.S. Treasury yields.

Solution: