Reference no: EM132162859
Question - As we have seen, over the 1926â€"2014 period, small-company stocks had the highest return and the highest risk, while U.S. Treasury bills had the lowest return and the lowest risk. While we certainly hope you have an 89-year holding period, it is likely your investment will be for fewer years. One way risk and return are examined over shorter investment periods is by using rolling returns and standard deviations. Suppose you have a series of annual returns, and you want to calculate a three-year rolling average return. You would calculate the first rolling average at Year 3 using the returns for the first three years. The next rolling average would be calculated using the returns from Years 2, 3, and 4, and so on. On excel.
1. Using the annual returns for large-company stocks and Treasury bills, calculate both the 5- and 10-year rolling average return and standard deviation.
2. Over how many 5-year periods did Treasury bills outperform large-company stocks? How many 10-year periods?
3. Over how many 5-year periods did Treasury bills have a larger standard deviation than large-company stocks? Over how many 10-year periods?
4. Graph the rolling 5-year and 10-year average returns for large-company stocks and Treasury bills.
5. What conclusions do you draw from the preceding results?