Question: Using historical data, create a portfolio, and solve for the portfolios average annual return. (Suggestion: pick 4 10 different companies to comprise the portfolio). and

Using historical data, create a portfolio, and solve for the portfolios

average annual return. (Suggestion: pick 4 10 different

companies to comprise the portfolio). and measure the risk (or standard deviation) of the portfolio.

Companies chosen:

- Amazon

-Google

-Pfizer

-Moderna

I already found the beta for them

Company

Beta

Amazon

1.14

Google

1.00

Pfizer

0.67

Moderna

1.49

Please help with making the portfolio and average annual return!!

Thank you so much, I truly appreciate it

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

a) What is an Investment portfolio ? b) Using historical data: create a portfolio, and solve for the portfolio's average, annual return. [Suggestion: Pick 4 - 10 different companies to comprise the...

Q:

a) What is an investment portfolio ? b) Using historical data, create a portfolio, and solve for the portfolios average annual return. (Suggestion: pick 4 10 different companies to comprise the...

Q:

7. Using historical data to measure portfolio risk and Peter Is an investor who believes that past variability of stocks is a reasonably good estimate of future risk associated with the stocks. Peter...

Q:

1. Using historical data to measure portfolio risk and correlation coefficient Michael is an investor who believes that past variability of stocks is a reasonably good estimate of future risk...

Q:

1. Using historical data to measure portfolio risk and correlation coefficient Pam is an investor who believes that past variability of stocks is a reasonably good estimate of future risk associated...

Q:

7. Using historical data to measure portfolio risk and correlation coefficient Peter is an investor who believes that past variability of stocks is a reasonably good estimate of future risk...

Q:

please show work and steps. I really appreciate it. 2. Stock prices and intrinsic values A Aa Benjamin Graham, the father of value investing, once said, "In the short run, the market is a voting...

Q:

First part is correct. I just need help figuring out the rest. Using historical data to measure portfolio risk and correlation coefficient. 7. Using historical data to measure portfolio risk and...

Q:

Attention:Due to a bug in Google Chrome, this page may not function correctly. Click hare to lsarn mare 7. Using historical data to measure portfolio risk and correlation coefficient Aa Aa Michael is...

Q:

Please Solve Using Excel Problem 3: The following table contains annual retums for the stocks of Home Depot (HD) and Lowe's (LOW) The returns are calculated using end-of-year prices (adjusted for...

Q:

In the same applecomputer trade example given in Section 19.5, suppose that because of technology transfer, the South becomes just as productive as the North at producing apples: one unit of southern...

Q:

What bank accounts do you intend to open for your business? What bank will you use? Why?

Q:

Expected Returns and Standard Deviations Based on the following information, calculate the expected return and standard deviation for stock A . State of EconomyProbability of the stateRate of return...

Q:

Add "Viggo Mortenslet cast = new Map ( ) ;en " to the cast as the key, with value "Aragorn".