CANNOT BE IN EXCEL AND MUST IN WORD DOCUMENT SHOWING ALL WORK IN DETAIL INCLUDING THE FORMULA.
Caswell Enterprises had the following end-of-year stock prices over the last five years and paid no dividends.
a. Calculate the average rate of return for each year from the above information.
b. What is the arithmetic average rate of return earned by investing in Caswell’s stock over this period?
c. What is the geometric average rate of return earned by investing in Caswell’s stock over this period?
d. Considering the beginning and ending stock prices for the five-year period are the same, which type of average rate of return best describes the annual rate of return earned over the period (arithmetic or geometric)?
e. The annual rate of return at the end of year 2 is what percent?