stock split 2
questionS: they are total 3 questions in this assignment first a and b I need answers by March 29th 8PM CDT, for c you need to spend some time atmost 3 days.
A)
Using Yahoo Finance, http://www.bloomberg.com or any credible source identify 5 securities that had significant appreciation in value from year 2015 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 the initiation of your written final paper 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.
Answer of A)
Please provide
Attach this Excel file to your post
atleast 3 paragraphs of content in this portfolio formation problem with data on the 5 securities, as mentioned above, and the criterion for choosing these securities.
give details
plagiarism less than 10%
APA format
b)
Read the final paper assignment listed in the course. Then, please provide an outline that itemizes the concepts that you will include in your final paper and final PPP. Please be sure to include concepts learned in the course and any information from your previous paper if applicable. Provide some brief details for each item that is outlined.
Answer of b)
based on the final question c mention what are the necessities needed
provide proper details
at least 3 paragraphs
APA PLAGIARISM
less than 10%
c) final important paper
This is complete write up of your portfolio formation in a Word file, with calculations copied and pasted in it from your Excel file.
1. Select the stocks of three publicly traded companies from different industries. State the criteria for selecting those securities.
2. Retrieve monthly data on adjusted closing prices of your securities from Yahoo Finance for the past 4 years and calculate the monthly rate of return of the stocks for every month.
3. Calculate the mean, variance, and standard deviation of the stocks’ monthly returns.
4. Calculate the correlation coefficient between every possible pair of stocks’ returns.
5. Decide what percentage of your money (weights) you want to invest in each stock and state the criteria you used to select those weights.
6. Now calculate your portfolio’s mean monthly return, variance, and standard deviation.
7. Assuming your portfolio return follows a normal distribution, calculate the chance that your portfolio loses 10% of its value during any month?
8. Assuming you have invested $100,000 in your portfolio, what is value at risk (VaR) of your portfolio at any particular month at 99% confidence level?
9. Now randomly change your portfolio’s weights 100 times (note total weights should always be 100%), for each weight combination calculate the mean and standard deviation of your portfolio, and then draw the efficient frontier.
10. For each item mentioned above explain your rationale and cite peer-reviewed and/or seminal sources.
Answer for c:
give proper abstract of the problem
at least 6 pages
proper introduction of the topic
details explaination of solving the problems and solution.
Apa format
plaigriasm less than 10%
5 references atleast
