Share
Explore BrainMass

five-year average return for each security

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.

Solution Preview

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 ...

Solution Summary

Response helps in calculating five-year average return for each security

$2.19