BOND COMPARISONS: Using the bond information below, fill in the cells of the Bond worksheet. You will ultimately need to calculate some missing value for each of the listed securities. Issuer Par Value Coupon Current Price Payments/Year Rating Years to Maturity Sears 15 $1,000 .065 2 Xrom 10 $1,000 None None BBB Gap 12 $1,000 .08 $1,125 2 Unknown GE 20 $10,000 .06 2 AA Verizon 30 $5,000 .07 N AAA Iomega 6 $1,000 .07 $840 2 Unknown Cisco 15 $1,000 .055 2 AAA Wendy's 3 $1,000 .085 $1,047 2 Unknown $1,000 None S500 None AAA US Savings Bond After you're finished inputting the bond information, click on the "Chart" tab on the bottom of the worksheet. Highlight the three columns (both name of issuer and data) and on the chart icon. Choose "Line" graph, and then choose the graph which connects the dots with a line. Be sure to name the graph and the x and y axes. What are the likely ratings for the three unknown bonds? Why might Wendy's and the Gap be selling at a premium? What could have happened since these bonds were issued? h (United States) View Tools Window Help Insert Format Data e Edit AutoSave OFF (c M Data Review View Tell me Insert Formulas Draw Page Layout 10 A A 2 Wrap Text v w Arial Cut Copy v Format 10 10 lile aA Merge & Center v v B c D E Bond Comparison Bond Rating Market interest rate AAA Bond 6.50% AA Bond 6.75% A Bond 7.00% BBB Bond 7.50% GE AA Sears A Xcom BBB Veron AAA 30 $5.000 7.00% 2 20 $10,000 6.00% 2 15 $1,000 6.50% 2 10 $1,000 0.00% 0 Band issuer Rating Years To Maturity Par Value Coupon Rate Payments Per Year Periodic Coupon Rate Coupon Payment Periodic Market Rate Number of Periods Curres Bond Price Yield To Maturity Current Yield Bond issuer Rating Yours To Maturity Par Value Coupon Rate Payments Per Year Potlodi Coupon Rate Coupon Payment Parodie Market Rate Number of Periods Current Bond Price Yield To Maturity Current Yield Gap Choo AAA Somega Wendys 15 $1,000 5.50% 2 12 $1,000 8.00% 2 6 $1.000 7.00% 2 $1.000 8.50% 2 1.125.00 840.00 1.047.00 Bond Info Bond Chart + [6 Copy Paste B I U v v Format 2 Xfx ="Bond Info'!F20 A B Bond Name Verizon GE Sears Xcom Cisco Gap Iomega Wendy's Yield to Maturity 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Coupon Rate 7.00% 6.00% 6.50% 0.00% 5.50% 8.00% 7.00% 8.50% BOND COMPARISONS: Using the bond information below, fill in the cells of the Bond worksheet. You will ultimately need to calculate some missing value for each of the listed securities. Issuer Par Value Coupon Current Price Payments/Year Rating Years to Maturity Sears 15 $1,000 .065 2 Xrom 10 $1,000 None None BBB Gap 12 $1,000 .08 $1,125 2 Unknown GE 20 $10,000 .06 2 AA Verizon 30 $5,000 .07 N AAA Iomega 6 $1,000 .07 $840 2 Unknown Cisco 15 $1,000 .055 2 AAA Wendy's 3 $1,000 .085 $1,047 2 Unknown $1,000 None S500 None AAA US Savings Bond After you're finished inputting the bond information, click on the "Chart" tab on the bottom of the worksheet. Highlight the three columns (both name of issuer and data) and on the chart icon. Choose "Line" graph, and then choose the graph which connects the dots with a line. Be sure to name the graph and the x and y axes. What are the likely ratings for the three unknown bonds? Why might Wendy's and the Gap be selling at a premium? What could have happened since these bonds were issued? h (United States) View Tools Window Help Insert Format Data e Edit AutoSave OFF (c M Data Review View Tell me Insert Formulas Draw Page Layout 10 A A 2 Wrap Text v w Arial Cut Copy v Format 10 10 lile aA Merge & Center v v B c D E Bond Comparison Bond Rating Market interest rate AAA Bond 6.50% AA Bond 6.75% A Bond 7.00% BBB Bond 7.50% GE AA Sears A Xcom BBB Veron AAA 30 $5.000 7.00% 2 20 $10,000 6.00% 2 15 $1,000 6.50% 2 10 $1,000 0.00% 0 Band issuer Rating Years To Maturity Par Value Coupon Rate Payments Per Year Periodic Coupon Rate Coupon Payment Periodic Market Rate Number of Periods Curres Bond Price Yield To Maturity Current Yield Bond issuer Rating Yours To Maturity Par Value Coupon Rate Payments Per Year Potlodi Coupon Rate Coupon Payment Parodie Market Rate Number of Periods Current Bond Price Yield To Maturity Current Yield Gap Choo AAA Somega Wendys 15 $1,000 5.50% 2 12 $1,000 8.00% 2 6 $1.000 7.00% 2 $1.000 8.50% 2 1.125.00 840.00 1.047.00 Bond Info Bond Chart + [6 Copy Paste B I U v v Format 2 Xfx ="Bond Info'!F20 A B Bond Name Verizon GE Sears Xcom Cisco Gap Iomega Wendy's Yield to Maturity 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Coupon Rate 7.00% 6.00% 6.50% 0.00% 5.50% 8.00% 7.00% 8.50%
