Purchase Solution

Compute the Mean and Standard Deviation of the Portfolio

Not what you're looking for?

Ask Custom Question

An investor puts $15,000 in each of four stocks, labeled A, B, C, and D. The table below contains means and standard deviations of the annual returns of these 4 stocks.

A: Mean = .15 Standard Deviation = .05
B: Mean = .18 Standard Deviation = .07
C: Mean = .14 Standard Deviation = .03
D: Mean = .17 Standard Deviation = .06

1) Assume that the returns of these 4 stocks are independent of each other. Use a spreadsheet to calculate the mean and standard deviation of the total amount that this investor earns in 1 year from these 4 investments as a function of the information in the table.

2) Let "v" denote a market volatility index. The standard deviation of a stock "n" is now v*std dev of n, where std dev is its base volatility level. The volatility index impacts all stocks in the same way.

If v=1 then the std dev of the 4 stocks A, B, C, D are as shown in the table. In general, v can be lower than 1 (low volatility) or higher. For example, if v=1.1, then stock A has volatility 1.1*.05, stock B has volatility 1.1*.07, and so on.

Modify the spreadsheet above to accommodate the possibility of v not equal to 1. Use excel data table (1 dimensional) to check the sensitivity of the portfolio's std dev as a function of v. Vary v from .05 to 1.5 in .05 increments.

Purchase this Solution
Solution Summary

The solution gives detailed steps on computing the mean and standard deviation of portfolio and checking the sensitivity of the portfolio's standard deviation using market volatility index.

Purchase this Solution
Free BrainMass Quizzes
Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Graphs and Functions

This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.

Know Your Linear Equations

Each question is a choice-summary multiple choice question that will present you with a linear equation and then make 4 statements about that equation. You must determine which of the 4 statements are true (if any) in regards to the equation.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

View More Free Quizzes
Related BrainMass Solutions

  • Portfolio Risk and Return, Beta, Standard deviation

    Compute the standard deviation of a portfolio invested half in X and half in Y. 4) The expected standard deviation of market returns is 0.20.

  • Calculate the Standard Deviation of a Two-stock Portfolio

    54% - Correlation(X,Y) = .25 - Mean is 15.6% What is the standard deviation for a portfolio with 60% in stock x and 40% invested in stock Y?

  • Calculating the Coefficient of Variation and Standard Deviation

    Calculate the standard deviation for each stock and for the portfolio 2. Calculate the coefficient of variation for each stock and for the portfolio. If you were a risk averse investor- which stock is better?

  • Standard Deviation and Risk

    An important attribute of the standard deviation as a measure of spread is that if the mean and standard deviation of a normal distribution are known, it is possible to compute the percentile rank associated with any given score.

  • Portfolio Optimization Techniques

    You must compute the mean (expected return) and standard deviation for each of these three portfolios in the designated spots using matrix functions. (Use CAPM for returns) d.

  • Poisson & Normal Probabilities - Contingency Tables

    If lamda = 2, find P( X >= 2 ) l = 2 X = 2 Q4: 6 Given a standardized normal distribution (with a mean of 0 and a standard deviation of 1, as in Table E.2), what is the probability that: a.

  • Portfolio risk and return

    Compute the mean and standard deviation of the individual stock returns, and S&P 500 index returns over the sample period. Is the portfolio's return riskier than the individual stock returns, than the index returns? 2.

  • Corporate Investment Analysis

    Compute the arithmetic mean annual rate of return for each stock. Which stock is most desirable by this measure? b. Compute the standard deviation of the annual rate of return for each stock. (Use Chapter 1 Appendix if necessary.)

  • Expected Return and Standard Deviation of Portfolio Caclulations

    29955 Expected return and standard deviation of portfolio 3. Consider two securities with expected return of 16% and 20% and standard deviation of 25% and 40%, respectively. a.

View More Related Solutions