This discussion question is in preparation of CLA 2. Using Yahoo Finan This discussion question is in preparation of CLA 2. Using Yahoo Finance, or any credible source identify 5 securities that had significant appreciation in value from year 2000 to 2018. In evaluating appreciation, you need to incorporate the 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. 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).
Paper For Above instruction Introduction The task of constructing an investment portfolio involves selecting securities with the potential for substantial appreciation over time. This analysis aims to identify five securities that experienced significant growth between 2000 and 2018, considering key factors such as stock splits and dividends. The goal is to systematically organize and evaluate the historical performance of these securities to understand their annual returns, which include capital appreciation, dividend payouts, and the impacts of stock splits. Portfolio Formation Problem The central problem addressed in this study is to determine which securities have demonstrated the most substantial appreciation from 2000 to 2018, accounting for corporate actions such as stock splits and dividends. The criterion for selection involves identifying stocks that not only appreciated in value but also maintained consistent dividend payouts. This ensures a comprehensive assessment of total returns, which encompasses capital gains, dividends, and adjustments for stock splits, thereby reflecting the true investor