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

70.2K

Verified Solution

Question

Finance

The stocks are as follows: Macy's, Microsoft, Amazon, Facebookand Apple. Create a portfolio that invests 24% of $1 million incompany 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 stocksand for the portfolio during the last calendar year (2018). Thismeans you are buying on Dec 31, after markets close, and selling onDec 31 of the following year, after markets close. Please make sureto show your work. You will need stock price/return data on the 5companies. To get the stock price/return data, go to Yahoo Finance,enter the ticker, click on “Historical Prices”, select the startand end date, and make sure “daily” is selected. Click on “GetPrices”, and use Adj. Close to calculate returns (Adj. Closeadjusts for dividends, stock splits, etc.).

Answer & Explanation Solved by verified expert

4.0 Ratings (790 Votes)

Macys 24 of 1 Million in Macys 024 Million Price of Macys on Dec 31 2017 after market close was 2595 while on Dec 31 2018 was 2630 Hence return during this period will be 134 Microsoft 22 of 1 Million in Microsoft See Answer

Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:

Unlimited Question Access with detailed Answers
Zin AI - 3 Million Words
10 Dall-E 3 Images
20 Plot Generations
Conversation with Dialogue Memory
No Ads, Ever!
Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!

Become a Member

Transcribed Image Text

The stocks are as follows: Macy's, Microsoft, Amazon, Facebookand Apple. Create a portfolio that invests 24% of $1 million incompany 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 stocksand for the portfolio during the last calendar year (2018). Thismeans you are buying on Dec 31, after markets close, and selling onDec 31 of the following year, after markets close. Please make sureto show your work. You will need stock price/return data on the 5companies. To get the stock price/return data, go to Yahoo Finance,enter the ticker, click on “Historical Prices”, select the startand end date, and make sure “daily” is selected. Click on “GetPrices”, and use Adj. Close to calculate returns (Adj. Closeadjusts for dividends, stock splits, etc.).