Finance assignment

Anonymous
timer Asked: Oct 17th, 2018
account_balance_wallet $9.99

Question Description

I just need this to be checked and fix the info in the "Data" tab which isn't correct. Then I need to input the allocation of the optimal complete portfolio (y-maxU). That would be all the whole assignment does not need to be completed.

Unformatted Attachment Preview

er of an asset er market - risk A- risk free free rate rate 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 Feb 05 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% 2,57% 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% 9,27% 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% 2,10% 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% 0,18% Rm - Rf -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% 1,93% RA - Rf -4,94% 8,37% 0,66% -2,77% -2,18% -4,07% -7,72% 1,83% 5,73% 1,81% -1,33% -1,58% 4,81% -5,43% -0,83% -8,41% -7,18% 0,66% -10,21% 6,79% 4,00% -5,11% -2,22% -1,60% 1,56% 6,76% 5,04% 1,02% 1,87% 2,29% -0,30% 5,48% 1,40% 4,15% 2,16% 2,27% -0,94% -2,30% 1,80% 2,42% -4,03% -0,30% 1,30% 1,82% 5,06% 3,07% -2,90% 2,40% 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 Return Annualized Volatility -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% -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% -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,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% Correlation of returns “=correl(ran ge 1, range2) 0,18 -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% 14,2% -0,79% -2,29% 3,60% 0,42% 3,90% -0,99% 1,69% -2,31% 4,45% 0,51% 3,82% -0,27% 0,63% 13,4% A= U= Weight A Weight B Exp Rtn Exp Risk Exp Risk 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% 24,64% 22,76% 20,88% 19,00% 17,13% 15,25% 13,37% 11,49% 9,62% 7,74% 5,86% 18,96% 15,49% 12,67% 10,50% 8,97% 8,09% 7,86% 8,27% 9,34% 11,05% 13,40% 43,5% 39,4% 35,6% 32,4% 30,0% 28,4% 28,0% 28,8% 30,6% 33,2% 36,6% a 0,50 b 0,50 1 sharpe optimal risky risk free assets 0,21 0,79 CAPM 1,87 1,71 1,56 1,4 1,24 1,09 0,93 0,77 0,62 0,46 0,31 Sharpe 0,52 0,52 0,53 0,52 0,50 0,46 0,40 0,32 0,24 0,17 0,10 Y Max 11,84% 13,28% 14,75% 16,02% 16,65% 16,14% 14,22% 11,24% 7,95% 5,02% 2,74% er of an asset b- risk free rate RB - Rf -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% 9,10% Beta = y-int = 0,924432 0,26% Beta = y-int = 0,210644 1,79% -1,30% -4,04% -0,29% 5,07% 2,52% -1,42% 6,82% 2,55% 5,64% -4,52% 0,84% 1,92% -5,42% 50,00% 19,0% 43,54% 45,00% 40,00% 39,36% 36,61% 10 9,0% Utility 35,60% 33,24% 35,00% 32,40% 30,56% 29,95% 28,77%28,03%28,44% 30,00% 25,00% 20,00% -1,03801 Exp Rtn Exp Risk -0,86459 15,00% 43,54% -0,723534 24,64% -0,614843 22,76% 39,36% 10,00% 35,60% -0,538515 20,88% -0,494552 19,00% 32,40% 5,00%2,19% -0,482953 17,13% 29,95% -0,503718 15,25% 28,44% -0,556847 13,37% 0,00% 28,03% -0,642341 11,49% 0,00% 28,77% -0,760198 9,62% 30,56% 7,74% 33,24% 5,86% 36,61% 5,00% 10,00% 15,00% 20,00% 25,00% Beta = y-int = 0,924 0,26% 43,54% 39,36% Beta = y-int = 25,00% 30,00% 0,211 1,79% 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 Feb 05 Mar 05 Apr 05 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% 2,57% -0,58% -2,07% 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% 9,27% -1,09% -3,82% 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% 2,10% -1,77% -1,90% 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% 0,18% 0,21% 0,22% Rm - Rf -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% 1,93% -1,98% -2,11% RA - Rf -4,94% 8,37% 0,66% -2,77% -2,18% -4,07% -7,72% 1,83% 5,73% 1,81% -1,33% -1,58% 4,81% -5,43% -0,83% -8,41% -7,18% 0,66% -10,21% 6,79% 4,00% -5,11% -2,22% -1,60% 1,56% 6,76% 5,04% 1,02% 1,87% 2,29% -0,30% 5,48% 1,40% 4,15% 2,16% 2,27% -0,94% -2,30% 1,80% 2,42% -4,03% -0,30% 1,30% 1,82% 5,06% 3,07% -2,90% 2,40% -0,79% -2,29% May 05 Jun 05 Jul 05 Aug 05 Sep 05 Oct 05 Nov 05 Dec 05 Jan-06 Feb-06 Mar-06 Annualized Return Annualized Volatility Variance standard deviation correlation 3,84% 0,66% 4,16% -0,72% 1,96% -2,02% 4,75% 0,83% 4,15% 0,05% 1,00% -0,06% 5,31% 2,78% -1,15% 7,09% 2,84% 5,94% -4,20% 1,17% 2,23% -5,05% 3,18% 0,14% 3,72% -0,91% 0,81% -1,67% 3,78% 0,03% 2,65% 0,27% 1,24% 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% 0,15% 3,84% 0,18 19,0% 0,29% 5,43% 14,2% 0,3% 2,94% -0,09% 3,47% -1,18% 0,54% -1,96% 3,48% -0,28% 2,31% -0,05% 0,87% 14,2% 13,4% A Beta A = 0,924 Alpha y-int A =0,002637 B Beta B = 0,211 Alpha y-int B = 0,01795 A= U= Weight A Weight B Exp Rtn Exp Risk Portfolio 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% 24,64% 22,76% 20,88% 19,00% 17,13% 15,25% 13,37% 11,49% 9,62% 7,74% 5,86% 3,59% 3,01% 2,52% 2,11% 1,80% 1,57% 1,44% 1,39% 1,44% 1,57% 1,80% Risky Risk Free Correlation Return 22,76% 2,19% 0,00% SD 17,35% 0,00% Risky Asset Risk Free Asset Return Portfolio 0,00% 100,00% 2,19% 5,00% 95,00% 3,22% 10,00% 90,00% 4,25% 15,00% 85,00% 5,28% 20,00% 80,00% 6,31% 25,00% 75,00% 7,33% 10 9,0% SD Portfolio Sharpe 18,96% 17,35% 15,86% 14,53% 13,41% 12,54% 11,99% 11,80% 11,99% 12,54% 13,40% 22,00% 1,184 1,185 1,178 1,157 1,114 1,041 0,932 0,788 0,619 0,442 0,274 Variance 0,00% 0,87% 1,74% 2,60% 3,47% 4,34% 3,60% 0,42% 3,90% -0,99% 1,69% -2,31% 4,45% 0,51% 3,82% -0,27% 0,63% Y Max 62,43% 68,31% 74,27% 79,60% 83,09% 83,02% 77,75% 66,79% 51,65% 35,28% 20,42% 30,00% 35,00% 40,00% 45,00% 50,00% 55,00% 60,00% 65,00% 70,00% 75,00% 80,00% 85,00% 90,00% 95,00% 100,00% 70,00% 65,00% 60,00% 55,00% 50,00% 45,00% 40,00% 35,00% 30,00% 25,00% 20,00% 15,00% 10,00% 5,00% 0,00% 8,36% 9,39% 10,42% 11,45% 12,48% 13,50% 14,53% 15,56% 16,59% 17,62% 18,65% 19,67% 20,70% 21,73% 22,76% 5,21% 6,07% 6,94% 7,81% 8,68% 9,54% 10,41% 11,28% 12,15% 13,01% 13,88% 14,75% 15,62% 16,48% 17,35% RB - Rf -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% 9,10% -1,30% -4,04% SUMMARY OUTPUT A Regression Statistics Multiple R 0,97947 R Square 0,959362 Adjusted R Square 0,958673 Standard Error 0,007879 Observations 61 ANOVA df Regression Residual Total Intercept Alpha X Variable Beta SS MS 1 0,086457 0,086457 59 0,003662 6,21E-05 60 0,09012 F Significance F 1392,84 9,7E-43 Coefficients Standard Error t Stat P-value Lower 95% 0,002637 0,001009 2,612767 1% 0,000617 0,924432 0,02477 37,32077 0% 0,874868 SUMMARY OUTPUT B Regression Statistics Multiple R 0,157688 R Square 0,024866 Adjusted R Square 0,008338 Standard Error 0,054624 Observations 61 ANOVA df Regression Residual Total Intercept Alpha X Variable Beta SS MS F Significance F 1 0,004489 0,004489 1,504478 0,224856 59 0,176043 0,002984 60 0,180532 Coefficients Standard Error t Stat P-value Lower 95% 0,017948 0,006997 2,565263 1% 0,003948 0,210644 0,171734 1,226572 22% -0,133 Portfolio A y = 0,9253x + 0,0028 10,00% 5,00% -15,00% -10,00% -5,00% 0,00% 0,00% 5,00% -0,29% 5,07% 2,52% -1,42% 6,82% 2,55% 5,64% -4,52% 0,84% 1,92% -5,42% -5,00% -10,00% -15,00% Portfolio B y = 0,2052x + 0,0194 15,00% 10,00% 5,00% 19,0% -15,00% -10,00% -5,00% 0,00% 0,00% -5,00% 5,00% -10,00% -15,00% Indifferenc e curve Exp Rtn 27% 24% 22% 20% 18% 17% 16% 16% 16% 17% 18% 33,2000% -20,00% CAPM 30,00% 25,00% 20,00% 15,00% 10,00% 5,00% 0,00% Variance Frontier 0,00%Minimum5,00% 10,00% Risk and Risk20,00% Free 15,00% A Risk Free Rate Significance F Upper 95%Lower 95.0% Upper 95.0% 0,004656 0,000617 0,004656 0,973997 0,874868 0,973997 Significance F Upper 95%Lower 95.0% Upper 95.0% 0,031948 0,003948 0,031948 0,554284 -0,133 0,554284 ,9253x + 0,0028 10,00% y = 0,2052x + 0,0194 10,00% 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 Feb 05 Mar 05 Apr 05 May 05 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% 2.57% -0.58% -2.07% 3.84% 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% 9.27% -1.09% -3.82% -0.06% 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% 2.10% -1.77% -1.90% 3.18% 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% 0.18% 0.21% 0.22% 0.24% Rm - Rf RA - Rf Jun 05 Jul 05 Aug 05 Sep 05 Oct 05 Nov 05 Dec 05 Jan-06 Feb-06 Mar-06 Annualized Return Annualized Volatility 0.66% 4.16% -0.72% 1.96% -2.02% 4.75% 0.83% 4.15% 0.05% 1.00% 5.31% 2.78% -1.15% 7.09% 2.84% 5.94% -4.20% 1.17% 2.23% -5.05% 0.14% 3.72% -0.91% 0.81% -1.67% 3.78% 0.03% 2.65% 0.27% 1.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% #DIV/0! A= U= Weight A Weight B 0% 10% 20% 30% 40% 50% 60% 70% 80% 90% 100% 100% 90% 80% 70% 60% 50% 40% 30% 20% 10% 0% Exp Rtn Exp Risk Sharpe 10 9.0% Indifference curve Exp Rtn #DIV/0! RB - Rf #DIV/0! Beta = y-int = #DIV/0! #DIV/0! Beta = y-int = #DIV/0! #DIV/0! Case Study Assignment – FNCE 561 You have been assigned to construct a portfolio comprising two risky assets (Portfolios A & B) while considering your client’s risk tolerance. The attached spread sheet shows historical monthly returns of the two portfolios; the market portfolio as represented by the S&P 500 index; and the risk free rate as represented by 90-day Treasury Bills. Also shown are the annualized returns for each investment during the period. The first risky asset (Portfolio A) is a US equity strategy that uses publically available valuation, technical and sentiment factors to assess which stocks are over-priced and which are under-priced. Fundamental factors indicate the magnitude and quality of a company’s earnings and the strength of its balance sheet. Examples of such factors include: cash flow growth, cash flow return on invested capital, price to cash flow, and accruals which assess earnings quality (low quality earnings indicate that management may be manipulating earnings by adjusting accruals). Companies with favorable fundamental factors tend to outperform those with less favorable factors. Technical and sentiment factors seek to identify mis-pricings resulting from investor behavior. Examples include: momentum and price reversals where investors tend to over-react to good news by bidding up prices ABOVE fair value and bad news by bidding down prices BELOW fair value; short interest on a stock which can indicate the investor sentiment about the company’s prospects; share buybacks which can indicate a positive signal from management’s optimism regarding a firm’s future prospects; and earnings / revenue surprise. Firms with favorable technical and sentiment factors also tend to outperform. For example, firms whose earnings and revenue exceed analysts’ expectations tend to continue to outperform vs. those firms that experience earnings surprise due to cost cutting. Starting with the market portfolio, the US equity strategy over-weights those stocks with more favorable fundamental, technical and sentiment factors and under-weights or avoids those stocks with less-favorable or un-favorable factors. The strategy seeks to out-perform the market portfolio as represented by the S&P 500. The monthly returns of the US equity strategy are shown in the attached spreadsheet (Portfolio A). The second risky asset (Portfolio B) is a global macro hedge fund. This strategy seeks to benefit from mis-pricings within and across broad asset classes by taking long and short positions in equity markets, bond markets and currencies. For example, if the manager believes that US equities will out-perform Japanese equities, the portfolio will go long S&P 500 futures and short TOPIX futures (TOPIX is an index that serves as a proxy for Japanese equities). This long/short trade is not impacted by the overall direction of global equities, but rather the relative movement between US and Japanese equities. Similarly for bonds, if the manager believes that interest rates in the United Kingdom (UK) will decline more so than interest rates in Australia, then the manager will buy UK gilt futures (gilt is the 10-year UK bond) and short Australian 10-year bond futures. Again, this trade is not impacted by the overall direction of global interest rates, but rather the relative movement between UK and Australian rates. Recall that bond prices rise as interest rates decline. The global macro hedge fund is mostly market neutral meaning that long positions equal short positions thereby dramatically reducing systematic exposures (low beta). Portfolios A & B are much more volatile than the risk free rate. You will find that their correlation is small indicating that there is a diversification benefit to be had from holding both in a portfolio (you will need to calculate this using the excel function “=correl(range 1, range2)”. You will be meeting with a client that is looking for investment advice from you based on the two strategies A & B. In preparation for your upcoming meeting with the client, your boss asks that you respond to the questions below and be ready to discuss. Hint: You will need to determine the correlations and volatilities for each risk premium. Analytical Assignment The analytical portion of the case assignment should be completed in the excel template which can be found in Canvas. 1. Plot in Excel the risky asset opportunity set for Portfolios A & B. To do this you will need to create the following table in Excel assuming weights of portfolio A & B in 10 percentage point increments. Then calculate expected return; standard deviation; and Sharpe ratio for each allocation to A & B. Your table in the Excel file should look like the one below. Weight Port A Weight Port B 0% 100% 10 90 20 80 30 70 Return Standard Deviation Sharpe Ratio 40 60 50 50 60 40 70 30 80 20 90 10 100 0 Determine the optimal allocation of A & B and draw in the Capital Allocation Line (CAL). The approximate optimal allocation can be determined using a table like the one shown above. Or you can obtain a more precise optimal allocation using the formula shown in Chapter 7 (equation 7.13). Some students have used Excel’s Solver function to find the optimal risky portfolio – that is also acceptable. When drawing the CAL on the efficient frontier graph plotted in Excel, you can manually draw a line starting at the risk free rate to the tangent point. 2. Find the optimal complete portfolio based on your client’s indifference curve. Hint: Plot an indifference curve on the same graph you just created using the utility function formula from Chapter 6. To make things easier, you can use the same portfolio risk numbers from the table above and then calculate the expected return based on U = 9% and a risk aversion coefficient A = 10. Plot the indifference curve AND the opportunity set of risky assets on the same graph. Next determine the optimal complete portfolio. While this can be done graphically, you need to use the formula to determine a more precise allocation between the optimal risky portfolio and T-Bills. 3. Use the capital asset pricing model (CAPM) to determine the beta and alpha of Portfolio A & Portfolio B. Show the CAPM relationship graphically for BOTH Portfolio A and Portfolio B (separate graphs). The market portfolio is represented by the S&P 500 and t ...
Purchase answer to see full attachment

Tutor Answer

DonKobong
School: University of Maryland

Attached.

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
Feb 05
Mar 05
Apr 05
May 05

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%
2.57%
-0.58%
-2.07%
3.84%

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...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors