Question

Financial analysts often use the following model to characterize changes in stock prices: Pt = POe(u-0.52)t+sdzt1/2...

Financial analysts often use the following model to characterize changes in stock prices: Pt = POe(u-0.52)t+sdzt1/2 Where PO = current stock price Pt = price at time t u = mean (logarithmic) standard deviation of price change Sd = (logarithmic) standard deviation of price change z = standard normal random variable This model assumes that the logarithm of stock's price is a normally disrstibuted random variable (see the discussion of the lognormal distribution and note that the first term of the exponent is the mean of the lognormal 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.

Homework Answers

Answer #1

Answer: ----                                                                                    Date: ----29/10/2018

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT