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:
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
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.

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.