Purchase Solution

Probability and Returns

Not what you're looking for?

Ask Custom Question

See attached file for proper format of template.

Profitability and Returns.

The assignment requires that I consider whether this is a good investment, by comparing it with investing in a bond fund. I will need to graph the opportunity set, calculate the weights, expected returns, variance and standard deviation in the attached Excel spreadsheet. All answers must be entered into the gray cells, along with the formula showing all work and how the answer was derived.

Input area:

10-year annual return Standard deviation
Bledsoe Large Company Stock Fund 11.08% 26.73%
Bledsoe Bond Fund 8.15% 10.34%
Risk-free rate (historic) 2.76%

Correlation 0.16

Output area:

Weight of stock fund Portfolio E(R) "Portfolio standard
deviation"
0% 10.34%
10% 10.08%
20% 10.54%
30% 11.63%
40% 13.19%
50% 15.08%
60% 17.19%
70% 19.45%
80% 21.81%
90% 24.24%
100% 26.73%

Dominant portfolio:
Weight of stock fund 17.11%
Weight of bond fund 82.89%
Standard deviation 10.34%
Expected return

Minimum variance portfolio:
Weight of large cap stock fund 8.55%
Weight of bond fund 91.45%
Expected return
Variance 0.010155
Standard deviation 10.0774%

Sharpe optimal portfolio: (Using Solver)
Weight of large cap stock fund 15.79%
Sharpe ratio 0.570098

Weight of large cap stock fund 15.75%
Weight of bond fund 84.25%
Expected return
Standard deviation 10.2640%
Sharpe ratio

Attachments
Purchase this Solution
Solution Summary

The solution does a great job of answering the question. The solution is brief and concise and very easy to follow along. All the steps are clearly shown and Excel formulas are provided so that the student can answer similar questions in the future. It can be easily understood by anyone with a basic understanding of the topic. Overall, an excellent solution.

Purchase this Solution
Free BrainMass Quizzes
Employee Orientation

Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Operations Management

This quiz tests a student's knowledge about Operations Management

View More Free Quizzes
Related BrainMass Solutions

  • Effect of Risk on Shape of Probability Distribution

    What shape would the probability distribution have for (a) completely certain returns and (b) completely uncertain returns? In case of less risky expected return, spread (variance) is low i.e. probability distribution is peaked.

  • Binomial Distribution

    Probability that 9 or more will submit their return by March 31= Probability that 9 will submit returns+ Probability that 10 will submit return) Probability that 9 will submit returns= p= 0.7 q=1-p= 0.3 n= 10 r=

  • probability of federal income tax returns

    The probability that federal income tax returns will have 0,1, or 2 errors is 0.53,0.15, and 0.32. if 10 randomly selected returns are audited, what is the probability that six will have no errors, three will have one error and one will have two errors

  • Probability & Expected Return

    = 13.5 % Now the issue is how you obtain the probability values and associated returns There are two methods to do it 1.

  • Estimating returns and standard deviation of returns

    112967 Estimating returns and determining the standard deviation Consider the use of probability analysis in estimating returns and determining the standard deviation.

  • Expected return and standard deviation

    141981 Calculate the expected returns and standard deviation Please explain how to calculate the expected return and standard deviation of returns when your only given possible outcomes and probability returns.

  • Stocks and Portfolio

    393078 Stocks and Portfolio Returns State of the economy Probability A Comp.

  • probability for this investment

    and the Standard deviation of the returns.

  • Probability

    If 10 federal income tax returns are selected at random, the probability that fewer than two of them will conatin errors is: see attached file Uses binomial probability distribution to calculate the probability of error in federal income tax returns

  • Standard Deviation of expected returns

    The probability of a normal economy is 65 percent while the probability of a recession is 25 percent and the probability of a boom is 10 percent. What is the standard deviation of these expected returns?

View More Related Solutions