1. Calculate the annual nominal return (2010-2020) for the stock in column H (in decimals).

2. Calculate the annual nominal return (2010-2020) for the market in column I (in decimals).

3. Present the annual nominal return (2010-2020) for the risk-free asset in column J (in decimals).

4. Present the annual rate of inflation (2010-2020) in Column K (in decimals).

5. Calculate the exact annual real return (2010-2020) for the stock in column L (in decimals).

6. Calculate the exact annual real return (2010-2020) for the market in column M (in decimals).

7. Calculate the exact annual real return (2010-2020) for the risk-free asset in column N (in decimals).

B6 X fx End of year price of stock B D E F G H 1 j K X Wrong + LDN 000 Risk Free rate (%) 5.03 Inflation (%) 2.8 4.51 3.0 3.11 2.2 2.61 2.7 2.75 1.7 Answer to Part A (l) and Part A (W) Year End of year price of stock Dividend per share of stock Value of ASX All Ordinaries Index Dividend yield of ASX All Ordinaries Index (%) 7 2010 50.4964 3 4760.79 3.76 2011 48.9548 3.23 4052.27 4.93 9 2012 61.8449 3.32 4626.27 4.33 10 2013 77.3808 3.62 5304.8 3.99 11 2014 85.1885 4.14 5348.93 4.24 12 2015 85.53 4.2 5249.09 4.72 13 2016 82.41 5617.73 4.09 14 2017 80.34 4.29 6023.3 4.04 15 2018 72.39 4.31 5596.96 4.48 16 2019 79.9 2.98 6647.74 3.95 17 2020 82.11 2.98 6574.33 2.82 18 Average 73.32 3.66 5436.56 4.12 19 Standard deviation 12.81 0.55 754.02 0.53 2.34 1.7 Nominal return_stock Nominal return_market Nominal return_risk free asset Rate of inflation 0.033436047 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 4.2 1.78 1.5 1.9 1.77 2.02 1.8 0.90 1.8 0.02 0.9 2.0 2.44 1.38 0.6 B6 X fx End of year price of stock B D E F G H 1 j K X Wrong + LDN 000 Risk Free rate (%) 5.03 Inflation (%) 2.8 4.51 3.0 3.11 2.2 2.61 2.7 2.75 1.7 Answer to Part A (l) and Part A (W) Year End of year price of stock Dividend per share of stock Value of ASX All Ordinaries Index Dividend yield of ASX All Ordinaries Index (%) 7 2010 50.4964 3 4760.79 3.76 2011 48.9548 3.23 4052.27 4.93 9 2012 61.8449 3.32 4626.27 4.33 10 2013 77.3808 3.62 5304.8 3.99 11 2014 85.1885 4.14 5348.93 4.24 12 2015 85.53 4.2 5249.09 4.72 13 2016 82.41 5617.73 4.09 14 2017 80.34 4.29 6023.3 4.04 15 2018 72.39 4.31 5596.96 4.48 16 2019 79.9 2.98 6647.74 3.95 17 2020 82.11 2.98 6574.33 2.82 18 Average 73.32 3.66 5436.56 4.12 19 Standard deviation 12.81 0.55 754.02 0.53 2.34 1.7 Nominal return_stock Nominal return_market Nominal return_risk free asset Rate of inflation 0.033436047 ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? 4.2 1.78 1.5 1.9 1.77 2.02 1.8 0.90 1.8 0.02 0.9 2.0 2.44 1.38 0.6