+1 (208) 254-6996 [email protected]
  

 Return and Risk (100 points)

Complete the following problems:

Don't use plagiarized sources. Get Your Custom Essay on
Finance, Return And Risk Need Excel
Just from $13/Page
Order Essay

Problem #1:You are the investment consultant for a Saudi Arabian hospital to assess the risk for its future investments.

There are three potential opportunities:

  • Investing in Clinic A, or Clinic B or Clinic C.
  • They have the following probabilities with regard to their return on investment:
  • What is the expected return for each clinic?
  • Calculate the standard deviation of return for each clinic?
  • If the hospital is risk averse, which clinic would you recommend?
  • If the hospital wants the highest, return which clinic would you recommend?
  • If the hospital wants a good return but with a medium level of risk, which clinic would you recommend?

Problem #2:

The hospital invests in several Mutual FundsCalculate the required rate of return for each fund.Problem #3:Mutual Fund D is made up of the following stocksBased on this data calculate the portfolio’s return and BetaProblem #4:You are provided with the following information about a portfolioCalculate the required rate of return for portfolio using CAPM You must show all your calculations for credit. Your calculations for this assignment must be submitted as an Excel file. Present your findings in a paper 4-5 pages in length excluding the cover, the reference page, and the excel spreadsheet for Problems #1-4. Be sure to include:

  • Summary of findings.
  • Analysis of the acceptable level of risk for each scenario.

 Your paper should meet the following structural requirements:

  • Four-to-five pages in length, not including the cover sheet and reference page. 
  • You must show all your calculations for credit. Your calculations for this assignment must be submitted as an Excel file, identified as Appendix A, and included as part of the Word document submission.
  • Formatted according to APA 7th edition 
  • Provide support for your statements with in-text citations from a minimum of four scholarly articles. Two of these sources may be from the class readings, textbook, or lectures, but the other two must be external. 

SEU HCM565 Critical Thinking Rubric – Module 6

Exceeds Expectation Meets Expectation Below Expectation Limited Evidence

Content, Research, and Analysis

10 Points 7-9 Points 5-6 Points 3-4 Points

Requirements Includes all of the required components, as specified in the assignment.

Includes most of the required components, as specified in the assignment.

Includes some of the required components, as specified in the assignment.

Includes few of the required components, as specified in the assignment.

87-90 Points 57-86 Points 25-56 Points 0-24 Points

Problem 9-1 All components are correct, with no errors or omissions.

Some significant but not major errors exist.

Some major errors or omissions exist.

Fails to demonstrate adequate comprehension of the concept.

Total points possible = 100

Order your essay today and save 10% with the discount code ESSAYHELP