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.