Question

1 Approved Answer

Posted on Jun 23, 2024

Name RIC PE EP'S DP S Div. Vid (36) ROE(16) P/Book P/Sales BHP Group Led Market capitalization BHP AX 14.99 2.26 2.38 6.38 15.85 2.15

Name RIC PE EP'S DP S Div. Vid (36) ROE(16) P/Book P/Sales BHP Group Led Market capitalization BHP AX 14.99 2.26 2.38 6.38 15.85 2.15 2.78 176,509,290.187.85 Commonwealth Bank of Austral CBAAX 17.46 6.16 7.75 - 2.03 5.76 141,512,946,189.58 Rio Tinto Lid RIO.AX 7.35 11 17 5.71 6.51 30.86 1.90 2.04 122,034,660,629-37 CSL Lid CSLAX 39.69 5.15 2.48 1.13 47.74 16.79 8.65 100,950,224,436.96 Westpac Banking Corp WBC AX 12.37 2.30 2.69 9.52 154 4.46 99,148,876,440-93 National Australia Bank Lid NAB AX 13.39 2.07 2.60 152 4.19 80,003 443,417.50 Australia and New Zealand Banking Group Lie ANZA 11.61 2.34 2.29 847 1.30 3.60 Telstra Corporation Led 76,987.326.508 68 TLS.AX 13.11 030 0.1.4 24.37 3.19 1.80 46,740.660,570.15 Woolworths Group Led WOW AX 28.95 1.23 1.36 3.83 16.04 4.28 0.79 44,859,713,987 88 Wesfarmers Ltd WESAX 17.02 230 3.14 9.10 11.15 1.95 0.66 11 44,344,491,864.62 Macquarie Group Lid MOG AX 13.00 9.41 6.86 5.59 12 2.35 2.83 41,652,665,752 Transurban Group TCLAX 228.40 0.07 0.60 13 66 6 2.39 4.69 Woodside Petroleum Lid 40,530,769,926.75 WPLAX 15.23 2.10 2 86 14 8.61 8.38 1.21 4.03 31,098,954,457.78 Newcrest Mining Lid NCMLAX 96.65 0.35 0.36 15 0.94 2.72 2.60 5.47 Goodman Group 28,694,871,099.9 GMG AX 25.52 0.59 0.30 16 2.01 12.57 2.98 17.29 Amcor PLC 27,371,479,304.55 AMC AX 16.84 0.84 0.47 3.00 79.48 16.66 189 25,080,919,943.37 Fortescue Metals Group Lid FMGAX 16.81 0.38 0.44 6.10 9.04 18 1 50 Scentre Grou 2.14 21,460,385,478.46 SCG.AX 9.31 0.49 0.24 19 9.91 090 Brambles Lid 8.07 21,267,988,824.00 BXB.AX 21.93 0.55 0.35 20 2.66 22.90 5.06 Sydney Airport Holdings Pty Ltd 2.51 20,717 854,017 4 SYD AX 51.06 0.17 0.39 21 4.61 103 31 237 23 12.02 19,049,750.009.40 Aristocrat Leaure Lid ALLAX 34.70 0.85 0.70 2.38 35.26 10.85 5.30 18,805,125,217.50 Insurance Australia Group Led LAG AX 21.32 036 0.43 5.62 2.80 1.04 17,956,831,949.91 Suncorp Group Lid SUN AX 17.25 0.80 1.00 7.25 1.36 24 1.15 ASK Lid 17,867,414,393.28 ASK AX 37.82 2.30 3.19 25 3.68 1133 OBE Insurance Group Lid 427 16.62 16,840,843,142.38 DBE AX 19.24 0.59 0.60 26 Dexus 1.26 0.75 15,526,239,094.8 DXS.AX 1.70 0.52 3.92 18 32 1.46 17.49 14,697,892,711.00 Ramsay Health Care Lid RHC AX 37.78 1.86 2.09 3.02 16.76 6.01 1.54 South32 Ltd 14,167,916,577.72 532 AX 7.53 0.34 0.23 786 12.72 0.89 1.27 Santas Lid 14,115,520,081.50 STO.AX 15.28 0.43 0.19 2.83 8.73 131 2.61 Sonic Healthcare Lid 14,080,478,637-16 SHLAX 26.03 1.07 0.91 3.29 31 11.38 3.18 Mirvac Group 2.39 13,264,811,673.92 MGRAX 11.82 0.12 32 3.53 APA Group 11.02 1.30 5.87 12,824,655,943.66 APAAX 46.06 0.23 0.50 33 4.65 6.54 3.07 5.35 12,660,260,989.04 Origin Energy Lid DRG.AX 45.21 0-16 0.14 34 2.41 20 T AGL Energy Lid 0.86 AGLAX 1.38 12,627,883,379.07 13.80 1.60 35 8.30 10.81 1.48 0.94 Cochlear Lid 12,473,792,317.86 COHAX 49.08 4.38 4.50 36 2-14 43.67 8.91 12,145,140,213.03 Treasury Wine Estates Lic TWE AX 35.64 0.46 0.50 3.02 9.57 4.77 37 GPT Group 11,908,304,031.60 GPTAX 7.67 0.26 38 Auricon Holdings Lid 4-15 14.95 1.17 11,862,889,534.44 AZI AX 15.76 21.08 0.28 0.31 39 5.44 Stockland Corporation Lid 247 3.75 11,662,152,025.52 SGP AX 10.90 0.42 0.28 6.00 DT OT 1.06 3.95 Oil Search Lid 10,968,016,913.80 OSH AX 21.38 0.32 0.15 41 2.12 6.75 141 4.74 James Hardie Industries PLC 10,718,971,304.5 THX AX 29.12 0.73 0.51 2.36 60.79 6.83 2.65 42 9,800,710,601.44 Vicinity Centres VCK AX 8.06 031 0.16 6.31 10.22 620 7.12 43 9,505,014,629.04 Medibank Private Lid MPLAX 21.16 0.16 0.18 44 5 36 $ 15 134 9,418,691,090.80 Qantas Airways Lid DAN AX 10.30 0.56 0.31 5.48 26.07 2.27 0.53 9,030,409,149.25 Computershare Lid CPU.AX 21 80 0.63 0.54 65 E 20.23 4.24 2.42 9,171,485,813.40 LendLease Group LLC AX 10.31 1.36 047 3.34 12.71 1.23 0.48 7,914,758,940.16 Caltex Australia Lid CTX AX 12.43 2.15 1.69 17.32 1.97 031 AMP Led 6,664,678,415.43 AMP AX 193.55 0.01 0.18 9.16 - 0.66 480,477,087 88 1.463.93 73.49 64.09 237.20 786.27 404.83 221.20 1,553,178,638,896.51 QUESTION 1 Using the sample data attached, using Excel, calculate the sample descriptive statistics for the following variables: Price-to-Earnings ratio (1.5 marks) ii. Dividends Per Share III. Dividend Yield (1.5 marks) (1.5 marks) iv. Price-to-Sales ratio (1.5 marks) Note: the answers are accepted in the form of tables - outputs from the Excel analysis