All the questions refer to the Savvy Stock Selection case study which is detailed below. Ever since the day she took her first economics class in high school, Lydia wondered about the financial practices of her parents. They worked very hard to earn enough money to live a comfortable middle-class life, but they never made their money work for them. They simply deposited their hard-earned paychecks in savings accounts earning a nominal amount of interest. (Fortunately, there always was enough money available when it came time to pay her college bills.) She promised herself that when she became an adult, she would not follow the same financially conservative practices as her parents. And Lydia kept this promise. She took every available finance course in her business program at college. Having landed a covered job on Wall Street upon graduation, she now begins every morning by watching the Bloomberg financial reports. She plays investment games on the internet. finding portfolios that maximize her return while minimizing her risk. And she reads The Wall Street Journal and Financial Times. Lydia also reads the investment advice columns of the financial websites. She decides to follow the current advice given by her two favorite bloggers. In his monthly blog, editor Jonathan Taylor recommends three stocks that he believes will rise far above market average. In addition, the well-known mutual fund guru Donna Carter advocates the purchase of three additional stocks that she thinks will outperform the market over the next year. Bigbell (ticker symbol on the stock exchange: BB), one of the nation's largest telecommunications companies, trades at a price-earnings ratio well below market average. Huge investments over the last eight months have depressed earnings considerably. However, with its new cutting-edge technology, the company is expected to significantly raise its profit margins. Taylor predicts that the stock will rise from its current price of $60 per share to $72 per share within the next year. Lotsofplace (LOP) is one of the leading hard drive manufacturers in the world. The industry recently underwent major consolidation, as fierce price wars over the last few years were followed by many competitors going bankrupt or being bought by Lotsofplace and its competitors. Due to reduced competition in the hard drive market, revenues and earnings are expected to rise considerably over the next year. Taylor predicts a one-year increase of 42 percent in the stock of Lotsofplace from the current price of $127 per share. Internetlife (ILI) has survived the many ups and downs of Internet companies. With the next Internet frenzy just around the corner, Taylor expects a doubling of this company's stock price from $4 to $8 within a year. Healthtomorrow (HEAL) is a leading biotechnology company that is about to get approval for several new drugs from the Food and Drug Administration, which will help earnings to grow 20 percent over the next few years. In particular, a new drug to significantly reduce the risk of heart attacks is supposed to reap huge profits. Also, due to several new great-tasting medications for children, the company has been able to build an excellent image in the media. This public relations coup will surely have a positive effect on the sale of its over-the-counter medications. Carter is convinced that the stock will rise from $50 to $75 per share within a year. JA 631 Prescriptive Analytics and Spreadsheet Modeling Spring 2023 Dr. James P. MinasQuicky (QUI) is a fast-food chain that has been vastly expanding its network of restaurants all over the United States. Carter has followed this company closely since it went public some 15 years ago when it had only a few dozen restaurants on the West Coast of the United States. Since then the company has expanded, and it now has restaurants in every state. Due to its emphasis on healthy foods, it is capturing a growing market share. Carter believes that the stock will continue to perform well above market average for an increase of 46 percent in one year from its current stock price of $150. Automobile Alliance (AUA) is a leading car manufacturer from the Detroit area that just recently introduced two new models. These models show very strong initial sales, and therefore the company's stock is predicted to rise from $20 to $26 over the next year. Using the Internet, Lydia found data about the risk involved in the stocks of these companies. The historical variances of return of the six stocks and their covariances are shown in the following tables Company BB LOP ILI HEAL QUI AUA Variance 0.032 0.1 0.333 0.125 0.065 0.08 Covariances LOP ILI HEAL QUI AUA BB 0.005 0.03 0.031 0.027 0.01 LOP 0.085 -0.07 -0.05 0.02 ILI 0.11 0.02 0.042 HEAL 0.05 -0.06 QUI -0.02 a. At first, Lydia wants to ignore the risk of all the investments. Given this strategy, what is her optimal investment portfolio; that is, what fraction of her money should she invest in each of the six different stocks? What is the total risk of her portfolio? b. Lydia decides that she doesn't want to invest more than 40 percent in any individual stock. While still ignoring risk, what is her new optimal investment portfolio? What is the total risk of her new portfolio? c. Now Lydia wants to take into account the risk of her investment opportunities. For use in the following parts, formulate a quadratic programming model that will minimize her risk (measured by the variance of the return from her portfolio) while ensuring that her expected return is at least as large as her choice of a minimum acceptable value. d. Lydia wants to ensure that she receives an expected return of at least 35 percent. She wants to reach this goal at minimum risk. What investment portfolio allows her to do that? e. What is the minimum risk Lydia can achieve if she wants an expected return of at least 25 percent? Of at least 40 percent? f. Do you see any problems or disadvantages with Lydia's approach to her investment strategy? Your total score for the project will be out of 100. Projects will be graded based on the following criteria: Report is clearly presented and easy to read (and within eight-page limit) Conclusions / recommendations are well supported by the analysis Appropriate model outputs are included in eight-page report Analysis is comprehensive and complete (it includes everything that has been asked for) Analysis is technically sound and has been done correctly Excel file that you submit contains all the analysis you undertook and is clearly laid out