Biology homework help

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.