80.2K

Verified Solution

Link Copied!

Using Solver to Find the Optimal Stock Portfolio Five investors plan to pool the fund and create a stock portfolio together. Based on their unique expertise and analysis, their investing preferences are as follows: Adam has a total amount of $50,000 and is only willing to invest in Google, Facebook and Amazon; Bill has a total amount of $80,000, and is willing to purchase at least 50 shares of Disney, and the rest of the fund can be allocated to AT&T, T-Mobile and Netflix; Cindy has a total amount of $65,000, and is only willing to allocate the fund to Google and Amazon; Dianna has a total amount of $90,000, and is open to invest in any companies; Elaine has a total amount of $60,000, and is willing to invest in Google, Facebook, Amazon, AT&T, T-Mobile, Netflix and Tesla. The purchase price (per share) of each stock is shown in the table below: Google Amazon Facebook Netflix T-Mobile AT&T Disney Tesla $1,400 $2,400 $213 $440 $97 $29 $108 $811 The expected profit for each stock (per share) is: Google Amazon Facebook Netflix T-Mobile AT&T Disney Tesla $52 $30 $19 $21 $8 $5 $20 $29 Please use Solver to determine the best fund allocation for each investor (i.e. for every investor, how many shares to purchase for each stock) to optimize their stock portfolio. (Note: fraction/partial share can be purchased, and integer constraint does not need to be imposed)

Answer & Explanation Solved by verified expert

See Answer