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.

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 o

$$2,500.$ Please represent this data in excel spreadsheets with the formulas displayable.