omplete excel assignments by 7/6/2022, 11:59 pm. 1) Download daily prices for three stocks: TSLA, AMZN, NVDA (Jan 1, 202

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

omplete excel assignments by 7/6/2022, 11:59 pm. 1) Download daily prices for three stocks: TSLA, AMZN, NVDA (Jan 1, 202

Post by answerhappygod »

omplete excel assignments by 7/6/2022, 11:59pm.
1) Download daily prices for threestocks: TSLA, AMZN, NVDA (Jan 1, 2021 - May 31, 2022) fromyahoo!finance.
2) Compute daily stockreturns for three stocks.
3) Calculate the respective averages &standard deviations for daily stock returns.
4) Generate a covariance matrix with threedaily stock returns using DataAnalysis 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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”