The organizations are Dell, Ford, UPS, Disney, and Proctor & Gamble. I just need help with part 3 and 4.
1. Determine the five-year average return for each security.
2. Identify the securitiesâ?? industries.
3. Determine the average five-year average return in each industry.
4. Identify three additional stocks in each industry and determine the five-year average return for each.
5. Compare your securitiesâ?? performance to those in the same industry and industry average.
6. Determine whether or not changes must be made to your portfolio.
7. Attach supporting Microsoft Excel tables and graphs to your paper. Spreadsheets must detail all calculations.