B C A 1 Student Name: 2 Student ID: 3. Name of the stock assigned: D E F G H 4. 5 Answer to Part I 5. Year End of year price of stock 7 2010 0.2813 Dividend per share of stock Value of ASX All Ordinaries Index Dividend yield of ASX All Ordinaries Index (% Risk Free rate (%) 0.02 4846.9 Inflation (%) Nominal return_stock Nominal return_ 3.68 5.03 2.8 3 2011 0.1875 0.02 4111 5.05 4.51 3.0 9 2012 0.1829 0.02 4664.6 4.28 3.11 2.2 9 20 07234567800 2013 0.1172 0 5353.1 3.95 2.61 2.7 1 2014 0.15 0 5388.6 4.19 2.75 1.7 2015 0.185 0 5344.6 4.62 2.34 1.7 2016 0.37 0 5719.1 4.04 1.78 1.5 2017 0.375 0 6167.3 3.98 1.77 1.9 2018 0.26 0 5709.4 4.47 2.02 1.8 2019 0.395 0 6802.4 3.99 0.90 1.8 2020 0.365 0.01 6850.6 2.81 0.02 0.9 802777508800 -0.262353 -0.108 0.082133 0.1832 -0.359213 0.1929 0.279863 0.0488 0.233333 0.0376 1.000000 0.1133 0.013514 0.1212 -0.306667 -0.032 0.519231 0.2389 -0.050633 0.0353 Average ? ? Standard deviation ? ? D K L N -234567810123456786222 Inflation (%) Nominal return_stock Nominal return_market Nominal return_risk free asset Rate of inflation Exact real return_stock Exact real return_market Exact real return_risk-free asset 5.03 2.8 4.51 3.0 -0.262353 -0.108996 -0.102985 0.071429 9 3.11 2.2 0.082133 0.183227 -0.309484 -0.266667 ? ? ? ? ? ? 2.61 2.7 -0.359213 0.192931 -0.163052 0.227273 ? ? ? 2.75 1.7 0.279863 0.048810 0.055662 -0.370370 ? ? 2.34 1.7 0.233333 0.037657 -0.150000 0.000000 ? ? ? ? 1.78 1.5 1.000000 0.113302 -0.238503 -0.117647 ? ? ? 1.77 1.9 0.013514 0.121288 -0.005618 0.266667 ? ? ? 2.02 1.8 -0.306667 -0.032865 0.141243 -0.052632 ? ? ? 0.90 1.8 0.519231 0.238977 -0.554455 0.000000 ? ? ? 0.02 0.9 -0.050633 0.035385 -0.977778 -0.500000 ? ? ? ? ? ? ? ? ? ? 19 ? ? ? ? ? ? ? G H