I just wanted to check if I did this correctly since my friend solver it by hand and got a different answer. I did =RATE(10,130,830*-1,1000,0)*5 on Excel which gave me a Yield to Maturity of 16.60%.

D 1 Formula 2 Face Value (FV) Given FV 1000 3 Coupon Rate (R) As Above 13% 4 Interest Frequency Assumed Annual An 5 # of coupon payments a year (n) 1 6 Time to maturity (no. of years) (N) Given 10 7 Number of future coupon payments N*n Nper 10 8 Amount of coupon payments FV*R PMT $ 130.00 9 Price Given PV $ 830.00 10 Yield to Maturity (YTM) RATE 16.60% 11 12 13 14 #11 15 Bonds issued by Realogic Company have a par value of $1,000. The 16 bonds are currently priced at $830. The bonds have 10 years remaining 17 until they mature. The annual interest payment is 13 percent ($130). 18 19 20 What is the yield to maturity. (Do not round intermediate calculations. 21 Input your answer as a percent rounded to 2 decimal places.) 22 23 Yield to maturity: 16.60% 24 25 26 27 28 29