how do in solve these? it didnt work for me in excel

Homework . Due in 6 hours A Tesla coupon bond with a face value of $1,000 has a coupon rate of 6% with annual coupons and it will mature in 5 years. If it is currently trading at $844.2, what is its yield-to-maturity? Round to the tenth of a percent (eg, 4.32%= 4.3) [Hint Use Excel's "rate" function as explained in the text. Make sure you set the cell to show decimal places.] Type your numeric answer and submit Unanswered. 3 attempts left Submit Question 10 Homework Answered Consider a semi-annual coupon bond with a 4% coupon rate, 10 years to maturity and $1,000 face value trading at $1,052 What is this bond's yield to maturity? Round to the tenth of a percent (e.g., 4.32% = 4.3) Type your numericanswer and submit X 1 Fullscreen You are incon Rate (nper, pmt, pv, [fu) * Semi-annual 4% coupon, 10 yrs maturity 1,000 face vale trading price 1,052 RATE ( 10x2,4/2, -1052, 1,000) 0584 .IX Z 0 X