| Tickers WMT ко PFE CVS BRK.A # Assets 5 WMT ко PFE CVS BRK.A WMT КО PFE Allocation Percentage Individual Portfolio Assets Name 20.00% Walmart Inc 10.00% Coca-Cola Co 5.00% Pfizer Inc. 25.00% CVS Health Corp 40.00% Berkshire Hathaway Inc. Class A Portfolio Calculations (Annualized) Expected Returns Allocation 100.00% WMT 1.000 0.240 0.085 0.348 0.318 Portfolio Coorelation Matrix 7.32% WMT 0.027 0.007 0.004 КО 0.240 0.985 0.140 0.350 0.567 StdDev (Volatility o) КО 0.007 0.028 0.006 13.74% Portfolio Annualized Covariance Matrix PFE 0.004 0.006 0.068 PFE 0.085 0.140 0.968 0.198 0.168 Allocation (w) 0.20 Sharpe Ratio 0.58 CVS 0.348 0.350 0.198 0.999 0.457 0.10 0.05 0.25 0.40 CVS 0.014 0.014 0.013 Mean Returns (μ) 6.24% 4.06% 0.33% 7.33% 9.53% BRK.A 0.318 0.567 0.168 0.457 0.994 BRK.A 0.009 0.016 0.007 Annualized StdDev (Volatility a) 15.65% 14.89% 15.33% 24.75% 16.05% Sharpe Ratio 0.44 0.31 0.06 0.32 0.63

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question

Considering the attached set of securities and portfolio returns:

  1. Choose different values within the range of the standard deviation of the portfolio, and for each chosen value, locate the corresponding point on the efficient frontier by finding the weights that maximize the expected rate of return of the portfolio. 
Individual Portfolio Assets
Annualized
Allocation
Mean Returns
StdDev
Sharpe Ratio
0.44
Tickers
Percentage
Name
Allocation (w)
(Volatility a)
(H)
6.24%
WMT
20.00% Walmart Inc
0.20
15.65%
KO
10.00% Coca-Cola Co
0.10
4.06%
14.89%
0.31
PFE
5.00% Pfizer Inc.
0.05
0.33%
15.33%
0.06
cvs
25.00% CVS Health Corp
0.25
7.33%
24.75%
0.32
BRK.A
40.00% Berkshire Hathaway Inc. Class A
0.40
9.53%
16.05%
0.63
Portfolio Calculations (Annualized)
Expected
StdDev
# Assets
Allocation
Sharpe Ratio
Returns
(Volatility o)
100.00%
7.32%
13.74%
0.58
Portfolio Coorelation Matrix
WMT
ко
PFE
CVs
BRK.A
WMT
1.000
0.240
0.085
0,348
0.318
ко
0.240
0.985
0.140
0.350
0.567
PFE
0.085
0.140
0.968
0.198
0.168
CVs
0.348
0.350
0.198
0.999
0.457
BRK.A
0.318
0.567
0.168
0.457
0.994
Portfolio Annualized Covariance Matrix
WMT
ко
PFE
CVs
BRK.A
WMT
0.027
0.007
0.004
0.014
0.009
ко
0.007
0.028
0.006
0.014
0.016
PFE
0.004
0.006
0.068
0.013
0.007
CVs
0.014
0.014
0.013
0.059
0.018
BRK.A
0.009
0.016
0.007
0.018
0.027
Transcribed Image Text:Individual Portfolio Assets Annualized Allocation Mean Returns StdDev Sharpe Ratio 0.44 Tickers Percentage Name Allocation (w) (Volatility a) (H) 6.24% WMT 20.00% Walmart Inc 0.20 15.65% KO 10.00% Coca-Cola Co 0.10 4.06% 14.89% 0.31 PFE 5.00% Pfizer Inc. 0.05 0.33% 15.33% 0.06 cvs 25.00% CVS Health Corp 0.25 7.33% 24.75% 0.32 BRK.A 40.00% Berkshire Hathaway Inc. Class A 0.40 9.53% 16.05% 0.63 Portfolio Calculations (Annualized) Expected StdDev # Assets Allocation Sharpe Ratio Returns (Volatility o) 100.00% 7.32% 13.74% 0.58 Portfolio Coorelation Matrix WMT ко PFE CVs BRK.A WMT 1.000 0.240 0.085 0,348 0.318 ко 0.240 0.985 0.140 0.350 0.567 PFE 0.085 0.140 0.968 0.198 0.168 CVs 0.348 0.350 0.198 0.999 0.457 BRK.A 0.318 0.567 0.168 0.457 0.994 Portfolio Annualized Covariance Matrix WMT ко PFE CVs BRK.A WMT 0.027 0.007 0.004 0.014 0.009 ко 0.007 0.028 0.006 0.014 0.016 PFE 0.004 0.006 0.068 0.013 0.007 CVs 0.014 0.014 0.013 0.059 0.018 BRK.A 0.009 0.016 0.007 0.018 0.027
Expert Solution
steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman