We claimed that bonds that pay interest monthly are rare, and that most bonds pay interest semiannually. Using the S&P 500 Company Outstanding Bonds.xlsx workbook from the official Web site (www.cengage.com/finance/ mayes/analysis/9e) check to see if that statement is correct.

a. Open the file and clean the data using Get & Transform. In particular, multiply the amount outstanding by one million, convert the issue date column to an actual date (use Column from Examples on the Add Column tab), and remove all of the records that have @NA in the Coupon Freq column.

b. Create a pivot table that shows each coupon payment frequency and how many times it occurs in the dataset. Show this count as % of Grand Total.

c. Filter out the coupon frequencies that occur less than 1% of the time and then create a pivot bar chart that shows the results.

d. Create another pivot table and bar chart that shows coupon payment frequency by Factset sector. Show only monthly and quarterly frequencies. Which sector tends to issue the most bonds with those payment frequencies?