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
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
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
2.
arrow_forward
Following is information for the required returns and standard deviations of returns for A, B, and C. The correlation coefficients for each pair also are shown below in a matrix. Which is the portfolio you will recommend AB, AC, or BC, and why?
A
B
C
Required Rate of return
7%
10%
20%
Standard Deviation
33%
54%
90%
Coefficient A,B
0.16
Coefficient A,C
0.19
Coefficient B,C
0.17
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
Portfolio manager wants to optimize the riskiness of the two assets portfolio with the given statistics below:-
Assets
Return
Volatility
Weight
A
17.00%
15.00%
40.00%
B
21.00%
25.00%
60.00%
Correlation
-0.70
-0.35
0.25
0.50
0.70
Requirements
Calculate the two assets portfolio standard deviation at different correlation levels which are mentioned above and suggest at which correlation is best suits to your portfolio.
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
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
The following portfolios are being considered for investment. During the period under consideration, RFR = 0.07.Portfolio Return Beta σiA 0.15 1.0 0.05B 0.20 1.5 0.10C 0.10 0.6 0.03D 0.17 1.1 0.06Market 0.13 1.0 0.04
a. Compute the Sharpe measure for each portfolio and the market portfolio.
b. Compute the Treynor measure for each portfolio and the market portfolio.
c. Rank the portfolios using each measure, explaining the cause for any differences you find in the rankings.
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
Using the return data on portfolios A and B provided in the accompanying spreadsheet, compute the return volatility for portfolio A. Round off your answer to three digits after the decimal point. State your answer as a percentage point, such as 1.234.
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
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
Use the information provided in the table below to answer the questions that
follows.
Average return
Beta
(ii)
Standard deviation
T-bill
Portfolio X
35%
1.2
42%
6%
Calculate each of the following performance measures for the above portfolio
and market:
Sharpe ratio
Treynor ratio
Jensen's alpha
Market Y
28 %
1.00
30%
6%
Interpret and compare the result obtained for Sharpe ratio against Treynor ratio.
arrow_forward
You are given the following information concerning three portfolios, the market portfolio, and the risk-
free asset:
Portfolio
X
Y
Z
Market
Risk-free
Rp
14.5%
R-squared
13.5
9.1
10.7
5.4
op
36%
31
21
26
0
6p
1.60
1.30
.80
1.00
0
Assume that the correlation of returns on Portfolio Y to returns on the market is 72. What percentage of
Portfolio Y's return is driven by the market? (Enter your answer as a decimal not a percentage. Round
your answer to 4 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_forward2.arrow_forwardFollowing is information for the required returns and standard deviations of returns for A, B, and C. The correlation coefficients for each pair also are shown below in a matrix. Which is the portfolio you will recommend AB, AC, or BC, and why? A B C Required Rate of return 7% 10% 20% Standard Deviation 33% 54% 90% Coefficient A,B 0.16 Coefficient A,C 0.19 Coefficient B,C 0.17arrow_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_forwardPortfolio manager wants to optimize the riskiness of the two assets portfolio with the given statistics below:- Assets Return Volatility Weight A 17.00% 15.00% 40.00% B 21.00% 25.00% 60.00% Correlation -0.70 -0.35 0.25 0.50 0.70 Requirements Calculate the two assets portfolio standard deviation at different correlation levels which are mentioned above and suggest at which correlation is best suits to your portfolio.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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you