A. Determine the five-year average return for each one of your selected securities.
b. Identify the industries of your six selected securities.
c. Determine the average five-year average return in each of your industries.
d. Identify three additional stocks in each industry and determine the five-year average return for each security.
e. Compare your selected securities’ performance to those in the same industry and to the industry average.
f. Based on your findings, determine whether or not changes should be made to your investment portfolio.
g. Attach supporting Microsoft® Excel® tables and graphs to your paper. Microsoft® Excel® spreadsheets must detail all calculations.