how to calculate this

Problem 5 Intro You purchase the following bond. The bond makes interest payments on May 15 and Nov. 15 of every year: A B 1 Purchase date 4/7/2021 2 Price (% of par) 75.05 3 Face value $1,000 4 Coupon rate 5.8% 5 Maturity date 11/15/2031 6 Payment frequency Semiannual 7 Day count basis 30/360 4 5 6 IB | Attempt 3/10 for 10 pts. Part 1 What is the bond's YTM using Excel's YIELD function? 3+ decimals Submit