Choose a publicly traded company that has been listed on the Egyptian Exchange (EGX) for at least five years. Use any data source of your choice to find the annual dividend paid by the company in each of the past five years. Also, find the closing price of the stock at the end of each of the preceding five years.

Calculate the return for each of the five one-year periods (5 marks).

Create a graph that shows the return that the investment earned on the y-axis and the year in which the return was earned on the x-axis (5 marks).

On the basis of the graph in part b, estimate the return for the coming year, and explain your answer (5 marks).