Portfolio expected return & risk analysis using crystal Ball
Not what you're looking for?
Solve the following exercise using Crystall Ball. Please refer to the attached word document for the instructions.
Erin Jones has $100,000 and, to diversify, she wants to invest equal amounts of $50,000 each in two mutual funds selected from a list of four possible mutual funds. She wants to invest for a three-year period. She has used historical data from the four funds plus data from the market to determine the mean and standard deviation (normally distributed) of the annual return for each fund, as follows:
Fund µ σ
1. Internet .20 .09
2. Index .12 .04
3. Entertainment .16 .10
4. Growth .14 .06
The possible combinations of two investments are (1,2),(1,3),(1,4),(2,3),(2,4), and (3,4).
a. Use Crystal Ball to simulate each of the investment combinations to determine the expected return in 3 years. (Note that the formula for the future value, FV, of a current investment, P, with return, r, for n years in the future is FVn = Pr (1 + r)n . Indicate which investment combination has the highest expected return.
b. Erin wants to reduce her risk as much as possible. She knows that if she invests her $100,000 in a CD at the bank she is guaranteed a return of $20,000 after 3 years. Using the frequency charts for the simulation runs in Crystal Ball determine which combination of investments would result in the greatest probability of receiving return of $120,000 or greater.
---
Purchase this Solution
Solution Summary
This post illustrates how simulation analysis can be used to build the portfolios with required expected return and risk. Crystal ball software is used for the simulation process. Thus this post provides an opportunity to learn the financial modeling using crystal ball along with the risk return basics for finance.
Solution Preview
See the attached file. The text here may not print correctly for tables and symbols. Thanks
There are two ways to do this, either we simulate the return for each year to calculate the overall return for the 3-year period. Else, we can simulate it for just one year and use the same return for the three years. The formula shown above
FVn=Pr(1+r)n indicates that we are looking for one year simulation.
If we are looking for 3 ...
Purchase this Solution
Free BrainMass Quizzes
Know Your Statistical Concepts
Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.
Measures of Central Tendency
Tests knowledge of the three main measures of central tendency, including some simple calculation questions.
Measures of Central Tendency
This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.
Terms and Definitions for Statistics
This quiz covers basic terms and definitions of statistics.