March 18th, 2006, 3:00 am
Normally by a return R we mean R = Change in Value/Initial Value.With that definition, returns can range from -1 to + infinity.Then, under a log-normal assumption, X = log (1+R) is normally distributed.The Z score eqn is Z = (X - m T)/(s Sqrt(T)) wherem and s are the annualized values of E[log(1+R)] and Sqrt[Var[log(1+R)]]However, often people will approximate m by mu - 1/2 sigma^2, wheremu = E[R] and sigma = Sqrt[Var[R]]. Similarly, people will approximate s = sigma.If you make those approximations and solve the Z score eqn for the critical R, you getR = e^{(mu - 0.5 sigma^2) T + Z sigma Sqrt(T)} - 1Note that this gives correctly that R -> -1 = -100% as Z -> -infinity You asked for a 3 year example. For mu = 0.06, sigma = 0.20, T = 3 and Z = +/- 1.64 (5%, 95% level), I getR(5%) = -32%R(95%) = +111%Please check my work.regards, p.s you might want to look at the difference between Sqrt[Var[log(1+R)]]and Sqrt[Var[R]] in a historical series that's similar to the portfolio you're projecting.Similarly for the mean approximation.
Last edited by
Alan on March 17th, 2006, 11:00 pm, edited 1 time in total.