BFN352 - 06 Problem set - Variations
xlsx
keyboard_arrow_up
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
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
Related Documents
Related Questions
Consider the following table which provides a comparison of the returns for a portfolio and its benchmark.
Year
0
1
2
3
4
5
Return
Alpha
Sum
Tracking Error
Information Ratio
Note: the numbers in red are negative
b. Calculate the portfolio alpha in percentage terms
c. Calculate the tracking error of the portfolio in percentage terms
Portfolio Return
16%
9%
-35%
22%
84%
Required
a. Calculate the annualised return of the portfolio and the benchmark in percentage terms
d. Calculate the information ratio of the portfolio to 2 decimal places
e. Determine to 2 decimal places the amount of Carhart alpha for the portfolio in percentage terms if:
o the risk-free rate is 3.25%,
o the return of the market is 9.20%,
o the exposure to the value factor (when the premium is 3.15%) is 0.65 (ie 65%),
o the exposure to the small cap factor (when the premium is 2.05%) is -0.12, and
o the exposure to the momentum factor (when the premium is 46%) is 0.1.
Benchmark Return
14%
7%
-38%
18%
86%
arrow_forward
Consider the following performance data for two portfolio managers (A and B) and a common benchmark portfolio:
BENCHMARK
MANAGER A
MANAGER B
Weight
Return
WEIGHT
RETURN
WEIGHT
RETURN
Stock
0.7
-4.7
0.7
-3.8
0.2
-4.7
%
Bonds
0.2
-4.0
0.1
-2.2
0.6
-4.0
Cash
0.1
0.3
0.2
0.3
0.2
0.3
Calculate (1) the overall return to the benchmark portfolio, (2) the overall return to Manager A’s actual portfolio, and (3) the overall return to Manager B’s actual portfolio. Briefly comment on whether these managers have under- or outperformed the benchmark fund. Round your answers to two decimal places. Use a minus sign to enter negative values, if any.
Overall return
Benchmark
%
Manager A
%
Manager B
%
Using attribution analysis, calculate (1) the selection effect, and (2) the allocation effect for both Manager A and Manager B. Using these numbers in conjunction with your results from Part a, comment on whether these managers have added value…
arrow_forward
USE THE INFORMATION BELOW FOR THE FOLLOWING
PROBLEM(S)
Asset (A)
Asset (B)
E(RA)=10%
E(RB) = 15%
(σA)=8%
(GB) = 9.5%
WA = 0.25
WB = 0.75
COVA.B = 0.006
What is the standard deviation of this portfolio?
O 13.75%
O 8.79%
O 12.5%
O 7.72%
arrow_forward
Consider the following performance data for two portfolio managers (A and B) and a common benchmark portfolio:
BENCHMARK
MANAGER A
MANAGER B
Weight Return
Weight Return
Weight Return
Stock
0.7
-4.8%
0.7
-3.9%
0.3
-4.8%
Bonds
0.2
-3.1
0.1
-2.2
0.4
-3.1
Cash
0.1
0.3
0.2
0.3
0.3
0.3
arrow_forward
Consider the following performance data for two portfolio managers (A and B) and a common benchmark portfolio:
BENCHMARK
MANAGER A
MANAGERB
Weight Return
Weight Return
Weight Return
Stock
0.7
-4.8%
0.7
-3.9%
0.3
-4.8%
Bonds
0.2
-3.1
0.1
-2.2
0.4
-3.1
Cash
0.1
0.3
0.2
0.3
0.3
0.3
a. Calculate (1) the overall return to the benchmark portfolio, (2) the overall return to Manager A's actual portfolio, and (3) the overall return to Manager B's actual portfolio. Briefly
comment on whether these managers have under- or outperformed the benchmark fund. Round your answers to two decimal places. Use a minus sign to enter negative values, if
any.
Overall return
Benchmark
Manager A
%
Manager B
%
Manager A has -Select-
v the benchmark fund.
Manager B has -Select-
| the benchmark fund.
b. Using attribution analysis, calculate (1) the selection effect, and (2) the allocation effect for both Manager A and Manager B. Using these numbers in conjunction with your results
from Part a, comment on whether…
arrow_forward
The following portfolios are being considered for investment. During the period under consideration, RFR = 0.07.
Portfolio
Return
Beta
P
0.15
1.00
0.05
Q
0.09
0.50
0.03
R.
0.21
1.30
0.10
0.18
1.20
0.06
Market
0.12
1.00
0.04
a. Compute the Sharpe measure for each portfolio and the market portfolio. Round your answers to three decimal places.
Portfolio
Sharpe measure
P
Q
R
Market
b. Compute the Treynor measure for each portfolio and the market portfolio. Round your answers to three decimal places.
Portfolio
Treynor measure
P
Q
R
Market
c. Rank the portfolios using each measure, explaining the cause for any differences you find in the rankings.
Portfolio
Rank (Sharpe measure) Rank (Treynor measure)
P
|-Select- v
|-Select- v
Q
-Select- v
-Select- V
R.
-Select- V
-Select- v
-Select- v
-Select- v
Market
-Select- v
-Select- v
-Select-
v is poorly diversified since it has a high ranking based on the -Select-
but a much lower ranking with the -Select-
arrow_forward
The following portfolios are being considered for investment. During the period under consideration, RFR = 0.08.
Portfolio
Return
Beta
σi
P
0.14
1.00
0.05
Q
0.20
1.30
0.11
R
0.10
0.60
0.03
S
0.17
1.20
0.06
Market
0.12
1.00
0.04
Compute the Sharpe measure for each portfolio and the market portfolio. Round your answers to three decimal places.
Portfolio
Sharpe measure
P
Q
R
S
Market
Compute the Treynor measure for each portfolio and the market portfolio. Round your answers to three decimal places.
Portfolio
Treynor measure
P
Q
R
S
Market
arrow_forward
Considering the attached set of securities and portfolio returns:
Find the combination of the weights that minimizes CV of the portfolio.
How does the CV of the optimal portfolio compare with the CVs of its constituents?
arrow_forward
What is portfolio A's CAPM beta based on your analysis? Round off your answer to three digits after the decimal points. State your answer as a percentage point as 1.234.
Compute the Treynor measure for portfolio B. Round off your answer to three digits after the decimal point. State your answer as 1.234
arrow_forward
2. Calculate the expected return and expected risk of the portfolio below given the Asset J
and Asset K has a correlation coefficient of +0.8.
Asset
Asset J
Asset K
Expected Return
8.0%
14.0%
Weighting
60%
40%
Risk of each asset
12.0%
21.0%
arrow_forward
Consider the following investments:
Investment Expected return Standard deviationA 5% 10%B 7% 11%C 6% 12%D 6% 10%
Which would you prefer between the following pairs:a) A and Db) B and Cc) C and D
arrow_forward
Berdasarkan informasi tersebut a. Expected return Asset A b. Standard Deviation Asset A dan Asset B c. Portfolio AB Expected Return. d. Coefficient Correlation AB e. Portofolio AB Standard Deviation Please explain by Microsoft excel
arrow_forward
Review the table below listing performance metrics for selected assets. The metrics are defined in the same way as in CAPM
Return
risk
beta
riskless asset
4%
0%
0
Market Portfolio
9%
24%
1
Fund A
8%
33%
0.4
Fund B
11%
30%
1.5
arrow_forward
The following portfolios are being considered for investment. During the period under consideration, RFR =0.07
Porfolio
Return
Beta
P
0.15
1.00
0.05
Q
0.20
1.50
0.1
R
0.10
0.60
0.03
S
0.17
1.10
0.06
Market
0.13
1.00
0.04
Compute the Sharpe measure for each portfolio and the market portfolio
Compute the Treynor measure for each portfolio and the market portfolio
Rank the portfolios using each measure explaining the cause for any differences you find in the rankings.
arrow_forward
Two investments, X and Y, have the characteristics shown below.
E(X) = $70, E(Y)3D$120, o =7,000, a
= 14,000, and ory =7,500
If the weight of portfolio assets assigned to investment X is 0.3, compute the
a. portfolio expected return and
b. portfolio risk.
a. If the weight of portfolio assets assigned to investment X is 0.3, the portfolio expected retum is $
(Type an integer or a decimal.)
b. If the weight of portfolio assets assigned to investment X is 0.3, the portfolio risk is approximately $.
(Round to two decimal places as needed.)
arrow_forward
6. Consider the following performance data for two portfolio managers (A and B) and a
common benchmark portfolio:
BENCHMARK
MANAGER A
MANAGER B
Return
Weight
Weight
Weight
Return
Return
Stock
0.5
-4.0%
0.6
-5.0%
0.3
-5.0%
Bonds
0.3
-3.5
0.2
-2.5
0.4
-3.5
0.1
Cash
0.3
0.3
0.3
0.3
0.3
Evaluation of Asset Management
a. Calculate (1) the overall return to the benchmark portfolio, (2) the overall return to
Manager A's actual portfolio, and (3) the overall return to Manager B's actual portfo-
lio. Briefly comment on whether these managers have under- or outperformed the
benchmark fund.
b. Using attribution analysis, calculate (1) the selection effect for Manager A, and (3) the
allocation effect for Manager B. Using these numbers in conjunction with your results
from part (a), comment on whether these managers have added value through their
selection skills, their allocation skills, or both.
arrow_forward
a. Compute the expected rate of return on investment i given the following information: the market risk premium is 5%; Rf = 6%; βi = 1.2.
b. Compute E(RM).
arrow_forward
Sangita
arrow_forward
Consider the following information for four portfolios, the market, and the risk-free rate (RFR):
Portfolio
Return
Beta
SD
A1
0.15
1.25
0.182
A2
0.1
0.9
0.223
A3
0.12
1.1
0.138
A4
0.08
0.8
0.125
Market
0.11
1
0.2
RFR
0.03
0
0
Refer to Exhibit 18.6. Calculate the Jensen alpha Measure for each portfolio.
a. A1 = 0.014, A2 = -0.002, A3 = 0.002, A4 = -0.02
b. A1 = 0.002, A2 = -0.02, A3 = 0.002, A4 = -0.014
c. A1 = 0.02, A2 = -0.002, A3 = 0.002, A4 = -0.014
d. A1 = 0.03, A2 = -0.002, A3 = 0.02, A4 = -0.14
e. A1 = 0.02, A2 = -0.002, A3 = 0.02, A4 = -0.14
arrow_forward
Consider the following information:
Portfolio
Expected Return
Standard Deviation
Risk-free
7%
0%
Market
11.6
28
A
10.0
17
Required:
a. Calculate the Sharpe ratios for the market portfolio and portfolio A. (Round your answers to 2 decimal places.)
b. If the simple CAPM is valid, is the above situation possible?
arrow_forward
Calculate the expected return of portfolio and standard deviation of portfolio of 3 Assets (Security B, C, and D) (Hints: Assume that weights of B, C, and D are , respectively;
the expected rate of return for Security B, C, and D is 9.9%, 1.2%, 7.3%, respectively)?
Prob.
Security A
Security B
Security C
Security D
Security E
Recession
0.1
3.0%
-29.5%
24.5%
3.5%
-19.5%
Below avg.
0.2
3.0%
-9.5%
10.5%
-16.5%
-5.5%
Average
0.4
3.0%
12.5%
-1.0%
0.5%
7.5%
Above avg.
0.2
3.0%
27.5%
-5.0%
38.5%
22.5%
Boom
0.1
3.0%
42.5%
-20.0%
23.5%
35.5%
arrow_forward
Compute the residual risk measure for portfolio A. Round off your final answer to three digits after the decimal point.
Compute the appraisal ratio for portfolio B. Round off your final answer to three digits after the decimal point.
arrow_forward
Capital asset pricing model (CAPM) For the asset shown in the following table, use the capital asset
pricing model to find the required return. (Click on the icon here in order to copy the contents of the
data table below into a spreadsheet.)
Risk-free
rate, RF
Market
return, m
Beta, b
5%
8%
1.3
The required return for the asset is
%. (Round to two decimal places.)
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Related Questions
- Consider the following table which provides a comparison of the returns for a portfolio and its benchmark. Year 0 1 2 3 4 5 Return Alpha Sum Tracking Error Information Ratio Note: the numbers in red are negative b. Calculate the portfolio alpha in percentage terms c. Calculate the tracking error of the portfolio in percentage terms Portfolio Return 16% 9% -35% 22% 84% Required a. Calculate the annualised return of the portfolio and the benchmark in percentage terms d. Calculate the information ratio of the portfolio to 2 decimal places e. Determine to 2 decimal places the amount of Carhart alpha for the portfolio in percentage terms if: o the risk-free rate is 3.25%, o the return of the market is 9.20%, o the exposure to the value factor (when the premium is 3.15%) is 0.65 (ie 65%), o the exposure to the small cap factor (when the premium is 2.05%) is -0.12, and o the exposure to the momentum factor (when the premium is 46%) is 0.1. Benchmark Return 14% 7% -38% 18% 86%arrow_forwardConsider the following performance data for two portfolio managers (A and B) and a common benchmark portfolio: BENCHMARK MANAGER A MANAGER B Weight Return WEIGHT RETURN WEIGHT RETURN Stock 0.7 -4.7 0.7 -3.8 0.2 -4.7 % Bonds 0.2 -4.0 0.1 -2.2 0.6 -4.0 Cash 0.1 0.3 0.2 0.3 0.2 0.3 Calculate (1) the overall return to the benchmark portfolio, (2) the overall return to Manager A’s actual portfolio, and (3) the overall return to Manager B’s actual portfolio. Briefly comment on whether these managers have under- or outperformed the benchmark fund. Round your answers to two decimal places. Use a minus sign to enter negative values, if any. Overall return Benchmark % Manager A % Manager B % Using attribution analysis, calculate (1) the selection effect, and (2) the allocation effect for both Manager A and Manager B. Using these numbers in conjunction with your results from Part a, comment on whether these managers have added value…arrow_forwardUSE THE INFORMATION BELOW FOR THE FOLLOWING PROBLEM(S) Asset (A) Asset (B) E(RA)=10% E(RB) = 15% (σA)=8% (GB) = 9.5% WA = 0.25 WB = 0.75 COVA.B = 0.006 What is the standard deviation of this portfolio? O 13.75% O 8.79% O 12.5% O 7.72%arrow_forward
- Consider the following performance data for two portfolio managers (A and B) and a common benchmark portfolio: BENCHMARK MANAGER A MANAGER B Weight Return Weight Return Weight Return Stock 0.7 -4.8% 0.7 -3.9% 0.3 -4.8% Bonds 0.2 -3.1 0.1 -2.2 0.4 -3.1 Cash 0.1 0.3 0.2 0.3 0.3 0.3arrow_forwardConsider the following performance data for two portfolio managers (A and B) and a common benchmark portfolio: BENCHMARK MANAGER A MANAGERB Weight Return Weight Return Weight Return Stock 0.7 -4.8% 0.7 -3.9% 0.3 -4.8% Bonds 0.2 -3.1 0.1 -2.2 0.4 -3.1 Cash 0.1 0.3 0.2 0.3 0.3 0.3 a. Calculate (1) the overall return to the benchmark portfolio, (2) the overall return to Manager A's actual portfolio, and (3) the overall return to Manager B's actual portfolio. Briefly comment on whether these managers have under- or outperformed the benchmark fund. Round your answers to two decimal places. Use a minus sign to enter negative values, if any. Overall return Benchmark Manager A % Manager B % Manager A has -Select- v the benchmark fund. Manager B has -Select- | the benchmark fund. b. Using attribution analysis, calculate (1) the selection effect, and (2) the allocation effect for both Manager A and Manager B. Using these numbers in conjunction with your results from Part a, comment on whether…arrow_forwardThe following portfolios are being considered for investment. During the period under consideration, RFR = 0.07. Portfolio Return Beta P 0.15 1.00 0.05 Q 0.09 0.50 0.03 R. 0.21 1.30 0.10 0.18 1.20 0.06 Market 0.12 1.00 0.04 a. Compute the Sharpe measure for each portfolio and the market portfolio. Round your answers to three decimal places. Portfolio Sharpe measure P Q R Market b. Compute the Treynor measure for each portfolio and the market portfolio. Round your answers to three decimal places. Portfolio Treynor measure P Q R Market c. Rank the portfolios using each measure, explaining the cause for any differences you find in the rankings. Portfolio Rank (Sharpe measure) Rank (Treynor measure) P |-Select- v |-Select- v Q -Select- v -Select- V R. -Select- V -Select- v -Select- v -Select- v Market -Select- v -Select- v -Select- v is poorly diversified since it has a high ranking based on the -Select- but a much lower ranking with the -Select-arrow_forward
- The following portfolios are being considered for investment. During the period under consideration, RFR = 0.08. Portfolio Return Beta σi P 0.14 1.00 0.05 Q 0.20 1.30 0.11 R 0.10 0.60 0.03 S 0.17 1.20 0.06 Market 0.12 1.00 0.04 Compute the Sharpe measure for each portfolio and the market portfolio. Round your answers to three decimal places. Portfolio Sharpe measure P Q R S Market Compute the Treynor measure for each portfolio and the market portfolio. Round your answers to three decimal places. Portfolio Treynor measure P Q R S Marketarrow_forwardConsidering the attached set of securities and portfolio returns: Find the combination of the weights that minimizes CV of the portfolio. How does the CV of the optimal portfolio compare with the CVs of its constituents?arrow_forwardWhat is portfolio A's CAPM beta based on your analysis? Round off your answer to three digits after the decimal points. State your answer as a percentage point as 1.234. Compute the Treynor measure for portfolio B. Round off your answer to three digits after the decimal point. State your answer as 1.234arrow_forward
- 2. Calculate the expected return and expected risk of the portfolio below given the Asset J and Asset K has a correlation coefficient of +0.8. Asset Asset J Asset K Expected Return 8.0% 14.0% Weighting 60% 40% Risk of each asset 12.0% 21.0%arrow_forwardConsider the following investments: Investment Expected return Standard deviationA 5% 10%B 7% 11%C 6% 12%D 6% 10% Which would you prefer between the following pairs:a) A and Db) B and Cc) C and Darrow_forwardBerdasarkan informasi tersebut a. Expected return Asset A b. Standard Deviation Asset A dan Asset B c. Portfolio AB Expected Return. d. Coefficient Correlation AB e. Portofolio AB Standard Deviation Please explain by Microsoft excelarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
