An investor is developing a portfolio of stocks. She has identified 3 stocks in which to invest. She wants to earn at least 11% return but with minimum risk.
Let: P_i = proportion of total funds invested in i, i = A, B, C
The NLP for this problem is: What formulas should go in cells G4:J14 of the spreadsheet for this problem? NOTE: Formulas are not required in all of these cells.

Question

An investor is developing a portfolio of stocks. She has identified 3 stocks in which to invest. She wants to earn at least 11% return but with minimum risk.
Let: P_i = proportion of total funds invested in i, i = A, B, C
The NLP for this problem is:

What formulas should go in cells G4:J14 of the spreadsheet for this problem? NOTE: Formulas are not required in all of these cells. An investor is developing a portfolio of stocks. She has identified 3 stocks in which to invest. She wants to earn at least 11% return but with minimum risk. Let: P<sub>i</sub> = proportion of total funds invested in i, i = A, B, C The NLP for this problem is: What formulas should go in cells G4:J14 of the spreadsheet for this problem? NOTE: Formulas are not required in all of these cells.

Quizplus · Accepted Answer

The Answer of An investor is developing a portfolio of stocks. She has identified 3 stocks in which to invest. She wants to earn at least 11% return but with minimum risk. Let: P_i = proportion of total funds invested in i, i = A, B, C The NLP for this problem is: What formulas should go in cells G4:J14 of the spreadsheet for this problem? NOTE: Formulas are not required in all of these cells.

An Investor Is Developing a Portfolio of Stocks