I need formulas for these. Thanks

A B D N = 1 On January 1, Ruiz Company issued bonds as follows: 3 4 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 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: 9% 17 Semiannual Interest Payment: $17,500 18 Bond Selling Price: 19 20 b) Market Interest Rate: 5.50% 21 Semiannual Interest Payment: 22 Bond Selling Price: 23 24 2 Ilse the answer either "Premium" or "Discount" to the following items Undo Clipboard Font Alignment Number B17 fx =B4*B6/2 F A B D 7 Interest payments per year 2 8 Note: The bonds pay interest semiannually. 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 references. 13 14 (Use cells A4 to B7 from the given information to complete this question.) 15 16 a) Market Interest Rate: 9% 17 Semiannual Interest Payment: $17,500 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 29