Question

In: Finance

The 5 stocks are as follows: Microsoft, Amazon, Macy’s, Facebook, and Apple. Create a portfolio that...

The 5 stocks are as follows: Microsoft, Amazon, Macy’s, Facebook, and Apple. Create a portfolio that invests 24% of $1 million in company A, 22% in company B, 20% in company C, 18% in company D, and 16% in company E.

What is the buy-and-hold return (HPR) for each of the 5 stocks and for the portfolio during the last calendar year (2018). This means you are buying on Dec 31, after markets close, and selling on Dec 31 of the following year, after markets close. Please make sure to show your work. You will need stock price/return data on the 5 companies. To get the stock price/return data, go to Yahoo Finance, enter the ticker, click on “Historical Prices”, select the start and end date, and make sure “daily” is selected. Click on “Get Prices”, and use Adj. Close to calculate returns (Adj. Close adjusts for dividends, stock splits, etc.).

Solutions

Expert Solution


Related Solutions

The stocks are as follows: Macy's, Microsoft, Amazon, Facebook and Apple. Create a portfolio that invests...
The stocks are as follows: Macy's, Microsoft, Amazon, Facebook and Apple. Create a portfolio that invests 24% of $1 million in company A, 22% in company B, 20% in company C, 18% in company D, and 16% in company E. What is the buy-and-hold return (HPR) for each of the 5 stocks and for the portfolio during the last calendar year (2018). This means you are buying on Dec 31, after markets close, and selling on Dec 31 of the...
In networked world dominated by the GAFAM (Google, Apple, Facebook, Amazon and Microsoft) and BATX (Baidu,...
In networked world dominated by the GAFAM (Google, Apple, Facebook, Amazon and Microsoft) and BATX (Baidu, Alibaba, Tencent and Xiaomi) tech giants it is better for new tech start-ups to either plug-in, or partner with them instead of competing head-on or differentiating.Develop a viable, ethical, legal, and profitable E-commerce business idea for the Pakistani market that integrates and uses specific AI enabled technologies and VR / AR platforms offered by GAFAM and BATX by using either plug-in, or partner strategy....
The five largest tech companies (Google, Apple, Facebook, Amazon, Microsoft or GAFAM) now make up 20%...
The five largest tech companies (Google, Apple, Facebook, Amazon, Microsoft or GAFAM) now make up 20% of the S&P 500 (the market portfolio). This problem aims to quantify the consequence of this increasing concentration for investors. We assume that the entire security market is made of only three types of assets: a risk-free asset (rf = 3%) and two risky securities G (a portfolio composed by investing in the ve GAFAM stocks) and B (a portfolio composed by investing in...
The five largest tech companies (Google, Apple, Facebook, Amazon, Microsoft or GAFAM) now make up 20%...
The five largest tech companies (Google, Apple, Facebook, Amazon, Microsoft or GAFAM) now make up 20% of the S&P 500 (the market portfolio). This problem aims to quantify the consequence of this increasing concentration for investors. We assume that the entire security market is made of only three types of assets: a risk-free asset (rf = 3%) and two risky securities G (a portfolio composed by investing in the five GAFAM stocks) and B (a portfolio composed by investing in...
Is It Time To Break Up Amazon, Apple, Facebook, or Google?
Is It Time To Break Up Amazon, Apple, Facebook, or Google?
CAREER E-PORTFOLIO INSTRUCTIONS The assignment is to create a Career E-Portfolio using Microsoft PowerPoint. As Microsoft...
CAREER E-PORTFOLIO INSTRUCTIONS The assignment is to create a Career E-Portfolio using Microsoft PowerPoint. As Microsoft PowerPoint competency is a requirement of this class, other technology will not be accepted. Elements of the E-portfolio assignment include (minimum of four slides required): Title page with picture, name, contact information, and a brief professional and educational overview Resume page Projects AND/OR Activities page including projects completed in classes, college club activities, and research conducted as part of the hospitality program. Volunteer AND/OR...
Article: Tech Giants Rethink the Businesses That Made Them Big Facebook, Apple, Amazon and Google are...
Article: Tech Giants Rethink the Businesses That Made Them Big Facebook, Apple, Amazon and Google are seeking out new places to disrupt, but analysts say future ventures will likely be costly Where does Microsoft figure into this?
(1) A: The stocks of Apple and Amazon have the following expected returns: State of Economy...
(1) A: The stocks of Apple and Amazon have the following expected returns: State of Economy Probability of State of Economy Apple's Return if State Occurs Amazon's Return if State Occurs Recession 55% -9% -12% Normal 30% 8% 11% Boom 15% 17% 14% Which company's stock is riskier, based on standard deviation?   B: If you have 120 shares of Apple's common stock ($171.05 per share) and 90 shares of Amazon's common stock ($1162.35 per share) in your portfolio, what is...
Apple Inc., Microsoft Corp., Berkshire Hathaway, and Facebook have all been identified as companies that have...
Apple Inc., Microsoft Corp., Berkshire Hathaway, and Facebook have all been identified as companies that have accumulated substantial sums of cash. For this discussion: Select one of these companies and review their latest Balance Sheet and Statement of Cash Flows. Suggest at least two (2) advantages and two (2) disadvantages of companies accumulating cash hoards. Provide a rationale for your suggestion.
Create a portfolio using the four stocks and information below:
Create a portfolio using the four stocks and information below: (Do not round intermediate calculations. Record your answers in decimal form and round your answers to 4 decimal places. Ex. X.XXXX)What is the variance of A?What is the variance of B?What is the variance of C?What is the variance of D?What is the Correlation (A,A)?What is the Correlation (B,B)?What is the Correlation (C,C)?What is the Correlation (D,D)?What is the Covariance (A,A)?What is the Covariance (A,B)?What is the Covariance (A,C)?What is the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT