Purchase Solution

Stock Analysis- Calculation of Beta in EXCEL

Not what you're looking for?

Ask Custom Question

I've attached an Excel file with the stock numbers. Please see my questions below.

A) Can you help me determine which stocks are the most volatile?
B) Help calculate the value of beta for each stock.

I don't have a lot of experience with stock market performance but can you help me determine:
C) Which of such stocks would you expect to perform best in an up market?
D) Which would you expect to hold their value best in a down market?
E) Please comment on how much of the return for the individual stocks is described by the market.

Thank you

Attachments
Purchase this Solution
Solution Summary

Stock Analysis- Calculation of Beta in EXCEL

Solution Preview

The volatility of a stock can be assessed by the value of its beta. A stock with a beta of zero indicates no correlation with the chosen benchmark. A stock with a beta of one indicates that the stock has the same volatility as the benchmark. A stock with a beta of more than one indicates the stock is more volatile than its benchmark. A stock with a beta of less than one indicates the stock is less volatile than its benchmark. ...

Solution provided by:
Anwesha Ghosh, MSc
Education
  • MSc, Osmania University
  • MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
  • BSc, Banaras Hindu University
Recent Feedback
  • "Very fast turnaround. Excellent communication! Much appreciated!"
  • "excellent"
  • "excellent"
  • "excellent work"
  • "Fantastic..great solution and very well explained!!!!"
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

View More Free Quizzes
Related BrainMass Solutions

  • Home Market Value vs Age: Scatter Chart, Trendline, Regression

    The Excel file Hypothetical Stock Data shows daily closing prices for a particular stock and the S&P 500 index. a. Apply regression analysis to find the beta associated with the stock. b. Test the hypothesis that beta is equal to one. c.

  • Calculating beta from raw data using regression

    However, we are building portfolio and making a decision whether a stock should be included in the portfolio or not, we consider beta. Run regression using Excel. Tools....Data Analysis .......Regression.

  • Portfolio of Stocks

    Critique the calculations and analysis of at least one colleague. If the calculation was in error, explain how to correct that calculation and please show all of your work.

  • Beta Value & Regression Analysis

    The solution provides step by step method for the calculation of regression analysis. Formula for the calculation and Interpretations of the results are also included. Attached in Excel and Word.

  • Expected Return

    77124 Formula and Calculation for Expected Return Explain and work in Excel. Expected return on the market portfolio is 17.7 percent and risk free rate is 4.1 percent. Edward Jones has a beta of 1.6. Under CAPM A.

  • Calculation of Beta of the portfolio

    473754 Calculation of Beta of the portfolio You hold a portfolio of stocks consisting of the following: Stock Beta Current Value Blackwater Gas 0.5 $10,000 Tidy Tom's Cleaners

  • Calculation of beta

    304646 Calculation of beta Pick at least one of the following companies and do the calculations that lead you to a result for beta, in a fashion similar to that which I used to compute 3M's beta in the Excel file included in this posting.

  • Equilibrium Stock Price - Change in Price Calculation

    The solution shows how to calculate the change in the stock price based on the given information with calculations in excel.

  • Risk Assessment of Strident Marks

    Calculate the measure of risk for this company (defined as Beta in the Capital Asset Pricing Model - CAPM) and explain why this calculation is a measure of risk.

View More Related Solutions