Use the Linear trendline in this problem. Beta is the measure of an asset’s risk in relation to

Use the Linear trendline in this problem. Beta is the measure of an asset's risk in relation to the market (for example, the S&P500) or to an alternative benchmark or factors. Roughly speaking, a security with a beta of 1.5, will have move, on average, 1.5 times the market return. According to asset pricing theory, beta represents the type of risk, systematic risk, that cannot be diversified away The file linear.xlsx contains the monthly returns on S&P index as well as the monthly return on Cinergy, Dell, Intel, Microsoft, Nortel and Pfizer. Estimate the beta of each stock by finding the slope with reference to S&P Index. R2 Beta Cinergy Dell Intel Microsoft Nortel Pfizer Which stock has the highest risk? Which stock has the highest forecast credibility?

 

Do you need a similar assignment done for you from scratch? We have qualified writers to help you. We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount!
Use Discount Code "Newclient" for a 15% Discount!

NB: We do not resell papers. Upon ordering, we do an original paper exclusively for you.