Microsoft Excel has dozens of preset formulas for many types of mathematical calculations, but compounding interest isn't one of them. To calculate the future value of a single amount compounded ...

The Mode function in Excel returns the most frequently repetitive value in an array or range of data. The formula for Mode function is Mode( number1, [number2,..]). In Excel, Modes can be arrays ...

Learn what present value (PV) and future value (FV) are and how to calculate present value in Excel given the future value, interest rate, and period.

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.

Regression statistics will typically include an R-squared value. The closer to 1 this is, the stronger the correlation between the returns of the two stocks. An R-squared figure of zero indicates ...

Use the CORREL function in Excel to calculate this value, applied to the two series of daily values for the two stocks. The portfolio variance formula is: (W1^2)(SD1^2)+(W2^2)(SD2^2)+(2xW1xW2xC12 ...