Extra Credit Chapt.. Google Slides (201) YouTube hvitation to edit- dit Chapter 10 pona Pricing-Exce HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In 3 Connections Properties Clear ReapplyData From From From From Other Existing Refresh Access Web Text Sources Connections All Sort Filter Tools Sort&Filter Get Extemal Data Connections x On January 1, Ruiz Company issued bonds as follows: A1 1 On Januaty 1, Ruiz Company issued bonds as follows Face Value Number of Years: Stated Interest Rate: Interest payments per year (Note: the bonds pay interest annually.) 500,000 30 7% 9 Required: 10 1) Calculate the bond selling price given the two market interest rates below 11 Use formulas that reference data from this worksheet and from the appropriate future or 12 present value tables (found by clicking the tabs at the bottom of this worksheet). 13 Note: Rounding is not required 14 a) 15 16 17 18 19 9% Market Interest Rate: Annual Interest Payment: PV of Face Value: +PV of Interest Payments: [Bond Selling Price 21 b) Market Interest Rate 55% 1 of 2 Prev Invitation to edit -L... Google Slides (201) YouTube Extra Credit Chapt... UNIT 4-BUSINES Chapter 10 6 pona rricing-Exce HOME INSERT PAGE LAYOUT FORMULAS DATA REVEW view Connections Clear 81 Properties Sort Fitery,Advanced Tools Reapply From From From From Other Existing Refresh Access Web Text Sources Connections Allb Edit Links Data Outl Tools Get Extemal Data Sort& Filter : | on January 1,Ruiz Company issued bonds as follows: fe Al v Bond Selling Price 19 21 b) Market Interest Rate 55% Annual Interest Payment: PV of Face Value 23 +PV of Interest Payments: 25 26 Bond Selling Price 27 28 2. Use the Excel IF function to answer either "Premium or Discount" to the following items. 30 The bond in (a) sold at a: 31 32 The bond in (b) sold at a: 35 Prev 1 of 2 Next> 80 F4 FS F6