Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

SK Compute the portfolio returns and risk measures of a portfolio you create. You can pick any two companies to download stock data for (daily

image text in transcribed

SK Compute the portfolio returns and risk measures of a portfolio you create. You can pick any two companies to download stock data for (daily or monthly). For the data you will need to attain about 50 observations (prices and returns for each stock). Task 1: Compute the respective average, standard deviation, and covariance of monthly or daily stock returns. Covariance table will be in the form: Var(stock1, stocki) Cov(stock1, stock2) Cov(stock1, stock2) Var(stock2, stock2) Note: Use STDEV.P in Excel for the standard deviation Task 2: Using the obtained statistics from Q1, calculate an equal weighted portfolio return and portfolio variance for the first portfolio using the below equations: Equal weighted portfolio return: E(Rp) = wi(avg(ra)) + wz(avg(r2)); where w is the weight of each stock in the portfolio. And avg(ra) is the mean return for stock 1 and avg(ra) is the mean return for stock 2. Portfolio variance: op=W ( 051) + W2 0252) + 2+W, W2. Osl Os2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Choose Wisely

Authors: Eliot Dylan Marr

1st Edition

1498416365, 978-1498416368

More Books

Students also viewed these Finance questions