Given the information in Table 12.1, calculate Treynor's Performance Index: (Use proper identifier and show 4 decimals)

a) TPI (100% Long) =

b) TPI (Long Margined at 52%) =

c) TPI (Short at 59%) =

d) TPI (T-Bond) =

Tools Data Window 83% 0 Sun 10:03 PM Tony Laaksonen Q E Excel File Edit .. AutoSave OFF Home Insert Draw View Insert Format DES Page Layout Formulas Help AS#12-Performance(FIN3520) Data Review View Share 2 470 Comments 47 v - 16 AA = = - B L Baghdad BI U D = ? SE Insert X Delete General $ %, A 8-9 Ideas Formatting as Table Format Sort Filter Styles X Find & Select V D2 E F G H I K L M N Table 12.1 Security Adobe 100% Adobe LM Adobe Short HPR 13.29% 25.56% Measures of Risk & Return CAPM 3.3056% 1.2812% 5.1370% 2.4639% -2.0450% -2.1716% Calculate 0.3177% 1.3200% 0.0000% 13.0000% 0.0000% -22.53% Std. Dev. 5.7500% 11.0600% 9.7500% 0.7684% NA 10.6700% Beta 0.1700 0.3268 -0.2881 0.9625 0.0000 1.0000 o 5.4586% 10.4973% 9.2518% 0.5154% 0.0000% 0.0000% T-Bond 1.37% Risk-Free Rate 1.32% S&P 500 13% Table 12.1 + i E - + 100% Tools Data Window 83% 0 Sun 10:03 PM Tony Laaksonen Q E Excel File Edit .. AutoSave OFF Home Insert Draw View Insert Format DES Page Layout Formulas Help AS#12-Performance(FIN3520) Data Review View Share 2 470 Comments 47 v - 16 AA = = - B L Baghdad BI U D = ? SE Insert X Delete General $ %, A 8-9 Ideas Formatting as Table Format Sort Filter Styles X Find & Select V D2 E F G H I K L M N Table 12.1 Security Adobe 100% Adobe LM Adobe Short HPR 13.29% 25.56% Measures of Risk & Return CAPM 3.3056% 1.2812% 5.1370% 2.4639% -2.0450% -2.1716% Calculate 0.3177% 1.3200% 0.0000% 13.0000% 0.0000% -22.53% Std. Dev. 5.7500% 11.0600% 9.7500% 0.7684% NA 10.6700% Beta 0.1700 0.3268 -0.2881 0.9625 0.0000 1.0000 o 5.4586% 10.4973% 9.2518% 0.5154% 0.0000% 0.0000% T-Bond 1.37% Risk-Free Rate 1.32% S&P 500 13% Table 12.1 + i E - + 100%