Question: URGENT PLEASE HELP - please please include excel formulas please please thank you will rate quickly 5. Financial analysts often use the following model to
URGENT PLEASE HELP - please please include excel formulas please please thank you will rate quickly

5. Financial analysts often use the following model to characterize changes in stock prices: P, = Page(4-0507)toZVi where Po = current stock price P = price at time f u = mean (logarithmic) change of the stock price per unit time o = (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 dis- cussion of the lognormal distribution and note that the first term of the exponent is the mean of the lognormal distribution). Using historical data, we can estimate val- ues for u and o. 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 NORM.S.INV(RAND()) to generate values for Z. Construct a chart showing the movement in the stock price
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
