Your Perfect Assignment is Just a Click Away
We Write Custom Academic Papers

100% Original, Plagiarism Free, Customized to your instructions!

glass
pen
clip
papers
heaphones

Finance Assignment: Standard Deviations

Finance Assignment: Standard Deviations

1) Download daily prices for three stocks: TSLA, AMZN, NVDA (Jan 1, 2021 – Jun 30, 2021) from      Bloomberg.
     2) Compute daily stock returns for three stocks.
     3) Calculate the respective averages standard deviations for daily stock returns. 
     4) Generate a covariance matrix with three daily stock returns using Data Analysis Toolpak  
     5) Compute an equal-weighted (33.3%: TSLA, 33.3%: AMZN, 33.3%: NVDA) portfolio return and risk (Hint: Use MMULT function in Excel)

Order Solution Now