| 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
| 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
Related questions
Question
Considering the attached set of securities and portfolio returns:
- 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.

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

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 4 images

Recommended textbooks for you

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc

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
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning

Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON

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
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman