Yield Curve 1 mo 9/1/2011 9/2/2011 3 mo 6 mo 0.02 1 yr 2 yr 3 yr 5 yr 7 yr 0.88 2 yr 16 30 37 39 48 51 54 72 80 85 195 205 215 275 285 295 460 4.71 3...

You are an intern with Sirius Satellite Radio in their corporate finance division. Thefirm is planning to issue $50 million of 12% annual coupon bonds with a ten-yearmaturity. Your boss wants you to determine the price of the bond and the initial yieldto maturity based on Sirius current bond rating. To prepare this information, you willhave to determine Sirius' current debt raring and the yield for their particular rating.In Excel create a timeline with the cash flows and discount rates you will need to value the new bond issue.a. To create the required spot rates For Sirius' issue add the appropriate spread to the Treasury yield of the same maturity.