Investment company is instructed to minimize the risk for


Please provide, in detail, how to process a sensitivity analysis and excel solver for the following problem:

Investment company is instructed to minimize the risk for an investor with $1,200,000 to invest. Stock funds cost $50 with a return of 10%. Money market fund costs $100 and annual return of 4%. Investor wants to earn at least $60,000. Stock fund risk index of 8 and money market risk index of 3. Investor wants at least $300,000 invested in the Money market. Provide annual income, how many units of each to purchase. Please identify constraints.

Request for Solution File

Ask an Expert for Answer!!
Financial Management: Investment company is instructed to minimize the risk for
Reference No:- TGS01126516

Expected delivery within 24 Hours