Suppose a portfolio manager wishes to construct a portfolio using two securities Coll and USR, both of their return data are shown in the Slide 5 with the title “Hypothetical Investment Alternatives”. Specifically, the manger allocates $60,000 in the Coll and $30,000 in the USR. Please calculate (1) Portfolio Expected Return (2) Portfolio Standard Deviation
Economy |
Prob. |
T-Bills |
HT |
Coll |
USR |
MP |
Recession |
0.1 |
5.5% |
-27.0% |
27.0% |
6.0% |
-17.0% |
Below avg |
0.2 |
5.5% |
-7.0% |
13.0% |
-14.0% |
-3.0% |
Average |
0.4 |
5.5% |
15.0% |
0.0% |
3.0% |
10.0% |
Above avg |
0.2 |
5.5% |
30.0% |
-11.0% |
41.0% |
25.0% |
Boom |
0.1 |
5.5% |
45.0% |
-21.0% |
26.0% |
38.0% |
Please do not use excel.
Suppose a portfolio manager wishes to construct a portfolio using two securities Coll and USR, both...
Suppose a portfolio manager wishes to construct a portfolio using two securities Coll and USR. Specifically, the manger allocates $60,000 in the Coll and $30,000 in the USR. Please calculate (1) Portfolio Expected Return (2) Portfolio Standard Deviation Economy Prob. T-Bills HT Coll USR MP Recession 0.1 5.5% -27.0% 27.0% 6.0% -17.0% Below avg 0.2 5.5% -7.0% 13.0% -14.0% -3.0% Average 0.4 5.5% 15.0% 0.0% 3.0% 10.0% Above avg 0.2 5.5% 30.0% -11.0% 41.0% 25.0% Boom 0.1 5.5% 45.0% -21.0%...
Suppose a portfolio manager wishes to construct a portfolio using two securities Coll and USR, both of their return data are shown in the Slide 5 with the title “Hypothetical Investment Alternatives”. Specifically, the manger allocates $60,000 in the Coll and $30,000 in the USR. Please calculate (1) Portfolio Expected Return (2) Portfolio Standard Deviation Economy Prob. T-Bills HT Coll USR MP Recession 0.1 5.5% -27.0% 27.0% 6.0% -17.0% Below avg 0.2 5.5% -7.0% 13.0% -14.0% -3.0% Average 0.4 5.5%...
USE EXCEL TO CALCULATE THE FREQUENCIES AS SHOWN BELOW. PLEASE PROVIDE EXCEL FORMULA USED. Frequency Distribution Low High Bins Frequency -67.0 -56.6 (-67, -56.6] -56.6 -46.2 (-56.6, -46.2] -46.2 -35.8 (-46.2, -35.8] -35.8 -25.4 (-35.8, -25.4] -25.4 -15.0 (-25.4, -15] -15.0 -4.6 (-15, -4.6] -4.6 5.8 (-4.6, 5.8] 5.8 16.2 (5.8, 16.2] 16.2 26.6 (16.2, 26.6] 26.6 37.0 (26.6, 37] 37.0 47.4 (37, 47.4] 47.4 57.8 (47.4, 57.8] 57.8 68.2 (57.8, 68.2] 68.2 78.6 (68.2, 78.6] 78.6 89.0 (78.6, 89]...