Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need this answer for this question please. it's important and urgent. 1. From the list of firms with historical return data from January 2011

image text in transcribed

I need this answer for this question please. it's important and urgent.

1. From the list of firms with historical return data from January 2011 to December 2015 (please note that some firms do not have complete data between these periods), you need to choose at least 5 firms as your portfolio choices. You need to think why you are choosing these specific firms as your portfolio. You can imagine that you are now a fund manager. Once you pick your firms, you need to extract the data of these firms along with market information from the dataset. 2. Based on the Markowitz portfolio optimization, what are the weights of your stocks if you are allowed to short sale? What are the weights if short sale is not allowed? 3. Based on the Single Index model, what are the weights of your stocks if you are allowed to short sale? What are the weights if short sale is not allowed? 4. Now you need to use the data from January 2016 to December 2019 for your firms. Please extract the data. 5. Let's see how your portfolio performed from January 2016 to December 2019. What is the performance of your Markowitz optimal portfolio with short sale? 6. Compare your Markowitz optimal portfolio with an equally-weighted portfolio of your stocks. Does it show your optimal portfolio outperformed the equally weighted one? 7. Now, you have a file for Berkshire Hathaway holdings as of December 2015. Using the data file of these portfolio with their weights as of December 2015. please check if your portfolio outperformed this Berkshire Hathaway's portfolio? In other words, did you beat Mr. Warren Buffet? 8. Please make a report to summarize what you find in this project along with the motivation of your stock picks and other questions in earlier parts in a separate word file. Please turn in your Excel sheet as a supplement to show your work. 1. From the list of firms with historical return data from January 2011 to December 2015 (please note that some firms do not have complete data between these periods), you need to choose at least 5 firms as your portfolio choices. You need to think why you are choosing these specific firms as your portfolio. You can imagine that you are now a fund manager. Once you pick your firms, you need to extract the data of these firms along with market information from the dataset. 2. Based on the Markowitz portfolio optimization, what are the weights of your stocks if you are allowed to short sale? What are the weights if short sale is not allowed? 3. Based on the Single Index model, what are the weights of your stocks if you are allowed to short sale? What are the weights if short sale is not allowed? 4. Now you need to use the data from January 2016 to December 2019 for your firms. Please extract the data. 5. Let's see how your portfolio performed from January 2016 to December 2019. What is the performance of your Markowitz optimal portfolio with short sale? 6. Compare your Markowitz optimal portfolio with an equally-weighted portfolio of your stocks. Does it show your optimal portfolio outperformed the equally weighted one? 7. Now, you have a file for Berkshire Hathaway holdings as of December 2015. Using the data file of these portfolio with their weights as of December 2015. please check if your portfolio outperformed this Berkshire Hathaway's portfolio? In other words, did you beat Mr. Warren Buffet? 8. Please make a report to summarize what you find in this project along with the motivation of your stock picks and other questions in earlier parts in a separate word file. Please turn in your Excel sheet as a supplement to show your work

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Healthcare Finance Modern Financial Analysis For Accelerating Biomedical Innovation

Authors: Andrew W. Lo, Shomesh E. Chaudhuri

1st Edition

0691183821, 978-0691183824

More Books

Students also viewed these Finance questions

Question

What do employees do to reduce or eliminate customer confusion?

Answered: 1 week ago