1. ) A business student has $2,500 available from a summer job and has identified three potential stocks in which to invest. The cost per share and expected return over the next two years is given in the table.

Stock	A	B	C
Price/share	$25	$15	$30
Return/share	$8	$7	$11

Develop a spreadsheet model that computes the total return for any mix of investments. Experiment with the model to attempt to find the best solution with the highest total return and that limits the investment to $2,500.

Please show me the excel formula