FINANCE-Complete this exercise in Excel using the company
Complete this exercise in
Excel using the company: RANDSTAD
Download 5 years of monthly
price data for your company. Convert your price series into a return
series by calculating:
returnt: = (Pt – Pt-1)/Pt-1
Or, download 5 years of
return data (then you donât have to calculate return). Calculate the mean and
standard deviation for your stock using the data you have collected. You can
use the functions of Excel to do this. Download 5 years of monthly price data
for the S&P 500 index. Convert this to returns in the same way. Calculate
mean (AVG) and standard deviation (STDEV), using excel.
has higher volatility â your stock or the S&P index?
Write a couple of sentences
speculating about why this might be.
We pride ourselves in writing quality essays CLICK HERE TO CONTACT US