What is the yield to maturity on the following bonds; all have a maturity of 10 years and a face value of $1,000, and a coupon rate of 9% (paid semiannually). The bonds' current market values are $945.50, $987.50, $1,090.00, and $1,225.875, respectively.

Problem 6: Using a Spreadsheet to Calculate Yield to Maturity (LG 3-2) Student Name: Course Name: Select the red highlighted items below for tips and suggestions to complete this problem. Problem 6: Using a Spreadsheet to Calculate Yield to Maturity (LG 3-2) Student Name: Course Name: Select the red highlighted items below for tips and suggestions to complete this