• Home
  • Blog
  • All American Career College Financial Risk and Required Return Worksheet

All American Career College Financial Risk and Required Return Worksheet

0 comments

Return and Risk

Complete the following problems:

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 Funds

HjeqkxwH SwBI V8 vSO1DgueVF9Y8PVLWFF1H6s aBowjLp4jR7uXlTKtf2MI1FhXyRYCes1O8qDeFKad45sX5zyS6IGW89i6Mc 7WQ6kVfKHpbfY5vt9KfaTbClpLf 50Fprw

Calculate the required rate of return for each fund.

Problem #3:

Mutual Fund D is made up of the following stocks

CUoLi9xYUcrIHWh0AJwPEAGKadQw7tDxhiHNMCPmMvOompv0W1K LkjjgbSEf15Crn7uQshEp4 k6xbc2Bl9fYJfB5ceg4d alQUlYiD5YEVz zqph49npsoEq ch8uvSSStXBo

Based on this data calculate the portfolio’s return and Beta

Problem #4:

You are provided with the following information about a portfolio

iGdBbPDpdkd6YNxj07yYtvKRiFxhy6lPb8E 33s

Calculate 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.

About the Author

Follow me


{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}