Can someone please help me solve the Yeild to Call sections? Please include the formula used

Yield to call is a similar concept to YTM, but measures the return to the earliest Call Date rather than to the Maturity date. The final repayment of principal includes a Call Premium equal to one interest payment. In your Rate() function, be sure to add that as a part of the FV to be received at maturity. Calculate Yield to Call: - Bond par Years remaining to maturity: Years remaining to earliest call Call premium (penalty): Coupon rate: Payments per year: Price paid for bond: $ 1,000 25 18 64% 5.20% 2 $ 972 4 Bond par Years remaining to maturity: Years remaining to earliest call Call premium (penalty): Coupon rate: Payments per year: Price paid for bond: $ 1,000 22 12 $34.89 4.70% 2 $ 1,022 Yield to Call (Use RATE() function) 5.53% Yield to Call (Use RATE() function) 4.61% Hint: When using the RATE() function, the result is a Periodic rate. We want the APR