Data table (Solving * comprehenalve problem) Use the end-of-year stock price data in the popup window, , to answer the following poestions for the Hurrs and Prwhoel companies. a. Compute the annual rales of colum for each trme period and for both frms. ary dividende) c. Compute a three-year rate of retum sparning the entire period (ie, using the ending price lor period 1 and ending price for period 4) (1+Three-YearRateofPebinn)=(1+AnnualRateofRetum)3 a. Compute the annual nites of rotum for each tme period and for both firms: any dividends ) c. Compute a three-year rate of retum spanning the entire period (i.e., using the ending price for period 1 and ending price for period 4 ) d. Since the rate of retum calculated in part 0 is a three year rate of return, convert it to an annual rate of retum by using the following equation: (1+Three-YearRateofReturn)=(1+AnnualRateofReturn)3 2. How in the annual rate of retum calculated in part d relaled to the geometric rate of retum? When you are evaluating the performance of an investment that has been held for several years, what type of average rate of return (arithmetic or geometic) should you use? Wiyl? a. Enter the annual rate of return for each year for Harris in the table below. (Round to two decimal places)