Develop a spreadsheet to simulate the price of the stock over the next 30 days, if the current price is \$53.

Financial analysts often use the following model to characterize changes in stock prices: where P0 = current stock price Pt = price at time t m = mean (logarithmic) change of the stock price per unit time s = (logarithmic) standard deviation of price change Z = standard normal random variable This model assumes that the logarithm of a stock’s price is a normally distributed random variable (see the discussion of the log normal distribution and note that the first term of the exponent is the mean of the log normal distribution). Using historical data, one can estimate values for m and s. Suppose that the average daily change for a stock is \$0.003227, and the standard deviation is 0.026154. Develop a spreadsheet to simulate the price of the stock over the next 30 days, if the current price is \$53. Use the Excel function NORMSINV (RAND ( )) to generate values for Z. Construct a chart showing the movement in the stock price.

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

PLACE THIS ORDER OR A SIMILAR ORDER WITH BEST NURSING TUTORS TODAY AND GET AN AMAZING DISCOUNT

The post Develop a spreadsheet to simulate the price of the stock over the next 30 days, if the current price is \$53. appeared first on BEST NURSING TUTORS .