Question: What are the expected return and risk for the index and each company based on historical information I have provided in the picture? Date Open

What are the expected return and risk for the index and

What are the expected return and risk for the index and each company based on historical information I have provided in the picture?

Date Open High Low Close Adj Close Volume 20/03/19 9435.7002 9435.7002 9435.7002 9435.7002 9435.7002 0 21/03/19 9452.07031 9461.51953 9413.00977 9461.30957 9461.30957 20942900 22/03/19 9461.30957 9550.99023 9461.30957 9550.99023 9550.99023 22427200 25/03/19 9550.99023 9550.99023 9461.26953 9519.30957 9519.30957 20120700 26/03/19 9519.30957 9574.82031 9511.05957 9574.82031 9574.82031 46093900 27/03/19 9574.82031 9701.75 9574.82031 9698.88965 9698.88965 33957900 28/03/19 9710.7002 9772.30957 9702.08008 9766.19043 9766.19043 21284300 29/03/19 9766.19043 9844.9502 9750.91016 9844.9502 9844.9502 28443000 1/04/19 9844.9502 9878.54981 9804 9853.91016 9853.91016 27834200 2/04/19 9853.91016 9958.34961 9853.91016 9958.34961 9958.34961 27867700 3/04/19 9963.86035 9963.86035 9878.82031 9939.25977 9939.25977 35317900 4/04/19 9939.25977 9939.25977 9869.38965 9892.59961 9892.59961 30201600 5/04/19 9892.59961 9895.29981 9808.01953 9857.04981 9857.04981 26742800 8/04/19 9857.04981 9857.04981 9807.08008 9807.08008 9807.08008 25059100 9/04/19 9787.29981 9787.29981 9787.29981 9787.29981 9787.29981 0 10/04/19 9787.29981 9787.29981 9705.7002 9707.95996 9707.95996 30970600 11/04/19 9707.95996 9773.08008 9707.95996 9766.59961 9766.59961 27244500 12/04/19 9766.59961 9773.79004 9752.95996 9768.33008 9768.33008 20142300 15/04/19 9768.33008 9846.34961 9768.33008 9846.34961 9846.34961 21519700 16/04/19 9846.34961 9908.38965 9846.34961 9908.38965 9908.38965 23320700 17/04/19 9908.38965 9982.24023 9908.38965 9982.24023 9982.24023 22504200 18/04/19 9982.24023 9982.24023 9932.86035 9959.62012 9959.62012 17735100 23/04/19 9959.62012 10036 9959.62012 10004.8398 10004.8398 14841400 24/04/19 10004.8398 10083.8096 10004.8398 10071.7402 10071.7402 20201600 26/04/19 10071.7402 10071.7402 9994.57031 9994.57031 9994.57031 25953700 29/04/19 9994.57031 10056.7998 9994.57031 10012.7695 10012.7695 20800800 30/04/19 10012.7695 10047.8203 10009.9502 10013.8301 10013.8301 34404900 1/05/19 10013.8301 10013.8301 9938.50977 9966.41992 9966.41992 16886900 2/05/19 10085.75 10085.75 10085.75 10085.75 10085.75 0 3/05/19 10085.75 10087.9102 10020.5703 10058.0801 10058.0801 48342100 6/05/19 10058.0801 10058.0801 9948.24023 9960.62012 9960.62012 22129000 7/05/19 9960.62012 10035.2998 9960.62012 10027.3896 10027.3896 25461000 8/05/19 10027.3896 10063.9102 9950.67969 10063.0498 10063.0498 30228900 9/05/19 10063.0498 10114.5303 10060.6699 10104.3496 10104.3496 39080200 Date Open High Low Close Adj Close Volume 20/03/19 9435.7002 9435.7002 9435.7002 9435.7002 9435.7002 0 21/03/19 9452.07031 9461.51953 9413.00977 9461.30957 9461.30957 20942900 22/03/19 9461.30957 9550.99023 9461.30957 9550.99023 9550.99023 22427200 25/03/19 9550.99023 9550.99023 9461.26953 9519.30957 9519.30957 20120700 26/03/19 9519.30957 9574.82031 9511.05957 9574.82031 9574.82031 46093900 27/03/19 9574.82031 9701.75 9574.82031 9698.88965 9698.88965 33957900 28/03/19 9710.7002 9772.30957 9702.08008 9766.19043 9766.19043 21284300 29/03/19 9766.19043 9844.9502 9750.91016 9844.9502 9844.9502 28443000 1/04/19 9844.9502 9878.54981 9804 9853.91016 9853.91016 27834200 2/04/19 9853.91016 9958.34961 9853.91016 9958.34961 9958.34961 27867700 3/04/19 9963.86035 9963.86035 9878.82031 9939.25977 9939.25977 35317900 4/04/19 9939.25977 9939.25977 9869.38965 9892.59961 9892.59961 30201600 5/04/19 9892.59961 9895.29981 9808.01953 9857.04981 9857.04981 26742800 8/04/19 9857.04981 9857.04981 9807.08008 9807.08008 9807.08008 25059100 9/04/19 9787.29981 9787.29981 9787.29981 9787.29981 9787.29981 0 10/04/19 9787.29981 9787.29981 9705.7002 9707.95996 9707.95996 30970600 11/04/19 9707.95996 9773.08008 9707.95996 9766.59961 9766.59961 27244500 12/04/19 9766.59961 9773.79004 9752.95996 9768.33008 9768.33008 20142300 15/04/19 9768.33008 9846.34961 9768.33008 9846.34961 9846.34961 21519700 16/04/19 9846.34961 9908.38965 9846.34961 9908.38965 9908.38965 23320700 17/04/19 9908.38965 9982.24023 9908.38965 9982.24023 9982.24023 22504200 18/04/19 9982.24023 9982.24023 9932.86035 9959.62012 9959.62012 17735100 23/04/19 9959.62012 10036 9959.62012 10004.8398 10004.8398 14841400 24/04/19 10004.8398 10083.8096 10004.8398 10071.7402 10071.7402 20201600 26/04/19 10071.7402 10071.7402 9994.57031 9994.57031 9994.57031 25953700 29/04/19 9994.57031 10056.7998 9994.57031 10012.7695 10012.7695 20800800 30/04/19 10012.7695 10047.8203 10009.9502 10013.8301 10013.8301 34404900 1/05/19 10013.8301 10013.8301 9938.50977 9966.41992 9966.41992 16886900 2/05/19 10085.75 10085.75 10085.75 10085.75 10085.75 0 3/05/19 10085.75 10087.9102 10020.5703 10058.0801 10058.0801 48342100 6/05/19 10058.0801 10058.0801 9948.24023 9960.62012 9960.62012 22129000 7/05/19 9960.62012 10035.2998 9960.62012 10027.3896 10027.3896 25461000 8/05/19 10027.3896 10063.9102 9950.67969 10063.0498 10063.0498 30228900 9/05/19 10063.0498 10114.5303 10060.6699 10104.3496 10104.3496 39080200

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!

