calculate using following data
-
Calculate the exact annual real return (2010-2020) for the stock
-
Calculate the exact annual real return (2010-2020) for the market
-
Calculate the exact annual real return of risk free asset
Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 End of year price of stock 0.375 0.375 0.41 0.73 0.62 0.2 0.2 0.21 0.53 5.1 5.78 Dividend per share of stock 0.02 0.02 0.01 0.03 0.03 0.01 0.01 0.01 0 0.02 0.02 Value of ASX All Ordinaries Index 4846.9 4111 4664.6 5353.1 5388.6 5344.6 5719.1 6167.3 5709.4 6802.4 6850.6 Dividend yield of ASX All Ordinaries Index (%) 3.68 5.05 4.28 3.95 4.19 4.62 4.04 3.98 4.47 3.99 2.81 Risk Free rate (%) 5.03 4.51 3.11 2.61 2.75 2.34 1.78 1.77 2.02 0.9 0.02 Inflation (%) 2.8 3 2.2 2.7 1.7 1.7 1.5 1.9 1.8 1.8 0.9 Nominal return_stock (%) Nominal return_market(%) Nominal return_risk free asset(%) Rate of inflation(%)_ 5.333333333 12 85.36585366 -10.95890411 -66.12903226 5 10 152.3809524 866.0377358 13.7254902 -10.89963688 18.32266796 19.29313232 4.88095384 3.765737297 11.33015829 12.12880593 -3.286524411 23.89770834 3.538484358 -10.33797217 -31.0421286 -16.07717042 5.363984674 - 14.90909091 -23.93162393 -0.561797753 14.12429379 -55.44554455 -97.77777778 7.14 -26.67 22.73 -37.04 0 -11.76 26.67 -5.26 0 -50 Year 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 End of year price of stock 0.375 0.375 0.41 0.73 0.62 0.2 0.2 0.21 0.53 5.1 5.78 Dividend per share of stock 0.02 0.02 0.01 0.03 0.03 0.01 0.01 0.01 0 0.02 0.02 Value of ASX All Ordinaries Index 4846.9 4111 4664.6 5353.1 5388.6 5344.6 5719.1 6167.3 5709.4 6802.4 6850.6 Dividend yield of ASX All Ordinaries Index (%) 3.68 5.05 4.28 3.95 4.19 4.62 4.04 3.98 4.47 3.99 2.81 Risk Free rate (%) 5.03 4.51 3.11 2.61 2.75 2.34 1.78 1.77 2.02 0.9 0.02 Inflation (%) 2.8 3 2.2 2.7 1.7 1.7 1.5 1.9 1.8 1.8 0.9 Nominal return_stock (%) Nominal return_market(%) Nominal return_risk free asset(%) Rate of inflation(%)_ 5.333333333 12 85.36585366 -10.95890411 -66.12903226 5 10 152.3809524 866.0377358 13.7254902 -10.89963688 18.32266796 19.29313232 4.88095384 3.765737297 11.33015829 12.12880593 -3.286524411 23.89770834 3.538484358 -10.33797217 -31.0421286 -16.07717042 5.363984674 - 14.90909091 -23.93162393 -0.561797753 14.12429379 -55.44554455 -97.77777778 7.14 -26.67 22.73 -37.04 0 -11.76 26.67 -5.26 0 -50