ALL MUST BE DONE IN EXCEL

The price of a share of Northwest Industrial Products listed on the New York Stock Exchange is currently $103. The following probability distribution shows how the price per share is expected to change over a three-month period: Stock Price Change ($) Probability -2 0.05 -1 0.10 0 0.25 +1 0.20 +2 0.20 +3 0.10 +4 0.10 Do the following on an Excel spreadsheet: a. Set up intervals of random numbers that can be used to generate the change in stock price over a three-month period b. With the current price of $103 per share and the random numbers 0.7895, 0.4522, 0.1801, 0.0039, and E, simulate the price per share for the next five 3-month periods. What is the ending simulated price per share? The price of a share of Northwest Industrial Products listed on the New York Stock Exchange is currently $103. The following probability distribution shows how the price per share is expected to change over a three-month period: Stock Price Change ($) Probability -2 0.05 -1 0.10 0 0.25 +1 0.20 +2 0.20 +3 0.10 +4 0.10 Do the following on an Excel spreadsheet: a. Set up intervals of random numbers that can be used to generate the change in stock price over a three-month period b. With the current price of $103 per share and the random numbers 0.7895, 0.4522, 0.1801, 0.0039, and E, simulate the price per share for the next five 3-month periods. What is the ending simulated price per share