Hello,
I am doing a finance course and need some help.
The question is as follows:
ABC's share price is currently £30, and has a monthly, continuously-compounded return which has a mean of 1.5% and a standard deviation of 1.2%. ABC pays no dividends. Assume that each month's continuously-compounded return (ln(P1)-ln(P0)) is normally distributed and that returns from different months are independent.
(a) What are the expected value and the standard deviation of the yearly return (annualised and continuously-compounded) of ABC's shares?
(b) What is the probability that ABC's stock price will be at or above £35 in one year?
I have done part (a) and believe that the answers are that it has an annual expected return of (1.5 * 12 =) 18% and a standard deviation of (1.2 * 12^0.5 =) 4.15%. Is this correct?
I'm not sure how to complete part (b). I believe that if the share price has an annual expected return of 18%, then the shares should be worth (30 * 1.18) = £35.40 at the end of the year. But how do you work out what the probability is of the share price being at least £35? I imagine that it can be done using statistical tables, but can the result also be achieved in Excel?
Any help would be most appreciated.