Explore BrainMass

Explore BrainMass

    Calculating beta from raw data using regression

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    The CFO has requested from you, a risk assessment of Strident Marks. Think about the risks inherent in Strident Marks and how to quantify these risks. Download the data provided and 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. Discuss when this type of calculation is appropriate, and when the coefficient of variation is an appropriate measure of risk.

    Attached is the raw data. I will write the paper. I need the calculation done, and an explanation of the type of calculation and why it is a measure of risk. No need to be too lengthy on the explanation. I will do the research later.
    Thanks in advance

    © BrainMass Inc. brainmass.com December 15, 2022, 4:51 pm ad1c9bdddf


    Solution Preview

    See the attached file. Thanks

    The beta is calculated by running regression between access return on ABC (dependent variable) and access return on market(independent variable)
    In a well diversified portfolio the only risk which is relevant is the risk related to the market. The company ...

    Solution Summary

    The solution calculates the beta from raw data using regression and provides easy to understand interpretation of the regression. It provides steps how we can make use of Excel software to run regression to caculate the beta for a stock.