This needs to be complete on EXCEL 2013 1 Portfolio Composition Rocky the Bull Rocky the Bull has won $1,000,000 in the Florida Lottery and wants to invest it in shares. He is interested in investing in General Mills, GE, and Intel shares only. He wants to invest half his windfall in the safest possible portfolio (Portfolio A) and wants the other half (Portfolio B) to generate maximum return for him. a) Chart the feasible set, with the efficient frontier, available to him. b) How many shares of each firm will he buy in Portfolio A? c) How many shares of each firm will he buy in Portfolio B?
Paper For Above instruction Portfolio Optimization and Investment Strategy for Rocky the Bull Portfolio Optimization and Investment Strategy for Rocky the Bull Rocky the Bull's recent windfall of $1,000,000 provides an excellent opportunity to explore portfolio construction, particularly focusing on risk minimization and maximizing returns through diversification among General Mills, General Electric (GE), and Intel shares. This paper meticulously examines the feasible investment set, constructs the efficient frontier, and determines specific share purchase strategies for the two distinct portfolios Rocky desires: a safe portfolio (Portfolio A) and a high-return portfolio (Portfolio B). Understanding the Investment Context Investing in stocks involves balancing risk and return. For Rocky, the challenge is to allocate his $1 million between shares of General Mills, GE, and Intel in a manner that meets his dual objectives: safety and maximized returns. To do so, analyzing the feasible set of all possible portfolios—and identifying the efficient frontier—is crucial. This process involves understanding each stock’s expected return, risk (standard deviation), and how their returns correlate, to optimize the portfolio according to Rocky’s risk preferences. Estimating Expected Returns and Risks Assuming access to historical data, the expected returns for General Mills, GE, and Intel can be estimated based on past performance. For example, suppose the annual expected returns are as follows: