Please answer using Excel and leaving step by step instructions for calculations, thank you!

Problems to be solved Using Excel (20 points) Provide your responses to the following problems in Excel. Please use a separate tab for each of the problems. Responses are to be submitted using Canvas by 11:59pm on November 10th The questions are worth 623 points each. 1. A bond with 5 years remaining until maturity is currently trading for 101 per 100 of par value. The bond offers a 6% coupon rate with interest paid semiannually. The bond is first a callable in 3 years, and is callable after that date on coupon dates according to the following schedule: End of Year Call Price 102 101 100 a.) What is the YTM? b.) What is the Yield to 1" Call? c.) What is the Yield to 2nd Call? d.) What is the Yield to Worst