Investment company is instructed to minimize risk

Assignment Help Financial Management

Reference no: EM13846322

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.

Reference no: EM13846322

Questions Cloud

Negative interest rate or zero interest rate : Please research Negative interest rate (NIRP) or Zero interest rate (ZIRP) policies and explain the following; How does this affect the bond market? Who wins and who loses in this environment?

Differences between the criminal and civil court processes : differences between the criminal and civil court processes

What are the process theories of motivation : Do you agree that the IT companies described in this case study have lessons for every organisation? If so, what are these lessons?

Perpetuity discounted-what is the present value : What is the present value of a $473 perpetuity discounted back to the present at 11.47 percent. The answer should be calculated to decimal places.

Investment company is instructed to minimize risk : 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.

Repaid in equal annual instalments : Big brothers inc borrows $165315 from the bank at 6.52 percent per year compounded annually to purchase new machines. This loan is to be repaid in equal annual instalments at the end of each year over the next 3 years. How much will each annual payme..

How to use directed reading activity : The Directed Reading Activity is a strategy that provides students with instructional support before, during, and after reading. The teacher takes an active role as he or she prepares students to read the text by pre-teaching important vocabulary,

What is the present value of this investment : An investment will pay $1283 two years from now, $ 3848 four years from now and $3124 five years from now. If the opportunity rate is 19.57 percent per year, what is the present value of this investment?

What is the total reported profit and net income : The agreed upon contract price was $2,250,000. By December 31 of the first year, Kinne Construction finished approximately one-third of the construction on the building (as agreed upon by the A/E) and subsequently billed Sitzabee Inc. $800,000. What ..

User Account

All Pages