b). Find one bond for each of the above 10 companies, and fill in the information in Table 2: Bond Level information. You should calculate the number of years until maturity, average yield to maturity, and Bid-ask spread (27 marks).

Here are the requirements:

1. All the 10 bonds should be bullet bonds (callable, puttable, extendable bonds are not allowed)
2. All the 10 bonds should have similar time to maturity (You cannot have one bond maturing in half year, but the other ones maturing in 10 years). You dont need to make them have the exact same maturity, but you should try your best to find the closest matches.
3. The Number of years until maturity is the difference between the maturity date and the current time you obtain the bond information, rounded to one digit after the decimal point.
4. The average yield to maturity is the average of the bid yield to maturity and ask yield to maturity.
5. The bid-ask spread is the difference between ask price and bid price.

Given these two tables information, answer the following questions:

a). What is the relationship between Altman Z-Score and credit rating? (2 marks)

b). What is the relationship between the average yield to maturity and credit rating? (2 marks)

c). What is the relationship between the bid-ask spread and credit rating? (2 marks)

	Company Name	Bond CUSIP	S&P bond level rating	Outstanding Amount	Maturity Date	Number of years until Maturity	Coupon Rate	Coupon Frequency	Bid Price	Ask Price	Bid Yield to Maturity	Ask Yield to Maturity	Average Yield to Maturity	Bid-Ask Spread
1
2
3
4
5
6
7
8
9
10