1. Calculate the price of a bond using the Excel PV function Bond Pricing Excel HOMEINSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Calibri Paste A. Alignment Number Conditional Format as Cell Cells Editing Formatting Table" Styles ClipboardF Font A1 | On January 1, Ruiz Company issued bonds as follows: 1 On January 1, Ruiz Company issued bonds as fbllows: 2 Face Amount 3 Number of Years: 4 Stated Interest Rate 5 Interest payments per vear 6 (Note: the bonds pay interest semi-annually.) 500,000 15 8% 8 Required 91) Given the different market interest rates below, calculate the following items. 10 Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Enter all 11 function arguments as cell reference:s. 12 13 a) Market Interest Rate: 14 Semi-annual interest payment: 15 Bond Selling Price: 16 17 b) Market Interest Rate: 18 Semi-annual interest payment: 19 Bond Selling Price: 20 21 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items 9% 6.0% 23 The bond in (a) sold at a: 24 The bond in (b) sold at a