K5 4 * fx H A c 22 1 Problem 6-30 A BBB-cated corporate bond lus yield to maturity of 8.2% A U.S. Treasury security has a yield to maturity of 6.5%. These yields are quoted as APRs with semiannual compounding, Both bonds pay semiannual coupons matute of 2% and have five years to maturity. Note: assume a $1,000 face value Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need to copy paste a formula across a row or down a cor, an absolute all Reference or a mind cell reference may be preferred if a speed Excel function is to be usad the directions will specify the water of thar function. Do not type in numerical data into a cell or fiction. Instead, make a reference to the olla which the data is found Make your computation only in the blue els highlighted below. In all cases, onless otherwise directed, we the earlier appearance of the data in your formulas, wally the Giver Data section 2. What is the price (expressed as a perontage of the face value of the Treasury bond? b. What is the price (expressed as a percentage of the face value of the BBB-rated corporate bond? c. What is the credit spread on the BBB bonds? RA EUR BBB bond YTM Treasury YTM Coupon rate Maturity (years) Face value 8.294 6.59 7% 5 1.000 $ What is the price (expressed as a percentage of the face values of the Treasury bend? le 11 RMRE Coupon Number of periods Seminal YTM Bond price Percentage of face value 22 b. What is the price (expressed as a percentage of the face value of the BB3-stad corponce bond? 23 14 RRRRRR Semua YTM Bood price Percentage of see value 20 What is the credit spread on the BBB bonds Spread 6-30 +