Business Finance Homework Help

The University of Alabama Calculate Monthly Beta for Apple Worksheet

 

I’m stuck on a Business question and need an explanation.

Case Study:

Hand in an excel sheet for the following:

Calculate monthly beta for Apple.

Use monthly return for Apple between June 1 2015 to June 1 2020. USE S&P return as market return.

For data look at yahoo finance web site.

Watch this video for help but don’t copy it blindly. You need to understand it and apply it to your case.