1. Verizon ATT: 2. Verizon: ATT: Problem 1 On Monday January 17, 2017 an investor wanted to invest $1,000,000 in two stocks Verizon (VZ) and ATT (T). Using historical adjusted weekly closes from...

PEF MRNA ICS 31 Summer Session 10-WK 2021 Assignment-4 You will write a program to model a series of stock market transactions over time. Your program will allow a user to examine stock prices and...

Question 7c: The below data is based on the ASX200 index and listed firm Cochlear (COH). Price Data Time Series Sourced from Yahoo Finance Historical Price Data ASX200 Index (^AXJO) Cochlear (COH.AX)...

what would have been some differences in return and risks charactersistics of your portfolio, if you had weighted the amount invested in the stocks differently ( in terms of optimum risk and return)...

///////////////////// //////////////////////////// i want to know the calculations and formulas Instructions 1. Please use the excel FINANCE 251 A1S12021Data.xls file to do the calculations. 2. This...

Using book debt-to-assets ratios only, estimate Rio Tintos levered equity beta based on the similar firm BHPs levered equity beta of 0.98 and BHP's book debt-to-assets ratio of 48 %. State any...

Find Rio Tintos 'unlevered beta' (asset beta) based on its book debt-to-assets ratio and equity beta found above. As with all questions, remember to state any important assumptions. Price Data Time...

Your client is obsessed with technology stocks and wants to invest only in Apple, Google (GOOGL) and Microsoft stock. Download weekly price data for those stocks from Yahoo Finance for 2012. For each...

Find Rio Tintos book debt-to-assets ratio based on balance sheet figures. Price Data Time Series Sourced from Yahoo Finance Historical Price Data ASX200 Index (^AXJO) Rio Tinto (RIO.AX) Date Open...

QUESTION 1 Instructions in detail: As a graduate student, you are employed as a finance intern at Berghaus and Associates. Harry Berghaus, one of the firm's founders has been talking to you about...

AirPro Corporation reports the following for this period. Actual total overhead Standard overhead applied Budgeted (flexible) variable overhead rate Budgeted fixed overhead Predicted activity level...

suppose jim purchased a $100,000 ordinary life policy at age 35 and named his wife, jane, beneficiary also assume that the ordinary life portion of table 81 on page 229 of the textbook is the...

Storgan Mankey is a large financial imditution. Storgan Manley increases its profitahility ly borrowing moncy lo imest. What is this process callod? securitiration delcwaraging leverage sebywime...

please explain how you got the answer Brief Exercise 6-1 Recording Sales Discounts On July 1, Pam's Pizza Supply sold 100 pounds of pepperoni for $800 on account to a local pizza parlor. The terms of...