Question

1 Approved Answer

Posted on Oct 02, 2024

A B D E F. G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19

image text in transcribed

A B D E F. G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Mar 01 Apr 01 May 01 Jun 01 Jul 01 Aug 01 Sep 01 Oct 01 Nov 01 Dec 01 Jan 02 Feb 02 Mar 02 Apr 02 May 02 Jun 02 Jul 02 Aug 02 Sep 02 Oct 02 Nov 02 Dec 02 Jan 03 Feb 03 Mar 03 Apr 03 May 03 Jun 03 Jul 03 Aug 03 Sep 03 Oct 03 Nov 03 Dec 03 Jan 04 Feb 04 Mar 04 Apr 04 May 04 Jun 04 Jul 04 Aug 04 Portfolio A -4.50% 8.75% 1.03% -2.45% -1.87% -3.77% -7.43% 2.09% 5.94% 1.99% -1.18% -1.45% 4.95% -5.28% -0.68% -8.26% -7.03% 0.80% -10.07% 6.93% 4.13% -4.99% -2.11% -1.51% 1.66% 6.85% 5.13% 1.11% 1.96% 2.37% -0.23% 5.56% 1.48% 4.23% 2.24% 2.34% -0.86% -2.23% 1.88% 2.50% -3.94% -0.19% 1.42% 1.96% 5.21% 3.23% -2.72% Portfolio B -1.10% 1.38% -7.13% 3.68% 2.72% 13.44% -2.11% 2.51% 4.24% 10.09% 1.27% -0.56% -0.86% 3.56% -1.62% 7.47% -2.09% 3.40% -0.32% 2.82% 4.95% -5.70% 5.90% -6.23% 1.78% 3.24% 10.52% 1.09% -17.02% 1.77% 13.19% 12.80% 3.82% 4.50% 8.29% 7.74% 4.09% -9.22% 1.35% -1.96% 8.12% -2.86% 1.15% 0.62% 6.39% 0.44% 1.18% S&P 500 -6.34% 7.77% 0.67% -2.43% -0.98% -6.26% -8.08% 1.91% 7.67% 0.88% -1.46% -1.93% 3.76% -6.06% -0.74% -7.12% -7.79% 0.66% -10.87% 8.80% 5.89% -5.87% -2.62% -1.50% 0.97% 8.24% 5.27% 1.28% 1.76% 1.95% -1.06% 5.66% 0.88% 5.24% 1.84% 1.39% -1.51% -1.57% 1.37% 1.94% -3.31% 0.40% 1.08% 1.53% 4.05% 3.40% -2.44% 90dBill 0.44% 0.38% 0.37% 0.32% 0.31% 0.30% 0.29% 0.26% 0.21% 0.18% 0.16% 0.13% 0.15% 0.14% 0.15% 0.14% 0.15% 0.14% 0.14% 0.14% 0.13% 0.12% 0.11% 0.09% 0.10% 0.10% 0.10% 0.09% 0.09% 0.08% 0.08% 0.08% 0.08% 0.08% 0.08% 0.07% 0.08% 0.08% 0.08% 0.08% 0.10% 0.11% 0.12% 0.13% 0.14% 0.16% 0.18% Sep 04 Oct 04 Nov 04 Dec 04 Jan 05 1 Portfolio A Portfolio B 90 dBill 38 Mar 04 39 Apr 04 40 May 04 41 Jun 04 42 Jul 04 43 Aug 04 44 Sep 04 45 Oct 04 46 Nov 04 47 Dec 04 48 Jan 05 49 Feb 05 50 Mar 05 51 Apr 05 52 May 05 53 Jun 05 54 Jul 05 55 Aug 05 56 Sep 05 57 Oct 05 58 Nov 05 59 Dec 05 60 Jan-06 61 Feb-06 62 Mar-06 Annualized 63 Return Annualized 64 Volatility 65 66 Monthly Vol 67 Avg Mthly Rtn 68 69 -0.86% -2.23% 1.88% 2.50% -3.94% -0.19% 1.42% 1.96% 5.21% 3.23% -2.72% 2.57% -0.58% -2.07% 3.84% 0.66% 4.16% -0.72% 1.96% -2.02% 4.75% 0.83% 4.15% 0.05% 1.00% 4.09% -9.22% 1.35% -1.96% 8.12% -2.86% 1.15% 0.62% 6.39% 0.44% 1.18% 9.27% -1.09% -3.82% -0.06% 5.31% 2.78% -1.15% 7.09% 2.84% 5.94% -4.20% 1.17% 2.23% -5.05% S&P 500 -1.51% -1.57% 1.37% 1.94% -3.31% 0.40% 1.08% 1.53% 4.05% 3.40% -2.44% 2.10% -1.77% -1.90% 3.18% 0.14% 3.72% -0.91% 0.81% -1.67% 3.78% 0.03% 2.65% 0.27% 1.24% 0.08% 0.08% 0.08% 0.08% 0.10% 0.11% 0.12% 0.13% 0.14% 0.16% 0.18% 0.18% 0.21% 0.22% 0.24% 0.24% 0.25% 0.27% 0.27% 0.29% 0.30% 0.32% 0.33% 0.32% 0.37% 5.86% 24.64% 2.57% 2. 19% 13.4% 19.0% 14.2% 0.3% 3.87% 0.55% 5.47% 2.00% 4.10% 0.30% 0.10% 0.18% A D E F G H 1 J K L M N o P Q RE Down/B] Down(B)^2 -1.54% 0.00023797 Down(S&P) -6.78% Down/S&P)^2 0.004591011 -7.50% 0.005622198 -2.76% -1.30% -6.56% -8.36% 0.000759113 0.00016848 0.004306872 0.006992639 -2.39% 0.000572433 -1.62% 2.06% 0.000260952 0.000425226 -0.69% 4.79832E-05 -1.01% 0.000101339 -1.77% 0.000312798 -6.21% -0.89% -7.27% -7.94% B Portfolio A 4.50% 8.75% 1.03% -2.45% -1,87% 3.77% -7.43% 2.09% 5.94% 1.99% -1.18% -1,45% 4.95% -5.28% -0.68% 8.26% -7.03% 0.80% -10.07% 6.93% 4.13% 4.99% 2.11% -1.51% 1.66% 6.85% 5.13% 1.11% 1.96% 2.37% -0.23% 5.56% 1.48% 0.003852685 7.85528E-05 0.005282092 0.006305948 -2.24% 0.000500225 -0.46% 2.10423E-05 -11.01% 0.012112983 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 -5.82% 0.003382902 Mar 01 Apr 01 May 01 Jun 01 Jul 01 Aug 01 Sep 01 Oct 01 Nov 01 Dec 01 Jan 02 Feb 02 Mar 02 Apr 02 May 02 Jun 02 Jul 02 Aug 02 Sep 02 Oct 02 Nov 02 Dec 02 Jan 03 Feb 03 Mar 03 Apr 03 May 03 Jun 03 Jul 03 Aug 03 Sep 03 Oct 03 Nov 03 Dec 03 Jan 04 Feb 04 Mar 04 Apr 04 May 04 Jun 04 Jul 04 Aug 04 Sep 04 Oct 04 Nov 04 Dec 04 Jan 05 Portfolio B -1.10% 1.38% -7.13% 3.68% 2.72% 13.44% -2.11% 2.51% 4.24% 10.09% 1.27% -0.56% -0.86% 3.56% -1.62% 7.47% 2.09% 3.40% -0.32% 2.82% 4.95% -5.70% 5.90% -6.23% 1.78% 3.24% 10.52% 1.09% -17.02% 1.77% 13.19% 12.80% 3.82% 4.50% 8.29% 7.74% 4.09% -9.22% 1.35% -1.96% 8.12% -2.86% 1.15% 0.62% 6.39% 0.44% 1.18% S&P 500 -6.34% 7.77% 0.67% -2.43% -0.98% -6.26% -8.08% 1.91% 7.67% 0.88% -1.46% -1.93% 3.76% -6.06% -0.74% -7.12% -7.79% 0.66% -10.87% 8.80% 5.89% -5.87% 2.62% -1.50% 0.97% 8.24% 5.27% 1.28% 1.76% 1.95% -1.06% 5.66% 0.88% 5.24% 1.84% 1.39% -1.51% -1.57% 1.37% 1.94% 3.31% 0.40% 1.08% 1.53% 4.05% 3.40% -2.44% 90dBill 0.44% 0.38% 0.37% 0.32% 0.31% 0.30% 0.29% 0.26% 0.21% 0.18% 0.16% 0.13% 0.15% 0.14% 0.15% 0.14% 0.15% 0.14% 0.14% 0.14% 0.13% 0.12% 0.11% 0.09% 0.10% 0.10% 0.10% 0.09% 0.09% 0.08% 0.08% 0.08% 0.08% 0.08% 0.08% 0.07% 0.08% 0.08% 0.08% 0.08% 0.10% 0.11% 0.12% 0.13% 0.14% 0.16% 0.18% Port A Down(A) Down(A)^2 4.94% 4.94% 0.00244074 8.37% 0.66% -2.77% -2.77% 0.00076907 -2.18% -2.18% 0.0004756 4.07% 4.07% 0.00165943 -7.72% -7.72% 0.00595768 1.83% 5.73% 1.81% -1.33% -1.33% 0.00017795 -1.58% -1.58% 0.00025 4.81% % -5.43% 5.43% 0.0029439 -0.83% 0.83% 6.8367E-05 8.41% 8.41% 0.0070655 -7.18% -7.18% 0.00515022 0.66% - 10.21% -10.21% 0.01042012 6.79% 4.00% -5.11% 5.11% 0.0026108 2.22% 2.22% 0.00049413 -1.60% -1.60% 0.00025581 1.56% 6.76% 5.04% 1.02% 1.87% 2.29% -0.30% % -0.30% 9.2355E-06 5.48% 1.40% 4.15% 2.16% 2.27% 0.94% 0.94% 8.7834E-05 -2.30% -2.30% 0.00052974 1.80% 2.42% 4.03% 4.03% 0.00162636 0.30% -0.30% 8.9653E-06 1.30% 1.82% 5.06% 3.07% -2.90% 2.90% 0.00083876 Port B -1.54% 1.00% -7.50% 3.36% 2.40% 13.14% -2.39% 2.25% 4.02% 9.91% 1.11% -0.69% -1.01% 3.41% % -1.77% 7.32% -2.24% 3.26% -0.46% 2.68% 4.82% 5.82% 5.79% 6.32% 1.68% % 3.15% 10.43% 1.00% -17.10% 1.69% 13.11% 12.72% 3.74% 4.43% 8.21% 7.67% 4.01% -9.30% 1.27% -2.04% 8.02% -2.97% 1.04% 0.48% 6.25% 0.28% 1.00% S&P 6.78% 7.39% 0.30% -2.76% -1.30% 6.56% 8.36% 1.65% 7.46% 0.70% -1.62% -2.06% 3.61% 6.21% 0.89% -7.27% -7.94% 0.51% -11.01% 8.66% 5.76% -5.99% 2.73% -1.59% 0.87% 8.14% 5.17% 1.18% 1.68% 1.87% -1.14% % 5.58% 0.80% 5.16% 1.76% 1.32% -1.59% -1.65% 1.29% 1.86% 3.40% 0.30% 0.96% 1.39% 3.90% 3.24% -2.62% -5.99% -2.73% -1.59% 0.003593163 0.000744799 0.000253542 -6.32% 0.003994531 -17.10% 0.029252393 -1.14% 0.000129459 4.23% -1.59% -1.65% 0.000251984 0.000271063 -9.30% 0.008641045 -2.04% 0.000416662 2.24% 2.34% -0.86% -2.23% 1.88% 2.50% 3.94% -0.19% 1.42% 1.96% 5.21% 3.23% -2.72% -3.40% 0.001159266 -2.97% 0.000882173 2.62% 0.000684607 A D F J N R P Down(S&P) Down(S&P) A2 -1.14% 0.000129459 -1.59% -1.65% 0.000251984 0.000271063 -3.40% 0.001159266 1 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 Apr 03 May 03 Jun 03 Jul 03 Aug 03 Sep 03 Oct 03 Nov 03 Dec 03 Jan 04 Feb 04 Mar 04 Apr 04 May 04 Jun 04 Jul 04 Aug 04 Sep 04 Oct 04 Nov 04 Dec 04 Jan 05 Feb 05 Mar 05 Apr 05 May 05 Jun 05 Jul 05 Aug 05 Sep 05 Oct 05 Nov 05 Dec 05 Jan-06 Feb-06 Mar-06 Annualized Retum Annualized Volatility B Portfolio A 6.85% 5.13% 1.11% 1.96% 2.37% -0.23% 5.56% 1.48% 4.23% 2.24% 2.34% -0.86% -2.23% 1.88% 2.50% 3.94% -0.19% 1.42% 1.96% 5.21% 3.23% 2.72% 2.57% -0.58% 2.07% 3.84% 0.66% 4.16% 0.72% 1.96% -2.02% 4.75% 0.83% 4.15% 0.05% 1.00% Portfolio B 3.24% 10.52% 1.09% -17.02% 1.77% 13.19% 12.80% 3.82% 4.50% 8.29% 7.74% 4.09% -9.22% 1.35% -1.96% 8.12% -2.86% 1.15% 0.62% 6.39% 0.44% 1.18% 9.27% -1.09% 3.82% -0.06% 5.31% 2.78% -1.15% 7.09% 2.84% 5.94% 4.20% 1.17% 2.23% -5.05% S&P 500 8.24% 5.27% 1.28% 1.76% 1.95% -1.06% 5.66% 0.88% 5.24% 1.84% 1.39% -1.51% -1.57% 1.37% 1.94% -3.31% 0.40% 1.08% 1.53% 4.05% 3.40% 2.44% 2.10% -1.77% -1.90% 3.18% 0.14% 3.72% -0.91% 0.81% -1.67% 3.78% 0.03% 2.65% 0.27% 1.24% E 90dBill 0.10% 0.10% 0.09% 0.09% 0.08% 0.08% 0.08% 0.08% 0.08% 0.08% 0.07% 0.08% 0.08% 0.08% 0.08% 0.10% 0.11% 0.12% 0.13% 0.14% 0.16% 0.18% 0.18% 0.21% 0.22% 0.24% 0.24% 0.25% 0.27% 0.27% 0.29% 0.30% 0.32% 0.33% 0.32% 0.37% G H Port A Down(A) Down(A) 2 6.76% 5.04% 1.02% 1.87% 2.29% -0.30% -0.30% 9.2355E-06 5.48% 1.40% 4.15% 2.16% 2.27% -0.94% -0.94% 8.7834E-05 -2.30% -2.30% 0.00052974 1.80% 2.42% 4.03% 4.03% 0.00162636 -0.30% -0.30% 8.9653E-06 1.30% 1.82% 5.06% 3.07% 2.90% -2.90% 0.00083876 2.40% -0.79% -0.79% 6.1665E-05 2.29% 2.29% 0.00052309 3.60% 0.42% 3.90% -0.99% -0.99% 9.7822E-05 1.69% -2.31% -2.31% 0.00053553 4.45% 0.51% 3.82% -0.27% -0.27% 7.393E-06 0.63% L M Port B Down(B) Down B)^2 3.15% 10.43% 1.00% -17.10% -17.10% 0.029252393 1.69% 13.11% 12.72% 3.74% 4.43% 8.21% 7.67% 4.01% -9.30% -9.30% 0.008641045 1.27% 2.04% 2.04% 0.000416662 8.02% -2.97% -2.97% 0.000882173 1.04% 0.48% 6.25% 0.28% 1.00% 9.10% -1.30% -1.30% 0.000168833 4.04% 4.04% 0.001630884 -0.29% -0.29% 8.68672E-06 5.07% 2.52% -1.42% -1.42% 0.00020206 6.82% 2.55% 5.64% 4.52% 4.52% 0.002040274 0.84% 1.92% -5.42% 5.42% 0.002932439 0 S&P 8.14% 5.17% 1.18% 1.68% 1.87% -1.14% 5.58% 0.80% 5.16% 1.76% 1.32% -1.59% -1.65% 1.29% 1.86% -3.40% 0.30% 0.96% 1.39% 3.90% 3.24% -2.62% 1.93% -1.98% -2.11% 2.94% -0.09% 3.47% -1.18% 0.54% -1.96% 3.48% -0.28% 2.31% -0.05% 0.87% 2.62% 0.000684607 -1.98% 2.11% 0.000392198 0.000447196 -0.09% 8.70489E-07 -1.18% 0.000139004 -1.96% 0.00038467 -0.28% 8.1168E-06 0.05% 2.07936E-07 63 5.86% 24.64% 2.57% 2.19% 9.42% 10.95% 10.27% 10.27% 13.4% 19.0% 14.2% 0.3% 64 65 66 3. Calculate the Sortino Ratio for Portfolios A, B & the S&P 500 4. Calculate the Information Ratio for Portfolios A, B & the S&P 500. Note the benchmark for Port A is the S&P 500. The benchmark for Port B is 90d T-bills. A B D E F. G 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 Mar 01 Apr 01 May 01 Jun 01 Jul 01 Aug 01 Sep 01 Oct 01 Nov 01 Dec 01 Jan 02 Feb 02 Mar 02 Apr 02 May 02 Jun 02 Jul 02 Aug 02 Sep 02 Oct 02 Nov 02 Dec 02 Jan 03 Feb 03 Mar 03 Apr 03 May 03 Jun 03 Jul 03 Aug 03 Sep 03 Oct 03 Nov 03 Dec 03 Jan 04 Feb 04 Mar 04 Apr 04 May 04 Jun 04 Jul 04 Aug 04 Portfolio A -4.50% 8.75% 1.03% -2.45% -1.87% -3.77% -7.43% 2.09% 5.94% 1.99% -1.18% -1.45% 4.95% -5.28% -0.68% -8.26% -7.03% 0.80% -10.07% 6.93% 4.13% -4.99% -2.11% -1.51% 1.66% 6.85% 5.13% 1.11% 1.96% 2.37% -0.23% 5.56% 1.48% 4.23% 2.24% 2.34% -0.86% -2.23% 1.88% 2.50% -3.94% -0.19% 1.42% 1.96% 5.21% 3.23% -2.72% Portfolio B -1.10% 1.38% -7.13% 3.68% 2.72% 13.44% -2.11% 2.51% 4.24% 10.09% 1.27% -0.56% -0.86% 3.56% -1.62% 7.47% -2.09% 3.40% -0.32% 2.82% 4.95% -5.70% 5.90% -6.23% 1.78% 3.24% 10.52% 1.09% -17.02% 1.77% 13.19% 12.80% 3.82% 4.50% 8.29% 7.74% 4.09% -9.22% 1.35% -1.96% 8.12% -2.86% 1.15% 0.62% 6.39% 0.44% 1.18% S&P 500 -6.34% 7.77% 0.67% -2.43% -0.98% -6.26% -8.08% 1.91% 7.67% 0.88% -1.46% -1.93% 3.76% -6.06% -0.74% -7.12% -7.79% 0.66% -10.87% 8.80% 5.89% -5.87% -2.62% -1.50% 0.97% 8.24% 5.27% 1.28% 1.76% 1.95% -1.06% 5.66% 0.88% 5.24% 1.84% 1.39% -1.51% -1.57% 1.37% 1.94% -3.31% 0.40% 1.08% 1.53% 4.05% 3.40% -2.44% 90dBill 0.44% 0.38% 0.37% 0.32% 0.31% 0.30% 0.29% 0.26% 0.21% 0.18% 0.16% 0.13% 0.15% 0.14% 0.15% 0.14% 0.15% 0.14% 0.14% 0.14% 0.13% 0.12% 0.11% 0.09% 0.10% 0.10% 0.10% 0.09% 0.09% 0.08% 0.08% 0.08% 0.08% 0.08% 0.08% 0.07% 0.08% 0.08% 0.08% 0.08% 0.10% 0.11% 0.12% 0.13% 0.14% 0.16% 0.18% Sep 04 Oct 04 Nov 04 Dec 04 Jan 05 1 Portfolio A Portfolio B 90 dBill 38 Mar 04 39 Apr 04 40 May 04 41 Jun 04 42 Jul 04 43 Aug 04 44 Sep 04 45 Oct 04 46 Nov 04 47 Dec 04 48 Jan 05 49 Feb 05 50 Mar 05 51 Apr 05 52 May 05 53 Jun 05 54 Jul 05 55 Aug 05 56 Sep 05 57 Oct 05 58 Nov 05 59 Dec 05 60 Jan-06 61 Feb-06 62 Mar-06 Annualized 63 Return Annualized 64 Volatility 65 66 Monthly Vol 67 Avg Mthly Rtn 68 69 -0.86% -2.23% 1.88% 2.50% -3.94% -0.19% 1.42% 1.96% 5.21% 3.23% -2.72% 2.57% -0.58% -2.07% 3.84% 0.66% 4.16% -0.72% 1.96% -2.02% 4.75% 0.83% 4.15% 0.05% 1.00% 4.09% -9.22% 1.35% -1.96% 8.12% -2.86% 1.15% 0.62% 6.39% 0.44% 1.18% 9.27% -1.09% -3.82% -0.06% 5.31% 2.78% -1.15% 7.09% 2.84% 5.94% -4.20% 1.17% 2.23% -5.05% S&P 500 -1.51% -1.57% 1.37% 1.94% -3.31% 0.40% 1.08% 1.53% 4.05% 3.40% -2.44% 2.10% -1.77% -1.90% 3.18% 0.14% 3.72% -0.91% 0.81% -1.67% 3.78% 0.03% 2.65% 0.27% 1.24% 0.08% 0.08% 0.08% 0.08% 0.10% 0.11% 0.12% 0.13% 0.14% 0.16% 0.18% 0.18% 0.21% 0.22% 0.24% 0.24% 0.25% 0.27% 0.27% 0.29% 0.30% 0.32% 0.33% 0.32% 0.37% 5.86% 24.64% 2.57% 2. 19% 13.4% 19.0% 14.2% 0.3% 3.87% 0.55% 5.47% 2.00% 4.10% 0.30% 0.10% 0.18% A D E F G H 1 J K L M N o P Q RE Down/B] Down(B)^2 -1.54% 0.00023797 Down(S&P) -6.78% Down/S&P)^2 0.004591011 -7.50% 0.005622198 -2.76% -1.30% -6.56% -8.36% 0.000759113 0.00016848 0.004306872 0.006992639 -2.39% 0.000572433 -1.62% 2.06% 0.000260952 0.000425226 -0.69% 4.79832E-05 -1.01% 0.000101339 -1.77% 0.000312798 -6.21% -0.89% -7.27% -7.94% B Portfolio A 4.50% 8.75% 1.03% -2.45% -1,87% 3.77% -7.43% 2.09% 5.94% 1.99% -1.18% -1,45% 4.95% -5.28% -0.68% 8.26% -7.03% 0.80% -10.07% 6.93% 4.13% 4.99% 2.11% -1.51% 1.66% 6.85% 5.13% 1.11% 1.96% 2.37% -0.23% 5.56% 1.48% 0.003852685 7.85528E-05 0.005282092 0.006305948 -2.24% 0.000500225 -0.46% 2.10423E-05 -11.01% 0.012112983 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 -5.82% 0.003382902 Mar 01 Apr 01 May 01 Jun 01 Jul 01 Aug 01 Sep 01 Oct 01 Nov 01 Dec 01 Jan 02 Feb 02 Mar 02 Apr 02 May 02 Jun 02 Jul 02 Aug 02 Sep 02 Oct 02 Nov 02 Dec 02 Jan 03 Feb 03 Mar 03 Apr 03 May 03 Jun 03 Jul 03 Aug 03 Sep 03 Oct 03 Nov 03 Dec 03 Jan 04 Feb 04 Mar 04 Apr 04 May 04 Jun 04 Jul 04 Aug 04 Sep 04 Oct 04 Nov 04 Dec 04 Jan 05 Portfolio B -1.10% 1.38% -7.13% 3.68% 2.72% 13.44% -2.11% 2.51% 4.24% 10.09% 1.27% -0.56% -0.86% 3.56% -1.62% 7.47% 2.09% 3.40% -0.32% 2.82% 4.95% -5.70% 5.90% -6.23% 1.78% 3.24% 10.52% 1.09% -17.02% 1.77% 13.19% 12.80% 3.82% 4.50% 8.29% 7.74% 4.09% -9.22% 1.35% -1.96% 8.12% -2.86% 1.15% 0.62% 6.39% 0.44% 1.18% S&P 500 -6.34% 7.77% 0.67% -2.43% -0.98% -6.26% -8.08% 1.91% 7.67% 0.88% -1.46% -1.93% 3.76% -6.06% -0.74% -7.12% -7.79% 0.66% -10.87% 8.80% 5.89% -5.87% 2.62% -1.50% 0.97% 8.24% 5.27% 1.28% 1.76% 1.95% -1.06% 5.66% 0.88% 5.24% 1.84% 1.39% -1.51% -1.57% 1.37% 1.94% 3.31% 0.40% 1.08% 1.53% 4.05% 3.40% -2.44% 90dBill 0.44% 0.38% 0.37% 0.32% 0.31% 0.30% 0.29% 0.26% 0.21% 0.18% 0.16% 0.13% 0.15% 0.14% 0.15% 0.14% 0.15% 0.14% 0.14% 0.14% 0.13% 0.12% 0.11% 0.09% 0.10% 0.10% 0.10% 0.09% 0.09% 0.08% 0.08% 0.08% 0.08% 0.08% 0.08% 0.07% 0.08% 0.08% 0.08% 0.08% 0.10% 0.11% 0.12% 0.13% 0.14% 0.16% 0.18% Port A Down(A) Down(A)^2 4.94% 4.94% 0.00244074 8.37% 0.66% -2.77% -2.77% 0.00076907 -2.18% -2.18% 0.0004756 4.07% 4.07% 0.00165943 -7.72% -7.72% 0.00595768 1.83% 5.73% 1.81% -1.33% -1.33% 0.00017795 -1.58% -1.58% 0.00025 4.81% % -5.43% 5.43% 0.0029439 -0.83% 0.83% 6.8367E-05 8.41% 8.41% 0.0070655 -7.18% -7.18% 0.00515022 0.66% - 10.21% -10.21% 0.01042012 6.79% 4.00% -5.11% 5.11% 0.0026108 2.22% 2.22% 0.00049413 -1.60% -1.60% 0.00025581 1.56% 6.76% 5.04% 1.02% 1.87% 2.29% -0.30% % -0.30% 9.2355E-06 5.48% 1.40% 4.15% 2.16% 2.27% 0.94% 0.94% 8.7834E-05 -2.30% -2.30% 0.00052974 1.80% 2.42% 4.03% 4.03% 0.00162636 0.30% -0.30% 8.9653E-06 1.30% 1.82% 5.06% 3.07% -2.90% 2.90% 0.00083876 Port B -1.54% 1.00% -7.50% 3.36% 2.40% 13.14% -2.39% 2.25% 4.02% 9.91% 1.11% -0.69% -1.01% 3.41% % -1.77% 7.32% -2.24% 3.26% -0.46% 2.68% 4.82% 5.82% 5.79% 6.32% 1.68% % 3.15% 10.43% 1.00% -17.10% 1.69% 13.11% 12.72% 3.74% 4.43% 8.21% 7.67% 4.01% -9.30% 1.27% -2.04% 8.02% -2.97% 1.04% 0.48% 6.25% 0.28% 1.00% S&P 6.78% 7.39% 0.30% -2.76% -1.30% 6.56% 8.36% 1.65% 7.46% 0.70% -1.62% -2.06% 3.61% 6.21% 0.89% -7.27% -7.94% 0.51% -11.01% 8.66% 5.76% -5.99% 2.73% -1.59% 0.87% 8.14% 5.17% 1.18% 1.68% 1.87% -1.14% % 5.58% 0.80% 5.16% 1.76% 1.32% -1.59% -1.65% 1.29% 1.86% 3.40% 0.30% 0.96% 1.39% 3.90% 3.24% -2.62% -5.99% -2.73% -1.59% 0.003593163 0.000744799 0.000253542 -6.32% 0.003994531 -17.10% 0.029252393 -1.14% 0.000129459 4.23% -1.59% -1.65% 0.000251984 0.000271063 -9.30% 0.008641045 -2.04% 0.000416662 2.24% 2.34% -0.86% -2.23% 1.88% 2.50% 3.94% -0.19% 1.42% 1.96% 5.21% 3.23% -2.72% -3.40% 0.001159266 -2.97% 0.000882173 2.62% 0.000684607 A D F J N R P Down(S&P) Down(S&P) A2 -1.14% 0.000129459 -1.59% -1.65% 0.000251984 0.000271063 -3.40% 0.001159266 1 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 Apr 03 May 03 Jun 03 Jul 03 Aug 03 Sep 03 Oct 03 Nov 03 Dec 03 Jan 04 Feb 04 Mar 04 Apr 04 May 04 Jun 04 Jul 04 Aug 04 Sep 04 Oct 04 Nov 04 Dec 04 Jan 05 Feb 05 Mar 05 Apr 05 May 05 Jun 05 Jul 05 Aug 05 Sep 05 Oct 05 Nov 05 Dec 05 Jan-06 Feb-06 Mar-06 Annualized Retum Annualized Volatility B Portfolio A 6.85% 5.13% 1.11% 1.96% 2.37% -0.23% 5.56% 1.48% 4.23% 2.24% 2.34% -0.86% -2.23% 1.88% 2.50% 3.94% -0.19% 1.42% 1.96% 5.21% 3.23% 2.72% 2.57% -0.58% 2.07% 3.84% 0.66% 4.16% 0.72% 1.96% -2.02% 4.75% 0.83% 4.15% 0.05% 1.00% Portfolio B 3.24% 10.52% 1.09% -17.02% 1.77% 13.19% 12.80% 3.82% 4.50% 8.29% 7.74% 4.09% -9.22% 1.35% -1.96% 8.12% -2.86% 1.15% 0.62% 6.39% 0.44% 1.18% 9.27% -1.09% 3.82% -0.06% 5.31% 2.78% -1.15% 7.09% 2.84% 5.94% 4.20% 1.17% 2.23% -5.05% S&P 500 8.24% 5.27% 1.28% 1.76% 1.95% -1.06% 5.66% 0.88% 5.24% 1.84% 1.39% -1.51% -1.57% 1.37% 1.94% -3.31% 0.40% 1.08% 1.53% 4.05% 3.40% 2.44% 2.10% -1.77% -1.90% 3.18% 0.14% 3.72% -0.91% 0.81% -1.67% 3.78% 0.03% 2.65% 0.27% 1.24% E 90dBill 0.10% 0.10% 0.09% 0.09% 0.08% 0.08% 0.08% 0.08% 0.08% 0.08% 0.07% 0.08% 0.08% 0.08% 0.08% 0.10% 0.11% 0.12% 0.13% 0.14% 0.16% 0.18% 0.18% 0.21% 0.22% 0.24% 0.24% 0.25% 0.27% 0.27% 0.29% 0.30% 0.32% 0.33% 0.32% 0.37% G H Port A Down(A) Down(A) 2 6.76% 5.04% 1.02% 1.87% 2.29% -0.30% -0.30% 9.2355E-06 5.48% 1.40% 4.15% 2.16% 2.27% -0.94% -0.94% 8.7834E-05 -2.30% -2.30% 0.00052974 1.80% 2.42% 4.03% 4.03% 0.00162636 -0.30% -0.30% 8.9653E-06 1.30% 1.82% 5.06% 3.07% 2.90% -2.90% 0.00083876 2.40% -0.79% -0.79% 6.1665E-05 2.29% 2.29% 0.00052309 3.60% 0.42% 3.90% -0.99% -0.99% 9.7822E-05 1.69% -2.31% -2.31% 0.00053553 4.45% 0.51% 3.82% -0.27% -0.27% 7.393E-06 0.63% L M Port B Down(B) Down B)^2 3.15% 10.43% 1.00% -17.10% -17.10% 0.029252393 1.69% 13.11% 12.72% 3.74% 4.43% 8.21% 7.67% 4.01% -9.30% -9.30% 0.008641045 1.27% 2.04% 2.04% 0.000416662 8.02% -2.97% -2.97% 0.000882173 1.04% 0.48% 6.25% 0.28% 1.00% 9.10% -1.30% -1.30% 0.000168833 4.04% 4.04% 0.001630884 -0.29% -0.29% 8.68672E-06 5.07% 2.52% -1.42% -1.42% 0.00020206 6.82% 2.55% 5.64% 4.52% 4.52% 0.002040274 0.84% 1.92% -5.42% 5.42% 0.002932439 0 S&P 8.14% 5.17% 1.18% 1.68% 1.87% -1.14% 5.58% 0.80% 5.16% 1.76% 1.32% -1.59% -1.65% 1.29% 1.86% -3.40% 0.30% 0.96% 1.39% 3.90% 3.24% -2.62% 1.93% -1.98% -2.11% 2.94% -0.09% 3.47% -1.18% 0.54% -1.96% 3.48% -0.28% 2.31% -0.05% 0.87% 2.62% 0.000684607 -1.98% 2.11% 0.000392198 0.000447196 -0.09% 8.70489E-07 -1.18% 0.000139004 -1.96% 0.00038467 -0.28% 8.1168E-06 0.05% 2.07936E-07 63 5.86% 24.64% 2.57% 2.19% 9.42% 10.95% 10.27% 10.27% 13.4% 19.0% 14.2% 0.3% 64 65 66 3. Calculate the Sortino Ratio for Portfolios A, B & the S&P 500 4. Calculate the Information Ratio for Portfolios A, B & the S&P 500. Note the benchmark for Port A is the S&P 500. The benchmark for Port B is 90d T-bills