Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

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.

How to Use Excel to Calculate a Bond's Yield to Call. Bonds are investment vehicles that make regular coupon payments until maturity, at which time the bond's face value is paid.

To calculate the returns on your mutual fund investments made on different dates, using XIRR formula in excel makes the task easier.