3/0 (Calculating the geometric and arithmetic average rate of return) The common stock of the Brangus Cattle Company had the following end-of-year stock prices over the last five years and paid no cash dividende Brangus cattle Comapny $14 10 22 26 (Click on the icon in order to copy its contents into a spreadsheet) a Calculate the annual rate of return for each year from the above Information b. What is the arithmetic average rate of retum earned by investing in Brangus Cattle Company's stock over this period? Time 1 2. 3 4 5 05 Hue a. The annual rate of return at the end of your 2 18 % (Round to two decimal places) preadsheet) a. Calculate the annual rate of return for each year from the above information b. What is the arithmetic average rate of retum eamed by investing in Brangus Cattle Company's stock over this period? c. What is the geometric average rate of retum eamed by investing in Brangus Cattle Company's stock over this period? d. Which type of average rate of return best describes the average annual rate of return earned over the period (the arithmetic or geometric)? Why