Using the Excel File:
1. Pick 3 stocks from the Most Actives List and download the last three years of monthly adjusted prices for these stocks and S&P 500 Index to Table 1
2. Calculate the monthly retuns of these three stocks in Table 1
3. Calculate the standard deviations of returns for three stocks and a portfolio with equal investment in three stocks using Table 5, similar to the TESLA example we did in class. Use the excel function STDEVP to check your answer and enter your findings in Table 2
4. Use the CORREL Function to calculate the Correlation Coefficient of monthly returns for each pair of stock and enter in Table 3. Whick pair provides the greatest gain from diversification? Why?
5.Calculate the beta, market variance and firm specific variance for three stocks and a portfolio with equal investment in three stocks using the TREND function in Table 4
The post FINANCE appeared first on Advanced Essay.
I absolutely LOVE this essay writing service. This is perhaps the tenth time I am ordering from them, and they have not failed me not once! My research paper was of excellent quality, as always. You can order essays, discussion, article critique, coursework, projects, case study, term papers, research papers, reaction paper, movie review, research proposal, capstone project, speech/presentation, book report/review, annotated bibliography, and more.
Ask a Question. Get an Answer ASAP!