Preview

positioning report

Satisfactory Essays
Open Document
Open Document
749 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
positioning report
BA 555 Practical Business Analysis

Group Project 2: Business Simulation
**** Due: November 12, 2014 ****

NAME
Tailong Wu (Section 001)
NAME
Ling Yang (Section 002)

NAME
Daijie Qi (Section 002)

1. The file Group Project 2 Model.xlsx contains 50 monthly returns of the SCHO and SPY EFT funds from September 2010 to October 2014. Suppose that in each of the next 72 months (six years), it is equally likely that any of the historical returns will occur. Develop a spreadsheet model to simulate the two suggested investment strategies over the six-year period. Plot the value of each strategy over time for a single iteration of the simulation. What is the total value of each strategy after six years? Do either of the strategies reach the target?

Based on our simulation model analysis of a single iteration, for the first strategy, the total value after 6 years is $ 22361. For the second strategy the value is $ 16610. So the first strategy reaches the target while the other one does not.

Hint:
1. To simulate ETF returns based on the historical return, use the @Risk function =RiskIntUniform( minimum, maximum ) to simulate an integer value between 1 and 50 to randomly pick a month. Use Excel function =VLOOKUP to pick the corresponding historical return based on the randomly selected month.
2. Repeat the process 71 more times to generate random monthly returns for the next 6 years. Use the simulated returns to calculate the ending portfolio values.
3. Make sure that Random Values (Monte Carlo) under Setting is selected. This would allow random numbers to be generated every time the spreadsheet is refreshed.

2. Simulate 1000 iterations of the two strategies over the six-year period. Create a histogram of the final fund values. Based on your simulation results, which of the two strategies would you recommend? Why?

Below are the histograms of the two strategies’ fund values:

Our group would recommend the first strategy. Although this strategy has a higher

You May Also Find These Documents Helpful

  • Good Essays

    tsa solution manual

    • 55080 Words
    • 1025 Pages

    Exercise 1.5 Simulate a completely random process of length 48 with independent, t-distributed values each with 5…

    • 55080 Words
    • 1025 Pages
    Good Essays
  • Satisfactory Essays

    i) Given figures in Exhibits 4 and 11 what is the expected return and volatility of the policy portfolio?…

    • 394 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    QAT 1 TASK 5

    • 398 Words
    • 2 Pages

    1.) The Company has determined that it has two alternatives for improving profits: develop new products either rapidly or thoroughly, or consolidate existing products by strengthening products or reaping without investing. On the first branch of the decision tree we know that the decision to develop thoroughly has a probability of 0.4 in a good market and predicted gains of $500,000. The second State of nature would be a moderate market reaction with a probability of .4 and predicted gains of $25,000. The third state of nature is a poor market reaction with a probability of .2 with predicted gains of $1,000. The expected monetary value (EMV) is determined by multiplying the probability in each state of nature by the predicted gains and then adding sums of each state of nature. The EMV (Developing thoroughly) =.4(500,000) +.4(25,000) +.2(1,000) =210,200…

    • 398 Words
    • 2 Pages
    Satisfactory Essays
  • Better Essays

    a) In the first set of calculations, the staff used a discount rate of 20%, a five-year time horizon, and ignored taxes and terminal value. What is the relative attractiveness of these three alternatives?…

    • 1278 Words
    • 6 Pages
    Better Essays
  • Good Essays

    2. An angel investor is considering investing in one of two start-up businesses and is evaluating the expected returns along with the risk of each option in order to choose the better alternative.…

    • 795 Words
    • 4 Pages
    Good Essays
  • Satisfactory Essays

    Now choose one of these strategies and perform the necessary calculation. Explain in complete sentences why you have chosen this strategy.…

    • 261 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Fi 360 Week 2

    • 418 Words
    • 2 Pages

    3-2. Dixon Shuttleworth has a large sum of money that he wants to invest to finance his retirement. He has been presented with three options. The first investment offers a 5% return for the first five years, a 10% return for the next five years, and a 20% return thereafter. The second investment offers 10% for the first ten years and 15% thereafter. The third investment offers a constant 12% rate of return. Determine which of these investments the best for Dixon is if he plans to retire in the following number of years.…

    • 418 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Encom Corporation

    • 369 Words
    • 2 Pages

    The first method lowers the 1st years ROE while inflating the ROE of the next 2 years.…

    • 369 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    The best decision using the equal likely criterion the best choice is the investment of $266,666.666.…

    • 638 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Brs Mdm3 Tif Ch08

    • 3288 Words
    • 19 Pages

    4) Determining the average payoff for each alternative and choosing the one with the best payoff is the approach called:…

    • 3288 Words
    • 19 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Optimistic Decision Maker

    • 325 Words
    • 2 Pages

    ( b) What is the optimal decision? The optimal decision is Sub 100, which has the highest Expected Monetary Value of 150,000.…

    • 325 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Hint: You will need to import Random and create a Random object, either directly in the new method or in the constructor and stored in a field. You will need to find the API documentation for the Random class and check its methods to choose the correct version of nextInt.…

    • 341 Words
    • 3 Pages
    Satisfactory Essays
  • Good Essays

    Ferguson Car Rental Essay

    • 942 Words
    • 4 Pages

    Option C: capture 20% of the four-week market, 50% of the eight-week market, and 25% of the twelve-week market.…

    • 942 Words
    • 4 Pages
    Good Essays
  • Better Essays

    Payback & NPV Examples

    • 867 Words
    • 4 Pages

    Machine A has a faster payback period. If Riveau Yachts does not want to take risks such as cash flow problems, it should choose Machine A. Payback period is also more accurate as it is more predictable. However, the net present value calculations shows that Machine B has a higher net present value of returns. Net Present Value is a better method or appraising investments because it takes time value of money into consideration. Thus, choose Machine B.…

    • 867 Words
    • 4 Pages
    Better Essays
  • Satisfactory Essays

    b. Option A is the better choice of the two given any positive rate of return.…

    • 2314 Words
    • 10 Pages
    Satisfactory Essays