Explore BrainMass

Explore BrainMass

    Excel Solver - Diversification of Investments

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Jose is going to invest up to $23,000 in a savings account, bonds, or both. He wants to invest from $3000 to $13,000 in the savings account at 4% interest. The bonds will be insured up to $17,000, so Jose doesn't want to invest more than that amount in bonds which will earn 4 1/2%. What will be the maximum amount of interest that Jose could learn?

    © BrainMass Inc. brainmass.com June 3, 2020, 6:23 pm ad1c9bdddf

    Solution Preview

    The accompanied excel file detail the use of Solver tool to find the ...

    Solution Summary

    The solution provides detailed explanations including the Excel Solver program.