Question

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.

Answer 1

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