Using Yahoo Finance or any credible source identify 5 securities that had significant appreciation in value from year 1980 to 2000. In evaluating appreciation, you need to incorporate effect of stock split. Then organize the data on the value at the end of each year, stock splits through these years, and annual paid dividend for each security in an Excel file. Organize it in a way that data on securities are arranged adjacent in horizontal direction. Then evaluate annual return for each year and for each security, incorporating change in value, paid dividends, and effect of stock split. No two submissions should be exactly the same, otherwise the later submission will be rejected in favor of the earlier submission. Attach this Excel file to your post. Also, in initiation of your written CLA 2 state your portfolio formation problem, provide the data on the 5 securities, as mentioned above, and the criterion for choosing these securities. Attach this Word file to this post. Please provide your explanations in detail in the Word file.