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

Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

Calculating the return One of the best methods for calculating an average return for a stock investment is the XIRR function in Excel.