BFN352 - 06 Problem set - Variations

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

31

Uploaded by ProfFishMaster665

Report
Beta Mean return Monthly rf 0.10% Market 1.00 -0.04% Alice 1.71 0.40% Mary 0.82 -0.26% Linda 0.63 0.55% *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 06.101 - Here is some information about the investment performance of 3 portfolio manag 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 500 1000 1500 2000 2500 Market Alice Mary Linda
e) Calculate the Information ratio of the 3 active portfolios. According to this criteria, whic 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) Based on e), what Sharpe ratio could you obtain with an optimal strategy combining acti
Total return Variance Pt -11.2% 0.0011320256 15.7% 0.0054752908 -35.9% 0.0022741628 64.9% 0.002667237 *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? gers (and a market index) based on their monthly 84 88 92 96 100 104 108 112 116 120 a
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
ch portfolio is the best investment? portfolio managers, which one would be the best choice? uld be the best choice? tive and passive investing?
Beta Mean return Monthly rf 0.10% Market 1.00 -0.04% Alice 1.71 0.40% Mary 0.82 -0.26% Linda 0.63 0.55% *Monthly a) Calculate the realized Sharpe ratios of these 4 portfolios. According to this criteria, whic Sharpe ratio Market -0.042 Alice 0.040 Mary -0.075 Linda 0.087 Answer Linda has the highest Sharpe ratio of the portfolio managers. Both Linda a 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.101 - Here is some information about the investment performance of 3 portfolio manag 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 500 1000 1500 2000 2500 Market Alice Mary Linda
The weights w* needed on the active portfolios are: w* Market 100.0% Alice 45.5% Mary 70.6% Linda 65.1% The mean monthly returns Rp* of these new portfolios are: Market -0.04% Alice 0.24% Mary -0.15% Linda 0.39% M2 measures : Market 0.00% Alice 0.28% Mary -0.11% Linda 0.43% Answer Same result as the Sharpe ratio. Linda has the highest M2 of the portfolio c) Calculate the Treynor ratio of these 4 portfolios. According to this criteria, which portfol Monthly Treynor ratio Market -0.0014 Alice 0.0018 Mary -0.0043 Linda 0.0071 Answer Linda and Alice have beaten the market index here. Linda has the highest 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% Alice 0.543% Mary -0.24% Linda 0.539% Answer Alice and Linda appear to have stock picking skills with Alice being the mo e) Calculate the Information ratio of the 3 active portfolios. According to this criteria, whic Systematic risk (Standard deviation) Alice 5.75% Mary 2.76% Linda 2.13% Firm-specific risk (Standard deviation) Alice 4.65% Mary 3.89% Linda 4.71% Information ratio Alice 0.117 Mary -0.061 Linda 0.115 Answer Alice and Linda would both increase the Sharpe ratio of a passive portfolio f) If you wanted to hire one of these portfolio managers to expand your existing team of p Answer Linda because she 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 Linda's because it gives the highest Sharpe ratio and M2 measure. (You ge h) Based on e), what Sharpe ratio could you obtain with an optimal strategy combining acti
Market Sharpe -0.042 Information ratio Sp optimal Alice 0.117 0.1240 Mary -0.061 0.0746 Linda 0.115 0.1221 Answer Combining Alice's active portfolio with a passive market portfolio would g
Total return Variance Pt Alpha Sharpe w* Rp* M2 -11.2% 0.0011320256 0.00% -0.042 100.0% -0.04% 0.0% 15.7% 0.0054752908 0.54% 0.040 45.5% 0.24% 0.3% -35.9% 0.0022741628 -0.24% -0.075 70.6% -0.15% -0.1% 64.9% 0.002667237 0.54% 0.087 65.1% 0.39% 0.4% *over 10 year *Monthly ch portfolio is the best investment? and Mary have beaten the market index. 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 gers (and a market index) based on their monthly 84 88 92 96 100 104 108 112 116 120 a
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 o managers and both Linda and Mary have beaten the market index. lio is the best investment? ratio so she would be the best choice. ars to have stock picking skills?
ost skilled. ch portfolio is the best investment? o. Alice would be the best choice. portfolio managers, which one would be the best choice? uld be the best choice? et more return per unit of total risk) tive and passive investing?
give a Sharpe ratio of 0.124.
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.0014 3.36% - - 0.0018 5.75% 4.65% 0.12 -0.0043 2.76% 3.89% -0.06 0.0071 2.13% 4.71% 0.11 e risk free security.
Risk premium 0.005 Excess returns before fees Market variance 0.00125 t Var(ei) 0 1 2 Market 0 1000 1063.761 1047.624 Alice 0.001667 1000 1116.084 1038.702 Mary 0.001667 1000 1046.78 1091.711 Linda 0.001667 1000 1018.545 1075.265 not excess returns Market 0.063761 -0.01517 Alice 11.6% -6.9% Mary 4.7% 4.3% Linda 1.9% 5.6% Simulation parameters Calculated Alpha Beta Beta rf 0.10% Market 0.0% 1 1.00 x Alice 0.0% 1.8 1.71 rf realized 12.74% Mary 0.0% 0.9 0.82 Linda 0.4% 0.65 0.63 x 0 5 10 15 20 25 30 35 40 45 50 55 60 65 70 0 500 1000 1500 2000 2500 Market Alice M
3 4 5 6 7 8 9 10 11 1090.749 1156.861 1085.682 1103.151 1126.378 1096.762 1048.384 1102.386 1108.776807 1099.736 1215.971 1079.154 1078.557 1195.076 1210.411 1042.081 1028.949 1030.616985 1082.494 1123.394 1066.618 1070.429 1052.554 1027.893 924.7833 927.2415 921.1920734 1092.081 1072.167 1024.464 1151.159 1323.962 1304 1279.052 1347.817 1408.910416 0.041165 0.060611 -0.06153 0.01609 0.021055 -0.02629 -0.04411 0.051509 0.005797637 5.9% 10.6% -11.3% -0.1% 10.8% 1.3% -13.9% -1.3% 0.2% -0.8% 3.8% -5.1% 0.4% -1.7% -2.3% -10.0% 0.3% -0.7% 1.6% -1.8% -4.4% 12.4% 15.0% -1.5% -1.9% 5.4% 4.5% d Mean Realized r Var Ptf Alpha Sharpe Rp* Ann. Rp Ann. Rp* -0.04% -11.2% 0.001132 0.00% -0.042 -0.112 -1.2% -1.2% 0.40% 15.7% 0.005475 0.54% 0.040 0.141 1.5% 1.3% -0.26% -35.9% 0.002274 -0.24% -0.075 -0.216 -4.4% -2.4% 0.55% 64.9% 0.002667 0.54% 0.087 0.467 5.1% 3.9% x x x 0 75 80 85 90 95 100 105 110 115 120 Mary Linda
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
12 13 14 15 16 17 18 1056.841878 1028.450042 1045.278532 1040.624712 1050.601561 1019.085449 992.3648146 937.610055 863.8209311 840.630199 875.5649462 873.7639263 894.4262316 887.9074958 898.9434142 908.7064397 930.9547192 943.3678665 1010.537794 981.1829978 1030.200052 1328.850664 1256.413706 1388.620469 1482.421754 1524.981961 1513.896056 1473.471621 -0.04683984 -0.02686479 0.016362963 -0.00445223 0.009587365 -0.02999816 -0.02622021 -9.0% -7.9% -2.7% 4.2% -0.2% 2.4% -0.7% -2.4% 1.1% 2.4% 1.3% 7.1% -2.9% 5.0% -5.7% -5.5% 10.5% 6.8% 2.9% -0.7% -2.7% w* Treynor MontMean Ann. Treynor Ann. Sys risk (StDevFirm St dev IR 100.0% -0.0014 -0.5% -0.005 0.0336 - - 45.5% 0.0018 4.9% 0.029 0.0575 4.65% 0.12 70.6% -0.0043 -3.0% -0.037 0.0276 3.89% -0.06 65.1% 0.0071 6.8% 0.108 0.0213 4.71% 0.11
19 20 21 22 23 24 25 960.705168 965.5703466 1011.895303 1017.876123 1001.447472 1023.809646 1018.622777 816.5003058 832.5756029 884.1177738 874.0260366 847.7813379 881.4619609 804.6646539 1005.201549 1004.41413 1036.776763 1098.241039 1069.216696 1128.458608 1125.469802 1419.303912 1486.004584 1678.001981 1757.92004 1768.24884 1806.389782 1675.443216 -0.03190323 0.005064174 0.04797678 0.005910514 -0.01614013 0.022329852 -0.00506624 -8.0% 2.0% 6.2% -1.1% -3.0% 4.0% -8.7% -2.4% -0.1% 3.2% 5.9% -2.6% 5.5% -0.3% -3.7% 4.7% 12.9% 4.8% 0.6% 2.2% -7.2%
26 27 28 29 30 31 32 1030.838598 917.6988899 919.8127033 963.2090784 989.385193 1043.908756 1086.332258 813.7830004 666.0222172 696.4408027 761.7268167 816.4159411 907.4859901 943.5044122 1152.456467 1056.604922 1086.253534 1173.164917 1147.53733 1223.677838 1236.074263 1699.804791 1531.963488 1404.700056 1473.543784 1567.853672 1518.023253 1609.600319 0.011992488 -0.10975502 0.002303384 0.047179578 0.027175943 0.055108529 0.04063909 1.1% -18.2% 4.6% 9.4% 7.2% 11.2% 4.0% 2.4% -8.3% 2.8% 8.0% -2.2% 6.6% 1.0% 1.5% -9.9% -8.3% 4.9% 6.4% -3.2% 6.0%
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
33 34 35 36 37 38 39 1077.710477 1047.590809 1010.23212 1022.55345 1032.484017 981.8734497 1011.736403 954.6007205 910.2808368 893.0704865 956.4258426 1004.173566 966.1594417 1056.629901 1225.016289 1162.353273 1067.351309 1137.921998 1168.576641 1090.530338 1146.726581 1645.954677 1551.235731 1436.907005 1522.637204 1643.006461 1657.013853 1775.039795 -0.0079366 -0.02794783 -0.03566153 0.012196534 0.009711538 -0.04901826 0.030414258 1.2% -4.6% -1.9% 7.1% 5.0% -3.8% 9.4% -0.9% -5.1% -8.2% 6.6% 2.7% -6.7% 5.2% 2.3% -5.8% -7.4% 6.0% 7.9% 0.9% 7.1%
40 41 42 43 44 45 46 1015.691714 963.0976589 977.1881834 1040.781956 1047.548685 1008.277737 1005.821598 1041.248481 938.3954975 953.1552559 986.0550922 1026.033372 1001.588949 891.1213994 1122.037985 1073.575657 1066.065287 1108.739963 1153.290059 1202.468097 1229.65796 1746.239194 1673.424952 1687.038263 1779.495737 1707.658455 1677.700411 1671.675599 0.003909428 -0.05178151 0.014630421 0.065078328 0.006501582 -0.03748842 -0.00243598 -1.5% -9.9% 1.6% 3.5% 4.1% -2.4% -11.0% -2.2% -4.3% -0.7% 4.0% 4.0% 4.3% 2.3% -1.6% -4.2% 0.8% 5.5% -4.0% -1.8% -0.4%
47 48 49 50 51 52 53 1014.762805 1027.55634 1031.434791 1020.833063 1045.721425 1030.682038 1010.266421 858.5431175 940.0376357 953.1007525 946.3287178 1003.002652 967.9249516 893.5651965 1187.350041 1187.685803 1129.959463 1058.536092 1139.65815 1102.163299 1010.088323 1614.886744 1502.66461 1536.226283 1712.894519 1689.85177 1565.665783 1453.70933 0.008889457 0.012607414 0.003774442 -0.01027862 0.024380443 -0.01438183 -0.01980787 -3.7% 9.5% 1.4% -0.7% 6.0% -3.5% -7.7% -3.4% 0.0% -4.9% -6.3% 7.7% -3.3% -8.4% -3.4% -6.9% 2.2% 11.5% -1.3% -7.3% -7.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
54 55 56 57 58 59 60 1048.681132 1018.243542 983.2955176 1010.592697 1007.267807 1035.50256 1064.744818 977.4323322 880.2966684 819.4934904 923.2704904 916.488238 857.9565711 892.6176441 1068.643012 957.944131 931.1973953 906.0236713 919.8290114 950.5369408 963.0849262 1404.384868 1476.717358 1490.205645 1386.773045 1342.460063 1371.554907 1406.934305 0.038024338 -0.02902464 -0.03432187 0.027760911 -0.00329004 0.028031029 0.028239677 9.4% -9.9% -6.9% 12.7% -0.7% -6.4% 4.0% 5.8% -10.4% -2.8% -2.7% 1.5% 3.3% 1.3% -3.4% 5.2% 0.9% -6.9% -3.2% 2.2% 2.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
61 62 63 64 65 66 67 1023.2516 992.9068258 998.5276038 994.7929915 987.5374632 1026.220019 1088.198776 768.2059427 815.2257714 806.3261801 783.049594 785.1179063 856.6669215 932.3581446 956.5804498 997.6974147 1098.351443 1098.972088 1072.402375 1136.473074 1203.007495 1333.740596 1284.821206 1334.726934 1363.139967 1400.059872 1380.048676 1436.492915 -0.03897011 -0.02965524 0.005660932 -0.00374012 -0.00729351 0.039170723 0.060395193 -13.9% 6.1% -1.1% -2.9% 0.3% 9.1% 8.8% -0.7% 4.3% 10.1% 0.1% -2.4% 6.0% 5.9% -5.2% -3.7% 3.9% 2.1% 2.7% -1.4% 4.1%
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 1087.399155 1126.766149 1180.407509 1182.763077 1170.660479 1186.221112 1237.240687 953.1195592 991.4039855 1080.852239 1042.569279 1050.265066 1137.967726 1214.654397 1197.558852 1176.735993 1164.635669 1219.271462 1171.989503 1224.722021 1298.592161 1432.528763 1472.496765 1471.40961 1494.441636 1621.688763 1742.313152 1751.47575 -0.00073481 0.036202892 0.047606471 0.001995554 -0.01023248 0.013292183 0.043010173 2.2% 4.0% 9.0% -3.5% 0.7% 8.4% 6.7% -0.5% -1.7% -1.0% 4.7% -3.9% 4.5% 6.0% -0.3% 2.8% -0.1% 1.6% 8.5% 7.4% 0.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
75 76 77 78 79 80 81 1260.307906 1240.339962 1191.997635 1197.760584 1201.219295 1160.125936 1198.972429 1240.499215 1242.965031 1178.798022 1128.241177 1255.359182 1173.555377 1259.886963 1369.714647 1419.21355 1293.314196 1342.2714 1289.070117 1240.792138 1246.661972 1838.040255 1850.321661 1743.262967 1624.302223 1685.713642 1696.047673 1809.172055 0.018644083 -0.0158437 -0.03897506 0.004834698 0.002887647 -0.03420971 0.033484721 2.1% 0.2% -5.2% -4.3% 11.3% -6.5% 7.4% 5.5% 3.6% -8.9% 3.8% -4.0% -3.7% 0.5% 4.9% 0.7% -5.8% -6.8% 3.8% 0.6% 6.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
82 83 84 85 86 87 88 1221.400335 1193.916493 1190.031526 1199.137633 1169.16632 1136.752574 1114.348863 1339.135874 1210.729932 1331.149337 1396.338508 1331.311324 1245.482865 1232.002199 1268.535412 1315.53394 1304.034378 1309.804573 1280.792444 1272.162505 1241.627975 1811.326975 1778.291047 1773.520915 1853.161403 1787.206127 1806.18228 1832.914656 0.018705939 -0.02250191 -0.00325397 0.007651988 -0.02499406 -0.02772381 -0.01970852 6.3% -9.6% 9.9% 4.9% -4.7% -6.4% -1.1% 1.8% 3.7% -0.9% 0.4% -2.2% -0.7% -2.4% 0.1% -1.8% -0.3% 4.5% -3.6% 1.1% 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
89 90 91 92 93 94 95 1054.129976 998.792831 1009.208665 990.948405 1012.771379 1057.768255 1013.068497 1173.132159 1107.43484 1195.414653 1307.379333 1402.554514 1439.723803 1370.819871 1182.659728 1122.463415 1081.014737 1085.609972 1078.401352 1109.171467 1099.435534 1752.039558 1761.675287 1807.510896 1690.172177 1737.25374 1742.824284 1674.647885 -0.05403953 -0.05249556 0.010428423 -0.01809364 0.022022311 0.044429451 -0.04225855 -4.8% -5.6% 7.9% 9.4% 7.3% 2.7% -4.8% -4.7% -5.1% -3.7% 0.4% -0.7% 2.9% -0.9% -4.4% 0.5% 2.6% -6.5% 2.8% 0.3% -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
96 97 98 99 100 101 102 1052.297756 1037.597389 1066.21639 1001.154672 1020.680816 1017.472214 1001.158782 1390.536561 1482.156086 1549.128475 1455.787019 1568.074279 1628.666504 1582.702944 1245.226481 1163.122023 1193.16819 1214.925886 1187.91197 1205.588101 1194.64355 1758.435527 1745.81567 1658.680169 1512.066592 1615.962279 1688.023393 1655.124169 0.038723205 -0.01396978 0.02758199 -0.06102112 0.019503624 -0.00314359 -0.0160333 1.4% 6.6% 4.5% -6.0% 7.7% 3.9% -2.8% 13.3% -6.6% 2.6% 1.8% -2.2% 1.5% -0.9% 5.0% -0.7% -5.0% -8.8% 6.9% 4.5% -1.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
103 104 105 106 107 108 109 975.8772728 975.3477454 957.2575307 972.5583281 942.9715074 859.96167 798.6306437 1516.391541 1575.903754 1498.658001 1600.092799 1406.643066 1117.742266 940.0958568 1152.339518 1125.286267 1198.112553 1190.032496 1077.016061 948.7689148 868.5481953 1731.049103 1726.464153 1890.206564 1980.370456 1832.880405 1720.217494 1723.800947 -0.02525225 -0.00054262 -0.01854745 0.015983993 -0.03042164 -0.08803006 -0.07131833 -4.2% 3.9% -4.9% 6.8% -12.1% -20.5% -15.9% -3.5% -2.3% 6.5% -0.7% -9.5% -11.9% -8.5% 4.6% -0.3% 9.5% 4.8% -7.4% -6.1% 0.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
110 111 112 113 114 115 116 840.1536155 868.5552609 877.8272688 832.7965214 844.1502723 847.5776312 830.5032089 1083.859991 1183.621342 1248.212438 1146.823447 1116.190561 1115.406678 1121.833 869.5237294 848.2955872 786.8971953 719.217484 678.2261852 661.6704219 603.9966604 1783.334254 1675.964838 1673.494069 1741.324606 1935.714608 1902.655583 1762.467175 0.05199271 0.033805301 0.010675208 -0.05129796 0.013633283 0.004060129 -0.02014497 15.3% 9.2% 5.5% -8.1% -2.7% -0.1% 0.6% 0.1% -2.4% -7.2% -8.6% -5.7% -2.4% -8.7% 3.5% -6.0% -0.1% 4.1% 11.2% -1.7% -7.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
117 118 119 120 887.1651326 909.7606992 887.4864803 887.6698432 1336.604947 1437.244723 1300.440879 1156.670669 649.956142 630.3605529 643.7273852 640.8049788 1752.955151 1769.076001 1686.693178 1648.561932 0.068226014 0.025469403 -0.0244836 0.000206609 19.1% 7.5% -9.5% -11.1% 7.6% -3.0% 2.1% -0.5% -0.5% 0.9% -4.7% -2.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