Company C is planning to issue bonds and the company's directors are considering two different options. Part (a) Using the information provided for Option 1, please calculate the following: - Gross yield of Option 1 - The total interest payable each year if they use Option 1 Part (b) Using the information provided for Option 2, please calculate the following: - Gross yield of Option 2 - The total interest payable each year if they use Option 2 Please ensure that you use formula wherever appropriate, so that the answers automatically update if any of the information changes. Part (b) Please complete the following for Option 2 Number of years Interest per bond Market value per bond Redemption value per bond Gross yield Total interest payable per year