A1 1 Xfx Accessibility tab summary: Bonds issuance by Ruiz Company, is presented in row A B 2345 On January 1, Ruiz Company issued bonds as follows: Face Amount: $500,000 5 Number of Years: 30 6 Stated Interest Rate: 7% 7 Interest payments per year 2 8 Note: The bonds pay interest semiannually. 9 10 Required: 11 D 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 references. 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 9%