The seven companies that I am using are Apple, Amazon, Ebay, Nike, Walmart, Colgate-palmolive, Disney If possible, can this be done in excel?
Step 1: Please calculate the return on stock 1 to stock 7 from January 31 to May1, 2017.
The beginning date: January 31 closing price. The ending date May1st, 2017, closing price.
Step 2: Compare the actual return and the financial ratio analysis (part 1) to see if your analysis from part 1 is consistent with the actual return.
Step 3: Collect beta coefficient for each firm and explain the systematic risk for each firm.