A B Face Value: Number of Years: Stated Interest Rate: Interest payments per year Note: The bonds pay interest semiannually. 1 2 On January 1, Ruiz Company issued bonds as follows: 3 4 5 6 7 8 9 10 Required: 11 1) Given the different market interest rates below, calculate the following items. 12 Calculate the bond selling price using the Excel PV function. Enter all function arguments as cell re 13 Semiannual Interest Payment: Bond Selling Price: $500,000 Semiannual Interest Payment: Bond Selling Price: 30 7% 14 (Use cells A4 to 87 from the given information to complete this question.) 15 2 16 a) Market Interest Rate: 17 18 19 20 b) Market Interest Rate: 21 22 23 24 2. Use the answer either "Premium" or "Discount" to the following items. C 9% 5.50% D TU 11 12 13 14 (Use cells A4 to B7 from the given information to complete this question.) 15 16 a) Market Interest Rate: 17 Semiannual Interest Payment: 18 Bond Selling Price: 19 20 b) Market Interest Rate: 21 2224258358 1) Given the different market interest rates below, calculate the following items. Calculate the bond selling price using the Excel PV function. Enter all function arguments as cell references Semiannual Interest Payment: Bond Selling Price: 24 2. Use the answer either "Premium" or "Discount" to the following items. 26 The bond in (a) sold at a: 27 The bond in (b) sold at a: 29 30 9% 5.50% 32 33 31 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be us Nothing in this area will be graded, but it will be submitted with your assignment.