Purchase Solution

Calculating returns, variances, standard deviations for X and Y

Not what you're looking for?

Ask Custom Question

Using the following returns, calculate the average returns, the variances, and the standard deviations for X and Y.

See attached spreadsheet for the data.

Prob #7
RETURNS
Year X Y
1 10% 26%
2 18 -4
3 -8 -10
4 12 42
5 6 21

Attachments
Purchase this Solution
Solution Summary

The solution shows the formulas and the calculations to solve the questions in the problem.

Solution Preview

Please refer to attached.

RETURNS
Year X Y
1 10% 26%
2 18 -4
3 -8 -10
4 12 42
5 6 21

Step 1
Work out average return for each stock, from Year 1 to Year 5.

Average (RX) = (10 + 18 - 8 + 12 + 6) / 5
= 7.6%

Average ...

Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

View More Free Quizzes
Related BrainMass Solutions

  • Average returns, the variances and the standard deviations

    105520 Average returns, the variances and the standard deviations Calculating returns and Variability: Using the following returns, calculate the average returns, the variances and the standard deviations for X and Y.

  • Average return, variance, & the standard deviation

    55684 Calculate the average returns, variances, & the standard deviations for X and Y 1) Calculate the average returns, variances, & the standard deviations for X and Y. For average return and s.d. (Input answers rounded to 2 decimal places.

  • Finding mean and standard deviation of returns

    557052 Finding Mean and Standard Deviation of Returns Question #1 Calculate arithmetic average returns, the variances, and the standard deviations for X and Y.

  • Constructing portfolios and efficient frontiers

    Step 2 First of all, we have a correlation matrix and we need a covariance matrix for calculating portfolio variances, so we need to convert that using cov(x,y) = cor(x,y)*sd(x)*sd(y) You will see that I've computed the covariance matrix in step

  • Finance Questions and Expected Returns for Stocks

    This solution is comprised of a detailed explanation to answer what are the expected returns for Stocks X and Y, what are the standard deviations of returns on Stocks X and Y, what is the expected return on your portfolio, calculate the expected return

  • Finance : Expected Return and Risk

    (Excel: Calculating means, standard deviations, covariance, and correlation) Given the probability distributions of returns for stock X and stock Y, compute: a.

  • Expected Return for Stocks

    253030 Expected Return for Stocks (Excel: Calculating means, standard deviations, covariance, and correlation) Given the probability distributions of returns for stock X and stock Y, compute: a. the expected return for each stock, and here RETURNS

  • Accounting: Calculating the expected return and standard deviation of a portfolio.

    140819 Calculating expected return & standard deviation of a portfolio Suppose the expected returns and standard deviations of stocks A and B are E(Ra) =0.15, E(Rb) = 0.25, Stdev A = 0.1, and Stdev B = 0.2, respectively.

  • 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?

View More Related Solutions