File Home Insert Draw Formulas Data Review View Help Calibri |11 B I Av B18 k A 2 3 On January 1, Ruiz Company Issued bends as follows: 4 Face Amount: 5 Number of Years: Stated Interest Rates 7 Interest payments per year $500,000 30 196 2 8 Note: The bonds pay interest semiannually. 9 10 Required: 11 Editing = Merge Currency $ -0 Conditional Formatting Styles v Format As Tablew Format v 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.) 75 16 a) Market Interest Rate: 9% 17 Semiannual Interest Payment: 18 Bond Selling Price: 19 20 b) Market Interest Rate: 5.50% 21 Semiannual Interest Payment: 22 Bond Selling Price: 23 24 2. Use the answer either "Premium" or "Discount" to the following items. 25 26 The bond in (a) sold at a: 27 The bond in (b) sold at a 28 20 F G H J K L M N P Q R Comments v