please show in excel format/excel equation to solve. thank you!!

Problem 3 - Tidewater Home Health Care, Inc. has a bond issue outstanding with eight years remaining to maturity, a coupon rate of 10 percent with interest paid annually, and a par value of $1,000. The current market price of the bond is $1,251.22. a. What is the bond's yield to maturity? b. Now, assume that the bond has semiannual coupon payments. What is its yield to maturity in this situation? Part A: Yield to Maturity: Note: format of response is 123.45% Part B: Yield to Maturity