(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 dividends:

NEED PART C AND D

(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 dividends: (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 return earned by investing in Brangus Cattle Company's stock over this period? c. What is the geometric average rate of return earned 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? a. The annual rate of return at the end of year 2 is \%. (Round to two decimal places.) The annual rate of return at the end of year 3 is \%. (Round to two decimal places.) The annual rate of return at the end of year 4 is 75.00%. (Round to two decimal places.) The annual rate of return at the end of year 5 is 23.81%. (Round to two decimal places.) b. The arithmetic average rate of return earned by investing in Brangus Cattle Company's stock over this period is %. (Round to two decimal places.) c. The geometric average rate of return earned by investing in Brangus Cattle Company's stock over this period is \%. (Round to two decimal places.)