Use Table 3.2 in the excel file to rank the TPIs: (1pt)

a) The name and TPI of the best performing security is:

b) The name and TPI of the worst performing security is:

Tools Data Window Help 82% O Fri 8:36 PM Tony Laaksonen Q E PS#3Data(FIN3520) View Excel File Edit View Insert Format .. AutoSave OFF OE U Home Insert Draw Page Layout Formulas Verdana (Body) 12 A A Paste BI U D A A18 x fx Data = Review = = Po Share E-49- O aby insert v Comments 4 General $ % EX Delete 28-28 Sort & Filter Find & Select Ideas Formatting as Table Styles Format X V Table 3.1 Solutions TPISPI Securities HPR Total Risk JPI Performance Systematic Alpha Risk -0.000035649 3.41257 0.000033806 -3.23605 -0.001270857 0.00143 AutoZone AZO (LM) AutoZone AZO (Short) 5/15/39 4.25% T-Bond -8.5339% 8.0923% 0.2145% 10.5252% 9.9808% 0.1031% Unsystematic Risk 9.7241% 9.2211% 0.1022% RANK Table 3.2 Securities AutoZone AZO (LM) AutoZone AZO (Short) 5/15/39 4.25% T-Bond 11 Performance Duration Money Market + - - + 100% Tools Data Window Help 82% O Fri 8:36 PM Tony Laaksonen Q E PS#3Data(FIN3520) View Excel File Edit View Insert Format .. AutoSave OFF OE U Home Insert Draw Page Layout Formulas Verdana (Body) 12 A A Paste BI U D A A18 x fx Data = Review = = Po Share E-49- O aby insert v Comments 4 General $ % EX Delete 28-28 Sort & Filter Find & Select Ideas Formatting as Table Styles Format X V Table 3.1 Solutions TPISPI Securities HPR Total Risk JPI Performance Systematic Alpha Risk -0.000035649 3.41257 0.000033806 -3.23605 -0.001270857 0.00143 AutoZone AZO (LM) AutoZone AZO (Short) 5/15/39 4.25% T-Bond -8.5339% 8.0923% 0.2145% 10.5252% 9.9808% 0.1031% Unsystematic Risk 9.7241% 9.2211% 0.1022% RANK Table 3.2 Securities AutoZone AZO (LM) AutoZone AZO (Short) 5/15/39 4.25% T-Bond 11 Performance Duration Money Market + - - + 100%