Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I've a set of 5 securities and their individual and portfolio SD/Mean etc. i had to choose random weightings for them but then have a

I've a set of 5 securities and their individual and portfolio SD/Mean etc. i had to choose random weightings for them but then have a question around minimizing CV.

How do I find the combination of the weights that minimizes CV of the portfolio?

(what i have so far attached for reference - but just wondering what formula/concept i use to do so)image text in transcribed

Individual Portfolio Assets Tickers WMT KO PFE Allocation Percentage 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 Allocation (w) 0.20 0.10 0.05 0.25 0.40 Mean Returns (u) 6.24% 4.06% 0.33% 7.33% 9.53% Annualized Std Dev (Volatility o) 15.65% 14.89% 15.33% 24.75% 16.05% Sharpe Ratio 0.44 0.31 0.06 0.32 0.63 CVS BRK.A # Assets Portfolio Calculations (Annualized) StdDev Allocation Expected Returns (Volatility o) 100.00% 7.32% 13.74% Sharpe Ratio 5 0.58 Portfolio Coorelation Matrix KO CVS WMT KO WMT 1.000 0.240 0.085 0.348 0.318 PFE 0.085 0.140 0.968 0.198 0.168 0.240 0.985 0.140 0.350 0.567 PFE CVS BRK.A BRK.A 0.318 0.567 0.168 0.457 0.994 0.348 0.350 0.198 0.999 0.457 Portfolio Annualized Covariance Matrix WMT KO PFE CVS BRK.A WMT 0.027 0.007 0.004 0.014 0.009 KO 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 BRKA 0.009 0.016 0.007 0.018 0.027 Individual Portfolio Assets Tickers WMT KO PFE Allocation Percentage 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 Allocation (w) 0.20 0.10 0.05 0.25 0.40 Mean Returns (u) 6.24% 4.06% 0.33% 7.33% 9.53% Annualized Std Dev (Volatility o) 15.65% 14.89% 15.33% 24.75% 16.05% Sharpe Ratio 0.44 0.31 0.06 0.32 0.63 CVS BRK.A # Assets Portfolio Calculations (Annualized) StdDev Allocation Expected Returns (Volatility o) 100.00% 7.32% 13.74% Sharpe Ratio 5 0.58 Portfolio Coorelation Matrix KO CVS WMT KO WMT 1.000 0.240 0.085 0.348 0.318 PFE 0.085 0.140 0.968 0.198 0.168 0.240 0.985 0.140 0.350 0.567 PFE CVS BRK.A BRK.A 0.318 0.567 0.168 0.457 0.994 0.348 0.350 0.198 0.999 0.457 Portfolio Annualized Covariance Matrix WMT KO PFE CVS BRK.A WMT 0.027 0.007 0.004 0.014 0.009 KO 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 BRKA 0.009 0.016 0.007 0.018 0.027

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance For Nonfinancial Managers Beginners Handbook For Finance

Authors: Murugesan Ramaswamy

1st Edition

1516973801, 978-1516973804

More Books

Students also viewed these Finance questions

Question

c. What groups were least represented? Why do you think this is so?

Answered: 1 week ago

Question

7. Describe phases of multicultural identity development.

Answered: 1 week ago