Answered step by step
Verified Expert Solution
Question
1 Approved Answer
not sure how to calculate returns on excel price column to your assigned company name. 4. Merge the company and SPY data. Keep the columns
not sure how to calculate returns on excel
price column to your assigned company name. 4. Merge the company and SPY data. Keep the columns for date, company close and SPY close and delete the rest. 5. Calculate returns [(P1PO)/PO]100 for your company and SPY. Select the date, company return and SPY return and insert a chart XY scatter with smooth lines and markers. 6. Calculate the mean and the standard deviation of your company returns and SPY returns using the excel functions AVERAGE and STDEV. 7. Calculate beta for your company. Use the Excel Slopeh function (company returns are Y s, SPY returns are X s). Compare the results to the posted beta for your company in Yahoo finance Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started