For example, if you are calculating a stock option based on the Black-Sholes model, you will need the natural logarithm function "LN" in Excel, the normal distribution, "NORM.DIST" and the "EXP ...

In Excel, syntax for this function is NORMINV(probability,mean,standard deviation). Using the sales example, with a weekly sales average of $2,000 that fluctuates about $500 up or down, you know ...

A log-normal distribution is a statistical distribution of logarithmic values from a related normal distribution. ... To calculate LOGNORM.DIST in Excel you will need the following: ...

Use Excel to calculate daily returns and standard deviation to gauge stock volatility. Annualize volatility by multiplying daily standard deviation by the square root of 252. Remember, standard ...

Learn what Value at Risk is, what it indicates about a portfolio, its pros and cons, and how to calculate the VaR of a portfolio using Microsoft Excel.