Question: Please explain clearly in excel sheet. thank you so much!! The Procter & Gamble Company (PG): NYSE Date Open High Low Close Adj Close Volume

Please explain clearly in excel sheet. thank you so much!! The

Please explain clearly in excel sheet. thank you so much!!

The Procter & Gamble Company (PG): NYSE Date Open High Low Close Adj Close Volume 1/27/20 124.75 126.39 124.75 125.69 125.69 1/28/20 125.93 126.98 125.72 126.03 126.03 1/29/20! 125.91 126.07 125.03 125.06 125.06 1/30/20 124.79 126.06 124.42 125.95 125.95 1/31/20 125.99 126.95 124.46 124.62 124.62 2/3/20 124.66 125.95 124.49 125.11 125.11 2/4/20 125.71 127.35 125.36 125.66 125.66 9338400.00 6200200.00 5271000.00 5894400.00 6612900.00 6052300.00 6511700.00 pen Apple Inc. (AAPL): NASDAQ Date Open High Low Close Adj Close Volume 1/27/20 310.06 311.77 304.88 308.95 308.95 40485000.00 1/28/20 312.60 318.40 312.19 317.69 317.69 40558500.00 1/29/20 324.45 327.85 321.38 324.34 324.34 54057300.00 1/30/20 320.54 324.09 318.75 323.87 323.87 31685800.00 1/31/20 320.93 322.68 308.29 309.51 309.51 49897100.00 2/3/20 304.30 313.49 302.22 308.66 308.66 43496400.00 2/4/20 315.31 319.64 313.63 318.85 318.85 34069200.00 a) Calculate the historical return b) Calculate their covariance c) Plot the 2 stocks on a standard deviation - expected (mean ) return plain d) Plot the mean & standard deviation of portfolio constructed using those two stocks The Procter & Gamble Company (PG): NYSE Date Open High Low Close Adj Close Volume 1/27/20 124.75 126.39 124.75 125.69 125.69 1/28/20 125.93 126.98 125.72 126.03 126.03 1/29/20! 125.91 126.07 125.03 125.06 125.06 1/30/20 124.79 126.06 124.42 125.95 125.95 1/31/20 125.99 126.95 124.46 124.62 124.62 2/3/20 124.66 125.95 124.49 125.11 125.11 2/4/20 125.71 127.35 125.36 125.66 125.66 9338400.00 6200200.00 5271000.00 5894400.00 6612900.00 6052300.00 6511700.00 pen Apple Inc. (AAPL): NASDAQ Date Open High Low Close Adj Close Volume 1/27/20 310.06 311.77 304.88 308.95 308.95 40485000.00 1/28/20 312.60 318.40 312.19 317.69 317.69 40558500.00 1/29/20 324.45 327.85 321.38 324.34 324.34 54057300.00 1/30/20 320.54 324.09 318.75 323.87 323.87 31685800.00 1/31/20 320.93 322.68 308.29 309.51 309.51 49897100.00 2/3/20 304.30 313.49 302.22 308.66 308.66 43496400.00 2/4/20 315.31 319.64 313.63 318.85 318.85 34069200.00 a) Calculate the historical return b) Calculate their covariance c) Plot the 2 stocks on a standard deviation - expected (mean ) return plain d) Plot the mean & standard deviation of portfolio constructed using those two stocks

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!

Hi Ruchi, I need help with the attached assignment. It's due in about a week. Thanks 1) The paper should be written in APA style Research Paper format. This is the link that explains the research...

I have 3 pictures attached. 1 is the instructions and the other is a picture of an the data I have chosen. Complete the workbook using the instructions to the data. The 3rd picture will be an example...

Please provide a page and a half paper to answer the following question: Major factors company should be aware of/evaluate regarding future investments projects. Use the attachments to answer the...

9 pages..3c48.. Due: 17/4 Give me 4 different attachments because of 4 differents works. WEEK 4.. 1 page work Weekly Writing Assignment Grading Criteria(23).doc This week, we discussed howracial...

Please explain clearly using Excel sheet Question 3 (based on Week 6 Excel Examples - Chapter 11) A new machine will cost $200,000. Its maximum useful life is 8 years. The expected market value (MV)...

NO EXCEL!!! PLEASE SHOW HOW TO GET ANSWERS! ANSWERS ARE KNOWN, PLEASE EXPLAIN CLEARLY WITHOUT EXCEL HOW TO SOLVE FOR ANSWERS! THANK YOU! Coronado Company is a multiproduct firm. Presented below is...

Please refer to the Excel data file "Equipment Sales from 1993 to 2005", which includes the sales record from 1993 to 2005 of a large semiconductor company in US. (a)When consider "time series data"...

What are the issues in this case? 2. What are the differences between nonprofit institutions and for-profit institutions? What are the nonfinancial drivers for adding an LTAC facility to the U.Va....

a. When considering time series data only, please compare at least 4 different time-series forecasting methods and select the best time-series forecasting model with clear explanation of why it is...

MGMT 222 (002) MANAGEMENT PRINCIPLES Winter 2022: Professor Jai Goolsarran Test No. 2 (25%) Student name and number: 1. Refer to the definition of strategy given in Chapter 8 of your textbook. Then,...

Explain why each of these statements is not an effective way to convey the negative message. a) I am sorry I must refuse your request. b) Therefore, following company policy seems to be the best...

Smiley Site, Inc., ended 2012 with 10 million shares of $1 par common stock issued and outstanding. Beginning additional paid-in capital was $9 million, and retained earnings totaled $44 million. In...

Tesla, Inc. has rapidly become a stand-out among American car companies. Illustration Capsule 6.4 describes how Tesla has made vertical integration a central part of its strategy. What value chain...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited ( Canadian Tire ) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

Was there an effort to involve the appropriate people?

18. If you have power, then people will dislike and fear you.

15. On very controversial issues, it often is best to delay or avoid your involvement as long as possible.