On January 1, Ruiz Company issued Bonds as Follows:

As mentirolo FOX esbon education.com/ext/map/index.html?_cons.contexternal browser to launch Urdt25 ation 9-12 Bond Pricing Using Tables 1 Calculate the price of a bond using tables BR. Bord Pricing - Excel FORMULAS DAIA HOME INSERT PAGE LAYOUT REVIEW Paste AA 96 - Alignment Number Conditional Forma Fomitting BTV Opboard Fort AL On January 1, Ritz Company Sundbords c On July 1, Rui Company issued bonds as follow 2 3 Face Value 500 000 4 Number of Years: 5 State interest Rates 5 interest payments pery 2 > 1 Required: 101) Calculate the bond selling price given the two market interest rates below. 11 Useformitas that reference data from this worksheet and from the appropriate futi 12 persent value tables found by dicking the tabs at the bottom of this worksheet) 11 Note: Rounding is not required 14 ) Annual Market Rate 15 16 Seminterest Pay 17 PV of Face - of interest Payments 19 Bondan Price 20 22 Annual Mantate 6.09 22 25 to search c 22 - Bond Pricing Using 1 Calculate the price of a bond using tables B5 FILE Bond Priong Excel FORMULAS DATA HOME INSERE PAGE LAYOUT VIEW REVIEW X Calon Paste AN - Alignment Number Conditional Formatas Cal Fomuning Styles Sye Gipboard For AL On January 1, Ruit Company issued bonds as follow c D E 101) 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 tales at the bottom of this worksheet) 11 Note Rounding is not required 1) Annual Market Rate 9 15 16 Semiannual interest Payment pvol Face Val 18 pofterest Payments 15 Band Selling Prices 30 316 Annual Mate SON 22 17 23 Semiannual interest 34 PV of Face Value 25 py of interest Payment 20 Jean San Price 11 28. the function to answer the Premium.com to the following items 39 30 The bond old 32 The bondino an O P c - . 3 1. Calculate the price of a bond using tables OH. FILE HOME tond Pianger FORMULAS DATA INSERT POE LAYOUT REVIEW WEW CA -AA Armera Note Condition Format Cat Fontatting Table Styles GO Paste BIU Tone AI 2 On laruary 1 Rue Company issued bonds as follows A 0 cond Selling Prices 20 21 Annual Marketit 6. Seranual interest Payment 24 JPV of Face 25 por interest Payments 26 Bond Selling Price 77 10 2. Use the well function to answer either "Premium" or the following 20 30 The bond in a 31 22 The bond is soldat 3. Use the PV FUNCTIONtoverly the willing prices of the bonds 35 Annual Market Bond Selling Price Ana Marietate Bond Selling Price 3 . The Art of Sheets arch O 0 5 As mentirolo FOX esbon education.com/ext/map/index.html?_cons.contexternal browser to launch Urdt25 ation 9-12 Bond Pricing Using Tables 1 Calculate the price of a bond using tables BR. Bord Pricing - Excel FORMULAS DAIA HOME INSERT PAGE LAYOUT REVIEW Paste AA 96 - Alignment Number Conditional Forma Fomitting BTV Opboard Fort AL On January 1, Ritz Company Sundbords c On July 1, Rui Company issued bonds as follow 2 3 Face Value 500 000 4 Number of Years: 5 State interest Rates 5 interest payments pery 2 > 1 Required: 101) Calculate the bond selling price given the two market interest rates below. 11 Useformitas that reference data from this worksheet and from the appropriate futi 12 persent value tables found by dicking the tabs at the bottom of this worksheet) 11 Note: Rounding is not required 14 ) Annual Market Rate 15 16 Seminterest Pay 17 PV of Face - of interest Payments 19 Bondan Price 20 22 Annual Mantate 6.09 22 25 to search c 22 - Bond Pricing Using 1 Calculate the price of a bond using tables B5 FILE Bond Priong Excel FORMULAS DATA HOME INSERE PAGE LAYOUT VIEW REVIEW X Calon Paste AN - Alignment Number Conditional Formatas Cal Fomuning Styles Sye Gipboard For AL On January 1, Ruit Company issued bonds as follow c D E 101) 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 tales at the bottom of this worksheet) 11 Note Rounding is not required 1) Annual Market Rate 9 15 16 Semiannual interest Payment pvol Face Val 18 pofterest Payments 15 Band Selling Prices 30 316 Annual Mate SON 22 17 23 Semiannual interest 34 PV of Face Value 25 py of interest Payment 20 Jean San Price 11 28. the function to answer the Premium.com to the following items 39 30 The bond old 32 The bondino an O P c - . 3 1. Calculate the price of a bond using tables OH. FILE HOME tond Pianger FORMULAS DATA INSERT POE LAYOUT REVIEW WEW CA -AA Armera Note Condition Format Cat Fontatting Table Styles GO Paste BIU Tone AI 2 On laruary 1 Rue Company issued bonds as follows A 0 cond Selling Prices 20 21 Annual Marketit 6. Seranual interest Payment 24 JPV of Face 25 por interest Payments 26 Bond Selling Price 77 10 2. Use the well function to answer either "Premium" or the following 20 30 The bond in a 31 22 The bond is soldat 3. Use the PV FUNCTIONtoverly the willing prices of the bonds 35 Annual Market Bond Selling Price Ana Marietate Bond Selling Price 3 . The Art of Sheets arch O 0 5