For the problem you will need to write a model to determine how to allocate the $2 million to each of the loan/investment alternatives to maximize total annual return. Then, solve the problem in Excel. Make sure you submit the model, your excel spreadsheet, and state the complete solution to the problem in the context of the problem (sentence form).
See attached file for more information and data.© BrainMass Inc. brainmass.com June 4, 2020, 4:12 am ad1c9bdddf
This solution helps with a problem regarding allocating loan and investment alternatives.