could i also get the excel formulas for these solutions please

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