The following data was obtained from a publicly listed company:

YearPrice/share (Kes)Dividend/share (Kes)

2016 18.55 2.9

2017 19.01 3.0

2018 22.00 3.5

2019 21.15 3.6

Required:

a) Enter the above data in an Excel Spread sheet (3 marks)

b) Using the system, determine the share's rate of return for each year (5 Marks)

c)Using the system, determine the share's average rate of return (1 Mark)