Cash Jones wants to invest in a portfolio composed of stocks ABC and XYZ (see below) that will yield a return of 19%. What is the weight of each stock in such a portfolio, and what is the portfolios standard deviation? Answer the question both by using Goal Seek or Solver and the mathematical formulas.

Expected return Standard deviation of return 15% 25% 33% 46% ABC XYZ Covariance(ABC,XYZ) Correlation(ABC,XYZ) 0.0865 0.5698