ࡱ> MOL` bjbjss 3( %` ` ` ` ` ` ` t 84t 400"RRR.G[ ^#`#`#`#A#D+D)4$\6h8M4` (@((M4` ` RRb4(` R` R^#(^#:,` ` lR$ X #Lx404RF9jF9llF9` R gZ@45gggM4M48Xggg4((((t t t t t t t t t ` ` ` ` ` `   GENEVA EXECUTIVE COURSES IN FINANCE  Performance Evaluation and Attribution (PEVA) Theory and Practical Application October 2 - 6, 2006  Professor Russ Wermers September 9, 2006 ( 2006 R. Wermers Lab Exercise #1, Part A: Computing and Comparing Basic Performance Measures Objective: Our objective with this exercise is to compute some basic performance measures using Excel, and to examine how our ranking of a group of managers changes under these different measures. Thus, we look at some of the issues pointed out by Roll (1978) and others. The following Excel data tables are available for you to complete todays list of tasks: A. net_returns_for_crystal_ball.xls -- This file contains monthly net returns for several U.S. mutual funds. The date is in the first column, formatted as RYYMMDD, where YYMM is the year and month (ignore the R and DD characters) B. t-bills and s&p 500 (monthly).xls -- This file contains the monthly returns for 30-day U.S. Treasury Bills (tbillretto) and S&P 500 stocks (sp500retto; value-weighed and rebalanced monthly, with cash dividends reinvested). The date is in the first column, formatted as YYMMDD (again, ignore the DD characters) C. msp500.xls -- This file contains the monthly returns for both the equal-weighted (ewretd) and value-weighted (vwretd) S&P 500 stocks (rebalanced monthly, with cash dividends reinvested). The date is in the first column, formatted as YYYYMMDD (again, ignore the DD characters) Please complete the following tasks: 1. Compute the arithmetic average monthly return of each fund, and rank the funds by this simple measure. 2. Compute the geometric average monthly return of each fund, and re-rank the funds. How and why is this ranking different from #1? 3. Compute the Jensen measure of each fund, and re-rank the funds. Assume that the value-weighted S&P 500 index is the market. How and why is this ranking different from #1? 4. Repeat #3, this time using the equal-weighted S&P 500 index as the market. How and why is this ranking different from #3? 5. Compute the tracking error variance of each fund, using the value-weighted S&P 500 as the benchmark. Re-rank funds by this measure (that is, the top fund will have the lowest tracking error variance, and the bottom fund will have the highest TEV). Thus, do not consider the tracking error gain in this exercise. What does this ranking tell you about the risk-taking behavior of these funds? What doesnt it tell you (i.e., systematic vs. idiosyncratic risk-taking)? 6. Using the Jensen model of #3, compute the information ratio of each fund, and re-rank the funds. How and why is this ranking different from #3?     PAGE  PAGE 1 &'(NUwrararaQ?"h\hk5CJOJQJ\aJh\hk>*CJOJQJaJ h1hk@CJOJQJaJhk@CJOJQJaJhk5OJQJaJ h\hk5OJQJaJ h\hkCJOJQJaJ0jh\hkCJOJQJUaJmHnHu+h\hk5B*CJOJQJ\aJph%hk5B*CJOJQJ\aJph hk5@jhfhk5@U&(Vwx   f  ^`gd63 gd63$a$gd_$a$ Jgdk  0h*$gdkgdk$a$gdkgdk    & Ӿ񯢒uj_M>h~ uh2rCJOJQJaJ"h~ uh2r5>*CJOJQJaJh~ uh2rOJQJh~ uhxOJQJh~ uhx5>*CJOJQJhd65>*CJOJQJh~ uh2r5>*CJOJQJh~ uhxCJ OJQJh\hkCJOJQJaJ( jh\hk5CJOJQJ\aJ"h\hk5CJOJQJ\aJhkCJOJQJaJhk5CJOJQJ\aJ 0 7 8  + - . < N ӵӦ|ċpċaaaph~ uh@"CJOJQJaJhsY-CJOJQJaJh~ uhdCJOJQJaJh~ uhn&CJOJQJaJh& CJOJQJaJh~ uhe,CJOJQJaJh~ uhXCJOJQJaJh~ uh63CJOJQJaJh~ uh2rCJOJQJaJh~ uhrNCJOJQJaJh~ uh`CJOJQJaJ!f , h O 34YZLM  ^gd63  ^gd63 ^`gd@" gd63 ^`gd63N g i n w     V W f q 3Ǹ帩ǚ|֋֋֋֋֋m^^h~ uh7CJOJQJaJh~ uhQCJOJQJaJh~ uhXCJOJQJaJh~ uhBxCJOJQJaJh~ uh63CJOJQJaJh~ uh@"CJOJQJaJh~ uhe,CJOJQJaJh~ uhn&CJOJQJaJh~ uh oCJOJQJaJhsY-CJOJQJaJh~ uh9cCJOJQJaJ$34Y^ju  KQ~$2Q񔣁rrcrTh~ uh|?CJOJQJaJh~ uhA:CJOJQJaJh~ uhECJOJQJaJ%h~ uh]56>*CJOJQJaJh~ uh9ZCJOJQJaJh~ uh]CJOJQJaJh~ uhQCJOJQJaJh~ uh?9xCJOJQJaJh~ uh2rCJOJQJaJ"h~ uh2r5>*CJOJQJaJh~ uhF%CJOJQJaJ]^  &`#$\]b  οοΆ~z~z~z~zpjpjfpjp[pjfzhk0JmHnHuh+LE h+LE0Jjh+LE0JUh~jh~Uh~ uh2rCJOJQJaJh~ uh]CJOJQJaJhMCJOJQJaJh~ uhA:CJOJQJaJh~ uh?9xCJOJQJaJh~ uhECJOJQJaJh~ uh|?CJOJQJaJ%h~ uh|?56>*CJOJQJaJ#10 :p o/ =!"8#8$% Dd >TID  3 (A"`b\?~4>@Aj8Dn0?~4>@AjPNG  IHDRl9F&sRGBIDATx^sIJ*UIQ e2Y``DqXgL%2$Y"Hym$t|3#S݅u}קov/GD@DncKD@D`@@28^LzH" "k^Wɴb@D@zM@2s" " V @ H{]=rND@$ӊ5tGΉdZ1 " & u9L+D@D$ӽ9'" iŀd#D@D@2^LzH" "k^Wɴb@D@zM@2s" " V @ H{]=rND@$ӊ5tGΉdZ1 " & u9L+D@D$ӽ9'" iŀd#D@D@2^LzH" "k^Wɴb@D@zM@2s" " V @ v^;(v3`b]n&ͤgs_zgyyٟqbĉOHoJsuG@2/O>ykkcccY[[{xg瞜z F-CLMJ0ӟ ?n֏c5LSf=;hwvB!UPo[Y3~FЊT v)Kvϡ̈l.Bj:t)Ou|Ŧ`t^25d&~Ш]^SOMŃ5g2Qt0;3k{O`gi_9szl Wgg.}LܸjG.xYŝytq;_0{SNtjaa!Se'b8ddΣ^`4Fl)1WccۜO]ip5[H@ͺėM"fI2]RƕC$uNn li;ǗXTI̳?\z便??>5ae(y𩩣/yFaJHK;ѱ1,Ӑ~b+کB1~q'qD=|1{;Uy3pՑtx@RvĿșyW*n(,kzMj|#'M ^b={F޻j݂mS!O?M |zFjoxN'6Zz R-zJJ}¿G)c-..}Vgf*X|G6ṊP:O`O c2))f}U,ݣCO?5녂x\IExRt28#>Q >q磅[GHbuweAT?59FeX{܎WE{'M7~[S3wqn&]6f)sۺQa n 8BT |&H&Y>^FL$\_}dĿaޣ1!Ub䣓 FϝӅ)nNdHwRf u-=} }9 bčΟ޺t3O~+ b9.dկҭ,i щ;F{ ;]k~Qԩ2(:T|ٟNt_yQ~1Co:6M#Q[/#g9KL?a0[]lLy&߃ LeT8j ֌[&!@5}^֗GGrk|wL]ҥ0}[>~uNz7"={ץwUsB'7^3vQ8732d?l̮5YQ$dnvңFnczQd[&˘Sbgнm$Lס^q>TG~tLx/75eL7{)(N&Ii6c?.xc#|Pa`Tw:f)Y-DכٍӎZʸ>}B}*P֛LNgzbJ'4mԯmٶ62,(ֱVD]\Z6eUsqv}EjKŕ=a ڨlb0 x7fO ymyd,h/m.[b}X\=#ˣh[53_nIIw'{`EI'T=VϺPeM}|:Uc}/IًNq4WDcԔ}Z>aeÀ,&Pa Ѕz k3@uRi8f/?x>VL9 ~O0uu5#a1$s }1]ζ.עZA6(۴ j>;d1Ob;u’Pz]6<1o@Og!.d\{ zqlfXy19a  Lp+<x98t-4&^48ϖ[jkna}qq160֬좖OGx:n1ƛ†?^ }!>,zY?w=|zd{>sWfʲ>▉?rzZn}qj̾ˌv:ԯTg]=WܮPdEf~% fe4 c}F#%:2dzk9}XgsW+}dhvzl:cgWeӎdlss/Gomn #MGi(k.e=B|yׯYKr(&Qggqr{6onXjGG_k7w:"km +A0d7[tsjR)ze{0G|idqMvP|QG^M^w^p.j y$Cdv Y~.N{gOJM.OFYCd7Qb(e{?1vIxeWe֗b&hbcM4KƗM#CpMwP% )p< B,K&8=[LM0L:xjK' w:(+v-w"Qxt.8@lIdg}c1tPb𗄭꓌ }h+@b)F%$8Þ vٛ8`BtGc7hV+/eEגj{{0eW >ľ} D-{gH1{:#OTUJxXKP}A]рv6;+ VHVPrU ,kq|ƚ-;VvюTG  ,xQѼQgu!W3~04ŝ R9 Th1m 'e!2Yv~`c)dL7fHz*I})޴X(7o/ B.c g}{ކvO iD.zNKwBq+Ӹcm| PՒiP6{ d ޗG7îG;O˯7}eƁCr 5,^ 9VNle1=@Ull_p{ cu:bI:h٭re0(aR3~O{YŠ9*>4!Qa"_2xpcZdD2JZE*5d%@en hn[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - H[Tv薀d[." - EL-IENDB`8@8 3^Normal_HmH sH tH >@> Heading 1$$@&a$CJ X@X Heading 2!$$  @&^a$ 5>*CJ^@^ Heading 3$$ 0h*$@&a$5>*@CJOJQJb@b Heading 4$$ 0h*$@&a$5@CJOJQJ\^@^ Heading 5$$ 0h*$@&a$5@CJOJQJ\f@f Heading 6&$$ & F 0h*$@&a$5@CJOJQJf@f Heading 7&$$ & F 0h*$@&a$5@CJOJQJJ@J Heading 8$  @& >*CJ \B @B Heading 9 $$@&a$>*CJ DA@D Default Paragraph FontVi@V  Table Normal :V 44 la (k@(No List 4 @4 Footer  !.)@. Page Number>'> Comment ReferenceCJ4@"4  Comment TextPB@2P ;$ Body Text h8p@CJ\aJZP@BZ Body Text 2$ 0h*$a$5@CJOJQJTOQT text11567>*CJOJQJS*Y(\]aJo(phfffVQ@bV Body Text 3$ 0h*$a$ @CJ\0>@r0 Title$a$CJ HH g Balloon TextCJOJQJ^JaJ (&(Vwxf,hO34YZLM] ^      @0@0@0@0@08@0W8@0W@0y@0y@0y@0y0t0t0t0t0t0t0t0t0t00t00t000t0t0t0t0t0t0t0t0t0t0t0t0t0t0t0t0t0t0th00@0h00@0h00@0h00@0h00@0@0@0@0@0@0h008&(Vwx @0@0@0 @0 @0:@0V:@0V@0x@0x@0x@0x 00 $$$' N 3 f    '!!8>?@>>(  NB = S DoNB > S DoB S  ?& >j"t=j"t OLE_LINK1 OLE_LINK2  A YA TYA YA YA YA ,b  B*urn:schemas-microsoft-com:office:smarttagscountry-region9*urn:schemas-microsoft-com:office:smarttagsplace8*urn:schemas-microsoft-com:office:smarttagsCity h  hn     hnimWe     33333333      f(WD_~g<^`o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L.808^8`0o(.^`.pLp^p`L.@ @ ^@ `.^`.L^`L.^`.^`.PLP^P`L._f(W0        ®          a8^n-[R;`RD,17 L Wwd!R;`, .,1"1d!5;, =fRqMq=\E@L `C\E`CQ9R=miWfRq[7 I]fRq8^5xnWI"dL eAhRD=m .n;5xnfRq5B.vfRqWwu yL |_Y+;`M0k D ox,z ( y [@"N,_NM& #>#;$sY-M/r2X2U~2363eT3X3?&8A:\:7);C; =|?wYw~w?9x ~x'zg{s|,g~9{>~~X~wH%_' EQ`9Eedf ?d|!7Sco:O ,lX_Bx;?@ABCEFGHIJKNRoot Entry F~YPData 1TableZ9WordDocument3(SummaryInformation(<DocumentSummaryInformation8DCompObjq  FMicrosoft Office Word Document MSWordDocWord.Document.89q