Simone is interested in three ASX listed healthcare companies, Cochlear Ltd (COH AX),Ramsay HealthCare Ltd (RHC AX) andAnsellLtd (ANN AX Her stock broker collected their year end adjusted closing prices between 2003 and 2018 and Simone asks you to conduct some preliminary analysis a Use EXCEL to calculate the expected return and standard deviation (risk) for these three common shares b Rank them in terms of their risk return profile, where 1 represents the best and 3 represents the worst, and present a summary table in WORD file Hint if additional indicator is needed for comparison, please demonstrate it to support your conclusion Year COH AX RHC AX ANN AX 2018 173 57 57 73 22 04 2017 171 23 70 12 24 30 2016 122 55 68 30 24 71 2015 95 58 67 94 21 43 2014 77 70 57 10 22 52 2013 58 92 43 26 20 67 2012 79 10 27 28 15 33 2011 62 00 19 28 14 54 2010 80 41 17 80 12 68 2009 69 07 10 89 10 93 2008 55 40 10 40 12 53 2007 74 90 10 95 12 07 2006 57 86 11 46 11 26 2005 45 73 9 50 11 05 2004 25 25 7 12 8 93 2003 21 46 4 77 6 45 RHC AX ANN AX Rank Expected Return E(R) Standard Deviation (o) c Use EXCEL to produce a correlation coefficient (p) matrix and present it in WORD file RHC AX ANN AX RHC AX ANN AX d Which two shares have the highest p Use their business background to explain these p readings e Consider three portfolios with weights allocated to each stock as shown in the table below Portfolio ANN AX RHC AX 65 35 0 0 70 II 30 40 60 0 II Which portfolio is expected to demonstrate WORST risk return profile Why Hint calculation is not necessary f Use EXCEL to compute risk and return of portfolio I, II III Rank these investments with the same criteria and present it in WORD file RHC AX ANN AX II II Rank Expected Return E(R) Standard Deviation (o)

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Sep 06, 2024

Simone is interested in three ASX -listed healthcare companies, Cochlear Ltd. (COH.AX),Ramsay HealthCare Ltd.(RHC.AX) andAnsellLtd.(ANN.AX. Her stock broker collected their year-end adjusted closing prices between

Simone is interested in three ASX -listed healthcare companies, Cochlear Ltd. (COH.AX),Ramsay HealthCare Ltd.(RHC.AX) andAnsellLtd.(ANN.AX. Her stock broker collected their year-end adjusted closing prices between 2003 and 2018 and Simone asks you to conduct some preliminary analysis.

a. Use EXCEL to calculate the expected return and standard deviation (risk) for these three common shares.

b. Rank them in terms of their risk-return profile, where 1 represents the best and 3 represents the worst, and present a summary table in WORD file. Hint: if additional indicator is needed for comparison, please demonstrate it to support your conclusion image text in transcribed

Year	COH.AX	RHC.AX	ANN.AX
2018	173.57	57.73	22.04
2017	171.23	70.12	24.30
2016	122.55	68.30	24.71
2015	95.58	67.94	21.43
2014	77.70	57.10	22.52
2013	58.92	43.26	20.67
2012	79.10	27.28	15.33
2011	62.00	19.28	14.54
2010	80.41	17.80	12.68
2009	69.07	10.89	10.93
2008	55.40	10.40	12.53
2007	74.90	10.95	12.07
2006	57.86	11.46	11.26
2005	45.73	9.50	11.05
2004	25.25	7.12	8.93
2003	21.46	4.77	6.45

. RHC.AX ANN.AX Rank Expected Return E(R) Standard Deviation (o) c. Use EXCEL to produce a correlation coefficient (p) matrix and present it in WORD file. . RHC.AX ANN.AX . RHC.AX ANN.AX d. Which two shares have the highest p? Use their business background to explain these p readings. e. Consider three portfolios with weights allocated to each stock as shown in the table below. Portfolio ANN.AX . RHC.AX 65% 35% 0% 0% 70% II 30% 40% 60% 0% II Which portfolio is expected to demonstrate WORST risk-return profile? Why? Hint: calculation is not necessary. f. Use EXCEL to compute risk and return of portfolio I, II & III. Rank these investments with the same criteria and present it in WORD file. . RHC.AX ANN.AX II II Rank Expected Return E(R) Standard Deviation (o)