BUS 204 Classwork 3 Chapter 14 Modify the financial model (optimal investment strategy) that we worked on in class. There is a claim that the Barney-Jones investment model is generalizable. Try generalizing it to the case where there are two more potential investments, F and G. Investment F requires a cash outlay in year 2 and returns $0.50 in each of the next four years for every dollar invested. Investment G requires a cash outlay in year 4 and returns $0.75 in each of years 5, 6, and 7 for every dollar invested. Modify the model as necessary, making the objective the final cash after 7 years. Be sure to save the optimal solution to the original model. Rename the file. Add the new information to the model. Modify the formulas as necessary to include the new information and the new variables. Modify the range names. Add all parameters in Solver as necessary. Run Solver to find the optimal solution.

Chapter 14 Modify the financial model (optimal investment strategy) that we worked on in class. There is a claim that the Barney-Jones investment model is generalizable. Try generalizing it to the case where there are two more potential investments, F and G. Investment F requires a cash outlay in year 2 and returns $0.50 in each of the next four years for every dollar invested. Investment G requires a cash outlay in year 4 and returns $0.75 in each of years 5,6 , and 7 for every doliar invested. Modify the model as necessary, making the objective the final cash after 7 years. Be sure to save the optimal solution to the original model. Rename the file. Add the new information to the model. Modify the formulas as necessary to include the new information and the new variables. Modify the range names. Add all parameters in Solver as necessary. Run Solver to find the optimal solution. Nange Names Used Cash_after_juvesting Dollars invested rVALUE! final_cash rVALUE: Masimum_eer_imestment 5286,791 96 evatuet