Answered You can hire a professional tutor to get the answer.

QUESTION

Ivana Miracle wishes to invest up to her full inheritance of $580,000, and her goal is to minimize her risk subject to an expected annual return of...

Ivana Miracle wishes to invest up to her full inheritance of $580,000, and her goal is to minimize her risk subject to an expected annual return of at least $29,000. She has decided to invest her money in any of three possible ways — CDs, which pay a guaranteed 2 percent; stocks, which have an expected return of 5 percent; and a money market mutual fund, which is expected to return 3 percent. Risk factors are 1.5 for the CDs, 4.5 for the stocks, and 2.8 for the money market fund. What is the optimal solution and minimum risk value?  Please attach the Excel file.

  1. Attach File
Objective Function:MinimiZe Z = 2610000 Decision Variables:ReturnCDs =Stocksmutual fund = $$ 580,000.00$- Constraints:Budget:Return: $ 580,000.00 =$29,000.00 >= Risk2%5%3% 1.5...
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question