Please help with Parts A, B, AND C.

Listed here, are data that pertain to the corporate bond market. (Note: Each "period below covers a span of 6 months.) a. Compute the confidence index for each of the four periods listed above b. Assume the latest confidence index (for period 0, in effect) amounts to 86.83%, while the yield spread between high- and average-grade corporate bonds is 85 basis points. Based on your calculations, what's happening to bond yield spreads and the confidence index over the period of time covered in the problem (i.e., from period o through period 4)? C. Based on the confidence index measures you computed, what would be your overall assessment of the stock market? In which one or more of the periods (1 through 4) is the confidence index bullish? In which one(s) is it bearish? a. Confidence index for period 1 is % (Round to two decimal places.) Data table 5.73% (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Period 1 Period 2 Period 3 Period 4 Average yleld on 10 high-grade 5.35% 5.06% corporate bonds Yield on the Dow Jones average of 6.48% 8.01% 4.88% 40 corporate bonds Yield spread (in basis points) 152 24 Confidence index 7 ? ? Print Done 1