BFN352 - 06 Problem set

xlsx

School

University of Prince Edward Island *

*We aren’t endorsed by this school

Course

BFN352

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

33

Uploaded by ProfFishMaster665

Report
Beta Mean return Monthly rf 0.10% Market 1.00 0.92% Alfred 1.60 1.45% Bruce 0.98 1.09% Richard 0.92 1.15% *Monthly a) Calculate the realized Sharpe ratios of these 4 portfolios. According to this criteria, whic b) Calculate the M2 measure of these 4 portfolios. According to this criteria, which portfol c) Calculate the Treynor ratio of these 4 portfolios. According to this criteria, which portfol d) Calculate the alpha of these 4 portfolios. Based on this measure, which manager appea e) Calculate the Information ratio of the 3 active portfolios. According to this criteria, whic 06.1 - Here is some information about the investment performance of 3 portfolio manager returns over the last 10 years. 0 12 4 8 16 20 24 28 32 36 40 44 48 52 56 60 64 68 72 76 80 84 0 1000 2000 3000 4000 5000 6000 Market Alfred Bruce Richa
f) If you wanted to hire one of these portfolio managers to expand your existing team of p g) If you wanted to invest all of your money in only one of these portfolios, which one wou h) Could you improve the portfolio of g)?
Total return Variance Pt 177.3% 0.0012686204 313.6% 0.0050867813 207.9% 0.0029855425 241.2% 0.0024328747 *over 10 year *Monthly ch portfolio is the best investment? lio is the best investment? lio is the best investment? ars to have stock picking skills? ch portfolio is the best investment? rs (and a market index) based on their monthly 84 88 92 96 100 104 108 112 116 120 ard
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
portfolio managers, which one would be the best choice? uld be the best choice?
Beta Mean return Monthly rf 0.10% Market 1.00 0.92% Alfred 1.60 1.45% Bruce 0.98 1.09% Richard 0.92 1.15% *Monthly a) Calculate the realized Sharpe ratios of these 4 portfolios. According to this criteria, whic Sharpe ratio Market 0.229 Alfred 0.189 Bruce 0.181 Richard 0.213 Answer Richard has the highest Sharpe ratio of the portfolio managers but he did b) Calculate the M2 measure of these 4 portfolios. According to this criteria, which portfol The active portfolios have a higher variance than the market. To get the sa 06.1 - Here is some information about the investment performance of 3 portfolio manager returns over the last 10 years. 0 12 4 8 16 20 24 28 32 36 40 44 48 52 56 60 64 68 72 76 80 84 0 1000 2000 3000 4000 5000 6000 Market Alfred Bruce Richa
The weights w* needed on the active portfolios are: w* Market 100.0% Alfred 49.9% Bruce 65.2% Richard 72.2% The mean monthly returns Rp* of these new portfolios are: Market 0.92% Alfred 0.77% Bruce 0.75% Richard 0.86% M2 measures : Market 0.00% Alfred -0.14% Bruce -0.17% Richard -0.06% Answer Same result as the Sharpe ratio. Richard has the highest M2 of the portfol c) Calculate the Treynor ratio of these 4 portfolios. According to this criteria, which portfol Monthly Treynor ratio Market 0.0082 Alfred 0.0084 Bruce 0.0101 Richard 0.0114 Answer All of the portfolio managers beat the market index here. Richard has the d) Calculate the alpha of these 4 portfolios. Based on this measure, which manager appea
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Monthly alphas: Market 0.00% Alfred 0.04% Bruce 0.19% Richard 0.30% Answer All of the portfolio managers appear to have stock picking skills with Richa e) Calculate the Information ratio of the 3 active portfolios. According to this criteria, whic Systematic risk (Standard deviation) Alfred 0.0571 Bruce 0.0348 Richard 0.0327 Firm-specific risk (Standard deviation) Alfred 0.0427 Bruce 0.0421 Richard 0.0369 Information ratio Alfred 0.01 Bruce 0.05 Richard 0.08 Answer All of the active portfolios would increase the Sharpe ratio of a passive po f) If you wanted to hire one of these portfolio managers to expand your existing team of p Answer Richard because he has the highest Treynor ratio. g) If you wanted to invest all of your money in only one of these portfolios, which one wou Answer A passive strategy of investing in the market index because it gives the hig h) Could you improve the portfolio of g)?
Answer Yes, the active portfolio managers have information ratios different than 0
Total return Variance Pt Alpha Sharpe w* Rp* M2 177.3% 0.0012686204 0.00% 0.229 100.0% 0.92% 0.0% 313.6% 0.0050867813 0.04% 0.189 49.9% 0.77% -0.1% 207.9% 0.0029855425 0.19% 0.181 65.2% 0.75% -0.2% 241.2% 0.0024328747 0.30% 0.213 72.2% 0.86% -0.1% *over 10 year *Monthly ch portfolio is the best investment? not beat the market index. The best portfolio is the market index (passive strategy). lio is the best investment? ame total risk as the market, we have to invest part of the money in an active portfolio and the rest in the rs (and a market index) based on their monthly 84 88 92 96 100 104 108 112 116 120 ard
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Cov()=0, Var(rf)=0 lio managers but he did not beat the market index. The best portfolio is the market index (passive strategy lio is the best investment? highest ratio so he would be the best choice. ars to have stock picking skills?
ard being the most skilled. However, that was not enough for them to beat the market's Sharpe ratio. ch portfolio is the best investment? ortfolio. Richard would again be the best choice. portfolio managers, which one would be the best choice? uld be the best choice? ghest Sharpe ratio and M2 measure. (You get more return per unit of total risk)
0 so they could increase the Sharpe ratio of my passive portfolio. Richard would be the first choice, but the
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Treynor Mont Sys risk (StDevFirm St dev IR 0.0082 0.0356 - - 0.0084 0.0571 4.27% 0.01 0.0101 0.0348 4.21% 0.05 0.0114 0.0327 3.69% 0.08 e risk free security.
y).
ey could all potentially be useful.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Risk premium 0.005 Excess returns before fees Market variance 0.00125 t Alpha Beta Var(ei) 0 1 2 Market 0 1 0 1000 998.7921 972.5376 No skill High risk 0 1.5 0.001667 1000 1004.652 989.2331 No skill medium risk 0.002 1.05 0.001667 1000 996.2435 937.0115 Skilled low risk 0.0% 0.8 0.001667 1000 995.2241 988.1724 not excess returns Market -0.1% -2.6% Alfred 0.5% -1.5% Bruce -0.4% -5.9% Richard -0.5% -0.7% Simulation parameters Calculated Alpha Beta Beta rf 0.10% Market 0.0% 1 1.00 x Alfred 0.0% 1.5 1.60 rf realized 12.74% Bruce 0.2% 1.05 0.98 Richard 0.0% 0.8 0.92 x 0 5 10 15 20 25 30 35 40 45 50 55 60 65 70 0 1000 2000 3000 4000 5000 6000 Market Alfred Br
3 4 5 6 7 8 9 10 11 966.443 925.1871 981.0515 964.4404 951.5458 970.3189 989.6689 951.0377 955.3092312 900.0099 876.3092 980.654 960.4315 928.3929 982.7536 1086.986 1035.975 1055.701413 917.0191 832.2303 882.2165 882.7153 853.7284 817.6907 855.1465 807.2797 836.6131161 1046.487 994.1787 1064.35 976.0641 1054.039 1056.926 1081.123 1046.595 990.2650012 -0.6% -4.3% 6.0% -1.7% -1.3% 2.0% 2.0% -3.9% 0.4% -9.0% -2.6% 11.9% -2.1% -3.3% 5.9% 10.6% -4.7% 1.9% -2.1% -9.2% 6.0% 0.1% -3.3% -4.2% 4.6% -5.6% 3.6% 5.9% -5.0% 7.1% -8.3% 8.0% 0.3% 2.3% -3.2% -5.4% d Mean Realized r Var Ptf Alpha Sharpe Rp* Ann. Rp Ann. Rp* 0.92% 177.3% 0.001269 0.00% 0.229 1.773 10.7% 10.7% 1.45% 313.6% 0.005087 0.04% 0.189 1.630 15.3% 10.2% 1.09% 207.9% 0.002986 0.19% 0.181 1.400 11.9% 9.1% 1.15% 241.2% 0.002433 0.30% 0.213 1.777 13.1% 10.8% x x x 0 75 80 85 90 95 100 105 110 115 120 ruce Richard
12 13 14 15 16 17 18 925.3834492 907.8275889 942.2269839 947.7096395 929.3901325 1000.76119 964.2179865 1043.951619 1101.407682 1174.903386 1164.160691 1092.26934 1267.702808 1245.439775 727.954458 717.3083292 733.371983 746.5098181 745.9183915 776.0163544 771.1268887 911.7864527 888.5977737 850.408975 860.6809755 851.820182 914.0226113 938.7421996 -3.1% -1.9% 3.8% 0.6% -1.9% 7.7% -3.7% -1.1% 5.5% 6.7% -0.9% -6.2% 16.1% -1.8% -13.0% -1.5% 2.2% 1.8% -0.1% 4.0% -0.6% -7.9% -2.5% -4.3% 1.2% -1.0% 7.3% 2.7% w* Treynor MontMean Ann. Treynor Ann. Sys risk (StDevFirm St dev IR 100.0% 0.0082 11.6% 0.116 0.0356 - - 49.9% 0.0084 18.8% 0.117 0.0571 4.27% 0.01 65.2% 0.0101 13.9% 0.142 0.0348 4.21% 0.05 72.2% 0.0114 14.7% 0.160 0.0327 3.69% 0.08
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
19 20 21 22 23 24 25 1037.563565 1013.881098 987.4687095 977.5602391 1032.993483 1081.65054 1030.487192 1346.495584 1357.910155 1295.686507 1256.561895 1409.031545 1402.346204 1319.270992 836.8089979 805.2547956 763.9561327 753.6554642 795.1388945 882.1593381 822.6970114 1023.314585 1019.31272 1013.128444 974.8571382 1086.799141 1126.845522 1134.4546 7.6% -2.3% -2.6% -1.0% 5.7% 4.7% -4.7% 8.1% 0.8% -4.6% -3.0% 12.1% -0.5% -5.9% 8.5% -3.8% -5.1% -1.3% 5.5% 10.9% -6.7% 9.0% -0.4% -0.6% -3.8% 11.5% 3.7% 0.7%
26 27 28 29 30 31 32 1080.37867 1078.382954 1133.335502 1188.545568 1196.19049 1248.605931 1362.980282 1395.915685 1372.247622 1480.177938 1573.186336 1582.057394 1701.592379 1898.703604 838.60036 841.9182261 903.745689 922.7513339 850.8558173 954.1258195 1085.470661 1208.287383 1200.824363 1250.544507 1378.455851 1249.711997 1305.128322 1476.960889 4.8% -0.2% 5.1% 4.9% 0.6% 4.4% 9.2% 5.8% -1.7% 7.9% 6.3% 0.6% 7.6% 11.6% 1.9% 0.4% 7.3% 2.1% -7.8% 12.1% 13.8% 6.5% -0.6% 4.1% 10.2% -9.3% 4.4% 13.2%
33 34 35 36 37 38 39 1331.405784 1383.720125 1299.438658 1382.147032 1404.310988 1402.586364 1429.245818 1712.960693 1764.847315 1533.921087 1710.013311 1849.426412 2081.816492 2126.99953 1102.081449 1178.045345 1054.117564 1109.69917 1241.11804 1228.239735 1300.557654 1418.479105 1352.719126 1289.064427 1352.19314 1374.840747 1353.035979 1391.627752 -2.3% 3.9% -6.1% 6.4% 1.6% -0.1% 1.9% -9.8% 3.0% -13.1% 11.5% 8.2% 12.6% 2.2% 1.5% 6.9% -10.5% 5.3% 11.8% -1.0% 5.9% -4.0% -4.6% -4.7% 4.9% 1.7% -1.6% 2.9%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
40 41 42 43 44 45 46 1445.838484 1500.338933 1570.988331 1524.878092 1580.136888 1594.494998 1567.974939 2056.675458 2201.325517 2255.180784 2193.83751 2221.454061 2320.045512 2383.555421 1327.102246 1363.953329 1391.287092 1439.98418 1527.593727 1521.320802 1336.909318 1336.596409 1297.074581 1287.895328 1266.652781 1358.286183 1400.641435 1332.797336 1.2% 3.8% 4.7% -2.9% 3.6% 0.9% -1.7% -3.3% 7.0% 2.4% -2.7% 1.3% 4.4% 2.7% 2.0% 2.8% 2.0% 3.5% 6.1% -0.4% -12.1% -4.0% -3.0% -0.7% -1.6% 7.2% 3.1% -4.8%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
47 48 49 50 51 52 53 1584.74935 1539.555464 1663.952506 1630.841282 1766.695527 1699.77791 1710.554584 2326.560812 2272.15016 2523.431852 2453.479034 2919.226038 2983.576815 3143.957246 1386.464334 1225.597909 1321.164707 1329.05953 1278.901662 1291.615549 1198.94275 1291.57447 1279.650025 1315.790192 1275.071799 1350.43717 1342.895405 1323.496294 1.1% -2.9% 8.1% -2.0% 8.3% -3.8% 0.6% -2.4% -2.3% 11.1% -2.8% 19.0% 2.2% 5.4% 3.7% -11.6% 7.8% 0.6% -3.8% 1.0% -7.2% -3.1% -0.9% 2.8% -3.1% 5.9% -0.6% -1.4%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
54 55 56 57 58 59 60 1616.40435 1580.533115 1657.987771 1678.401931 1708.547281 1681.464971 1700.312105 3046.616489 3024.88347 3379.439875 3667.436707 3812.42279 3787.879487 3755.225062 1098.779135 1070.000654 1055.77562 1085.491578 1166.37201 1203.806328 1205.740953 1206.98435 1226.932955 1303.663581 1380.156439 1450.819961 1407.563393 1386.020116 -5.5% -2.2% 4.9% 1.2% 1.8% -1.6% 1.1% -3.1% -0.7% 11.7% 8.5% 4.0% -0.6% -0.9% -8.4% -2.6% -1.3% 2.8% 7.5% 3.2% 0.2% -8.8% 1.7% 6.3% 5.9% 5.1% -3.0% -1.5%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
61 62 63 64 65 66 67 1703.132886 1782.547973 1828.707264 1860.097337 1823.312394 1795.158482 1833.927187 3744.850204 4224.539107 4340.432888 4388.24671 4391.970899 4248.864653 4310.635666 1251.071217 1312.878243 1276.879662 1318.365942 1231.48746 1165.554655 1185.165356 1401.692303 1457.731706 1561.740371 1599.94689 1657.699503 1730.212067 1722.743679 0.2% 4.7% 2.6% 1.7% -2.0% -1.5% 2.2% -0.3% 12.8% 2.7% 1.1% 0.1% -3.3% 1.5% 3.8% 4.9% -2.7% 3.2% -6.6% -5.4% 1.7% 1.1% 4.0% 7.1% 2.4% 3.6% 4.4% -0.4%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
68 69 70 71 72 73 74 1798.031224 1839.583754 1841.534401 1843.440445 1877.504654 1973.057507 1977.321152 4079.38696 4012.109177 3846.974275 3846.716651 4058.781692 4557.373025 4555.194501 1192.861127 1210.564094 1166.952014 1202.398226 1241.341106 1289.311327 1366.63594 1629.485908 1651.079834 1626.214359 1636.953168 1735.306931 1782.788077 1851.636403 -2.0% 2.3% 0.1% 0.1% 1.8% 5.1% 0.2% -5.4% -1.6% -4.1% 0.0% 5.5% 12.3% 0.0% 0.6% 1.5% -3.6% 3.0% 3.2% 3.9% 6.0% -5.4% 1.3% -1.5% 0.7% 6.0% 2.7% 3.9%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
75 76 77 78 79 80 81 2009.341574 2147.734042 2093.375125 2066.594878 2128.055349 2058.664608 2036.885574 4794.863783 5457.687956 5057.077631 5146.932783 5411.588422 4958.119647 5369.473605 1413.205344 1480.140472 1560.835915 1580.821751 1655.001402 1694.880105 1753.628431 1942.029382 2078.489185 1907.870494 2010.526546 2026.559559 1896.409029 1995.005773 1.6% 6.9% -2.5% -1.3% 3.0% -3.3% -1.1% 5.3% 13.8% -7.3% 1.8% 5.1% -8.4% 8.3% 3.4% 4.7% 5.5% 1.3% 4.7% 2.4% 3.5% 4.9% 7.0% -8.2% 5.4% 0.8% -6.4% 5.2%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
82 83 84 85 86 87 88 2067.722607 2124.900654 2169.545023 2011.401861 1879.924041 1950.81819 2077.240958 5291.301958 5230.120913 4993.00854 3969.082634 3256.620928 3573.725651 3771.891298 1798.187846 1724.280532 1865.633632 1794.75475 1677.556836 1818.800988 2046.273249 1991.667311 1989.839143 2162.832525 2040.984441 1995.65875 1977.357146 2062.654551 1.5% 2.8% 2.1% -7.3% -6.5% 3.8% 6.5% -1.5% -1.2% -4.5% -20.5% -18.0% 9.7% 5.5% 2.5% -4.1% 8.2% -3.8% -6.5% 8.4% 12.5% -0.2% -0.1% 8.7% -5.6% -2.2% -0.9% 4.3%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
89 90 91 92 93 94 95 2106.436642 2182.299249 2082.387455 1989.191396 1968.341332 1817.310073 1905.941304 3569.27146 3821.291799 3631.128844 3095.81101 3209.835995 2784.298658 2939.553386 2242.547456 2287.624722 2133.655558 1988.493619 2087.185527 2060.61649 2134.50346 2058.646627 2221.37476 2137.55625 2010.71598 1896.453903 1714.840392 1799.705386 1.4% 3.6% -4.6% -4.5% -1.0% -7.7% 4.9% -5.4% 7.1% -5.0% -14.7% 3.7% -13.3% 5.6% 9.6% 2.0% -6.7% -6.8% 5.0% -1.3% 3.6% -0.2% 7.9% -3.8% -5.9% -5.7% -9.6% 4.9%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
96 97 98 99 100 101 102 1938.778439 1953.406298 1957.856408 2025.5464 2083.796967 2186.539012 2092.852862 2847.783143 2842.790146 2764.783813 2747.39542 2801.121318 3207.147968 2856.210119 1966.672064 1995.454292 2034.415542 2095.996066 2102.912162 2193.068374 2075.099344 1855.449477 1899.998567 1841.874496 1908.00121 1964.659141 2107.039847 2029.600883 1.7% 0.8% 0.2% 3.5% 2.9% 4.9% -4.3% -3.1% -0.2% -2.7% -0.6% 2.0% 14.5% -10.9% -7.9% 1.5% 2.0% 3.0% 0.3% 4.3% -5.4% 3.1% 2.4% -3.1% 3.6% 3.0% 7.2% -3.7%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
103 104 105 106 107 108 109 2207.695695 2110.83577 2224.234817 2228.098841 2255.690944 2333.773931 2339.782883 3051.250404 2666.016508 2762.186598 2834.348569 2739.979843 2959.531636 3054.624055 2187.500411 2013.109319 2144.659302 2038.18002 2132.613625 2294.866744 2272.893643 2091.084193 2067.534431 2198.526523 2301.71205 2329.247346 2610.955233 2515.889574 5.5% -4.4% 5.4% 0.2% 1.2% 3.5% 0.3% 6.8% -12.6% 3.6% 2.6% -3.3% 8.0% 3.2% 5.4% -8.0% 6.5% -5.0% 4.6% 7.6% -1.0% 3.0% -1.1% 6.3% 4.7% 1.2% 12.1% -3.6%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
110 111 112 113 114 115 116 2353.855489 2486.963983 2579.538553 2574.074982 2617.686716 2637.003929 2747.403211 3279.461124 3747.243012 4131.215699 4074.738227 4239.788399 4170.240104 4245.917704 2377.91763 2562.498268 2709.101829 2909.642075 2824.996974 2789.978175 2866.39082 2648.310229 2831.08733 2937.282419 2958.277428 3147.235261 3245.878386 3586.934572 0.6% 5.7% 3.7% -0.2% 1.7% 0.7% 4.2% 7.4% 14.3% 10.2% -1.4% 4.1% -1.6% 1.8% 4.6% 7.8% 5.7% 7.4% -2.9% -1.2% 2.7% 5.3% 6.9% 3.8% 0.7% 6.4% 3.1% 10.5%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
117 118 119 120 2801.7793 2803.305291 2723.199125 2772.620267 4194.79682 4243.078059 3909.784711 4136.068878 2850.725636 2910.455754 2966.355214 3078.894739 3770.009186 3680.364113 3523.038026 3411.675269 2.0% 0.1% -2.9% 1.8% -1.2% 1.2% -7.9% 5.8% -0.5% 2.1% 1.9% 3.8% 5.1% -2.4% -4.3% -3.2%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help