Use NORMSINV(RAND()) to generate spreadsheet

written by - Comments off

Financial analysts often use the following model to characterize changes in stock prices:

Pt = Po*e^(u-0.5s^2)t+s*Z*t^0.5

where Po = current stock price
Pt – price at time t
u – 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. Using historical data, one can estimate the values for u 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 stimulate 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.

Note: Currently, Regular Priority times are 3-5 days. Log in to upload files with your questions. Tutorials you buy shall be emailed to your PAYPAL email. Talking about quality references: finding and referencing an (n+1)th article for your tutorial requires substantially more time than the (n)th article referenced, therefore you will see the price increasing with the number of references you require in some questions. Wanted to contact us over something related to this question? Email us: support AT

© 2010 Customized Homework help. - Powered by OM