Use Solver and the information below to find the highest Sharpe ratio portfolio (long-only, no short sales allowed). The

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

Use Solver and the information below to find the highest Sharpe ratio portfolio (long-only, no short sales allowed). The

Post by answerhappygod »

Use Solver and the information below to find the highest Sharpe
ratio portfolio (long-only, no short sales allowed). The riskless
rate of 0.1. What is the standard deviation of this optimized
portfolio (in the same units as below)?
The expected EXCESS returns of the five assets are:
A
B
C
D
E
0.49
0.58
0.85
0.37
0.50
And covariance matrix of the 5 assets is:
A
B
C
D
E
A
24
15
10
10
14
B
15
24
13
15
17
C
10
13
16
9
11
D
10
15
9
36
12
E
14
17
11
12
23
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply