Table 1: Issuer Level Financial Information \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & CompanyName & CompanyS&PCreditRating(Issuercreditrating) & StockTickerSymbol & Total Assets & EBIT & Sales & ShareholdersEquity & TotalLiabilities & RetainedEarnings & CurrentAssets & CurrentLiabilities & WorkingCapital & AltmanZ-Score \\ \hline 1 & Microsoft & AAA & MSFT & 411.976B & 89.311B & 211.91B & 206.223B & 205.753B & 118.848B & 184.257B & 104.149B & 80.108B & 2.486 \\ \hline 2 & JohnsonandJohnson & AAA & JNJ & 187.378B & 17.845B & 97.773B & 76.804B & 110.574B & 128.345B & 55.294B & 55.802B & (0.508B) & 2.208 \\ \hline 3 & Apple & AA+ & AAPL & 352.755B & 119.44B & 383,933B & 50.672B & 302.083B & (3,068B) & 135.405B & 153.982B & (18.577 B) & 2.230 \\ \hline 4 & Pepsi Co. & A+ & PEP & 92.187B & 10.456B & 90.135B & 17.273B & 74.914B & 67.8B & 21.539B & 26.220B & 4.681B & 2.580 \\ \hline 5 & AllstateCoorporation & A- & ALL & 50.588B & (3.057B) & 54.622B & 17.350B & 80.607B & 50.954B & 19.507B & 63.29B & (43.783B) & 1.379 \\ \hline 6 & GeneralMotors & BBB & GM & 275.83B & 11.369B & 169.728B & 75.685B & 192.11B & 49.251B & 100.451B & 91.173B & 9.28B & 1.2775 \\ \hline 7 & Netflix & BBB + & NFLX & 48.59B & 5.633B & 12.447B & 20.777B & 27.817B & 12.689B & 9.266B & 7.931B & (1.335 B) & 1.419 \\ \hline 8 & Ford & BB+ & F & 255.884B & 6.639B & 169.819B & 43.167B & 212.717B & 31.754B & 116.476B & 96.866B & 19.61B & 1.136 \\ \hline 9 & Tesla & B+ & TSLA & 90.591B & 12.652B & 94.03B & 45.489B & 94.028B & 12.885B & 40.917B & 26.709B & 14.208B & 2.175 \\ \hline 10 & & & & & & & & & & & & & \\ \hline \end{tabular} Table 2: Bond Level Information \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & CompanyName & BondCUSIP & S&Pbondlevelrating & OutstandingAmount & MaturityDate & NumberofyearsuntilMaturity & CouponRate & CouponFrequency & LastTradePrice & Last Trade Yield & LastTradeDate \\ \hline 1 & & & & & & & & & & & \\ \hline 2 & & & & & & & & & & & \\ \hline 3 & & & & & & & & & & & \\ \hline 4 & & & & & & & & & & & \\ \hline 5 & & & & & & & & & & & \\ \hline 6 & & & & & & & & & & & \\ \hline 7 & & & & & & & & & & & \\ \hline 8 & & & & & & & & & & & \\ \hline 9 & & & & & & & & & & & \\ \hline 10 & & & & & & & & & & & \\ \hline \end{tabular} b). (45 marks) 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. 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 don't 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. Given these two tables' information, answer the following questions: a). What is the relationship between Altman Z-Score and credit rating? (3 marks) b). What is the relationship between the last trade yield and credit rating? ( 3 marks) c). What is the relationship between the trading frequency (implied from the last trade date) and credit rating? (4 marks)