Excel project

i) estimate the following statistics for individual stocks and a portfolio: several risk measures (variance, standard deviation, and covariance) and average return

 ii) construct a portfolio & draw an investment opportunity set 

iii) run a regression to estimate a security characteristic line (SCL) & estimate expected return based on CAPM