Question

In: Finance

Given the data below, explain the distribution of weights for every portfolio? For example, the Eq-Wtd...

  1. Given the data below, explain the distribution of weights for every portfolio? For example, the Eq-Wtd portfolio allocates 20% weights to all five asset classes because it is an equally-weighted portfolio.

Portfolios

---------------------------Weights----------------------------

LGGR

LGVAL

SMGR

SMVAL

INTL

m

s

Prob(<0)

Eq-Wtd

0.200

0.200

0.200

0.200

0.200

0.126

0.161

0.241

Prop-Wtd

0.350

0.350

0.100

0.100

0.100

0.129

0.158

0.230

Tilt

0.300

0.400

0.050

0.150

0.100

0.132

0.153

0.216

l = 1

0.000

0.347

0.000

0.653

0.000

0.145

0.156

0.197

l = 2

0.000

0.622

0.000

0.378

0.000

0.142

0.149

0.190

Min Var.

0.000

0.632

0.000

0.041

0.327

0.126

0.138

0.198

Max Ret.

0.000

0.000

0.000

1.000

0.000

0.148

0.170

0.216


Solutions

Expert Solution

LGGR = Large Cap Growth .Stocks LGVL = Large Cap Value Stocks , SMGR - Small Cap Growth Stocks, SMVL = Small Cap Value Stocks . INTL = International Stocks. M = Expected Market Return of Portfolio . S = Standard deviation of the Returns , and Prob = Probability of Returns being negative.

1.The first row shows an equally weighted portfolio across large/Small Caps as well as Growth/Value stocks with expected market return  = 12.6% , and Standard deviation 16.1% . It also shows probability of negative return @24.1% which is the highest .

2. This portfolio has a larger 35%  weight to Large Value and Large Growth and lower 10% each to Small Growth and Small Value as well as international stocks. Mean Return 12.9% with deviation 15.3% and Prob of negative return 21.6% . This is large cap oriented

3.Tilted towards Value ( 40+15%)=55% .Growth 35% and International 10%

4.L1 seems to be 100% value portfolio with 65% to small value and balance Large Value. No Large or International.

5.L2 seems to 100% value but skewed towards large cap value @62.2%.

6. This portfolio is also 100% Value with 63.2% on Large Cap.This allocation  gives the Min Variation 13.8% but has one of the lowest returns of 12.6% ( along with Eq wtd) .

7. This is a 100% allocation to SmallCap Value stocks resulting in Max return of 14.8% but it has the highest variance of 17%

Conclusion is the highest returns comes with highest variation ( volatility/risk) whereas if one wants to minimize risk  then the returns are the lowest. also to minimize probability of negative return chose L2 ( value portfolio) which has the lowest  at 19% .


Related Solutions

Given that the data below was randomly selected from a lognormal distribution. What is the probability...
Given that the data below was randomly selected from a lognormal distribution. What is the probability of a randomly selected item having a value greater than 3.9? Give your answer to 3 decimal places. Data 1.72, 124.2, 1.04, 0.84, 12.82, 11.76, 51.2, 0.11
Given that the data below was randomly selected from a lognormal distribution. What is the probability...
Given that the data below was randomly selected from a lognormal distribution. What is the probability of a randomly selected item having a value greater than 3.9? Give your answer to 3 decimal places. Data 1.72, 124.2, 1.04, 0.84, 12.82, 11.76, 51.2, 0.11 answer - 0.846 was wrong  
Using the atomic weights of selected elements given below, find the formula weights for the following...
Using the atomic weights of selected elements given below, find the formula weights for the following compounds:   Atomic weights of selected elements Ca = 40 g moL-1, C = 12 g moL-1, O = 16 g moL-1, H = 1 g moL-1, P = 31 g moL-1, K = 39 g moL-1                   Si = 28 g moL-1, Al = 27 g moL-1, S = 32 g moL-1, N = 14 g moL-1 Example: (NH4)2SO4 Element no. of moles Atomic...
1. The weights in ounces of a sample of rats in a lab are given below....
1. The weights in ounces of a sample of rats in a lab are given below. 4, 4, 2, 5, 5, 3, 4, 7, 9, 5 a. Construct a frequency distribution using five classes. b. Construct a histogram for the above distribution. c. Find the Mean d. Find the Median & Mode e. Find the sample variance and standard deviation (5 points) 2. The probability that a part will malfunction is 0, 1, 2, 3, or 4 or more times...
How do you find the optimal weights of a portfolio in excel using solver given a...
How do you find the optimal weights of a portfolio in excel using solver given a predefined risk (target standard deviation)?
Do different treatments affect the weights of poplar trees? Data below report weights (in kilograms) of...
Do different treatments affect the weights of poplar trees? Data below report weights (in kilograms) of randomly selected poplar trees given different treatments (none, fertilizer, irrigation, fertilizer + irrigation). The treatments are assigned at random to the trees. Conduct a complete hypothesis testing to investigate if there are significant differences in the mean weight of poplar trees at α= 0.05 None (N) Fertilizer (F) Irrigation (I) Fertilizer + Irrigation none 0.18 0.78 0.23 2.03 0.02 Fertilizer 0.54 0.40 2.07 0.16...
Use the Empirical Rule to answer the questions below: The distribution of weights for newborn babies...
Use the Empirical Rule to answer the questions below: The distribution of weights for newborn babies is approximately normally distributed with a mean of 7.4 pounds and a standard deviation of 0.8 pounds. 1. What percent of newborn babies weigh more than 8.2 pounds? % 2. The middle 95% of newborn babies weigh between and pounds. 3. What percent of newborn babies weigh less than 5.8 pounds? % 4. Approximately 50% of newborn babies weigh more than pounds. 5. What...
Using Securities Market Line Equation (SML, Eq. 8.7, Ch. 8) and given the information below, which...
Using Securities Market Line Equation (SML, Eq. 8.7, Ch. 8) and given the information below, which of the following stock has the lowest risk? a. Stock with the required rate of return is 5%, the risk free rate is 1.5%, rate of return on market portfolio is 3% b. Stock with the required rate of return is 6%, the risk free rate is 1.5%, rate of return on market portfolio is 3% c. Stock with the required rate of return...
Listed below are annual data for various years. The data are weights ( metric tons) of...
Listed below are annual data for various years. The data are weights ( metric tons) of imported lemons and car crash fatality rates per 100,000 population. Construct a scatterplot, find the value of the linear correlation coefficient 'r' and find the P- value using significance level 0.05. Is there sufficient evidence to conclude that there is a linear correlation between lemon imports and crash fatality rates? Do the results suggest that imported lemons cause car fatalities? Lemon imports 232 266...
ind the standard deviation, s, of sample data summarized in the frequency distribution table given below...
ind the standard deviation, s, of sample data summarized in the frequency distribution table given below by using the formula below, where x represents the class midpoint, f represents the class frequency, and n represents the total number of sample values. Also, compare the computed standard deviation to the standard deviation obtained from the original list of data values, 9.09.0. sequals=StartRoot StartFraction n left bracket Summation from nothing to nothing left parenthesis f times x squared right parenthesis right bracket...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT