(Solving a comprehensive problem) Use the end-of-year sock price data in a. Compute the annual rates of roturn for each time period and for both firms dividonds:) c. Compute a throe-year rate of refurn spanning the onse penod (ce, using the ending price for period 1 and ondirg price for penod 4 ) d. Since the rate of roturn calculated in part c is a threo-year rate of tetum, convort it to an arriax rate of cotum by stire the folowing equation: a. Fintar the annual rate of return for each year for Hairs in the table below, (Roound to two docinal places) Data table View an example a. Enter the annual rate of return for each year for Harris in the table below. (Round to two decimal places.) a. Contpute the annuss rates of rotum for each fime period and tor both firms. idvidendic) average rate of retum (arithmetic or goometric) should you use? Why