Short and simple financial findings

 
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.

Also, in initiation of your written document(attached) 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. 

Provide your explanations and definitions in detail and be precise. Comment on your findings. Provide references for content when necessary. Provide your work in detail and explain in your own words. Support your statements with peer-reviewed in-text citation(s) and reference(s).