Question

In: Statistics and Probability

Problem 12-11 (Algorithmic) Over a five-year period, the quarterly change in the price per share of...

Problem 12-11 (Algorithmic)

Over a five-year period, the quarterly change in the price per share of common stock for a major oil company ranged from -7% to 10%. A financial analyst wants to learn what can be expected for price appreciation of this stock over the next two years. Using the five-year history as a basis, the analyst is willing to assume that the change in price for each quarter is uniformly distributed between -7% and 10%. Use simulation to provide information about the price per share for the stock over the coming two-year period (eight quarters).

  1. Use the random numbers 0.46, 0.91, 0.15, 0.17, 0.50, 0.74, 0.40 and 0.51 to simulate the quarterly price change for each of the eight quarters. If required, round your answers to two decimal places. For those boxes in which you must enter subtractive or negative numbers use a minus sign. (Example: -300)
    Quarter r Return %
    1 0.46 %
    2 0.91 %
    3 0.15 %
    4 0.17 %
    5 0.50 %
    6 0.74 %
    7 0.40 %
    8 0.51 %
  2. If the current price per share is $80, what is the simulated price per share at the end of the two-year period? If required, round your answer to two decimal places.

    $   
  3. Discuss how risk analysis would be helpful in identifying the risk associated with a two-year investment in this stock.

    Risk analysis requires multiple simulations  of the eight-quarter, two-year period, which would then provide a distribution of the ending price per share.

Solutions

Expert Solution

a)

b) Stock price at the end of 2 year = 87.16083759
c) Risk analysis requires multiple simulations  of the eight-quarter, two-year period, which would then provide a distribution of the ending price per share.


( Please give like it will be very helpful. Thank You. )

B A Quarter 1 r 1 2 3 2 4 3 C D E Return% Start Price Changed price 0.46 0.82 80 80.656 0.91 8.47 80.656 87.4875632 0.15 -4.45 87.4875632 83.59436664 0.17 -4.11 83.59436664 80.15863817 0.5 1.5 80.15863817 81.36101774 0.74 5.58 81.36101774 85.90096253 0.4 -0.2 85.90096253 85.72916061 0.51 1.67 85.72916061 87.16083759 4 5 6 7 5 6 7 8 8 9 10 11


Related Solutions

Problem 12-11 (Algorithmic) Over a five-year period, the quarterly change in the price per share of...
Problem 12-11 (Algorithmic) Over a five-year period, the quarterly change in the price per share of common stock for a major oil company ranged from -9% to 12%. A financial analyst wants to learn what can be expected for price appreciation of this stock over the next two years. Using the five-year history as a basis, the analyst is willing to assume that the change in price for each quarter is uniformly distributed between -9% and 12%. Use simulation to...
Over a five-year period, the quarterly change in the price per share of common stock for...
Over a five-year period, the quarterly change in the price per share of common stock for a major oil company ranged from -8% to 12%. A financial analyst wants to learn what can be expected for price appreciation of this stock over the next two years. Using the fiveyear history as a basis, the analyst is willing to assume that the change in price for each quarter is uniformly distributed between -8% and 12%. Use simulation to provide information about...
Over a five-year period, the quarterly change in the price per share of common stock for...
Over a five-year period, the quarterly change in the price per share of common stock for a major oil company ranged from -7% to 14%. A financial analyst wants to learn what can be expected for price appreciation of this stock over the next two years. Using the five-year history as a basis, the analyst is willing to assume that the change in price for each quarter is uniformly distributed between -7% and 14%. Use simulation to provide information about...
Over a five-year period, the quarterly change in the price per share of common stock for...
Over a five-year period, the quarterly change in the price per share of common stock for a major oil company ranged from -6% to 10%. A financial analyst wants to learn what can be expected for price appreciation of this stock over the next two years. Using the five-year history as a basis, the analyst is willing to assume that the change in price for each quarter is uniformly distributed between -6% and 10%. Use simulation to provide information about...
Problem 12-05 (Algorithmic) The price of a share of a particular stock listed on the New...
Problem 12-05 (Algorithmic) The price of a share of a particular stock listed on the New York Stock Exchange is currently $42. The following probability distribution shows how the price per share is expected to change over a three-month period: Stock Price Change ($) Probability -1 0.10 0 0.05 1 0.20 2 0.30 3 0.10 4 0.05 5 0.20 Set up intervals of random numbers that can be used to generate the change in stock price over a three-month period....
You get a $13,000 loan over a five-year period at 10% per year interest. The payments...
You get a $13,000 loan over a five-year period at 10% per year interest. The payments are to be made monthly. What is the unrecovered balance immediately after the first payment has been made?
Monitor the price of a stock over a five-week period. Note the amount of gain or loss per day. Test
Monitor the price of a stock over a five-week period. Note the amount of gain or loss per day. Test the claim that the median is 0. Perform a runs test to see if the distribution of gains and losses is random.
Number of Shares Outstanding (000's) 300 Share Price as of 12/31/2017 $11 Share Price as of...
Number of Shares Outstanding (000's) 300 Share Price as of 12/31/2017 $11 Share Price as of 12/31/2016 $9 Tax Rate 40% Total Dividends Paid In 2017 (000's) $ 60 Capital Expenditures in 2017 (000's) $70 Net Income 2016 $171 Net income 2017 $189 Sold old equipment for $20,000 with an original cost of $25,000 and A/D of $10,000 - Find total stakeholder return ( Dividends + SPA) for year ended 2016 and 2017
Ivy bought some shares of stock and, over the next year, the price per share increased...
Ivy bought some shares of stock and, over the next year, the price per share increased by 5 percent, while the price level went up by 3%. Before taxes, Ivy experienced a. both a nominal gain and a real gain, and Ivy paid taxes on the nominal gain. b. both a nominal gain and a real gain, and Ivy paid taxes only on the real gain. c. a nominal gain, but no real gain, and Ivy paid taxes on the...
Problem 10-37 (Algorithmic) (LO. 6, 7, 8, 9, 10, 11) Amy and Mitchell share equally in...
Problem 10-37 (Algorithmic) (LO. 6, 7, 8, 9, 10, 11) Amy and Mitchell share equally in the profits, losses, and capital of the accrual basis AM Products LLC. The LLC does not need to report financial information to any third parties, so capital accounts are determined using tax rules (rather than GAAP). Amy is a managing member of the LLC (treated as a general partner) and is a U.S. person. At the beginning of the current tax year, Amy's capital...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT