Share
Explore BrainMass

Stock Analysis- Calculation of Beta in EXCEL

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

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 Summary

Stock Analysis- Calculation of Beta in EXCEL

$2.19